# 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 |  | This column is for Oracle Internal use only. 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_INSERT_ACCTG_METHD_LKP_TL with CODE_TYPE=SLA_ACCOUNTING_METHOD. #1 | DW_INSERT_ACCTG_METHD_LKP_TL | INSERT_ACCTG_METHD_LKP_CODE
SLA_ACCOUNTING_METHOD_CODE | VARCHAR2 | 128 |  |  | Subledger accounting method code. Values are from the table DW_INSERT_ACCTG_METHD_LKP_TL with CODE_TYPE=SLA_ACCOUNTING_METHOD. #1 | DW_INSERT_ACCTG_METHD_LKP_TL | INSERT_ACCTG_METHD_LKP_CODE
PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. |  |
LEDGER_CATEGORY_CODE | VARCHAR2 | 128 |  |  | Ledger category. Values are from the table DW_INSERT_LEDGER_CAT_LKP_TL with CODE_TYPE=GL_ASF_LEDGER_CATEGORY. Possible values are PRIMARY, SECONDARY, ALC, and so on. | DW_INSERT_LEDGER_CAT_LKP_TL | INSERT_LEDGER_CAT_LKP_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_INSERT_ACCTG_METHD_LKP_TL.

Copyright © 2019, 2025, Oracle and/or its affiliates.