DW_LEDGER_D

This table contains information about ledgers. Each row stores the ledger name, short name, description, ledger currency, calendar, period type, chart of accounts, and other information. Clients can maintain multiple ledgers. Each ledger can have different values for major attributes such as value sets, currency and set of books,

Details

Module:

Key Columns

LEDGER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEDGER_ID NUMBER 38 0 True Ledger identifier. It is used as the primary key.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier.    
LEDGER_NAME VARCHAR2 32     Ledger name.    
LEDGER_SHORT_NAME VARCHAR2 32     Ledger short name.    
LEDGER_DESCRIPTION VARCHAR2 256     Ledger description.    
LEDGER_CHART_OF_ACCOUNTS_ID NUMBER 38 0   Chart of accounts.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Currency code.    
LEDGER_CALENDER_NAME VARCHAR2 16     Accounting calendar name.    
SLA_ACCOUNTING_METHOD_TYPE VARCHAR2 16     Subledger accounting method type code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SLA_ACCOUNTING_METHOD. #1 DW_CODE_VALUES_LKP_TL CODE
SLA_ACCOUNTING_METHOD_CODE VARCHAR2 128     Subledger accounting method code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SLA_ACCOUNTING_METHOD. #1 DW_CODE_VALUES_LKP_TL CODE
PERIOD_TYPE VARCHAR2 16     Accounting period type.    
LEDGER_CATEGORY_CODE VARCHAR2 128     Ledger category. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_ASF_LEDGER_CATEGORY. Possible values are PRIMARY, SECONDARY, ALC, and so on. DW_CODE_VALUES_LKP_TL CODE

Notes

#1: To get the transalation for SLA Accounting method, Use the combination SLA_ACCOUNTING_METHOD_TYPE||'~'||SLA_ACCOUNTING_METHOD_CODE, when joining to column 'CODE' of table DW_CODE_VALUES_LKP_TL.