JA_CN_LEDGER_LE_BSV_GT

This table contains the relationship between legal entity and balancing segment under the ledger. Oracle internal use only.

Details

  • Schema: FUSION

  • Object owner: JA

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
LEDGER_ID NUMBER 18 Yes Oracle internal use only.
LEDGER_CATEGORY_CODE VARCHAR2 30 Yes Oracle internal use only.
CHART_OF_ACCOUNTS_ID NUMBER 18 Yes Oracle internal use only.
BAL_SEG_VALUE_OPTION_CODE VARCHAR2 1 Yes Oracle internal use only.
BAL_SEG_VALUE_SET_ID NUMBER 18 Yes Oracle internal use only.
BAL_SEG_VALUE VARCHAR2 25 Yes Oracle internal use only.
LEGAL_ENTITY_ID NUMBER 18 Yes Oracle internal use only.
START_DATE DATE Oracle internal use only.
END_DATE DATE Oracle internal use only.

Indexes

Index Uniqueness Columns
JA_CN_LEDGER_LE_BSV_GT_N1 Non Unique LEDGER_ID, BAL_SEG_VALUE, LEGAL_ENTITY_ID