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 | |
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. |