Name: Fleet_Unit

Display Field: UnitNo

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2bf9676cc319459e9831b05b4ab135fe

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

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

Templates:

• Name: Fleet_Unit
  Description:
  Prototype:
  ReplacementDate: null
  UnitNo: null
  UnitDescription: null
  Year: null
  Manufacturer: null
  Model: null
  SerialNum: null
  CostCentre: null
  Location: null
  LicensePlate: null
  Status: null
  Operator: null
  DocumentationLink: null
  ParentId: null
  ParentDesc: null
  Vendor: null
  ReadingType: null
  CurrentMeterReading: null
  PurchasePrice: null
  PurchaseDate: null
  WarrantyDate: null
  EQType: null
  Priority: null
  RadioChannels: null
  RentalRate: null
  GVW1: null
  GVW2: null
  Mobility: null
  GLString: null
  POMisc: null
  Miscellaneous1: null
  Miscellaneous2: null
  Warranty_Notes: null
  Warranty_Notes2: null
  SalvageValue: null
  UsefulLife: null
  DeprecMethod: null
  DeprecFactor: null
  Category: null
  Class: null
  Type: null
  DataValidated: null
  SecureLink: null
  AID: null
  FuelType: null
  RateDesc: null
  IMAGE: null
  ReplacementYear: null
  
  Drawing Tool: esriFeatureEditToolNone

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata