1. Tables and Views for SCM
  2. CMR_EXP_PO_DIST_COSTS

CMR_EXP_PO_DIST_COSTS

This table stores the net delivered quantity and net invoiced quantity at purchase order distribution level for matched to invoice cases. For matched to receipt cases, it stores the net delivered quantity and net invoiced quantity at invoice distribution and receipt transaction level.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMR_EXP_PO_DIST_COSTS_PK

EXP_PO_DIST_COST_ID

Columns

Name Datatype Length Precision Not-null Comments
EXP_PO_DIST_COST_ID NUMBER 18 Yes This is surrogate key column and unique for each purchase order distribution and receipt.
SOLD_TO_BUSINESS_UNIT_ID NUMBER 18 R9: Profit center business unit identifier of purchase order deliver transactions. Pre R9 - business unit identifier where accrual is accounted.
BUSINESS_UNIT_ID NUMBER 18 Yes Profit center business unit identifier of purchase order deliver transactions.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to business unit identifier where invoices are created.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Yes Identifies entity in receipt accounting purchase order distributions. This value will exist for match to purchase order as well as match to receipt cases.
CMR_ROOT_RECEIVE_TXN_ID NUMBER 18 Internal root receiving transaction identifier for match to receipt purchase orders. For match to purchase orders it is null.
AP_INVOICE_DISTRIBUTION_TYPE VARCHAR2 25 Invoice distribution type indicates the accounted amount is accrual, tax or variances.
DELIVER_TO_INVENTORY_ORG_ID NUMBER 18 Inventory organization identifier where the material is scheduled to be received.
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier which is present on the purchase order line.
MATCHING_BASIS VARCHAR2 30 Functionally it is obsolete. Prior rel10 - possible values are "QUANTITY" and "SERVICES".
PURCHASE_BASIS VARCHAR2 30 Identifies whether the purchase order line is for goods or services. Valid values are "GOODS" and "SERVICES".
AUTO_ACCRUAL_CLR_FLAG VARCHAR2 1 This flag indicates that the transaction clearing happened using auto accrual clearing process.
AUTO_ACCRUAL_CLR_DATE TIMESTAMP Indicates the auto accrual clearing performed date.
INVOICE_ACCT_DATE TIMESTAMP Invoice accounted date of the purchase order distribution.
RETRO_EVENT_DATE TIMESTAMP Retro price event date of the purchase order distribution.
PO_UNIT_VALUE NUMBER Purchase order unit price or non-recoverable tax for quantity based purchase orders.
PO_AMOUNT NUMBER For service or amount based purchase orders, amount received or invoiced in ledger currency.
INVOICE_AMT NUMBER Purchase order distribution accounted invoice amount in ledger currency.
NET_DELIVERED_QTY NUMBER Purchase order net delivered quantity against this purchase order distribution.
NET_INVOICED_QTY NUMBER Net invoiced quantity of purchase order distribution.
CURRENT_RUN_EXP_ADJ_AMT NUMBER This stores the current run accounted expense adjustment amount.
CURRENT_RUN_EXP_ADJ_AMT_EC NUMBER This stores the current run entered currency expense adjustment amount.
CURRENT_RUN_INVOICE_AMT NUMBER This stores the total invoices amount for the current batch that is being processed.
NET_EXP_ADJ_AMT NUMBER Net expense adjustment accounted value in ledger currency.
RETRO_EVENT_FLAG VARCHAR2 1 Indicates if there is a retro price event change. This is passed to projects.
INVOICE_NUMBER VARCHAR2 50 This column display the latest invoice number of the purchase order distribution.
PO_NUMBER VARCHAR2 50 User specified purchase order document number.
CURRENCY_CODE VARCHAR2 15 Indicates the purchase order ledger currency.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_RATE NUMBER Optional user specified currency conversion rate.
CURRENCY_CONVERSION_DATE TIMESTAMP The date to be used to determine the exchange rates for currency conversion.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
INCLUSIVE_FLAG VARCHAR2 1 Tax inclusive flag on tax lines to calculate the tax exclusive price.
NET_EXP_ADJ_AMT_ROUNDED NUMBER Net expense adjustment amount in ledger currency rounded to functional currency precision.
PO_AMOUNT_ROUNDED NUMBER For service or amount based purchase orders, amount received or invoiced in ledger currency which is rounded to functional currency precision.
INVOICE_AMT_ENTERED_CURR NUMBER Purchase order distribution accounted invoice amount in entered currency.
PO_AMOUNT_ENTERED_CURR NUMBER For service or amount based purchase orders, amount received or invoiced in entered currency.
NET_EXP_ADJ_AMT_ENTERED_CURR NUMBER Net expense adjustment accounted value in entered currency.
ENTERED_CURRENCY_CODE VARCHAR2 15 Indicates the purchase order entered currency.
PO_AMOUNT_ROUNDED_EC NUMBER For service or amount based purchase orders, amount received or invoiced which is rounded to entered currency precision in entered currency.
NET_EXP_ADJ_AMT_ROUNDED_EC NUMBER Net expense adjustment amount rounded to entered currency precision in entered currency.

Foreign Keys

Table Foreign Table Foreign Key Column
CMR_EXP_PO_DIST_COSTS cst_aid_type_cost_comp_map AP_INVOICE_DISTRIBUTION_TYPE

Indexes

Index Uniqueness Tablespace Columns
CMR_EXP_PO_DIST_COSTS_N1 Non Unique FUSION_TS_TX_DATA BUSINESS_UNIT_ID, CMR_PO_DISTRIBUTION_ID, CMR_ROOT_RECEIVE_TXN_ID
CMR_EXP_PO_DIST_COSTS_N2 Non Unique DEFAULT CMR_PO_DISTRIBUTION_ID
CMR_EXP_PO_DIST_COSTS_U1 Unique FUSION_TS_TX_DATA EXP_PO_DIST_COST_ID