cust

cust_id

string40

Y

N

Identify customer/vendor. Not an ID in case this should conform to another system’s coding (e.g., ERP or accounting).

cust_name

string80

N

N

Business or individual’s name

address1

string80

N

N

1st address line

address2

string80

N

Y

2nd address line

city

string80

N

N

City

state

string40

N

Y

State or province; nullable for tiny countries with no subdivisions

zip

string40

N

Y

Postal code

country

string40

N

Y

Nullable as there may be an obvious default

phone

string40

N

Y

Telephone number

fax

string40

N

Y

Facsimile number

email

string80

N

Y

E-mail address

customer

logical

N

N

May new sales orders be attributed to this customer? Default = Yes.

vendor

logical

N

N

May new purchase orders be attributed to this vendor? Default = Yes.

spare1

string80

N

Y

Use defined by language term 548 for customer records and 689 for vendor records

spare2

string80

N

Y

Use defined by language term 549 for customer records and 699 for vendor records

spare3

string80

N

Y

Use defined by language term 550 for customer records and 747 for vendor records

spare4

string80

N

Y

Use defined by language term 551 for customer records and 762 for vendor 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