Equipment Component Library Details
Field Name |
Caption |
Mask |
Description |
Field Type |
CD_CL_ID |
Equip Comp Library # |
-nnnnnnnn |
Long Integer |
|
CD_COMP_CD |
Component |
nnn |
Component |
Integer |
CD_COMP_TY |
Component Text |
25x |
Component Text |
Text |
CD_CRT_BY |
Created By |
25x |
Created By |
Text |
CD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CD_DESC |
Description |
50x |
Description |
Text |
CD_ID |
Equip Comp Libr Detail # |
-nnnnnnnn |
Equipment Catalog Rec # |
Long Integer |
CD_MAKE |
Make |
30x |
Make: |
Text |
CD_MAN_CD |
Manufacturer |
12x |
Manufacturer |
Text |
CD_MAN_TY |
Manufacturer Text |
60x |
Manufacturer Text |
Text |
CD_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
CD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
CD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CD_MODEL |
Model |
30x |
Model Number: |
Text |
CD_QUAN |
Quantity |
nnnn.nn |
Quantity |
Double |
CD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CD_SPEC |
Spec |
80x |
Spec |
Text |
CD_TYPE_CD |
Type |
12x |
Type |
Text |
CD_TYPE_TY |
Type Text |
60x |
Type Text |
Text |
CD_YEAR |
Year |
30x |
Year |
Text |