Name: 'Haul Tickets$'

Display Field: globalid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c03f4c464b7547819afde3b2fc175ece

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
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:

Fields:

• globalid ( modelName: globalid, nullable: true, editable: true, defaultValue: null, length: 255, alias: GlobalID, type: esriFieldTypeString )
• incidentid ( modelName: incidentid, nullable: true, editable: true, defaultValue: null, length: 255, alias: incidentid, type: esriFieldTypeString )
• loaddate ( modelName: loaddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: loaddate, type: esriFieldTypeDate )
• ticketid ( modelName: ticketid, nullable: true, editable: true, defaultValue: null, alias: ticketid, type: esriFieldTypeDouble )
• truckid ( modelName: truckid, nullable: true, editable: true, defaultValue: null, alias: truckid, type: esriFieldTypeDouble )
• contractor ( modelName: contractor, nullable: true, editable: true, defaultValue: null, length: 255, alias: contractor, type: esriFieldTypeString )
• subcontactor ( modelName: subcontactor, nullable: true, editable: true, defaultValue: null, length: 255, alias: subcontactor, type: esriFieldTypeString )
• capacity ( modelName: capacity, nullable: true, editable: true, defaultValue: null, alias: capacity, type: esriFieldTypeDouble )
• trucktype ( modelName: trucktype, nullable: true, editable: true, defaultValue: null, length: 255, alias: truckType, type: esriFieldTypeString )
• truckcert ( modelName: truckcert, nullable: true, editable: true, defaultValue: null, length: 255, alias: truckCert, type: esriFieldTypeString )
• debristype ( modelName: debristype, nullable: true, editable: true, defaultValue: null, length: 255, alias: debristype, type: esriFieldTypeString )
• payableunit ( modelName: payableunit, nullable: true, editable: true, defaultValue: null, length: 255, alias: payableunit, type: esriFieldTypeString )
• comments ( modelName: comments, nullable: true, editable: true, defaultValue: null, length: 255, alias: comments, type: esriFieldTypeString )
• loadmonitor ( modelName: loadmonitor, nullable: true, editable: true, defaultValue: null, length: 255, alias: loadMonitor, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 255, alias: city, type: esriFieldTypeString )
• zone ( modelName: zone, nullable: true, editable: true, defaultValue: null, length: 255, alias: zone, type: esriFieldTypeString )
• highway ( modelName: highway, nullable: true, editable: true, defaultValue: null, length: 255, alias: highway, type: esriFieldTypeString )
• milemarker ( modelName: milemarker, nullable: true, editable: true, defaultValue: null, length: 255, alias: mileMarker, type: esriFieldTypeString )
• highwayoffset ( modelName: highwayoffset, nullable: true, editable: true, defaultValue: null, length: 255, alias: highwayOffset, type: esriFieldTypeString )
• version ( modelName: version, nullable: true, editable: true, defaultValue: null, length: 255, alias: version, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: longitude, type: esriFieldTypeDouble )
• unitbarcode ( modelName: unitbarcode, nullable: true, editable: true, defaultValue: null, length: 255, alias: unitbarcode, type: esriFieldTypeString )
• percentfull ( modelName: percentfull, nullable: true, editable: true, defaultValue: null, length: 255, alias: percentFull, type: esriFieldTypeString )
• measuresite ( modelName: measuresite, nullable: true, editable: true, defaultValue: null, length: 255, alias: measureSite, type: esriFieldTypeString )
• measuredate ( modelName: measuredate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: measureDate, type: esriFieldTypeDate )
• unit_weight ( modelName: unit_weight, nullable: true, editable: true, defaultValue: null, length: 255, alias: unit_weight, type: esriFieldTypeString )
• dispoweight_lb ( modelName: dispoweight_lb, nullable: true, editable: true, defaultValue: null, length: 255, alias: dispoweight_lb, type: esriFieldTypeString )
• num_tare_lb ( modelName: num_tare_lb, nullable: true, editable: true, defaultValue: null, length: 255, alias: num_tare_lb, type: esriFieldTypeString )
• dispoweight_ton ( modelName: dispoweight_ton, nullable: true, editable: true, defaultValue: null, length: 255, alias: dispoweight_ton, type: esriFieldTypeString )
• num_tare_ton ( modelName: num_tare_ton, nullable: true, editable: true, defaultValue: null, length: 255, alias: num_tare_ton, type: esriFieldTypeString )
• netweight_ton ( modelName: netweight_ton, nullable: true, editable: true, defaultValue: null, length: 255, alias: netweight_ton, type: esriFieldTypeString )
• dispoweight ( modelName: dispoweight, nullable: true, editable: true, defaultValue: null, length: 255, alias: dispoweight, type: esriFieldTypeString )
• num_tare ( modelName: num_tare, nullable: true, editable: true, defaultValue: null, length: 255, alias: num_tare, type: esriFieldTypeString )
• payableweight ( modelName: payableweight, nullable: true, editable: true, defaultValue: null, length: 255, alias: payableWeight, type: esriFieldTypeString )
• netweight ( modelName: netweight, nullable: true, editable: true, defaultValue: null, length: 255, alias: netweight, type: esriFieldTypeString )
• dispoestimate ( modelName: dispoestimate, nullable: true, editable: true, defaultValue: null, length: 255, alias: dispoestimate, type: esriFieldTypeString )
• totalpayable ( modelName: totalpayable, nullable: true, editable: true, defaultValue: null, alias: totalPayable, type: esriFieldTypeDouble )
• scale_receipt ( modelName: scale_receipt, nullable: true, editable: true, defaultValue: null, length: 255, alias: scale_receipt, type: esriFieldTypeString )
• measuremonitor ( modelName: measuremonitor, nullable: true, editable: true, defaultValue: null, length: 255, alias: measureMonitor, type: esriFieldTypeString )
• mileage ( modelName: mileage, nullable: true, editable: true, defaultValue: null, alias: mileage, type: esriFieldTypeDouble )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• attachment_count ( modelName: attachment_count, nullable: true, editable: true, defaultValue: null, alias: Attachment Count, type: esriFieldTypeDouble )
• payableunitvalue ( modelName: payableunitvalue, nullable: true, editable: true, defaultValue: null, length: 255, alias: payableUnitValue, type: esriFieldTypeString )
• type ( modelName: type, nullable: true, editable: true, defaultValue: null, length: 255, alias: type, type: esriFieldTypeString )
• countunits ( modelName: countunits, nullable: true, editable: true, defaultValue: null, length: 255, alias: countUnits, type: esriFieldTypeString )
• netweight_lb ( modelName: netweight_lb, nullable: true, editable: true, defaultValue: null, length: 255, alias: netweight_lb, type: esriFieldTypeString )
• num_tare_hydrated ( modelName: num_tare_hydrated, nullable: true, editable: true, defaultValue: null, length: 255, alias: num_tare_hydrated, type: esriFieldTypeString )
• num_tare_final ( modelName: num_tare_final, nullable: true, editable: true, defaultValue: null, length: 255, alias: num_tare_final, type: esriFieldTypeString )
• payablecy ( modelName: payablecy, nullable: true, editable: true, defaultValue: null, length: 255, alias: payableCY, type: esriFieldTypeString )
• latitude_mt ( modelName: latitude_mt, nullable: true, editable: true, defaultValue: null, length: 255, alias: latitude_mt, type: esriFieldTypeString )
• longitude_mt ( modelName: longitude_mt, nullable: true, editable: true, defaultValue: null, length: 255, alias: longitude_mt, type: esriFieldTypeString )
• longitude_dt ( modelName: longitude_dt, nullable: true, editable: true, defaultValue: null, length: 255, alias: longitude_dt, type: esriFieldTypeString )
• latitue_dt ( modelName: latitue_dt, nullable: true, editable: true, defaultValue: null, length: 255, alias: latitue_dt, type: esriFieldTypeString )
• ticket_type ( modelName: ticket_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Ticket type, type: esriFieldTypeString )
• measuretime ( modelName: measuretime, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: measureTime, type: esriFieldTypeDate )
• loadtime ( modelName: loadtime, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: loadtime, type: esriFieldTypeDate )
• streetnum ( modelName: streetnum, nullable: true, editable: true, defaultValue: null, length: 255, alias: streetnum, type: esriFieldTypeString )
• street ( modelName: street, nullable: true, editable: true, defaultValue: null, length: 255, alias: street, type: esriFieldTypeString )
• tph_ticketid ( modelName: tph_ticketid, nullable: true, editable: true, defaultValue: null, alias: TPH_ticketid, type: esriFieldTypeDouble )
• note_uniqueid ( modelName: note_uniqueid, nullable: true, editable: true, defaultValue: null, length: 255, alias: note_uniqueid, type: esriFieldTypeString )
• debristype_other ( modelName: debristype_other, nullable: true, editable: true, defaultValue: null, length: 255, alias: debristype_other, type: esriFieldTypeString )
• strap ( modelName: strap, nullable: true, editable: true, defaultValue: null, length: 255, alias: Strap, type: esriFieldTypeString )
• landuse ( modelName: landuse, nullable: true, editable: true, defaultValue: null, length: 255, alias: Landuse, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• disposalsitetype ( modelName: disposalsitetype, nullable: true, editable: true, defaultValue: null, length: 255, alias: disposalsitetype, type: esriFieldTypeString )
• wg_freon ( modelName: wg_freon, nullable: true, editable: true, defaultValue: null, length: 255, alias: wg_freon, type: esriFieldTypeString )
• length_titledproperty_ft ( modelName: length_titledproperty_ft, nullable: true, editable: true, defaultValue: null, length: 255, alias: length_titledproperty_ft, type: esriFieldTypeString )
• ticket_status ( modelName: ticket_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: ticket_status, type: esriFieldTypeString )
• offense_number ( modelName: offense_number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Offense Number, type: esriFieldTypeString )
• length ( modelName: length, nullable: true, editable: true, defaultValue: null, alias: Length, type: esriFieldTypeDouble )
• registration ( modelName: registration, nullable: true, editable: true, defaultValue: null, length: 255, alias: Registration, type: esriFieldTypeString )
• hin ( modelName: hin, nullable: true, editable: true, defaultValue: null, length: 255, alias: HIN, type: esriFieldTypeString )
• make ( modelName: make, nullable: true, editable: true, defaultValue: null, length: 255, alias: Make, type: esriFieldTypeString )
• type2 ( modelName: type2, nullable: true, editable: true, defaultValue: null, length: 255, alias: Type2, type: esriFieldTypeString )
• percentload ( modelName: percentload, nullable: true, editable: true, defaultValue: null, length: 255, alias: percentLoad, type: esriFieldTypeString )
• roe_id ( modelName: roe_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: ROE_ID, type: esriFieldTypeString )
• dev_loaduniqueid ( modelName: dev_loaduniqueid, nullable: true, editable: true, defaultValue: null, length: 255, alias: DEV_LoadUniqueID, type: esriFieldTypeString )
• dev_measureuniqueid ( modelName: dev_measureuniqueid, nullable: true, editable: true, defaultValue: null, length: 255, alias: DEV_MeasureUniqueID, type: esriFieldTypeString )
• objectid ( modelName: objectid, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeDouble )
• report_type ( modelName: report_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Report Type, type: esriFieldTypeString )
• objectid_1 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid_1, alias: ObjectID_1 )

Templates:

• Name: 'Haul Tickets$'
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata