Name: umCustomers

Display Field: umFirstName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 30000

Supported Query Formats: JSON, geoJSON

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 )
• CUSTNMBR ( type: esriFieldTypeString, alias: CUSTNMBR, editable: true, nullable: false, length: 15, defaultValue: null, modelName: CUSTNMBR )
• umFirstName ( type: esriFieldTypeString, alias: umFirstName, editable: true, nullable: false, length: 31, defaultValue: null, modelName: umFirstName )
• umLastName ( type: esriFieldTypeString, alias: umLastName, editable: true, nullable: false, length: 31, defaultValue: null, modelName: umLastName )
• umPlaceOfWork ( type: esriFieldTypeString, alias: umPlaceOfWork, editable: true, nullable: false, length: 41, defaultValue: null, modelName: umPlaceOfWork )
• FullCustomerName ( type: esriFieldTypeString, alias: FullCustomerName, editable: true, nullable: true, length: 63, defaultValue: null, modelName: FullCustomerName )
• umCustClassID ( type: esriFieldTypeString, alias: umCustClassID, editable: true, nullable: false, length: 15, defaultValue: null, modelName: umCustClassID )
• umIndividual ( type: esriFieldTypeSmallInteger, alias: umIndividual, editable: true, nullable: false, defaultValue: null, modelName: umIndividual )
• umDateCreated ( type: esriFieldTypeDate, alias: umDateCreated, editable: true, nullable: false, length: 8, defaultValue: null, modelName: umDateCreated )
• umDateModified ( type: esriFieldTypeDate, alias: umDateModified, editable: true, nullable: false, length: 8, defaultValue: null, modelName: umDateModified )
• umContactPerson ( type: esriFieldTypeString, alias: umContactPerson, editable: true, nullable: false, length: 31, defaultValue: null, modelName: umContactPerson )
• PHONE1 ( type: esriFieldTypeString, alias: PHONE1, editable: true, nullable: false, length: 21, defaultValue: null, modelName: PHONE1 )
• PHONE2 ( type: esriFieldTypeString, alias: PHONE2, editable: true, nullable: false, length: 21, defaultValue: null, modelName: PHONE2 )
• PHONE3 ( type: esriFieldTypeString, alias: PHONE3, editable: true, nullable: false, length: 21, defaultValue: null, modelName: PHONE3 )
• umAddressCateg ( type: esriFieldTypeSmallInteger, alias: umAddressCateg, editable: true, nullable: false, defaultValue: null, modelName: umAddressCateg )
• umStreetNumber ( type: esriFieldTypeString, alias: umStreetNumber, editable: true, nullable: false, length: 7, defaultValue: null, modelName: umStreetNumber )
• umStreetNumberINT ( type: esriFieldTypeInteger, alias: umStreetNumberINT, editable: true, nullable: false, defaultValue: null, modelName: umStreetNumberINT )
• umStrNumberSuffix ( type: esriFieldTypeString, alias: umStrNumberSuffix, editable: true, nullable: false, length: 3, defaultValue: null, modelName: umStrNumberSuffix )
• umStreetName ( type: esriFieldTypeString, alias: umStreetName, editable: true, nullable: false, length: 31, defaultValue: null, modelName: umStreetName )
• umAptNumber ( type: esriFieldTypeString, alias: umAptNumber, editable: true, nullable: false, length: 15, defaultValue: null, modelName: umAptNumber )
• umAptDescription ( type: esriFieldTypeString, alias: umAptDescription, editable: true, nullable: false, length: 15, defaultValue: null, modelName: umAptDescription )
• umZipCode ( type: esriFieldTypeString, alias: umZipCode, editable: true, nullable: false, length: 11, defaultValue: null, modelName: umZipCode )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: false, length: 31, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: false, length: 29, defaultValue: null, modelName: State )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: false, length: 61, defaultValue: null, modelName: Country )
• umLocationID ( type: esriFieldTypeString, alias: umLocationID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: umLocationID )
• umLocClass ( type: esriFieldTypeString, alias: umLocClass, editable: true, nullable: true, length: 15, defaultValue: null, modelName: umLocClass )
• umZoneID ( type: esriFieldTypeString, alias: umZoneID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: umZoneID )
• umBillToCust ( type: esriFieldTypeString, alias: umBillToCust, editable: true, nullable: true, length: 15, defaultValue: null, modelName: umBillToCust )
• umStreetNumber_1 ( type: esriFieldTypeString, alias: umStreetNumber_1, editable: true, nullable: true, length: 7, defaultValue: null, modelName: umStreetNumber_1 )
• umStreetNumberINT_1 ( type: esriFieldTypeInteger, alias: umStreetNumberINT_1, editable: true, nullable: true, defaultValue: null, modelName: umStreetNumberINT_1 )
• umStrNumberSuffix_1 ( type: esriFieldTypeString, alias: umStrNumberSuffix_1, editable: true, nullable: true, length: 3, defaultValue: null, modelName: umStrNumberSuffix_1 )
• umStreetName_1 ( type: esriFieldTypeString, alias: umStreetName_1, editable: true, nullable: true, length: 31, defaultValue: null, modelName: umStreetName_1 )
• umAptNumber_1 ( type: esriFieldTypeString, alias: umAptNumber_1, editable: true, nullable: true, length: 15, defaultValue: null, modelName: umAptNumber_1 )
• umAptDescription_1 ( type: esriFieldTypeString, alias: umAptDescription_1, editable: true, nullable: true, length: 15, defaultValue: null, modelName: umAptDescription_1 )
• umZipCode_1 ( type: esriFieldTypeString, alias: umZipCode_1, editable: true, nullable: true, length: 11, defaultValue: null, modelName: umZipCode_1 )
• City_1 ( type: esriFieldTypeString, alias: City_1, editable: true, nullable: true, length: 31, defaultValue: null, modelName: City_1 )
• State_1 ( type: esriFieldTypeString, alias: State_1, editable: true, nullable: true, length: 29, defaultValue: null, modelName: State_1 )

Templates:

• Name: umCustomers
  Description:
  Prototype:
  City_1: null
  State_1: null
  CUSTNMBR:
  umFirstName:
  umLastName:
  umPlaceOfWork:
  FullCustomerName: null
  umCustClassID:
  umIndividual: 0
  umDateCreated: -2209161600000
  umDateModified: -2209161600000
  umContactPerson:
  PHONE1:
  PHONE2:
  PHONE3:
  umAddressCateg: 0
  umStreetNumber:
  umStreetNumberINT: 0
  umStrNumberSuffix:
  umStreetName:
  umAptNumber:
  umAptDescription:
  umZipCode:
  City:
  State:
  Country:
  umLocationID: null
  umLocClass: null
  umZoneID: null
  umBillToCust: null
  umStreetNumber_1: null
  umStreetNumberINT_1: null
  umStrNumberSuffix_1: null
  umStreetName_1: null
  umAptNumber_1: null
  umAptDescription_1: null
  umZipCode_1: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Electric.GIS.ElectricMeters (3) -- Related To: ElectricMeters (16)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

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