{ "currentVersion": 10.4, "id": 3, "name": "sde.gistech.curr_billing_lease_view", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "billed_fromthru", "typeIdField": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeInteger", "alias": "objectid", "domain": null }, { "name": "ar_doc", "type": "esriFieldTypeInteger", "alias": "ar_doc", "domain": null }, { "name": "ke", "type": "esriFieldTypeSmallInteger", "alias": "ke", "domain": null }, { "name": "lease_num", "type": "esriFieldTypeInteger", "alias": "lease_num", "domain": null }, { "name": "lse_code", "type": "esriFieldTypeSmallInteger", "alias": "lse_code", "domain": null }, { "name": "rolonum", "type": "esriFieldTypeInteger", "alias": "rolonum", "domain": null }, { "name": "billed_fromthru", "type": "esriFieldTypeString", "alias": "billed_fromthru", "length": 50, "domain": null }, { "name": "billed_date", "type": "esriFieldTypeString", "alias": "billed_date", "length": 20, "domain": null }, { "name": "due_date", "type": "esriFieldTypeString", "alias": "due_date", "length": 20, "domain": null }, { "name": "billed_date2", "type": "esriFieldTypeDate", "alias": "billed_date2", "length": 8, "domain": null }, { "name": "due_date2", "type": "esriFieldTypeDate", "alias": "due_date2", "length": 8, "domain": null }, { "name": "status_code", "type": "esriFieldTypeSmallInteger", "alias": "status_code", "domain": null }, { "name": "status_desc", "type": "esriFieldTypeString", "alias": "status_desc", "length": 30, "domain": null }, { "name": "bill_type", "type": "esriFieldTypeString", "alias": "bill_type", "length": 40, "domain": null }, { "name": "moneytype_sub", "type": "esriFieldTypeString", "alias": "moneytype_sub", "length": 100, "domain": null }, { "name": "billed_amt", "type": "esriFieldTypeDouble", "alias": "billed_amt", "domain": null }, { "name": "collected_amt", "type": "esriFieldTypeDouble", "alias": "collected_amt", "domain": null }, { "name": "balance_amt", "type": "esriFieldTypeDouble", "alias": "balance_amt", "domain": null }, { "name": "fiscal_year", "type": "esriFieldTypeSmallInteger", "alias": "fiscal_year", "domain": null }, { "name": "billcycle_receipt", "type": "esriFieldTypeString", "alias": "billcycle_receipt", "length": 50, "domain": null } ], "indexes": [ { "name": "r52_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true }, "dateFieldsTimeReference": null }