<CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="kstplcode<>''" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="kstplcode" fieldLevelType="0" title="Kostenplaats"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="kstplcode.oms25" fieldLevelType="0" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag" fieldLevelType="2" format="#,##0.00" title="Budget"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag-RealBedrag" fieldLevelType="2" format="#,##0.00" title="Verschil"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="RealBedrag" field2="BudgetBedrag" fieldLevelType="2" format="0%" title="%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable>

Sumatra_Package��N��Oj{��'��$K��ȏ��cc``cP��KI��wI,q��I�M-Iԫ��ab�Yp��{'AhA��܂b��#�!�Ǡ��Ă��b��C��<&��P�/��L�s~^Ibf^j� wC�܃�<��)�9��d�@�e��CJbIbn~Jj�~iqj��<�)�7�q�Ci�Jtrt��B��m÷c��r7pJ�n0U�fj� XƄ�H�1"�ŉ?(�p��0��"��~�rE��H�HiG�L �j��l�;c��˪�'�ؤ��Tb��bDx�~x�ǭ|�p��.LP��|�u��b�o�oڋRiy��d�\�Ӧ.[�>�F�˻ i7�p��BBIM��hOG�ؤ��c#x�،^X�.��U��E>��^�( 0505a __pkg_Budgetkostenplaa_aikpuz0dbzdk__pp__ This version of the Builder is no longer supported and cannot be used to open this file. Please update to version 5.1.8580 or later to open this file. This file was created with version 5.5.1355 of the Builder. Continuing will downgrade the file and may cause minor differences in functionality. Budget kostenplaats

LightPlusDark Placeholder 1 mod1 aUfLTCC/avnq8YfTbJ07Y5e0y6rlJxKDG9ikzPuSE6E= 540 2026-07-09T13:32:42.2638625Z https://licensejwt1.vault.azure.net/keys/ModuleStamping/9d40d28b9c73483bb45c07d9d85b9bfa Dkz2y/gpgjH4daUwQMINUuKBLM/MnO6+s/HSEFm0Ow1TkkKF+djamH6/k80YyLCxWDQc0Rd5gs0dGEZar4t1tff8y0BYRHGkgy6D374D1PT5HTAImO11FaqwwMdMdNLMVtAXoP6YitKkoGc+jKkprIy1Rbg8xBn/VbRJm1bTVUQLieIbeCVEWf+rHxD1jjIr0ZB1fwDIi4Vgqy1JNKhYGwrq+Io01439O15aArt/LhoFhz2oy7R4ZlG+fTEzIM5Fr3qY4ByP6WveMVd8gJYwcAsjwckbTpaxRfHEmTsw03R653X76lubXLXGrNhWjZ5uHJq5A/NIpIQS5nVS3HyqBw== ProdVer 5.5 Ver0505acolor5102, 207, 228color2138, 161, 219)colorTheme3IdisableExcelExport0iconid:30!presnameMBudget kostenplaatstouch2v 43v 54 �field!bkjrcodeflags0titleJaartype1�groupby!bkjrcodeorderby!bkjrcode9resetSelection0!selected�bkjrcode=SV_DEFAULTS__PKG__.JaartablePERDATtitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0�fieldperiodeflags8titlePeriodetype1�groupbyper_finorderbyper_fin9resetSelection0!selected%per_fin=1tablePERDATtitleper_finvalueper_finEvalueIsConstraint0�fieldPeriodeflags4title t/mtype1�groupbyper_finorderbyper_fin9resetSelection0!selectedUper_fin=MONTH(@TODAY)tablePERDATtitleper_finvalueper_finEvalueIsConstraint0�field%kstplcodeflags0title1Kostenplaatstype1�groupby%kstplcode-initialText)-- ALLE --orderby%kstplcode9resetSelection0tableKSTPLtitleUkstplcode+' - '+oms25value%kstplcodeEvalueIsConstraint0)expandTabs1v 52�)background)foregroundtitle1Kostenplaatsmode0-orientation-verticalBar5splitPosition 500mode0-orientation5horizontalBar5splitPosition 333* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint5kstplcode<>''=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�!Compress1)Constraint1Hidden05crossTreeType1field%kstplcode9fieldLevelType0=irr_Aggregation0title1Kostenplaats�footerheadermodeValues�footerheadermodeValues�Hidden05crossTreeType1field=kstplcode.oms259fieldLevelType0=irr_Aggregation0title1Omschrijving�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field1BudgetBedrag9fieldLevelType2format!#,##0.00titleBudget�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field]BudgetBedrag-RealBedrag9fieldLevelType2format!#,##0.00title!Verschil�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field)RealBedragfield21BudgetBedrag9fieldLevelType2format 0%title%�footerheadermodeValues�footerheadermodeValues)expandTabs1v 52�)background)foregroundtitleRubriek* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint5kstplcode<>''=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�!Compress1)Constraint1Hidden05crossTreeType1field!Class_049fieldLevelType0=irr_Aggregation0!sortType1titleRubriek�footerheadermodeValues�footerheadermodeValues� Hidden05crossTreeType1fielduClass_04@CLASS_04.Description9fieldLevelType0=irr_Aggregation0�footerheadermodeValues�footerheadermodeValues�!Compress1)Constraint1Hidden0%alignment25crossTreeType1fieldreknr9fieldLevelType0=irr_Aggregation0!sortType1title!Rekening%treeLevel1�footerheadermodeValues�footerheadermodeValues�Hidden05crossTreeType1field-reknr.oms259fieldLevelType0=irr_Aggregation0%treeLevel1�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field1BudgetBedrag9fieldLevelType2format!#,##0.00titleBudget�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field]BudgetBedrag-RealBedrag9fieldLevelType2format!#,##0.00title!Verschil�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field)RealBedragfield21BudgetBedrag9fieldLevelType2format 0%title%�footerheadermodeValues�footerheadermodeValues�)background)foregroundtitle-Leverancier* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintmcrdnr<>'' and kstplcode<>''=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�!Compress1)Constraint1Hidden0%alignment25crossTreeType1fieldcrdnr9fieldLevelType0=irr_Aggregation0title-Leverancier�footerheadermodeValues�footerheadermodeValues�Hidden05crossTreeType1field)crdnr.naam9fieldLevelType0=irr_Aggregation0titleNaam�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValuesx)linkTarget5BudgetDetailsv 50�namefiltervalue5kstplcode<>''�)background)foregroundtitle-Leveranciermode0-orientation-verticalBar5splitPosition 500mode0-orientation5horizontalBar5splitPosition 667* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintmcrdnr<>'' AND kstplcode<>''=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�!Compress1)Constraint1Hidden0%alignment25crossTreeType1fieldcrdnr9fieldLevelType0=irr_Aggregation0title-Leverancier�footerheadermodeValues�footerheadermodeValues�Hidden05crossTreeType1field)crdnr.naam9fieldLevelType0=irr_Aggregation0titleNaam�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValues* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint5kstplcode<>''=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�!Compress1)Constraint1Hidden0%alignment25crossTreeType1fieldreknr9fieldLevelType0=irr_Aggregation0!sortType1title!Rekening�footerheadermodeValues�footerheadermodeValues� Hidden05crossTreeType1field-reknr.oms259fieldLevelType0=irr_Aggregation0�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValuesx)linkTarget5BudgetDetailsv 50�namefiltervalue5kstplcode<>''�)background)foregroundtitleRubriekmode0-orientation-verticalBar5splitPosition 500* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint5kstplcode<>''=hideColOfTotals0)hideCorner1AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending11markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�!Compress1)Constraint1Hidden05crossTreeType1field!Class_049fieldLevelType0=irr_Aggregation0!sortType1titleRubriek�footerheadermodeValues�footerheadermodeValues� Hidden05crossTreeType1fielduClass_04@CLASS_04.Description9fieldLevelType0=irr_Aggregation0�footerheadermodeValues�footerheadermodeValues�!Compress1)Constraint1Hidden0%alignment25crossTreeType1fieldreknr9fieldLevelType0=irr_Aggregation0!sortType1title!Rekening%treeLevel1�footerheadermodeValues�footerheadermodeValues�Hidden05crossTreeType1field-reknr.oms259fieldLevelType0=irr_Aggregation0%treeLevel1�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field1BudgetBedrag9fieldLevelType2format!#,##0.00titleBudget�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field]BudgetBedrag-RealBedrag9fieldLevelType2format!#,##0.00title!Verschil�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field)RealBedragfield21BudgetBedrag9fieldLevelType2format 0%title%�footerheadermodeValues�footerheadermodeValuesvname5BudgetDetails�namefiltervalue5kstplcode<>''mode0-orientation5horizontalBar5splitPosition 333* )background-disableMenu0)foregroundmarkup0title]Budget vs Realisatie|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint!%filter%=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1 �!Compress1)Constraint1Hidden0%alignment25crossTreeType3fieldperiode9fieldLevelType0format#,##0=irr_Aggregation0!sortType1titlePeriode�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00title)Realisatie�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field1BudgetBedrag9fieldLevelType2format!#,##0.00titleBudget�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field]BudgetBedrag-RealBedrag9fieldLevelType2format!#,##0.00title!Verschil�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field)RealBedragfield21BudgetBedrag9fieldLevelType2format 0%title%�footerheadermodeValues�footerheadermodeValuesmode0-orientation5horizontalBar5splitPosition 500* )background-disableMenu0)foregroundmarkup0title)Details|||n4IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintiRealBedrag<>0 and %filter%=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru01queryHeaders0ArowLevelExpanded0QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tableMSV_BudgetMut__pkg__v 55)zebraLevel1�-Aggregation0Hidden05crossTreeType2fielddatum9fieldLevelType2format)d MMM yyyytitleDatum�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment25crossTreeType1fieldbkstnr9fieldLevelType2title!Boekstuk�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldoms259fieldLevelType2title1Omschrijving�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealBedrag9fieldLevelType2format!#,##0.00titleBedragkcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field)RealAantal9fieldLevelType2format!#,##0.00titleAantalkcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment25crossTreeType1fieldcrdnr9fieldLevelType2title%Crediteur�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field)crdnr.naam9fieldLevelType2titleNaam�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field%kstplcode9fieldLevelType2title1Kostenplaats�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field=kstplcode.oms259fieldLevelType2title1Omschrijving�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment25crossTreeType1fieldreknr9fieldLevelType2title!Rekening�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field-reknr.oms259fieldLevelType2title1Omschrijving�footerheadermodeValues�footerheadermodeValues�)Constraint1Hidden1field=DocAttachmentID9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1�-Aggregation0Hidden05crossTreeType1field�IIF(DocAttachmentID is null,'Nee','Ja')9fieldLevelType2title!Document�footerheadermodeValues�footerheadermodeValuesvname9MutatieDetails!presname9MutatieDetails)expandTabs1v 52�)background)foregroundtitleBijlage*)background)foregroundmarkup0titleBijlage!presname�Elimineer Binnenkomend Constraint�`-lookupField�{#name:DocAttachmentID#default:''}='' ? 0 :1 -lookupTable)SYS\$SRNF$�%condition0!presname1Geen Bijlagefield�'Geen Bijlage gekoppeld aan deze mutatie'table)SYS\$SRNF$ top0�%condition1!presname-Wel BijlageB=extraConstraintUID=#{DocAttachmentID}table=bacodiscussionsv4�)constraint1field hidfield!documenttable=bacodiscussionsv 51UwebclientAutoDownload0�!presname=Initieel schermfield ''table)SYS\$SRNF$ top0�)background)foregroundtitleBoeking* )background)foregroundmarkup0!presnameTitletitleIBoekstuk #{bkstnr}n8IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3comment'[Converted from Table on 14/04/2026 17:09:21] The following issues were encountered during conversion: - Positive or Negative will result in missing parameter values when value is suppressed.5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintw(transtype='N' or transtype='C') or (transtype='P' and transsubtype='N')=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru0!presnamegbkmut1queryHeaders0ArowLevelExpanded0QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style26tablegbkmutv 55)zebraLevel1�-Aggregation0Hidden0%alignment25crossTreeType1field!bkjrcode9fieldLevelType2titleJaar�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment25crossTreeType1fieldperiode9fieldLevelType2title Per�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment25crossTreeType1fieldreknr9fieldLevelType2titleReknr�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field-reknr.oms259fieldLevelType2titleNaam�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldoms259fieldLevelType2title1Omschrijving�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType2fielddatum9fieldLevelType2format)d MMM yyyytitleDatum�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(bdr_hfl < 0 , null , bdr_hfl)9fieldLevelType2format!#,##0.00titleDebetkcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(bdr_hfl >= 0 , null , -bdr_hfl)9fieldLevelType2format!#,##0.00titleCreditkcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field%docnumber9fieldLevelType2title5Uw referentie�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field�debnr is not null?debiteuren.debcode + ' - ' + debiteuren.naam:crediteuren.crdcode + ' - ' + crediteuren.naam9fieldLevelType2titleRelatie�footerheadermodeValues�footerheadermodeValues�)background)foregroundtitleNotitie*)background)foregroundmarkup0titleNotitie!presname�Elimineer Binnenkomend Constraint�`-lookupField�{#name:DocumentID#default:''}='' ? 0 :1 -lookupTable)SYS\$SRNF$�%condition0!presname5Geen Notitiesfield�'Geen Notities gekoppeld aan deze mutatie'table)SYS\$SRNF$ top0�%condition1!presname1Wel NotitiesB=extraConstraintAID=#{DocumentID}table=bacodiscussionsv4�)constraint1field hid!presnameIVerwijderen quotes�from'field!documenttable=bacodiscussionsv 51UwebclientAutoDownload0�!presname=Initieel schermfield ''table)SYS\$SRNF$ top0+; Version: 5.5.1355 View created by Sumatra Software B.V. <CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="kstplcode<>''" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="kstplcode" fieldLevelType="0" title="Kostenplaats"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="kstplcode.oms25" fieldLevelType="0" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag" fieldLevelType="2" format="#,##0.00" title="Budget"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag-RealBedrag" fieldLevelType="2" format="#,##0.00" title="Verschil"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="RealBedrag" field2="BudgetBedrag" fieldLevelType="2" format="0%" title="%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="kstplcode<>''" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="Class_04" fieldLevelType="0" sortType="1" title="Rubriek"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="Class_04@CLASS_04.Description" fieldLevelType="0"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" alignment="2" crossTreeType="1" field="reknr" fieldLevelType="0" sortType="1" title="Rekening" treeLevel="1"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="reknr.oms25" fieldLevelType="0" treeLevel="1"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag" fieldLevelType="2" format="#,##0.00" title="Budget"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag-RealBedrag" fieldLevelType="2" format="#,##0.00" title="Verschil"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="RealBedrag" field2="BudgetBedrag" fieldLevelType="2" format="0%" title="%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="crdnr<>'' and kstplcode<>''" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" alignment="2" crossTreeType="1" field="crdnr" fieldLevelType="0" title="Leverancier"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="crdnr.naam" fieldLevelType="0" title="Naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="crdnr<>'' AND kstplcode<>''" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" alignment="2" crossTreeType="1" field="crdnr" fieldLevelType="0" title="Leverancier"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="crdnr.naam" fieldLevelType="0" title="Naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="kstplcode<>''" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" alignment="2" crossTreeType="1" field="reknr" fieldLevelType="0" sortType="1" title="Rekening"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="reknr.oms25" fieldLevelType="0"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="kstplcode<>''" hideColOfTotals="0" hideCorner="1" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="1" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="Class_04" fieldLevelType="0" sortType="1" title="Rubriek"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="Class_04@CLASS_04.Description" fieldLevelType="0"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" alignment="2" crossTreeType="1" field="reknr" fieldLevelType="0" sortType="1" title="Rekening" treeLevel="1"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="0" crossTreeType="1" field="reknr.oms25" fieldLevelType="0" treeLevel="1"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag" fieldLevelType="2" format="#,##0.00" title="Budget"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag-RealBedrag" fieldLevelType="2" format="#,##0.00" title="Verschil"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="RealBedrag" field2="BudgetBedrag" fieldLevelType="2" format="0%" title="%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="%filter%" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" alignment="2" crossTreeType="3" field="periode" fieldLevelType="0" format="#,##0" sortType="1" title="Periode"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Realisatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag" fieldLevelType="2" format="#,##0.00" title="Budget"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="BudgetBedrag-RealBedrag" fieldLevelType="2" format="#,##0.00" title="Verschil"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="RealBedrag" field2="BudgetBedrag" fieldLevelType="2" format="0%" title="%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="RealBedrag<>0 and %filter%" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="0" queryHeaders="0" rowLevelExpanded="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="SV_BudgetMut__pkg__" v="55" zebraLevel="1"><CrossTableField Aggregation="0" Hidden="0" crossTreeType="2" field="datum" fieldLevelType="2" format="d MMM yyyy" title="Datum"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="2" crossTreeType="1" field="bkstnr" fieldLevelType="2" title="Boekstuk"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="oms25" fieldLevelType="2" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealBedrag" fieldLevelType="2" format="#,##0.00" title="Bedrag"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="RealAantal" fieldLevelType="2" format="#,##0.00" title="Aantal"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="2" crossTreeType="1" field="crdnr" fieldLevelType="2" title="Crediteur"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="crdnr.naam" fieldLevelType="2" title="Naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="kstplcode" fieldLevelType="2" title="Kostenplaats"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="kstplcode.oms25" fieldLevelType="2" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="2" crossTreeType="1" field="reknr" fieldLevelType="2" title="Rekening"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="reknr.oms25" fieldLevelType="2" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Constraint="1" Hidden="1" irr_crossTreeType="1" field="DocAttachmentID" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="IIF(DocAttachmentID is null,'Nee','Ja')" fieldLevelType="2" title="Document"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><Translator presname="Elimineer Binnenkomend Constraint"><FromTo /><LookupFilterDeck lookupField="{#name:DocAttachmentID#default:''}='' ? 0 :1 " lookupTable="SYS\$SRNF$"><filter condition="0" presname="Geen Bijlage"><NotitiePage field="'Geen Bijlage gekoppeld aan deze mutatie'" table="SYS\$SRNF$" top="0" /></filter><filter condition="1" presname="Wel Bijlage"><LookupTranslator extraConstraint="ID=#{DocAttachmentID}" table="bacodiscussions" v="4"><LookupTranslatorField constraint="1" field="hid" /><ImagePanel field="document" table="bacodiscussions" v="51" webclientAutoDownload="0" /></LookupTranslator></filter><filter presname="Initieel scherm"><NotitiePage field="''" table="SYS\$SRNF$" top="0" /></filter></LookupFilterDeck></Translator><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 14/04/2026 17:09:21] The following issues were encountered during conversion: - Positive or Negative will result in missing parameter values when value is suppressed." depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(transtype='N' or transtype='C') or (transtype='P' and transsubtype='N')" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="0" presname="gbkmut" queryHeaders="0" rowLevelExpanded="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="6" table="gbkmut" v="55" zebraLevel="1"><CrossTableField Aggregation="0" Hidden="0" alignment="2" crossTreeType="1" field="bkjrcode" fieldLevelType="2" title="Jaar"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="2" crossTreeType="1" field="periode" fieldLevelType="2" title="Per"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="2" crossTreeType="1" field="reknr" fieldLevelType="2" title="Reknr"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="reknr.oms25" fieldLevelType="2" title="Naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="oms25" fieldLevelType="2" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="2" field="datum" fieldLevelType="2" format="d MMM yyyy" title="Datum"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(bdr_hfl < 0 , null , bdr_hfl)" fieldLevelType="2" format="#,##0.00" title="Debet"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(bdr_hfl >= 0 , null , -bdr_hfl)" fieldLevelType="2" format="#,##0.00" title="Credit"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="docnumber" fieldLevelType="2" title="Uw referentie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="debnr is not null?debiteuren.debcode + ' - ' + debiteuren.naam:crediteuren.crdcode + ' - ' + crediteuren.naam" fieldLevelType="2" title="Relatie"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><Translator presname="Elimineer Binnenkomend Constraint"><FromTo /><LookupFilterDeck lookupField="{#name:DocumentID#default:''}='' ? 0 :1 " lookupTable="SYS\$SRNF$"><filter condition="0" presname="Geen Notities"><NotitiePage field="'Geen Notities gekoppeld aan deze mutatie'" table="SYS\$SRNF$" top="0" /></filter><filter condition="1" presname="Wel Notities"><LookupTranslator extraConstraint="ID=#{DocumentID}" table="bacodiscussions" v="4"><LookupTranslatorField constraint="1" field="hid" /><Translator presname="Verwijderen quotes"><FromTo from="'" /><ImagePanel field="document" table="bacodiscussions" v="51" webclientAutoDownload="0" /></Translator></LookupTranslator></filter><filter presname="Initieel scherm"><NotitiePage field="''" table="SYS\$SRNF$" top="0" /></filter></LookupFilterDeck></Translator> select YEAR(GetDate()) Jaar, MONTH(GetDate()) maand, GetDate() vandaag,'Boekdatum' BalansType,0.7 LogABC_A_perc,0.2 LogABC_B_perc,0.1 LogABC_C_perc SELECT 'Boekdatum' AdmStelsel UNION ALL SELECT 'Rapportagedatum' select --- SELECTIE VELDEN g.bkjrcode ,periode ,datum ,g.reknr ,g.kstplcode ,g.kstdrcode ,g.project ,gb.Class_04 ,g.crdnr --- RESULTAAT VELDEN ,g.aantal ,g.bdr_hfl ,CASE WHEN transtype='B' THEN bdr_hfl ELSE 0.00 END BudgetBedrag ,CASE WHEN transtype='B' THEN aantal ELSE 0.00 END BudgetAantal ,CASE WHEN transtype<>'B' THEN bdr_hfl ELSE 0.00 END RealBedrag ,CASE WHEN transtype<>'B' THEN aantal ELSE 0.00 END RealAantal --- DETAIL VELDEN ,g.bkstnr ,g.bkstnr_sub ordernr ,g.oms25 ,g.DocAttachmentID ,g.id -- DOORPUNTEN NAAR HET GBKMUT from gbkmut g INNER JOIN grtbk gb on gb.reknr=g.reknr LEFT JOIN items i on i.itemcode=g.artcode -- where g.transtype in ('N','C','P','B') AND gb.bal_vw='W' -- ALLEEN W&V REKENINGEN --AND gb.class_02<>'021' -- UITSLUITEN MARGE REKENINGEN AND (bud_vers is null or bud_vers='BEGROTIN') reknr kstplcode kstdrcode project crdnr reknr kstdrcode reknr kstplcode crdnr bkstnr ordernr ID