Tables:

Table: 'Haul Tickets$' (5)

Name: 'Haul Tickets$'

Display Field: globalid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 960464b234b74809aec9433ffddb89bd

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, alias: netweight_ton, type: esriFieldTypeDouble )
• 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, alias: dispoestimate, type: esriFieldTypeDouble )
• totalpayable ( modelName: totalpayable, nullable: true, editable: true, defaultValue: null, alias: totalPayable, type: esriFieldTypeDouble )
• scale_receipt ( modelName: scale_receipt, nullable: true, editable: true, defaultValue: null, alias: scale_receipt, type: esriFieldTypeDouble )
• 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: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, 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, alias: payableCY, type: esriFieldTypeDouble )
• latitude_mt ( modelName: latitude_mt, nullable: true, editable: true, defaultValue: null, alias: latitude_mt, type: esriFieldTypeDouble )
• longitude_mt ( modelName: longitude_mt, nullable: true, editable: true, defaultValue: null, alias: longitude_mt, type: esriFieldTypeDouble )
• 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, length: 255, alias: TPH_ticketid, type: esriFieldTypeString )
• 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, length: 255, alias: Length, type: esriFieldTypeString )
• 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 )
• load_date_conv ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Load_Date_Conv, type: esriFieldTypeDate )
• wg_w_freon ( nullable: true, editable: true, defaultValue: null, alias: wg_w_freon, type: esriFieldTypeDouble )
• wg_wo ( nullable: true, editable: true, defaultValue: null, alias: wg_wo, type: esriFieldTypeDouble )
• total_wg ( nullable: true, editable: true, defaultValue: null, alias: total_wg, type: esriFieldTypeDouble )
Templates:
• Name: 'Haul Tickets$'
  Description:
  Prototype:
  truckcert: null
  ticket_type: null
  measuremonitor: null
  disposalsitetype: null
  num_tare_ton: null
  scale_receipt: null
  type: null
  hin: null
  latitude_mt: null
  longitude_mt: null
  trucktype: null
  num_tare: null
  debristype: null
  zone: null
  longitude_dt: null
  incidentid: null
  loaddate: null
  highway: null
  payableweight: null
  dispoweight: null
  percentload: null
  longitude: null
  mileage: null
  note_uniqueid: null
  ticket_status: null
  loadtime: null
  type2: null
  created_user: null
  roe_id: null
  latitue_dt: null
  report_type: null
  num_tare_lb: null
  strap: null
  subcontactor: null
  version: null
  unitbarcode: null
  offense_number: null
  wg_freon: null
  netweight: null
  milemarker: null
  registration: null
  netweight_lb: null
  truckid: null
  contractor: null
  countunits: null
  city: null
  netweight_ton: null
  payableunit: null
  latitude: null
  globalid: null
  streetnum: null
  dispoweight_ton: null
  payablecy: null
  debristype_other: null
  totalpayable: null
  capacity: null
  measuresite: null
  payableunitvalue: null
  loadmonitor: null
  street: null
  tph_ticketid: null
  landuse: null
  last_edited_date: null
  num_tare_hydrated: null
  num_tare_final: null
  measuretime: null
  make: null
  ticketid: null
  measuredate: null
  comments: null
  address: null
  percentfull: null
  length_titledproperty_ft: null
  length: null
  dispoweight_lb: null
  dispoestimate: null
  last_edited_user: null
  dev_measureuniqueid: null
  created_date: null
  highwayoffset: null
  unit_weight: null
  attachment_count: null
  objectid: null
  dev_loaduniqueid: null
  
  Drawing Tool: esriFeatureEditToolNone