Name: Resident_Contact

Display Field: custname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 5f99e7265b75441a905448372ca56ba7

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 8, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• custnmbr ( modelName: custnmbr, nullable: true, editable: true, defaultValue: null, length: 15, alias: CUSTNMBR, type: esriFieldTypeString )
• custname ( modelName: custname, nullable: true, editable: true, defaultValue: null, length: 65, alias: CUSTNAME, type: esriFieldTypeString )
• custclas ( modelName: custclas, nullable: true, editable: true, defaultValue: null, length: 15, alias: CUSTCLAS, type: esriFieldTypeString )
• cprcstnm ( modelName: cprcstnm, nullable: true, editable: true, defaultValue: null, length: 15, alias: CPRCSTNM, type: esriFieldTypeString )
• cntcprsn ( modelName: cntcprsn, nullable: true, editable: true, defaultValue: null, length: 61, alias: CNTCPRSN, type: esriFieldTypeString )
• stmtname ( modelName: stmtname, nullable: true, editable: true, defaultValue: null, length: 65, alias: STMTNAME, type: esriFieldTypeString )
• shrtname ( modelName: shrtname, nullable: true, editable: true, defaultValue: null, length: 15, alias: SHRTNAME, type: esriFieldTypeString )
• adrscode ( modelName: adrscode, nullable: true, editable: true, defaultValue: null, length: 15, alias: ADRSCODE, type: esriFieldTypeString )
• upszone ( modelName: upszone, nullable: true, editable: true, defaultValue: null, length: 3, alias: UPSZONE, type: esriFieldTypeString )
• shipmthd ( modelName: shipmthd, nullable: true, editable: true, defaultValue: null, length: 15, alias: SHIPMTHD, type: esriFieldTypeString )
• taxschid ( modelName: taxschid, nullable: true, editable: true, defaultValue: null, length: 15, alias: TAXSCHID, type: esriFieldTypeString )
• address1 ( modelName: address1, nullable: true, editable: true, defaultValue: null, length: 61, alias: ADDRESS1, type: esriFieldTypeString )
• address2 ( modelName: address2, nullable: true, editable: true, defaultValue: null, length: 61, alias: ADDRESS2, type: esriFieldTypeString )
• address3 ( modelName: address3, nullable: true, editable: true, defaultValue: null, length: 61, alias: ADDRESS3, type: esriFieldTypeString )
• country ( modelName: country, nullable: true, editable: true, defaultValue: null, length: 61, alias: COUNTRY, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 35, alias: CITY, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 29, alias: STATE, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 11, alias: ZIP, type: esriFieldTypeString )
• phone1 ( modelName: phone1, nullable: true, editable: true, defaultValue: null, length: 21, alias: PHONE1, type: esriFieldTypeString )
• phone2 ( modelName: phone2, nullable: true, editable: true, defaultValue: null, length: 21, alias: PHONE2, type: esriFieldTypeString )
• phone3 ( modelName: phone3, nullable: true, editable: true, defaultValue: null, length: 21, alias: PHONE3, type: esriFieldTypeString )
• fax ( modelName: fax, nullable: true, editable: true, defaultValue: null, length: 21, alias: FAX, type: esriFieldTypeString )
• prbtadcd ( modelName: prbtadcd, nullable: true, editable: true, defaultValue: null, length: 15, alias: PRBTADCD, type: esriFieldTypeString )
• prstadcd ( modelName: prstadcd, nullable: true, editable: true, defaultValue: null, length: 15, alias: PRSTADCD, type: esriFieldTypeString )
• staddrcd ( modelName: staddrcd, nullable: true, editable: true, defaultValue: null, length: 15, alias: STADDRCD, type: esriFieldTypeString )
• slprsnid ( modelName: slprsnid, nullable: true, editable: true, defaultValue: null, length: 15, alias: SLPRSNID, type: esriFieldTypeString )
• chekbkid ( modelName: chekbkid, nullable: true, editable: true, defaultValue: null, length: 15, alias: CHEKBKID, type: esriFieldTypeString )
• pymtrmid ( modelName: pymtrmid, nullable: true, editable: true, defaultValue: null, length: 21, alias: PYMTRMID, type: esriFieldTypeString )
• crlmttyp ( modelName: crlmttyp, nullable: true, editable: true, defaultValue: null, alias: CRLMTTYP, type: esriFieldTypeSmallInteger )
• crlmtamt ( modelName: crlmtamt, nullable: true, editable: true, defaultValue: null, alias: CRLMTAMT, type: esriFieldTypeDouble )
• crlmtper ( modelName: crlmtper, nullable: true, editable: true, defaultValue: null, alias: CRLMTPER, type: esriFieldTypeSmallInteger )
• crlmtpam ( modelName: crlmtpam, nullable: true, editable: true, defaultValue: null, alias: CRLMTPAM, type: esriFieldTypeDouble )
• curncyid ( modelName: curncyid, nullable: true, editable: true, defaultValue: null, length: 15, alias: CURNCYID, type: esriFieldTypeString )
• ratetpid ( modelName: ratetpid, nullable: true, editable: true, defaultValue: null, length: 15, alias: RATETPID, type: esriFieldTypeString )
• custdisc ( modelName: custdisc, nullable: true, editable: true, defaultValue: null, alias: CUSTDISC, type: esriFieldTypeSmallInteger )
• prclevel ( modelName: prclevel, nullable: true, editable: true, defaultValue: null, length: 11, alias: PRCLEVEL, type: esriFieldTypeString )
• minpytyp ( modelName: minpytyp, nullable: true, editable: true, defaultValue: null, alias: MINPYTYP, type: esriFieldTypeSmallInteger )
• minpydlr ( modelName: minpydlr, nullable: true, editable: true, defaultValue: null, alias: MINPYDLR, type: esriFieldTypeDouble )
• minpypct ( modelName: minpypct, nullable: true, editable: true, defaultValue: null, alias: MINPYPCT, type: esriFieldTypeSmallInteger )
• fnchatyp ( modelName: fnchatyp, nullable: true, editable: true, defaultValue: null, alias: FNCHATYP, type: esriFieldTypeSmallInteger )
• fnchpcnt ( modelName: fnchpcnt, nullable: true, editable: true, defaultValue: null, alias: FNCHPCNT, type: esriFieldTypeSmallInteger )
• finchdlr ( modelName: finchdlr, nullable: true, editable: true, defaultValue: null, alias: FINCHDLR, type: esriFieldTypeDouble )
• mxwoftyp ( modelName: mxwoftyp, nullable: true, editable: true, defaultValue: null, alias: MXWOFTYP, type: esriFieldTypeSmallInteger )
• mxwrofam ( modelName: mxwrofam, nullable: true, editable: true, defaultValue: null, alias: MXWROFAM, type: esriFieldTypeDouble )
• comment1 ( modelName: comment1, nullable: true, editable: true, defaultValue: null, length: 31, alias: COMMENT1, type: esriFieldTypeString )
• comment2 ( modelName: comment2, nullable: true, editable: true, defaultValue: null, length: 31, alias: COMMENT2, type: esriFieldTypeString )
• userdef1 ( modelName: userdef1, nullable: true, editable: true, defaultValue: null, length: 21, alias: USERDEF1, type: esriFieldTypeString )
• userdef2 ( modelName: userdef2, nullable: true, editable: true, defaultValue: null, length: 21, alias: USERDEF2, type: esriFieldTypeString )
• taxexmt1 ( modelName: taxexmt1, nullable: true, editable: true, defaultValue: null, length: 25, alias: TAXEXMT1, type: esriFieldTypeString )
• taxexmt2 ( modelName: taxexmt2, nullable: true, editable: true, defaultValue: null, length: 25, alias: TAXEXMT2, type: esriFieldTypeString )
• txrgnnum ( modelName: txrgnnum, nullable: true, editable: true, defaultValue: null, length: 25, alias: TXRGNNUM, type: esriFieldTypeString )
• balnctyp ( modelName: balnctyp, nullable: true, editable: true, defaultValue: null, alias: BALNCTYP, type: esriFieldTypeSmallInteger )
• stmtcycl ( modelName: stmtcycl, nullable: true, editable: true, defaultValue: null, alias: STMTCYCL, type: esriFieldTypeSmallInteger )
• bankname ( modelName: bankname, nullable: true, editable: true, defaultValue: null, length: 31, alias: BANKNAME, type: esriFieldTypeString )
• bnkbrnch ( modelName: bnkbrnch, nullable: true, editable: true, defaultValue: null, length: 21, alias: BNKBRNCH, type: esriFieldTypeString )
• salsterr ( modelName: salsterr, nullable: true, editable: true, defaultValue: null, length: 15, alias: SALSTERR, type: esriFieldTypeString )
• defcacty ( modelName: defcacty, nullable: true, editable: true, defaultValue: null, alias: DEFCACTY, type: esriFieldTypeSmallInteger )
• rmcshacc ( modelName: rmcshacc, nullable: true, editable: true, defaultValue: null, alias: RMCSHACC, type: esriFieldTypeInteger )
• rmaracc ( modelName: rmaracc, nullable: true, editable: true, defaultValue: null, alias: RMARACC, type: esriFieldTypeInteger )
• rmslsacc ( modelName: rmslsacc, nullable: true, editable: true, defaultValue: null, alias: RMSLSACC, type: esriFieldTypeInteger )
• rmivacc ( modelName: rmivacc, nullable: true, editable: true, defaultValue: null, alias: RMIVACC, type: esriFieldTypeInteger )
• rmcosacc ( modelName: rmcosacc, nullable: true, editable: true, defaultValue: null, alias: RMCOSACC, type: esriFieldTypeInteger )
• rmtakacc ( modelName: rmtakacc, nullable: true, editable: true, defaultValue: null, alias: RMTAKACC, type: esriFieldTypeInteger )
• rmavacc ( modelName: rmavacc, nullable: true, editable: true, defaultValue: null, alias: RMAVACC, type: esriFieldTypeInteger )
• rmfcgacc ( modelName: rmfcgacc, nullable: true, editable: true, defaultValue: null, alias: RMFCGACC, type: esriFieldTypeInteger )
• rmwracc ( modelName: rmwracc, nullable: true, editable: true, defaultValue: null, alias: RMWRACC, type: esriFieldTypeInteger )
• rmsoracc ( modelName: rmsoracc, nullable: true, editable: true, defaultValue: null, alias: RMSORACC, type: esriFieldTypeInteger )
• frstindt ( modelName: frstindt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FRSTINDT, type: esriFieldTypeDate )
• inactive ( modelName: inactive, nullable: true, editable: true, defaultValue: null, alias: INACTIVE, type: esriFieldTypeSmallInteger )
• hold ( modelName: hold, nullable: true, editable: true, defaultValue: null, alias: HOLD, type: esriFieldTypeSmallInteger )
• crcardid ( modelName: crcardid, nullable: true, editable: true, defaultValue: null, length: 15, alias: CRCARDID, type: esriFieldTypeString )
• crcrdnum ( modelName: crcrdnum, nullable: true, editable: true, defaultValue: null, length: 21, alias: CRCRDNUM, type: esriFieldTypeString )
• ccrdxpdt ( modelName: ccrdxpdt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CCRDXPDT, type: esriFieldTypeDate )
• kpdsthst ( modelName: kpdsthst, nullable: true, editable: true, defaultValue: null, alias: KPDSTHST, type: esriFieldTypeSmallInteger )
• kpcalhst ( modelName: kpcalhst, nullable: true, editable: true, defaultValue: null, alias: KPCALHST, type: esriFieldTypeSmallInteger )
• kperhist ( modelName: kperhist, nullable: true, editable: true, defaultValue: null, alias: KPERHIST, type: esriFieldTypeSmallInteger )
• kptrxhst ( modelName: kptrxhst, nullable: true, editable: true, defaultValue: null, alias: KPTRXHST, type: esriFieldTypeSmallInteger )
• noteindx ( modelName: noteindx, nullable: true, editable: true, defaultValue: null, alias: NOTEINDX, type: esriFieldTypeDouble )
• creatddt ( modelName: creatddt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CREATDDT, type: esriFieldTypeDate )
• modifdt ( modelName: modifdt, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: MODIFDT, type: esriFieldTypeDate )
• revalue_customer ( modelName: revalue_customer, nullable: true, editable: true, defaultValue: null, alias: Revalue_Customer, type: esriFieldTypeSmallInteger )
• post_results_to ( modelName: post_results_to, nullable: true, editable: true, defaultValue: null, alias: Post_Results_To, type: esriFieldTypeSmallInteger )
• finchid ( modelName: finchid, nullable: true, editable: true, defaultValue: null, length: 15, alias: FINCHID, type: esriFieldTypeString )
• govcrpid ( modelName: govcrpid, nullable: true, editable: true, defaultValue: null, length: 31, alias: GOVCRPID, type: esriFieldTypeString )
• govindid ( modelName: govindid, nullable: true, editable: true, defaultValue: null, length: 31, alias: GOVINDID, type: esriFieldTypeString )
• disgrper ( modelName: disgrper, nullable: true, editable: true, defaultValue: null, alias: DISGRPER, type: esriFieldTypeSmallInteger )
• duegrper ( modelName: duegrper, nullable: true, editable: true, defaultValue: null, alias: DUEGRPER, type: esriFieldTypeSmallInteger )
• docfmtid ( modelName: docfmtid, nullable: true, editable: true, defaultValue: null, length: 15, alias: DOCFMTID, type: esriFieldTypeString )
• send_email_statements ( modelName: send_email_statements, nullable: true, editable: true, defaultValue: null, alias: Send_Email_Statements, type: esriFieldTypeSmallInteger )
• userlang ( modelName: userlang, nullable: true, editable: true, defaultValue: null, alias: USERLANG, type: esriFieldTypeSmallInteger )
• gpsfointegrationid ( modelName: gpsfointegrationid, nullable: true, editable: true, defaultValue: null, length: 31, alias: GPSFOINTEGRATIONID, type: esriFieldTypeString )
• integrationsource ( modelName: integrationsource, nullable: true, editable: true, defaultValue: null, alias: INTEGRATIONSOURCE, type: esriFieldTypeSmallInteger )
• integrationid ( modelName: integrationid, nullable: true, editable: true, defaultValue: null, length: 31, alias: INTEGRATIONID, type: esriFieldTypeString )
• orderfulfilldefault ( modelName: orderfulfilldefault, nullable: true, editable: true, defaultValue: null, alias: ORDERFULFILLDEFAULT, type: esriFieldTypeSmallInteger )
• custpriority ( modelName: custpriority, nullable: true, editable: true, defaultValue: null, alias: CUSTPRIORITY, type: esriFieldTypeSmallInteger )
• ccode ( modelName: ccode, nullable: true, editable: true, defaultValue: null, length: 7, alias: CCode, type: esriFieldTypeString )
• declid ( modelName: declid, nullable: true, editable: true, defaultValue: null, length: 15, alias: DECLID, type: esriFieldTypeString )
• rmovrpymtwrtoffacctidx ( modelName: rmovrpymtwrtoffacctidx, nullable: true, editable: true, defaultValue: null, alias: RMOvrpymtWrtoffAcctIdx, type: esriFieldTypeInteger )
• shipcomplete ( modelName: shipcomplete, nullable: true, editable: true, defaultValue: null, alias: SHIPCOMPLETE, type: esriFieldTypeSmallInteger )
• cbvat ( modelName: cbvat, nullable: true, editable: true, defaultValue: null, alias: CBVAT, type: esriFieldTypeSmallInteger )
• includeindp ( modelName: includeindp, nullable: true, editable: true, defaultValue: null, alias: INCLUDEINDP, type: esriFieldTypeSmallInteger )
• dex_row_ts ( modelName: dex_row_ts, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DEX_ROW_TS, type: esriFieldTypeDate )
• dex_row_id ( modelName: dex_row_id, nullable: true, editable: true, defaultValue: null, alias: DEX_ROW_ID, type: esriFieldTypeInteger )
• customer ( modelName: customer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Customer, type: esriFieldTypeString )
• rollnumber_format ( modelName: rollnumber_format, nullable: true, editable: true, defaultValue: null, length: 512, alias: RollNumber_Format, type: esriFieldTypeString )

Templates:

• Name: Resident_Contact
  Description:
  Prototype:
  upszone: null
  custnmbr: null
  staddrcd: null
  disgrper: null
  rmfcgacc: null
  userlang: null
  inactive: null
  crlmtamt: null
  gpsfointegrationid: null
  state: null
  rmcosacc: null
  fax: null
  zip: null
  rmwracc: null
  fnchpcnt: null
  shipmthd: null
  declid: null
  stmtcycl: null
  noteindx: null
  curncyid: null
  frstindt: null
  custclas: null
  userdef1: null
  custpriority: null
  post_results_to: null
  kptrxhst: null
  userdef2: null
  balnctyp: null
  minpypct: null
  dex_row_id: null
  stmtname: null
  city: null
  crlmtper: null
  finchdlr: null
  ccrdxpdt: null
  rollnumber_format: null
  rmcshacc: null
  rmaracc: null
  minpydlr: null
  integrationid: null
  creatddt: null
  fnchatyp: null
  crcardid: null
  modifdt: null
  prbtadcd: null
  ratetpid: null
  orderfulfilldefault: null
  defcacty: null
  rmivacc: null
  kperhist: null
  mxwrofam: null
  chekbkid: null
  includeindp: null
  cntcprsn: null
  ccode: null
  custdisc: null
  custname: null
  shipcomplete: null
  salsterr: null
  mxwoftyp: null
  country: null
  revalue_customer: null
  phone2: null
  phone3: null
  kpdsthst: null
  phone1: null
  hold: null
  bnkbrnch: null
  prclevel: null
  govcrpid: null
  rmovrpymtwrtoffacctidx: null
  comment2: null
  comment1: null
  dex_row_ts: null
  shrtname: null
  govindid: null
  rmslsacc: null
  kpcalhst: null
  slprsnid: null
  minpytyp: null
  duegrper: null
  send_email_statements: null
  docfmtid: null
  crcrdnum: null
  cprcstnm: null
  crlmtpam: null
  rmavacc: null
  txrgnnum: null
  cbvat: null
  integrationsource: null
  rmtakacc: null
  crlmttyp: null
  taxexmt2: null
  adrscode: null
  taxexmt1: null
  address3: null
  taxschid: null
  address2: null
  address1: null
  pymtrmid: null
  finchid: null
  prstadcd: null
  rmsoracc: null
  bankname: null
  customer: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Town_of_Morinville (0) -- Related To: Town_of_Morinville (554)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata