Work Order Associated PM Table
Field Name |
Caption |
Mask |
Description |
Field Type |
AM_CLOSED |
Closed PM |
|
Closed PM |
Boolean |
AM_CRT_BY |
Created By |
25x |
Created By |
Text |
AM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AM_ID |
AutoNumber |
-nnnnnnnn |
AutoNumber |
Long Integer |
AM_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
AM_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
AM_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AM_PM_ID |
Link To PM Scheduling |
-nnnnnnnn |
Long Integer |
|
AM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
AM_RUTN_CD |
Associated PM |
20x |
Associated PM |
Text |
AM_RUTN_TY |
Associated PM Text |
80x |
Associated PM Text |
Text |
AM_TO_ID |
Link to PMs |
-nnnnnnnn |
Long Integer |
|
AM_WO_ID |
Link To Work Order |
-nnnnnnnn |
Long Integer |