| Name | Description | Type | Additional information |
|---|---|---|---|
| AssetHistoryID | integer |
None. |
|
| AssetID | integer |
None. |
|
| Name | string |
None. |
|
| AssetCode | string |
None. |
|
| AssetDescription | string |
None. |
|
| FacilityID | integer |
None. |
|
| FacilityName | string |
None. |
|
| SubFacilityID | integer |
None. |
|
| SubFacilityName | string |
None. |
|
| AssetCategoryID | integer |
None. |
|
| CategoryName | string |
None. |
|
| DepartmentID | integer |
None. |
|
| DepartmentName | string |
None. |
|
| AssetGroupID | integer |
None. |
|
| GroupName | string |
None. |
|
| AssetTypeID | integer |
None. |
|
| AssetTypeName | string |
None. |
|
| AssetSubGroupID | integer |
None. |
|
| AssetSubGroupName | string |
None. |
|
| AssetClassificationID | integer |
None. |
|
| AssetClassificationName | string |
None. |
|
| PurchaseDate | date |
None. |
|
| PurchaseCost | decimal number |
None. |
|
| VendorID | integer |
None. |
|
| VendorName | string |
None. |
|
| Manufacturer | string |
None. |
|
| ModelName | string |
None. |
|
| PartNumber | string |
None. |
|
| RegistrationNumber | string |
None. |
|
| VINNumber | string |
None. |
|
| VehicleTitleNumber | string |
None. |
|
| VehicleTitleCountyID | string |
None. |
|
| VehicleTitleCountyName | string |
None. |
|
| VehicleRegistrationNumber | string |
None. |
|
| VehicleLastInspection | date |
None. |
|
| StatusID | integer |
None. |
|
| StatusName | string |
None. |
|
| ColourCode | string |
None. |
|
| ImageOriginalFileName | string |
None. |
|
| ImageRenamedFileName | string |
None. |
|
| ImageFullPath | string |
None. |
|
| DepreciationID | integer |
None. |
|
| PuchaseCost | decimal number |
None. |
|
| PuchaseDate | date |
None. |
|
| ApportionID | integer |
None. |
|
| ApportionName | string |
None. |
|
| DepreciationMethodID | integer |
None. |
|
| DepreciationMethodName | string |
None. |
|
| UsefulLife | integer |
None. |
|
| SalvageValue | decimal number |
None. |
|
| DepreciationRate | decimal number |
None. |
|
| AddedBy | integer |
None. |
|
| AddedByName | string |
None. |
|
| WarrantyStartDate | date |
None. |
|
| WarrantyEndDate | date |
None. |
|
| ProcessName | string |
None. |
|
| PerformedBy | integer |
None. |
|
| PerformedDate | date |
None. |
|
| PerformedByName | string |
None. |
|
| ProcessFrom | string |
None. |
|
| Lat | decimal number |
None. |
|
| Long | decimal number |
None. |