| Equipment Identification |
| Equipment Type Id |
ID for the category of equipment. |
| Equipment Type Name |
The type of equipment (e.g., Front-load Container, Roll-off, or Compactor). |
| Equipment External Id |
An ID used by an external system or third-party vendor associated with the Equipment Type. |
| License Plate |
The vehicle license plate number for mobile assets like haul trucks. |
| RFID Tag |
The unique RFID identifier used for automated tracking. |
| Owner Type Id |
ID associated with Owner Type. |
| Owner Type |
The entity that owns the asset (Company, Customer, or Vendor). |
| Quantity |
The number of identical units available at this location (e.g., number of 2-yard bins). |
| Serial Number |
The manufacturer's unique serial number for the piece of equipment. |
| LOB Id |
ID for the Line of Business (e.g., Residential, Commercial, or Industrial). |
| LOB Name |
Name of the Line of Business associated with the asset. |
| Physical Specifications |
| Tare Weight |
The empty weight of the container or vehicle. |
| Tare Weight UOM ID |
ID for the unit of measure used for tare weight. |
| Tare Weight UOM |
The unit of measure for weight (e.g., Pounds or Kilograms). |
| Location Information |
| Location Type |
The category of the site where the equipment is held (e.g., Transfer Station, Landfill, or Maintenance Yard). |
| Location Id |
Unique ID for the specific yard or site location. |
| Location Name |
The descriptive name of the facility or site where the equipment is held. |
| Address Line1 |
The primary street address of the location where the equipment is held. |
| Address Line2 |
The secondary address details (e.g., Suite or Gate number) for the location. |
| City |
The city of the location where the equipment is held. |
| State |
The state or province of the location where the equipment is held. |
| Postal Code |
The ZIP or postal code of the location where the equipment is held. |
| Latitude |
The GPS latitude coordinate of the location where the equipment is held. |
| Longitude |
The GPS longitude coordinate of the location where the equipment is held. |
| Service Region Id |
ID of the geographical region served by this inventory. |
| Service Region Name |
The name of the operational region served by this inventory. |
| Activity & Maintenance |
| Last Activity Time |
The timestamp of the most recent event involving this asset. |
| Last Activity Type |
The category of the most recent action taken with the asset. |
| Last Activity Event Type Id |
The numerical ID of the last event (e.g., 6 for Inbound). |
| Last Activity Event Type |
The description of the last single event (e.g., Swap/Exchange or Inbound). |
| Last Activity Work Type Id |
The ID of the work order type associated with the last activity. |
| Last Activity Work Type |
The type of work performed (e.g., Preventative Maintenance or Repair). |
| Days Since Last Activity |
Number of days since the asset was last moved or serviced. |
| Avg Days Between Activity |
Average cycle time for when this equipment is used. |
| Last Activity Service Record Id |
ID of the service record linked to the last activity. |
| Last Activity Work Order Number |
Specific work order number for the last maintenance or move event. |
| Last Activity Completed By User Id |
ID of the user who completed the last activity. |
Last Activity Completed By User
|
The full name of the user who performed the last action. |
