Fields

External field name:

A field name in the external data source that is recognised by the SQL script.

Data type:

Select from Char, Integer, Double, Date, Logical or AutoInc.

Date format:

If the PayGlobal field is a date, the external data source stores the data in this format. If the separator is not “/ “, then the data is stored in another format.

Internal table name:

The PayGlobal table that is updated from the external data source.

Internal field name:

The field in the PayGlobal table that is updated from the external data source.

See also

External Validation