Name: Utilities_Water.DBO.Gems_Usage

Display Field: OVERIDEDT

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 732beeb6a74b435e90b06d6014d23853

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TRANSDATE ( type: esriFieldTypeInteger, alias: TRANSDATE )
• ACTUALUSED ( type: esriFieldTypeInteger, alias: ACTUALUSED )
• SERVDAYS ( type: esriFieldTypeSmallInteger, alias: SERVDAYS )
• OVERIDEDT ( type: esriFieldTypeString, alias: OVERIDEDT, length: 1 )
• SERIALNBR ( type: esriFieldTypeString, alias: SERIALNBR, length: 14 )
• READING ( type: esriFieldTypeInteger, alias: READING )
• ESTRECD ( type: esriFieldTypeString, alias: ESTRECD, length: 2 )
• DEMANDREAD ( type: esriFieldTypeDouble, alias: DEMANDREAD )
• OFFPDEMDUS ( type: esriFieldTypeDouble, alias: OFFPDEMDUS )
• CONSUMED ( type: esriFieldTypeInteger, alias: CONSUMED )
• TRANSNBR ( type: esriFieldTypeDouble, alias: TRANSNBR )
• ADKEY ( type: esriFieldTypeInteger, alias: ADKEY )
• USAGEMONTH ( type: esriFieldTypeInteger, alias: USAGEMONTH )
• READDATNUM ( type: esriFieldTypeInteger, alias: READDATNUM )
• OFFPDEMDRD ( type: esriFieldTypeDouble, alias: OFFPDEMDRD )
• READCODE ( type: esriFieldTypeSmallInteger, alias: READCODE )
• CURRENTCUS ( type: esriFieldTypeSmallInteger, alias: CURRENTCUS )
• CUSTNO ( type: esriFieldTypeDouble, alias: CUSTNO )
• DEMANDUSED ( type: esriFieldTypeDouble, alias: DEMANDUSED )
• RMOVED ( type: esriFieldTypeString, alias: RMOVED, length: 1 )
• WORS ( type: esriFieldTypeString, alias: WORS, length: 1 )
• BILLED ( type: esriFieldTypeInteger, alias: BILLED )
• METERKY ( type: esriFieldTypeInteger, alias: METERKY )
• MXCONSUMED ( type: esriFieldTypeInteger, alias: MXCONSUMED )
• USGFLAG2 ( type: esriFieldTypeString, alias: USGFLAG2, length: 1 )
• USGFLAG1 ( type: esriFieldTypeString, alias: USGFLAG1, length: 1 )
• OLDMETERKY ( type: esriFieldTypeInteger, alias: OLDMETERKY )
• MNCONSUMED ( type: esriFieldTypeInteger, alias: MNCONSUMED )
• KWRDORIG ( type: esriFieldTypeDouble, alias: KWRDORIG )
• KVRHREAD ( type: esriFieldTypeInteger, alias: KVRHREAD )
• CALCPWRF ( type: esriFieldTypeSingle, alias: CALCPWRF )
• KVRHUSED ( type: esriFieldTypeInteger, alias: KVRHUSED )
• BILLEDKW ( type: esriFieldTypeDouble, alias: BILLEDKW )
• KWUSED ( type: esriFieldTypeDouble, alias: KWUSED )
• SONBR ( type: esriFieldTypeInteger, alias: SONBR )
• STREETDIR ( type: esriFieldTypeString, alias: STREETDIR, length: 2 )
• STREETPREF ( type: esriFieldTypeString, alias: STREETPREF, length: 2 )
• STREETNBR ( type: esriFieldTypeInteger, alias: STREETNBR )
• SUITE ( type: esriFieldTypeString, alias: SUITE, length: 10 )
• FRAHOUSE ( type: esriFieldTypeString, alias: FRAHOUSE, length: 5 )
• STREETTYPE ( type: esriFieldTypeString, alias: STREETTYPE, length: 5 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 25 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata