| Name | Description | Type | Additional information |
|---|---|---|---|
| PeriodicScheduleID | integer |
None. |
|
| WorkOrderID | integer |
None. |
|
| ScheduleDate | date |
None. |
|
| WeekNumber | string |
None. |
|
| DayOfWeek | string |
None. |
|
| StatusID | string |
None. |
|
| Frequency | string |
None. |
|
| Details | string |
None. |
|
| PeriodicAssetID | integer |
None. |
|
| PeriodicalID | integer |
None. |
|
| AssetNumber | decimal number |
None. |
|
| AssetTaskID | integer |
None. |
|
| AssetType | string |
None. |
|
| TypeID | integer |
None. |
|
| Reference | string |
None. |
|
| Description | string |
None. |
|
| Quantity | integer |
None. |
|
| Location | string |
None. |
|
| AssetMake | string |
None. |
|
| AssetModel | string |
None. |
|
| AssetSerialNum | string |
None. |
|
| AssetNotes | string |
None. |
|
| Building | string |
None. |
|
| ClientReference | string |
None. |
|
| AccessDetails | string |
None. |
|
| AssetCategory | string |
None. |
|
| PPMStatusID | integer |
None. |
|
| PPMNotes | string |
None. |
|
| PPMCondition | string |
None. |
|
| PPMMaterials | string |
None. |
|
| PPMMarkForAttention | boolean |
None. |
|
| PPMComplete | boolean |
None. |
|
| PPMCompleteDate | date |
None. |
|
| AssetScheduleID | integer |
None. |
|
| ScheduleRef1 | string |
None. |
|
| AssetScheduleID2 | integer |
None. |
|
| ScheduleRef2 | string |
None. |
|
| AssetScheduleID3 | integer |
None. |
|
| ScheduleRef3 | string |
None. |
|
| AssetScheduleID4 | integer |
None. |
|
| ScheduleRef4 | string |
None. |
|
| StatutoryTypeDesc | string |
None. |
|
| ManagedID | integer |
None. |
|
| AssetRefrigerant | string |
None. |
|
| AssetFan | string |
None. |
|
| AssetBelt | string |
None. |
|
| AssetFilter | string |
None. |
|
| CategoryTypeDesc | string |
None. |
|
| ManagedFlagID | integer |
None. |
|
| AssetRefrigerantID | integer |
None. |
|
| AssetLabelCode | string |
None. |
|
| AssetDetails | string |
None. |
|
| InstallationDate | string |
None. |
|
| WarrantyDate | string |
None. |
|
| YearOfManufacture | string |
None. |
|
| AssetID | integer |
None. |
|
| MaintenanceDocID | integer |
None. |