CONTACTTYPE
This table stores information about the type of a contact stored in the Contact table. Examples of contact types include Tenant, Owner, and Accounts Payable Clerk.
|
Column name |
Column data type |
Character length |
Description |
|---|---|---|---|
|
ContactTypeKey |
uniqueidentifier |
|
A unique primary key for the entity, an internal value |
|
ContactTypeID |
nvarchar |
100 |
A unique identifier for contact type |
|
Description |
nvarchar |
100 |
A text description for this entity. |
|
IsSystem |
tinyint |
|
Indicates if this is a system value delivered with the database |
|
DataSource |
tinyint |
|
0 = User data. Data created by IEE users. User data is not modified during an upgrade 1 = Static data. Data installed with IEE that cannot be overwritten. This data is crucial to the correct operation of IEE. Update, insert, or delete static data during an upgrade 2 = Default data. Data installed with IEE that can be overwritten. Default data is not updated or deleted during an upgrade. However, you can add new default data during an upgrade |
The CONTACTTYPE table references the following tables:
None
and is referenced by:
(Contact) -> (Contact)