...
RTA Data | LoadMaster table.fieldname |
|---|---|
Company ID from vehicle’s facility (facility.div_lme_company_id) | trailer.company_id |
vehfile.vehfile | trailer.id |
“A” if "I" if facility is Inactive (facility.div_active_sw = “A”“I” if ) or Archived (facility.div_active_sw = “Z”archive_sw) or if the vehicle status code (vehcost.vhcst_status_code, vhstatcd.stat_system_status) is marked as inoperable | trailer.is_active |
trailer.empty | |
vehfile.inservice_date | trailer.inservice_date |
trailer.outservice_date | |
trailer.trailer_type | |
vehfile.vehicle_make | trailer.make |
vehfile.vehicle_model | trailer.model |
vehfile.year | trailer.model_year |
trailer.features | |
trailer.owner | |
trailer.trailer_group | |
Depends on syssize.nyseg_sw (SSM) Miscellaneous Parameter I #29 if “Alpha” then vehfile.gross_vol_weight if “Numeric” then vehfile.num_veh_gvw | trailer.weight |
vehfile.license_plate | trailer.license_no |
trailer.license_state | |
trailer.tag_expire_date | |
vehfile.serial_number | trailer.serial_number |
vehfile.purchase_date | trailer.purchase_date |
trailer.inspection_date | |
trailer.min_temp | |
trailer.max_temp | |
trailer.length_of | |
trailer.width | |
trailer.height | |
trailer.door_height | |
trailer.volume | |
trailer.floor_space | |
trailer.pallets |
...