Receipt Accounting Purchase Order Details
The Receipt Accounting Purchase Order Details view object contains purchase order details interfaced to receipt accounting.
Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrPurchaseOrderDtlsExtractPVO
Primary Keys : CmrPurchaseOrderDtlsPEOExternalSystemRefId, CmrPurchaseOrderDtlsPEOExternalSystemReference, CmrPurchaseOrderDtlsPEOEventDate
Initial Extract Date : CmrPurchaseOrderDtlsPEOCreationDate
Incremental Extract Date : CmrPurchaseOrderDtlsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CmrPurchaseOrderDtlsPEOAccrualAccountId | Value that identifies the code combination identifier of the accrual account. |
| CmrPurchaseOrderDtlsPEOAccrueOnReceiptFlag | Value that indicates whether the accrual should be done on receipt or at the end of the period. |
| CmrPurchaseOrderDtlsPEOActiveFlag | Value that indicates whether there is more recent information for this distribution. Only the most recent record will have this option set to Y. |
| CmrPurchaseOrderDtlsPEOActiveForCaFlag | Value used by the PO interface processor to help the acquisition cost processor keep track of the latest record for the distribution. |
| CmrPurchaseOrderDtlsPEOAgentId | Value that uniquely identifies the person of the buyer. |
| CmrPurchaseOrderDtlsPEOAmountCancelled | Value that identifies the amount canceled for this distribution. |
| CmrPurchaseOrderDtlsPEOAmountOrdered | Value that identifies the amount ordered for the service based purchase order distribution. |
| CmrPurchaseOrderDtlsPEOBillToBusinessUnitId | Value that identifies the business unit that will create the invoice for the purchase. |
| CmrPurchaseOrderDtlsPEOBillToLocationId | Value that identifies the specific location that will create the invoice for the purchase. |
| CmrPurchaseOrderDtlsPEOCategoryId | Value that identifies the purchasing category that the inventory item belongs to. |
| CmrPurchaseOrderDtlsPEOChargeAccountId | Value that identifies the code combination ID of the charge account. |
| CmrPurchaseOrderDtlsPEOCmrPoDistributionId | Value that identifies the internal ID of the purchase order distribution. |
| CmrPurchaseOrderDtlsPEOCmrPoLineLocationId | Value that identifies the internal ID of the purchase order schedule. |
| CmrPurchaseOrderDtlsPEOConsignedFlag | Value that indicates whether the item will be purchased under a consignment arrangement from the supplier. |
| CmrPurchaseOrderDtlsPEOConvFactorToPrimaryUom | Value that identifies the factor to be multiplied with the PO quantity to convert it into the primary unit of measure of the item, as defined in the deliver to inventory organization. |
| CmrPurchaseOrderDtlsPEOCountryOfOriginCode | Value that identifies the code for the country of manufacture. |
| CmrPurchaseOrderDtlsPEOCreatedBy | User who created the row. |
| CmrPurchaseOrderDtlsPEOCreationDate | Date and time the row was created. |
| CmrPurchaseOrderDtlsPEOCurrencyCode | Value that identifies the currency of the price. |
| CmrPurchaseOrderDtlsPEOCurrencyConversionDate | Date to be used to determine the exchange rates for currency conversion. |
| CmrPurchaseOrderDtlsPEOCurrencyConversionRate | Value that identifies the optional user specified currency conversion rate. |
| CmrPurchaseOrderDtlsPEOCurrencyConversionType | Value that identifies the conversion type that should be used for currency conversion. |
| CmrPurchaseOrderDtlsPEODefaultInventoryOrgId | Value that identifies the default inventory organization for the PO. This is used along with the inventory_item_id at the PO line level to get item information from the product data hub. |
| CmrPurchaseOrderDtlsPEODeliverToBuFuncCurrCode | Value that identifies the functional currency of the deliver to business unit. |
| CmrPurchaseOrderDtlsPEODeliverToBusinessUnitId | Value that identifies the business unit of the inventory organization. |
| CmrPurchaseOrderDtlsPEODeliverToInventoryOrgId | Value that identifies the inventory organization where the material is scheduled to be received. |
| CmrPurchaseOrderDtlsPEODestinationChargeAccountId | Value that identifies the code combination ID of the destination charge account. |
| CmrPurchaseOrderDtlsPEODestinationTypeCode | Value that identifies the destination type for the material. |
| CmrPurchaseOrderDtlsPEODestinationVarianceAcctId | Value that identifies the destination variance account. |
| CmrPurchaseOrderDtlsPEODistributionNumber | Value that identifies the user specified number for the purchase order distribution. |
| CmrPurchaseOrderDtlsPEOEventDate | Date when the event in the EVENT_TYPE happened. |
| CmrPurchaseOrderDtlsPEOEventType | Can be one of the following event types: PO Approval, Retroactive Price Update, Quantity Cancellation, PO Close. |
| CmrPurchaseOrderDtlsPEOExternalSystemRefId | Value that identifies the purchase order distribution line in the source system. |
| CmrPurchaseOrderDtlsPEOExternalSystemReference | Value that identifies the source system that owns the purchase order entity. |
| CmrPurchaseOrderDtlsPEOFobLookupCode | Value that indicates the type of free-on-board terms for the document. References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE as FOB. |
| CmrPurchaseOrderDtlsPEOIntendedUse | Value that identifies the intended use for which a product is likely to be used in the business by the purchaser. |
| CmrPurchaseOrderDtlsPEOInventoryItemId | Value that identifies the inventory Item ID and references EGP_SYSTEM_ITEMS_B.inventory_item_id. |
| CmrPurchaseOrderDtlsPEOItemDescription | Description for the item. |
| CmrPurchaseOrderDtlsPEOLastRunPeriodId | Value that identifies the period for which the period end accrual process was last run for this distribution. |
| CmrPurchaseOrderDtlsPEOLastUpdateDate | Date and time the row was most recently updated. |
| CmrPurchaseOrderDtlsPEOLastUpdateLogin | Session login associated with the user who last updated the row. |
| CmrPurchaseOrderDtlsPEOLastUpdatedBy | User who last updated the row. |
| CmrPurchaseOrderDtlsPEOLeTimezoneCode | Value that identifies the time zone code of the legal entity. |
| CmrPurchaseOrderDtlsPEOLineNumber | Value that identifies the user specified number for the purchase order line. |
| CmrPurchaseOrderDtlsPEOMatchOption | Value that indicates whether the invoice match should happen at the purchase order or the receipt. |
| CmrPurchaseOrderDtlsPEONeedByDate | Value that identifies the need-by date for the shipment schedule. |
| CmrPurchaseOrderDtlsPEONonrecoverableInclusiveTax | Value that identifies the portion of taxes paid that's included in the distribution ordered amount and is nonrecoverable. |
| CmrPurchaseOrderDtlsPEONonrecoverableTax | Value that identifies the nonrecoverable tax per unit amount. |
| CmrPurchaseOrderDtlsPEONrTaxInPrimaryUom | Value that identifies the nonrecoverable tax as calculated per the primary unit of the item as defined in the deliver to inventory organization. |
| CmrPurchaseOrderDtlsPEOOrchestrationOrderFlag | Value that indicates if this is an orchestrated purchase order. |
| CmrPurchaseOrderDtlsPEOPaymentType | For complex service POs, the payment type will be either RATE or LUMPSUM. For normal service POs, this value will be null. |
| CmrPurchaseOrderDtlsPEOPeriodEndAccruedFlag | Value that indicates whether this distribution has been picked up by the period end accrual process. |
| CmrPurchaseOrderDtlsPEOPoHeaderId | Value that identifies the purchase order header. |
| CmrPurchaseOrderDtlsPEOPoLineId | Value that identifies the purchase order line and references to table PO_LINES_ALL.PO_LINE_ID. |
| CmrPurchaseOrderDtlsPEOPoLineLocationId | Value that identifies the purchase order shipment schedule. |
| CmrPurchaseOrderDtlsPEOPoNumber | Value that identifies the user specified number for the purchase order. |
| CmrPurchaseOrderDtlsPEOPoPurchaseBasis | Value that identifies whether the PO line is for goods or services. |
| CmrPurchaseOrderDtlsPEOPrice | Value that identifies the purchase price per unit as specified by the buyer on the purchase order. |
| CmrPurchaseOrderDtlsPEOPriceInPrimaryUom | Value that identifies the price calculated per the primary unit of the item as defined in the deliver to inventory organization. |
| CmrPurchaseOrderDtlsPEOProcessedByCaFlag | Value that indicates whether the distribution was picked up by the cost accounting processor. |
| CmrPurchaseOrderDtlsPEOProcessedByRaFlag | Value that indicates if the distribution was picked up by the receipt accounting processor. |
| CmrPurchaseOrderDtlsPEOProcurementBusinessUnitId | Value that identifies the business unit that created the purchase order. |
| CmrPurchaseOrderDtlsPEOProductFiscalClassification | Value that identifies the product fiscal classification. It's based on the inventory item category. |
| CmrPurchaseOrderDtlsPEOPromisedDate | Value that identifies the supplier promised delivery date. |
| CmrPurchaseOrderDtlsPEOPurchaseBasis | Value that identifies whether the PO line is for goods or services. |
| CmrPurchaseOrderDtlsPEOQuantityCancelled | Value that identifies the quantity canceled for this distribution. |
| CmrPurchaseOrderDtlsPEOQuantityOrdered | Value that identifies the quantity of the material ordered for this distribution. |
| CmrPurchaseOrderDtlsPEORecoverableInclusiveTax | Value that identifies the portion of taxes paid that's included in the distribution ordered amount and is recoverable. |
| CmrPurchaseOrderDtlsPEORecoverableTax | Value that identifies the recoverable tax per unit amount and is excluded in the distribution ordered amount. |
| CmrPurchaseOrderDtlsPEORequisitioningBuId | Value that identifies the business unit of the inventory organization. |
| CmrPurchaseOrderDtlsPEOScheduleStatus | Value that indicates the schedule status. |
| CmrPurchaseOrderDtlsPEOSecondaryQtyCancelled | Value that identifies the quantity canceled in the secondary unit of measure. |
| CmrPurchaseOrderDtlsPEOSecondaryQuantity | Value that identifies the quantity ordered in the secondary unit of measure. |
| CmrPurchaseOrderDtlsPEOSecondaryUomCode | Value that identifies the secondary unit of measure code of item |
| CmrPurchaseOrderDtlsPEOSfoPrimaryTradeRelationId | Value that identifies the primary trade relationship of an orchestration agreement line. |
| CmrPurchaseOrderDtlsPEOShipToLocationId | Value that identifies the specific location that the goods are being shipped to. |
| CmrPurchaseOrderDtlsPEOShipmentNumber | Value that identifies the user specified number for the purchase order shipment. |
| CmrPurchaseOrderDtlsPEOSoldToLegalEntityId | Value that identifies the legal entity where the accrual will be performed for the purchase. |
| CmrPurchaseOrderDtlsPEOStatusUpdateDate | Value that indicates the date when the PO schedule status changed. |
| CmrPurchaseOrderDtlsPEOSupplierItem | Value that identifies the supplier item number on the document. |
| CmrPurchaseOrderDtlsPEOTaxExclusivePrice | Value that identifies the PO line price exclusive of all taxes. |
| CmrPurchaseOrderDtlsPEOTradeOrgBuFuncCurrCode | Value that identifies the functional currency of the trade organization business unit. |
| CmrPurchaseOrderDtlsPEOTradeOrgProfitCenterBuId | Value that identifies the profit center business unit of the trade organization for global procurement orders. |
| CmrPurchaseOrderDtlsPEOTradeOrganizationId | Value that identifies the inventory organization where the trade buy-sell transactions defined by orchestration agreement are accounted. |
| CmrPurchaseOrderDtlsPEOUomCode | Value that identifies the unit of measure for the quantity. |
| CmrPurchaseOrderDtlsPEOUseForGpFlag | Value that indicates whether this record should be used for global procurement scenarios by overriding the ACTIVE_FLAG. |
| CmrPurchaseOrderDtlsPEOVarianceAccountId | Value that identifies the variance account. |
| CmrPurchaseOrderDtlsPEOVendorId | Value that identifies the supplier and references PO_VENDORS.vendor_id. |
| CmrPurchaseOrderDtlsPEOVendorSiteId | Value that identifies the supplier site and references PO_VENDOR_SITES_ALL.vendor_site_id. |
| CmrPurchaseOrderDtlsPEOWoOperationSeqNumber | Value that identifies the sequence number of the operation in work order. |
| CmrPurchaseOrderDtlsPEOWorkOrderId | Value that uniquely identifies for the contract manufacturing work order. |
| CmrPurchaseOrderDtlsPEOWorkOrderNumber | Value that identifies the contract manufacturing work order number. |
| CmrPurchaseOrderDtlsPEOWorkOrderOperationId | Value that uniquely identifies the work order operation. |
| CmrPurchaseOrderDtlsPEOWorkOrderProduct | Value that identifies the finished good product of the contract manufacturing work order. |