Name: Munis Account Records
Display Field: Primary_Name
Type: Table
Geometry Type: N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
Account_Number
(
type: esriFieldTypeString, alias: Account Number, editable: true, nullable: false, length: 30, defaultValue: null, modelName: Account_Number
)
-
Start_Date
(
type: esriFieldTypeDate, alias: Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Start_Date
)
-
Stop_Date
(
type: esriFieldTypeDate, alias: Stop Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Stop_Date
)
-
Account_Type
(
type: esriFieldTypeString, alias: Account Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Account_Type
)
-
Parcel_ID
(
type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Parcel_ID
)
-
Read_Location
(
type: esriFieldTypeString, alias: Read Location, editable: true, nullable: true, length: 65, defaultValue: null, modelName: Read_Location
)
-
District
(
type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 2, defaultValue: null, modelName: District
)
-
Service_Unit
(
type: esriFieldTypeString, alias: Service Unit, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Service_Unit
)
-
Service_City
(
type: esriFieldTypeString, alias: Service City, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Service_City
)
-
Service_Lot
(
type: esriFieldTypeString, alias: Service Lot, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Service_Lot
)
-
Steet_Number
(
type: esriFieldTypeInteger, alias: Steet Number, editable: true, nullable: true, defaultValue: null, modelName: Steet_Number
)
-
Streer_Suffix
(
type: esriFieldTypeString, alias: Streer Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Streer_Suffix
)
-
Streer_Post_Direction
(
type: esriFieldTypeString, alias: Street Post Direction, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Streer_Post_Direction
)
-
Streer_Pre_Direction
(
type: esriFieldTypeString, alias: Street Pre Direction, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Streer_Pre_Direction
)
-
Street_Type
(
type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Street_Type
)
-
Service_Street
(
type: esriFieldTypeString, alias: Service Street, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Service_Street
)
-
Service_Zip_Code
(
type: esriFieldTypeString, alias: Service Zip Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Service_Zip_Code
)
-
Account_Create_Date
(
type: esriFieldTypeDate, alias: Account Create Date, editable: true, nullable: false, length: 8, defaultValue: null, modelName: Account_Create_Date
)
-
Read_Sequence
(
type: esriFieldTypeInteger, alias: Read Sequence, editable: true, nullable: true, defaultValue: null, modelName: Read_Sequence
)
-
Route_Book
(
type: esriFieldTypeString, alias: Route Book, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Route_Book
)
-
Backflow_Required
(
type: esriFieldTypeString, alias: Backflow Required, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Backflow_Required
)
-
Customer_ID
(
type: esriFieldTypeInteger, alias: Customer ID, editable: true, nullable: true, defaultValue: null, modelName: Customer_ID
)
-
Addtional_Adress
(
type: esriFieldTypeSmallInteger, alias: Addtional Address, editable: true, nullable: true, defaultValue: null, modelName: Addtional_Adress
)
-
Hold_Bill
(
type: esriFieldTypeString, alias: Hold Bill, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Hold_Bill
)
-
Phone_Number
(
type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Phone_Number
)
-
Billable
(
type: esriFieldTypeString, alias: Billable, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Billable
)
-
Delivery_Method
(
type: esriFieldTypeString, alias: Delivery Method, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Delivery_Method
)
-
Billing_Comment
(
type: esriFieldTypeString, alias: Billing Comment, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Billing_Comment
)
-
Account_Key
(
type: esriFieldTypeInteger, alias: Account Key, editable: true, nullable: true, defaultValue: null, modelName: Account_Key
)
-
Customer_Start_Date
(
type: esriFieldTypeDate, alias: Customer Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Customer_Start_Date
)
-
Meter_Size
(
type: esriFieldTypeString, alias: Meter Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Meter_Size
)
-
Meter_Serial
(
type: esriFieldTypeString, alias: Meter Serial, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Meter_Serial
)
-
Meter_Install
(
type: esriFieldTypeDate, alias: Meter Install, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Meter_Install
)
-
Meter_Remote
(
type: esriFieldTypeString, alias: Meter Remote, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Meter_Remote
)
-
Service_Status
(
type: esriFieldTypeString, alias: Service Status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Service_Status
)
-
Type_
(
type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type_
)
-
Acitve
(
type: esriFieldTypeString, alias: Acitve, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Acitve
)
-
Update_Date
(
type: esriFieldTypeDate, alias: Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Update_Date
)
-
Update_By
(
type: esriFieldTypeString, alias: Update By, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Update_By
)
-
Primary_Name
(
type: esriFieldTypeString, alias: Primary Name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Primary_Name
)
-
Secondary_Name
(
type: esriFieldTypeString, alias: Secondary Name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Secondary_Name
)
-
Mailing_Name_1
(
type: esriFieldTypeString, alias: Mailing Address, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Mailing_Name_1
)
-
Mailing_Name_2
(
type: esriFieldTypeString, alias: Mailing Address 2, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Mailing_Name_2
)
-
Mailing_Name_3
(
type: esriFieldTypeString, alias: Mailing Address 3, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Mailing_Name_3
)
-
Customer_Phone
(
type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Customer_Phone
)
-
Customer_Email
(
type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Customer_Email
)
-
Phone_Type
(
type: esriFieldTypeString, alias: Phone Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Phone_Type
)
-
Primary_Address
(
type: esriFieldTypeString, alias: Primary Address, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Primary_Address
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
Templates:
-
Name: Munis Account Records
Description:
Prototype:
Primary_Address: null
Phone_Type: null
Account_Number:
Start_Date: null
Stop_Date: null
Account_Type: null
Parcel_ID: null
Read_Location: null
District: null
Service_Unit: null
Service_City: null
Service_Lot: null
Steet_Number: null
Streer_Suffix: null
Streer_Post_Direction: null
Streer_Pre_Direction: null
Street_Type: null
Service_Street: null
Service_Zip_Code: null
Account_Create_Date: -2209161600000
Read_Sequence: null
Route_Book: null
Backflow_Required: null
Customer_ID: null
Addtional_Adress: null
Hold_Bill: null
Phone_Number: null
Billable: null
Delivery_Method: null
Billing_Comment: null
Account_Key: null
Customer_Start_Date: null
Meter_Size: null
Meter_Serial: null
Meter_Install: null
Meter_Remote: null
Service_Status: null
Type_: null
Acitve: null
Update_Date: null
Update_By: null
Primary_Name: null
Secondary_Name: null
Mailing_Name_1: null
Mailing_Name_2: null
Mailing_Name_3: null
Customer_Phone: null
Customer_Email: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: true
Supports OidReservation: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: true
Supports Coordinates Quantization: false
Supported Operations:
Query
Query Attachments
Query Related Records
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata