Name: flFleet

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: flFleet
  Description:
  Prototype:
  TOW: null
  SHORTID: null
  ASSETID: null
  FEATURETYPE: null
  FEATURESTATUS: Active
  EQDESCRIPTION: null
  VEHICLE: 1
  VEHICLECLASS: null
  FINANCESTATUS: null
  DEPARTMENT: null
  EMPLOYEE: null
  MANUFACTURER: null
  LICENSEPLATENO: null
  MODELNUM: null
  VEHICLEYEAR: null
  DRIVETRAIN: null
  SERIALVIN: null
  FUELTYPE: null
  CHIPKEYNO: null
  CHIPKEYPIN: null
  METERREADING: null
  METERUNIT: null
  FUELSYSTEMMETERREAD: null
  LOCATION: null
  PURCHASEDATE: null
  PURCHASEORDER: null
  PURCHASEPRICE: null
  PURCHASEPRICEEQUIP: null
  DRACCOUNT: null
  VENDOR: null
  TOTALCOSTOFVEHICLE: null
  USEDATE: null
  SOLDDATE: null
  SOLDPRICE: null
  VEHICLEREPLACED: null
  DATEREPLACED: null
  ESTIMATEREPLYEAR: null
  ACTUALREPLYEAR: null
  DEPRECIATIONVALUE: null
  CHARGERATE: null
  LIFEEXPECTANCY: null
  FINANCERATECLASS: null
  NAFACODE: null
  COF: null
  POF: null
  BRE: null
  COMMENTS: null
  UPDATESOURCE: null
  UPDATEBY: null
  UPDATEDATE: null
  PHOTOLINK: null
  RECEIVEDDATE: null
  ASSETWEIGHT: null
  ASSETGVWR: null
  ECOLOGYBODYTYPE: null
  ECOLOGYWEIGHTBIN: null
  GPS: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata