JContFax
JContFax contains information about the fax numbers in a contact record. This information includes the number itself, fax type (such as Home or Business), and contact record to which each number belongs. This table represents the Fax Numbers block on the General tab of a contact record.
Object: JContFax (J_CONT_FAX)
|
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
|---|---|---|---|---|---|---|---|
|
owner--> |
CONTACT_ID (NUMBER) |
x |
x |
object |
8 The contact to which the fax number belongs. --> Links to specific information about the contact record. |
||
|
number Before TeamConnect 3.3 SP2: faxString |
FAX_STRING (VARCHAR2) (50) |
Number |
x |
string (50) |
The actual fax number. |
||
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the fax number record. |
|||
|
typeID--> |
TYPE_ID (NUMBER) |
Type |
x |
x |
object |
8 The type of the fax number. --> Links to definition information for the fax type. |
|
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the fax number was updated. |
LContFaxType
LContFaxType contains information about the fax types defined for contact fax numbers including the name of the fax type, tree position, and display order. This table represents the Fax Type system lookup table.
Object: LContFaxType (L_CONT_FAX_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 fax type. |
||
|
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the fax type list item. |
|||
|
treePosition |
TREE_ |
Tree Position |
x |
string (250) |
The unique four- character alphanumeric code that is created when the fax type is defined. |
||
|
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the fax type list item was updated. |