Tractor object
Tractor properties and column mapping
To condense the information in this table, the Database Column Name uses the following abbreviations for database tables: t = tractorprofile All columns in the tractorprofile table are included. |
Property | Database Column | |||||
---|---|---|---|---|---|---|
Name |
Data Type (in C#) |
Name |
Data Type |
Modifiable |
Comments |
|
1 |
DataSourceID |
string |
N/A |
Not mapped |
||
2 |
ExpirationAssetID |
string |
t.trc_number |
int |
Read-only |
Returns trc_number |
3 |
ExpirationAssetType |
Read-only |
Returns AssetTypeEnum.TRC |
|||
4 |
Expirations |
List Expiration> |
Insert/Update |
Reference Expiration object in Expirations table |
||
5 |
IsDirty |
bool |
N/A |
Not mapped or used in service |
||
6 |
IsNew |
bool |
N/A |
Not mapped, set to false during save to update |
||
7 |
IsValid |
bool |
N/A |
Not mapped or used in service |
||
8 |
trc_aceid |
string |
t.trc_aceid |
varchar(15) |
Insert/Update |
|
9 |
trc_aceidtype |
string |
t.trc_aceidtype |
varchar(6) |
Insert/Update |
|
10 |
trc_actg_type |
string |
t.trc_actg_type |
char(1) |
Insert/Update |
|
11 |
trc_alert_date |
DateTime |
t.trc_alert_date |
datetime |
Insert/Update |
|
12 |
trc_altid |
string |
t.trc_altid |
varchar(25) |
Insert/Update |
|
13 |
trc_avl_city |
int |
t.trc_avl_city |
int |
Insert/Update |
|
14 |
trc_avl_cmp_id |
string |
t.trc_avl_cmp_id |
varchar(8) |
Insert/Update |
|
15 |
trc_avl_date |
DateTime |
t.trc_avl_date |
datetime |
Insert/Update |
|
16 |
trc_avl_lgh |
int |
t.trc_avl_lgh |
int |
Insert/Update |
|
17 |
trc_avl_status |
string |
t.trc_avl_status |
varchar(6) |
Insert/Update |
|
18 |
trc_axles |
short |
t.trc_axles |
smallint |
Insert/Update |
|
19 |
trc_axlgrp1_grosswgt |
double |
t.trc_axlgrp1_grosswgt |
float |
Insert/Update |
|
20 |
trc_axlgrp1_tarewgt |
double |
t.trc_axlgrp1_tarewgt |
float |
Insert/Update |
|
21 |
trc_axlgrp2_grosswgt |
double |
t.trc_axlgrp2_grosswgt |
float |
Insert/Update |
|
22 |
trc_axlgrp2_tarewgt |
double |
t.trc_axlgrp2_tarewgt |
float |
Insert/Update |
|
23 |
trc_bmpr_to_steer |
double |
t.trc_bmpr_to_steer |
float |
Insert/Update |
|
24 |
trc_bmpr_to_steer_uom |
string |
t.trc_bmpr_to_steer_uom |
varchar(6) |
Insert/Update |
|
25 |
trc_bprtobkcab |
int |
t.trc_bprtobkcab |
int |
Insert/Update |
|
26 |
trc_bprtobkcab_uom |
string |
t.trc_bprtobkcab_uom |
varchar(6) |
Insert/Update |
|
27 |
trc_branch |
string |
t.trc_branch |
varchar(12) |
Insert/Update |
|
28 |
trc_cabtoaxle |
int |
t.trc_cabtoaxle |
int |
Insert/Update |
|
29 |
trc_cabtoaxle_uom |
string |
t.trc_cabtoaxle_uom |
varchar(6) |
Insert/Update |
|
30 |
trc_carrier |
string |
t.trc_carrier |
varchar(8) |
Insert/Update |
|
31 |
trc_checkconflict |
string |
t.trc_checkconflict |
char(1) |
Insert/Update |
|
32 |
trc_commethod |
string |
t.trc_commethod |
varchar(6) |
Insert/Update |
|
33 |
trc_company |
string |
t.trc_company |
varchar(6) |
Insert/Update |
|
34 |
trc_createdate |
DateTime |
t.trc_createdate |
datetime |
Insert/Update |
|
35 |
trc_cur_mileage |
int |
t.trc_cur_mileage |
int |
Insert/Update |
|
36 |
trc_currenthub |
int |
t.trc_currenthub |
int |
Insert/Update |
|
37 |
trc_dateacquired |
DateTime |
t.trc_dateacquired |
datetime |
Insert/Update |
|
38 |
trc_division |
string |
t.trc_division |
varchar(6) |
Insert/Update |
|
39 |
trc_dotnumber |
string |
t.trc_dotnumber |
varchar(18) |
Insert/Update |
|
40 |
trc_drive1_to_drive2 |
double |
t.trc_drive1_to_drive2 |
float |
Insert/Update |
|
41 |
trc_drive1_to_drive2_uom |
string |
t.trc_drive1_to_drive2_uom |
varchar(6) |
Insert/Update |
|
42 |
trc_drive2_to_rear |
double |
t.trc_drive2_to_rear |
float |
Insert/Update |
|
43 |
trc_drive2_to_rear_uom |
string |
t.trc_drive2_to_rear_uom |
varchar(6) |
Insert/Update |
|
44 |
trc_driver |
string |
t.trc_driver |
varchar(8) |
Insert/Update |
|
45 |
trc_driver2 |
string |
t.trc_driver2 |
varchar(8) |
Insert/Update |
|
46 |
trc_dummy |
int |
t.trc_dummy |
int |
Insert/Update |
|
47 |
trc_enginehrs |
int |
t.trc_enginehrs |
int |
Insert/Update |
|
48 |
trc_enginemake |
string |
t.trc_enginemake |
varchar(10) |
Insert/Update |
|
49 |
trc_enginemodel |
string |
t.trc_enginemodel |
varchar(10) |
Insert/Update |
|
50 |
trc_engineserial |
string |
t.trc_engineserial |
varchar(20) |
Insert/Update |
|
51 |
trc_eta_skip |
string |
t.trc_eta_skip |
char(1) |
Insert/Update |
|
52 |
trc_exp1_date |
DateTime |
t.trc_exp1_date |
datetime |
Insert/Update |
|
53 |
trc_exp1_enddate |
DateTime |
t.trc_exp1_enddate |
datetime |
Read-only |
|
54 |
trc_exp2_date |
DateTime |
t.trc_exp2_date |
datetime |
Insert/Update |
|
55 |
trc_exp2_enddate |
DateTime |
t.trc_exp2_enddate |
datetime |
Read-only |
|
56 |
trc_fifthwheelht |
int |
t.trc_fifthwheelht |
int |
Insert/Update |
|
57 |
trc_fifthwheelht_uom |
string |
t.trc_fifthwheelht_uom |
varchar(6) |
Insert/Update |
|
58 |
trc_fifthwhltvl |
int |
t.trc_fifthwhltvl |
int |
Insert/Update |
|
59 |
trc_fifthwhltvl_uom |
string |
t.trc_fifthwhltvl_uom |
varchar(6) |
Insert/Update |
|
60 |
trc_fleet |
string |
t.trc_fleet |
varchar(6) |
Insert/Update |
|
61 |
trc_frontaxlspc |
int |
t.trc_frontaxlspc |
int |
Insert/Update |
|
62 |
trc_frontaxlspc_uom |
string |
t.trc_frontaxlspc_uom |
varchar(6) |
Insert/Update |
|
63 |
trc_gal_in_tank |
int |
t.trc_gal_in_tank |
int |
Insert/Update |
|
64 |
trc_gp_class |
string |
t.trc_gp_class |
varchar(15) |
Insert/Update |
|
65 |
trc_gps_date |
DateTime |
t.trc_gps_date |
datetime |
Insert/Update |
|
66 |
trc_gps_desc |
string |
t.trc_gps_desc |
varchar(255) |
Insert/Update |
|
67 |
trc_gps_latitude |
decimal |
t.trc_gps_latitude |
Decimal(10,2) |
Insert/Update |
Versions 2014.4 and prior use int as the data type. |
68 |
trc_gps_longitude |
decimal |
t.trc_gps_longitude |
Decimal(10,2) |
Insert/Update |
Versions 2014.4 and prior use int as the data type. |
69 |
trc_gps_odometer |
int |
t.trc_gps_odometer |
int |
Insert/Update |
|
70 |
trc_grosswgt |
int |
t.trc_grosswgt |
int |
Insert/Update |
|
71 |
trc_insurance_amt |
int |
t.trc_insurance_amt |
int |
Insert/Update |
|
72 |
trc_insurance_co |
string |
t.trc_insurance_co |
varchar(60) |
Insert/Update |
|
73 |
trc_insurance_policy |
string |
t.trc_insurance_policy |
varchar(50) |
Insert/Update |
|
74 |
trc_insurance_year |
string |
t.trc_insurance_year |
varchar(4) |
Insert/Update |
|
75 |
trc_last_calcdate |
DateTime |
t.trc_last_calcdate |
datetime |
Read-only |
|
76 |
trc_liccountry |
string |
t.trc_liccountry |
varchar(50) |
Insert/Update |
|
77 |
trc_licnum |
string |
t.trc_licnum |
varchar(12) |
Insert/Update |
|
78 |
trc_licstate |
string |
t.trc_licstate |
varchar(6) |
Insert/Update |
|
79 |
trc_lifetimemileage |
decimal |
t.trc_lifetimemileage |
decimal(12,1) |
Insert/Update |
|
80 |
trc_loading_class |
string |
t.trc_loading_class |
varchar(6) |
Insert/Update |
|
81 |
trc_make |
string |
t.trc_make |
varchar(6) |
Insert/Update |
|
82 |
trc_milestonext |
int |
t.trc_milestonext |
int |
Insert/Update |
|
83 |
trc_misc1 |
string |
t.trc_misc1 |
varchar(254) |
Insert/Update |
|
84 |
trc_misc2 |
string |
t.trc_misc2 |
varchar(254) |
Insert/Update |
|
85 |
trc_misc3 |
string |
t.trc_misc3 |
varchar(254) |
Insert/Update |
|
86 |
trc_misc4 |
string |
t.trc_misc4 |
varchar(254) |
Insert/Update |
|
87 |
trc_model |
string |
t.trc_model |
varchar(8) |
Insert/Update |
|
88 |
trc_mpg |
double |
t.trc_mpg |
float |
Insert/Update |
|
89 |
trc_mtcalltime |
DateTime |
t.trc_mtcalltime |
datetime |
Insert/Update |
|
90 |
trc_networks |
string |
t.trc_networks |
char(5) |
Insert/Update |
|
91 |
trc_newused |
int |
t.trc_newused |
int |
Insert/Update |
|
92 |
trc_next_city |
int |
t.trc_next_city |
Int |
Insert/Update |
|
93 |
trc_next_cmp_id |
string |
t.trc_next_cmp_id |
varchar(8) |
Insert/Update |
|
94 |
trc_next_event |
string |
t.trc_next_event |
char(6) |
Read-only |
|
95 |
trc_next_legnumber |
int |
t.trc_next_legnumber |
Int |
Read-only |
|
96 |
trc_next_region1 |
string |
t.trc_next_region1 |
varchar(6) |
Read-only |
|
97 |
trc_next_region2 |
string |
t.trc_next_region2 |
varchar(6) |
Read-only |
|
98 |
trc_next_region3 |
string |
t.trc_next_region3 |
varchar(6) |
Read-only |
|
99 |
trc_next_region4 |
string |
t.trc_next_region4 |
varchar(6) |
Read-only |
|
100 |
trc_next_state |
string |
t.trc_next_state |
varchar(6) |
Read-only |
|
101 |
trc_next_stoparrival |
DateTime |
t.trc_next_stoparrival |
datetime |
Read-only |
|
102 |
trc_next_stopnumber |
int |
t.trc_next_stopnumber |
int |
Read-only |
|
103 |
trc_nextdestpref |
string |
t.trc_nextdestpref |
varchar(64) |
Insert/Update |
|
104 |
trc_nextmainthub |
int |
t.trc_nextmainthub |
int |
Insert/Update |
|
105 |
trc_note_date |
DateTime |
t.trc_note_date |
Datetime |
Insert/Update |
|
106 |
trc_number |
string |
t.trc_number |
varchar(8) |
Insert |
Required for update |
107 |
trc_opercostpermi |
double |
t.trc_opercostpermi |
float |
Insert/Update |
|
108 |
trc_origcost |
double |
t.trc_origcost |
float |
Insert/Update |
|
109 |
trc_origmileage |
int |
t.trc_origmileage |
Int |
Insert/Update |
|
110 |
trc_owner |
string |
t.trc_owner |
varchar(12) |
Insert/Update |
|
111 |
trc_phone |
string |
t.trc_phone |
char(13) |
Insert/Update |
|
112 |
trc_pln_city |
int |
t.trc_pln_city |
int |
Insert/Update |
|
113 |
trc_pln_cmp_id |
string |
t.trc_pln_cmp_id |
varchar(8) |
Insert/Update |
|
114 |
trc_pln_date |
DateTime |
t.trc_pln_date |
datetime |
Insert/Update |
|
115 |
trc_pln_lgh |
int |
t.trc_pln_lgh |
int |
Insert/Update |
|
116 |
trc_prior_city |
int |
t.trc_prior_city |
int |
Read-only |
|
117 |
trc_prior_cmp_id |
string |
t.trc_prior_cmp_id |
varchar(8) |
Read-only |
|
118 |
trc_prior_event |
string |
t.trc_prior_event |
char(6) |
Insert/Update |
|
119 |
trc_prior_region1 |
string |
t.trc_prior_region1 |
varchar(6) |
Insert/Update |
|
120 |
trc_prior_region2 |
string |
t.trc_prior_region2 |
varchar(6) |
Insert/Update |
|
121 |
trc_prior_region3 |
string |
t.trc_prior_region3 |
varchar(6) |
Insert/Update |
|
122 |
trc_prior_region4 |
string |
t.trc_prior_region4 |
varchar(6) |
Insert/Update |
|
123 |
trc_prior_state |
string |
t.trc_prior_state |
varchar(6) |
Read-only |
|
124 |
trc_rearaxlspc |
int |
t.trc_rearaxlspc |
int |
Insert/Update |
|
125 |
trc_rearaxlspc_uom |
string |
t.trc_rearaxlspc_uom |
varchar(6) |
Insert/Update |
|
126 |
trc_require_drvtrl |
string |
t.trc_require_drvtrl |
char(1) |
Read-only |
|
127 |
trc_retiredate |
DateTime |
t.trc_retiredate |
datetime |
Insert/Update |
|
128 |
trc_serial |
string |
t.trc_serial |
varchar(20) |
Insert/Update |
|
129 |
trc_startdate |
DateTime |
t.trc_startdate |
datetime |
Insert/Update |
|
130 |
trc_status |
string |
t.trc_status |
varchar(6) |
Insert/Update |
|
131 |
trc_steer_to_drive1 |
double |
t.trc_steer_to_drive1 |
float |
Insert/Update |
|
132 |
trc_steer_to_drive1_uom |
string |
t.trc_steer_to_drive1_uom |
varchar(6) |
Insert/Update |
|
133 |
trc_tank_capacity |
int |
t.trc_tank_capacity |
int |
Insert/Update |
|
134 |
trc_tareweight |
double |
t.trc_tareweight |
float |
Insert/Update |
|
135 |
trc_tareweight_uom |
string |
t.trc_tareweight_uom |
varchar(6) |
Insert/Update |
|
136 |
trc_terminal |
string |
t.trc_terminal |
varchar(6) |
Insert/Update |
|
137 |
trc_thirdparty |
string |
t.trc_thirdparty |
varchar(12) |
Insert/Update |
|
138 |
trc_trailer1 |
string |
t.trc_trailer1 |
varchar(13) |
Insert/Update |
|
139 |
trc_trailer2 |
string |
t.trc_trailer1 |
varchar(13) |
Insert/Update |
|
140 |
trc_transponder |
string |
t.trc_transponder |
varchar(20) |
Insert/Update |
|
141 |
trc_ttltarewt |
int |
t.ttltarewr |
int |
Insert/Update |
|
142 |
trc_ttltarewt_uom |
string |
t.ttltarewt_uom |
varchar(6) |
Insert/Update |
|
143 |
trc_turndown |
DateTime |
t.trc_turndown |
datetime |
Insert/Update |
|
144 |
trc_type1 |
string |
t.trc_type1 |
varchar(6) |
Insert/Update |
|
145 |
trc_type2 |
string |
t.trc_type2 |
varchar(6) |
Insert/Update |
|
146 |
trc_type3 |
string |
t.trc_type3 |
varchar(6) |
Insert/Update |
|
147 |
trc_type4 |
string |
t.trc_type4 |
varchar(6) |
Insert/Update |
|
148 |
trc_updatedby |
string |
t.trc_updatedby |
varchar(256) |
Insert/Update |
|
149 |
trc_updatedon |
DateTime |
t.trc_updatedon |
datetime |
Insert/Update |
|
150 |
trc_usegeofencing |
string |
t.trc_usegeofencing |
char(1) |
Insert/Update |
|
151 |
trc_warrantydays |
short |
t.trc_warrantydays |
int |
Insert/Update |
|
152 |
trc_whltobase |
int |
t.trc_whltobase |
int |
Insert/Update |
|
153 |
trc_whltobase_uom |
string |
t.trc_whltobase_uom |
varchar(6) |
Insert/Update |
|
154 |
trc_year |
int |
t.trc_year |
int |
Insert/Update |
|
155 |
UpdateableProperties |
N/A |
Not mapped |
Tractor methods
The Return Value for all methods is Tractor.ReturnObject.
Internal
Parameters | ||||
---|---|---|---|---|
Method Name |
Name |
Data type (in C#) |
Tractor.ReturnObject. |
Description |
N/A |
0 = successful 1000 = errors occurred |
Creates a new Tractor object |
||
total |
int |
0 = successful 1000 = errors occurred |
Creates the specified number of new Tractor objects |
|
criteria |
0 = successful 100 = no records found 1000 = errors occurred |
Returns all Tractor objects that meet the specified criteria |
||
tractors |
List<Tractor> |
0 = successful 100 = validation errors occurred and updates prevented 500 = update proceeded with warnings 1000 = error occurred and updates prevented |
Saves the provided Tractor objects and updates the database if requested, then returns the saved objects if the save was successful |
|
updateDB |
bool |
External
Parameters | ||||
---|---|---|---|---|
Method Name |
Name |
Data type (in C#) |
Tractor.ReturnObject. |
Description |
NewTractor |
tokenValue |
string |
0 = successful 1000 = errors occurred |
Creates a new Tractor object |
NewTractors |
tokenValue |
string |
0 = successful 1000 = errors occurred |
Creates the specified number of new Tractor objects |
total |
int |
|||
RetrieveTractor |
tokenValue |
string |
0 = successful 100 = no records found 1000 = errors occurred |
Returns all Tractor objects that meet the specified criteria |
criteria |
||||
SaveTractor |
tokenValue |
string |
0 = successful 100 = validation errors occurred and updates prevented 500 = update proceeded with warnings 1000 = error occurred and updates prevented |
Saves the provided Tractor objects and updates the database if requested, then returns the saved objects if the save was successful |
tractors |
List<Tractor> |
|||
updateDB |
bool |
Tractor.ReturnObject
Property Name | Data Type (in C#) | Comments | |
---|---|---|---|
1 |
ErrorMessages |
List<string> |
|
2 |
ErrorObjectIndexList |
List<int> |
|
3 |
Exceptions |
List<Exception> |
|
4 |
ReferenceObjects |
List<Tractor> |
|
5 |
ReturnCode |
int |
|
6 |
TraceMessages |
List<string> |
|
7 |
WarningMessages |
List<string> |
TractorUpdateInfo object
-
Data types (in C#) for all properties are bool.
-
Set the property to
true
to update the corresponding Tractor property.
Property Name | |
---|---|
1 |
Expirations |
2 |
trc_aceid |
3 |
trc_aceidtype |
4 |
trc_actg_type |
5 |
trc_alert_date |
6 |
trc_altid |
7 |
trc_avl_city |
8 |
trc_avl_cmp_id |
9 |
trc_avl_date |
10 |
trc_avl_lgh |
11 |
trc_avl_status |
12 |
trc_axles |
13 |
trc_axlgrp1_grosswgt |
14 |
trc_axlgrp1_tarewgt |
15 |
trc_axlgrp2_grosswgt |
16 |
trc_axlgrp2_tarewgt |
17 |
trc_bmpr_to_steer |
18 |
trc_bmpr_to_steer_uom |
19 |
trc_bprtobkcab |
20 |
trc_bprtobkcab_uom |
21 |
trc_branch |
22 |
trc_cabtoaxle |
23 |
trc_cabtoaxle_uom |
24 |
trc_carrier |
25 |
trc_checkconflict |
26 |
trc_commethod |
27 |
trc_company |
28 |
trc_createdate |
29 |
trc_cur_mileage |
30 |
trc_currenthub |
31 |
trc_dateacquired |
32 |
trc_division |
33 |
trc_dotnumber |
34 |
trc_drive1_to_drive2 |
35 |
trc_drive1_to_drive2_uom |
36 |
trc_drive2_to_rear |
37 |
trc_drive2_to_rear_uom |
38 |
trc_driver |
39 |
trc_driver2 |
40 |
trc_dummy |
41 |
trc_enginehrs |
42 |
trc_enginemake |
43 |
trc_enginemodel |
44 |
trc_engineserial |
45 |
trc_eta_skip |
46 |
trc_exp1_date |
47 |
trc_exp2_date |
48 |
trc_fifthwheelht |
49 |
trc_fifthwheelht_uom |
50 |
trc_fifthwhltvl |
51 |
trc_fifthwhltvl_uom |
52 |
trc_fleet |
53 |
trc_frontaxlspc |
54 |
trc_frontaxlspc_uom |
55 |
trc_gal_in_tank |
56 |
trc_gp_class |
57 |
trc_gps_date |
58 |
trc_gps_desc |
59 |
trc_gps_latitude |
60 |
trc_gps_longitude |
61 |
trc_gps_odometer |
62 |
trc_grosswgt |
63 |
trc_insurance_amt |
64 |
trc_insurance_co |
65 |
trc_insurance_policy |
66 |
trc_insurance_year |
67 |
trc_liccountry |
68 |
trc_licnum |
69 |
trc_licstate |
70 |
trc_lifetimemileage |
71 |
trc_loading_class |
72 |
trc_make |
73 |
trc_milestonext |
74 |
trc_misc1 |
75 |
trc_misc2 |
76 |
trc_misc3 |
77 |
trc_misc4 |
78 |
trc_model |
79 |
trc_mpg |
80 |
trc_mtcalltime |
81 |
trc_networks |
82 |
trc_newused |
83 |
trc_nextdestpref |
84 |
trc_nextmainthub |
85 |
trc_note_date |
86 |
trc_number |
87 |
trc_opercostpermi |
88 |
trc_origcost |
89 |
trc_origmileage |
90 |
trc_owner |
91 |
trc_phone |
92 |
trc_pln_city |
93 |
trc_pln_cmp_id |
94 |
trc_pln_date |
95 |
trc_pln_lgh |
96 |
trc_prior_event |
97 |
trc_prior_region1 |
98 |
trc_prior_region2 |
99 |
trc_prior_region3 |
100 |
trc_prior_region4 |
101 |
trc_rearaxlspc |
102 |
trc_rearaxlspc_uom |
103 |
trc_retiredate |
104 |
trc_serial |
105 |
trc_startdate |
106 |
trc_status |
107 |
trc_steer_to_drive1 |
108 |
trc_steer_to_drive1_uom |
109 |
trc_tank_capacity |
110 |
trc_tareweight |
111 |
trc_tareweight_uom |
112 |
trc_terminal |
113 |
trc_thirdparty |
114 |
trc_trailer1 |
115 |
trc_trailer2 |
116 |
trc_transponder |
117 |
trc_ttltarewt |
118 |
trc_ttltarewt_uom |
119 |
trc_turndown |
120 |
trc_type1 |
121 |
trc_type2 |
122 |
trc_type3 |
123 |
trc_type4 |
124 |
trc_updatedby |
125 |
trc_updatedon |
126 |
trc_usegeofencing |
127 |
trc_warrantydays |
128 |
trc_whltobase |
129 |
trc_whltobase_uom |
130 |
trc_year |
Tractor Criteria object
To condense the information in the table, the Database Column uses the following abbreviations for database tables: t = tractorprofile |
Name | Database Column | Data Type (in C#) | Comments | |
---|---|---|---|---|
1 |
trc_actg_type |
t.trc_actg_type |
string |
|
2 |
trc_altid |
t.trc_altid |
string |
|
3 |
trc_avl_city |
t.trc_avl_city |
int? |
|
4 |
trc_avl_cmp_id |
t.trc_avl_cmp_id |
string |
|
5 |
trc_avl_date |
t.trc_avl_date |
DateTime? |
|
6 |
trc_avl_status |
t.trc_avl_status |
string |
|
7 |
trc_branch |
t.trc_branch |
string |
|
8 |
trc_company |
t.trc_company |
string |
|
9 |
trc_division |
t.trc_division |
string |
|
10 |
trc_fleet |
t.trc_fleet |
string |
|
11 |
trc_next_region1 |
t.trc_next_region1 |
string |
|
12 |
trc_next_region2 |
t.trc_next_region2 |
string |
|
13 |
trc_next_region3 |
t.trc_next_region3 |
string |
|
14 |
trc_next_region4 |
t.trc_next_region4 |
string |
|
15 |
trc_next_state |
t.trc_next_state |
string |
|
16 |
trc_number |
t.trc_number |
string |
|
17 |
trc_owner |
t.trc_owner |
string |
|
18 |
trc_pln_city |
t.trc_pln_city |
int? |
|
19 |
trc_pln_cmp_id |
t.trc_pln_cmp_id |
string |
|
20 |
trc_pln_date |
t.trc_pln_date |
DateTime? |
|
21 |
trc_pln_lgh |
t.trc_pln_lgh |
int? |
|
22 |
trc_status |
t.trc_status |
string |
|
23 |
trc_terminal |
t.trc_terminal |
string |
|
24 |
trc_type1 |
t.trc_type1 |
string |
|
25 |
trc_type2 |
t.trc_type2 |
string |
|
26 |
trc_type3 |
t.trc_type3 |
string |
|
27 |
trc_type4 |
t.trc_type4 |
string |
|
28 |
trc_updatedby |
t.trc_updatedby |
string |