VALT (Row 1)
=mandatory in template or in PARAM (FORMS)
=optional in row 1 (REPORTS)
Parameter |
Mandatory/Optional |
Value (example) |
Occurrence in row 1 |
Comment |
|
|---|---|---|---|---|---|
FORMS |
REPORT |
||||
VALT |
AMOUNT |
1 |
In FORM templates, a value type must be defined in the PARAM sheet or in the template (in column A or row 1). |
||
VALT is a FORM specific parameter, which is mandatory either in column A, row 1 or in PARAM. When updating values in the database, the data rows need to be tagged to a specific value type, in order to keep the updated data cells separated and not risk that already existing data would be updated with incorrect data. Value types can, for example be AMOUNT, QUANTITY, or TIME.
The parameter can also be used in REPORTS if data from the Bizview data view (in which FORM data is updated) is used in the report. Then one specific value type maybe need to be specified in order to get the correct numbers in the report, however that is only the case if data is registered in several different value types.
Caution: VALT can only be defined in ONE place, either in column A (for each CVAL column), in row 1 (for each DATA row) or in PARAM.
Template Worksheet
If a template only contains one value type, then it is best to state VALT once in the PARAM sheet. However, VALT can also be stated in row 1 and defined for each DATA row. If a template contains several value types for different DATA rows, then VALT must be defined in row 1.