{"recNo":5602,"appUser_recNo":10549,"area":"tripSearch_config","name":"config","selectedRecNo":18514,"mainRecNo":null,"viewList":[{"recNo":18514,"name":"Client Vouchers ","orderId":1,"isDefault":null,"isSelected":true,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationEndDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":2,"header":"Trip Client","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":1,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"No of Vouchers","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":34,"header":"Reservation Client Balance","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Balance","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationClientBalance","isIncluded":true,"isDefault":true,"defaultOrderId":34,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":49,"header":"Trip Number","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":34,"header":"Reservation Client Balance","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Balance","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationClientBalance","isIncluded":true,"isDefault":true,"defaultOrderId":34,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":7,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","label":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Advisor","placeHolder":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","filterOperatorType":1,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":31,"field":"reservationClientBalance","label":"Reservation Client Balance","maxLength":100,"isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Client Balance","placeHolder":"Reservation Client Balance","field":"reservationClientBalance","filterOperatorType":1,"type":"CurrencyAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":-0.01,"value":{"trimString":null,"compareCondition":6,"value":[-0.01],"minValue":null,"maxValue":null}}]},{"recNo":21,"type":"DropDownField","label":"Reservation Travel Category","field":"reservationTravelCategory","dataSource":"ReservationTravelCategory","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Travel Category","placeHolder":"Reservation Travel Category","field":"reservationTravelCategory","filterOperatorType":5,"type":"MultiDropDownFieldOperator","dataSource":"ReservationTravelCategory","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"ClientVoucher","value":{"value":[11]}}],"isIncluded":true}],"filterSets":[]},{"recNo":9723,"name":"Clients with Current Reservation Balance","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"clientProfileName","sortDirection":"asc","searchAreaViewType":null,"reportFormat":null,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":2,"header":"Trip Client","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":1,"header":"Trip Name","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":34,"header":"Reservation Client Balance","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Client Balance","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationClientBalance","isIncluded":true,"isDefault":true,"defaultOrderId":34,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":31,"field":"reservationClientBalance","label":"Reservation Client Balance","maxLength":100,"isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Client Balance","placeHolder":"Reservation Client Balance","field":"reservationClientBalance","filterOperatorType":1,"type":"CurrencyAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":0.01,"value":{"trimString":null,"compareCondition":5,"value":[0.01],"minValue":null,"maxValue":null}}]}],"filterSets":[]},{"recNo":18770,"name":"Clients without bookings in past 2 years","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationStartDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":2,"header":"Trip Client","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"No of Trips","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":49,"header":"Trip Number","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Depart Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":24,"header":"Trip Destination","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":3,"type":"LookupFilter","moduleForLookup":"ClientProfile","field":"clientProfileRecNo","label":"Trip Client","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Client","placeHolder":"Reservation Provider","field":"clientProfileRecNo","filterOperatorType":1,"type":"MultiLookupFilter","moduleForLookup":"ClientProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"trimString":null,"compareCondition":1,"value":[],"minValue":null,"maxValue":null}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":37,"label":"Reservation Booking Date Range","filterArea":5,"filterFieldList":[{"recNo":0,"field":"reservationBookDateTimeFrom","label":"Reservation Booking Date Range","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,-24,0","relativeDate":null,"date":null,"trimString":null},"type":"DateRangeOperator","placeHolder":"Reservation Booking Date Range","displayText":"=0,-24,0"},{"recNo":0,"field":"reservationBookDateTimeTo","label":"Reservation Booking Date Range","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=0,0,0","relativeDate":null,"date":null,"trimString":null,"time":"23:59:59.9999999","dateTimeUTC":null},"type":"DateRangeOperatorHidden","placeHolder":"Reservation Booking Date Range","displayText":"=0,0,0"}]}]}]},{"recNo":9726,"name":"Future Departures ","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"destinationName","sortDirection":"asc","searchAreaViewType":null,"reportFormat":false,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":2,"header":"Trip Client","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":1,"header":"Trip Name","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":121,"header":"Trip Destinations","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destinations","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinations","isIncluded":true,"isDefault":true,"defaultOrderId":121},{"recNo":48,"header":"Trip Total Fare","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"tripTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":48,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":117,"header":"Trip Total Commission","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Commission","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"tripCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":117,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":4,"type":"DateRangeOperator","label":"Trip Start Date Range","field":"tripStartDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=0,0,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,0,0","relativeDate":null,"date":null,"trimString":null}},{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":9727,"name":"Future Departures by Client Name - Report View","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"startDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":2,"header":"Trip Client","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":1,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"No of Trips","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":49,"header":"Trip Number","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Depart Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":121,"header":"Trip Destinations","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinations","isIncluded":true,"isDefault":true,"defaultOrderId":121},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":4,"type":"DateRangeOperator","label":"Trip Start Date Range","field":"tripStartDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=0,0,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,0,0","relativeDate":null,"date":null,"trimString":null}},{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":18510,"name":"Missing Client Profile","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"createDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":null,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":2,"header":"Trip Client","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":24,"header":"Trip Destination","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24}],"filters":[{"recNo":42,"type":"DateRangeOperator","label":"Trip Created Date Range","field":"createDateTimeFrom","placeHolder":"Value","isIncluded":true,"allowRemove":true,"filterArea":5,"filterFieldList":[{"label":"Create Date","placeHolder":"Create Date","field":"createDateTimeFrom","filterOperatorType":6,"type":"DateTimeUtcRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=-31,0,0","value":{"trimString":null,"text":"=-31,0,0","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:50:28.6+00:00","compareCondition":1,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null}},{"label":"Create Date Time To","placeHolder":"Create Date Time To","field":"createDateTimeTo","filterOperatorType":6,"type":"DateTimeUtcRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=","value":{"trimString":null,"text":"=","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:50:28.6+00:00","compareCondition":null,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null,"time":"23:59:59.9999999"}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":1,"label":"Client Name","filterArea":1,"filterFieldList":[{"recNo":0,"field":"profileName","label":"Client Name","value":{"trimString":null,"compareCondition":4,"value":[""]},"type":"TextBoxAreaOperator","placeHolder":"Client Name","displayText":""}]}]}]},{"recNo":18509,"name":"Missing Destination","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"createDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":null,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":2,"header":"Trip Client","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":24,"header":"Trip Destination","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24}],"filters":[{"recNo":42,"type":"DateRangeOperator","label":"Trip Created Date Range","field":"createDateTimeFrom","placeHolder":"Value","isIncluded":true,"allowRemove":true,"filterArea":5,"filterFieldList":[{"label":"Create Date","placeHolder":"Create Date","field":"createDateTimeFrom","filterOperatorType":6,"type":"DateTimeUtcRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=-31,0,0","value":{"trimString":null,"text":"=-31,0,0","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:51:16.83+00:00","compareCondition":1,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null}},{"label":"Create Date Time To","placeHolder":"Create Date Time To","field":"createDateTimeTo","filterOperatorType":6,"type":"DateTimeUtcRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=","value":{"trimString":null,"text":"=","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:51:16.83+00:00","compareCondition":null,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null,"time":"23:59:59.9999999"}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":1,"label":"Destination Name","filterArea":23,"filterFieldList":[{"recNo":0,"field":"name","label":"Name","value":{"trimString":null,"compareCondition":4,"value":[""]},"type":"TextBoxAreaOperator","placeHolder":"Destination Name","displayText":""}]}]}]},{"recNo":9725,"name":"Missing Insurance","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"createDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":null,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":2,"header":"Trip Client","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":1,"header":"Trip Name","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":24,"header":"Trip Destination","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24}],"filters":[{"recNo":42,"type":"DateRangeOperator","label":"Trip Created Date Range","field":"createDateTimeFrom","placeHolder":"Value","isIncluded":true,"allowRemove":true,"filterArea":5,"filterFieldList":[{"label":"Create Date","placeHolder":"Create Date","field":"createDateTimeFrom","filterOperatorType":6,"type":"DateTimeUtcRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=-31,0,0","value":{"trimString":null,"text":"=-31,0,0","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:51:35.967+00:00","compareCondition":1,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null}},{"label":"Create Date Time To","placeHolder":"Create Date Time To","field":"createDateTimeTo","filterOperatorType":6,"type":"DateTimeUtcRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=","value":{"trimString":null,"text":"=","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:51:35.967+00:00","compareCondition":null,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null,"time":"23:59:59.9999999"}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":21,"label":"Reservation Travel Category","filterArea":5,"filterFieldList":[{"recNo":0,"field":"reservationTravelCategory","label":"Reservation Travel Category","value":{"value":[8]},"type":"MultiDropDownFieldOperator","placeHolder":"Reservation Travel Category","displayText":"Insurance"}]}]}]},{"recNo":9724,"name":"Missing Service Fee","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"createDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":null,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":2,"header":"Trip Client","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":1,"header":"Trip Name","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":24,"header":"Trip Destination","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24}],"filters":[{"recNo":42,"type":"DateRangeOperator","label":"Trip Created Date Range","field":"createDateTimeFrom","placeHolder":"Value","isIncluded":true,"allowRemove":true,"filterArea":5,"filterFieldList":[{"label":"Create Date","placeHolder":"Create Date","field":"createDateTimeFrom","filterOperatorType":6,"type":"DateTimeUtcRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=-31,0,0","value":{"trimString":null,"text":"=-31,0,0","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:51:50.956+00:00","compareCondition":1,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null}},{"label":"Create Date Time To","placeHolder":"Create Date Time To","field":"createDateTimeTo","filterOperatorType":6,"type":"DateTimeUtcRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=","value":{"trimString":null,"text":"=","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:51:50.956+00:00","compareCondition":null,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null,"time":"23:59:59.9999999"}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":21,"label":"Reservation Travel Category","filterArea":5,"filterFieldList":[{"recNo":0,"field":"reservationTravelCategory","label":"Reservation Travel Category","value":{"value":[9]},"type":"MultiDropDownFieldOperator","placeHolder":"Reservation Travel Category","displayText":"ServiceFee"}]}]}]},{"recNo":18511,"name":"Missing Traveler(s)","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"createDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":null,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":2,"header":"Trip Client","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":24,"header":"Trip Destination","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24}],"filters":[{"recNo":42,"type":"DateRangeOperator","label":"Trip Created Date Range","field":"createDateTimeFrom","placeHolder":"Value","isIncluded":true,"allowRemove":true,"filterArea":5,"filterFieldList":[{"label":"Create Date","placeHolder":"Create Date","field":"createDateTimeFrom","filterOperatorType":6,"type":"DateTimeUtcRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=-31,0,0","value":{"trimString":null,"text":"=-31,0,0","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:52:05.355+00:00","compareCondition":1,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null}},{"label":"Create Date Time To","placeHolder":"Create Date Time To","field":"createDateTimeTo","filterOperatorType":6,"type":"DateTimeUtcRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=","value":{"trimString":null,"text":"=","dateTimeUTC":null,"relativeDateTimeUTC":"2026-03-06T22:52:05.355+00:00","compareCondition":null,"yearOffset":null,"year":null,"monthOffset":null,"month":null,"dayOffset":null,"dayOfWeek":null,"day":null,"time":"23:59:59.9999999"}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":48,"label":"Reservation Traveler Name - Freeflow","filterArea":5,"filterFieldList":[{"recNo":0,"field":"reservationTravelerName","label":"Reservation Traveler Name - Freeflow","value":{"trimString":null,"compareCondition":4,"value":[""]},"type":"TextBoxAreaOperator","placeHolder":"Reservation Traveler Name - Freeflow","displayText":""}]}]}]},{"recNo":7285,"name":"Mon to Sun Trip Start Date Range","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":null,"sortDirection":null,"searchAreaViewType":null,"reportFormat":false,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":1,"header":"Trip Name","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":2,"header":"Client","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4}],"filters":[{"recNo":4,"type":"DateRangeOperator","label":"Trip Start Date Range","field":"tripStartDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=Mon-1","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=Mon-1","relativeDate":null,"date":null,"trimString":null,"time":null,"dateTimeUTC":null}},{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=Sun","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=Sun","relativeDate":null,"date":null,"trimString":null,"time":"23:59:59.9999999","dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":5599,"name":"Outstanding Client Balance","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":null,"sortDirection":null,"searchAreaViewType":null,"reportFormat":false,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":2,"header":"Client","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":28,"header":"Reservation Advisor","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationAdvisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":28},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":34,"header":"Reservation Client Balance","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Client Balance","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationClientBalance","isIncluded":true,"isDefault":true,"defaultOrderId":34,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":3,"type":"LookupFilter","moduleForLookup":"ClientProfile","field":"clientProfileRecNo","label":"Trip Client","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Client","placeHolder":"Reservation Provider","field":"clientProfileRecNo","filterOperatorType":1,"type":"MultiLookupFilter","moduleForLookup":"ClientProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}]},{"recNo":7,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","label":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Advisor","placeHolder":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","filterOperatorType":1,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":31,"field":"reservationClientBalance","label":"Reservation Client Balance","maxLength":100,"isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Client Balance","placeHolder":"Reservation Client Balance","field":"reservationClientBalance","filterOperatorType":1,"type":"CurrencyAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":0.01,"value":{"value":[0.01],"compareCondition":5,"trimString":null}}]}],"filterSets":[]},{"recNo":7664,"name":"Outstanding Supplier Balance","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationEndDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":false,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":28,"header":"Reservation Advisor","width":"168","orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationAdvisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":28},{"recNo":1,"header":"Trip Name","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":35,"header":"Reservation Supplier Balance","width":"267","orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Client Balance","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierBalance","isIncluded":true,"isDefault":true,"defaultOrderId":35,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":14,"header":"Reservation Start Date","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationStartDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":14},{"recNo":9,"header":"Reservation End Date","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationEndDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":9}],"filters":[{"recNo":29,"type":"DateRangeOperator","label":"Trip End Date Range","field":"tripEndDateTimeFrom","fieldForName":"From","field1":"tripEndDateTimeTo","field1ForName":"To","maxLength":100,"dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Trip End Date","placeHolder":"Trip End Date","field":"tripEndDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":null,"relativeDate":null,"date":null,"trimString":null}},{"label":"Trip End Date","placeHolder":"Trip End Date","field":"tripEndDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}],"isIncluded":true},{"recNo":16,"type":"LookupFilter","moduleForLookup":"SupplierProfile","field":"reservationSupplierProfileRecNo","label":"Reservation Supplier","maxLength":100,"dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Supplier","placeHolder":"Reservation Supplier","field":"reservationSupplierProfileRecNo","filterOperatorType":1,"type":"MultiLookupFilter","moduleForLookup":"SupplierProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":32,"field":"reservationSupplierBalance","label":"Reservation Supplier Balance","maxLength":100,"isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Supplier Balance","placeHolder":"Reservation Supplier Balance","field":"reservationSupplierBalance","filterOperatorType":1,"type":"CurrencyAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":0.01,"value":{"value":[0.01],"compareCondition":5,"trimString":null}}]},{"recNo":7,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","label":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Advisor","placeHolder":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","filterOperatorType":1,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":4,"type":"DateRangeOperator","label":"Trip Start Date Range","field":"tripStartDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":null,"relativeDate":null,"date":null,"trimString":null}},{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":19417,"name":"Owed to Supplier (Draft)","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationEndDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":false,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":28,"header":"Reservation Advisor","width":"168","orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationAdvisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":28},{"recNo":1,"header":"Trip Name","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":35,"header":"Reservation Supplier Balance","width":"267","orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Client Balance","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierBalance","isIncluded":true,"isDefault":true,"defaultOrderId":35,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":14,"header":"Reservation Start Date","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationStartDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":14},{"recNo":9,"header":"Reservation End Date","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationEndDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":9}],"filters":[{"recNo":29,"type":"DateRangeOperator","label":"Trip End Date Range","field":"tripEndDateTimeFrom","fieldForName":"From","field1":"tripEndDateTimeTo","field1ForName":"To","maxLength":100,"dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Trip End Date","placeHolder":"Trip End Date","field":"tripEndDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":null,"relativeDate":null,"date":null,"trimString":null}},{"label":"Trip End Date","placeHolder":"Trip End Date","field":"tripEndDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}],"isIncluded":true},{"recNo":16,"type":"LookupFilter","moduleForLookup":"SupplierProfile","field":"reservationSupplierProfileRecNo","label":"Reservation Supplier","maxLength":100,"dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Supplier","placeHolder":"Reservation Supplier","field":"reservationSupplierProfileRecNo","filterOperatorType":1,"type":"MultiLookupFilter","moduleForLookup":"SupplierProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":32,"field":"reservationSupplierBalance","label":"Reservation Supplier Balance","maxLength":100,"isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Supplier Balance","placeHolder":"Reservation Supplier Balance","field":"reservationSupplierBalance","filterOperatorType":1,"type":"CurrencyAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":-0.01,"value":{"trimString":null,"compareCondition":6,"value":[-0.01]}}]},{"recNo":7,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","label":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Advisor","placeHolder":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","filterOperatorType":1,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":4,"type":"DateRangeOperator","label":"Trip Start Date Range","field":"tripStartDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":null,"relativeDate":null,"date":null,"trimString":null}},{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":9733,"name":"Sales by Client Last 12 Months","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"startDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":2,"header":"Client","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":2,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"No of Trips","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":49,"header":"Trip Number","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Depart Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":24,"header":"Trip Destination","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":37,"type":"DateRangeOperator","label":"Reservation Booking Date Range","field":"reservationBookDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Booking Date Range","placeHolder":"Reservation Booking Date Range","field":"reservationBookDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=0,-12,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,-12,0","relativeDate":null,"date":null,"trimString":null}},{"label":"Reservation Booking Date Range","placeHolder":"Reservation Booking Date Range","field":"reservationBookDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=31,-1,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=31,-1,0","relativeDate":null,"date":null,"trimString":null,"time":"23:59:59.9999999","dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":9730,"name":"Sales by Supplier Last 12 Months","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"startDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/supplier-profiles/detail/{reservationSupplierProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":2,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":70,"header":"Reservation Supplier Profile Record Number","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":70},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Number of Reservations","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":35,"header":"Reservation Supplier Balance","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Balance","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierBalance","isIncluded":true,"isDefault":true,"defaultOrderId":35,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":2,"header":"Client","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":49,"header":"Trip Number","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":67,"header":"Reservation Number","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":67},{"recNo":80,"header":"Reservation Confirmation Number","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Confirmation Number","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}/reservations/detail/{reservationRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationConfirmationNo","isIncluded":true,"isDefault":true,"defaultOrderId":80},{"recNo":29,"header":"Travel Category","width":null,"orderId":14,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Category","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTravelCategoryName","isIncluded":true,"isDefault":true,"doAlighRight":false,"defaultOrderId":29},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":15,"entityRecNo":null,"entityName":null,"name":null,"displayName":"depart date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":16,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":17,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":35,"header":"Reservation Supplier Balance","width":null,"orderId":18,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Balance","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierBalance","isIncluded":true,"isDefault":true,"defaultOrderId":35,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":37,"type":"DateRangeOperator","label":"Reservation Booking Date Range","field":"reservationBookDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Booking Date Range","placeHolder":"Reservation Booking Date Range","field":"reservationBookDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=0,-12,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,-12,0","relativeDate":null,"date":null,"trimString":null}},{"label":"Reservation Booking Date Range","placeHolder":"Reservation Booking Date Range","field":"reservationBookDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=31,-1,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=31,-1,0","relativeDate":null,"date":null,"trimString":null,"time":"23:59:59.9999999","dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":9729,"name":"Sales by Travel Category Last 12 Months","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"startDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":29,"header":"Travel Category","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Travel Category","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTravelCategoryName","isIncluded":true,"isDefault":true,"doAlighRight":false,"defaultOrderId":29},{"recNo":52,"header":"Summary Count","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Number of Reservations","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/supplier-profiles/detail/{reservationSupplierProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":70,"header":"Reservation Supplier Profile Record Number","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":70},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":49,"header":"Trip Number","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":67,"header":"Reservation Number","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":67},{"recNo":80,"header":"Reservation Confirmation Number","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Confirmation Number","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}/reservations/detail/{reservationRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationConfirmationNo","isIncluded":true,"isDefault":true,"defaultOrderId":80},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Depart Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":14,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":15,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":37,"type":"DateRangeOperator","label":"Reservation Booking Date Range","field":"reservationBookDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Booking Date Range","placeHolder":"Reservation Booking Date Range","field":"reservationBookDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"=0,-12,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,-12,0","relativeDate":null,"date":null,"trimString":null}},{"label":"Reservation Booking Date Range","placeHolder":"Reservation Booking Date Range","field":"reservationBookDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=31,-1,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=31,-1,0","relativeDate":null,"date":null,"trimString":null}}]}],"filterSets":[]},{"recNo":18513,"name":"Settled Reservations, Commission Not paid to advisors","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationEndDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Supplier","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/supplier-profiles/detail/{reservationSupplierProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":2,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":70,"header":"Reservation Supplier Profile Record Number","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":70},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Number of Reservations","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Commission","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":2,"header":"Trip Client","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":49,"header":"Trip Number","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":67,"header":"Reservation Number","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":67},{"recNo":80,"header":"Reservation Confirmation Number","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Confirmation Number","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}/reservations/detail/{reservationRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationConfirmationNo","isIncluded":true,"isDefault":true,"defaultOrderId":80},{"recNo":29,"header":"Reservation Travel Category","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Category","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTravelCategoryName","isIncluded":true,"isDefault":true,"doAlighRight":false,"defaultOrderId":29},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":14,"entityRecNo":null,"entityName":null,"name":null,"displayName":"depart date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":15,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":16,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Reservation Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":7,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","label":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Advisor","placeHolder":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","filterOperatorType":1,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":41,"type":"DateRangeOperator","label":"Reservation Balances Settled Date Range","field":"reservationAccountingEntryCreateDateFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Accounting Entry Create Date","placeHolder":"Reservation Accounting Entry Create Date","field":"reservationAccountingEntryCreateDateFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null}},{"label":"Reservation Accounting Entry Create Date","placeHolder":"Reservation Accounting Entry Create Date","field":"reservationAccountingEntryCreateDateTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"=0,0,0","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=0,0,0","relativeDate":null,"date":null,"trimString":null,"time":"23:59:59.9999999","dateTimeUTC":null}}]},{"recNo":47,"type":"DateRangeOperator","label":"Reservation Advisor Date Reconciled From/To","field":"reservationAdvisorReconciliationDateFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Advisor Reconciliation Date From","placeHolder":"Advisor Reconciliation Date From","field":"reservationAdvisorReconciliationDateFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":3,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null}},{"label":"Advisor Reconciliation Date To","placeHolder":"Advisor Reconciliation Date To","field":"reservationAdvisorReconciliationDateTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":20108,"name":"Starting Table View","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":null,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"destinationName","sortDirection":"asc","searchAreaViewType":null,"reportFormat":false,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":121,"header":"Trip Destinations","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Destinations","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinations","isIncluded":true,"isDefault":true,"defaultOrderId":121},{"recNo":2,"header":"Trip Client","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Client","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Start Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":22,"header":"Trip End Date","width":"177","orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip End Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"endDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":22},{"recNo":48,"header":"Trip Total Fare","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"tripTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":48,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":117,"header":"Trip Total Commission","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Commission","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"tripCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":117,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":1,"type":"TextBoxAreaOperator","field":"tripName","label":"Trip Name","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Name","placeHolder":"Trip Name","field":"tripName","filterOperatorType":4,"type":"TextBoxAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"trimString":null,"compareCondition":5,"value":[null]}}]},{"recNo":3,"type":"LookupFilter","moduleForLookup":"ClientProfile","field":"clientProfileRecNo","label":"Trip Client","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Client","placeHolder":"Reservation Provider","field":"clientProfileRecNo","filterOperatorType":1,"type":"MultiLookupFilter","moduleForLookup":"ClientProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"trimString":null,"compareCondition":1,"value":[],"minValue":null,"maxValue":null}}]},{"recNo":4,"type":"DateRangeOperator","label":"Trip Start Date Range","field":"tripStartDateTimeFrom","placeHolder":"Value","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeFrom","filterOperatorType":2,"type":"DateRangeOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null}},{"label":"Trip Start Date","placeHolder":"Trip Start Date","field":"tripStartDateTimeTo","filterOperatorType":2,"type":"DateRangeOperatorHidden","doAutofocus":true,"doClick":true,"isRequired":true,"addADay":true,"displayText":"","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":null,"relativeDate":null,"date":null,"trimString":null,"time":null,"relativeDateTimeUTC":null,"dateTimeUTC":null}}]}],"filterSets":[]},{"recNo":18518,"name":"Supplier Vouchers ","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationEndDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":16,"header":"Reservation Supplier","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Supplier Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":1,"sortIndex":2,"widthPercentage":null,"columnDef":"reservationSupplierProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":16},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"No of Vouchers","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":35,"header":"Reservation Supplier Balance","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Supplier Balance","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierBalance","isIncluded":true,"isDefault":true,"defaultOrderId":35,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":49,"header":"Trip Number","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":40,"header":"Trip Date Created","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Date Created","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"createDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":40},{"recNo":35,"header":"Reservation Supplier Balance","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Supplier Balance","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationSupplierBalance","isIncluded":true,"isDefault":true,"defaultOrderId":35,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":7,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","label":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","dataSource":"BooleanOptions","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Advisor","placeHolder":"Reservation Advisor","field":"reservationAdvisorProfileRecNo","filterOperatorType":1,"type":"LookupFilter","moduleForLookup":"AdvisorProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"value":[""],"compareCondition":1,"trimString":null}}],"isIncluded":true},{"recNo":21,"type":"DropDownField","label":"Reservation Travel Category","field":"reservationTravelCategory","dataSource":"ReservationTravelCategory","placeHolder":"Value","filterArea":5,"filterFieldList":[{"label":"Reservation Travel Category","placeHolder":"Reservation Travel Category","field":"reservationTravelCategory","filterOperatorType":5,"type":"MultiDropDownFieldOperator","dataSource":"ReservationTravelCategory","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"SupplierVoucher","value":{"value":[13]}}],"isIncluded":true},{"recNo":32,"field":"reservationSupplierBalance","label":"Reservation Supplier Balance","maxLength":100,"isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Reservation Supplier Balance","placeHolder":"Reservation Supplier Balance","field":"reservationSupplierBalance","filterOperatorType":1,"type":"CurrencyAreaOperator","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":-0.01,"value":{"trimString":null,"compareCondition":6,"value":[-0.01],"minValue":null,"maxValue":null}}]}],"filterSets":[]}]}