CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

PurchaseOrderLifeCycleDetailsreceipts

The details about receipts and deliveries that are created against purchase orders, such as how many items have been received and when they were received.

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.
ReceiptId [KEY] Long Value that uniquely identifies the receipt.
Receipt String Number that identifies the receipt.
ReceiptDate Date Date when goods or services were received.
ReceivedBy String Name of the person who received the goods or services.
CurrencyCode String Code that identifies the purchase order currency.
UOM String Unit of measure that the item uses for quantity.
UOMCode String Abbreviation that identifies the unit of measure.
ReceivedQuantity Decimal Ordered quantity that has been received.
ReceivedAmount Decimal Amount received against the purchase order schedule for service lines.
DeliveredQuantity Decimal Ordered quantity that has been delivered.
DeliveredAmount Decimal Amount delivered against the purchase order schedule for the service lines.
ReturnedQuantity Decimal Ordered quantity that has been returned.
InConsignedInventory Decimal Denotes the on hand balance of consignment goods delivered into consigned inventory but not yet consumed.
ShipmentNumber String Number that identifies the shipment.
ShipmentId Decimal Value that uniquely identifies the shipment.
ReturnToSupplierType String Type of the return to supplier transaction. Contains one of the following values: Return For Credit or Return For Replacement.
ReceivedInSecondaryQuantity Decimal Ordered quantity that has been received 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.
ReceivedWithQualifier String Ordered quantity that has been received shown with the UOM code.
DeliveredWithQualifier String Quantity or amount delivered against the purchase order schedule.
ReturnedWithQualifier String Ordered quantity that has been returned shown with the UOM code.
InConsignedInventoryWithQualifier String Denotes the on hand balance of consignment goods delivered into consigned inventory but not yet consumed. Value shown with UOM code.
InvoicedQuantity Decimal Ordered quantity that has been invoiced.
InvoicedAmount Decimal Ordered amount that has been invoiced.
InvoicedWithQualifier String Quantity or amount invoiced against the purchase order schedule.
OpenToInvoiceQuantity Decimal Ordered quantity that hasn't been invoiced yet.
OpenToInvoiceAmount Decimal Ordered amount that hasn't been invoiced yet.
OpenToInvoiceWithQualifier String Quantity or amount that hasn't been invoiced yet.
ReceivedInSecondaryQuantityWithQualifier String Ordered quantity that has been received 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 receipts 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