Name: zema_rams.dbo.vwSupportTicketJobCard
Display Field: ContactName
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
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:
-
OBJECTID
(
type: esriFieldTypeInteger, alias: OBJECTID
)
-
SupportTicketID
(
type: esriFieldTypeInteger, alias: SupportTicketID
)
-
ZemaTicketNumber
(
type: esriFieldTypeString, alias: ZemaTicketNumber, length: 50
)
-
CustomerID
(
type: esriFieldTypeString, alias: CustomerID, length: 500
)
-
ContactNumber
(
type: esriFieldTypeString, alias: ContactNumber, length: 50
)
-
ContactName
(
type: esriFieldTypeString, alias: ContactName, length: 50
)
-
FaultDescription
(
type: esriFieldTypeString, alias: FaultDescription, length: 5000
)
-
SupportTicketTypeCode
(
type: esriFieldTypeString, alias: SupportTicketTypeCode, length: 200
)
-
ProviderName
(
type: esriFieldTypeString, alias: ProviderName, length: 150
)
-
JobCardNo
(
type: esriFieldTypeString, alias: JobCardNo, length: 50
)
-
ScopeOfWork
(
type: esriFieldTypeString, alias: ScopeOfWork, length: 254
)
-
ManagerApprovalDate
(
type: esriFieldTypeDate, alias: ManagerApprovalDate, length: 8
)
-
ApprovedBy
(
type: esriFieldTypeInteger, alias: ApprovedBy
)
-
JobCardCloseDate
(
type: esriFieldTypeDate, alias: JobCardCloseDate, length: 8
)
-
JobCardClosedBy
(
type: esriFieldTypeInteger, alias: JobCardClosedBy
)
-
StartDate
(
type: esriFieldTypeDate, alias: StartDate, length: 8
)
-
EndDate
(
type: esriFieldTypeDate, alias: EndDate, length: 8
)
-
POnumber
(
type: esriFieldTypeString, alias: POnumber, length: 254
)
-
Budgeted
(
type: esriFieldTypeString, alias: Budgeted, length: 254
)
-
DatePOApproved
(
type: esriFieldTypeDate, alias: DatePOApproved, length: 8
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 254
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
RequestPOnumber
(
type: esriFieldTypeSmallInteger, alias: RequestPOnumber
)
-
DatePOnumberRequested
(
type: esriFieldTypeDate, alias: DatePOnumberRequested, length: 8
)
-
StatusName
(
type: esriFieldTypeString, alias: StatusName, length: 50
)
-
StatusID
(
type: esriFieldTypeInteger, alias: StatusID
)
-
SupportTicketDescription
(
type: esriFieldTypeString, alias: SupportTicketDescription, length: 253
)
Supported Operations:
Query
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata