CarrierBid object :: SystemsLink

Methods

The Return Value for all methods is CarrierBidReturnObject.

Method Name	Parameters		ReturnCode	Description
	Name	Data type (in C#)
NewCarrierBid	N/A		CarrierBid.ReturnObject.ReturnCode 0 = successful 1000 = errors occurred	Returns new CarrierBid object instance
NewCarrierBids	number	int	CarrierBid.ReturnObject.ReturnCode 0 = successful 1000 = errors occurred	Returns new CarrierBid object instances
RetrieveCarrierBid	criteria	CarrierBid.Criteria	CarrierBid.ReturnObject.ReturnCode 0 = successful 100 = no records found 1000 = errors occurred	Creates a new CarrierBid object in memory
RetrievePagedCarrierBid	criteria	CarrierBid.Criteria	CarrierBid.PagedReturnObject.ReturnCode 0 = successful 100 = no records found 1000 = errors occurred	Retrieves CarrierBids based on passed in-criteria and paging
SaveCarrierBid	items	List<CarrierBid>	CarrierBid.ReturnObject.ReturnCode 0 = successful 100 = validation errors occurred and updates prevented 500 = update proceeded with warnings 1000 = error occurred and updates prevented	Saves the provided CarrierBid object and updates the database if requested, then returns the saved objects if the save was successful
	updateDB	bool

Method Name

Parameters

ReturnCode

Description

Name

Data type (in C#)

NewCarrierBid

N/A

CarrierBid.ReturnObject.ReturnCode

0 = successful

1000 = errors occurred

Returns new CarrierBid object instance

NewCarrierBids

number

int

CarrierBid.ReturnObject.ReturnCode

0 = successful

1000 = errors occurred

Returns new CarrierBid object instances

RetrieveCarrierBid

criteria

CarrierBid.Criteria

CarrierBid.ReturnObject.ReturnCode

0 = successful

100 = no records found

1000 = errors occurred

Creates a new CarrierBid object in memory

RetrievePagedCarrierBid

criteria

CarrierBid.Criteria

CarrierBid.PagedReturnObject.ReturnCode

0 = successful

100 = no records found

1000 = errors occurred

Retrieves CarrierBids based on passed in-criteria and paging

SaveCarrierBid

items

List<CarrierBid>

CarrierBid.ReturnObject.ReturnCode

0 = successful

100 = validation errors occurred and updates prevented

500 = update proceeded with warnings

1000 = error occurred and updates prevented

Saves the provided CarrierBid object 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:

cb = carrierbids

	Property	Database Column	Modifiable	Comments
	Name	Data Type (in C#)	Name	Data Type
1	AwardApplication	string	cb.cb_award_application	varchar(20)	Insert / Update
2	AwardDateTime	DateTime	cb.cb_award_datetime	datetime	Insert / Update
3	AwardStatus	string	cb.cb_award_status	varchar(6)	Insert / Update
4	AwardUser	string	cb.cb_award_user	varchar(20)	Insert / Update
5	CaId	int	cb.ca_id	int	Insert / Update
6	CarId	string	cb.car_id	varchar(8)	Insert / Update
7	CarrierID	string	cb.car_id	varchar(8)	Insert / Update
8	CarrierLaneCommitmentId	int	cb.carrierlanecommitmentid	int	Insert / Update
9	CarrierName	string				Not mapped
10	CbId	int	cb.cb_id	int	Insert / Update
11	ClcLoadsAwarded	int	cb.clc_loads_awarded	int	Insert / Update
12	ClcLoadsNotRespondedTo	int	cb.clc_loads_not_responded_to	int	Insert / Update
13	ClcLoadsOffered	int	cb.clc_loads_offered	int	Insert / Update
14	ClcLoadsOnTime	int	cb.clc_loads_on_time	int	Insert / Update
15	ClcLoadsRespondedTo	int	cb.clc_loads_responded_to	int	Insert / Update
16	ClcRating	string	cb.clc_car_rating	varchar(12)	Insert / Update
17	Contact	string	cb.cb_contact	varchar(255)	Insert / Update
18	CreatedDate	DateTime	cb.cb_reply_date	datetime	Insert / Update
19	CreatedUser	string	cb.created_user	varchar(20)	Insert / Update
20	DataSourceID	String				Not mapped
21	DeadheadDispatchDatetime	DateTime	cb.deadhead_dispatch_datetime	datetime	Insert / Update
22	DeadheadDistance	double	cb.deadhead_distance	decimal	Insert / Update
23	DeadheadFlag	int	cb.deadhead_flag	int	Insert / Update
24	DeadheadOriginCity	string	cb.deadhead_origin_city	varchar(50)	Insert / Update
25	DeadheadStopStatus	string	cb.deadhead_stop_status	varchar(6)	Insert / Update
26	DispatchNote	string	cb.cb_dispatch_note	varchar(255)	Insert / Update
27	DriverName	string	cb.cb_driver_name	varchar(255)	Insert / Update
28	DriverPhone	string	cb.cb_driver_phone	varchar(25)	Insert / Update
29	Duplicate	string	cb.cb_duplicate	char(1)	Insert / Update
30	EmailConfirmationFlag	bool	cb.cb_email_confirmation_flag	char(1)	Insert / Update
31	Fax	string	cb.cb_fax	varchar(25)	Insert / Update
32	FaxConfirmationFlag	bool	cb.cb_fax_confirmation_flag	char(1)	Insert / Update
33	IsDirty	bool				Not mapped
34	IsNew	bool				Not mapped
35	IsValid	bool				Not mapped
36	LaneName	string	cb.cb_lanename	varchar(50)	Insert / Update
37	LghBookedRevtype1	string	cb.lgh_booked_revtype1	varchar(12)	Insert / Update
38	LoadAwarded	int	cb.car_loads_awarded	int	Insert / Update
39	LoadOffered	int	cb.car_loads_offered	int	Insert / Update
40	LoadRequirement	string	cb.cb_load_requirement	char(1)	Insert / Update
41	LoadRespondedTo	int	cb.car_loads_responded_to	int	Insert / Update
42	LoadsNotRespondedTo	int	cb.car_loads_not_responded_to	int	Insert / Update
43	LoadsOnTime	int	cb.car_loads_on_time	int	Insert / Update
44	Margin	double			Read Only	Not mapped
45	ModifiedDate	DateTime	cb.modified_date	datetime	Insert / Update
46	ModifiedUser	string	cb.modified_user	varchar(20)	Insert / Update
47	MoveDerivedDataUpdated	string	cb.cb_move_derive_data_updated	char(1)	Insert / Update
48	OrdBookedRevtype1	string	cb.ord_booked_revtype1	varchar(12)	Insert / Update
49	Phone	string	cb.cb_phone	varchar(25)	Insert / Update
50	PringConfirmationFlag	bool	cb.cb_print_confirmation_flag	char(1)	Insert / Update
51	Rating	string	cb.car_rating	varchar(12)	Insert / Update
52	ReplyAmount	double	cb.cb_reply_amount	money	Insert / Update
53	ReplyCounterAmount	double	cb.cb_reply_counter_amount	money	Insert / Update
54	ReplyCounterDate	DateTime	cb.cb_reply_counter_date	datetime	Insert / Update
55	ReplyDate	DateTime	cb.cb_reply_date	datetime	Insert / Update
56	ReplyExpires	DateTime	cb.cb_reply_expires	datetime	Insert / Update
57	ReplyFuelAmount	double	cb.cb_reply_fuelamount	money	Insert / Update
58	ReplyLineHaul	double	cb.cb_reply_linehaul	money	Insert / Update
59	ReplyMessage	string	cb.cb_reply_message	varchar(2000)	Insert / Update
60	ReplyOtherAmount	double	cb.cb_reply_otheramount	money	Insert / Update
61	ReplyReasonCode	string	cb.cb_reply_reason_code	varchar(6)	Insert / Update
62	ReplyStatus	string	cb.cb_reply_status	varchar(6)	Insert / Update
63	SentByApplication	string	cb.cb_sent_by_application	varchar(20)	Insert / Update
64	SentByUser	string	cb.cb_sent_by_user	varchar(20)	Insert / Update
65	SentDate	DateTime	cb.cb_sent_date	datetime	Insert / Update
66	SentEmail	string	cb.cb_sent_email	varchar(255)	Insert / Update
67	SentEmailTemplate	int	cb.cb_sent_email_template	int	Insert / Update
68	SentExperies	DateTime	cb.cb_sent_expires	datetime	Insert / Update
69	SentMessage	string	cb.cb_sent_message	varchar(2000)	Insert / Update
70	SentSequence	int	cb.cb_sent_sequence	int	Insert / Update
71	SentStatus	string	cb.cb_sent_status	varchar(6)	Insert / Update
72	SentTimePeriod	int	cb.cb_sent_time_period	int	Insert / Update
73	SpecificCity	int	cb.cb_specificity	int	Insert / Update
74	TrailerNumber	string	cb.cb_trailernumber	varchar(50)	Insert / Update
75	TruckMcNum	string	cb.cb_truck_mcnum	varchar(25)	Insert / Update
76	UpdateableProperties	CarrierBidsUpdateInfo			Insert / Update

Property

Database Column

Modifiable

Comments

Name

Data Type (in C#)

Name

Data Type

1

AwardApplication

string

cb.cb_award_application

varchar(20)

Insert / Update

2

AwardDateTime

DateTime

cb.cb_award_datetime

datetime

Insert / Update

3

AwardStatus

string

cb.cb_award_status

varchar(6)

Insert / Update

4

AwardUser

string

cb.cb_award_user

varchar(20)

Insert / Update

5

CaId

int

cb.ca_id

int

Insert / Update

6

CarId

string

cb.car_id

varchar(8)

Insert / Update

7

CarrierID

string

cb.car_id

varchar(8)

Insert / Update

8

CarrierLaneCommitmentId

int

cb.carrierlanecommitmentid

int

Insert / Update

9

CarrierName

string

Not mapped

10

CbId

int

cb.cb_id

int

Insert / Update

11

ClcLoadsAwarded

int

cb.clc_loads_awarded

int

Insert / Update

12

ClcLoadsNotRespondedTo

int

cb.clc_loads_not_responded_to

int

Insert / Update

13

ClcLoadsOffered

int

cb.clc_loads_offered

int

Insert / Update

14

ClcLoadsOnTime

int

cb.clc_loads_on_time

int

Insert / Update

15

ClcLoadsRespondedTo

int

cb.clc_loads_responded_to

int

Insert / Update

16

ClcRating

string

cb.clc_car_rating

varchar(12)

Insert / Update

17

Contact

string

cb.cb_contact

varchar(255)

Insert / Update

18

CreatedDate

DateTime

cb.cb_reply_date

datetime

Insert / Update

19

CreatedUser

string

cb.created_user

varchar(20)

Insert / Update

20

DataSourceID

String

Not mapped

21

DeadheadDispatchDatetime

DateTime

cb.deadhead_dispatch_datetime

datetime

Insert / Update

22

DeadheadDistance

double

cb.deadhead_distance

decimal

Insert / Update

23

DeadheadFlag

int

cb.deadhead_flag

int

Insert / Update

24

DeadheadOriginCity

string

cb.deadhead_origin_city

varchar(50)

Insert / Update

25

DeadheadStopStatus

string

cb.deadhead_stop_status

varchar(6)

Insert / Update

26

DispatchNote

string

cb.cb_dispatch_note

varchar(255)

Insert / Update

27

DriverName

string

cb.cb_driver_name

varchar(255)

Insert / Update

28

DriverPhone

string

cb.cb_driver_phone

varchar(25)

Insert / Update

29

Duplicate

string

cb.cb_duplicate

char(1)

Insert / Update

30

EmailConfirmationFlag

bool

cb.cb_email_confirmation_flag

char(1)

Insert / Update

31

Fax

string

cb.cb_fax

varchar(25)

Insert / Update

32

FaxConfirmationFlag

bool

cb.cb_fax_confirmation_flag

char(1)

Insert / Update

33

IsDirty

bool

Not mapped

34

IsNew

bool

Not mapped

35

IsValid

bool

Not mapped

36

LaneName

string

cb.cb_lanename

varchar(50)

Insert / Update

37

LghBookedRevtype1

string

cb.lgh_booked_revtype1

varchar(12)

Insert / Update

38

LoadAwarded

int

cb.car_loads_awarded

int

Insert / Update

39

LoadOffered

int

cb.car_loads_offered

int

Insert / Update

40

LoadRequirement

string

cb.cb_load_requirement

char(1)

Insert / Update

41

LoadRespondedTo

int

cb.car_loads_responded_to

int

Insert / Update

42

LoadsNotRespondedTo

int

cb.car_loads_not_responded_to

int

Insert / Update

43

LoadsOnTime

int

cb.car_loads_on_time

int

Insert / Update

44

Margin

double

Read Only

Not mapped

45

ModifiedDate

DateTime

cb.modified_date

datetime

Insert / Update

46

ModifiedUser

string

cb.modified_user

varchar(20)

Insert / Update

47

MoveDerivedDataUpdated

string

cb.cb_move_derive_data_updated

char(1)

Insert / Update

48

OrdBookedRevtype1

string

cb.ord_booked_revtype1

varchar(12)

Insert / Update

49

Phone

string

cb.cb_phone

varchar(25)

Insert / Update

50

PringConfirmationFlag

bool

cb.cb_print_confirmation_flag

char(1)

Insert / Update

51

Rating

string

cb.car_rating

varchar(12)

Insert / Update

52

ReplyAmount

double

cb.cb_reply_amount

money

Insert / Update

53

ReplyCounterAmount

double

cb.cb_reply_counter_amount

money

Insert / Update

54

ReplyCounterDate

DateTime

cb.cb_reply_counter_date

datetime

Insert / Update

55

ReplyDate

DateTime

cb.cb_reply_date

datetime

Insert / Update

56

ReplyExpires

DateTime

cb.cb_reply_expires

datetime

Insert / Update

57

ReplyFuelAmount

double

cb.cb_reply_fuelamount

money

Insert / Update

58

ReplyLineHaul

double

cb.cb_reply_linehaul

money

Insert / Update

59

ReplyMessage

string

cb.cb_reply_message

varchar(2000)

Insert / Update

60

ReplyOtherAmount

double

cb.cb_reply_otheramount

money

Insert / Update

61

ReplyReasonCode

string

cb.cb_reply_reason_code

varchar(6)

Insert / Update

62

ReplyStatus

string

cb.cb_reply_status

varchar(6)

Insert / Update

63

SentByApplication

string

cb.cb_sent_by_application

varchar(20)

Insert / Update

64

SentByUser

string

cb.cb_sent_by_user

varchar(20)

Insert / Update

65

SentDate

DateTime

cb.cb_sent_date

datetime

Insert / Update

66

SentEmail

string

cb.cb_sent_email

varchar(255)

Insert / Update

67

SentEmailTemplate

int

cb.cb_sent_email_template

int

Insert / Update

68

SentExperies

DateTime

cb.cb_sent_expires

datetime

Insert / Update

69

SentMessage

string

cb.cb_sent_message

varchar(2000)

Insert / Update

70

SentSequence

int

cb.cb_sent_sequence

int

Insert / Update

71

SentStatus

string

cb.cb_sent_status

varchar(6)

Insert / Update

72

SentTimePeriod

int

cb.cb_sent_time_period

int

Insert / Update

73

SpecificCity

int

cb.cb_specificity

int

Insert / Update

74

TrailerNumber

string

cb.cb_trailernumber

varchar(50)

Insert / Update

75

TruckMcNum

string

cb.cb_truck_mcnum

varchar(25)

Insert / Update

76

UpdateableProperties

CarrierBidsUpdateInfo

Insert / Update

CarrierBid.ReturnObject

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

Property Name

Data Type (in C#)

Comments

1

ErrorMessages

List<string>

2

ErrorObjectIndexList

List<int>

3

Exceptions

List<Exception>

4

ReferenceObjects

List<CarrierBid>

5

ReturnCode

int

6

TraceMessages

List<string>

7

WarningMessages

List<string>

CarrierBid.PagedReturnObject

	Property Name	Data Type (in C#)
1	PageIndex	int
2	PageSize	int
3	TotalRecords	int

Property Name

Data Type (in C#)

Comments

1

PageIndex

int

2

PageSize

int

3

TotalRecords

int

CarrierBidsUpdateInfo object

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

	Property Name	Comments
1	AwardApplication
2	AwardDateTime
3	AwardStatus
4	AwardUser
5	CaId
6	CarId
7	CarrierID
8	CarrierLaneCommitmentId
9	CarrierName
10	ClcLoadsAwarded
11	ClcLoadsNotRespondedTo
12	ClcLoadsOffered
13	ClcLoadsOnTime
14	ClcLoadsRespondedTo
15	ClcRating
16	Contact
17	CreatedDate
18	CreatedUser
19	DeadheadDispatchDatetime
20	DeadheadDistance
21	DeadheadFlag
22	DeadheadOriginCity
23	DeadheadStopStatus
24	DispatchNote
25	DriverName
26	DriverPhone
27	Duplicate
28	EmailConfirmationFlag
29	Fax
30	FaxConfirmationFlag
31	LaneName
32	LghBookedRevtype1
33	LoadAwarded
34	LoadOffered
35	LoadRequirement
36	LoadRespondedTo
37	LoadsNotRespondedTo
38	LoadsOnTime
39	ModifiedDate
40	ModifiedUser
41	MoveDerivedDataUpdated
42	OrdBookedRevtype1
43	Phone
44	PringConfirmationFlag
45	Rating
46	ReplyAmount
47	ReplyCounterAmount
48	ReplyCounterDate
49	ReplyDate
50	ReplyExpires
51	ReplyFuelAmount
52	ReplyLineHaul
53	ReplyMessage
54	ReplyOtherAmount
55	ReplyReasonCode
56	ReplyStatus
57	SentByApplication
58	SentByUser
59	SentDate
60	SentEmail
61	SentEmailTemplate
62	SentExperies
63	SentMessage
64	SentSequence
65	SentStatus
66	SentTimePeriod
67	SpecificCity
68	TrailerNumber
69	TruckMcNum

Criteria object

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

cb = carrierbids

	Name	Database Column	Data Type (in C#)	Comments
1	Ascending		bool?	Not mapped
2	AwardApplication	cb.cb_award_application	string
3	AwardDateTime	cb.cb_award_datetime	DateTime?
4	AwardStatus	cb.cb_award_status	string
5	AwardUser	cb.cb_award_user	string
6	CaId	cb.ca_id	int?
7	CarId	cb.car_id	string
8	CarrierLaneCommitmentId	cb.carrierlanecommitmentid	int?
9	CbId	cb.cb_id	int?
10	ClcLoadsAwarded	cb.clc_loads_awarded	int?
11	ClcLoadsNotRespondedTo	cb.clc_loads_not_responded_to	int?
12	ClcLoadsOffered	cb.clc_loads_offered	int?
13	ClcLoadsOnTime	cb.clc_loads_on_time	int?
14	ClcLoadsRespondedTo	cb.clc_loads_responded_to	int?
15	ClcRating	cb.clc_car_rating	string
16	Contact	cb.cb_contact	string
17	CreatedDate	cb.cb_reply_date	DateTime?
18	CreatedUser	cb.created_user	string
19	DriverName	cb.cb_driver_name	string
20	Duplicate	cb.cb_duplicate	string
21	Expressions		List<CriteriaExpression>
22	Fax	cb.cb_fax	string
23	LaneName	cb.cb_lanename	string
24	LoadAwarded	cb.car_loads_awarded	int?
25	LoadOffered	cb.car_loads_offered	int?
26	LoadRequirement	cb.cb_load_requirement	string
27	LoadRespondedTo	cb.car_loads_responded_to	int?
28	LoadsNotRespondedTo	cb.car_loads_not_responded_to	int?
29	LoadsOnTime	cb.car_loads_on_time	int?
30	ModifiedDate	cb.modified_date	DateTime?
31	ModifiedUser	cb.modified_user	string
32	MoveDerivedDataUpdated	cb.cb_move_derive_data_updated	string
33	PagingData		PagingData	Not mapped
34	Phone	cb.cb_phone	string
35	Rating	cb.car_rating	string
36	ReplyAmount	cb.cb_reply_amount	double?
37	ReplyDate	cb.cb_reply_date	DateTime?
38	ReplyExpires	cb.cb_reply_expires	DateTime?
39	ReplyLineHaul	cb.cb_reply_linehaul	double?
40	ReplyMessage	cb.cb_reply_message	string
41	ReplyReasonCode	cb.cb_reply_reason_code	string
42	ReplyStatus	cb.cb_reply_status	string
43	SentByApplication	cb.cb_sent_by_application	string
44	SentByUser	cb.cb_sent_by_user	string
45	SentDate	cb.cb_sent_date	DateTime?
46	SentEmail	cb.cb_sent_email	string
47	SentEmailTemplate	cb.cb_sent_email_template	int?
48	SentExperies	cb.cb_sent_expires	DateTime?
49	SentMessage	cb.cb_sent_message	string
50	SentSequence	cb.cb_sent_sequence	int?
51	SentStatus	cb.cb_sent_status	string
52	SentTimePeriod	cb.cb_sent_time_period	int?
53	Settings		CriteriaSettings
54	SortBy		string	Not mapped
55	SpecificCity	cb.cb_specificity	int?
56	TrailerNumber	cb.cb_trailernumber	string

Name

Database Column

Data Type (in C#)

Comments

1

Ascending

bool?

Not mapped

2

AwardApplication

cb.cb_award_application

string

3

AwardDateTime

cb.cb_award_datetime

DateTime?

4

AwardStatus

cb.cb_award_status

string

5

AwardUser

cb.cb_award_user

string

6

CaId

cb.ca_id

int?

7

CarId

cb.car_id

string

8

CarrierLaneCommitmentId

cb.carrierlanecommitmentid

int?

9

CbId

cb.cb_id

int?

10

ClcLoadsAwarded

cb.clc_loads_awarded

int?

11

ClcLoadsNotRespondedTo

cb.clc_loads_not_responded_to

int?

12

ClcLoadsOffered

cb.clc_loads_offered

int?

13

ClcLoadsOnTime

cb.clc_loads_on_time

int?

14

ClcLoadsRespondedTo

cb.clc_loads_responded_to

int?

15

ClcRating

cb.clc_car_rating

string

16

Contact

cb.cb_contact

string

17

CreatedDate

cb.cb_reply_date

DateTime?

18

CreatedUser

cb.created_user

string

19

DriverName

cb.cb_driver_name

string

20

Duplicate

cb.cb_duplicate

string

21

Expressions

List<CriteriaExpression>

22

Fax

cb.cb_fax

string

23

LaneName

cb.cb_lanename

string

24

LoadAwarded

cb.car_loads_awarded

int?

25

LoadOffered

cb.car_loads_offered

int?

26

LoadRequirement

cb.cb_load_requirement

string

27

LoadRespondedTo

cb.car_loads_responded_to

int?

28

LoadsNotRespondedTo

cb.car_loads_not_responded_to

int?

29

LoadsOnTime

cb.car_loads_on_time

int?

30

ModifiedDate

cb.modified_date

DateTime?

31

ModifiedUser

cb.modified_user

string

32

MoveDerivedDataUpdated

cb.cb_move_derive_data_updated

string

33

PagingData

Not mapped

34

Phone

cb.cb_phone

string

35

Rating

cb.car_rating

string

36

ReplyAmount

cb.cb_reply_amount

double?

37

ReplyDate

cb.cb_reply_date

DateTime?

38

ReplyExpires

cb.cb_reply_expires

DateTime?

39

ReplyLineHaul

cb.cb_reply_linehaul

double?

40

ReplyMessage

cb.cb_reply_message

string

41

ReplyReasonCode

cb.cb_reply_reason_code

string

42

ReplyStatus

cb.cb_reply_status

string

43

SentByApplication

cb.cb_sent_by_application

string

44

SentByUser

cb.cb_sent_by_user

string

45

SentDate

cb.cb_sent_date

DateTime?

46

SentEmail

cb.cb_sent_email

string

47

SentEmailTemplate

cb.cb_sent_email_template

int?

48

SentExperies

cb.cb_sent_expires

DateTime?

49

SentMessage

cb.cb_sent_message

string

50

SentSequence

cb.cb_sent_sequence

int?

51

SentStatus

cb.cb_sent_status

string

52

SentTimePeriod

cb.cb_sent_time_period

int?

53

Settings

CriteriaSettings

54

SortBy

string

Not mapped

55

SpecificCity

cb.cb_specificity

int?

56

TrailerNumber

cb.cb_trailernumber

string

CriteriaSettings object

	Name	Comments
1	AwardApplication
2	AwardDateTime
3	AwardStatus
4	AwardUser
5	CaId
6	CarId
7	CarrierLaneCommitmentId
8	CbId
9	ClcLoadsAwarded
10	ClcLoadsNotRespondedTo
11	ClcLoadsOffered
12	ClcLoadsOnTime
13	ClcLoadsRespondedTo
14	ClcRating
15	Contact
16	CreatedDate
17	CreatedUser
18	DriverName
19	Duplicate
20	Fax
21	LaneName
22	LoadAwarded
23	LoadOffered
24	LoadRequirement
25	LoadRespondedTo
26	LoadsNotRespondedTo
27	LoadsOnTime
28	ModifiedDate
29	ModifiedUser
30	MoveDerivedDataUpdated
31	Phone
32	Rating
33	ReplyAmount
34	ReplyDate
35	ReplyExpires
36	ReplyLineHaul
37	ReplyMessage
38	ReplyReasonCode
39	ReplyStatus
40	SentByApplication
41	SentByUser
42	SentDate
43	SentEmail
44	SentEmailTemplate
45	SentExperies
46	SentMessage
47	SentSequence
48	SentStatus
49	SentTimePeriod
50	SpecificCity
51	TrailerNumber

CriteriaExpression object

	Name	Data Type (in C#)	Comments
1	Conjuction	CriteriaSetting.ConjuctionEnum
2	Criteria	Criteria

Name

Data Type (in C#)

Comments

1

Conjuction

CriteriaSetting.ConjuctionEnum

2

Criteria