Name: AUTOMATION.WEBREADER.PrepayCustomer

Display Field: CUSTOMER_FIRSTNAME

Type: Table

Geometry Type: N/A

Description: null

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:

• ACCOUNT_NUMBER ( type: esriFieldTypeDouble, alias: ACCOUNT_NUMBER )
• CUSTOMER_NUMBER ( type: esriFieldTypeDouble, alias: CUSTOMER_NUMBER )
• SERVICE_TYPE ( type: esriFieldTypeString, alias: SERVICE_TYPE, length: 5 )
• STATUS_NUMBER ( type: esriFieldTypeSmallInteger, alias: STATUS_NUMBER )
• STATUS_CODE ( type: esriFieldTypeString, alias: STATUS_CODE, length: 1 )
• PRT_CODE ( type: esriFieldTypeSmallInteger, alias: PRT_CODE )
• CUSTOMER_ADDRESS ( type: esriFieldTypeString, alias: CUSTOMER_ADDRESS, length: 122 )
• CUSTOMER_CITY ( type: esriFieldTypeString, alias: CUSTOMER_CITY, length: 18 )
• CUSTOMER_STATE ( type: esriFieldTypeString, alias: CUSTOMER_STATE, length: 2 )
• CUSTOMER_ZIP ( type: esriFieldTypeString, alias: CUSTOMER_ZIP, length: 6 )
• CUSTOMER_EMAIL ( type: esriFieldTypeString, alias: CUSTOMER_EMAIL, length: 50 )
• CYCLE_CODE ( type: esriFieldTypeSmallInteger, alias: CYCLE_CODE )
• NEWS_CODE ( type: esriFieldTypeSmallInteger, alias: NEWS_CODE )
• CUSTOMER_FIRSTNAME ( type: esriFieldTypeString, alias: CUSTOMER_FIRSTNAME, length: 13 )
• CUSTOMER_LASTNAME ( type: esriFieldTypeString, alias: CUSTOMER_LASTNAME, length: 17 )
• CUSTOMER_MIDDLENAME ( type: esriFieldTypeString, alias: CUSTOMER_MIDDLENAME, length: 9 )
• CUSTOMER_FULLNAME ( type: esriFieldTypeString, alias: CUSTOMER_FULLNAME, length: 36 )
• CUSTOMER_HOMEPHONE ( type: esriFieldTypeString, alias: CUSTOMER_HOMEPHONE, length: 10 )
• CUSTOMER_MOBILEPHONE ( type: esriFieldTypeString, alias: CUSTOMER_MOBILEPHONE, length: 10 )
• CUSTOMER_BUSINESSPHONE ( type: esriFieldTypeString, alias: CUSTOMER_BUSINESSPHONE, length: 10 )
• SERVICE_HOUSENUMBER ( type: esriFieldTypeString, alias: SERVICE_HOUSENUMBER, length: 5 )
• SERVICE_HOMEADDRESS1 ( type: esriFieldTypeString, alias: SERVICE_HOMEADDRESS1, length: 40 )
• SERVICE_CITY ( type: esriFieldTypeString, alias: SERVICE_CITY, length: 18 )
• SERVICE_STATE ( type: esriFieldTypeString, alias: SERVICE_STATE, length: 2 )
• SERVICE_ZIP ( type: esriFieldTypeString, alias: SERVICE_ZIP, length: 6 )
• VOTING_DISTRICT ( type: esriFieldTypeString, alias: VOTING_DISTRICT, length: 3 )
• CAN_VOTE ( type: esriFieldTypeString, alias: CAN_VOTE, length: 1 )
• CURRENT_TRUSTEE ( type: esriFieldTypeString, alias: CURRENT_TRUSTEE, length: 30 )
• CONNECT_DATE ( type: esriFieldTypeDate, alias: CONNECT_DATE, length: 8 )
• DISCONNECT_DATE ( type: esriFieldTypeDate, alias: DISCONNECT_DATE, length: 8 )
• CUSTOMER_COUNTY ( type: esriFieldTypeString, alias: CUSTOMER_COUNTY, length: 30 )
• SERVICE_COUNTY ( type: esriFieldTypeString, alias: SERVICE_COUNTY, length: 30 )
• SERVICE_COUNTY_CD ( type: esriFieldTypeString, alias: SERVICE_COUNTY_CD, length: 3 )
• PRIMARY_RATE_SCHEDULE ( type: esriFieldTypeString, alias: PRIMARY_RATE_SCHEDULE, length: 5 )
• SERVICE_SUBDIVISION ( type: esriFieldTypeString, alias: SERVICE_SUBDIVISION, length: 40 )
• ACCOUNT_NUMBER_STR ( type: esriFieldTypeString, alias: ACCOUNT_NUMBER_STR, length: 50 )
• BI_SRV_PT_SW ( type: esriFieldTypeString, alias: BI_SRV_PT_SW, length: 1 )
• BI_REV_CLASS_CD ( type: esriFieldTypeSmallInteger, alias: BI_REV_CLASS_CD )
• BI_SRV_LOC_NBR ( type: esriFieldTypeDouble, alias: BI_SRV_LOC_NBR )
• BI_ADDR1 ( type: esriFieldTypeString, alias: BI_ADDR1, length: 40 )
• BI_ADDR2 ( type: esriFieldTypeString, alias: BI_ADDR2, length: 40 )
• BI_ADDR3 ( type: esriFieldTypeString, alias: BI_ADDR3, length: 40 )
• BI_CONS_CLASS_CD ( type: esriFieldTypeString, alias: BI_CONS_CLASS_CD, length: 1 )
• SERVICELOCATIONADDR ( type: esriFieldTypeString, alias: SERVICELOCATIONADDR, length: 40 )
• BI_EBILL_SW ( type: esriFieldTypeString, alias: BI_EBILL_SW, length: 1 )
• BI_SAL ( type: esriFieldTypeString, alias: BI_SAL, length: 6 )
• BI_GEN ( type: esriFieldTypeString, alias: BI_GEN, length: 3 )
• BI_CNTY_CD ( type: esriFieldTypeString, alias: BI_CNTY_CD, length: 3 )
• SERVICEADDRESS2 ( type: esriFieldTypeString, alias: SERVICEADDRESS2, length: 40 )
• BI_X_COORD ( type: esriFieldTypeString, alias: BI_X_COORD, length: 15 )
• BI_Y_COORD ( type: esriFieldTypeString, alias: BI_Y_COORD, length: 15 )
• BI_TAX_EXEMPT_SW ( type: esriFieldTypeString, alias: BI_TAX_EXEMPT_SW, length: 1 )
• BI_BUDG_START_DT ( type: esriFieldTypeDate, alias: BI_BUDG_START_DT, length: 8 )
• BI_MO_BUDG_AMT ( type: esriFieldTypeDouble, alias: BI_MO_BUDG_AMT )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata