Name: SewerBilling

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1020164c74e94704a631cfaf460f5dcb

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NSACCTNO ( type: esriFieldTypeInteger, alias: Northstar Number, editable: true, nullable: true, defaultValue: null, modelName: NSACCTNO )
• NSOCCPNT ( type: esriFieldTypeSmallInteger, alias: Northstar Occupant Code, editable: true, nullable: true, defaultValue: null, modelName: NSOCCPNT )
• DSBL ( type: esriFieldTypeString, alias: Tax Map Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DSBL )
• ACCTNUM ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ACCTNUM )
• CUSTNUM ( type: esriFieldTypeString, alias: Customer Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CUSTNUM )
• NAME ( type: esriFieldTypeString, alias: Customer Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME )
• ADDRNUM ( type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ADDRNUM )
• ADDRSUF ( type: esriFieldTypeString, alias: Address Suffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADDRSUF )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 70, defaultValue: null, modelName: STREET )
• SUBADDR ( type: esriFieldTypeString, alias: Subaddress, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SUBADDR )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIP Code, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ZIPCODE )
• DISTRICT ( type: esriFieldTypeString, alias: Sewer District, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DISTRICT )
• BILLDATE ( type: esriFieldTypeDate, alias: Last Billed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BILLDATE )
• BILLAMT ( type: esriFieldTypeDouble, alias: Last Billed Amount, editable: true, nullable: true, defaultValue: null, modelName: BILLAMT )
• BILLDUE ( type: esriFieldTypeDate, alias: Last Billed Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BILLDUE )
• PAIDAMT ( type: esriFieldTypeDouble, alias: Last Payment Amount, editable: true, nullable: true, defaultValue: null, modelName: PAIDAMT )
• PAIDDATE ( type: esriFieldTypeDate, alias: Last Payment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PAIDDATE )
• ACCTBAL ( type: esriFieldTypeDouble, alias: Total Balance Due, editable: true, nullable: true, defaultValue: null, modelName: ACCTBAL )
• CURNTBAL ( type: esriFieldTypeDouble, alias: Current Balance, editable: true, nullable: true, defaultValue: null, modelName: CURNTBAL )
• OVRDUEBAL ( type: esriFieldTypeDouble, alias: Overdue Balance, editable: true, nullable: true, defaultValue: null, modelName: OVRDUEBAL )
• LATECHGBAL ( type: esriFieldTypeDouble, alias: Late Charge Balance, editable: true, nullable: true, defaultValue: null, modelName: LATECHGBAL )
• INTBAL ( type: esriFieldTypeDouble, alias: Interest Balance, editable: true, nullable: true, defaultValue: null, modelName: INTBAL )
• FULLADDR ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 170, defaultValue: null, modelName: FULLADDR )
• ASOFDATE ( type: esriFieldTypeDate, alias: As of Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASOFDATE )

Templates:

• Name: SewerBilling
  Description:
  Prototype:
  FULLADDR: null
  ASOFDATE: null
  NSACCTNO: null
  NSOCCPNT: null
  DSBL: null
  ACCTNUM: null
  CUSTNUM: null
  NAME: null
  ADDRNUM: null
  ADDRSUF: null
  STREET: null
  SUBADDR: null
  CITY: null
  STATE: null
  ZIPCODE: null
  DISTRICT: null
  BILLDATE: null
  BILLAMT: null
  BILLDUE: null
  PAIDAMT: null
  PAIDDATE: null
  ACCTBAL: null
  CURNTBAL: null
  OVRDUEBAL: null
  LATECHGBAL: null
  INTBAL: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

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

Child Resources:

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata