ODBC Driver for Oracle Fusion Cloud Financials

Build 26.0.9770

PayablesInterfaceInvoices

Returns invoices staged in the Oracle Payables interface tables that are pending validation and import into Payables.

Columns

Name Type SupportedFinders Description
InvoiceRecordNumber String The unique sequential number assigned to an invoice.
InvoiceId [KEY] Long PrimaryKey The unique identifier of the invoice, is generated while creating the invoice.
LoadRequestId [KEY] Long PrimaryKey The unique identifier of the request associated with the interface load job that created the row.
OperatingUnit String The business unit associated with the invoice.
Source String The code that indicates the feeder system from which an invoice is created. The valid values are defined in the SOURCE lookup type. You can review the valid values using the Setup and Maintenance work area and the Manage Payables Lookups task.
GroupId String The unique name of the invoice group assigned to a group of invoices used for reporting and payment purposes. It's a mandatory attribute, which is based on the Require invoice grouping option in the Manage Invoice Options for the invoicing business unit.
InvoiceNumber String FindBySpreadsheetSearch The unique number of the supplier invoice.
InvoiceAmount Decimal The invoice amount in transaction currency. The value must be provided while creating an invoice.
InvoiceDate Date The date on the supplier invoice. The value can either be provided while creating an invoice or populated by default to the system date.
VendorName String The supplier name on the invoice. The value must be provided while creating the invoice. It can't be updated once the invoice is created.
VendorNumber String The unique number assigned to a supplier.
VendorSiteCode String The name of the physical location of the supplier from where the goods and services are rendered. The value must be provided during creation action. It can't be updated once the invoice is created.
InvoiceCurrencyCode String The three-letter ISO code associated with a currency used on the invoice.
Description String A brief description of an invoice.
InvoiceTypeLookupCode String The lookup code indicating the type of the invoice. The valid values are Standard, Prepayment, Credit Memo, and Debit Memo.
CustomerRegistrationNumber String The registration number of the customer. You can review list of valid values using the Manage Suppliers task, Transaction Tax region.
CustomerRegistrationCode String The code representing the customer legal registration. Used to derive customer registration number for an invoice. You can review list of valid values using the Manage Suppliers task, Transaction Tax region.
LegalEntityName String The name of the legal entity. The value can either be provided while creating an invoice or derived by the system.
TermsName String The name of the payment terms that's used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
TermsDate Date The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
GoodsReceivedDate Date The date when the goods were received. This date is used to calculate the invoice payment due date. The value can either be provided while creating the invoice or populated by default to the system date.
InvoiceReceivedDate Date The date when the invoice was received. This date can be used to calculate the invoice payment due date. The value can either be provided while creating the invoice or populated by default to the system date.
GlDate Date The accounting date captured on the invoice that's finally used to default to invoice lines and distributions. The value can either be provided while creating the invoice or derived based on the Accounting Date Basis option on the Manage Invoice Options for the invoicing business unit.
BudgetDate Date The budgetary calendar period date applicable for funds checking.
InvoiceIncludesPrepayFlag Bool Indicates whether the invoice amount includes the prepayment amount and any associated tax that are referenced on the supplier invoice. The default value is false.
PrepayNumber String Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice.
PrepayLineNumber Int The line number of the prepayment line applied to the invoice line.
PrepayApplyAmount Decimal Amount of prepayment to apply to the invoice. The prepayment amount must be a positive value and can't exceed the unpaid invoice amount or the amount of available prepayments.
PrepayGlDate Date Accounting date for the prepayment application.
PaymentMethodCode String The method of payment, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values.
PayGroupLookupCode String The code representing a group of supplier or invoices for a single pay run. For example, employees, merchandise, and nonmerchandise. You can review and update the valid values using Manage Payables Lookups task, lookup type PAY GROUP.
ExclusivePaymentFlag Bool Indicates whether the payment to the invoice is paid on a separate payment document.
ExchangeRateType String The source of currency conversion rate for an invoice. For example, corporate, user-defined, and spot. This is a mandatory attribute for invoices that aren't in ledger currencies, which is based on the Require conversion rate entry option in the Manage Common Options for Payables and Procurement options for the invoicing business unit. The value can either be provided while creating an invoice or populated by default from the Conversion Rate Type from the Manage Common Options for Payables and Procurement options for the invoicing business unit.
ExchangeDate Date The date as of which a conversion rate is used to convert an amount into another currency for an invoice. It's a mandatory attribute for invoices that aren't in ledger currency. The value can either be provided while creating the invoice or populated by default from the accounting date of the invoice.
ExchangeRate Decimal The conversion rate at which the principal unit of one currency is converted into another currency for an invoice. It's a mandatory attribute for invoices that aren't in ledger currency, which is based on the Require conversion rate entry option in the Manage Common Options for Payables and Procurement options for the invoicing business unit. The value can either be provided while creating the invoice or populated by default from the Manage Daily Rates for the conversion rate type and date, or can be updated later using the Apply Missing Conversion Rates process.
AmountApplicableToDiscount Decimal The invoice amount that's applicable for discount.
TransientAccount String The account combination to which liability is recorded. Payables uses the liability account combination when accounting entries are created for invoices. The value can either be provided while creating an invoice or populated by default from the Supplier Site Assignment or from the Default Distributions from Manage Common Options for Payables and Procurement options for the invoicing business unit.
DocumentCategoryCode String The document sequence category code used to derive the document sequence of the transaction. This attribute is a mandatory attribute, which is based on the Sequencing setup at Specify Ledger Options for the ledger associated to the invoicing business unit.
VoucherNumber String The manual voucher number when document sequential numbering isn't used.
FirstPartyRegistrationNumber String The tax registration number of the first party. The value can either be provided while creating an invoice or populated by default from the first party legal establishment. You can also update the value for the first-party tax registration number.
FirstPartyRegistrationId Long The unique identifier of the first party tax registration.
ThirdPartyRegistrationNumber String The tax registration number of the third party. The value can either be provided while creating an invoice or populated by default from the supplier.
ThirdPartyRegistrationId Long The unique identifier of the third party tax registration number.
RequesterFirstName String The first name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.
RequesterLastName String The last name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.
RequesterEmployeeNumber String The employee's unique identifier who made the request for the products or services.
DeliveryChannelCode String The code representing the delivery channel entered by an user. This is used as an unique identifier for a delivery channel.
BankChargeBearer String The bearer of bank charge cost. A list of accepted values are defined in the lookup type IBY_BANK_CHARGE_BEARER. You can review and update the list of acceptable values using the Setup and Maintenance work area, and the Manage Standard Lookups task.
SettlementPriority String The priority with which the financial institution or payment system should settle the payment for a document. A list of accepted values is defined in the lookup type IBY_SETTLEMENT_PRIORITY. You can review and update the valid values using Setup and Maintenance work area and the Manage Standard Lookups task.
UniqueRemittanceIdentifier String The unique identifier for the remittance. Contains reference information for a payment.
UriCheckDigit String A check digit used to validate the unique identifier of the remittance.
PaymentReasonCode String Code that indicates the reason for payment for payment system or bank with additional details for the payment. You can review the valid values using the Manage Payment Codes task. The corresponding Payment Code Type must be Payment Reason.
PaymentReasonComments String Reason for the payment.
RemittanceMessage1 String The remittance message for use in payment processing. You can provide the information during invoice creation or update it later.
RemittanceMessage2 String The remittance message for use in payment processing. You can provide the information during invoice creation or update it later.
RemittanceMessage3 String The remittance message for use in payment processing. You can provide the information during invoice creation or update it later.
TaxationCountry String The country where the transaction took place for taxation purposes. Oracle Fusion Tax sets the context of other tax drivers such as the Product Fiscal Classification based on the value of this field. The value can either be provided when creating an invoice or it's populated by default from the setup.
DocumentSubType String The classification that categorizes the document associated with an interface invoice for tax or governmental authority.
TaxInvoiceInternalSequence String The internal sequence number issued by the company for a supplier issued tax invoice.
SupplierTaxInvoiceNumber String The supplier tax invoice number.
TaxInvoiceRecordingDate Date The date when the supplier issued tax invoice was recorded. Provide value for this attribute if the company-specific tax invoice date and number is captured.
SupplierTaxInvoiceDate Date Tax invoice date on the supplier-issued tax invoice.
SupplierTaxExchangeRate Decimal The supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices.
PortOfEntryCode String Identifies the location or port through which the invoiced goods entered the country.
CorrectionYear Decimal Correction year for the invoice. For example: 2020.
CorrectionPeriod String Correction period for the invoice being corrected.
ControlAmount Decimal The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
CalculateTaxDuringImportFlag Bool Indicates whether the tax should be calculated for an invoice during import.
AddTaxToInvoiceAmountFlag Bool Indicates whether the tax amount should be added to the invoice amount.
NoXrateBaseAmount Decimal Invoice amount in the ledger currency. Used to calculate conversion rate. Used only when Calculate User Exchange Rate option is enabled for foreign currency invoices with exchange rate type of User.
PaymentCurrencyCode String The code representing the currency that the payment is made in.
AttributeCategory String Descriptive flexfield context name for interface invoice.
Attribute1 String A segment for the interface invoices descriptive flexfield.
Attribute2 String A segment for the interface invoices descriptive flexfield.
Attribute3 String A segment for the interface invoices descriptive flexfield.
Attribute4 String A segment for the interface invoices descriptive flexfield.
Attribute5 String A segment for the interface invoices descriptive flexfield.
Attribute6 String A segment for the interface invoices descriptive flexfield.
Attribute7 String A segment for the interface invoices descriptive flexfield.
Attribute8 String A segment for the interface invoices descriptive flexfield.
Attribute9 String A segment for the interface invoices descriptive flexfield.
Attribute10 String A segment for the interface invoices descriptive flexfield.
Attribute11 String A segment for the interface invoices descriptive flexfield.
Attribute12 String A segment for the interface invoices descriptive flexfield.
Attribute13 String A segment for the interface invoices descriptive flexfield.
Attribute14 String A segment for the interface invoices descriptive flexfield.
Attribute15 String A segment for the interface invoices descriptive flexfield.
GlobalAttributeCategory String The global descriptive flexfield context name for the interface invoice.
GlobalAttribute1 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute2 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute3 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute4 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute5 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute6 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute7 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute8 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute9 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute10 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute11 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute12 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute13 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute14 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute15 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute16 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute17 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute18 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute19 String A segment for the interface invoices global descriptive flexfield.
GlobalAttribute20 String A segment for the interface invoices global descriptive flexfield.
GlobalAttributeDate1 Date A date segment for the interface invoices global descriptive flexfield.
GlobalAttributeDate2 Date A date segment for the interface invoices global descriptive flexfield.
GlobalAttributeDate3 Date A date segment for the interface invoices global descriptive flexfield.
GlobalAttributeDate4 Date A date segment for the interface invoices global descriptive flexfield.
GlobalAttributeDate5 Date A date segment for the interface invoices global descriptive flexfield.
GlobalAttributeNumber1 Decimal A number segment for the interface invoices global descriptive flexfield.
GlobalAttributeNumber2 Decimal A number segment for the interface invoices global descriptive flexfield.
GlobalAttributeNumber3 Decimal A number segment for the interface invoices global descriptive flexfield.
GlobalAttributeNumber4 Decimal A number segment for the interface invoices global descriptive flexfield.
GlobalAttributeNumber5 Decimal A number segment for the interface invoices global descriptive flexfield.
TermsId Long The unique identifier of the payment terms that's used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice.
AcctsPayCodeCombinationId Long The unique identifier of the account combination to which liability is recorded. Payables uses the liability account combination when accounting entries are created for invoices.
TaxRelatedInvoiceId Long The unique identifier of the related tax invoice.
BankAccountNumber String The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes.
RemitToSupplierName String The third-party payment related remit-to supplier where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to supplier page.
RemitToSupplierNumber String The supplier number of the third party.
RemitToAddressName String The third-party payment related remit-to address where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to address page.
AwtGroupId Long The unique identifier of the withholding tax group. If the identifier isn't available, use the attribute AwtGroupName.
RequesterId Long The unique identifier of the requester.
ApplicationId Long The unique identifier of the source application.
LegalEntityId Long The unique identifier of the legal entity on the interface invoice.
ProductTable String Name of the product source table used to generate an invoice.
ReferenceKey1 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey2 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey3 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey4 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey5 String The primary key information that uniquely identifies the record in another product's view.
ImageDocumentUri String The unique reference number to identify the image with the invoice.
ExternalBankAccountIBANNumber String The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes.
RequesterEmailAddress String The email address of the employee for the requested items.
IntercompanyCrossChargeFlag Bool Indicates whether the invoice is categorized as a cross charged intercompany invoice.
ImportRequestId Long The request identifier of the job that created or last updated the row.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
Queues String The queue name assigned to the invoice rejection.
OrgId Long The unique identifier of the business unit associated with the invoice. If the business unit identifier isn't available, use the OperatingUnit attribute.
VendorId Long The unique identifier of the supplier on the interface invoice.
VendorSiteId Long The unique identifier of the supplier site on the interface invoice.
ApplyAdvancesFlag Bool Indicates whether the advance should be applied to the expense reports and other invoices.
AwtGroupName String Name of the withholding tax group. This is used to apply multiple withholding taxes to an invoice line. Valid values are defined in Manage Withholding Groups task.
ExternalBankAccountId Long The unique identifier for the supplier bank account. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes. If you provide values for multiple bank account-related attributes, such as Bank Account, Supplier IBAN, or External Bank Account ID, then all the information provided is validated.
ExternalDocumentReference String The internal document reference number from Accounts Receivables system.
ImportDocumentDate Date The date assigned by the user during import of invoice.
ImportDocumentNumber String The document number assigned by the user.
NetOfRetainageFlag Bool Indicates whether the retainage amount is deducted from the invoice amount.
PaidOnBehalfEmployeeId Long The employee ID of the employee associated with the original expense report, when the expense report is split using Both Pay Scenario.
PartyId Long The unique identifier of the party associated with the supplier or party associated with the employee or customers for payment request type of invoices.
PartySiteId Long The unique identifier of the party associated with the supplier site.
PayProcTrxnTypeCode String The code representing the type of payment processing transaction or document.
PaymentCrossRate Decimal Conversion rate used to convert the entered amount to ledger currency if the entered amount isn't in ledger currency.
PaymentCrossRateDate Date The date as of which a conversion rate is used to convert the entered amount into ledger currency.
PaymentCrossRateType String The source of a currency conversion rate used to convert the derived amount into ledger currency, such as user defined, spot, or corporate.
PaymentFunction String The function or purpose of the payment.
PaymentMethodLookupCode String Name of the payment method. Use the Manage Payables Lookups task, lookup type PAYMENT METHOD to identify valid values.
PaymentPriority Int The payment priority for a scheduled payment. Valid values are whole numbers from 1 to 99.
Reference1 String Captures invoice reference information from non-Oracle application.
Reference2 String Captures invoice reference information from non-Oracle application.
ShipToLocation String The location where the goods and services have been shipped to by the supplier.
VendorEmailAddress String The supplier email address on the invoice.
RoutingAttribute1 String Captures additional attributes information that may have been used for routing payables invoice images.
RoutingAttribute2 String Captures additional attributes information that may have been used for routing payables invoice images.
RoutingAttribute3 String Captures additional attributes information that may have been used for routing payables invoice images.
RoutingAttribute4 String Captures additional attributes information that may have been used for routing payables invoice images.
RoutingAttribute5 String Captures additional attributes information that may have been used for routing payables invoice images.
Status String Status of the row for the import process.
AttributeDate1 Date A date segment for the interface invoices descriptive flexfield.
AttributeDate2 Date A date segment for the interface invoices descriptive flexfield.
AttributeDate3 Date A date segment for the interface invoices descriptive flexfield.
AttributeDate4 Date A date segment for the interface invoices descriptive flexfield.
AttributeDate5 Date A date segment for the interface invoices descriptive flexfield.
AttributeNumber1 Decimal A number segment for the interface invoices descriptive flexfield.
AttributeNumber2 Decimal A number segment for the interface invoices descriptive flexfield.
AttributeNumber3 Decimal A number segment for the interface invoices descriptive flexfield.
AttributeNumber4 Decimal A number segment for the interface invoices descriptive flexfield.
AttributeNumber5 Decimal A number segment for the interface invoices descriptive flexfield.
ImageDocumentNumber String The unique image document number associated with the invoice.
PONumber String Document number used to request a seller to supply a product or service for payment.
InitExceptionCategoryTransient String Category of the exception associated with the rejection raised on the invoice.
InitSourceTransient String The code that indicates the feeder system from which an invoice is created. The valid values are defined in the SOURCE lookup type. You can review the valid values using the Setup and Maintenance work area and the Manage Payables Lookups task.
InitBusinessUnitTransient Long The business unit associated with the invoice.
InitOwnerTransient String The user name of the owner associated with the interface invoice.
Owner String FindBySpreadsheetSearch The user name of the owner associated with the interface invoice.
DigitalPaymentAccountName String Name of the digital payment account used to remit the payment.
LogicalDocumentId Long A unique identifier generated by Document IO for each invoice, providing end-to-end traceability, supporting bulk adaptive learning across invoices, and serving as a standard reference for all Document IO consumers.
BusinessUnit String FindBySpreadsheetSearch The business unit name supplied as a finder input when querying payables interface invoices.
BusinessUnitId Long FindBySpreadsheetSearch The business unit identifier supplied as a finder input when querying payables interface invoices.
ChannelPartnerReference String FindByB2BInvoiceStatus, findByProcessedStatus The channel partner reference supplied as a finder input when querying payables interface invoices.
CreationDateFrom Datetime FindByB2BInvoiceStatus, findByProcessedStatus, findBySpreadsheetSearch The start of the creation date range supplied as a finder input when querying payables interface invoices.
CreationDateTo Datetime FindByB2BInvoiceStatus, findByProcessedStatus, findBySpreadsheetSearch The end of the creation date range supplied as a finder input when querying payables interface invoices.
ExceptionCategory String FindBySpreadsheetSearch The exception category supplied as a finder input when querying payables interface invoices.
Finder String A named finder reference used to filter or locate specific payables interface invoices when querying.
HeadersOnly String FindBySpreadsheetSearch The flag supplied as a finder input to return only invoice headers when querying payables interface invoices.
ImportError String FindBySpreadsheetSearch The import error value supplied as a finder input when querying payables interface invoices.
ImportRequestNumber Long FindByB2BInvoiceStatus, findByProcessedStatus The import request number supplied as a finder input when querying payables interface invoices.
ImportSet String FindByB2BInvoiceStatus, findByProcessedStatus, findBySpreadsheetSearch The import set name supplied as a finder input when querying payables interface invoices.
InvoiceSource String FindByProcessedStatus, findBySpreadsheetSearch The invoice source supplied as a finder input when querying payables interface invoices.
LedgerId Long FindBySpreadsheetSearch The ledger identifier supplied as a finder input when querying payables interface invoices.
LineNumberFrom Long FindBySpreadsheetSearch The start of the line number range supplied as a finder input when querying payables interface invoices.
LineNumberTo Long FindBySpreadsheetSearch The end of the line number range supplied as a finder input when querying payables interface invoices.
NoOfInvoices Long FindBySpreadsheetSearch The number of invoices supplied as a finder input when querying payables interface invoices.
Queue String FindBySpreadsheetSearch The processing queue supplied as a finder input when querying payables interface invoices.
ShowOnlyErrorLines String FindBySpreadsheetSearch The flag supplied as a finder input to return only error lines when querying payables interface invoices.
Supplier String FindBySpreadsheetSearch The supplier name supplied as a finder input when querying payables interface invoices.
SupplierId Long FindBySpreadsheetSearch The supplier identifier supplied as a finder input when querying payables interface invoices.
SupplierNotified String FindByB2BInvoiceStatus The supplier notified indicator supplied as a finder input when querying payables interface invoices.
SupplierSite String FindBySpreadsheetSearch The supplier site supplied as a finder input when querying payables interface invoices.
SupplierSiteId Long FindBySpreadsheetSearch The supplier site identifier supplied as a finder input when querying payables interface invoices.
TotalNoOfInvoiceLines Long FindBySpreadsheetSearch The total number of invoice lines supplied as a finder input when querying payables interface invoices.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770