Validation Properties
Show/Hide All
This field displays the name of the data field. This field can only be viewed.
This field displays the data type of the data field. This field can only be viewed.
Select a validation type.
Select File to validate that a record exists in another file that matches the data value. A file name and a key expression must be specified.
Select String to validate that the field contain one of the listed characters. The validation string field must contain the valid string characters without any separators (for example, if valid invoice types are IM, CM, and DM, the validation string must contain IMCMDM).
Select Uppercase to validate that the field contain uppercase characters and must be contained in the validation string field. If the validation string field is not supplied, the field must be uppercase.
Select Expression to execute a ProvideX expression to perform the validation. If the expression evaluates as true, the validation is passed; otherwise, validation fails.
Select Range to validate against a range of values. The field must contain a value within the range of values entered in the Starting and Ending fields.
Select List to validate against one or more lines of valid values. The import field must contain a value that matches one of the lines in the list.
Select Program to perform validation using a ProvideX program. This feature is provided for use by a qualified Master Developer.
Select this check box if no validation is to be performed when the data is blank. Clear this check box if validation is to be performed, regardless of whether the data is blank.
Enter the data dictionary against which to validate. Click the Lookup button to list available file names. This field is available only if File is selected in the Validation Type field.
Type a key expression. The key expression is used to validate for file-type validation.
Type the record type for which this validation is required. This field is available only if more than one record type is defined for the import file.
Type string characters without separators. This field is available only if String is selected in the Validation Type field.
For invoice types IM, CM, and DM, you would enter IMCMDM.
Type an expression. This field is available only if Expression is selected in the Validation Type field. Click the Tools button to access the Expression Builder window to build complex expressions.
Type a starting and ending value. The Starting and Ending fields are available only if Range is selected in the Validation Type field.
Type one or more lines of valid values. The import field must contain a value that matches one of the lines in this list.
Type a ProvideX program name to perform validation. This field is available only if Program is selected in the Validation Type field.
© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks