DW_CMR_DISTRIBUTIONS_CF (Preview)

This table requires activation of Procurement Receipt Accounting functional area. This fact table stores Receipt Accounting Distribution details for PO source

Details

Module: Purchasing

Key Columns

DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DISTRIBUTION_ID NUMBER 38 0 True Receipt accounting distribution identifier
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 256 Receipt accounting distribution identifier
DISTRIBUTION_ACCOUNTING_EVENT_ID NUMBER 38 0 Receipt accounting event identifier
DISTRIBUTION_ACCOUNTING_LINE_TYPE VARCHAR2 64 Distribution accounting line type #1 DW_XLA_ACCNT_LINE_TYPES_LKP_TL ACCOUNTING_LINE_CODE
DISTRIBUTION_CREATED_BY VARCHAR2 128 Indicates the user who created the row. DW_USER_D USERNAME
DISTRIBUTION_CREATION_DATE DATE Distribution creation date without timestamp DW_DAY_D CALENDAR_DATE
DISTRIBUTION_CREATION_TIMESTAMP TIMESTAMP Distribution creation date with timestamp
DISTRIBUTION_LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated the row. DW_USER_D USERNAME
DISTRIBUTION_LAST_UPDATE_DATE DATE Distribution last update date without timestamp DW_DAY_D CALENDAR_DATE
DISTRIBUTION_LAST_UPDATE_TIMESTAMP TIMESTAMP Distribution last update date with timestamp
DISTRIBUTION_ENTERED_CURRENCY_CODE VARCHAR2 16 Entered currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
DISTRIBUTION_ENTERED_CURRENCY_AMOUNT NUMBER Distribution amount in entered currency
DISTRIBUTION_LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
DISTRIBUTION_LEDGER_AMOUNT NUMBER Distribution amount in ledger currency
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE NUMBER Ledger Currency to Global Currency Exchange Rate
DISTRIBUTION_GLOBAL_AMOUNT NUMBER Distribution amount in global currency
EVENT_TXN_TABLE_NAME VARCHAR2 32 Stores transaction event creation source transaction table name.
EVENT_SOURCE VARCHAR2 32 Receipt accounting event source DW_ORA_CMR_DOC_FLOW_TYPES_LKP_TL ORA_CMR_DOC_FLOW_TYPES_CODE
PO_HEADER_ID NUMBER 38 0 Purchase order header identifier of source PO
SOURCE_DOC_NUMBER VARCHAR2 64 Source document number
PO_LINE_ID NUMBER 38 0 Purchase order line identifier
SOURCE_DOC_LINE_NUMBER VARCHAR2 64 Source document line number
PO_LINE_LOCATION_ID NUMBER 38 0 Purchase order schedule identifier
PO_SCHEDULE_NUMBER VARCHAR2 64 Purchase order schedule number
PO_DISTRIBUTION_ID NUMBER 38 0 Purchase order distribution identifier
PO_DISTRIBUTION_NUMBER VARCHAR2 64 Purchase order distribution number
CMR_PO_DISTRIBUTION_ID NUMBER 38 0 Identifier for Receipt accounting PO Distributions
CMR_RCV_TRANSACTION_ID NUMBER 38 0 Identifier for the Receipt accounting receiving transaction.
RCV_TRANSACTION_ID NUMBER 38 0 Receiving transaction identifier
RECEIPT_NUMBER VARCHAR2 64 Receipt Number
RECEIPT_LINE_NUMBER NUMBER 38 0 Receipt Line Number
RECEIPT_CREATION_DATE DATE Receipt creation date DW_DAY_D CALENDAR_DATE
PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 38 0 Profit Center Business Unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
BILL_TO_BUSINESS_UNIT_ID NUMBER 38 0 Bill to Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEDGER_ID NUMBER 38 0 Ledger identifier DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Fiscal period set name #3 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Fiscal period type #3 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
INVENTORY_ORG_ID NUMBER 38 0 Inventory organization id where the item is stored #4 DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0 Inventory item identifier, it will be null for description based item #4 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ITEM_DESCRIPTION VARCHAR2 256 Item description.
TRANSACTION_DATE DATE Transaction date DW_DAY_D CALENDAR_DATE
TRANSACTION_TYPE_ID NUMBER 38 0 Transaction Type Identifier DW_CMR_TRANSACTION_TYPES_TL TRANSACTION_TYPE_ID
TRANSACTION_TYPE_CODE VARCHAR2 64 Transaction Type Code
DESTINATION_TYPE_CODE VARCHAR2 32 Identifies type of destination for the material: Inventory, Expense DW_DESTINATION_TYPE_LKP_TL DESTINATION_TYPE_CODE
VENDOR_ID NUMBER 38 0 Identifies the Supplier #6 DW_PARTY_D SUPPLIER_ID
VENDOR_PARTY_ID NUMBER 38 0 Identifies the Supplier Party #6 DW_PARTY_D PARTY_ID
VENDOR_SITE_ID NUMBER 38 0 Identifies the Supplier site DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
SHIP_TO_LOCATION_ID NUMBER 38 0 The identifier of the specific location that the goods are being shipped to. DW_WORKER_LOCATION_D LOCATION_ID
EVENT_TYPE_CODE VARCHAR2 64 Event type code #2 DW_XLA_EVENT_TYPES_LKP_TL EVENT_TYPE_CODE
EVENT_CLASS_CODE VARCHAR2 32 Event class code #5 DW_XLA_EVENT_CLASSES_LKP_TL EVENT_CLASS_CODE
ENTITY_CODE VARCHAR2 32 Entity code #5 DW_XLA_EVENT_CLASSES_LKP_TL ENTITY_CODE
CMR_AP_INVOICE_DIST_ID NUMBER 38 0 CMR AP Invoice Distribution Identifier
AP_INVOICE_DIST_ID NUMBER 38 0 Payables invoice distribution identifier
AP_INVOICE_ID NUMBER 38 0 Invoice identifier
AP_INVOICE_NUMBER VARCHAR2 64 Invoice number
AP_INVOICE_LINE_NUMBER VARCHAR2 64 Invoice line number
PJC_PROJECT_ID NUMBER 38 0 Project Identifier DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0 Project task identifier DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0 Project expenditure type identifier DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE DATE Project expenditure date DW_DAY_D CALENDAR_DATE
PJC_ORGANIZATION_ID NUMBER 38 0 Project expenditure organization DW_INTERNAL_ORG_D ORGANIZATION_ID
DEFAULT_ACCRUAL_ACCOUNT_ID NUMBER 38 0 Code Combination Identifier of the Default Accrual Account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
DEFAULT_ACCRUAL_ACCOUNT_GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT1_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT1_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT2_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT2_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT3_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT3_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT4_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT4_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT5_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT5_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT6_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT6_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT7_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT7_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT8_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT8_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT9_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT9_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT10_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT10_D GL_SEGMENT_VALUESET_CODE

Notes

#1 Apart from DISTRIBUTION_ACCOUNTING_LINE_TYPE the join with DW_XLA_ACCNT_LINE_TYPES_LKP_TL should also be done on ENTITY_CODE and EVENT_CLASS_CODE and DW_XLA_ACCNT_LINE_TYPES_LKP_TL.APPLICATION_ID=10096 and ACCOUNTING_LINE_TYPE_CODE='S'. #2 Apart from EVENT_TYPE_CODE the join with DW_XLA_EVENT_TYPES_LKP_TL should also be done on EVENT_CLASS_CODE and ENTITY_CODE and DW_XLA_EVENT_TYPES_LKP_TL.APPLICATION_ID=10096. #3 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 TRANSACTION_DATE column. #4 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORG_ID. #5 Apart from the join conditions for DW_XLA_EVENT_CLASSES_LKP_TL also condition DW_XLA_EVENT_CLASSES_LKP_TL.APPLICATION_ID=10096 should be added. #6 Depending on the association(Vendor or Vendor party), any one of the 2 joins with party dimension can be picked.