Truck table

<< Click to Display Table of Contents >>

Navigation:  Data Sources > Tables > Descriptions >

Truck table

Previous pageReturn to chapter overviewNext page

A column name shown in red indicates that a value is required for that column.

 

Column

Description

Truck ID

A unique sequence of letters and/or number that will be used to identify the Truck.

Driver

The name of the driver who normally operates the Truck.

Owner

The owner of the Truck.

Description

A description of the Truck - something like 'Blue Kenworth'.

Vehicle Type

This is typically used to identify the Trucks configuration — number of axles, number of trailers. If you are not interested in storing this data, use the default value of NS (not specified).

Tare weight

The empty weight of the Truck. Tare must be a value greater than or equal to zero.

Last tared

The date and time that the Tare weight was updated. This column is updated automatically.

Manual tare

An indication of whether the Tare weight was recorded manually or automatically. This column is updated automatically.

AGW

Allowable Gross Weight (AGW) is the amount of weight that a Truck can carry as determined by the physical characteristics of the Truck.

 

AGW must be a value greater than or equal to zero.

RGW

Registered Gross Weight is the maximum amount of weight a Truck has been licenced to carry.

 

RGW must be a value greater than or equal to zero.

Last Order

The last/current Item that was/will hauled by the Truck

Recall Order

A true/false value that indicates whether the information about a Order should be recalled automatically when the Truck is selected.

Last Item

The last/current Item that was/will hauled by the Truck. Last Item should identify an Item for the Order identified by the Last Order column for the Truck.

Recall Item

A true/false value that indicates whether the information about a Order should be recalled automatically when the Truck is selected.

Licence

The licence number of the Truck.

Expiry Date

The date that the Trucks licence expires.

Registration/V.I.N.

The registration number or vehicle identification number of the Truck.