Contact object

Contact properties and column mapping

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

c = companyemail
Property Database Column

Name

Data Type (in C#)

Name

Data Type

Modifiable

Comments

1

Address1

string

c.ce_address1

varchar(100)

Insert/Update

2

Address2

string

c.ce_address2

varchar(100)

Insert/Update

3

Address3

string

c.ce_address3

varchar(100)

Insert/Update

4

Branch

string

c.ce_branch

varchar(12)

Insert/Update

5

City

string

Insert/Update

6

CityCode

int

c.ce_cty_code

int

Insert/Update

7

Comment

string

c.ce_comment

varchar(256)

Insert/Update

8

ContactId

int

c.ce_id

int

Insert/Update

9

DatasourceID

string

N/A

Not mapped

10

EdiActive

bool

Insert/Update

Not mapped

11

EmailAddress

string

c.email_address

varchar(300)

Insert/Update

12

FaxNumber

string

c.ce_faxnumber

varchar(20)

Insert/Update

13

FirstName

string

c.ce_fname

varchar(40)

Insert/Update

14

HoursOfOperation

string

c.ce_hours_of_operation

varchar(100)

Insert/Update

Removed from versions 2014.3.0 SP9 and newer

15

IsAfterHours

bool

c.ce_after_hours

char(1)

Insert/Update

Removed from versions 2014.3.0 SP9 and newer

16

IsDefaultContact

bool

c.ce_defaultcontact

char(1)

Insert/Update

17

IsDirty

bool

N/A

Not mapped or used in service

18

IsNew

bool

N/A

Not mapped, set to false during save to update

19

IsValid

bool

N/A

Not mapped or used in service

20

JobTitle

string

c.ce_title

varchar(30)

Insert/Update

21

LoadTimeStamp

DateTime

Insert-Update

Not mapped

Removed from versions 2014.3.0 SP9 and newer

22

MailingAddress1

string

c.ce_mail_address1

varchar(100)

Insert/Update

23

MailingAddress2

string

c.ce_mail_address2

varchar(100)

Insert/Update

24

MailingAddress3

string

c.ce_mail_address3

varchar(100)

Insert/Update

25

MailingCity

string

Insert/Update

26

MailingCityCode

int

c.ce_mail_cty_code

int

Insert/Update

27

MailingState

string

Read only

Not mapped

28

MailingZip

string

c.ce_mail_zip

varchar(10)

Insert/Update

29

MobilePhone

string

c.ce_mobilenumber

varchar(20)

Insert/Update

30

Name

string

c.contact_name

varchar(40)

Insert/Update

31

OwnerId

string

c.cmp_id

varchar(8)

Insert/Update

32

OwnerType

string

c.ce_source

varchar(6)

Insert/Update

33

Phone1

string

c.ce_phone1

varchar(20)

Insert/Update

34

Phone1Ext

string

c.ce_phone1_ext

varchar(6)

Insert/Update

35

Phone2

string

c.ce_phone2

varchar(20)

Insert/Update

36

Phone2Ext

string

c.ce_phone2_ext

varchar(6)

Insert/Update

37

Retired

bool

c.ce_retired

char(1)

Insert/Update

38

State

string

Read only

Not mapped

39

TimeStampRepoKey

string

Read only

Not mapped

Removed from versions 2014.3.0 SP9 and newer

40

Type

string

c.type

varchar(6)

Insert/Update

41

UpdateableProperties

ContactUpdateInfo

N/A

Not mapped

42

UpdateDate

DateTime

c.ce_updatedt

datetime

Read only

43

UpdatedBy

string

c.ce_updatedby

varchar(20)

Read only

44

Zip

string

c.ce_zip

varchar(10)

Insert/Update

Contact.ReturnObject

Property Name Data Type (in C#) Comments

1

ErrorMessages

List<string>

2

ErrorObjectIndexList

List<int>

3

Exceptions

List<Exception>

4

ReferenceObjects

List<Contact>

5

ReturnCode

int

6

TraceMessages

List<string>

7

WarningMessages

List<string>

ContactUpdateInfo object

  • Data types (in C#) for all properties are bool.

  • Set the property to true to update the corresponding City property.

Property Name Comments

1

Address1

2

Address2

3

Address3

4

Branch

5

City

6

CityCode

7

Comment

8

ContactId

9

EdiActive

10

EmailAddress

11

FaxNumber

12

FirstName

13

HoursOfOperation

Removed from versions 2014.3.0 SP9 and newer

14

IsAfterHours

Removed from versions 2014.3.0 SP9 and newer

15

IsDefaultContact

16

JobTitle

17

LoadTimeStamp

Removed from versions 2014.3.0 SP9 and newer

18

MailingAddress1

19

MailingAddress2

20

MailingAddress3

21

MailingCity

22

MailingCityCode

23

MailingZip

24

MobilePhone

25

Name

26

OwnerId

27

OwnerType

28

Phone1

29

Phone1Ext

30

Phone2

31

Phone2Ext

32

Retired

33

Type

34

Zip

Contact Criteria object

The Criteria Object exists but its use has not been implemented.
Name Database Column Data Type (in C#) Comments

1

Address1

string

2

Address2

string

3

Address3

string

4

Branch

string

5

City

string

6

CityCode

int?

7

Comment

string

8

ContactId

int?

9

EdiActive

bool?

10

EmailAddress

string

11

FaxNumber

string

12

FirstName

string

13

IsDefaultContact

bool?

14

JobTitle

string

15

MailingAddress1

string

16

MailingAddress2

string

17

MailingAddress3

string

18

MailingCity

string

19

MailingCityCode

int?

20

MailingState

string

21

MailingZip

string

22

MobilePhone

string

23

Name

string

24

OwnerId

string

25

OwnerType

string

26

Phone1

string

27

Phone1Ext

string

28

Phone2

string

29

Phone2Ext

string

30

State

string

31

Type

string

32

UpdateDate

DateTime?

33

UpdatedBy

string

34

Zip

string