Name: Vendor_Spending

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• check_number (type: esriFieldTypeInteger, alias: check_number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• check_date (type: esriFieldTypeString, alias: check_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• check_amount (type: esriFieldTypeDouble, alias: check_amount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• status_code (type: esriFieldTypeString, alias: status_code, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• party_type (type: esriFieldTypeString, alias: party_type, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• vendor_type (type: esriFieldTypeString, alias: vendor_type, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• vendor_name (type: esriFieldTypeString, alias: vendor_name, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: state, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: zip, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• country (type: esriFieldTypeString, alias: country, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• payment_number (type: esriFieldTypeInteger, alias: payment_number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• period_name (type: esriFieldTypeDate, alias: period_name, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• accounting_date (type: esriFieldTypeString, alias: accounting_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• invoice_payment_dist_amount (type: esriFieldTypeDouble, alias: invoice_payment_dist_amount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• invoice_source (type: esriFieldTypeString, alias: invoice_source, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• invoice_number (type: esriFieldTypeString, alias: invoice_number, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• invoice_amount (type: esriFieldTypeDouble, alias: invoice_amount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• invoice_date (type: esriFieldTypeString, alias: invoice_date, SQL Type: sqlTypeNVarchar, length: 257, nullable: true, editable: true)
• fund_desc (type: esriFieldTypeString, alias: fund_desc, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• agency_desc (type: esriFieldTypeString, alias: agency_desc, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• approp_desc (type: esriFieldTypeString, alias: approp_desc, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• costcenter_desc (type: esriFieldTypeString, alias: costcenter_desc, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• object_desc (type: esriFieldTypeString, alias: object_desc, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• object_desc_shorthand (type: esriFieldTypeString, alias: object_desc_shorthand, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• fiscal_year (type: esriFieldTypeInteger, alias: fiscal_year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/6/2021 8:38:21 PM

Schema Last Edit Date: 1/6/2021 8:38:21 PM

Data Last Edit Date: 1/6/2021 8:38:21 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat