Version of Tables
Field Name |
Caption |
Mask |
Description |
Field Type |
TY_CLOSED |
PMs Closed |
nnnn |
Scheduled WOs that are closed |
Integer |
TY_CRT_BY |
Created By |
25x |
Created By |
Text |
TY_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TY_ID |
AutoNumber |
nnnnnnnn |
AutoNumber |
Long Integer |
TY_MOD_BY |
Modified By |
25x |
Last Modified By |
Text |
TY_MOD_DT |
Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TY_MOD_TM |
Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TY_REMAIN |
PMs Remaining |
nnnn |
Remaining scheduled WOs |
Integer |
TY_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TY_RT_ID |
Link To WKRoutine |
nnnnnnnn |
Long Integer |
|
TY_SCHEDUL |
PMs Scheduled |
nnnn |
WOs scheduled per year |
Integer |
TY_YEAR |
Year |
nnnn |
Year |
Integer |