DW_LEDGER_SET_D

This table contains ledger sets information. Ledger set is grouping of ledgers. Multiple ledgers and ledger sets can be grouped in one ledger set. Ledgers in a given ledger set share the same chart of accounts and accounting calendar combination. This table will only store the ledger sets to ledger assignments, It will not store ledger sets assigned to given ledger set.

Details

Module:

Key Columns

LEDGER_SET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEDGER_SET_ID NUMBER 38 0 True Ledger set identifier.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier.    
LEDGER_SET_NAME VARCHAR2 32     Ledger set name.    
LEDGER_SET_SHORT_NAME VARCHAR2 32     Ledger set short name.    
LEDGER_SET_DESCRIPTION VARCHAR2 256     Ledger set description.    
LEDGER_SET_CHART_OF_ACCOUNTS_ID NUMBER 38 0   Chart of accounts identifier.    
LEDGER_SET_CALENDER_NAME VARCHAR2 16     Accounting calendar name.    
LEDGER_SET_PERIOD_TYPE VARCHAR2 16     Accounting period type.