CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

PurchaseOrderLifeCycleDetailsinvoices

The 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 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] Decimal 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.
InvoiceId [KEY] Decimal Value that uniquely identifies the invoice.
Invoice String Number that identifies the invoice.
InvoicedDate Date Date when the goods or services were invoiced.
InvoiceStatusCode String Abbreviation that identifies the invoice status.
InvoiceStatus String Status of the invoice.
HoldReasonCode String Abbreviation that identifies the reason for the invoice hold.
MatchedQuantity Decimal Invoice quantity matched to the purchase order schedule.
UOM String Unit of measure that the item uses for quantity.
UOMCode String Abbreviation that identifies the unit of measure.
MatchedQuantityWithQualifier String Invoice quantity matched to the purchase order schedule shown with the UOM code.
MatchedAmount Decimal Invoice amount matched to the purchase order schedule.
CurrencyCode String Code that identifies the purchase order currency.
MatchedAmountWithQualifier String Invoice amount matched to the purchase order schedule shown with the currency code.
ReceiptId [KEY] Decimal Value that uniquely identifies the receipt.
Receipt String Number that identifies the receipt.
ConsumptionAdvice String Number that identifies the consumption advice associated with the invoice line.
TotalInvoicedAmount Decimal Total amount of an invoice.
TotalInvoicedAmountWithQualifier String Total amount of an invoice shown with the currency code.
InvoiceType String Type of the 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) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454