Equipment Components
Field Name |
Caption |
Mask |
Description |
Field Type |
CM_COMMENT1 |
Long Note |
|
Long Note |
Memo |
CM_COMP_CD |
Component |
nnn |
Component |
Integer |
CM_COMP_TY |
Component Text |
25x |
Component Text |
Text |
CM_CRT_BY |
Created By |
25x |
Created By |
Text |
CM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CM_DESC |
Description |
50x |
Description |
Text |
CM_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
CM_GE_ID |
Equipment Rec # |
nnnnnnnn |
Long Integer |
|
CM_ID |
Equip Comp Rec # |
-nnnnnnnn |
AutoID Number |
Long Integer |
CM_INAC_DT |
Inactive Date |
mm/dd/yyyy |
Inactive Date |
Date/Time |
CM_INST_DT |
Install Date |
mm/dd/yyyy |
Installed Date |
Date/Time |
CM_MAN_CD |
Manufacturer |
12x |
Manufacturer |
Text |
CM_MAN_TY |
Manufacturer Text |
60x |
Manufacturer Text |
Text |
CM_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CM_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modification Date |
Date/Time |
CM_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CM_MODEL |
Model |
30x |
Model |
Text |
CM_QUAN |
Quantity |
nnnn.nn |
Quantity |
Double |
CM_REC_DT |
Date Recorded |
mm/dd/yyyy |
Date Recorded |
Date/Time |
CM_REC_TM |
Time Recorded |
hh:mm am |
Time Recorded |
Date/Time |
CM_RECNO |
Rec No |
nnn |
Record Number |
Integer |
CM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CM_SERIAL |
Serial Number |
30x |
Serial Number |
Text |
CM_SPEC |
Spec |
80x |
Spec |
Text |
CM_STAT_CD |
Status |
nnn |
Status |
Integer |
CM_STAT_TY |
Status Text |
25x |
Status Text |
Text |
CM_TYPE_CD |
Type |
12x |
Component Type Code |
Text |
CM_TYPE-TY |
|
60x |
Component Type Description |
Text |
CM_YEAR |
Year |
30x |
Year |
Text |