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,
Module:
LEDGER_ID
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 |
#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.
Copyright © 2019, 2022, Oracle and/or its affiliates.