Tables:

Table: Order (6)

Name: Order

Display Field: orderid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bca0a3d67ed04cc0846f1cbcecbc4098

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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
Feature Draw Order:
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: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• orderid ( modelName: orderid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: OrderID, type: esriFieldTypeString )
• centerid ( modelName: centerid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: CenterID, type: esriFieldTypeString )
• planneddate ( modelName: planneddate, nullable: true, editable: true, defaultValue: null, alias: PlannedDate, type: esriFieldTypeDateOnly )
• mealtype ( modelName: mealtype, nullable: true, editable: true, defaultValue: null, length: 8000, alias: MealType, type: esriFieldTypeString )
• requiredqty ( modelName: requiredqty, nullable: true, editable: true, defaultValue: null, alias: RequiredQty, type: esriFieldTypeDouble )
• assignedpersonid ( modelName: assignedpersonid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: AssignedPersonID, type: esriFieldTypeString )
• priority ( modelName: priority, nullable: true, editable: true, defaultValue: null, alias: Priority, type: esriFieldTypeInteger )
• routeno ( modelName: routeno, nullable: true, editable: true, defaultValue: null, alias: RouteNo, type: esriFieldTypeInteger )
• stopseq ( modelName: stopseq, nullable: true, editable: true, defaultValue: null, alias: StopSeq, type: esriFieldTypeInteger )
• windowstart ( modelName: windowstart, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: WindowStart, type: esriFieldTypeDate )
• windowend ( modelName: windowend, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: WindowEnd, type: esriFieldTypeDate )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Notes, type: esriFieldTypeString )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Status, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
Templates:
• Name: Order
  Description:
  Prototype:
  centerid: null
  planneddate: null
  notes: null
  orderid: null
  windowstart: null
  assignedpersonid: null
  priority: null
  stopseq: null
  requiredqty: null
  mealtype: null
  windowend: null
  routeno: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone