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