Routine Work - Other PMs Affected
Field Name |
Caption |
Mask |
Description |
Field Type |
TP_AFF_FLG |
Tightly Linked PM |
|
Tightly Linked PM Flag |
Boolean |
TP_AFFECTEDPM |
Affected PM |
|
Affected PM |
Boolean |
TP_CRT_BY |
Created By |
25x |
Created By |
Text |
TP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TP_ID |
Link Rec # |
nnnnnnnn |
AutoNumber |
Long Integer |
TP_MAIN_NO |
# Between PMs |
nnn. |
# Between PMs |
Double |
TP_MAINREM |
# Remaining |
nnn. |
# Remaining |
Double |
TP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
TP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TP_PM2_ID |
Schedule Rec # |
nnnnnnnn |
Child ID - Link to WKRTPM.PM_ID |
Long Integer |
TP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TP_RS_ID |
Grouped Asset Rec # |
nnnnnnnn |
Grouped Asset Rec # |
Long Integer |
TP_RSGI_ID |
PM Group ID |
-nnnnnnnn |
Parent ID - Link to WKRTPM.PM_ID |
Long Integer |
TP_RUTN_CD |
Routine Code |
20x |
Routine Work of Child Record |
Text |
TP_RUTN_TY |
Routine Text |
80x |
Routing Work Text of Child Record |
Text |
TP_TO_ID |
PM Rec # |
nnnnnnnn |
Parent ID - Link to WKROUTINE.TO_ID |
Long Integer |
TP_TO2_ID |
Linked PM Rec # |
nnnnnnnn |
Child ID - Link to Affected WKROUTINE.TO_ID Record |
Long Integer |