RevenueContractPromisedDetail

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

Expand all

Collapse all

Business Views

** Available for extracting data

• revenueContractPromisedDetailsExtract**

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

  Label

  Revenue Contract Promised Details

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • additionalSatisfactionEventExistsCode (enumeration: AdditionalSatisfactionEventExistence)

    Indicates whether the promised detail line has any additional satisfaction events on it. Values are derived from the ORA_VRM_LINE_ASE_EXISTANCE lookup type.

    Label

    Additional Satisfaction Event Exists

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: AdditionalSatisfactionEventExistence

    Valid Values

    • ORA_EVALUATED_AND_HAS_ASE_RULE
    • ORA_EVALUATED_AND_NO_ASE_RULE
    • ORA_NOT_EVALUATED
  • additionalSatisfactionEventFulfillmentCode (enumeration: AdditionalSatisfactionEventStatus)

    Indicates whether all the additional sublines indicating the fulfillment of additional satisfaction events for the promised detail line are processed. Values are derived from the ORA_VRM_LINE_ASE_PROCESS lookup type.

    Label

    Additional Satisfaction Event Fulfillment

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: AdditionalSatisfactionEventStatus

    Valid Values

    • ORA_NOT_PROCESSED
    • ORA_NOT_RECEIVED
    • ORA_NOT_REQUIRED
    • ORA_PROCESSED
  • additionalSatisfactionEventLineStatusCode (enumeration: LineSatisfactionStatus)

    The overall fulfillment status of all the additional satisfaction events on the promised detail line. Values are derived from the ORA_VRM_LINE_SATISFACTN_STATUS lookup type.

    Label

    Additional Satisfaction Event Line Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: LineSatisfactionStatus

    Valid Values

    • ORA_FULLY_SATISFIED
    • ORA_NOT_REQUIRED
    • ORA_NOT_SATISFIED
    • ORA_PARTIALLY_SATISFIED
  • allocatedAmount (big-decimal)

    Represents the portion of the transaction price allocated to the promised detail line in the contract currency.

    Label

    Allocated Amount

  • allocationRequiredFlag (boolean)

    Indicates whether the promised detail line is eligible for allocation after processing the immaterial change.

    Label

    Allocation Required

  • billedAmount (big-decimal)

    The amount billed in the contract currency for the promised detail line.

    Label

    Billed Amount

  • billingLineCreatedFlag (boolean)

    Indicates whether the zero amount billing line is created for the implied promise detail line upon full satisfaction.

    Label

    Billing Line Created

  • comments (string)

    The user-entered comments for performing an action on a promised detail line.

    Label

    Comments

  • conversionRate (big-decimal)

    The rate used to convert the promised detail line amount into the contract currency.

    Label

    Conversion Rate

  • conversionRateDate (date)

    The date when the conversion rate is used to convert the promised detail line amount to the contract currency.

    Label

    Conversion Rate Date

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

    Indicates whether the promised detail line has been discarded.

    Label

    Discard Status

  • discountAmount (big-decimal)

    The difference between the net consideration amount and the allocated amount in the contract currency for the promised detail line. A positive result represents a discount. A negative result represents a premium.

    Label

    Discount Amount

  • distributedRevenueAmount (big-decimal)

    The recognized revenue amount in the contract currency for the promised detail line.

    Label

    Distributed Revenue Amount

  • eligibleAdditionalSatisfactionEventValue (big-decimal)

    The value of the fulfillment of the additional satisfaction event according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.

    Label

    Eligible Additional Satisfaction Event Value

  • eligiblePrimarySatisfactionEventValue (big-decimal)

    The value of the fulfillment of the primary satisfaction event according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.

    Label

    Eligible Primary Satisfaction Event Value

  • enteredAllocatedAmount (big-decimal)

    The allocated transaction price in the entered currency.

    Label

    Entered Allocated Amount

  • enteredBilledAmount (big-decimal)

    The amount billed in the entered currency for the promised detail line.

    Label

    Entered Billed Amount

  • enteredDiscountAmount (big-decimal)

    Discount amount in the entered currency.

    Label

    Entered Discount Amount

  • enteredDistributedRevenueAmount (big-decimal)

    The recognized revenue amount in the entered currency for the promised detail line.

    Label

    Entered Distributed Revenue Amount

  • enteredExtendedStandaloneSellingPriceAmount (big-decimal)

    The total standalone selling price for the goods and services promised to the customers on the promised detail line.

    Label

    Entered Extended Standalone Selling Price Amount

  • enteredNetConsiderationAmount (big-decimal)

    The sum of the net consideration amount and the discount amount in the entered currency.

    Label

    Entered Net Consideration Amount

  • enteredSellingAmount (big-decimal)

    Net line amount of the performance obligation line.

    Label

    Entered Selling Amount

    Properties

    • not nullable
  • enteredUnitSSP (big-decimal)

    The amount of the unit standalone selling price of the item or performance obligation template. This value represents the absolute unit standalone selling price of the item that's assigned to a percentage based standalone selling price representation type.

    Label

    Entered Unit SSP Amount

  • enteredUnitSSPAmount (big-decimal)

    The amount of the unit standalone selling price of the item or performance obligation template. This value represents the absolute unit standalone selling price of the item that's assigned to a percentage based standalone selling price representation type.

    Label

    Entered Unit SSP Amount

  • enteredVariableConsiderationAmount (big-decimal)

    The amount for variable consideration in entered currency.

    Label

    Entered Variable Consideration Amount

  • extendedStandaloneSellingPriceAmount (big-decimal)

    The total standalone selling price in the accounted currency for the goods and services promised to the customers on the promised detail line.

    Label

    Extended Standalone Selling Price Amount

  • firstSatisfactionEventDate (date)

    The date when the first satisfaction event was created for a promised detail line.

    Label

    First Satisfaction Event Date

  • lastPrimarySatisfactionEventDate (date)

    Last fulfillment date of the primary satisfaction event.

    Label

    Last Primary Satisfaction Event Date

  • latestRevisionIntentCode (enumeration: RevisionIntentType)

    The revision intent of the last source document line version of the promised detail. Valid values are Contract Modification, Estimate Correction, and Unassigned.

    Label

    Latest Revision Intent

    Type

    • Module: oraErpCoreRevenueManagementSetup

    • Enumeration Type: RevisionIntentType

    Valid Values

    • ORA_CM
    • ORA_EC
    • ORA_UA
  • latestVersionDate (date)

    The date of the most recent version of the promised detail line's supporting source document.

    Label

    Latest Version Date

  • lineSatisfactionDate (date)

    The date on which a performance obligation line is satisfied.

    Label

    Line Satisfaction Date

  • lineSatisfactionStatus (enumeration: LineSatisfactionStatus)

    The status of the performance obligation line satisfaction. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTN_STATUS.

    Label

    Line Satisfaction Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: LineSatisfactionStatus

    Properties

    • not nullable

    Valid Values

    • ORA_FULLY_SATISFIED
    • ORA_NOT_REQUIRED
    • ORA_NOT_SATISFIED
    • ORA_PARTIALLY_SATISFIED
  • missingRevenueInformationFlag (boolean)

    Indicates whether the required revenue-related attributes for the satisfaction measurement event creation are missing on the line.

    Label

    Missing Revenue Information

  • netConsiderationAmount (big-decimal)

    Net consideration amount in the contract currency.

    Label

    Net Consideration Amount

  • parentPerformanceObligationLineID (int64)

    The identifier of the related line for an implied performance obligation line.

    Label

    Parent Performance Obligation Line ID

  • pendingAdditionalSatisfactionEventValue (big-decimal)

    Value of the fulfillment of the additional satisfaction event that's pending revenue recognition according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.

    Label

    Pending Additional Satisfaction Event Value

  • pendingPrimarySatisfactionEventValue (big-decimal)

    The value of the fulfillment of the primary satisfaction event that's pending revenue recognition according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.

    Label

    Pending Primary Satisfaction Event Value

  • planDurationinPeriods (big-decimal)

    The number of periods in the satisfaction plan.

    Label

    Plan Duration in Periods

  • planEndDate (date)

    The date when the satisfaction plan ends.

    Label

    Plan End Date

  • planStartDate (date)

    The date when the satisfaction plan begins.

    Label

    Plan Start Date

  • promisedDetailNumber (int64)

    The numeric identifier for the running sequence within a customer contract.

    Label

    Promised Detail Number

    Properties

    • not nullable
  • promisedDetailRemovedBy (string)

    The user who removed the obligation line.

    Label

    Promise Detail Removed By

  • promisedDetailRemovedDate (date)

    The date when the promised detail line was removed from the obligation.

    Label

    Promised Detail Removed Date

  • quantity (big-decimal)

    Net quantity of a promised detail line.

    Label

    Quantity

  • recognizedSatisfactionEventValue (big-decimal)

    The value of the fulfillment of both the primary and additional satisfaction events according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.

    Label

    Recognized Satisfaction Event Value

  • referenceConversionDateTypeCode (enumeration: ReferenceCurrencyDateType)

    The date type used to convert entered currency amounts to the reference currency. Valid values are defined in the ORA_REF_CONVERSION_RATE_DATE lookup type.

    Label

    Reference Conversion Date Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ReferenceCurrencyDateType

    Valid Values

    • ORA_CONTRACT_DATE
    • ORA_REF_CUR_DATE
  • referenceConversionRate (big-decimal)

    The conversion rate used to convert the amount from entered currency into reference currency.

    Label

    Reference Conversion Rate

  • referenceConversionRateDate (date)

    The date as of which a conversion rate is used to convert the amount from entered currency into reference currency.

    Label

    Reference Conversion Rate Date

  • removeFromObligationFlag (boolean)

    Indicates whether the promised detail line has been removed.

    Label

    Remove from Obligation

  • removedRequestID (int64)

    The request identifier of the job that marked this row as removed.

    Label

    Removed Request ID

  • residualApproachFlag (boolean)

    Indicates whether the pricing for the goods or services for the promised detail line is variable or missing and the standalone selling price for the performance obligation is estimated using the residual approach. Valid values are yes and no.

    Label

    Residual Approach

  • revenueContractPromisedDetailId (int64)

    The unique identifier of the promised detail.

    Label

    Promised Detail ID

    Properties

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

    The unique identifier of the source document line used for satisfaction events creation.

    Label

    Revenue Recognition Processed Document Line ID

  • revenueRecognitionProcessedDuration (big-decimal)

    The duration of the period when the revenue is amortized.

    Label

    Revenue Recognition Processed Duration

  • revenueRecognitionProcessedEndDate (date)

    The end date of the revenue recognition that was most recently used for accounting events creation.

    Label

    Revenue Recognition Processed End Date

  • revenueRecognitionProcessedFlag (boolean)

    Indicates whether the revenue recognition of this performance obligation line was processed.

    Label

    Revenue Recognition Processed

  • revenueRecognitionProcessedStartDate (date)

    The date when the revenue amortization begins.

    Label

    Revenue Recognition Processed Start Date

  • revenueRecognitionReprocessStatusCode (enumeration: RevenueRecognitionReprocessStatus)

    Indicates whether the revenue recognition of this performance obligation line was processed.

    Label

    Revenue Recognition Reprocess Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: RevenueRecognitionReprocessStatus

    Valid Values

    • ORA_NOT_REQUIRED
    • ORA_PENDING_ACCOUNTING_EVENTS
    • ORA_PENDING_PROCESSING
    • ORA_PENDING_REF_LIN_PROCESSING
    • ORA_PROCESSED
    • ORA_SATIS_EVENT_SUBLIN_ARRIVED
  • satisfactionMeasurementModel (string)

    Indicates the method used to measure and record the satisfaction for a performance obligation line. Valid values are derived from the ORA_VRM_SATIS_MEAS_MODEL lookup type.

    Label

    Satisfaction Measurement Model

  • satisfactionPlanBaseProportion (big-decimal)

    The base number proportion for the satisfaction plan.

    Label

    Satisfaction Plan Base Proportion

  • sellingAmount (big-decimal)

    The selling amount of the promised detail line in the contract currency.

    Label

    Selling Amount

  • serviceDuration (big-decimal)

    The duration of the service item in terms of the service unit of measure.

    Label

    Service Duration

  • sspHigh (big-decimal)

    The high point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges.

    Label

    SSP High

  • sspLow (big-decimal)

    The low point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges.

    Label

    SSP Low

  • sspRangeTestResult (enumeration: StandaloneSellingPriceRange)

    The result of the comparison of the actual selling price with the SSP low and high points. This result shows whether the actual value is below the low point, in range, or above the high point.

    Label

    SSP Range Test Result

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: StandaloneSellingPriceRange

    Valid Values

    • ORA_COMMON_PRICE
    • ORA_SSP_HIGH
    • ORA_SSP_LOW
    • ORA_SSP_MID
    • ORA_SSP_PUB_SALE
  • sspRangeValueApplied (enumeration: StandaloneSellingPriceRangeRule)

    The rule used to derive the unit standalone selling price based on the SSP range test result.

    Label

    SSP Range Value Applied

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: StandaloneSellingPriceRangeRule

    Valid Values

    • ORA_ABOVE_RANGE
    • ORA_BELOW_RANGE
    • ORA_WITHIN_RANGE
  • standaloneSalesFlag (boolean)

    Indicates whether the line will be used in the standalone selling price calculation.

    Label

    Standalone Sales

  • 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
  • variableConsiderationAmount (big-decimal)

    The variable consideration amount in the contract currency.

    Label

    Variable Consideration Amount

  Expand all

  Collapse all

  Reference Object

  • 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

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

  • 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

  • promisedDetailEffectivePeriod (StandaloneSellingPriceEffectivePeriod)

    The standalone selling price effective period provides the details of the standalone selling price effective periods for which standalone sales can be calculated or imported.

    Business Object

    StandaloneSellingPriceEffectivePeriod

    Expand all

    Collapse all

    Fields

    • effectivityPeriodId (int64)

      The unique identifier of a standalone selling price effective period.

      Label

      Effectivity Period ID

      Properties

      • searchable
      • sortable
      • not nullable

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

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

  • revenuePricingLine (RevenuePricingLine)

    The pricing line provides the revised net value details for a document line.

    Business Object

    RevenuePricingLine

    Expand all

    Collapse all

    Fields

    • documentLineId (int64)

      The unique identifier of a source document line.

      Label

      Document Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • revenueRecognitionProcessedSatisfactionPlan (ReceivablesRevenueSchedulingRule)

    The Receivables Revenue Scheduling Rule business object determines the accounting period or periods in which to recognize receivables and record revenue distributions for each transaction line. The revenue scheduling rule setup requires assigning an invoicing rule to transactions.

    Business Object

    ReceivablesRevenueSchedulingRule

    Expand all

    Collapse all

    Fields

    • ruleId (int64)

      Identifier of the invoicing rule and revenue scheduling rule.

      Label

      Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • satisfactionPlan (ReceivablesRevenueSchedulingRule)

    The Receivables Revenue Scheduling Rule business object determines the accounting period or periods in which to recognize receivables and record revenue distributions for each transaction line. The revenue scheduling rule setup requires assigning an invoicing rule to transactions.

    Business Object

    ReceivablesRevenueSchedulingRule

    Expand all

    Collapse all

    Fields

    • ruleId (int64)

      Identifier of the invoicing rule and revenue scheduling rule.

      Label

      Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • serviceUnitOfMeasure (UnitOfMeasure)

    The units that an application, system, or service can use with the transaction to reflect the measurement of a quantity. For example, each, box, hours, and milliliter are units used when ordering, fulfilling, and manufacturing products. The items involved in these transactions will include a numeric amount and a UOM to indicate the quantity used.

    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

  • sourceDocumentLine (RevenueSourceDocumentLine)

    The source document line detail includes document lines from upstream applications, identified as contracts and performance obligations, and used in standalone selling price calculations.

    Business Object

    RevenueSourceDocumentLine

    Expand all

    Collapse all

    Fields

    • sourceDocumentLineId (int64)

      The internal identifier for source document line.

      Label

      Source Document Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • standaloneSellingPrice (RevenueContractStandaloneSellingPrice)

    The standalone selling price provides the details of unit standalone selling prices

    Business Object

    RevenueContractStandaloneSellingPrice

    Expand all

    Collapse all

    Fields

    • standaloneSellingPriceLineId (int64)

      The identifier for a Standalone Selling Price line.

      Label

      Standalone Selling Price Line ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top