0bookingBooking reportbegTimestampdate1endTimestampdate1groupBystring1sortBystring1sortDirsstring1IDintegerid11IDVehicle idintegerobjectid1Vehicle idLocation idintegerlocationid1Location idPerson Idintegerpersonid1Person idOrganization idintegerorgid1Organization idTrip Type IdintegertripTypeId1Trip Type IdPurpose IdintegerpurposeId1Purpose IdCreated atdatetimed.m.Y H:i:screatedAt1Created atCommute DistanceintegercommuteDistance1Commute DistanceCommute Distance %float2commuteDistancePercent1Commute Distance %Start timedatetimed.m.Y H:i:sstartTime1Booking start timeEnd timedatetimed.m.Y H:i:sendTime1Booking end timeDurationintervaldhmduration1Booking durationTrip start timedatetimed.m.Y H:i:stripStartTimeTrip start timeTrip end timedatetimed.m.Y H:i:stripEndTimeTrip end timePerson namestringpersonName11Person namePhonestringpersonPhone11Person phone numberVehicle platestringvehiclePlate11Vehicle plateLocation namestringlocationName11Location nameStatusstringstatus11StatusVehicle statusstringvehicleStatus11Vehicle statusDistancefloat21distancekm1DistanceVehicle groupsstringvehicleGroups11Vehicle groupsCancellation reasonstringcancellationReason1Cancellation reasonFault descriptionstringfaultDescription1Fault descriptionCost per hourfloat2costPerHour€11Cost per hourCost per kmfloat2costPerKm€11Cost per kmDepartment namestringdepartmentName1Department nameEmployee numberstringemployeeNumber1Employee numberShareablebooleanbookingShareable1Booking shareableOverridebooleanoverride1OverrideDestination addressstringdestinationAddress11Destination addressTrip typestringtripType11Trip typePurposestringpurpose11PurposeNotestringnote11NoteSharing notesstringsharingNote1Sharing notesShared booking idintegersharedBookingId11Shared booking idShared booking personstringsharedBookingPersonName11Shared booking person nameShared booking destinationstringsharedBookingDestination11Shared booking destinationShared booking notestringsharedBookingNote11Shared booking noteInvoicing codestringpublicId11Booking public idOrder numberstringorderNumber1Value of the order field in the booking form