Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
13970 lines (13969 sloc) 994 KB
</
<?xml version='1.0' encoding='utf-8' ?>
<!-- build 20192.19.0917.1648 -->
<workbook source-build='2019.2.4 (20192.19.0917.1648)' source-platform='mac' version='18.1' xmlns:user='http://www.tableausoftware.com/xml/user'>
<document-format-change-manifest>
<AutoCreateAndUpdateDSDPhoneLayouts ignorable='true' predowngraded='true' />
<IntuitiveSorting />
<IntuitiveSorting_SP2 />
<MapboxVectorStylesAndLayers />
<SheetIdentifierTracking ignorable='true' predowngraded='true' />
<SortTagCleanup />
<WindowsPersistSimpleIdentifiers />
<ZoneBackgroundTransparency />
<ZoneFriendlyName ignorable='true' predowngraded='true' />
</document-format-change-manifest>
<preferences>
<preference name='ui.encoding.shelf.height' value='24' />
<preference name='ui.shelf.height' value='26' />
</preferences>
<datasources>
<datasource caption='Transaction Details' inline='true' name='federated.1536j2w1odgej11h17r3l1ukn6qo' version='18.1'>
<connection class='federated'>
<named-connections>
<named-connection caption='my_url.snowflakecomputing.com' name='snowflake.1f23d7u0suaie21433v7m1bb442p'>
<connection authentication='Username Password' class='snowflake' dbname='my_db_name' odbc-connect-string-extras='' one-time-sql='' schema='NETSUITE' server='my_url.snowflakecomputing.com' service='my_service' username='my_username' warehouse='my_warehouse' />
</named-connection>
</named-connections>
<relation connection='snowflake.1f23d7u0suaie21433v7m1bb442p' name='transaction_details' type='text'>with period_exchange_rate_map as ( -- exchange rates used, by accounting period, to convert to parent subsidiary&#10; select&#10; consolidated_exchange_rates.accounting_period_id,&#10; consolidated_exchange_rates.average_rate,&#10; consolidated_exchange_rates.current_rate,&#10; consolidated_exchange_rates.historical_rate,&#10; consolidated_exchange_rates.from_subsidiary_id,&#10; consolidated_exchange_rates.to_subsidiary_id&#10; from netsuite.consolidated_exchange_rates&#10; where consolidated_exchange_rates.to_subsidiary_id in (&#10; select&#10; subsidiary_id&#10; from netsuite.subsidiaries&#10; where parent_id is null -- constrait - only the primary subsidiary has no parent&#10; )&#10; and consolidated_exchange_rates.accounting_book_id in (&#10; select&#10; accounting_book_id&#10; from netsuite.accounting_books&#10; where lower(is_primary) = &apos;yes&apos;&#10; )&#10; and not consolidated_exchange_rates._fivetran_deleted&#10;), accountxperiod_exchange_rate_map as ( -- account table with exchange rate details by accounting period&#10; select&#10; period_exchange_rate_map.accounting_period_id,&#10; period_exchange_rate_map.from_subsidiary_id,&#10; period_exchange_rate_map.to_subsidiary_id,&#10; accounts.account_id,&#10; case &#10; when lower(accounts.general_rate_type) = &apos;historical&apos; then period_exchange_rate_map.historical_rate&#10; when lower(accounts.general_rate_type) = &apos;current&apos; then period_exchange_rate_map.current_rate&#10; when lower(accounts.general_rate_type) = &apos;average&apos; then period_exchange_rate_map.average_rate&#10; else null&#10; end as exchange_rate,&#10; period_exchange_rate_map.current_rate as CTA_control_current_exchange_rate&#10; from netsuite.accounts&#10; cross join period_exchange_rate_map&#10;), transaction_lines_w_accounting_period as ( -- transaction line totals, by accounts, accounting period and subsidiary&#10; select&#10; transaction_lines.transaction_id,&#10; transaction_lines.transaction_line_id,&#10; transaction_lines.subsidiary_id,&#10; transaction_lines.account_id,&#10; transactions.accounting_period_id as transaction_accounting_period_id,&#10; coalesce(transaction_lines.amount, 0) as unconverted_amount&#10; from netsuite.transaction_lines&#10; join netsuite.transactions on transactions.transaction_id = transaction_lines.transaction_id&#10; where not transactions._fivetran_deleted&#10; and lower(transactions.transaction_type) != &apos;revenue arrangement&apos;&#10; and lower(non_posting_line) != &apos;yes&apos;&#10;), period_id_list_to_current_period as ( -- period ids with all future period ids. this is needed to calculate cumulative totals by correct exchange rates.&#10; select&#10; base.accounting_period_id,&#10; array_agg(multiplier.accounting_period_id) within group (order by multiplier.accounting_period_id) as accounting_periods_to_include_for&#10; from netsuite.accounting_periods as base&#10; join netsuite.accounting_periods as multiplier&#10; on multiplier.starting &gt;&gt;= base.starting&#10; and multiplier.quarter = base.quarter&#10; and multiplier.year_0 = base.year_0&#10; and multiplier.fiscal_calendar_id = base.fiscal_calendar_id&#10; and multiplier.starting &lt;&lt;= current_timestamp()&#10; where lower(base.quarter) = &apos;no&apos;&#10; and lower(base.year_0) = &apos;no&apos;&#10; and base.fiscal_calendar_id = (select &#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null) -- fiscal calendar will align with parent subsidiary&apos;s default calendar&#10; group by 1&#10;), flattened_period_id_list_to_current_period as (&#10; select&#10; accounting_period_id,&#10; reporting_accounting_period_id.value as reporting_accounting_period_id&#10; from period_id_list_to_current_period,&#10; lateral flatten (input =&gt;&gt; accounting_periods_to_include_for) reporting_accounting_period_id&#10;), transactions_in_every_calculation_period_w_exchange_rates as (&#10; select&#10; transaction_lines_w_accounting_period.*,&#10; reporting_accounting_period_id,&#10; exchange_reporting_period.exchange_rate as exchange_rate_reporting_period,&#10; exchange_transaction_period.exchange_rate as exchange_rate_transaction_period,&#10; exchange_transaction_period.CTA_control_current_exchange_rate as CTA_control_current_exchange_rate&#10; from transaction_lines_w_accounting_period&#10; inner join flattened_period_id_list_to_current_period on flattened_period_id_list_to_current_period.accounting_period_id = transaction_lines_w_accounting_period.transaction_accounting_period_id &#10; left join accountxperiod_exchange_rate_map as exchange_reporting_period&#10; on exchange_reporting_period.accounting_period_id = flattened_period_id_list_to_current_period.reporting_accounting_period_id&#10; and exchange_reporting_period.account_id = transaction_lines_w_accounting_period.account_id&#10; and exchange_reporting_period.from_subsidiary_id = transaction_lines_w_accounting_period.subsidiary_id&#10; left join accountxperiod_exchange_rate_map as exchange_transaction_period&#10; on exchange_transaction_period.accounting_period_id = flattened_period_id_list_to_current_period.accounting_period_id&#10; and exchange_transaction_period.account_id = transaction_lines_w_accounting_period.account_id&#10; and exchange_transaction_period.from_subsidiary_id = transaction_lines_w_accounting_period.subsidiary_id&#10;), transactions_with_converted_amounts as (&#10; select&#10; transactions_in_every_calculation_period_w_exchange_rates.*,&#10; unconverted_amount * exchange_rate_transaction_period as converted_amount_using_transaction_accounting_period,&#10; unconverted_amount * exchange_rate_reporting_period as converted_amount_using_reporting_month,&#10; unconverted_amount * CTA_control_current_exchange_rate as converted_amount_using_cta_control,&#10; case&#10; when lower(accounts.type_name) in (&apos;income&apos;,&apos;other income&apos;,&apos;expense&apos;,&apos;other expense&apos;,&apos;other income&apos;,&apos;cost of goods sold&apos;) then true&#10; else false &#10; end as is_income_statement,&#10; case&#10; when lower(accounts.type_name) in (&apos;accounts receivable&apos;, &apos;bank&apos;, &apos;deferred expense&apos;, &apos;fixed asset&apos;, &apos;other asset&apos;, &apos;other current asset&apos;, &apos;unbilled receivable&apos;) then &apos;Asset&apos;&#10; when lower(accounts.type_name) in (&apos;cost of goods sold&apos;, &apos;expense&apos;, &apos;other expense&apos;) then &apos;Expense&apos;&#10; when lower(accounts.type_name) in (&apos;income&apos;, &apos;other income&apos;) then &apos;Income&apos;&#10; when lower(accounts.type_name) in (&apos;accounts payable&apos;, &apos;credit card&apos;, &apos;deferred revenue&apos;, &apos;long term liability&apos;, &apos;other current liability&apos;) then &apos;Liability&apos;&#10; when lower(accounts.type_name) in (&apos;equity&apos;, &apos;retained earnings&apos;, &apos;net income&apos;) then &apos;Equity&apos;&#10; else null &#10; end as account_category&#10; from transactions_in_every_calculation_period_w_exchange_rates&#10; left join netsuite.accounts on accounts.account_id = transactions_in_every_calculation_period_w_exchange_rates.account_id&#10;)&#10;select&#10; transaction_lines.transaction_line_id,&#10; transaction_lines.memo as transaction_memo,&#10; lower(transaction_lines.non_posting_line) = &apos;yes&apos; as is_transaction_non_posting,&#10; transactions.transaction_id,&#10; transactions.status as transaction_status,&#10; transactions.trandate as transaction_date,&#10; transactions.due_date as transaction_due_date,&#10; transactions.transaction_type as transaction_type,&#10; (lower(transactions.is_advanced_intercompany) = &apos;yes&apos; or lower(transactions.is_intercompany) = &apos;yes&apos;) as is_transaction_intercompany,&#10; accounting_periods.ending as accounting_period_ending,&#10; accounting_periods.full_name as accounting_period_full_name,&#10; accounting_periods.name as accounting_period_name,&#10; lower(accounting_periods.is_adjustment) = &apos;yes&apos; as is_accounting_period_adjustment,&#10; lower(accounting_periods.closed) = &apos;yes&apos; as is_accounting_period_closed,&#10; accounts.name as account_name,&#10; accounts.type_name as account_type_name,&#10; accounts.account_id as account_id,&#10; accounts.accountnumber as account_number,&#10; lower(accounts.is_leftside) = &apos;t&apos; as is_account_leftside,&#10; lower(accounts.type_name) like &apos;accounts payable%&apos; as is_accounts_payable,&#10; lower(accounts.type_name) like &apos;accounts receivable%&apos; as is_accounts_receivable,&#10; lower(accounts.name) like &apos;%intercompany%&apos; as is_account_intercompany,&#10; coalesce(parent_account.name, accounts.name) as parent_account_name,&#10; income_accounts.income_account_id is not null as is_income_account,&#10; expense_accounts.expense_account_id is not null as is_expense_account,&#10; customers.companyname as customer_company_name,&#10; customers.city as customer_city,&#10; customers.state as customer_state,&#10; customers.zipcode as customer_zipcode,&#10; customers.country as customer_country,&#10; customers.date_first_order as customer_date_first_order,&#10; items.name as item_name,&#10; items.type_name as item_type_name,&#10; items.salesdescription as item_sales_description,&#10; locations.name as location_name,&#10; locations.city as location_city,&#10; locations.country as location_country,&#10; vendor_types.name as vendor_type_name,&#10; vendors.companyname as vendor_name,&#10; vendors.create_date as vendor_create_date,&#10; currencies.name as currency_name,&#10; currencies.symbol as currency_symbol,&#10; departments.name as department_name,&#10; subsidiaries.name as subsidiary_name,&#10; case&#10; when lower(accounts.type_name) = &apos;income&apos; or lower(accounts.type_name) = &apos;other income&apos; then -converted_amount_using_transaction_accounting_period&#10; else converted_amount_using_transaction_accounting_period&#10; end as converted_amount,&#10; case&#10; when lower(accounts.type_name) = &apos;income&apos; or lower(accounts.type_name) = &apos;other income&apos; then -transaction_lines.amount&#10; else transaction_lines.amount&#10; end as transaction_amount,&#10; case&#10; when datediff(day, to_date(due_date), current_date) &lt;&lt; 0 then &apos;&lt;&lt; 0.0&apos;&#10; when datediff(day, to_date(due_date), current_date) &gt;&gt;= 0 and datediff(day, to_date(due_date), current_date) &lt;&lt; 30 then &apos;&gt;&gt;= 0.0 and &lt;&lt; 30.0&apos;&#10; when datediff(day, to_date(due_date), current_date) &gt;&gt;= 30 and datediff(day, to_date(due_date), current_date) &lt;&lt; 60 then &apos;&gt;&gt;= 30.0 and &lt;&lt; 60.0&apos;&#10; when datediff(day, to_date(due_date), current_date) &gt;&gt;= 60 and datediff(day, to_date(due_date), current_date) &lt;&lt; 90 then &apos;&gt;&gt;= 60.0 and &lt;&lt; 90.0&apos;&#10; when datediff(day, to_date(due_date), current_date) &gt;&gt;= 90 then &apos;&gt;&gt;= 90.0&apos;&#10; else &apos;Undefined&apos;&#10; end as days_past_due_date_tier&#10;from netsuite.transaction_lines&#10;join netsuite.transactions on transactions.transaction_id = transaction_lines.transaction_id&#10; and not transactions._fivetran_deleted&#10;left join transactions_with_converted_amounts as transactions_with_converted_amounts&#10; on transactions_with_converted_amounts.transaction_line_id = transaction_lines.transaction_line_id&#10; and transactions_with_converted_amounts.transaction_id = transaction_lines.transaction_id&#10; and transactions_with_converted_amounts.transaction_accounting_period_id = transactions_with_converted_amounts.reporting_accounting_period_id&#10;left join netsuite.accounts on accounts.account_id = transaction_lines.account_id&#10;left join netsuite.accounts as parent_account on parent_account.account_id = accounts.parent_id&#10;left join netsuite.accounting_periods on accounting_periods.accounting_period_id = transactions.accounting_period_id&#10;left join netsuite.income_accounts on income_accounts.income_account_id = accounts.account_id&#10;left join netsuite.expense_accounts on expense_accounts.expense_account_id = accounts.account_id&#10;left join netsuite.customers on customers.customer_id = transaction_lines.company_id&#10; and not customers._fivetran_deleted&#10;left join netsuite.items on items.item_id = transaction_lines.item_id&#10; and not items._fivetran_deleted&#10;left join netsuite.locations on locations.location_id = transaction_lines.location_id&#10;left join netsuite.vendors on vendors.vendor_id = transaction_lines.company_id&#10; and not vendors._fivetran_deleted&#10;left join netsuite.vendor_types on vendor_types.vendor_type_id = vendors.vendor_type_id&#10; and not vendor_types._fivetran_deleted&#10;left join netsuite.currencies on currencies.currency_id = transactions.currency_id&#10; and not currencies._fivetran_deleted&#10;left join netsuite.departments on departments.department_id = transaction_lines.department_id&#10;left join netsuite.subsidiaries on subsidiaries.subsidiary_id = transaction_lines.subsidiary_id&#10;where (accounting_periods.fiscal_calendar_id is null&#10; or accounting_periods.fiscal_calendar_id = (select&#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null))</relation>
<metadata-records>
<metadata-record class='column'>
<remote-name>TRANSACTION_LINE_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[TRANSACTION_LINE_ID]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_LINE_ID</remote-alias>
<ordinal>1</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_MEMO</remote-name>
<remote-type>129</remote-type>
<local-name>[TRANSACTION_MEMO]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_MEMO</remote-alias>
<ordinal>2</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16000</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_TRANSACTION_NON_POSTING</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_TRANSACTION_NON_POSTING]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_TRANSACTION_NON_POSTING</remote-alias>
<ordinal>3</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[TRANSACTION_ID]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_ID</remote-alias>
<ordinal>4</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_STATUS</remote-name>
<remote-type>129</remote-type>
<local-name>[TRANSACTION_STATUS]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_STATUS</remote-alias>
<ordinal>5</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>1920</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_DATE</remote-name>
<remote-type>7</remote-type>
<local-name>[TRANSACTION_DATE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_DATE</remote-alias>
<ordinal>6</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_DUE_DATE</remote-name>
<remote-type>7</remote-type>
<local-name>[TRANSACTION_DUE_DATE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_DUE_DATE</remote-alias>
<ordinal>7</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_TYPE</remote-name>
<remote-type>129</remote-type>
<local-name>[TRANSACTION_TYPE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_TYPE</remote-alias>
<ordinal>8</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>768</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_TRANSACTION_INTERCOMPANY</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_TRANSACTION_INTERCOMPANY]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_TRANSACTION_INTERCOMPANY</remote-alias>
<ordinal>9</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_ENDING</remote-name>
<remote-type>7</remote-type>
<local-name>[ACCOUNTING_PERIOD_ENDING]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_ENDING</remote-alias>
<ordinal>10</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_FULL_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNTING_PERIOD_FULL_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_FULL_NAME</remote-alias>
<ordinal>11</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>2388</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNTING_PERIOD_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_NAME</remote-alias>
<ordinal>12</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>256</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTING_PERIOD_ADJUSTMENT</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTING_PERIOD_ADJUSTMENT]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_ACCOUNTING_PERIOD_ADJUSTMENT</remote-alias>
<ordinal>13</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTING_PERIOD_CLOSED</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTING_PERIOD_CLOSED]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_ACCOUNTING_PERIOD_CLOSED</remote-alias>
<ordinal>14</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNT_NAME</remote-alias>
<ordinal>15</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>372</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_TYPE_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_TYPE_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNT_TYPE_NAME</remote-alias>
<ordinal>16</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>512</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[ACCOUNT_ID]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNT_ID</remote-alias>
<ordinal>17</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NUMBER</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NUMBER]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ACCOUNT_NUMBER</remote-alias>
<ordinal>18</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>240</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNT_LEFTSIDE</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNT_LEFTSIDE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_ACCOUNT_LEFTSIDE</remote-alias>
<ordinal>19</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTS_PAYABLE</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTS_PAYABLE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_ACCOUNTS_PAYABLE</remote-alias>
<ordinal>20</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTS_RECEIVABLE</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTS_RECEIVABLE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_ACCOUNTS_RECEIVABLE</remote-alias>
<ordinal>21</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNT_INTERCOMPANY</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNT_INTERCOMPANY]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_ACCOUNT_INTERCOMPANY</remote-alias>
<ordinal>22</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>PARENT_ACCOUNT_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[PARENT_ACCOUNT_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>PARENT_ACCOUNT_NAME</remote-alias>
<ordinal>23</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>372</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_INCOME_ACCOUNT</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_INCOME_ACCOUNT]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_INCOME_ACCOUNT</remote-alias>
<ordinal>24</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_EXPENSE_ACCOUNT</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_EXPENSE_ACCOUNT]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>IS_EXPENSE_ACCOUNT</remote-alias>
<ordinal>25</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CUSTOMER_COMPANY_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[CUSTOMER_COMPANY_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CUSTOMER_COMPANY_NAME</remote-alias>
<ordinal>26</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>332</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CUSTOMER_CITY</remote-name>
<remote-type>129</remote-type>
<local-name>[CUSTOMER_CITY]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CUSTOMER_CITY</remote-alias>
<ordinal>27</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>200</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CUSTOMER_STATE</remote-name>
<remote-type>129</remote-type>
<local-name>[CUSTOMER_STATE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CUSTOMER_STATE</remote-alias>
<ordinal>28</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>200</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CUSTOMER_ZIPCODE</remote-name>
<remote-type>129</remote-type>
<local-name>[CUSTOMER_ZIPCODE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CUSTOMER_ZIPCODE</remote-alias>
<ordinal>29</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>144</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CUSTOMER_COUNTRY</remote-name>
<remote-type>129</remote-type>
<local-name>[CUSTOMER_COUNTRY]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CUSTOMER_COUNTRY</remote-alias>
<ordinal>30</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>200</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CUSTOMER_DATE_FIRST_ORDER</remote-name>
<remote-type>7</remote-type>
<local-name>[CUSTOMER_DATE_FIRST_ORDER]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CUSTOMER_DATE_FIRST_ORDER</remote-alias>
<ordinal>31</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ITEM_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ITEM_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ITEM_NAME</remote-alias>
<ordinal>32</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>1000</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ITEM_TYPE_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ITEM_TYPE_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ITEM_TYPE_NAME</remote-alias>
<ordinal>33</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>512</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ITEM_SALES_DESCRIPTION</remote-name>
<remote-type>129</remote-type>
<local-name>[ITEM_SALES_DESCRIPTION]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>ITEM_SALES_DESCRIPTION</remote-alias>
<ordinal>34</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16000</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>LOCATION_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[LOCATION_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>LOCATION_NAME</remote-alias>
<ordinal>35</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>124</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>LOCATION_CITY</remote-name>
<remote-type>129</remote-type>
<local-name>[LOCATION_CITY]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>LOCATION_CITY</remote-alias>
<ordinal>36</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>200</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>LOCATION_COUNTRY</remote-name>
<remote-type>129</remote-type>
<local-name>[LOCATION_COUNTRY]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>LOCATION_COUNTRY</remote-alias>
<ordinal>37</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>200</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>VENDOR_TYPE_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[VENDOR_TYPE_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>VENDOR_TYPE_NAME</remote-alias>
<ordinal>38</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>124</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>VENDOR_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[VENDOR_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>VENDOR_NAME</remote-alias>
<ordinal>39</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>332</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>VENDOR_CREATE_DATE</remote-name>
<remote-type>7</remote-type>
<local-name>[VENDOR_CREATE_DATE]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>VENDOR_CREATE_DATE</remote-alias>
<ordinal>40</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CURRENCY_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[CURRENCY_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CURRENCY_NAME</remote-alias>
<ordinal>41</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>420</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CURRENCY_SYMBOL</remote-name>
<remote-type>129</remote-type>
<local-name>[CURRENCY_SYMBOL]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CURRENCY_SYMBOL</remote-alias>
<ordinal>42</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>DEPARTMENT_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[DEPARTMENT_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>DEPARTMENT_NAME</remote-alias>
<ordinal>43</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>124</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>SUBSIDIARY_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[SUBSIDIARY_NAME]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>SUBSIDIARY_NAME</remote-alias>
<ordinal>44</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>332</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CONVERTED_AMOUNT</remote-name>
<remote-type>5</remote-type>
<local-name>[CONVERTED_AMOUNT]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>CONVERTED_AMOUNT</remote-alias>
<ordinal>45</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>TRANSACTION_AMOUNT</remote-name>
<remote-type>5</remote-type>
<local-name>[TRANSACTION_AMOUNT]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>TRANSACTION_AMOUNT</remote-alias>
<ordinal>46</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>DAYS_PAST_DUE_DATE_TIER</remote-name>
<remote-type>129</remote-type>
<local-name>[DAYS_PAST_DUE_DATE_TIER]</local-name>
<parent-name>[transaction_details]</parent-name>
<remote-alias>DAYS_PAST_DUE_DATE_TIER</remote-alias>
<ordinal>47</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>18</width>
<contains-null>false</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
</metadata-records>
</connection>
<column aggregation='Sum' datatype='real' name='[ACCOUNT_ID]' role='dimension' type='ordinal' />
<column datatype='string' name='[CUSTOMER_CITY]' role='dimension' semantic-role='[City].[Name]' type='nominal' />
<column datatype='string' name='[CUSTOMER_COUNTRY]' role='dimension' semantic-role='[Country].[ISO3166_2]' type='nominal' />
<column datatype='string' name='[CUSTOMER_STATE]' role='dimension' semantic-role='[State].[Name]' type='nominal' />
<column datatype='string' name='[CUSTOMER_ZIPCODE]' role='dimension' semantic-role='[ZipCode].[Name]' type='nominal' />
<column datatype='string' name='[LOCATION_CITY]' role='dimension' semantic-role='[City].[Name]' type='nominal' />
<column datatype='string' name='[LOCATION_COUNTRY]' role='dimension' semantic-role='[Country].[ISO3166_2]' type='nominal' />
<column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
<calculation class='tableau' formula='1' />
</column>
<column datatype='string' name='[PARENT_ACCOUNT_NAME]' role='dimension' type='nominal' />
<column aggregation='Sum' datatype='real' name='[TRANSACTION_ID]' role='dimension' type='ordinal' />
<column aggregation='Sum' datatype='real' name='[TRANSACTION_LINE_ID]' role='dimension' type='ordinal' />
<column-instance column='[CUSTOMER_STATE]' derivation='None' name='[none:CUSTOMER_STATE:nk]' pivot='key' type='nominal' />
<column-instance column='[PARENT_ACCOUNT_NAME]' derivation='None' name='[none:PARENT_ACCOUNT_NAME:nk]' pivot='key' type='nominal' />
<group caption='Action (ACCOUNT_CATEGORY)' hidden='true' name='[Action (ACCOUNT_CATEGORY)]' name-style='unqualified' user:auto-column='sheet_link'>
<groupfilter function='crossjoin'>
<groupfilter function='level-members' level='[ACCOUNT_CATEGORY]' />
</groupfilter>
</group>
<layout dim-ordering='alphabetic' dim-percentage='0.846473' measure-ordering='alphabetic' measure-percentage='0.153527' show-structure='true' user-set-layout='true' />
<style>
<style-rule element='mark'>
<encoding attr='color' field='[none:CUSTOMER_STATE:nk]' type='palette'>
<map to='#499894'>
<bucket>&quot;DC&quot;</bucket>
</map>
<map to='#499894'>
<bucket>&quot;RI&quot;</bucket>
</map>
<map to='#4e79a7'>
<bucket>&quot;CA&quot;</bucket>
</map>
<map to='#4e79a7'>
<bucket>&quot;MN&quot;</bucket>
</map>
<map to='#4e79a7'>
<bucket>&quot;VA&quot;</bucket>
</map>
<map to='#59a14f'>
<bucket>&quot;New York&quot;</bucket>
</map>
<map to='#59a14f'>
<bucket>&quot;VIC&quot;</bucket>
</map>
<map to='#76b7b2'>
<bucket>&quot;SA&quot;</bucket>
</map>
<map to='#79706e'>
<bucket>&quot;GA&quot;</bucket>
</map>
<map to='#79706e'>
<bucket>&quot;OR&quot;</bucket>
</map>
<map to='#86bcb6'>
<bucket>&quot;DE&quot;</bucket>
</map>
<map to='#86bcb6'>
<bucket>&quot;SC&quot;</bucket>
</map>
<map to='#8cd17d'>
<bucket>&quot;California&quot;</bucket>
</map>
<map to='#8cd17d'>
<bucket>&quot;NH&quot;</bucket>
</map>
<map to='#9d7660'>
<bucket>&quot;MI&quot;</bucket>
</map>
<map to='#9d7660'>
<bucket>&quot;TX&quot;</bucket>
</map>
<map to='#a0cbe8'>
<bucket>&quot;AL&quot;</bucket>
</map>
<map to='#a0cbe8'>
<bucket>&quot;MO&quot;</bucket>
</map>
<map to='#a0cbe8'>
<bucket>&quot;WA&quot;</bucket>
</map>
<map to='#b07aa1'>
<bucket>&quot;MA&quot;</bucket>
</map>
<map to='#b07aa1'>
<bucket>&quot;OH&quot;</bucket>
</map>
<map to='#b6992d'>
<bucket>&quot;CO&quot;</bucket>
</map>
<map to='#b6992d'>
<bucket>&quot;NJ&quot;</bucket>
</map>
<map to='#bab0ac'>
<bucket>&quot;Georgia&quot;</bucket>
</map>
<map to='#bab0ac'>
<bucket>&quot;PA&quot;</bucket>
</map>
<map to='#d37295'>
<bucket>&quot;ID&quot;</bucket>
</map>
<map to='#d37295'>
<bucket>&quot;PR&quot;</bucket>
</map>
<map to='#d4a6c8'>
<bucket>&quot;IN&quot;</bucket>
</map>
<map to='#d4a6c8'>
<bucket>&quot;MD&quot;</bucket>
</map>
<map to='#d4a6c8'>
<bucket>&quot;TN&quot;</bucket>
</map>
<map to='#d7b5a6'>
<bucket>&quot;Michigan&quot;</bucket>
</map>
<map to='#d7b5a6'>
<bucket>&quot;UT&quot;</bucket>
</map>
<map to='#e15759'>
<bucket>&quot;NSW&quot;</bucket>
</map>
<map to='#e15759'>
<bucket>&quot;Ohio&quot;</bucket>
</map>
<map to='#edc948'>
<bucket>&quot;NY&quot;</bucket>
</map>
<map to='#f1ce63'>
<bucket>&quot;CT&quot;</bucket>
</map>
<map to='#f1ce63'>
<bucket>&quot;NM&quot;</bucket>
</map>
<map to='#f28e2b'>
<bucket>%null%</bucket>
</map>
<map to='#f28e2b'>
<bucket>&quot;NC&quot;</bucket>
</map>
<map to='#f28e2b'>
<bucket>&quot;WI&quot;</bucket>
</map>
<map to='#fabfd2'>
<bucket>&quot;IL&quot;</bucket>
</map>
<map to='#fabfd2'>
<bucket>&quot;KY&quot;</bucket>
</map>
<map to='#ff9d9a'>
<bucket>&quot;FL&quot;</bucket>
</map>
<map to='#ff9d9a'>
<bucket>&quot;OK&quot;</bucket>
</map>
<map to='#ffbe7d'>
<bucket>&quot;AZ&quot;</bucket>
</map>
<map to='#ffbe7d'>
<bucket>&quot;NE&quot;</bucket>
</map>
</encoding>
<encoding attr='color' field='[none:PARENT_ACCOUNT_NAME:nk]' type='palette'>
<map to='#499894'>
<bucket>&quot;Facilities&quot;</bucket>
</map>
<map to='#4e79a7'>
<bucket>&quot;Benefits&quot;</bucket>
</map>
<map to='#4e79a7'>
<bucket>&quot;Recruiting&quot;</bucket>
</map>
<map to='#59a14f'>
<bucket>&quot;Cost of Goods Sold&quot;</bucket>
</map>
<map to='#59a14f'>
<bucket>&quot;Travel and Entertainment&quot;</bucket>
</map>
<map to='#79706e'>
<bucket>&quot;Marketing&quot;</bucket>
</map>
<map to='#86bcb6'>
<bucket>&quot;Finance&quot;</bucket>
</map>
<map to='#8cd17d'>
<bucket>&quot;Culture&quot;</bucket>
</map>
<map to='#8cd17d'>
<bucket>&quot;Unrealized Gain/Loss&quot;</bucket>
</map>
<map to='#9d7660'>
<bucket>&quot;Professional and Consulting Services&quot;</bucket>
</map>
<map to='#a0cbe8'>
<bucket>&quot;Bonus&quot;</bucket>
</map>
<map to='#a0cbe8'>
<bucket>&quot;Rounding Gain/Loss&quot;</bucket>
</map>
<map to='#b07aa1'>
<bucket>&quot;Payroll and Related&quot;</bucket>
</map>
<map to='#b6992d'>
<bucket>&quot;Depreciation and Amortization&quot;</bucket>
</map>
<map to='#bab0ac'>
<bucket>&quot;Office Expenses&quot;</bucket>
</map>
<map to='#d37295'>
<bucket>&quot;Other Expense&quot;</bucket>
</map>
<map to='#d4a6c8'>
<bucket>&quot;People Operations&quot;</bucket>
</map>
<map to='#d7b5a6'>
<bucket>&quot;Realized Gain/Loss&quot;</bucket>
</map>
<map to='#e15759'>
<bucket>&quot;IT&quot;</bucket>
</map>
<map to='#f1ce63'>
<bucket>&quot;Expense&quot;</bucket>
</map>
<map to='#f28e2b'>
<bucket>&quot;Commisions&quot;</bucket>
</map>
<map to='#f28e2b'>
<bucket>&quot;Stock Based Compensation&quot;</bucket>
</map>
<map to='#fabfd2'>
<bucket>&quot;Partnerships and Resell&quot;</bucket>
</map>
<map to='#ff9d9a'>
<bucket>&quot;Legal&quot;</bucket>
</map>
<map to='#ffbe7d'>
<bucket>&quot;Community&quot;</bucket>
</map>
<map to='#ffbe7d'>
<bucket>&quot;Suspense&quot;</bucket>
</map>
</encoding>
</style-rule>
</style>
<semantic-values>
<semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
</semantic-values>
</datasource>
<datasource caption='Income Statement' inline='true' name='federated.1y90zz21qenhz81frqyhy06hh5op' version='18.1'>
<connection class='federated'>
<named-connections>
<named-connection caption='my_url.snowflakecomputing.com' name='snowflake.0ufqrqc0bebtg910kchqs130n4zn'>
<connection authentication='Username Password' class='snowflake' dbname='my_db_name' odbc-connect-string-extras='' one-time-sql='' schema='NETSUITE' server='my_url.snowflakecomputing.com' service='my_service' username='my_username' warehouse='my_warehouse' />
</named-connection>
</named-connections>
<relation connection='snowflake.0ufqrqc0bebtg910kchqs130n4zn' name='income_statement' type='text'>with period_exchange_rate_map as ( -- exchange rates used, by accounting period, to convert to parent subsidiary&#10; select&#10; consolidated_exchange_rates.accounting_period_id,&#10; consolidated_exchange_rates.average_rate,&#10; consolidated_exchange_rates.current_rate,&#10; consolidated_exchange_rates.historical_rate,&#10; consolidated_exchange_rates.from_subsidiary_id,&#10; consolidated_exchange_rates.to_subsidiary_id&#10; from netsuite.consolidated_exchange_rates&#10; where consolidated_exchange_rates.to_subsidiary_id in (&#10; select&#10; subsidiary_id&#10; from netsuite.subsidiaries&#10; where parent_id is null -- constrait - only the primary subsidiary has no parent&#10; )&#10; and consolidated_exchange_rates.accounting_book_id in (&#10; select&#10; accounting_book_id&#10; from netsuite.accounting_books&#10; where lower(is_primary) = &apos;yes&apos;&#10; )&#10; and not consolidated_exchange_rates._fivetran_deleted&#10;), accountxperiod_exchange_rate_map as ( -- account table with exchange rate details by accounting period&#10; select&#10; period_exchange_rate_map.accounting_period_id,&#10; period_exchange_rate_map.from_subsidiary_id,&#10; period_exchange_rate_map.to_subsidiary_id,&#10; accounts.account_id,&#10; case &#10; when lower(accounts.general_rate_type) = &apos;historical&apos; then period_exchange_rate_map.historical_rate&#10; when lower(accounts.general_rate_type) = &apos;current&apos; then period_exchange_rate_map.current_rate&#10; when lower(accounts.general_rate_type) = &apos;average&apos; then period_exchange_rate_map.average_rate&#10; else null&#10; end as exchange_rate,&#10; period_exchange_rate_map.current_rate as CTA_control_current_exchange_rate&#10; from netsuite.accounts&#10; cross join period_exchange_rate_map&#10;), transaction_lines_w_accounting_period as ( -- transaction line totals, by accounts, accounting period and subsidiary&#10; select&#10; transaction_lines.transaction_id,&#10; transaction_lines.transaction_line_id,&#10; transaction_lines.subsidiary_id,&#10; transaction_lines.account_id,&#10; transactions.accounting_period_id as transaction_accounting_period_id,&#10; coalesce(transaction_lines.amount, 0) as unconverted_amount&#10; from netsuite.transaction_lines&#10; join netsuite.transactions on transactions.transaction_id = transaction_lines.transaction_id&#10; where not transactions._fivetran_deleted&#10; and lower(transactions.transaction_type) != &apos;revenue arrangement&apos;&#10; and lower(non_posting_line) != &apos;yes&apos;&#10;), period_id_list_to_current_period as ( -- period ids with all future period ids. this is needed to calculate cumulative totals by correct exchange rates.&#10; select&#10; base.accounting_period_id,&#10; array_agg(multiplier.accounting_period_id) within group (order by multiplier.accounting_period_id) as accounting_periods_to_include_for&#10; from netsuite.accounting_periods as base&#10; join netsuite.accounting_periods as multiplier&#10; on multiplier.starting &gt;&gt;= base.starting&#10; and multiplier.quarter = base.quarter&#10; and multiplier.year_0 = base.year_0&#10; and multiplier.fiscal_calendar_id = base.fiscal_calendar_id&#10; and multiplier.starting &lt;&lt;= current_timestamp()&#10; where lower(base.quarter) = &apos;no&apos;&#10; and lower(base.year_0) = &apos;no&apos;&#10; and base.fiscal_calendar_id = (select &#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null) -- fiscal calendar will align with parent subsidiary&apos;s default calendar&#10; group by 1&#10;), flattened_period_id_list_to_current_period as (&#10; select&#10; accounting_period_id,&#10; reporting_accounting_period_id.value as reporting_accounting_period_id&#10; from period_id_list_to_current_period,&#10; lateral flatten (input =&gt;&gt; accounting_periods_to_include_for) reporting_accounting_period_id&#10;), transactions_in_every_calculation_period_w_exchange_rates as (&#10; select&#10; transaction_lines_w_accounting_period.*,&#10; reporting_accounting_period_id,&#10; exchange_reporting_period.exchange_rate as exchange_rate_reporting_period,&#10; exchange_transaction_period.exchange_rate as exchange_rate_transaction_period,&#10; exchange_transaction_period.CTA_control_current_exchange_rate as CTA_control_current_exchange_rate&#10; from transaction_lines_w_accounting_period&#10; inner join flattened_period_id_list_to_current_period on flattened_period_id_list_to_current_period.accounting_period_id = transaction_lines_w_accounting_period.transaction_accounting_period_id &#10; left join accountxperiod_exchange_rate_map as exchange_reporting_period&#10; on exchange_reporting_period.accounting_period_id = flattened_period_id_list_to_current_period.reporting_accounting_period_id&#10; and exchange_reporting_period.account_id = transaction_lines_w_accounting_period.account_id&#10; and exchange_reporting_period.from_subsidiary_id = transaction_lines_w_accounting_period.subsidiary_id&#10; left join accountxperiod_exchange_rate_map as exchange_transaction_period&#10; on exchange_transaction_period.accounting_period_id = flattened_period_id_list_to_current_period.accounting_period_id&#10; and exchange_transaction_period.account_id = transaction_lines_w_accounting_period.account_id&#10; and exchange_transaction_period.from_subsidiary_id = transaction_lines_w_accounting_period.subsidiary_id&#10;), transactions_with_converted_amounts as (&#10; select&#10; transactions_in_every_calculation_period_w_exchange_rates.*,&#10; unconverted_amount * exchange_rate_transaction_period as converted_amount_using_transaction_accounting_period,&#10; unconverted_amount * exchange_rate_reporting_period as converted_amount_using_reporting_month,&#10; unconverted_amount * CTA_control_current_exchange_rate as converted_amount_using_cta_control,&#10; case&#10; when lower(accounts.type_name) in (&apos;income&apos;,&apos;other income&apos;,&apos;expense&apos;,&apos;other expense&apos;,&apos;other income&apos;,&apos;cost of goods sold&apos;) then true&#10; else false &#10; end as is_income_statement,&#10; case&#10; when lower(accounts.type_name) in (&apos;accounts receivable&apos;, &apos;bank&apos;, &apos;deferred expense&apos;, &apos;fixed asset&apos;, &apos;other asset&apos;, &apos;other current asset&apos;, &apos;unbilled receivable&apos;) then &apos;Asset&apos;&#10; when lower(accounts.type_name) in (&apos;cost of goods sold&apos;, &apos;expense&apos;, &apos;other expense&apos;) then &apos;Expense&apos;&#10; when lower(accounts.type_name) in (&apos;income&apos;, &apos;other income&apos;) then &apos;Income&apos;&#10; when lower(accounts.type_name) in (&apos;accounts payable&apos;, &apos;credit card&apos;, &apos;deferred revenue&apos;, &apos;long term liability&apos;, &apos;other current liability&apos;) then &apos;Liability&apos;&#10; when lower(accounts.type_name) in (&apos;equity&apos;, &apos;retained earnings&apos;, &apos;net income&apos;) then &apos;Equity&apos;&#10; else null &#10; end as account_category&#10; from transactions_in_every_calculation_period_w_exchange_rates&#10; left join netsuite.accounts on accounts.account_id = transactions_in_every_calculation_period_w_exchange_rates.account_id&#10;)&#10;select&#10; reporting_accounting_periods.accounting_period_id as accounting_period_id,&#10; reporting_accounting_periods.ending as accounting_period_ending,&#10; reporting_accounting_periods.full_name as accounting_period_full_name,&#10; reporting_accounting_periods.name as accounting_period_name,&#10; lower(reporting_accounting_periods.is_adjustment) = &apos;yes&apos; as is_accounting_period_adjustment,&#10; lower(reporting_accounting_periods.closed) = &apos;yes&apos; as is_accounting_period_closed,&#10; accounts.name as account_name,&#10; accounts.type_name as account_type_name,&#10; accounts.account_id as account_id,&#10; accounts.accountnumber as account_number,&#10; concat(accounts.accountnumber, &apos; - &apos;, accounts.name) as account_number_and_name,&#10; classes.full_name as class_full_name,&#10; locations.full_name as location_full_name,&#10; departments.full_name as department_full_name,&#10; -converted_amount_using_transaction_accounting_period as converted_amount,&#10; transactions_with_converted_amounts.account_category as account_category,&#10; case when lower(accounts.type_name) = &apos;income&apos; then 1&#10; when lower(accounts.type_name) = &apos;cost of goods sold&apos; then 2&#10; when lower(accounts.type_name) = &apos;expense&apos; then 3&#10; when lower(accounts.type_name) = &apos;other income&apos; then 4&#10; when lower(accounts.type_name) = &apos;other expense&apos; then 5&#10; else null&#10; end as income_statement_sort_helper&#10;from transactions_with_converted_amounts as transactions_with_converted_amounts&#10;left join netsuite.transaction_lines as transaction_lines&#10; on transaction_lines.transaction_line_id = transactions_with_converted_amounts.transaction_line_id&#10; and transaction_lines.transaction_id = transactions_with_converted_amounts.transaction_id&#10;left join netsuite.classes on classes.class_id = transaction_lines.class_id&#10;left join netsuite.locations on locations.location_id = transaction_lines.location_id&#10;left join netsuite.departments on departments.department_id = transaction_lines.department_id&#10;left join netsuite.accounts on accounts.account_id = transactions_with_converted_amounts.account_id&#10;left join netsuite.accounting_periods as reporting_accounting_periods on reporting_accounting_periods.accounting_period_id = transactions_with_converted_amounts.reporting_accounting_period_id&#10;where reporting_accounting_periods.fiscal_calendar_id = (select&#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null)&#10; and transactions_with_converted_amounts.transaction_accounting_period_id = transactions_with_converted_amounts.reporting_accounting_period_id&#10; and transactions_with_converted_amounts.is_income_statement</relation>
<metadata-records>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[ACCOUNTING_PERIOD_ID]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_ID</remote-alias>
<ordinal>1</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_ENDING</remote-name>
<remote-type>7</remote-type>
<local-name>[ACCOUNTING_PERIOD_ENDING]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_ENDING</remote-alias>
<ordinal>2</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_FULL_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNTING_PERIOD_FULL_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_FULL_NAME</remote-alias>
<ordinal>3</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>2388</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNTING_PERIOD_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_NAME</remote-alias>
<ordinal>4</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>256</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTING_PERIOD_ADJUSTMENT</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTING_PERIOD_ADJUSTMENT]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>IS_ACCOUNTING_PERIOD_ADJUSTMENT</remote-alias>
<ordinal>5</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTING_PERIOD_CLOSED</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTING_PERIOD_CLOSED]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>IS_ACCOUNTING_PERIOD_CLOSED</remote-alias>
<ordinal>6</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNT_NAME</remote-alias>
<ordinal>7</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>372</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_TYPE_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_TYPE_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNT_TYPE_NAME</remote-alias>
<ordinal>8</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>512</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[ACCOUNT_ID]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNT_ID</remote-alias>
<ordinal>9</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NUMBER</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NUMBER]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNT_NUMBER</remote-alias>
<ordinal>10</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>240</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NUMBER_AND_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NUMBER_AND_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNT_NUMBER_AND_NAME</remote-alias>
<ordinal>11</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>615</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CLASS_FULL_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[CLASS_FULL_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>CLASS_FULL_NAME</remote-alias>
<ordinal>12</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16000</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>LOCATION_FULL_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[LOCATION_FULL_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>LOCATION_FULL_NAME</remote-alias>
<ordinal>13</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16000</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>DEPARTMENT_FULL_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[DEPARTMENT_FULL_NAME]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>DEPARTMENT_FULL_NAME</remote-alias>
<ordinal>14</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16000</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CONVERTED_AMOUNT</remote-name>
<remote-type>5</remote-type>
<local-name>[CONVERTED_AMOUNT]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>CONVERTED_AMOUNT</remote-alias>
<ordinal>15</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_CATEGORY</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_CATEGORY]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>ACCOUNT_CATEGORY</remote-alias>
<ordinal>16</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16777216</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>INCOME_STATEMENT_SORT_HELPER</remote-name>
<remote-type>131</remote-type>
<local-name>[INCOME_STATEMENT_SORT_HELPER]</local-name>
<parent-name>[income_statement]</parent-name>
<remote-alias>INCOME_STATEMENT_SORT_HELPER</remote-alias>
<ordinal>17</ordinal>
<local-type>integer</local-type>
<aggregation>Sum</aggregation>
<precision>1</precision>
<scale>0</scale>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DECIMAL&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_NUMERIC&quot;</attribute>
</attributes>
</metadata-record>
</metadata-records>
</connection>
<column aggregation='Sum' datatype='real' name='[ACCOUNTING_PERIOD_ID]' role='dimension' type='ordinal' />
<column aggregation='Sum' datatype='real' name='[ACCOUNT_ID]' role='dimension' type='ordinal' />
<column aggregation='Sum' datatype='integer' name='[INCOME_STATEMENT_SORT_HELPER]' role='dimension' type='ordinal' />
<column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
<calculation class='tableau' formula='1' />
</column>
<layout dim-ordering='alphabetic' dim-percentage='0.704011' measure-ordering='alphabetic' measure-percentage='0.295989' show-structure='true' />
<semantic-values>
<semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
</semantic-values>
</datasource>
<datasource caption='Balance Sheet' inline='true' name='federated.0ggpjke1y9yu8m1dosxmx1k711l5' version='18.1'>
<connection class='federated'>
<named-connections>
<named-connection caption='my_url.snowflakecomputing.com' name='snowflake.1b6dx090wabws11gswl370m1wuht'>
<connection authentication='Username Password' class='snowflake' dbname='my_db_name' odbc-connect-string-extras='' one-time-sql='' schema='NETSUITE' server='my_url.snowflakecomputing.com' service='my_service' username='my_username' warehouse='my_warehouse' />
</named-connection>
</named-connections>
<relation connection='snowflake.1b6dx090wabws11gswl370m1wuht' name='balance_sheet' type='text'>with period_exchange_rate_map as ( -- exchange rates used, by accounting period, to convert to parent subsidiary&#10; select&#10; consolidated_exchange_rates.accounting_period_id,&#10; consolidated_exchange_rates.average_rate,&#10; consolidated_exchange_rates.current_rate,&#10; consolidated_exchange_rates.historical_rate,&#10; consolidated_exchange_rates.from_subsidiary_id,&#10; consolidated_exchange_rates.to_subsidiary_id&#10; from netsuite.consolidated_exchange_rates&#10; where consolidated_exchange_rates.to_subsidiary_id in (&#10; select&#10; subsidiary_id&#10; from netsuite.subsidiaries&#10; where parent_id is null -- constrait - only the primary subsidiary has no parent&#10; )&#10; and consolidated_exchange_rates.accounting_book_id in (&#10; select&#10; accounting_book_id&#10; from netsuite.accounting_books&#10; where lower(is_primary) = &apos;yes&apos;&#10; )&#10; and not consolidated_exchange_rates._fivetran_deleted&#10;), accountxperiod_exchange_rate_map as ( -- account table with exchange rate details by accounting period&#10; select&#10; period_exchange_rate_map.accounting_period_id,&#10; period_exchange_rate_map.from_subsidiary_id,&#10; period_exchange_rate_map.to_subsidiary_id,&#10; accounts.account_id,&#10; case &#10; when lower(accounts.general_rate_type) = &apos;historical&apos; then period_exchange_rate_map.historical_rate&#10; when lower(accounts.general_rate_type) = &apos;current&apos; then period_exchange_rate_map.current_rate&#10; when lower(accounts.general_rate_type) = &apos;average&apos; then period_exchange_rate_map.average_rate&#10; else null&#10; end as exchange_rate,&#10; period_exchange_rate_map.current_rate as CTA_control_current_exchange_rate&#10; from netsuite.accounts&#10; cross join period_exchange_rate_map&#10;), transaction_lines_w_accounting_period as ( -- transaction line totals, by accounts, accounting period and subsidiary&#10; select&#10; transaction_lines.transaction_id,&#10; transaction_lines.transaction_line_id,&#10; transaction_lines.subsidiary_id,&#10; transaction_lines.account_id,&#10; transactions.accounting_period_id as transaction_accounting_period_id,&#10; coalesce(transaction_lines.amount, 0) as unconverted_amount&#10; from netsuite.transaction_lines&#10; join netsuite.transactions on transactions.transaction_id = transaction_lines.transaction_id&#10; where not transactions._fivetran_deleted&#10; and lower(transactions.transaction_type) != &apos;revenue arrangement&apos;&#10; and lower(non_posting_line) != &apos;yes&apos;&#10;), period_id_list_to_current_period as ( -- period ids with all future period ids. this is needed to calculate cumulative totals by correct exchange rates.&#10; select&#10; base.accounting_period_id,&#10; array_agg(multiplier.accounting_period_id) within group (order by multiplier.accounting_period_id) as accounting_periods_to_include_for&#10; from netsuite.accounting_periods as base&#10; join netsuite.accounting_periods as multiplier&#10; on multiplier.starting &gt;&gt;= base.starting&#10; and multiplier.quarter = base.quarter&#10; and multiplier.year_0 = base.year_0&#10; and multiplier.fiscal_calendar_id = base.fiscal_calendar_id&#10; and multiplier.starting &lt;&lt;= current_timestamp()&#10; where lower(base.quarter) = &apos;no&apos;&#10; and lower(base.year_0) = &apos;no&apos;&#10; and base.fiscal_calendar_id = (select &#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null) -- fiscal calendar will align with parent subsidiary&apos;s default calendar&#10; group by 1&#10;), flattened_period_id_list_to_current_period as (&#10; select&#10; accounting_period_id,&#10; reporting_accounting_period_id.value as reporting_accounting_period_id&#10; from period_id_list_to_current_period,&#10; lateral flatten (input =&gt;&gt; accounting_periods_to_include_for) reporting_accounting_period_id&#10;), transactions_in_every_calculation_period_w_exchange_rates as (&#10; select&#10; transaction_lines_w_accounting_period.*,&#10; reporting_accounting_period_id,&#10; exchange_reporting_period.exchange_rate as exchange_rate_reporting_period,&#10; exchange_transaction_period.exchange_rate as exchange_rate_transaction_period,&#10; exchange_transaction_period.CTA_control_current_exchange_rate as CTA_control_current_exchange_rate&#10; from transaction_lines_w_accounting_period&#10; inner join flattened_period_id_list_to_current_period on flattened_period_id_list_to_current_period.accounting_period_id = transaction_lines_w_accounting_period.transaction_accounting_period_id &#10; left join accountxperiod_exchange_rate_map as exchange_reporting_period&#10; on exchange_reporting_period.accounting_period_id = flattened_period_id_list_to_current_period.reporting_accounting_period_id&#10; and exchange_reporting_period.account_id = transaction_lines_w_accounting_period.account_id&#10; and exchange_reporting_period.from_subsidiary_id = transaction_lines_w_accounting_period.subsidiary_id&#10; left join accountxperiod_exchange_rate_map as exchange_transaction_period&#10; on exchange_transaction_period.accounting_period_id = flattened_period_id_list_to_current_period.accounting_period_id&#10; and exchange_transaction_period.account_id = transaction_lines_w_accounting_period.account_id&#10; and exchange_transaction_period.from_subsidiary_id = transaction_lines_w_accounting_period.subsidiary_id&#10;), transactions_with_converted_amounts as (&#10; select&#10; transactions_in_every_calculation_period_w_exchange_rates.*,&#10; unconverted_amount * exchange_rate_transaction_period as converted_amount_using_transaction_accounting_period,&#10; unconverted_amount * exchange_rate_reporting_period as converted_amount_using_reporting_month,&#10; unconverted_amount * CTA_control_current_exchange_rate as converted_amount_using_cta_control,&#10; case&#10; when lower(accounts.type_name) in (&apos;income&apos;,&apos;other income&apos;,&apos;expense&apos;,&apos;other expense&apos;,&apos;other income&apos;,&apos;cost of goods sold&apos;) then true&#10; else false &#10; end as is_income_statement,&#10; case&#10; when lower(accounts.type_name) in (&apos;accounts receivable&apos;, &apos;bank&apos;, &apos;deferred expense&apos;, &apos;fixed asset&apos;, &apos;other asset&apos;, &apos;other current asset&apos;, &apos;unbilled receivable&apos;) then &apos;Asset&apos;&#10; when lower(accounts.type_name) in (&apos;cost of goods sold&apos;, &apos;expense&apos;, &apos;other expense&apos;) then &apos;Expense&apos;&#10; when lower(accounts.type_name) in (&apos;income&apos;, &apos;other income&apos;) then &apos;Income&apos;&#10; when lower(accounts.type_name) in (&apos;accounts payable&apos;, &apos;credit card&apos;, &apos;deferred revenue&apos;, &apos;long term liability&apos;, &apos;other current liability&apos;) then &apos;Liability&apos;&#10; when lower(accounts.type_name) in (&apos;equity&apos;, &apos;retained earnings&apos;, &apos;net income&apos;) then &apos;Equity&apos;&#10; else null &#10; end as account_category&#10; from transactions_in_every_calculation_period_w_exchange_rates&#10; left join netsuite.accounts on accounts.account_id = transactions_in_every_calculation_period_w_exchange_rates.account_id&#10;)&#10;select&#10; reporting_accounting_periods.accounting_period_id as accounting_period_id,&#10; reporting_accounting_periods.ending as accounting_period_ending,&#10; reporting_accounting_periods.full_name as accounting_period_full_name,&#10; reporting_accounting_periods.name as accounting_period_name,&#10; lower(reporting_accounting_periods.is_adjustment) = &apos;yes&apos; as is_accounting_period_adjustment,&#10; lower(reporting_accounting_periods.closed) = &apos;yes&apos; as is_accounting_period_closed,&#10; transactions_with_converted_amounts.account_category as account_category,&#10; case&#10; when (lower(accounts.is_balancesheet) = &apos;f&apos; and reporting_accounting_periods.year_id = transaction_accounting_periods.year_id) then &apos;Net Income&apos;&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then &apos;Retained Earnings&apos;&#10; else accounts.name&#10; end as account_name,&#10; case&#10; when (lower(accounts.is_balancesheet) = &apos;f&apos; and reporting_accounting_periods.year_id = transaction_accounting_periods.year_id) then &apos;Net Income&apos;&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then &apos;Retained Earnings&apos;&#10; else accounts.type_name&#10; end as account_type_name,&#10; case&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then null&#10; else accounts.account_id&#10; end as account_id,&#10; case&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then null&#10; else accounts.accountnumber&#10; end as account_number,&#10; case&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then -converted_amount_using_transaction_accounting_period&#10; when lower(accounts.is_leftside) = &apos;f&apos; then -converted_amount_using_transaction_accounting_period&#10; when lower(accounts.is_leftside) = &apos;t&apos; then converted_amount_using_transaction_accounting_period&#10; else 0 &#10; end as converted_amount,&#10; case&#10; when lower(account_type_name) = &apos;bank&apos; then 1&#10; when lower(account_type_name) = &apos;accounts receivable&apos; then 2&#10; when lower(account_type_name) = &apos;unbilled receivable&apos; then 3&#10; when lower(account_type_name) = &apos;other current asset&apos; then 4&#10; when lower(account_type_name) = &apos;fixed asset&apos; then 5&#10; when lower(account_type_name) = &apos;other asset&apos; then 6&#10; when lower(account_type_name) = &apos;deferred expense&apos; then 7&#10; when lower(account_type_name) = &apos;accounts payable&apos; then 8&#10; when lower(account_type_name) = &apos;credit card&apos; then 9&#10; when lower(account_type_name) = &apos;other current liability&apos; then 10&#10; when lower(account_type_name) = &apos;long term liability&apos; then 11&#10; when lower(account_type_name) = &apos;deferred revenue&apos; then 12&#10; when lower(account_type_name) = &apos;equity&apos; then 13&#10; when (lower(accounts.is_balancesheet) = &apos;f&apos; and reporting_accounting_periods.year_id = transaction_accounting_periods.year_id) then 15&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then 14&#10; else null&#10; end as balance_sheet_sort_helper&#10;from transactions_with_converted_amounts as transactions_with_converted_amounts&#10;left join netsuite.accounts on accounts.account_id = transactions_with_converted_amounts.account_id&#10;left join netsuite.accounting_periods as reporting_accounting_periods on reporting_accounting_periods.accounting_period_id = transactions_with_converted_amounts.reporting_accounting_period_id&#10;left join netsuite.accounting_periods as transaction_accounting_periods on transaction_accounting_periods.accounting_period_id = transactions_with_converted_amounts.transaction_accounting_period_id&#10;where reporting_accounting_periods.fiscal_calendar_id = (select &#10; fiscal_calendar_id &#10; from netsuite.subsidiaries &#10; where parent_id is null)&#10; and transaction_accounting_periods.fiscal_calendar_id = (select &#10; fiscal_calendar_id &#10; from netsuite.subsidiaries &#10; where parent_id is null)&#10; and (lower(accounts.is_balancesheet) = &apos;t&apos; &#10; or transactions_with_converted_amounts.is_income_statement)&#10; &#10;union all&#10;&#10;select&#10; reporting_accounting_periods.accounting_period_id as accounting_period_id,&#10; reporting_accounting_periods.ending as accounting_period_ending,&#10; reporting_accounting_periods.full_name as accounting_period_full_name,&#10; reporting_accounting_periods.name as accounting_period_name,&#10; lower(reporting_accounting_periods.is_adjustment) = &apos;yes&apos; as is_accounting_period_adjustment,&#10; lower(reporting_accounting_periods.closed) = &apos;yes&apos; as is_accounting_period_closed,&#10; &apos;Equity&apos; as account_category,&#10; &apos;Cumulative Translation Adjustment&apos; as account_name,&#10; &apos;Equity&apos; as account_type_name,&#10; null as account_id,&#10; null as account_number,&#10; case&#10; when lower(accounts.is_balancesheet) = &apos;f&apos; then converted_amount_using_transaction_accounting_period - converted_amount_using_cta_control&#10; else converted_amount_using_reporting_month - converted_amount_using_cta_control&#10; end as converted_amount,&#10; 16 as balance_sheet_sort_helper&#10;from transactions_with_converted_amounts as transactions_with_converted_amounts&#10;left join netsuite.accounts on accounts.account_id = transactions_with_converted_amounts.account_id&#10;left join netsuite.accounting_periods as reporting_accounting_periods on reporting_accounting_periods.accounting_period_id = transactions_with_converted_amounts.reporting_accounting_period_id&#10;left join netsuite.accounting_periods as transaction_accounting_periods on transaction_accounting_periods.accounting_period_id = transactions_with_converted_amounts.transaction_accounting_period_id&#10;where reporting_accounting_periods.fiscal_calendar_id = (select&#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null)&#10; and transaction_accounting_periods.fiscal_calendar_id = (select&#10; fiscal_calendar_id&#10; from netsuite.subsidiaries&#10; where parent_id is null)&#10; and (lower(accounts.is_balancesheet) = &apos;t&apos;&#10; or transactions_with_converted_amounts.is_income_statement)</relation>
<metadata-records>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[ACCOUNTING_PERIOD_ID]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_ID</remote-alias>
<ordinal>1</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_ENDING</remote-name>
<remote-type>7</remote-type>
<local-name>[ACCOUNTING_PERIOD_ENDING]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_ENDING</remote-alias>
<ordinal>2</ordinal>
<local-type>datetime</local-type>
<aggregation>Year</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_TYPE_TIMESTAMP&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_TYPE_TIMESTAMP&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_FULL_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNTING_PERIOD_FULL_NAME]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_FULL_NAME</remote-alias>
<ordinal>3</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>2388</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNTING_PERIOD_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNTING_PERIOD_NAME]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNTING_PERIOD_NAME</remote-alias>
<ordinal>4</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>256</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTING_PERIOD_ADJUSTMENT</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTING_PERIOD_ADJUSTMENT]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>IS_ACCOUNTING_PERIOD_ADJUSTMENT</remote-alias>
<ordinal>5</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>IS_ACCOUNTING_PERIOD_CLOSED</remote-name>
<remote-type>11</remote-type>
<local-name>[IS_ACCOUNTING_PERIOD_CLOSED]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>IS_ACCOUNTING_PERIOD_CLOSED</remote-alias>
<ordinal>6</ordinal>
<local-type>boolean</local-type>
<aggregation>Count</aggregation>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_BIT&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_BIT&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_CATEGORY</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_CATEGORY]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNT_CATEGORY</remote-alias>
<ordinal>7</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16777216</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NAME]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNT_NAME</remote-alias>
<ordinal>8</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>372</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_TYPE_NAME</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_TYPE_NAME]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNT_TYPE_NAME</remote-alias>
<ordinal>9</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>512</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_ID</remote-name>
<remote-type>5</remote-type>
<local-name>[ACCOUNT_ID]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNT_ID</remote-alias>
<ordinal>10</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>ACCOUNT_NUMBER</remote-name>
<remote-type>129</remote-type>
<local-name>[ACCOUNT_NUMBER]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>ACCOUNT_NUMBER</remote-alias>
<ordinal>11</ordinal>
<local-type>string</local-type>
<aggregation>Count</aggregation>
<width>16777216</width>
<contains-null>true</contains-null>
<collation flag='0' name='binary' />
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_VARCHAR&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_CHAR&quot;</attribute>
<attribute datatype='string' name='TypeIsVarchar'>&quot;true&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>CONVERTED_AMOUNT</remote-name>
<remote-type>5</remote-type>
<local-name>[CONVERTED_AMOUNT]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>CONVERTED_AMOUNT</remote-alias>
<ordinal>12</ordinal>
<local-type>real</local-type>
<aggregation>Sum</aggregation>
<precision>15</precision>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DOUBLE&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_DOUBLE&quot;</attribute>
</attributes>
</metadata-record>
<metadata-record class='column'>
<remote-name>BALANCE_SHEET_SORT_HELPER</remote-name>
<remote-type>131</remote-type>
<local-name>[BALANCE_SHEET_SORT_HELPER]</local-name>
<parent-name>[balance_sheet]</parent-name>
<remote-alias>BALANCE_SHEET_SORT_HELPER</remote-alias>
<ordinal>13</ordinal>
<local-type>integer</local-type>
<aggregation>Sum</aggregation>
<precision>2</precision>
<scale>0</scale>
<contains-null>true</contains-null>
<attributes>
<attribute datatype='string' name='DebugRemoteType'>&quot;SQL_DECIMAL&quot;</attribute>
<attribute datatype='string' name='DebugWireType'>&quot;SQL_C_NUMERIC&quot;</attribute>
</attributes>
</metadata-record>
</metadata-records>
</connection>
<aliases enabled='yes' />
<column aggregation='Sum' datatype='real' name='[ACCOUNTING_PERIOD_ID]' role='dimension' type='ordinal' />
<column aggregation='Sum' datatype='real' name='[ACCOUNT_ID]' role='dimension' type='ordinal' />
<column aggregation='Sum' datatype='integer' name='[BALANCE_SHEET_SORT_HELPER]' role='dimension' type='ordinal' />
<column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
<calculation class='tableau' formula='1' />
</column>
<layout dim-ordering='alphabetic' dim-percentage='0.64592' measure-ordering='alphabetic' measure-percentage='0.35408' show-structure='true' />
<semantic-values>
<semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
</semantic-values>
<field-sort-info field-sort-order-type='custom-order'>
<field-sort-custom-order field='ACCOUNTING_PERIOD_ID' />
<field-sort-custom-order field='ACCOUNTING_PERIOD_ENDING' />
<field-sort-custom-order field='ACCOUNTING_PERIOD_FULL_NAME' />
<field-sort-custom-order field='ACCOUNTING_PERIOD_NAME' />
<field-sort-custom-order field='ACCOUNTING_PERIOD_IS_ADJUSTMENT' />
<field-sort-custom-order field='ACCOUNT_NAME' />
<field-sort-custom-order field='ACCOUNT_TYPE_NAME' />
<field-sort-custom-order field='ACCOUNT_ID' />
<field-sort-custom-order field='ACCOUNT_NUMBER' />
<field-sort-custom-order field='CONVERTED_AMOUNT' />
<field-sort-custom-order field='Calculation_68750306296590336' />
<field-sort-custom-order field='BALANCE_SHEET_SORT_HELPER' />
<field-sort-custom-order field='ACCOUNT_CATEGORY' />
</field-sort-info>
</datasource>
</datasources>
<mapsources>
<mapsource name='Tableau' />
</mapsources>
<worksheets>
<worksheet name='A/P Aging'>
<layout-options>
<title>
<formatted-text>
<run bold='true' fontalignment='1' fontcolor='#000000' fontsize='12'>&lt;Sheet Name&gt;</run>
</formatted-text>
</title>
</layout-options>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='real' name='[CONVERTED_AMOUNT]' role='measure' type='quantitative' />
<column datatype='string' name='[DAYS_PAST_DUE_DATE_TIER]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNTS_PAYABLE]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='string' name='[SUBSIDIARY_NAME]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_STATUS]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_TYPE]' role='dimension' type='nominal' />
<column datatype='string' name='[VENDOR_NAME]' role='dimension' type='nominal' />
<column-instance column='[DAYS_PAST_DUE_DATE_TIER]' derivation='None' name='[none:DAYS_PAST_DUE_DATE_TIER:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNTS_PAYABLE]' derivation='None' name='[none:IS_ACCOUNTS_PAYABLE:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[SUBSIDIARY_NAME]' derivation='None' name='[none:SUBSIDIARY_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_STATUS]' derivation='None' name='[none:TRANSACTION_STATUS:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_TYPE]' derivation='None' name='[none:TRANSACTION_TYPE:nk]' pivot='key' type='nominal' />
<column-instance column='[VENDOR_NAME]' derivation='None' name='[none:VENDOR_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[CONVERTED_AMOUNT]' derivation='Sum' name='[sum:CONVERTED_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_PAYABLE:nk]' filter-group='21'>
<groupfilter function='member' level='[none:IS_ACCOUNTS_PAYABLE:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='18'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='16'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]' filter-group='17'>
<groupfilter function='member' level='[none:TRANSACTION_STATUS:nk]' member='&quot;Open&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]' filter-group='20'>
<groupfilter function='member' level='[none:TRANSACTION_TYPE:nk]' member='&quot;Bill&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:VENDOR_NAME:nk]' filter-group='22'>
<groupfilter function='level-members' level='[none:VENDOR_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_PAYABLE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:VENDOR_NAME:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='cell'>
<format attr='width' value='201' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]' value='228' />
</style-rule>
<style-rule element='worksheet'>
<format attr='display-field-labels' scope='rows' value='false' />
<format attr='font-size' value='8' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Automatic' />
<encodings>
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
</style-rule>
<style-rule element='pane'>
<format attr='minwidth' value='-1' />
<format attr='maxwidth' value='-1' />
</style-rule>
</style>
</pane>
</panes>
<rows>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]</rows>
<cols />
</table>
<simple-id uuid='{FE936CBD-9DCE-4D78-9BE9-E6A116EF117A}' />
</worksheet>
<worksheet name='A/R Aging'>
<layout-options>
<title>
<formatted-text>
<run bold='true' fontalignment='1' fontcolor='#000000' fontsize='12'>&lt;Sheet Name&gt;</run>
</formatted-text>
</title>
</layout-options>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='real' name='[CONVERTED_AMOUNT]' role='measure' type='quantitative' />
<column datatype='string' name='[CUSTOMER_COMPANY_NAME]' role='dimension' type='nominal' />
<column datatype='string' name='[DAYS_PAST_DUE_DATE_TIER]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNTS_RECEIVABLE]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='string' name='[SUBSIDIARY_NAME]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_STATUS]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_TYPE]' role='dimension' type='nominal' />
<column-instance column='[CUSTOMER_COMPANY_NAME]' derivation='None' name='[none:CUSTOMER_COMPANY_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[DAYS_PAST_DUE_DATE_TIER]' derivation='None' name='[none:DAYS_PAST_DUE_DATE_TIER:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNTS_RECEIVABLE]' derivation='None' name='[none:IS_ACCOUNTS_RECEIVABLE:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[SUBSIDIARY_NAME]' derivation='None' name='[none:SUBSIDIARY_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_STATUS]' derivation='None' name='[none:TRANSACTION_STATUS:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_TYPE]' derivation='None' name='[none:TRANSACTION_TYPE:nk]' pivot='key' type='nominal' />
<column-instance column='[CONVERTED_AMOUNT]' derivation='Sum' name='[sum:CONVERTED_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CUSTOMER_COMPANY_NAME:nk]' filter-group='13'>
<groupfilter function='level-members' level='[none:CUSTOMER_COMPANY_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_RECEIVABLE:nk]' filter-group='9'>
<groupfilter function='member' level='[none:IS_ACCOUNTS_RECEIVABLE:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='12'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='10'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:SUBSIDIARY_NAME:nk]'>
<groupfilter function='level-members' level='[none:SUBSIDIARY_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]' filter-group='11'>
<groupfilter function='member' level='[none:TRANSACTION_STATUS:nk]' member='&quot;Open&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]' filter-group='15'>
<groupfilter function='union' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate'>
<groupfilter function='member' level='[none:TRANSACTION_TYPE:nk]' member='&quot;Credit Memo&quot;' />
<groupfilter function='member' level='[none:TRANSACTION_TYPE:nk]' member='&quot;Invoice&quot;' />
</groupfilter>
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_RECEIVABLE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CUSTOMER_COMPANY_NAME:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:SUBSIDIARY_NAME:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='cell'>
<format attr='width' value='201' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]' value='228' />
</style-rule>
<style-rule element='worksheet'>
<format attr='display-field-labels' scope='rows' value='false' />
<format attr='font-size' value='8' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Automatic' />
<encodings>
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
</style-rule>
<style-rule element='pane'>
<format attr='minwidth' value='-1' />
<format attr='maxwidth' value='-1' />
</style-rule>
</style>
</pane>
</panes>
<rows>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]</rows>
<cols />
</table>
<simple-id uuid='{2FF8A65A-B5BA-40EE-A532-A92D11F4D9D9}' />
</worksheet>
<worksheet name='Expense by Department'>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='real' name='[CONVERTED_AMOUNT]' role='measure' type='quantitative' />
<column datatype='string' name='[DEPARTMENT_NAME]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_EXPENSE_ACCOUNT]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='string' name='[PARENT_ACCOUNT_NAME]' role='dimension' type='nominal' />
<column datatype='datetime' name='[TRANSACTION_DATE]' role='dimension' type='ordinal' />
<column-instance column='[DEPARTMENT_NAME]' derivation='None' name='[none:DEPARTMENT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_EXPENSE_ACCOUNT]' derivation='None' name='[none:IS_EXPENSE_ACCOUNT:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[PARENT_ACCOUNT_NAME]' derivation='None' name='[none:PARENT_ACCOUNT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_DATE]' derivation='None' name='[none:TRANSACTION_DATE:qk]' pivot='key' type='quantitative' />
<column-instance column='[CONVERTED_AMOUNT]' derivation='Sum' name='[sum:CONVERTED_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]' filter-group='27'>
<groupfilter function='level-members' level='[none:DEPARTMENT_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<computed-sort column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]' direction='DESC' using='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='25'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_EXPENSE_ACCOUNT:nk]' filter-group='7'>
<groupfilter function='member' level='[none:IS_EXPENSE_ACCOUNT:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='23'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]' filter-group='26'>
<groupfilter function='level-members' level='[none:PARENT_ACCOUNT_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='quantitative' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_DATE:qk]' filter-group='24' included-values='in-range'>
<min>#2018-01-01 00:00:00#</min>
<max>#2018-12-30 16:00:00#</max>
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_EXPENSE_ACCOUNT:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_DATE:qk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='cell'>
<format attr='text-format' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' value='c&quot;$&quot;#,##0;(&quot;$&quot;#,##0)' />
<format attr='width' value='234' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]' value='232' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Bar' />
<encodings>
<size column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
</style-rule>
<style-rule element='pane'>
<format attr='minwidth' value='-1' />
<format attr='maxwidth' value='-1' />
</style-rule>
</style>
</pane>
</panes>
<rows>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]</rows>
<cols />
</table>
<simple-id uuid='{283A4ABE-B168-44D9-A92E-EE475A55FA7E}' />
</worksheet>
<worksheet name='Expense by Location'>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='real' name='[CONVERTED_AMOUNT]' role='measure' type='quantitative' />
<column datatype='string' name='[DEPARTMENT_NAME]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_EXPENSE_ACCOUNT]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='string' name='[LOCATION_NAME]' role='dimension' type='nominal' />
<column datatype='string' name='[PARENT_ACCOUNT_NAME]' role='dimension' type='nominal' />
<column datatype='datetime' name='[TRANSACTION_DATE]' role='dimension' type='ordinal' />
<column-instance column='[DEPARTMENT_NAME]' derivation='None' name='[none:DEPARTMENT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_EXPENSE_ACCOUNT]' derivation='None' name='[none:IS_EXPENSE_ACCOUNT:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[LOCATION_NAME]' derivation='None' name='[none:LOCATION_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[PARENT_ACCOUNT_NAME]' derivation='None' name='[none:PARENT_ACCOUNT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_DATE]' derivation='None' name='[none:TRANSACTION_DATE:qk]' pivot='key' type='quantitative' />
<column-instance column='[CONVERTED_AMOUNT]' derivation='Sum' name='[sum:CONVERTED_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]' filter-group='27'>
<groupfilter function='level-members' level='[none:DEPARTMENT_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='25'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_EXPENSE_ACCOUNT:nk]' filter-group='7'>
<groupfilter function='member' level='[none:IS_EXPENSE_ACCOUNT:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='23'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<computed-sort column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:LOCATION_NAME:nk]' direction='DESC' using='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]' filter-group='26'>
<groupfilter function='level-members' level='[none:PARENT_ACCOUNT_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='quantitative' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_DATE:qk]' filter-group='24' included-values='in-range'>
<min>#2018-01-01 00:00:00#</min>
<max>#2018-12-30 16:00:00#</max>
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_EXPENSE_ACCOUNT:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_DATE:qk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='cell'>
<format attr='text-format' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' value='c&quot;$&quot;#,##0;(&quot;$&quot;#,##0)' />
<format attr='width' value='222' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]' value='240' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:LOCATION_NAME:nk]' value='244' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Bar' />
<encodings>
<size column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
</style-rule>
<style-rule element='pane'>
<format attr='minwidth' value='-1' />
<format attr='maxwidth' value='-1' />
</style-rule>
</style>
</pane>
</panes>
<rows>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:LOCATION_NAME:nk]</rows>
<cols />
</table>
<simple-id uuid='{EEFDFEBB-FDDD-4580-B54A-6651B0D77DAD}' />
</worksheet>
<worksheet name='Expenses by Account'>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='real' name='[CONVERTED_AMOUNT]' role='measure' type='quantitative' />
<column datatype='string' name='[DEPARTMENT_NAME]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_EXPENSE_ACCOUNT]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='string' name='[PARENT_ACCOUNT_NAME]' role='dimension' type='nominal' />
<column datatype='datetime' name='[TRANSACTION_DATE]' role='dimension' type='ordinal' />
<column-instance column='[PARENT_ACCOUNT_NAME]' derivation='Attribute' name='[attr:PARENT_ACCOUNT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_DATE]' derivation='MY' name='[my:TRANSACTION_DATE:ok]' pivot='key' type='ordinal' />
<column-instance column='[DEPARTMENT_NAME]' derivation='None' name='[none:DEPARTMENT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_EXPENSE_ACCOUNT]' derivation='None' name='[none:IS_EXPENSE_ACCOUNT:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[PARENT_ACCOUNT_NAME]' derivation='None' name='[none:PARENT_ACCOUNT_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_DATE]' derivation='None' name='[none:TRANSACTION_DATE:qk]' pivot='key' type='quantitative' />
<column-instance column='[CONVERTED_AMOUNT]' derivation='Sum' name='[sum:CONVERTED_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]' filter-group='27'>
<groupfilter function='level-members' level='[none:DEPARTMENT_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='25'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_EXPENSE_ACCOUNT:nk]' filter-group='7'>
<groupfilter function='member' level='[none:IS_EXPENSE_ACCOUNT:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='23'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]' filter-group='26'>
<groupfilter function='level-members' level='[none:PARENT_ACCOUNT_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='quantitative' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_DATE:qk]' filter-group='24' included-values='in-range'>
<min>#2018-01-01 00:00:00#</min>
<max>#2018-12-30 16:00:00#</max>
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_EXPENSE_ACCOUNT:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_DATE:qk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DEPARTMENT_NAME:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='axis'>
<format attr='height' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]' value='21' />
<format attr='title' class='0' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' scope='rows' value='' />
</style-rule>
<style-rule element='cell'>
<format attr='text-format' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]' value='c&quot;$&quot;#,##0;(&quot;$&quot;#,##0)' />
<format attr='width' value='257' />
</style-rule>
<style-rule element='worksheet'>
<format attr='display-field-labels' scope='rows' value='false' />
<format attr='display-field-labels' scope='cols' value='false' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Bar' />
<encodings>
<color column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]' />
<tooltip column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[attr:PARENT_ACCOUNT_NAME:nk]' />
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:PARENT_ACCOUNT_NAME:nk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
<format attr='mark-labels-cull' value='true' />
</style-rule>
<style-rule element='pane'>
<format attr='minwidth' value='6682' />
<format attr='maxwidth' value='6682' />
<format attr='minheight' value='708' />
<format attr='maxheight' value='708' />
<format attr='aspect' value='0' />
</style-rule>
</style>
</pane>
</panes>
<rows>[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:CONVERTED_AMOUNT:qk]</rows>
<cols>[federated.1536j2w1odgej11h17r3l1ukn6qo].[my:TRANSACTION_DATE:ok]</cols>
</table>
<simple-id uuid='{320E3AF4-8810-4539-B5F4-B57B7EAFF61D}' />
</worksheet>
<worksheet name='Overdue BIlls'>
<layout-options>
<title>
<formatted-text>
<run bold='true' fontalignment='1' fontcolor='#000000'>&lt;Sheet Name&gt;</run>
</formatted-text>
</title>
</layout-options>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='string' name='[CURRENCY_SYMBOL]' role='dimension' type='nominal' />
<column datatype='string' name='[DAYS_PAST_DUE_DATE_TIER]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNTS_PAYABLE]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='real' name='[TRANSACTION_AMOUNT]' role='measure' type='quantitative' />
<column datatype='datetime' name='[TRANSACTION_DUE_DATE]' role='dimension' type='ordinal' />
<column datatype='string' name='[TRANSACTION_MEMO]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_STATUS]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_TYPE]' role='dimension' type='nominal' />
<column datatype='string' name='[VENDOR_NAME]' role='dimension' type='nominal' />
<column-instance column='[TRANSACTION_DUE_DATE]' derivation='MDY' name='[md:TRANSACTION_DUE_DATE:ok]' pivot='key' type='ordinal' />
<column-instance column='[CURRENCY_SYMBOL]' derivation='None' name='[none:CURRENCY_SYMBOL:nk]' pivot='key' type='nominal' />
<column-instance column='[DAYS_PAST_DUE_DATE_TIER]' derivation='None' name='[none:DAYS_PAST_DUE_DATE_TIER:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNTS_PAYABLE]' derivation='None' name='[none:IS_ACCOUNTS_PAYABLE:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_MEMO]' derivation='None' name='[none:TRANSACTION_MEMO:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_STATUS]' derivation='None' name='[none:TRANSACTION_STATUS:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_TYPE]' derivation='None' name='[none:TRANSACTION_TYPE:nk]' pivot='key' type='nominal' />
<column-instance column='[VENDOR_NAME]' derivation='None' name='[none:VENDOR_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_AMOUNT]' derivation='Sum' name='[sum:TRANSACTION_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]'>
<groupfilter function='union' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate'>
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 0.0 and &lt; 30.0&quot;' />
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 30.0 and &lt; 60.0&quot;' />
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 60.0 and &lt; 90.0&quot;' />
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 90.0&quot;' />
</groupfilter>
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_PAYABLE:nk]' filter-group='21'>
<groupfilter function='member' level='[none:IS_ACCOUNTS_PAYABLE:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='18'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='16'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]' filter-group='17'>
<groupfilter function='member' level='[none:TRANSACTION_STATUS:nk]' member='&quot;Open&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]' filter-group='20'>
<groupfilter function='member' level='[none:TRANSACTION_TYPE:nk]' member='&quot;Bill&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:VENDOR_NAME:nk]' filter-group='22'>
<groupfilter function='level-members' level='[none:VENDOR_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_PAYABLE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:VENDOR_NAME:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='cell'>
<format attr='width' value='196' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]' value='228' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:VENDOR_NAME:nk]' value='196' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_MEMO:nk]' value='280' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CURRENCY_SYMBOL:nk]' value='112' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[md:TRANSACTION_DUE_DATE:ok]' value='172' />
</style-rule>
<style-rule element='worksheet'>
<format attr='font-size' value='8' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Automatic' />
<encodings>
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:TRANSACTION_AMOUNT:qk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
</style-rule>
<style-rule element='pane'>
<format attr='minwidth' value='-1' />
<format attr='maxwidth' value='-1' />
</style-rule>
</style>
</pane>
</panes>
<rows>([federated.1536j2w1odgej11h17r3l1ukn6qo].[md:TRANSACTION_DUE_DATE:ok] / ([federated.1536j2w1odgej11h17r3l1ukn6qo].[none:VENDOR_NAME:nk] / ([federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_MEMO:nk] / [federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CURRENCY_SYMBOL:nk])))</rows>
<cols />
</table>
<simple-id uuid='{9735F660-9238-4DBE-82E5-0053A7B4E96F}' />
</worksheet>
<worksheet name='Overdue Invoices'>
<layout-options>
<title>
<formatted-text>
<run bold='true' fontalignment='1' fontcolor='#1b1b1b'>&lt;Sheet Name&gt;</run>
</formatted-text>
</title>
</layout-options>
<table>
<view>
<datasources>
<datasource caption='Transaction Details' name='federated.1536j2w1odgej11h17r3l1ukn6qo' />
</datasources>
<datasource-dependencies datasource='federated.1536j2w1odgej11h17r3l1ukn6qo'>
<column datatype='string' name='[CURRENCY_SYMBOL]' role='dimension' type='nominal' />
<column datatype='string' name='[CUSTOMER_COMPANY_NAME]' role='dimension' type='nominal' />
<column datatype='string' name='[DAYS_PAST_DUE_DATE_TIER]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNTS_RECEIVABLE]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_ACCOUNT_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='boolean' name='[IS_TRANSACTION_INTERCOMPANY]' role='dimension' type='nominal' />
<column datatype='real' name='[TRANSACTION_AMOUNT]' role='measure' type='quantitative' />
<column datatype='datetime' name='[TRANSACTION_DUE_DATE]' role='dimension' type='ordinal' />
<column datatype='string' name='[TRANSACTION_MEMO]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_STATUS]' role='dimension' type='nominal' />
<column datatype='string' name='[TRANSACTION_TYPE]' role='dimension' type='nominal' />
<column-instance column='[TRANSACTION_DUE_DATE]' derivation='MDY' name='[md:TRANSACTION_DUE_DATE:ok]' pivot='key' type='ordinal' />
<column-instance column='[CURRENCY_SYMBOL]' derivation='None' name='[none:CURRENCY_SYMBOL:nk]' pivot='key' type='nominal' />
<column-instance column='[CUSTOMER_COMPANY_NAME]' derivation='None' name='[none:CUSTOMER_COMPANY_NAME:nk]' pivot='key' type='nominal' />
<column-instance column='[DAYS_PAST_DUE_DATE_TIER]' derivation='None' name='[none:DAYS_PAST_DUE_DATE_TIER:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNTS_RECEIVABLE]' derivation='None' name='[none:IS_ACCOUNTS_RECEIVABLE:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_ACCOUNT_INTERCOMPANY]' derivation='None' name='[none:IS_ACCOUNT_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[IS_TRANSACTION_INTERCOMPANY]' derivation='None' name='[none:IS_TRANSACTION_INTERCOMPANY:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_MEMO]' derivation='None' name='[none:TRANSACTION_MEMO:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_STATUS]' derivation='None' name='[none:TRANSACTION_STATUS:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_TYPE]' derivation='None' name='[none:TRANSACTION_TYPE:nk]' pivot='key' type='nominal' />
<column-instance column='[TRANSACTION_AMOUNT]' derivation='Sum' name='[sum:TRANSACTION_AMOUNT:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<natural-sort column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[md:TRANSACTION_DUE_DATE:ok]' direction='DESC' />
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CUSTOMER_COMPANY_NAME:nk]' filter-group='13'>
<groupfilter function='level-members' level='[none:CUSTOMER_COMPANY_NAME:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]'>
<groupfilter function='union' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate'>
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 0.0 and &lt; 30.0&quot;' />
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 30.0 and &lt; 60.0&quot;' />
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 60.0 and &lt; 90.0&quot;' />
<groupfilter function='member' level='[none:DAYS_PAST_DUE_DATE_TIER:nk]' member='&quot;&gt;= 90.0&quot;' />
</groupfilter>
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_RECEIVABLE:nk]' filter-group='9'>
<groupfilter function='member' level='[none:IS_ACCOUNTS_RECEIVABLE:nk]' member='true' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]' filter-group='12'>
<groupfilter function='member' level='[none:IS_ACCOUNT_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]' filter-group='10'>
<groupfilter function='member' level='[none:IS_TRANSACTION_INTERCOMPANY:nk]' member='false' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]' filter-group='11'>
<groupfilter function='member' level='[none:TRANSACTION_STATUS:nk]' member='&quot;Open&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
</filter>
<filter class='categorical' column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]' filter-group='15'>
<groupfilter function='union' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate'>
<groupfilter function='member' level='[none:TRANSACTION_TYPE:nk]' member='&quot;Credit Memo&quot;' />
<groupfilter function='member' level='[none:TRANSACTION_TYPE:nk]' member='&quot;Invoice&quot;' />
</groupfilter>
</filter>
<slices>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNTS_RECEIVABLE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_TRANSACTION_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_STATUS:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:IS_ACCOUNT_INTERCOMPANY:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CUSTOMER_COMPANY_NAME:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_TYPE:nk]</column>
<column>[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='cell'>
<format attr='width' value='190' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:DAYS_PAST_DUE_DATE_TIER:nk]' value='228' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[md:TRANSACTION_DUE_DATE:ok]' value='200' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CUSTOMER_COMPANY_NAME:nk]' value='208' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:TRANSACTION_MEMO:nk]' value='256' />
<format attr='width' field='[federated.1536j2w1odgej11h17r3l1ukn6qo].[none:CURRENCY_SYMBOL:nk]' value='92' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Automatic' />
<encodings>
<lod column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:TRANSACTION_AMOUNT:qk]' />
<text column='[federated.1536j2w1odgej11h17r3l1ukn6qo].[sum:TRANSACTION_AMOUNT:qk]' />
</encodings>
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='true' />
</style-rule>
<style-rule element='pane'>