{"data":{"id":"089bb596645b49dfa30a4c6fdd102b7d_0","type":"dataset","attributes":{"errors":[],"access":"public","additionalResources":[],"advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"supportsQueryBins":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsFullTextStopWords":true,"supportsApproxPercentileStatistics":true,"supportsFullTextAccentSensitivity":true,"supportsTimeRelation":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"collection":["Dataset"],"categories":["Metro Government"],"commentsEnabled":true,"composeStatus":{"retries":0,"pass":true,"lastRetriedAt":1789797100736,"lastSuccessAt":1789797100736},"composedAt":1789797100736,"content":"Feature Service","contentSecurityPolicy":null,"created":1711396256000,"currentVersion":12,"description":"<div><span style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:medium;'>Metro vendor payments for the indicated monthly period.  This dataset is updated monthly.</span><br /></div><div><br /></div><div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'>Source Link: <a href='https://www.nashville.gov/departments/finance' style='color:rgb(0, 97, 155); text-decoration-line:none; font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;' target='_blank' rel='nofollow ugc noopener noreferrer'>https://www.nashville.gov/departments/finance</a></font></div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'>Metadata Document: </font><a href='https://nashville.maps.arcgis.com/sharing/rest/content/items/e58e484282fd4992a9a131e21f382fe7/data' style='font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size:15px;' target='_blank' rel='nofollow ugc noopener noreferrer'>Metro Vendor Payments Metadata.pdf</a></div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'>Contact Data Owner: </font><a href='mailto:opendata@nashville.gov?subject=Metro Vendor Payments' style='font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size:15px;' target='_blank' rel='nofollow ugc noopener noreferrer'>opendata@nashville.gov</a></div></div>","displayField":"","downloadable":true,"enrichCoverage":"unknown","enrichQuality":79,"extent":null,"fieldNames":["Operating_Unit","Operating Unit","Supplier_Number","Supplier Number","Invoice_Number","Invoice Number","Distribution_Amount","Distribution Amount","Invoice_Date","Invoice Date","Payment_Date","Payment Date","Payment_Number","Payment Number","Check_Amount","Check Amount","Department_Name","Department Name","Department_Number","Department Number","FID"],"fields":[{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Operating_Unit","length":4000,"alias":"Operating Unit","description":"{\"value\":\"Operating unit or Metro organization associated with the payment record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Supplier_Number","length":4000,"alias":"Supplier Number","description":"{\"value\":\"Unique identifier assigned to the supplier or vendor.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Invoice_Number","length":4000,"alias":"Invoice Number","description":"{\"value\":\"Invoice identifier associated with the vendor payment.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeFloat","isViewOverride":true,"actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Distribution_Amount","alias":"Distribution Amount","description":"{\"value\":\"Monetary amount distributed for the invoice line item.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"actualType":"datetime2","nullable":true,"editable":true,"defaultValue":null,"precision":1,"length":8,"description":"{\"value\":\"Date the invoice was issued or recorded.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate","sqlType":"sqlTypeTimestamp2","isViewOverride":true,"domain":null,"name":"Invoice_Date","alias":"Invoice Date"},{"actualType":"datetime2","nullable":true,"editable":true,"defaultValue":null,"precision":1,"length":8,"description":"{\"value\":\"Date the payment was made.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate","sqlType":"sqlTypeTimestamp2","isViewOverride":true,"domain":null,"name":"Payment_Date","alias":"Payment Date"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Payment_Number","alias":"Payment Number","description":"{\"value\":\"Unique number assigned to the payment transaction.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeFloat","isViewOverride":true,"actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Check_Amount","alias":"Check Amount","description":"{\"value\":\"Total monetary amount of the check issued for payment.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Name","length":4000,"alias":"Department Name","description":"{\"value\":\"Name of the Metro department associated with the payment.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Number","alias":"Department Number","description":"{\"value\":\"Numeric identifier for the Metro department associated with the payment.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"FID","alias":"FID","description":"{\"value\":\"Internal feature record identifier.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"}],"groupIds":["8c9c6d0ef3434041b84116fdff861259"],"hasApi":true,"hubType":"Table","id":"089bb596645b49dfa30a4c6fdd102b7d_0","itemId":"089bb596645b49dfa30a4c6fdd102b7d","itemModified":1711466123000,"itemExtent":[],"layer":{"supportedContingentValuesFormats":"JSON, PBF","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":true,"editingInfo":{"lastEditDate":1789580830919,"schemaLastEditDate":1789580830919,"dataLastEditDate":1774550435016},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsAttachmentsResizing":true,"id":0,"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":32000,"isDataVersioned":false,"templates":[],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsReturnEditResults":true,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF","supportsTranslation":false,"supportsMaxTranslations":10},"supportsQuantizationEditMode":true,"objectIdField":"FID","hasContingentValuesDefinition":false,"viewSourceHasAttachments":false,"name":"Metro_Vendor_Payments_tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Operating_Unit","length":4000,"alias":"Operating Unit","description":"{\"value\":\"Operating unit or Metro organization associated with the payment record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Supplier_Number","length":4000,"alias":"Supplier Number","description":"{\"value\":\"Unique identifier assigned to the supplier or vendor.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Invoice_Number","length":4000,"alias":"Invoice Number","description":"{\"value\":\"Invoice identifier associated with the vendor payment.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeFloat","isViewOverride":true,"actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Distribution_Amount","alias":"Distribution Amount","description":"{\"value\":\"Monetary amount distributed for the invoice line item.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"actualType":"datetime2","nullable":true,"editable":true,"defaultValue":null,"precision":1,"length":8,"description":"{\"value\":\"Date the invoice was issued or recorded.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate","sqlType":"sqlTypeTimestamp2","isViewOverride":true,"domain":null,"name":"Invoice_Date","alias":"Invoice Date"},{"actualType":"datetime2","nullable":true,"editable":true,"defaultValue":null,"precision":1,"length":8,"description":"{\"value\":\"Date the payment was made.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate","sqlType":"sqlTypeTimestamp2","isViewOverride":true,"domain":null,"name":"Payment_Date","alias":"Payment Date"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Payment_Number","alias":"Payment Number","description":"{\"value\":\"Unique number assigned to the payment transaction.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeFloat","isViewOverride":true,"actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Check_Amount","alias":"Check Amount","description":"{\"value\":\"Total monetary amount of the check issued for payment.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Name","length":4000,"alias":"Department Name","description":"{\"value\":\"Name of the Metro department associated with the payment.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Number","alias":"Department Number","description":"{\"value\":\"Numeric identifier for the Metro department associated with the payment.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"FID","alias":"FID","description":"{\"value\":\"Internal feature record identifier.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"respectsDaylightSaving":false,"timeZone":"UTC","timeZoneIANA":"Etc/UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","isUpdatableView":true,"supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__METRO_VE__C1BEA5A24EBA130D","isUnique":true,"description":"clustered, unique, primary key","fields":"FID","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"queryBinsCapabilities":{"supportsAsync":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsFixedIntervalBin":true,"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true,"supportsDateBin":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsStackBy":true,"supportsSplitBy":true,"supportsReturnFullIntervalBin":true,"supportsFirstDayOfWeek":true,"supportsReturnStackValueRange":true,"supportsClassificationBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"supportsQueryBins":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsFullTextStopWords":true,"supportsApproxPercentileStatistics":true,"supportsFullTextAccentSensitivity":true,"supportsTimeRelation":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"serviceItemId":"089bb596645b49dfa30a4c6fdd102b7d","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsPercentileAnalytic":true,"supportsTrendlineRegression":true},"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"FID"},"tileMaxRecordCount":8000,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsLayerOverrides":true,"collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsColumnStoreIndex":true,"guidFormat":"","supportedOperationsWithCollation":"query,addField,updateField","supportsContingentValues":true,"supportsFieldGroups":true,"supportsEditingContingentValues":true,"maxIdsCount":1000000},"layers":[{"supportedContingentValuesFormats":"JSON, PBF","guidFormat":"","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":true,"editingInfo":{"lastEditDate":1789580830919,"schemaLastEditDate":1789580830919,"dataLastEditDate":1774550435016},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsEditingContingentValues":true,"supportsAttachmentsResizing":true,"id":0,"collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":32000,"isDataVersioned":false,"templates":[],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsTranslation":false,"supportsReturnEditResults":true,"supportsMaxTranslations":10,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportsQuantizationEditMode":true,"objectIdField":"FID","hasContingentValuesDefinition":false,"maxIdsCount":1000000,"viewSourceHasAttachments":false,"name":"Metro_Vendor_Payments_tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Operating_Unit","length":4000,"alias":"Operating Unit","description":"{\"value\":\"Operating unit or Metro organization associated with the payment record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Supplier_Number","length":4000,"alias":"Supplier Number","description":"{\"value\":\"Unique identifier assigned to the supplier or vendor.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Invoice_Number","length":4000,"alias":"Invoice Number","description":"{\"value\":\"Invoice identifier associated with the vendor payment.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeFloat","isViewOverride":true,"actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Distribution_Amount","alias":"Distribution Amount","description":"{\"value\":\"Monetary amount distributed for the invoice line item.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"actualType":"datetime2","nullable":true,"editable":true,"defaultValue":null,"precision":1,"length":8,"description":"{\"value\":\"Date the invoice was issued or recorded.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate","sqlType":"sqlTypeTimestamp2","isViewOverride":true,"domain":null,"name":"Invoice_Date","alias":"Invoice Date"},{"actualType":"datetime2","nullable":true,"editable":true,"defaultValue":null,"precision":1,"length":8,"description":"{\"value\":\"Date the payment was made.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate","sqlType":"sqlTypeTimestamp2","isViewOverride":true,"domain":null,"name":"Payment_Date","alias":"Payment Date"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Payment_Number","alias":"Payment Number","description":"{\"value\":\"Unique number assigned to the payment transaction.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeFloat","isViewOverride":true,"actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Check_Amount","alias":"Check Amount","description":"{\"value\":\"Total monetary amount of the check issued for payment.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeNVarchar","isViewOverride":true,"actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Name","length":4000,"alias":"Department Name","description":"{\"value\":\"Name of the Metro department associated with the payment.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Number","alias":"Department Number","description":"{\"value\":\"Numeric identifier for the Metro department associated with the payment.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeInteger","isViewOverride":true,"actualType":"int","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"FID","alias":"FID","description":"{\"value\":\"Internal feature record identifier.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"timeZoneIANA":"Etc/UTC","respectsDaylightSaving":false,"timeZone":"UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","isUpdatableView":true,"supportedOperationsWithCollation":"query,addField,updateField","supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__METRO_VE__C1BEA5A24EBA130D","isUnique":true,"description":"clustered, unique, primary key","fields":"FID","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"queryBinsCapabilities":{"supportsReturnStackValueRange":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsFixedIntervalBin":true,"supportsStackBy":true,"supportsDateBin":true,"supportsSplitBy":true,"supportsClassificationBin":true,"supportsReturnFullIntervalBin":true,"supportsAsync":true,"supportsFirstDayOfWeek":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsTranslations":false,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsAggIds":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsApproxPercentileStatistics":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsReturningQueryExtent":false,"supportsISODOW":true,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsISOWeek":true,"supportsHavingClause":true},"serviceItemId":"089bb596645b49dfa30a4c6fdd102b7d","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"supportsContingentValues":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsTrendlineRegression":true,"supportsPercentileAnalytic":true},"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"FID"},"tileMaxRecordCount":8000,"supportsFieldGroups":true,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsColumnStoreIndex":true,"supportsLayerOverrides":true}],"licenseInfo":null,"maxRecordCount":1000,"metadata":null,"modified":1789580830919,"modifiedProvenance":"layer.editingInfo.lastEditDate","name":"Metro Vendor Payments","objectIdField":"FID","openData":false,"orgId":"HdTo6HJqh92wn4D8","orgName":"Nashville GIS","organization":"Nashville GIS","orgExtent":{"ymin":4295228.852216443,"xmin":-9698309.88519694,"ymax":4357295.044720508,"xmax":-9623402.999842146,"spatialReference":{"wkid":102100}},"orgContactEmail":"mailto: gisdatateam@nashville.gov","owner":"NashvilleOpenData","recordCount":1307617,"region":"US","searchDescription":"Metro vendor payments for the indicated monthly period.  This dataset is updated monthly.  Source Link: https://www.nashville.gov/departments/financeMetadata Document: Metro Vendor Payments Metadata.pdfContact Data Owner: opendata@nashville.gov","sector":"Local and State Government","server":{"supportedContingentValuesFormats":"JSON, PBF","allowGeometryUpdates":true,"supportsQueryContingentValues":true,"isView":true,"supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"supportedConvertContentFormats":"LayerEditCollection","description":"","units":"","isUpdatableView":true,"onlyAllowTrueCurveUpdatesByTrueCurveClients":false,"supportsSharedDomains":true,"hasStaticData":true,"syncEnabled":false,"tables":[{"subLayerIds":null,"maxScale":0,"name":"Metro_Vendor_Payments_tbl","defaultVisibility":true,"id":0,"minScale":0,"parentLayerId":-1}],"hasVersionedData":false,"layerOverridesEnabled":true,"layers":[],"supportedConvertFileFormats":"JSON,PBF","serviceItemId":"089bb596645b49dfa30a4c6fdd102b7d","fullExtent":null,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel","capabilities":"Query,Extract","supportsTrueCurve":true,"supportsAppend":true,"xssPreventionInfo":{"xssInputRule":"rejectInvalid","xssPreventionRule":"InputOnly","xssPreventionEnabled":true},"supportsDisconnectedEditing":false,"sourceSchemaChangesAllowed":true,"supportsContingentValuesJson":2,"supportsTilesAndBasicQueriesMode":true,"preserveLayerIds":true,"supportsReturnDeleteResults":true,"currentVersion":12,"hasSharedDomains":false,"supportsWebHooks":true,"supportsVCSProjection":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsSplit":false,"supportsReturnEditResults":true,"supportsReturnServiceEditsInSourceSR":false,"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportedQueryFormats":"JSON","initialExtent":null,"supportedCurveTypes":["esriGeometryCircularArc"],"allowTrueCurvesUpdates":true,"supportsTemporalLayers":true,"serviceDescription":"","copyrightText":"","supportsLayerOverrides":true,"supportedFullTextLocales":["neutral","ar-SA","bg-BG","bn-IN","ca-ES","cs-CZ","da-DK","de-DE","el-GR","en-GB","en-US","es-ES","fr-FR","gu-IN","he-IL","hi-IN","hr-HR","id-ID","is-IS","it-IT","ja-JP","kn-IN","ko-KR","lt-LT","lv-LV","ml-IN","mr-IN","ms-MY","nb-NO","nl-NL","pa-IN","pl-PL","pt-BR","pt-PT","ro-RO","ru-RU","sk-SK","sl-SI","sr-Cyrl-CS","sr-Latn-CS","sv-SE","ta-IN","te-IN","th-TH","tr-TR","uk-UA","ur-PK","vi-VN","zh-CN","zh-HK","zh-MO","zh-SG","zh-TW"],"supportsSharedTemplates":true,"hasSharedTemplates":true,"supportedAppendCapabilities":"Features","supportedTrueCurvePbfFeatureEncodings":["esriCompressedShapeBuffer","esriDefault"],"trueCurveSupportMode":"OGC","maxIdsCount":1000000},"serverCapabilities":"Query,Extract","size":0,"slug":"Nashville::metro-vendor-payments","source":"Nashville GIS","sourceProvenance":"org.name","statistics":{"string":{"department_name":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":889.0879759999989,"values":[{"count":647648,"value":"MNPS"},{"count":95511,"value":"Administrative"},{"count":79378,"value":"Water and Sewer"},{"count":78118,"value":"General Services"},{"count":57666,"value":"Parks"},{"count":50354,"value":"Police"},{"count":46354,"value":"Public Library"},{"count":30971,"value":"Health"},{"count":30621,"value":"Metro Action Commission"},{"count":28166,"value":"Nashville Department of Transportation"},{"count":27666,"value":"Sheriff"},{"count":23477,"value":"Fire"},{"count":12653,"value":"Convention Center Authority"},{"count":10335,"value":"Information Technology Service"},{"count":5488,"value":"Social Services"},{"count":5383,"value":"Law"},{"count":4587,"value":"Employee Benefit Board"},{"count":4114,"value":"Finance"},{"count":3981,"value":"State Trial Courts"},{"count":3836,"value":"Public Defender"},{"count":3718,"value":"General Sessions Court"},{"count":3521,"value":"Office of Homeless Services"},{"count":3514,"value":"Juvenile Court"},{"count":3513,"value":"Planning Commission"},{"count":3411,"value":"Waste Services"},{"count":3339,"value":"Codes Administration"},{"count":3321,"value":"Board of Fair Commissioners"},{"count":2796,"value":"Municipal Auditorium"},{"count":2596,"value":"Department of Emergency Communications"},{"count":2581,"value":"Office of Family Safety"},{"count":2554,"value":"Farmer's Market"},{"count":2207,"value":"Assessor of Property"},{"count":2103,"value":"District Attorney"},{"count":2068,"value":"Arts Commission"},{"count":1821,"value":"MTA"},{"count":1499,"value":"Human Resources"},{"count":1494,"value":"County Clerk"},{"count":1311,"value":"Office of Emergency Management"},{"count":1214,"value":"Criminal Court Clerk"},{"count":1142,"value":"Historical Commission"},{"count":979,"value":"Metropolitan Council"},{"count":924,"value":"Election Commission"},{"count":920,"value":"Mayor's Office"},{"count":902,"value":"Sports Authority"},{"count":873,"value":"Trustee"},{"count":843,"value":"Circuit Court Clerk"},{"count":826,"value":"Debt Service"},{"count":822,"value":"Metropolitan Clerk"},{"count":708,"value":"DES-District Energy System"},{"count":521,"value":"Clerk and Master - Chancery"}],"count":1307609,"uniqueCount":68}},"operating_unit":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":113.52995300000111,"values":[{"count":658073,"value":"METRO_GG"},{"count":649544,"value":"METRO_MNPS"}],"count":1307617,"uniqueCount":2}},"invoice_number":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":20117.356610999996,"values":[{"count":574,"value":"INV6905263"},{"count":570,"value":"INV6359139"},{"count":569,"value":"INV6512249"},{"count":568,"value":"INV6955639"},{"count":567,"value":"INV6561799"},{"count":563,"value":"INV6611182"},{"count":560,"value":"INV6214519"},{"count":560,"value":"INV6681807"},{"count":558,"value":"INV6230612"},{"count":554,"value":"INV6804266"},{"count":553,"value":"INV6774990"},{"count":553,"value":"INV7770841"},{"count":552,"value":"INV7105356"},{"count":551,"value":"INV6139166"},{"count":551,"value":"INV7259948"},{"count":551,"value":"INV7678133"},{"count":546,"value":"INV6308976"},{"count":546,"value":"INV7294403"},{"count":544,"value":"INV6078368"},{"count":544,"value":"INV6660358"},{"count":543,"value":"INV7344690"},{"count":540,"value":"INV7723411"},{"count":539,"value":"INV7440381"},{"count":534,"value":"INV7488789"},{"count":532,"value":"INV7394887"},{"count":532,"value":"INV7812676"},{"count":530,"value":"INV4969993"},{"count":528,"value":"INV4826789"},{"count":528,"value":"INV6052088"},{"count":523,"value":"INV7201674"},{"count":521,"value":"INV5020092"},{"count":521,"value":"INV7150473"},{"count":516,"value":"INV6852458"},{"count":500,"value":"INV6261117"},{"count":472,"value":"INV6402220"},{"count":467,"value":"INV4866185"},{"count":466,"value":"INV7627884"},{"count":460,"value":"INV7548247"},{"count":436,"value":"INV4920373"},{"count":418,"value":"INV7001687"},{"count":415,"value":"INV7059009"},{"count":359,"value":"INV6455654"},{"count":310,"value":"INV7582189"},{"count":188,"value":"101"},{"count":169,"value":"24600"},{"count":147,"value":"240502PARKS"},{"count":139,"value":"IN245827"},{"count":139,"value":"IN245827AA"},{"count":139,"value":"IN245992"},{"count":139,"value":"IN246613"}],"count":96637,"uniqueCount":2000}},"supplier_number":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":217.16784000000007,"values":[{"count":77678,"value":"336"},{"count":59300,"value":"3422"},{"count":48231,"value":"21969"},{"count":45452,"value":"1010328"},{"count":41029,"value":"7841"},{"count":39857,"value":"4777"},{"count":39142,"value":"1002609"},{"count":39026,"value":"282"},{"count":33095,"value":"1004787"},{"count":23489,"value":"2074"},{"count":21019,"value":"1013891"},{"count":14553,"value":"214958"},{"count":14406,"value":"532"},{"count":11940,"value":"100007"},{"count":11586,"value":"388"},{"count":11580,"value":"1000405"},{"count":10620,"value":"5308"},{"count":9693,"value":"8505"},{"count":8828,"value":"216"},{"count":7952,"value":"12122"},{"count":6865,"value":"125"},{"count":6569,"value":"1450"},{"count":6069,"value":"1968"},{"count":5605,"value":"23084"},{"count":5598,"value":"1001129"},{"count":5450,"value":"6"},{"count":5384,"value":"1237"},{"count":5271,"value":"6571"},{"count":5168,"value":"4220"},{"count":5114,"value":"14367"},{"count":5091,"value":"979"},{"count":5057,"value":"286"},{"count":5036,"value":"2478"},{"count":5018,"value":"470"},{"count":4990,"value":"23621"},{"count":4619,"value":"23936"},{"count":4536,"value":"22170"},{"count":4384,"value":"137"},{"count":4318,"value":"2075"},{"count":4283,"value":"1830"},{"count":4270,"value":"4041"},{"count":4135,"value":"416183"},{"count":4121,"value":"17706"},{"count":4052,"value":"9117"},{"count":3847,"value":"1007101"},{"count":3799,"value":"259908"},{"count":3753,"value":"1135"},{"count":3750,"value":"26556"},{"count":3704,"value":"23453"},{"count":3673,"value":"2531"}],"count":1226633,"uniqueCount":2000}}},"numeric":{"payment_number":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":790.6743659999993,"values":{"avg":587671.9465363328,"min":6,"max":80705805,"var":1607669543231.9995,"count":1307617,"sum":768449827714,"stddev":1267939.0928715777}}},"distribution_amount":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":790.6743659999993,"values":{"avg":9926.114649863712,"min":-18693077.28,"max":65000000,"var":33614152384.533283,"count":1307617,"sum":12979556260.110838,"stddev":183341.62752777472}}},"check_amount":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":790.6743659999993,"values":{"avg":103567.30762141138,"min":0,"max":297666706.62,"var":7944937242832.933,"count":1307617,"sum":135426372089.98709,"stddev":2818676.5055310857}}},"department_number":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":790.6743659999993,"values":{"avg":56.46217049793632,"min":1,"max":91,"var":814.8515718352608,"count":1307617,"sum":73830894,"stddev":28.545605122947748}}}},"date":{"payment_date":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":277.0361699999994,"values":{"min":1656633600000,"max":1767139200000,"count":1307617}}},"invoice_date":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":277.0361699999994,"values":{"min":667958400000,"max":3585945600000,"count":1307617}}}},"objectid":{"fid":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":302.6163430000015,"values":{"avg":653809,"min":1,"max":1307617,"count":1307617,"sum":854931763153}}}}},"structuredLicense":{"type":"none"},"license":"none","supportedQueryFormats":"JSON, geoJSON, PBF","supportsAdvancedQueries":true,"tags":["budget","finance","supplier","money","department","vendor","invoice","checks","expenditures","payment","payments","financial"],"thumbnail":"thumbnail/thumbnail1711396388092.png","thumbnailUrl":"thumbnail/thumbnail1711396388092.png","type":"Table","typeCategories":["Dataset"],"typeKeywords":["ArcGIS Server","Data","Feature Access","Feature Service","Service","Singlelayer","Table","Hosted Service","View Service"],"url":"https://services2.arcgis.com/HdTo6HJqh92wn4D8/arcgis/rest/services/Metro_Vendor_Payments_view/FeatureServer/0","useStandardizedQueries":true,"validExtent":true,"xFrameOptions":null,"boundary":null,"snippet":"Metro vendor payments for the indicated monthly period.  This dataset is updated monthly.","culture":""},"links":{"self":"https://hub.arcgis.com/api/v3/datasets/089bb596645b49dfa30a4c6fdd102b7d_0","rawEs":"https://hub.arcgis.com/api/es/datasets/089bb596645b49dfa30a4c6fdd102b7d_0","itemPage":"https://www.arcgis.com/home/item.html?id=089bb596645b49dfa30a4c6fdd102b7d","esriRest":"https://www.arcgis.com/sharing/content/items/089bb596645b49dfa30a4c6fdd102b7d?f=json"},"meta":{"highlights":{},"matchedFields":[]}},"meta":{"apiRoot":"https://hub.arcgis.com/api/v3/","resourceRoot":"https://hub.arcgis.com/api/v3/datasets","request":"https://hub.arcgis.com/api/v3/datasets/089bb596645b49dfa30a4c6fdd102b7d_0"}}