{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 50, "name": "Purchase Card Transactions", "type": "Table", "description": "DC government is providing Purchase Card transaction data. The Purchase Card Program Management Office is part of the Office of Contracting and Procurement.In an effort to promote transparency and accountability, DC is providing Purchase Card transaction data to let taxpayers know how their tax dollars are being spent. Purchase Card transaction information is updated monthly. The Purchase Card Program Management Office is part of the Office of Contracting and Procurement.", "copyrightText": "Office of Contracting and Procurement", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "VENDOR_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "AGENCY", "type": "esriFieldTypeString", "alias": "Agency", "length": 100, "domain": null }, { "name": "TRANSACTION_DATE", "type": "esriFieldTypeDate", "alias": "Transaction Date", "length": 8, "domain": null }, { "name": "TRANSACTION_AMOUNT", "type": "esriFieldTypeDouble", "alias": "Transaction Amount", "domain": null }, { "name": "VENDOR_NAME", "type": "esriFieldTypeString", "alias": "Vendor Name", "length": 50, "domain": null }, { "name": "VENDOR_STATE_PROVINCE", "type": "esriFieldTypeString", "alias": "Vendor State Province", "length": 5, "domain": null }, { "name": "MCC_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Merchant Category Classification Description", "length": 50, "domain": null }, { "name": "DCS_LAST_MOD_DTTM", "type": "esriFieldTypeDate", "alias": "Last Modified Date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "OBJECTID" ], "OIDFieldContainsHashValue": false }, "maxUniqueIDCount": 100000 }