Grouped PM Scheduling
Field Name |
Caption |
Mask |
Description |
Field Type |
PM_CRT_BY |
Created By |
25x |
Created By |
Text |
PM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PM_DAYSAHD |
Days Ahead |
nnn |
Days Ahead |
Integer |
PM_DT_INNO |
End Date Interval |
nnn |
Date Interval Number |
Integer |
PM_DTINT_CD |
End Interval Code |
nnn |
Date Interval Code |
|
PM_DTINT_TY |
End Interval Text |
25x |
Date Interval Text |
Text |
PM_HR_AHD |
Hourmeter Ahead |
nnnnnn.nn |
GA Hourmeter Ahead |
Double |
PM_HR_AMT |
Hourmeter Interval |
nnnnnn.nn |
Hourmeter Interval |
Double |
PM_HR_NXT |
Next Hourmeter |
nnnnnn.nn |
Next Hourmeter |
Double |
PM_HR_PRV |
Previous Hourmeter |
nnnnnn.nn |
Previous Hourmeter |
Double |
PM_ID |
AutoNumber |
nnnnnnnn |
Auto Number |
Long Integer |
PM_INIT_DT |
Initiated Date |
mm/dd/yyyy |
Initiated Date |
Date/Time |
PM_LSTRTDT |
Last Start Date |
mm/dd/yyyy |
Last Start Date |
Date/Time |
PM_MOD_BY |
Last Modified By |
25x |
Last Modified By : |
Text |
PM_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date : |
Date/Time |
PM_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PM_NXT_DT |
Next End Date |
mm/dd/yyyy |
Next Date |
Date/Time |
PM_ODM_AHD |
Odometer Ahead |
nnnnnnn.n |
GA Odometer Ahead |
Double |
PM_ODM_AMT |
Odometer Interval |
nnnnnnn.n |
Odometer Interval |
Double |
PM_ODM_NXT |
Next Odometer |
nnnnnnn.n |
Next Odometer |
Double |
PM_ODM_PRV |
Previous Odometer |
nnnnnnn.n |
Previous Odometer |
Double |
PM_OTH_AHD |
Other Ahead |
nnnnnnn.nn |
GA Other Meter Ahead |
Double |
PM_OTH_AMT |
Other Interval |
nnnnnnn.nn |
Other Interval |
Double |
PM_OTH_NXT |
Next Other |
nnnnnnn.nn |
Next Other |
Double |
PM_OTH_PRV |
Previous Other |
nnnnnnn.nn |
Previous Other |
Double |
PM_PRV_DT |
Last End Date |
mm/dd/yyyy |
Previous End Date |
Date/Time |
PM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PM_RS_ID |
Grouped Asset Rec # |
nnnnnnnn |
Grouped Asset Rec # |
Long Integer |
PM_RSGI_ID |
Group ID |
-nnnnnnnn |
Long Integer |
|
PM_ST_INV |
Start Date Interval |
nnn |
Start Date Interval |
Integer |
PM_STAT_CD |
Status |
nnn |
Status |
Integer |
PM_STAT_TY |
Status Text |
25x |
Status Text |
Text |
PM_STINT_CD |
Start Interval Code |
nnn |
Start Interval Code |
|
PM_STINT_TY |
Start Interval Text |
25x |
Start Interval Text |
Text |
PM_STNXTDT |
Next Start Date |
mm/dd/yyyy |
Next Date by Start |
Date/Time |
PM_TO_ID |
PM Rec # |
nnnnnnnn |
Long Integer |
|
PM_WO_NUM |
Work Order # |
18x |
WO Number |
Text |