PayablesInvoiceDistribution

Invoice distribution provides the allocation details of the costs or charges from an invoice to various accounts or departments within an organization. The details include distribution code combination, distribution amount, and so on. The invoice distributions are entered manually or system generated. An invoice can have multiple distributions, and there is one row for each distribution.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesInvoiceDistributionsExtract**

  Invoice distribution provides the allocation details of the costs or charges from an invoice to various accounts or departments within an organization. The details include distribution code combination, distribution amount, and so on. The invoice distributions are entered manually or system generated. An invoice can have multiple distributions, and there is one row for each distribution.

  Label, Plural Label

  Payables Invoice Distribution, Payables Invoice Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountingDate (date)

    The date when the invoice distribution is to be accounted.

    Label

    Invoice Distribution Accounting Date

    Properties

    • searchable
    • not nullable
  • adjustmentReason (string)

    The reason for the invoice distribution adjustment.

    Label

    Invoice Distribution Adjustment Reason

    Properties

    • searchable
    • sortable
  • amount (big-decimal)

    The amount on the invoice distribution.

    Label

    Amount

  • amountAtPrepayExchangeRate (big-decimal)

    The invoice distribution amount in the ledger currency at the prepayment payment conversion rate. Populated for prepay type distributions on foreign currency invoices.

    Label

    Invoice Distribution Amount at Prepayment Payment Conversion Rate

  • amountAtPrepayPayExchangeRate (big-decimal)

    The invoice distribution amount in the ledger currency at the prepayment payment conversion rate. Populated for prepay type distributions on foreign currency invoices.

    Label

    Invoice Distribution Amount at Prepayment Payment Conversion Rate

  • amountVariance (big-decimal)

    The amount variance in the entered currency for invoice distributions that are matched to a service shipment or receipt.

    Label

    Invoice Distribution Amount Variance

  • assetsAdditionCode (string)

    Indicates whether the invoice distribution has been transferred to Oracle Fusion Assets. A value of U indicates that the distribution isn't yet processed for transfer to Oracle Fusion Assets. A value of Y indicates that the distribution has been transferred and a value of N indicates that the distribution hasn't been transferred to Oracle Fusion Assets.

    Label

    Asset Addition Indicator

    Properties

    • not nullable
  • assetsTrackingFlag (boolean)

    Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice distribution or populated by default from the parent invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value is true, then it indicates that the item should be transferred to Oracle Fusion Assets.

    Label

    Track as Asset

    Properties

    • not nullable
  • automaticWithholdingTaxCode (string)

    Indicates whether the invoice distribution is subject to withholding tax. Possible values are Y, N or null.

    Label

    Invoice Distribution Withholding Indicator

  • automaticWithholdingTaxGrossAmount (big-decimal)

    The distribution amount subject to withholding tax.

    Label

    Amount Subject to Withholding Tax

  • baseAmount (big-decimal)

    The invoice distribution amount in the ledger currency. This is only used for foreign currency invoices.

    Label

    Accounted Amount

  • baseAmountVariance (big-decimal)

    The amount variance in the ledger currency for invoice distributions matched to a service shipment or receipt.

    Label

    Invoice Distribution Ledger Amount Variance

  • baseQuantityVariance (big-decimal)

    The quantity variance on the invoice distribution.

    Label

    Invoice Distribution Base Quantity Variance

  • budgetDate (date)

    The budgetary calendar period date applicable for funds checking.

    Label

    Budget Date

  • cancellationFlag (boolean)

    Indicates whether an invoice distribution is canceled. The default value is false. If the value if true, then it indicates the invoice distribution is canceled.

    Label

    Invoice Distribution Canceled Indicator

  • conversionRate (big-decimal)

    The conversion rate used to convert the foreign currency invoice distribution amount to the ledger currency.

    Label

    Invoice Distribution Conversion Rate

  • correctedQuantity (big-decimal)

    The quantity corrected for price, quantity, or invoice line corrections. This attribute is populated for the correcting distribution.

    Label

    Quantity

  • createdBy (string)

    The user who created the invoice distribution.

    Label

    Created By

    Properties

    • not nullable
  • creditCardReversalFlag (boolean)

    Indicates if the prepaid credit card transaction line distributions are reversed or not. A value of Y indicates that the distributions are reversed.

    Label

    Credit Card Reversal Indicator

  • deferredAccountingEndDate (date)

    The multiperiod accounting end date on the invoice distribution.

    Label

    Multiperiod Accounting End Date

  • deferredAccountingStartDate (date)

    The multiperiod accounting start date on the invoice distribution.

    Label

    Multiperiod Accounting Start Date

  • description (string)

    The description of the invoice distribution.

    Label

    Description

  • distributionClass (string)

    Indicates whether the distribution is permanent or built in preview mode for display to the user. A list of value values is defined in the lookup DISTRIBUTION_CLASS.

    Label

    Distribution Class

  • distributionLineNumber (int64)

    The line number associated with the invoice distribution.

    Label

    Line Number

    Properties

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

    Indicates status of the invoice distribution line in the encumbrance process.

    Label

    Encumbrance Status

  • endExpenseDate (date)

    The last day of an expense that spans multiple days. Used for expense reports.

    Label

    Expense End Date

  • exchangeDate (date)

    The date used to derive the conversion rate for converting the foreign currency invoice distribution amount to the ledger currency.

    Label

    Invoice Distribution Conversion Date

  • exchangeRateVariance (big-decimal)

    The conversion rate variance for receipt matched distributions, based on the receipt and purchase order conversion rates. This is used for encumbrance accounting.

    Label

    Conversion Rate Variance

  • expenseGroup (string)

    The expense group associated with the invoice line.

    Label

    Expense Group

  • finalApplicationRounding (big-decimal)

    The rounding amount to relieve the prepaid expense completely. The amount is calculated during the final application of a prepayment. It's then added to the prepay type distributions on the invoice that the prepayment is applied to that has the same account as the prepayment distribution with the outstanding balance being relieved.

    Label

    Invoice Distribution Final Application Rounding

  • finalMatchStatus (enumeration: FinalMatchStatus)

    Indicates if an invoice is the last one being matched to a purchase order, so that the purchase order is no longer available for matching to other invoices.

    Label

    Final Match

    Type

    • Module: oraErpCorePayablesInvoices

    • Enumeration Type: FinalMatchStatus

    Valid Values

    • D
    • N
    • R
    • Y
  • finalPaymentRounding (big-decimal)

    The rounding amount to relieve the invoice liability completely for foreign currency invoices paid with more than one prepayment application or payment. This is calculated when the invoice becomes fully paid by a prepayment application. This amount is added to the largest prepay distribution on the invoice.

    Label

    Invoice Distribution Final Payment Rounding

  • fullyPaidAccountedFlag (boolean)

    Indicates whether the invoice is fully paid and accounted. Used for US Federal Financials. A value of Y indicates that the invoice is fully paid and accounted.

    Label

    Fully Paid and Accounted Indicator

  • incomeTaxRegion (string)

    The reporting region on the invoice line for a 1099 supplier.

    Label

    Income Tax Region

  • intendedUse (string)

    A tax driver used to determine and calculate the applicable taxes.

    Label

    Invoice Distribution Intended Use

  • intendedUseIdentifier (int64)

    The unique identifier of the user-entered intended use code.

    Label

    Intended Use

  • inventoryTransferStatusFlag (boolean)

    Indicates whether the invoice distribution was processed by the transfer invoice variance program. A value of N indicates that the distribution hasn't been transferred. No value indicates that either the distribution was transferred or isn't eligible for transfer to inventory valuation. The default value of this attribute at the time of distribution creation is N.

    Label

    Invoice Distribution Inventory Transfer Status

  • invoiceDistributionId (int64)

    The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

    Label

    Invoice Distribution ID

    Properties

    • searchable
    • sortable
    • not nullable
  • invoiceId (int64)

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

    Label

    Invoice ID

    Properties

    • searchable
    • sortable
    • not nullable
  • invoiceIncludesPrepaymentFlag (boolean)

    Indicates whether the prepayment amount is included in the invoice amount.

    Label

    Indicates that the prepayment is referenced on the supplier invoice and the invoice amount includes the amount of the prepayment and any associated tax.

  • invoiceLineNumber (int64)

    The unique number for the invoice line associated with the invoice distribution.

    Label

    Line

    Properties

    • searchable
    • sortable
  • matchStatusCode (string)

    Indicates whether the invoice distribution is generated for a purchase order matched line. The default value is set to Not Matched.

    Label

    Matched

  • merchantDocumentNumber (string)

    The number on the receipt issued by the merchant. Used for expense reports.

    Label

    Merchant Document Number

  • merchantName (string)

    The name of the merchant where the expense was incurred. Used for expense reports.

    Label

    Merchant Name

  • merchantReference (string)

    The purchase identification of a transaction provided by the merchant at the point of sale. Used for expense reports.

    Label

    Merchant Reference

  • merchantTaxRegistrationNumber (string)

    Unique sequence of letters or numbers assigned to the merchant by a tax authority when it's registered and by which the merchant registration is identified.

    Label

    Merchant Tax Registration Number

  • merchantTaxpayerIdentificationNumber (string)

    The unique identifier of the merchant tax payer.

    Label

    Merchant Taxpayer ID

  • periodName (string)

    The period name for the invoice distribution.

    Label

    Invoice Distribution Period Name

    Properties

    • not nullable
  • prepayAmountRemaining (big-decimal)

    The amount of the prepayment that can still be applied to an invoice.

    Label

    Invoice Distribution Prepayment Amount Remaining

  • productTable (string)

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

    Label

    Product Table

  • projectsAdditionCode (string)

    Indicates whether the invoice distribution has been transferred to Oracle Fusion Assets. A value of U indicates that the distribution isn't yet processed for transfer to Oracle Fusion Assets. A value of Y indicates that the distribution has been transferred and a value of N indicates that the distribution hasn't been transferred to Oracle Fusion Assets.

    Label

    Invoice Distribution Projects Addition Indicator

  • projectsQuantity (big-decimal)

    Quantity billed to a project on the invoice distribution.

    Label

    Quantity billed to a project.

  • quantityInvoiced (big-decimal)

    The quantity that was invoiced.

    Label

    Invoiced Quantity

  • quantityVariance (big-decimal)

    The quantity variance on the invoice distribution.

    Label

    Invoice Distribution Quantity Variance

  • receiptConversionRate (big-decimal)

    The conversion rate used for conversion from the receipt currency to the ledger currency. Used for expense reports.

    Label

    Receipt Conversion Rate

  • receiptCurrencyAmount (big-decimal)

    The distribution amount in the expense receipt currency. Used for expense reports.

    Label

    Receipt Amount

  • receiptCurrencyCode (string)

    The currency of the expense receipt. Used for expense reports.

    Label

    Receipt Currency

  • receiptMissingFlag (boolean)

    Indicates whether receipts are missing for an expense. Used for expense reports.

    Label

    Receipt Missing

  • receiptRequiredFlag (boolean)

    Indicates whether an expense requires a receipt. Used for expense reports.

    Label

    Receipt Required Indicator

  • receiptVerifiedFlag (boolean)

    Indicates whether an auditor verified the receipt for an expense. Used for expense reports.

    Label

    Receipt Verified Indicator

  • receivingChargeAdditionFlag (boolean)

    Indicates whether distributions have been reversed. A value of N indicates that distribution have been not been reversed. A value of blank indicates that the distributions have been reversed.

    Label

    Receiving Charge Addition Indicator

  • recoverableNonrecoverableRate (big-decimal)

    Indicates whether a tax rate is recoverable or nonrecoverable.

    Label

    Recoverable or Nonrecoverable Rate

  • recoveryRateName (string)

    The name of the tax rate.

    Label

    Recovery Rate Name

  • referenceOne (string)

    The reference information from the Oracle Projects expense reports.

    Label

    Reference 1

  • referenceTwo (string)

    The reference information from the Oracle Projects expense reports.

    Label

    Reference 2

  • requestIdentifier (int64)

    Properties

    • not nullable
  • retainedAmountRemaining (big-decimal)

    The retained amount available for release on the standard invoice distribution.

    Label

    Retainage Remaining

  • reversalFlag (boolean)

    Indicates whether a distribution is part of a reversal pair. The default value is false. If the value if true, then it indicates that the distribution is part of a reversal pair.

    Label

    Invoice Distribution Reversal Indicator

  • roundingAmount (big-decimal)

    The rounding amount on the invoice distribution represented in the ledger currency.

    Label

    Invoice Distribution Rounding Amount

  • startExpenseDate (date)

    The date when the expense occurred or the first day of an expense that spans multiple days. Used for expense reports.

    Label

    Expense Receipt Date

  • statisticalAmount (big-decimal)

    The amount associated with a distribution for measuring statistical quantities.

    Label

    Statistical Quantity

  • taxAlreadyDistributedFlag (boolean)

    Internal processing indicator for Oracle Fusion Payables, indicating whether tax was distributed.

    Label

    Tax Already Distributed Indicator

  • taxDifferenceFromPrepayment (big-decimal)

    The amount resulting from a tax rate or recovery rate change between the prepayment invoice date and the standard invoice date.

    Label

    Invoice Distribution Prepayment Tax Difference Amount

  • taxRecoverableFlag (boolean)

    Indicates if tax is fully or partially recoverable for the invoice distribution. Valid values are Y or N.

    Label

    Invoice Distribution Tax Recoverable Indicator

  • taxableBaseAmount (big-decimal)

    The taxable amount in the ledger currency for the distribution. This attribute is used during upgrade and is intended for internal use only.

    Label

    Invoice Distribution Taxable Ledger Amount

  • timeCreated (date-time)

    The date and time when the invoice distribution was created.

    Label

    Invoice Distribution Creation Date

    Properties

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

    The date and time when the invoice distribution was last updated. This attribute forms part of the primary key for the Invoice Distributions view object.

    Label

    Invoice Distribution Last Updated Date

    Properties

    • searchable
    • not nullable
  • totalDistributionAmount (big-decimal)

    The sum total of amounts related to this distribution including variance amounts from related invoice distributions.

    Label

    Invoice Total Distribution Amount

  • totalDistributionBaseAmount (big-decimal)

    The sum total of amounts related to this distribution including variance amounts from related invoice distributions in the ledger currency.

    Label

    Invoice Distribution Total Distribution Ledger Amount

  • unitPrice (big-decimal)

    The unit price for a good or service.

    Label

    Unit Price

  • updatedBy (string)

    The user who last updated the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

    Label

    Invoice Distribution Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accountingEvent (SubledgerAccountingEvent)

    Invoice distribution accounting event.

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • eventId (int64)

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • assetCategory (AssetAbstractCategory)

    A category represents the classification of assets, such as buildings, computer equipment, furniture and fixtures, and land. Assets are grouped based on the financial accounts and depreciation rules.

    Business Object

    AssetAbstractCategory

    Expand all

    Collapse all

    Fields

    • categoryId (int64)

      The identifier of the asset category.

      Label

      Category ID

      Properties

      • searchable
      • sortable
      • not nullable

  • automaticWithholdingRelatedItemDistribution (PayablesInvoiceDistribution)

    Invoice distributions related to this withholding tax distribution.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • automaticWithholdingTaxInvoice (PayablesInvoiceTransaction)

    The withholding tax invoice created from the invoice distribution.

    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

  • automaticWithholdingTaxInvoicePayment (PayablesInvoicePayment)

    Payment for the parent invoice, populated only for withholding tax distributions created at payment time.

    Business Object

    PayablesInvoicePayment

    Expand all

    Collapse all

    Fields

    • invoicePaymentId (int64)

      The unique identifier of the payment. This is the primary key of the Invoice Payments view object.

      Label

      Invoice Payment ID

      Properties

      • searchable
      • sortable
      • not nullable

  • automaticWithholdingTaxOriginGroup (PayablesAutomaticTaxWithholdingGroup)

    Parent withholding tax group associated with the invoice distribution. Populated for automatically created withholding tax distributions.

    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

  • budgetaryControlEvent (SubledgerAccountingEvent)

    The identifier of the budgetary control transaction or group of transactions.

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • eventId (int64)

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • 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

  • chargeApplicableDistribution (PayablesInvoiceDistribution)

    The distribution to which the entire amount of the current charge is applied.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • companyPrepaidInvoice (PayablesInvoiceTransaction)

    The identifier of the invoice for prepaid credit card 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

  • consumptionAdvice (ConsumptionAdviceHeader)

    The identifier of the consumption advice associated with the invoice distribution.

    Business Object

    ConsumptionAdviceHeader

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely describes the consumption advice header ID.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • consumptionAdviceLine (ConsumptionAdviceLine)

    The identifier of the line number of the consumption advice associated with the invoice distribution.

    Business Object

    ConsumptionAdviceLine

    Expand all

    Collapse all

    Fields

    • lineId (int64)

      Value that uniquely describes the consumption advice line ID.

      Label

      Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • conversationRateType (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

  • correctedInvoiceDistribution (PayablesInvoiceDistribution)

    The identifier of the invoice distribution that's corrected by the current invoice distribution. This is used for price, quantity, or invoice line corrections.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • country (Territory)

    The country where services or goods were originated. Used for expense reports.

    Business Object

    Territory

    Expand all

    Collapse all

    Fields

    • territoryCode (string)

      The unique code of the territory.

      Label

      Territory Code

      Properties

      • searchable
      • sortable
      • not nullable

  • creditCardTransaction (CorporateCardTransaction)

    The identifier of the credit card transaction.

    Business Object

    CorporateCardTransaction

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the corporate card transaction.

      Label

      Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • crossInvoiceParentReversal (PayablesInvoiceDistribution)

    The cross-invoice parent reversal identifier of the distribution that has been reversed. This attribute is populated for distributions that negate a distribution on a different invoice.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • deferredAccount (GeneralLedgerAccount)

    The identifier of the accrual account used in multiperiod accounting to accrue deferred expenses.

    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

  • distributionAccount (GeneralLedgerAccount)

    The identifier of the accounting flexfield for the account associated with the distribution.

    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

  • distributionMatchType (ERPLookupCode)

    Indicates if the invoice is matched to a purchase order or to a receipt of material. A list of accepted values is defined in the lookup type INVOICE LINE MATCH TYPE.

    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

  • 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

  • fixedAssetsBook (AssetBook)

    The asset book associated with the row. The value is populated by default from the invoice line to the distributions candidate for transfer to Oracle Fusion Assets.

    Business Object

    AssetBook

    Expand all

    Collapse all

    Fields

    • name (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable

  • fundsStatus (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

  • invoiceDistributionType (ERPLookupCode)

    The type of invoice line associated with the invoice distribution. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.

    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

  • invoiceGroup (PayablesInvoiceBatch)

    The unique identifier of the invoice group.

    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

  • invoiceHeader (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

  • invoiceLine (PayablesInvoiceLine)

    An invoice line represents a specific item or charge listed on an invoice. It provides a detailed breakdown of the products, services, or expenses included in the invoice, along with their respective quantities, unit prices, and total amounts. Invoice lines record invoice lines entered manually, generated automatically, or imported from the Open Interface. An invoice can have one or more invoice lines. An invoice line can have one or more invoice distributions.

    Business Object

    PayablesInvoiceLine

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique invoice identifier that's generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • lineNumber (int64)

      The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Number

      Properties

      • searchable
      • sortable
      • not nullable

  • invoicePostingStatus (ERPLookupCode)

    Indicates whether the invoice distribution line has been accounted.

    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

  • matchedUnitOfMeasure (UnitOfMeasure)

    The unit of measure used for the invoiced quantity when this distribution is matched.

    Business Object

    UnitOfMeasure

    Expand all

    Collapse all

    Fields

    • code (string)

      User-supplied short code that identifies the unit of measure. This attribute is required.

      Label

      Code

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

  • orderDistribution (OrderDistribution)

    The identifier of the purchase order distribution line that's associated with the invoice distribution.

    Business Object

    OrderDistribution

    Expand all

    Collapse all

    Fields

    • poDistributionId (int64)

      Value that uniquely identifies the purchase order distribution.

      Label

      Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • parentInvoiceHeader (PayablesInvoiceTransaction)

    The identifier of the invoice matched to a credit or debit memo.

    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

  • parentReversal (PayablesInvoiceDistribution)

    The identifier of the invoice distribution being reversed by the current distribution.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • payablesIncomeTaxType (Payables1099IncomeTaxType)

    The 1099 income tax type represents a certain type of nonemployment income tax assigned to a supplier.

    Business Object

    Payables1099IncomeTaxType

    Expand all

    Collapse all

    Fields

    • incomeTaxType (string)

      The type of income tax.

      Label

      Income Tax Type

      Properties

      • searchable
      • sortable
      • not nullable

  • prepayDistribution (PayablesInvoiceDistribution)

    The identifier of the prepayment distribution line related to the prepayment line.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      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

  • receivingTransaction (ReceivingTransaction)

    The identifier of the receipt of material that originated the invoice distribution.

    Business Object

    ReceivingTransaction

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely describes the receiving transaction.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • recoveryType (ERPLookupCode)

    The mechanism to administer the recovery process for a specific tax.

    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

  • relatedDistribution (PayablesInvoiceDistribution)

    Links this distribution to a related invoice distribution, such as IPV, ERV, ITEM, or ACCRUAL.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • relatedRetainageDistribution (PayablesInvoiceDistribution)

    The identifier of the related retainage invoice distribution.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • retainageReleaseInvoiceDistribution (PayablesInvoiceDistribution)

    The identifier of the original invoice distribution on which the amount was retained. This attribute is populated for the invoice distributions of the retainage release invoice.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • retainedInvoiceDistribution (PayablesInvoiceDistribution)

    The identifier of the original invoice distribution on which the amount was retained. This attribute is populated for the invoice distributions of the retainage release invoice.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • rootDistribution (PayablesInvoiceDistribution)

    The identifier of the original invoice distribution on which the amount was retained. This attribute is populated for the invoice distributions of the retainage release invoice.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • invoiceDistributionId (int64)

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • summaryTaxLine (SummaryTaxLine)

    Summary tax line provides summarized information for transaction tax lines associated with a Payable transaction.

    Business Object

    SummaryTaxLine

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the summary tax line associated with this tax line.

      Label

      Summary Tax Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • task (ProjectTask)

    The identifier of the project task used to build the transaction descriptive flexfield for project-related invoice line distributions.

    Business Object

    ProjectTask

    Expand all

    Collapse all

    Fields

    • id (int64)

      Identifier of the project task.

      Label

      Task ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxDistribution (PurchaseTransactionTaxDistribution)

    The unique identifier of the detail tax line associated with the tax distribution.

    Business Object

    PurchaseTransactionTaxDistribution

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for the recoverable and nonrecoverable tax distribution.

      Label

      Recoverable and Nonrecoverable Tax Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionTaxCode (TaxRate)

    The tax rate is a percentage of an amount, a value per unit quantity, or a fixed sum per transaction at which an individual or corporation is taxed and is effective for a period of time.

    Business Object

    TaxRate

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax rate.

      Label

      Rate ID

      Properties

      • searchable
      • sortable
      • not nullable

  • withholdingTaxCode (TaxRate)

    The unique identifier of the withholding tax rates applicable to the invoice.

    Business Object

    TaxRate

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax rate.

      Label

      Rate ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top