DraftPurchaseOrderslinesschedules
Manages shipping schedules, delivery dates, and receiving locations for each line in a draft purchase order.
Table-Specific Information
Select
The driver uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The driver processes other filters within the driver.
For example, the following query is processed server-side:
SELECT * FROM [Cdata].[Procurement].[DraftPurchaseOrderslinesschedules] WHERE LineLocationId = 10003
Insert
Create an DraftPurchaseOrderslinesschedule.
You need to provide DraftPurchaseOrdersUniqID instead of DraftPurchaseOrdersPOHeaderId and LinesUniqId instead of LinesPOLineId , to insert the record.
INSERT INTO DraftPurchaseOrderslinesschedules(DraftPurchaseOrdersUniqID,LinesUniqId,ScheduleNumber,Quantity,ShipToLocation,ShipToOrganization,ReceiptCloseTolerancePercent,InvoiceMatchOptionCode,EarlyReceiptToleranceDays,InvoiceCloseTolerancePercent,LateReceiptToleranceDays,AccrueAtReceiptFlag,InspectionRequiredFlag,ReceiptRequiredFlag,ReceiptRoutingId,DestinationTypeCode,Carrier,ServiceLevel,ModeOfTransportCode) VALUES (121321,2131,5,10,'Marseille','Marseille',0,'P',60,0,0,'N',false,false,3,'EXPENSE','Airborne','2nd day air','PARCEL')
Update
The Oracle Fusion Cloud Financials API uses DraftPurchaseOrdersUniqID instead of DraftPurchaseOrdersPOHeaderId, LinesUniqId instead of LinesPOLineId and LineLocationUniqId instead of LineLocation as a path parameter in the URL to update the record.
If you want to update a record directly using the Id (without any other filter), you can update the record in the following way:
Update [Cdata].[Procurement].[DraftPurchaseOrderslinesschedules] set Description='abcd' WHERE draftPurchaseOrdersUniqID=454545454 and LinesUniqId=121 and LineLocationUniqId=55655
Note: This does not require an extra GET request to retrieve the UniqId. You need to provide all the UniqIds.
Alternatively, if you want to apply any other filter, use DraftPurchaseOrdersPOHeaderId instead of DraftPurchaseOrdersUniqID, LinesPOLineId instead of LinesUniqId and LineLocation instead of LineLocationUniqId. You can update the record in the following way:
Update [Cdata].[Procurement].[DraftPurchaseOrderslinesschedules] set Description='abcd' WHERE DraftPurchaseOrdersPOHeaderId=454545454
Note : Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.
Delete
The Oracle Fusion Cloud Financials API uses DraftPurchaseOrdersUniqID instead of DraftPurchaseOrdersPOHeaderId, LinesUniqId instead of LinesPOLineId and LineLocationUniqId instead of LineLocation as a path parameter in the URL to delete the record.
If you want to delete a record directly using the Id (without any other filter), you can delete the record in the following way:
DELETE FROM [Cdata].[Procurement].[DraftPurchaseOrderslinesschedules] WHERE draftPurchaseOrdersUniqID=454545454 and LinesUniqId=121 and LineLocationUniqId=55655
Note: This does not require an extra GET request to retrieve the UniqId. You need to provide all the UniqIds.
Alternatively, if you want to apply any other filter, use DraftPurchaseOrdersPOHeaderId instead of DraftPurchaseOrdersUniqID, LinesPOLineId instead of LinesUniqId and LineLocation instead of LineLocationUniqId. You can delete the record in the following way:
DELETE FROM [Cdata].[Procurement].[DraftPurchaseOrderslinesschedules] WHERE DraftPurchaseOrdersPOHeaderId=454545454
Columns
| Name | Type | ReadOnly | Description |
| DraftPurchaseOrdersPOHeaderId [KEY] | Long | True |
The unique identifier for a draft purchase order header, linking the schedule to the corresponding purchase order. |
| DraftPurchaseOrdersUniqId [KEY] | String | True |
A unique identifier used for insert, update, and delete operations in place of DraftPurchaseOrdersPOHeaderId, providing a more specific reference for the schedule. |
| LinesPOLineId [KEY] | Long | True |
The identifier for the specific purchase order line, linking this schedule to the corresponding line item. |
| LinesUniqId [KEY] | String | True |
A unique identifier for the schedule line, used for insert, update, and delete operations instead of LinesPOLineId. |
| LineLocationId [KEY] | Long | True |
The identifier for the location where the purchase order line item is to be delivered, indicating the specific shipping location. |
| LineLocationUniqId [KEY] | String | True |
A unique identifier used in insert, update, and delete operations instead of LineLocationId, providing a more specific reference for the location. |
| ScheduleNumber | Decimal | False |
The number that uniquely identifies the purchase order schedule for the given purchase order line. |
| POLineId | Long | False |
The unique identifier for the parent purchase order line, used when the schedule is a split or a child of another line. |
| LineNumber | Decimal | True |
The line number assigned to the schedule, helping to track and identify the specific line item within the schedule. |
| POHeaderId | Long | False |
The identifier for the purchase order header associated with this purchase order schedule. |
| OrderNumber | String | True |
The order number for the purchase order schedule, used to track the order across the system. |
| Quantity | Decimal | False |
The quantity of items specified in the purchase order schedule, indicating how many units are being scheduled. |
| Amount | Decimal | False |
The monetary value of the scheduled item or service, reflecting the total cost for the scheduled quantity. |
| ShipToOrganizationId | Long | False |
The unique identifier for the inventory organization where the supplier is expected to deliver the item. |
| ShipToOrganizationCode | String | False |
The abbreviation or code for the inventory organization where the item is to be shipped. |
| ShipToOrganization | String | False |
The name of the inventory organization that will receive the shipment. |
| ShipToLocation | String | False |
The name of the physical location within the organization where the item will be delivered. |
| ShipToLocationId | Long | False |
The identifier for the specific location within the organization where the item is to be shipped. |
| ShipToLocationCode | String | False |
The abbreviation or code that uniquely identifies the shipping location within the organization. |
| ShipToLocationInternalCode | String | False |
An internal code used to identify the location where goods should be shipped within the organization. |
| DestinationTypeCode | String | False |
A code representing how the item will be used upon fulfillment, such as inventory, expense, drop ship, or manufacturing. |
| DestinationType | String | False |
The type of destination indicating how to categorize the charge for the item, including values like inventory, expense, drop ship, or work order. |
| LocationOfFinalDischargeId | Long | False |
The identifier for the final location where the item or service will be delivered or discharged. |
| LocationOfFinalDischargeCode | String | False |
An abbreviation that identifies the final discharge location where the goods will be received. |
| TransactionBusinessCategoryId | Long | False |
The identifier for the business category classification of the transaction, typically used for tax reporting purposes. |
| TransactionBusinessCategoryCode | String | False |
An abbreviation for the business category used for tax categorization of the transaction. |
| TransactionBusinessCategory | String | False |
The description of the business category used to classify the transaction for tax purposes. |
| UserDefinedFiscalClassificationCode | String | False |
An abbreviation for the user-defined fiscal classification, which can be customized for tax or financial reporting. |
| UserDefinedFiscalClassification | String | False |
An additional custom classification for fiscal reporting or tax purposes, as defined by the organization. |
| ProductFiscalClassificationId | Long | False |
The unique identifier for the fiscal classification of a product, used for tax categorization by tax authorities. |
| ProductFiscalClassificationCode | String | False |
An abbreviation for the fiscal classification of the product, used in tax reporting. |
| ProductFiscalClassification | String | False |
The classification applied by tax authorities to a product, used for tax categorization. |
| ProductCategoryCode | String | False |
The code used to categorize the product for tax purposes, based on the tax classification. |
| ProductCategory | String | False |
The name or description of the product category used for tax reporting and categorization. |
| LineIntendedUseId | Long | False |
The identifier for the intended business use of a product, indicating how the purchaser plans to use the item. |
| LineIntendedUse | String | False |
The purpose for which the product is intended to be used by the purchaser in their business. |
| ProductTypeCode | String | False |
An abbreviation that identifies the product type, typically used for classification in tax or financial reporting. |
| ProductType | String | False |
The type of product, determining how tax is calculated. Common types include goods and services. |
| AssessableValue | Decimal | False |
The value of the product that is assessable for tax purposes, typically based on the transaction amount. |
| TaxClassificationCode | String | False |
The abbreviation for the tax classification code, used for categorizing products and services for tax reporting. |
| TaxClassification | String | False |
The tax classification used to group items for tax reporting and processing purposes. |
| InvoiceCloseTolerancePercent | Decimal | False |
The percentage tolerance used to determine whether a purchase order schedule should be closed when the invoice covers only part of the scheduled quantity or amount. |
| ReceiptCloseTolerancePercent | Decimal | False |
The percentage tolerance used to determine whether a purchase order schedule should be closed when only part of the scheduled quantity or amount is received. |
| EarlyReceiptToleranceDays | Decimal | False |
The maximum number of days that the system allows for an early shipment of the order. |
| LateReceiptToleranceDays | Decimal | False |
The maximum number of days that the system allows for a late shipment of the order. |
| AccrueAtReceiptFlag | Bool | False |
A flag indicating whether to accrue the purchase order schedule at the time of receipt. If true, the system will accrue at receipt; if false, accrual does not occur at receipt. |
| ReceiptRoutingId | Long | False |
The identifier for the receipt routing method to use when receiving the item, such as standard receipt or inspection required. |
| ReceiptRouting | String | False |
The method used for routing the receipt, determining how the item is handled when it arrives (for example, standard receipt, inspection required, or direct delivery). |
| InvoiceMatchOptionCode | String | False |
A code indicating whether the invoice must match the purchase order or receipt for validation. Possible values include C (consumption advice), P (purchase order), or R (receipt). |
| InvoiceMatchOption | String | False |
The matching option used for invoice validation, specifying whether to match against the purchase order or receipt. For consignment, it matches the consumption advice. |
| InspectionRequiredFlag | Bool | False |
A flag indicating whether the schedule requires inspection before payment can be made. If true, inspection is required; if false, payment can be made without inspection. |
| ReceiptRequiredFlag | Bool | False |
A flag indicating whether receipt of the goods is required before payment can be made. If true, receipt is required; if false, payment can occur even without receipt. |
| MatchApprovalLevelCode | String | False |
An abbreviation for the match approval level, specifying the level of matching required between the purchase order, receipt, inspection, and invoice. |
| MatchApprovalLevel | String | False |
The approval level required for matching purchase order quantities, receipts, inspections, and invoices before payment can be made. Values include 2-way, 3-way, or 4-way match. |
| AllowSubstituteReceiptsFlag | Bool | False |
A flag indicating whether the schedule allows for a substitute item to be used in place of the original item. If true, substitution is allowed; if false, no substitution is permitted. |
| FirmFlag | Bool | True |
A flag indicating whether the schedule is firm or not, determining whether the order commitment is fixed or flexible. |
| OverReceiptTolerancePercent | Decimal | False |
The percentage tolerance for receiving more than the ordered quantity without triggering the over-receipt action. |
| BackToBackFlag | Bool | True |
A flag indicating whether the purchase order schedule is a back-to-back order, typically used for orders that directly correspond to another order. |
| NoteToReceiver | String | False |
A note providing additional instructions to the receiver regarding how to process the purchase order schedule. |
| RequestedDeliveryDate | Date | False |
The date on which the buyer has requested that the supplier deliver the item. |
| PromisedDeliveryDate | Date | False |
The date on which the supplier has promised to deliver the item to the buyer. |
| RequestedShipDate | Date | False |
The date on which the buyer has requested that the supplier ship the item. |
| PromisedShipDate | Date | False |
The date on which the supplier has promised to ship the item to the buyer. |
| SalesOrderNumber | String | True |
The sales order number associated with this purchase order schedule. |
| SalesOrderLineNumber | String | True |
The sales order line number related to this purchase order schedule. |
| SalesOrderScheduleNumber | String | True |
The sales order schedule number associated with this purchase order schedule. |
| SecondaryQuantity | Decimal | False |
The scheduled quantity in a secondary unit of measure, applicable when multiple units of measure are used. |
| TaxableFlag | Bool | True |
A flag indicating whether the item is subject to tax under the applicable tax rules. |
| Carrier | String | False |
The company responsible for transporting the item to the destination. |
| CarrierId | Long | False |
The unique identifier for the carrier company handling the shipment. |
| CountryOfOrigin | String | False |
The country where the item is produced or manufactured, used for customs and regulatory purposes. |
| CountryOfOriginCode | String | False |
An abbreviation for the country of origin, typically used in international trade and customs processing. |
| ShipToExceptionAction | String | False |
The action to take if there is an exception with the ship-to location, such as none, reject, or warning. |
| ShipToExceptionActionCode | String | False |
The code indicating the action to take when there is a discrepancy with the ship-to location, such as none, reject, or warning. |
| FundsStatusCode | String | True |
The code representing the current funds status for this schedule, indicating whether there are sufficient funds. |
| FundsStatus | String | True |
The description of the funds status, showing whether the purchase order schedule has adequate funds for the purchase. |
| ModeOfTransport | String | False |
The mode of transport used to ship the item, such as truck, air, or sea. |
| ModeOfTransportCode | String | False |
An abbreviation for the mode of transport used for shipment, such as 'TRK' for truck, 'AIR' for air, or 'SEA' for sea. |
| CancelDate | Date | True |
The date when the purchase order schedule was canceled, if applicable. |
| CancelReason | String | False |
The reason for the cancellation of the purchase order schedule, providing context for the decision. |
| CancelledBy | Long | True |
The identifier of the user or system that canceled the purchase order schedule. |
| RejectedReason | String | True |
The reason why the purchase order schedule was rejected, if applicable. |
| ReasonForChange | String | False |
The reason for changing the schedule, such as product modification, price adjustment, or shipping issues. |
| ChangeAcceptedFlag | Bool | True |
A flag indicating whether the changes made to the purchase order schedule have been accepted. |
| ChangeOrderAmountCancelled | Decimal | True |
The amount of the change order that has been canceled. |
| ChangeOrderQuantityCancelled | Decimal | True |
The quantity of the change order that has been canceled. |
| CustomerItem | String | True |
The item identifier used by the customer for this purchase order schedule. |
| CustomerItemDescription | String | True |
The description of the item from the customer’s perspective. |
| CustomerPOLineNumber | String | True |
The customer’s purchase order line number associated with this schedule. |
| CustomerPONumber | String | True |
The customer’s purchase order number associated with this schedule. |
| CustomerPOScheduleNumber | String | True |
The customer’s purchase order schedule number associated with this schedule. |
| CurrencyCode | String | True |
The currency code used for the purchase order schedule, such as USD or EUR. |
| Currency | String | True |
The name of the currency used for the purchase order schedule. |
| RejectedBy | Long | True |
The user or system that rejected the purchase order schedule. |
| RejectedByRole | String | True |
The role of the user who rejected the purchase order schedule. |
| CancelFlag | Bool | False |
A flag indicating whether the schedule is canceled (true) or not canceled (false). |
| SecondaryUOMCode | String | True |
The code for the secondary unit of measure used in the purchase order schedule. |
| SecondaryUOM | String | True |
The secondary unit of measure for the purchase order schedule, applicable when more than one unit of measure is used. |
| UOMCode | String | False |
An abbreviation for the unit of measure used for the purchase order schedule. |
| UOM | String | False |
The unit of measure used for the scheduled quantity of the item. |
| PricingUOMCode | String | False |
The unit of measure used for pricing the item in the purchase order schedule. |
| PricingUOM | String | True |
The unit of measure used for the pricing of the item in the purchase order schedule. |
| ReceiptDateExceptionActionCode | String | False |
The action to take when the receipt does not match the ordered quantity or amount by the specified receipt date tolerance. Possible values include none, reject, or warning. |
| ReceiptDateExceptionAction | String | False |
The action to take when the receipt deviates from the ordered quantity or amount based on the receipt date tolerance, such as none, reject, or warning. |
| OverReceiptActionCode | String | False |
The code indicating what action to take when the receipt exceeds the ordered quantity or amount. |
| OverReceiptAction | String | False |
The action to take when the receipt quantity exceeds the ordered quantity, such as none, reject, or warning. |
| WorkOrderId | Long | True |
The identifier for the work order associated with the purchase order schedule. |
| WorkOrderNumber | String | True |
The work order number associated with the purchase order schedule. |
| WorkOrderOperationId | Long | True |
The operation identifier for the work order associated with the purchase order schedule. |
| WorkOrderOperationSequence | Decimal | True |
The sequence number for the operation in the work order related to the purchase order schedule. |
| WorkOrderSubType | String | True |
The subtype of the work order related to the purchase order schedule. |
| SupplierOrderLineNumber | String | True |
The supplier's order line number associated with this purchase order schedule. |
| OrchestrationAgreementLineNumber | Long | True |
The line number within the orchestration agreement for this purchase order schedule. |
| OrchestrationAgreementNumber | String | True |
The number of the orchestration agreement associated with this purchase order schedule. |
| PrimaryTradeRelationshipId | Long | True |
The identifier for the primary trade relationship involved in this purchase order schedule. |
| POTradingOrganizationId | Long | True |
The identifier for the trading organization associated with this purchase order schedule. |
| POTradingOrganizationCode | String | True |
The code for the trading organization associated with the purchase order schedule. |
| POTradingOrganization | String | True |
The name of the trading organization associated with this purchase order schedule. |
| FirmStatusLookupCode | String | True |
The lookup code for the firm status of this purchase order schedule. |
| FirmStatus | String | True |
The firm status of the purchase order schedule, indicating whether the schedule is confirmed or tentative. |
| ParentLineLocationId | Long | True |
The identifier for the parent line location from which this schedule was derived. |
| ParentScheduleNumber | Decimal | False |
The number of the parent schedule from which this purchase order schedule was created. |
| ShipToCustomerContactId | Long | True |
The identifier for the contact person at the ship-to customer location for this purchase order schedule. |
| ShipToCustomerContact | String | True |
The name of the contact person at the ship-to customer location for the purchase order schedule. |
| ShipToCustomerId | Long | True |
The identifier for the ship-to customer for this purchase order schedule. |
| ShipToCustomer | String | True |
The name of the customer receiving the goods in this purchase order schedule. |
| ShipToCustomerLocationId | Long | True |
The identifier for the specific location of the ship-to customer. |
| ServiceLevelCode | String | False |
The abbreviation for the service level, indicating the priority or method of shipping. |
| ServiceLevel | String | False |
The service level associated with the shipment, indicating the speed or method of delivery. |
| CancelUnfulfilledDemandFlag | Bool | False |
A flag indicating whether to cancel any unfulfilled demand when the purchase order schedule is canceled. |
| CreatedBy | String | True |
The user or system that created the purchase order schedule record. |
| CreationDate | Datetime | True |
The date and time when the purchase order schedule record was created. |
| LastUpdateDate | Datetime | True |
The date and time when the purchase order schedule was last updated. |
| LastUpdatedBy | String | True |
The user or system that last updated the purchase order schedule record. |
| ShippingMethod | String | False |
The method of transport used for shipping the item in the purchase order schedule. |
| RetainageRate | Decimal | False |
The percentage of the invoice value that is withheld as retainage, often used in construction projects. |
| LastAcceptableDeliveryDate | Date | True |
The last date on which the item can be delivered according to the purchase order schedule. |
| LastAcceptableShipDate | Date | True |
The last date on which the item can be shipped according to the purchase order schedule. |
| OriginalPromisedDeliveryDate | Date | True |
The original promised delivery date for the purchase order schedule, prior to any changes. |
| OriginalPromisedShipDate | Date | True |
The original promised ship date for the purchase order schedule, prior to any changes. |
| Type | String | False |
The type of payment schedule for the purchase order, such as lump sum or based on units of work. |
| Description | String | False |
A description of the work associated with the purchase order schedule, often used for progress payments. |
| Price | Decimal | False |
The price for the item or service specified in the purchase order schedule. |
| TypeCode | String | False |
The abbreviation for the type of purchase order schedule, typically used to classify the payment type (for example, rate, lump sum). |
| Finder | String | True |
A search identifier used to locate specific purchase order schedules. |
| Intent | String | True |
The intended action or purpose related to the schedule, such as creating, reviewing, or updating. |
| SysEffectiveDate | String | True |
The effective date in the system, marking when the schedule was created or last updated. |
| CUReferenceNumber | Int | False |
An identifier used to link child aggregate records to their corresponding parent tables. |
| EffectiveDate | Date | True |
The effective date for the schedule, used to determine when the purchase order schedule becomes valid. |