Name: PROPERTYCARD_SALESHISTORY

Display Field: PARCEL

Type: Table

Geometry Type: N/A

Description: SALES HISTORY

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: PROPERTYCARD_SALESHISTORY
  Description:
  Prototype:
  ClientUser: null
  ClientDate: null
  PARCEL: null
  SALENM: null
  SALNUM: null
  SANOFP: null
  SALDT: null
  SALNAM: null
  SALTYP: null
  SALINV: null
  SALPRI: null
  SALOCL: null
  SALLND: null
  SALBLD: null
  FK_WorkflowID: null
  FK_Dataset: null
  FK_Commit: null
  RowGUID: null
  RowState: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates