{"recNo":5602,"appUser_recNo":10549,"area":"tripSearch_config","name":"config","selectedRecNo":18514,"mainRecNo":null,"viewList":[{"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":[]}]}