CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

PurchaseOrderLifeCycleDetailsschedules

The 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 Value that uniquely identifies the purchase order.
POHeaderId Decimal Value that uniquely identifies the purchase order.
POLineId Decimal Value that uniquely identifies the purchase order line.
LineNumber Decimal Number that uniquely identifies the purchase order line.
LineLocationId [KEY] Long Value that uniquely identifies the purchase order schedule.
ScheduleNumber Decimal Number that uniquely identifies the purchase order schedule for the purchase order line.
LineNumberScheduleNumber String Line and schedule number for a purchase order.
LineDescription String Description of the item that the purchase order references.
ScheduleDescription String Description of the work associated with the progress payment schedule.
ItemOrScheduleDescription String Either the description of the item or the work associated with the progress payment schedule.
Requisition String Number that identifies the requisition.
RequisitionLine Decimal Number that uniquely identifies the requisition line for the requisition.
RequisitionNumberLineNumber String Requisition and line number for a requisition.
RequestedQuantity Decimal Quantity requested on the requisition line associated with the purchase order schedule.
UOM String Unit of measure that the item uses for quantity.
UOMCode String Abbreviation that identifies the unit of measure.
RequestedAmount Decimal Amount requested on the requisition line associated with the purchase order schedule.
CurrencyCode String Code that identifies the purchase order currency.
RequestedWithQualifier String Quantity or amount requested on the requisition line associated with the purchase order schedule.
OrderedQuantity Decimal Total quantity ordered for this purchase order schedule.
OrderedQuantityWithQualifier String Total quantity ordered for this purchase order schedule shown with the UOM code.
OrderedAmount Decimal Total amount ordered for this purchase order schedule.
OrderedAmountWithQualifier String Total amount ordered for this purchase order schedule shown with the currency code.
ShippedQuantity Decimal Total number of items shipped by the supplier.
ShippedQuantityWithQualifier String Total number of items shipped by the supplier in the purchase order line UOM.
InTransitQuantity Decimal Ordered quantity shipped by the supplier, but yet to be received at the buying organization.
InTransitQuantityWithQualifier String Ordered quantity shipped by the supplier, but yet to be received at the buying organization. Value is shown with the UOM code.
ReceivedQuantity Decimal Ordered quantity that has been received.
ReceivedAmount Decimal Ordered amount that has been received.
ReceivedWithQualifier String Quantity or amount received against the purchase order schedule.
InReceivingQuantity Decimal Ordered quantity received by the buying organization, currently in receiving, and not delivered, or returned.
InReceivingQuantityWithQualifier String Ordered quantity received by the buying organization, currently in receiving, and not delivered, or returned. Value is shown with UOM code.
DeliveredQuantity Decimal Ordered quantity or amount that has been delivered.
DeliveredAmount Decimal Amount delivered against the purchase order schedule for service lines.
DeliveredWithQualifier String Quantity or amount delivered against the purchase order schedule.
InvoicedQuantity Decimal Ordered quantity that has been invoiced.
InvoicedQuantityWithQualifier String Ordered quantity that has been invoiced shown with the UOM code.
InvoicedAmount Decimal Ordered amount that has been invoiced.
InvoicedAmountWithQualifier String Ordered amount that has been invoiced shown with the currency code.
DueDate Date Date when the goods are requested or promised for delivery.
ReceiptDate Date 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 Ordered quantity that has been received against the purchase order schedule in the secondary UOM of a dual UOM-controlled item.
SecondaryUOMCode String Abbreviation that identifies the UOM that's allowed to quantify a dual UOM-controlled item.
SecondaryUOM String An alternative UOM that's allowed to quantify a dual UOM-controlled item.
OpenToInvoiceQuantity Decimal Ordered quantity that hasn't been invoiced yet.
OpenToInvoiceAmount Decimal Ordered amount that hasn't been invoiced yet.
OrderedInSecondaryQuantity Decimal Ordered quantity of the purchase order schedule in the secondary UOM of a dual UOM-controlled item.
OpenToInvoiceWithQualifier String Quantity or amount that hasn't been invoiced yet.
ReceivedInSecondaryQuantityWithQualifier String 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 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) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454