Transaction Manager: Line-level system fields
Learn about the Transaction Manager fields that provide information about a product, including price, product details, and order information.
The fields available in Transaction Manager are categorized into two levels in the user interface (UI):
- Transaction-level fields: Also known as header-level fields, these fields provide general information about the transaction, such as the quote number, opportunity details, and account information. For more information about transaction-level fields, see Transaction Manager: Transaction-level system fields.
- Transaction line-level fields: Also referred to as line-level fields, these fields capture specific information about the products associated with the transaction lines, including price, product details, and order information.
System-provided fields in Transaction Manager
By default, Transaction Manager offers a set of system-provided fields that assist administrators in transaction processing.
This article focuses on transaction-line-level fields that are predefined by the system.
- System-generated fields at the line level use the prefix “txn.line” followed by the actual field name.
- Custom line-level fields created by users are prefixed with “txn.line.custom” followed by the desired field name.
List of system-provided line-level fields
The following table outlines the system-provided fields at the transaction line level.
Columns:
- Variable name: The system-defined name of the field as configured in the environment
- Description: A brief overview of the purpose and use case of the system field
- Modifiable by: Indicates who can edit the field configurations:
- System: Only the System Administrator can modify the field
- User: Any authorized end user with the appropriate permissions can update the field configurations
- Default value: The initial value assigned to the system field, specifying what can be set as the default during configuration
| Variable name | Description | Modifiable by | Default value |
|---|---|---|---|
| txn.line.id | UUID for the transaction line - must be unique across sectors and regions for any one tenant; may not be unique across tenants | System |
<Generated > Auto-generated by the system |
| txn.line.parent.id | ID of the parent line | User |
<Empty> Expected to be passed by user |
| txn.line.isProduct | Boolean field indicating whether the product to be added is available in the catalog | System | FALSE |
| txn.line.product.id | Product ID of the product to be added | System |
<Generated> Auto-generated by the system Stage setting “Refresh Product Data” refreshes data if enabled |
| txn.line.product.name | Name of the product to be added | System |
<Generated> Auto-generated by the system Stage setting “Refresh Product Data” refreshes data if enabled |
| txn.line.product.externalId | External ID of the product to be added (defined in the CPQ Admin utilities) | System |
<Generated> Auto-generated by the system Stage setting “Refresh Product Data” refreshes data if enabled |
| txn.line.product.partnerId | Partner ID of the product to be added (defined in the CPQ Admin utilities) | System |
<Generated> Auto-generated by the system Stage setting “Refresh Product Data” refreshes data if enabled |
| txn.line.product.productCode | Product code of the product to be added (defined in the CPQ Admin utilities) | System |
<Generated> Auto-generated by the system Stage setting “Refresh Product Data” refreshes data if Enabled |
| txn.line.product.description | Description of the product to be added | System |
<Generated> Auto-generated by the system Stage setting “Refresh Product Data” refreshes data if enabled |
| txn.line.created | Timestamp indicating when a transaction line was added | System |
<Generated> Auto-generated by the system. |
| txn.line.createdBy | Name of the user who added the transaction line | System |
<Generated> Auto-generated by the system |
| txn.line.modified | Timestamp indicating when a transaction line was last modified | System |
<Generated> Auto-generated by the system |
| txn.line.modifiedBy | Name of the user who last modified the transaction line | System |
<Generated> Auto-generated by the system |
| txn.line.isConfigured | Boolean indicating whether the line is a configured line (a simple product added) or a top-level configured line (top line level of a configuration consisting of parent and child products) | System |
FALSE Auto-set to true if the configuration is added |
| txn.line.configuration.id | UUID of the configuration | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.solutionId | UUID of the solution the configuration is a part of | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.id | Configuration item ID of the items in BOM once a configuration is added | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.price | Configuration item price of the items in BOM once a configuration is added | System |
0 Remains unused if there is no configuration |
| txn.line.configuration.item.quantity | Configuration item quantity of the items in BOM once a configuration is added | System |
0 Remains unused if there is no configuration |
| txn.line.configuration.item.type | Configuration item type of the items in BOM once a configuration is added | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.notes | Configuration item notes of the items in BOM once a configuration is added | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.description | Description mentioned when the configuration item was created | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.parentProduct | Transaction line configuration item ID of the parent product for the configuration item added in BOM | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.uom | The unit of measure used to define the configuration item when it was created | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.bomType | BOM type defined for a configuration item when it was created | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.extPrice | Configuration quantity price (defined in the extPrice column of the configuration item) | System |
0 This field will not exist if there is no configuration |
| txn.line.configuration.item.orderNumber | Order number of the configuration item when it was added | System |
<Empty> Remains unused if there is no configuration |
| txn.line.configuration.item.rollUpPrice | Value defined in the rollupPrice column for the configuration item when it was created | System |
0 Remains unused if there is no configuration |
| txn.line.configuration.item.uniqueIdentifier | Unique identifier used to define a configuration item (useful for reconfiguration) | System |
<Empty> User generated, but cannot be modified once created |
| txn.line.configuration.item.key | Fallback to match configuration items on reconfigure when the unique identifier can’t be used | System |
<Empty> Generated by system when the lines are added |
| txn.line.isVisible | Determines whetherto show the entry on the line item grid | User |
TRUE To be selected by the user |
| txn.line.selected | Used in rule conditions to perform actions on selected lines - set to TRUE when a line-level event runs | System |
False Field is set to TRUE when an event runs - affects all lines affected by the event For example, if you delete a top level line, this field is set to TRUE for all child lines that are deleted when the event runs. After all actions are complete, the value is set back to False |
| txn.line.isReorderable | Indicates whether a line can be reordered | User | TRUE |
| txn.line.configuration.status | Indicates configuration validation status - supports validate configured items on event setting | System |
<Empty> Generated by the system when lines are added |
| txn.line.configuration.validatedAt | Indicates date of last configuration validation. Supports validation of configured Items on event setting | System |
<Empty> Generated by the system when lines are added |
| txn.line.isNew | Indicates whether a line is new (true) or existing (false) | System |
<Empty> Generated by the system when lines are added Value is TRUE during the operation of the event that creates the line. |