{ "currentVersion": 10.81, "id": 33, "name": "CustomerInfo", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CUST_NAME", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "ACCOUNTNUMBER", "type": "esriFieldTypeString", "alias": "Account Number", "length": 50 }, { "name": "DATASOURCE", "type": "esriFieldTypeString", "alias": "Data Source", "length": 20 }, { "name": "MONTHCD", "type": "esriFieldTypeString", "alias": "Month", "length": 10 }, { "name": "SERVICEADDRESSOBJECTID", "type": "esriFieldTypeInteger", "alias": "Service Address ObjectID" }, { "name": "HYPERLINK", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255 }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255 }, { "name": "CUST_NAME", "type": "esriFieldTypeString", "alias": "Cust Name", "length": 254 }, { "name": "CUST_OCC_NAME", "type": "esriFieldTypeString", "alias": "Cust_Occ_Name", "length": 50 }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 50 }, { "name": "CUST_PAN_NO", "type": "esriFieldTypeString", "alias": "Cust Pan No", "length": 100 }, { "name": "CUST_FATHER_NAME", "type": "esriFieldTypeString", "alias": "Customer Father Name", "length": 254 }, { "name": "CUST_HUSBAND_NAME", "type": "esriFieldTypeString", "alias": "Customer Husband Name", "length": 254 }, { "name": "CUST_ADD_LINE1", "type": "esriFieldTypeString", "alias": "Customer Address Line1", "length": 254 }, { "name": "CUST_ADD_LINE2", "type": "esriFieldTypeString", "alias": "Customer Address Line2", "length": 254 }, { "name": "LEFTSIDEHOUSECIN", "type": "esriFieldTypeString", "alias": "Left Side House CIN", "length": 50 }, { "name": "RIGHTSIDEHOUSECIN", "type": "esriFieldTypeString", "alias": "Right Side House CIN", "length": 50 }, { "name": "COLONYNAME", "type": "esriFieldTypeString", "alias": "Colony Name", "length": 50 }, { "name": "WARDNUMBER", "type": "esriFieldTypeString", "alias": "Ward Number", "length": 50 }, { "name": "BPLNUMBER", "type": "esriFieldTypeString", "alias": "BPL Number", "length": 50 }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "Email", "length": 70 }, { "name": "GOVTEMPLOYEE", "type": "esriFieldTypeString", "alias": "Goverment Employee", "length": 50 }, { "name": "POLENAME", "type": "esriFieldTypeString", "alias": "Pole Name", "length": 50 }, { "name": "ZONEMATCH", "type": "esriFieldTypeString", "alias": "Zone Match", "length": 50 }, { "name": "ZONENAME", "type": "esriFieldTypeString", "alias": "Zone Name", "length": 50 }, { "name": "KHASARA_METER_NO", "type": "esriFieldTypeString", "alias": "Khasara Meter No", "length": 50 }, { "name": "PHONE_NO_MOBILE", "type": "esriFieldTypeString", "alias": "Mobile Phone No", "length": 50 }, { "name": "PHONE_NO_LL", "type": "esriFieldTypeString", "alias": "Landline Phone No", "length": 50 }, { "name": "CON_TOT_LOAD", "type": "esriFieldTypeDouble", "alias": "Connected Total Load" }, { "name": "ESTIMATED_LOAD", "type": "esriFieldTypeDouble", "alias": "Estimated Load" }, { "name": "SANCTIONED_LOAD", "type": "esriFieldTypeDouble", "alias": "Sanction Load" }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "Service Type", "length": 50 }, { "name": "BPL", "type": "esriFieldTypeString", "alias": "BPL", "length": 50 }, { "name": "DEPTEMPLOYEE", "type": "esriFieldTypeString", "alias": "Department Employee", "length": 50 }, { "name": "KNO", "type": "esriFieldTypeString", "alias": "KNO", "length": 100 }, { "name": "HV2NO", "type": "esriFieldTypeString", "alias": "HV2NO", "length": 50 }, { "name": "SCNO", "type": "esriFieldTypeString", "alias": "SCNO", "length": 50 }, { "name": "BOOKNO", "type": "esriFieldTypeString", "alias": "BOOKNO", "length": 50 }, { "name": "CINNUMBER", "type": "esriFieldTypeString", "alias": "CIN Number", "length": 50 }, { "name": "FIRMNAME", "type": "esriFieldTypeString", "alias": "Firm Name", "length": 50 }, { "name": "AREANAME", "type": "esriFieldTypeString", "alias": "Area Name", "length": 50 }, { "name": "POLECODE", "type": "esriFieldTypeString", "alias": "Pole Code", "length": 50 }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "BuildingID", "length": 50 }, { "name": "BUILDINGFLOORNUMBER", "type": "esriFieldTypeString", "alias": "Building Floor Number", "length": 50 }, { "name": "SUPPLYVOLTAGE", "type": "esriFieldTypeString", "alias": "Supply Voltage", "length": 50 }, { "name": "RATEDVOLTAGE", "type": "esriFieldTypeString", "alias": "Rated Voltage", "length": 50 }, { "name": "POWERFACTOR", "type": "esriFieldTypeString", "alias": "Power Factor", "length": 50 }, { "name": "DOUBLEMETER", "type": "esriFieldTypeString", "alias": "Double Meter", "length": 50 }, { "name": "METERCTRATIO", "type": "esriFieldTypeString", "alias": "Meter CT Ratio", "length": 50 }, { "name": "LINECTRATIO", "type": "esriFieldTypeString", "alias": "Line CT Ratio", "length": 50 }, { "name": "BUSVECTORGROUP", "type": "esriFieldTypeString", "alias": "Bus Vector Group", "length": 50 }, { "name": "CONNECTEDCIRCUIT", "type": "esriFieldTypeString", "alias": "Connected Circuit", "length": 50 }, { "name": "LTCIRCUITENO", "type": "esriFieldTypeSmallInteger", "alias": "LT Circuit Number" }, { "name": "SUPPLYPHASE", "type": "esriFieldTypeString", "alias": "Supply Phase", "length": 50 }, { "name": "SUPPLYTYPE", "type": "esriFieldTypeString", "alias": "Supply Type", "length": 50 }, { "name": "ACTUALUSE", "type": "esriFieldTypeString", "alias": "Actual Use", "length": 50 }, { "name": "READINGFOUND", "type": "esriFieldTypeString", "alias": "Reading Found", "length": 50 }, { "name": "SERVICECABLELENGTH", "type": "esriFieldTypeDouble", "alias": "Service Cable Length" }, { "name": "CONSUMERSTATUS", "type": "esriFieldTypeString", "alias": "Consumer Status", "length": 50 }, { "name": "SUPPLY_RELEASE_DATE", "type": "esriFieldTypeString", "alias": "Supply Relese Date", "length": 50 }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 50 }, { "name": "METERCOLORCODE", "type": "esriFieldTypeString", "alias": "Meter Colour Code", "length": 50 }, { "name": "CONFIGURATIONCHANGEDATE", "type": "esriFieldTypeDate", "alias": "Configuration Change Date", "length": 8 }, { "name": "CCB_NC_INSERTED", "type": "esriFieldTypeString", "alias": "CCB NC Inserted", "length": 50 }, { "name": "CON_CORELATION", "type": "esriFieldTypeString", "alias": "Con_corelation", "length": 50 }, { "name": "SERVICECABLESIZE", "type": "esriFieldTypeString", "alias": "Service Cable Size", "length": 50 }, { "name": "PINNO", "type": "esriFieldTypeDouble", "alias": "PINNo" }, { "name": "GISID", "type": "esriFieldTypeString", "alias": "GIS ID", "length": 20 }, { "name": "WEBEDITOR", "type": "esriFieldTypeString", "alias": "Webeditor", "length": 50 }, { "name": "TARRIF_CAT", "type": "esriFieldTypeString", "alias": "Tarrif_CAT", "length": 8 }, { "name": "METERROOM_INDEPENDENTENTRY", "type": "esriFieldTypeString", "alias": "Meter Room Independent Entry", "length": 50 }, { "name": "GROUPCODE", "type": "esriFieldTypeInteger", "alias": "Group Code" }, { "name": "DTRGISID", "type": "esriFieldTypeString", "alias": "DTR GIS ID", "length": 50 }, { "name": "DTRWISEWALKSEQNO", "type": "esriFieldTypeInteger", "alias": "DTR Wise Walking Sequence Number" }, { "name": "DTRWISEPOLENO", "type": "esriFieldTypeInteger", "alias": "DTR Wise Pole Number" }, { "name": "PHASEDESIGNATION", "type": "esriFieldTypeInteger", "alias": "Phase Designation" }, { "name": "DIVISIONNAME", "type": "esriFieldTypeString", "alias": "Division Name", "length": 50 }, { "name": "SERVICEPOINTGISID", "type": "esriFieldTypeString", "alias": "Service Point GISID", "length": 50 }, { "name": "SURVEY_BUILDINGID", "type": "esriFieldTypeString", "alias": "Survey Building ID", "length": 50 }, { "name": "SUBSTATIONNAME", "type": "esriFieldTypeString", "alias": "Substation Name", "length": 50 }, { "name": "FEEDERNAME", "type": "esriFieldTypeString", "alias": "Feeder Name", "length": 255 }, { "name": "DTR_TCODE", "type": "esriFieldTypeString", "alias": "DTR_T Code", "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": "TOWNNAME", "type": "esriFieldTypeString", "alias": "Town Name", "length": 50 }, { "name": "FEEDERCODE", "type": "esriFieldTypeString", "alias": "Feeder Code", "length": 20 }, { "name": "PROJECTSOURCE", "type": "esriFieldTypeString", "alias": "Project Source", "length": 20 }, { "name": "TEMPPOLECODE", "type": "esriFieldTypeString", "alias": "TEMPPOLECODE", "length": 255 }, { "name": "RECORDTYPE", "type": "esriFieldTypeInteger", "alias": "Record Type" } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_613_GISID", "fields": "GISID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_613_DTRGISID", "fields": "DTRGISID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_613_BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "ConsumerMeter", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "GISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "DistributionTransformer", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "DTRGISID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "ServicePoint", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000000, "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": "a82c79f2345744b3a37e90ec02b654c1" }