Line Item Tables
Estimated Reading Time: 1 Minutes
Name:
Name of each line item.
Type:
They can alpha or numeric
Size:
You can specify their display size
Formula:
Used for a basic formula to calculate the value for the column.
Line Item Table Formulas support the four major operations +, -, *, /, for addition, subtraction, multiplication, and division respectively. Formulas can contain multiple columns indicators, parentheses, and numeric constants. Formulas are calculated from left to right.
Format:
Formatting for decimal works the same way as numeric data elements. For more on Numeric Data Elements, review the Numeric section.
Validation:
Validation uses a regular expression to determine field validation. Some samples of field validation are found in the appendix
Validation Error:
If there is no match to the regular expression, an error message will be displayed.
The summary calculation will calculate a value based on the values in the specified column, and the selected operation.
All column calculations and summary calculations must be performed on Numeric data types.
When using a Line Item Calculation field in another calculation, the summary value is calculated and used. For example, you could calculate the total cost of an invoice, and then later multiply that value by a certain percentage to calculate sales tax.
Use the Add Column and Delete Columns buttons to modify the Line Item Table structure. Up to 26 columns can be added to a Line Item Table.
Line Item Tables will show as a table structure in the Web Interface in a separate window.