JContInetAddress
This information includes the address itself, internet address type (such as Personal or Business), and contact record to which each address belongs. This table represents the Internet Addresses block on the General tab of a contact record.
Object: JContInetAddress (J_CONT_INET_ADDRESS)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
|---|---|---|---|---|---|---|---|
|
url Before TeamConnect 3.3 SP2: |
INET_ADDRESS_STRING (VARCHAR2) (250) |
Address |
x |
string (250) |
The actual internet address. |
||
|
owner--> |
CONTACT_ID (NUMBER) |
x |
x |
object |
8 The contact to which the internet address belongs. --> Links to specific information for the contact record. |
||
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the internet address record. |
|||
|
type--> |
TYPE_ID (NUMBER) |
Type |
x |
x |
object |
8 The type of the internet address. --> Links to definition information for the internet address type. |
|
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the internet address was updated. |
LContInetAddressType
LContInetAddressType contains information about the internet address types defined for contact internet addresses. This information includes the name of the internet address type, tree position, and display order. This table represents the Internet Address Type system lookup table.
Object: LContInetAddressType (L_CONT_INET_ADDRESS_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 ) |
||||||
|
displayOrder |
DISPLAY_ |
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 internet address type. |
||
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the internet address type list item. |
|||
|
treePosition |
TREE_ |
Tree Position |
x |
string (250) |
The unique four-character alphanumeric code that is created when the internet address type is defined. |
||
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the internet address type list item was updated. |