Name: data_accounts

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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:

• ACCOUNT_NO (type: esriFieldTypeString, alias: ACCOUNT_NO, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• PROPERTY_ADDRESS (type: esriFieldTypeString, alias: PROPERTY_ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FOLIO_NUMBER (type: esriFieldTypeDouble, alias: FOLIO_NUMBER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OWNER_PHONE (type: esriFieldTypeString, alias: OWNER_PHONE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OCCUPANT_NAME (type: esriFieldTypeString, alias: OCCUPANT_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OCCUPANT_PHONE (type: esriFieldTypeInteger, alias: OCCUPANT_PHONE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SERVICE_DATE (type: esriFieldTypeDate, alias: SERVICE_DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• LEGAL_DESC (type: esriFieldTypeString, alias: LEGAL_DESC, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MAILING_ADDRESS (type: esriFieldTypeString, alias: MAILING_ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LAND_USE_CODE (type: esriFieldTypeDouble, alias: LAND_USE_CODE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TAX_UNITS (type: esriFieldTypeDouble, alias: TAX_UNITS, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• WASTE_UNITS (type: esriFieldTypeDouble, alias: WASTE_UNITS, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ACCOUNT_STATUS (type: esriFieldTypeString, alias: ACCOUNT_STATUS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CREATION_DATE (type: esriFieldTypeString, alias: CREATION_DATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ACCOUNT_PROCESS_TYPE (type: esriFieldTypeString, alias: ACCOUNT_PROCESS_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WCS_ACC_TYPE_DATE (type: esriFieldTypeString, alias: WCS_ACC_TYPE_DATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PICKUP_DAYS (type: esriFieldTypeString, alias: PICKUP_DAYS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• GARBAGE_ROUTE (type: esriFieldTypeString, alias: GARBAGE_ROUTE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• BULKY_BOOK (type: esriFieldTypeInteger, alias: BULKY_BOOK, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TOTAL_UNPAID_BULKY_AMOUNT (type: esriFieldTypeDouble, alias: TOTAL_UNPAID_BULKY_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TOTAL_DELINQUENT_AMOUNT (type: esriFieldTypeDouble, alias: TOTAL_DELINQUENT_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TOTAL_JUDGEMENT_AMOUNT (type: esriFieldTypeDouble, alias: TOTAL_JUDGEMENT_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• WCS_ACC_HANDICAP (type: esriFieldTypeString, alias: WCS_ACC_HANDICAP, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BILLING_STATUS (type: esriFieldTypeString, alias: BILLING_STATUS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FREE_BULKY_YARDAGE (type: esriFieldTypeDouble, alias: FREE_BULKY_YARDAGE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• FREE_BULKY_TRIPS (type: esriFieldTypeDouble, alias: FREE_BULKY_TRIPS, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• OUT_OF_SERVICE_AREA (type: esriFieldTypeString, alias: OUT_OF_SERVICE_AREA, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LAST_BILL_DATE (type: esriFieldTypeString, alias: LAST_BILL_DATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PRIOR_YEAR_UNPAID_AMOUNT (type: esriFieldTypeDouble, alias: PRIOR_YEAR_UNPAID_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PRIOR_YEAR_SERV_TAX_AMOUNT (type: esriFieldTypeDouble, alias: PRIOR_YEAR_SERV_TAX_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PRIOR_YEAR_PENALTY_AMOUNT (type: esriFieldTypeDouble, alias: PRIOR_YEAR_PENALTY_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PRIOR_PENALTY_DATE (type: esriFieldTypeString, alias: PRIOR_PENALTY_DATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MONTH_DELINQUENT_AMOUNT (type: esriFieldTypeDouble, alias: MONTH_DELINQUENT_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• CURRENT_PENALTY_AMOUNT (type: esriFieldTypeDouble, alias: CURRENT_PENALTY_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PENALTY_DATE (type: esriFieldTypeString, alias: PENALTY_DATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CURRENT_SERV_TAX_AMOUNT (type: esriFieldTypeDouble, alias: CURRENT_SERV_TAX_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• CURRENT_FEE_AMOUNT (type: esriFieldTypeDouble, alias: CURRENT_FEE_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• BAD_CHECK_FEE_AMOUNT (type: esriFieldTypeDouble, alias: BAD_CHECK_FEE_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• AMOUNT_PAID (type: esriFieldTypeDouble, alias: AMOUNT_PAID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• CREDIT_BALANCE_AMOUNT (type: esriFieldTypeDouble, alias: CREDIT_BALANCE_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TOTAL_AMOUNT_DUE (type: esriFieldTypeDouble, alias: TOTAL_AMOUNT_DUE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• SERVICE_ITEM_CODE (type: esriFieldTypeString, alias: SERVICE_ITEM_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeInteger, alias: DISTRICT, 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: 12/4/2025 8:32:18 AM

Schema Last Edit Date: 12/4/2025 8:32:18 AM

Data Last Edit Date: 12/4/2025 8:32:18 AM

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