Purchase Order Accrual Amounts Report

The Purchase Order Accrual Amounts Report view object contains purchase order accrual amount report information.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrPoAccrualAmtsRptExtractPVO

Primary Keys : CmrPoAccrualAmtsRptPEOCmrPoDistributionId, CmrPoAccrualAmtsRptPEOPeriodStartDate

Initial Extract Date : CmrPoAccrualAmtsRptPEOCreationDate

Incremental Extract Date : CmrPoAccrualAmtsRptPEOLastUpdateDate

Attributes

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

Name	Description
CmrPoAccrualAmtsRptPEOAccrualAccountId	Value that identifies the code combination of the accrual account.
CmrPoAccrualAmtsRptPEOAccrualAmt	Value that identifies the uninvoiced accrual amount of the purchase order distribution for a specific run.
CmrPoAccrualAmtsRptPEOAccrualQty	Value that identifies the uninvoiced accrual quantity of the purchase order distribution for a specific run.
CmrPoAccrualAmtsRptPEOBillToBuId	Value that identifies the business unit that will create the invoice for the purchase.
CmrPoAccrualAmtsRptPEOCategoryId	Value that identifies the purchasing category of the inventory item.
CmrPoAccrualAmtsRptPEOChargeAccountId	Value that identifies the code combination of the charge account.
CmrPoAccrualAmtsRptPEOCmrPoDistributionId	Value that identifies the internal identifier of the purchase order distribution.
CmrPoAccrualAmtsRptPEOCreatedBy	User who created the row.
CmrPoAccrualAmtsRptPEOCreationDate	Date and time the row was created.
CmrPoAccrualAmtsRptPEOCurrencyCode	Value that identifies the currency of the purchase order price.
CmrPoAccrualAmtsRptPEOCurrencyConversionDate	Date used to determine the exchange rates for currency conversion.
CmrPoAccrualAmtsRptPEOCurrencyConversionRate	Value that identifies the optional user specified currency conversion rate.
CmrPoAccrualAmtsRptPEOCurrencyConversionType	Value that identifies the conversion type used for currency conversion.
CmrPoAccrualAmtsRptPEODistributionNumber	Value that identifies the user specified number for purchase order distributions.
CmrPoAccrualAmtsRptPEOFuncCurrencyCode	Value that identifies the general ledger currency code.
CmrPoAccrualAmtsRptPEOInventoryItemId	Value that identifies the inventory item and references EGP_SYSTEM_ITEMS_B.inventory_item_id.
CmrPoAccrualAmtsRptPEOInventoryOrgId	Value that identifies the inventory organization where the material is scheduled for receiving.
CmrPoAccrualAmtsRptPEOInvoiceAmtFuncCurr	Value that identifies the amount on the invoice distribution.
CmrPoAccrualAmtsRptPEOInvoiceVarianceAmt	Value that identifies the invoice quantity in the unit of measure code.
CmrPoAccrualAmtsRptPEOInvoicedAmt	Value that identifies the amount on the invoice distribution in functional currency.
CmrPoAccrualAmtsRptPEOInvoicedQty	Value that identifies the invoice variance amount on the invoice distribution in functional currency.
CmrPoAccrualAmtsRptPEOItemDescription	Description for the item.
CmrPoAccrualAmtsRptPEOLastUpdateDate	User who last updated the row.
CmrPoAccrualAmtsRptPEOLastUpdateLogin	Date and time the row was most recently updated.
CmrPoAccrualAmtsRptPEOLastUpdatedBy	Session login associated to the user who last updated the row.
CmrPoAccrualAmtsRptPEOLineNumber	Value that identifies the user specified number for the purchase order line.
CmrPoAccrualAmtsRptPEOLineType	Value that identifies whether the PO line is for goods or services. Valid values are GOODS and SERVICES.
CmrPoAccrualAmtsRptPEOPeriodEndDate	Date when the accounting period ends.
CmrPoAccrualAmtsRptPEOPeriodStartDate	Date when the accounting period begins.
CmrPoAccrualAmtsRptPEOPoAmount	Value that identifies the amount ordered for the service based purchase order distribution.
CmrPoAccrualAmtsRptPEOPoNumber	Value that identifies the user specified number for the purchase order.
CmrPoAccrualAmtsRptPEOPoPrice	Value that identifies the purchase price per unit as specified by the buyer on the purchase order.
CmrPoAccrualAmtsRptPEOPoQuantity	Value that identifies the quantity of the material ordered for this distribution.
CmrPoAccrualAmtsRptPEOPrimaryLedgerId	Value that identifies the primary Ledger for the bill to business unit.
CmrPoAccrualAmtsRptPEOReceivedAmt	Value that identifies the transaction amount for service line items.
CmrPoAccrualAmtsRptPEOReceivedQty	Value that identifies the received transaction quantity.
CmrPoAccrualAmtsRptPEOShipmentNumber	Value that identifies a user specified number for the purchase order shipment.
CmrPoAccrualAmtsRptPEOUomCode	Value that identifies the unit of measure for the purchase order quantity.
CmrPoAccrualAmtsRptPEOVendorId	Value that identifies the supplier and references PO_VENDORS.vendor_id.
CmrPoAccrualAmtsRptPEOVendorSiteId	Value that identifies the supplier site and references PO_VENDOR_SITES_ALL.vendor_site_id.