Overview
CPQ uses Data Columns to define attributes in order to report, search or query transaction or transaction line data. The following tables list pre-defined Commerce Data Columns for 24D Standard Processes.
|
Element |
Document Level |
Attribute Name |
Attribute Variable Name |
Search Label |
Report Label |
|---|---|---|---|---|---|
|
Commerce Attribute |
Transaction |
Owner |
owner_t |
Sales Owner |
Sales Owner |
|
Commerce Attribute |
Transaction |
Created Date |
createdDate_t |
Created Date |
Created Date |
|
Commerce Attribute |
Transaction |
Transaction Number |
transactionID_t |
Transaction ID |
Transaction ID |
|
Commerce Attribute |
Transaction |
Customer Company Name |
_customer_t_company_name |
Customer Company Name |
Customer Company Name |
|
Commerce Attribute |
Transaction |
Last Updated |
lastUpdatedDate_t |
Last Updated |
Last Updated |
|
Commerce Attribute |
Transaction |
Transaction Name |
transactionName_t |
Transaction Name |
Transaction Name |
|
Commerce Attribute |
Transaction |
Status |
status_t |
Status |
Status |
|
Commerce Attribute |
Transaction |
Total Contract Value |
totalContractValue_t |
Total Contract Value |
Total Contract Value |
|
Commerce Attribute |
Transaction |
Annual Contract Value |
totalAnnualValue_t |
Annual contract Value |
Annual contract Value |
|
Commerce Attribute |
Transaction |
Total Discount |
totalOneTimeDiscount_t |
Total Discount |
Total Discount |
|
Commerce Attribute |
Transaction |
Total |
totalOneTimeListAmount_t |
Total (List) |
Total (List) |
|
Commerce Attribute |
Transaction |
Total |
totalOneTimeNetAmount_t |
Total (Net) |
Total (Net) |
|
Commerce Attribute |
Transaction |
Total |
totalMonthlyListAmount_t |
Total (List) Per Month |
Total (List) Per Month |
|
Commerce Attribute |
Transaction |
Total |
totalMonthlyNetAmount_t |
Total (Net) Per Month |
Total (Net) Per Month |
|
Commerce Attribute |
Transaction |
Total Discount Per Month |
totalMonthlyDiscount_t |
Total Discount Per Month |
Total Discount Per Month |
|
Commerce Attribute |
Transaction |
Last Priced |
lastPricedDate_t |
Last Priced |
Last Priced |
|
Commerce Attribute |
Transaction |
Price Within Policy |
priceWithinPolicy_t |
Price Within Policy |
Price Within Policy |
|
Commerce Attribute |
Transaction Line |
Status |
status_l |
Line Item Status |
Line Item Status |
|
Commerce Attribute |
Transaction Line |
Contracted Periods |
contractedPeriods_l |
Contracted Periods |
Contracted Periods |
|
Commerce Attribute |
Transaction Line |
Discount |
customDiscountValue_l |
Discount |
Discount |
|
Commerce Attribute |
Transaction Line |
Custom Discount Amount |
customDiscountAmount_l |
Custom Discount Amount |
Custom Discount Amount |
|
Commerce Attribute |
Transaction Line |
Discount Type |
customDiscountType_l |
Discount Type |
Discount Type |
|
Commerce Attribute |
Transaction Line |
Amount |
netAmount_l |
Amount (Net) |
Amount (Net) |
|
Commerce Attribute |
Transaction Line |
Price |
netPrice_l |
Price (Net) |
Price (Net) |
|
Commerce Attribute |
Transaction Line |
Price |
listPrice_l |
Price (List) |
Price (List) |
|
Commerce Attribute |
Transaction Line |
Amount |
listAmount_l |
Amount (List) |
Amount (List) |
|
Commerce Attribute |
Transaction Line |
Transaction Internal ID |
transactionID_l |
Transaction ID |
Transaction ID |
|
Commerce Attribute |
Transaction |
Version Number |
version_number_versionTransaction_t |
Version Number |
Version Number |
|
Commerce Attribute |
Transaction |
Version |
version_t |
Version |
Version |
|
Commerce Attribute |
Transaction Line |
Action Code |
oRCL_ABO_ActionCode_l |
Action Code |
Action Code |
|
Commerce Attribute |
Transaction |
Customer Id |
_customer_id |
First Customer ID |
First Customer ID |
|
Commerce Attribute |
Transaction Line |
Part Number |
_part_number |
Part Number |
Part Number |
|
Commerce Attribute |
Transaction Line |
Request Date |
requestDate_l |
Line Request Date |
Line Request Date |
|
Commerce Attribute |
Transaction Line |
Instance ID |
itemInstanceId_l |
Item Instance Id |
Item Instance Id |
|
Commerce Attribute |
Transaction Line |
Fulfillment Status |
fulfillmentStatus_l |
Fulfill Status |
Fulfill Status |
| Commerce Attribute | Transaction | Contact Party Number |
_s_contactPartyNumber_t |
Customer Party Number | Customer Party Number |
| Commerce Attribute | Transaction | Assigned To |
_s_assignedTo_t |
Assigned to | Assigned to |
| Commerce Attribute | Transaction | Customer Status |
_s_customerStatus_t |
Customer Quote Status | Customer Quote Status |
| Commerce Attribute | Transaction | Price Expiration Date |
priceExpirationDate_t |
Due Date | Due Date |
| Commerce Attribute | Transaction | Contact Name |
contactName_t |
Contact Name | Contact Name |
| Commerce Attribute | Transaction | Is Published |
_s_isPublished_t |
Is Quote Published | Is Quote Published |
| Commerce Attribute | Transaction | Source Of Transaction |
_s_transactionSource_t |
Source Of Transaction | Source Of Transaction |
| Commerce Attribute | Transaction | Host Company Full Name |
_s_hostCompanyFullName_t |
Host Company Full Name | Host Company Full Name |
See Also
