DW_DATA_ACCESS_SET_LEDGERS_D

This table contains the access set and associated ledgers.

Details

Module:

Key Columns

ACCESS_SET_ID, LEDGER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCESS_SET_ID NUMBER 38 0 True Unique identifier of the access set.    
LEDGER_ID NUMBER 38 0 True Ledger or ledger set ID assigned to the data access set.    
SOURCE_RECORD_ID VARCHAR2 128     Unique System Primary Key    
ACCESS_SET_NAME VARCHAR2 32     User defined access set defining column.    
SECURITY_SEGMENT_CODE VARCHAR2 16     Security segment (balancing segment, management segment, full).    
ENABLED_FLAG VARCHAR2 16     Whether the access set is enabled.    
CHART_OF_ACCOUNTS_ID NUMBER 38 0   Key flexfield structure identifier.    
PERIOD_SET_NAME VARCHAR2 32     Accounting calendar name.    
ACCOUNTED_PERIOD_TYPE VARCHAR2 32     Accounting period type.    
AUTOMATICALLY_CREATED_FLAG VARCHAR2 16     Automatically created access set flag.    
DEFAULT_LEDGER_ID NUMBER 38 0   Default ledger of the access set.    
DESCRIPTION VARCHAR2 256     Access set definition description.    
ACCESS_PRIVILEGE_CODE VARCHAR2 16     Access level for the ledger or ledger set assigned to the data access set. Possible values are F for Full Ledger, B for Both Read And Write, and R for Read Only.    
LEDGER_ACCESS_SET_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the Ledger Access Set row.    
LEDGER_ACCESS_SET_LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the Last updated of the Ledger Access Set row.    
ACCESS_SET_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the Access Set row.    
ACCESS_SET_LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last updated of the Access Set row.