Name: Transaction

Display Field: CATEGORY

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TRANSACTIONID ( type: esriFieldTypeDouble, alias: TRANSACTIONID, editable: false, nullable: true, defaultValue: null, modelName: TRANSACTIONID )
• PRICEPRODUCT ( type: esriFieldTypeDouble, alias: PRICEPRODUCT, editable: false, nullable: true, defaultValue: null, modelName: PRICEPRODUCT )
• COSTPRODUCT ( type: esriFieldTypeDouble, alias: COSTPRODUCT, editable: false, nullable: true, defaultValue: null, modelName: COSTPRODUCT )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: false, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: false, nullable: true, defaultValue: null, modelName: LATITUDE )
• TRANSACTIONREVENUE ( type: esriFieldTypeDouble, alias: TRANSACTIONREVENUE, editable: false, nullable: true, defaultValue: null, modelName: TRANSACTIONREVENUE )
• MARGIN ( type: esriFieldTypeDouble, alias: MARGIN, editable: false, nullable: true, defaultValue: null, modelName: MARGIN )
• NETPROFIT ( type: esriFieldTypeDouble, alias: NETPROFIT, editable: false, nullable: true, defaultValue: null, modelName: NETPROFIT )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID, editable: false, nullable: true, defaultValue: null, modelName: CUSTOMERID )
• PRODUCTID ( type: esriFieldTypeInteger, alias: PRODUCTID, editable: false, nullable: true, defaultValue: null, modelName: PRODUCTID )
• LOCATIONID ( type: esriFieldTypeInteger, alias: LOCATIONID, editable: false, nullable: true, defaultValue: null, modelName: LOCATIONID )
• PLANOGRAMID ( type: esriFieldTypeInteger, alias: PLANOGRAMID, editable: false, nullable: true, defaultValue: null, modelName: PLANOGRAMID )
• MACHINEID ( type: esriFieldTypeInteger, alias: MACHINEID, editable: false, nullable: true, defaultValue: null, modelName: MACHINEID )
• DATESAP ( type: esriFieldTypeInteger, alias: DATESAP, editable: false, nullable: true, defaultValue: null, modelName: DATESAP )
• QUARTER ( type: esriFieldTypeInteger, alias: QUARTER, editable: false, nullable: true, defaultValue: null, modelName: QUARTER )
• MONTH ( type: esriFieldTypeInteger, alias: MONTH, editable: false, nullable: true, defaultValue: null, modelName: MONTH )
• WEEK ( type: esriFieldTypeInteger, alias: WEEK, editable: false, nullable: true, defaultValue: null, modelName: WEEK )
• DAY ( type: esriFieldTypeInteger, alias: DAY, editable: false, nullable: true, defaultValue: null, modelName: DAY )
• PRODUCTQUANTITYSOLD ( type: esriFieldTypeInteger, alias: PRODUCTQUANTITYSOLD, editable: false, nullable: true, defaultValue: null, modelName: PRODUCTQUANTITYSOLD )
• TRANSACTIONTOTAL ( type: esriFieldTypeInteger, alias: TRANSACTIONTOTAL, editable: false, nullable: true, defaultValue: null, modelName: TRANSACTIONTOTAL )
• HOUR ( type: esriFieldTypeInteger, alias: HOUR, editable: false, nullable: true, defaultValue: null, modelName: HOUR )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, editable: false, nullable: true, length: 250, defaultValue: null, modelName: CATEGORY )
• PRODUCT ( type: esriFieldTypeString, alias: PRODUCT, editable: false, nullable: true, length: 250, defaultValue: null, modelName: PRODUCT )
• DESC ( type: esriFieldTypeString, alias: DESC, editable: false, nullable: true, length: 250, defaultValue: null, modelName: DESC )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: false, nullable: true, length: 250, defaultValue: null, modelName: ADDRESS )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, editable: false, nullable: true, length: 250, defaultValue: null, modelName: ADDRESS2 )
• DATETIMESTAMP ( type: esriFieldTypeString, alias: DATETIMESTAMP, editable: false, nullable: true, length: 250, defaultValue: null, modelName: DATETIMESTAMP )
• TRANSACTIONID_STR ( type: esriFieldTypeString, alias: TRANSACTIONID_STR, editable: false, nullable: true, length: 250, defaultValue: null, modelName: TRANSACTIONID_STR )
• DATE ( type: esriFieldTypeString, alias: DATE, editable: false, nullable: true, length: 250, defaultValue: null, modelName: DATE )
• DATETIME ( type: esriFieldTypeString, alias: DATETIME, editable: false, nullable: true, length: 250, defaultValue: null, modelName: DATETIME )
• CAT ( type: esriFieldTypeString, alias: CAT, editable: false, nullable: true, length: 250, defaultValue: null, modelName: CAT )

Templates:

• Name: Transaction
  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   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata