RevenuePricingLine

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

Expand all

Collapse all

Business Views

** Available for extracting data

• revenuePricingLinesExtract**

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

  Label

  Revenue Pricing Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • addToExistingContract (enumeration: AddToContractAction)

    Indicates how the latest version line was added to the contract. Valid values are Add to an existing performance obligation and Created a new performance obligation.

    Label

    Add to Existing Contract

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: AddToContractAction

    Valid Values

    • ORA_ADD_TO_EXISTING_PO
    • ORA_CREATE_NEW_PO
  • billedAmount (big-decimal)

    The amount billed for the promised detail line.

    Label

    Billed Amount

  • comments (string)

    The user entered comments for standalone sales.

    Label

    Comments

  • contractRevisionDate (date)

    The date when the revenue contract was modified.

    Label

    Contract Revision Date

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • discountPercentage (big-decimal)

    Discount percentage after adjusting the return amount.

    Label

    Discount Percentage

  • documentGroupID (int64)

    Source document group identifier used to group the initial recurring source document header and system-generated recurring source document headers. Value is the source document identifier for the original source document.

    Label

    Document Group ID

  • documentLineId (int64)

    The unique identifier of a source document line.

    Label

    Document Line ID

    Properties

    • searchable
    • sortable
    • not nullable
  • documentLineTypeCode (enumeration: DocumentLineType)

    Specifies the type of line sent from the source system. Valid values are derived from the ORA_VRM_DOCUMENT_LINE_TYPE lookup type. Blank is equivalent to ORA_NEW_LINE.

    Label

    Document Line Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: DocumentLineType

    Valid Values

    • ORA_ADD_TO_CONTRACT_NEW_LINE
    • ORA_NEW_LINE
    • ORA_RETURN_LINE
    • ORA_VERSION_LINE
  • immaterialChangeType (enumeration: ImmaterialChangeType)

    The immaterial change type available for this line. Valid values are derived from the ORA_IMMATERIAL_CHANGE_TYPE lookup type.

    Label

    Immaterial Change Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ImmaterialChangeType

    Valid Values

    • IMMATERIAL
    • MATERIAL
  • initialDocumentLineID (int64)

    The reference key that identifies the parent source document line for the current line.

    Label

    Initial Document Line ID

  • itemType (enumeration: ItemType)

    Indicates the type of a source document item. Valid values are ITEM, MEMO_LINE, and ITEM_GROUP.

    Label

    Item Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ItemType

    Valid Values

    • ITEM
    • ITEM_GROUP
    • MEMO_LINE
    • ORA_BUNDLE
    • ORA_I_BUND
    • ORA_M_BUND
  • itemTypeID (int64)

    The unique identifier of the item type.

    Label

    Item Type ID

  • latestContractRevisionDate (date)

    The date when the revenue contract was last modified.

    Label

    Latest Contract Revision Date

  • latestImmaterialChangeType (enumeration: ImmaterialChangeType)

    The immaterial change type available for this line. Valid values are derived from the ORA_IMMATERIAL_CHANGE_TYPE lookup type.

    Label

    Latest Immaterial Change Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ImmaterialChangeType

    Valid Values

    • IMMATERIAL
    • MATERIAL
  • latestPeriodActionCode (enumeration: PeriodSublineAction)

    The latest satisfaction period action that was processed on this document line. Valid values are from the ORA_VRM_PERIOD_SUBLINE_ACTION lookup type.

    Label

    Latest Period Action

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: PeriodSublineAction

    Valid Values

    • REINSTATE
    • REVERSE
  • latestReversalDays (int32)

    The number of days since the latest suspension of service. This value is calculated based on the number of days between the effective plan end date of the promised detail and the recently processed reversal subline.

    Label

    Latest Reversal Days

  • netBasePrice (big-decimal)

    Net base price used to validate VSOE value of a MEA line.

    Label

    Net Base Price

  • netLineAmount (big-decimal)

    Net line amount after adjusting return amount.

    Label

    Net Line Amount

  • netQuantity (big-decimal)

    The total quantity of a transaction line for the source document line.

    Label

    Net Quantity

  • netUnitListPrice (big-decimal)

    Net unit list price discount used to validate VSOE value of a MEA line.

    Label

    Net Unit List Price

  • netUnitSSP (big-decimal)

    Net unit standalone selling price of the item or memo line.

    Label

    Net Unit SSP

  • netUnitSellingPrice (big-decimal)

    Unit selling price after adjusting return amount.

    Label

    Net Unit Selling Price

  • originalDocumentLineID (int64)

    The identifier of the original source document line used to create the recurring source document line.

    Label

    Original Document Line ID

  • percentageOfBasePrice (big-decimal)

    Unit sales percent base price after adjusting return amount.

    Label

    Percentage of Base Price

  • planDurationInPeriods (big-decimal)

    Number of periods in which revenue of this performance obligation line is to be recognized.

    Label

    Plan Duration in Periods

  • previousDocumentLineID (int64)

    The internal identifier of the Reference document line.

    Label

    Previous Document Line ID

  • pricingDimensionStatus (enumeration: ProcessStatus)

    Indicates whether pricing combination is successfully derived for the given document line.

    Label

    Pricing Dimension

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ProcessStatus

    Valid Values

    • I
    • N
    • Y
  • recurringLineStatusFlag (boolean)

    Indicates whether the line was processed for the period. Valid values are Yes or No from the lookup type.

    Label

    Recurring Line Status

  • revenueProcessStatus (string)

    The status of a document line to indicate whether line is processed by revenue.

    Label

    Revenue Process Status

  • revisedCostAmount (big-decimal)

    The cost of sales adjusted after the document is revised.

    Label

    Revised Cost Amount

  • revisedDiscountAmount (big-decimal)

    Net discount amount of the original line.

    Label

    Revised Discount Amount

  • revisedGrossMarginPercentage (big-decimal)

    The gross margin of sales adjusted after the document is revised.

    Label

    Revised Gross Margin Percentage

  • revisedRecurringAmount (big-decimal)

    Revised selling amount per frequency for the recurring line.

    Label

    Revised Recurring Amount

  • revisedRecurringFrequency (big-decimal)

    The identifier for the revised recurring frequency of the line. Valid values are Yes and No.

    Label

    Revised Recurring Frequency

  • revisedRecurringPatternCode (enumeration: RecurringPattern)

    The identifier for the revised recurring frequency of the line. Valid values are Yes and No.

    Label

    Revised Recurring Pattern

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: RecurringPattern

    Valid Values

    • ORA_MO
    • ORA_WK
    • ORA_YR
  • revisedRecurringStatusFlag (boolean)

    Indicates whether the line recurs on the line's satisfaction plan end date. Valid values are Yes and No.

    Label

    Revised Recurring Status

  • revisedRuleEndDate (date)

    The end date of the revised revenue recognition for the revenue scheduling rule.

    Label

    Revised Rule End Date

  • revisedRuleStartDate (date)

    The start date of the revised revenue recognition for the revenue scheduling rule.

    Label

    Revised Rule Start Date

  • revisedServiceDuration (big-decimal)

    The duration allowed for revising the service item in terms of the unit of measure.

    Label

    Revised Service Duration

  • revisedTerminationDate (date)

    The date when the line was terminated and will no longer recur automatically.

    Label

    Revised Termination Date

  • revisionIntent (enumeration: RevisionIntentType)

    Identifies the intent of the revision line. Valid values are Contract Modification, Estimate Correction, or Unassigned.

    Label

    Revision Intent

    Type

    • Module: oraErpCoreRevenueManagementSetup

    • Enumeration Type: RevisionIntentType

    Valid Values

    • ORA_CM
    • ORA_EC
    • ORA_UA
  • satisfactionMeasurementModel (string)

    Identifies the method to be used to measure and record the fulfillment. Valid values are Percentage, Period, and Quantity.

    Label

    Satisfaction Measurement Model

  • sourceDocumentDate (date)

    The date of the source document for pricing.

    Label

    Source Document Date

    Properties

    • not nullable
  • status (enumeration: RevenueLineStatus)

    Indicates whether to display the SSP for the line. Valid values are Yes and No.

    Label

    Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: RevenueLineStatus

    Valid Values

    • I
    • M
    • N
    • P
    • Y
  • terminationDate (date)

    The date when the revenue line was terminated.

    Label

    Termination Date

  • 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
  • topInitialDocumentLineID (int64)

    The reference key that identifies the topmost parent document line for the current line.

    Label

    Top Initial Document Line ID

  • totalReversalDays (int32)

    The total number of days the service was suspended. This value is calculated based on the number of days between the effective dates of all reversals and their corresponding reinstatements.

    Label

    Total Reversal Days

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • warningMessage (string)

    Specifies the name of the message for the warning line.

    Label

    Warning Message

  Expand all

  Collapse all

  Reference Object

  • contractClassification (ERPLookupCode)

    The classification used to categorize revenue contracts, such as consumer, subscription services, software license, and professional services. The contract classification is user-defined and can be used in reporting, and in subledger accounting rules.

    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

  • contractIdentificationRule (RevenueContractIdentificationRule)

    The contract identification rule provides the details of the contract identification rules used to identify customer contracts.

    Business Object

    RevenueContractIdentificationRule

    Expand all

    Collapse all

    Fields

    • contractIdentificationRuleId (int64)

      The numeric identifier of the contract identification rule.

      Label

      Contract Identification Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • itemClassification (ERPLookupCode)

    The classification to categorize items such as Hardware, Software License, Hardware Maintenance, and Software Support as defined by the user.

    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

  • itemGroup (RevenueItemGroup)

    The revenue item group provides details of item groups and their assigned items.

    Business Object

    RevenueItemGroup

    Expand all

    Collapse all

    Fields

    • itemGroupId (int64)

      The identifier of the item group.

      Label

      Item Group ID

      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

  • pricingDimensionCombination (RevenueContractPricingDimensionCombination)

    The pricing dimension combination provides pricing dimension details for establishing the standalone selling price of a product or price.

    Business Object

    RevenueContractPricingDimensionCombination

    Expand all

    Collapse all

    Fields

    • pricingDimensionCombinationId (int64)

      The unique identifier of the pricing dimension combination.

      Label

      Pricing Dimension Combination ID

      Properties

      • searchable
      • sortable
      • not nullable

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

  • revisedRevenueSchedulingRule (ReceivablesAccountingRule)

    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

    ReceivablesAccountingRule

    Expand all

    Collapse all

    Fields

    • ruleId (int64)

      Identifier of the invoicing rule and revenue scheduling rule.

      Label

      Rule ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • revisedServiceUnitofMeasure (UnitOfMeasure)

    The unit of measure of the service or subscription referred on the promised detail line.

    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

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

  • sourceDocument (RevenueSourceDocument)

    The contract source document provides the details of the documents from the upstream applications.

    Business Object

    RevenueSourceDocument

    Expand all

    Collapse all

    Fields

    • documentId (int64)

      The identifier of the source document for a sales order, invoice, project, or service contract.

      Label

      Document ID

      Properties

      • searchable
      • sortable
      • not nullable

  • sourceDocumentLine (RevenueSourceDocumentLine)

    The internal identifier for source document line.

    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

  • standaloneSellingPriceProfile (StandaloneSellingPriceProfile)

    The standalone selling price profile provides the details of the standalone selling price profiles, items assigned to the profile, and pricing dimension band assignments.

    Business Object

    StandaloneSellingPriceProfile

    Expand all

    Collapse all

    Fields

    • standaloneSellingPriceProfileId (int64)

      The identifier of the standalone selling price profile.

      Label

      Standalone Selling Price Profile ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top