Work PM Asset Filter Table
Field Name |
Caption |
Mask |
Description |
Field Type |
FI_CAT_CD |
Category |
10x |
Category |
Text |
FI_CAT_TY |
Category Text |
60x |
Category Text |
Text |
FI_CRT_BY |
Created By |
25x |
Created By |
Text |
FI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FI_FILTER |
Filter Name |
50x |
Filter Name |
Text |
FI_ID |
AutoNumber |
nnnnnnnn |
AutoNumber |
Long Integer |
FI_MOD_BY |
Modified By |
25x |
Last Modified By |
Text |
FI_MOD_DT |
Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
FI_MOD_TM |
Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FI_TO_ID |
PM Record # |
nnnnnnnn |
Long Integer |