Name: WorkOrder

Display Field: customername

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 100 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• createddate ( type: esriFieldTypeDate, alias: createddate, length: 8 )
• createdby ( type: esriFieldTypeString, alias: createdby, length: 50 )
• startdate ( type: esriFieldTypeDate, alias: startdate, length: 8 )
• completeddate ( type: esriFieldTypeDate, alias: completeddate, length: 8 )
• completedby ( type: esriFieldTypeString, alias: completedby, length: 50 )
• assignedto ( type: esriFieldTypeString, alias: assignedto, length: 1073741822 )
• priority ( type: esriFieldTypeSmallInteger, alias: priority )
• location ( type: esriFieldTypeString, alias: location, length: 255 )
• customername ( type: esriFieldTypeString, alias: customername, length: 255 )
• contactinfo ( type: esriFieldTypeString, alias: contactinfo, length: 255 )
• description ( type: esriFieldTypeString, alias: description, length: 255 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1073741822 )
• iscorrective ( type: esriFieldTypeSmallInteger, alias: iscorrective )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )
• budgetid ( type: esriFieldTypeString, alias: budgetid, length: 50 )
• systemid ( type: esriFieldTypeString, alias: systemid, length: 100 )
• accountnumber ( type: esriFieldTypeString, alias: accountnumber, length: 50 )
• parentworkorderkey ( type: esriFieldTypeString, alias: workorderparentkey, length: 50 )
• xcoordinate ( type: esriFieldTypeDouble, alias: xcoordinate )
• ycoordinate ( type: esriFieldTypeDouble, alias: ycoordinate )
• isrequest ( type: esriFieldTypeSmallInteger, alias: isrequest )
• worktypeid ( type: esriFieldTypeString, alias: worktypeid, length: 50 )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata