RICE LAKE Printer Kiosks
July 9, 2019
RICE LAKE Traffic Light Kits
July 9, 2019
RICE LAKE OnTrak™ Truck Scale Data Management
- Supports systems using Windows® 7 and up
- SQL Server® Express client/server database
- Comprehensive report filters
- User and administrator filters
- Backup and restore via included SQL Server Management Studio Express
- Unlimited charge/discount per product
- Ship or Receive mode for each transaction
- Exclusive database for: customer, hauler, truck, product, job, price/discount, tax, transaction
- Ethernet TCP/IP or RS-232 connectivity
- Supports VIRTUi/VIRTUi2® or Rice Lake weight indicators
- .CSV transaction file export
- Supports one or two scales
Optional Features
- Image capture with Ethernet camera TCP/IP (may require SQL server upgrade through Microsoft)
- Interface to non-Rice Lake weight indicators
- Custom reports
- Database configuration
- Field installation and training
- Factory phone support
OnTrak Specifications
Databases:
Windows® 7 and newer (x86 or x64 systems)
4 GB max database size when using included MS
SQL Server Express, unlimited with standard
version of MS SQL Server
Back up and restore via included SQL Server
Management Studio Express
Transaction Ticket: Reports:
Support for multiple printers
Supports all Rice Lake indicator interfaces
Supports VIRTUi/VIRTUi2 interface
Optional Drivers available for non-Rice Lake weight
indicators
User defined ticket formatting
Comprehensive report filters
Optional custom reports
Transaction Calculations: Software Support: Approvals:
File transfer via XML transaction; exported reports can be saved as PDF/XLS
Unlimited product prices and discounts
Tax calculations (does not integrate directly to financial software)
Database configuration, field installation and training available
Phone support packages available
Contact Rice Lake for further options
NTEP CC 05-107
OnTrak Database Features
Transaction Charge: Product: Product Charge:
Truck ID
Customer ID
Job
Product
Weigh In T and D
Weigh Out T and D
Gross Weight
Tare Weight
Net Weight
Tare Type
Units
Void
Ship Mode
Transaction #
Charge Name
Charge Rate
Charge Type
Product Name
Product ID
Price
Description
Minimum Charge
Product
Charge
Job
Job ID
Job Name
Job Closed
Customer #
Truck: Hauler: Weigh In:
Job #
Product #
Amount Ordered
Amount Delivered
Discount
Truck ID
Tare
Are Acquired
Tare Expiration
Tare Type
Name
Minimum Weight
Maximum Weight
Radio Tag ID
Customer ID
Job #
Product #
Hauler #
Name
Address
Phone
Fax
Contact Name
Truck ID
Customer ID
Job #
Product #
Weigh In TandD
Weight Value
Discount Schedule: Address: Customer: Hauler: Customer Charge:
Charge Name
Charge Rate
Charge Type
Name
Rate
Line 1
Line 2
Line 3
City
State
Postal Code
Country
Customer ID
Name
Bill to Address
Ship to Address
Phone
Fax
Contact Name
Name
Address
Phone
Fax
Contact Name
Inactive
Discount Level
Customer ID
Charge #
OnTrak Optional Features
- Image capture with Ethernet camera TCP/IP (may require SQL server upgrade through Microsoft)
- Interface to non-Rice Lake weight indicators
- Custom reports
- Database configuration
- Field installation and training
- Factory phone support
