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