CUSTOMTEMPLATE – This table contains all Custom Field Templates.
Ÿ ID – The Unique ID for the Custom field template. (PK)
Ÿ LINKTYPE - The Type of object that the Custom Field Template is linked to. ( M = "Time Entry", X = "Actual Expense", G = "Group", P = "Project", T= "Task", C = "Client", N = "Region", I = "Receivable", E = "Employee", R = "Rate", O = "Overtime)
Ÿ TYPE – The field type of the Custom Field Template. (A = Alphanumeric, D = Date, M = Multiple Choice, N = Numeric, X = Single Choice)
Ÿ NAME – The name of the Custom Field Template.
Ÿ REQUIRED – "T" if the custom field is a required field, "F" otherwise.
Ÿ DESC – The description of the custom template.
Ÿ HIDE - "T" if the Custom Template is hidden from Custom Template lists, "F" otherwise.