SiteSystems - Systems maintained at each customers site
| Column | Type | Notes |
|---|---|---|
| CancellationDate | DATETIME | |
| CancellationReason | TEXT | |
| CompanyNumber | WHOLE NUMBER | |
| ContractExpiryDate | DATETIME | |
| ContractTermInYears | WHOLE NUMBER | |
| DateOfSale | DATETIME | |
| Description | TEXT | |
| EnabledDate | DATETIME | |
| ExpectedEnableDate | DATETIME | |
| InstallationDate | DATETIME | |
| InstalledBy | TEXT | |
| LastEditTime | TEXT | |
| LastMaintenanceDate | DATETIME | |
| LastMaintenanceType | TEXT | |
| Maintained_YN | TEXT | |
| Rented_YN | TEXT | |
| SiteID | TEXT | |
| SiteIdSystemNo | TEXT | |
| Status | TEXT | |
| SystemCode | TEXT | |
| SystemNo | WHOLE NUMBER | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |