Trailer object

First available in SystemsLink: 2014.2

Used by External SystemsLink for TMWSuite.

Methods

The Return Value for all methods is Trailer.ReturnObject.

Method Name	Parameters		Trailer.ReturnObject. ReturnCode	Description
	Name	Data type (in C#)
NewTrailer	N/A		0 = successful 1000 = errors occurred	Creates a new Trailer object in memory
NewTrailers	total	int	0 = successful 1000 = errors occurred	Creates the specified number of new Trailer objects in memory
RetrieveTrailer	criteria	Trailer.Criteria	0 = successful 100 = no records found 1000 = errors occurred	Returns all Trailer objects that meet the specified criteria
SaveTrailer	trailers	List<Trailer>	0 = successful 100 = validation errors occurred and updates prevented 500 = update proceeded with warnings 1000 = error occurred and updates prevented	Saves the provided Trailer objects and updates the database if requested, then returns the saved objects if the save was successful
	updateDB	bool

Method Name

Parameters

Trailer.ReturnObject.
ReturnCode

Description

Name

Data type (in C#)

NewTrailer

N/A

0 = successful

1000 = errors occurred

Creates a new Trailer object in memory

NewTrailers

total

int

0 = successful

1000 = errors occurred

Creates the specified number of new Trailer objects in memory

RetrieveTrailer

criteria

Trailer.Criteria

0 = successful

100 = no records found

1000 = errors occurred

Returns all Trailer objects that meet the specified criteria

SaveTrailer

trailers

List<Trailer>

0 = successful

100 = validation errors occurred and updates prevented

500 = update proceeded with warnings

1000 = error occurred and updates prevented

Saves the provided Trailer objects and updates the database if requested, then returns the saved objects if the save was successful

updateDB

bool

Properties and column mapping

To condense the information in this table, the Database Column Name uses the following abbreviations for database tables:

t = trailerrprofile

All columns in the trailerprofile table are included.

	Property	Database Column	Modifiable	Comments
	Name	Data Type (in C#)	Name	Data Type
1	cmp_id	string	t.cmp_id	varchar(8)	Insert/Update
2	cty_code	int	t.cty_code	int	Insert/Update
3	DataSourceID	string			N/A	Not mapped
4	ExpirationAssetID	string			Read only
5	ExpirationAssetType	AssetTypeEnum			Read only
6	Expirations	List <Expiration>			Insert/Update	Reference Expiration object from Expiration table
7	IsDirty	bool			N/A	Not mapped or used in service
8	IsNew	bool			N/A	Not mapped, set to false during save to update
9	IsValid	bool			N/A	Not mapped or used in service
10	timestamp	Byte[]	t.timestamp	timestamp	Insert/Update
11	TrailerImage	Byte[]			Insert/Update	Calculated from trl_bmp_pathname property
12	trl_accessorylist	string	t.trl_accessorylist	varchar(254)	Insert/Update
13	trl_aceid	string	t.trl_aceid	varchar(10)	Insert/Update
14	trl_aceidtype	string	t.trl_aceidtype	varchar(6)	Insert/Update
15	trl_actg_type	string	t.trl_actg_type	char(1)	Insert/Update
16	trl_avail_city	int	t.trl_avail_city	int	Insert/Update
17	trl_avail_cmp_id	string	t.trl_avail_cmp_id	varchar(8)	Insert/Update
18	trl_avail_date	DateTime	t.trl_avail_date	datetime	Insert/Update
19	trl_axle1_to_axle2	double	t.trl_axle1_to_axle2	float	Insert/Update
20	trl_axle1_to_axle2_uom	string	t.trl_axle1_to_axle2_uom	varchar(6)	Insert/Update
21	trl_axle2_to_axle3	double	t.trl_axle2_to_axle3	float	Insert/Update
22	trl_axle2_to_axle3_uom	string	t.trl_axle2_to_axle3_uom	varchar(6)	Insert/Update
23	trl_axle3_to_axle4	double	t.trl_axle3_to_axle4	float	Insert/Update
24	trl_axle3_to_axle4_uom	string	t.trl_axle3_to_axle4_uom	varchar(6)	Insert/Update
25	trl_axle4_to_axle5	double	t.trl_axle4_to_axle5	float	Insert/Update
26	trl_axle4_to_axle5_uom	string	t.trl_axle4_to_axle5_uom	varchar(6)	Insert/Update
27	trl_axles	short	t.trl_axles	smallint	Insert/Update
28	trl_axlgrp1_grosswgt	double	t.trl_axlgrp1_grosswgt	float	Insert/Update
29	trl_axlgrp1_tarewgt	double	t.trl_axlgrp1_tarewgt	float	Insert/Update
30	trl_axlgrp2_grosswgt	double	t.trl_axlgrp2_grosswgt	float	Insert/Update
31	trl_axlgrp2_tarewgt	double	t.trl_axlgrp2_tarewgt	float	Insert/Update
32	trl_billto_parent	string	t.trl_billto_parent	varchar(8)	Insert/Update
33	trl_bmp_pathname	string	t.trl_bmp_pathname	varchar(255)	Insert/Update
34	trl_booked_revtype1	string	t.trl_booked_revtype1	t.trl_booked_revtype1	Insert/Update
35	trl_branch	string	t.trl_branch	varchar(12)	Insert/Update
36	trl_bulkhead_comprt1_thick	double	t.trl_bulkhead_comprt1_thick	float	Insert/Update
37	trl_bulkhead_comprt1_thick_uom	string	t.trl_comprt1_thick_uom	varchar(6)	Insert/Update
38	trl_bulkhead_comprt2_thick	double	t.trl_bulkhead_comprt2_thick	float	Insert/Update
39	trl_bulkhead_comprt2_thick_uom	string	t.trl_comprt2_thick_uom	varchar(6)	Insert/Update
40	trl_bulkhead_comprt3_thick	double	t.trl_bulkhead_comprt3_thick	float	Insert/Update
41	trl_bulkhead_comprt3_thick_uom	string	t.trl_comprt3_thick_uom	varchar(6)	Insert/Update
42	trl_bulkhead_comprt4_thick	double	t.trl_bulkhead_comprt4_thick	float	Insert/Update
43	trl_bulkhead_comprt4_thick_uom	string	t.trl_comprt4_thick_uom	varchar(6)	Insert/Update
44	trl_bulkhead_comprt5_thick	double	t.trl_bulkhead_comprt5_thick	float	Insert/Update
45	trl_bulkhead_comprt5_thick_uom	string	t.trl_comprt5_thick_uom	varchar(6)	Insert/Update
46	trl_company	string	t.trl_company	varchar(6)	Insert/Update
47	trl_comprt1_bulkhead	string	t.trl_comprt1_bulkhead	varchar(6)	Insert/Update
48	trl_comprt1_size_dry	int	t.trl_comprt1_size_dry	int	Insert/Update
49	trl_comprt1_size_wet	int	t.trl_comprt1_size_wet	int	Insert/Update
50	trl_comprt1_uom_dry	string	t.trl_comprt1_uom_dry	varchar(6)	Insert/Update
51	trl_comprt1_uom_wet	string	t.trl_comprt1_uom_wet	varchar(6)	Insert/Update
52	trl_comprt2_bulkhead	string	t.trl_comprt2_bulkhead	varchar(6)	Insert/Update
53	trl_comprt2_size_dry	int	t.trl_comprt2_size_dry	int	Insert/Update
54	trl_comprt2_size_wet	int	t.trl_comprt2_size_wet	int	Insert/Update
55	trl_comprt2_uom_dry	string	t.trl_comprt2_uom_dry	varchar(6)	Insert/Update
56	trl_comprt2_uom_wet	string	t.trl_comprt2_uom_wet	varchar(6)	Insert/Update
57	trl_comprt3_bulkhead	string	t.trl_comprt3_bulkhead	varchar(6)	Insert/Update
58	trl_comprt3_size_dry	int	t.trl_comprt3_size_dry	int	Insert/Update
59	trl_comprt3_size_wet	int	t.trl_comprt3_size_wet	int	Insert/Update
60	trl_comprt3_uom_dry	string	t.trl_comprt3_uom_dry	varchar(6)	Insert/Update
61	trl_comprt3_uom_wet	string	t.trl_comprt3_uom_wet	varchar(6)	Insert/Update
62	trl_comprt4_bulkhead	string	t.trl_comprt4_bulkhead	varchar(6)	Insert/Update
63	trl_comprt4_size_dry	int	t.trl_comprt4_size_dry	int	Insert/Update
64	trl_comprt4_size_wet	int	t.trl_comprt4_size_wet	int	Insert/Update
65	trl_comprt4_uom_dry	string	t.trl_comprt4_uom_dry	varchar(6)	Insert/Update
66	trl_comprt4_uom_wet	string	t.trl_comprt4_uom_wet	varchar(6)	Insert/Update
67	trl_comprt5_bulkhead	string	t.trl_comprt5_bulkhead	varchar(6)	Insert/Update
68	trl_comprt5_size_dry	int	t.trl_comprt5_size_dry	int	Insert/Update
69	trl_comprt5_size_wet	int	t.trl_comprt5_size_wet	int	Insert/Update
70	trl_comprt5_uom_dry	string	t.trl_comprt5_uom_dry	varchar(6)	Insert/Update
71	trl_comprt5_uom_wet	string	t.trl_comprt5_uom_wet	varchar(6)	Insert/Update
72	trl_comprt6_size_dry	int	t.trl_comprt6_size_dry	int	Insert/Update
73	trl_comprt6_size_wet	int	t.trl_comprt6_size_wet	int	Insert/Update
74	trl_comprt6_uom_dry	string	t.trl_comprt6_uom_dry	varchar(6)	Insert/Update
75	trl_comprt6_uom_wet	string	t.trl_comprt6_uom_wet	varchar(6)	Insert/Update
76	trl_createdate	DateTime	t.trl_createdate	datetime	Insert/Update
77	trl_cur_mileage	int	t.trl_cur_mileage	int	Insert/Update
78	trl_currenthub	int	t.trl_currenthub	int	Insert/Update
79	trl_dateacquired	DateTime	t.trl_dateacquired	datetime	Insert/Update
80	trl_division	string	t.trl_division	varchar(6)	Insert/Update
81	trl_dwelltime	decimal	t.trl_dwelltime	decimal(9,1)	Insert/Update
82	trl_exp1_date	DateTime	t.trl_exp1_date	datetime	Insert/Update
83	trl_exp1_enddate	DateTime	t.trl_exp1_enddate	datetime	Insert/Update
84	trl_exp2_date	DateTime	t.trl_exp2_date	datetime	Insert/Update
85	trl_exp2_enddate	DateTime	t.trl_exp2_enddate	datetime	Insert/Update
86	trl_fix_record	string	t.trl_fix_record	char(1)	Insert/Update
87	trl_fleet	string	t.trl_fleet	varchar(6)	Insert/Update
88	trl_gp_class	string	t.trl_gp_class	varchar(15)	Insert/Update
89	trl_gps_desc	string	t.trl_gps_desc	varchar(255)	Insert/Update
90	trl_grosswgt	int	t.trl_grosswgt	int	Insert/Update
91	trl_ht	double	t.trl_ht	Float	Insert/Update
92	trl_id	string	t.trl_id	varchar(13)	Insert/Update	Key
93	trl_ilt_scac	string	t.trl_ilt_scac	char(4)	Insert/Update
94	trl_iltFlag	bool	t.trl_ilt	char(1)	Insert/Update
95	trl_kp_to_axle1	double	t.trl_kp_to_axle1	float	Insert/Update
96	trl_kp_to_axle1_uom	string	t.trl_kp_to_axle1_uom	varchar(6)	Insert/Update
97	trl_last_cmd	string	t.trl_last_cmd	varchar(8)	Insert/Update
98	trl_last_cmd_date	DateTime	t.trl_last_cmd_date	datetime	Insert/Update
99	trl_last_cmd_ord	int	t.trl_last_cmd_ord	int	Insert/Update
100	trl_last_stop	int	t.trl_last_stop	int	Insert/Update
101	trl_lastaxle_to_rear	double	t.trl_lastaxle_to_rear	float	Insert/Update
102	trl_lastaxle_to_rear_uom	string	t.trl_lastaxle_to_rear_uom	varchar(6)	Insert/Update
103	trl_len	double	t.trl_len	float	Insert/Update
104	trl_liccountry	string	t.trl_liccountry	varchar(50)	Insert/Update
105	trl_licnum	string	t.trl_licnum	varchar(12)	Insert/Update
106	trl_licstate	string	t.trl_licstate	varchar(6)	Insert/Update
107	trl_loading_class	string	t.trl_loading_class	varchar(6)	Insert/Update
108	trl_make	string	t.trl_make	varchar(8)	Insert/Update
109	trl_misc1	string	t.trl_misc1	varchar(254)	Insert/Update
110	trl_misc2	string	t.trl_misc2	varchar(254)	Insert/Update
111	trl_misc3	string	t.trl_misc3	varchar(254)	Insert/Update
112	trl_misc4	string	t.trl_misc4	varchar(254)	Insert/Update
113	trl_model	string	t.trl_model	varchar(12)	Insert/Update
114	trl_mpg	double	t.trl_mpg	float	Insert/Update
115	trl_mtwgt	int	t.trl_mtwgt	int	Insert/Update
116	trl_newused	int	t.trl_newused	int	Insert/Update
117	trl_next_city	int	t.trl_next_city	int	Insert/Update
118	trl_next_cmp_id	string	t.trl_next_cmp_id	varchar(8)	Insert/Update
119	trl_next_event	string	t.trl_next_event	char(6)	Insert/Update
120	trl_next_region1	string	t.trl_next_region1	varchar(6)	Insert/Update
121	trl_next_region2	string	t.trl_next_region2	varchar(6)	Insert/Update
122	trl_next_region3	string	t.trl_next_region3	varchar(6)	Insert/Update
123	trl_next_region4	string	t.trl_next_region4	varchar(6)	Insert/Update
124	trl_next_state	string	t.trl_next_state	varchar(6)	Insert/Update
125	trl_nose_to_kp	double	t.trl_nose_to_kp	float	Insert/Update
126	trl_nose_to_kp_uom	string	t.trl_nose_to_kp_uom	varchar(6)	Insert/Update
127	trl_number	string	t.trl_number	varchar(8)	Insert/Update
128	trl_opercostmile	double	t.trl_opercostmile	float	Insert/Update
129	trl_origcost	double	t.trl_origcost	float	Insert/Update
130	trl_owner	string	t.trl_owner	varchar(12)	Insert/Update
131	trl_palletcount	int	t.trl_palletcount	int	Insert/Update
132	trl_prior_city	int	t.trl_prior_city	int	Insert/Update
133	trl_prior_cmp_id	string	t.trl_prior_cmp_id	varchar(8)	Insert/Update
134	trl_prior_event	string	t.trl_prior_event	char(6)	Insert/Update
135	trl_prior_region1	string	t.trl_prior_region1	varchar(6)	Insert/Update
136	trl_prior_region2	string	t.trl_prior_region2	varchar(6)	Insert/Update
137	trl_prior_region3	string	t.trl_prior_region3	varchar(6)	Insert/Update
138	trl_prior_region4	string	t.trl_prior_region4	varchar(6)	Insert/Update
139	trl_prior_state	string	t.trl_prior_state	varchar(6)	Insert/Update
140	trl_pupid	string	t.trl_pupid	varchar(13)	Insert/Update
141	trl_retiredate	DateTime	t.trl_retiredate	datetime	Insert/Update
142	trl_sch_city	int	t.trl_sch_city	int	Insert/Update
143	trl_sch_cmp_id	string	t.trl_sch_cmp_id	varchar(8)	Insert/Update
144	trl_sch_date	DateTime	t.trl_sch_date	datetime	Insert/Update
145	trl_sch_status	string	t.trl_sch_status	varchar(6)	Insert/Update
146	trl_serial	string	t.trl_serial	varchar(20)	Insert/Update
147	trl_startdate	DateTime	t.trl_startdate	datetime	Insert/Update
148	trl_status	string	t.trl_status	varchar(6)	Insert/Update
149	trl_tareweight	double	t.trl_tareweight	float	Insert/Update
150	trl_tareweight_uom	string	t.trl_tareweight_uom	varchar(6)	Insert/Update
151	trl_terminal	string	t.trl_terminal	varchar(6)	Insert/Update
152	trl_total_no_of_compartments	int	t.trl_total_no_of_compartments	int	Insert/Update
153	trl_total_trailer_size_dry	double	t.trl_total_trailer_size_dry	float	Insert/Update
154	trl_total_trailer_size_wet	double	t.trl_total_trailer_size_wet	float	Insert/Update
155	trl_type1	string	t.trl_type1	varchar(6)	Insert/Update
156	trl_type2	string	t.trl_type2	varchar(6)	Insert/Update
157	trl_type3	string	t.trl_type3	varchar(6)	Insert/Update
158	trl_type4	string	t.trl_type4	varchar(6)	Insert/Update
159	trl_uom_dry	string	t.trl_uom_dry	varchar(6)	Insert/Update
160	trl_uom_wet	string	t.trl_uom_wet	varchar(6)	Insert/Update
161	trl_updatedby	string	t.trl_updatedby	varchar(256)	Insert/Update
162	trl_updateon	DateTime	t.trl_updateon	datetime	Insert/Update
163	trl_wash_statusFlag	bool	t.trl_wash_status	char(1)	Insert/Update
164	trl_wdth	double	t.trl_wdth	float	Insert/Update
165	trl_worksheet_comment1	string	t.trl_worksheet_comment1	varchar(60)	Insert/Update
166	trl_worksheet_comment2	string	t.trl_worksheet_comment2	varchar(60)	Insert/Update
167	trl_year	int	t.trl_year	int	Insert/Update
168	UpdateableProperties	TrailerUpdateInfo			N/A	Not mapped

Property

Database Column

Modifiable

Comments

Name

Data Type (in C#)

Name

Data Type

cmp_id

string

t.cmp_id

varchar(8)

Insert/Update

cty_code

int

t.cty_code

int

Insert/Update

DataSourceID

string

N/A

Not mapped

ExpirationAssetID

string

Read only

ExpirationAssetType

AssetTypeEnum

Read only

Expirations

List <Expiration>

Insert/Update

Reference Expiration object from Expiration table

IsDirty

bool

N/A

Not mapped or used in service

IsNew

bool

N/A

Not mapped, set to false during save to update

IsValid

bool

N/A

Not mapped or used in service

timestamp

Byte[]

t.timestamp

timestamp

Insert/Update

TrailerImage

Byte[]

Insert/Update

Calculated from trl_bmp_pathname property

trl_accessorylist

string

t.trl_accessorylist

varchar(254)

Insert/Update

trl_aceid

string

t.trl_aceid

varchar(10)

Insert/Update

trl_aceidtype

string

t.trl_aceidtype

varchar(6)

Insert/Update

trl_actg_type

string

t.trl_actg_type

char(1)

Insert/Update

trl_avail_city

int

t.trl_avail_city

int

Insert/Update

trl_avail_cmp_id

string

t.trl_avail_cmp_id

varchar(8)

Insert/Update

trl_avail_date

DateTime

t.trl_avail_date

datetime

Insert/Update

trl_axle1_to_axle2

double

t.trl_axle1_to_axle2

float

Insert/Update

trl_axle1_to_axle2_uom

string

t.trl_axle1_to_axle2_uom

varchar(6)

Insert/Update

trl_axle2_to_axle3

double

t.trl_axle2_to_axle3

float

Insert/Update

trl_axle2_to_axle3_uom

string

t.trl_axle2_to_axle3_uom

varchar(6)

Insert/Update

trl_axle3_to_axle4

double

t.trl_axle3_to_axle4

float

Insert/Update

trl_axle3_to_axle4_uom

string

t.trl_axle3_to_axle4_uom

varchar(6)

Insert/Update

trl_axle4_to_axle5

double

t.trl_axle4_to_axle5

float

Insert/Update

trl_axle4_to_axle5_uom

string

t.trl_axle4_to_axle5_uom

varchar(6)

Insert/Update

trl_axles

short

t.trl_axles

smallint

Insert/Update

trl_axlgrp1_grosswgt

double

t.trl_axlgrp1_grosswgt

float

Insert/Update

trl_axlgrp1_tarewgt

double

t.trl_axlgrp1_tarewgt

float

Insert/Update

trl_axlgrp2_grosswgt

double

t.trl_axlgrp2_grosswgt

float

Insert/Update

trl_axlgrp2_tarewgt

double

t.trl_axlgrp2_tarewgt

float

Insert/Update

trl_billto_parent

string

t.trl_billto_parent

varchar(8)

Insert/Update

trl_bmp_pathname

string

t.trl_bmp_pathname

varchar(255)

Insert/Update

trl_booked_revtype1

string

t.trl_booked_revtype1

Insert/Update

trl_branch

string

t.trl_branch

varchar(12)

Insert/Update

trl_bulkhead_comprt1_thick

double

t.trl_bulkhead_comprt1_thick

float

Insert/Update

trl_bulkhead_comprt1_thick_uom

string

t.trl_comprt1_thick_uom

varchar(6)

Insert/Update

trl_bulkhead_comprt2_thick

double

t.trl_bulkhead_comprt2_thick

float

Insert/Update

trl_bulkhead_comprt2_thick_uom

string

t.trl_comprt2_thick_uom

varchar(6)

Insert/Update

trl_bulkhead_comprt3_thick

double

t.trl_bulkhead_comprt3_thick

float

Insert/Update

trl_bulkhead_comprt3_thick_uom

string

t.trl_comprt3_thick_uom

varchar(6)

Insert/Update

trl_bulkhead_comprt4_thick

double

t.trl_bulkhead_comprt4_thick

float

Insert/Update

trl_bulkhead_comprt4_thick_uom

string

t.trl_comprt4_thick_uom

varchar(6)

Insert/Update

trl_bulkhead_comprt5_thick

double

t.trl_bulkhead_comprt5_thick

float

Insert/Update

trl_bulkhead_comprt5_thick_uom

string

t.trl_comprt5_thick_uom

varchar(6)

Insert/Update

trl_company

string

t.trl_company

varchar(6)

Insert/Update

trl_comprt1_bulkhead

string

t.trl_comprt1_bulkhead

varchar(6)

Insert/Update

trl_comprt1_size_dry

int

t.trl_comprt1_size_dry

int

Insert/Update

trl_comprt1_size_wet

int

t.trl_comprt1_size_wet

int

Insert/Update

trl_comprt1_uom_dry

string

t.trl_comprt1_uom_dry

varchar(6)

Insert/Update

trl_comprt1_uom_wet

string

t.trl_comprt1_uom_wet

varchar(6)

Insert/Update

trl_comprt2_bulkhead

string

t.trl_comprt2_bulkhead

varchar(6)

Insert/Update

trl_comprt2_size_dry

int

t.trl_comprt2_size_dry

int

Insert/Update

trl_comprt2_size_wet

int

t.trl_comprt2_size_wet

int

Insert/Update

trl_comprt2_uom_dry

string

t.trl_comprt2_uom_dry

varchar(6)

Insert/Update

trl_comprt2_uom_wet

string

t.trl_comprt2_uom_wet

varchar(6)

Insert/Update

trl_comprt3_bulkhead

string

t.trl_comprt3_bulkhead

varchar(6)

Insert/Update

trl_comprt3_size_dry

int

t.trl_comprt3_size_dry

int

Insert/Update

trl_comprt3_size_wet

int

t.trl_comprt3_size_wet

int

Insert/Update

trl_comprt3_uom_dry

string

t.trl_comprt3_uom_dry

varchar(6)

Insert/Update

trl_comprt3_uom_wet

string

t.trl_comprt3_uom_wet

varchar(6)

Insert/Update

trl_comprt4_bulkhead

string

t.trl_comprt4_bulkhead

varchar(6)

Insert/Update

trl_comprt4_size_dry

int

t.trl_comprt4_size_dry

int

Insert/Update

trl_comprt4_size_wet

int

t.trl_comprt4_size_wet

int

Insert/Update

trl_comprt4_uom_dry

string

t.trl_comprt4_uom_dry

varchar(6)

Insert/Update

trl_comprt4_uom_wet

string

t.trl_comprt4_uom_wet

varchar(6)

Insert/Update

trl_comprt5_bulkhead

string

t.trl_comprt5_bulkhead

varchar(6)

Insert/Update

trl_comprt5_size_dry

int

t.trl_comprt5_size_dry

int

Insert/Update

trl_comprt5_size_wet

int

t.trl_comprt5_size_wet

int

Insert/Update

trl_comprt5_uom_dry

string

t.trl_comprt5_uom_dry

varchar(6)

Insert/Update

trl_comprt5_uom_wet

string

t.trl_comprt5_uom_wet

varchar(6)

Insert/Update

trl_comprt6_size_dry

int

t.trl_comprt6_size_dry

int

Insert/Update

trl_comprt6_size_wet

int

t.trl_comprt6_size_wet

int

Insert/Update

trl_comprt6_uom_dry

string

t.trl_comprt6_uom_dry

varchar(6)

Insert/Update

trl_comprt6_uom_wet

string

t.trl_comprt6_uom_wet

varchar(6)

Insert/Update

trl_createdate

DateTime

t.trl_createdate

datetime

Insert/Update

trl_cur_mileage

int

t.trl_cur_mileage

int

Insert/Update

trl_currenthub

int

t.trl_currenthub

int

Insert/Update

trl_dateacquired

DateTime

t.trl_dateacquired

datetime

Insert/Update

trl_division

string

t.trl_division

varchar(6)

Insert/Update

trl_dwelltime

decimal

t.trl_dwelltime

decimal(9,1)

Insert/Update

trl_exp1_date

DateTime

t.trl_exp1_date

datetime

Insert/Update

trl_exp1_enddate

DateTime

t.trl_exp1_enddate

datetime

Insert/Update

trl_exp2_date

DateTime

t.trl_exp2_date

datetime

Insert/Update

trl_exp2_enddate

DateTime

t.trl_exp2_enddate

datetime

Insert/Update

trl_fix_record

string

t.trl_fix_record

char(1)

Insert/Update

trl_fleet

string

t.trl_fleet

varchar(6)

Insert/Update

trl_gp_class

string

t.trl_gp_class

varchar(15)

Insert/Update

trl_gps_desc

string

t.trl_gps_desc

varchar(255)

Insert/Update

trl_grosswgt

int

t.trl_grosswgt

int

Insert/Update

trl_ht

double

t.trl_ht

Float

Insert/Update

trl_id

string

t.trl_id

varchar(13)

Insert/Update

Key

trl_ilt_scac

string

t.trl_ilt_scac

char(4)

Insert/Update

trl_iltFlag

bool

t.trl_ilt

char(1)

Insert/Update

trl_kp_to_axle1

double

t.trl_kp_to_axle1

float

Insert/Update

trl_kp_to_axle1_uom

string

t.trl_kp_to_axle1_uom

varchar(6)

Insert/Update

trl_last_cmd

string

t.trl_last_cmd

varchar(8)

Insert/Update

trl_last_cmd_date

DateTime

t.trl_last_cmd_date

datetime

Insert/Update

trl_last_cmd_ord

int

t.trl_last_cmd_ord

int

Insert/Update

100

trl_last_stop

int

t.trl_last_stop

int

Insert/Update

101

trl_lastaxle_to_rear

double

t.trl_lastaxle_to_rear

float

Insert/Update

102

trl_lastaxle_to_rear_uom

string

t.trl_lastaxle_to_rear_uom

varchar(6)

Insert/Update

103

trl_len

double

t.trl_len

float

Insert/Update

104

trl_liccountry

string

t.trl_liccountry

varchar(50)

Insert/Update

105

trl_licnum

string

t.trl_licnum

varchar(12)

Insert/Update

106

trl_licstate

string

t.trl_licstate

varchar(6)

Insert/Update

107

trl_loading_class

string

t.trl_loading_class

varchar(6)

Insert/Update

108

trl_make

string

t.trl_make

varchar(8)

Insert/Update

109

trl_misc1

string

t.trl_misc1

varchar(254)

Insert/Update

110

trl_misc2

string

t.trl_misc2

varchar(254)

Insert/Update

111

trl_misc3

string

t.trl_misc3

varchar(254)

Insert/Update

112

trl_misc4

string

t.trl_misc4

varchar(254)

Insert/Update

113

trl_model

string

t.trl_model

varchar(12)

Insert/Update

114

trl_mpg

double

t.trl_mpg

float

Insert/Update

115

trl_mtwgt

int

t.trl_mtwgt

int

Insert/Update

116

trl_newused

int

t.trl_newused

int

Insert/Update

117

trl_next_city

int

t.trl_next_city

int

Insert/Update

118

trl_next_cmp_id

string

t.trl_next_cmp_id

varchar(8)

Insert/Update

119

trl_next_event

string

t.trl_next_event

char(6)

Insert/Update

120

trl_next_region1

string

t.trl_next_region1

varchar(6)

Insert/Update

121

trl_next_region2

string

t.trl_next_region2

varchar(6)

Insert/Update

122

trl_next_region3

string

t.trl_next_region3

varchar(6)

Insert/Update

123

trl_next_region4

string

t.trl_next_region4

varchar(6)

Insert/Update

124

trl_next_state

string

t.trl_next_state

varchar(6)

Insert/Update

125

trl_nose_to_kp

double

t.trl_nose_to_kp

float

Insert/Update

126

trl_nose_to_kp_uom

string

t.trl_nose_to_kp_uom

varchar(6)

Insert/Update

127

trl_number

string

t.trl_number

varchar(8)

Insert/Update

128

trl_opercostmile

double

t.trl_opercostmile

float

Insert/Update

129

trl_origcost

double

t.trl_origcost

float

Insert/Update

130

trl_owner

string

t.trl_owner

varchar(12)

Insert/Update

131

trl_palletcount

int

t.trl_palletcount

int

Insert/Update

132

trl_prior_city

int

t.trl_prior_city

int

Insert/Update

133

trl_prior_cmp_id

string

t.trl_prior_cmp_id

varchar(8)

Insert/Update

134

trl_prior_event

string

t.trl_prior_event

char(6)

Insert/Update

135

trl_prior_region1

string

t.trl_prior_region1

varchar(6)

Insert/Update

136

trl_prior_region2

string

t.trl_prior_region2

varchar(6)

Insert/Update

137

trl_prior_region3

string

t.trl_prior_region3

varchar(6)

Insert/Update

138

trl_prior_region4

string

t.trl_prior_region4

varchar(6)

Insert/Update

139

trl_prior_state

string

t.trl_prior_state

varchar(6)

Insert/Update

140

trl_pupid

string

t.trl_pupid

varchar(13)

Insert/Update

141

trl_retiredate

DateTime

t.trl_retiredate

datetime

Insert/Update

142

trl_sch_city

int

t.trl_sch_city

int

Insert/Update

143

trl_sch_cmp_id

string

t.trl_sch_cmp_id

varchar(8)

Insert/Update

144

trl_sch_date

DateTime

t.trl_sch_date

datetime

Insert/Update

145

trl_sch_status

string

t.trl_sch_status

varchar(6)

Insert/Update

146

trl_serial

string

t.trl_serial

varchar(20)

Insert/Update

147

trl_startdate

DateTime

t.trl_startdate

datetime

Insert/Update

148

trl_status

string

t.trl_status

varchar(6)

Insert/Update

149

trl_tareweight

double

t.trl_tareweight

float

Insert/Update

150

trl_tareweight_uom

string

t.trl_tareweight_uom

varchar(6)

Insert/Update

151

trl_terminal

string

t.trl_terminal

varchar(6)

Insert/Update

152

trl_total_no_of_compartments

int

t.trl_total_no_of_compartments

int

Insert/Update

153

trl_total_trailer_size_dry

double

t.trl_total_trailer_size_dry

float

Insert/Update

154

trl_total_trailer_size_wet

double

t.trl_total_trailer_size_wet

float

Insert/Update

155

trl_type1

string

t.trl_type1

varchar(6)

Insert/Update

156

trl_type2

string

t.trl_type2

varchar(6)

Insert/Update

157

trl_type3

string

t.trl_type3

varchar(6)

Insert/Update

158

trl_type4

string

t.trl_type4

varchar(6)

Insert/Update

159

trl_uom_dry

string

t.trl_uom_dry

varchar(6)

Insert/Update

160

trl_uom_wet

string

t.trl_uom_wet

varchar(6)

Insert/Update

161

trl_updatedby

string

t.trl_updatedby

varchar(256)

Insert/Update

162

trl_updateon

DateTime

t.trl_updateon

datetime

Insert/Update

163

trl_wash_statusFlag

bool

t.trl_wash_status

char(1)

Insert/Update

164

trl_wdth

double

t.trl_wdth

float

Insert/Update

165

trl_worksheet_comment1

string

t.trl_worksheet_comment1

varchar(60)

Insert/Update

166

trl_worksheet_comment2

string

t.trl_worksheet_comment2

varchar(60)

Insert/Update

167

trl_year

int

t.trl_year

int

Insert/Update

168

UpdateableProperties

TrailerUpdateInfo

N/A

Not mapped

Trailer.ReturnObject

	Property Name	Data Type (in C#)
1	ErrorMessages	List <string>
2	ErrorObjectIndexList	List <int>
3	Exceptions	List <Exception>
4	ReferenceObjects	List <Trailer>
5	ReturnCode	int
6	TraceMessages	List <string>
7	WarningMessages	List <string>

Property Name

Data Type (in C#)

Comments

ErrorMessages

List <string>

ErrorObjectIndexList

List <int>

Exceptions

List <Exception>

ReferenceObjects

List <Trailer>

ReturnCode

int

TraceMessages

List <string>

WarningMessages

List <string>

TrailerUpdateInfo object

Data types (in C#) for all properties are bool.
Set the property to true to update the corresponding Trailer property.

	Property Name		Property Name		Property Name		Property Name
1	cmp_id	41	trl_comprt1_bulkhead	81	trl_fleet	121	trl_number
2	cty_code	42	trl_comprt1_size_dry	82	trl_gp_class	122	trl_opercostmile
3	Expirations	43	trl_comprt1_size_wet	83	trl_gps_desc	123	trl_origcost
4	timestamp	44	trl_comprt1_uom_dry	84	trl_grosswgt	124	trl_owner
5	TrailerImage	45	trl_comprt1_uom_wet	85	trl_ht	125	trl_palletcount
6	trl_accessorylist	46	trl_comprt2_bulkhead	86	trl_id	126	trl_prior_city
7	trl_aceid	47	trl_comprt2_size_dry	87	trl_ilt_scac	127	trl_prior_cmp_id
8	trl_aceidtype	48	trl_comprt2_size_wet	88	trl_iltFlag	128	trl_prior_event
9	trl_actg_type	49	trl_comprt2_uom_dry	89	trl_kp_to_axle1	129	trl_prior_region1
10	trl_avail_city	50	trl_comprt2_uom_wet	90	trl_kp_to_axle1_uom	130	trl_prior_region2
11	trl_avail_cmp_id	51	trl_comprt3_bulkhead	91	trl_last_cmd	131	trl_prior_region3
12	trl_avail_date	52	trl_comprt3_size_dry	92	trl_last_cmd_date	132	trl_prior_region4
13	trl_axle1_to_axle2	53	trl_comprt3_size_wet	93	trl_last_cmd_ord	133	trl_prior_state
14	trl_axle1_to_axle2_uom	54	trl_comprt3_uom_dry	94	trl_last_stop	134	trl_pupid
15	trl_axle2_to_axle3	55	trl_comprt3_uom_wet	95	trl_lastaxle_to_rear	135	trl_retiredate
16	trl_axle2_to_axle3_uom	56	trl_comprt4_bulkhead	96	trl_lastaxle_to_rear_uom	136	trl_sch_city
17	trl_axle3_to_axle4	57	trl_comprt4_size_dry	97	trl_len	137	trl_sch_cmp_id
18	trl_axle3_to_axle4_uom	58	trl_comprt4_size_wet	98	trl_liccountry	138	trl_sch_date
19	trl_axle4_to_axle5	59	trl_comprt4_uom_dry	99	trl_licnum	139	trl_sch_status
20	trl_axle4_to_axle5_uom	60	trl_comprt4_uom_wet	100	trl_licstate	140	trl_serial
21	trl_axles	61	trl_comprt5_bulkhead	101	trl_loading_class	141	trl_startdate
22	trl_axlgrp1_grosswgt	62	trl_comprt5_size_dry	102	trl_make	142	trl_status
23	trl_axlgrp1_tarewgt	63	trl_comprt5_size_wet	103	trl_misc1	143	trl_tareweight
24	trl_axlgrp2_grosswgt	64	trl_comprt5_uom_dry	104	trl_misc2	144	trl_tareweight_uom
25	trl_axlgrp2_tarewgt	65	trl_comprt5_uom_wet	105	trl_misc3	145	trl_terminal
26	trl_billto_parent	66	trl_comprt6_size_dry	106	trl_misc4	146	trl_total_no_of_compartments
27	trl_bmp_pathname	67	trl_comprt6_size_wet	107	trl_model	147	trl_total_trailer_size_dry
28	trl_booked_revtype1	68	trl_comprt6_uom_dry	108	trl_mpg	148	trl_total_trailer_size_wet
29	trl_branch	69	trl_comprt6_uom_wet	109	trl_mtwgt	149	trl_type1
30	trl_bulkhead_comprt1_thick	70	trl_createdate	110	trl_newused	150	trl_type2
31	trl_bulkhead_comprt1_thick_uom	71	trl_cur_mileage	111	trl_next_city	151	trl_type3
32	trl_bulkhead_comprt2_thick	72	trl_currenthub	112	trl_next_cmp_id	152	trl_type4
33	trl_bulkhead_comprt2_thick_uom	73	trl_dateacquired	113	trl_next_event	153	trl_uom_dry
34	trl_bulkhead_comprt3_thick	74	trl_division	114	trl_next_region1	154	trl_uom_wet
35	trl_bulkhead_comprt3_thick_uom	75	trl_dwelltime	115	trl_next_region2	155	trl_wash_statusFlag
36	trl_bulkhead_comprt4_thick	76	trl_exp1_date	116	trl_next_region3	156	trl_wdth
37	trl_bulkhead_comprt4_thick_uom	77	trl_exp1_enddate	117	trl_next_region4	157	trl_worksheet_comment1
38	trl_bulkhead_comprt5_thick	78	trl_exp2_date	118	trl_next_state	158	trl_worksheet_comment2
39	trl_bulkhead_comprt5_thick_uom	79	trl_exp2_enddate	119	trl_nose_to_kp	159	trl_year
40	trl_company	80	trl_fix_record	120	trl_nose_to_kp_uom

Criteria object

To condense the information in table, the Database Column uses the following abbreviations for database tables:

t = trailerprofile

All columns in the trailerprofile table are included.

	Name	Database Column	Data Type (in C#)
1	cmp_id	co.cmp_id	string
2	cty_code	ci.cty_code	int?
3	trl_avail_city	t.trl_avail_city	int?
4	trl_avail_cmp_id	t.trl_avail_cmp_id	string
5	trl_avail_date	t.trl_avail_date	DateTime?
6	trl_billto_parent	t.trl_billto_parent	string
7	trl_booked_revtype1	t.trl_booked_revtype1	string
8	trl_branch	t.trl_branch	string
9	trl_company	t.trl_company	string
10	trl_dateacquired	t.trl_dateacquired	DateTime?
11	trl_division	t.trl_division	string
12	trl_fleet	t.trl_fleet	string
13	trl_id	t.trl_id	string
14	trl_ilt_scac	t.trl_ilt_scac	string
15	trl_last_cmd	t.trl_last_cmd	string
16	trl_make	t.trl_make	string
17	trl_model	t.trl_model	string
18	trl_number	t.trl_number	string
19	trl_owner	t.trl_owner	string
20	trl_pupid	t.trl_pupid	string
21	trl_retiredate	t.trl_retiredate	DateTime?
22	trl_status	t.trl_status	string
23	trl_terminal	t.trl_terminal	string
24	trl_type1	t.trl_type1	string
25	trl_type2	t.trl_type2	string
26	trl_type3	t.trl_type3	string
27	trl_type4	t.trl_type4	string
28	trl_updatedby	t.trl_updatedby	string
29	trl_updateon	t.trl_updateon	DateTime?
30	trl_wash_statusFlag	t.trl_wash_statusFlag	bool?

Name

Database Column

Data Type (in C#)

Comments

cmp_id

co.cmp_id

string

cty_code

ci.cty_code

int?

trl_avail_city

t.trl_avail_city

int?

trl_avail_cmp_id

t.trl_avail_cmp_id

string

trl_avail_date

t.trl_avail_date

DateTime?

trl_billto_parent

t.trl_billto_parent

string

trl_booked_revtype1

t.trl_booked_revtype1

string

trl_branch

t.trl_branch

string

trl_company

t.trl_company

string

trl_dateacquired

t.trl_dateacquired

DateTime?

trl_division

t.trl_division

string

trl_fleet

t.trl_fleet

string

trl_id

t.trl_id

string

trl_ilt_scac

t.trl_ilt_scac

string

trl_last_cmd

t.trl_last_cmd

string

trl_make

t.trl_make

string

trl_model

t.trl_model

string

trl_number

t.trl_number

string

trl_owner

t.trl_owner

string

trl_pupid

t.trl_pupid

string

trl_retiredate

t.trl_retiredate

DateTime?

trl_status

t.trl_status

string

trl_terminal

t.trl_terminal

string

trl_type1

t.trl_type1

string

trl_type2

t.trl_type2

string

trl_type3

t.trl_type3

string

trl_type4

t.trl_type4

string

trl_updatedby

t.trl_updatedby

string

trl_updateon

t.trl_updateon

DateTime?

trl_wash_statusFlag

t.trl_wash_statusFlag

bool?