Rice Lake TransAct 5.0 - Installation & Operation Manual - Manual (Page 165)

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