Name: WorkOrder

Display Field: customername

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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

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: System-maintained ObjectID )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workorderkey )
• worktype ( type: esriFieldTypeString, alias: worktype, editable: true, nullable: true, length: 100, defaultValue: null, modelName: worktype )
• status ( type: esriFieldTypeString, alias: status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status )
• createddate ( type: esriFieldTypeDate, alias: createddate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: createddate )
• createdby ( type: esriFieldTypeString, alias: createdby, editable: true, nullable: true, length: 50, defaultValue: null, modelName: createdby )
• startdate ( type: esriFieldTypeDate, alias: startdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: startdate )
• completeddate ( type: esriFieldTypeDate, alias: completeddate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: completeddate )
• completedby ( type: esriFieldTypeString, alias: completedby, editable: true, nullable: true, length: 50, defaultValue: null, modelName: completedby )
• assignedto ( type: esriFieldTypeString, alias: assignedto, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: assignedto )
• priority ( type: esriFieldTypeSmallInteger, alias: priority, editable: true, nullable: true, defaultValue: null, modelName: priority )
• location ( type: esriFieldTypeString, alias: location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: location )
• customername ( type: esriFieldTypeString, alias: customername, editable: true, nullable: true, length: 255, defaultValue: null, modelName: customername )
• contactinfo ( type: esriFieldTypeString, alias: contactinfo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: contactinfo )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: comments )
• iscorrective ( type: esriFieldTypeSmallInteger, alias: iscorrective, editable: true, nullable: true, defaultValue: null, modelName: iscorrective )
• change_status ( type: esriFieldTypeString, alias: change_status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: change_status )
• budgetid ( type: esriFieldTypeString, alias: budgetid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: budgetid )
• systemid ( type: esriFieldTypeString, alias: systemid, editable: true, nullable: true, length: 100, defaultValue: null, modelName: systemid )
• accountnumber ( type: esriFieldTypeString, alias: accountnumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: accountnumber )
• parentworkorderkey ( type: esriFieldTypeString, alias: workorderparentkey, editable: true, nullable: true, length: 50, defaultValue: null, modelName: parentworkorderkey )
• xcoordinate ( type: esriFieldTypeDouble, alias: xcoordinate, editable: true, nullable: true, defaultValue: null, modelName: xcoordinate )
• ycoordinate ( type: esriFieldTypeDouble, alias: ycoordinate, editable: true, nullable: true, defaultValue: null, modelName: ycoordinate )
• isrequest ( type: esriFieldTypeSmallInteger, alias: isrequest, editable: true, nullable: true, defaultValue: null, modelName: isrequest )
• worktypeid ( type: esriFieldTypeString, alias: worktypeid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: worktypeid )

Templates:

• Name: WorkOrder
  Description:
  Prototype:
  isrequest: null
  worktypeid: null
  workorderkey: null
  worktype: null
  status: null
  createddate: null
  createdby: null
  startdate: null
  completeddate: null
  completedby: null
  assignedto: null
  priority: null
  location: null
  customername: null
  contactinfo: null
  description: null
  comments: null
  iscorrective: null
  change_status: null
  budgetid: null
  systemid: null
  accountnumber: null
  parentworkorderkey: null
  xcoordinate: null
  ycoordinate: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata