2 database table, 1 built in truck database – Rice Lake 920i Single Kiosk Truck In/Out User Manual

Page 8

Advertising
background image

4

Single Kiosk Truck In/Out Software Operation Manual

4.2

Database Table

4.2.1

Built In Truck Database

Field

Type

Description

ID

String

Truck Id – 16 alphanumeric

Gross

Real

Gross Weight

Tare

Real

Tare Weight

Net

Real

Net Weight

DT

DateTime

Date and Time of Transaction

Table 4-2. Transactions (“Trans”) Database Table 1,000 Records

Field

Type

Description

ID

String

Alphanumeric truck identifier – 16 characters

Pri_Wgt

Real

Inbound weight in primary units

Sec_Wgt

Real

Inbound weight in secondary units (Currently Not Used)

Ter_Wgt

Real

Inbound weight in tertiary units (Currently Not Used)

TimeDate

DateTime

Time and date of inbound weighment (Currently Not Used)

Scale

Byte

Scale number (Currently Not Used)

Keyed

Byte

Keyed Tare (Currently Not Used)

Table 4-3. Truck (“Truck”) Database Table 1,000 Records

Advertising