Default Values for Columns

See Also

You can define default values for columns. These default values are displayed in the corresponding window fields, and will be stored in the database if the end-user does not change them.

If you want the default value to be the current date, or the current date and time, you must specify one of the values:

$$CURRENTDATE$$

or

$$CURRENTDATETIME$$

A new date and time value is fetched from the server each time you refer to one of these functions. A different possibility is to use:

$$TRANSACTIONDATE$$

or

$$TRANSACTIONDATETIME$$

In this case, the current date and time are fetched from the server only once within a transaction. If you refer to one of these functions again within the same transaction, an identical date and time value is returned.

If you want the default value to be the user name of the current user, specify:

$$USER$$

You can specify default values at column level and at domain level. If both are specified, the default value at column level takes precedence.