OrderItemDetail

Represents the breakdown details of an order product. Revenue Management generates these records to capture pricing and quantity changes, such as negative quantity reductions, early renewals, derived pricing or repricing during an amendment, and bundle or product attribute reconfigurations. This object is available in API version 60.0 and later.

Supported Calls

describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve()

Special Access Rules

This object is available in Enterprise, Unlimited, and Developer Editions of Revenue Cloud.

Fields

BillingReference

Type: string
Properties: Filter, Group, Nillable, Sort
Description: Reference to the original order item for which this amend or cancel record is created.

EffectiveFrom

Type: dateTime
Properties: Filter, Nillable, Sort
Description: The date when the transaction becomes effective.

EffectiveTo

Type: dateTime
Properties: Filter, Nillable, Sort
Description: The date when the transaction ends.

LineNumber

Type: int
Properties: Filter, Group, Nillable, Sort
Description: The line number of the detail record.

Name

Type: string
Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort
Description: The name of the record.

NetUnitPrice

Type: currency
Properties: Filter, Sort
Description: The unit price of the item that’s calculated after applying any discounts and before tax calculation.

OrderItemId

Type: reference
Properties: Filter, Group, Sort
Description: The ID of the related order item.

This field is a relationship field.

Relationship Name: OrderItem
Relationship Type: Lookup
Refers To: OrderItem

PriceWaterfallIdentifier

Type: string
Properties: Filter, Group, Nillable, Sort
Description: The price waterfall identifier generated by Salesforce Pricing that’s associated with the pricing of the detail record.

Quantity

Type: double
Properties: Filter, Sort
Description: The quantity specified for the item in the detail record.

ReferenceDate

Type: date
Properties: Filter, Group, Nillable, Sort
Description: The reference date of the item. For example, the start date of the subscription that’s associated with the detail record.

ReferenceNumber

Type: string
Properties: Filter, Group, Nillable, Sort
Description: The reference number of the item. For example, the order number that’s associated with the detail record.

TotalLineAmount

Type: currency
Properties: Filter, Sort
Description: The net total price of the order product, before price adjustments, inclusive of quantity and subscription term.

TotalPrice

Type: currency
Properties: Filter, Sort
Description: The total price of the item in the detail record that’s calculated using the quantity, net unit price, and after applying the pricing terms.

UnitPrice

Type: currency
Properties: Filter, Sort
Description: The unit price of the item before any discounts or tax calculation.