Fairbanks InterAct FB3000 Series - Manual (Page 87)

50772 87 12/04 Issue # 2
Field Descriptions
Criteria or SQL Radio Buttons
For the database transaction table you have two choices for selecting records.
Criteria Select this option to display this screen of fixed selection
criteria. Select values for any or all fields. Only those
transaction records that meet all criteria entered will be
accepted from the import file or placed in the export file.
SQL
Select this option to display a screen where an SQL
statement can be entered to select the desired records
from the database table. This is the only option available
for all tables other than the transaction table. This screen
does not accept a full SQL statement for selecting
records, just the WHERE clause without the "WHERE".
For example, to select records from account "123" with
material code equal to "40" use the following statement:
TransAcct = "123" AND TransMatrl = "40".
From Ticket, To Ticket
Enter a ticket range by which transactions will be selected.
From Date, To Date
Enter a date range by which transactions will be selected.
List Sites
Site code is a unique one character field assigned to each PC running this application. Enter a list
of site codes (e.g. AFG for sites A, F and G) by which transactions will be selected.
Type, Customer, Hauler, Job, Material, User Defined Categories and Price
These are drop downs containing a list of codes that are attached to a transaction record. Select a
value from any of these lists to use in selecting transactions.