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.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesTransactionDistributionsExtract**

  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.

  Label, Plural Label

  Receivables Transaction Distributions, Receivables Transaction Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountClass (enumeration: AccountClass)

    The option that indicates whether this is an account set record. Valid values are Y and N.

    Label

    Account Class

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AccountClass

    Properties

    • not nullable

    Valid Values

    • OFFSET
    • REVENUE
    • REVENUE_ASSIGNMENT
    • SUSPENSE
    • SUSPENSE_ASSIGNMENT
    • TAX
    • TAX_ASSIGNMENT
  • accountSegments (string)

    The user who created the transaction line distribution.

    Label

    Account Segments

  • accountSetFlag (boolean)

    The option that indicates whether this is an account set record. Valid values are Y and N.

    Label

    Account Set

    Properties

    • not nullable
  • accountedAmount (big-decimal)

    The amount of the transaction in the entered currency.

    Label

    Accounted Amount

  • accountingDate (date)

    The date the transaction line was accounted.

    Label

    Accounting Date

  • amount (big-decimal)

    The identifier of the code combination of the accounting flexfield for the tax liability account. This account records the total amount of tax that an entity is legally obligated to pay to a tax authority as the result of a taxable event.

    Label

    Amount

  • collectedTaxAccountSegments (string)

    The comments about the transaction line revenue distribution.

    Label

    Collected Tax Account Segments

  • comments (string)

    The transaction line distribution of the revenue account.

    Label

    Comments

  • createdBy (string)

    The date and time the transaction line distribution was created.

    Label

    Created By

    Properties

    • not nullable
  • 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
  • latestRecordFlag (boolean)

    The column that identifies the latest record in this table with an ACCOUNT_CLASS of REC. Valid values are: Y - latest REC record, N - not the latest REC record, Null - not a REC record. You can only have one Y for each CUSTOMER_TRX_ID.

    Label

    Latest Record

  • originalAccountingDate (date)

    The original accounting date derived by the Recognize Revenue process.

    Label

    Original Accounting Date

  • percentage (big-decimal)

    The percentage of the transaction line distribution amount represented by this record.

    Label

    Percentage

  • postedDate (date)

    The date the transaction line was posted.

    Label

    Posted Date

  • postedFlag (boolean)

    Indicates whether the record is posted to General Ledger. If true, then the record is posted to General Ledger. If false, then the record isn't posted.

    Label

    Posted

    Properties

    • searchable
  • postingControlID (int64)

    The identifier of the Receivables posting batch. Valid values are: -1, -2, and -4 if posted in previous releases, or -3 if not posted.

    Label

    Posting Control ID

    Properties

    • not nullable
  • receivableOffsetFlag (boolean)

    The option that indicates the offset to the REC account. Valid values are: Y - An UNBILL or UNEARN line paired with the transaction REC row, Null - Either another line type or an UNBILL or UNEARN line paired with a REV line.

    Label

    Receivable Offset

  • roundingCorrectionFlag (boolean)

    The option that indicates whether a rounding correction was made to the transaction line.

    Label

    Rounding Correction

  • 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
  • transferToCostingFlag (boolean)

    The option that indicates whether to transfer transaction lines to Costing. Valid values are: N - transfer lines to Costing, NULL - lines already transferred to Costing.

    Label

    Transfer to Costing

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • userGeneratedFlag (boolean)

    The option that indicates whether the transaction line distribution is user-defined or system generated.

    Label

    User Generated

  Expand all

  Collapse all

  Reference Object

  • 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

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

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

  • 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

  • receivablesRevenueAdjustmentsDetail (ReceivablesRevenueAdjustmentsDetail)

    The Receivables Revenue Adjustments Detail business object provides the details of the revenue adjustments on transactions.

    Business Object

    ReceivablesRevenueAdjustmentsDetail

    Expand all

    Collapse all

    Fields

    • revenueAdjustmentId (int64)

      The identifier of the Receivable transaction revenue adjustment.

      Label

      Revenue Adjustment ID

      Properties

      • searchable
      • sortable
      • not nullable

  • salesperson (ResourceCreditProfile)

    The identifier of the primary salesperson. This is the primary key of the Primary Salesperson Number view object.

    Business Object

    ResourceCreditProfile

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of a resource credit profile record.

      Label

      Credit Profile ID

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerAccountingEvent (SubledgerAccountingEvent)

    A subledger accounting event contains all information related to a specific accounting event and the transactions linked to the event which are used to generate accounting entries. It stores details associated with the accounting event such as the associated accounting event identifier, application identifier, event type, event status, event processing status, and other information associated with the 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

  • transactionHeader (ReceivablesTransaction)

    The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction 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

Back to Top