{"table":{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"balance","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"reverseSign":false,"label":"","lensApiName":"xRB_FT_Dual_Not_Match_V1","repeatGroupingLabels":false},{"alias":"total","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#EAEDED"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"single","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"label":"Total","expression":"sum(balance)"}],"lensDimensions":[{"fieldName":"AccountName","label":"Account"},{"fieldName":"CompanyName","label":"Company"},{"fieldName":"TrialBalance3","label":"TB3"}],"lensMeasures":[],"softDates":{"enabled":false},"subtotals":{"columns":[{"enabled":true,"fieldName":"AccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":true,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"single","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"label":"Total {value}","format":{"abovePosition":false,"isHiddenForSingleRows":false}},{"enabled":false,"fieldName":"CompanyName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TrialBalance3","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDual_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]},"drillTables":[{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"totdetail","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"single","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"label":"Total","expression":"sum(detail)"},{"alias":"detail","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"reverseSign":false,"label":"","lensApiName":"DrillLensOutstanding_Dual","repeatGroupingLabels":false}],"lensDimensions":[],"lensMeasures":[],"softDates":{"enabled":false},"drillConfig":{"bindings":[{"from":"AccountName","to":"AccountName"},{"from":"CompanyName","to":"CompanyName"},{"from":"TrialBalance3","to":"TrialBalance3"},{"from":"MatchingStatus","to":"MatchingStatus"},{"from":"LineType","to":"LineType"}]},"subtotals":{"columns":[{"enabled":false,"fieldName":"GeneralLedgerAccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDocumentNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDualOutstanding_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]}],"lensFormatting":{"decimalPrecision":0,"numberColourRed":false,"numberFormatBrackets":false,"numberScaling":"none","tableDensity":0,"columnDensity":75,"reverseSign":false,"columnsLocked":false,"rowBorderType":0,"ignoreWarnings":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","headerCurrencyOptions":"iso_code"},"lensCache":{},"version":19}

{"table":{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"xRB_Workspace_Account_Profile","visible":true,"rowFormatting":{"text":{"font":"arial","size":14,"bold":true,"italic":false,"color":"#2874A6","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"single","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"reverseSign":false,"label":"","lensApiName":"xRB_Account_Name_FT","repeatGroupingLabels":false}],"lensDimensions":[{"fieldName":"AccountBillingCity","label":"City"},{"fieldName":"AccountBillingState","label":"State"},{"fieldName":"AccountBillingCountry","label":"Country"},{"fieldName":"AccountType","label":"Type"},{"fieldName":"AccountNumber","label":"Account Number"}],"lensMeasures":[],"softDates":{"enabled":false},"subtotals":{"columns":[{"enabled":false,"fieldName":"AccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountBillingCity","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountBillingState","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountBillingCountry","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountType","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"hidden":false,"region":"normal","locked":false,"text":"Account Name","field":"AccountName_b85774646183d637","width":300,"name":"AccountName_b85774646183d637","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"City","field":"AccountBillingCity_b85774646183d637","width":161,"name":"AccountBillingCity_b85774646183d637","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"State","field":"AccountBillingState_b85774646183d637","width":112,"name":"AccountBillingState_b85774646183d637","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Country","field":"AccountBillingCountry_b85774646183d637","width":175,"name":"AccountBillingCountry_b85774646183d637","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Type","field":"AccountType_b85774646183d637","width":126,"name":"AccountType_b85774646183d637","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Account Number","field":"AccountNumber_b85774646183d637","width":154.33331298828125,"name":"AccountNumber_b85774646183d637","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":true,"region":"normal","locked":false,"text":"Count of Rows","field":"count_*_1_b85774646183d637","width":111,"name":"count_*_1_b85774646183d637","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":79,"measureColumns":[{"fieldName":"count_*_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]},"drillTables":[],"lensFormatting":{"decimalPrecision":0,"numberColourRed":false,"numberFormatBrackets":false,"numberScaling":"none","tableDensity":0,"columnDensity":75,"reverseSign":false,"columnsLocked":false,"rowBorderType":0,"ignoreWarnings":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","headerCurrencyOptions":"iso_code"},"lensCache":{},"version":19}

{"table":{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"revenue","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"reverseSign":false,"label":"Recognized Revenue","lensApiName":"xRB_Dual_TB_2_Revenue","repeatGroupingLabels":false},{"alias":"totrev","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"single","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"label":"Total Revenue Recognized","expression":"sum(revenue)"},{"alias":"SIN","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"reverseSign":false,"label":"Invoices","lensApiName":"xRB_Dual_SIN_only","repeatGroupingLabels":false},{"alias":"totSIN","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"single","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"label":"Total Invoices","expression":"sum(SIN)"}],"lensDimensions":[{"fieldName":"GeneralLedgerAccountName","label":""}],"lensMeasures":[],"softDates":{"enabled":false},"subtotals":{"columns":[{"enabled":false,"fieldName":"GeneralLedgerAccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDual_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]},"drillTables":[{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"totDrill","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#F2F3F4"},"cell":{"underline":{"line":"single","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"label":"Total","expression":"sum(drill)"},{"alias":"drill","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false,"percentageDecimalPrecision":2},"reverseSign":false,"label":"","lensApiName":"xRB_DrillLens_dual1","repeatGroupingLabels":false}],"lensDimensions":[],"lensMeasures":[],"softDates":{"enabled":false},"drillConfig":{"bindings":[{"from":"GeneralLedgerAccountName","to":"GeneralLedgerAccountName"},{"from":"TrialBalance2","to":"TrialBalance2"},{"from":"TrialBalance3","to":"TrialBalance3"}]},"subtotals":{"columns":[{"enabled":false,"fieldName":"GeneralLedgerAccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"format":{"abovePosition":false,"isHiddenForSingleRows":false},"label":""},{"enabled":false,"fieldName":"TransactionName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDocumentNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"hidden":false,"region":"normal","locked":false,"text":"","field":"section","width":50,"name":"section","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"General Ledger Account Name","field":"GeneralLedgerAccountName_ac3fbc1d9745d5ba","width":250,"name":"GeneralLedgerAccountName_ac3fbc1d9745d5ba","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Transaction Date","field":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day_ac3fbc1d9745d5ba","width":128,"name":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day_ac3fbc1d9745d5ba","columnType":"date","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Transaction Name","field":"TransactionName_ac3fbc1d9745d5ba","width":135,"name":"TransactionName_ac3fbc1d9745d5ba","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Transaction Document Number","field":"TransactionDocumentNumber_ac3fbc1d9745d5ba","width":219,"name":"TransactionDocumentNumber_ac3fbc1d9745d5ba","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Transaction Date","field":"TransactionDate_ac3fbc1d9745d5ba","width":128,"name":"TransactionDate_ac3fbc1d9745d5ba","columnType":"date","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Dual Credit (USD)","field":"sum_ValueDualCredits_1_ac3fbc1d9745d5ba","width":133,"name":"sum_ValueDualCredits_1_ac3fbc1d9745d5ba","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Dual Debit (USD)","field":"sum_ValueDualDebits_1_ac3fbc1d9745d5ba","width":128,"name":"sum_ValueDualDebits_1_ac3fbc1d9745d5ba","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Net Dual (USD)","field":"sum_ValueDual_1_ac3fbc1d9745d5ba","width":116,"name":"sum_ValueDual_1_ac3fbc1d9745d5ba","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDualCredits_1","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDualDebits_1","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]}],"lensFormatting":{"decimalPrecision":0,"numberColourRed":false,"numberFormatBrackets":false,"numberScaling":"none","tableDensity":0,"columnDensity":75,"reverseSign":false,"columnsLocked":false,"rowBorderType":0,"ignoreWarnings":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","headerCurrencyOptions":"iso_code"},"lensCache":{"Xrb_dual_TB_2_revENue":{"id":"0FKDZ000000AhjO4AS","name":"Xrb_dual_TB_2_revENue","label":"xRB Dual TB 2 Revenue","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":true,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]]}}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"]],\"filters\":[[\"TrialBalance2\",[\"Revenue\"],\"in\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","label":"Financial Transactions","id":"0Fb4Q000000gLJ4SAM"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":[],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"},"xRB_Dual_TB_2_Revenue":{"id":"0FKfI0000005VRNWA2","name":"xRB_Dual_TB_2_Revenue","label":"xRB Dual TB 2 Revenue","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":true,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]]}}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"]],\"filters\":[[\"TrialBalance2\",[\"Sales Revenue\"],\"in\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","label":"Financial Transactions","id":"0FbfI000000HePzSAK"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["A"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"},"xRB_Dual_SIN_only":{"id":"0FKfI0000005Y2fWAE","name":"xRB_Dual_SIN_only","label":"xRB_Dual_SIN_only","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":true,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]]}}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"]],\"filters\":[[\"TransactionDocumentNumber\",[\"SIN\"],\"starts with\"],[\"LineType\",[\"Account\"],\"in\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","label":"Financial Transactions","id":"0FbfI000000HePzSAK"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["A"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"},"xRB_DrillLens_dual1":{"id":"0FKfI0000005VHhWAM","name":"xRB_DrillLens_dual1","label":"xRB_DrillLens_dual","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":true,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]},\"header\":\"Net Dual\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualCredits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]},\"header\":\"Dual Credit\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualDebits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]},\"header\":\"Dual Debit\"}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"],[\"sum\",\"ValueDualCredits\",\"B\"],[\"sum\",\"ValueDualDebits\",\"C\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","label":"Financial Transactions","id":"0FbfI000000HePzSAK"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["B","C","A","GeneralLedgerAccountName","TransactionName","TransactionDocumentNumber","TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"}},"version":19}

{"table":{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"TotAging","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#F2F3F4"},"cell":{"underline":{"line":"single","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"label":"","expression":"sum(Aging)"},{"alias":"Aging","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"reverseSign":false,"label":"","lensApiName":"xRB_Aging_as_of_Now_Outstanding_Dual","repeatGroupingLabels":false}],"lensDimensions":[{"fieldName":"AccountName","label":""}],"lensMeasures":[],"softDates":{"enabled":false},"subtotals":{"columns":[{"enabled":false,"fieldName":"AccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"hidden":false,"region":"normal","locked":false,"text":"Account Name","field":"AccountName_d8644b78550a665a","width":238,"name":"AccountName_d8644b78550a665a","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":true,"region":"normal","locked":false,"text":"Number of Documents","field":"count_*_1_d8644b78550a665a","width":163,"name":"count_*_1_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Current (USD)","field":"sum_ValueDualOutstanding_1_d8644b78550a665a","width":68,"name":"sum_ValueDualOutstanding_1_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"1-30 (USD)","field":"sum_ValueDualOutstanding_2_d8644b78550a665a","width":97,"name":"sum_ValueDualOutstanding_2_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"31-60 (USD)","field":"sum_ValueDualOutstanding_3_d8644b78550a665a","width":81,"name":"sum_ValueDualOutstanding_3_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"61-90 (USD)","field":"sum_ValueDualOutstanding_4_d8644b78550a665a","width":86,"name":"sum_ValueDualOutstanding_4_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"91-120 (USD)","field":"sum_ValueDualOutstanding_5_d8644b78550a665a","width":81,"name":"sum_ValueDualOutstanding_5_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":">120 (USD)","field":"sum_ValueDualOutstanding_6_d8644b78550a665a","width":93,"name":"sum_ValueDualOutstanding_6_d8644b78550a665a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Total (USD)","field":"Tot3_dde8fc56e5e658dc37dc","width":92,"name":"Tot3_dde8fc56e5e658dc37dc","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":684,"measureColumns":[{"fieldName":"sum_ValueDual_1","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_2","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_3","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_4","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_5","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_6","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]},"drillTables":[{"datasetApiName":"FinancialTransactions","label":"","pivot":false,"lensItems":[{"alias":"Total","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#EAEDED"},"cell":{"underline":{"line":"single","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"label":"","expression":"sum(detail)"},{"alias":"detail","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"reverseSign":false,"label":"","lensApiName":"xRB_DrillLens_dual1","repeatGroupingLabels":false}],"lensDimensions":[{"fieldName":"AccountName","label":""}],"lensMeasures":[],"softDates":{"enabled":false},"drillConfig":{"bindings":[{"from":"AccountName","to":"AccountName"},{"from":"ValueHomeOutstanding","to":"ValueHomeOutstanding"}]},"subtotals":{"columns":[{"enabled":false,"fieldName":"GeneralLedgerAccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDocumentNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"columnType":"group","name":"GeneralLedgerAccountName_40ad1728ff60e3da","width":214,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"AccountName_40ad1728ff60e3da","width":145,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"TransactionName_40ad1728ff60e3da","width":135,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"TransactionDocumentNumber_40ad1728ff60e3da","width":130,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"date","name":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day_40ad1728ff60e3da","width":128,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"measure","name":"sum_ValueHome_1_40ad1728ff60e3da","width":186,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDualCredits_1","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDualDebits_1","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDual_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]}],"lensFormatting":{"decimalPrecision":0,"numberColourRed":false,"numberFormatBrackets":false,"numberScaling":"none","tableDensity":0,"columnDensity":75,"reverseSign":false,"columnsLocked":false,"rowBorderType":0,"ignoreWarnings":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","headerCurrencyOptions":"iso_code"},"lensCache":{"xRB_Aging_as_of_Now_Outstanding_Dual":{"id":"0FKHr000000H9DpOAK","name":"xRB_Aging_as_of_Now_Outstanding_Dual","label":"xRB_Aging_as_of_Now_Outstanding_Dual","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHr000000LJwFKAW","label":"Financial Transactions","name":"FinancialTransactions","url":"/services/data/v58.0/wave/datasets/0FbHr000000LJwFKAW"}],"isGlobal":false,"query":{"query":"{\"columns\":[{\"query\":{\"measures\":[[\"count\",\"*\"]],\"groups\":[\"AccountName\"]},\"header\":\"Number of Documents\"},{\"query\":{\"measures\":[[\"sum\",\"ValueHomeOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[0,0]],\">=<=\"]]},\"header\":\"Current\"},{\"query\":{\"measures\":[[\"sum\",\"ValueHomeOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[1,30]],\">=<=\"]]},\"header\":\"1-30\"},{\"query\":{\"measures\":[[\"sum\",\"ValueHomeOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[31,60]],\">=<=\"]]},\"header\":\"31-60\"},{\"query\":{\"measures\":[[\"sum\",\"ValueHomeOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[61,90]],\">=<=\"]]},\"header\":\"61-90\"},{\"query\":{\"measures\":[[\"sum\",\"ValueHomeOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[91,120]],\">=<=\"]]},\"header\":\"91-120\"},{\"query\":{\"measures\":[[\"sum\",\"ValueHomeOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[120]],\">\"]]},\"header\":\"121+\"}],\"measures\":[[\"count\",\"*\",\"A\"],[\"sum\",\"ValueHomeOutstanding\",\"B\"],[\"sum\",\"ValueHomeOutstanding\",\"C\"],[\"sum\",\"ValueHomeOutstanding\",\"D\"],[\"sum\",\"ValueHomeOutstanding\",\"E\"],[\"sum\",\"ValueHomeOutstanding\",\"F\"],[\"sum\",\"ValueHomeOutstanding\",\"G\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueHomeOutstanding\",[[0]],\"!=\"]]}","version":-1},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":["B","C","D","E","F","G","A","AccountName"]},"type":"table"}}},"datasets":[{"id":"0FbfI000000HePzSAK","name":"FinancialTransactions","url":"/services/data/v58.0/wave/datasets/0FbHr000000LJwFKAW"}],"type":"lens"},"DrillLens_home":{"id":"0FKHu000000FewmOAC","name":"DrillLens_home","label":"DrillLens (home)","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHu000000G0PMKA0","label":"Financial Transactions","name":"FinancialTransactions","url":"/services/data/v59.0/wave/datasets/0FbHu000000G0PMKA0"}],"isGlobal":false,"query":{"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueHome\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000}}],\"measures\":[[\"sum\",\"ValueHome\",\"A\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]}","version":-1},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":[]},"type":"table"}}},"datasets":[{"id":"0FbfI000000HePzSAK","name":"FinancialTransactions","url":"/services/data/v59.0/wave/datasets/0FbHu000000G0PMKA0"}],"type":"lens"},"xRB_Aging_as_of_Now_Outstanding_Dual":{"id":"0FKDZ0000005p034AA","name":"xRB_Aging_as_of_Now_Outstanding_Dual","label":"xRB_Aging_as_of_Now_Outstanding_Dual","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":false,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[0,0]],\">=<=\"]]},\"header\":\"Current\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[1,30]],\">=<=\"]]},\"header\":\"1-30\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[31,60]],\">=<=\"]]},\"header\":\"31-60\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[61,90]],\">=<=\"]]},\"header\":\"61-90\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[91,120]],\">=<=\"]]},\"header\":\"91-120\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstanding\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[120]],\">\"]]},\"header\":\">120\"}],\"measures\":[[\"sum\",\"ValueDualOutstanding\",\"A\"],[\"sum\",\"ValueDualOutstanding\",\"B\"],[\"sum\",\"ValueDualOutstanding\",\"C\"],[\"sum\",\"ValueDualOutstanding\",\"D\"],[\"sum\",\"ValueDualOutstanding\",\"E\"],[\"sum\",\"ValueDualOutstanding\",\"F\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueHomeOutstanding\",[[0]],\"!=\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","label":"Financial Transactions","id":"0Fb4Q000000gLJ4SAM"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["A","B","C","D","E","F","AccountName"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"},"xRB_DrillLens_dual":{"id":"0FKDZ0000005p084AA","name":"xRB_DrillLens_dual","label":"DrillLens (Dual)","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":false,"type":"aggregateflex","selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000},\"header\":\"Net Dual\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualCredits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000},\"header\":\"Credit\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualDebits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000},\"header\":\"Debit\"}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"],[\"sum\",\"ValueDualCredits\",\"B\"],[\"sum\",\"ValueDualDebits\",\"C\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","label":"Financial Transactions","id":"0Fb4Q000000gLJ4SAM"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["C","B","A","GeneralLedgerAccountName","TransactionName","TransactionDocumentNumber","TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"},"xRB_Aging_as_of_Now_Outstanding_Dual":{"id":"0FKfI0000004gqHWAQ","name":"xRB_Aging_as_of_Now_Outstanding_Dual","label":"xRB_Aging_as_of_Now_Outstanding_Dual","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":false,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[0,0]],\">=<=\"]]},\"header\":\"Current\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[1,30]],\">=<=\"]]},\"header\":\"1-30\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[31,60]],\">=<=\"]]},\"header\":\"31-60\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[61,90]],\">=<=\"]]},\"header\":\"61-90\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[91,120]],\">=<=\"]]},\"header\":\"91-120\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueDaysOverdue\",[[120]],\">\"]]},\"header\":\"121 +\"}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"],[\"sum\",\"ValueDual\",\"B\"],[\"sum\",\"ValueDual\",\"C\"],[\"sum\",\"ValueDual\",\"D\"],[\"sum\",\"ValueDual\",\"E\"],[\"sum\",\"ValueDual\",\"F\"]],\"groups\":[\"AccountName\"],\"filters\":[[\"ValueHomeOutstanding\",[[0]],\"!=\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","label":"Financial Transactions","id":"0FbfI000000HePzSAK"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["A","B","C","D","E","F","AccountName"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"},"xRB_DrillLens_dual1":{"id":"0FKfI0000005VHhWAM","name":"xRB_DrillLens_dual1","label":"xRB_DrillLens_dual","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"visualizationParameters":{"visualizationType":"comparisontable","options":{}},"useGlobal":true,"useExternalFilters":true,"type":"aggregateflex","sortable":true,"selectMode":"multi","receiveFacetSource":{"steps":[],"mode":"none"},"query":{"version":-1,"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]},\"header\":\"Net Dual\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualCredits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]},\"header\":\"Dual Credit\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualDebits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]},\"header\":\"Dual Debit\"}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"],[\"sum\",\"ValueDualCredits\",\"B\"],[\"sum\",\"ValueDualDebits\",\"C\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]}"},"isGlobal":false,"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","label":"Financial Transactions","id":"0FbfI000000HePzSAK"}],"broadcastFacet":false}},"widgets":{"aggregateflex_table":{"type":"table","parameters":{"columns":["B","C","A","GeneralLedgerAccountName","TransactionName","TransactionDocumentNumber","TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day"],"pivoted":false}}}},"datasets":[{"url":"/services/data/v64.0/wave/datasets/0FbfI000000HePzSAK","name":"FinancialTransactions","id":"0FbfI000000HePzSAK"}],"type":"lens"}},"version":19}

{"table":{"datasetApiName":"FinancialMatching","label":"","pivot":false,"lensItems":[{"alias":"matchingline","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"reverseSign":false,"label":"","lensApiName":"FRB_Cash_Matching_1_0","repeatGroupingLabels":false}],"lensDimensions":[{"fieldName":"AccountName","label":""},{"fieldName":"TransactionDocumentNumber","label":"Document"},{"fieldName":"PeriodNumber","label":"Period"},{"fieldName":"TransactionDocumentDescription","label":"Descr"},{"fieldName":"TransactionDate","label":"Date"},{"fieldName":"TransactionName","label":"T Name"},{"fieldName":"FfaCompanyName","label":"Company"},{"fieldName":"Dimension1Name","label":""}],"lensMeasures":[],"softDates":{"enabled":false},"subtotals":{"columns":[{"enabled":true,"fieldName":"MatchingReferenceName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":"#EAEDED"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"format":{"abovePosition":false,"isHiddenForSingleRows":false},"label":"Subtotal {value}"},{"enabled":false,"fieldName":"MatchingLineName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"AccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDocumentNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"PeriodNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDocumentDescription","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDate","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"FfaCompanyName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"Dimension1Name","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"columnType":"group","name":"AccountName_cf10b51ef1e97689","width":132,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"MatchingReferenceName_cf10b51ef1e97689","width":188,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"MatchingLineName_cf10b51ef1e97689","width":114,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"TransactionDocumentNumber_cf10b51ef1e97689","width":104,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"PeriodNumber_cf10b51ef1e97689","width":60,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"date","name":"TransactionDate_cf10b51ef1e97689","width":84,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"measure","name":"sum_ValueDualMatching_1_cf10b51ef1e97689","width":127,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"measure","name":"sum_ValueDualMatching_2_cf10b51ef1e97689","width":133,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"TransactionDocumentDescription_cf10b51ef1e97689","width":250,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"TransactionName_cf10b51ef1e97689","width":142,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"FfaCompanyName_cf10b51ef1e97689","width":163,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"columnType":"group","name":"Dimension1Name_cf10b51ef1e97689","width":112,"hidden":false,"locked":false,"mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDualMatching_1","label":"Dual Debit","suppressRowCalculations":false},{"fieldName":"sum_ValueDualMatching_2","label":"Dual Credit","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]},"drillTables":[{"datasetApiName":"FinancialTransactions","label":"Transaction Detail","pivot":false,"lensItems":[{"alias":"detail","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"reverseSign":false,"label":"","lensApiName":"xRB_DrillLens_dual","repeatGroupingLabels":false}],"lensDimensions":[],"lensMeasures":[],"softDates":{"enabled":false},"drillConfig":{"bindings":[{"from":"TransactionName","to":"TransactionName"}]},"subtotals":{"columns":[{"enabled":false,"fieldName":"GeneralLedgerAccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionName","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDocumentNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"hidden":false,"region":"normal","locked":false,"width":214,"name":"GeneralLedgerAccountName_40ad1728ff60e3da","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"width":135,"name":"TransactionName_40ad1728ff60e3da","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"width":219,"name":"TransactionDocumentNumber_40ad1728ff60e3da","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"width":128,"name":"TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day_40ad1728ff60e3da","columnType":"date","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"width":95,"name":"sum_ValueDualDebits_1_40ad1728ff60e3da","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"width":100,"name":"sum_ValueDualCredits_1_40ad1728ff60e3da","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"width":177,"name":"sum_ValueDual_1_40ad1728ff60e3da","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":196,"measureColumns":[{"fieldName":"sum_ValueDual_1","label":"Sum of Dual Value","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]}],"lensFormatting":{"decimalPrecision":0,"numberColourRed":false,"numberFormatBrackets":false,"numberScaling":"none","tableDensity":0,"columnDensity":75,"reverseSign":false,"columnsLocked":false,"rowBorderType":1,"ignoreWarnings":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","headerCurrencyOptions":"iso_code"},"lensCache":{"FRB_Cash_Matching_1_0":{"id":"0FKHr000000HLW2OAO","name":"FRB_Cash_Matching_1_0","label":"FRB Cash Matching 1.0","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHr000000LJwGKAW","label":"Financial Matching","name":"FinancialMatching","url":"/services/data/v58.0/wave/datasets/0FbHr000000LJwGKAW"}],"isGlobal":false,"query":{"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDualMatching\"]],\"groups\":[\"MatchingReferenceName\",\"MatchingLineName\"],\"filters\":[[\"ValueDualMatching\",[[0]],\">=\"]]},\"header\":\"Dual Debit\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualMatching\"]],\"groups\":[\"MatchingReferenceName\",\"MatchingLineName\"],\"filters\":[[\"ValueDualMatching\",[[0]],\"<=\"]]},\"header\":\"Dual Credit\"}],\"measures\":[[\"sum\",\"ValueDualMatching\",\"A\"],[\"sum\",\"ValueDualMatching\",\"B\"]],\"groups\":[\"MatchingReferenceName\",\"MatchingLineName\"]}","version":-1},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":[]},"type":"table"}}},"datasets":[{"id":"0Fb4Q000000gLJ3SAM","name":"FinancialMatching","url":"/services/data/v58.0/wave/datasets/0FbHr000000LJwGKAW"}],"type":"lens"},"xRB_DrillLens_dual":{"id":"0FKHo0000009PBfOAM","name":"xRB_DrillLens_dual","label":"FRB DrillLens (dual)","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHo00000168QMKAY","label":"Financial Transactions","name":"FinancialTransactions","url":"/services/data/v60.0/wave/datasets/0FbHo00000168QMKAY"}],"isGlobal":false,"query":{"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDual\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000},\"header\":\"Net Dual\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualDebits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000},\"header\":\"Debit\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualCredits\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]],\"limit\":10000},\"header\":\"Credit\"}],\"measures\":[[\"sum\",\"ValueDual\",\"A\"],[\"sum\",\"ValueDualDebits\",\"B\"],[\"sum\",\"ValueDualCredits\",\"C\"]],\"groups\":[\"GeneralLedgerAccountName\",\"TransactionName\",\"TransactionDocumentNumber\",[\"TransactionDate_Year\",\"TransactionDate_Month\",\"TransactionDate_Day\"]]}","version":-1},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":["B","C","A","GeneralLedgerAccountName","TransactionName","TransactionDocumentNumber","TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day"]},"type":"table"}}},"datasets":[{"id":"0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","url":"/services/data/v60.0/wave/datasets/0FbHo00000168QMKAY"}],"type":"lens"}},"version":19}

{"table":{"datasetApiName":"FinancialMatching","label":"Document Days to Pay","pivot":false,"lensItems":[{"alias":"Invoices","visible":true,"rowFormatting":{"text":{"font":"arial","size":10,"bold":false,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"reverseSign":false,"label":"","lensApiName":"xRB_Matched_Days_to_Pay_FM","repeatGroupingLabels":true}],"lensDimensions":[{"fieldName":"AccountName","label":"Account"},{"fieldName":"TransactionDocumentNumber","label":"Document"},{"fieldName":"MatchingStatus","label":""},{"fieldName":"TransactionDate","label":"Tran Date"},{"fieldName":"MatchingMatchDate","label":"Payment Date"},{"fieldName":"TransactionLineItemDueDate","label":"due date"}],"lensMeasures":[{"visible":true,"calculationPrecedence":"row","alias":"Count","label":"Count","expression":"1","columnFormatting":{"numberScaling":"none","decimalPrecision":0,"negativeNumberColor":"#17202A","numberFormatBrackets":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","currencySymbol":"none","text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"halign":"right","percentageSymbol":false}},{"visible":true,"calculationPrecedence":"column","alias":"SubtotalAverage","label":"Sub total Average","expression":"coalesce(measure(\"avg_DaysToPay_1\"), 0)/Count","columnFormatting":{"numberScaling":"none","decimalPrecision":0,"negativeNumberColor":"#17202A","numberFormatBrackets":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","currencySymbol":"none","text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"halign":"right","percentageSymbol":false}}],"softDates":{"enabled":false},"subtotals":{"columns":[{"enabled":true,"fieldName":"AccountName","rowFormatting":{"text":{"font":null,"size":null,"bold":true,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"single","color":"#17202A"},"overline":{"line":"single","color":"#17202A"}},"spacing":"medium","percentageSymbol":false},"label":"Average {value}","format":{"abovePosition":true,"isHiddenForSingleRows":false}},{"enabled":false,"fieldName":"TransactionDocumentNumber","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"MatchingStatus","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionDate","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"MatchingMatchDate","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}},{"enabled":false,"fieldName":"TransactionLineItemDueDate","rowFormatting":{"text":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"cell":{"underline":{"line":"none","color":"#17202A"},"overline":{"line":"none","color":"#17202A"}},"spacing":"medium","percentageSymbol":false}}]},"columnsDisplayConfig":[{"hidden":false,"region":"normal","locked":false,"text":"Account","field":"AccountName_1c01c64592d0d63a","width":188,"name":"AccountName_1c01c64592d0d63a","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Document","field":"TransactionDocumentNumber_1c01c64592d0d63a","width":87,"name":"TransactionDocumentNumber_1c01c64592d0d63a","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Matching Status","field":"MatchingStatus_1c01c64592d0d63a","width":124,"name":"MatchingStatus_1c01c64592d0d63a","columnType":"group","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Tran Date","field":"TransactionDate_1c01c64592d0d63a","width":84,"name":"TransactionDate_1c01c64592d0d63a","columnType":"date","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Payment Date","field":"MatchingMatchDate_1c01c64592d0d63a","width":108,"name":"MatchingMatchDate_1c01c64592d0d63a","columnType":"date","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"due date","field":"TransactionLineItemDueDate_1c01c64592d0d63a","width":83,"name":"TransactionLineItemDueDate_1c01c64592d0d63a","columnType":"date","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Dual (USD)","field":"sum_ValueDualMatching_1_1c01c64592d0d63a","width":90,"name":"sum_ValueDualMatching_1_1c01c64592d0d63a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Outstanding (USD)","field":"sum_ValueDualOutstandingMatching_1_1c01c64592d0d63a","width":141,"name":"sum_ValueDualOutstandingMatching_1_1c01c64592d0d63a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Avg of Days to Pay","field":"avg_DaysToPay_1_1c01c64592d0d63a","width":137,"name":"avg_DaysToPay_1_1c01c64592d0d63a","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Sub total Average","field":"SubtotalAverage_dde8fc56e5e658dc37dc","width":132,"name":"SubtotalAverage_dde8fc56e5e658dc37dc","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}},{"hidden":false,"region":"normal","locked":false,"text":"Count","field":"Count_dde8fc56e5e658dc37dc","width":57,"name":"Count_dde8fc56e5e658dc37dc","columnType":"measure","mergeInfo":{"isMergedColumn":false,"hasBeenMerged":false}}],"titleFormatting":{"text":{"font":"arial","size":16,"bold":true,"italic":false,"color":"#17202A","backgroundColor":"#FDFEFE"},"underline":{"line":"none","color":"#17202A"}},"tableHeight":null,"measureColumns":[{"fieldName":"sum_ValueDualMatching_1","label":"","suppressRowCalculations":false},{"fieldName":"sum_ValueDualOutstandingMatching_1","label":"Outstanding","suppressRowCalculations":false},{"fieldName":"avg_DaysToPay_1","label":"","suppressRowCalculations":false}],"realTime":{"realTimeQuery":null,"display":"below","formatting":{"font":null,"size":null,"bold":false,"italic":false,"color":null,"backgroundColor":null},"showRefreshedDate":true},"mergedColumns":[]},"drillTables":[],"lensFormatting":{"decimalPrecision":0,"numberColourRed":false,"numberFormatBrackets":false,"numberScaling":"none","tableDensity":0,"columnDensity":75,"reverseSign":false,"columnsLocked":false,"rowBorderType":0,"ignoreWarnings":false,"emptyValuesFormat":"zero","divideByZeroFormat":"error_message","headerCurrencyOptions":"iso_code"},"lensCache":{"xRB_Matched_Days_to_Pay_FM":{"id":"0FKHo0000009Pd2OAE","name":"xRB_Matched_Days_to_Pay_FM","label":"FRB Matched Days to Pay","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHo00000168QPKAY","label":"Financial Matching","name":"FinancialMatching","url":"/services/data/v61.0/wave/datasets/0FbHo00000168QPKAY"}],"isGlobal":false,"query":{"query":"{\"columns\":[{\"query\":{\"measures\":[[\"sum\",\"ValueDualMatching\"]]},\"header\":\"Dual\"},{\"query\":{\"measures\":[[\"sum\",\"ValueDualOutstandingMatching\"]]},\"header\":\"Outstanding Value\"},{\"query\":{\"measures\":[[\"avg\",\"DaysToPay\"]]}}],\"measures\":[[\"sum\",\"ValueDualMatching\",\"A\"],[\"sum\",\"ValueDualOutstandingMatching\",\"B\"],[\"avg\",\"DaysToPay\",\"C\"]],\"filters\":[[\"MatchingStatus\",[\"Matched\"],\"in\"],[\"TransactionType\",[\"Invoice\"],\"in\"]]}","version":-1},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":[]},"type":"table"}}},"datasets":[{"id":"0Fb4Q000000gLJ3SAM","name":"FinancialMatching","url":"/services/data/v61.0/wave/datasets/0FbHo00000168QPKAY"}],"type":"lens"}},"version":19}

{"filterType":"dimension","lensCache":{},"label":"Account Name","lensApiName":"xRB_Account_Name_FT","lensFieldName":"AccountName","version":2,"constraint":{"operator":"in","value":["Acme"]}}

{"filterType":"dimension","lensCache":{},"label":"Company Name","lensApiName":"xRB_Company_Name_FT","lensFieldName":"CompanyName","version":2,"constraint":{"operator":"in","value":[]}}

xRBFilterMatchingReference

{"filterType":"dimension","lensCache":{"xRB_Matching_Ref_Name_Matching_FM":{"id":"0FKHr0000008t1ZOAQ","name":"xRB_Matching_Ref_Name_Matching_FM","label":"FRB Matching Ref Name (Matching) CF1","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHr000000LJwGKAW","label":"Financial Matching","name":"FinancialMatching","url":"/services/data/v58.0/wave/datasets/0FbHr000000LJwGKAW"}],"isGlobal":false,"query":{"query":"{\"columns\":[{\"query\":{\"measures\":[[\"count\",\"*\"]],\"groups\":[\"MatchingReferenceName\"]}}],\"measures\":[[\"count\",\"*\",\"A\"]],\"groups\":[\"MatchingReferenceName\"]}","version":-1},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":[]},"type":"table"}}},"datasets":[{"id":"0Fb4Q000000gLJ3SAM","name":"FinancialMatching","url":"/services/data/v58.0/wave/datasets/0FbHr000000LJwGKAW"}],"type":"lens"}},"label":"Matching Reference","lensApiName":"xRB_Matching_Ref_Name_Matching_FM","lensFieldName":"MatchingReferenceName","version":2,"constraint":{"operator":"in","value":[]}}

{"filterType":"date","lensCache":{"xRB_TRANSACTION_DATE":{"id":"0FKHo000000Ej09OAC","name":"xRB_TRANSACTION_DATE","label":"FRB TRANSACTION DATE","visualizationType":"comparisontable","state":{"steps":{"aggregateflex":{"broadcastFacet":false,"datasets":[{"id":"0FbHo00000168QMKAY","label":"Financial Transactions","name":"FinancialTransactions","url":"/services/data/v61.0/wave/datasets/0FbHo00000168QMKAY"}],"isGlobal":false,"query":{"aggregateFilters":[],"columnGroups":[],"columnTotals":[],"limit":2000,"orders":[{"name":"TransactionDate_Year","filters":[],"ascending":true},{"name":"TransactionDate_Month","filters":[],"ascending":true},{"name":"TransactionDate_Day","filters":[],"ascending":true}],"rowTotals":[],"sourceFilters":{},"sources":[{"columns":[{"field":["count","*"],"name":"B"}],"filters":[],"groups":["TransactionDate_Year","TransactionDate_Month","TransactionDate_Day"],"joins":[],"name":"FinancialTransactions"}]},"receiveFacetSource":{"mode":"none","steps":[]},"selectMode":"multi","type":"aggregateflex","useGlobal":true,"visualizationParameters":{"options":{},"visualizationType":"comparisontable"}}},"widgets":{"aggregateflex_table":{"parameters":{"columns":["B","TransactionDate_Year~~~TransactionDate_Month~~~TransactionDate_Day"]},"type":"table"}}},"datasets":[{"id":"0Fb4Q000000gLJ4SAM","name":"FinancialTransactions","url":"/services/data/v61.0/wave/datasets/0FbHo00000168QMKAY"}],"type":"lens"}},"label":"Transaction Date","lensApiName":"xRB_TRANSACTION_DATE","lensFieldName":"TransactionDate","version":2,"constraint":{"operator":">=","value":1577836800000}}