Transfer Orders
The Supply Transfer Order Details Extract view object extracts details from the transfer order.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyTransferOrderDetailsExtractPVO
Primary Keys : DosTransferOrderDetailsPEOSupplyTransferDetailsId
Initial Extract Date : DosTransferOrderDetailsPEOCreationDate
Incremental Extract Date : DosTransferOrderDetailsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosTransferOrderDetailsPEOAgreementId | Value that uniquely identifies the agreement that you use to transfer price. Financial orchestration uses the Primary Trade Relationship ID to provide the value. |
| DosTransferOrderDetailsPEOAttributeCategory | Attribute category you can use to identify the descriptive flexfield that captures details about the transfer order. |
| DosTransferOrderDetailsPEOAttributeChar1 | Descriptive flexfield 1 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar10 | Descriptive flexfield 10 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar11 | Descriptive flexfield 11 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar12 | Descriptive flexfield 12 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar13 | Descriptive flexfield 13 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar14 | Descriptive flexfield 14 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar15 | Descriptive flexfield 15 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar16 | Descriptive flexfield 16 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar17 | Descriptive flexfield 17 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar18 | Descriptive flexfield 18 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar19 | Descriptive flexfield 19 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar2 | Descriptive flexfield 2 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar20 | Descriptive flexfield 20 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar3 | Descriptive flexfield 3 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar4 | Descriptive flexfield 4 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar5 | Descriptive flexfield 5 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar6 | Descriptive flexfield 6 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar7 | Descriptive flexfield 7 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar8 | Descriptive flexfield 8 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeChar9 | Descriptive flexfield 9 for details in the transfer order. The data type of the flexfield is character. |
| DosTransferOrderDetailsPEOAttributeDate1 | Descriptive flexfield 1 for details in the transfer order. The data type of the flexfield is date. |
| DosTransferOrderDetailsPEOAttributeDate2 | Descriptive flexfield 2 for details in the transfer order. The data type of the flexfield is date. |
| DosTransferOrderDetailsPEOAttributeDate3 | Descriptive flexfield 3 for details in the transfer order. The data type of the flexfield is date. |
| DosTransferOrderDetailsPEOAttributeDate4 | Descriptive flexfield 4 for details in the transfer order. The data type of the flexfield is date. |
| DosTransferOrderDetailsPEOAttributeDate5 | Descriptive flexfield 5 for details in the transfer order. The data type of the flexfield is date. |
| DosTransferOrderDetailsPEOAttributeNumber1 | Descriptive flexfield 1 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber10 | Descriptive flexfield 10 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber2 | Descriptive flexfield 2 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber3 | Descriptive flexfield 3 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber4 | Descriptive flexfield 4 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber5 | Descriptive flexfield 5 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber6 | Descriptive flexfield 6 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber7 | Descriptive flexfield 7 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber8 | Descriptive flexfield 8 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeNumber9 | Descriptive flexfield 9 for details in the transfer order. The data type of the flexfield is number. |
| DosTransferOrderDetailsPEOAttributeTimestamp1 | Descriptive flexfield 1 for details in the transfer order. The data type of the flexfield is time stamp. |
| DosTransferOrderDetailsPEOAttributeTimestamp2 | Descriptive flexfield 2 for details in the transfer order. The data type of the flexfield is time stamp. |
| DosTransferOrderDetailsPEOAttributeTimestamp3 | Descriptive flexfield 3 for details in the transfer order. The data type of the flexfield is time stamp. |
| DosTransferOrderDetailsPEOAttributeTimestamp4 | Descriptive flexfield 4 for details in the transfer order. The data type of the flexfield is time stamp. |
| DosTransferOrderDetailsPEOAttributeTimestamp5 | Descriptive flexfield 5 for details in the transfer order. The data type of the flexfield is time stamp. |
| DosTransferOrderDetailsPEOBudgetControlEnabledFlag | This attribute contains 1 or 0. 1 means the line on the transfer order is under budgetary control. 0 means it isn't. No value means 0. 0 is the default value. |
| DosTransferOrderDetailsPEOBudgetDate | Date to record the budget for the transfer order. |
| DosTransferOrderDetailsPEOCarrierId | Value that uniquely identifies the carrier for the shipping method. You must associate this value with the name of the carrier when you set up Oracle Cloud applications. |
| DosTransferOrderDetailsPEOChangeSupplyOperation | Operation to perform for the primary document supply when recording change in demand. |
| DosTransferOrderDetailsPEOComments | Comments that the supply requester entered in the transfer supply request. |
| DosTransferOrderDetailsPEOCreatedBy | Name of the user who created the transfer details. |
| DosTransferOrderDetailsPEOCreationDate | Date and time when the user created the transfer details. |
| DosTransferOrderDetailsPEODeliverToRequestorId | Value that uniquely identifies the person where Supply Orchestration will deliver the transfer detail. Its usually the user identification for the employee from human resources. |
| DosTransferOrderDetailsPEODestinationLocationId | Value that uniquely identifies the location where Supply Orchestration sends or transfers the item. You must specify this value in Oracle Cloud applications. This attribute is required only if the internal material transfer includes an expense destination. If it includes an inventory destination, then Supply Orchestration automatically sets the value for this attribute to the location associated with the destination organization when it processes the supply request. |
| DosTransferOrderDetailsPEODestinationSubinventoryCode | Abbreviation that identifies the subinventory where Supply Orchestration creates supply for the requested item. You must define this value in Oracle Cloud applications. |
| DosTransferOrderDetailsPEODestinationTypeCode | Abbreviation that identifies the destination type to use when receiving the transfer order. Values include INVENTORY or EXPENSE. |
| DosTransferOrderDetailsPEODooShipmentFlag | This attribute contains Y or N. Y means to route the shipment for the transfer order through Order Management. N means don't route it through Order Management. No value means N. N is the default value. |
| DosTransferOrderDetailsPEOEndInventoryItemId | Value that uniquely identifies the inventory item when you deliver the item to a location that is different from the location that the item references. Use this value for an internal purchase requisition. |
| DosTransferOrderDetailsPEOEndItemName | Name of the inventory item when the item is an end item. Use this value for an internal purchase requisition. |
| DosTransferOrderDetailsPEOExecSystemDeliverToSubinv | Name of the destination subinventory. Use it only when you transfer the item to inventory. |
| DosTransferOrderDetailsPEOExecSystemDelvrToLocName | Name of the destination location. Use it for a new supply order or to reschedule a supply order for an internal requisition, internal sales order, or transfer order. |
| DosTransferOrderDetailsPEOExecSystemDelvrToRequestor | Name of the requester where you deliver the transfer detail. Its usually an employee from human resources. Use this attribute when you must send the value to a system that resides outside of Oracle Fusion Applications. |
| DosTransferOrderDetailsPEOExecSystemDestnLoctrCode | Abbreviation that identifies the destination locator where fulfillment delivers the item. |
| DosTransferOrderDetailsPEOExecSystemSourceLoctrCode | Abbreviation that identifies the location that Supply Orchestration uses to source the item that it transfers. Orchestration transfers the item from the source location to the destination. |
| DosTransferOrderDetailsPEOExecSystemSourceOrgCode | Abbreviation that identifies the organization that Supply Orchestration uses to source the item that it transfers. Orchestration transfers the item from the source organization to the destination. |
| DosTransferOrderDetailsPEOFirmDemandFlag | This attribute contains Y or N. Y means demand is firm. N means it isn't. No value means N. N is the default value. |
| DosTransferOrderDetailsPEOFundsStatus | Status of the funds as firm or demand for the transfer detail. Values include Firm Transfer Flag or Firm Demand Flag. Planning sends this value to plan a new or reschedule an existing internal requisition, internal sales order, or transfer order. |
| DosTransferOrderDetailsPEOGroupCode | Abbreviation that identifies the import group when the transfer detail is part of a group. |
| DosTransferOrderDetailsPEOLastUpdateDate | Date and time when the user most recently updated the transfer detail. |
| DosTransferOrderDetailsPEOLastUpdateLogin | Login that the user used when updating the transfer detail. |
| DosTransferOrderDetailsPEOLastUpdatedBy | User who most recently updated the transfer detail. |
| DosTransferOrderDetailsPEOLoadType | Type of load. This attribute specifies whether the current interface record is for a planned order or for an update recommendation. The value 1 means to create a standard discrete job. 3 means to update a standard or nonstandard discrete job. 4 means to create a nonstandard discrete job. If this attribute empty doesn't contain a value, then an error will occur. |
| DosTransferOrderDetailsPEONeedByDate | Date when the requester requested to deliver supply to the destination location. |
| DosTransferOrderDetailsPEONoteToReceiver | Text that the person who requests supply enters to provide details for the person who receives supply. For example, receiving instructions. |
| DosTransferOrderDetailsPEONoteToSupplier | Text that the person who requests supply enters to provide details for the person who provides supply. For example, shipping instructions. |
| DosTransferOrderDetailsPEOObjectVersionNumber | Version of the transfer detail. 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. |
| DosTransferOrderDetailsPEOPreparerId | Value that uniquely identifies the person who prepared the supply request. You must associate this value with the preparer name that you set up in Oracle Cloud applications. |
| DosTransferOrderDetailsPEOPrimaryDocQuantity | Quantity to use for the primary document during change management. |
| DosTransferOrderDetailsPEOPrimaryDocQuantityUom | Unit of measure to use for the primary document. |
| DosTransferOrderDetailsPEORepriceFlag | This attribute contains 1 or 0. 1 means to call Supply Chain Financial Orchestration to reprice the transfer supply request. 0 means don't make that call. No value means 0. 0 is the default value. |
| DosTransferOrderDetailsPEORequestedShipDate | Date when the person who requested supply requested to ship the item from the supply source. |
| DosTransferOrderDetailsPEOSalesOrderHeaderId | Value that uniquely identifies the sales order header. Use this attribute when you reschedule an internal requisition or internal sales order. Supply Orchestration uses a purchase order to process a request for an internal material transfer. |
| DosTransferOrderDetailsPEOSalesOrderHeaderNumber | Number that identifies the sales order header in the source system. Use this attribute when you reschedule an internal requisition or internal sales order. |
| DosTransferOrderDetailsPEOSalesOrderLineId | Value that uniquely identifies the sales order line. Use this attribute when you reschedule an internal requisition or internal sales order. |
| DosTransferOrderDetailsPEOSalesOrderLineNumber | Number that identifies the sales order line. Use this attribute when you reschedule an internal requisition or internal sales order. |
| DosTransferOrderDetailsPEOScheduledShipDate | Date when Supply Orchestration scheduled the requested item to ship. |
| DosTransferOrderDetailsPEOShipClassOfService | Class of service for the shipping method. It specifies the priority to use when transporting the item. The WSH_SERVICE_LEVELS lookup contains the values that you can use for this attribute. |
| DosTransferOrderDetailsPEOShipModeOfTransport | Mode of transport for the shipping method. It specifies the mode to use when transporting the item. The WSH_MODE_TRANSPORT lookup contains the values that you can use for this attribute. |
| DosTransferOrderDetailsPEOShipToPartyId | Value that uniquely identifies the party where Supply Orchestration ships the item. Supply Orchestration sends this value to Order Management when it routes the transfer shipment through Order Management. |
| DosTransferOrderDetailsPEOShipToPartySiteId | Value that uniquely identifies the site where Supply Orchestration ships the item. Supply Orchestration sends this value to Order Management when it routes the transfer shipment through Order Management. |
| DosTransferOrderDetailsPEOShipmentPriorityCode | Abbreviation that identifies the priority to use when shipping the fulfillment lines. |
| DosTransferOrderDetailsPEOShippingMethod | Shipping method to use for the purchase requisition when your organization outsources shipping for an internal material transfer. Outsourcing might involve a carrier, shipping terms, freight terms, temporary ownership transfer, and so on. In this situation, you must specify the shipment method, carrier, and freight terms on the transfer document and not on the purchase requisition. |
| DosTransferOrderDetailsPEOSourceBuId | Value that uniquely identifies the business unit for the source system. |
| DosTransferOrderDetailsPEOSourceLocationId | Value that uniquely identifies the location where Supply Orchestration ships the requested item. You must set up this value in Oracle Cloud applications. |
| DosTransferOrderDetailsPEOSourceOrganizationId | Value that uniquely identifies the organization where Supply Orchestration transfers the requested item to the destination organization or subinventory for the supply request. Oracle Cloud applications must create this identifier. |
| DosTransferOrderDetailsPEOSourceSubinventoryCode | Abbreviation that identifies the subinventory where Supply Orchestration transfers the requested item to the destination organization or subinventory for the supply request. You must set up this value in Oracle Cloud applications. |
| DosTransferOrderDetailsPEOSupplyTransferDetailsId | Value that uniquely identifies details for the supply transfer. |
| DosTransferOrderDetailsPEOTrackingLineId | Value that uniquely identifies the tracking line. |
| DosTransferOrderDetailsPEOTransferOrderHeaderId | Value that uniquely identifies the transfer order header. |
| DosTransferOrderDetailsPEOTransferOrderHeaderNumber | Number that identifies the transfer order header. |
| DosTransferOrderDetailsPEOTransferOrderLineId | Value that uniquely identifies the transfer order line. |
| DosTransferOrderDetailsPEOTransferOrderLineNumber | Number that identifies the transfer order line. |
| DosTransferOrderDetailsPEOTransferPrice | Price of the transfer detail. |
| DosTransferOrderDetailsPEOTransferPriceCurrencyCode | Abbreviation that identifies the currency of the transfer price. |
| DosTransferOrderDetailsPEOUnitPrice | Unit price for the transfer detail. Its the transfer price that destination organization uses. |
| DosTransferOrderDetailsPEOUnitPriceCurrencyCode | Abbreviation that identifies the currency of the unit price. |