Default Attribute Values

A default attribute value takes the following values:

Default Value—the attribute value is a constant specified in the table and this value is saved in the database.
NOT NULL – the attribute value cannot be empty otherwise the system displays an error (i.e. there must be at least one character between two separators); the specific Not Null value is saved in the database.
NULL – the attribute value can be empty whereas NULL is saved in the database (i.e. no character needs to be specified between two separators).

An attribute type takes the following values:

Date – the system carries out a check of the YYYYMMDD date format; if the check uncovers a problem, the "Incorrect Date Format" error message is displayed.
Money – the system carries out a check of the finance format:
- the value is specified in hellers without a decimal separator.
- the first character CAN be a sign.
- the other characters are digits (if a number starts with zeros, all zeros from the left are ignored during conversion into the numerical value).

Note

If the conditions are not adhered to, the "Incorrect Currency Format" error message is displayed.

Text – any alphanumeric character except for an attribute separator is permitted. If the string length is longer than the system expected (the Maximum Length column), the string is cropped from the right.

For example, the MC value in the batch is "0123456789ABCDEFGHIJabcd" but the system expects the maximum length of 20 and so the MC value will be shortened to the string "0123456789ABCDEFGHIJ" , i.e twenty characters.