Buy Orders
The Supply Buy Order Details Extract view object extracts details for the buy order.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyBuyOrderDetailsExtractPVO
Primary Keys : DosBuyOrderDetailsPEOSupplyBuyOrdDtlsId
Initial Extract Date : DosBuyOrderDetailsPEOCreationDate
Incremental Extract Date : DosBuyOrderDetailsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosBuyOrderDetailsPEOAuthorizationStatus | Approval status of the buy request. |
| DosBuyOrderDetailsPEOAutosourceFlag | Planning sets this attribute to 1 or 0. 1 means to pick the supplier and supplier site from the purchasing sourcing rule. 0 means to not pick from the rule. No value means 0. 0 is the default value. |
| DosBuyOrderDetailsPEOBatchId | Value that uniquely identifies the batch to use for the purchase requisition. |
| DosBuyOrderDetailsPEOBuyerId | Value that uniquely identifies the person who is the buyer for the supply request. You must associate the value in this attribute with the Description of the buyer that you set up in Oracle Cloud applications. |
| DosBuyOrderDetailsPEOCarrierId | Value that uniquely identifies the carrier in the shipping method. You must associate the value in this attribute with the Description of the carrier that you set up in Oracle Cloud applications. |
| DosBuyOrderDetailsPEOCategoryId | Value that uniquely identifies the category of the item in the supply request. |
| DosBuyOrderDetailsPEOChangeSupplyOperation | Description of the supply operation to perform for the change in demand. |
| DosBuyOrderDetailsPEOContractMfgItemId | Value that uniquely identifies the item in contract manufacturing. |
| DosBuyOrderDetailsPEOContractMfgItemRevision | Value that uniquely identifies the revision for the item in contract manufacturing. Supply Orchestration uses it to place the purchase order with the contract manufacturer. |
| DosBuyOrderDetailsPEOCreatedBy | Description of the user who created the buy details. |
| DosBuyOrderDetailsPEOCreationDate | Date and time when the user created the buy details. |
| DosBuyOrderDetailsPEODeliverToLocationId | Value that uniquely identifies the location to deliver the requested item. You must set up the location in Oracle Cloud applications. |
| DosBuyOrderDetailsPEODeliverToRequestorId | Value that uniquely identifies the person who requested the buy details. You deliver the item to this person. |
| DosBuyOrderDetailsPEODeliveryLeadTime | Value that identifies the transit lead time for the supply order. |
| DosBuyOrderDetailsPEODestinationSubinventoryCode | Abbreviation that identifies the subinventory where fulfillment will create supply for the requested item. You must set up the subinventory code in Oracle Cloud applications. |
| DosBuyOrderDetailsPEODestinationTypeCode | Abbreviation that identifies the destination type to use when receiving the buy order. Values include INVENTORY or EXPENSE. |
| DosBuyOrderDetailsPEODistributionId | Value that uniquely identifies distribution details for the buy request. |
| DosBuyOrderDetailsPEOEarliestShipDate | Earliest ship date for the sales order. |
| DosBuyOrderDetailsPEOEndInventoryItemId | Value that uniquely identifies the end item in inventory for the internal purchase requisition. |
| DosBuyOrderDetailsPEOEndItemName | Number that identifies the end item on the work order for outside processing. |
| DosBuyOrderDetailsPEOExecSystemDeliverToSubinv | Subinventory where fulfillment delivers the item. |
| DosBuyOrderDetailsPEOExecSystemDelvrToLocName | Description of the destination location for the supply request. |
| DosBuyOrderDetailsPEOExecSystemDelvrToRequestor | Description of the requester where fulfillment delivers the item. |
| DosBuyOrderDetailsPEOExecSystemDestnLoctrCode | Abbreviation that identifies the destination locator for the supply request. |
| DosBuyOrderDetailsPEOExecSystemSuggestedVendor | Description of the suggested supplier for the purchase request. |
| DosBuyOrderDetailsPEOExecSystemSugstdVendorSite | Description of the suggested supplier site for the purchase request. |
| DosBuyOrderDetailsPEOFirmFlag | Planning sets this attribute to Y or N. Y means demand is firm. N means it isn't. No value means N. N is the default value. |
| DosBuyOrderDetailsPEOGroupCode | Abbreviation that identifies the import group to use for this buy order line in a group. |
| DosBuyOrderDetailsPEOLastUpdateDate | Date and time when the user most recently updated the buy details. |
| DosBuyOrderDetailsPEOLastUpdateLogin | Login that the user used when updating the buy details. |
| DosBuyOrderDetailsPEOLastUpdatedBy | User who most recently updated the buy details. |
| DosBuyOrderDetailsPEOLineLocationId | Value that uniquely identifies the location of the line on the purchase order schedule. |
| DosBuyOrderDetailsPEOLineTypeId | Value that uniquely identifies the line type. It specifies whether the line on the purchasing document is for goods or for services. It also affects some of the default values on attributes that are associated with the line. |
| DosBuyOrderDetailsPEONeedByDate | Date when the requester needs the supply delivered at the destination. |
| DosBuyOrderDetailsPEOObjectVersionNumber | Version of the buy details. This attribute makes sure no more than one user modifies the same object at the same time. The database increments the version every time it updates the row, then compares the version at the start and at the end of each transaction to determine whether another user updated the row during the current session. |
| DosBuyOrderDetailsPEOPreparerId | Value that uniquely identifies the person who prepares the supply request. You must associate this number with the preparer when you set up the preparer in Oracle Cloud applications. |
| DosBuyOrderDetailsPEOPrimaryDocQuantity | Quantity on the primary document to use for change management. |
| DosBuyOrderDetailsPEOPrimaryDocQuantityUom | Unit of measure for the quantity on the primary document to use for change management. |
| DosBuyOrderDetailsPEOPurchaseOrderHeaderId | Value that uniquely identifies the purchase order header. |
| DosBuyOrderDetailsPEOPurchaseOrderLineId | Value that uniquely identifies the purchase order line. |
| DosBuyOrderDetailsPEOPurchaseOrderLineNumber | Number that identifies the purchase order line. |
| DosBuyOrderDetailsPEOPurchaseOrderNumber | Number that identifies the purchase order. |
| DosBuyOrderDetailsPEOPurchaseOrderScheduleNumber | Number that identifies the purchase order schedule. |
| DosBuyOrderDetailsPEORequestedShipDate | Date when the person who requested supply needs fulfillment to ship the item from the supply source location. |
| DosBuyOrderDetailsPEORequisitionId | Value that uniquely identifies the purchase requisition. |
| DosBuyOrderDetailsPEORequisitionLineId | Value that uniquely identifies the purchase requisition line. |
| DosBuyOrderDetailsPEORequisitionLineNumber | Number that identifies the purchase requisition line. |
| DosBuyOrderDetailsPEORequisitionNumber | Number that identifies the purchase requisition. |
| DosBuyOrderDetailsPEORequisitionSourceTypeCode | Abbreviation that identifies the source type on the purchase requisition. Use values INVENTORY or VENDOR. |
| DosBuyOrderDetailsPEORequisitioningBuId | Value that uniquely identifies the business unit on the requisition for the supply request. You must set up this business unit in Oracle Cloud applications. |
| DosBuyOrderDetailsPEOScheduledShipDate | Date when fulfillment schedules to ship the requested item. |
| DosBuyOrderDetailsPEOShipClassOfService | Class of service to use for the shipping method. Class of service specifies the priority to use when transporting the item. The WSH_SERVICE_LEVELS lookup contains the values that you can use for this attribute. |
| DosBuyOrderDetailsPEOShipModeOfTransport | Mode of transport to use for the shipping method. Mode of transport specifies how to transport the item. The WSH_MODE_TRANSPORT lookup contains the values that you can use for this attribute. |
| DosBuyOrderDetailsPEOShipmentPriorityCode | Abbreviation that identifies the priority to use when shipping the fulfillment lines. |
| DosBuyOrderDetailsPEOShippingMethod | Shipping method to use when shipping items for the purchase request. |
| DosBuyOrderDetailsPEOSuggestedVendorId | Value that uniquely identifies the suggested supplier to use for the purchase requisition. |
| DosBuyOrderDetailsPEOSuggestedVendorSiteId | Value that uniquely identifies the suggested supplier site to use for the purchase request. |
| DosBuyOrderDetailsPEOSupplyBuyOrdDtlsId | Value that uniquely identifies the buy order for the supply in Supply Orchestration. Orchestration creates this value when it processes the supply request. |
| DosBuyOrderDetailsPEOTrackingLineId | Value that uniquely identifies the supply tracking line in Supply Orchestration. Orchestration creates this value when it processes the supply request. |
| DosBuyOrderDetailsPEOWorkOrderSubType | Type of work order type for the buy order in outside processing. It specifies the type work to do for the work order, such as standard production, prototype, or repair. |