DW_CMR_EVENTS_CF (Preview)

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

Details

Module: Purchasing

Key Columns

ACCOUNTING_EVENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCOUNTING_EVENT_ID NUMBER 38 0 True Receipt accounting event identifier
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 256 Receipt accounting event identifier
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 #2 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Fiscal period type #2 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 #3 DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0 Inventory item identifier, it will be null for description based item #3 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
TRANSACTION_STATUS_CODE VARCHAR2 16 Indicator flag if event is accounted or not DW_CMR_ACCOUNTED_FLAG_LKP_TL CMR_ACCOUNTED_FLAG_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 #5 DW_PARTY_D SUPPLIER_ID
VENDOR_PARTY_ID NUMBER 38 0 Identifies the Supplier Party #5 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 #1 DW_XLA_EVENT_TYPES_LKP_TL EVENT_TYPE_CODE
EVENT_CLASS_CODE VARCHAR2 32 Event class code #4 DW_XLA_EVENT_CLASSES_LKP_TL EVENT_CLASS_CODE
ENTITY_CODE VARCHAR2 32 Entity code #4 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
CREATED_BY VARCHAR2 64 Indicates the user who created the row. DW_USER_D USERNAME
CREATION_DATE DATE Creation date of the event, without timestamp DW_DAY_D CALENDAR_DATE
CREATION_TIMESTAMP TIMESTAMP Creation date with timestamp
LAST_UPDATED_BY VARCHAR2 64 Indicates the user who last updated the row. DW_USER_D USERNAME
LAST_UPDATE_DATE DATE Last update date without timestamp DW_DAY_D CALENDAR_DATE
LAST_UPDATE_TIMESTAMP TIMESTAMP Last update date, with timestamp
SOURCE_DOC_UOM_CODE VARCHAR2 32 Source document UOM code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SOURCE_DOC_QTY NUMBER Transaction quantity in source document UOM
TRANSACTION_UOM_CODE VARCHAR2 32 Transaction UOM code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
TRANSACTION_QTY NUMBER Transaction quantity in transaction UOM
PRIMARY_UOM_CODE VARCHAR2 32 Primary UOM code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PRIMARY_QTY NUMBER Transaction quantity in Primary UOM
SECONDARY_UOM_CODE VARCHAR2 32 Secondary UOM code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SECONDARY_TRANSACTION_QTY NUMBER Transaction quantity in secondary UOM
GL_DATE DATE Accounted date. This can be the same as transaction date, or any general ledger open / future period start date. DW_DAY_D CALENDAR_DATE
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 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. #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 TRANSACTION_DATE column. #3 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORG_ID. #4 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. #5 Depending on the association(Vendor or Vendor party), any one of the 2 joins with party dimension can be picked.