System lookup tables are provided with TeamConnect by default for use with specific system objects. You can also create custom lookup tables, as described in Creating Custom Pages.
The following table lists TeamConnect's system lookup tables and their location in the end-user interface. It also indicates which tables can have a hierarchical tree structure.
System Lookup Table Information
Table Name |
Object Record |
System Block |
Field Name |
Tree Structure |
Unique Code |
Table Name in object model |
Activity Item |
Task |
General |
Activity |
|
ACTI |
LTaskActivityItem |
Invoice |
Line items/Expanded View |
Activity |
|
ACTI |
LTaskActivityItem |
|
Address Type |
Contact |
General |
Type |
|
ADDR |
LContAddressType |
Area Item |
Appointment |
General |
Area |
x |
AREA |
LApptAreaItem |
Contact Relation Type |
Contact |
Relations |
Type of relationship |
|
CONR |
LContRelationType |
Involved |
Relations |
Type of relationship |
|
CONR |
LContRelationType |
|
Country Item |
Contact |
General |
Country |
|
COUN |
LCountryItem |
Email Type |
Contact |
General |
Type |
|
LContEmailType |
|
Fax Type |
Contact |
General |
Type |
|
FAXX |
LContFaxType |
Internet Address Type |
Contact |
General |
Type |
|
INET |
LContInetAddressType |
Integration Message Queue |
This lookup table is deprecated. It provides backward compatibility for existing Integration Message Queue rules. |
MESQ |
LMessageQueueItem |
|||
Invoice Rejection Reason |
Invoice |
My Approvals pop-up screen |
Reason for Reject |
|
INRR |
LApphRejectReason |
Phone Type |
Contact |
General |
Type |
|
PHON |
LContPhoneType |
Project Relation Type |
Project |
Relations |
Type of relationship |
|
PRJR |
LProjRelationType |
Resource Type |
Appointment |
Resources |
Resource |
|
RESO |
LApptResourceType |
Skill Type |
Contact |
Skills |
Type |
x |
SKIL |
LContSkillType |
State Type |
Contact |
General |
State/Province |
x |
STAT |
LContState |
Territory Type |
Contact |
Territories |
Territory |
x |
TERR |
LContTerritoryType |
