JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9539

PurchaseOrderLifeCycleDetails

Displays the full life cycle of a purchase order, showing how requisitions progress through ordering, shipment, receiving, invoicing, and payment to support procure-to-pay tracking.

Columns

Name Type Description
POHeaderId [KEY] Long The unique identifier for the purchase order header, linking all related schedules, shipments, receipts, and invoices.
OrderNumber String The number that uniquely identifies the purchase order in the sold-to legal entity.
OrderedAmount Decimal The total value of the order based on the quantities and prices of all goods and services.
DeliveredAmount Decimal The value of the goods and services delivered to the buying organization.
InReceivingAmount Decimal The value of the goods received by the buying organization, currently in receiving, not delivered or returned.
InTransitAmount Decimal The value of goods shipped by the supplier, but yet to be received at the buying organization.
PaidAmount Decimal The portion of invoiced charges that has been fully paid.
PartiallyPaidAmount Decimal The portion of invoiced charges that has been paid in part but not in full.
UnpaidAmount Decimal The portion of invoiced charges that remains outstanding with no payment applied.
CurrencyCode String The currency used for the purchase order and all associated financial amounts.
Finder String Finder criteria used to filter purchase order lifecycle details 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