StandaloneSellingPriceProfileAssignment

The standalone selling price profile assignment provides the details of the assignments of Vendor-Specific Objective Evidence templates to items.

Expand all

Collapse all

Business Views

** Available for extracting data

• standaloneSellingPriceProfileAssignmentsExtract**

  The standalone selling price profile assignment provides the details of the assignments of Vendor-Specific Objective Evidence templates to items.

  Label

  Standalone Selling Price Profile Assignments

  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: oraErpCoreRevenueManagementSetup

    • Enumeration Type: StandaloneSellingPriceRange

    Valid Values

    • ORA_COMMON_PRICE
    • ORA_SSP_HIGH
    • ORA_SSP_LOW
    • ORA_SSP_MID
    • ORA_SSP_PUB_SALE
  • 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: oraErpCoreRevenueManagementSetup

    • Enumeration Type: StandaloneSellingPriceRange

    Valid Values

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

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • effectiveEndPeriod (int64)

    The effective ending period name for the item assigned to the standalone selling price profile.

    Label

    Effective End Period

    Properties

    • searchable
  • effectiveStartPeriod (int64)

    The extraction period during which an item is assigned to a template.

    Label

    Effective Start Period

    Properties

    • searchable
    • not nullable
  • 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: oraErpCoreRevenueManagementSetup

    • Enumeration Type: StandaloneSellingPriceRange

    Valid Values

    • ORA_COMMON_PRICE
    • ORA_SSP_HIGH
    • ORA_SSP_LOW
    • ORA_SSP_MID
    • ORA_SSP_PUB_SALE
  • inUseFlag (boolean)

    Indicates whether the record is active and can't be deleted. 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: oraErpCoreRevenueManagementSetup

    • Enumeration Type: ItemType

    Properties

    • searchable
    • not nullable

    Valid Values

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

    The unique identifier of an item type.

    Label

    Item Type ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
  • minimumStandaloneSales (int64)

    The minimum number of standalone sales needed to determine a valid standalone selling price.

    Label

    Minimum Standalone Sales

  • monthsCovered (int64)

    The number of coverage periods from which a standalone selling price calculation process will gather the standalone sales.

    Label

    Months Covered

  • sspProfileAssignmentId (int64)

    The unique identifier of the standalone selling price profile assignments.

    Label

    SSP Profile Assignment ID

    Properties

    • searchable
    • sortable
    • not nullable
  • sspRangeTolerancePercent (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

  • sspToleranceUsageCode (enumeration: ToleranceCode)

    Indicates the standalone selling price value tolerance range level used to calculate the contract discount adjustment.

    Label

    SSP Tolerance Usage

    Type

    • Module: oraErpCoreRevenueManagementSetup

    • Enumeration Type: ToleranceCode

    Valid Values

    • H
    • L
    • M
  • standaloneSellingPriceProfileId (int64)

    The identifier of the standalone selling price profile.

    Label

    Standalone Selling Price Profile ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • not nullable
  • toleranceRangeCoverage (big-decimal)

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

    Label

    Tolerance Range Coverage

  • toleranceRangeHighPercentage (big-decimal)

    The highest percentage of the standalone selling price tolerance range.

    Label

    Tolerance Range High Percentage

  • toleranceRangeLowPercentage (big-decimal)

    The lowest percentage of the standalone selling price tolerance range.

    Label

    Tolerance Range Low Percentage

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • 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

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

  • 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

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

  • 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

  • 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