User-defined Categories
Field Name |
Caption |
Mask |
Description |
Field Type |
CT_AC_ID |
Account Number Rec # |
|
Long Integer |
|
CT_ACCTNO |
Account # |
45x |
Account Number |
Text |
CT_AREA_CD |
Area Code |
10x |
Area Code |
String |
CT_AREA_TY |
Area Description |
40x |
Area Description |
String |
CT_BR_CD |
Category |
10x |
Category |
Text |
CT_BR_TY |
Category Text |
60x |
Category Text |
Text |
CT_CLAS_ID |
Category Class |
nnnnnnnn |
Long Integer |
|
CT_CLASSCD |
|
|
Classification |
Integer |
CT_CLASSTY |
|
25x |
Classification Text |
Text |
CT_CRT_BY |
Created By |
25x |
Created By |
Text |
CT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CT_DEPT_CD |
Department |
10x |
Department |
String |
CT_DEPT_TY |
Department Text |
50x |
Department Text |
String |
CT_DIV_CD |
Division Code |
10x |
Division Code |
String |
CT_DIV_TY |
Division Description |
40x |
Division Description |
String |
CT_EA_ID |
|
|
Long Integer |
|
CT_EP_ID |
|
|
Long Integer |
|
CT_EQPT_ID |
|
|
Link to CMEQTGRP |
Long Integer |
CT_GISRQRT |
GIS Request Report |
25x |
GIS Request Report |
Text |
CT_GISWORT |
GIS Work Report |
25x |
GIS Work Report |
Text |
CT_ID |
Category Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
CT_IMG_FLG |
|
|
Image Available (Not Used) |
Boolean |
CT_INVID |
Inventory Type ID |
nnnnnnnn |
Link to WKCATINV.CI_ID - Lucity System Category |
Long Integer |
CT_LEVEL |
|
|
Level number in the tree control. |
Integer |
CT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CT_MOV_FLG |
|
|
Movie Available (Not Used) |
Boolean |
CT_NAME |
Branch Name |
60x |
Branch Name |
Text |
CT_OID |
|
|
Visual CE Linking Field |
Long Integer |
CT_PARENT |
Link to previous lev |
nnnnnnnn |
ID number of parent category in the tree control |
Long Integer |
CT_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
CT_RASSET_FLG |
|
|
Require Asset to Close WO when WO has this Category if set to TRUE |
Boolean |
CT_REMP_FLG |
|
|
Require at least one Employee Resource Record exists and that all Employee Resource Records have Grant Total Units > 0 to Close WO when WO has this Category if set to TRUE |
Boolean |
CT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CT_RWT_FLG |
|
|
If set to TRUE, When in Request and the Create WO button is selected, then prompt user to display WO Templates that can be selected |
Boolean |
CT_SAREACD |
Sub-Area Code |
10x |
Sub-Area Code |
String |
CT_SAREATY |
Sub-Area Description |
40x |
Sub-Area Description |
String |
CT_SDIV_CD |
SubDivision Code |
10x |
SubDivision Code |
String |
CT_SDIV_TY |
SubDivision Description |
40x |
SubDivision Description |
String |
CT_UOM_CD |
UOM Type |
nnn |
Unit of Measure (1 - Count, 2 - Sum) |
Integer |
CT_UOM_TY |
UOM Type Text |
25x |
Unit of Measure Type |
Text |
CT_UOMF |
UOM Field |
30x |
Unit of Measure Field (if CI_UOMT is not Count) |
Text |
CT_WO_FLG |
Not Allowed in Wos |
|
Category Not to be used in a WO |
Boolean |
CT_WOUOMCD |
Unit of Measure |
5x |
WO Unit of Measure |
Text |
CT_WOUOMTY |
Unit of Measure Text |
25x |
WO Unit of Measure Type |
Text |