Show/Hide Toolbars

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

 

MAIL

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