2Tables

Overview

This chapter provides table details. The details contain information on key columns, data types, and its description. Refer to the ReferredTable and Referred Column to decide on the join condition between Fact and Dimension tables.

General Ledger

DW_BALANCING_SEGMENT_D

This table contains balancing segment information.

Details

Module: General Ledger

Key Columns

GL_BALANCING_SEGMENT, GL_BLNC_SGMNT_VALUESET_CODE

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 True Balancing segment value set identifier.
GL_BALANCING_SEGMENT VARCHAR2 256 True Balancing segment code.
SOURCE_RECORD_ID VARCHAR2 512 Source record identifier. Value is derived from a combination of balancing segment value set identifier and balancing segment code.
GL_BALANCING_SEGMENT_ID VARCHAR2 512 Balancing segment identifier. Value is derived from a combination of balancing segment value set identifier and balancing segment code.

DW_BALANCING_SEGMENT_DH

This table contains details of balancing segment hierarchy.

Details

Module: General Ledger

Key Columns

HIERARCHY_VALUESET_CODE, HIERARCHY_TREE_CODE, GL_BALANCING_SEGMENT, HIERARCHY_VERSION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
HIERARCHY_VALUESET_CODE VARCHAR2 128 True Balancing segment hierarchy tree value set identifier. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
HIERARCHY_TREE_CODE VARCHAR2 32 True Balancing segment hierarchy tree identifier.
GL_BALANCING_SEGMENT VARCHAR2 128 True Balancing segment number. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
HIERARCHY_VERSION_ID VARCHAR2 64 True Balancing segment hierarchy tree version.
SOURCE_RECORD_ID VARCHAR2 512 Source record identifier.
HIERARCHY_NAME VARCHAR2 128 Balancing segment hierarchy name.
HIERARCHY_VERSION_NAME VARCHAR2 128 Balancing segment hierarchy tree version name.
TREE_CODE_VER_EFF_START_DATE DATE Hierarchy start date.
TREE_CODE_VER_EFF_END_DATE DATE Hierarchy end date.
HIERARCHY_VERSION_STATUS VARCHAR2 32 Hierarchy version status.
LEVEL0_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 0.
LEVEL0_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 0. It is the lowest level.
LEVEL0_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 0.
LEVEL1_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 1.
LEVEL1_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 1.
LEVEL1_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 1.
LEVEL2_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 2.
LEVEL2_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 2.
LEVEL2_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 2.
LEVEL3_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 3.
LEVEL3_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 3.
LEVEL3_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 3.
LEVEL4_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 4.
LEVEL4_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 4.
LEVEL4_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 4.
LEVEL5_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 5.
LEVEL5_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 5.
LEVEL5_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 5.
LEVEL6_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 6.
LEVEL6_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 6.
LEVEL6_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 6.
LEVEL7_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 7.
LEVEL7_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 7.
LEVEL7_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 7.
LEVEL8_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 8.
LEVEL8_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 8.
LEVEL8_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 8.
LEVEL9_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 9.
LEVEL9_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 9.
LEVEL9_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 9.
LEVEL10_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 10.
LEVEL10_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 10.
LEVEL10_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 10.
LEVEL11_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 11.
LEVEL11_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 11.
LEVEL11_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 11.
LEVEL12_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 12.
LEVEL12_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 12.
LEVEL12_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 12.
LEVEL13_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 13.
LEVEL13_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 13.
LEVEL13_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 13.
LEVEL14_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 14.
LEVEL14_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 14.
LEVEL14_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 14.
LEVEL15_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 15.
LEVEL15_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 15.
LEVEL15_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 15.
LEVEL16_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 16.
LEVEL16_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 16.
LEVEL16_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 16.
LEVEL17_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 17.
LEVEL17_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 17.
LEVEL17_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 17.
LEVEL18_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 18.
LEVEL18_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 18.
LEVEL18_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 18.
LEVEL19_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 19.
LEVEL19_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 19.
LEVEL19_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 19.
LEVEL20_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 20.
LEVEL20_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 20.
LEVEL20_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 20.
LEVEL21_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 21.
LEVEL21_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 21.
LEVEL21_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 21.
LEVEL22_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 22.
LEVEL22_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 22.
LEVEL22_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 22.
LEVEL23_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 23.
LEVEL23_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 23.
LEVEL23_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 23.
LEVEL24_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 24.
LEVEL24_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 24.
LEVEL24_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 24.
LEVEL25_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 25.
LEVEL25_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 25.
LEVEL25_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 25.
LEVEL26_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 26.
LEVEL26_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 26.
LEVEL26_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 26.
LEVEL27_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 27.
LEVEL27_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 27.
LEVEL27_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 27.
LEVEL28_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 28.
LEVEL28_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 28.
LEVEL28_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 28.
LEVEL29_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 29.
LEVEL29_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 29.
LEVEL29_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 29.
LEVEL30_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 30.
LEVEL30_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 30.
LEVEL30_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 30.
LEVEL31_SEGMENT VARCHAR2 128 Balancing segment number at hierarchy level 31.
LEVEL31_VALUESET_CODE VARCHAR2 128 Value set for balancing segment number at hierarchy level 31. It is the highest level.
LEVEL31_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 31.
FIXED_HIER_LEVEL NUMBER 38 0 Distance of the node from the highest level of hierarchy.

DW_GL_BALANCE_CA

This table contains information about aggregated metrics for GL.

Details

Module: General Ledger

Key Columns

FISCAL_PERIOD_NAME, COST_CENTER_VALUESET_CODE, LEGAL_ENTITY_ID, COST_CENTER_SEGMENT, GBL_CURRENCY_CODE, TRANSLATED_FLAG, NTRL_ACNT_SGMNT_VALUESET_CODE, TRANSACTION_CURRENCY_CODE, FISCAL_PERIOD_SET_NAME, LEDGER_ID, LEDGER_CURRENCY_CODE, GL_BALANCING_SEGMENT, NATURAL_ACCOUNT_SEGMENT, GL_BLNC_SGMNT_VALUESET_CODE

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Accounting calendar name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_SET_NAME
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_BALANCING_SEGMENT VARCHAR2 32 True Balancing segment for the ledger. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 True Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 True Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 True Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
COST_CENTER_SEGMENT VARCHAR2 32 True Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 True Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 64 True Transaction currency code.
LEDGER_CURRENCY_CODE VARCHAR2 16 True Ledger currency code.
GBL_CURRENCY_CODE VARCHAR2 16 True Global currency code.
TRANSLATED_FLAG VARCHAR2 16 True Indicates currency translation.
CURRENCY_TYPE VARCHAR2 64 Currency type.
TRXN_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance.
TRXN_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit.
TRXN_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit.
TRXN_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance.
TRXN_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit.
TRXN_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit.
LDGR_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in ledger currency.
LDGR_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance in ledger currency.
LDGR_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit in ledger currency.
LDGR_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit in ledger currency.
GBL_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance in global currency.
GBL_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in global currency.
GBL_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in global currency.
GBL_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance in global currency.
GBL_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit in global currency.
GBL_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit in global currency.

DW_GL_BALANCE_CF

This table contains information of GL balance and the metrics in global currency.

Details

Module: General Ledger

Key Columns

FISCAL_PERIOD_NAME, TRANSLATED_FLAG, TRANSACTION_CURRENCY_CODE, LEDGER_ID, CODE_COMBINATION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
CODE_COMBINATION_ID NUMBER 38 0 True Account key flexfield combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
TRANSACTION_CURRENCY_CODE VARCHAR2 64 True Transaction currency code.
TRANSLATED_FLAG VARCHAR2 16 True Indicates currency translation.
SOURCE_RECORD_ID VARCHAR2 256 Source record identifier. Value is derived from a combination of ledger identifier, account key flexfield combination identifier, transaction currency code, accounting period name, and translation flag.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
ACCT_PERIOD_START_DATE DATE Accounting period start date.
ACCT_PERIOD_END_DATE DATE Accounting period end date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
CURRENCY_TYPE VARCHAR2 64 Currency type.
TRXN_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance.
TRXN_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit.
TRXN_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit.
TRXN_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance.
TRXN_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit.
TRXN_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
LDGR_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in ledger currency.
LDGR_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance in ledger currency.
LDGR_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit in ledger currency.
LDGR_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit in ledger currency.
GBL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GBL_CURRENCY_EXCH_RATE NUMBER Ledger curreny to global currency conversion rate.
GBL_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance in global currency.
GBL_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in global currency.
GBL_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in global currency.
GBL_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance in global currency.
GBL_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit in global currency.
GBL_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit in global currency.

DW_GL_BALANCE_F

This table contains information about actual balances and activities of GL accounts.

Details

Module: General Ledger

Key Columns

FISCAL_PERIOD_NAME, TRANSLATED_FLAG, TRANSACTION_CURRENCY_CODE, LEDGER_ID, CODE_COMBINATION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
CODE_COMBINATION_ID NUMBER 38 0 True Account key flexfield combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
TRANSACTION_CURRENCY_CODE VARCHAR2 64 True Transaction currency code.
TRANSLATED_FLAG VARCHAR2 16 True Indicates currency translation.
SOURCE_RECORD_ID VARCHAR2 256 Source record identifier. Value is derived from a combination of ledger identifier, account key flexfield combination identifier, transaction currency code, accounting period name, and translation flag.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
ACCT_PERIOD_START_DATE DATE Accounting period start date.
ACCT_PERIOD_END_DATE DATE Accounting period end date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
CURRENCY_TYPE VARCHAR2 64 Currency type.
TRXN_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance.
TRXN_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit.
TRXN_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit.
TRXN_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance.
TRXN_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit.
TRXN_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
LDGR_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net balance in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in ledger currency.
LDGR_CRNC_PRD_END_BALANCE NUMBER Accounting period end balance in ledger currency.
LDGR_CRNC_PRD_END_BALANCE_CR NUMBER Accounting period end credit in ledger currency.
LDGR_CRNC_PRD_END_BALANCE_DR NUMBER Accounting period end debit in ledger currency.

DW_GL_BUDGET_CF

This table contains information about General Ledger budget, GL budget facts, and metrics in global currency.

Details

Module: General Ledger

Key Columns

FISCAL_PERIOD_NAME, BUDGET_NAME, TRANSACTION_CURRENCY_CODE, FISCAL_PERIOD_SET_NAME, LEDGER_ID, CODE_COMBINATION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BUDGET_NAME VARCHAR2 128 True Name of the accounting budget.
LEDGER_ID NUMBER 38 0 True Ledger identifier of Oracle Fusion General Ledger. DW_LEDGER_D LEDGER_ID
CODE_COMBINATION_ID NUMBER 38 0 True GL account key flexfield combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Set of accounting periods defined by a party to quantify the fiscal position of the business. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name of Oracle Fusion General Ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
TRANSACTION_CURRENCY_CODE VARCHAR2 16 True Functional currency code of the transaction.
SOURCE_RECORD_ID VARCHAR2 256 Functional key of records. Value is derived from a combination of accounting budget name, ledger identifier, GL account key flexfield combination identifier, calendar, currency code and currency type.
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
TRXN_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net amount in trxn currency.
TRXN_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in trxn currency.
TRXN_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in trxn currency.
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency code of the ledger.
LDGR_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net amount in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in ledger currency.
CREATED_BY_USER_ID VARCHAR2 128 User who created the accounting record. DW_USER_D USERNAME
CREATION_DATE DATE Who column: Indicates the date and time of the creation of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE
GBL_CURRENCY_CODE VARCHAR2 16 Global currency code of the General Ledger.
GBL_CURRENCY_EXCH_RATE NUMBER Ledger currency to global currency exchange rate.
GBL_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net amount in global currency.
GBL_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in global currency.
GBL_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in global currency.

DW_GL_BUDGET_F

This table contains information about the General Ledger budget.

Details

Module: General Ledger

Key Columns

FISCAL_PERIOD_NAME, BUDGET_NAME, TRANSACTION_CURRENCY_CODE, FISCAL_PERIOD_SET_NAME, LEDGER_ID, CODE_COMBINATION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BUDGET_NAME VARCHAR2 128 True Name of the accounting budget.
LEDGER_ID NUMBER 38 0 True Ledger identifier of Oracle Fusion General Ledger. DW_LEDGER_D LEDGER_ID
CODE_COMBINATION_ID NUMBER 38 0 True GL account key flexfield combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Set of accounting periods defined by a party to quantify the fiscal position of the business. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name of Oracle Fusion General Ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
TRANSACTION_CURRENCY_CODE VARCHAR2 16 True Functional currency code of the transaction.
SOURCE_RECORD_ID VARCHAR2 256 Functional key of records. Value is derived from a combination of accounting budget name, ledger identifier, GL account key flexfield combination identifier, calendar name and calendar period name.
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
TRXN_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net amount in transaction currency.
TRXN_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in transaction currency.
TRXN_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in transaction currency.
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency code of the ledger.
LDGR_CRNC_PRD_NET_ACTIVITY NUMBER Accounting period net amount in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_CR NUMBER Accounting period net credit in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_DR NUMBER Accounting period net debit in ledger currency.
CREATED_BY_USER_ID VARCHAR2 128 User who created the accounting record. DW_USER_D USERNAME
CREATION_DATE DATE Who column: Indicates the date and time of the creation of the row. DW_FISCAL_DAY_D FISCAL_DAY_DATE

DW_GL_CODE_COMBINATION_D

This table contains key flex field segments information for GL.

Details

Module: General Ledger

Key Columns

CODE_COMBINATION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CODE_COMBINATION_ID NUMBER 38 0 True Account key flexfield combination identifier.
SOURCE_RECORD_ID VARCHAR2 64 Source record identifier. Value is same as the account key flexfield combination identifier.
CHART_OF_ACCOUNTS_ID NUMBER 38 0 Chart of account identifier.
ENABLED_FLAG VARCHAR2 16 Indicates that code combination is enabled.
CONCAT_SEGMENTS VARCHAR2 2048 Concatenated segments.
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment.
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code.
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment.
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code.
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment.
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code.
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1.
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code.
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2.
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code.
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3.
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code.
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4.
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code.
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5.
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code.
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6.
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code.
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7.
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code.
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8.
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code.
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9.
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code.
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10.
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code.
GL_SEGMENT11 VARCHAR2 32 Accounting segment 11.
GL_SEGMENT11_VALUESET_CODE VARCHAR2 64 Accounting segment 11 value set code.
GL_SEGMENT12 VARCHAR2 32 Accounting segment 12.
GL_SEGMENT12_VALUESET_CODE VARCHAR2 64 Accounting segment 12 value set code.
GL_SEGMENT13 VARCHAR2 32 Accounting segment 13.
GL_SEGMENT13_VALUESET_CODE VARCHAR2 64 Accounting segment 13 value set code.
GL_SEGMENT14 VARCHAR2 32 Accounting segment 14.
GL_SEGMENT14_VALUESET_CODE VARCHAR2 64 Accounting segment 14 value set code.
GL_SEGMENT15 VARCHAR2 32 Accounting segment 15.
GL_SEGMENT15_VALUESET_CODE VARCHAR2 64 Accounting segment 15 value set code.
GL_SEGMENT16 VARCHAR2 32 Accounting segment 16.
GL_SEGMENT16_VALUESET_CODE VARCHAR2 64 Accounting segment 16 value set code.
GL_SEGMENT17 VARCHAR2 32 Accounting segment 17.
GL_SEGMENT17_VALUESET_CODE VARCHAR2 64 Accounting segment 17 value set code.
GL_SEGMENT18 VARCHAR2 32 Accounting segment 18.
GL_SEGMENT18_VALUESET_CODE VARCHAR2 64 Accounting segment 18 value set code.
GL_SEGMENT19 VARCHAR2 32 Accounting segment 19.
GL_SEGMENT19_VALUESET_CODE VARCHAR2 64 Accounting segment 19 value set code.
GL_SEGMENT20 VARCHAR2 32 Accounting segment 20.
GL_SEGMENT20_VALUESET_CODE VARCHAR2 64 Accounting segment 20 value set code.
GL_SEGMENT21 VARCHAR2 32 Accounting segment 21.
GL_SEGMENT21_VALUESET_CODE VARCHAR2 64 Accounting segment 21 value set code.
GL_SEGMENT22 VARCHAR2 32 Accounting segment 22.
GL_SEGMENT22_VALUESET_CODE VARCHAR2 64 Accounting segment 22 value set code.
GL_SEGMENT23 VARCHAR2 32 Accounting segment 23.
GL_SEGMENT23_VALUESET_CODE VARCHAR2 64 Accounting segment 23 value set code.
GL_SEGMENT24 VARCHAR2 32 Accounting segment 24.
GL_SEGMENT24_VALUESET_CODE VARCHAR2 64 Accounting segment 24 value set code.
GL_SEGMENT25 VARCHAR2 32 Accounting segment 25.
GL_SEGMENT25_VALUESET_CODE VARCHAR2 64 Accounting segment 25 value set code.
GL_SEGMENT26 VARCHAR2 32 Accounting segment 26.
GL_SEGMENT26_VALUESET_CODE VARCHAR2 64 Accounting segment 26 value set code.
GL_SEGMENT27 VARCHAR2 32 Accounting segment 27.
GL_SEGMENT27_VALUESET_CODE VARCHAR2 64 Accounting segment 27 value set code.
GL_SEGMENT28 VARCHAR2 32 Accounting segment 28.
GL_SEGMENT28_VALUESET_CODE VARCHAR2 64 Accounting segment 28 value set code.
GL_SEGMENT29 VARCHAR2 32 Accounting segment 29.
GL_SEGMENT29_VALUESET_CODE VARCHAR2 64 Accounting segment 29 value set code.
GL_SEGMENT30 VARCHAR2 32 Accounting segment 30.
GL_SEGMENT30_VALUESET_CODE VARCHAR2 64 Accounting segment 30 value set code.

DW_GL_JOURNAL_CA

This table contains information about journal entries aggregated on few attributes.

Details

Module: General Ledger

Key Columns

FISCAL_PERIOD_NAME, COST_CENTER_VALUESET_CODE, LEGAL_ENTITY_ID, COST_CENTER_SEGMENT, NTRL_ACNT_SGMNT_VALUESET_CODE, TRANSACTION_CURRENCY_CODE, FISCAL_PERIOD_SET_NAME, LEDGER_ID, LEDGER_CURRENCY_CODE, GLOBAL_CURRENCY_CODE, GL_BALANCING_SEGMENT, DEBIT_CREDIT_IND, NATURAL_ACCOUNT_SEGMENT, JOURNAL_LINE_STATUS, GL_BLNC_SGMNT_VALUESET_CODE

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Accounting calendar name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 16 True Accounting period name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_NAME
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_BALANCING_SEGMENT VARCHAR2 32 True Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 True Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 True Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 True Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
COST_CENTER_SEGMENT VARCHAR2 32 True Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 True Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
JOURNAL_LINE_STATUS VARCHAR2 16 True Journal entry line status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16 True Transaction currency code.
LEDGER_CURRENCY_CODE VARCHAR2 16 True Ledger currency code.
GLOBAL_CURRENCY_CODE VARCHAR2 16 True Global currency code.
DEBIT_CREDIT_IND VARCHAR2 32 True Indicates debit or credit.
TRANSACTION_CURRENCY_AMOUNT NUMBER Amount in transaction currency.
LEDGER_CURRENCY_AMOUNT NUMBER Amount in ledger currency.
GLOBAL_CURRENCY_AMOUNT NUMBER Amount in global currency.

DW_GL_JOURNAL_CF

This table contains information about journal entries and converted reporting currency.

Details

Module: General Ledger

Key Columns

JOURNAL_HEADER_ID, JOURNAL_LINE_NUM

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
JOURNAL_HEADER_ID NUMBER 38 0 True Journal entry header identifier.
JOURNAL_LINE_NUM NUMBER 38 0 True Journal line number.
SOURCE_RECORD_ID VARCHAR2 128 Source record identifier. Value is derived from a combination of journal entry header identifier and journal line number.
JOURNAL_BATCH_ID NUMBER Journal entry batch defining column.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 16 Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ACCT_PERIOD_START_DATE DATE Accounting period start date.
ACCT_PERIOD_END_DATE DATE Accounting period end date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
JOURNAL_BATCH_NAME VARCHAR2 128 User-defined journal batch name.
JOURNAL_HEADER_NAME VARCHAR2 128 User-entered journal header name.
JOURNAL_HEADER_DESCRIPTION VARCHAR2 256 User-entered journal header description.
JOURNAL_BATCH_DESCRIPTION VARCHAR2 256 Journal entry batch description.
JOURNAL_POSTED_DATE DATE Date when journal entry header was posted.
JOURNAL_CREATION_DATE TIMESTAMP indicates the date and time of the creation of the row
JRNL_HDR_DFLT_EFFECTIVE_DATE DATE Journal header effective date.
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
JOURNAL_CATEGORY VARCHAR2 32 Journal category code. Journal entry is assigned a journal entry category to identify its purpose. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_SOURCE VARCHAR2 32 Journal source. Journal entry is assigned a source name to indicate how it was created. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_LINE_DESCRIPTION VARCHAR2 256 User-entered journal line description.
JOURNAL_LINE_STATUS VARCHAR2 16 Journal entry line status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
DEBIT_CREDIT_IND VARCHAR2 32 Indicates debit or credit
TRANSACTION_CURRENCY_AMOUNT NUMBER Amount in transaction currency.
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Transaction currency code.
LEDGER_CURRENCY_AMOUNT NUMBER Amount in ledger currency.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
CURRENCY_CONVERSION_DATE DATE Currency conversion date.
GLOBAL_CURRENCY_AMOUNT NUMBER Amount in global currency.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE NUMBER Ledger currency to global currency conversion rate.
CODE_COMBINATION_ID NUMBER 38 0 Account key flexfield combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
JOURNAL_REVERSAL_STATUS VARCHAR2 16 Reversed journal entry status code.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_APPROVAL_STATUS_CODE VARCHAR2 16 Journal entry batch approval status.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE='JE_BATCH_APPROVAL_STATUS'. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_HEADER_CREATED_BY_ID VARCHAR2 128 Journal header created by user identifier DW_USER_D USERNAME
JOURNAL_LINE_CREATED_BY_ID VARCHAR2 128 Journal line created by user identifier DW_USER_D USERNAME
JOURNAL_APPROVED_BY VARCHAR2 128 Defining column of the employee who submitted the journal batch for approval.

DW_GL_JOURNAL_F

This table contains information about journal transactions.

Details

Module: General Ledger

Key Columns

JOURNAL_HEADER_ID, JOURNAL_LINE_NUM

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
JOURNAL_HEADER_ID NUMBER 38 0 True Journal entry header identifier.
JOURNAL_LINE_NUM NUMBER 38 0 True Journal line number.
SOURCE_RECORD_ID VARCHAR2 128 Source record identifier. Value is derived from a combination of journal entry header identifier and journal line number.
JOURNAL_BATCH_ID NUMBER Journal entry batch defining column.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 16 Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ACCT_PERIOD_START_DATE DATE Accounting period start date.
JOURNAL_CREATION_DATE TIMESTAMP indicates the date and time of the creation of the row
ACCT_PERIOD_END_DATE DATE Accounting period end date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
JOURNAL_BATCH_NAME VARCHAR2 128 User-defined journal batch name.
JOURNAL_HEADER_NAME VARCHAR2 128 User-entered journal header name.
JOURNAL_HEADER_DESCRIPTION VARCHAR2 256 User-entered journal header description.
JOURNAL_BATCH_DESCRIPTION VARCHAR2 256 Journal entry batch description.
JOURNAL_POSTED_DATE DATE Date when journal entry header was posted.
JRNL_HDR_DFLT_EFFECTIVE_DATE DATE Journal header effective date.
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
JOURNAL_CATEGORY VARCHAR2 32 Journal category code. Journal entry is assigned a journal entry category to identify its purpose. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_SOURCE VARCHAR2 32 Journal source. Journal entry is assigned a source name to indicate how it was created. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_LINE_DESCRIPTION VARCHAR2 256 User-entered journal line description.
JOURNAL_LINE_STATUS VARCHAR2 16 Journal entry line status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
DEBIT_CREDIT_IND VARCHAR2 32 Indicates debit or credit
TRANSACTION_CURRENCY_AMOUNT NUMBER Amount in transaction currency.
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Transaction currency code.
LEDGER_CURRENCY_AMOUNT NUMBER Amount in ledger currency.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
CURRENCY_CONVERSION_DATE DATE Currency conversion date.
CODE_COMBINATION_ID NUMBER 38 0 Account key flexfield combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
JOURNAL_REVERSAL_STATUS VARCHAR2 16 Reversed journal entry status code.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_APPROVAL_STATUS_CODE VARCHAR2 16 Journal entry batch approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE='JE_BATCH_APPROVAL_STATUS'. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_HEADER_CREATED_BY_ID VARCHAR2 128 Journal header created by user identifier DW_USER_D USERNAME
JOURNAL_LINE_CREATED_BY_ID VARCHAR2 128 Journal line created by user identifier DW_USER_D USERNAME
JOURNAL_APPROVED_BY VARCHAR2 128 Defining column of the employee who submitted the journal batch for approval. DW_USER_D USERNAME

DW_GL_SEGMENT_D

This table contains non qualified GL segment information.

Details

Module: General Ledger

Key Columns

GL_SEGMENT_VALUESET_CODE, GL_SEGMENT_CODE

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GL_SEGMENT_VALUESET_CODE VARCHAR2 64 True Accounting segment value set identifier.
GL_SEGMENT_CODE VARCHAR2 512 True Accounting segment code.
SOURCE_RECORD_ID VARCHAR2 1024 Source record identifier. Value is derived from a combination of accounting segment value set identifier and accounting segment code.
GL_SEGMENT_ID VARCHAR2 1024 Accounting segment identifier, Value is derived by combining accounting segment value set identifier and segment code.

DW_GL_SEGMENT_DH

GL Segment Hierarchy dimension

Details

Module: General Ledger

Key Columns

HIERARCHY_VALUESET_CODE, HIERARCHY_TREE_CODE, GL_SEGMENT, HIERARCHY_VERSION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
HIERARCHY_VALUESET_CODE VARCHAR2 128 True Accounting segment hierarchy tree value set identifier. DW_GL_SEGMENT_D GL_SEGMENT_CODE
HIERARCHY_TREE_CODE VARCHAR2 32 True Accounting segment hierarchy tree identifier.
GL_SEGMENT VARCHAR2 128 True Accounting segment number. DW_GL_SEGMENT_D GL_SEGMENT_CODE
HIERARCHY_VERSION_ID VARCHAR2 64 True Accounting segment hierarchy tree version.
SOURCE_RECORD_ID VARCHAR2 512 Source record identifier.
HIERARCHY_NAME VARCHAR2 128 Accounting segment hierarchy name.
HIERARCHY_VERSION_NAME VARCHAR2 128 Accounting segment hierarchy tree version name.
TREE_CODE_VER_EFF_START_DATE DATE Hierarchy start date.
TREE_CODE_VER_EFF_END_DATE DATE Hierarchy end date.
HIERARCHY_VERSION_STATUS VARCHAR2 32 Hierarchy version status.
LEVEL0_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 0.
LEVEL0_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 0. It is the lowest level.
LEVEL0_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 0.
LEVEL1_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 1.
LEVEL1_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 1.
LEVEL1_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 1.
LEVEL2_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 2.
LEVEL2_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 2.
LEVEL2_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 2.
LEVEL3_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 3.
LEVEL3_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 3.
LEVEL3_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 3.
LEVEL4_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 4.
LEVEL4_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 4.
LEVEL4_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 4.
LEVEL5_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 5.
LEVEL5_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 5.
LEVEL5_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 5.
LEVEL6_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 6.
LEVEL6_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 6.
LEVEL6_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 6.
LEVEL7_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 7.
LEVEL7_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 7.
LEVEL7_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 7.
LEVEL8_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 8.
LEVEL8_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 8.
LEVEL8_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 8.
LEVEL9_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 9.
LEVEL9_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 9.
LEVEL9_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 9.
LEVEL10_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 10.
LEVEL10_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 10.
LEVEL10_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 10.
LEVEL11_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 11.
LEVEL11_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 11.
LEVEL11_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 11.
LEVEL12_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 12.
LEVEL12_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 12.
LEVEL12_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 12.
LEVEL13_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 13.
LEVEL13_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 13.
LEVEL13_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 13.
LEVEL14_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 14.
LEVEL14_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 14.
LEVEL14_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 14.
LEVEL15_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 15.
LEVEL15_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 15.
LEVEL15_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 15.
LEVEL16_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 16.
LEVEL16_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 16.
LEVEL16_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 16.
LEVEL17_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 17.
LEVEL17_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 17.
LEVEL17_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 17.
LEVEL18_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 18.
LEVEL18_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 18.
LEVEL18_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 18.
LEVEL19_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 19.
LEVEL19_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 19.
LEVEL19_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 19.
LEVEL20_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 20.
LEVEL20_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 20.
LEVEL20_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 20.
LEVEL21_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 21.
LEVEL21_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 21.
LEVEL21_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 21.
LEVEL22_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 22.
LEVEL22_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 22.
LEVEL22_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 22.
LEVEL23_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 23.
LEVEL23_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 23.
LEVEL23_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 23.
LEVEL24_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 24.
LEVEL24_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 24.
LEVEL24_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 24.
LEVEL25_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 25.
LEVEL25_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 25.
LEVEL25_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 25.
LEVEL26_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 26.
LEVEL26_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 26.
LEVEL26_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 26.
LEVEL27_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 27.
LEVEL27_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 27.
LEVEL27_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 27.
LEVEL28_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 28.
LEVEL28_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 28.
LEVEL28_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 28.
LEVEL29_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 29.
LEVEL29_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 29.
LEVEL29_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 29.
LEVEL30_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 30.
LEVEL30_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 30.
LEVEL30_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 30.
LEVEL31_SEGMENT VARCHAR2 128 Accounting segment number at hierarchy level 31.
LEVEL31_VALUESET_CODE VARCHAR2 128 Value set for accounting segment number at hierarchy level 31. It is the highest level.
LEVEL31_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 31.
FIXED_HIER_LEVEL NUMBER 38 0 Distance of the node from the highest level of hierarchy.

DW_GL_SEGMENT_D_TL

This table contains translated information about accounting segments.

Details

Module: General Ledger

Key Columns

GL_SEGMENT_VALUESET_CODE, GL_SEGMENT_CODE, LANGUAGE

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GL_SEGMENT_VALUESET_CODE VARCHAR2 64 True Accounting segment value set identifier. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT_CODE VARCHAR2 256 True Accounting segment code. DW_GL_SEGMENT_D GL_SEGMENT_CODE
LANGUAGE VARCHAR2 16 True Language code.
SOURCE_RECORD_ID VARCHAR2 512 Source record identifier. Value is derived from a combination of accounting segment value set identifier and accounting segment code.
GL_SEGMENT_ID VARCHAR2 1024 Accouting segment identifier, Value is derived from a combination of accounting segment value set identifier and accounting segment code.
GL_SEGMENT_NAME VARCHAR2 256 GL Segment Value name
GL_SEGMENT_DESCRIPTION VARCHAR2 256 GL Segment Value Description

DW_GL_SLA_SUBLEDGER_LINKAGE_G

This table contains link between general ledger journals and subledger.

Details

Module: General Ledger

Key Columns

APPLICATION_ID, JOURNAL_LINE_NUM, REF_AE_HEADER_ID, AE_HEADER_ID, DISTRIBUTION_ID, TEMP_LINE_NUM, JOURNAL_HEADER_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
APPLICATION_ID NUMBER 38 0 True Functional area within a software suite of products. For example, Financials -Payables 200, Receivables 222.
DISTRIBUTION_ID NUMBER 38 0 True Transaction source distribution identifier.
REF_AE_HEADER_ID NUMBER 38 0 True Reversed subledger journal entry header identifier.
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.
JOURNAL_HEADER_ID NUMBER 38 0 True Journal entry header identifier.
JOURNAL_LINE_NUM NUMBER 38 0 True Line number of the imported journal.
SOURCE_RECORD_ID VARCHAR2 256 Source Record Identifier. Values are derived by concatenating application identifier, distribution identifier, journal header identifier and journal line number.
SUBLEDGER_FACT_NAME VARCHAR2 64 Subledger fact name.
SUBLEDGER_GBL_CURR_FACT_NAME VARCHAR2 64 Subledger global currency fact name.
SUBLEDGER_LINK_COLUMN VARCHAR2 32 Subledger linking column.
LINKAGE_ID NUMBER 38 0 Sub legder linkage identifier.
JOURNAL_BATCH_NAME VARCHAR2 128 User-defined journal batch name.
JOURNAL_HEADER_NAME VARCHAR2 128 User-entered journal header name.
JOURNAL_HEADER_DESCRIPTION VARCHAR2 256 User-entered journal header description.
JOURNAL_HEADER_STATUS VARCHAR2 16 Journal entry header status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
JRNL_HDR_DFLT_EFFECTIVE_DATE DATE Journal entry default effective date
JOURNAL_POSTED_DATE DATE Date when journal entry header was posted.
JOURNAL_CATEGORY VARCHAR2 32 Journal category code. Journal entry is assigned a journal entry category to identify its purpose. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_SOURCE VARCHAR2 32 Journal source. Journal entry is assigned a source name to indicate how it was created. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_REVERSAL_STATUS VARCHAR2 16 Reversed journal entry status code.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_HEADER_CREATION_DATE TIMESTAMP Date and time of the creation of the journal header row
JOURNAL_HEADER_CREATED_BY_ID VARCHAR2 128 Journal header created by user identifier DW_USER_D USERNAME
LEDGER_ID NUMBER 38 0 Ledger identifier DW_LEDGER_D LEDGER_ID
JOURNAL_LINE_DESCRIPTION VARCHAR2 256 User-entered journal line description.
JOURNAL_LINE_STATUS VARCHAR2 16 Journal entry line status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_LINE_CREATED_BY_ID VARCHAR2 128 Journal line created by user identifier DW_USER_D USERNAME
JOURNAL_BATCH_ID NUMBER Journal entry batch defining column.
JOURNAL_APPROVAL_STATUS_CODE VARCHAR2 16 Journal entry batch approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JE_BATCH_APPROVAL_STATUS. Possible values are V,R,I,A,J,Z.
JOURNAL_APPROVED_BY VARCHAR2 128 Defining column of the employee who submitted the journal batch for approval.
JOURNAL_BATCH_DESCRIPTION VARCHAR2 256 Journal entry batch description.
GL_FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
GL_FISCAL_PERIOD_NAME VARCHAR2 16 Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ACCT_PERIOD_START_DATE DATE Accounting period start date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
ACCT_PERIOD_END_DATE DATE Accounting period end date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
GL_SL_LINK_ID NUMBER 38 0 Link to associated subledger data
EVENT_TYPE_CODE VARCHAR2 32 Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
EVENT_CLASS_CODE VARCHAR2 32 Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.
GL_TRANSFER_STATUS_CODE VARCHAR2 32 General Ledger transfer status code.
GL_TRANSFER_DATE DATE Date when journal entry is transferred to general ledger.
XLA_ACCOUNTING_DATE DATE Date used to determine the accounting period for transactions.
XLA_CREATED_BY_USER_ID VARCHAR2 128 Indicates the user who created the row.

DW_GL_SUBLEDGER_LINKAGE_G

This table contains link between general ledger journals and subledger.

Details

Module: General Ledger

Key Columns

JOURNAL_HEADER_ID, JOURNAL_LINE_NUM, APPLICATION_ID, DISTRIBUTION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
APPLICATION_ID NUMBER 38 0 True Functional area within a software suite of products. For example, Financials -Payables 200, Receivables 222.
DISTRIBUTION_ID NUMBER 38 0 True Transaction source distribution identifier.
JOURNAL_HEADER_ID NUMBER 38 0 True Journal entry header identifier.
JOURNAL_LINE_NUM NUMBER 38 0 True Line number of the imported journal.
SOURCE_RECORD_ID VARCHAR2 256 Source Record Identifier. Values are derived by concatenating application identifier, distribution identifier, journal header identifier and journal line number.
SUBLEDGER_FACT_NAME VARCHAR2 64 Subledger fact name.
SUBLEDGER_GBL_CURR_FACT_NAME VARCHAR2 64 Subledger global currency fact name.
SUBLEDGER_LINK_COLUMN VARCHAR2 32 Subledger linking column.
LINKAGE_ID NUMBER 38 0 Sub legder linkage identifier.

DW_NATURAL_ACCOUNT_D

This table contains natural account segment information.

Details

Module: General Ledger

Key Columns

NATURAL_ACCOUNT_SEGMENT, NTRL_ACNT_SGMNT_VALUESET_CODE

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 True Natural account value set identifier.
NATURAL_ACCOUNT_SEGMENT VARCHAR2 256 True Natural account segment code.
SOURCE_RECORD_ID VARCHAR2 512 Source record identifier. Value is derived from a combination of natural account value set identifier and segment code.
NATURAL_ACCOUNT_SEGMENT_ID VARCHAR2 512 Natural account segment identifier, Value is derived by combining natural account value set identifier and segment code.
ACCOUNT_TYPE VARCHAR2 32 Account type code. Possible values are O for Owner's Equity, R for Revenue, A for Asset, E for Expense, or L for Liability.
FINANCIAL_CATEGORY VARCHAR2 32 Account financial category. Possible values are AP, AR, COGS, DEPRECIATION, CASH, and so on.

DW_NATURAL_ACCOUNT_DH

This table contains information about natural account segment hierarchy.

Details

Module: General Ledger

Key Columns

HIERARCHY_VALUESET_CODE, NATURAL_ACCOUNT_SEGMENT, HIERARCHY_TREE_CODE, HIERARCHY_VERSION_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
HIERARCHY_VALUESET_CODE VARCHAR2 128 True Natural account hierarchy tree value set identifier. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
HIERARCHY_TREE_CODE VARCHAR2 32 True Natural account hierarchy tree identifier.
NATURAL_ACCOUNT_SEGMENT VARCHAR2 128 True Natural account number. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
HIERARCHY_VERSION_ID VARCHAR2 64 True Natural account hierarchy tree version.
SOURCE_RECORD_ID VARCHAR2 512 Source record identifier.
HIERARCHY_NAME VARCHAR2 128 Natural account hierarchy name.
HIERARCHY_VERSION_NAME VARCHAR2 128 Natural account hierarchy tree version name.
TREE_CODE_VER_EFF_START_DATE DATE Hierarchy start date.
TREE_CODE_VER_EFF_END_DATE DATE Hierarchy end date.
HIERARCHY_VERSION_STATUS VARCHAR2 32 Hierarchy version status.
LEVEL0_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 0.
LEVEL0_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 0. It is the lowest level.
LEVEL0_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 0.
LEVEL1_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 1.
LEVEL1_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 1.
LEVEL1_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 1.
LEVEL2_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 2.
LEVEL2_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 2.
LEVEL2_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 2.
LEVEL3_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 3.
LEVEL3_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 3.
LEVEL3_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 3.
LEVEL4_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 4.
LEVEL4_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 4.
LEVEL4_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 4.
LEVEL5_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 5.
LEVEL5_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 5.
LEVEL5_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 5.
LEVEL6_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 6.
LEVEL6_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 6.
LEVEL6_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 6.
LEVEL7_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 7.
LEVEL7_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 7.
LEVEL7_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 7.
LEVEL8_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 8.
LEVEL8_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 8.
LEVEL8_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 8.
LEVEL9_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 9.
LEVEL9_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 9.
LEVEL9_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 9.
LEVEL10_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 10.
LEVEL10_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 10.
LEVEL10_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 10.
LEVEL11_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 11.
LEVEL11_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 11.
LEVEL11_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 11.
LEVEL12_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 12.
LEVEL12_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 12.
LEVEL12_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 12.
LEVEL13_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 13.
LEVEL13_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 13.
LEVEL13_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 13.
LEVEL14_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 14.
LEVEL14_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 14.
LEVEL14_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 14.
LEVEL15_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 15.
LEVEL15_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 15.
LEVEL15_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 15.
LEVEL16_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 16.
LEVEL16_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 16.
LEVEL16_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 16.
LEVEL17_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 17.
LEVEL17_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 17.
LEVEL17_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 17.
LEVEL18_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 18.
LEVEL18_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 18.
LEVEL18_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 18.
LEVEL19_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 19.
LEVEL19_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 19.
LEVEL19_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 19.
LEVEL20_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 20.
LEVEL20_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 20.
LEVEL20_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 20.
LEVEL21_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 21.
LEVEL21_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 21.
LEVEL21_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 21.
LEVEL22_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 22.
LEVEL22_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 22.
LEVEL22_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 22.
LEVEL23_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 23.
LEVEL23_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 23.
LEVEL23_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 23.
LEVEL24_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 24.
LEVEL24_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 24.
LEVEL24_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 24.
LEVEL25_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 25.
LEVEL25_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 25.
LEVEL25_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 25.
LEVEL26_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 26.
LEVEL26_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 26.
LEVEL26_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 26.
LEVEL27_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 27.
LEVEL27_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 27.
LEVEL27_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 27.
LEVEL28_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 28.
LEVEL28_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 28.
LEVEL28_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 28.
LEVEL29_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 29.
LEVEL29_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 29.
LEVEL29_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 29.
LEVEL30_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 30.
LEVEL30_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 30.
LEVEL30_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 30.
LEVEL31_SEGMENT VARCHAR2 128 Natural account number at hierarchy level 31.
LEVEL31_VALUESET_CODE VARCHAR2 128 Value set for natural account number at hierarchy level 31. It is the highest level.
LEVEL31_SEGMENT_ID VARCHAR2 256 Level identifier, Derived by combining value set code and segment number at hierarchy level 31.
FIXED_HIER_LEVEL NUMBER 38 0 Distance of the node from the highest level of hierarchy.

Payables

DW_AP_AGING_BUCKETS_D

This table contains the AP Aging method and aging bucket definitions.

Details

Module: Payables

Key Columns

AGING_PERIOD_LINE_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AGING_PERIOD_LINE_ID NUMBER 38 0 True Aging period line identifier.
SOURCE_RECORD_ID NUMBER 38 0 Source record identifier for aging buckets. It is used as the primary key.
AGING_PERIOD_NAME VARCHAR2 64 Aging period name.
AGING_PERIOD_DESCRIPTION VARCHAR2 256 Aging period description.
AGING_BUCKET_NAME VARCHAR2 16 Aging bucket name.
AGING_BUCKET_NUMBER NUMBER Aging bucket number.
DAYS_FROM NUMBER Starting day number for aging bucket.
DAYS_TO NUMBER Ending day number for aging bucket.
OVERDUE_FLAG VARCHAR2 16 Indicates that the aging bucket is overdue. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
ACTIVE_FLAG VARCHAR2 16 Indicates that the aging bucket is active. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE

DW_AP_AGING_INVOICE_A

This table contains the aging information for each Open Payment schedule in Payables. It supports aging analysis at the Payment schedule level.

Details

Module: Payables

Key Columns

SNAPSHOT_PERIOD_END_DATE_ID, SNAPSHOT_CAPTURED_DATE, INVOICE_SCHEDULE_NUMBER, INVOICE_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SNAPSHOT_PERIOD_END_DATE_ID NUMBER 38 0 True Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD) DW_FISCAL_DAY_D FISCAL_PERIOD_END_DATE_ID
SNAPSHOT_CAPTURED_DATE DATE True Date when the snapshot is captured (Note for a current snapshot this will point to the actual date and not month end date)
INVOICE_ID NUMBER 38 0 True Invoice identifier.
INVOICE_SCHEDULE_NUMBER NUMBER 38 0 True Invoice schedule number.
SOURCE_RECORD_ID VARCHAR2 128 Source record identifier. Values are derived from combination of invoice identifier and invoice schedule number.
INVOICE_NUMBER VARCHAR2 64 Invoice number.
INVOICE_GROUP VARCHAR2 64 Invoice Group or Invoice batch name
SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 Payables liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
INVOICED_ON_DATE DATE Date when invoiced is created.
INVOICE_RECEIVED_DATE DATE Date when invoice is received.
INVOICE_SCHEDULE_DUE_DATE DATE Invoice schedule due date.
FIRST_DISCOUNT_DATE DATE Date when first discount is available.
SECOND_DISCOUNT_DATE DATE Date when second discount is available.
THIRD_DISCOUNT_DATE DATE Date when third discount is available.
INVOICE_HOLD_FLAG VARCHAR2 16 Indicates if invoice had any hold in the past. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
HOLD_STATUS_FLAG VARCHAR2 16 Indicates that the invoice is on hold. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
INVOICE_SCH_HOLD_STATUS_FLAG VARCHAR2 16 Flag that indicates if scheduled payment is on hold .Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
OVERDUE_FLAG VARCHAR2 16 Indicates that the invoice is overdue. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
ELAPSED_DAYS_DUE NUMBER 38 0 Number of days elapsed since invoice due date.
ELAPSED_DAYS_OPEN NUMBER 38 0 Number of days elapsed since invoice was created.
PAYMENT_TERMS_ID NUMBER 38 0 Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
PAYMENT_METHOD_CODE VARCHAR2 32 Payment method. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_TYPE_CODE VARCHAR2 32 Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_SOURCE_CODE VARCHAR2 32 Invoice source. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64 Invoice approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. DW_CODE_VALUES_LKP_TL CODE
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 32 Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_ACCOUNTING_STATUS_CODE VARCHAR2 32 Invoice accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Invoice currency code.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
TRANSACTION_AMOUNT NUMBER Invoice schedule amount in invoice currency.
LEDGER_AMOUNT NUMBER Invoice schedule amount in ledger currency.
REMAINING_TRANSACTION_AMOUNT NUMBER Invoice schedule remaining amount in invoice currency.
REMAINING_LEDGER_AMOUNT NUMBER Invoice schedule remaining amount in ledger currency.
INVC_SCHEDULE_CLEARED_DATE TIMESTAMP Date when invoice schedule was paid
INVOICE_SCHEDULE_STATUS_CODE VARCHAR2 32 Invoice Schedule Status.For translation refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='INVOICE PAYMENT STATUS' DW_CODE_VALUES_LKP_TL CODE
INVOICE_ACCOUNTING_DATE DATE Date when invoice was accounted
INVOICE_CREATION_DATE TIMESTAMP Date when invoice row was created in the table.
INVOICE_CREATION_DATE_1 DATE Date when invoice row was created in the table.
NET_ACTIVITY_AMOUNT NUMBER Net activity amount in invoice currency
NET_ACTIVITY_LEDGER_AMOUNT NUMBER Net activity amount in ledger currency
HEADER_CREATED_BY_USER_ID VARCHAR2 128 User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128 User who updated the invoice. DW_USER_D USERNAME

DW_AP_AGING_INVOICE_CA

This table contains the aging information for each Open Payment schedule in Payables. It supports aging analysis at Payment schedule level.

Details

Module: Payables

Key Columns

SNAPSHOT_PERIOD_END_DATE_ID, SNAPSHOT_CAPTURED_DATE, INVOICE_SCHEDULE_NUMBER, INVOICE_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SNAPSHOT_PERIOD_END_DATE_ID NUMBER 38 0 True Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD) DW_FISCAL_DAY_D FISCAL_PERIOD_END_DATE_ID
SNAPSHOT_CAPTURED_DATE DATE True Date when the snapshot is captured (Note for a current snapshot this will point to the actual date and not the month end date)
INVOICE_ID NUMBER 38 0 True Invoice identifier.
INVOICE_SCHEDULE_NUMBER NUMBER 38 0 True Invoice schedule number.
SOURCE_RECORD_ID VARCHAR2 128 Source record identifier. Values are derived from combination of invoice identifier and invoice schedule number.
INVOICE_NUMBER VARCHAR2 64 Invoice number.
INVOICE_GROUP VARCHAR2 64 Invoice Group or Invoice batch name
SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 Payables liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
INVOICED_ON_DATE DATE Date when invoiced is created.
INVOICE_RECEIVED_DATE DATE Date when invoice is received.
INVOICE_SCHEDULE_DUE_DATE DATE Invoice schedule due date.
FIRST_DISCOUNT_DATE DATE Date when first discount is available.
SECOND_DISCOUNT_DATE DATE Date when second discount is available.
THIRD_DISCOUNT_DATE DATE Date when third discount is available.
INVOICE_HOLD_FLAG VARCHAR2 16 Indicates if invoice had any hold in the past. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
HOLD_STATUS_FLAG VARCHAR2 16 Indicates that the invoice is on hold. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
INVOICE_SCH_HOLD_STATUS_FLAG VARCHAR2 16 Flag that indicates if scheduled payment is on hold .Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
OVERDUE_FLAG VARCHAR2 16 Indicates that the invoice is overdue. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
ELAPSED_DAYS_DUE NUMBER 38 0 Number of days elapsed since invoice due date.
ELAPSED_DAYS_OPEN NUMBER 38 0 Number of days elapsed since invoice was created.
PAYMENT_TERMS_ID NUMBER 38 0 Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
PAYMENT_METHOD_CODE VARCHAR2 32 Payment method. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_TYPE_CODE VARCHAR2 32 Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_SOURCE_CODE VARCHAR2 32 Invoice source. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64 Invoice approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. DW_CODE_VALUES_LKP_TL CODE
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 32 Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. DW_CODE_VALUES_LKP_TL CODE
INVOICE_ACCOUNTING_STATUS_CODE VARCHAR2 32 Invoice accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Invoice currency code.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
TRANSACTION_AMOUNT NUMBER Invoice schedule amount in invoice currency.
LEDGER_AMOUNT NUMBER Invoice schedule amount in ledger currency.
REMAINING_TRANSACTION_AMOUNT NUMBER Invoice schedule remaining amount in invoice currency.
REMAINING_LEDGER_AMOUNT NUMBER Invoice schedule remaining amount in ledger currency.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate.
GLOBAL_AMOUNT NUMBER Invoice schedule amount in global currency.
REMAINING_GLOBAL_AMOUNT NUMBER Invoice schedule remaining amount in global currency.
INVC_SCHEDULE_CLEARED_DATE TIMESTAMP Date when invoice schedule was paid
INVOICE_SCHEDULE_STATUS_CODE VARCHAR2 32 Invoice Schedule Status.For translation refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='INVOICE PAYMENT STATUS' DW_CODE_VALUES_LKP_TL CODE
INVOICE_ACCOUNTING_DATE DATE Date when invoice was accounted
INVOICE_CREATION_DATE TIMESTAMP Date when invoice row was created in the table.
INVOICE_CREATION_DATE_1 DATE Date when invoice row was created in the table.
NET_ACTIVITY_AMOUNT NUMBER Net activity amount in invoice currency
NET_ACTIVITY_LEDGER_AMOUNT NUMBER Net activity amount in ledger currency
NET_ACTIVITY_GLOBAL_AMOUNT NUMBER Net activity amount in global currency
HEADER_CREATED_BY_USER_ID VARCHAR2 128 User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128 User who updated the invoice. DW_USER_D USERNAME

DW_AP_AGING_SUPPLIER_CA

Supplier Aging aggregate.Amounts aggregated by following dimensions:Fiscal Calendar,Supplier,Supplier Site, Third Party, Payable Business Unit, Ledger, Legal Entity, GL Account, Cost Center, Balancing Segment, Natural Account, GL Segments and Currency.

Details

Module: Payables

Key Columns

FISCAL_PERIOD_TYPE, SNAPSHOT_CAPTURED_DATE, LEGAL_ENTITY_ID, SUPPLIER_SITE_ID, SUPPLIER_PARTY_ID, TRANSACTION_CURRENCY_CODE, FISCAL_PERIOD_SET_NAME, LEDGER_ID, GL_CODE_COMBINATION_ID, THIRD_PARTY_ID, INVOICE_SCHEDULE_STATUS_CODE, SNAPSHOT_PERIOD_END_DATE_ID, PAYABLES_BU_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SNAPSHOT_PERIOD_END_DATE_ID NUMBER 38 0 True Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD) DW_FISCAL_DAY_D FISCAL_PERIOD_END_DATE_ID
SNAPSHOT_CAPTURED_DATE DATE True Date when the snapshot is captured (Note for a current snapshot this will point to the actual date and not the month end date)
SUPPLIER_PARTY_ID NUMBER 38 0 True Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 True Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 True Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 True Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 True Payables liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 True Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
TRANSACTION_CURRENCY_CODE VARCHAR2 16 True Invoice currency code.
INVOICE_SCHEDULE_STATUS_CODE VARCHAR2 32 True Invoice Schedule Status.For translation refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='INVOICE PAYMENT STATUS' DW_CODE_VALUES_LKP_TL CODE
SOURCE_RECORD_ID VARCHAR2 1024 Source record identifier.
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
TRANSACTION_AMOUNT NUMBER Total Invoice schedule amount in invoice currency.
LEDGER_AMOUNT NUMBER Total Invoice schedule amount in ledger currency.
GLOBAL_AMOUNT NUMBER Total Invoice schedule amount in global currency.
REMAINING_TRANSACTION_AMOUNT NUMBER Total Invoice schedule remaining amount in invoice currency.
REMAINING_LEDGER_AMOUNT NUMBER Total Invoice schedule remaining amount in ledger currency.
REMAINING_GLOBAL_AMOUNT NUMBER Total Invoice schedule remaining amount in global currency.
NET_ACTIVITY_AMOUNT NUMBER Total Net activity amount in invoice currency
NET_ACTIVITY_LEDGER_AMOUNT NUMBER Total Net activity amount in ledger currency
NET_ACTIVITY_GLOBAL_AMOUNT NUMBER Total Net activity amount in global currency

DW_AP_BALANCE_CF

This table contains details about Payables balance currency.

Details

Module: Payables

Key Columns

FISCAL_PERIOD_END_DATE_ID, BALANCE_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BALANCE_ID VARCHAR2 1024 True Balance identifier. Value is derived from a combination of supplier identifier, supplier site identifier, payables business unit identifier, ledger identifier, legal entity identifier, payables liability account identifier, accounting calendar, and accounting period type.
FISCAL_PERIOD_END_DATE_ID NUMBER 38 0 True Fiscal period end date identifier. DW_FISCAL_PERIOD_D FISCAL_PERIOD_END_DATE_ID
SOURCE_RECORD_ID VARCHAR2 2048 Source record identifier. Value is derived from a combination of balance identifier and fiscal period end date identifier.
SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 Payables liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
CURRENT_PERIOD_END_DATE_ID NUMBER 38 0 Current period end date identifier.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
ACTIVITY_LEDGER_CRNCY_AMOUNT NUMBER Activity amount in ledger currency.
BALANCE_LEDGER_CRNCY_AMOUNT NUMBER Balance amount in ledger currency.
CREDIT_LEDGER_CRNCY_AMOUNT NUMBER Credit amount in ledger currency.
DEBIT_LEDGER_CRNCY_AMOUNT NUMBER Debit amount in ledger currency.
DEBIT_CREDIT_INDICATOR VARCHAR2 16 Debit or Credit indicator. VARCHAR2
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code. VARCHAR2
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate. NUMBER
ACTIVITY_GLOBAL_CRNCY_AMOUNT NUMBER Activity amount in global currency. NUMBER
BALANCE_GLOBAL_CRNCY_AMOUNT NUMBER Balance amount in global currency. NUMBER
CREDIT_GLOBAL_CRNCY_AMOUNT NUMBER Credit amount in global currency. NUMBER
DEBIT_GLOBAL_CRNCY_AMOUNT NUMBER Debit amount in global currency. NUMBER

DW_AP_BALANCE_F

This table contains details about Payables balance.

Details

Module: Payables

Key Columns

FISCAL_PERIOD_END_DATE_ID, BALANCE_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BALANCE_ID VARCHAR2 1024 True Balance identifier. Value is derived from a combination of supplier identifier, supplier site identifier, payables business unit identifier, ledger identifier, legal entity identifier, payables liability account identifier, accounting calendar, and accounting period type.
FISCAL_PERIOD_END_DATE_ID NUMBER 38 0 True Fiscal period end date identifier. DW_FISCAL_PERIOD_D FISCAL_PERIOD_END_DATE_ID
SOURCE_RECORD_ID VARCHAR2 2048 Source record identifier. Value is derived from a combination of balance identifier and fiscal period end date identifier.
SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 Payables liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
CURRENT_PERIOD_END_DATE_ID NUMBER 38 0 Current period end date identifier.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
ACTIVITY_LEDGER_CRNCY_AMOUNT NUMBER Activity amount in ledger currency.
BALANCE_LEDGER_CRNCY_AMOUNT NUMBER Balance amount in ledger currency.
CREDIT_LEDGER_CRNCY_AMOUNT NUMBER Credit amount in ledger currency.
DEBIT_LEDGER_CRNCY_AMOUNT NUMBER Debit amount in ledger currency.
DEBIT_CREDIT_INDICATOR VARCHAR2 16 Debit or Credit indicator.

DW_AP_EXPENSE_DISTRIBUTION_F

This table contains details of expense distribution transactions for Payables.

Details

Module: Payables

Key Columns

DISTRIBUTION_LINE_NUMBER, INVOICE_LINE_NUMBER, PREPAY_APP_DIST_ID, INVOICE_DISTRIBUTION_ID, INVOICE_ID

Columns

Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_ID NUMBER 38 0 True Invoice identifier.
INVOICE_LINE_NUMBER NUMBER True Invoice line number.
DISTRIBUTION_LINE_NUMBER NUMBER 38 0 True Distribution line number.
INVOICE_DISTRIBUTION_ID NUMBER 38 0 True Invoice distribution identifier.
PREPAY_APP_DIST_ID NUMBER 38 0 True Prepayment application distribution identifier.
SOURCE_RECORD_ID VARCHAR2 128 Source record identifier. Value is derived from a combination of invoice identifier, invoice line number, distribution line number, invoice distribution identifier, and prepayment application distribution identifier.
LINKAGE_ID NUMBER 38 0 Sub legder linkage identifier.
INVOICE_NUMBER VARCHAR2 64 Invoice number.
INVOICE_GROUP VARCHAR2 64 Invoice Group or Invoice batch name
PURCHASE_ORDER_NUMBER VARCHAR2 32 Purchase order number.
PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase order line number.
PURCHASE_ORDER_SHIPMENT_NUM NUMBER Purchase order shipment number.
PURCHASE_ORDER_DIST_NUMBER NUMBER Purchase order distribution number.
RECEIVING_SHIPMENT_RECEIPT_NUM VARCHAR2 32 Shipment receipt number.
RECEIVING_SHIPMENT_LINE_NUMBER NUMBER 38 0 Shipment line number.
INVOICE_DESCRIPTION VARCHAR2 256 Invoice description.
PAYMENT_REASON_COMMENTS VARCHAR2 256 Reason for payment.
DISTRIBUTION_DESCRIPTION VARCHAR2 256 Distribution description.
SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 Expense account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
INV_DIST_VALIDATION_STATUS VARCHAR2 32 Invoice Distribution validation status.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. DW_CODE_VALUES_LKP_TL CODE
INV_DIST_REVERSAL_INDICATOR VARCHAR2 16 Flag that indicates if distribution is part of a reversal pair.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
INV_DISTRIBUTION_MATCH_TYPE VARCHAR2 32 Indicates whether an invoice matched a PO or a receipt of material.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=MATCH_STATUS. DW_CODE_VALUES_LKP_TL CODE
ACCOUNTING_DATE DATE Accounting date.
INVOICED_ON_DATE DATE Date when invoiced is created.
INVOICE_RECEIVED_DATE DATE Date when invoice is received.
PURCHASE_ORDER_DATE TIMESTAMP Purchase order creation date.
PAYMENT_TERMS_ID NUMBER 38 0 Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
INVOICE_TYPE_CODE VARCHAR2 32 Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. DW_CODE_VALUES_LKP_TL CODE
DISTRIBUTION_TYPE_CODE VARCHAR2 32 Distribution type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE DISTRIBUTION TYPE. Possible values are ITEM, ERV, NONREC_TAX, TRV, FREIGHT, MISCELLANEOUS, TIPV, AWT, IPV, REC_TAX, ACCRUAL, PREPAY, TERV, and so on. DW_CODE_VALUES_LKP_TL CODE
PREPAY_DIST_TYPE_CODE VARCHAR2 32 Type of prepayment application distribution.
INVOICE_SOURCE_CODE VARCHAR2 32 Invoice source. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. Possible values are INVOICE GATEWAY, Recurring Invoice, SelfService, Confirm PaymentBatch, LOANS, Manual Invoice Entry, QuickCheck, and so on. DW_CODE_VALUES_LKP_TL CODE
INVOICE_ACCOUNTING_STATUS_CODE VARCHAR2 32 Invoice distribution accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_CODE_VALUES_LKP_TL CODE
INVOICE_CANCELLED_FLAG VARCHAR2 32 Indicates a cancelled invoice. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
DISTRIBUTION_CANCELLED_FLAG VARCHAR2 16 Indicates a cancelled distribution. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Invoice currency code.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code.
TRANSACTION_AMOUNT NUMBER Distribution amount in invoice currency.
LEDGER_AMOUNT NUMBER Distribution amount in ledger currency.
CREATED_BY_USER_ID VARCHAR2 128 User who created the record. DW_USER_D USERNAME
UPDATED_BY_USER_ID VARCHAR2 128 User who updated the record. DW_USER_D USERNAME
HEADER_CREATED_BY_USER_ID VARCHAR2 128 User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128 User who updated the invoice. DW_USER_D USERNAME
INVOICE_CREATION_DATE TIMESTAMP Date when invoice row was created in the table.
INVOICE_CREATION_DATE_1 DATE