JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9539

PurchaseOrderLifeCycleDetailsinvoices

Displays details about supplier invoices that are created against purchase orders, such as matched quantities and amounts and total invoice amounts.

Columns

Name Type Description
PurchaseOrderLifeCycleDetailsPOHeaderId [KEY] Long The unique identifier for the purchase order associated with the invoice.
POHeaderId Decimal The identifier for the purchase order header linked to the invoice record.
POLineId Decimal The unique identifier for the purchase order line associated with the invoice.
LineNumber Decimal The number that uniquely identifies the purchase order line.
LineLocationId [KEY] Decimal The unique identifier for the purchase order schedule associated with the invoice.
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 associated with the payment schedule.
InvoiceId [KEY] Decimal The unique identifier for the invoice.
Invoice String The number that identifies the invoice.
InvoicedDate Date The date when the goods or services were invoiced.
InvoiceStatusCode String The abbreviation that identifies the invoice status.
InvoiceStatus String The status of the invoice.
HoldReasonCode String The abbreviation that identifies the reason for the invoice hold.
MatchedQuantity Decimal The invoice quantity matched to the purchase order schedule.
UOM String The unit of measure that the item uses for quantity.
UOMCode String The abbreviation that identifies the unit of measure.
MatchedQuantityWithQualifier String The invoice quantity matched to the purchase order schedule shown with the UOM code.
MatchedAmount Decimal The invoice amount matched to the purchase order schedule.
CurrencyCode String The code that identifies the purchase order currency.
MatchedAmountWithQualifier String The invoice amount matched to the purchase order schedule shown with the currency code.
ReceiptId [KEY] Decimal The unique identifier for the receipt associated with the invoice.
Receipt String The number that identifies the receipt.
ConsumptionAdvice String The number that identifies the consumption advice associated with the invoice line.
TotalInvoicedAmount Decimal The total amount of an invoice.
TotalInvoicedAmountWithQualifier String The total amount of an invoice shown with the currency code.
InvoiceType String Type of invoice. Contains one of the following values: Prepayment, Credit Memo, Debit Memo or Standard Invoice.
Finder String Finder criteria used to filter purchase order lifecycle detail invoices 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