Is het mogelijk om deze view toe te voegen aan de Minox-driver:
create or replace view TransactionLinesAll
as
select fyr.administration_code
, fyr.fiscal_year
, clr.month_number fiscal_period
, tle.*
--
-- Workaround bug https://forums.invantive.com/t/minox-fiscalyears-bevat-carthesisch-product-van-alle-administraties-en-jaren/3669
--
from ( select *
from Minox.MasterDataAdministration.FiscalYears
where administration_name like '%-' || name
) fyr
join Calendar@DataDictionary clr
on clr.year_number = fyr.fiscal_year
and clr.day_in_month = 1
and clr.month_number between 1 and fyr.number_of_periods
join Minox.FinancialTransactionLines.TransactionLinesByFiscalYearPeriod(fiscal_year => fyr.fiscal_year, period => clr.month_number) tle