cust_contact

cust_id

string40

Y

N

Identify customer

contact_id

int32

Y

N

Identify contact

contact _name

string80

N

N

Contact name

dept

string80

N

Y

Department in which contact works

phone

string40

N

Y

Contact’s phone number

fax

string40

N

Y

Contact’s facsimile number

email

string80

N

Y

Contact’s e-mail address

spare1

string80

N

Y

Use defined by language term 552 for customer contact records and 2168 for vendor contact records

spare2

string80

N

Y

Use defined by language term 553 for customer contact records and 2169 for vendor contact records

spare3

string80

N

Y

Use defined by language term 554 for customer contact records and 2185 for vendor contact records

spare4

string80

N

Y

Use defined by language term 555 for customer contact records and 2222 for vendor contact records

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail.