Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9539

PurchaseOrderLifeCycleDetailsreceipts

Displays 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 The unique identifier for the purchase order associated with the receipt.
POHeaderId Decimal The identifier for the purchase order header linked to the receipt record.
POLineId Decimal The unique identifier for the purchase order line associated with the receipt.
LineNumber Decimal The number that uniquely identifies the purchase order line.
LineLocationId [KEY] Long The unique identifier for the purchase order schedule tied to the receipt.
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 on the payment schedule.
ReceiptId [KEY] Long The unique identifier for the receipt record.
Receipt String The number that identifies the receipt.
ReceiptDate Date The date when goods or services were received.
ReceivedBy String The name of the person who received the goods or services.
CurrencyCode String The code that identifies the purchase order currency.
UOM String The unit of measure that the item uses for quantity.
UOMCode String The abbreviation that represents the unit of measure.
ReceivedQuantity Decimal The ordered quantity that has been received.
ReceivedAmount Decimal The amount received against the purchase order schedule for service lines.
DeliveredQuantity Decimal The ordered quantity that has been delivered.
DeliveredAmount Decimal The amount delivered against the purchase order schedule for the service lines.
ReturnedQuantity Decimal The ordered quantity that has been returned.
InConsignedInventory Decimal The on-hand balance of consignment goods delivered into consigned inventory but not yet consumed.
ShipmentNumber String The number that identifies the shipment.
ShipmentId Decimal The unique identifier for the shipment associated with the receipt.
ReturnToSupplierType String The return transaction type. Contains one of the following values: Return For Credit or Return For Replacement.
ReceivedInSecondaryQuantity Decimal The ordered quantity that has been received in the secondary UOM of a dual UOM-controlled item.
SecondaryUOMCode String The abbreviation that represents the 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.
ReceivedWithQualifier String The received quantity shown with its unit of measure qualifier.
DeliveredWithQualifier String The delivered quantity or amount shown with its qualifier.
ReturnedWithQualifier String The returned quantity shown with its unit of measure qualifier.
InConsignedInventoryWithQualifier String The on-hand balance of consignment goods delivered into consigned inventory but not yet consumed. Value shown with UOM code.
InvoicedQuantity Decimal The ordered quantity that has been invoiced.
InvoicedAmount Decimal The ordered amount that has been invoiced.
InvoicedWithQualifier String The quantity or amount invoiced against the purchase order schedule.
OpenToInvoiceQuantity Decimal The ordered quantity that has not been invoiced yet.
OpenToInvoiceAmount Decimal The ordered amount that has not been invoiced yet.
OpenToInvoiceWithQualifier String The quantity or amount that has not been invoiced yet.
ReceivedInSecondaryQuantityWithQualifier String The 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) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539