DW_CMR_EVENTS_CF (Preview)

This table requires activation of Receipt Accounting functional area. This fact table stores Receipt Accounting Event details

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     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 DW_PARTY_D SUPPLIER_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    

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.

Copyright © 2019, 2023, Oracle and/or its affiliates.