{ "currentVersion": 10.81, "id": 53, "name": "ConsumerMeter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DIVISIONNAME", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "CONFIGURATIONCHANGEDATE", "type": "esriFieldTypeDate", "alias": "Configuration Change Date", "length": 8 }, { "name": "ENERGY_METER_NO", "type": "esriFieldTypeString", "alias": "Energy Meter No", "length": 50 }, { "name": "ENERGY_METER_TYPE", "type": "esriFieldTypeString", "alias": "Energy Meter Type", "length": 50 }, { "name": "ENERGY_METER_MAKE", "type": "esriFieldTypeString", "alias": "Energy Meter Make", "length": 50 }, { "name": "ENERGY_METER_CLASS", "type": "esriFieldTypeString", "alias": "Energy Meter Class", "length": 50 }, { "name": "ENERGY_METER_INSTL_DATE", "type": "esriFieldTypeDate", "alias": "Energy Meter Installation Date", "length": 8 }, { "name": "ENERGY_METER_VIEW_GLASS", "type": "esriFieldTypeDouble", "alias": "Energy Meter View Glass" }, { "name": "ENERGY_METER_SEAL", "type": "esriFieldTypeString", "alias": "Energy Meter Seal", "length": 254 }, { "name": "ENERGY_METER_LOC", "type": "esriFieldTypeString", "alias": "Energy Meter Location", "length": 50 }, { "name": "ENERGY_METER_MOUNT_HT", "type": "esriFieldTypeDouble", "alias": "Energy Meter Mounting Height" }, { "name": "ENERGY_METER_CLUSTER", "type": "esriFieldTypeString", "alias": "Energy Meter Cluster", "length": 50 }, { "name": "ENERGY_METER_SERIAL_NO", "type": "esriFieldTypeString", "alias": "Energy Meter Serial No", "length": 50 }, { "name": "ENERGY_METER_LAB_NO", "type": "esriFieldTypeString", "alias": "Energy Meter Lab No", "length": 50 }, { "name": "ENERGY_METER_SEAL_TYPE", "type": "esriFieldTypeString", "alias": "Energy Meter Seal Type", "length": 50 }, { "name": "ENERGY_METER_SEAL_COND", "type": "esriFieldTypeString", "alias": "Energy Meter Seal Condition", "length": 60 }, { "name": "ENERGY_METER_COLOR_CODE", "type": "esriFieldTypeString", "alias": "Energy Meter Colour Code", "length": 50 }, { "name": "METER_ROOM_INDEPENDENT_ENTRY", "type": "esriFieldTypeString", "alias": "Meter Room Independent Entry", "length": 50 }, { "name": "ENERGY_METER_STATUS", "type": "esriFieldTypeString", "alias": "Energy Meter Status", "length": 50 }, { "name": "RELKNO", "type": "esriFieldTypeString", "alias": "RELKNO", "length": 50 }, { "name": "SYNERGENID", "type": "esriFieldTypeString", "alias": "Synergen ID", "length": 17 }, { "name": "WORKORDERNO", "type": "esriFieldTypeString", "alias": "Work Order Number", "length": 30 }, { "name": "MEASUREMENT_UNIT", "type": "esriFieldTypeString", "alias": "Measurement Unit", "length": 30 }, { "name": "RELGISID", "type": "esriFieldTypeString", "alias": "RELGISID", "length": 50 }, { "name": "WEBEDITOR", "type": "esriFieldTypeString", "alias": "Webeditor", "length": 50 }, { "name": "ACCOUNTNUMBER", "type": "esriFieldTypeString", "alias": "Account Number", "length": 50 }, { "name": "MRDBD", "type": "esriFieldTypeInteger", "alias": "Meter Reading Digits Before Decimal" }, { "name": "MRDAD", "type": "esriFieldTypeInteger", "alias": "Meter Reading Digits After Decimal" }, { "name": "MEASUREMENTTYPE", "type": "esriFieldTypeString", "alias": "Measurement Type", "length": 50 }, { "name": "ENERGY_MERTER_TAMPER", "type": "esriFieldTypeString", "alias": "Energy Meter Tamper", "length": 60 }, { "name": "DIVISIONNAME", "type": "esriFieldTypeString", "alias": "Division Name", "length": 50 }, { "name": "CI_SURVEY_UNIQUE_ID", "type": "esriFieldTypeString", "alias": "CI Survey Unique ID", "length": 255 }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Creation User", "length": 30 }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8 }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 30 }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8 }, { "name": "GISID", "type": "esriFieldTypeString", "alias": "GIS ID", "length": 20 }, { "name": "FEEDERCODE", "type": "esriFieldTypeString", "alias": "Feeder Code", "length": 50 }, { "name": "FEEDERNAME", "type": "esriFieldTypeString", "alias": "Feeder Name", "length": 50 }, { "name": "PROJECTSOURCE", "type": "esriFieldTypeString", "alias": "Project Source", "length": 20 }, { "name": "TOWNNAME", "type": "esriFieldTypeString", "alias": "Town Name", "length": 50 } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_612_RELGISID", "fields": "RELGISID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "CustomerInfo", "relatedTableId": 54, "role": "esriRelRoleDestination", "keyField": "RELGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "serviceItemId": "657b4be6c7d44a1ea13742338cb80bf9" }