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 PO 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 PO 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 - invoices are created
CMR_PO_DISTRIBUTION_ID NUMBER 18 Yes Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
CMR_ROOT_RECEIVE_TXN_ID NUMBER 18 Internal Root Receiving Transaction Identifier for Match to Receipt Pos. For Match to PO POs it will be NULL
AP_INVOICE_DISTRIBUTION_TYPE VARCHAR2 25 Invoice Distribution Types - ACCRUAL, ERV,NONREC_TAX,TERV,TIPV,TRV
DELIVER_TO_INVENTORY_ORG_ID NUMBER 18 Inventory organization where the material is scheduled to be received
INVENTORY_ITEM_ID NUMBER 18 inventory item identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
MATCHING_BASIS VARCHAR2 30 Functionally it is OBSOLETE. Prior Rel10 - Possible values "QUANTITY" and "SERVICES"
PURCHASE_BASIS VARCHAR2 30 Identifies whether the PO line is for Goods or Services. Valid values are 'GOODS' and 'SERVICES'
AUTO_ACCRUAL_CLR_FLAG VARCHAR2 1 Auto accrual indicator flag - Y means accrual clearing transaction is performed.
AUTO_ACCRUAL_CLR_DATE TIMESTAMP Purchase order distribution auto accrual cleared date
INVOICE_ACCT_DATE TIMESTAMP invoice accounted date of purchase order distribution
RETRO_EVENT_DATE TIMESTAMP retro price event date of purchase order distribution.
PO_UNIT_VALUE NUMBER PO unit value - PO unit price or PO non recoverable tax for quantity based POs
PO_AMOUNT NUMBER For service or amount based POs, amount received or invoiced in ledger currency.
INVOICE_AMT NUMBER Purchase order distribution accounted invoice amount in ledger currency.
NET_DELIVERED_QTY NUMBER PO net delivered qty against this Po 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 Current batch processing invoices total amount
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 Invoice Number and it is always the latest invoice number on PO distribution
PO_NUMBER VARCHAR2 50 Purchase Order Document Number of PO distribution.
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 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 POs, amount received or invoiced in ledger currency, 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 POs, 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 POs, amount received or invoiced, 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_U1 Unique FUSION_TS_TX_DATA EXP_PO_DIST_COST_ID