JContEmail
This information includes the address itself, email address type (such as Personal or Business), and contact record to which each email address belongs. This table represents the Email Addresses block on the General tab of a contact record.
Object: JContEmail (J_CONT_EMAIL)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
|---|---|---|---|---|---|---|---|
|
address Before TeamConnect 3.3 SP2: emailString |
EMAIL_STRING (VARCHAR20) (250) |
|
x |
string (250) |
The actual email address. |
||
|
owner--> |
CONTACT_ID (NUMBER) |
x |
x |
object |
8 The contact to which the email address belongs. --> Links to specific information for the contact record. |
||
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x
|
int |
The unique ID of the email address record. |
|||
|
type--> |
TYPE_ID (NUMBER) |
Type |
x
|
x |
object |
8 The type of the email address. --> Links to definition information for the email address type. |
|
|
version |
VERSION (NUMBER) |
x
|
int |
Indicates how many times the email address was updated. |
LContEmailType
LContEmailType contains information about the email types defined for contact email addresses. This information includes the name of the email type, tree position, and display order. This table represents the Email Type system lookup table.
Object: LContEmailType (L_CONT_EMAIL_TYPE)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
|---|---|---|---|---|---|---|---|
|
childList--> |
n/a |
Do not apply. These lookup items cannot have a hierarchical structure. |
|||||
|
parent--> |
PARENT_ID (NUMBER) |
||||||
|
display Order |
DISPLAY_ORDER (NUMBER) |
Order |
x |
int |
The order in which the table items will be listed in the GUI, lowest number first. |
||
| isActive | IS_ACTIVE | boolean | |||||
|
name |
NAME (VARCHAR2) (50) |
Item Name |
x
|
string (50) |
The name of the email type. |
||
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x
|
int |
The unique ID of the email type list item. |
|||
|
treePosition |
TREE_POSITION (VARCHAR20) (250) |
Tree Position |
x |
string (250) |
The unique four- character alphanumeric code that is created when the email type is defined. |
||
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the email type list item was updated. |