Purchase Order Schedule Version 2
An object, representing a set of schedule attributes, that is returned when inquiring a purchase order.
QName: {http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/}PurchaseOrderSchedule
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
AccrueAtReceiptFlag |
boolean |
Indicates whether the purchase order schedule will be accrued at receipt. |
|
AllowSubstituteReceiptsFlag |
boolean |
Indicates whether the purchase order schedule can receive substitute item in place of an ordered item. |
|
AssessableAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities. |
|
BackToBackFlag |
boolean |
Indicates whether the purchase order schedule has a backing sales order that is fulfilled using a back to back order. |
|
Carrier |
string |
The display name of the company that transports goods from one point to another by land, sea, or air. |
|
CarrierId |
long |
The unique identifier of the company that transports goods from one point to another by land, sea, or air. |
|
ClosedDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when a schedule is closed or finally closed. |
|
CountryOfOrigin |
string |
The display name of a country from which goods are exported. |
|
CountryOfOriginCode |
string |
A code indicating the country from which goods are exported. |
|
CustomerItem |
string |
The display name of a customer's identification number or code for the goods ordered on your order line. |
|
CustomerItemDescription |
string |
A text description capturing a customer's identification number or code for the goods ordered on your order line. |
|
CustomerPOLine |
string |
The display number used to identify a purchase order line from the customer that originated the sales order which is being fulfilled by the material being procured in a drop ship arrangement. |
|
CustomerPONumber |
string |
The display number used to identify a purchase order from the customer that originated the sales order which is being fulfilled by the material being procured in a drop ship arrangement. |
|
CustomerPOSchedule |
string |
The display number used to identify a purchase order schedule from the customer that originated the sales order which is being fulfilled by the material being procured in a drop ship arrangement. |
|
DestinationType |
string |
The display name indicating if the item should be charged to an inventory or should be expensed. |
|
DestinationTypeCode |
string |
A code indicating if the item should be charged to an inventory or should be expensed. |
|
EarlyReceiptToleranceDays |
decimal |
Maximum acceptable number of days early for receipts. |
|
FundsStatus |
string |
Status of funds check or funds reservation validation result. |
|
FundsStatusCode |
string |
Status code of funds check or funds reservation validation result. |
|
IntendedUse |
string |
A tax classification based on the purpose for which a product is used. |
|
IntendedUseId |
long |
The unique identifier of the tax classification based on the purpose for which a product is used. |
|
InvoiceCloseTolerancePercent |
decimal |
The tolerance that allows a purchase order schedule to be automatically closed for invoicing, if it is within the tolerance at billing, when Payables matches invoices to purchase orders or receipts. |
|
InvoiceMatchOption |
string |
The option that determines whether invoices for the purchase order schedule should match to the purchase order or the receipt. |
|
InvoiceMatchOptionCode |
string |
The code associated with the option that determines whether invoices for the purchase order schedule should match to the purchase order or the receipt. |
|
LastAcceptDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The last date when the ordered quantity or amount can be received. |
|
LastAcceptableDeliveryDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The last date when the ordered quantity or amount can be received. |
|
LastAcceptableShipDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The last date when the ordered quantity or amount can be shipped. |
|
LateReceiptToleranceDays |
decimal |
Maximum acceptable number of days late for receipts. |
|
LineLocationId |
long |
The unique identifier of a purchase order schedule.
|
|
MatchApprovalLevelCode |
string |
A code that indicates how purchase order, receipt, inspection, and invoice quantities should match before the corresponding invoice can be paid. |
|
ModeOfTransport |
string |
The mode of transport used for shipment. |
|
ModeOfTransportCode |
string |
The code of the mode of transport used for shipment. |
|
NeedByDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
A date by when the buying company requests the supplier to deliver the item. |
|
NoteToReceiver |
string |
Special text instructions to the receiver in the docking area, to be reviewed while performing the receipt. |
|
OrchestrationAgreementLineNumber |
long |
Number representing a primary route in a supply chain financial orchestration flow. |
|
OrchestrationAgreementNumber |
string |
An agreement entered into between the legal entities, business units and trade organizations of a corporate group for establishing a trade relationship. An orchestration agreement contains the parties involved in the trade relationship, and the process of financial settlement among them. |
|
OrderedAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total amount of the order, according to the quantities and prices of the goods and service items specified on the order. |
|
OriginalPromisedDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The first promised date recorded for a purchase order schedule. |
|
OriginalPromisedDeliveryDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The initial date by when the supplier has promised to deliver the item or service ordered by the buying company. |
|
OriginalPromisedShipDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The initial date by when the supplier has promised to ship the item ordered by the buying company. |
|
OverReceiptAction |
string |
Determines how to handle receipts that exceed the received quantity tolerance. |
|
OverReceiptActionCode |
string |
A code that determines how to handle receipts that exceed the received quantity tolerance. |
|
OverReceiptTolerancePercent |
decimal |
The tolerance that allows a purchase order schedule to receive more than ordered quantity or amount without triggering the over-receipt action. |
|
POHeaderId |
long |
The unique identifier of a purchasing document. |
|
POLineId |
long |
The unique identifier of a purchasing document line. |
|
ParentLineLocationId |
long |
Identifier of the schedule that is being split to create the new schedule. |
|
ParentScheduleNumber |
decimal |
The number of the schedule that is being split to create the new schedule. |
|
PrimaryTradeRelationshipId |
long |
A unique identifier for the trade relationship between two primary parties in a supply chain financial orchestration flow, such as the relationship between a shipping business unit and a selling business unit in a shipment to an external customer, or between the sold to business unit and receiving business unit in a procurement from external supplier. |
|
ProductCategory |
string |
A type of product fiscal classification used to classify products. Related term(s): product fiscal classification. |
|
ProductCategoryCode |
string |
A code indicating a type of product fiscal classification used to classify products. Related term(s): product fiscal classification. |
|
ProductFiscalClassification |
string |
A classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required. |
|
ProductFiscalClassificationId |
long |
The unique identifier of the classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required. |
|
ProductType |
string |
The nature or the product involved in a taxable transaction. For example, goods or services. |
|
ProductTypeCode |
string |
A code indicating a type of product fiscal classification used to classify products. Related term(s): product fiscal classification. |
|
PromisedDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
A date by when the supplier has promised to deliver the item ordered by the buying company. |
|
PromisedDeliveryDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
A date by when the supplier has promised to deliver the ordered item or service. |
|
PromisedDeliveryDateUTC |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
A date in UTC by when the supplier has promised to deliver the ordered item or service. |
|
PromisedShipDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
A date by when the supplier has promised to ship the item ordered by the buying company. |
|
PromisedShipDateUTC |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
A date in UTC by when the supplier has promised to ship the item ordered by the buying company. |
|
PurchaseOrderDistribution |
The purchase order distribution information. |
|
|
PurchasingTradingOrganization |
string |
The inventory organization reporting to the sold-to legal entity identified on the purchase order. This organization is used for cost accounting the transactions in the sold-to legal entity. |
|
PurchasingTradingOrganizationCode |
string |
The code of the inventory organization reporting to the sold-to legal entity identified on the purchase order. This organization is used for cost accounting the transactions in the sold-to legal entity. |
|
PurchasingTradingOrganizationId |
long |
The identifier of the inventory organization reporting to the sold-to legal entity identified on the purchase order. This organization is used for cost accounting the transactions in the sold-to legal entity. |
|
Quantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The ordered quantity for the purchase order schedule. |
|
ReceiptCloseTolerancePercent |
decimal |
The percentage that allows a purchase order schedule to be automatically closed for receiving, if it is within the tolerance at receiving. |
|
ReceiptDateExceptionAction |
string |
The display name of an action that is triggered when the ordered quantity or amount is not yet received before the late receipt tolerance days. |
|
ReceiptDateExceptionActionCode |
string |
A code indicating the action that is triggered when the ordered quantity or amount is not yet received before the late receipt tolerance days. |
|
ReceiptRouting |
string |
A method of simplifying transaction entry by specifying routing steps for receipts. |
|
ReceiptRoutingId |
long |
The unique identifier of a method of simplifying transaction entry by specifying routing steps for receipts. |
|
ReopenFinalCloseDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date on which a finally closed schedule is reopened. |
|
RequestedDeliveryDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
A date when the buying company requests the ordered item or service to be delivered. |
|
RequestedDeliveryDateUTC |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
A date in UTC when the buying company requests the ordered item or service to be delivered. |
|
RequestedShipDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the buying company has requested the ordered item is ready to be shipped. |
|
RequestedShipDateUTC |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date in UTC when the buying company has requested the ordered item is ready to be shipped. |
|
SalesOrderLineNumber |
string |
The display number used to identify a backing customer sales order line number. |
|
SalesOrderNumber |
string |
The display number used to identify a backing customer sales order number. |
|
SalesOrderScheduleNumber |
string |
The display number used to identify a backing customer sales order schedule number. |
|
ScheduleFlexfield |
An object that enables customers to extend the purchase order schedule attributes, and retrieve values for these additional attributes when inquiring a purchase order schedule. |
|
|
ScheduleNumber |
decimal |
The display number used to identify a purchase order schedule associated with a line. |
|
ScheduleStatus |
string |
The display name of a purchase order schedule state relative to the entire schedule lifecycle. |
|
ScheduleStatusCode |
string |
A code indicating the state that the purchase order schedule is in relative to the entire schedule lifecycle. |
|
SecondaryQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity converted in the secondary unit of measure of a dual UOM controlled item. |
|
SecondaryUOM |
string |
An alternative unit of measure that is allowed to quantify a dual UOM controlled item. |
|
SecondaryUOMCode |
string |
A code indicating an alternative unit of measure that is allowed to quantify a dual UOM controlled item. |
|
ServiceLevel |
string |
The display name of a transportation priority that affects how quickly goods are transported. Applicable values are all meanings of the lookup Carrier Service Levels. |
|
ServiceLevelCode |
string |
A code indicating the priority of transportation that affects how quickly goods are transported. Applicable values are all codes of the lookup Carrier Service Levels. |
|
ShipToCustomer |
string |
The display name of a customer to whom materials, being procured in a drop ship or a back to back arrangement, need to be shipped. |
|
ShipToCustomerContact |
string |
The display name of the customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped. |
|
ShipToCustomerContactId |
long |
The unique identifier for the customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped. |
|
ShipToCustomerId |
long |
The unique identifier of a customer to whom materials, being procured in a drop ship or a back to back arrangement need to be shipped. |
|
ShipToCustomerLocation |
string |
The display name of a customer location where materials, being procured in a drop ship arrangement, need to be shipped. |
|
ShipToCustomerLocationId |
long |
The unique identifier of a customer location where materials, being procured in a drop ship arrangement, need to be shipped. |
|
ShipToExceptionAction |
string |
The display name of how to handle receipts when the receiving location differs from the ship-to location. |
|
ShipToExceptionActionCode |
string |
A code indicating how to handle receipts when the receiving location differs from the ship-to location. |
|
ShipToLocationCode |
string |
A code indicating a location where the supplier should ship the goods. |
|
ShipToLocationId |
long |
The unique identifier of the location where the supplier should ship the goods. |
|
ShipToOrganizationCode |
string |
A code indicating an inventory organization where the supplier should ship the goods. |
|
ShipToOrganizationId |
long |
The unique identifier of the inventory organization where the supplier should ship the goods. |
|
ShipToOrganizationName |
string |
The name of the inventory organization where the supplier should ship the goods. |
|
SupplierOrderLine |
string |
The number or text that the supplier uses to identify a purchase order schedule. |
|
TaxClassification |
string |
The display name of a group of taxes for reporting and processing purposes. |
|
TaxClassificationCode |
string |
A code indicating a grouping of taxes for reporting and processing purposes. |
|
TotalAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The sum of the ordered amount and the total tax amount. |
|
TotalTaxAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The sum of the recoverable and non-recoverable tax amounts. |
|
TransactionBusinessCategory |
string |
A business classification used by Oracle Fusion Tax to identify and categorize an external transaction into an Oracle Fusion Tax transaction. |
|
TransactionBusinessCategoryCode |
string |
A code indicating a business classification used by Oracle Fusion Tax to identify and categorize an external transaction into an Oracle Fusion Tax transaction. |
|
UserDefinedFiscalClassification |
string |
A classification for any tax requirement that you cannot define using the existing fiscal classification types. |
|
UserDefinedFiscalClassificationCode |
string |
A classification code for any tax requirement that you cannot define using the existing fiscal classification types. |
|
WorkOrderId |
long |
Unique identifier for the contract manufacturing work order. |
|
WorkOrderNumber |
string |
The display number used to identify the finished goods product of a contract manufacturing work order. |
|
WorkOrderOperationId |
long |
The unique identifier of a work order operation. |
|
WorkOrderOperationSequence |
decimal |
The display number used to identify the work order operation sequence. |
|
WorkOrderSubTypeCode |
string |
A code indicating the work order operation subtype. |