Standard Process Transaction Line Attributes

The following table lists Transaction Line attributes provided in the Standard Process.

 Name   Variable Name   Type   Description
Action Code

oRCL_ABO_ActionCode_l

Menu

Indicates the changes required by the transaction line.

Amount (Discount)

discountAmount_l

Currency

The discount amount for this line.

Amount (List)

listAmount_l

Currency

The extended list amount for this line.

Amount (Net)

netAmount_l

Currency

The extended list amount minus any discounts for this line.

Annual Cost

annualCost_l

Currency

The extended cost for recurring pricing on this transaction line.

Annual Discount

annualDiscount_l

Currency

The annual discount on the recurring charges on this line.

Annual Margin

annualMargin_l

Currency

The extended margin for recurring pricing on this transaction line.

Annual Value (List)

annualListValue_l

Currency

The extended value at list price for recurring pricing on this transaction line over the duration of the contracted periods.

Annual Value (Net)

annualValue_l

Currency

The annual contract value of the recurring charges on this line.

Associated Line Id

associatedLineId_l

Text

Document number to be associated with the subscription line.

Associated Order Id

associatedOrderId_l

Text

Source order Id associated with the subscription line

Available Rate Plan Set Control

_availableRatePlanSetControl

Integer

 

Available Rate Plans

_availableRatePlans

Menu

This menu attribute is populated with the list of available rate plans.

Cancel Reason

cancelReason_l

Menu

The reason why the customer canceled this line.

Change Code

changeCode_l

Menu

A single select menu to handle all the possible codes to close a subscription.

Change Reason

changeReason_l

Menu

A single select menu to handle all the possible reasons for closing a subscription.

Charge Set Control

_chargeSetControl

Integer

 

Component Attributes

oRCL_ABO_ComponentAttributes_l

Text Area

A comma separated collection of key / value pair attributes that define the configuration of this asset / component plus an action code indicating whether the attribute has changed.

Config Extra Info

_config_extra_info

Text Area

Configuration Extra Information.

Configuration ID

_configuration_id

Text

Configuration id for integrations.

Contract Cost

contractCost_l

Currency

The total of all contract extended costs for this line, including one-time and recurring costs.

Contract Discount

contractDiscount_l

Currency

The total discount of this line including all one-time and recurring charges.

Contract End Date

contractEndDate_l

Date

Date that the customer stops to receive the service.

Contract Margin

contractMargin_l

Currency

The total of all contract extended margins for this line, including one-time and recurring values.

Contract Start Date

contractStartDate_l

Date

Date that the customer starts to receive the service.

Contract Value (List Rollup)

contractListValueRollup_l

Currency

Contract list value on this line or for the root model lines, the sum of all contract list values for all the child lines.

Contract Value (List)

contractListValue_l

Currency

The total of all contract list value of this line, including all one-time and recurring charges.

Contract Value (Net Rollup)

contractValueRollup_l

Currency

Contract value on this line or for the root model lines, the sum of all contract revenues for all the child lines.

Contract Value (Net Summable)

contractValue_l

Currency

The total contract value of this line including all one-time and recurring charges.

Contracted Periods

contractedPeriods_l

Integer

Number of periods the customer has contracted to receive the item.

Contracted Periods (Rollup)

contractedPeriodsRollup_l

Integer

Number of periods the customer has contracted to receive the item or for the root model rolled up to include all child values.

Cost Amount

costAmount_l

Currency

The total cost of this line.

Coverage Line Number

_s_coverageLineNumber

Text

Source line number of the coverage line for OM Integration.

Coverage Order Number

_s_coverageOrderNumber

Text

Source order number of the coverage line for OM Integration.

Created By

createdBy_l

Text

The person that created the transaction line.

Created Date

createdDate_l

Date

The date when the transaction line was created.

Custom Discount Amount

customDiscountAmount_l

Currency

The amount by which to adjust the list price because of a custom discount.

Discount

customDiscountValue_l

Float

Used to capture the numeric value associated with the discount type. This might be an override price, amount off or percentage.

Discount %

discountPercent_l

Float

The percentage of the Contract Value (List) that is discounted off of the transaction line.

Discount Percent (Rollup)

discountPercentRollup_l

Float

The percentage of the Contract Value (List) that is discounted off of the transaction line or for the root model rolled up to include all child values.

Discount Type

customDiscountType_l

Menu

The type of custom discount to apply to this line.

Document Number

documentNumber_l

Text

Document number of the line.

Freeze Negotiation Flag

_s_freezeNegotiationFlag_l

Boolean

Flag indicating whether price negotiation is permitted.

Fulfillment Line Id

fulfillmentLineId_l

Text

Value that uniquely identifies the fulfillment line.

Fulfillment Organization Code

fulfillmentOrganizationCode_l

Text

Abbreviation that identifies the organization that ships the shipment.

Fulfillment Status

fulfillmentStatus_l

Menu

The status for this line supplied by the fulfillment system after the transaction is submitted as a sales order.

Group Sequence Number

_group_sequence_number

Group Sequence Number Attribute

Group sequence number for the sub-document.

html_line_scatterplot

_s_html_line_scatterplot_l

Read-only text or HTML

Hold line scatter plot graph.

html_line_timeseries_l

_s_html_line_timeseries_l

Read-only text or HTML

Hold line time series graph.

Instance ID

itemInstanceId_l

Text

The unique, invariant, internal identifier of this instance of a product. It is used to link sales order lines to the assets they change in an asset based order and as the key stored in a sales order line association. This ID is assigned when the product instance is created in either an external federated asset repository or in CPQ when a sales order line is created.

Instance Name

itemInstanceName_l

Text

The public identifier of the instance of a product. For goods this is typically the serial #. For services it might be another identifier such as the telephone #. This does not have to be unique across all product instances (e.g. a cell phone # may be reallocated over time). It is one of the primary attributes for searching for a product instance.

Inventory Item ID

oRCL_SFA_InventoryItemID_l

Text

The inventory item id of the sales product in SFA.

Is Coverage Product

_is_coverage

Boolean

Indicates whether the product is of coverage type

Last Price Paid

_s_lastPricePaid_l

Currency

The most recent price at which the part/model was quoted.

Last Price Paid (CustomerId)

_s_lastPricePaidCustomerId_l

Currency

The most recent price at which the part/model was quoted to the customer.

Last Updated

lastUpdatedDate_l

Date

The date and time the transaction line was last updated.

Last Updated By

lastUpdatedBy_l

Text

The person that last updated this transaction line.

Line BOM Effective Date

_line_bom_effective_date

Date

System attribute to be stored in model line effective date to drive date effectivity in all BOM mappings.

Line BOM Item Quantity

_line_bom_item_quantity

Integer

The BOM item line quantity. This is the unexploded line quantity, whereas _price_quantity stores the exploded quantity.

Line BOM Level

_line_bom_level

Integer

The BOM item depth (level) in the quote.

Line BOM Name

_line_bom_name

Text

The name of the BOM item

Line BOM Part Number

_line_bom_part_number

Text

The part number of the BOM item. Only applicable to the model line.

Line BOM Variable Name

_line_bom_variable_name

Text

The variable name of the BOM item

Line Delta Action Code

aBO_Delta_Action_Code_l

Menu

An action code indicating whether a transaction line attribute has changed during an ABO operation.

Line Discount Guidance Ceiling

_s_lineDiscountGuidanceCeiling_l

Float

Upper bound of the line discount guidance.

Line Discount Guidance Floor

_s_lineDiscountGuidanceFloor_l

Float

Lower bound of the line discount guidance.

Line Discount Guidance Max

_s_lineDiscountGuidanceMax_l

Float

Max of the line discount guidance.

Line Discount Guidance Meter Gauge

_s_lineDiscountGuidanceMeterGauge_l

Read-only text or HTML

Hold line discount guidance graph.

Line Display Name

_line_display_name

Text

Display name attribute for line items.

Line Item BOM Attributes

_line_bom_attributes

Text Area

BOM attributes, stored as a JSON string.

Line Item BOM ID

_line_bom_id

Text

The BOM item instance id.

Line Item Type

_line_item_type

Text

Type attribute for line items.

Line Number

lineNumber_l

Integer

Line number in a line item grid is a sequential number assigned to each row or line of the grid. This is used to sort lines on the screen and in documents.

Line Type

lineType_l

Menu

The type of a transaction line whether it represents a model or a part.

List Price (Rollup)

listPriceRollup_l

Currency

The list price of the item or for the root model rolled up to include all child values.

Margin

unitMargin_l

Currency

The margin for a single unit of this transaction line.

Margin %

marginPercent_l

Float

The percentage of the List price for which this transaction line's margin accounts.

Margin Amount

marginAmount_l

Currency

The margin for all quoted units of this transaction line.

MRR (Rollup)

monthlyRecurRevRollup_l

Currency

Monthly recurring revenue on this line or for the root model lines, the sum of monthly recurring revenues for all the child lines.

MRR (Summable)

monthlyRecurRevSummable_l

Currency

Monthly recurring revenues net of all discounts for this line.

MUR (Rollup)

monthlyUsageRevRollup_l

Currency

Monthly usage revenue on this line or for the root model lines, the sum of monthly usage revenues for all the child lines.

MUR (Summable)

monthlyUsageRevSummable_l

Currency

Monthly usage revenues net of all discounts for this line.

Net Amount (Rollup)

netAmountRollup_l

Currency

The extended list amount minus any discounts for this line or for the root model rolled up to include all child values.

Net Price (Rollup)

netPriceRollup_l

Currency

The price paid by the customer for the individual item or for the root model rolled up to include all child values.

Non-Recurring Revenue (Rollup)

nonRecurRevRollup_l

Currency

One-time revenue on this line or for the root model lines, the sum of one-time revenues for all the child lines.

Non-Recurring Revenue (Summable)

nonRecurRevSummable_l

Currency

One-time revenue net of all discounts for this line.

Opportunity Win/Loss Status (Line)

oRCL_SFA_Status_l

Text

The SFA status of the transaction line. This value may differ from the transaction status for CPQ. Initially, there is no internal logic setting this value.

Order Date

orderDate_l

Date

The date and time the order was placed for fulfillment.

Order Number

oRCL_ERP_OrderNumber_l

Text

The order number assigned by the external Order Management and ERP system.

Owner Resource ID

ownerResourceId_l

Text

The owner of the associated Opportunity Revenue Line.

Parent Asset Key

parentAssetKey_l

Text

The identifier for the corresponding parent asset in an external asset repository. Used only for asset-related lines.

Parent Doc Number

parentDocNumber_l

Text

Document number of the parent line item.

Parent Line Item BOM ID

_line_bom_parent_id

Text

The parent BOM item instance id.

Part ID

_s_partID_l

Text

Part number from the Items table.

Partner Orgnanization ID

oRCL_SFA_InventoryOrgID_l

Text

The inventory organization in SFA used for sales products.

Payment Terms

paymentTerms_l

Menu

Payment terms to apply to collect payment. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Receivables Payment Terms task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source.

Period

pricePeriod_l

Menu

The period of service purchased at this price.

Price (List)

listPrice_l

Currency

The list price of the item.

Price (Net)

netPrice_l

Currency

The price paid by the customer for the item.

Price Recurrence Frequency

priceRecurFrequency_l

Menu

The periodicity or frequency of this pricing. Derived from the pricePeriod_l.

Price Recurrence Frequency (Rollup)

priceRecurFrequencyRollup_l

Menu

The periodicity or frequency of this pricing or for the root model rolled up to include all child values.

Price Score

priceScore_l

Integer

The calculated price score for this transaction line, based on the line item's List and Net pricing.

Price Score List Based

_s_priceScoreListBased_l

Integer

List Based Method price score calculation for line.

Price Score Margin Based

_s_priceScoreMarginBased_l

Integer

Margin Based Method price score calculation for a line.

Price Score Simple Margin Based (List Price Basis)

_s_priceScoreSimpleMarginListPrice_l

Integer

Price score calculation using Simple Margin Based method and List Price as Basis attribute.

Price Score Simple Margin Based (Net Price Basis)

_s_priceScoreSimpleMarginNetPrice_l

Integer

Price score calculation using Simple Margin Based method and Net Price as Basis attribute.

Price Score Simple Margin Based (Unit Cost Basis)

_s_priceScoreSimpleMarginUnitCost_l

Integer

Price score calculation using Simple Margin Based method and Unit Cost as Basis attribute.

Price Score Weighting

_s_priceScoreWeighting_l

Float

Weighting attribute for price score calculation at the transaction level.

Price Type

priceType_l

Menu

Indicates whether the amount on this line is charged once or periodically.

Price Type (Rollup)

priceTypeRollup_l

Menu

Indicates whether the amount on this line is charged once or periodically. For Root model lines, this will represent a rollup of values for all child lines.

Price Within Policy

priceWithinPolicy_l

Boolean

Flag which indicates if line price is within requesting user's defined pricing limits

Recurring Revenue (Rollup)

recurRevRollup_l

Currency

Recurring revenue on this line or for the root model lines, the sum of recurring revenues for all the child lines.

Recurring Revenue (Summable)

recurringRevSummable_l

Currency

Recurring revenue net of all discounts for this line.

Renew Date

renewDate_l

Date

Renewal date of a subscription service.

Request Date

requestDate_l

Date

The date on which the user requests that fulfillment occur for this transaction line.

Request Ship Date

requestShipDate_l

Date

The requested ship date for the order line.

Resume Date

resumeDate_l

Date

Resuming date of a subscription service

Rollup Flag

rollupFlag_l

Boolean

Specifies a charge component as a rollup value or aggregate value for the element code of the charge component price.

Root Line

rootLine_l

Menu

Indicates whether the line is a root line. Root lines include only root model lines and standalone part lines.

Root Asset Key

rootAssetKey_l

Text

 

Sales Channel

salesChannel_l

Menu

 

Sequence Number

_sequence_number

Sequence Number Attribute

Sequence number for the subdocument.

Status

status_l

Menu

The status of this line.

Subscription Id

subscriptionId_l

Text

The unique identifier for the subscription. Used only for subscription billing-related transactions.

Subscription Line Id

subscriptionLineId_l

Text

The unique identifier for the subscription line. Used only for subscription billing-related transactions.

Suspend Date

suspendDate_l

Date

Suspension date of a subscription service

Transaction Internal ID

transactionID_l

Text

The parent transaction's internal ID.

Transaction Line ID

_transactionLine_id

Text

Unique identifier for this subdocument.

Unit Cost

unitCost_l

Currency

The unit cost of the item.

Unit of Measure

requestedUnitOfMeasure_l

Menu

The unit of measure of the item requested by the customer (e.g. "Each").

Usage Revenue (Rollup)

usageRevRollup_l

Currency

Usage revenue on this line or for the root model lines, the sum of usage revenues for all the child lines.

Usage Revenue (Summable)

usageRevSummable_l

Currency

Usage revenue net of all discounts for this line.

Win/Loss Status

winLossStatus_l

Menu

The determining status of whether the transaction line represents a won or a lost sale. This can be used in Deal Management analysis.

 

Related Topics

Related Topics Link IconSee Also