{ "currentVersion": 10.81, "id": 205, "name": "gs53515.DBO.gs_cau_items_ref", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "gs_guid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "gs_guid", "type": "esriFieldTypeString", "alias": "gs_guid", "length": 38, "domain": null }, { "name": "gs_stock_number", "type": "esriFieldTypeString", "alias": "gs_stock_number", "length": 20, "domain": null }, { "name": "gs_description", "type": "esriFieldTypeString", "alias": "gs_description", "length": 60, "domain": null }, { "name": "gs_group", "type": "esriFieldTypeString", "alias": "gs_group", "length": 8, "domain": null }, { "name": "gs_unit_of_measure", "type": "esriFieldTypeString", "alias": "gs_unit_of_measure", "length": 8, "domain": null }, { "name": "gs_qty_on_hand", "type": "esriFieldTypeInteger", "alias": "gs_qty_on_hand", "domain": null }, { "name": "gs_sag_factor_pct", "type": "esriFieldTypeDouble", "alias": "gs_sag_factor_pct", "domain": null }, { "name": "gs_vc_revision", "type": "esriFieldTypeInteger", "alias": "gs_vc_revision", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "gs_type", "type": "esriFieldTypeString", "alias": "gs_type", "length": 4, "domain": null }, { "name": "gs_vc_modified_sw", "type": "esriFieldTypeSmallInteger", "alias": "gs_vc_modified_sw", "domain": null }, { "name": "gs_item_cost", "type": "esriFieldTypeDouble", "alias": "gs_item_cost", "domain": null }, { "name": "gs_item_overhead_pct", "type": "esriFieldTypeDouble", "alias": "gs_item_overhead_pct", "domain": null } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I16gs_stock_numb", "fields": "gs_stock_number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I16gs_guid", "fields": "gs_guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 } }