Name: Transaction
Display Field: CATEGORY
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
TRANSACTIONID
(
type: esriFieldTypeDouble, alias: TRANSACTIONID
)
-
PRICEPRODUCT
(
type: esriFieldTypeDouble, alias: PRICEPRODUCT
)
-
COSTPRODUCT
(
type: esriFieldTypeDouble, alias: COSTPRODUCT
)
-
LONGITUDE
(
type: esriFieldTypeDouble, alias: LONGITUDE
)
-
LATITUDE
(
type: esriFieldTypeDouble, alias: LATITUDE
)
-
TRANSACTIONREVENUE
(
type: esriFieldTypeDouble, alias: TRANSACTIONREVENUE
)
-
MARGIN
(
type: esriFieldTypeDouble, alias: MARGIN
)
-
NETPROFIT
(
type: esriFieldTypeDouble, alias: NETPROFIT
)
-
CUSTOMERID
(
type: esriFieldTypeInteger, alias: CUSTOMERID
)
-
PRODUCTID
(
type: esriFieldTypeInteger, alias: PRODUCTID
)
-
LOCATIONID
(
type: esriFieldTypeInteger, alias: LOCATIONID
)
-
PLANOGRAMID
(
type: esriFieldTypeInteger, alias: PLANOGRAMID
)
-
MACHINEID
(
type: esriFieldTypeInteger, alias: MACHINEID
)
-
DATESAP
(
type: esriFieldTypeInteger, alias: DATESAP
)
-
QUARTER
(
type: esriFieldTypeInteger, alias: QUARTER
)
-
MONTH
(
type: esriFieldTypeInteger, alias: MONTH
)
-
WEEK
(
type: esriFieldTypeInteger, alias: WEEK
)
-
DAY
(
type: esriFieldTypeInteger, alias: DAY
)
-
PRODUCTQUANTITYSOLD
(
type: esriFieldTypeInteger, alias: PRODUCTQUANTITYSOLD
)
-
TRANSACTIONTOTAL
(
type: esriFieldTypeInteger, alias: TRANSACTIONTOTAL
)
-
HOUR
(
type: esriFieldTypeInteger, alias: HOUR
)
-
CATEGORY
(
type: esriFieldTypeString, alias: CATEGORY, length: 250
)
-
PRODUCT
(
type: esriFieldTypeString, alias: PRODUCT, length: 250
)
-
DESC
(
type: esriFieldTypeString, alias: DESC, length: 250
)
-
ADDRESS
(
type: esriFieldTypeString, alias: ADDRESS, length: 250
)
-
ADDRESS2
(
type: esriFieldTypeString, alias: ADDRESS2, length: 250
)
-
DATETIMESTAMP
(
type: esriFieldTypeString, alias: DATETIMESTAMP, length: 250
)
-
TRANSACTIONID_STR
(
type: esriFieldTypeString, alias: TRANSACTIONID_STR, length: 250
)
-
DATE
(
type: esriFieldTypeString, alias: DATE, length: 250
)
-
DATETIME
(
type: esriFieldTypeString, alias: DATETIME, length: 250
)
-
CAT
(
type: esriFieldTypeString, alias: CAT, length: 250
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata