Field Properties - Fields

 

Field Properties

Field Name

This field displays the name of the data field. This field can only be viewed.

 

Type

This field displays the data type of the data field. This field can only be viewed.

 

Description

This field displays the data field description. This field can only be viewed.

 

Field

Enter the source data field, or click the Lookup button to list all available fields.

 

Position

Enter the character position in which the data will be placed in the export ASCII file for the data field. This field is available only if ASCII is selected in the File Type field on the Configuration tab.

 

Mask

Enter the mask to use for numeric and date fields. For numeric fields, enter the mask using the ###,###.00- format where # indicates space-filled digits and 0 indicates zero-filled digits. Commas and periods can be specified in the appropriate positions. DB, CR, -, and + can be used to indicate positive or negative values. For date fields, click the Format Date button to activate the Date Format feature.

 

Sub String

Select this check box to export data into part of a field (for example, just the area code portion of a phone number). Clear this check box if you do not want to export data into part of a field.

 

Start/Length

Enter the portion of the field to export when the Sub String check box is selected.