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. |