Name: PROPERTYCARD_SALESHISTORY

Display Field: PARCEL

Type: Table

Geometry Type: N/A

Description: SALES HISTORY

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 5000

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
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• PARCEL ( type: esriFieldTypeString , alias: PARCEL , length: 12 )
• SALENM ( type: esriFieldTypeInteger , alias: NumTranfs )
• SALNUM ( type: esriFieldTypeInteger , alias: SaleNum )
• SANOFP ( type: esriFieldTypeInteger , alias: NumPcls )
• SALDT ( type: esriFieldTypeDate , alias: SaleDate , length: 8 )
• SALNAM ( type: esriFieldTypeString , alias: Owner , length: 31 )
• SALTYP ( type: esriFieldTypeString , alias: SaleType , length: 3 )
• SALINV ( type: esriFieldTypeString , alias: InvalidSale , length: 1 )
• SALPRI ( type: esriFieldTypeInteger , alias: SalePrice )
• SALOCL ( type: esriFieldTypeString , alias: LUC , length: 3 )
• SALLND ( type: esriFieldTypeInteger , alias: LandValue )
• SALBLD ( type: esriFieldTypeInteger , alias: BldgValue )
• FK_WorkflowID ( type: esriFieldTypeInteger , alias: FK_WorkflowID )
• FK_Dataset ( type: esriFieldTypeInteger , alias: FK_Dataset )
• FK_Commit ( type: esriFieldTypeInteger , alias: FK_Commit )
• RowGUID ( type: esriFieldTypeGUID , alias: RowGUID , length: 38 )
• RowState ( type: esriFieldTypeSmallInteger , alias: RowState , Coded Values: [0: Unchanged] , [1: Added] , [2: Deleted] , ...1 more... )
• ClientUser ( type: esriFieldTypeString , alias: ClientUser , length: 255 )
• ClientDate ( type: esriFieldTypeDate , alias: ClientDate , length: 8 )

Relationships:

• WORKFLOWS (12) -- Related To: Workflows (0)
• PROPERTYCARD (30) -- Related To: PROPERTYCARD (10)
• PROPERTYCARDDSCOMMITSTATES (42) -- Related To: PROPERTYCARDDSCOMMITSTATES (12)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates