Fields tab

The Fields tab is where you define properties for the fields being exported. The following table describes each field:

Field	Description
Name	The name of the field
Type	Type of the field can be either String, Date or Number.
Format	An optional mask for converting the format of the original field.
Length	The length of the field depends on the following field types: Number Total number of significant figures in a number. String Total length of string. Date Length of printed output of the string (for example, four is a length for a year).
Precision	Number of floating point digits for number-type fields.
Currency	Symbol used to represent currencies ($5,000.00 or €5.000,00 for example).
Decimal	A decimal point can be a period (.) as in 10,000.00 or it can be a comma (,) as in 5.000,00.
Group	A grouping can be a comma (,) as in 10,000.00 or it can be a period (.) as in 5.000,00.
Trim Type	The trimming method to apply to a string. Trimming only works when no field length is specified.
Null	If the value of the field is null, the specified string is inserted into the output text file.