Fairbanks InterAct FB3000 Series - Manual (Page 91)

50772 91 12/04 Issue # 2
This is a drop down containing a list of all tables in the database. It is initially set to the default
table specified in the Field Editor Main screen. However, you are not limited to exporting fields
from the default table only. Fields from any table related to the default table can also be exported.
For example, you may wish to include the account name in a transaction table export. Account
name is not in the Transaction table but needs to be retrieved from the Account table. Select
Account table from this list which will then enable you to include any account field in the export.
Field List
This list contains the fields that are currently being imported or exported. Selecting any row will
enable a drop down containing all fields for the selected table (Fields From). To add a new field to
the list, select the row marked with an asterisk (*) and choose a field.
Up Button
Click this button to move the currently selected field one position up in the list.
Down Button
Click this button to move the currently selected field on position down in the list.
Delete Button
Click this button to delete the currently selected field from the list.
Table / Field
These controls display the table and field name for the currently selected field in the list.
Fixed Width
Enter a field width. Data in the import/export text file will always occupy this many positions.
Calculation
Simple calculations can be performed on the field before it is imported or exported. The
calculation consists of a operator followed by a constant. Valid operators are decrement (--),
multiplication (*) and division (/).
For example, all weights in the Transaction table are stored in pounds. To convert the weight to
tons before exporting, enter "/2000" in the calculation field.
Value True, Value False, Boolean Value
At times you may need to export values based on a simple compare condition. If the condition is
true, export one value. If it is false, export another value.
For example, if the tax code stored with a transaction is "Exempt" then export one (1), otherwise
export zero (0). This conversion can be performed as follows:
Boolean Value Enter the compare value. In this example "Exempt".
True Value
Enter the value you wish to export if the tax code field
equals "Exempt". In this example, one (1). The value