RevenueContractPromisedLineDistribution

The promised detail line distribution provides the distribution details of the performance obligation line.

Expand all

Collapse all

Business Views

** Available for extracting data

• revenueContractPromisedLineDistributionsExtract**

  The promised detail line distribution provides the distribution details of the performance obligation line.

  Label

  Revenue Contract Promised Line Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountClass (enumeration: AccountClass)

    Indicates the revenue distribution account category. Valid values are Contract Asset, Contract Liability, Contract Revenue, Contract Revenue Clearing, Contract Discount Clearing, and Contract Price Variance.

    Label

    Account Class

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: AccountClass

    Properties

    • not nullable

    Valid Values

    • ORA_CA
    • ORA_CL
    • ORA_DISC_CLR
    • ORA_PRICE_VAR
    • ORA_REV
    • ORA_REV_CLR
  • accountedDistributionAmount (big-decimal)

    The distribution amount in the ledger currency.

    Label

    Accounted Distribution Amount

    Properties

    • not nullable
  • accountingDate (date)

    Accounting date of the satisfaction event.

    Label

    Accounting Date

    Properties

    • not nullable
  • cogsRequestID (int64)

    The Enterprise Service Scheduler request ID of the COGS job that processed the row.

    Label

    COGS Request ID

  • conversionDate (date)

    The date when the rate is used for converting amounts from entered currency to ledger currency.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The rate for converting amounts from entered currency to ledger currency.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • createdFrom (string)

    The process or user interface from which this row was created.

    Label

    Created From

    Properties

    • not nullable
  • enteredDistributionAmount (big-decimal)

    The distribution amount in the entered currency.

    Label

    Entered Distribution Amount

  • originalAccountingDate (date)

    The original accounting date of the satisfaction event.

    Label

    Original Accounting Date

    Properties

    • not nullable
  • performanceObligationLineDistributionId (int64)

    The unique identifier of the performance obligation line distribution.

    Label

    Performance Obligation Line Distribution ID

    Properties

    • searchable
    • sortable
    • not nullable
  • postedToSubledgerDate (date)

    Date when the revenue is posted to the subledger application.

    Label

    Posted to Subledger Date

  • postedToSubledgerFlag (boolean)

    Indicates whether the distribution was posted to the subledger.

    Label

    Posted to Subledger

    Properties

    • not nullable
  • requestID (int64)

    Indicates the request ID of the job that created or last updated the row.

    Label

    Request ID

  • 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

  Expand all

  Collapse all

  Reference Object

  • accountingEventDistribution (RevenueContractAccountingEvent)

    The accounting event provides the details of the accounting events of customer contract.

    Business Object

    RevenueContractAccountingEvent

    Expand all

    Collapse all

    Fields

    • accountingEventId (int64)

      The unique identifier of the accounting event from which the distribution was created.

      Label

      Accounting Event ID

      Properties

      • searchable
      • sortable
      • not nullable

  • contract (RevenueContract)

    The customer contract provides the details of the customer contract. This includes performance obligations and promised detail lines.

    Business Object

    RevenueContract

    Expand all

    Collapse all

    Fields

    • customerContractHeaderId (int64)

      The unique identifier of the customer contract header.

      Label

      Customer Contract Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • 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

  • performanceObligation (RevenueContractPerformanceObligation)

    The customer contract performance obligation provides the details of the performance obligations of customer contract.

    Business Object

    RevenueContractPerformanceObligation

    Expand all

    Collapse all

    Fields

    • performanceObligationId (int64)

      The unique identifier of the performance obligation.

      Label

      Performance Obligation Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • promisedDetail (RevenueContractPromisedDetail)

    The customer contract promised detail outlines the promised detail lines in a customer contract.

    Business Object

    RevenueContractPromisedDetail

    Expand all

    Collapse all

    Fields

    • revenueContractPromisedDetailId (int64)

      The unique identifier of the promised detail.

      Label

      Promised Detail 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

    • applicationId (int64)

      The unique identifier of the source application that represents a functional area.

      Label

      Application

      Properties

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

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

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top