Name: Fuelmasterplussql.AZTECA.%VehicleCK
Display Field: VEHICLEID
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: f087e06c4b0a485f8db8cda080706d54
Copyright Text: null
Default Visibility: false
MaxRecordCount: 1000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Unique Id Infos:
Type: simple
Fields: ["AUTOINCREMENT"]
OID Field Contains Hash Value: false
Extent:
Drawing Info:
Feature Draw Order:
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
LQUANTITY
(
type: esriFieldTypeDouble, alias: LQUANTITY
)
-
AUTOINCREMENT
(
type: esriFieldTypeOID, alias: AUTOINCREMENT
)
-
VEHICLEID
(
type: esriFieldTypeString, alias: VEHICLEID, length: 8
)
-
DESCRIPT
(
type: esriFieldTypeString, alias: DESCRIPT, length: 40
)
-
VEHIYEAR
(
type: esriFieldTypeSmallInteger, alias: VEHIYEAR
)
-
REISSUE
(
type: esriFieldTypeSmallInteger, alias: REISSUE
)
-
DATEREISS
(
type: esriFieldTypeDate, alias: DATEREISS, length: 8
)
-
ENCODED
(
type: esriFieldTypeSmallInteger, alias: ENCODED
)
-
DATEENCOD
(
type: esriFieldTypeDate, alias: DATEENCOD, length: 8
)
-
AUTH
(
type: esriFieldTypeSmallInteger, alias: AUTH
)
-
DATEAUTH
(
type: esriFieldTypeDate, alias: DATEAUTH, length: 8
)
-
KEYTYPE
(
type: esriFieldTypeString, alias: KEYTYPE, length: 2
)
-
INTKEY
(
type: esriFieldTypeString, alias: INTKEY, length: 9
)
-
OLDINTKEY
(
type: esriFieldTypeString, alias: OLDINTKEY, length: 9
)
-
CUSTID
(
type: esriFieldTypeString, alias: CUSTID, length: 9
)
-
CURRODOM
(
type: esriFieldTypeInteger, alias: CURRODOM
)
-
ODOMDATE
(
type: esriFieldTypeDate, alias: ODOMDATE, length: 8
)
-
PMRANGE
(
type: esriFieldTypeInteger, alias: PMRANGE
)
-
NEXTPMMILAGE
(
type: esriFieldTypeInteger, alias: NEXTPMMILAGE
)
-
MILESHOURSRANGE
(
type: esriFieldTypeSmallInteger, alias: MILESHOURSRANGE
)
-
AGENCY
(
type: esriFieldTypeString, alias: AGENCY, length: 5
)
-
ORG
(
type: esriFieldTypeString, alias: ORG, length: 3
)
-
KO_ODOM
(
type: esriFieldTypeSmallInteger, alias: KO_ODOM
)
-
KO_PIN
(
type: esriFieldTypeSmallInteger, alias: KO_PIN
)
-
KO_USERID
(
type: esriFieldTypeSmallInteger, alias: KO_USERID
)
-
KO_RECEIPT
(
type: esriFieldTypeSmallInteger, alias: KO_RECEIPT
)
-
KO_FREE1
(
type: esriFieldTypeSmallInteger, alias: KO_FREE1
)
-
KO_FREE2
(
type: esriFieldTypeSmallInteger, alias: KO_FREE2
)
-
KO_FREE3
(
type: esriFieldTypeSmallInteger, alias: KO_FREE3
)
-
MISC1
(
type: esriFieldTypeString, alias: MISC1, length: 255
)
-
MISC2
(
type: esriFieldTypeString, alias: MISC2, length: 255
)
-
MISC3
(
type: esriFieldTypeString, alias: MISC3, length: 255
)
-
MISC4
(
type: esriFieldTypeString, alias: MISC4, length: 255
)
-
MISC5
(
type: esriFieldTypeString, alias: MISC5, length: 255
)
-
FREE1
(
type: esriFieldTypeString, alias: FREE1, length: 15
)
-
FREE2
(
type: esriFieldTypeString, alias: FREE2, length: 15
)
-
FREE3
(
type: esriFieldTypeString, alias: FREE3, length: 15
)
-
COMMENT
(
type: esriFieldTypeString, alias: COMMENT, length: 40
)
-
SERVDATE
(
type: esriFieldTypeDate, alias: SERVDATE, length: 8
)
-
USAGE
(
type: esriFieldTypeString, alias: USAGE, length: 10
)
-
PROD_A
(
type: esriFieldTypeSmallInteger, alias: PROD_A
)
-
PROD_B
(
type: esriFieldTypeSmallInteger, alias: PROD_B
)
-
PROD_C
(
type: esriFieldTypeSmallInteger, alias: PROD_C
)
-
PROD_D
(
type: esriFieldTypeSmallInteger, alias: PROD_D
)
-
PROD_E
(
type: esriFieldTypeSmallInteger, alias: PROD_E
)
-
PROD_F
(
type: esriFieldTypeSmallInteger, alias: PROD_F
)
-
PROD_G
(
type: esriFieldTypeSmallInteger, alias: PROD_G
)
-
PROD_H
(
type: esriFieldTypeSmallInteger, alias: PROD_H
)
-
DPA_A
(
type: esriFieldTypeSmallInteger, alias: DPA_A
)
-
DPA_B
(
type: esriFieldTypeSmallInteger, alias: DPA_B
)
-
DPA_C
(
type: esriFieldTypeSmallInteger, alias: DPA_C
)
-
DPA_D
(
type: esriFieldTypeSmallInteger, alias: DPA_D
)
-
DPA_E
(
type: esriFieldTypeSmallInteger, alias: DPA_E
)
-
DPA_F
(
type: esriFieldTypeSmallInteger, alias: DPA_F
)
-
DPA_G
(
type: esriFieldTypeSmallInteger, alias: DPA_G
)
-
DPA_H
(
type: esriFieldTypeSmallInteger, alias: DPA_H
)
-
TRXLIM_A
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_A
)
-
TRXLIM_B
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_B
)
-
TRXLIM_C
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_C
)
-
TRXLIM_D
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_D
)
-
TRXLIM_E
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_E
)
-
TRXLIM_F
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_F
)
-
TRXLIM_G
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_G
)
-
TRXLIM_H
(
type: esriFieldTypeSmallInteger, alias: TRXLIM_H
)
-
PRICELEV_A
(
type: esriFieldTypeString, alias: PRICELEV_A, length: 2
)
-
PRICELEV_B
(
type: esriFieldTypeString, alias: PRICELEV_B, length: 2
)
-
PRICELEV_C
(
type: esriFieldTypeString, alias: PRICELEV_C, length: 2
)
-
PRICELEV_D
(
type: esriFieldTypeString, alias: PRICELEV_D, length: 2
)
-
PRICELEV_E
(
type: esriFieldTypeString, alias: PRICELEV_E, length: 2
)
-
PRICELEV_F
(
type: esriFieldTypeString, alias: PRICELEV_F, length: 2
)
-
PRICELEV_G
(
type: esriFieldTypeString, alias: PRICELEV_G, length: 2
)
-
PRICELEV_H
(
type: esriFieldTypeString, alias: PRICELEV_H, length: 2
)
-
MATCH_A
(
type: esriFieldTypeSmallInteger, alias: MATCH_A
)
-
MATCH_B
(
type: esriFieldTypeSmallInteger, alias: MATCH_B
)
-
MATCH_C
(
type: esriFieldTypeSmallInteger, alias: MATCH_C
)
-
MATCH_D
(
type: esriFieldTypeSmallInteger, alias: MATCH_D
)
-
MATCH_E
(
type: esriFieldTypeSmallInteger, alias: MATCH_E
)
-
MATCH_F
(
type: esriFieldTypeSmallInteger, alias: MATCH_F
)
-
MATCH_G
(
type: esriFieldTypeSmallInteger, alias: MATCH_G
)
-
MATCH_H
(
type: esriFieldTypeSmallInteger, alias: MATCH_H
)
-
AIM
(
type: esriFieldTypeSmallInteger, alias: AIM
)
-
AIMKEY
(
type: esriFieldTypeString, alias: AIMKEY, length: 12
)
-
OLDAIMKEY
(
type: esriFieldTypeString, alias: OLDAIMKEY, length: 12
)
-
AIMAUTH
(
type: esriFieldTypeSmallInteger, alias: AIMAUTH
)
-
AIMDATEAUTH
(
type: esriFieldTypeDate, alias: AIMDATEAUTH, length: 8
)
-
AIM_KO_ODOM
(
type: esriFieldTypeSmallInteger, alias: AIM_KO_ODOM
)
-
AIM_KO_RECEIPT
(
type: esriFieldTypeSmallInteger, alias: AIM_KO_RECEIPT
)
-
AIM_KO_USERID
(
type: esriFieldTypeSmallInteger, alias: AIM_KO_USERID
)
-
PULSEFACT
(
type: esriFieldTypeInteger, alias: PULSEFACT
)
-
AIMSTATUS
(
type: esriFieldTypeSmallInteger, alias: AIMSTATUS
)
-
TERMINALID
(
type: esriFieldTypeString, alias: TERMINALID, length: 3
)
-
TERM_TIME
(
type: esriFieldTypeDate, alias: TERM_TIME, length: 8
)
-
AIMREISSUE
(
type: esriFieldTypeSmallInteger, alias: AIMREISSUE
)
-
AIMDATEREISS
(
type: esriFieldTypeDate, alias: AIMDATEREISS, length: 8
)
-
REISSFOR
(
type: esriFieldTypeSmallInteger, alias: REISSFOR
)
-
ENCODING
(
type: esriFieldTypeSmallInteger, alias: ENCODING
)
-
AIMROLLED
(
type: esriFieldTypeSmallInteger, alias: AIMROLLED
)
-
LPRODUCT
(
type: esriFieldTypeInteger, alias: LPRODUCT
)
-
LTRANTIME
(
type: esriFieldTypeDate, alias: LTRANTIME, length: 8
)
-
LSITEID
(
type: esriFieldTypeString, alias: LSITEID, length: 50
)
-
C1_CHRONOON
(
type: esriFieldTypeSmallInteger, alias: C1_CHRONOON
)
-
C1_CHRONOANALOG
(
type: esriFieldTypeSmallInteger, alias: C1_CHRONOANALOG
)
-
C1_CHRONOANALOGCHANNEL
(
type: esriFieldTypeSmallInteger, alias: C1_CHRONOANALOGCHANNEL
)
-
C1_CHRONOTYPE
(
type: esriFieldTypeSmallInteger, alias: C1_CHRONOTYPE
)
-
C2_CHRONOON
(
type: esriFieldTypeSmallInteger, alias: C2_CHRONOON
)
-
C2_CHRONOANALOG
(
type: esriFieldTypeSmallInteger, alias: C2_CHRONOANALOG
)
-
C2_CHRONOANALOGCHANNEL
(
type: esriFieldTypeSmallInteger, alias: C2_CHRONOANALOGCHANNEL
)
-
C2_CHRONOTYPE
(
type: esriFieldTypeSmallInteger, alias: C2_CHRONOTYPE
)
-
C1_CHRONOCOMMENT
(
type: esriFieldTypeString, alias: C1_CHRONOCOMMENT, length: 50
)
-
C1_CHRONOREADING
(
type: esriFieldTypeInteger, alias: C1_CHRONOREADING
)
-
C1_CHRONDATE
(
type: esriFieldTypeDate, alias: C1_CHRONDATE, length: 8
)
-
C1_CHRONOPMRANGE
(
type: esriFieldTypeInteger, alias: C1_CHRONOPMRANGE
)
-
C1_CHRONONEXTPM
(
type: esriFieldTypeInteger, alias: C1_CHRONONEXTPM
)
-
C1_CHRONOFUELRANGE
(
type: esriFieldTypeInteger, alias: C1_CHRONOFUELRANGE
)
-
C2_CHRONOCOMMENT
(
type: esriFieldTypeString, alias: C2_CHRONOCOMMENT, length: 50
)
-
C2_CHRONOREADING
(
type: esriFieldTypeInteger, alias: C2_CHRONOREADING
)
-
C2_CHRONDATE
(
type: esriFieldTypeDate, alias: C2_CHRONDATE, length: 8
)
-
C2_CHRONOPMRANGE
(
type: esriFieldTypeInteger, alias: C2_CHRONOPMRANGE
)
-
C2_CHRONONEXTPM
(
type: esriFieldTypeInteger, alias: C2_CHRONONEXTPM
)
-
C2_CHRONOFUELRANGE
(
type: esriFieldTypeInteger, alias: C2_CHRONOFUELRANGE
)
-
ODOM_PMNOTICE
(
type: esriFieldTypeInteger, alias: ODOM_PMNOTICE
)
-
ODOM_EXPECTEDEFF
(
type: esriFieldTypeInteger, alias: ODOM_EXPECTEDEFF
)
-
C1_PMNOTICE
(
type: esriFieldTypeInteger, alias: C1_PMNOTICE
)
-
C1_EXPECTEDEFF
(
type: esriFieldTypeInteger, alias: C1_EXPECTEDEFF
)
-
C2_PMNOTICE
(
type: esriFieldTypeInteger, alias: C2_PMNOTICE
)
-
C2_EXPECTEDEFF
(
type: esriFieldTypeInteger, alias: C2_EXPECTEDEFF
)
-
MAKEID
(
type: esriFieldTypeInteger, alias: MAKEID
)
-
MODELID
(
type: esriFieldTypeInteger, alias: MODELID
)
-
C3_CHRONOON
(
type: esriFieldTypeSmallInteger, alias: C3_CHRONOON
)
-
C3_CHRONOANALOG
(
type: esriFieldTypeSmallInteger, alias: C3_CHRONOANALOG
)
-
C3_CHRONOANALOGCHANNEL
(
type: esriFieldTypeSmallInteger, alias: C3_CHRONOANALOGCHANNEL
)
-
C3_CHRONOTYPE
(
type: esriFieldTypeSmallInteger, alias: C3_CHRONOTYPE
)
-
C3_CHRONOCOMMENT
(
type: esriFieldTypeString, alias: C3_CHRONOCOMMENT, length: 50
)
-
C3_CHRONOREADING
(
type: esriFieldTypeInteger, alias: C3_CHRONOREADING
)
-
C3_CHRONDATE
(
type: esriFieldTypeDate, alias: C3_CHRONDATE, length: 8
)
-
C3_CHRONOPMRANGE
(
type: esriFieldTypeInteger, alias: C3_CHRONOPMRANGE
)
-
C3_CHRONONEXTPM
(
type: esriFieldTypeInteger, alias: C3_CHRONONEXTPM
)
-
C3_CHRONOFUELRANGE
(
type: esriFieldTypeInteger, alias: C3_CHRONOFUELRANGE
)
-
C3_PMNOTICE
(
type: esriFieldTypeInteger, alias: C3_PMNOTICE
)
-
C3_EXPECTEDEFF
(
type: esriFieldTypeInteger, alias: C3_EXPECTEDEFF
)
-
KEYPAD_AUTH
(
type: esriFieldTypeSmallInteger, alias: KEYPAD_AUTH
)
-
C1_PREVMAINTENANCE
(
type: esriFieldTypeSmallInteger, alias: C1_PREVMAINTENANCE
)
-
C2_PREVMAINTENANCE
(
type: esriFieldTypeSmallInteger, alias: C2_PREVMAINTENANCE
)
-
C3_PREVMAINTENANCE
(
type: esriFieldTypeSmallInteger, alias: C3_PREVMAINTENANCE
)
-
ODOM_PREVMAINTENANCE
(
type: esriFieldTypeSmallInteger, alias: ODOM_PREVMAINTENANCE
)
-
AIMFWVERSION
(
type: esriFieldTypeString, alias: AIMFWVERSION, length: 4
)
-
AIMFWVERSIONDATE
(
type: esriFieldTypeDate, alias: AIMFWVERSIONDATE, length: 8
)
-
SHOWGCM
(
type: esriFieldTypeSmallInteger, alias: SHOWGCM
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata