JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9539

PurchaseOrderLifeCycleDetailsschedules

Displays details about the purchase order schedule, such as how many items were requested and ordered, as well information regarding how many of those items were shipped, received, and invoiced.

Columns

Name Type Description
PurchaseOrderLifeCycleDetailsPOHeaderId [KEY] Long The unique identifier for the purchase order linked to the schedule.
POHeaderId Decimal The unique identifier of the purchase order.
POLineId Decimal The unique identifier of the purchase order line.
LineNumber Decimal The number that uniquely identifies the purchase order line.
LineLocationId [KEY] Long The unique identifier of the purchase order schedule.
ScheduleNumber Decimal The number that uniquely identifies the purchase order schedule for the purchase order line.
LineNumberScheduleNumber String The line and schedule number for a purchase order.
LineDescription String The description of the item that the purchase order references.
ScheduleDescription String The description of the work associated with the progress payment schedule.
ItemOrScheduleDescription String The item description or the description of the work for the payment schedule.
Requisition String The number that identifies the requisition.
RequisitionLine Decimal The number that uniquely identifies the requisition line for the requisition.
RequisitionNumberLineNumber String The requisition and line number for a requisition.
RequestedQuantity Decimal The quantity requested on the requisition line associated with the purchase order schedule.
UOM String The unit of measure used for the requested or ordered quantity.
UOMCode String The abbreviation that identifies the unit of measure.
RequestedAmount Decimal The amount requested on the requisition line associated with the purchase order schedule.
CurrencyCode String The code that identifies the purchase order currency.
RequestedWithQualifier String The quantity or amount requested on the requisition line associated with the purchase order schedule.
OrderedQuantity Decimal The total quantity ordered for this purchase order schedule.
OrderedQuantityWithQualifier String The total quantity ordered for this purchase order schedule shown with the UOM code.
OrderedAmount Decimal The total amount ordered for this purchase order schedule.
OrderedAmountWithQualifier String The total amount ordered for this purchase order schedule shown with the currency code.
ShippedQuantity Decimal The total number of items shipped by the supplier.
ShippedQuantityWithQualifier String The total number of items shipped by the supplier in the purchase order line UOM.
InTransitQuantity Decimal The ordered quantity shipped by the supplier, but yet to be received at the buying organization.
InTransitQuantityWithQualifier String The ordered quantity shipped by the supplier, but yet to be received at the buying organization. Value is shown with the UOM code.
ReceivedQuantity Decimal The ordered quantity that has been received.
ReceivedAmount Decimal The ordered amount that has been received.
ReceivedWithQualifier String The quantity or amount received against the purchase order schedule.
InReceivingQuantity Decimal The ordered quantity received by the buying organization, currently in receiving, and not delivered, or returned.
InReceivingQuantityWithQualifier String The ordered quantity received by the buying organization, currently in receiving, and not delivered, or returned. Value is shown with UOM code.
DeliveredQuantity Decimal The ordered quantity or amount that has been delivered.
DeliveredAmount Decimal The amount delivered against the purchase order schedule for service lines.
DeliveredWithQualifier String The quantity or amount delivered against the purchase order schedule.
InvoicedQuantity Decimal The ordered quantity that has been invoiced.
InvoicedQuantityWithQualifier String The ordered quantity that has been invoiced shown with the UOM code.
InvoicedAmount Decimal The ordered amount that has been invoiced.
InvoicedAmountWithQualifier String The ordered amount that has been invoiced shown with the currency code.
DueDate Date The date when the goods are requested or promised for delivery.
ReceiptDate Date The date when the goods or services were received.
HasMultipleReceiptsFlag Bool Indicates whether the purchase order schedule has multiple receipts or not. Valid values are true and false.
ReceivedInSecondaryQuantity Decimal The ordered quantity that has been received against the purchase order schedule in the secondary UOM of a dual UOM-controlled item.
SecondaryUOMCode String An abbreviation that represents secondary unit of measure used to quantify dual-UOM items.
SecondaryUOM String An alternative UOM that is allowed to quantify a dual UOM-controlled item.
OpenToInvoiceQuantity Decimal The ordered quantity that has not been invoiced yet.
OpenToInvoiceAmount Decimal The ordered amount that has not been invoiced yet.
OrderedInSecondaryQuantity Decimal The ordered quantity of the purchase order schedule in the secondary UOM of a dual UOM-controlled item.
OpenToInvoiceWithQualifier String The quantity or amount that has not been invoiced yet.
ReceivedInSecondaryQuantityWithQualifier String The ordered quantity that has been received against the purchase order schedule in the secondary UOM of a dual UOM-controlled item shown with the UOM code.
OrderedInSecondaryQuantityWithQualifier String The ordered quantity of the purchase order schedule in the secondary UOM of a dual UOM-controlled item shown with the UOM code.
Finder String Finder criteria used to filter purchase order lifecycle detail schedules based on specific search parameters and conditions.
Intent String Finder attribute to be used with the Finder column. It is the value that identifies the intent for accessing the Purchase Order Lifecycle Details resource. Valid values are APUser, POUser, LOBUser, SSPUser and NonAgentUser.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539