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