Name: gcgis.sde.map_recent_sales

Display Field: jur

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• jur ( type: esriFieldTypeString , alias: jur , length: 6 )
• parid ( type: esriFieldTypeString , alias: parid , length: 30 )
• saledt ( type: esriFieldTypeDate , alias: saledt , length: 8 )
• stampval ( type: esriFieldTypeDouble , alias: stampval )
• price ( type: esriFieldTypeDouble , alias: price )
• seq ( type: esriFieldTypeSmallInteger , alias: seq )
• salekey ( type: esriFieldTypeInteger , alias: salekey )
• cur ( type: esriFieldTypeString , alias: cur , length: 1 )
• who ( type: esriFieldTypeString , alias: who , length: 10 )
• wen ( type: esriFieldTypeDate , alias: wen , length: 8 )
• whocalc ( type: esriFieldTypeString , alias: whocalc , length: 10 )
• wencalc ( type: esriFieldTypeDate , alias: wencalc , length: 8 )
• status ( type: esriFieldTypeString , alias: status , length: 1 )
• transno ( type: esriFieldTypeString , alias: transno , length: 20 )
• transdt ( type: esriFieldTypeDate , alias: transdt , length: 8 )
• oldyr ( type: esriFieldTypeSmallInteger , alias: oldyr )
• oldseq ( type: esriFieldTypeSmallInteger , alias: oldseq )
• newyr ( type: esriFieldTypeSmallInteger , alias: newyr )
• newseq ( type: esriFieldTypeSmallInteger , alias: newseq )
• book ( type: esriFieldTypeString , alias: book , length: 8 )
• page ( type: esriFieldTypeString , alias: page , length: 8 )
• oldown ( type: esriFieldTypeString , alias: oldown , length: 205 )
• own1 ( type: esriFieldTypeString , alias: own1 , length: 205 )
• source ( type: esriFieldTypeString , alias: source , length: 1 )
• saletype ( type: esriFieldTypeString , alias: saletype , length: 1 )
• saleval ( type: esriFieldTypeString , alias: saleval , length: 2 )
• mktvalid ( type: esriFieldTypeString , alias: mktvalid , length: 2 )
• note1 ( type: esriFieldTypeString , alias: note1 , length: 80 )
• note2 ( type: esriFieldTypeString , alias: note2 , length: 80 )
• note3 ( type: esriFieldTypeString , alias: note3 , length: 80 )
• note4 ( type: esriFieldTypeString , alias: note4 , length: 80 )
• note5 ( type: esriFieldTypeString , alias: note5 , length: 80 )
• note6 ( type: esriFieldTypeString , alias: note6 , length: 80 )
• steb ( type: esriFieldTypeString , alias: steb , length: 3 )
• asmt ( type: esriFieldTypeDouble , alias: asmt )
• stflag ( type: esriFieldTypeString , alias: stflag , length: 1 )
• nopar ( type: esriFieldTypeSmallInteger , alias: nopar )
• instruno ( type: esriFieldTypeString , alias: instruno , length: 20 )
• instrtyp ( type: esriFieldTypeString , alias: instrtyp , length: 20 )
• imageno ( type: esriFieldTypeString , alias: imageno , length: 12 )
• adjamt ( type: esriFieldTypeDouble , alias: adjamt )
• adjprice ( type: esriFieldTypeDouble , alias: adjprice )
• adjreas ( type: esriFieldTypeString , alias: adjreas , length: 3 )
• recorddt ( type: esriFieldTypeDate , alias: recorddt , length: 8 )
• aprtot ( type: esriFieldTypeDouble , alias: aprtot )
• asr ( type: esriFieldTypeDouble , alias: asr )
• linkno ( type: esriFieldTypeString , alias: linkno , length: 20 )
• user1 ( type: esriFieldTypeString , alias: user1 , length: 40 )
• user2 ( type: esriFieldTypeString , alias: user2 , length: 40 )
• user3 ( type: esriFieldTypeString , alias: user3 , length: 40 )
• user4 ( type: esriFieldTypeString , alias: user4 , length: 40 )
• user5 ( type: esriFieldTypeString , alias: user5 , length: 40 )
• user6 ( type: esriFieldTypeString , alias: user6 , length: 40 )
• user7 ( type: esriFieldTypeString , alias: user7 , length: 40 )
• user8 ( type: esriFieldTypeString , alias: user8 , length: 40 )
• user9 ( type: esriFieldTypeString , alias: user9 , length: 40 )
• user10 ( type: esriFieldTypeString , alias: user10 , length: 40 )
• user11 ( type: esriFieldTypeString , alias: user11 , length: 40 )
• user12 ( type: esriFieldTypeString , alias: user12 , length: 40 )
• user13 ( type: esriFieldTypeString , alias: user13 , length: 40 )
• user14 ( type: esriFieldTypeString , alias: user14 , length: 40 )
• user15 ( type: esriFieldTypeString , alias: user15 , length: 40 )
• user16 ( type: esriFieldTypeString , alias: user16 , length: 40 )
• user17 ( type: esriFieldTypeString , alias: user17 , length: 40 )
• user18 ( type: esriFieldTypeString , alias: user18 , length: 40 )
• user19 ( type: esriFieldTypeString , alias: user19 , length: 40 )
• user20 ( type: esriFieldTypeString , alias: user20 , length: 40 )
• user21 ( type: esriFieldTypeString , alias: user21 , length: 40 )
• user22 ( type: esriFieldTypeString , alias: user22 , length: 40 )
• user23 ( type: esriFieldTypeString , alias: user23 , length: 40 )
• user24 ( type: esriFieldTypeString , alias: user24 , length: 40 )
• iasw_id ( type: esriFieldTypeDouble , alias: iasw_id )
• trans_id ( type: esriFieldTypeDouble , alias: trans_id )
• upd_status ( type: esriFieldTypeString , alias: upd_status , length: 1 )
• deactivat ( type: esriFieldTypeDate , alias: deactivat , length: 8 )
• oldown2 ( type: esriFieldTypeString , alias: oldown2 , length: 205 )
• own2 ( type: esriFieldTypeString , alias: own2 , length: 205 )
• hassale ( type: esriFieldTypeString , alias: hassale , length: 1 )
• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )

Supported Operations:   Query   Generate Renderer   Return Updates