Classification Setup
Field Name |
Caption |
Mask |
Description |
Field Type |
CL_CLASSCD |
Classification |
20x |
Class Code: |
Text |
CL_CLASSTY |
Classification Text |
50x |
Class Description: |
Text |
CL_CRT_BY |
Created By |
25x |
Created By |
Text |
CL_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CL_DOC_FLG |
Document Available |
|
Document Flag: |
Boolean |
CL_ID |
Classification Rec # |
nnnnnnnn |
AutoID Number |
Long Integer |
CL_IMG_FLG |
|
|
Image Flag: |
Boolean |
CL_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CL_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CL_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CL_MOV_FLG |
|
|
Movie Flag: |
Boolean |
CL_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CL_TYPE_CD |
Class Type |
nnn |
Type Code - 1 - Staff, 2 - Equipment |
Integer |
CL_TYPE_TY |
Class Type Text |
25x |
Type Text |
Text |
CL_UNIT_C |
Hourly Rate |
nnn.nn |
Unit Cost |
Double |
CL_UOM_CD |
Unit of Measure |
5x |
Unit of Measure |
Text |
CL_UOM_TY |
Unit of Measure Text |
25x |
Unit of Measure Text |
Text |