{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 48, "name": "SIG.ASSET", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ANCESTOR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ANCESTOR", "type": "esriFieldTypeString", "alias": "ANCESTOR", "length": 25, "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeDouble", "alias": "ASSETID", "domain": null }, { "name": "ASSETNUM", "type": "esriFieldTypeString", "alias": "ASSETNUM", "length": 25, "domain": null }, { "name": "ASSETTAG", "type": "esriFieldTypeString", "alias": "ASSETTAG", "length": 15, "domain": null }, { "name": "ASSETTYPE", "type": "esriFieldTypeString", "alias": "ASSETTYPE", "length": 25, "domain": null }, { "name": "ASSETUID", "type": "esriFieldTypeDouble", "alias": "ASSETUID", "domain": null }, { "name": "AUTOWOGEN", "type": "esriFieldTypeDouble", "alias": "AUTOWOGEN", "domain": null }, { "name": "BINNUM", "type": "esriFieldTypeString", "alias": "BINNUM", "length": 8, "domain": null }, { "name": "BUDGETCOST", "type": "esriFieldTypeDouble", "alias": "BUDGETCOST", "domain": null }, { "name": "CALNUM", "type": "esriFieldTypeString", "alias": "CALNUM", "length": 8, "domain": null }, { "name": "CHANGEBY", "type": "esriFieldTypeString", "alias": "CHANGEBY", "length": 30, "domain": null }, { "name": "CHANGEDATE", "type": "esriFieldTypeDate", "alias": "CHANGEDATE", "length": 8, "domain": null }, { "name": "CHILDREN", "type": "esriFieldTypeDouble", "alias": "CHILDREN", "domain": null }, { "name": "CLASSSTRUCTUREID", "type": "esriFieldTypeString", "alias": "CLASSSTRUCTUREID", "length": 20, "domain": null }, { "name": "CONDITIONCODE", "type": "esriFieldTypeString", "alias": "CONDITIONCODE", "length": 30, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 100, "domain": null }, { "name": "DISABLED", "type": "esriFieldTypeDouble", "alias": "DISABLED", "domain": null }, { "name": "EQ1", "type": "esriFieldTypeString", "alias": "EQ1", "length": 12, "domain": null }, { "name": "EQ10", "type": "esriFieldTypeString", "alias": "EQ10", "length": 10, "domain": null }, { "name": "EQ11", "type": "esriFieldTypeString", "alias": "EQ11", "length": 10, "domain": null }, { "name": "EQ12", "type": "esriFieldTypeString", "alias": "EQ12", "length": 1, "domain": null }, { "name": "EQ2", "type": "esriFieldTypeString", "alias": "EQ2", "length": 12, "domain": null }, { "name": "EQ23", "type": "esriFieldTypeString", "alias": "EQ23", "length": 50, "domain": null }, { "name": "EQ24", "type": "esriFieldTypeString", "alias": "EQ24", "length": 1, "domain": null }, { "name": "EQ3", "type": "esriFieldTypeString", "alias": "EQ3", "length": 10, "domain": null }, { "name": "EQ4", "type": "esriFieldTypeString", "alias": "EQ4", "length": 25, "domain": null }, { "name": "EQ5", "type": "esriFieldTypeString", "alias": "EQ5", "length": 1, "domain": null }, { "name": "EQ6", "type": "esriFieldTypeString", "alias": "EQ6", "length": 8, "domain": null }, { "name": "EQ7", "type": "esriFieldTypeString", "alias": "EQ7", "length": 50, "domain": null }, { "name": "EQ8", "type": "esriFieldTypeString", "alias": "EQ8", "length": 20, "domain": null }, { "name": "EQ9", "type": "esriFieldTypeString", "alias": "EQ9", "length": 10, "domain": null }, { "name": "EXTERNALREFID", "type": "esriFieldTypeString", "alias": "EXTERNALREFID", "length": 10, "domain": null }, { "name": "FAILURECODE", "type": "esriFieldTypeString", "alias": "FAILURECODE", "length": 8, "domain": null }, { "name": "GLACCOUNT", "type": "esriFieldTypeString", "alias": "GLACCOUNT", "length": 20, "domain": null }, { "name": "GROUPNAME", "type": "esriFieldTypeString", "alias": "GROUPNAME", "length": 10, "domain": null }, { "name": "HASLD", "type": "esriFieldTypeDouble", "alias": "HASLD", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "INVCOST", "type": "esriFieldTypeDouble", "alias": "INVCOST", "domain": null }, { "name": "ISRUNNING", "type": "esriFieldTypeDouble", "alias": "ISRUNNING", "domain": null }, { "name": "ITEMNUM", "type": "esriFieldTypeString", "alias": "ITEMNUM", "length": 30, "domain": null }, { "name": "ITEMSETID", "type": "esriFieldTypeString", "alias": "ITEMSETID", "length": 82, "domain": null }, { "name": "ITEMTYPE", "type": "esriFieldTypeString", "alias": "ITEMTYPE", "length": 12, "domain": null }, { "name": "LANGCODE", "type": "esriFieldTypeString", "alias": "LANGCODE", "length": 4, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAINTHIERCHY", "type": "esriFieldTypeDouble", "alias": "MAINTHIERCHY", "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 15, "domain": null }, { "name": "MOVED", "type": "esriFieldTypeDouble", "alias": "MOVED", "domain": null }, { "name": "ORGID", "type": "esriFieldTypeString", "alias": "ORGID", "length": 8, "domain": null }, { "name": "OWNERSYSID", "type": "esriFieldTypeString", "alias": "OWNERSYSID", "length": 10, "domain": null }, { "name": "PARENT", "type": "esriFieldTypeString", "alias": "PARENT", "length": 25, "domain": null }, { "name": "PRIORITY", "type": "esriFieldTypeDouble", "alias": "PRIORITY", "domain": null }, { "name": "PURCHASEPRICE", "type": "esriFieldTypeDouble", "alias": "PURCHASEPRICE", "domain": null }, { "name": "REPLACECOST", "type": "esriFieldTypeDouble", "alias": "REPLACECOST", "domain": null }, { "name": "ROTSUSPACCT", "type": "esriFieldTypeString", "alias": "ROTSUSPACCT", "length": 20, "domain": null }, { "name": "SENDERSYSID", "type": "esriFieldTypeString", "alias": "SENDERSYSID", "length": 50, "domain": null }, { "name": "SERIALNUM", "type": "esriFieldTypeString", "alias": "SERIALNUM", "length": 64, "domain": null }, { "name": "SHIFTNUM", "type": "esriFieldTypeString", "alias": "SHIFTNUM", "length": 8, "domain": null }, { "name": "SITEID", "type": "esriFieldTypeString", "alias": "SITEID", "length": 8, "domain": null }, { "name": "SOURCESYSID", "type": "esriFieldTypeString", "alias": "SOURCESYSID", "length": 10, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 20, "domain": null }, { "name": "STATUSDATE", "type": "esriFieldTypeDate", "alias": "STATUSDATE", "length": 8, "domain": null }, { "name": "TOOLCONTROLACCOUNT", "type": "esriFieldTypeString", "alias": "TOOLCONTROLACCOUNT", "length": 20, "domain": null }, { "name": "TOOLRATE", "type": "esriFieldTypeDouble", "alias": "TOOLRATE", "domain": null }, { "name": "TOTALCOST", "type": "esriFieldTypeDouble", "alias": "TOTALCOST", "domain": null }, { "name": "TOTDOWNTIME", "type": "esriFieldTypeDouble", "alias": "TOTDOWNTIME", "domain": null }, { "name": "TOTUNCHARGEDCOST", "type": "esriFieldTypeDouble", "alias": "TOTUNCHARGEDCOST", "domain": null }, { "name": "UNCHARGEDCOST", "type": "esriFieldTypeDouble", "alias": "UNCHARGEDCOST", "domain": null }, { "name": "USAGE", "type": "esriFieldTypeString", "alias": "USAGE", "length": 15, "domain": null }, { "name": "VENDOR", "type": "esriFieldTypeString", "alias": "VENDOR", "length": 15, "domain": null }, { "name": "WARRANTYEXPDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYEXPDATE", "length": 8, "domain": null }, { "name": "YTDCOST", "type": "esriFieldTypeDouble", "alias": "YTDCOST", "domain": null }, { "name": "EQ13", "type": "esriFieldTypeDate", "alias": "EQ13", "length": 8, "domain": null }, { "name": "EQ14", "type": "esriFieldTypeString", "alias": "EQ14", "length": 25, "domain": null }, { "name": "EQ15", "type": "esriFieldTypeDouble", "alias": "EQ15", "domain": null }, { "name": "EQ16", "type": "esriFieldTypeString", "alias": "EQ16", "length": 1, "domain": null }, { "name": "EQ17", "type": "esriFieldTypeString", "alias": "EQ17", "length": 25, "domain": null }, { "name": "EQ18", "type": "esriFieldTypeString", "alias": "EQ18", "length": 20, "domain": null }, { "name": "EQ19", "type": "esriFieldTypeString", "alias": "EQ19", "length": 12, "domain": null }, { "name": "EQ20", "type": "esriFieldTypeString", "alias": "EQ20", "length": 10, "domain": null }, { "name": "EQ21", "type": "esriFieldTypeString", "alias": "EQ21", "length": 1, "domain": null }, { "name": "EQ22", "type": "esriFieldTypeString", "alias": "EQ22", "length": 50, "domain": null }, { "name": "ROWSTAMP", "type": "esriFieldTypeString", "alias": "ROWSTAMP", "length": 40, "domain": null }, { "name": "EQCLASS", "type": "esriFieldTypeString", "alias": "EQCLASS", "length": 10, "domain": null }, { "name": "STATE", "type": "esriFieldTypeInteger", "alias": "STATE", "domain": null }, { "name": "RUE_LIB", "type": "esriFieldTypeString", "alias": "RUE_LIB", "length": 250, "domain": null }, { "name": "COMMUNE_LIB", "type": "esriFieldTypeString", "alias": "COMMUNE_LIB", "length": 250, "domain": null }, { "name": "PARENT_LIB", "type": "esriFieldTypeString", "alias": "PARENT_LIB", "length": 250, "domain": null }, { "name": "BUDGET_AFF", "type": "esriFieldTypeString", "alias": "BUDGET_AFF", "length": 16, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "ASSET_NDX", "fields": "ASSETUID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ASSET_NDX10", "fields": "STATUS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ASSET_NDX12", "fields": "ASSETNUM", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ASSET_NDX13", "fields": "EQCLASS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ASSET_NDX2", "fields": "PARENT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_CHANGEBY", "fields": "CHANGEBY", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2a57ae212f9e4229b9bde5fd0b6c860c" }