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:
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:
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