Name: meterchange.dbo.MeterNew

Display Field: BillingName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 9963f39ca27444a38eed806e76e2b7a4

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• ID ( type: esriFieldTypeOID, alias: ID )
• WorkCompletedBy ( type: esriFieldTypeString, alias: WorkCompletedBy, length: 255 )
• DateSubmitted ( type: esriFieldTypeDateOnly, alias: DateSubmitted )
• RegID ( type: esriFieldTypeString, alias: RegID, length: 255 )
• ServiceAddress ( type: esriFieldTypeString, alias: ServiceAddress, length: 255 )
• AccountNumber ( type: esriFieldTypeString, alias: AccountNumber, length: 255 )
• AccountNumberPrior ( type: esriFieldTypeString, alias: AccountNumberPrior, length: 255 )
• MXU_ID ( type: esriFieldTypeString, alias: MXU_ID, length: 255 )
• InstallRead ( type: esriFieldTypeInteger, alias: InstallRead )
• PressureZone ( type: esriFieldTypeString, alias: PressureZone, length: 255 )
• CrossConnection ( type: esriFieldTypeInteger, alias: CrossConnection )
• MeterNumber ( type: esriFieldTypeInteger, alias: MeterNumber )
• PipeSize ( type: esriFieldTypeString, alias: PipeSize, length: 255 )
• MeterDigits ( type: esriFieldTypeInteger, alias: MeterDigits )
• MeterMake ( type: esriFieldTypeString, alias: MeterMake, length: 255 )
• LocationX ( type: esriFieldTypeString, alias: LocationX, length: 255 )
• LocationY ( type: esriFieldTypeString, alias: LocationY, length: 255 )
• TaxID ( type: esriFieldTypeString, alias: TaxID, length: 255 )
• PermitNum ( type: esriFieldTypeString, alias: PermitNum, length: 255 )
• JobType ( type: esriFieldTypeString, alias: JobType, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• AccountClass ( type: esriFieldTypeInteger, alias: AccountClass )
• AccountIndicator ( type: esriFieldTypeInteger, alias: AccountIndicator )
• AccountType ( type: esriFieldTypeInteger, alias: AccountType )
• Units ( type: esriFieldTypeInteger, alias: Units )
• WaterZone ( type: esriFieldTypeInteger, alias: WaterZone )
• FireDistrict ( type: esriFieldTypeInteger, alias: FireDistrict )
• Location ( type: esriFieldTypeInteger, alias: Location )
• RateClass ( type: esriFieldTypeString, alias: RateClass, length: 255 )
• WaterCodeFixed ( type: esriFieldTypeString, alias: WaterCodeFixed, length: 255 )
• WaterCodeCommodity ( type: esriFieldTypeString, alias: WaterCodeCommodity, length: 255 )
• WaterCodeFire ( type: esriFieldTypeString, alias: WaterCodeFire, length: 255 )
• WaterCodeSurcharge ( type: esriFieldTypeString, alias: WaterCodeSurcharge, length: 255 )
• WaterCodeLights ( type: esriFieldTypeString, alias: WaterCodeLights, length: 255 )
• WaterCodeAdmin ( type: esriFieldTypeString, alias: WaterCodeAdmin, length: 255 )
• SewerCodeSingle ( type: esriFieldTypeString, alias: SewerCodeSingle, length: 255 )
• SewerCodeMulti ( type: esriFieldTypeString, alias: SewerCodeMulti, length: 255 )
• SewerCodeComm1 ( type: esriFieldTypeString, alias: SewerCodeComm1, length: 255 )
• SewerCodeComm2 ( type: esriFieldTypeString, alias: SewerCodeComm2, length: 255 )
• SewerCodeComm3 ( type: esriFieldTypeString, alias: SewerCodeComm3, length: 255 )
• SewerCodeSurcharge ( type: esriFieldTypeString, alias: SewerCodeSurcharge, length: 255 )
• SewerCodeGrinder ( type: esriFieldTypeString, alias: SewerCodeGrinder, length: 255 )
• StormSingle ( type: esriFieldTypeString, alias: StormSingle, length: 255 )
• StormDuplex ( type: esriFieldTypeString, alias: StormDuplex, length: 255 )
• StormDuplexSep ( type: esriFieldTypeString, alias: StormDuplexSep, length: 255 )
• StormMulti ( type: esriFieldTypeString, alias: StormMulti, length: 255 )
• StormISU ( type: esriFieldTypeString, alias: StormISU, length: 255 )
• StormQuantity ( type: esriFieldTypeString, alias: StormQuantity, length: 255 )
• StormQuality ( type: esriFieldTypeString, alias: StormQuality, length: 255 )
• StormPenalty ( type: esriFieldTypeString, alias: StormPenalty, length: 255 )
• StormMultiplier1 ( type: esriFieldTypeString, alias: StormMultiplier1, length: 255 )
• StormMultiplier2 ( type: esriFieldTypeString, alias: StormMultiplier2, length: 255 )
• StormMultiplier3 ( type: esriFieldTypeString, alias: StormMultiplier3, length: 255 )
• ClosedByBilling ( type: esriFieldTypeInteger, alias: ClosedByBilling )
• BillingCheck ( type: esriFieldTypeInteger, alias: BillingCheck )
• BillingName ( type: esriFieldTypeString, alias: BillingName, length: 255 )
• BillingDate ( type: esriFieldTypeDateOnly, alias: BillingDate )
• SequenceNumber ( type: esriFieldTypeInteger, alias: SequenceNumber )
• SequenceDate ( type: esriFieldTypeDateOnly, alias: SequenceDate )
• BillingCycle ( type: esriFieldTypeString, alias: BillingCycle, length: 255 )
• BillingPrior ( type: esriFieldTypeString, alias: BillingPrior, length: 255 )
• BillingNew ( type: esriFieldTypeString, alias: BillingNew, length: 255 )
• BillingZipCode ( type: esriFieldTypeString, alias: BillingZipCode, length: 255 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata