ReceivablesDistribution

The Receivables Distribution business object provides the details of the accounting distributions for cash receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesDistributionsExtract**

  The Receivables Distribution business object provides the details of the accounting distributions for cash receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions.

  Label, Plural Label

  Receivables Distributions, Receivables Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountedAmountCredit (big-decimal)

    The journal entry recorded for the accounted debit amount of the receipt.

    Label

    Accounted Amount CR

  • accountedAmountDebit (big-decimal)

    The amount for which the distribution activity is recorded.

    Label

    Accounted Amount DR

  • activityBucket (string)

    The distribution recorded for the accounted credit amount of the receipt.

    Label

    Cash Distribution Activity Bucket

  • amountCredit (big-decimal)

    The distribution recorded for the accounted debit amount of the receipt.

    Label

    Amount CR

  • amountDebit (big-decimal)

    The distribution conversion date.

    Label

    Amount DR

  • conversionDate (date)

    The credit amount of the receipt in the ledger currency.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The distribution conversion rate.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • fromAccountedAmountCR (big-decimal)

    The debit amount of the receipt in the ledger currency.

    Label

    From Accounted Amount CR

  • fromAccountedAmountDR (big-decimal)

    The credit amount of the cash receipt in the ledger currency.

    Label

    From Accounted Amount DR

  • fromAmountCR (big-decimal)

    The debit amount of the receipt in the ledger currency.

    Label

    From Amount CR

  • fromAmountDR (big-decimal)

    The unique identifier of the accounting line distribution. This is a primary key of the General Ledger Line Distribution view object.

    Label

    From Amount DR

  • lineId (int64)

    The journal entry recorded for the accounted credit amount of the receipt.

    Label

    Line ID

    Properties

    • searchable
    • sortable
    • not nullable
  • referenceAccountClass (enumeration: AccountClass)

    The account class of the receipt distribution.

    Label

    Reference Account Class

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AccountClass

    Valid Values

    • OFFSET
    • REVENUE
    • REVENUE_ASSIGNMENT
    • SUSPENSE
    • SUSPENSE_ASSIGNMENT
    • TAX
    • TAX_ASSIGNMENT
  • reversalFlag (boolean)

    The option that indicates whether the receipt distribution was reversed.

    Label

    Reversal

  • secondarySourceTable (string)

    The distribution source for the receipt that represents a secondary table.

    Label

    Secondary Source Table

  • secondarySourceType (string)

    The distribution source type for the receipt.

    Label

    Secondary Source Type

  • sourceTable (string)

    The distribution source for the cash receipt history.

    Label

    Source Table

    Properties

    • searchable
    • not nullable
  • sourceType (enumeration: AccountSourceType)

    The account type of the receipt for which the distribution is posted.

    Label

    Source Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AccountSourceType

    Properties

    • not nullable

    Valid Values

    • ACC
    • ACTIVITY
    • ADJ
    • ADJ_NON_REC_TAX
    • BANK_CHARGES
    • BILLS_REC_FUND
    • CASH
    • CONFIRMATION
    • CURR_ROUND
    • DEFERRED_TAX

    For a complete list of valid values, see the AccountSourceType enumeration type.

  • taxableAccountedCredit (big-decimal)

    The accounted taxable credit amount.

    Label

    Taxable Accounted Amount CR

  • taxableAccountedDebit (big-decimal)

    The accounted taxable debit amount.

    Label

    Taxable Accounted Amount DR

  • taxableEnteredCredit (big-decimal)

    The taxable receipt debit lines.

    Label

    Taxable Amount DR

  • taxableEnteredDebit (big-decimal)

    The taxable receipt credit lines.

    Label

    Taxable Amount CR

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Subtype

  • Discriminator:

    ADJMCDRA

  • The Receivables Adjustment Distribution business object provides the details of the accounted amounts of all the Receivables adjustments in the ledger currency.

    Business Object

    ReceivablesAdjustmentDistribution

    Expand all

    Collapse all

    Reference Object

    • billingAdjustment (ReceivablesAdjustment)

      The transaction distribution is a process of allocating or distributing the amounts within a receivable transaction to various accounts or categories. The transaction distribution provides the details of the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line. At least one distribution must exist for each invoice or credit memo line.

      Business Object

      ReceivablesAdjustment

      Expand all

      Collapse all

      Fields

      • adjustmentId (int64)

        The identifier of the adjustment.

        Label

        Adjustment ID

        Properties

        • searchable
        • sortable
        • not nullable

    The Receivables Miscellaneous Receipt Distribution business object provides the details of the accounting distributions for miscellaneous receipts.

    Business Object

    ReceivablesMiscellaneousReceiptDistribution

    Expand all

    Collapse all

    Reference Object

    • miscellaneousReceiptDistribution (ReceivablesMiscellaneousCashReceiptDistribution)

      The miscellaneous cash receipt distribution is the process of allocating or distributing cash receipts received from miscellaneous sources across various accounts or categories within the accounts receivables. Miscellaneous cash refers to nonrevenue income, such as stock revenue, interest income, and investment income. This distribution ensures that the cash received is appropriately applied to outstanding invoices, credits, or other receivable entries, reflecting accurate financial information within the organization's accounting system. The miscellaneous cash distribution includes details such as receipt type, status, business unit, receipt method, receipt number, receivables activity, distribution set, reference, currency, entered amount, accounted amount, tax rate code, tax account, receipt date, accounting entries, and accounting date. The miscellaneous cash distribution stores one record for each receipt distribution.

      Business Object

      ReceivablesMiscellaneousCashReceiptDistribution

      Expand all

      Collapse all

      Fields

      • miscellaneousCashDistributionId (int64)

        The primary key of the miscellaneous cash distribution.

        Label

        Miscellaneous Cash Distribution ID

        Properties

        • searchable
        • sortable
        • not nullable

    • reversedMiscellaneousReceiptDistribution (ReceivablesMiscellaneousCashReceiptDistribution)

      The miscellaneous cash receipt distribution is the process of allocating or distributing cash receipts received from miscellaneous sources across various accounts or categories within the accounts receivables. Miscellaneous cash refers to nonrevenue income, such as stock revenue, interest income, and investment income. This distribution ensures that the cash received is appropriately applied to outstanding invoices, credits, or other receivable entries, reflecting accurate financial information within the organization's accounting system. The miscellaneous cash distribution includes details such as receipt type, status, business unit, receipt method, receipt number, receivables activity, distribution set, reference, currency, entered amount, accounted amount, tax rate code, tax account, receipt date, accounting entries, and accounting date. The miscellaneous cash distribution stores one record for each receipt distribution.

      Business Object

      ReceivablesMiscellaneousCashReceiptDistribution

      Expand all

      Collapse all

      Fields

      • miscellaneousCashDistributionId (int64)

        The primary key of the miscellaneous cash distribution.

        Label

        Miscellaneous Cash Distribution ID

        Properties

        • searchable
        • sortable
        • not nullable

    The receivables distribution refers to distributing received payments across various invoices or accounts receivable entries. This distribution ensures that the payment is appropriately applied to outstanding balances, reducing the accounts receivable and reflecting accurate financial information. The distributions provide detailed accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions.

    Business Object

    ReceivablesReceiptDistribution

    Expand all

    Collapse all

    Reference Object

    • creditMemoApplication (ReceivablesCreditMemoApplication)

      The receivable application provides details of the accounting entries for cash and credit memo applications, including applied transactions, installment, application type, amount applied, discounts, days late, application rule, and application status. Valid statuses are APP-applied, UNAPP-unapplied, ACC-on account, UNID-unidentified, ACTIVITY-receivable activity, and OTHER ACC-other application. The total amount applied for cash applications should equal the cash receipt amount. An unapplied record for the cash receipt amount is created when a cash receipt is created. For each subsequent application, one applied record for the amount applied to the invoice and one unapplied record for the negative of the applied amount are created. If a cash application is reversed, one applied record for the negative of the original application amount and one unapplied record for the positive amount of the application are created.

      Business Object

      ReceivablesCreditMemoApplication

      Expand all

      Collapse all

      Fields

      • receivableApplicationId (int64)

        The identifier of the receipt application to the transaction.

        Label

        Receivable Application ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • distribution (ReceivablesDistribution)

      The Receivables Distribution business object provides the details of the accounting distributions for cash receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions.

      Business Object

      ReceivablesDistribution

      Expand all

      Collapse all

      Fields

      • lineId (int64)

        The journal entry recorded for the accounted credit amount of the receipt.

        Label

        Line ID

        Properties

        • searchable
        • sortable
        • not nullable

    • previousTransactionLine (ReceivablesTransactionLine)

      A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

      Business Object

      ReceivablesTransactionLine

      Expand all

      Collapse all

      Fields

      • customerTransactionLineId (int64)

        The identifier of the Receivable transaction line.

        Label

        Customer Transaction Line ID

        Properties

        • searchable
        • sortable
        • not nullable

    • receiptApplication (ReceivablesReceiptActivity)

      The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.

      Business Object

      ReceivablesReceiptActivity

      Expand all

      Collapse all

      Fields

      • receivableApplicationId (int64)

        The identifier of the receipt application to the transaction.

        Label

        Receivable Application ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • reversedCreditMemoApplication (ReceivablesCreditMemoApplication)

      The receivable application provides details of the accounting entries for cash and credit memo applications, including applied transactions, installment, application type, amount applied, discounts, days late, application rule, and application status. Valid statuses are APP-applied, UNAPP-unapplied, ACC-on account, UNID-unidentified, ACTIVITY-receivable activity, and OTHER ACC-other application. The total amount applied for cash applications should equal the cash receipt amount. An unapplied record for the cash receipt amount is created when a cash receipt is created. For each subsequent application, one applied record for the amount applied to the invoice and one unapplied record for the negative of the applied amount are created. If a cash application is reversed, one applied record for the negative of the original application amount and one unapplied record for the positive amount of the application are created.

      Business Object

      ReceivablesCreditMemoApplication

      Expand all

      Collapse all

      Fields

      • receivableApplicationId (int64)

        The identifier of the receipt application to the transaction.

        Label

        Receivable Application ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • reversedReceiptApplication (ReceivablesReceiptActivity)

      The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.

      Business Object

      ReceivablesReceiptActivity

      Expand all

      Collapse all

      Fields

      • receivableApplicationId (int64)

        The identifier of the receipt application to the transaction.

        Label

        Receivable Application ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • transactionDistribution (ReceivablesTransactionDistribution)

      The transaction distribution is a process of allocating or distributing the amounts within a receivable transaction to various accounts or categories. The transaction distribution provides the details of the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line. At least one distribution must exist for each invoice or credit memo line.

      Business Object

      ReceivablesTransactionDistribution

      Expand all

      Collapse all

      Fields

      • customerTransactionLineAccountingDistributionId (int64)

        The distribution account class of the transaction. Examples include Freight, Receivable, Revenue, AutoInvoice Clearing, Tax, Unbilled Receivable, Unearned Revenue, and Charges.

        Label

        Customer Transaction Line Accounting Distribution ID

        Properties

        • searchable
        • sortable
        • not nullable

    • transactionLine (ReceivablesTransactionLine)

      A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

      Business Object

      ReceivablesTransactionLine

      Expand all

      Collapse all

      Fields

      • customerTransactionLineId (int64)

        The identifier of the Receivable transaction line.

        Label

        Customer Transaction Line ID

        Properties

        • searchable
        • sortable
        • not nullable

  Expand all

  Collapse all

  Reference Object

  • account (GeneralLedgerAccount)

    A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

    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

  • 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

  • currency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    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

  • customerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerAccountSitePurpose (CustomerAccountSitePurpose)

    The Customer Account Site Business Purpose business object provides the details of the business purposes assigned to customer account sites, for example Bill-to, Ship-to, and Statements. Each customer account site can have one or more business purposes.

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • referenceDistributionAccount (GeneralLedgerAccount)

    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

  • taxLine (TaxLine)

    The tax line represents the details of the tax calculated for an item line for a purchase or sales transaction. It includes details such as the rate applied and the tax amount.

    Business Object

    TaxLine

    Expand all

    Collapse all

    Fields

    • taxLineId (int64)

      The unique identifier of the tax line.

      Label

      Tax Line ID

      Properties

      • searchable
      • sortable
      • not nullable

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

Back to Top