Name: DLSPortalMain.dbo.Sale
Display Field: MainsBpStatus
Type: Table
Geometry Type: N/A
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: false
MaxRecordCount: 500000
Supported Query Formats: JSON, AMF, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: false
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: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
SaleId
(
type: esriFieldTypeDouble
,
alias: SaleId
,
editable: false
,
nullable: false
)
-
PropertyId
(
type: esriFieldTypeDouble
,
alias: PropertyId
,
editable: false
,
nullable: false
)
-
ParcelId
(
type: esriFieldTypeInteger
,
alias: ParcelId
,
editable: false
,
nullable: true
)
-
DeclaredPrice
(
type: esriFieldTypeDouble
,
alias: DeclaredPrice
,
editable: false
,
nullable: true
)
-
AcceptedPrice
(
type: esriFieldTypeDouble
,
alias: AcceptedPrice
,
editable: false
,
nullable: true
)
-
ShareNumerator
(
type: esriFieldTypeInteger
,
alias: ShareNumerator
,
editable: false
,
nullable: true
)
-
ShareDenominator
(
type: esriFieldTypeInteger
,
alias: ShareDenominator
,
editable: false
,
nullable: true
)
-
DlofileId
(
type: esriFieldTypeDouble
,
alias: DlofileId
,
editable: false
,
nullable: true
)
-
AgreementDate
(
type: esriFieldTypeDate
,
alias: AgreementDate
,
editable: false
,
nullable: true
,
length: 8
)
-
ValuationDate
(
type: esriFieldTypeDate
,
alias: ValuationDate
,
editable: false
,
nullable: true
,
length: 8
)
-
ParcelExtent
(
type: esriFieldTypeDouble
,
alias: ParcelExtent
,
editable: false
,
nullable: true
)
-
EncloseDextent
(
type: esriFieldTypeDouble
,
alias: EncloseDextent
,
editable: false
,
nullable: true
)
-
CoveredExtent
(
type: esriFieldTypeDouble
,
alias: CoveredExtent
,
editable: false
,
nullable: true
)
-
UncovereDextent
(
type: esriFieldTypeDouble
,
alias: UncovereDextent
,
editable: false
,
nullable: true
)
-
Extent
(
type: esriFieldTypeDouble
,
alias: Extent
,
editable: false
,
nullable: true
)
-
MainsBpCategory
(
type: esriFieldTypeDouble
,
alias: MainsBpCategory
,
editable: false
,
nullable: true
)
-
MainsBpKind
(
type: esriFieldTypeDouble
,
alias: MainsBpKind
,
editable: false
,
nullable: true
)
-
MainsBpStatus
(
type: esriFieldTypeString
,
alias: MainsBpStatus
,
editable: false
,
nullable: true
,
length: 2
)
-
SecondsBpCategory
(
type: esriFieldTypeDouble
,
alias: SecondsBpCategory
,
editable: false
,
nullable: true
)
-
SecondsBpKind
(
type: esriFieldTypeDouble
,
alias: SecondsBpKind
,
editable: false
,
nullable: true
)
-
SecondsBpStatus
(
type: esriFieldTypeString
,
alias: SecondsBpStatus
,
editable: false
,
nullable: true
,
length: 2
)
-
BuildInGremark
(
type: esriFieldTypeString
,
alias: BuildInGremark
,
editable: false
,
nullable: true
,
length: 100
)
-
SalesRemark
(
type: esriFieldTypeString
,
alias: SalesRemark
,
editable: false
,
nullable: true
,
length: 300
)
-
createUser
(
type: esriFieldTypeString
,
alias: createUser
,
editable: false
,
nullable: false
,
length: 50
)
-
createDate
(
type: esriFieldTypeDate
,
alias: createDate
,
editable: false
,
nullable: false
,
length: 8
)
-
updateUser
(
type: esriFieldTypeString
,
alias: updateUser
,
editable: false
,
nullable: false
,
length: 50
)
-
updateDate
(
type: esriFieldTypeDate
,
alias: updateDate
,
editable: false
,
nullable: false
,
length: 8
)
Templates:
-
Name: DLSPortalMain.dbo.Sale
Description:
Prototype:
Drawing Tool: esriFeatureEditToolNone
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
Supports Coordinates Quantization: false
Supported Operations:
Query
Apply Edits
Add Features
Update Features
Delete Features
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata