Each system object and each system lookup table has a four-character unique code. You will need to use these unique codes for certain tasks such as writing document template for Document Generator or writing automated qualifiers or actions for rules.
The following table lists the unique codes and database table names for system objects.
System Object |
Object Table Name |
Database Table Name |
Unique Code |
Account |
TAccount |
T_ACCOUNT |
ACCT |
Appointment |
TAppointment |
T_APPOINTMENT |
APPT |
Contact |
TContact |
T_CONTACT |
CONT |
Document |
TDocument |
T_DOCUMENT |
DOCU |
Expense |
TExpense |
T_EXPENSE |
EXPE |
History |
THistory |
T_HISTORY |
HIST |
Invoice |
TInvoice |
T_INVOICE |
INVC |
Invoice Line Item |
JInvcLineItem |
J_INVC_LINE_ITEM |
LNI$ |
Task |
TTask |
T_TASK |
TASK |
The following table lists the unique codes and database table names for all system lookup tables.
System Lookup Table |
Object Table Name |
Database Table Name |
Unique Code |
Activity Item |
LTaskActivityItem |
L_TASK_ACTIVITY_ITEM |
ACTI |
Address Type |
LContAddressType |
L_CONT_ADDRESS_TYPE |
ADDR |
Area Item |
LApptAreaItem |
L_APPT_AREA_ITEM |
AREA |
Contact Relation Type |
LContRelationType |
L_CONT_RELATION_TYPE |
CONR |
Country Item |
LCountryItem |
L_COUNTRY_ITEM |
COUN |
Currency Item |
LCurrencyItem |
L_CURRENCY_ITEM |
CURR |
Email Type |
LContEmailType |
L_CONT_EMAIL_TYPE |
|
Fax Type |
LContFaxType |
L_CONT_FAX_TYPE |
FAXX |
Internet Address Type |
LContInetAddressType |
L_CONT_INET_ADDRESS_TYPE |
INET |
Phone Type |
LContPhoneType |
L_CONT_PHONE_TYPE |
PHON |
Project Assignee Type |
LProjAssigneeType |
L_PROJ_ASSIGNEE_TYPE |
Unique code of the corresponding custom object definition. |
Project Relation Type |
LProjRelationType |
L_PROJ_RELATION_TYPE |
PRJR |
Resource Type |
LApptResourceType |
L_APPT_RESOURCE_TYPE |
RESO |
Skill Type |
LContSkillType |
L_CONT_SKILL_TYPE |
SKIL |
Territory Type |
LContTerritoryType |
L_CONT_TERRITORY_TYPE |
TERR |
