Field Purpose, Usage, and Notes
This field is used to save the variables used in any transaction (order, estimate, service ticket, etc.) line item. The data within the field is saved in XML format.
Field Structure
The top element is . Within the Parameters, we can define any number of individual below it.
Each Parameter is associated to a variable that is used in the transaction item. Therefore, , and should be defined for each parameter. In addition to those three child elements there are other optional child elements that can be added to the parameter based on the variable it defines.The structure of ParamStr field is shown below.
Note: Any optional elements are shown in green.
Information on ParamStr field
- ClassTypeIDs Stores in Field:
- 14505 for Variable
- 300 for Unit
- 1601 for List(SelectionList)
- IDs Stores in Field:
- VariableID can be found in Variable table
- UnitID can be found in "pricing_units" wiki page
- ListID can be found in SelectionList table
- ListValue:
- Default List Index usually equals 0.
- PropertyBag:
- Miscellaneous data for things such as Layout data
- Overridden
- Binary value {0,1}
Source
Contributor: Soha, Cyrious
Date: 01.20.2015
Version: Control 5.5