{
 "currentVersion": 10.81,
 "id": 14,
 "name": "Cityworks.AZTECA.Flushing_Workorders",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "WORKORDERID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "WORKORDERID",
   "type": "esriFieldTypeString",
   "alias": "WORKORDERID",
   "length": 60,
   "domain": null
  },
  {
   "name": "DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "DESCRIPTION",
   "length": 60,
   "domain": null
  },
  {
   "name": "SUPERVISOR",
   "type": "esriFieldTypeString",
   "alias": "SUPERVISOR",
   "length": 50,
   "domain": null
  },
  {
   "name": "REQUESTEDBY",
   "type": "esriFieldTypeString",
   "alias": "REQUESTEDBY",
   "length": 50,
   "domain": null
  },
  {
   "name": "INITIATEDBY",
   "type": "esriFieldTypeString",
   "alias": "INITIATEDBY",
   "length": 50,
   "domain": null
  },
  {
   "name": "INITIATEDATE",
   "type": "esriFieldTypeDate",
   "alias": "INITIATEDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "PROJECTNAME",
   "type": "esriFieldTypeString",
   "alias": "PROJECTNAME",
   "length": 130,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 256,
   "domain": null
  },
  {
   "name": "PROJSTARTDATE",
   "type": "esriFieldTypeDate",
   "alias": "PROJSTARTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "PROJFINISHDATE",
   "type": "esriFieldTypeDate",
   "alias": "PROJFINISHDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ACTUALSTARTDATE",
   "type": "esriFieldTypeDate",
   "alias": "ACTUALSTARTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ACTUALFINISHDATE",
   "type": "esriFieldTypeDate",
   "alias": "ACTUALFINISHDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "WOCLOSEDBY",
   "type": "esriFieldTypeString",
   "alias": "WOCLOSEDBY",
   "length": 50,
   "domain": null
  },
  {
   "name": "CANCEL",
   "type": "esriFieldTypeString",
   "alias": "CANCEL",
   "length": 1,
   "domain": null
  },
  {
   "name": "PRIORITY",
   "type": "esriFieldTypeString",
   "alias": "PRIORITY",
   "length": 2,
   "domain": null
  },
  {
   "name": "NUMDAYSBEFORE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "NUMDAYSBEFORE",
   "domain": null
  },
  {
   "name": "DATETOBEPRINTED",
   "type": "esriFieldTypeDate",
   "alias": "DATETOBEPRINTED",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATEPRINTED",
   "type": "esriFieldTypeDate",
   "alias": "DATEPRINTED",
   "length": 8,
   "domain": null
  },
  {
   "name": "MAPTEMPLATENAME",
   "type": "esriFieldTypeString",
   "alias": "MAPTEMPLATENAME",
   "length": 250,
   "domain": null
  },
  {
   "name": "WOMAPEXTENT",
   "type": "esriFieldTypeString",
   "alias": "WOMAPEXTENT",
   "length": 1,
   "domain": null
  },
  {
   "name": "WOMAPSCALE",
   "type": "esriFieldTypeInteger",
   "alias": "WOMAPSCALE",
   "domain": null
  },
  {
   "name": "WOOUTPUT",
   "type": "esriFieldTypeString",
   "alias": "WOOUTPUT",
   "length": 1,
   "domain": null
  },
  {
   "name": "SOURCEWOID",
   "type": "esriFieldTypeString",
   "alias": "SOURCEWOID",
   "length": 20,
   "domain": null
  },
  {
   "name": "CYCLETYPE",
   "type": "esriFieldTypeString",
   "alias": "CYCLETYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "CYCLEINTERVALNUM",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CYCLEINTERVALNUM",
   "domain": null
  },
  {
   "name": "CYCLEINTERVALUNIT",
   "type": "esriFieldTypeString",
   "alias": "CYCLEINTERVALUNIT",
   "length": 1,
   "domain": null
  },
  {
   "name": "SCHEDULEDATE",
   "type": "esriFieldTypeDate",
   "alias": "SCHEDULEDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "FROMDATE",
   "type": "esriFieldTypeDate",
   "alias": "FROMDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "WOXCOORDINATE",
   "type": "esriFieldTypeDouble",
   "alias": "WOXCOORDINATE",
   "domain": null
  },
  {
   "name": "WOYCOORDINATE",
   "type": "esriFieldTypeDouble",
   "alias": "WOYCOORDINATE",
   "domain": null
  },
  {
   "name": "SHOP",
   "type": "esriFieldTypeString",
   "alias": "SHOP",
   "length": 100,
   "domain": null
  },
  {
   "name": "WOCATEGORY",
   "type": "esriFieldTypeString",
   "alias": "WOCATEGORY",
   "length": 50,
   "domain": null
  },
  {
   "name": "UNATTACHED",
   "type": "esriFieldTypeString",
   "alias": "UNATTACHED",
   "length": 1,
   "domain": null
  },
  {
   "name": "WOCOST",
   "type": "esriFieldTypeDouble",
   "alias": "WOCOST",
   "domain": null
  },
  {
   "name": "WOLABORCOST",
   "type": "esriFieldTypeDouble",
   "alias": "WOLABORCOST",
   "domain": null
  },
  {
   "name": "WOMATCOST",
   "type": "esriFieldTypeDouble",
   "alias": "WOMATCOST",
   "domain": null
  },
  {
   "name": "WOEQUIPCOST",
   "type": "esriFieldTypeDouble",
   "alias": "WOEQUIPCOST",
   "domain": null
  },
  {
   "name": "WOPERMITCOST",
   "type": "esriFieldTypeDouble",
   "alias": "WOPERMITCOST",
   "domain": null
  },
  {
   "name": "WOTEMPLATEID",
   "type": "esriFieldTypeString",
   "alias": "WOTEMPLATEID",
   "length": 20,
   "domain": null
  },
  {
   "name": "ACCTNUM",
   "type": "esriFieldTypeString",
   "alias": "ACCTNUM",
   "length": 50,
   "domain": null
  },
  {
   "name": "SUBMITTO",
   "type": "esriFieldTypeString",
   "alias": "SUBMITTO",
   "length": 50,
   "domain": null
  },
  {
   "name": "DATESUBMITTO",
   "type": "esriFieldTypeDate",
   "alias": "DATESUBMITTO",
   "length": 8,
   "domain": null
  },
  {
   "name": "SUBMITTOOPENBY",
   "type": "esriFieldTypeString",
   "alias": "SUBMITTOOPENBY",
   "length": 50,
   "domain": null
  },
  {
   "name": "DATESUBMITTOOPEN",
   "type": "esriFieldTypeDate",
   "alias": "DATESUBMITTOOPEN",
   "length": 8,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 50,
   "domain": null
  },
  {
   "name": "CONTRACTORSID",
   "type": "esriFieldTypeDouble",
   "alias": "CONTRACTORSID",
   "domain": null
  },
  {
   "name": "WORKCOMPLETEDBY",
   "type": "esriFieldTypeString",
   "alias": "WORKCOMPLETEDBY",
   "length": 50,
   "domain": null
  },
  {
   "name": "DATEWOCLOSED",
   "type": "esriFieldTypeDate",
   "alias": "DATEWOCLOSED",
   "length": 8,
   "domain": null
  },
  {
   "name": "MAPPAGE",
   "type": "esriFieldTypeString",
   "alias": "MAPPAGE",
   "length": 100,
   "domain": null
  },
  {
   "name": "LEGALBILLABLE",
   "type": "esriFieldTypeString",
   "alias": "LEGALBILLABLE",
   "length": 1,
   "domain": null
  },
  {
   "name": "CONTRBILLABLE",
   "type": "esriFieldTypeString",
   "alias": "CONTRBILLABLE",
   "length": 1,
   "domain": null
  },
  {
   "name": "CANCELLEDBY",
   "type": "esriFieldTypeString",
   "alias": "CANCELLEDBY",
   "length": 50,
   "domain": null
  },
  {
   "name": "DATECANCELLED",
   "type": "esriFieldTypeDate",
   "alias": "DATECANCELLED",
   "length": 8,
   "domain": null
  },
  {
   "name": "CUSTOM1",
   "type": "esriFieldTypeDouble",
   "alias": "CUSTOM1",
   "domain": null
  },
  {
   "name": "CUSTOM2",
   "type": "esriFieldTypeDouble",
   "alias": "CUSTOM2",
   "domain": null
  },
  {
   "name": "CUSTOM3",
   "type": "esriFieldTypeString",
   "alias": "CUSTOM3",
   "length": 20,
   "domain": null
  },
  {
   "name": "CUSTOM4",
   "type": "esriFieldTypeString",
   "alias": "CUSTOM4",
   "length": 20,
   "domain": null
  },
  {
   "name": "CUSTOM5",
   "type": "esriFieldTypeString",
   "alias": "CUSTOM5",
   "length": 40,
   "domain": null
  },
  {
   "name": "UPDATEMAP",
   "type": "esriFieldTypeString",
   "alias": "UPDATEMAP",
   "length": 1,
   "domain": null
  },
  {
   "name": "TILENO",
   "type": "esriFieldTypeString",
   "alias": "TILENO",
   "length": 100,
   "domain": null
  },
  {
   "name": "CYCLEFROM",
   "type": "esriFieldTypeString",
   "alias": "CYCLEFROM",
   "length": 30,
   "domain": null
  },
  {
   "name": "APPLYTOENTITY",
   "type": "esriFieldTypeString",
   "alias": "APPLYTOENTITY",
   "length": 50,
   "domain": null
  },
  {
   "name": "DOMAINID",
   "type": "esriFieldTypeDouble",
   "alias": "DOMAINID",
   "domain": null
  },
  {
   "name": "WOCUSTFIELDCATID",
   "type": "esriFieldTypeDouble",
   "alias": "WOCUSTFIELDCATID",
   "domain": null
  },
  {
   "name": "ASSETGROUP",
   "type": "esriFieldTypeString",
   "alias": "ASSETGROUP",
   "length": 20,
   "domain": null
  },
  {
   "name": "WOADDRESS",
   "type": "esriFieldTypeString",
   "alias": "WOADDRESS",
   "length": 130,
   "domain": null
  },
  {
   "name": "CREATEDBYCYCLE",
   "type": "esriFieldTypeString",
   "alias": "CREATEDBYCYCLE",
   "length": 1,
   "domain": null
  },
  {
   "name": "TRANSTOWOID",
   "type": "esriFieldTypeString",
   "alias": "TRANSTOWOID",
   "length": 20,
   "domain": null
  },
  {
   "name": "STAGE",
   "type": "esriFieldTypeString",
   "alias": "STAGE",
   "length": 20,
   "domain": null
  },
  {
   "name": "EXPENSETYPE",
   "type": "esriFieldTypeString",
   "alias": "EXPENSETYPE",
   "length": 20,
   "domain": null
  },
  {
   "name": "UNITSACCOMPLISHED",
   "type": "esriFieldTypeDouble",
   "alias": "UNITSACCOMPLISHED",
   "domain": null
  },
  {
   "name": "UNITSACCOMPDESC",
   "type": "esriFieldTypeString",
   "alias": "UNITSACCOMPDESC",
   "length": 40,
   "domain": null
  },
  {
   "name": "PROJECTSID",
   "type": "esriFieldTypeDouble",
   "alias": "PROJECTSID",
   "domain": null
  },
  {
   "name": "CONTRACTWOID",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTWOID",
   "length": 30,
   "domain": null
  },
  {
   "name": "STREETNAME",
   "type": "esriFieldTypeString",
   "alias": "STREETNAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "LINEITEMCOST",
   "type": "esriFieldTypeDouble",
   "alias": "LINEITEMCOST",
   "domain": null
  },
  {
   "name": "CANCELREASON",
   "type": "esriFieldTypeString",
   "alias": "CANCELREASON",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT1",
   "type": "esriFieldTypeString",
   "alias": "TEXT1",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT2",
   "type": "esriFieldTypeString",
   "alias": "TEXT2",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT3",
   "type": "esriFieldTypeString",
   "alias": "TEXT3",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT4",
   "type": "esriFieldTypeString",
   "alias": "TEXT4",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT5",
   "type": "esriFieldTypeString",
   "alias": "TEXT5",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT6",
   "type": "esriFieldTypeString",
   "alias": "TEXT6",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT7",
   "type": "esriFieldTypeString",
   "alias": "TEXT7",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT8",
   "type": "esriFieldTypeString",
   "alias": "TEXT8",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT9",
   "type": "esriFieldTypeString",
   "alias": "TEXT9",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT10",
   "type": "esriFieldTypeString",
   "alias": "TEXT10",
   "length": 100,
   "domain": null
  },
  {
   "name": "NUM1",
   "type": "esriFieldTypeDouble",
   "alias": "NUM1",
   "domain": null
  },
  {
   "name": "NUM2",
   "type": "esriFieldTypeDouble",
   "alias": "NUM2",
   "domain": null
  },
  {
   "name": "NUM3",
   "type": "esriFieldTypeDouble",
   "alias": "NUM3",
   "domain": null
  },
  {
   "name": "NUM4",
   "type": "esriFieldTypeDouble",
   "alias": "NUM4",
   "domain": null
  },
  {
   "name": "NUM5",
   "type": "esriFieldTypeDouble",
   "alias": "NUM5",
   "domain": null
  },
  {
   "name": "DATE1",
   "type": "esriFieldTypeDate",
   "alias": "DATE1",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE2",
   "type": "esriFieldTypeDate",
   "alias": "DATE2",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE3",
   "type": "esriFieldTypeDate",
   "alias": "DATE3",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE4",
   "type": "esriFieldTypeDate",
   "alias": "DATE4",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE5",
   "type": "esriFieldTypeDate",
   "alias": "DATE5",
   "length": 8,
   "domain": null
  },
  {
   "name": "DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "DISTRICT",
   "length": 50,
   "domain": null
  },
  {
   "name": "RESOLUTION",
   "type": "esriFieldTypeString",
   "alias": "RESOLUTION",
   "length": 100,
   "domain": null
  },
  {
   "name": "PRIMARYCONTRACTID",
   "type": "esriFieldTypeInteger",
   "alias": "PRIMARYCONTRACTID",
   "domain": null
  },
  {
   "name": "UNITSACCOMPDESCLOCK",
   "type": "esriFieldTypeString",
   "alias": "UNITSACCOMPDESCLOCK",
   "length": 1,
   "domain": null
  },
  {
   "name": "ISREACTIVE",
   "type": "esriFieldTypeString",
   "alias": "ISREACTIVE",
   "length": 1,
   "domain": null
  },
  {
   "name": "EFFORT",
   "type": "esriFieldTypeDouble",
   "alias": "EFFORT",
   "domain": null
  },
  {
   "name": "ACTIVITYZONE",
   "type": "esriFieldTypeString",
   "alias": "ACTIVITYZONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "TEXT11",
   "type": "esriFieldTypeString",
   "alias": "TEXT11",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT12",
   "type": "esriFieldTypeString",
   "alias": "TEXT12",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT13",
   "type": "esriFieldTypeString",
   "alias": "TEXT13",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT14",
   "type": "esriFieldTypeString",
   "alias": "TEXT14",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT15",
   "type": "esriFieldTypeString",
   "alias": "TEXT15",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT16",
   "type": "esriFieldTypeString",
   "alias": "TEXT16",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT17",
   "type": "esriFieldTypeString",
   "alias": "TEXT17",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT18",
   "type": "esriFieldTypeString",
   "alias": "TEXT18",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT19",
   "type": "esriFieldTypeString",
   "alias": "TEXT19",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT20",
   "type": "esriFieldTypeString",
   "alias": "TEXT20",
   "length": 100,
   "domain": null
  },
  {
   "name": "GUID",
   "type": "esriFieldTypeString",
   "alias": "GUID",
   "length": 50,
   "domain": null
  },
  {
   "name": "INITIATEDBYAPP",
   "type": "esriFieldTypeString",
   "alias": "INITIATEDBYAPP",
   "length": 50,
   "domain": null
  },
  {
   "name": "ESRI_OID",
   "type": "esriFieldTypeOID",
   "alias": "ESRI_OID",
   "domain": null
  },
  {
   "name": "SUPERVISORSID",
   "type": "esriFieldTypeInteger",
   "alias": "SUPERVISORSID",
   "domain": null
  },
  {
   "name": "REQUESTEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "REQUESTEDBYSID",
   "domain": null
  },
  {
   "name": "INITIATEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "INITIATEDBYSID",
   "domain": null
  },
  {
   "name": "SUBMITTOSID",
   "type": "esriFieldTypeInteger",
   "alias": "SUBMITTOSID",
   "domain": null
  },
  {
   "name": "SUBMITTOOPENBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "SUBMITTOOPENBYSID",
   "domain": null
  },
  {
   "name": "WORKCOMPLETEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "WORKCOMPLETEDBYSID",
   "domain": null
  },
  {
   "name": "CANCELLEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "CANCELLEDBYSID",
   "domain": null
  },
  {
   "name": "CLOSEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "CLOSEDBYSID",
   "domain": null
  },
  {
   "name": "WORKORDERSID",
   "type": "esriFieldTypeDouble",
   "alias": "WORKORDERSID",
   "domain": null
  },
  {
   "name": "FACILITY_ID",
   "type": "esriFieldTypeString",
   "alias": "FACILITY_ID",
   "length": 256,
   "domain": null
  },
  {
   "name": "LEVEL_ID",
   "type": "esriFieldTypeString",
   "alias": "LEVEL_ID",
   "length": 256,
   "domain": null
  },
  {
   "name": "PROJECTPHASEID",
   "type": "esriFieldTypeInteger",
   "alias": "PROJECTPHASEID",
   "domain": null
  }
 ],
 "indexes": null,
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}