Inventory items Categories can be tied to
Field Name |
Caption |
Mask |
Description |
Field Type |
CI_ADRFLD |
|
10x |
Which of 3 fields in CMADDR to link to |
Text |
CI_DB_NAME |
Database Name |
20x |
Database Name |
Text |
CI_FILTERBY |
|
50x |
Field that is used by some internal filter processes to create a smaller lookup list |
Text |
CI_ICONNAME |
|
50x |
stores the icons name for the image shown in the category tree |
String |
CI_ID |
CatInv Rec # |
nnnnnnnn |
autoID |
Long Integer |
CI_LNKFLD1 |
|
10x |
Common Man's ID Link1 Field in Inventory Table |
Text |
CI_LNKFLD2 |
|
10x |
Common Man's ID Link2 Field in Inventory Table |
Text |
CI_LNKFLID |
|
10x |
ID Field in Inventory Table |
Text |
CI_MOD_ID |
|
|
ID of module in gbaUser.mdb Modules |
Long Integer |
CI_MODNAME |
|
8x |
Module Name |
Text |
CI_NAME |
Common Name |
25x |
Common Name |
Text |
CI_SYSFLD1 |
|
10x |
Common Man's ID Link1 Field in System ID Table |
Text |
CI_SYSFLD2 |
|
10x |
Common Man's ID Link2 Field in System ID Table |
Text |
CI_SYSFLID |
|
10x |
ID Field in System ID Table which stores the inventory item ID |
Text |
CI_SYSIDFL |
|
10x |
ID Field in System ID Table which stores the work order ID |
Text |
CI_SYSTBL |
|
20x |
Work Order System ID Table |
Text |
CI_TBLNAME |
|
20x |
Inventory Table Name |
Text |
CI_TEXT1 |
|
60x |
Asset Description 1 |
Text |
CI_TEXT2 |
|
100x |
Asset Description 2 |
Text |