SytemMaintenaceSchedules - Schedule of when systems are next due for maintenance
| Column | Type | Notes |
|---|---|---|
| Appointment_YN | TEXT | |
| CK_SiteSystemSchedule | TEXT | Tugger created column comprising: SiteID, SystemNo, ScheduleNo |
| CallNumber | WHOLE NUMBER | |
| ExcludeAssociatedPMCallsFromCallPerformanceAnalysis_YN | TEXT | |
| Frequency | WHOLE NUMBER | |
| GroupCode | TEXT | |
| NextMaintenanceDate | DATETIME | |
| NoOfEngineersTechnicians | WHOLE NUMBER | |
| NoOfHours | WHOLE NUMBER | |
| NoOfMinutes | WHOLE NUMBER | |
| OnlyUseThisSchedulesCheckListItems_YN | TEXT | |
| PartnerBilling_YN | TEXT | |
| PlantRequiredDetails | TEXT | |
| PreferredEngineer | TEXT | |
| PrintDocket_YN | TEXT | |
| Priority | WHOLE NUMBER | |
| RemoteMaint_YN | TEXT | |
| RevenueTaken_YN | TEXT | |
| RevenueValue | DECIMAL NUMBER | |
| SalesCommissionEndDate | DATETIME | |
| SalesCommission_YN | TEXT | |
| ScheduleNo | WHOLE NUMBER | |
| ScheduleType | TEXT | |
| SiteID | TEXT | |
| SystemNo | WHOLE NUMBER | |
| UseGreatestFreqSchedWhenSchedsFallOnSameDay_YN | TEXT | |
| VisitLetters_YN | TEXT | |
| WeeklyBiWeeklyVisit | TEXT | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |