Receipt Accounting Event Costs
The Receipt Accounting Event Costs view object contains cost details, including material, tax, and landed costs, for receipt transaction events.
Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvEventCostsExtractPVO
Primary Keys : CmrRcvEventCostsPEOEventCostId
Initial Extract Date : CmrRcvEventCostsPEOCreationDate
Incremental Extract Date : CmrRcvEventCostsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CmrRcvEventCostsPEOAccountingEventId | Value that identifies the accounting event and maps to CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID. |
CmrRcvEventCostsPEOAccrualClrId | Value that identifies the accrual clear ID that's used as foreign key to CMR_ACCRUAL_CLR_AMTS. |
CmrRcvEventCostsPEOChargeId | Value that identifies the charge ID of the landed cost charge. |
CmrRcvEventCostsPEOCmrApInvoiceDistId | Value that identifies the CMR accounts payable invoice distribution ID that's used as foreign key to CMR_AP_INVOICE_DTLS. |
CmrRcvEventCostsPEOCmrPoDistributionId | Value that identifies the purchase order distribution ID that's used as a foreign key to CMR_PURCHASE_ORDER_DTLS. |
CmrRcvEventCostsPEOCreatedBy | User who created the row. |
CmrRcvEventCostsPEOCreationDate | Date and time the row was created. |
CmrRcvEventCostsPEOCrossBuFlag | Value that indicates if it's a global or nonglobal purchase order. |
CmrRcvEventCostsPEOCurrencyCode | Value that identifies the accounting transaction's entered currency code. |
CmrRcvEventCostsPEOCurrencyConversionDate | Value that identifies the entered currency conversion date. |
CmrRcvEventCostsPEOCurrencyConversionRate | Value that identifies the entered currency conversion rate. |
CmrRcvEventCostsPEOCurrencyConversionType | Value that identifies the entered currency conversion type. |
CmrRcvEventCostsPEODestinationTypeCode | Value that identifies the destination type for the material. Valid values include Inventory and Expense. |
CmrRcvEventCostsPEOEventCostId | Value that identifies the surrogate key identifying accounting event cost ID. |
CmrRcvEventCostsPEOEventCostSource | Value that identifies the event cost source. Valid values include Transfer Price, Purchase Order, Landed Costs, Payables, and Transaction Taxes. |
CmrRcvEventCostsPEOEventCostSourceType | Value that identifies the event source type based on the event cost source values. |
CmrRcvEventCostsPEOEventPriorUnitCost | Value that identifies the prior unit cost of the same cost source document. |
CmrRcvEventCostsPEOEventUnitCost | Value that identifies the accounting transaction unit cost. |
CmrRcvEventCostsPEOInclusiveFlag | Value that identifies the inclusive tax line indicator used while transferring taxes to projects. Valid values are Y and N or Null. Y indicates inclusive tax and NULL or N indicates exclusive tax. |
CmrRcvEventCostsPEOInclusiveTax | Value that identifies the inclusive tax unit amount of the cost source document and is applicable for inclusive tax enabled documents. |
CmrRcvEventCostsPEOIntercompanyInvoicingFlag | Value that identifies whether the accounting event is intercompany enabled. |
CmrRcvEventCostsPEOLastUpdateDate | Date and time the row was last updated. |
CmrRcvEventCostsPEOLastUpdateLogin | Session login associated with the user who last updated the row. |
CmrRcvEventCostsPEOLastUpdatedBy | User who last updated the row. |
CmrRcvEventCostsPEOProcurementBuFlag | Value that indicates whether it's a procurement business. |
CmrRcvEventCostsPEORcvChargeActualId | Value that identifies the receiving charge actual ID used as a foreign key to CML_RCV_CHARGE_ACTUALS. |
CmrRcvEventCostsPEORcvChargeAllocId | Value that identifies the fiscal document freight charges and maps to CMF_RCV_CHARGE_ALLOCS. |
CmrRcvEventCostsPEORcvChargeEstimateId | Value that identifies the RCV charge estimate ID that's used as a foreign key to CML_RCV_CHARGE_ESTIMATES. |
CmrRcvEventCostsPEOSelfAssessedFlag | Value that indicates if the tax is self assessed. |
CmrRcvEventCostsPEOServiceLineTypePoFlag | Value that indicates if it's a service line type PO. |
CmrRcvEventCostsPEOTaxLiabilityFlag | Value that identifies the tax liability accounting line type on the transaction tax line. Valid values are Y, NULL, or N. If Y, then it's a tax Liability accounting line type. If NULL or N, then it's an ACCRUAL type. |
CmrRcvEventCostsPEOTradeEventAvgCostId | Value that identifies the trade event average cost ID that's used as a foreign key to CMR_TRADE_EVENT_AVG_COST. |
CmrRcvEventCostsPEOTradeEventCostId | Value that identifies the trade event cost ID that's used as a foreign key to CST_TRADE_EVENTS. |
CmrRcvEventCostsPEOTradeEventTaxId | Value that identifies the trade event tax ID that's used as a foreign key to CST_TRADE_EVENT_TAXES. |
CmrRcvEventCostsPEOTradeOverheadId | Value that identifies the trade overhead ID and maps to CMR_TRADE_OVERHEADS.TRADE_OVERHEAD_ID. |
CmrRcvEventCostsPEOTransactionTaxId | Value that identifies the foreign key reference to CMR_TRANSACTION_TAXES. |