CLIENT table

CLIENT – This table stores the client information for a Track-IT pro database.

Ÿ      ID – The unique ID for a client. (PK)

Ÿ      REGION – A region ID that this client could belong to.

Ÿ      NAME – The unique name for a client.

Ÿ      ACR – The unique acronym for a client.

Ÿ      CONTACT – The contact name for the client.

Ÿ      EMAIL – The client’s email address.

Ÿ      ARCHIVE – "T" if flagged for archive "F" otherwise.

Ÿ      OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.

Ÿ      HIDE – "T" if the item should be hidden in client lists, "F" otherwise.

Ÿ      INTEGRATE – This field contains Quick Books link information, which is used internally by the software.