Tables:

Table: Fleet_Unit (2)

Name: Fleet_Unit

Display Field: UnitNo

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• UnitNo ( type: esriFieldTypeString, alias: UnitNo, length: 255 )
• UnitDescription ( type: esriFieldTypeString, alias: UnitDescription, length: 255 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 255 , Coded Values: [Aardvark: Aardvark] , [Air-loc: Air-loc] , [Airlift: Airlift] , ...153 more... )
• Model ( type: esriFieldTypeString, alias: Model, length: 255 )
• SerialNum ( type: esriFieldTypeString, alias: SerialNum, length: 255 )
• CostCentre ( type: esriFieldTypeString, alias: CostCentre, length: 50 , Coded Values: [100: 100] , [105: 105] , [111: 111] , ...43 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 , Coded Values: [Administration: Administration] , [Airport: Airport] , [Cemetery: Cemetery] , ...42 more... )
• LicensePlate ( type: esriFieldTypeString, alias: LicensePlate, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 , Coded Values: [Operating: Operating] , [Retain: Retain] , [Sold: Sold] , ...6 more... )
• Operator ( type: esriFieldTypeString, alias: Operator, length: 255 )
• DocumentationLink ( type: esriFieldTypeString, alias: DocumentationLink, length: 255 )
• ParentId ( type: esriFieldTypeInteger, alias: ParentId )
• ParentDesc ( type: esriFieldTypeString, alias: ParentDesc, length: 255 )
• Vendor ( type: esriFieldTypeString, alias: Vendor, length: 255 , Coded Values: [0835688 Bc Ltd: 0835688 Bc Ltd] , [AB Contracting: AB Contracting] , [Altec Industries: Altec Industries] , ...131 more... )
• ReadingType ( type: esriFieldTypeString, alias: ReadingType, length: 255 , Coded Values: [KM: KM] , [HR: HR] )
• CurrentMeterReading ( type: esriFieldTypeInteger, alias: CurrentMeterReading )
• PurchasePrice ( type: esriFieldTypeDouble, alias: PurchasePrice )
• PurchaseDate ( type: esriFieldTypeDate, alias: PurchaseDate, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• EQType ( type: esriFieldTypeString, alias: EQType, length: 255 )
• Priority ( type: esriFieldTypeString, alias: Priority, length: 255 )
• RadioChannels ( type: esriFieldTypeString, alias: RadioChannels, length: 255 )
• RentalRate ( type: esriFieldTypeString, alias: RentalRate, length: 255 )
• GVW1 ( type: esriFieldTypeString, alias: GVW1, length: 255 )
• GVW2 ( type: esriFieldTypeString, alias: GVW2, length: 255 )
• Mobility ( type: esriFieldTypeString, alias: Mobility, length: 255 , Coded Values: [Open: Open] , [Fixed: Fixed] )
• GLString ( type: esriFieldTypeString, alias: GLString, length: 255 )
• POMisc ( type: esriFieldTypeString, alias: POMisc, length: 255 )
• Miscellaneous1 ( type: esriFieldTypeString, alias: Miscellaneous1, length: 800 )
• Miscellaneous2 ( type: esriFieldTypeString, alias: Miscellaneous2, length: 800 )
• Warranty_Notes ( type: esriFieldTypeString, alias: Warranty_Notes, length: 255 )
• Warranty_Notes2 ( type: esriFieldTypeString, alias: Warranty_Notes2, length: 255 )
• SalvageValue ( type: esriFieldTypeInteger, alias: SalvageValue )
• UsefulLife ( type: esriFieldTypeInteger, alias: UsefulLife )
• DeprecMethod ( type: esriFieldTypeInteger, alias: DeprecMethod )
• DeprecFactor ( type: esriFieldTypeInteger, alias: DeprecFactor )
• Category ( type: esriFieldTypeString, alias: Category, length: 255 , Coded Values: [Equipment: Equipment] , [Heavy Vehicles: Heavy Vehicles] , [Light Vehicles: Light Vehicles] , ...2 more... )
• Class ( type: esriFieldTypeString, alias: Class , length: 255 , Coded Values: [Heavy Duty Equipment: Heavy Duty Equipment] , [Medium Duty Equipment: Light Duty Equipment] , [Tandem Axle Truck: Tandem Axle Truck] , ...8 more... )
• Type ( type: esriFieldTypeString, alias: Type, length: 255 , Coded Values: [Tractor: Tractor] , [Refuse Compactor: Refuse Compactor] , [Processing Plant: Processing Plant] , ...59 more... )
• DataValidated ( type: esriFieldTypeString, alias: DataValidated, length: 3 )
• SecureLink ( type: esriFieldTypeString, alias: SecureLink, length: 256 )
• AID ( type: esriFieldTypeString, alias: AID, length: 11 )
• FuelType ( type: esriFieldTypeString, alias: FuelType, length: 50 , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...5 more... )
• RateDesc ( type: esriFieldTypeString, alias: RateDesc, length: 25 , Coded Values: [Actual Costs: Actual Costs] , [Hourly Rate: Hourly Rate] , [Insurance Only: Insurance Only] , ...3 more... )
• IMAGE ( type: esriFieldTypeString, alias: IMAGE, length: 100 )
• ReplacementDate ( type: esriFieldTypeDate, alias: ReplacementDate, length: 8 )
• ReplacementYear ( type: esriFieldTypeSmallInteger, alias: ReplacementYear )

Relationships:

• FT_Accessories (4) -- Related To: FT_Accessories (12)
• Warranty (3) -- Related To: Fleet_Warranty (9)
• Specifications (2) -- Related To: Fleet_Specification (5)
• Fleet_Engine (7) -- Related To: Fleet_Engine (4)
• Fleet_Blades (1) -- Related To: Fleet_Blades (3)
• Fleet_Tires (0) -- Related To: Fleet_Tires (6)
• FleetSpecs (8) -- Related To: Fleet_Specs (11)
• FleetComponents (6) -- Related To: FleetComponents (10)

Table: Fleet_Blades (3)

Name: Fleet_Blades

Display Field: BladeId

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BladeId ( type: esriFieldTypeString, alias: BladeId, length: 50 )
• VehicleId ( type: esriFieldTypeString, alias: VehicleId, length: 50 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• AssembledDepth_inches ( type: esriFieldTypeInteger, alias: Assembled Depth (in inches) )
• AssembledHeight_inches ( type: esriFieldTypeInteger, alias: Assembled Height (in nches) )
• AssembledWidth_inches ( type: esriFieldTypeInteger, alias: Assembled Width (in inches) )
• AssembledWeight_kg ( type: esriFieldTypeInteger, alias: Assembled Weight (in kg) )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• Image ( type: esriFieldTypeString, alias: Image, length: 50 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [ABND: Abandoned] , [PROP: Proposed] , [ACT: Active] , ...1 more... )
• Condition ( type: esriFieldTypeInteger, alias: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )

Relationships:

• Fleet_Unit (1) -- Related To: Fleet_Unit (2)

Table: Fleet_Engine (4)

Name: Fleet_Engine

Display Field: EngineId

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EngineId ( type: esriFieldTypeString, alias: EngineId, length: 50 )
• VehicleId ( type: esriFieldTypeString, alias: VehicleId, length: 50 )
• Description ( type: esriFieldTypeString, alias: Description, length: 50 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• Horsepower ( type: esriFieldTypeInteger, alias: Horsepower )
• FuelType ( type: esriFieldTypeString, alias: FuelType, length: 50 )
• Cylinders ( type: esriFieldTypeInteger, alias: Cylinders )
• EngineSize ( type: esriFieldTypeInteger, alias: EngineSize )
• Image ( type: esriFieldTypeString, alias: Image, length: 100 )

Relationships:

• Fleet_Unit (7) -- Related To: Fleet_Unit (2)

Table: Fleet_Specification (5)

Name: Fleet_Specification

Display Field: LinkId

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• LinkId ( type: esriFieldTypeString, alias: LinkId, length: 60 )
• Counter ( type: esriFieldTypeOID, alias: Counter )
• EntityID ( type: esriFieldTypeString, alias: EntityID, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 )
• Value ( type: esriFieldTypeString, alias: Value, length: 255 )
• AID ( type: esriFieldTypeString, alias: AID, length: 11 )

Relationships:

• Unit (2) -- Related To: Fleet_Unit (2)
• Fleet_Transit (9) -- Related To: Fleet_Transit (7)

Table: Fleet_Tires (6)

Name: Fleet_Tires

Display Field: TireId

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TireId ( type: esriFieldTypeString, alias: TireId, length: 50 )
• VehicleId ( type: esriFieldTypeString, alias: VehicleId, length: 50 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• MaxPSI ( type: esriFieldTypeInteger, alias: MaxPSI )
• Size ( type: esriFieldTypeString, alias: Size, length: 50 )
• Image ( type: esriFieldTypeString, alias: Image, length: 100 )

Relationships:

• Fleet_Unit (0) -- Related To: Fleet_Unit (2)

Table: Fleet_Transit (7)

Name: Fleet_Transit

Display Field: UnitNo

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• UnitNo ( type: esriFieldTypeString, alias: UnitNo, length: 255 )
• UnitDescription ( type: esriFieldTypeString, alias: UnitDescription, length: 255 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 255 , Coded Values: [Aardvark: Aardvark] , [Air-loc: Air-loc] , [Airlift: Airlift] , ...153 more... )
• Model ( type: esriFieldTypeString, alias: Model, length: 255 )
• SerialNum ( type: esriFieldTypeString, alias: SerialNum, length: 255 )
• CostCentre ( type: esriFieldTypeString, alias: CostCentre, length: 50 , Coded Values: [100: 100] , [105: 105] , [111: 111] , ...43 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 , Coded Values: [Administration: Administration] , [Airport: Airport] , [Cemetery: Cemetery] , ...42 more... )
• LicensePlate ( type: esriFieldTypeString, alias: LicensePlate, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 , Coded Values: [Operating: Operating] , [Retain: Retain] , [Sold: Sold] , ...6 more... )
• Operator ( type: esriFieldTypeString, alias: Operator, length: 255 )
• DocumentationLink ( type: esriFieldTypeString, alias: DocumentationLink, length: 255 )
• Vendor ( type: esriFieldTypeString, alias: Vendor, length: 255 , Coded Values: [0835688 Bc Ltd: 0835688 Bc Ltd] , [AB Contracting: AB Contracting] , [Altec Industries: Altec Industries] , ...131 more... )
• ReadingType ( type: esriFieldTypeString, alias: ReadingType, length: 255 , Coded Values: [KM: KM] , [HR: HR] )
• CurrentMeterReading ( type: esriFieldTypeInteger, alias: CurrentMeterReading )
• PurchasePrice ( type: esriFieldTypeDouble, alias: PurchasePrice )
• PurchaseDate ( type: esriFieldTypeDate, alias: PurchaseDate, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• EQType ( type: esriFieldTypeString, alias: EQType, length: 255 )
• Priority ( type: esriFieldTypeString, alias: Priority, length: 255 )
• RentalRate ( type: esriFieldTypeString, alias: RentalRate, length: 255 )
• GVW1 ( type: esriFieldTypeString, alias: GVW1, length: 255 )
• GVW2 ( type: esriFieldTypeString, alias: GVW2, length: 255 )
• Category ( type: esriFieldTypeString, alias: Category, length: 255 , Coded Values: [Equipment: Equipment] , [Heavy Vehicles: Heavy Vehicles] , [Light Vehicles: Light Vehicles] , ...2 more... )
• Class ( type: esriFieldTypeString, alias: Class , length: 255 , Coded Values: [Heavy Duty Equipment: Heavy Duty Equipment] , [Medium Duty Equipment: Light Duty Equipment] , [Tandem Axle Truck: Tandem Axle Truck] , ...8 more... )
• Type ( type: esriFieldTypeString, alias: Type, length: 255 , Coded Values: [Tractor: Tractor] , [Refuse Compactor: Refuse Compactor] , [Processing Plant: Processing Plant] , ...59 more... )
• FuelType ( type: esriFieldTypeString, alias: FuelType, length: 50 , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...5 more... )
• Image ( type: esriFieldTypeString, alias: Image, length: 100 )

Relationships:

• Fleet_Specification (9) -- Related To: Fleet_Specification (5)
• Fleet_Warranty (10) -- Related To: Fleet_Warranty (9)

Table: Fleet_Unit__ATTACH (8)

Name: Fleet_Unit__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_OBJECTID ( type: esriFieldTypeInteger, alias: REL_OBJECTID )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )

Table: Fleet_Warranty (9)

Name: Fleet_Warranty

Display Field: Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EntityID ( type: esriFieldTypeString, alias: EntityID, length: 50 )
• Name ( type: esriFieldTypeString, alias: Name, length: 50 )
• Description ( type: esriFieldTypeString, alias: Description, length: 50 )
• EndDate ( type: esriFieldTypeDate, alias: EndDate, length: 8 )
• EndKM ( type: esriFieldTypeInteger, alias: EndKM )
• DocumentLink ( type: esriFieldTypeString, alias: DocumentLink, length: 100 )
• ParentID ( type: esriFieldTypeString, alias: ParentID, length: 50 )
• AID ( type: esriFieldTypeString, alias: AID, length: 11 )

Relationships:

• FleetComponents (11) -- Related To: FleetComponents (10)
• Unit (3) -- Related To: Fleet_Unit (2)
• Fleet_Transit (10) -- Related To: Fleet_Transit (7)

Table: FleetComponents (10)

Name: FleetComponents

Display Field: Description

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: System

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Description ( type: esriFieldTypeString, alias: Description, length: 50 )
• parentFleetID ( type: esriFieldTypeString, alias: parentFleetID, length: 50 )
• System ( type: esriFieldTypeSmallInteger, alias: System )
• Component ( type: esriFieldTypeSmallInteger, alias: Component )
• VMRS_Full ( type: esriFieldTypeString, alias: VMRS Code, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 50 )
• ComponentID ( type: esriFieldTypeString, alias: ComponentID, length: 50 )
• Assembly ( type: esriFieldTypeInteger, alias: Assembly )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 50 , Coded Values: [IN: IN SERVICE] , [OUT: OUT OF SERVICE/ ABANDONED] , [REMOVED: REMOVED] )
• ExpectedUsefulLife ( type: esriFieldTypeSmallInteger, alias: ExpectedUsefulLife )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• ResidualLife ( type: esriFieldTypeSmallInteger, alias: ResidualLife )
Types:
ID: 164
Name: Blowing
Domains:

---

ID: 25
Name: Transfer Case 026 Transmission—Main, Manual
Domains:

---

ID: 27
Name: Transmission—Main, Automatic
Domains:

---

ID: 21
Name: Axle Driven—Front Steering
Domains:

---

ID: 22
Name: Axle Driven—Rear
Domains:

---

ID: 23
Name: Clutch 024 Drive Shaft(s)
Domains:

---

ID: 28
Name: Transmission—Auxiliary and Transfer Case
Domains:

---

ID: 29
Name: Auxiliary Section (Transmission— Main, Manual)
Domains:

---

ID: 94
Name: Engine, Auxiliary (for power units, trailers, etc.)
Domains:

---

ID: 4
Name: Aerodynamic Devices
Domains:

---

ID: 263
Name: Hammering
Domains:

---

ID: 262
Name: Breaking
Domains:

---

ID: 261
Name: Raking
Domains:

---

ID: 267
Name: Drilling and Boring
Domains:

---

ID: 265
Name: Magnetic
Domains:

---

ID: 264
Name: Grappling
Domains:

---

ID: 269
Name: Dust & Debris Collecting
Domains:

---

ID: 268
Name: Pulling
Domains:

---

ID: 59
Name: Vehicle Coupling
Domains:

---

ID: 58
Name: Winch (for power units, trailers, etc.)
Domains:

---

ID: 55
Name: Cargo Handling, Restraints and Lift Systems (for power units, trailers, etc.)
Domains:

---

ID: 54
Name: Horns and Mounting and Reverse Signal Alarms
Domains:

---

ID: 57
Name: Spare Wheel Mounting
Domains:

---

ID: 56
Name: Power Take Off
Domains:

---

ID: 51
Name: General Accessories (for power units, trailers, etc.)
Domains:

---

ID: 53
Name: Expendable Items (for power units, trailers, etc.)
Domains:

---

ID: 52
Name: Electrical Accessories (for power units, trailers, etc.)
Domains:

---

ID: 191
Name: Batch Mobile Processing Plant
Domains:

---

ID: 192
Name: Conveying Systems
Domains:

---

ID: 111
Name: Undercarriage
Domains:

---

ID: 112
Name: Stabilization
Domains:

---

ID: 82
Name: Refrigeration, Mechanical (for power units, trailers, etc.)
Domains:

---

ID: 83
Name: Refrigeration, Nitrogen (for power units, trailers, etc.)
Domains:

---

ID: 81
Name: Heating Unit (for power units, trailers, etc.)
Domains:

---

ID: 84
Name: Refrigeration, Holdover Plate (for power units, trailers, etc.)
Domains:

---

ID: 3
Name: Instruments, Gauges (All), and Meters
Domains:
• Assembly:
  Coded Values: [1: Gauges & Warning Devices] , [2: Speedometer] , [4: Shutdown Devices]

---

ID: 167
Name: Tilling
Domains:

---

ID: 33
Name: Ignition System
Domains:

---

ID: 32
Name: Cranking System
Domains:

---

ID: 31
Name: Charging System
Domains:

---

ID: 34
Name: Lighting System
Domains:

---

ID: 61
Name: Terminal Equipment Systems and Accessories
Domains:

---

ID: 63
Name: Satellite Communications Systems
Domains:

---

ID: 97
Name: Pump (for power units, trailers, etc.)
Domains:

---

ID: 65
Name: Hydraulic Systems, Multifunctional
Domains:

---

ID: 66
Name: Scrapping
Domains:

---

ID: 67
Name: Buckets
Domains:

---

ID: 68
Name: Lifting
Domains:

---

ID: 69
Name: Conveyance
Domains:

---

ID: 173
Name: Tilt Bodies
Domains:

---

ID: 172
Name: Compaction Bodies
Domains:

---

ID: 171
Name: Mixers
Domains:

---

ID: 2
Name: Cab and Sheet Metal
Domains:
• Assembly:
  Coded Values: [1: Air Conditioning Assembly - Complete] , [2: Heating & Ventilating] , [5: Auxiliary Fan – Defroster]

---

ID: 99
Name: Safety Devices, Instruments and Gauges (for power units, trailers, etc.)
Domains:

---

ID: 98
Name: Valves and Controls (for power units, trailers, etc.)
Domains:

---

ID: 168
Name: Mowing
Domains:

---

ID: 169
Name: Ripping
Domains:

---

ID: 91
Name: Blowers, Conveyors, and Vibrators (for power units, trailers, etc.)
Domains:

---

ID: 165
Name: Vacuuming
Domains:

---

ID: 166
Name: Trenching
Domains:

---

ID: 92
Name: Compressor, Bulk Product Systems (for power units, trailers, etc.)
Domains:

---

ID: 95
Name: Manifold (for power units, trailers, etc.) 096 Power Shaft (for power units, trailers, etc.)
Domains:

---

ID: 161
Name: Sweeping
Domains:

---

ID: 162
Name: Spreading
Domains:

---

ID: 163
Name: Chipping
Domains:

---

ID: 11
Name: Axles Front—Non-Driven
Domains:

---

ID: 13
Name: Brakes
Domains:
• Assembly:
  Coded Values: [1: Front Brakes & Drums] , [2: Rear Brakes & Drums] , [3: Parking Brakes] , ...10 more...

---

ID: 12
Name: Axles Rear—Non-Driven
Domains:

---

ID: 15
Name: Steering
Domains:
• Assembly:
  Coded Values: [2: Steering Shaft Support] , [3: Steering Gear] , [4: Steering Linkage] , ...1 more...

---

ID: 14
Name: Frame
Domains:
• Assembly:
  Coded Values: [1: Frame Assembly Components] , [2: Bumpers & Attaching Parts] , [3: Engine Mountings] , ...6 more...

---

ID: 17
Name: Tires
Domains:
• Assembly:
  Coded Values: [1: Tire – Pneumatic] , [4: Inner Tube – Pneumatic Tire] , [6: Liner (Flap) – Pneumatic Tire] , ...1 more...

---

ID: 16
Name: Suspension
Domains:
• Assembly:
  Coded Values: [2: Front Springs] , [3: Front Shock Absorbers] , [4: Front Stabilizer] , ...7 more...

---

ID: 19
Name: Automatic/Manual Chassis Lubricator
Domains:

---

ID: 18
Name: Wheels, Rim, Hubs, and Bearings
Domains:
• Assembly:
  Coded Values: [1: Front Steer Axle Wheel End Components] , [2: Drive Axle Wheel End Components] , [3: Wheels] , ...1 more...

---

ID: 46
Name: Electric Propulsion System
Domains:

---

ID: 47
Name: Filter Kits (Multi-Piece)
Domains:

---

ID: 44
Name: Fuel System
Domains:

---

ID: 45
Name: Power Plant
Domains:

---

ID: 42
Name: Cooling System
Domains:
• Assembly:
  Coded Values: [1: Shutters] , [2: Radiator] , [3: Fan – Engine Cooling] , ...4 more...

---

ID: 43
Name: Exhaust System
Domains:

---

ID: 41
Name: Air Intake System
Domains:
• Assembly:
  Coded Values: [1: Air Cleaner] , [2: Intake Manifold] , [4: Intercooler] , ...1 more...

---

ID: 1
Name: Air Conditioning, Heating, and Ventilating System
Domains:
• Assembly:
  Coded Values: [1: Air Conditioning Assembly - Complete] , [2: Heating & Ventilating] , [5: Auxiliary Fan – Defroster]

---

ID: 77
Name: Trailer Frame and Support
Domains:

---

ID: 76
Name: Rings and Bolsters
Domains:

---

ID: 75
Name: Manholes
Domains:

---

ID: 74
Name: Tank Vessel, outer jacket
Domains:

---

ID: 73
Name: Tank Vessel, inner shell
Domains:

---

ID: 72
Name: Rear Wall and Door
Domains:

---

ID: 71
Name: Body (except bulk carrier body)
Domains:

---

ID: 79
Name: Safety Devices
Domains:

---

ID: 78
Name: Trim and Miscellaneous Hardware
Domains:

---

Relationships:

• Fleet_Warranty (11) -- Related To: Fleet_Warranty (9)
• Fleet_Unit (6) -- Related To: Fleet_Unit (2)

Table: Fleet_Specs (11)

Name: Fleet_Specs

Display Field: parentFleetUnit

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: Type

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• parentFleetUnit ( type: esriFieldTypeString, alias: parentFleetUnit, length: 50 )
• Description ( type: esriFieldTypeString, alias: Description, length: 50 )
• WheelSize ( type: esriFieldTypeString, alias: Wheel Size, length: 50 , Coded Values: [275/65R18: 275/65R18] , [R15: R15] , [R16: R16] )
• FuelEconomy ( type: esriFieldTypeString, alias: Fuel Economy, length: 50 )
• DriveType ( type: esriFieldTypeString, alias: Drive Type, length: 50 , Coded Values: [FWD: Front-wheel drive] , [4WD: Four-wheel drive] , [AWD: All-wheel drive] , ...1 more... )
• FuelType ( type: esriFieldTypeString, alias: Fuel Type, length: 50 , Coded Values: [RegularUnleaded: Regular Unleaded] , [PremiumUnleaded: Premium Unleaded] , [Diesel: Diesel] )
• WheelBase ( type: esriFieldTypeString, alias: Wheel Base (cm), length: 50 )
• OverallLength ( type: esriFieldTypeDouble, alias: Overall Length (cm) )
• OverallWidth ( type: esriFieldTypeDouble, alias: Overall Width (cm) )
• OverallHeight ( type: esriFieldTypeDouble, alias: Overall Height (cm) )
• CurbWeight ( type: esriFieldTypeDouble, alias: Curb Weight (kg) )
• Type ( type: esriFieldTypeSmallInteger, alias: Component )
• SpecID ( type: esriFieldTypeString, alias: SpecID, length: 50 )
Types:
ID: 0
Name: Ford 250 4X4
Domains:
• WheelSize:
  Inherited
• DriveType:
  Inherited
• FuelType:
  Inherited

---

ID: 1
Name: GMC SIerra 1500
Domains:
• WheelSize:
  Inherited
• DriveType:
  Inherited
• FuelType:
  Inherited

---

Relationships:

• Fleet_Unit (8) -- Related To: Fleet_Unit (2)

Table: FT_Accessories (12)

Name: FT_Accessories

Display Field: vehicleId

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8746e12115aa4687babd720c9af0edcc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• vehicleId ( type: esriFieldTypeString, alias: vehicleId, length: 50 )
• aid ( type: esriFieldTypeString, alias: aid, length: 50 )
• AccessoryType ( type: esriFieldTypeString, alias: AccessoryType, length: 50 )
• Details ( type: esriFieldTypeString, alias: Details, length: 50 )

Relationships:

• Fleet_Unit (4) -- Related To: Fleet_Unit (2)