Name: Fleet Assets

Display Field: EQUIPMENTID

Type: Table

Geometry Type: N/A

Description:

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 )
• EQUIPMENTID ( type: esriFieldTypeString, alias: EQUIPMENTID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EQUIPMENTID )
• LEGACYID ( type: esriFieldTypeString, alias: LEGACYID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEGACYID )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPTION )
• EQUIPMENT_YEAR ( type: esriFieldTypeSmallInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Equipment_Year )
• MAKE ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAKE , Coded Values: [Admiral: Admiral] , [AGCO: AGCO] , [Alamo: Alamo] , ...74 more... )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODEL )
• LICENCE ( type: esriFieldTypeString, alias: Licence Plate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Licence )
• SERIAL_NUM ( type: esriFieldTypeString, alias: VIN orSerial #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Serial_Num )
• CHARGE_TO ( type: esriFieldTypeString, alias: CHARGE_TO, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CHARGE_TO )
• PURCHASE_DATE ( type: esriFieldTypeDate, alias: PURCHASE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PURCHASE_DATE )
• LIFE_CYCLE ( type: esriFieldTypeDouble, alias: LIFE_CYCLE, editable: true, nullable: true, defaultValue: null, modelName: LIFE_CYCLE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• ODOMETERREADING ( type: esriFieldTypeDouble, alias: ODOMETERREADING, editable: true, nullable: true, defaultValue: null, modelName: ODOMETERREADING )
• SITEID ( type: esriFieldTypeInteger, alias: SITEID, editable: true, nullable: true, defaultValue: null, modelName: SITEID )
• GPS ( type: esriFieldTypeString, alias: GPS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPS , Coded Values: [Yes: Yes] , [No: No] )
• ENGINE_SIZE ( type: esriFieldTypeString, alias: ENGINE_SIZE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ENGINE_SIZE )
• IMAGE_FIELD ( type: esriFieldTypeString, alias: IMAGE_FIELD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IMAGE_FIELD )
• FRONT_TIRE ( type: esriFieldTypeString, alias: FrontTire, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Front_Tire )
• REAR_TIRE ( type: esriFieldTypeString, alias: Rear, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Rear_Tire )
• WARRANTY_DATE ( type: esriFieldTypeDate, alias: WARRANTY_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTY_DATE )
• RATE ( type: esriFieldTypeString, alias: RATE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RATE )
• PURCHASE_PRICE ( type: esriFieldTypeString, alias: PURCHASE_PRICE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PURCHASE_PRICE )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [In Service: In Service] , [Sold: Sold] )
• RELATIONSHIPCLASS ( type: esriFieldTypeInteger, alias: RelationshipClass, editable: true, nullable: true, defaultValue: 1, modelName: RELATIONSHIPCLASS )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• RATE_NUM ( type: esriFieldTypeDouble, alias: RATE_NUM, editable: true, nullable: true, defaultValue: null, modelName: RATE_NUM )
• PURCHASE_PRICE_NUM ( type: esriFieldTypeDouble, alias: PURCHASE_PRICE_NUM, editable: true, nullable: true, defaultValue: null, modelName: PURCHASE_PRICE_NUM )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATOR )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITOR ( type: esriFieldTypeString, alias: LAST_EDITOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITOR )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: Fleet Assets
  Description:
  Prototype:
  RATE_NUM: null
  EQUIPMENTID: null
  LEGACYID: null
  DESCRIPTION: null
  EQUIPMENT_YEAR: null
  MAKE: null
  MODEL: null
  LICENCE: null
  SERIAL_NUM: null
  CHARGE_TO: null
  PURCHASE_DATE: null
  LIFE_CYCLE: null
  COMMENTS: null
  ODOMETERREADING: null
  SITEID: null
  GPS: null
  ENGINE_SIZE: null
  IMAGE_FIELD: null
  FRONT_TIRE: null
  REAR_TIRE: null
  WARRANTY_DATE: null
  RATE: null
  PURCHASE_PRICE: null
  PURCHASE_PRICE_NUM: null
  STATUS: null
  RELATIONSHIPCLASS: 1
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GISADMIN.Ajax_Border_Polygon (0) -- Related To: Ajax Border (0)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CREATED_DATE
• Creator Field: CREATOR
• Edit Date Field: LAST_EDITED_DATE
• Editor Field: LAST_EDITOR

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

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