JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434