RX_TRUCKS
Field Name |
Description |
---|---|
REGION |
The region in which the truck is located. This field uses the REGION domain. |
TRUCK_TYPE |
The type of truck. |
RADIO1 |
The radio frequency at which the crew can be reached. |
RADIO2 |
An alternative radio frequency at which the crew can be reached. |
COMPANY |
The company to which the truck belongs. This field uses the COMPANY domain. |
STATUS |
The status of the truck. This field uses the STATUS domain. |
CREW_ID |
Indicates the crew to which the truck is assigned. This field acts as a foreign key to the RX_CREWS table. |
USER_CREATED |
The name of the user who created the record. This field is populated automatically by Responder. |
USER_UPDATED |
The name of the user who updated the record. This field is populated automatically by Responder. |
TRUCK_NUMBER |
This optional field holds company ID values (e.g., license plate numbers, inventory numbers). This string field holds up to 15 characters. |