Tables

2 Tables

Tables Details

Expenses

DW_EXM_YES_NO_D_TL

Y and N translation

Details

Module: Expenses

Key Columns

CODE, LANGUAGE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	EXM_YES_NO
CODE	VARCHAR2	128	True	Values are N and Y
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type, code and language.
NAME	VARCHAR2	2048		Values are Yes , No
DESCRIPTION	VARCHAR2	4000		description

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
ACCOUNTING_SCENARIO_CODE	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_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.
CURRENCY_TYPE	VARCHAR2	64		True	Currency type.
TRANSLATED_FLAG	VARCHAR2	16		True	Indicates currency translation.
CONCAT_ACCOUNT	VARCHAR2	1024		True	The concatenated string of all the segments from segment 1 through segment 30.
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.
FISCAL_PERIOD_SET_NAME	VARCHAR2	16			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_START_DATE	DATE				Start date of the fiscal period.
FISCAL_PERIOD_NUMBER	NUMBER	38	0		Accounting period number.
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
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.
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.
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_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_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.

Name	Datatype	Length	Precision	Not Null	Comments
CUSTOMER_LOCATION_ID	NUMBER	38	0	True	Customer location identifier.
SOURCE_RECORD_ID	NUMBER	38	0		Source record identifier. Value is same as the customer location identifier.
STREET_ADDRESS1	VARCHAR2	256			Street name of the customer location.
STREET_ADDRESS2	VARCHAR2	256			Street number of the customer location.
STREET_ADDRESS3	VARCHAR2	256			Street description of the address.
STREET_ADDRESS4	VARCHAR2	256			Street description of the address.
POSTAL_CODE	VARCHAR2	64			Postal code of the customer location.
CITY	VARCHAR2	64			City of the customer location.
COUNTY	VARCHAR2	64			County name of the customer location.
STATE_PROVINCE_CODE	VARCHAR2	64			State of the customer location. Possible values are AZ, CA, and so on.
COUNTRY_CODE	VARCHAR2	16			Country code of the customer location. Possible values are USA for United States of America, UK for United Kingdom, and so on.
ACTIVE_FLAG	VARCHAR2	16			Indicates an active customer location.

Subledger Accounting

DW_GL_SLA_RECON_CF

This is the reconciliation table with AP facts, AR facts,XLA details, Journal details and GL balance details.

Details

Module: Subledger Accounting

Key Columns

AE_HEADER_ID, JOURNAL_LINE_NUM, APPLICATION_ID, SOURCE_DISTRIBUTION_ID_NUM_1, PARENT_STRIPE, JOURNAL_HEADER_ID, AE_LINE_NUM, REF_AE_HEADER_ID, TEMP_LINE_NUM

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
PARENT_STRIPE	VARCHAR2	128		True	To identify different types of Entities eg. AR_RECEIPTS, AR_TRANSACTIONS etc
APPLICATION_ID	NUMBER	38	0	True	101 for GL, 200 for AP, 222 for AR
AE_HEADER_ID	NUMBER	38	0	True	Subledger journal entry identifier.
AE_LINE_NUM	NUMBER	38	0	True	Number that is associated with each subledger journal entry line.
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.
SOURCE_DISTRIBUTION_ID_NUM_1	NUMBER	38	0	True	Sub legder transaction source distribution identifier.
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	1024			Unique record identifier
STRIPE	VARCHAR2	128			To identify different types of stripes eg. Posted to GL, transferred to GL etc
XLA_LEDGER_ID	NUMBER	38	0		SLA ledger identifier	DW_LEDGER_D	LEDGER_ID
RECON_LEDGER_ID	NUMBER	38	0		Ledger Id	DW_LEDGER_D	LEDGER_ID
JOURNAL_LEDGER_ID	NUMBER	38	0		Journal Ledger identifier.	DW_LEDGER_D	LEDGER_ID
JOURNAL_LEDGER_CATEGORY_CODE	VARCHAR2	128			Journal Ledger category. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_ASF_LEDGER_CATEGORY. Possible values are PRIMARY, SECONDARY, ALC, and so on.	DW_CODE_VALUES_LKP_TL	CODE
LEGAL_ENTITY_ID	NUMBER	38	0		Legal entity identifier.	DW_LEGAL_ENTITY_D	LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID	NUMBER	38	0		GL 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
FISCAL_PERIOD_NAME	VARCHAR2	256			Accounting period name.	DW_FISCAL_DAY_D	FISCAL_PERIOD_NAME
ACCOUNTING_DATE	DATE				Pre-SLA Accounting date.	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
RECON_FISCAL_PERIOD_SET_NAME	VARCHAR2	16			Accounting calendar name(driven by xla accounting date for AP and AR, Journal header effective date for GL )..	DW_FISCAL_DAY_D	FISCAL_PERIOD_SET_NAME
RECON_FISCAL_PERIOD_TYPE	VARCHAR2	16			Accounting period type(driven by xla accounting date for AP and AR, Journal header effective date for GL )..	DW_FISCAL_DAY_D	FISCAL_PERIOD_TYPE
RECON_FISCAL_PERIOD_NAME	VARCHAR2	256			Accounting period name(driven by xla accounting date for AP and AR, Journal header effective date for GL ).	DW_FISCAL_DAY_D	FISCAL_PERIOD_NAME
RECON_ACCOUNTING_DATE	DATE				Accounting date(driven by xla accounting date for AP and AR, Journal header effective date for GL )..	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
JRNL_HDR_DFLT_EFFECTIVE_DATE	DATE				Journal header effective date.	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
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
PAYABLES_CODE_COMB_ID	NUMBER	38	0		Payables Account Identifier	DW_GL_CODE_COMBINATION_D	CODE_COMBINATION_ID
INVOICE_ID	NUMBER	38	0		Invoice identifier
INVOICE_NUMBER	VARCHAR2	64			Invoice number
INVOICE_GROUP	VARCHAR2	64			Invoice Group or Invoice batch name
INVOICE_DESCRIPTION	VARCHAR2	256			Invoice description
INVOICE_VOUCHER_NUMBER	VARCHAR2	64			Voucher number related to the invoice; Validated (Sequential Numbering enabled) or Non-Validated (Sequential Numbering not enabled)
AP_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 (OR) Payment distribution type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAY_DIST_TYPES.	DW_CODE_VALUES_LKP_TL	CODE
AP_ACCOUNTING_STATUS_CODE	VARCHAR2	32			Invoice distribution accounting status or Payment accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS.	DW_CODE_VALUES_LKP_TL	CODE
PURCHASE_ORDER_DATE	TIMESTAMP				Purchase order creation date.
INVOICED_ON_DATE	DATE				Date when invoiced is created.
INVOICE_RECEIVED_DATE	DATE				Date when invoice is received.
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
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_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
HEADER_CREATED_BY_USER_ID	VARCHAR2	128			User who created the invoice.	DW_USER_D	USERNAME
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
INVOICE_CREATION_DATE	TIMESTAMP				Date when invoice row was created in the table.
INVOICE_LINE_NUMBER	NUMBER				Invoice line number.
DISTRIBUTION_LINE_NUMBER	NUMBER	38	0		Distribution line number.
PURCHASE_ORDER_NUMBER	VARCHAR2	32			Purchase order number.
PURCHASE_ORDER_LINE_NUMBER	NUMBER				Purchase order line number.
RECEIVING_SHIPMENT_RECEIPT_NUM	VARCHAR2	32			Shipment receipt number.
RECEIVING_SHIPMENT_LINE_NUMBER	NUMBER	38	0		Shipment line number.
DISTRIBUTION_DESCRIPTION	VARCHAR2	256			Distribution description.
AP_INVOICE_ACCOUNTING_DATE	DATE				Date when invoice was accounted	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
PREPAY_DIST_TYPE_CODE	VARCHAR2	32			Type of prepayment application distribution.
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
PAYABLES_PAYMENTS_BU_ID	NUMBER	38	0		Payables payments business unit identifier.	DW_INTERNAL_ORG_D	ORGANIZATION_ID
INVOICE_SCHEDULE_NUMBER	NUMBER	38	0		Invoice schedule number.
CHECK_ID	NUMBER	38	0		Check Identifier
CHECK_NUMBER	NUMBER	38	0		Check number.
PAYMENT_REASON_COMMENTS	VARCHAR2	256			Reason for payment.
CHECK_DATE	DATE				Date when check was issued.
CHECK_CLEARED_DATE	DATE				Check cleared date.
PAYMENT_STATUS_CODE	VARCHAR2	32			Payment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=CHECK STATE.	DW_CODE_VALUES_LKP_TL	CODE
PAYMENT_CANCELLED_FLAG	VARCHAR2	16			Indicates a cancelled payment. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO.	DW_CODE_VALUES_LKP_TL	CODE
CUSTOMER_ID	NUMBER	38	0		Customer identifier.	DW_PARTY_D	PARTY_ID
CUSTOMER_ACCOUNT_ID	NUMBER	38	0		Customer account identifier.	DW_CUSTOMER_ACCOUNT_D	CUSTOMER_ACCOUNT_ID
RECEIVABLES_BU_ORG_ID	NUMBER	38	0		Receivables business unit organization identifier.	DW_INTERNAL_ORG_D	ORGANIZATION_ID
CUSTOMER_TRX_ID	NUMBER	38	0		Customer Transaction Identifier
TRANSACTION_NUMBER	VARCHAR2	32			Transaction number.
TRANSACTION_CLASS_CODE	VARCHAR2	32			Transaction class. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AR_TRANSACTION_TYPE_CODE. Possible values are INV, CM, DM, or CB.	DW_CODE_VALUES_LKP_TL	CODE
BATCH_SOURCE_SEQ_ID	NUMBER	38	0		Batch source sequence identifier.	DW_AR_TRX_BATCH_SOURCES_D	BATCH_SOURCE_SEQ_ID
CUST_TRX_TYPE_SEQ_ID	NUMBER	38	0		Transaction type identifier	DW_AR_TRANSACTION_TYPES_D	CUST_TRX_TYPE_SEQ_ID
LINE_NUMBER	NUMBER	38	0		Invoice Line Number
DETAIL_LINE_NUMBER	NUMBER	38	0		Invoice Detail Number
DISTRIBUTION_COMMENTS	VARCHAR2	256			Distribution Line comments
RECEIVABLES_RECEIPT_BU_ORG_ID	NUMBER	38	0		Receivables receipt business unit organization identifier.	DW_INTERNAL_ORG_D	ORGANIZATION_ID
CASH_RECEIPT_ID	NUMBER	38	0		Cash Receipt ID
RECEIPT_NUMBER	VARCHAR2	32			Receipt number.
RECEIPT_TYPE	VARCHAR2	32			Receipt type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAYMENT_CATEGORY_TYPE. Possible values are CASH for Standard ,MISC for Miscellaneous.	DW_CODE_VALUES_LKP_TL	CODE
RECEIPT_STATUS_CODE	VARCHAR2	32			Receipt status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_CREATION_STATUS. Possible values are APPROVED, CLEARED, CONFIRMED, REMITTED, REVERSED, RISK_ELIMINATED	DW_CODE_VALUES_LKP_TL	CODE
RECEIPT_APPLN_STATUS_CODE	VARCHAR2	32			Receipt application status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_STATUS. Possible values are NSF forNonsufficient funds, APP for Applied, STOP for Stopped payment and so on.	DW_CODE_VALUES_LKP_TL	CODE
RECEIPT_APPLN_ACCOUNTING_DATE	DATE				Receipt application accounting date.	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
ADJUSTMENT_ID	NUMBER	38	0		Adjustment identifier.
ADJUSTMENT_NUMBER	VARCHAR2	128			Adjustment number.
ADJUSTMENT_TYPE	VARCHAR2	16			Adjustment type . Possible values are CHARGES,INVOICE,LINE,FREIGHT,TAX and so on.
ADJUSTMENT_STATUS_CODE	VARCHAR2	32			Adjustment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=ADJUSTMENT_STATUS. Possible values are A, R, and so on.	DW_CODE_VALUES_LKP_TL	CODE
CREDITMEMO_APPL_STATUS_CODE	VARCHAR2	32			Credit memo application status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_STATUS or AR_APPLICATION_STATUS. Possible values are APP, ACTIVITY, and so on.	DW_CODE_VALUES_LKP_TL	CODE
APPLIED_TRANSACTION_NUMBER	VARCHAR2	32			Applied transaction number.
XLA_TRANSACTION_AMOUNT	NUMBER				Unrounded entered amount
XLA_LEDGER_AMOUNT	NUMBER				Unrounded accounted amount
XLA_ENTERED_DR_AMOUNT	NUMBER				Unrounded entered debit amount for the journal line.
XLA_ENTERED_CR_AMOUNT	NUMBER				Unrounded entered credit amount for the journal line.
XLA_ACCOUNTED_DR_AMOUNT	NUMBER				Unrounded accounted debit for journal entry line.
XLA_ACCOUNTED_CR_AMOUNT	NUMBER				Unrounded accounted credit for journal entry line.
XLA_MANUAL_OVERRIDE_FLAG	VARCHAR2	16			Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE='YES/NO'.	DW_CODE_VALUES_LKP_TL	CODE
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	32			Classification of transaction source distribution
ACCOUNTING_LINE_CODE	VARCHAR2	32			Short name of a rule to convert transactional data into a journal entry line.
ACCOUNTING_LINE_TYPE_CODE	VARCHAR2	16			Type of journal line rule: Debit, Credit, Gain or Loss.
ACCOUNTING_CLASS_CODE	VARCHAR2	32			Short name of a lookup type that is shared across application used to classify journal entry lines.	DW_XLA_ACCOUNT_CLASS_LKP_TL	ACCOUNTING_CLASS_CODE
XLA_LINE_TRANSACTION_AMOUNT	NUMBER				XLA Line Amount in transaction Currency
XLA_LINE_ENTERED_DR_AMOUNT	NUMBER				Unrounded entered debit amount for the journal line.
XLA_LINE_ENTERED_CR_AMOUNT	NUMBER				Unrounded entered credit amount for the journal line.
XLA_LINE_LEDGER_AMOUNT	NUMBER				XLA Line Amount in Ledger Currency
XLA_LINE_ACCOUNTED_DR_AMOUNT	NUMBER				Unrounded accounted debit amount of the journal entry line.
XLA_LINE_ACCOUNTED_CR_AMOUNT	NUMBER				Unrounded accounted credit amount of the journal entry line.
XLA_TRX_CURRENCY_CODE	VARCHAR2	16			Transaction Currency Code
RECON_TRX_CURRENCY_CODE	VARCHAR2	16			Transaction Currency Code (driven by xla trx currency code for AP and AR, Journal Transaction currency code for GL )
XLA_LEDGER_CURRENCY_CODE	VARCHAR2	16			Functional currency of the ledger.
RECON_LEDGER_CURRENCY_CODE	VARCHAR2	16			Ledger Currency Code (driven by xla ledger currency code for AP and AR, Journal Ledger currency code for GL )
GL_SL_LINK_ID	NUMBER	38	0		Audit trail from subledger application to general ledger.
EVENT_TYPE_CODE	VARCHAR2	32			Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.	DW_XLA_EVENT_TYPES_LKP_TL	EVENT_TYPE_CODE
EVENT_CLASS_CODE	VARCHAR2	32			Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.	DW_XLA_EVENT_CLASSES_LKP_TL	EVENT_CLASS_CODE
GL_TRANSFER_STATUS_CODE	VARCHAR2	32			General Ledger transfer status code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_TRANSFER_STATUS.	DW_CODE_VALUES_LKP_TL	CODE
GL_TRANSFER_DATE	DATE				Date when journal entry is transferred to general ledger.	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
XLA_ACCOUNTING_DATE	DATE				SLA Accounting date.	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
XLA_CREATED_BY_USER_ID	VARCHAR2	128			Who column: indicates the user who created the row.	DW_USER_D	USERNAME
JOURNAL_BATCH_ID	NUMBER				Journal entry batch defining column.
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
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_POSTED_DATE	DATE				Date when journal entry header was posted.	DW_FISCAL_DAY_D	FISCAL_DAY_DATE
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				Journal Amount in transaction currency.
TRANSACTION_CURRENCY_CODE	VARCHAR2	16			Journal Transaction currency code.
LEDGER_CURRENCY_AMOUNT	NUMBER				Journal Amount in ledger currency.
LEDGER_CURRENCY_CODE	VARCHAR2	16			Journal Ledger currency code.
CURRENCY_CONVERSION_DATE	DATE				Journal Currency conversion date.
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_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_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.	DW_CODE_VALUES_LKP_TL	CODE
JOURNAL_APPROVED_BY	VARCHAR2	128			Defining column of the employee who submitted the journal batch for approval.	DW_USER_D	USERNAME
JOURNAL_BATCH_DESCRIPTION	VARCHAR2	256			Journal entry batch description.
JOURNAL_HEADER_CREATION_DATE	TIMESTAMP				Date and time of the creation of the journal header row
TRANSLATED_FLAG	VARCHAR2	16			Indicates currency translation.
CURRENCY_TYPE	VARCHAR2	64			Currency type.
TRXN_CRNC_PRD_NET_ACTIVITY	NUMBER				Accounting period net balance.
TRXN_CRNC_PRD_NET_ACTIVITY_DR	NUMBER				Accounting period net credit.
TRXN_CRNC_PRD_NET_ACTIVITY_CR	NUMBER				Accounting period net debit.
LDGR_CRNC_PRD_NET_ACTIVITY	NUMBER				Accounting period net balance in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_DR	NUMBER				Accounting period net credit in ledger currency.
LDGR_CRNC_PRD_NET_ACTIVITY_CR	NUMBER				Accounting period net debit in ledger currency.
DELTA_FLAG	VARCHAR2	16			Delta flag to identify if the records exist in Distribution link table or if it exists only in xla_ae_lines.
EVENT_ID	NUMBER	38	0		Identifier of the categorization of accounting events that is unique within an application and event class
ACCOUNTING_ENTRY_STATUS_CODE	VARCHAR2	32			Status code of the accounting entry
JGZZ_RECON_REF	VARCHAR2	256			Reconciliation reference.
RECON_BU_ID	NUMBER	38	0		Common across all pillars - business unit organization identifier.	DW_INTERNAL_ORG_D	ORGANIZATION_ID
RECON_XLA_TRANSACTION_AMOUNT	NUMBER				Recon Column to equalize distribution and line amounts in trx currency
RECON_XLA_LEDGER_AMOUNT	NUMBER				Recon Column to equalize distribution and line amounts in ledger currency
RECON_XLA_ENTERED_DR_AMOUNT	NUMBER				Unrounded entered debit amount for the journal line/dist line.
RECON_XLA_ENTERED_CR_AMOUNT	NUMBER				Unrounded entered credit amount for the journal line/dist line.
RECON_XLA_ACCOUNTED_DR_AMOUNT	NUMBER				Unrounded accounted debit amount for the journal line/dist line.
RECON_XLA_ACCOUNTED_CR_AMOUNT	NUMBER				Unrounded accounted credit amount for the journal line/dist line.
RELATIONSHIP_TYPE_CODE	VARCHAR2	32			Relationship level between source and target ledger.
JOURNAL_LINE_ENTERED_DR	NUMBER				Journal entry line debit amount in entered currency.
JOURNAL_LINE_ENTERED_CR	NUMBER				Journal entry line credit amount in entered currency.
JOURNAL_LINE_ACCOUNTED_DR	NUMBER				Journal entry line debit amount in base currency.
JOURNAL_LINE_ACCOUNTED_CR	NUMBER				Journal entry line credit amount in base currency.

Name	Datatype	Length	Precision	Not Null	Comments
TARGET_TABLE_NAME	VARCHAR2	512		True	Table name where loading error occurred.
COLUMN_NAME	VARCHAR2	512		True	Column name added to the error record ID structure.
COLUMN_ORDER	NUMBER	38	0		Order of column in the error record ID structure.
SOURCE_TYPE_CODE	VARCHAR2	32			Source Code of OAX

DW_ERR_RECORDS

This table contains information about the loading error conditions.

Details

Module: Common

Columns

Name	Datatype	Length	Comments
JOB_ID	VARCHAR2	512	Job identifier. It can be used to identify all the errors or rejected records during a DW refresh.
PROCESS_NAME	VARCHAR2	128	Process which caused the error.
FUNCTIONAL_AREA_CODE	VARCHAR2	4000	Functional area name.
TABLE_NAME	VARCHAR2	512	Table name where loading error occurred.
TABLE_TYPE	VARCHAR2	32	Table type where loading error occurred. Possible values are WAREHOUSE or INTERNAL.
ERROR_TIME	TIMESTAMP		Date and time when the error occurred.
ERROR_CODE	VARCHAR2	256	Error type. Possible value are DUPLICATE, TRIM, or OTHER.
RESERVED1	VARCHAR2	32767	For oracle internal use only.
ERROR_RECORD_ID	VARCHAR2	4000	Error record identifier. Value is derived from concatenation of primary key value in the defined sequence with vertical bar as delimiter.
ERROR_STATUS	VARCHAR2	256	Placeholder column for future usage.
ERROR_SUB_STATUS	VARCHAR2	256	Placeholder column for future usage.
SOURCE_TYPE_CODE	VARCHAR2	32	Source Code of OAX

DW_FISCAL_CONTEXT_G

This table contains information about the relationship between organization or ledger with a fiscal calendar.

Details

Module: Common

Key Columns

LEDGER_ID, FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
ORGANIZATION_ID	NUMBER	38	0	True	Organization identifier.
LEDGER_ID	NUMBER	38	0	True	Ledger identifier.
FISCAL_PERIOD_SET_NAME	VARCHAR2	16		True	Accounting calendar name.
FISCAL_PERIOD_TYPE	VARCHAR2	16		True	Accounting period type.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier. Value is derived from a combination of organization identifier, accounting calendar name, accounting period type, ledger identifier.
LEDGER_NAME	VARCHAR2	128			Ledger name

DW_FISCAL_DAY_D

This table contains day-level information of fiscal calendars. Join can be done on one of these combinations (Fiscal Period Set Name - Fiscal Period Type - Fiscal Day Date Id, Fiscal Period Set Name - Fiscal Period Type - Fiscal Day Date, Fiscal Period Set Name - Fiscal Period Name - Fiscal Day Date Id, Fiscal Period Set Name - Fiscal Period Name - Fiscal Day Date)

Details

Module: Common

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_PERIOD_NAME, FISCAL_DAY_DATE_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
FISCAL_PERIOD_NAME	VARCHAR2	64		True	Accounting period name.
FISCAL_PERIOD_SET_NAME	VARCHAR2	16		True	Accounting calendar name. #1
FISCAL_PERIOD_TYPE	VARCHAR2	16		True	Accounting period type.
FISCAL_DAY_DATE_ID	NUMBER	38	0	True	Fiscal day in YYYYMMDD format.
SOURCE_RECORD_ID	VARCHAR2	64			Source record identifier. Value is derived from a combination of accounting calendar name, accounting period type, accounting period nameand fiscal day in YYYYMMDD format.
FISCAL_PERIOD_SORT_KEY	VARCHAR2	256			Enables sorting by fiscal calendar and fiscal period.
FISCAL_DAY_DATE	DATE				Date of the fiscal day.
FISCAL_DAY_CODE	VARCHAR2	64			Name of the fiscal day. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=DAYS_OF_WEEK.
ADJUSTMENT_PERIOD_FLAG	VARCHAR2	16			Indicates an adjustment period for the fiscal year.
FISCAL_PERIOD_NUMBER	NUMBER	38	0		Accounting period number.
FISCAL_PERIOD_START_DATE	DATE				Start date of the fiscal period.
FISCAL_PERIOD_START_DATE_ID	NUMBER	38	0		First day of fiscal day in YYYYMMDD format.
FISCAL_PERIOD_END_DATE	DATE				End date of the fiscal period.
FISCAL_PERIOD_END_DATE_ID	NUMBER	38	0		Last day of fiscal period in YYYYMMDD format.
FISCAL_QUARTER_NUMBER	NUMBER	38	0		Fiscal quarter. Possible values are 1, 2, 3, and 4.
FISCAL_QUARTER_CODE	VARCHAR2	16			Fiscal quarter . For example, 1999Q2.
FISCAL_QUARTER_START_DATE	DATE				Start date of the fiscal quarter.
FISCAL_QUARTER_START_DATE_ID	NUMBER	38	0		First day of fiscal quarter in YYYYMMDD format.
FISCAL_QUARTER_END_DATE	DATE				End date of the fiscal quarter.
FISCAL_QUARTER_END_DATE_ID	NUMBER	38	0		Last day of fiscal quarter in YYYYMMDD format.
FISCAL_HALF_NUMBER	NUMBER	38	0		Fiscal half year. Possible values are 1 and 2.
FISCAL_YEAR_NUMBER	NUMBER	38	0		Fiscal Year in YYYY format.
FISCAL_YEAR_START_DATE	DATE				Start date of the fiscal year.
FISCAL_YEAR_START_DATE_ID	NUMBER	38	0		First day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_END_DATE	DATE				End date of the fiscal year.
FISCAL_YEAR_END_DATE_ID	NUMBER	38	0		Last day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_TOTAL_WEEKS	NUMBER	38	0		Number of weeks in this fiscal year.
FISCAL_YEAR_TOTAL_DAYS	NUMBER	38	0		Number of days in this fiscal year.
FISCAL_DAY_OF_YEAR	NUMBER	38	0		Day number in the fiscal year.
FISCAL_DAY_OF_QUARTER	NUMBER	38	0		Day number in the fiscal quarter.
FISCAL_DAY_OF_PERIOD	NUMBER	38	0		Day number in the fiscal period.
FIRST_DAY_FISCAL_PERIOD_FLAG	VARCHAR2	16			Indicates that this day is the first day of fiscal period.
FIRST_DAY_FISCAL_QUARTER_FLAG	VARCHAR2	16			Indicates that this day is the first day of fiscal quarter.
FIRST_DAY_FISCAL_YEAR_FLAG	VARCHAR2	16			Indicates that this day is the first day of fiscal year.
LAST_DAY_FISCAL_PERIOD_FLAG	VARCHAR2	16			Indicates that this day is the last day of fiscal period.
LAST_DAY_FISCAL_QUARTER_FLAG	VARCHAR2	16			Indicates that this day is the last day of fiscal quarter.
LAST_DAY_FISCAL_YEAR_FLAG	VARCHAR2	16			Indicates that this day is the last day of fiscal year.
FISCAL_WEEK_NUMBER	NUMBER	38	0		Week number in the fiscal year. Possible values are 1, 2, and so on.
FISCAL_WEEK_START_DATE	DATE				Start date of the fiscal week.
FISCAL_WEEK_START_DATE_ID	NUMBER	38	0		First day of fiscal week in YYYYMMDD format.
FISCAL_WEEK_END_DATE	DATE				End date of the fiscal week.
FISCAL_WEEK_END_DATE_ID	NUMBER	38	0		Last day of fiscal week in YYYYMMDD format.
FIRST_DAY_FISCAL_WEEK_FLAG	VARCHAR2	16			Indicates that this day is the first day of fiscal week.
LAST_DAY_FISCAL_WEEK_FLAG	VARCHAR2	16			Indicates that this day is the last day of fiscal week.
FISCAL_DAY_OF_WEEK	NUMBER	38	0		Day number in the fiscal week.
CURRENT_FISCAL_DAY_CODE	VARCHAR2	16			Indicates the current fiscal day. Possible value is Current.
CURRENT_FISCAL_WEEK_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal week. Possible value is Current.
CURRENT_FISCAL_PERIOD_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal period. Possible value is Current.
CURRENT_FISCAL_QUARTER_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal quarter. Possible value is Current.
CURRENT_FISCAL_YEAR_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal year. Possible value is Current.
FISCAL_TRAILING_PERIOD_NUMBER	NUMBER	38	0		Indicates the trailing fiscal period number
FISCAL_TRAILING_QUARTER_NUMBER	NUMBER	38	0		Indicates the trailing fiscal quarter number
FISCAL_TRAILING_YEAR_NUMBER	NUMBER	38	0		Indicates the trailing fiscal year number

Notes

#1: DW_FISCAL_DAY_D can be joined to DW_FISCAL_PERIOD_D using FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_NAME

DW_FISCAL_DAY_D can be joined to DW_FISCAL_QUARTER_D using FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER, FISCAL_QUARTER_NUMBER

DW_FISCAL_DAY_D can be joined to DW_FISCAL_YEAR_D using FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER

DW_FISCAL_PERIOD_D

This table contains period-level information of fiscal calendars.

Details

Module: Common

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_NAME

Columns

Name	Datatype	Length	Precision	Not Null	Comments
FISCAL_PERIOD_SET_NAME	VARCHAR2	16		True	Accounting calendar name.
FISCAL_PERIOD_NAME	VARCHAR2	256		True	Accounting period name.
SOURCE_RECORD_ID	VARCHAR2	256			Source record identifier. Value is derived from a combination of accounting calendar name and accounting period name.
FISCAL_PERIOD_SORT_KEY	VARCHAR2	256			Enables sorting by fiscal calendar and fiscal period.
FISCAL_PERIOD_TYPE	VARCHAR2	16			Accounting period type.
ADJUSTMENT_PERIOD_FLAG	VARCHAR2	16			Indicates an adjustment period for the fiscal year.
FISCAL_PERIOD_NUMBER	NUMBER	38	0		Accounting period number.
FISCAL_PERIOD_START_DATE	DATE				Start date of the fiscal period.
FISCAL_PERIOD_START_DATE_ID	NUMBER	38	0		First day of fiscal day in YYYYMMDD format.
FISCAL_PERIOD_END_DATE	DATE				End date of the fiscal period.
FISCAL_PERIOD_END_DATE_ID	NUMBER	38	0		Last day of fiscal period in YYYYMMDD format.
FISCAL_YEAR_NUMBER	NUMBER	38	0		Fiscal Year in YYYY format.
FISCAL_QUARTER_NUMBER	NUMBER	38	0		Fiscal quarter. Possible values are 1, 2, 3, and 4.
FISCAL_QUARTER_CODE	VARCHAR2	16			Fiscal quarter period. For example, 1999Q2.
FISCAL_HALF_NUMBER	NUMBER	38	0		Fiscal half. Possible values are 1 and 2.
FISCAL_PERIOD_TOTAL_WEEKS	NUMBER	38	0		Number of weeks in the fiscal period.
FISCAL_PERIOD_TOTAL_DAYS	NUMBER	38	0		Number of days in the fiscal period.
FISCAL_YEAR_TOTAL_WEEKS	NUMBER	38	0		Number of weeks in this fiscal year.
FISCAL_YEAR_TOTAL_DAYS	NUMBER	38	0		Number of days in this fiscal year.
FISCAL_QUARTER_START_DATE	DATE				Start date of the fiscal quarter.
FISCAL_QUARTER_START_DATE_ID	NUMBER	38	0		First day of fiscal quarter in YYYYMMDD format.
FISCAL_QUARTER_END_DATE	DATE				End date of the fiscal quarter.
FISCAL_QUARTER_END_DATE_ID	NUMBER	38	0		Last day of fiscal quarter in YYYYMMDD format.
FISCAL_YEAR_START_DATE	DATE				Start date of the fiscal year.
FISCAL_YEAR_START_DATE_ID	NUMBER	38	0		First day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_END_DATE	DATE				End date of the fiscal year.
FISCAL_YEAR_END_DATE_ID	NUMBER	38	0		Last day of fiscal year in YYYYMMDD format.
FIRST_PERIOD_FISCAL_QTR_FLAG	VARCHAR2	16			Indicates the first fiscal period of the fiscal quarter.
LAST_PERIOD_FISCAL_QTR_FLAG	VARCHAR2	16			Indicates the last fiscal period of the fiscal quarter.
FIRST_PERIOD_FISCAL_YEAR_FLAG	VARCHAR2	16			Indicates the first fiscal period of the fiscal year.
LAST_PERIOD_FISCAL_YEAR_FLAG	VARCHAR2	16			Indicates the last fiscal period of the fiscal year.
CURRENT_FISCAL_PERIOD_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal period. Possible value is Current.
CURRENT_FISCAL_QUARTER_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal quarter. Possible value is Current.
CURRENT_FISCAL_YEAR_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal year. Possible value is Current.
PERIOD_END_OR_PRV_CRNT_DATE	DATE				For current fiscal period, day before current date else fiscal period end date
QUARTER_END_OR_PRV_CRNT_DATE	DATE				For current fiscal quarter, day before current date else fiscal quarter end date
YEAR_END_OR_PRV_CRNT_DATE	DATE				For current fiscal year, day before current date else fiscal year end date
FISCAL_TRAILING_PERIOD_NUMBER	NUMBER	38	0		Indicates the trailing fiscal period number
FISCAL_TRAILING_QUARTER_NUMBER	NUMBER	38	0		Indicates the trailing fiscal quarter number
FISCAL_TRAILING_YEAR_NUMBER	NUMBER	38	0		Indicates the trailing fiscal year number

DW_FISCAL_QUARTER_D

This table contains quarter-level information of fiscal calendars.

Details

Module: Common

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_QUARTER_NUMBER, FISCAL_YEAR_NUMBER

Columns

Name	Datatype	Length	Precision	Not Null	Comments
FISCAL_PERIOD_SET_NAME	VARCHAR2	16		True	Accounting calendar name.
FISCAL_PERIOD_TYPE	VARCHAR2	16		True	Accounting period type.
FISCAL_YEAR_NUMBER	NUMBER	38	0	True	Fiscal Year in YYYY format.
FISCAL_QUARTER_NUMBER	NUMBER	38	0	True	Fiscal quarter. Possible values are 1, 2, 3, and 4.
SOURCE_RECORD_ID	VARCHAR2	64			Source record identifier. Value is derived from a combination of accounting calendar name, accounting period type, fiscal year in YYYY format, and fiscal quarter.
FISCAL_HALF_NUMBER	NUMBER	38	0		Fiscal half. Possible values are 1 and 2.
FISCAL_QUARTER_CODE	VARCHAR2	16			Fiscal quarter period. For example, 1999Q2.
FISCAL_QUARTER_START_DATE	DATE				Start date of the fiscal quarter.
FISCAL_QUARTER_START_DATE_ID	NUMBER	38	0		First day of fiscal quarter in YYYYMMDD format.
FISCAL_QUARTER_END_DATE	DATE				End date of the fiscal quarter.
FISCAL_QUARTER_END_DATE_ID	NUMBER	38	0		Last day of fiscal quarter in YYYYMMDD format.
FISCAL_YEAR_START_DATE	DATE				Start date of the fiscal year.
FISCAL_YEAR_START_DATE_ID	NUMBER	38	0		First day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_END_DATE	DATE				End date of the fiscal year.
FISCAL_YEAR_END_DATE_ID	NUMBER	38	0		Last day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_TOTAL_WEEKS	NUMBER	38	0		Number of weeks in this fiscal year.
FISCAL_YEAR_TOTAL_DAYS	NUMBER	38	0		Number of days in this fiscal year.
FIRST_QUARTER_FISCAL_YEAR_FLG	VARCHAR2	16			Indicates that this quarter is the first quarter of fiscal year.
LAST_QUARTER_FISCAL_YEAR_FLAG	VARCHAR2	16			Indicates that this quarter is the last quarter of fiscal year.
CURRENT_FISCAL_QUARTER_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal quarter. Possible value is Current.
CURRENT_FISCAL_YEAR_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal year. Possible value is Current.
FISCAL_TRAILING_QUARTER_NUMBER	NUMBER	38	0		Indicates the trailing fiscal quarter number
FISCAL_TRAILING_YEAR_NUMBER	NUMBER	38	0		Indicates the trailing fiscal year number
QUARTER_END_OR_PRV_CRNT_DATE	DATE				For current fiscal quarter, day before current date else fiscal quarter end date

DW_FISCAL_YEAR_D

This table contains year-level information of fiscal calendars.

Details

Module: Common

Key Columns

FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER

Columns

Name	Datatype	Length	Precision	Not Null	Comments
FISCAL_PERIOD_SET_NAME	VARCHAR2	16		True	Accounting calendar name.
FISCAL_PERIOD_TYPE	VARCHAR2	16		True	Accounting period type.
FISCAL_YEAR_NUMBER	NUMBER	38	0	True	Fiscal Year in YYYY format.
SOURCE_RECORD_ID	VARCHAR2	64			Source record identifier of a fiscal year.
FISCAL_YEAR_START_DATE	DATE				Start date of the fiscal year.
FISCAL_YEAR_START_DATE_ID	NUMBER	38	0		First day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_END_DATE	DATE				End date of the fiscal year.
FISCAL_YEAR_END_DATE_ID	NUMBER	38	0		Last day of fiscal year in YYYYMMDD format.
FISCAL_YEAR_TOTAL_WEEKS	NUMBER	38	0		Number of weeks in this fiscal year.
FISCAL_YEAR_TOTAL_DAYS	NUMBER	38	0		Number of days in this fiscal year.
CURRENT_FISCAL_YEAR_CODE	VARCHAR2	16			Indicates that this day belongs to current fiscal year. Possible value is Current.
FISCAL_TRAILING_YEAR_NUMBER	NUMBER	38	0		Indicates the trailing fiscal year number
YEAR_END_OR_PRV_CRNT_DATE	DATE				For current fiscal year, day before current date else fiscal year end date

DW_FLEX_BI_OBJECT_LBL_LKP_TL

This table contains information about flexfield BI objects and their names.

Details

Module: Common

Key Columns

KEY_FLEXFIELD_CODE, LANGUAGE, APPLICATION_ID, SEGMENT_LABEL_CODE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
APPLICATION_ID	NUMBER	38	0	True	Application identifier.
KEY_FLEXFIELD_CODE	VARCHAR2	16		True	Key flexfield code.
SEGMENT_LABEL_CODE	VARCHAR2	32		True	Segment label code of the BI object.
LANGUAGE	VARCHAR2	16		True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier.
BI_OBJECT_NAME	VARCHAR2	256			Fixed name of the BI object.
SEGMENT_LABEL_NAME	VARCHAR2	64			Implementation specific name of the BI object.
SEGMENT_LABEL_DESCRIPTION	VARCHAR2	256			Implementation specific description of the BI object.

DW_FLEX_BI_OBJECT_VAL_SET_H

This table contains information about the BI objects and the associated value sets.

Details

Module: Common

Key Columns

CHART_OF_ACCOUNTS_ID, APPLICATION_ID, VALUESET_CODE, KEY_FLEXFIELD_CODE, BI_OBJECT_NAME

Columns

Name	Datatype	Length	Precision	Not Null	Comments
APPLICATION_ID	NUMBER	38	0	True	Application identifier.
KEY_FLEXFIELD_CODE	VARCHAR2	16		True	Key flexfield code.
CHART_OF_ACCOUNTS_ID	NUMBER	38	0	True	Chart of account identifier.
BI_OBJECT_NAME	VARCHAR2	256		True	Fixed name of the BI object.
VALUESET_CODE	VARCHAR2	64		True	Value set for the BI object.
SOURCE_RECORD_ID	VARCHAR2	512			Source record identifier.

DW_GL_BATCH_APP_STATUS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

GL_BATCH_APP_STATUS_LKP_CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
GL_BATCH_APP_STATUS_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

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
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_REV_STAT_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, GL_JOURNAL_REV_STAT_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
GL_JOURNAL_REV_STAT_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_GL_JOURNAL_STATUS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, GL_JOURNAL_STATUS_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
GL_JOURNAL_STATUS_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_GL_LEDGER_RELATIONSHIPS_D

This table contains the relationships between ledgers. Each relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency is stored in one or more rows in this table.

Details

Module: Common

Key Columns

RELATIONSHIP_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
RELATIONSHIP_ID	NUMBER	38	0	True	Ledger relationship identifier.
SOURCE_RECORD_ID	VARCHAR2	64			Source record identifier.
SOURCE_LEDGER_ID	NUMBER	38	0		Ledger identifier where reporting currency conversions are based from transactions, journals, or balances.
TARGET_LEDGER_ID	VARCHAR2	16			Destination ledger identifier for conversion of transactions, journals, or balances.
SOURCE_CURRENCY_CODE	VARCHAR	16			Source ledger currency code
SOURCE_LEDGER_NAME	VARCHAR	32			Source ledger name
SOURCE_LEDGER_SHORT_NAME	VARCHAR	32			Source ledger short name
SOURCE_LEDGER_CATEGORY_CODE	VARCHAR	32			Source ledger category code
TARGET_CURRENCY_CODE	VARCHAR	16			Target ledger functional currency.
TARGET_LEDGER_NAME	VARCHAR	32			User entered target ledger name.
TARGET_LEDGER_SHORT_NAME	VARCHAR	32			User entered target ledger short name.
TARGET_LEDGER_CATEGORY_CODE	VARCHAR	32			Target ledger category code. Valid values are PRIMARY, SECONDARY and ALC.
RELATIONSHIP_TYPE_CODE	VARCHAR	32			Relationship level between source and target ledger.
RELATIONSHIP_ENABLED_FLAG	VARCHAR	16			Whether or not ledger relationship is enabled.
GL_RELATIONSHIP_STATUS_CODE	VARCHAR	32			Ledger relationship status code.
SOURCE_CHART_OF_ACCOUNTS_ID	NUMBER	38	0		Source ledger chart of accounts identifier
TARGET_CHART_OF_ACCOUNTS_ID	NUMBER	38	0		Target ledger chart of accounts identifier
PRIMARY_LEDGER_ID	NUMBER	38	0		Ledger identifier of the primary ledger as defined in the accounting configuration.
APPLICATION_ID	NUMBER	38	0		Application defining column (backward compatible only).
ORG_ID	NUMBER	38	0		Indicates the identifier of the business unit associated to the row.

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	Not Null	Comments
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_D_TL

This table contains translated information about accounting segments.

Details

Module: General Ledger

Key Columns

LANGUAGE, GL_SEGMENT_VALUESET_CODE, GL_SEGMENT_CODE

Columns

Name	Datatype	Length	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_SEGMENT_DH

GL Segment Hierarchy dimension

Details

Module: General Ledger

Key Columns

HIERARCHY_VERSION_ID, GL_SEGMENT, HIERARCHY_VALUESET_CODE, HIERARCHY_TREE_CODE

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_TRANSFER_STATUS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

GL_TRANSFER_STATUS_LKP_CODE, LANGUAGE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
GL_TRANSFER_STATUS_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_GROUP_ACC_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

GROUP_ACC_LKP_CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
GROUP_ACC_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_INDUSTRY_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

INDUSTRY_LKP_CODE, LANGUAGE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
INDUSTRY_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_INSERT_ACCTG_METHD_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, INSERT_ACCTG_METHD_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
INSERT_ACCTG_METHD_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_INSERT_COUNTRY_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, INSERT_COUNTRY_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
INSERT_COUNTRY_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_INSERT_LEDGER_CAT_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

INSERT_LEDGER_CAT_LKP_CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
INSERT_LEDGER_CAT_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_INTERNAL_ORG_CLASS_D

This table stores the Organizations classifications and related information.

Details

Module: Common

Key Columns

CLASSIFICATION_CODE, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
ORGANIZATION_ID	NUMBER	38	0	True	Organization Identifier, Translation in DW_INTERNAL_ORG_D_TL table.
CLASSIFICATION_CODE	VARCHAR2	64		True	Seeded classifications code for organizations.
SOURCE_RECORD_ID	VARCHAR2	128			Uniquely identifies Organization Identifier and its Classification
EFFECTIVE_START_DATE	DATE				Classification effective start date
EFFECTIVE_END_DATE	DATE				Classification effective end date
STATUS_CODE	VARCHAR2	32			Indicates if an organization is active or inactive. For translation, refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE'
SET_ID	NUMBER	38	0		Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
LEGISLATION_CODE	VARCHAR2	32			Legislation code derived from Legal Entity, Translation in DW_LEGISLATION_D_TL table.

DW_INTERNAL_ORG_D

This table contains information about organizations and business units.

Details

Module: Common

Key Columns

ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
ORGANIZATION_ID	NUMBER	38	0	True	Business unit or organization identifier. Value is derived from the table DW_INTERNAL_ORG_D_TL.
SOURCE_RECORD_ID	NUMBER	38	0		Source record identifier of the usiness unit or organization.
EFFECTIVE_START_DATE	DATE				Organization effective start date, date range within which the row is effective.
EFFECTIVE_END_DATE	DATE				Organization effective end date, date range within which the row is effective.
ORGANIZATION_MANAGER_NAME	VARCHAR2	2048			Organization manager name.
ORG_MANAGER_PERSON_NUMBER	VARCHAR2	32			Organization manager person number.
ORG_LEGAL_ENTITY_ID	NUMBER	38	0		Organization legal entity identifier.
BUSINESS_UNIT_MANAGER_NAME	VARCHAR2	2048			Business unit manager name.
ORGANIZATION_LOCATION_ID	NUMBER	38	0		Organization location identifier.
CURRENCY_CODE	VARCHAR2	256			Business unit default currency code.
LEGAL_ENTITY_ID	NUMBER	38	0		Business unit legal entity identifier.
BUSINESS_UNIT_DATE_TO	DATE				Business unit end date.
BUSINESS_UNIT_START_FROM	DATE				Business unit start date.
ORGANIZATION_STATUS_CODE	VARCHAR2	32			Business unit status.
ORGANIZATION_CODE	VARCHAR2	32			Organization code.
ORGANIZATION_TYPE	VARCHAR2	32			Organization type. This is a user defined type for differentiating between organizations. For example you many want to differentiate between different kinds of Departments, say as Health and Safety , Service Departments, Training.
PRIMARY_LEDGER_ID	NUMBER	38	0		Business unit primary ledger identifier.
PRIMARY_LEDGER	VARCHAR2	32			Business unit primary ledger name.
SET_ID	NUMBER	38	0		Business unit set identifier.
PHONE_NUMBER	VARCHAR2	256			Organization location phone number.
FAX_NUMBER	VARCHAR2	256			Organization location fax number.
EMAIL_ADDRESS	VARCHAR2	256			Organization location email.
ADDRESS_LINE_1	VARCHAR2	256			Organization location address line 1.
ADDRESS_LINE_2	VARCHAR2	256			Organization location address line 2.
CITY_CODE	VARCHAR2	128			Organization location city or town.
POSTAL_CODE	VARCHAR2	32			Organization location postal code.
COUNTY_CODE	VARCHAR2	128			Organization location county.
STATE_PROV_CODE	VARCHAR2	128			Organization location state or province.
COUNTRY_CODE	VARCHAR2	64			Organization location country.
INV_LEGAL_ENTITY_ID	NUMBER	38	0		Inventory organization legal entity identifier
INV_BUSINESS_UNIT_ID	NUMBER	38	0		Inventory organization business unit identifier
INV_SUPPLIER_ID	NUMBER	38	0		Inventory organization supplier identifier
INV_SUPPLIER_SITE_ID	NUMBER	38	0		Inventory organization supplier site identifier
INV_MASTER_ORGANIZATION_ID	NUMBER	38	0		Inventory organization master organization identifier
BUSINESS_UNIT_FLAG	VARCHAR2	16			Indicates whether organization is a business unit.
BILLING_REVENUE_MNG_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs billing and revenue management business function.
COLLECTIONS_MNGMNT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs collections management business function.
CUST_CONTRACT_MNGMNT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs customer contract management business function.
CUSTOMER_PAYMENTS_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs customer payments business function.
EXPENSE_MNGMNT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs expense management business function.
FINANCIAL_BU_FLAG	VARCHAR2	16			Indicates a financial BU. Includes business units that perform collections management, customer payments, expense management, payables invoicing, payables payment, or billing and revenue management business function.
MATERIALS_MNGMNT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs materials management business function.
PAYABLES_INVOICING_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs payables invoicing business function.
PAYABLES_PAYMENT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs payables payment business function.
PRC_CONTRACT_MNGMNT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs procurement contract management business function.
PROCUREMENT_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs procurement business function.
PROJECT_ACCOUNTING_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs project accounting business function.
RECEIVING_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs receiving business function.
REQUISITION_BU_FLAG	VARCHAR2	16			Indicates whether business unit performs requisitioning business function.
COST_ORGANIZATION_FLAG	VARCHAR2	16			Indicates a cost organization.
DEPARTMENT_FLAG	VARCHAR2	16			Indicates a department or human resource organization.
ENTERPRISE_FLAG	VARCHAR2	16			Indicates an enterprise.
EXPENDITURE_ORGANIZATION_FLAG	VARCHAR2	16			Indicates an expenditure organization.
INTERNAL_FLAG	VARCHAR2	16			Indicates an internal organization.
INV_ORGANIZATION_FLAG	VARCHAR2	16			Indicates an inventory organization.
PAYROLL_STATUTORY_UNIT_FLAG	VARCHAR2	16			Indicates a payroll statutory unit.
PROJECT_ORGANIZATION_FLAG	VARCHAR2	16			Indicates a project organization.
PROJECT_UNIT_FLAG	VARCHAR2	16			Indicates a project unit.
REPORTING_EST_FLAG	VARCHAR2	16			Indicates a reporting establishment.
SALES_GROUP_FLAG	VARCHAR2	16			Indicates a marketing resource, sales resource, partner resource, or resource organization.
LEGAL_EMPLOYER_FLAG	VARCHAR2	16			Indicates a legal employer.
DISABILITY_ORGANIZATION_FLG	VARCHAR2	16			Indicates a disability organization.
INV_INVENTORY_FLAG	VARCHAR2	16			Indicates the usge of Organization.	DW_INV_ORG_USAGE_LKP_TL	INV_ORG_USAGE_CODE
TAX_REPORTING_UNIT_FLAG	VARCHAR2	16			Indicates whether organization is a tax reporting unit organization.

DW_INTERNAL_ORG_D_TL

This table contains information about the translated names for organizations and business units.

Details

Module: Common

Key Columns

LANGUAGE, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
ORGANIZATION_ID	NUMBER	38	0	True	Business unit or organization identifier.
LANGUAGE	VARCHAR2	16		True	Language code.
SOURCE_RECORD_ID	NUMBER	38	0		Source record identifier. Value is derived from BU or organization identifier.
ORGANIZATION_NAME	VARCHAR2	256			Business unit or organization name.

DW_INV_ORGANIZATION_D

This table stores the inventory organization information.

Details

Module: Common

Key Columns

INV_ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
INV_ORGANIZATION_ID	NUMBER	38	0	True	Inventroy organization Id, Translation in DW_INTERNAL_ORG_D_TL table.
SOURCE_RECORD_ID	NUMBER	38	0		Uniquely identifies a inventroy organization.
INV_ORGANIZATION_CODE	VARCHAR2	32			Organization code.
INV_LEGAL_ENTITY_ID	NUMBER	38	0		Inventory organization legal entity identifier
INV_BUSINESS_UNIT_ID	NUMBER	38	0		Inventory organization business unit identifier
INV_SUPPLIER_ID	NUMBER	38	0		Inventory organization supplier identifier
INV_SUPPLIER_SITE_ID	NUMBER	38	0		Inventory organization supplier site identifier
INV_MASTER_ORGANIZATION_ID	NUMBER	38	0		Inventory organization master organization identifier
LOCATION_ID	NUMBER	38	0		Inventory organization location identifier.
PHONE_NUMBER	VARCHAR2	256			Inventory organization location phone number.
FAX_NUMBER	VARCHAR2	256			Inventory organization location fax number.
EMAIL_ADDRESS	VARCHAR2	256			Inventory organization location email.
ADDRESS_LINE_1	VARCHAR2	256			Inventory organization location address line 1.
ADDRESS_LINE_2	VARCHAR2	256			Inventory organization location address line 2.
CITY_CODE	VARCHAR2	128			Inventory organization location city or town.
POSTAL_CODE	VARCHAR2	32			Inventory organization location postal code.
COUNTY_CODE	VARCHAR2	128			Inventory organization location county.
STATE_PROV_CODE	VARCHAR2	128			Inventory organization location state or province.
COUNTRY_CODE	VARCHAR2	64			Inventory organization location country.
STATUS_CODE	VARCHAR2	32			Indicates if an organization is active or inactive.	DW_ACTIVE_INACTIVE_LKP_TL	ACTIVE_INACTIVE_LKP_CODE
INV_INVENTORY_FLAG	VARCHAR2	16			Indicates the usge of Organization.	DW_INV_ORG_USAGE_LKP_TL	INV_ORG_USAGE_CODE

DW_INV_ORGANIZATION_D_TL

This table contains information about the translated names for inventory organization.

Details

Module: Common

Key Columns

LANGUAGE, INV_ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
INV_ORGANIZATION_ID	NUMBER	38	0	True	Inventroy organization identifier.
LANGUAGE	VARCHAR2	16		True	Language code.
SOURCE_RECORD_ID	NUMBER	38	0		Uniquely identifies a inventroy organization Language code is not included in this identifier.
INV_ORGANIZATION_NAME	VARCHAR2	256			This is the name of the inventroy organization.

DW_INVENTORY_ITEM_D

This table contains the details of the inventory item.

Details

Module: Common

Key Columns

INVENTORY_ITEM_ID, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
INVENTORY_ITEM_ID	NUMBER	38	0	True	Unique identifier for an item.
ORGANIZATION_ID	NUMBER	38	0	True	A organizing unit in the internal or external structure of your enterprise.
SOURCE_RECORD_ID	VARCHAR2	128			Source record id based on concatenation of INVENTORY_ITEM_ID and ORGANIZATION_ID
ITEM_NUMBER	VARCHAR2	512			Identifier of the Item.
BASE_ITEM_ID	NUMBER	38	0		Attribute indicating the Model from which an ATO configuration was created.
ITEM_TYPE	VARCHAR2	32			Indicator or classification for an item, such as finished or purchased.	DW_EGP_ITEM_TYPE_LKP_TL	EGP_ITEM_TYPE_CODE
SOURCE_SUBINVENTORY	VARCHAR2	16			Attribute indicating the sub inventory from which an internal requisition draws the item.
APPROVAL_STATUS	VARCHAR2	32			The Approval Status of the Item.	DW_EGP_APPROVAL_STATUS_LKP_TL	EGP_APPROVAL_STATUS_CODE
START_DATE_ACTIVE	TIMESTAMP				The date on which a task, event or business process begins.
END_DATE_ACTIVE	TIMESTAMP				Date on which Item is inactivated
FIXED_ORDER_QUANTITY	NUMBER				Attribute indicating the quantity used to modify the size of planned order quantities or repetitive daily rates
HAZARD_CLASS_ID	NUMBER	38	0		Attribute indicating the category of Hazard material for International trade.
ORDER_COST	NUMBER				Attribute indicating the fixed cost associated with placing an order for the item.
PRIMARY_UOM_CODE	VARCHAR2	16			The principal unit of measure in which the quantity of an item is managed.	DW_UNIT_OF_MEASURE_D_TL	UOM_CODE
SERIAL_NUMBER_CONTROL_CODE	NUMBER				Attribute indicating number assigned to each unit of an item and used to track the item.
VOLUME_UOM_CODE	VARCHAR2	16			Attribute indicating Volume Unit of Measure.	DW_UNIT_OF_MEASURE_D_TL	UOM_CODE
WEIGHT_UOM_CODE	VARCHAR2	16			Attribute indicating Weight Unit of Measure.	DW_UNIT_OF_MEASURE_D_TL	UOM_CODE
UNIT_VOLUME	NUMBER				Attribute Indicating Volume of One Unit of Item.
UNIT_WEIGHT	NUMBER				Attribute Indicating Weight of One Unit of Item.
PARENT_ITEM_CLASS_ID	NUMBER	38	0		Parent item class identifier.	DW_ITEM_CLASS_LKP_TL	ITEM_CLASS_LKP_CODE
ITEM_CLASS_ID	NUMBER	38	0		Item class identifier from which the attribute group is inherited.	DW_ITEM_CLASS_LKP_TL	ITEM_CLASS_LKP_CODE
MINIMUM_ORDER_QUANTITY	NUMBER				Attribute indicating Minimum Order quantity of the Item.
MAXIMUM_ORDER_QUANTITY	NUMBER				Attribute indicating Maximum Order quantity of the Item.
STD_LOT_SIZE	NUMBER				The amount of a particular item that is ordered from the plant or a supplier or issued as a standard quantity to the production process.
SHELF_LIFE_DAYS	NUMBER				Attribute indicating number of days each lot is active.
UNIT_OF_ISSUE	VARCHAR2	32			Attribute indicating Unit of measure used for issuing the item from inventory.
PLANNER_CODE	VARCHAR2	16			Attribute indicating the material planner for the item.
MRP_PLANNING_CODE	NUMBER				Attribute indicating the organization level planning for the Item. Choices -Min-Max,Not Planned, Reorder Point.	DW_EGP_PLANNING_CODE_LKP_TL	EGP_PLANNING_CODE
ENABLED_FLAG	VARCHAR2	16			Attribute indicating the item class is enabled for use.
CUSTOMER_ORDER_ENABLED_FLAG	VARCHAR2	16			Attribute indicating whether an item is currently customer orderable.
INVENTORY_ITEM_FLAG	VARCHAR2	16			Attribute indicating whether the Item can be Stocked and transacted.
PROCESS_QUALITY_ENABLED_FLAG	VARCHAR2	16			Attribute indicating whether to use the process manufacturing quality module with this item.
PURCHASING_ENABLED_FLAG	VARCHAR2	16			Attribute which determines whether the item can be added in to a purchase order.
RETURNABLE_FLAG	VARCHAR2	16			Attribute indicating whether to allow customers to return an item.
SERVICEABLE_PRODUCT_FLAG	VARCHAR2	16			Attribute indicating whether the item is eligible to be covered by a service contract.
INVOICEABLE_ITEM_FLAG	VARCHAR2	16			Attribute indicating whether to include an item on an Oracle Receivables invoice.
INVOICE_ENABLED_FLAG	VARCHAR2	16			Attribute indicating whether to activate an item for invoicing in Oracle Receivables.
PLANNING_TIME_FENCE_DAYS	NUMBER				Attribute indicating the optional day added to the planning time fence when planning time fence is User defined.
FULL_LEAD_TIME	NUMBER				Attribute indicating the days required to procure or manufacture an item.
CUM_MANUFACTURING_LEAD_TIME	NUMBER				Attribute indicating the manufacturing lead time of an assembly (in days) plus the largest adjusted cumulative manufacturing lead time of its components, where each is adjusted by subtracting the operation lead time offset.
FIXED_LEAD_TIME	NUMBER				Attribute indicating the days required to make an assembly independent of order quantity, such as setup or tear down time.
VARIABLE_LEAD_TIME	NUMBER				Attribute indicating time to produce one additional unit of an assembly.
CUMULATIVE_TOTAL_LEAD_TIME	NUMBER				Attribute indicating the total lead time of the assembly plus the largest adjusted cumulative total lead time of its components, where each is adjusted by subtracting the operation lead time offset.
POSTPROCESSING_LEAD_TIME	NUMBER				Attribute indicating the days required to receive a purchased item into inventory from the initial supplier receipt.
PREPROCESSING_LEAD_TIME	NUMBER				Attribute indicating the days which must be added to purchasing or manufacturing lead time to place an order.
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	16			Code used to control the transaction activity of an item.	DW_ITEM_STATUS_LKP_TL	ITEM_STATUS_LKP_CODE
CURRENT_PHASE_CODE	VARCHAR2	128			Each phase represents a set of tasks and deliverables that are required before promoting the object to the next phase of the Item Lifecycle. Possible values are Concept, Design, Prototype, Preproduction etc	DW_EGP_LIFECYCLE_PHASE_LKP_TL	EGP_LIFECYCLE_PHASE_CODE
PLANNING_MAKE_BUY_CODE	NUMBER				Attribute indicating whether the item is usually manufactured or bought.	DW_EGP_PLANNING_TYPE_LKP_TL	EGP_PLANNING_TYPE_CODE
MUST_USE_APPROVED_VENDOR_FLAG	VARCHAR2	16			Attribute indicating whether to use only approved suppliers. Possible values are Y,N.	DW_YN_LKP_TL	YN_LKP_CODE
MIN_MINMAX_QUANTITY	NUMBER				Attribute indicating the minimum qty for Min-Max Planning.
MAX_MINMAX_QUANTITY	NUMBER				Attribute indicating the maximum qty for Min-Max Planning.
BACK_TO_BACK_ENABLED	VARCHAR2	16			Indicates that an item is enabled for back-to-back ordering.
CURRENT_PHASE_START_DATE	DATE				Indicates the date when current phase of the item becomes active.
CURRENT_PHASE_TYPE	VARCHAR2	32			One of the four seeded Lifecycle Phases. It can be either of Design, Prototype or Preproduction, Production, and End of Life.	DW_EGP_LIFECYCLE_PHASE_LKP_TL	EGP_LIFECYCLE_PHASE_CODE

DW_INVENTORY_ITEM_D_TL

This table contains the translation details of the Inventory Items.

Details

Module: Common

Key Columns

LANGUAGE, INVENTORY_ITEM_ID, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
INVENTORY_ITEM_ID	NUMBER	38	0	True	Inventory Item Id
LANGUAGE	VARCHAR2	16		True	Language
ORGANIZATION_ID	NUMBER	38	0	True	Organization Id
SOURCE_RECORD_ID	VARCHAR2	256			Source record Id formed by concatenatinf INVENTORY_ITEM_ID,LANGUAGE and ORGANIZATION_ID
ITEM_DESCRIPTION	VARCHAR2	256			Item Description

DW_INV_ORG_USAGE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

INV_ORG_USAGE_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
INV_ORG_USAGE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ITEM_CAT_ASSIGNMENTS_D

This table contains information of items assigned to a Catalog and its category.

Details

Module: Common

Key Columns

CATEGORY_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
CATEGORY_SET_ID	NUMBER	38	0	True	Identifier for category set, Category set is collection of items grouped into categories. Value is derived from the table DW_ITEM_CATEGORIES_D_TL.
CATEGORY_ID	NUMBER	38	0	True	Category identifier for category belonging to the Item Catalog. Value is derived from the table DW_ITEM_CATEGORY_SETS_D_TL.
INVENTORY_ITEM_ID	NUMBER	38	0	True	Unique identifier for an item. This represents the ItemId for which this assignment is created.	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
ORGANIZATION_ID	NUMBER	38	0	True	A organizing unit in the internal or external structure of your enterprise.	DW_INVENTORY_ITEM_D	ORGANIZATION_ID
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier formed by item identifier, organization identifier, category set identifier and category identifier.

DW_ITEM_CATEGORIES_D

This table contains item categories information.

Details

Module: Common

Key Columns

CATEGORY_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
CATEGORY_ID	NUMBER	38	0	True	CATEGORY_ID
SOURCE_RECORD_ID	NUMBER	38	0		Source record identifier.
CATEGORY_CODE	VARCHAR2	1024			CATEGORY_CODE
START_DATE_ACTIVE	DATE				START_DATE_ACTIVE
END_DATE_ACTIVE	DATE				END_DATE_ACTIVE

DW_ITEM_CATEGORIES_D_TL

This table contains information about the translated names for item categories.

Details

Module: Common

Key Columns

CATEGORY_ID, LANGUAGE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
CATEGORY_ID	NUMBER	38	0	True	Category identifier.
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	NUMBER	38	0		Source record Id formed by category identifier.
CATEGORY_NAME	VARCHAR2	256			Translatable name of the category.
DESCRIPTION	VARCHAR2	256			Translatable description of the category.

DW_ITEM_CATEGORIES_DH

This table holds the information about Item category Hierarchy.

Details

Module: Common

Key Columns

CATEGORY_ID, CATEGORY_SET_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
CATEGORY_SET_ID	NUMBER	38	0	True	Collection of items grouped into categories.	DW_ITEM_CATEGORY_SETS_D	CATEGORY_SET_ID
CATEGORY_ID	NUMBER	38	0	True	Category belonging to the Item Catalog.	DW_ITEM_CATEGORIES_D	CATEGORY_ID
SOURCE_RECORD_ID	VARCHAR2	64			Unique Identifier
CATALOG_CODE	VARCHAR2	32			Unique indentifier of the catalogs.
CATEGORY_CODE	VARCHAR2	1024			A unique identification assigned to an item class which can be easily associated with the UNSPC category.
LVL	NUMBER				Level
PATH	VARCHAR2	4000			Path
PARENT_CATEGORY_ID1	VARCHAR2	4000			Parent Category ID1	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE1	VARCHAR2	1024			Parent Category Code1
PARENT_CATEGORY_ID2	VARCHAR2	4000			Parent Category ID2	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE2	VARCHAR2	1024			Parent Category Code2
PARENT_CATEGORY_ID3	VARCHAR2	4000			Parent Category ID3	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE3	VARCHAR2	1024			Parent Category Code3
PARENT_CATEGORY_ID4	VARCHAR2	4000			Parent Category ID4	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE4	VARCHAR2	1024			Parent Category Code4
PARENT_CATEGORY_ID5	VARCHAR2	4000			Parent Category ID5	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE5	VARCHAR2	1024			Parent Category Code5
PARENT_CATEGORY_ID6	VARCHAR2	4000			Parent Category ID6	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE6	VARCHAR2	1024			Parent Category Code6
PARENT_CATEGORY_ID7	VARCHAR2	4000			Parent Category ID7	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE7	VARCHAR2	1024			Parent Category Code7
PARENT_CATEGORY_ID8	VARCHAR2	4000			Parent Category ID8	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE8	VARCHAR2	1024			Parent Category Code8
PARENT_CATEGORY_ID9	VARCHAR2	4000			Parent Category ID9	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE9	VARCHAR2	1024			Parent Category Code9
PARENT_CATEGORY_ID10	VARCHAR2	4000			Parent Category ID10	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE10	VARCHAR2	1024			Parent Category Code10
PARENT_CATEGORY_ID11	VARCHAR2	4000			Parent Category ID11	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE11	VARCHAR2	1024			Parent Category Code11
PARENT_CATEGORY_ID12	VARCHAR2	4000			Parent Category ID12	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE12	VARCHAR2	1024			Parent Category Code12
PARENT_CATEGORY_ID13	VARCHAR2	4000			Parent Category ID13	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE13	VARCHAR2	1024			Parent Category Code13
PARENT_CATEGORY_ID14	VARCHAR2	4000			Parent Category ID14	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE14	VARCHAR2	1024			Parent Category Code14
PARENT_CATEGORY_ID15	VARCHAR2	4000			Parent Category ID15	DW_ITEM_CATEGORIES_D	CATEGORY_ID
PARENT_CATEGORY_CODE15	VARCHAR2	1024			Parent Category Code15

DW_ITEM_CATEGORY_SETS_D

This table contains item category set information.

Details

Module: Common

Key Columns

CATEGORY_SET_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
CATEGORY_SET_ID	NUMBER	38	0	True	CATEGORY_SET_ID
SOURCE_RECORD_ID	NUMBER	38	0		Source record identifier.
CATALOG_CODE	VARCHAR2	32			CATALOG_CODE
MULT_ITEM_CAT_ASSIGN_FLAG	VARCHAR2	16			MULT_ITEM_CAT_ASSIGN_FLAG
CONTROL_LEVEL	NUMBER				CONTROL_LEVEL	DW_CATALOG_CONTROL_LVL_LKP_TL	CATALOG_CONTROL_LEVEL_CODE
DEFAULT_CATEGORY_CODE	VARCHAR2	1024			Category an item is assigned to when during new item creation
START_DATE	DATE				Date the catalog will become active
END_DATE	DATE				Date the catalog will become inactive

DW_ITEM_CATEGORY_SETS_D_TL

This table contains information about the translated names for item category sets.

Details

Module: Common

Key Columns

LANGUAGE, CATEGORY_SET_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
CATEGORY_SET_ID	NUMBER	38	0	True	Category set identifier, Category set represents collection of items grouped into categories.
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	NUMBER	38	0		Source record Id formed by category set identifier.
CATEGORY_SET_NAME	VARCHAR2	32			Translatable name of the category set.
DESCRIPTION	VARCHAR2	256			Translatable description of the category set.

DW_ITEM_CLASS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, ITEM_CLASS_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
ITEM_CLASS_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ITEM_PHASE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

ITEM_PHASE_LKP_CODE, LANGUAGE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
ITEM_PHASE_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ITEM_STATUS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, ITEM_STATUS_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
ITEM_STATUS_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_JOURNAL_CATEGORY_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, JOURNAL_CATEGORY_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
JOURNAL_CATEGORY_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_JOURNAL_SOURCE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, JOURNAL_SOURCE_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
JOURNAL_SOURCE_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_LEDGER_SET_ASSIGNMENTS_D

This table contains ledgers and ledger sets assignment mapping.

Details

Module: Common

Key Columns

LEDGER_SET_ID, LEDGER_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
LEDGER_SET_ID	NUMBER	38	0	True	Ledger set Identifier.	DW_LEDGER_SET_D	LEDGER_SET_ID
LEDGER_ID	NUMBER	38	0	True	Ledger identifier.	DW_LEDGER_D	LEDGER_ID
SOURCE_RECORD_ID	VARCHAR2	64			Source record identifier, Value is derived from ledger set identifier and ledger identifier.

DW_LEDGER_SET_D

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

Details

Module: Common

Key Columns

LEDGER_SET_ID

Columns

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

DW_LEGAL_ENTITY_D

This table contains information about legal entities.

Details

Module: Common

Key Columns

LEGAL_ENTITY_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
LEGAL_ENTITY_ID	NUMBER	38	0	True	Legal entity identifier.
SOURCE_RECORD_ID	NUMBER	38	0		Source record identifier for legal entity.
LEGAL_ENTITY_NAME	VARCHAR2	256			Legal entity name.
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	32			Unique number used to identify a legal entity; either manually set by the user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. This is only relevant for third party legal entity.
EFFECTIVE_FROM	DATE				Effective start date for legal entity.
EFFECTIVE_TO	DATE				Effective end date for legal entity.
PAYROLL_STATUTORY_UNIT_FLAG	VARCHAR2	16			Indicates a legal entity PSU.
TRANSACTING_ENTITY_FLAG	VARCHAR2	16			Indicates a transacting legal entity.
ADDRESS_ELEMENT_ATTRIBUTE1	VARCHAR2	256			Location address element attribute 1.
ADDRESS_ELEMENT_ATTRIBUTE2	VARCHAR2	256			Location address element attribute 2.
CITY	VARCHAR2	64			Legal entity location city.
POSTAL_CODE	VARCHAR2	64			Legal entity location postal code.
COUNTY	VARCHAR2	64			Legal entity location county.
STATE	VARCHAR2	64			Legal entity location state.
COUNTRY_CODE	VARCHAR2	16			Legal entity location country.
REGISTERED_NAME	VARCHAR2	256			Legal entity registration name.
REGISTRATION_NUMBER	VARCHAR2	32			Legal entity registration number.

DW_LEGAL_ENTITY_LEDGER_REL_D

This table contains information about relationship between ledger and legal entities.

Details

Module: Common

Key Columns

LEDGER_ID, LEGAL_ENTITY_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
LEGAL_ENTITY_ID	NUMBER	38	0	True	Legal entity identifier.
LEDGER_ID	NUMBER	38	0	True	Unique ledger identifier.
SOURCE_RECORD_ID	VARCHAR2	256			Source record identifier,combination of LEGAL_ENTITY_ID and LEDGER_ID
CHART_OF_ACCOUNTS_ID	NUMBER	38	0		Key flexfield structure identifier.
LEGAL_ENTITY_NAME	VARCHAR2	256			Legal entity name.
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	32			Unique number used to identify a legal entity; either manually set by the user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. This is only relevant for third party legal entity.
EFFECTIVE_FROM	DATE				Effective start date for legal entity.
EFFECTIVE_TO	DATE				Effective end date for legal entity.
PAYROLL_STATUTORY_UNIT_FLAG	VARCHAR2	16			Indicates a legal entity PSU.
TRANSACTING_ENTITY_FLAG	VARCHAR2	16			Indicates a transacting legal entity.
LEDGER_NAME	VARCHAR2	32			User entered unique ledger name.
LEDGER_SHORT_NAME	VARCHAR2	32			User entered unique ledger short name.
LEDGER_DESCRIPTION	VARCHAR2	256			Description of the ledger definition.
LEDGER_CATEGORY_CODE	VARCHAR2	32			Type of ledger. Valid values are PRIMARY, SECONDARY and ALC.
LEDGER_CURRENCY_CODE	VARCHAR2	16			Functional currency of the ledger.
LE_LAST_UPDATED_BY	VARCHAR2	128			indicates the user who last updated the row.
LE_LAST_UPDATE_LOGIN	VARCHAR2	64			indicates the session login associated to the user who last updated the row.
LE_LAST_UPDATE_DATE	TIMESTAMP				indicates the date and time of the last update of the row.
LE_CREATION_DATE	TIMESTAMP				indicates the date and time of the creation of the row.

DW_MATCH_BASIS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, MATCH_BASIS_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
MATCH_BASIS_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_MSC_PLAN_MAKE_BUY_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, MSC_PLAN_MAKE_BUY_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
MSC_PLAN_MAKE_BUY_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_NATURAL_ACCOUNT_D

This table contains natural account segment information.

Details

Module: General Ledger

Key Columns

NTRL_ACNT_SGMNT_VALUESET_CODE, NATURAL_ACCOUNT_SEGMENT

Columns

Name	Datatype	Length	Not Null	Comments
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_VERSION_ID, HIERARCHY_VALUESET_CODE, NATURAL_ACCOUNT_SEGMENT, HIERARCHY_TREE_CODE

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.

DW_OAX_VERSION

This table will contain a single record of the current version of OAX.

Details

Module: Common

Key Columns

RELEASE_VERSION

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
RELEASE_VERSION	VARCHAR2	32		True	Release Version
RELEASE_VERSION_SEQUENCE	NUMBER	38	0		Release Version Sequence Number

DW_ORGANIZATION_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, CODE_TYPE, ORGANIZATION_TYPE_LKP_CODE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
ORGANIZATION_TYPE_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_PARTY_SIC_CODE_TYPE_TL

Table to store the translations for SIC TYPE and SIC Code combinations.

Details

Module: Common

Key Columns

LANGUAGE, SIC_CODE, SIC_CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
SIC_CODE_TYPE	VARCHAR2	128	True	SIC Code Type
SIC_CODE	VARCHAR2	128	True	SIC Code
LANGUAGE	VARCHAR2	64	True	Translation language
SOURCE_RECORD_ID	VARCHAR2	512		Source Record Identifier It is a unique combination of CODE_TYPE, CODE
NAME	VARCHAR2	2048		Business name or value of the code
DESCRIPTION	VARCHAR2	4000		Description of the code

DW_PARTY_STATUS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

PARTY_STATUS_LKP_CODE, LANGUAGE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
PARTY_STATUS_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_PLACE_OF_SUPPLY_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_POR_ITEM_SOURCE_D_TL

Requisition Item source Translation

Details

Module: Purchasing

Key Columns

CODE, LANGUAGE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_PO_INV_MATCH_OPTION_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, PO_INV_MATCH_OPTION_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
PO_INV_MATCH_OPTION_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_PURCHASE_BASIS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, PURCHASE_BASIS_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
PURCHASE_BASIS_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_RCPT_CREATION_STATUS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, CODE_TYPE, RECEIPT_CREATION_STATUS_CODE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
RECEIPT_CREATION_STATUS_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_SCM_CODE_VALUES_LKP_TL

This table contains information about code, name, and description for the SCM related codes.

Details

Module: Common

Key Columns

CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_SUPPLIER_SITE_D

This table contains supplier site information.

Details

Module: Common

Key Columns

SUPPLIER_SITE_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
SUPPLIER_SITE_ID	NUMBER	38	0	True	Supplier site identifier.
SOURCE_RECORD_ID	NUMBER	38	0		Source Record Identifier for supplier site. It is used as the primary key.
ACTIVE_FLAG	VARCHAR2	16			Indicates an active supplier.
SUPPLIER_SITE_CODE	VARCHAR2	16			Supplier site code.
SUPPLIER_SITE_NUMBER	VARCHAR2	32			Supplier site number.
SUPPLIER_SITE_NAME	VARCHAR2	16			Supplier site name.
SUPPLIER_RECEIPT_TYPE_CODE	VARCHAR2	32			Supplier Receipt type, Identifies how to consolidate the receipts to create invoices. Possible values are PACKING_SLIP, RECEIPT, or PAY_SITE.
PAYMENT_TERMS_ID	NUMBER	38	0		Payment terms identifier.	DW_AP_TERMS_D	PAYMENT_TERMS_ID
PAYMENT_GROUP_CODE	VARCHAR2	32			Payment group type. Values are derived from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAY GROUP. Possible values are Priority, GPS, FOREIGN, Standard, or International.	DW_CODE_VALUES_LKP_TL	CODE
ADDRESS1	VARCHAR2	256			Address Line 1.
ADDRESS2	VARCHAR2	256			Address Line 2.
CITY	VARCHAR2	64			Supplier location city. Possible value are Cleveland, New York, New Jersey, and so on.
COUNTY	VARCHAR2	64			Supplier location county. Possible values are Lorrain, New York, Middlesex, and so on.
POSTAL_CODE	VARCHAR2	64			Supplier location postal code. Possible values are 44105, 10013, 07054, and so on.
STATE	VARCHAR2	64			Supplier location state. Possible values are OH, NY, NJ, and so on.
PROVINCE	VARCHAR2	64			Supplier location province. Possible values are ARKANSAS, NEW HAMPSHIRE, ARIZONA, and so on.
COUNTRY	VARCHAR2	32			Supplier location country code. Possible values are US, GB, CA, and so on.
PHONE_NUMBER	VARCHAR2	32			Supplier phone number.
FAX_NUMBER	VARCHAR2	64			Supplier fax number.
CUSTOMER_NUMBER	VARCHAR2	32			Customer number with the supplier site.
SUPPLIER_ID	NUMBER	38	0		Supplier identifier.
PARTY_ID	NUMBER	38	0		Party identifier.
PARTY_SITE_ID	NUMBER	38	0		Party site identifier.
LOCATION_ID	NUMBER	38	0		Location identifier.
PRC_BUSINESS_UNIT_ID	NUMBER	38	0		Procurement business unit identifier.	DW_INTERNAL_ORG_D	ORGANIZATION_ID
INACTIVE_DATE	DATE				Inactive date of the site.	DW_DAY_D	CALENDAR_DATE
PURCHASING_SITE_FLAG	VARCHAR2	16			Indicates whether you can purchase from this site. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO	DW_CODE_VALUES_LKP_TL	CODE
PCARD_SITE_FLAG	VARCHAR2	16			Indicator of whether the site allows use of procurement cards. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO	DW_CODE_VALUES_LKP_TL	CODE

DW_SUPPLIER_SOURCE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, SUPPLIER_SOURCE_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
SUPPLIER_SOURCE_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_SUPPLIER_TYPE_LKP_TL

This table contains information about Supplier Type code, name and description.

Details

Module: Common

Key Columns

LANGUAGE, SUPPLIER_TYPE_CODE

Columns

Name	Datatype	Length	Not Null	Comments
SUPPLIER_TYPE_CODE	VARCHAR2	128	True	Supplier type code
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier
SUPPLIER_TYPE_NAME	VARCHAR2	2048		Business name or value of the supplier type code.
SUPPLIER_TYPE_DESCRIPTION	VARCHAR2	4000		Supplier type code description.

DW_SUPSITE_PMT_GRP_NAME_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, SUPSITE_PMT_GRP_NAME_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
SUPSITE_PMT_GRP_NAME_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_TARGET_EXTENSION_MAPPINGS_DFG

Stores information about the extended DFF Attributes. This table Contains all the Extended DFF tables and its corresponding attributes and labels.

Details

Module: Common

Key Columns

DW_COLUMN_NAME, DW_TABLE_NAME

Columns

Name	Datatype	Length	Not Null	Comments
DW_TABLE_NAME	VARCHAR2	128	True	DFF Target table name
DW_COLUMN_NAME	VARCHAR2	128	True	DFF Attribute Name
DW_DATA_TYPE	VARCHAR2	32		DFF Data Type
DW_DATA_LENGTH	VARCHAR2	16		DFF Data Length
DW_DATA_SCALE	VARCHAR2	16		DFF Data scale
DW_IS_PRIMARY	VARCHAR2	16		DFF IS Primary Column
DISPLAY_LABEL	VARCHAR2	2048		DFF Prompt Value
COLUMN_ORDER	VARCHAR2	16		DFF column position

DW_TAX_POINT_BASIS_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_UNIT_OF_MEASURE_D_TL

Unit of measurement Dimension translation.

Details

Module: Common

Key Columns

LANGUAGE, UNIT_OF_MEASURE_ID

Columns

Name	Datatype	Length	Not Null	Comments
UNIT_OF_MEASURE_ID	NUMBER		True	Unit of measure Identifier
LANGUAGE	VARCHAR2	16	True	Language code.
SOURCE_RECORD_ID	VARCHAR2	128		Source record identifier
UOM_CODE	VARCHAR2	16		Unique short code assigned to a UOM
UOM_CLASS	VARCHAR2	16		UOM Class
BASE_UOM_FLAG	VARCHAR2	16		Base UOM flag
DISABLE_DATE	DATE			Date from when the UOM cannot be used to define conversions
UNIT_OF_MEASURE_NAME	VARCHAR2	32		Translatable UOM name
UNIT_OF_MEASURE_DESCRIPTION	VARCHAR2	64		Translatable UOM description

DW_USER_D

This table contains information about users who created or modified records in the source system from which the rows have been extracted. It has the users' contact and location information.

Details

Module: Common

Key Columns

USERNAME

Columns

Name	Datatype	Length	Precision	Not Null	Comments
USERNAME	VARCHAR2	128		True	User name.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier. Value is same as the user name.
FIRST_NAME	VARCHAR2	256			First name.
MIDDLE_NAME	VARCHAR2	256			Middle name.
LAST_NAME	VARCHAR2	256			Last name.
FULL_NAME	VARCHAR2	2048			Full name.
NAME_PREFIX	VARCHAR2	256			Name prefix.
NAME_SUFFIX	VARCHAR2	128			Name suffix.
NAME_EFFECTIVE_START_DATE	TIMESTAMP				Effective start date for user name.
WORK_PHONE_NUMBER	VARCHAR2	256			Work phone.
MOBILE_PHONE_NUMBER	VARCHAR2	256			Mobile number.
PAGER_NUMBER	VARCHAR2	256			Pager number.
FAX_NUMBER	VARCHAR2	256			Fax number.
PRIMARY_EMAIL_ADDRESS	VARCHAR2	256			Primary email.
SUPERVISOR_NAME	VARCHAR2	256			Supervisor name.
DEPARTMENT_ID	NUMBER	38	0		Department.
LOGIN_ID	VARCHAR2	256			Login.
USER_FORMED_DATE	TIMESTAMP				Date of user account creation.
ACTIVE_FLAG	VARCHAR2	32			User active flag.
PARTY_ID	NUMBER	38	0		User party id

DW_WEEK_D

This table contains week-level information about the Gregorian calendar.

Details

Module: Common

Key Columns

CAL_WEEK_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
CAL_WEEK_ID	NUMBER	38	0	True	Week identifier in YYYYW format. For example, 197949.
SOURCE_RECORD_ID	NUMBER	38	0		Integration identifier generated by formatting the week in YYYYMMDD format.
CAL_YEAR_ID	NUMBER	38	0		Year identifier in YYYY format. For example, 1979.
CAL_WEEK_CODE	VARCHAR2	32			Calendar week period Name. For example, 1979 Week53.
CAL_WEEK_START_DATE	DATE				Start date of the week.
CAL_WEEK_END_DATE	DATE				End date of the week.
CAL_YEAR_START_DATE	DATE				Start date of the year.
CAL_YEAR_END_DATE	DATE				End date of the year.
CAL_WEEK_NUMBER	NUMBER	38	0		Calendar week identifier. Possible values are 1 through 53.
CAL_WEEK_END_DATE_ID	NUMBER	38	0		Last day of week in YYYYMMDD format.
CAL_WEEK_START_DATE_ID	NUMBER	38	0		First day of week in YYYYMMDD format.
CAL_YEAR_END_DATE_ID	NUMBER	38	0		Last day of year in YYYYMMDD format.
CAL_YEAR_START_DATE_ID	NUMBER	38	0		First day of year in YYYYMMDD format.
FIRST_WEEK_CAL_YEAR_FLAG	VARCHAR2	16			Indicates that this week is the first week of calendar year.
LAST_WEEK_CAL_YEAR_FLAG	VARCHAR2	16			Indicates that this week is the last week of calendar year.
CURRENT_CAL_WEEK_CODE	VARCHAR2	16			Indicates that this day belongs to current week. Possible value is Current.
CURRENT_CAL_YEAR_CODE	VARCHAR2	16			Indicates that this day belongs to current year. Possible value is Current.

DW_WH_REFRESH_DETAILS

This table contains the list of the warehouse views that was updated to facilitate BI server cache refresh.

Details

Module: Common

Key Columns

TABLE_NAME

Columns

Name	Datatype	Length	Not Null	Comments
TABLE_NAME	VARCHAR2	256	True	Name of the warehouse view that was updated.
JOB_ID	VARCHAR2	256		Load plan run job identifier.
SOURCE_TYPE_CODE	VARCHAR2	32		Source Code of OAX

DW_WH_REFRESH_SUMMARY

This table contains warehouse refresh summary information.

Details

Module: Common

Key Columns

JOB_ID, PROCESS_NAME, FUNCTIONAL_AREA_CODE

Columns

Name	Datatype	Length	Not Null	Comments
JOB_ID	VARCHAR2	256	True	Load plan job identifier.
PROCESS_NAME	VARCHAR2	128	True	Process name.
FUNCTIONAL_AREA_CODE	VARCHAR2	1024	True	Functional area code.
SOURCE_RECORD_ID	VARCHAR2	2048		Source record identifier. Value is derived from a combination of load plan job identifier, process name, and functional area code.
FUNCTIONAL_AREA_NAME	VARCHAR2	1024		Functional area name.
SOURCE_TYPE_CODE	VARCHAR2	32		Source Code of OAX
WAREHOUSE_REFRESH_DATETIME	TIMESTAMP			Warehouse refresh completion time stamp.
SOURCE_EXTRACT_DATETIME	TIMESTAMP			Source extract completion time stamp.

DW_WORKER_LOCATION_D

Business location Dimension.

Details

Module: Common

Key Columns

LOCATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
LOCATION_ID	NUMBER	38	0	True	Business Location ID	DW_WORKER_LOCATION_D_TL	LOCATION_ID
SOURCE_RECORD_ID	NUMBER	38	0		Unique record Identifier.Business location ID as Primary Key
LOCATION_CODE	VARCHAR2	256			Internal Location Code
ADDRESS_LINE_1	VARCHAR2	256			First line of address
ADDRESS_LINE_2	VARCHAR2	256			Second line of address
ADDRESS_LINE_3	VARCHAR2	256			Third line of address
ADDRESS_LINE_4	VARCHAR2	256			Fourth line of address
TOWN_OR_CITY	VARCHAR2	32			Name of the Town or City for the address
POSTAL_CODE	VARCHAR2	32			Postal code of the address
REGION1	VARCHAR2	128			Primary region in which the address is located.
REGION2	VARCHAR2	128			Sub-region of Region 1.
REGION3	VARCHAR2	128			Sub-region of Region 2.
COUNTRY	VARCHAR2	64			Country of the address. For translation refer table DW_COUNTRY_D_TL.	DW_COUNTRY_D_TL	COUNTRY
MAIN_PHONE_NUMBER	VARCHAR2	256			Main Phone Number
MAIN_PHONE_EXTENSION	VARCHAR2	64			Main Phone Extension
FAX_NUMBER	VARCHAR2	256			Fax Number
FAX_NUMBER_EXTENSION	VARCHAR2	64			Fax Extension
OTHER_PHONE_NUMBER	VARCHAR2	256			Other Phone Number
OTHER_PHONE_EXTENSION	VARCHAR2	64			Pther pHone extension
EMAIL_ADDRESS	VARCHAR2	256			Email Address
ACTIVE	VARCHAR2	32			Active
INVENTORY_ORGANIZATION_NAME	VARCHAR2	256			Represents the inventory organization id the location is attached. This attribute is not supported.

DW_WORKER_LOCATION_D_TL

Business location Dimension Translation.

Details

Module: Common

Key Columns

LANGUAGE, LOCATION_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
LOCATION_ID	NUMBER	38	0	True	Location Id
LANGUAGE	VARCHAR2	16		True	Language code
SOURCE_RECORD_ID	VARCHAR2	64			Source Record Identifier
LOCATION_NAME	VARCHAR2	256			Location Name
LOCATION_DESCRIPTION	VARCHAR2	256			Location Description

DW_XLA_ACCNT_LINE_TYPES_LKP_TL

This table contains translated information about Journal Line Rules.

Details

Module: Common

Key Columns

EVENT_CLASS_CODE, APPLICATION_ID, ACCOUNTING_LINE_CODE, ACCOUNTING_LINE_TYPE_CODE, LANGUAGE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
APPLICATION_ID	NUMBER	38	0	True	Functional area within a software suite of products. For example, Financials or Payroll.
EVENT_CLASS_CODE	VARCHAR2	32		True	Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.
ACCOUNTING_LINE_TYPE_CODE	VARCHAR2	16		True	Unique abbreviated name assigned to a journal line rule and used for reporting or in reference to an option.
ACCOUNTING_LINE_CODE	VARCHAR2	32		True	Unique abbreviated name assigned to a journal line rule and used for reporting or in reference to an option.
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	VARCHAR2	256			Source record identifier
ENTITY_CODE	VARCHAR2	32			Unique abbreviated name assigned to an entity and used for reporting or in reference to an option.
NAME	VARCHAR2	128			Rule to convert transactional data into a journal entry line.
DESCRIPTION	VARCHAR2	256			Additional information associated with the rule to convert transactional data into a journal entry line.
SOURCE_LANG	VARCHAR2	16			Indicates the code of the language in which the contents of the translatable columns were originally created.

DW_XLA_ACCOUNT_CLASS_LKP_TL

This table contains information about sla accounting class code, name and description.

Details

Module: Common

Key Columns

LANGUAGE, ACCOUNTING_CLASS_CODE

Columns

Name	Datatype	Length	Not Null	Comments
ACCOUNTING_CLASS_CODE	VARCHAR2	128	True	Accounting class code
LANGUAGE	VARCHAR2	64	True	Translation language
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier
ACCOUNTING_CLASS_NAME	VARCHAR2	2048		Business name or value of the accounting class code
ACCOUNTING_CLASS_DESCRIPTION	VARCHAR2	4000		Accounting class code description

DW_YEAR_D

This table contains year-level information about the Gregorian calendar.

Details

Module: Common

Key Columns

CAL_YEAR_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
CAL_YEAR_ID	NUMBER	38	0	True	Year identifier in YYYY format. For example, 1979.
SOURCE_RECORD_ID	NUMBER	38	0		Integration identifier generated by formatting the date in YYYYMMDD format.
CAL_YEAR_START_DATE	DATE				Start date of the year.
CAL_YEAR_END_DATE	DATE				End date of the year.
CAL_YEAR_END_DATE_ID	NUMBER	38	0		Last day of year in YYYYMMDD format.
CAL_YEAR_START_DATE_ID	NUMBER	38	0		First day of year in YYYYMMDD format.
CURRENT_CAL_YEAR_CODE	VARCHAR2	16			Indicates that this day belongs to current year. Possible value is Current.
YEAR_END_OR_PRV_CRNT_DATE	DATE				For current year, day before current date else year end date
TRAILING_YEAR_NUMBER	NUMBER	38	0		Indicate trailing year number

DW_YESNO_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

YESNO_LKP_CODE, CODE_TYPE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
YESNO_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_YESNONEVER_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, YESNONEVER_LKP_CODE, CODE_TYPE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
YESNONEVER_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_YN_LKP_TL

This table contains information about code, name, and description.

Details

Module: Common

Key Columns

LANGUAGE, CODE_TYPE, YN_LKP_CODE

Columns

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
YN_LKP_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ZX_JURISDICTIONS_LKP_TL

This table contains information about code and name for the Tax Jurisdiction codes

Details

Module: Common

Key Columns

TAX_REGIME_CODE, TAX_JURISDICTION_ID, LANGUAGE, TAX, TAX_JURISDICTION_CODE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
TAX_REGIME_CODE	VARCHAR2	32		True	Code type. It is specific to functionality.
TAX	VARCHAR2	32		True	Code Type
TAX_JURISDICTION_CODE	VARCHAR2	32		True	Tax Jurisdictions Code
TAX_JURISDICTION_ID	NUMBER	38	0	True	Translation language.
LANGUAGE	VARCHAR2	16		True	Tax Jurisdiction id
SOURCE_RECORD_ID	VARCHAR2	512			Source record identifier. Value is derived from a combination of code type and code.
TAX_JURISDICTION_NAME	VARCHAR2	256			Tax Jurisdiction Name

DW_ZX_RATES_LKP_TL

This table contains information about name for the Tax Rate and Description.

Details

Module: Common

Key Columns

TAX_RATE_ID, LANGUAGE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
TAX_RATE_ID	NUMBER	38	0	True	Tax Rate Id
LANGUAGE	VARCHAR2	16		True	Language
SOURCE_RECORD_ID	VARCHAR2	512			Source record identifier. Value is derived from a combination of code type and code.
TAX_RATE_NAME	VARCHAR2	256			Tax Full Name
DESCRIPTION	VARCHAR2	256			Tax rate description

DW_ZX_REGIMES_LKP_TL

This table contains information about code and name for the Tax Regimes

Details

Module: Common

Key Columns

TAX_REGIME_CODE, LANGUAGE, TAX_REGIME_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
TAX_REGIME_CODE	VARCHAR2	128		True	Code type. It is specific to functionality.
TAX_REGIME_ID	NUMBER	38	0	True	Code.
LANGUAGE	VARCHAR2	16		True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512			Source record identifier. Value is derived from a combination of code type and code.
TAX_REGIME_NAME	VARCHAR2	256			Business name or value of the code.

DW_ZX_TAXES_LKP_TL

This table contains information about code and name for the Taxes

Details

Module: Common

Key Columns

TAX_REGIME_CODE, CONTENT_OWNER_ID, TAX_ID, LANGUAGE, TAX

Columns

Name	Datatype	Length	Precision	Not Null	Comments
TAX_REGIME_CODE	VARCHAR2	128		True	Code type. It is specific to functionality.
TAX	VARCHAR2	32		True	Code Type
CONTENT_OWNER_ID	NUMBER	38	0	True	Content Owner id
TAX_ID	NUMBER	38	0	True	Translation language.
LANGUAGE	VARCHAR2	16		True	Tax id
SOURCE_RECORD_ID	VARCHAR2	512			Source record identifier. Value is derived from a combination of code type and code.
TAX_FULL_NAME	VARCHAR2	128			Tax Full Name

Name	Datatype	Length	Not Null	Comments
CODE_TYPE	VARCHAR2	128	True	Code type. It is specific to functionality.
CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
VALUATION_ID	NUMBER	38	0	True	Surrogate key that identifies a row in this table.
SOURCE_RECORD_ID	VARCHAR2	32			System Identifier
COST_BOOK_ID	NUMBER	38	0		Identifies the Cost Book assigned to the Cost Organization.	DW_CST_COST_ORG_BOOKS_D	COST_BOOK_ID
COST_ORG_ID	NUMBER	38	0		Identifies the Cost Organization associated with the inventory organization.	DW_CST_COST_ORG_BOOKS_D	COST_ORG_ID
EFFECTIVE_START_DATE	DATE				Snapshot Start Date	DW_DAY_D	CALENDAR_DATE
EFFECTIVE_END_DATE	DATE				Snapshot End date	DW_DAY_D	CALENDAR_DATE
LEGAL_ENTITY_ID	NUMBER	38	0		Legal entity Identifier	DW_LEGAL_ENTITY_D	LEGAL_ENTITY_ID
COST_ORG_BOOK_LEDGER_ID	NUMBER	38	0		"This is the unique Ledger corresponding to the cost organization and cost book. It can be Primary, Secondary or any other Ledger defined in Financial setups. A Null value indicates Ledger-less cost organization and cost book entity, which may be used for costing simulations."	DW_LEDGER_D	LEDGER_ID
CURRENCY_CODE	VARCHAR2	32			Identifies the currency of the transaction.
VAL_UNIT_ID	NUMBER	38	0		Valuation unit identifier	DW_CST_VALUATION_UNITS_D	VAL_UNIT_ID
INVENTORY_ORG_ID	NUMBER	38	0		Indicates The Inventory Org To Which The Item Belongs	DW_INTERNAL_ORG_D	ORGANIZATION_ID
INVENTORY_ITEM_ID	NUMBER	38	0		Inventory Item Identifier #1	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
SUBINVENTORY_CODE	VARCHAR2	16			The subinventory code	DW_INV_SUBINVENTORY_D	SECONDARY_INVENTORY_NAME
SUBINVENTORY_LOCATION_ID	NUMBER	38	0		This identifies the location of the subinventory	DW_WORKER_LOCATION_D	LOCATION_ID
LOCATOR_ID	NUMBER	38	0		Inventory locator identifier	DW_INV_LOCATOR_D	INVENTORY_LOCATION_ID
QUANTITY_ONHAND	NUMBER				Quantity Onhand for the period.
VU_QUANTITY_ONHAND	NUMBER				Total quantity at the VU level for the period
UOM_CODE	VARCHAR2	16			Unit of Measure of the quantities	DW_UNIT_OF_MEASURE_D_TL	UOM_CODE
GLOBAL_CURRENCY_CODE	VARCHAR2	32			Analytics currency code
GLOBAL_CURRENCY_EXCH_RATE	NUMBER				Transaction to Global currency exchange rate
AMOUNT	NUMBER				Quantity onhand amount
VU_AMOUNT	NUMBER				Total amount at the VU level
WRITEOFF_AMOUNT	NUMBER				Quantity onhand amount that is in write-off instead of inventory.
VU_WRITEOFF_AMOUNT	NUMBER				Total amount that is in write-off instead of Inventory at the VU level.
STANDARD_COST	NUMBER				Standard cost, if the valuation is for standard cost method.
VU_UNIT_COST	NUMBER				Unit Cost at the VU level
PERP_AVERAGE_COST	NUMBER				Perpetual Average cost, if the valuation is for perpetual average cost method.
ACCTD_AMOUNT	NUMBER				Amount that is final accounted.
EXCL_FROM_ACCTG_AMOUNT	NUMBER				Amount that is excluded from accounting.
GLOBAL_AMOUNT	NUMBER				Global Quantity onhand amount
GLOBAL_VU_AMOUNT	NUMBER				Total global amount at the VU level
GLOBAL_WRITEOFF_AMOUNT	NUMBER				Quantity onhand global amount that is in write-off instead of inventory.
GLOBAL_VU_WRITEOFF_AMOUNT	NUMBER				Total global amount that is in write-off instead of Inventory at the VU level.
GLOBAL_STANDARD_COST	NUMBER				Global Standard cost, if the valuation is for standard cost method.
GLOBAL_VU_UNIT_COST	NUMBER				Global Unit Cost at the VU level
GLOBAL_PERP_AVERAGE_COST	NUMBER				Global Perpetual Average cost, if the valuation is for perpetual average cost method.
GLOBAL_ACCTD_AMOUNT	NUMBER				Global Amount that is final accounted.
GLOBAL_EXCL_FROM_ACCTG_AMOUNT	NUMBER				Global Amount that is excluded from accounting.
COST_METHOD_CODE	VARCHAR2	32			The cost method code. Contains values PERPETUAL AVERAGE, STANDARD and ACTUAL.	DW_CST_COST_METHODS_LKP_TL	CST_COST_METHODS_CODE
FISCAL_PERIOD_SET_NAME	VARCHAR2	16			Fiscal Period Set Name. #2	DW_FISCAL_DAY_D	FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE	VARCHAR2	16			Period type. Examples are Weekly, Monthly, Quarterly. #2	DW_FISCAL_DAY_D	FISCAL_PERIOD_TYPE
LAST_UPDATE_DATE	DATE				Who column: indicates the date and time of the last update of the row.	DW_DAY_D	CALENDAR_DATE

Notes

#1 In these cases in addition to the item columns INVENTORY_ORG_ID column should also be used for join with DW_INVENTORY_ITEM_D

#2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on EFFECTIVE_START_DATE or EFFECTIVE_END_DATE columns depending on Fiscal Period is being checked for Effective_Start_Date or Effective_End_Date

DW_CST_ITEM_COST_CF

This fact table contains information about Item Costing.

Details

Module: Cost Management

Key Columns

COST_BOOK_ID, VAL_UNIT_ID, EXPENSE_POOL_ID, EFFECTIVE_START_DATE, COST_LEVEL_CODE, COST_ELEMENT_ID, COST_ORG_ID, INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
COST_ORG_ID	NUMBER	38	0	True	Cost Org identifier	DW_CST_COST_ORG_BOOKS_D	COST_ORG_ID
COST_BOOK_ID	NUMBER	38	0	True	Cost Book identifier	DW_CST_COST_ORG_BOOKS_D	COST_BOOK_ID
INVENTORY_ITEM_ID	NUMBER	38	0	True	Inventory Item Identifier #1	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
VAL_UNIT_ID	NUMBER	38	0	True	Valuation Unit Identifier	DW_CST_VALUATION_UNITS_D	VAL_UNIT_ID
COST_ELEMENT_ID	NUMBER	38	0	True	Cost element corresponding to the cost of the transaction.	DW_CST_COST_ELEMENTS_D	COST_ELEMENT_ID
EXPENSE_POOL_ID	NUMBER	38	0	True	Identifies the expense pool for which this cost is created.	DW_CST_EXPENSE_POOLS_D	EXPENSE_POOL_ID
COST_LEVEL_CODE	VARCHAR2	32		True	Indicates the level of the standard cost detail. Options are This Level Cost and Lower Level Cost.	DW_ORA_CST_STD_COST_LEVEL_LKP_TL	ORA_CST_STD_COST_LEVEL_CODE
EFFECTIVE_START_DATE	DATE			True	Indicates the date at the beginning of the date range within which the row is effective	DW_DAY_D	CALENDAR_DATE
SOURCE_RECORD_ID	VARCHAR2	512			System Identifier
EFFECTIVE_END_DATE	DATE				Indicates the date at the end of the date range within which the row is effective	DW_DAY_D	CALENDAR_DATE
LEGAL_ENTITY_ID	NUMBER	38	0		Legal entity Identifier	DW_LEGAL_ENTITY_D	LEGAL_ENTITY_ID
COST_ORG_BOOK_LEDGER_ID	NUMBER	38	0		"This is the unique Ledger corresponding to the cost organization and cost book. It can be Primary, Secondary or any other Ledger defined in Financial setups. A Null value indicates Ledger-less cost organization and cost book entity, which may be used for costing simulations."	DW_LEDGER_D	LEDGER_ID
SCENARIO_ID	NUMBER	38	0		Scenario Identifier	DW_CST_SCENARIOS_D	SCENARIO_ID
INVENTORY_ORG_ID	NUMBER	38	0		Identifies the master organization of the item for which the standard cost is entered
COST_PROFILE_ID	NUMBER	38	0		Cost Profile Identifier	DW_CST_COST_PROFILES_D	COST_PROFILE_ID
CURRENCY_CODE	VARCHAR2	16			Indicates the currency code in which the cost is entered
GLOBAL_CURRENCY_CODE	VARCHAR2	32			Analytics currency code
GLOBAL_CURRENCY_EXCH_RATE	NUMBER				Transaction to Global currency exchange rate
UNIT_COST	NUMBER				Indicates the unit cost in transaction/document currency
GLOBAL_UNIT_COST	NUMBER				Indicates the unit cost in global/analytical currency
COST_METHOD_CODE	VARCHAR2	32			The cost method code. Possible values are PERPETUAL AVERAGE,STANDARD ad ACTUAL.	DW_CST_COST_METHODS_LKP_TL	CST_COST_METHODS_CODE
FISCAL_PERIOD_SET_NAME	VARCHAR2	16			Fiscal Period Set Name #2	DW_FISCAL_DAY_D	FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE	VARCHAR2	16			Period type. Examples are Weekly, Monthly, Quarterly #2	DW_FISCAL_DAY_D	FISCAL_PERIOD_TYPE
UOM_CODE	VARCHAR2	32			Unit of Measure	DW_UNIT_OF_MEASURE_D_TL	UOM_CODE

Notes

#1 In these cases in addition to the item columns INVENTORY_ORG_ID column should also be used for join with DW_INVENTORY_ITEM_D

#2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on EFFECTIVE_START_DATE column

DW_CST_SCENARIOS_D

This table contains the header information about the cost planning scenarios.

Details

Module: Cost Management

Key Columns

SCENARIO_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
SCENARIO_ID	NUMBER	38	0	True	Surrogate key and unique identifier for each cost planning scenario
SOURCE_RECORD_ID	VARCHAR2	64			System Identifier
EFFECTIVE_START_DATE	DATE				Indicates the date when the scenario becomes effective
SCENARIO_NUMBER	VARCHAR2	32			User definable number to identify the cost planning scenario
SCENARIO_TYPE	VARCHAR2	32			Indicates the type of the scenario	DW_ORA_CST_SCENARIO_TYPES_LKP_TL	ORA_CST_SCENARIO_TYPES_CODE
STATE_CODE	VARCHAR2	32			Indicates the state of the scenario	DW_ORA_CST_SCENARIO_STATE_LKP_TL	ORA_CST_SCENARIO_STATE_CODE
STATUS_CODE	VARCHAR2	32			Indicates the status of the scenario	DW_ORA_CST_SCENARIO_STATUS_SMPL_LKP_TL	ORA_CST_SCENARIO_STATUS_SMPL_CODE
COMMENTS	VARCHAR2	1024			Indicates the detailed information or comments about the cost planning scenario being defined

DW_CST_VALUATION_STRUCTURE_MODES_LKP_TL

This table contains information about code, name, and description.

Details

Module: Cost Management

Key Columns

CST_VALUATION_STRUCTURE_MODES_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CST_VALUATION_STRUCTURE_MODES_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_CST_VALUATION_STRUCTURE_TYPES_LKP_TL

This table contains information about code, name, and description.

Details

Module: Cost Management

Key Columns

CST_VALUATION_STRUCTURE_TYPES_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
CST_VALUATION_STRUCTURE_TYPES_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_CST_VALUATION_STRUCTURES_TL

Translation table containing the valuation structure descriptions.

Details

Module: Cost Management

Key Columns

VAL_STRUCTURE_ID, LANGUAGE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
VAL_STRUCTURE_ID	NUMBER	38	0	True	Single column FK. Identifies a row in CST_VAL_STRUCTURES_B table. The corresponding tranlated descriptions are stored in this table.
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
VAL_STRUCTURE_DESC	VARCHAR2	256			Valuation Structure Description

DW_CST_VALUATION_UNITS_D

This table contains the valuation unit information.

Details

Module: Cost Management

Key Columns

VAL_UNIT_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
VAL_UNIT_ID	NUMBER	38	0	True	Surrogate key identifying Valuation Unit row in this table.	DW_CST_VALUATION_UNITS_TL	VAL_UNIT_ID
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
VAL_STRUCTURE_ID	NUMBER	38	0		Identifies the Valuation Structure.	DW_CST_VALUATION_STRUCTURES_TL	VAL_STRUCTURE_ID
VAL_UNIT_CODE	VARCHAR2	1024			Valuation Unit Code
COST_ORG_ID	NUMBER	38	0		Identifies the Cost Organization.	DW_CST_COST_ORG_BOOKS_D	COST_ORG_ID
COST_BOOK_ID	NUMBER	38	0		Identifies the Cost Book assigned to the Cost Organization.	DW_CST_COST_ORG_BOOKS_D	COST_BOOK_ID
VAL_STRUCTURE_CODE	VARCHAR2	32			Valuation Structure Code
VAL_STRUCTURE_TYPE_CODE	VARCHAR2	32			Valuation Structure Type	DW_CST_VALUATION_STRUCTURE_TYPES_LKP_TL	CST_VALUATION_STRUCTURE_TYPES_CODE
VAL_STRUCTURE_MODE_CODE	VARCHAR2	32			Valuation Structure Creation Mode	DW_CST_VALUATION_STRUCTURE_MODES_LKP_TL	CST_VALUATION_STRUCTURE_MODES_CODE

DW_CST_VALUATION_UNITS_TL

Translation table containing the valuation unit descriptions.

Details

Module: Cost Management

Key Columns

VAL_UNIT_ID, LANGUAGE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
VAL_UNIT_ID	NUMBER	38	0	True	Valuation Unit Identifier
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
VAL_UNIT_DESC	VARCHAR2	256			Valuation Unit Description

DW_ORA_CST_SCENARIO_STATE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Cost Management

Key Columns

ORA_CST_SCENARIO_STATE_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
ORA_CST_SCENARIO_STATE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	16	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	256		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128		Business name or value of the code.
DESCRIPTION	VARCHAR2	256		Code description.

DW_ORA_CST_SCENARIO_STATUS_SMPL_LKP_TL

This table contains information about code, name, and description.

Details

Module: Cost Management

Key Columns

LANGUAGE, ORA_CST_SCENARIO_STATUS_SMPL_CODE

Columns

Name	Datatype	Length	Not Null	Comments
ORA_CST_SCENARIO_STATUS_SMPL_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	16	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	256		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128		Business name or value of the code.
DESCRIPTION	VARCHAR2	256		Code description.

DW_ORA_CST_SCENARIO_TYPES_LKP_TL

This table contains information about code, name, and description.

Details

Module: Cost Management

Key Columns

ORA_CST_SCENARIO_TYPES_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
ORA_CST_SCENARIO_TYPES_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ORA_CST_STD_COST_LEVEL_LKP_TL

This table contains information about code, name, and description.

Details

Module: Cost Management

Key Columns

LANGUAGE, ORA_CST_STD_COST_LEVEL_CODE

Columns

Name	Datatype	Length	Not Null	Comments
ORA_CST_STD_COST_LEVEL_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

Name	Datatype	Length	Not Null	Comments
INV_YES_NO_NUMERIC_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
FULFILL_LINE_ID	NUMBER	38	0	True	Unique Identifier for a fulfillment line
SOURCE_RECORD_ID	VARCHAR2	128			System Identifier
ORDER_HEADER_ID	NUMBER	38	0		Unique identifier of the orchestration order
ORDER_NUMBER	VARCHAR2	64			Representation of a sales order used in communication with fulfillment systems
LINE_ID	NUMBER	38	0		Unique identifier of the sales order line
ORDER_LINE_NUMBER	NUMBER	38	0		Representation of a sales order line used in communication with fulfillment systems
FULFILL_LINE_NUMBER	NUMBER	38	0		Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split
LINE_DISPLAY_LINE_NUMBER	VARCHAR2	128			Line number for display purposes. Corresponds to the line number on UI
FULFILL_DISPLAY_LINE_NUMBER	VARCHAR2	256			Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI
ORGANIZATION_ID	NUMBER	38	0		Indicates the identifier of the inventory organization	DW_INTERNAL_ORG_D	ORGANIZATION_ID
FULFILL_ORG_ID	NUMBER	38	0		Reference to the unique identifier for the fulfillment organization	DW_INTERNAL_ORG_D	ORGANIZATION_ID
BUSINESS_UNIT_ID	NUMBER	38	0		Business Unit ID	DW_BUSINESS_UNIT_D	BUSINESS_UNIT_ID
PROFIT_CENTER_BUSINESS_UNIT_ID	NUMBER	38	0		Reference to Unique Identifier of Profit Center Business Unit	DW_BUSINESS_UNIT_D	BUSINESS_UNIT_ID
ORGANIZATION_BU_ID	NUMBER	38	0		Inventory Business Unit ID	DW_BUSINESS_UNIT_D	BUSINESS_UNIT_ID
LEGAL_ENTITY_ID	NUMBER	38	0		Legal entity identifier	DW_LEGAL_ENTITY_D	LEGAL_ENTITY_ID
ORDER_TYPE_CODE	VARCHAR2	32			Name of the type of order that was placed. Stores codes for values of order types.	DW_ORDER_TYPE_LKP_TL	ORDER_TYPE_CODE
ORDER_STATUS_CODE	VARCHAR2	32			Status of the order.	DW_OM_STATUS_D	STATUS_CODE
FULFILLMENT_MODE	VARCHAR2	32			It captures the fulfillment mode codes. The lookup can have the below 3 values for Regular Order Fulfill Lines (Not applicable for Return Fulfill lines) - Regular, DropShip, Back to Back	DW_ORDER_FULFILL_MODE_LKP_TL	FULFILLMENT_MODE_CODE
LINE_CATEGORY_CODE	VARCHAR2	32			Represents whether a sales order line belongs to a regular order or a return order	DW_ORDER_LINE_CATEGORY_LKP_TL	LINE_CATEGORY_CODE
LINE_TYPE_CODE	VARCHAR2	32			Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. Use DW_ORDER_LINE_TYPE_LKP_TL to resolve the lookup codes for order lines, and DW_ORDER_RETURN_TYPE_LKP_TL for return lines	DW_ORDER_LINE_TYPE_LKP_TL	LINE_TYPE_CODE
FULFILL_LINE_STATUS_CODE	VARCHAR2	32			Current fulfillment status of the fulfillment line.	DW_OM_STATUS_D	STATUS_CODE
SOURCE_ORDER_NUMBER	VARCHAR2	64			Reference to the number of the originating sales order
SOURCE_ORDER_SYSTEM	VARCHAR2	64			Reference to the order capture system that the source order came from
SOURCE_ORDER_LINE_NUMBER	VARCHAR2	128			Reference to the number of the originating sales order line
SOURCE_DOCUMENT_TYPE_CODE	VARCHAR2	64			Indicates the Original Document document type on the order
SPLIT_FROM_FLINE_ID	NUMBER	38	0		Reference to the original fulfillment line in the event that splits occur
SPLIT_FLINE_FLAG	VARCHAR2	16			Indicates if the fulfill line is split and if it is original or a result of splitting from another line. The values - 'O' stands for the original line in an order from which there are split lines, 'C' indicates the split lines or the child lines, 'N' referes to the lines which have no association with split
PARENT_SPLIT_LINE_FLAG	VARCHAR2	16			Indicates if the fulfill line is split into atleast one further line
PARENT_FULFILL_LINE_ID	NUMBER	38	0		Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line
ROOT_PARENT_FULFILL_LINE_ID	NUMBER	38	0		Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy
PARENT_LINE_ID	NUMBER	38	0		Parent Line Identifier
ROOT_PARENT_LINE_ID	NUMBER	38	0		Root Parent Line Identifier
COMP_SEQ_PATH	VARCHAR2	4000			Defines the hierarchical relation of a model. Derived from BOM table
INVENTORY_ITEM_ID	NUMBER	38	0		Reference to the unique identifier for the inventory item #1	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
ITEM_TYPE_CODE	VARCHAR2	32			Indicates a grouping of all items of a particular type that share the same set of item attributes. Stores codes for values like - Model, Option Class, Standard, etc	DW_ORDER_ITEM_TYPE_LKP_TL	ORDER_ITEM_TYPE_CODE
ITEM_SUBTYPE_CODE	VARCHAR2	32			More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC). Stores codes for values like - Standard, Pick to order model, Kit, etc	DW_ORDER_ITEM_SUBTYPE_LKP_TL	ORDER_ITEM_SUBTYPE_CODE
SALES_PRODUCT_TYPE_CODE	VARCHAR2	32			Identifies sales product type of product on the fulfillment line. Stores codes for values like:- Goods, Subscription, extended warranty, etc	DW_SALES_PRODUCT_TYPE_LKP_TL	SALES_PRODUCT_TYPE_CODE
PAYMENT_TERM_ID	NUMBER	38	0		Identifies the AR payment term associated with the Payment terms	DW_AR_PAYMENT_TERMS_D	PAYMENT_TERM_ID
COVERED_FULFILL_LINE_ID	NUMBER	38	0		Fulfill line ID of the item for which coverage is required within the order
COVERED_INVENTORY_ITEM_ID	NUMBER	38	0		Inventory Item id of the item that is covered #1	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
COVERED_ORDER_NUMBER	VARCHAR2	64			Order number of the item that is covered
COVERED_LINE_DISPLAY_LINE_NUM	VARCHAR2	128			Line Display line number of the item line that is covered
COVERED_FLINE_DISPLAY_LINE_NUM	VARCHAR2	128			Fulfill line Display line number of the item line that is covered
PARENT_LINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of parent line
PARENT_FLINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of parent fulfill line
RP_LINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of root parent line
RP_FLINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of root parent fulfill line
CONFIGURED_ITEM_ID	NUMBER	38	0		Inventory item of shippable ATO configuration #1	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
ORIGINAL_INVENTORY_ITEM_ID	NUMBER	38	0		Reference to the unique identifier for the original inventory item that was populated on the fulfillment line from decomposition #1	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
TRX_UOM	VARCHAR2	16			Unit of measure of the Item used for the transaction	DW_UNIT_OF_MEASURE_D_TL	UOM_CODE
DEMAND_CLASS_CODE	VARCHAR2	32			Demand Class used by the promise engine to consume target allocation amounts. This helps identify different market and customer segments.	DW_DEMAND_CLASS_LKP_TL	DEMAND_CLASS_CODE
BILL_TO_CUSTOMER_ACCOUNT_ID	NUMBER	38	0		Reference to the unique identifier for the bill-to customer	DW_CUSTOMER_ACCOUNT_D	CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID	NUMBER	38	0		Reference to the unique identifier for bill-to Party	DW_PARTY_D	PARTY_ID
SOLD_TO_PARTY_ID	NUMBER	38	0		Reference to the unique identifier for the sold-to Party.	DW_PARTY_D	PARTY_ID
SHIP_TO_PARTY_ID	NUMBER	38	0		Reference to the unique identifier for ship-to Party	DW_PARTY_D	PARTY_ID
LEDGER_ID	NUMBER	38	0		Primary ledger id. Derived from the Business Unit.	DW_LEDGER_D	LEDGER_ID
FISCAL_PERIOD_TYPE	VARCHAR2	16			Period type. Derived from the ledger associated with the Business Unit. #2	DW_FISCAL_DAY_D	FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME	VARCHAR2	16			Period Set Name.Derived from the ledger associated with the Business Unit. #2	DW_FISCAL_DAY_D	FISCAL_PERIOD_SET_NAME
ORDER_OPEN_FLAG	VARCHAR2	16			Indicates that the status of an order that is not closed or canceled
ORDER_ON_HOLD_FLAG	VARCHAR2	16			Indicates an order is not accepting further processing
FULFILL_LINE_OPEN_FLAG	VARCHAR2	16			Indicates that the status of a fulfillment line that is not closed or canceled
FULFILL_LINE_ON_HOLD_FLAG	VARCHAR2	16			Indicates fulfillment lines are not accepting further processing
SALES_AGREEMENT_FLAG	VARCHAR2	16			Indicated application of a Sales Agreement
INVOICEABLE_ITEM_FLAG	VARCHAR2	16			This fulfillment line has an item that is enabled for billing or invoicing
INVOICE_ENABLED_FLAG	VARCHAR2	16			Indicator implying the line / item qualifies for billing
ORDER_SUBMIT_DATE	DATE				The date and time of the submission of the order	DW_DAY_D	CALENDAR_DATE
ORDER_SUBMIT_TIMESTAMP	TIMESTAMP				The date and time of the submission of the order
ORDERED_DATE	DATE				Date when the items where ordered	DW_DAY_D	CALENDAR_DATE
ORDERED_TIMESTAMP	TIMESTAMP				Date when the items where ordered
DOCUMENT_CURRENCY_CODE	VARCHAR2	32			Currency code captured at the order header level
GLOBAL_CURRENCY_CODE	VARCHAR2	32			Analytics currency code
GLOBAL_CURRENCY_EXCH_RATE	NUMBER				Transaction to Global currency exchange rate
ORDERED_QTY	NUMBER				The quantity of a good or service ordered
RESERVED_QTY	NUMBER				Quantity of an item that was set aside in a warehouse specifically to fulfill the demand from a given fulfillment line
TRX_UNIT_SELLING_PRICE	NUMBER				The price per unit that a buyer paid for an item
TRX_UNIT_LIST_PRICE	NUMBER				The base selling price before applying discounts. It typically defaults from the item definition
TRX_FLINE_AMT	NUMBER				Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) whether return or general orders
TRX_ORDER_AMT	NUMBER				Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) for general orders
GLOBAL_UNIT_SELLING_PRICE	NUMBER				In Global Currency - The price per unit that a buyer paid for an item
GLOBAL_UNIT_LIST_PRICE	NUMBER				In Global Currency - The base selling price before applying discounts. It typically defaults from the item definition
GLOBAL_FLINE_AMT	NUMBER				In Global Currency - Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) whether return or general orders
GLOBAL_ORDER_AMT	NUMBER				In Global Currency - Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) for general orders
SCHEDULE_SHIP_DATE	DATE				The current date the shipment is planned to ship on	DW_DAY_D	CALENDAR_DATE
SCHEDULE_SHIP_TIMESTAMP	TIMESTAMP				The current date the shipment is planned to ship on
PROMISE_SHIP_DATE	DATE				The date that was promised to the customer that the item would ship	DW_DAY_D	CALENDAR_DATE
PROMISE_SHIP_TIMESTAMP	TIMESTAMP				The date that was promised to the customer that the item would ship
REQUEST_SHIP_DATE	DATE				The original date the customer requested the item ship on	DW_DAY_D	CALENDAR_DATE
REQUEST_SHIP_TIMESTAMP	TIMESTAMP				The original date the customer requested the item ship on
ACTUAL_SHIP_DATE	DATE				The date the shipment was actually sent	DW_DAY_D	CALENDAR_DATE
ACTUAL_SHIP_TIMESTAMP	TIMESTAMP				The date the shipment was actually sent
SCHEDULE_ARRIVAL_DATE	DATE				The current date the shipment is planned to arrive on	DW_DAY_D	CALENDAR_DATE
SCHEDULE_ARRIVAL_TIMESTAMP	TIMESTAMP				The current date the shipment is planned to arrive on
PROMISE_ARRIVAL_DATE	DATE				The date that was promised to the customer that the item would arrive	DW_DAY_D	CALENDAR_DATE
PROMISE_ARRIVAL_TIMESTAMP	TIMESTAMP				The date that was promised to the customer that the item would arrive
REQUEST_ARRIVAL_DATE	DATE				The original date the customer requested the item arrive on	DW_DAY_D	CALENDAR_DATE
REQUEST_ARRIVAL_TIMESTAMP	TIMESTAMP				The original date the customer requested the item arrive on
SHIPPABLE_FLAG	VARCHAR2	16			Indicates whether a fulfillment line can be shipped to a customer
SHIPPED_FLAG	VARCHAR2	16			Indicates whether a fulfillment line is shipped or not. Applies to Line_Category Order, based on. the Actual Ship Date being populated or not.
SHIPPED_FROM_INVENTORY_FLAG	VARCHAR2	16			Indicates if the item that is shipped is shipped from inventory. For example, the Main ATO item will be shipped from inventory and not it's options
ON_TIME_SHIPMENT_SCH_DATE_FLAG	VARCHAR2	16			Indicates if the shipment is done before the schedule ship date
ON_TIME_SHIPMENT_REQ_DATE_FLAG	VARCHAR2	16			Indicates if the shipment is done before the request ship date
SHIPPED_IN_FULL_FLAG	VARCHAR2	16			Indicates if the shipment is done as per the original order without splitting the lines
PERFECT_ORDER_FLAG	VARCHAR2	16			This is a column derived using OPEN_ORDER_FLAG and PERFECT_ORDER_LINES_FLAG. This can be used for directly aggregating at Order Grain to determine if an order is perfect or not. Logic for aggregating it would be : MIN(PERFECT_ORDER_FLAG) by ORDER_HEADER_ID
ORDER_SHIPPED_IN_FULL_FLAG	VARCHAR2	16			This is a column derived using OPEN_ORDER_FLAG and SHIPPED_IN_FULL_FLAG. This can be used for directly aggregating at Order Grain to determine if an order is Shipped in Full or Not. Logic for aggregating it would be : MIN(ORDER_SHIPPED_IN_FULL_FLAG) by ORDER_HEADER_ID
PERFECT_ORDER_LINES_FLAG	VARCHAR2	16			Indicates if the order fulfillment line was a perfect order line or not
CARRIER_NAME	VARCHAR2	512			Trading Partner Carrier Name
MODE_OF_TRANSPORT	VARCHAR2	32			Type of transportation used to ship the product, such as - Truck, Air, Boat, etc	DW_WSH_TRANSPORT_MODE_LKP_TL	TRANSPORT_MODE_CODE
SERVICE_LEVEL	VARCHAR2	32			Priority of transportation that affects how quickly goods are transported	DW_WSH_SERVICE_LEVEL_LKP_TL	SERVICE_LEVEL_CODE
SHIP_SET_NAME	VARCHAR2	64			Group of order lines within an order that need to ship together from their common origin to a common destination and which have the same scheduled ship date
SHIPMENT_PRIORITY_CODE	VARCHAR2	32			Indicates the priority of the fulfillment lines to be shipped. For Ex - High, low, medium	DW_SHIPMENT_PRIORITY_LKP_TL	SHIPMENT_PRIORITY_CODE
FOB_POINT_CODE	VARCHAR2	32			Code that indicates freight on board. This indicates who owns the goods while they are in transit.For Ex - Destination, Origin, etc	DW_FOB_POINT_LKP_TL	FOB_POINT_CODE
FREIGHT_TERMS_CODE	VARCHAR2	32			Freight Terms, specifying the responsibility for Freight charges. For Ex - Add Freight, Prepaid Frieght, etc	DW_FREIGHT_CHARGE_TERMS_LKP_TL	FREIGHT_CHARGE_TERMS_CODE
SHIPPED_QTY	NUMBER				Quantity of product on a fulfillment line that is shipped
FULFILLED_DATE	DATE				Date when the order line is fulfilled (Goods shipped, hardware installed etc.)	DW_DAY_D	CALENDAR_DATE
FULFILLED_TIMESTAMP	TIMESTAMP				Date when the order line is fulfilled (Goods shipped, hardware installed etc.)
FULFILLED_FLAG	VARCHAR2	16			Indicated if the order line if fulfilled
FULFILLED_QTY	NUMBER				Quantity used to fulfill the order line
FULFILL_LINE_CANCEL_DATE	DATE				Date on which customer requested cancellation on the fulfill line	DW_DAY_D	CALENDAR_DATE
FULFILL_LINE_CANCEL_TIMESTAMP	TIMESTAMP				Date on which customer requested cancellation on the fulfill line
ORDER_CANCELLED_FLAG	VARCHAR2	16			Indicates if the entire order has been cancelled or not
ORDER_CANCELLED_REASON_CODE	VARCHAR2	32			Reason for cancelation of order	DW_RETURN_REASON_LKP_TL	RETURN_REASON_CODE
FULFILL_LINE_CANCEL_FLAG	VARCHAR2	16			Indicates if the order fulfill line has been cancelled or not
CANCELLED_QTY	NUMBER				Canceled Quantity
RMA_RECEIPT_DATE	DATE				Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system	DW_DAY_D	CALENDAR_DATE
RMA_RECEIPT_TIMESTAMP	TIMESTAMP				Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system
RETURN_LINE_FLAG	VARCHAR2	16			Indicates if the fulfill line is a return line
RETURNED_LINE_FLAG	VARCHAR2	16			Indicates if the return fulfill line is closed or not
UNREFERENCED_RETURN_FLAG	VARCHAR2	16			Identify return that does not include a reference order.
ORIGINAL_ORDER_NUMBER	VARCHAR2	64			Corresponds to the original order number for which return is generated
RETURN_ASSOCIATED_FLAG	VARCHAR2	16			Indicates if the original fulfill line has a return associated with it in future
RETURN_REASON_CODE	VARCHAR2	32			Justification for a return of a specific product. Many companies have standard reasons that are assigned to returns to be used to analyze the quantity and types of returns	DW_RETURN_REASON_LKP_TL	RETURN_REASON_CODE
RMA_DELIVERED_QTY	NUMBER				The quantity delivered against the receipt fulfill line
TRX_BILLED_AMT	NUMBER				Transaction currency billed amount for a order fulfill line
GLOBAL_BILLED_ORDER_AMT	NUMBER				Global currency billed amount for a order fulfill line
SUBMITTED_BY	VARCHAR2	64			Order submitted by	DW_USER_D	USERNAME
CREATION_DATE	DATE				fulfill line creation date	DW_DAY_D	CALENDAR_DATE
CREATION_TIMESTAMP	TIMESTAMP				fulfill line creation date
ORDER_CREATION_DATE	DATE				order creation date	DW_DAY_D	CALENDAR_DATE
ORDER_CREATION_TIMESTAMP	TIMESTAMP				order creation date
CREATED_BY	VARCHAR2	64			Fulfill line created by	DW_USER_D	USERNAME
LAST_UPDATE_DATE	DATE				Fulfill line last update date	DW_DAY_D	CALENDAR_DATE
LAST_UPDATE_TIMESTAMP	TIMESTAMP				Fulfill line last update date
LAST_UPDATED_BY	VARCHAR2	64			Fulfill line last updated by	DW_USER_D	USERNAME

Notes

#1 In these cases in addition to the item columns ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D

#2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on ORDERED_DATE column

DW_OM_HOLD_CODES_D

This reference base table stores the definition of Hold Codes.

Details

Module: Order Management

Key Columns

HOLD_CODE_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
HOLD_CODE_ID	NUMBER	38	0	True	Unique identifier of the hold code.
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
HOLD_CODE	VARCHAR2	32			Identifier for the hold.
EFFECTIVE_START_DATE	DATE				Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE	DATE				Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
GENERAL_HOLD_FLAG	VARCHAR2	16			Indicates that a specific hold code prevents all services from being performed.
SYSTEM_FLAG	VARCHAR2	16			System seeded holds that cannot be updated or deleted.

DW_OM_HOLD_CODES_D_TL

Translation table to store hold names and hold descriptions.

Details

Module: Order Management

Key Columns

LANGUAGE, HOLD_CODE_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
HOLD_CODE_ID	NUMBER	38	0	True	Reference to the unique identifier for hold codes
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
HOLD_NAME	VARCHAR2	256			Name given by user for the hold code.
HOLD_DESCRIPTION	VARCHAR2	1024			Description for the hold code.

DW_OM_HOLDS_CF

This table contains details of Holds Facts.

Details

Module: Order Management

Key Columns

FULFILL_LINE_ID, HOLD_INSTANCE_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
HOLD_INSTANCE_ID	NUMBER	38	0	True	Unique identifier of the hold instance
FULFILL_LINE_ID	NUMBER	38	0	True	Unique Identifier for a fulfillment line
SOURCE_RECORD_ID	VARCHAR2	128			System Identifier
ACTIVE_FLAG	VARCHAR2	16			Identifies whether a hold is active on a transaction.
APPLY_TIMESTAMP	TIMESTAMP				Date hold was placed.
APPLY_DATE	DATE				Date hold was placed.	DW_DAY_D	CALENDAR_DATE
APPLIED_BY	VARCHAR2	128			The user name that requested to apply this hold instance. This is only applicable when the apply system is DOO workbench.	DW_USER_D	USERNAME
HOLD_CODE_ID	NUMBER	38	0		Reference to the unique identifier for hold codes	DW_OM_HOLD_CODES_D	HOLD_CODE_ID
HOLD_COMMENTS	VARCHAR2	256			Comments the user who is initiating the hold adds to the hold.
HOLD_CREATION_DATE	DATE				Who column: indicates the date and time of the creation of the row.	DW_DAY_D	CALENDAR_DATE
HOLD_CREATION_TIMESTAMP	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
HOLD_LAST_UPDATE_DATE	DATE				Who column: indicates the date and time of the last update of the row.	DW_DAY_D	CALENDAR_DATE
HOLD_LAST_UPDATE_TIMESTAMP	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
HOLD_CREATED_BY	VARCHAR2	128			Who column: indicates the user who created the row.	DW_USER_D	USERNAME
HOLD_LAST_UPDATED_BY	VARCHAR2	128			Who column: indicates the user who last updated the row.	DW_USER_D	USERNAME
HOLD_RELEASE_COMMENTS	VARCHAR2	256			Comments added by user while releasing a hold.
HOLD_RELEASE_REASON_CODE	VARCHAR2	32			Reason for releasing the hold.	DW_HOLD_RELEASE_REASON_LKP_TL	HOLD_RELEASE_REASON_CODE
TRANSACTION_ENTITY_NAME1	VARCHAR2	32			Entity name corresponding to Transaction Entity Id1.
HOLD_LEVEL	VARCHAR2	32			Reference to the level at which the hold is applied	DW_MSG_ENTITY_TYPE_LKP_TL	HOLD_LEVEL_CODE
RELEASE_TIMESTAMP	TIMESTAMP				The date when the hold is released.
RELEASE_DATE	DATE				The date when the hold is released.	DW_DAY_D	CALENDAR_DATE
RELEASED_BY	VARCHAR2	128			The user name that requested to release this hold instance.	DW_USER_D	USERNAME
HOLD_SOURCE_ORDER_SYSTEM	VARCHAR2	64			Reference to the order capture system that the source order came from.
APPLY_SYSTEM	VARCHAR2	32			The system that requested to apply this hold instance.
ORDER_HEADER_ID	NUMBER	38	0		Unique identifier of the orchestration order
ORDER_NUMBER	VARCHAR2	64			Representation of a sales order used in communication with fulfillment systems
LINE_ID	NUMBER	38	0		Unique identifier of the sales order line
ORDER_LINE_NUMBER	NUMBER	38	0		Representation of a sales order line used in communication with fulfillment systems
FULFILL_LINE_NUMBER	NUMBER	38	0		Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split
LINE_DISPLAY_LINE_NUMBER	VARCHAR2	128			Line number for display purposes. Corresponds to the line number on UI
FULFILL_DISPLAY_LINE_NUMBER	VARCHAR2	256			Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI
ORGANIZATION_ID	NUMBER	38	0		Indicates the identifier of the inventory organization	DW_INTERNAL_ORG_D	ORGANIZATION_ID
FULFILL_ORG_ID	NUMBER	38	0		Reference to the unique identifier for the fulfillment organization	DW_INTERNAL_ORG_D	ORGANIZATION_ID
BUSINESS_UNIT_ID	NUMBER	38	0		Business Unit ID	DW_BUSINESS_UNIT_D	BUSINESS_UNIT_ID
PROFIT_CENTER_BUSINESS_UNIT_ID	NUMBER	38	0		Reference to Unique Identifier of Profit Center Business Unit	DW_BUSINESS_UNIT_D	BUSINESS_UNIT_ID
ORGANIZATION_BU_ID	NUMBER	38	0		Inventory Business Unit ID	DW_BUSINESS_UNIT_D	BUSINESS_UNIT_ID
LEGAL_ENTITY_ID	NUMBER	38	0		Legal entity identifier	DW_LEGAL_ENTITY_D	LEGAL_ENTITY_ID
ORDER_TYPE_CODE	VARCHAR2	32			Name of the type of order that was placed	DW_ORDER_TYPE_LKP_TL	ORDER_TYPE_CODE
ORDER_STATUS_CODE	VARCHAR2	32			Status of the order	DW_OM_STATUS_D	STATUS_CODE
LINE_CATEGORY_CODE	VARCHAR2	32			Represents whether a sales order line belongs to a regular order or a return order	DW_ORDER_LINE_CATEGORY_LKP_TL	LINE_CATEGORY_CODE
LINE_TYPE_CODE	VARCHAR2	32			Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. Use DW_ORDER_LINE_TYPE_LKP_TL to resolve the lookup codes for order lines, and DW_ORDER_RETURN_TYPE_LKP_TL for return lines	DW_ORDER_LINE_TYPE_LKP_TL	LINE_TYPE_CODE
FULFILL_LINE_STATUS_CODE	VARCHAR2	32			Current fulfillment status of the fulfillment line	DW_OM_STATUS_D	STATUS_CODE
SOURCE_ORDER_NUMBER	VARCHAR2	64			Reference to the number of the originating sales order
SOURCE_ORDER_SYSTEM	VARCHAR2	64			Reference to the order capture system that the source order came from
SOURCE_ORDER_LINE_NUMBER	VARCHAR2	128			Reference to the number of the originating sales order line
SOURCE_DOCUMENT_TYPE_CODE	VARCHAR2	64			Indicates the Original Document document type on the order
PARENT_FULFILL_LINE_ID	NUMBER	38	0		Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line
ROOT_PARENT_FULFILL_LINE_ID	NUMBER	38	0		Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy
PARENT_LINE_ID	NUMBER	38	0		Parent Line Identifier
ROOT_PARENT_LINE_ID	NUMBER	38	0		Root Parent Line Identifier
COMP_SEQ_PATH	VARCHAR2	4000			Defines the hierarchical relation of a model. Derived from BOM table
INVENTORY_ITEM_ID	NUMBER	38	0		Reference to the unique identifier for the inventory item	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
ITEM_TYPE_CODE	VARCHAR2	32			Indicates a grouping of all items of a particular type that share the same set of item attributes	DW_ORDER_ITEM_TYPE_LKP_TL	ORDER_ITEM_TYPE_CODE
ITEM_SUBTYPE_CODE	VARCHAR2	32			More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC)	DW_ORDER_ITEM_SUBTYPE_LKP_TL	ORDER_ITEM_SUBTYPE_CODE
SALES_PRODUCT_TYPE_CODE	VARCHAR2	32			Identifies sales product type of product on the fulfillment line	DW_SALES_PRODUCT_TYPE_LKP_TL	SALES_PRODUCT_TYPE_CODE
PAYMENT_TERM_ID	NUMBER	38	0		Identifies the AR payment term associated with the Payment terms	DW_AR_PAYMENT_TERMS_D	PAYMENT_TERM_ID
PARENT_LINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of parent line
PARENT_FLINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of parent fulfill line
RP_LINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of root parent line
RP_FLINE_DISPLAY_LINE_NUM	VARCHAR2	128			Display line number of root parent fulfill line
CONFIGURED_ITEM_ID	NUMBER	38	0		Inventory item of shippable ATO configuration	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
ORIGINAL_INVENTORY_ITEM_ID	NUMBER	38	0		Reference to the unique identifier for the original inventory item that was populated on the fulfillment line from decomposition	DW_INVENTORY_ITEM_D	INVENTORY_ITEM_ID
BILL_TO_CUSTOMER_ACCOUNT_ID	NUMBER	38	0		Reference to the unique identifier for the bill-to customer	DW_CUSTOMER_ACCOUNT_D	CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID	NUMBER	38	0		Reference to the unique identifier for bill-to Party	DW_PARTY_D	PARTY_ID
SOLD_TO_PARTY_ID	NUMBER	38	0		Reference to the unique identifier for the sold-to Party.	DW_PARTY_D	PARTY_ID
SHIP_TO_PARTY_ID	NUMBER	38	0		Reference to the unique identifier for ship-to Party	DW_PARTY_D	PARTY_ID
LEDGER_ID	NUMBER	38	0		Primary ledger id	DW_LEDGER_D	LEDGER_ID
FISCAL_PERIOD_TYPE	VARCHAR2	16			Period type	DW_FISCAL_DAY_D	FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME	VARCHAR2	16			Period Set Name	DW_FISCAL_DAY_D	FISCAL_PERIOD_SET_NAME
ORDER_OPEN_FLAG	VARCHAR2	16			Indicates that the status of an order that is not closed or canceled
ORDER_ON_HOLD_FLAG	VARCHAR2	16			Indicates an order is not accepting further processing
FULFILL_LINE_OPEN_FLAG	VARCHAR2	16			Indicates that the status of a fulfillment line that is not closed or canceled
FULFILL_LINE_ON_HOLD_FLAG	VARCHAR2	16			Indicates fulfillment lines are not accepting further processing
SALES_AGREEMENT_FLAG	VARCHAR2	16			Indicated application of a Sales Agreement
ORDER_SUBMIT_DATE	DATE				The date and time of the submission of the order	DW_DAY_D	CALENDAR_DATE
ORDER_SUBMIT_TIMESTAMP	TIMESTAMP				The date and time of the submission of the order
ORDERED_DATE	DATE				Date when the items where ordered	DW_DAY_D	CALENDAR_DATE
ORDERED_TIMESTAMP	TIMESTAMP				Date when the items where ordered
SCHEDULE_SHIP_DATE	DATE				The current date the shipment is planned to ship on	DW_DAY_D	CALENDAR_DATE
SCHEDULE_SHIP_TIMESTAMP	TIMESTAMP				The current date the shipment is planned to ship on
PROMISE_SHIP_DATE	DATE				The date that was promised to the customer that the item would ship	DW_DAY_D	CALENDAR_DATE
PROMISE_SHIP_TIMESTAMP	TIMESTAMP				The date that was promised to the customer that the item would ship
REQUEST_SHIP_DATE	DATE				The original date the customer requested the item ship on	DW_DAY_D	CALENDAR_DATE
REQUEST_SHIP_TIMESTAMP	TIMESTAMP				The original date the customer requested the item ship on
ACTUAL_SHIP_DATE	DATE				The date the shipment was actually sent	DW_DAY_D	CALENDAR_DATE
ACTUAL_SHIP_TIMESTAMP	TIMESTAMP				The date the shipment was actually sent
SCHEDULE_ARRIVAL_DATE	DATE				The current date the shipment is planned to arrive on	DW_DAY_D	CALENDAR_DATE
SCHEDULE_ARRIVAL_TIMESTAMP	TIMESTAMP				The current date the shipment is planned to arrive on
PROMISE_ARRIVAL_DATE	DATE				The date that was promised to the customer that the item would arrive	DW_DAY_D	CALENDAR_DATE
PROMISE_ARRIVAL_TIMESTAMP	TIMESTAMP				The date that was promised to the customer that the item would arrive
REQUEST_ARRIVAL_DATE	DATE				The original date the customer requested the item arrive on	DW_DAY_D	CALENDAR_DATE
REQUEST_ARRIVAL_TIMESTAMP	TIMESTAMP				The original date the customer requested the item arrive on
FULFILLED_DATE	DATE				Date when the order line is fulfilled (Goods shipped, hardware installed etc.)	DW_DAY_D	CALENDAR_DATE
FULFILLED_TIMESTAMP	TIMESTAMP				Date when the order line is fulfilled (Goods shipped, hardware installed etc.)
FULFILL_LINE_CANCEL_DATE	DATE				Date on which customer requested cancellation on the fulfill line	DW_DAY_D	CALENDAR_DATE
FULFILL_LINE_CANCEL_TIMESTAMP	TIMESTAMP				Date on which customer requested cancellation on the fulfill line
ORDER_CANCELLED_FLAG	VARCHAR2	16			Indicates if the entire order has been cancelled or not
ORDER_CANCELLED_REASON_CODE	VARCHAR2	32			Reason for cancelation of order	DW_RETURN_REASON_LKP_TL	RETURN_REASON_CODE
FULFILL_LINE_CANCEL_FLAG	VARCHAR2	16			Indicates if the order fulfill line has been cancelled or not
RMA_RECEIPT_DATE	DATE				Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system	DW_DAY_D	CALENDAR_DATE
RMA_RECEIPT_TIMESTAMP	TIMESTAMP				Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system
ORIGINAL_ORDER_NUMBER	VARCHAR2	64			Corresponds to the original order number for which return is generated
SUBMITTED_BY	VARCHAR2	64			Order submitted by	DW_USER_D	USERNAME
CREATION_DATE	DATE				fulfill line creation date	DW_DAY_D	CALENDAR_DATE
CREATION_TIMESTAMP	TIMESTAMP				fulfill line creation date
ORDER_CREATION_DATE	DATE				order creation date	DW_DAY_D	CALENDAR_DATE
ORDER_CREATION_TIMESTAMP	TIMESTAMP				order creation date
CREATED_BY	VARCHAR2	64			Fulfill line created by	DW_USER_D	USERNAME
LAST_UPDATE_DATE	DATE				Fulfill line last update date	DW_DAY_D	CALENDAR_DATE
LAST_UPDATE_TIMESTAMP	TIMESTAMP				Fulfill line last update date
LAST_UPDATED_BY	VARCHAR2	64			Fulfill line last updated by	DW_USER_D	USERNAME

DW_OM_STATUS_D

List of all possible status codes that can be used in Distributed Order Orchestration.

Details

Module: Order Management

Key Columns

STATUS_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
STATUS_ID	NUMBER	38	0	True	Unique identifier of the status.
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
STATUS_CODE	VARCHAR2	32			Status code

DW_OM_STATUS_D_TL

This table stores Status codes used with in Order Orchestration.

Details

Module: Order Management

Key Columns

LANGUAGE, STATUS_ID

Columns

Name	Datatype	Length	Precision	Not Null	Comments
STATUS_ID	NUMBER	38	0	True	Reference to the unique identifier of the status
LANGUAGE	VARCHAR2	16		True	Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID	VARCHAR2	64			System Generated
DISPLAY_NAME	VARCHAR2	256			Process class that is displayed to user.

DW_ORDER_FULFILL_MODE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, FULFILLMENT_MODE_CODE

Columns

Name	Datatype	Length	Not Null	Comments
FULFILLMENT_MODE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ORDER_ITEM_SUBTYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, ORDER_ITEM_SUBTYPE_CODE

Columns

Name	Datatype	Length	Not Null	Comments
ORDER_ITEM_SUBTYPE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ORDER_ITEM_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, ORDER_ITEM_TYPE_CODE

Columns

Name	Datatype	Length	Not Null	Comments
ORDER_ITEM_TYPE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ORDER_LINE_CATEGORY_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, LINE_CATEGORY_CODE

Columns

Name	Datatype	Length	Not Null	Comments
LINE_CATEGORY_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ORDER_LINE_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, LINE_TYPE_CODE

Columns

Name	Datatype	Length	Not Null	Comments
LINE_TYPE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_ORDER_RETURN_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

ORDER_RETURN_TYPE_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
ORDER_RETURN_TYPE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	16	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	128		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128		Business name or value of the code.
DESCRIPTION	VARCHAR2	256		Code description.

DW_ORDER_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

ORDER_TYPE_CODE, LANGUAGE

Columns

Name	Datatype	Length	Not Null	Comments
ORDER_TYPE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_RETURN_REASON_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, RETURN_REASON_CODE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
RETURN_REASON_CODE	NUMBER	38	0	True	Code.
LANGUAGE	VARCHAR2	16		True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128			Business name or value of the code.
DESCRIPTION	VARCHAR2	256			Code description.

DW_SALES_PRODUCT_TYPE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, SALES_PRODUCT_TYPE_CODE

Columns

Name	Datatype	Length	Not Null	Comments
SALES_PRODUCT_TYPE_CODE	VARCHAR2	128	True	Code.
LANGUAGE	VARCHAR2	64	True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	512		Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	2048		Business name or value of the code.
DESCRIPTION	VARCHAR2	4000		Code description.

DW_SHIPMENT_PRIORITY_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, SHIPMENT_PRIORITY_CODE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
SHIPMENT_PRIORITY_CODE	NUMBER	38	0	True	Code.
LANGUAGE	VARCHAR2	16		True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128			Business name or value of the code.
DESCRIPTION	VARCHAR2	256			Code description.

DW_WSH_SERVICE_LEVEL_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

SERVICE_LEVEL_CODE, LANGUAGE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
SERVICE_LEVEL_CODE	NUMBER	38	0	True	Code.
LANGUAGE	VARCHAR2	16		True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128			Business name or value of the code.
DESCRIPTION	VARCHAR2	256			Code description.

DW_WSH_TRANSPORT_MODE_LKP_TL

This table contains information about code, name, and description.

Details

Module: Order Management

Key Columns

LANGUAGE, TRANSPORT_MODE_CODE

Columns

Name	Datatype	Length	Precision	Not Null	Comments
TRANSPORT_MODE_CODE	NUMBER	38	0	True	Code.
LANGUAGE	VARCHAR2	16		True	Translation language.
SOURCE_RECORD_ID	VARCHAR2	128			Source record identifier. Value is derived from a combination of code type and code.
NAME	VARCHAR2	128			Business name or value of the code.
DESCRIPTION	VARCHAR2	256			Code description.

Tables Without WHO Columns

All tables have two system date columns which can be used to get the last refresh dates.

These system date columns are:

W$_INSERT_DT - the timestamp when that particular record was inserted into that table.
W$_UPDATE_DT - the timestamp when that particular row was updated in that table.

Objects that don't have the WHO columns are the views based on the data warehouse tables. Views based on the data warehouse tables won't have any WHO columns because they aren't tables; instead they are views joining two or more underlying data warehouse tables.

The following views based on the data warehouse tables don't have the WHO columns:

DW_BUSINESS_UNIT_D
DW_DEPARTMENT_D
DW_INV_ORGANIZATION_D
DW_BUSINESS_UNIT_D_TL
DW_DEPARTMENT_D_TL
DW_INV_ORGANIZATION_D_TL
DW_PERSON_NAME_CURRENT_D