CLIENT – This table stores the client information for a Track-IT pro database.
Ÿ ID – The unique ID for a client. (PK)
Ÿ NAME – The unique name for a client.
Ÿ ACR – The unique acronym for a client.
Ÿ CONTACT – The contact name for the client.
Ÿ REGION – A region ID that this client could belong to. (FK)
Ÿ 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.