VALT (Col A)

        = mandatory in template or in PARAM (FORMS)

 = optional in Column A (REPORTS)                                                                                                                                        

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 column A and defined for each CVAL column. If a template contains several value types for different CVAL columns, then VALT must be defined in column A.

If spread groups are used in the template, then only one value type can be defined within one SPGROUP. However, different value types can be stated in different spread groups.

The VALT row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).