T_ENT_CONT
|
Name |
Data Type |
Allows Null |
Description |
|
|---|---|---|---|---|
|
|
CONTId |
int |
No |
Auto-generated unique ID that identifies a contact |
|
|
CONTName |
nvarchar (255) |
Yes |
Not in use |
|
|
EmailId |
nvarchar (125) |
Yes |
Contact's e-mail |
|
|
CONTNumber |
nvarchar (100) |
Yes |
Not in use |
|
|
BillAddr |
nvarchar (510) |
Yes |
Not in use |
|
|
ShipAddr |
nvarchar (510) |
Yes |
Not in use |
|
|
BillAddrCity |
nvarchar (510) |
Yes |
Not in use |
|
|
ShipAddrCity |
nvarchar (510) |
Yes |
Not in use |
|
|
ShipAddrState |
nvarchar (510) |
Yes |
Not in use |
|
|
BillAddrState |
nvarchar (510) |
Yes |
Not in use |
|
|
BillAddrCountry |
nvarchar (510) |
Yes |
Not in use |
|
|
ShipAddrCountry |
nvarchar (510) |
Yes |
Not in use |
|
|
BillAddrZip |
nvarchar (40) |
Yes |
Not in use |
|
|
ShipAddrZip |
nvarchar (40) |
Yes |
Not in use |
|
|
CSTMRId |
int |
Yes |
Customer ID associated with this contact. Relates to T_CSTMR. |
|
|
IsCustomerAdmin |
bit |
No |
Not in use |
|
|
isEnabled |
bit |
No |
Indicates if the contact is enabled. |
|
|
ContUserId |
nvarchar (255) |
Yes |
Not in use |
|
|
ContPassword |
nvarchar (255) |
Yes |
Not in use |
|
|
ContOrgnization |
nvarchar (255) |
Yes |
Not in use |
|
|
RefId1 |
nvarchar (250) |
Yes |
Not in use |
|
|
RefId2 |
nvarchar (250) |
Yes |
Not in use |
|
|
IsUserRegistered |
bit |
Yes |
Indicates if contact is created during user registration |
|
|
CreateDateTime |
datetime |
No |
Contact create time |
|
|
LocaleId |
int |
Yes |
Contact locale ID |
|
|
PartnerId |
int |
No |
Not in use. |
|
|
FirstName |
nvarchar (255) |
Yes |
Contact’s first name |
|
|
LastName |
nvarchar (255) |
Yes |
Contact’s last name |
|
|
MiddleName |
nvarchar (255) |
Yes |
Contact’s middle name |
|
|
IsDefault |
bit |
No |
Specifies if this contact is default contact for the associated customer |
|
|
CreatedBy |
nvarchar (50) |
Yes |
User who created this contact |
