Name: flFleet

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 15000

Supported Query Formats: JSON

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 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 20 )
• FEATURETYPE ( type: esriFieldTypeString, alias: VEHICLECLASS, length: 50 , Coded Values: [Boat: Boat] , [Boat Engine: Boat Engine] , [Bus: Bus] , ...16 more... )
• FEATURESTATUS ( type: esriFieldTypeString, alias: FEATURESTATUS, length: 20 , Coded Values: [Active: Active] , [Active- NIF: Active- NIF] , [Sold: Sold] )
• EQDESCRIPTION ( type: esriFieldTypeString, alias: EQDESCRIPTION, length: 100 )
• VEHICLE ( type: esriFieldTypeSmallInteger, alias: VEHICLE , Coded Values: [0: False] , [1: True] )
• VEHICLECLASS ( type: esriFieldTypeString, alias: VEHICLECLASS, length: 50 )
• FINANCESTATUS ( type: esriFieldTypeString, alias: FINANCESTATUS, length: 10 , Coded Values: [E: E] , [ER: ER] , [EX: EX] , ...3 more... )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, length: 50 , Coded Values: [ROW Team: ROW Team] , [Water Utility: Water Utility] , [Sewer Utility: Sewer Utility] , ...11 more... )
• EMPLOYEE ( type: esriFieldTypeString, alias: EMPLOYEE, length: 100 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 25 )
• LICENSEPLATENO ( type: esriFieldTypeString, alias: LICENSEPLATENO, length: 50 )
• MODELNUM ( type: esriFieldTypeString, alias: MODELNUM, length: 50 )
• VEHICLEYEAR ( type: esriFieldTypeString, alias: VEHICLEYEAR, length: 15 )
• DRIVETRAIN ( type: esriFieldTypeString, alias: DRIVETRAIN, length: 25 , Coded Values: [4x4: 4x4] , [All Wheel Drive (AWD): All Wheel Drive (AWD)] , [Other: Other] , ...2 more... )
• SERIALVIN ( type: esriFieldTypeString, alias: SERIALVIN, length: 25 )
• FUELTYPE ( type: esriFieldTypeString, alias: FUELTYPE, length: 20 , Coded Values: [Unleaded: Unleaded] , [Diesel: Diesel] , [Natural Gas: Natural Gas] , ...6 more... )
• CHIPKEYNO ( type: esriFieldTypeString, alias: CHIPKEYNO, length: 30 )
• CHIPKEYPIN ( type: esriFieldTypeString, alias: CHIPKEYPIN, length: 30 )
• METERREADING ( type: esriFieldTypeDouble, alias: METERREADING )
• METERUNIT ( type: esriFieldTypeString, alias: METERUNIT, length: 20 , Coded Values: [Miles: Miles] , [Hours: Hours] , [NA: NA] , ...2 more... )
• FUELSYSTEMMETERREAD ( type: esriFieldTypeDouble, alias: FUELSYSTEMMETERREAD )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• PURCHASEDATE ( type: esriFieldTypeDate, alias: PURCHASEDATE, length: 8 )
• PURCHASEORDER ( type: esriFieldTypeString, alias: PURCHASEORDER, length: 25 )
• PURCHASEPRICE ( type: esriFieldTypeDouble, alias: PURCHASEPRICE )
• PURCHASEPRICEEQUIP ( type: esriFieldTypeString, alias: PURCHASEPRICEEQUIP, length: 25 )
• DRACCOUNT ( type: esriFieldTypeString, alias: DRACCOUNT, length: 20 )
• VENDOR ( type: esriFieldTypeString, alias: VENDOR, length: 100 )
• TOTALCOSTOFVEHICLE ( type: esriFieldTypeString, alias: TOTALCOSTOFVEHICLE, length: 25 )
• USEDATE ( type: esriFieldTypeDate, alias: USEDATE, length: 8 )
• SOLDDATE ( type: esriFieldTypeDate, alias: SOLDDATE, length: 8 )
• SOLDPRICE ( type: esriFieldTypeString, alias: SOLDPRICE, length: 20 )
• VEHICLEREPLACED ( type: esriFieldTypeString, alias: VEHICLEREPLACED, length: 25 )
• DATEREPLACED ( type: esriFieldTypeDate, alias: DATEREPLACED, length: 8 )
• ESTIMATEREPLYEAR ( type: esriFieldTypeSmallInteger, alias: ESTIMATEREPLYEAR )
• ACTUALREPLYEAR ( type: esriFieldTypeSmallInteger, alias: ACTUALREPLYEAR )
• DEPRECIATIONVALUE ( type: esriFieldTypeString, alias: DEPRECIATIONVALUE, length: 50 )
• CHARGERATE ( type: esriFieldTypeDouble, alias: CHARGERATE )
• LIFEEXPECTANCY ( type: esriFieldTypeSmallInteger, alias: LIFEEXPECTANCY )
• FINANCERATECLASS ( type: esriFieldTypeString, alias: FINANCERATECLASS, length: 50 , Coded Values: [010- Class 1: Passenger Cars: 010- Class 1: Passenger Cars] , [011- Class 1: Passenger Vans: 011- Class 1: Passenger Vans] , [012- Class 1: Passenger SUVs: 012- Class 1: Passenger SUVs] , ...54 more... )
• NAFACODE ( type: esriFieldTypeString, alias: NAFACODE, length: 30 )
• COF ( type: esriFieldTypeSmallInteger, alias: COF )
• POF ( type: esriFieldTypeSmallInteger, alias: POF )
• BRE ( type: esriFieldTypeSmallInteger, alias: BRE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• UPDATESOURCE ( type: esriFieldTypeString, alias: UPDATESOURCE, length: 255 )
• UPDATEBY ( type: esriFieldTypeString, alias: UPDATEBY, length: 20 )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, length: 8 )
• PHOTOLINK ( type: esriFieldTypeString, alias: PHOTOLINK, length: 255 )
• RECEIVEDDATE ( type: esriFieldTypeDate, alias: RECEIVEDDATE, length: 8 )
• ASSETWEIGHT ( type: esriFieldTypeInteger, alias: ASSETWEIGHT )
• ASSETGVWR ( type: esriFieldTypeString, alias: ASSETGVWR, length: 100 )
• ECOLOGYBODYTYPE ( type: esriFieldTypeString, alias: ECOLOGYBODYTYPE, length: 255 )
• ECOLOGYWEIGHTBIN ( type: esriFieldTypeString, alias: ECOLOGYWEIGHTBIN, length: 255 )
• GPS ( type: esriFieldTypeString, alias: GPS, length: 255 )
• TOW ( type: esriFieldTypeString, alias: TOW, length: 255 )
• SHORTID ( type: esriFieldTypeString, alias: SHORTID, length: 10 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata