Name: KSM Customer

Display Field: CUSTOMERNAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: af808476e3cc4bd3b8e6fa163939039e

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: 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 )
• ACCTNUM ( type: esriFieldTypeString, alias: ACCTNUM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ACCTNUM )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CUSTOMERNAME )
• FIRSTNAME ( type: esriFieldTypeString, alias: FIRSTNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FIRSTNAME )
• MIDDLEINITIAL ( type: esriFieldTypeString, alias: MIDDLEINITIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MIDDLEINITIAL )
• LASTNAME ( type: esriFieldTypeString, alias: LASTNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LASTNAME )
• TITLE ( type: esriFieldTypeString, alias: TITLE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TITLE )
• CUSTADDRESS ( type: esriFieldTypeString, alias: CUSTADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CUSTADDRESS )
• CUSTCITY ( type: esriFieldTypeString, alias: CUSTCITY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CUSTCITY )
• CUSTZIP ( type: esriFieldTypeDouble, alias: CUSTZIP, editable: true, nullable: true, defaultValue: null, modelName: CUSTZIP )
• HOMEPHONE ( type: esriFieldTypeString, alias: HOMEPHONE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HOMEPHONE )
• WORKPHONE ( type: esriFieldTypeString, alias: WORKPHONE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WORKPHONE )
• OTHERPHONE ( type: esriFieldTypeString, alias: OTHERPHONE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHERPHONE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• ACCTTYPE ( type: esriFieldTypeString, alias: ACCTTYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ACCTTYPE )
• APTNUM ( type: esriFieldTypeString, alias: APTNUM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: APTNUM )
• EMAIL ( type: esriFieldTypeString, alias: EMAIL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EMAIL )
• ACCTSID ( type: esriFieldTypeDouble, alias: ACCTSID, editable: true, nullable: true, defaultValue: null, modelName: ACCTSID )
• CELLPHONE ( type: esriFieldTypeString, alias: CELLPHONE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CELLPHONE )
• FAX ( type: esriFieldTypeString, alias: FAX, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FAX )
• CUSTDISTRICT ( type: esriFieldTypeString, alias: CUSTDISTRICT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CUSTDISTRICT )
• CUSTSTATE ( type: esriFieldTypeString, alias: CUSTSTATE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CUSTSTATE )
• GIS_ID_NUM ( type: esriFieldTypeInteger, alias: GIS_ID_NUM, editable: true, nullable: true, defaultValue: null, modelName: GIS_ID_NUM )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: KSM Customer
  Description:
  Prototype:
  AssetID: null
  GIS_ID_NUM: null
  ACCTNUM: null
  CUSTOMERNAME: null
  FIRSTNAME: null
  MIDDLEINITIAL: null
  LASTNAME: null
  TITLE: null
  CUSTADDRESS: null
  CUSTCITY: null
  CUSTZIP: null
  HOMEPHONE: null
  WORKPHONE: null
  OTHERPHONE: null
  COMMENTS: null
  ACCTTYPE: null
  APTNUM: null
  EMAIL: null
  ACCTSID: null
  CELLPHONE: null
  FAX: null
  CUSTDISTRICT: null
  CUSTSTATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Addresses (2) -- Related To: Addresses (2)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata