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)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata