Name: VISION_SALEHIST

Display Field: SLH_BOOK

Type: Table

Geometry Type: N/A

Description:

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

Feature Draw Order:

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: 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 )
• SLH_MNC ( type: esriFieldTypeInteger, alias: SLH_MNC, editable: true, nullable: false, defaultValue: null, modelName: SLH_MNC )
• SLH_PID ( type: esriFieldTypeInteger, alias: SLH_PID, editable: true, nullable: false, defaultValue: null, modelName: SLH_PID )
• SLH_INTRNL_DATE ( type: esriFieldTypeInteger, alias: SLH_INTRNL_DATE, editable: true, nullable: true, defaultValue: null, modelName: SLH_INTRNL_DATE )
• SLH_LINE_NUM ( type: esriFieldTypeInteger, alias: SLH_LINE_NUM, editable: true, nullable: false, defaultValue: null, modelName: SLH_LINE_NUM )
• SLH_SALE_DATE ( type: esriFieldTypeDate, alias: SLH_SALE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLH_SALE_DATE )
• SLH_BOOK ( type: esriFieldTypeString, alias: SLH_BOOK, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SLH_BOOK )
• SLH_PAGE ( type: esriFieldTypeString, alias: SLH_PAGE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SLH_PAGE )
• SLH_INSTRUMENT ( type: esriFieldTypeString, alias: SLH_INSTRUMENT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SLH_INSTRUMENT )
• SLH_INSTRUMENT2 ( type: esriFieldTypeString, alias: SLH_INSTRUMENT2, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SLH_INSTRUMENT2 )
• SLH_QUALIFIED ( type: esriFieldTypeString, alias: SLH_QUALIFIED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SLH_QUALIFIED )
• SLH_QUALIFIED2 ( type: esriFieldTypeString, alias: SLH_QUALIFIED2, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SLH_QUALIFIED2 )
• SLH_IMPROVED ( type: esriFieldTypeString, alias: SLH_IMPROVED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SLH_IMPROVED )
• SLH_PRICE ( type: esriFieldTypeDouble, alias: SLH_PRICE, editable: true, nullable: true, defaultValue: null, modelName: SLH_PRICE )
• SLH_STAMP_RATE ( type: esriFieldTypeDouble, alias: SLH_STAMP_RATE, editable: true, nullable: true, defaultValue: null, modelName: SLH_STAMP_RATE )
• SLH_STAMP_TAX ( type: esriFieldTypeDouble, alias: SLH_STAMP_TAX, editable: true, nullable: true, defaultValue: null, modelName: SLH_STAMP_TAX )
• SLH_STATUS_DATE ( type: esriFieldTypeDate, alias: SLH_STATUS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLH_STATUS_DATE )
• SLH_TIME_ADJ_PRICE ( type: esriFieldTypeDouble, alias: SLH_TIME_ADJ_PRICE, editable: true, nullable: true, defaultValue: null, modelName: SLH_TIME_ADJ_PRICE )
• SLH_CERTIFICATE ( type: esriFieldTypeString, alias: SLH_CERTIFICATE, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SLH_CERTIFICATE )
• SLH_NOTES ( type: esriFieldTypeString, alias: SLH_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLH_NOTES )
• SLH_SALE_TYPE ( type: esriFieldTypeString, alias: SLH_SALE_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SLH_SALE_TYPE )
• SLH_DEED_TYPE ( type: esriFieldTypeString, alias: SLH_DEED_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SLH_DEED_TYPE )
• SLH_DEED_DATE ( type: esriFieldTypeDate, alias: SLH_DEED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLH_DEED_DATE )
• SLH_RECORD_DATE ( type: esriFieldTypeDate, alias: SLH_RECORD_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLH_RECORD_DATE )
• SLH_REFERENCE_NUM ( type: esriFieldTypeString, alias: SLH_REFERENCE_NUM, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_REFERENCE_NUM )
• SLH_MORTGAGE ( type: esriFieldTypeString, alias: SLH_MORTGAGE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SLH_MORTGAGE )
• SLH_MORTGAGE_DESC ( type: esriFieldTypeString, alias: SLH_MORTGAGE_DESC, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_MORTGAGE_DESC )
• SLH_SALESHIST_TRANSACTION ( type: esriFieldTypeString, alias: SLH_SALESHIST_TRANSACTION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SLH_SALESHIST_TRANSACTION )
• SLH_USER_FLAG1 ( type: esriFieldTypeSmallInteger, alias: SLH_USER_FLAG1, editable: true, nullable: true, defaultValue: null, modelName: SLH_USER_FLAG1 )
• SLH_USER_FLAG2 ( type: esriFieldTypeSmallInteger, alias: SLH_USER_FLAG2, editable: true, nullable: true, defaultValue: null, modelName: SLH_USER_FLAG2 )
• SLH_USER1 ( type: esriFieldTypeString, alias: SLH_USER1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER1 )
• SLH_USER_DESC1 ( type: esriFieldTypeString, alias: SLH_USER_DESC1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC1 )
• SLH_USER2 ( type: esriFieldTypeString, alias: SLH_USER2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER2 )
• SLH_USER_DESC2 ( type: esriFieldTypeString, alias: SLH_USER_DESC2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC2 )
• SLH_CREATE_DATE ( type: esriFieldTypeDate, alias: SLH_CREATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLH_CREATE_DATE )
• SLH_LAST_UPDATE ( type: esriFieldTypeDate, alias: SLH_LAST_UPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLH_LAST_UPDATE )
• SLH_FUTURE ( type: esriFieldTypeSmallInteger, alias: SLH_FUTURE, editable: true, nullable: true, defaultValue: null, modelName: SLH_FUTURE )
• SLH_LEGAL_OWNER ( type: esriFieldTypeSmallInteger, alias: SLH_LEGAL_OWNER, editable: true, nullable: true, defaultValue: null, modelName: SLH_LEGAL_OWNER )
• SLH_CURRENT_OWNER ( type: esriFieldTypeSmallInteger, alias: SLH_CURRENT_OWNER, editable: true, nullable: true, defaultValue: null, modelName: SLH_CURRENT_OWNER )
• SLH_PREV_LINE_NUM ( type: esriFieldTypeInteger, alias: SLH_PREV_LINE_NUM, editable: true, nullable: true, defaultValue: null, modelName: SLH_PREV_LINE_NUM )
• SLH_USER3 ( type: esriFieldTypeString, alias: SLH_USER3, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER3 )
• SLH_USER_DESC3 ( type: esriFieldTypeString, alias: SLH_USER_DESC3, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC3 )
• SLH_USER4 ( type: esriFieldTypeString, alias: SLH_USER4, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER4 )
• SLH_USER_DESC4 ( type: esriFieldTypeString, alias: SLH_USER_DESC4, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC4 )
• SLH_USER5 ( type: esriFieldTypeString, alias: SLH_USER5, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER5 )
• SLH_USER_DESC5 ( type: esriFieldTypeString, alias: SLH_USER_DESC5, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC5 )
• SLH_USER6 ( type: esriFieldTypeString, alias: SLH_USER6, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER6 )
• SLH_USER_DESC6 ( type: esriFieldTypeString, alias: SLH_USER_DESC6, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC6 )
• SLH_USER7 ( type: esriFieldTypeString, alias: SLH_USER7, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SLH_USER7 )
• SLH_USER_DESC7 ( type: esriFieldTypeString, alias: SLH_USER_DESC7, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SLH_USER_DESC7 )
• SLH_TIME_ADJ_PRICE_2 ( type: esriFieldTypeDouble, alias: SLH_TIME_ADJ_PRICE_2, editable: true, nullable: true, defaultValue: null, modelName: SLH_TIME_ADJ_PRICE_2 )
• SLH_CESP ( type: esriFieldTypeDouble, alias: SLH_CESP, editable: true, nullable: true, defaultValue: null, modelName: SLH_CESP )
• SLH_SUPERVISOR_REVIEWED ( type: esriFieldTypeSmallInteger, alias: SLH_SUPERVISOR_REVIEWED, editable: true, nullable: true, defaultValue: null, modelName: SLH_SUPERVISOR_REVIEWED )
• SLH_SUPERVISOR_ID ( type: esriFieldTypeString, alias: SLH_SUPERVISOR_ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SLH_SUPERVISOR_ID )

Templates:

• Name: VISION_SALEHIST
  Description:
  Prototype:
  SLH_SUPERVISOR_REVIEWED: null
  SLH_SUPERVISOR_ID: null
  SLH_MNC: 0
  SLH_PID: 0
  SLH_INTRNL_DATE: null
  SLH_LINE_NUM: 0
  SLH_SALE_DATE: null
  SLH_BOOK: null
  SLH_PAGE: null
  SLH_INSTRUMENT: null
  SLH_INSTRUMENT2: null
  SLH_QUALIFIED: null
  SLH_QUALIFIED2: null
  SLH_IMPROVED: null
  SLH_PRICE: null
  SLH_STAMP_RATE: null
  SLH_STAMP_TAX: null
  SLH_STATUS_DATE: null
  SLH_TIME_ADJ_PRICE: null
  SLH_CERTIFICATE: null
  SLH_NOTES: null
  SLH_SALE_TYPE: null
  SLH_DEED_TYPE: null
  SLH_DEED_DATE: null
  SLH_RECORD_DATE: null
  SLH_REFERENCE_NUM: null
  SLH_MORTGAGE: null
  SLH_MORTGAGE_DESC: null
  SLH_SALESHIST_TRANSACTION: null
  SLH_USER_FLAG1: null
  SLH_USER_FLAG2: null
  SLH_USER1: null
  SLH_USER_DESC1: null
  SLH_USER2: null
  SLH_USER_DESC2: null
  SLH_CREATE_DATE: null
  SLH_LAST_UPDATE: null
  SLH_FUTURE: null
  SLH_LEGAL_OWNER: null
  SLH_CURRENT_OWNER: null
  SLH_PREV_LINE_NUM: null
  SLH_USER3: null
  SLH_USER_DESC3: null
  SLH_USER4: null
  SLH_USER_DESC4: null
  SLH_USER5: null
  SLH_USER_DESC5: null
  SLH_USER6: null
  SLH_USER_DESC6: null
  SLH_USER7: null
  SLH_USER_DESC7: null
  SLH_TIME_ADJ_PRICE_2: null
  SLH_CESP: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata