PayablesInvoiceTransaction

An invoice transaction represents details of all the transactions related to purchases made for producing goods and services or managing business operations, excluding payment requests, taxes, joint ventures, and intercompany transactions.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesInvoiceTransactionsExtract**

  An invoice transaction represents details of all the transactions related to purchases made for producing goods and services or managing business operations, excluding payment requests, taxes, joint ventures, and intercompany transactions.

  Label, Plural Label

  Invoice Transaction, Payables Invoice Transactions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountingDate (date)

    The accounting date captured on the invoice that's 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 options on the manage invoice options for the invoicing business unit.

    Label

    Invoice Accounting Date

    Properties

    • not nullable
  • amountApplicableToDiscount (big-decimal)

    The invoice amount used as the basis for calculation of discount.

    Label

    Discountable Amount

  • amountPaid (big-decimal)

    The amount paid for the invoice.

    Label

    Invoice Amount Paid

  • approvalIteration (int32)

    The number of times the invoice has passed through the invoice approval workflow process.

    Label

    Invoice Approval Iteration

  • approvalReadyFlag (boolean)

    Indicates whether the invoice is ready for approval using the invoice approval workflow. Valid values are Y and N.

    Label

    Ready for Approval

    Properties

    • not nullable
  • approvedAmount (big-decimal)

    The invoice amount approved through the invoice approval workflow process.

    Label

    Approved Amount

  • bankChargeBearer (string)

    Bearer of bank charge cost.

    Label

    Bank Charge Bearer

  • baseAmount (big-decimal)

    The invoice amount in the ledger currency.

    Label

    Invoice Amount in Ledger Currency

  • budgetDate (date)

    The budgetary calendar period date applicable for funds checking.

    Label

    Budget Date

  • cancelledAmount (big-decimal)

    The original amount of the canceled invoice.

    Label

    Canceled Amount

  • cancelledBy (string)

    The user who canceled an invoice.

    Label

    Canceled By

  • cancelledDate (date)

    The date when the invoice was canceled.

    Label

    Canceled Date

    Properties

    • searchable
    • sortable
  • cancelledFlag (boolean)

    Indicates whether the invoice is canceled. If true, the invoice has been canceled. If false, the invoice hasn't been canceled.

    Label

    Canceled

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
    • updatable
  • checkVATAmountPaid (string)

    Indicates whether a partially paid purchase transaction is reportable for tax. This is used for tax reporting purposes in Eastern and Central Europe.

    Label

    VAT Amount Paid Indicator

  • conversionDate (date)

    The date as of which a conversion rate is used to convert an amount into another currency for an invoice. Conversion date is a mandatory attribute for invoices that aren't in ledger currency. The value can either be provided while creating the invoice or defaults from the accounting date of the invoice.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The conversion rate at which the principal unit of one currency is converted into another currency for an invoice. 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.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the row.

    Label

    Created By

    Properties

    • not nullable
  • customerRegistrationCode (string)

    The first party tax registration code.

    Label

    Customer Registration Code

  • customerRegistrationNumber (string)

    The first party tax registration number.

    Label

    Tax Registration Number

  • deliveryChannelCode (string)

    The payment code representing the text on electronic payment that instructs the bank about the execution of payment. For example, print a check and hold it for collection by the payee. The value can either be provided while creating the invoice or defaults from the supplier site or address or profile level payment attributes.

    Label

    Delivery Channel

  • description (string)

    The statement that describes the invoice.

    Label

    Description

  • discountAmountTaken (big-decimal)

    The discount amount on the invoice.

    Label

    Discount Amount

  • documentCategoryCode (string)

    The sequential numbering document category name.

    Label

    Document Category

  • documentSequenceValue (big-decimal)

    The sequence number is a number assigned to the document when document sequential numbering is enabled.

    Label

    Document Sequence

  • exclusivePaymentFlag (boolean)

    Indicates whether the invoice should be paid with its own payment document without including other invoices for the supplier.

    Label

    Pay Alone

  • forceRevalidationFlag (boolean)

    Indicates whether the revalidation is allowed for the invoice. Valid values are Y and N.

    Label

    Force Revalidation Indicator

  • invoiceAmount (big-decimal)

    The invoice amount in transaction currency. This attribute value must be provided while creating an invoice.

    Label

    Invoice Amount

  • invoiceDate (date)

    The date on the supplier invoice. The value can either be provided while creating an invoice or defaults to the system date.

    Label

    Invoice Date

    Properties

    • searchable
  • invoiceId (int64)

    The unique identifier of the invoice that's generated while creating the invoice.

    Label

    Invoice ID

    Properties

    • searchable
    • sortable
    • not nullable
  • invoiceNumber (string)

    The unique number for supplier invoice.

    Label

    Invoice Number

    Properties

    • searchable
    • sortable
    • not nullable
  • invoiceTypeDiscriminator (string)

    The discriminator to distinguish Payables Invoice and Payment Request subtypes.

    Label

    Discriminator

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
    • updatable
  • logicalDocumentIdentifier (int64)

    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.

    Label

    Logical Document ID

  • payProcurementTransactionTypeCode (string)

    The code representing the type of payment processing transaction or document for the invoice.

    Label

    Payment Process Transaction Type Code

  • paymentAmountTotal (big-decimal)

    The amount of invoice paid.

    Label

    Invoice Payment Amount Total

  • paymentCrossRate (big-decimal)

    The conversion rate between the invoice currency and the payment currency.

    Label

    Payment Cross-Conversion Rate Type

    Properties

    • not nullable
  • paymentCrossRateDate (date)

    The date effective for the conversion rate.

    Label

    Payment Cross-Conversion Date

  • paymentCurrencyInvoiceAmount (big-decimal)

    The currency used to make a payment. The value can either be provided while creating an invoice or defaults from the supplier site or from the manage invoice options for the invoicing business unit.

    Label

    Invoice Amount in Payment Currency

  • paymentReasonCode (string)

    The user-entered payment reason code that helps to uniquely identify a payment reason.

    Label

    Payment Reason

  • paymentReasonComments (string)

    The comments indicating the reason for creating the payment. The value can either be provided while creating an invoice or defaults from the supplier site or address or profile level payment attributes.

    Label

    Payment Reason Comments

  • postingStatus (string)

    The code representing the posting status of the invoice. A list of accepted values are defined in the lookup POSTING STATUS.

    Label

    Invoice Posting Status Indicator

  • productTable (string)

    The name of the product source table used to generate the invoice.

    Label

    Product Table

  • reference1 (string)

    The reference information from the Oracle Projects expense reports.

    Label

    Reference 1

  • reference2 (string)

    The reference information from the Oracle Projects expense reports.

    Label

    Reference 2

  • referenceKey1 (string)

    The primary key information that uniquely identifies the record in another product's view.

    Label

    Reference Key 1

  • referenceKey2 (string)

    The primary key information that uniquely identifies the record in another product's view.

    Label

    Reference Key 2

  • referenceKey3 (string)

    The primary key information that uniquely identifies the record in another product's view.

    Label

    Reference Key 3

  • referenceKey4 (string)

    The primary key information that uniquely identifies the record in another product's view.

    Label

    Reference Key 4

  • referenceKey5 (string)

    The primary key information that uniquely identifies the record in another product's view.

    Label

    Reference Key 5

  • remittanceMessage1 (string)

    Remittance message provided for payment processing. You can provide the information during invoice creation or update it later.

    Label

    Remittance Message 1

  • remittanceMessage2 (string)

    Remittance message provided for payment processing. You can provide the information during invoice creation or update it later.

    Label

    Remittance Message 2

  • remittanceMessage3 (string)

    Remittance message provided for payment processing. You can provide the information during invoice creation or update it later.

    Label

    Remittance Message 3

  • requestIdentifier (int64)

    Properties

    • not nullable
  • temporaryCancelledAmount (big-decimal)

    Column for recording the original amount of an invoice until cancellation completes successfully.

    Label

    Original Amount

  • 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.

    Label

    Terms Date

  • timeCreated (date-time)

    The date and time when the row was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the row was last updated.

    Label

    Last Update Date

    Properties

    • searchable
    • not nullable
  • uniqueRemittanceIdentifier (string)

    The unique identifier for a remittance. Contains reference information for a payment.

    Label

    Unique Remittance Identifier

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • uriCheckDigit (string)

    A check digit used to validate the unique remittance identifier.

    Label

    Unique Remittance Identifier Check Digit

  • validatedTaxAmount (big-decimal)

    The total tax amount excluded from the discountable amount.

    Label

    Validated Tax Amount

  Subtype

  • Discriminator:

    InvoicePaymentRequest

  • An invoice provides the details of the products or services provided by the merchant, including the invoice number, invoice date, invoice amount, supplier, and currency.

    Business Object

    PayablesInvoice

    Expand all

    Collapse all

    Fields

    • applyAfterDate (date)

      The date associated with a prepayment invoice after which you can apply the prepayment against invoices. It's only used for temporary prepayments. The column is null for permanent prepayments and other invoice types. The value can either be provided while creating an invoice or derived based on the prepayment settlement days setup in the manage invoice options for the invoicing business unit.

      Label

      Apply After Date

    • approvalDescription (string)

      A brief description about the invoice approval. The attribute value is for reference only.

      Label

      Invoice Approval Description

    • automaticWithholdingTaxFlag (boolean)

      Indicates whether withholding tax has been calculated automatically or manually. A value of A indicates automatic calculation and a value of M indicates manual calculation.

      Label

      Withholding Tax Indicator

    • controlAmount (big-decimal)

      The user-enterable value to ensure that the calculated tax will be the same as on the physical document.

      Label

      Control Amount

    • correctionPeriod (string)

      The tax declaration period for the invoice being corrected.

      Label

      Correction Period

    • correctionYear (int32)

      The tax declaration year for the invoice being corrected.

      Label

      Correction Year

    • documentSubType (string)

      The classification that categorizes the document associated with a transaction for tax.

      Label

      Document Subtype

    • excludeFreightFromDiscountFlag (boolean)

      Indicates whether the freight amount is excluded from the discountable amount when calculating the invoice amount subject to discount. Valid values are Y and N.

      Label

      Exclude Freight from Discount Indicator

    • excludeTaxFromDiscountFlag (boolean)

      Indicates whether the tax amount is excluded from the discountable amount when calculating the invoice amount subject to tax. Valid values are Y and N.

      Label

      Exclude Tax from Discount Indicator

    • fiscalDocumentAccessKey (string)

      The unique identifier of the fiscal document, which is generated by concatenating multiple attributes of the fiscal document.

      Label

      Fiscal Document Access Key

    • freightAmount (big-decimal)

      The total freight amount for the invoice.

      Label

      Freight Amount

    • goodsReceivedDate (date)

      The date when the goods were received.

      Label

      Goods Received

    • imageDocumentNumber (string)

      The unique image document number associated with the invoice. For internal use only.

      Label

      Image Document Number

    • importDocumentDate (date)

      The import declaration date associated with the import document number.

      Label

      Import Document Date

    • intercompanyFlag (boolean)

      Indicates whether the invoice is an intercompany invoice. Valid values are Y and N.

      Label

      Intercompany invoice

    • 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 defaults to the system date.

      Label

      Invoice Received Date

    • lockTime (date-time)

      The time when the invoice is locked for editing.

      Label

      Lock Time

    • lockedBy (string)

      The user who has locked the invoice for editing.

      Label

      Locked By

    • netOfRetainageFlag (boolean)

      Indicates whether the invoice amount is net of retainage.

      Label

      Net of Retainage

    • portOfEntryCode (string)

      The code representing the location or port through which the invoiced goods entered the country.

      Label

      Customs Location Code

    • purchaseOrderMatchedFlag (boolean)

      Indicates whether the invoice is matched to a purchase order.

      Label

      Purchase Order Matched Indicator

    • releaseAmountNetOfTax (big-decimal)

      The invoice amount net of tax for retainage release invoices.

      Label

      Release Amount Net of Tax

    • remitToAddressName (string)

      The third-party payment related remit-to address where the payment is sent.

      Label

      Remit-to Address Name

    • remitToSupplierName (string)

      Name of the third party supplier.

      Label

      Remit-to Supplier

    • routingAttribute1 (string)

      Additional attributes information that may have been used for routing payables invoice images.

      Label

      Routing Attribute 1

    • routingAttribute2 (string)

      Additional attributes information that may have been used for routing payables invoice images.

      Label

      Routing Attribute 2

    • routingAttribute3 (string)

      Additional attributes information that may have been used for routing payables invoice images.

      Label

      Routing Attribute 3

    • routingAttribute4 (string)

      Additional attributes information that may have been used for routing payables invoice images.

      Label

      Routing Attribute 4

    • routingAttribute5 (string)

      Additional attributes information that may have been used for routing payables invoice images.

      Label

      Routing Attribute 5

    • selfAssessedTaxAmount (big-decimal)

      The total self-assessed tax amount on the invoice.

      Label

      Invoice Self-Assessed Tax Amount

    • supplierTaxExchangeRate (big-decimal)

      Conversion rate entered for taxes on a supplier invoice.

      Label

      Supplier Tax Invoice Conversion Rate

    • supplierTaxInvoiceDate (date)

      The date when the supplier charged tax, as shown on the purchase order.

      Label

      Supplier Tax Invoice Date

    • supplierTaxInvoiceNumber (string)

      The supplier tax invoice number on the invoice.

      Label

      Supplier Tax Invoice Number

    • taxInvoiceInternalSequence (string)

      The internal sequence number for a supplier issued tax invoice.

      Label

      Internal Sequence Number

    • taxInvoiceRecordingDate (date)

      The date when the tax invoice was recorded.

      Label

      Internal Recording Date

    • taxationCountry (string)

      The country in which the transaction is deemed to have taken place for taxation purposes. Oracle Fusion Tax will set the context of other tax drivers such as product fiscal classification based on the value of this field.

      Label

      Taxation Country

    • totalTaxAmount (big-decimal)

      The total tax charged on the invoice.

      Label

      Total Tax Charged

    • transactionBusinessCategory (string)

      The transaction category assigned to the invoice. Used to identify and classify business transactions for the purpose of tax calculation.

      Label

      Transaction Business Category

    • transactionDeadline (big-decimal)

      Information pertaining to the declaration or register of certain intracommunity transactions, including the number of days to perform the transactions. This attribute is used for Spanish transactions only.

      Label

      Transaction Deadline

    • userDefinedFiscalClassification (string)

      A classification for any tax requirement that you can't define using the existing fiscal classification types.

      Label

      User-Defined Fiscal Classification

    • voucherNumber (string)

      The manual voucher number when document sequential numbering isn't used.

      Label

      Voucher Number

    Expand all

    Collapse all

    Reference Object

    • automaticWithholdingTaxGroup (PayablesAutomaticTaxWithholdingGroup)

      The automatic tax withholding group contains withholding tax groups. Each withholding tax group contains one or more withholding tax codes.

      Business Object

      PayablesAutomaticTaxWithholdingGroup

      Expand all

      Collapse all

      Fields

      • groupId (int64)

        The unique identifier for the withholding tax group.

        Label

        Group ID

        Properties

        • searchable
        • sortable
        • not nullable

    • purchaseOrder (Order)

      The unique identifier of the purchase order that the invoice is matched to.

      Business Object

      Order

      Expand all

      Collapse all

      Fields

      • orderHeaderId (int64)

        Value that uniquely identifies the purchase order header.

        Label

        Header ID

        Properties

        • searchable
        • sortable
        • not nullable

    • relationship (ThirdPartyPaymentRelationship)

      The third-party relationship to whom the payment is made.

      Business Object

      ThirdPartyPaymentRelationship

      Expand all

      Collapse all

      Fields

      • id (int64)

        Value that uniquely identifies the supplier third-party payment relationship.

        Label

        Third-Party Payment Relationship ID

        Properties

        • searchable
        • sortable
        • not nullable

    • remitToAddress (PayablesPaymentRequestorAddress)

      Remit-to address where payment should be sent.

      Business Object

      PayablesPaymentRequestorAddress

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier for an address.

        Label

        Site ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • remitToSupplier (Supplier)

      The identifier of the third-party payment related remit-to supplier where the payment is sent.

      Business Object

      Supplier

      Expand all

      Collapse all

      Fields

      • supplierId (int64)

        Value that uniquely identifies the supplier.

        Label

        Supplier ID

        Properties

        • searchable
        • sortable
        • not nullable

    • requestor (Worker)

      The unique identifier of the person who requested the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.

      Business Object

      Worker

      Expand all

      Collapse all

      Fields

      • id (int64)

        Unique identifier of person business object.

        Label

        Id

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • supplier (Supplier)

      A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.

      Business Object

      Supplier

      Expand all

      Collapse all

      Fields

      • supplierId (int64)

        Value that uniquely identifies the supplier.

        Label

        Supplier ID

        Properties

        • searchable
        • sortable
        • not nullable

    • supplierAddress (Address)

      The unique identifier of supplier or party site.

      Business Object

      Address

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier for an address.

        Label

        Site ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • supplierSite (SupplierSite)

      A supplier site contains the details about the terms, controls, and policies that govern how procure to pay transactions are executed between the buying organization and the supplier. You can have multiple sites for a supplier. For example, a purchasing site or a pay site.

      Business Object

      SupplierSite

      Expand all

      Collapse all

      Fields

      • id (int64)

        Value that uniquely identifies the supplier site.

        Label

        Supplier Site ID

        Properties

        • searchable
        • sortable
        • not nullable

    • taxRelatedInvoice (PayablesInvoiceTransaction)

      The identifier of the invoice tax related invoice.

      Business Object

      PayablesInvoiceTransaction

      Expand all

      Collapse all

      Fields

      • invoiceId (int64)

        The unique identifier of the invoice that's generated while creating the invoice.

        Label

        Invoice ID

        Properties

        • searchable
        • sortable
        • not nullable
      • invoiceNumber (string)

        The unique number for supplier invoice.

        Label

        Invoice Number

        Properties

        • searchable
        • sortable
        • not nullable
      • invoiceTypeDiscriminator (string)

        The discriminator to distinguish Payables Invoice and Payment Request subtypes.

        Label

        Discriminator

        Properties

        • creatable
        • searchable
        • sortable
        • not nullable
        • updatable

    • vendorContact (ContactAddressRelationship)

      The contact person at the supplier associated with the invoice.

      Business Object

      ContactAddressRelationship

      Expand all

      Collapse all

      Fields

      • id (int64)

        Unique identifier for the relationship between a supplier contact and supplier address.

        Label

        Contact Address Relationship ID

        Properties

        • searchable
        • sortable
        • not nullable

    A payment request is a one-time payment request type that allows users to initiate a payment for a specific purpose outside of the regular payables or receivables processes. This could include various types of payments such as refunds, reimbursements, bonuses, or one-time merchant payments that don't follow the usual procurement or invoicing workflows. This type of payment request invoice doesn't require a defined supplier in the application.

    Business Object

    PayablesPaymentRequest

    Expand all

    Collapse all

    Fields

    • amountDueEmployee (big-decimal)

      The amount that's due to an employee.

      Label

      Amount Due to Employee

    • amountDueToCreditCardCompany (big-decimal)

      The amount that's due to the credit card company.

      Label

      Amount Due to Credit Card Company

    • employeeAddressCode (string)

      The address code of the employee. Valid values are HOME and OFFICE.

      Label

      Employee Address Code

    • internalContactEmail (email)

      The email address of the internal contact.

      Label

      Internal Contact Email

    Expand all

    Collapse all

    Reference Object

    • paymentRequestor (PayablesPaymentRequestor)

      A payment requester represents an individual or entity that initiates a request to create a payment request invoice. It provides details of the payment requester such as name, number, and other information.

      Business Object

      PayablesPaymentRequestor

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the party.

        Label

        Party ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
        • overridable

    • paymentRequestorAddress (PayablesPaymentRequestorAddress)

      The payment requester address stores all the addresses associated to a payment requester.

      Business Object

      PayablesPaymentRequestorAddress

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier for an address.

        Label

        Site ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • personDetail (PersonDetail)

      The identifier of the employee on the new expense report created when an expense report gets split in the both pay scenario. This identifier is populated with the original expense report's employee identifier.

      Business Object

      PersonDetail

      Expand all

      Collapse all

      Fields

      • id (int64)

        Unique identifier of person detail.

        Label

        Id

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

  Expand all

  Collapse all

  Reference Object

  • application (TaxonomyNode)

    The unique identifier of the application from where the invoice originated.

    Business Object

    TaxonomyNode

    Expand all

    Collapse all

    Fields

    • alternativeId (int64)

      The alternative identifier of the taxonomy node.

      Label

      Alternative ID

      Properties

      • searchable
      • sortable
      • not nullable

  • approvalStatus (ERPLookupCode)

    The code representing the status of the invoice in the invoice approval workflow.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • creditedInvoice (PayablesInvoiceTransaction)

    An invoice transaction represents details of all the transactions related to purchases made for producing goods and services or managing business operations, excluding payment requests, taxes, joint ventures, and intercompany transactions.

    Business Object

    PayablesInvoiceTransaction

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique identifier of the invoice that's generated while creating the invoice.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • invoiceNumber (string)

      The unique number for supplier invoice.

      Label

      Invoice Number

      Properties

      • searchable
      • sortable
      • not nullable
    • invoiceTypeDiscriminator (string)

      The discriminator to distinguish Payables Invoice and Payment Request subtypes.

      Label

      Discriminator

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
      • updatable

  • dataSet (BudgetaryControlValidationRequest)

    A budgetary control validation request contains the information of each request, such as the type of transaction being validated and the validation result.

    Business Object

    BudgetaryControlValidationRequest

    Expand all

    Collapse all

    Fields

    • validationRequestId (int64)

      The unique identifier of the budgetary control validation request.

      Label

      Validation Request ID

      Properties

      • searchable
      • sortable
      • not nullable

  • distributionSet (PayablesDistributionSet)

    The distribution set represents a collection of invoices for automatic distribution.

    Business Object

    PayablesDistributionSet

    Expand all

    Collapse all

    Fields

    • distributionSetId (int64)

      The unique identifier of an invoice distribution set.

      Label

      Distribution Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentSequence (DocumentSequence)

    The unique identifier of the document sequential numbering.

    Business Object

    DocumentSequence

    Expand all

    Collapse all

    Fields

    • docSequenceId (int64)

      The unique identifier of the document sequence.

      Label

      Document Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • expenditureBusinessUnit (BusinessUnit)

    The identifier for the project expenditure organization associated with the invoice distribution.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • externalBankAccount (ExternalBankAccount)

    The identifier of the external bank account.

    Business Object

    ExternalBankAccount

    Expand all

    Collapse all

    Fields

    • id (int64)

      Primary key of the physical entity IBY_EXT_BANK_ACCOUNTS.

      Label

      External Bank Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • firstPartyRegistration (TaxRegistration)

    The identifier of the first party tax registration.

    Business Object

    TaxRegistration

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax registration.

      Label

      Registration ID

      Properties

      • searchable
      • sortable
      • not nullable

  • fundsStatus (StandardLookupCode)

    Indicates whether funds checking and reservation is applicable for the invoice.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceBatch (PayablesInvoiceBatch)

    Invoice batch stores summary information about invoices entered in batches when the Batch Control Payables option is enabled. There is one row for each batch of invoices entered in system. It uses this information to group together invoices that a person entered in one batch.

    Business Object

    PayablesInvoiceBatch

    Expand all

    Collapse all

    Fields

    • batchId (int64)

      The unique identifier of the invoice group.

      Label

      Invoice Group

      Properties

      • searchable
      • sortable
      • not nullable

  • invoiceCurrency (Currency)

    The currency in which a supplier invoice is received.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • invoiceSource (ERPLookupCode)

    The source that indicates the feeder system from which an invoice is created. A list of accepted values is defined in the lookup SOURCE.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceTypeCode (ERPLookupCode)

    The code representing the type of invoice. Valid values are STANDARD, PREPAYMENT, CREDIT MEMO, and DEBIT MEMO. This attribute value can either be provided while creating the invoice or derived based on the invoice amount. The positive invoice amount is considered as standard invoice and negative values are considered as credit memo. A list of accepted values are defined in the lookup INVOICE TYPE. Review and update the list of values using the Setup and Maintenance work area, and the Manage Payables Lookups task.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • liabilityAccount (GeneralLedgerAccount)

    The unique identifier of the accounting flexfield for accounts payable liability account.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • inherited
      • creatable
      • searchable
      • sortable

  • payGroup (ERPLookupCode)

    The group for a category of suppliers or invoices for a single pay run. Examples include employees, merchandise, nonmerchandise, government, domestic, and international. A list of accepted values is defined in the lookup PAY GROUP.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • paymentConversionRateType (CurrencyConversionRateType)

    The conversion rate type of a future dated maturity payment. This attribute value is only used for foreign currency payments.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentCurrency (Currency)

    The code representing the currency that the payment is made in.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentFunctionLookup (StandardLookupCode)

    The funds check or reservation status for the invoice distribution.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • paymentMethod (PaymentMethod)

    A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods include printing paper checks in-house, outsourcing checks to be printed by a payment system, and wiring money. A payment method can be very generic, such as EFT, or very specific, such as EFT in Denmark via Citibank using the EDIFACT format. Some payment methods are predefined, but implementation teams may define their own payment methods.

    Business Object

    PaymentMethod

    Expand all

    Collapse all

    Fields

    • code (string)

      Primary key entered by the user.

      Label

      Payment Method Code

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentSettlementPriority (StandardLookupCode)

    The priority with which the financial institution or payment system should settle payment for this document. A list of accepted values is defined in the lookup type IBY_SETTLEMENT_PRIORITY.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • paymentStatusCode (ERPLookupCode)

    Indicates whether payment has been made for the installment. A value of Y indicates fully paid, N indicates unpaid and P indicates partially paid installments.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • paymentTerm (PayablesPaymentTerm)

    The payment terms contain information related to payment terms that outline the timing and method of payment. Payment terms are assigned to suppliers and invoices that automatically create payment installments when the Payables Invoice is created. Payment terms have one or more payment terms lines to denote the due date, each of which creates one installment. Each payment terms line and its corresponding installment has a due date or a discount date.

    Business Object

    PayablesPaymentTerm

    Expand all

    Collapse all

    Fields

    • termId (int64)

      The unique identifier of the payment term line. This attribute is a part of the composite key of the payment terms details view object.

      Label

      Payment Terms

      Properties

      • searchable
      • sortable
      • not nullable

  • project (Project)

    The unique identifier of the project associated with the invoice distribution.

    Business Object

    Project

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the project.

      Label

      Project ID

      Properties

      • searchable
      • sortable
      • not nullable

  • projectsDefaultDistribution (GeneralLedgerAbstractAccount)

    The identifier for the project expenditure organization associated with the invoice distribution.

    Business Object

    GeneralLedgerAbstractAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • creatable
      • searchable
      • sortable

  • quickPurchaseOrder (Order)

    The unique identifier of the purchase order that the invoice is matched to.

    Business Object

    Order

    Expand all

    Collapse all

    Fields

    • orderHeaderId (int64)

      Value that uniquely identifies the purchase order header.

      Label

      Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • routingStatus (ERPLookupCode)

    The code representing the routing status of the invoice. The invoice can be in the process of routing or complete.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • systemOption (PayablesSystemOption)

    System options represent the parameters and defaults defined for Oracle Payables application operations. It encompasses vital details like the set of books, functional currency, default bank account, payment terms, and more. This information guides Oracle Payables in establishing default values that extend to supplier and invoice entries.

    Business Object

    PayablesSystemOption

    Expand all

    Collapse all

    Fields

    • businessUnitId (int64)

      The unique identifier of the business unit associated with the payment.

      Label

      Business Unit

      Properties

      • searchable
      • sortable
      • not nullable

  • thirdPartyRegistration (TaxRegistration)

    The unique identifier of the third party tax registration.

    Business Object

    TaxRegistration

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax registration.

      Label

      Registration ID

      Properties

      • searchable
      • sortable
      • not nullable

  • validationStatus (ERPLookupCode)

    The code representing the status of the invoice in the validation process.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Back to Top