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:

N/A

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:

• SDE.Water_Service (2) -- Related To: Water Service (0)

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