RevenueContractStandaloneSellingPrice

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

Expand all

Collapse all

Business Views

** Available for extracting data

• revenueContractStandaloneSellingPricesExtract**

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

  Label

  Revenue Contract Standalone Selling Prices

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • aboveHighPoint (enumeration: StandaloneSellingPriceRange)

    The rule to be used in accordance with the standalone selling price policy of the business when the actual value is above the SSP High Point. Valid values are from the ORA_VRM_SSP_RANGE_CODE lookup type.

    Label

    Above High Point

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: StandaloneSellingPriceRange

    Properties

    • creatable
    • updatable

    Valid Values

    • ORA_COMMON_PRICE
    • ORA_SSP_HIGH
    • ORA_SSP_LOW
    • ORA_SSP_MID
    • ORA_SSP_PUB_SALE
  • averagePrice (big-decimal)

    An average price of an item, item group, and memo line.

    Label

    Average Price

    Properties

    • creatable
  • belowLowPoint (enumeration: StandaloneSellingPriceRange)

    The rule to be used in accordance with the standalone selling price policy of the business when the actual value is below the SSP Low Point. Valid values are from the ORA_VRM_SSP_RANGE_CODE lookup type.

    Label

    Below Low Point

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: StandaloneSellingPriceRange

    Properties

    • creatable
    • updatable

    Valid Values

    • ORA_COMMON_PRICE
    • ORA_SSP_HIGH
    • ORA_SSP_LOW
    • ORA_SSP_MID
    • ORA_SSP_PUB_SALE
  • comments (string)

    The user-entered exception comments for Standalone Selling Price.

    Label

    Comments

    Properties

    • creatable
  • conversionDate (date)

    The date when the conversion rate is used to convert standalone selling price amounts in entered currency to the ledger currency.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The rate used to convert standalone selling price amounts from the entered currency to the ledger currency.

    Label

    Conversion Rate

  • coverageEndDate (date)

    The end date of the coverage period used to compute Standalone Selling Price value.

    Label

    Coverage End Date

  • coverageStartDate (date)

    The start date of the coverage period used to compute standalone selling price value.

    Label

    Coverage Start Date

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • establishedBy (string)

    The user who established the standalone selling price value.

    Label

    Established By

  • establishedDate (date-time)

    The date when the standalone selling price is established.

    Label

    Established Date

  • exceptionAction (string)

    Indicates an action taken on a standalone selling price with an exception status. A revenue analyst or manager can determine whether the exception standalone selling price is valid or invalid. Valid values are from the VSOE Price Exception Line Status lookup.

    Label

    Exception Action

  • exceptionComment (string)

    The user entered comments.

    Label

    Exception Comment

  • exceptionReason (string)

    The reason provided by a revenue analyst or manager to mark if the standalone selling price for an item is invalid. Valid values are from the VRM_VSOE_PRICE_EXLINE_REASON lookup.

    Label

    Exception Reason

  • exceptionType (string)

    The type of a standalone selling price exception such as Manual and System. Valid values are from the VRM_VSOE_PRICE_EXLINE_TYPE lookup.

    Label

    Exception Type

  • highestPrice (big-decimal)

    The highest selling price of standalone sales of an item with in a coverage period.

    Label

    Highest Price

    Properties

    • creatable
  • inRange (enumeration: StandaloneSellingPriceRange)

    The rule to be used in accordance with the standalone selling price policy of the business when the actual value is between the SSP Low and SSP High Points. Valid values are from the ORA_VRM_SSP_RANGE_CODE lookup.

    Label

    In Range

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: StandaloneSellingPriceRange

    Properties

    • creatable
    • updatable

    Valid Values

    • ORA_COMMON_PRICE
    • ORA_SSP_HIGH
    • ORA_SSP_LOW
    • ORA_SSP_MID
    • ORA_SSP_PUB_SALE
  • inUse (string)

    Indicates whether the standalone selling price line has been used in the compliance process. Valid values are Yes and No.

    Label

    In Use

  • itemType (enumeration: ItemType)

    The item type in a promised detail line. Valid values are Item, Memo Line, and Item Group.

    Label

    Item Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ItemType

    Properties

    • searchable

    Valid Values

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

    An item pricing count of a standalone selling price set.

    Label

    Line Count

  • lineSource (string)

    Indicates the source of the sets whether the price is generated manually or by a system. Valid values are Manual and System.

    Label

    Line Source

  • lowestPrice (big-decimal)

    The lowest selling price of standalone sales of an item within a coverage period.

    Label

    Lowest Price

    Properties

    • creatable
  • manuallyEnteredStatusFlag (boolean)

    Indicates whether the standalone selling price value is the manually added by the user. Valid values are Yes and No.

    Label

    Manually Entered Status

  • minimumLineCount (int64)

    The minimum number of standalone sales required to calculate a valid standalone selling price.

    Label

    Minimum Line Count

  • obseredSspReviewStatus (string)

    The review status of standalone selling price value. Values are from the VRM_VSOE_VALUE_REVIEW_STATUS lookup.

    Label

    Observed SSP Review Status

  • observedSspReviewReason (string)

    The value that identifies the review reason of the standalone selling price value. Valid values are from the VRM_VSOE_VALUE_REVIEW_REASON lookup.

    Label

    Observed SSP Review Reason

  • observedSspValueReason (string)

    The value that identifies the reason of the standalone selling price value. Valid values are from the VRM_VSOE_VALUE_REASON lookup.

    Label

    Observed SSP Value Reason

  • publishedSalesPoint (big-decimal)

    The price determined and published by the business as published sales point of an item or service.

    Label

    Published Sales Point

    Properties

    • creatable
    • updatable
  • sspHighPoint (big-decimal)

    The highest 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 Point

    Properties

    • creatable
    • updatable
  • sspLowPoint (big-decimal)

    The lowest 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 Point

    Properties

    • creatable
    • searchable
    • updatable
  • sspMidPoint (big-decimal)

    The midpoint 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 Midpoint

    Properties

    • creatable
    • updatable
  • sspRangeTolerancePercentage (big-decimal)

    The tolerance percentage in accordance with the standalone selling price policy of the business. The standalone selling price low point and high point are calculated by the application when the standalone selling price tolerance percentage and standalone selling price midpoint are provided for an item or service.

    Label

    SSP Range Tolerance Percentage

    Properties

    • creatable
  • sspToleranceHighValue (big-decimal)

    The highest value of the standalone selling price tolerance range.

    Label

    SSP Tolerance High Value

    Properties

    • creatable
    • updatable
  • sspToleranceLowValue (big-decimal)

    The lowest value of the standalone selling price tolerance range.

    Label

    SSP Tolerance Low Value

    Properties

    • creatable
    • updatable
  • sspType (enumeration: FairMarketValueType)

    The type of standalone selling price of the item. Valid values are User Observed standalone selling price and User Estimated standalone selling price.

    Label

    SSP Type

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: FairMarketValueType

    Properties

    • creatable
    • updatable

    Valid Values

    • ESTIMATED_SELLING_PRICE
    • ORA_USER_OBSERVED_SSP
    • STANDALONE_SELLING_PRICE
  • sspTypeObservedSspStatus (string)

    The status of standalone selling price value. Valid values are from the VRM_VSOE_PRICE_LINE_STATUS lookup.

    Label

    Observed SSP Status

  • standaloneSellingPriceAmount (big-decimal)

    A standalone selling price of an item, item group, or memo line in entered currency.

    Label

    Standalone Selling Price Amount

    Properties

    • creatable
    • searchable
    • updatable
  • standaloneSellingPriceLineId (int64)

    The identifier for a Standalone Selling Price line.

    Label

    Standalone Selling Price Line ID

    Properties

    • searchable
    • sortable
    • not nullable
  • standardDeviation (big-decimal)

    Stores the standard deviation based on the standalone selling price basis line set used for calculating the standalone selling price.

    Label

    Standard Deviation

  • status (string)

    The status set for standalone selling price. Valid values are processed, processing, ready set, and unprocessed.

    Label

    Status

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

    Stores the standard deviation based on the standalone selling price basis line set used for calculating the standalone selling price.

    Label

    Standard Deviation

  • toleranceCoverageCount (int64)

    Stores the number of standalone sales that its unit selling price falls within tolerance range price of an item.

    Label

    Tolerance Coverage Count

  • tolerancePercentageHighPercentage (big-decimal)

    The highest percentage of the standalone selling price tolerance range.

    Label

    Tolerance Range High Percentage

    Properties

    • creatable
    • updatable
  • tolerancePercentageLowPercentage (big-decimal)

    The lowest percentage of the standalone selling price tolerance range.

    Label

    Tolerance Range Low Percentage

    Properties

    • creatable
    • updatable
  • toleranceRangeCoverage (big-decimal)

    Indicates the minimum standalone sales percentage required so that its unit selling price falls within the tolerance range price of an item.

    Label

    Tolerance Range Coverage

  • totalAmount (big-decimal)

    The total line amount of a price basis data set.

    Label

    Total Amount

  • totalQuantity (big-decimal)

    The total quantity of a price basis data set.

    Label

    Total Quantity

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • 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

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

  • inventoryOrganization (OrganizationConfiguration)

    The item inventory organization of the inventory item on the source document line.

    Business Object

    OrganizationConfiguration

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the item or inventory organization. It's a primary key that the application generates when it creates an item or inventory organization.

      Label

      ID

      Properties

      • searchable
      • 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

  • itemCode (Item)

    An object that can be transacted, such as physical product or service offering.

    Business Object

    Item

    Expand all

    Collapse all

    Fields

    • itemId (int64)

      Value that uniquely identifies the part, material, product, or service that's unique as compared with other items by the nature of its attributes.

      Label

      Item

      Properties

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

      Value that uniquely identifies the organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.

      Label

      Organization

      Properties

      • 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

  • memoLineCode (ReceivablesStandardMemoLine)

    The memo line provides information about standard memo lines for invoices, debit memos, on-account credits, debit memo reversals, and chargebacks, including unit of measure, standard price, memo line translation, tax rate code, standard invoicing and revenue scheduling rules, and reference set. It also derives the revenue account when AutoAccounting is based on standard line items.

    Business Object

    ReceivablesStandardMemoLine

    Expand all

    Collapse all

    Fields

    • memoLineSequenceId (int64)

      The sequence identifier of the memo line.

      Label

      Memo Line Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • observedPriceSet (RevenueContractObservedStandaloneSellingPriceSet)

    The Revenue Contract Observed Standalone Selling Price Set Business Object provides the details of the set of standalone sales used to calculate the standalone selling price, the observed standalone selling price, and the history of the observed standalone selling prices.

    Business Object

    RevenueContractObservedStandaloneSellingPriceSet

    Expand all

    Collapse all

    Fields

    • observedStandaloneSellingPriceSetId (int64)

      The unique identifier of the observed standalone selling price set.

      Label

      Observed Standalone Selling Price Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • performanceObligationTemplate (PerformanceObligationTemplate)

    The performance obligation template is a structured document used to outline and manage the performance obligations within a contract. It explains the rules for creating performance obligations.

    Business Object

    PerformanceObligationTemplate

    Expand all

    Collapse all

    Fields

    • performanceObligationTemplateId (int64)

      The identifier of the performance obligation template.

      Label

      Performance Obligation Template 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

  • standaloneSellingPriceProfile (StandaloneSellingPriceProfile)

    The identifier of the standalone selling price profile.

    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

  • unitOfMeasureCode (UnitOfMeasure)

    A statistical unit of measure contains information about where both statistical and monetary amounts for the same account are used within a single journal entry.

    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

Back to Top