Expense Purchase Order Distribution Costs

The Expense Purchase Order Distribution Costs view object contains the net delivered quantity and net invoiced quantity at the 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.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrExpPoDistCostsExtractPVO

Primary Keys : CmrExpPoDistCostsPEOExpPoDistCostId

Initial Extract Date : CmrExpPoDistCostsPEOCreationDate

Incremental Extract Date : CmrExpPoDistCostsPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CmrExpPoDistCostsPEOApInvoiceDistributionType	Value that identifies the invoice distribution type. Possible values include ACCRUAL, ERV, NONREC_TAX, TERV, TIPV, TRV, and so on.
CmrExpPoDistCostsPEOAutoAccrualClrDate	Value that identifies the purchase order distribution auto accrual cleared date.
CmrExpPoDistCostsPEOAutoAccrualClrFlag	Value that indicates the auto accrual flag. Y indicates that accrual clearing transaction is performed.
CmrExpPoDistCostsPEOBillToBusinessUnitId	Value that uniquely identifies the bill to business unit where the invoice is created.
CmrExpPoDistCostsPEOBusinessUnitId	Value that identifies the profit center business unit of the purchase order deliver transactions.
CmrExpPoDistCostsPEOCmrPoDistributionId	Value that identifies the entity in receipt accounting purchase order distributions. This value will exist for Match to PO and Match to Receipt cases.
CmrExpPoDistCostsPEOCmrRootReceiveTxnId	Value that identifies the internal root or first receiving transaction ID for match to receipt purchase orders. For match to PO purchase orders, this value would be null.
CmrExpPoDistCostsPEOCreatedBy	User who created the row.
CmrExpPoDistCostsPEOCreationDate	Date and time the row was created.
CmrExpPoDistCostsPEOCurrencyCode	Value that identifies purchase order ledger currency.
CmrExpPoDistCostsPEOCurrencyConversionDate	Date to be used to determine the exchange rates for currency conversions.
CmrExpPoDistCostsPEOCurrencyConversionRate	Value that identifies the optional user-specified currency conversion rate.
CmrExpPoDistCostsPEOCurrencyConversionType	Value that identifies the conversion type that should be used for currency conversions.
CmrExpPoDistCostsPEOCurrentRunExpAdjAmt	Value that identifies the current run accounted expense adjustment amount.
CmrExpPoDistCostsPEOCurrentRunExpAdjAmtEc	Value that identifies current run entered currency expense adjustment amount.
CmrExpPoDistCostsPEOCurrentRunInvoiceAmt	Value that identifies current batch processing invoices total amount.
CmrExpPoDistCostsPEODeliverToInventoryOrgId	Value that identifies the inventory organization where the material is scheduled to be received.
CmrExpPoDistCostsPEOEnteredCurrencyCode	Value that identifies the purchase order entered currency.
CmrExpPoDistCostsPEOExpPoDistCostId	Value that uniquely identifies the expense purchase order distribution ID. It's unique for each purchase order distribution and receipt.
CmrExpPoDistCostsPEOInclusiveFlag	Value that indicates if tax is inclusive on the tax lines.
CmrExpPoDistCostsPEOInventoryItemId	Value that identifies the inventory Item and maps to EGP_SYSTEM_ITEMS_B.inventory_item_id.
CmrExpPoDistCostsPEOInvoiceAcctDate	Date when the invoice of the purchase order distribution was accounted.
CmrExpPoDistCostsPEOInvoiceAmt	Value that identifies the purchase order distribution accounted invoice amount in ledger currency.
CmrExpPoDistCostsPEOInvoiceAmtEnteredCurr	Value that identifies the purchase order distribution accounted invoice amount in entered currency.
CmrExpPoDistCostsPEOInvoiceNumber	Value that identifies the most recent invoice number on the purchase order distribution.
CmrExpPoDistCostsPEOLastUpdateDate	Date and time the row was last updated.
CmrExpPoDistCostsPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CmrExpPoDistCostsPEOLastUpdatedBy	User who last updated the row.
CmrExpPoDistCostsPEONetDeliveredQty	Value that identifies the net delivered quantity on the purchase order against the purchase order distribution.
CmrExpPoDistCostsPEONetExpAdjAmt	Value that identifies the net expense adjustment accounted value in ledger currency.
CmrExpPoDistCostsPEONetExpAdjAmtEnteredCurr	Value that identifies the net expense adjustment accounted value in entered currency.
CmrExpPoDistCostsPEONetExpAdjAmtRounded	Value that identifies the net expense adjustment accounted value in ledger currency rounded to functional currency precision.
CmrExpPoDistCostsPEONetExpAdjAmtRoundedEc	Value that identifies the net expense adjustment value rounded to the entered currency precision in the entered currency.
CmrExpPoDistCostsPEONetInvoicedQty	Value that identifies the net invoiced quantity of the purchase order distribution.
CmrExpPoDistCostsPEOPoAmount	Value that identifies the amount received or invoiced in the ledger currency for a service or amount-based purchase order.
CmrExpPoDistCostsPEOPoAmountEnteredCurr	Value that identifies the amount received or invoiced in the entered currency for the service or amount-based purchase order.
CmrExpPoDistCostsPEOPoAmountRounded	Value that identifies the amount received or invoiced in the ledger currency and is rounded to the functional currency precision for the service or amount-based purchase order.
CmrExpPoDistCostsPEOPoAmountRoundedEc	Value that identifies the amount received or invoiced in the entered currency and is rounded to the entered currency precision for the service or amount-based purchase order.
CmrExpPoDistCostsPEOPoNumber	Value that identifies the purchase order document number of the PO distribution.
CmrExpPoDistCostsPEOPoUnitValue	Value that identifies the purchase order unit price or the purchase order nonrecoverable tax for a quantity based purchase order.
CmrExpPoDistCostsPEOPurchaseBasis	Value that identifies whether the purchase order line is for goods or services. Valid values include GOODS and SERVICES.
CmrExpPoDistCostsPEORetroEventDate	Value that identifies the retro price event date of the purchase order distribution.
CmrExpPoDistCostsPEORetroEventFlag	Value that identifies the retro price event change.
CmrExpPoDistCostsPEOSoldToBusinessUnitId	Value that identifies the profit center business unit of the purchase order deliver transactions.