Sumatra_Package ]E jY&gHQ!; cc``cPKIwI,qIM-Iԫab7~\ 0Z2$1eDFˡ(
K,(/)O1Kcb`0 y%yE'L< )90Z!%$17?%5G8d
ém 6 ˻hc'nG[xX?ᾴ|uIѤ q>w[ef@gE:??mm_ " J, -+Px$_:vW ȗ,wjTaďQD41|( M >! >! k F~ @
:肛& 6 KG1 Vk vF'zK\ kL=e乃"Sǽ DC
0505a
__pkg_Klanten11_rkwbjfg9ao1s__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.1367 of the Builder.
Continuing will downgrade the file and may cause minor differences in functionality.
Klanten uitgebreid
LightPlusDark
Placeholder
1
mod0
SuYsmMnyqLnMHu0XGy0rUMV4rovLJF864rzSdtjw7Vc=
1080
2026-10-11T13:43:37.5326492Z
https://licensejwt1.vault.azure.net/keys/ModuleStamping/9d40d28b9c73483bb45c07d9d85b9bfa
ECwZnt4Swy3i3mE+hxs5Uz20ZA6vLTz9fIb7HG1Wuta36EAWrcjbVVMQJXxt7hwmcaXDX1Lo7plxaxLI/HB/olwpUReGjHUPCeNsiR8UmqenjG4435K8gxGNYCMyzittv6CMlM7nJw8Rk9pTSi0xxxyXNATv66oksMC2PawRPSvXjyxVv/ZV9+lpAQLMluR/21t/TIcoUw1izIAzm4upEEfF3GY5AF/nYNy5H11OqrhSsBwJYb2wpOqIaIpuM+zLD5AXf6X74iwf3MEgiLBO3aNQBuVRt9vGJ/kxTVcMLUiIWUazQqDwaI/kRvuP/vstQWX43PhUPezaOoVi3jL4Bg==
ProdVer
5.5
Ver0505acolor5113, 188, 158color2180, 186, 144)colorTheme3IdisableExcelExport0iconid:14!presnameIKlanten uitgebreid tooltipOverzichten met betrekking tot klantenv 43%hideClear1!presname)Debiteurenv 54
field debcodeflags1024-placeholder1!presname Debcodesize7title Debcodetype1 field!cmp_nameflags1024-placeholder1!presname)Naam bevatsize 20title)Naam bevattype1 field%cmp_fcityflags1024-placeholder1!presname1Plaats bevatsize 15title1Plaats bevattype1
field cmp_telflags1024-placeholder1title!Telefoontype1 mode0-orientation-verticalBar!presname)Debiteuren5splitPosition
300vname%Deb_lijstnameLabel2valueKlant nameLabelvalue Klanten *)background)foregroundmarkup0title %Label%|||{#name:debcode#prefix:Debcode #postfix: } {#name:cmp_name#prefix:Naam bevat #postfix: }{#name:cmp_fcity#prefix:Plaats bevat #postfix: }IdisableExcelExport0=extraConstraintdebcode is not null and cmp_type<>'E'!presnamecicmpysortBy debcodetablecicmpy
top0v 54
-Aggregation0field debcode!presname!Debiteurtitle!%Label2%type4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!cmp_name!presnameNaamtitleNaamtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field cmp_fpc!presname!Postcodetitle!Postcodetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%cmp_fcity!presnamePlaatstitlePlaatstype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0)Constraint1Hidden1fielddebnr!presname9Debiteurnummertitle9Debiteurnummertype4footerheadermodeValues!presname)background footerheadermodeValues *
)background-disableMenu0)foregroundmarkup0title#{debcode} {#name:cmp_name#prefix: - } )expandTabs1v 52 )background)foregroundtitleStatusmode0-orientation5horizontalBar5splitPosition
500*
)background-disableMenu0)foregroundmarkup0title#{debcode} {#name:cmp_name#prefix: - }V columns1v 50 B
ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__
top1v7fieldjaar field5Jaar-1 as Jr1 fieldmaand |=extraConstraint(boekjr=#{jaar} OR boekjr=#{Jr1}) AND periode<=#{maand}namecOMZET1passIncoming1rowNum0tableMSV_OmzetFact__pkg__
top0v 51{!Compress1fieldboekjr {!Compress1field artcode {fieldartcode@artbst.oms30 Description {!Compress1field periode {fieldomzet {!Compress1fielddebnr V columns 30v 50 colspan8*
)background-disableMenu0)foregroundmarkup0titleOmzet #{jaar} {#name:Maand#prefix: t/m maand }V columns 10)syncPanels1v 50 colspan 10MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan 10V columns 10)syncPanels1v 50 colspan2MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan6=clickConstraint9debnr=#{debnr} commentQ content{#name:ODJ#format:##,####0}!fontsize4MhorizontalAlignment11marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table :cOMZETEverticalAlignment1fieldsum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ fieldsum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan2MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan 10V columns 10)syncPanels1v 50
colspan3MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 content#{icon}MhorizontalAlignment01marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table :cOMZETEverticalAlignment2 fieldsum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ fieldsum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ fieldA#ODJ-#OVJ as vrs fieldiif(#vrs > 0, ' ▲ ' , ' ▼ ') as icon fieldiif(#vrs >= 0, '#50BA90' , '#FF2B38') as fc color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan2 content{#name:vp#postfix:%#format:0.0}MhorizontalAlignment21marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table :cOMZETEverticalAlignment2
fieldsum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ fieldsum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ fieldA#ODJ-#OVJ as vrs fieldiif(#OVJ=0,100,((#vrs/#OVJ)*100)) as vp color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan3MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan 10MhorizontalAlignment01passIncoming1EverticalAlignment0 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan8* )background-disableMenu0)foreground-lookupTable$SRNF$markup0title}Omzet per maand #{Jr} tov #{VJ}!Compress0field1#{Jr1} as VJmarkup0 !Compress0field5#{jaar} as Jrmarkup0 !Compress1legend19legendOverPlot1!passthru11queryHeaders1table :cOMZETv 50)yAxisTitle 'Omzet'field periodetype -1 fieldIIF(boekjr=#{jaar},omzet, 0.0) as ODJ%graphType5titley{#name:jaar#init:YEAR(@today)} fieldIIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OVJ%graphType4marker1title{#name:jaar#init:YEAR(@today)}-1 color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 colspan 14*
)background-disableMenu0)foregroundmarkup0titleTop 25 achterblijvende omzet {#name:jaar}{#name:maand#prefix: t/m maand }n2IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0!fontsize2=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0sortBy%SUM(#vrs)style3style22table :cOMZET
top 25v 55-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1field artcode9fieldLevelType2title%'Artikel'footerheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field-Description9fieldLevelType2title'Naam'footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF(boekjr=#{jaar},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor footerheadermodeValues footerheadermodeValues
Hidden1fieldIIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1 -Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth
100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54 footerheadermodeValues footerheadermodeValues -Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title
'%'footerheadermodeValues footerheadermodeValues
Hidden1fieldemax(#{maand} ) as periode9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1 V columns 30v 50 colspan 16*
)background-disableMenu0)foregroundmarkup0title-Orderintake!Compress1=extraConstraint (YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)=CAST(#{year} as INT)-2)tableMSV_OmzetFact__pkg__v 50fieldCAST(boekjr as VARCHAR) + '-' + periodetype1 fieldomzet%graphType7titleomzet color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 %conditionI(IIF(YEAR(orddat)=B
ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__
top1v7field9Jaar as {year} fieldU#{periode} as {month} fromwIIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,orddat,DATEADD(YY,+1,orddat))= toIIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,orddat,DATEADD(YY,+1,orddat))<= *
)background-disableMenu0)foregroundmarkup0title-Orderintaken.IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint (YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat) 0!fontsize2!passthru1!presname-Open postentabledbopen
top0v 54 -Aggregation0)Constraint1fieldbkstnr!presname!Boekstuktitle!Boekstuktype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)vervdatfakformat)d MMM yyyy!presname-Vervaldatumtitle-Vervaldatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field)bdr_na_bknformat!#,##0.00!presname)Openstaandtitle)Openstaandtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldE@today-vervdatfak!presname Te laattitle Te laattype4
fieldE@today-vervdatfakfooterheadermodeValues!presname)backgroundcolorWhite!presname)ColorValuevalue0 color
Red!presname)ColorValuevalue
100 footerheadermodeValues . )background)foregroundtitle!Algemeenvname Deb_alg )expandTabs1v 52)background)foregroundtitle!AlgemeenBtablecicmpyv4)constraint1field cmp_wwn mode2-orientation5horizontalBar!presname!Splitter5splitPosition
500*)background)foregroundmarkup0titleAlgemeen|||#{debcode} - #{cmp_name}!presname!Debiteurtablecicmpyv 43, Last0digits 10field debcode!presname!Debiteurtitle!Debiteurtype1 Last1digits1field}cmp_status='B'?"Geblokkeerd":""format 00!presname1Geblokkeerd?type9 Last0digits 32field!cmp_name!presnameNaamtitleNaamtype1 Last1digits 20fieldClassificationId+' '+ClassificationId.ml_desc!presname%Categorietitle%Categorietype1 Last0digits 32field%cmp_fadd1!presnameAdrestitleAdrestype1 Last1digits 20fieldcmp_type+' '+('cicmpy':'cmp_type':cmp_type)@ddtests.description!presnameTypetitleTypetype1 Last1digits 32field%cmp_fadd2!presname title type1 Last0digits 30fieldUcmp_fpc+' '+cmp_fcity!presname)Woonplaatstitle)Woonplaatstype1 Last1digits 20fieldycmp_fctry+' '+ cmp_fctry.oms60!presnameLandtitleLandtype1 Last0digits 15field cmp_tel!presname!Telefoontitle!Telefoontype1 Last1digits 15field5InvoiceDebtor!presname)Factuurdebtitle)Factuurdebtype1 Last0digits 15fieldGBankAccountNumber@BNKACC.IBAN<>'' ? BankAccountNumber@BNKACC.IBAN : BankAccountNumber!presname Bankrektitle Bankrektype1 Last1digits 10field)CreditLine!presname5Kredietlimiettitle5Kredietlimiettype1 Last1digits5field!Discount!presnameKort%titleKort%type1 Last0digits 15fieldQcmp_acc_man.fullname!presname%Vertegenwtitle%Vertegenwtype1 Last1digits3field!Currency!presnameValutatitleValutatype1 Last0digits 30fielduPriceList+' '+PriceList.oms30!presname)Prijslijsttitle)Prijslijsttype1 Last1digits 20fieldPaymentCondition+' '+PaymentCondition.oms30!presname1Bet.conditietitle1Bet.conditietype1
fieldcmp_e_mail<>''?'mailto:'+cmp_e_mail:''!irr_Last0)irr_digits0!presnameALink naar e-mailtype 12 Last1digits 40field)cmp_e_mail!presname1e-mail adrestitle1e-mail adrestype1 fieldcmp_web<>''?(charindex('://',cmp_web)=0?'//'+cmp_web:cmp_web):''!irr_Last0)irr_digits0!presnameELink naar Websitetitle_newtype 12 Last0digits 40field cmp_web!presname Websitetitle Websitetype1 )expandTabs1!presname!Notebookv 52)background)foregroundtitle=Contactpersonenmode0-orientation5horizontalBar!presname!Splitter5splitPosition
500*)background)foregroundmarkup0titleContactpersonen|||#{debcode} - #{cmp_name}
IdisableExcelExport0!presnameTabletableCICNTP
top0v 54-Aggregation0)Constraint1Hidden1fieldcnt_id!presname IDtitle IDtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!Predcode!presnameTiteltitleTiteltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!Initials!presname-Voorletterstitle%Initialentype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!FullName!presnameNaamtitleNaamtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldGender!presname!Geslachttitle
M/Vtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1cnt_job_desc!presnameMFunctieomschrijvingtitle Functietype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%cnt_f_tel!presname!Telefoontitle!Telefoontype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1cnt_f_mobile!presnameAMobiele telefoontitleMobieltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0Hidden1fieldcnt_email<>''?'mailto:'+cnt_email:''!presnameALink naar e-mailtype 12footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%cnt_email!presnameE-mailtitleE-mailtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!active_y!presnameActieftitleActieftype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fielducnt_id=cmp_wwn.cnt_id?'J':'N'!presnameHoofdtitleHoofdtype1footerheadermodeValues!presname)background footerheadermodeValues )expandTabs1!presname!Notebookv 52)background)foregroundtitle!Adressen fromcnt_id to5contactperson *
)background)foregroundmarkup0!presnameTitletitleYAdressen|||#{FullName}
IdisableExcelExport0!presnameTabletable%addresses
top0v 54
-Aggregation0fieldType!presnameTypetitleTypetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1AddressLine1!presname1Adresregel 1title1Adresregel 1type1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!PostCode!presname!Postcodetitle!Postcodetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldCity!presnamePlaatstitlePlaatstype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field Country!presname!Landcodetitle!Landcodetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldMain!presnameHoofdtitleHoofdtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field=KeepSameAsVisit!presnameAKopie Bezoekadr.titleAKopie Bezoekadr.type1footerheadermodeValues!presname)background footerheadermodeValues )background)foregroundtitle5Visitekaartje*)background)foregroundmarkup0titlemVisitekaartje|||#{FullName}
field picture!presname Picturetablecicntpv 51UwebclientAutoDownload0 )background)foregroundtitle!Adressen*)background)foregroundmarkup0titleHoofdadressen|||#{debcode} - #{cmp_name}!presname)Translatorfrom cmp_wwn to Account IdisableExcelExport0=extraConstraint!main='J'!presnameTabletable%addresses
top0v 54
-Aggregation0fieldType!presnameTypetitleTypetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1AddressLine1!presname1Adresregel 1title1Adresregel 1type1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1AddressLine2!presname1Adresregel 2title1Adresregel 2type1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field!PostCode!presname!Postcodetitle!Postcodetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldCity!presnamePlaatstitlePlaatstype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field Country!presname!Landcodetitle!Landcodetype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldYContactPerson.FullName!presname Contacttitle9Contactpersoontype1footerheadermodeValues!presname)background footerheadermodeValues )background)foregroundtitle!Notities*)background)foregroundmarkup0titleNotities|||#{debcode} - #{cmp_name}field!cmp_note!presname!Notitiestablecicmpy
top0 )background)foregroundtitle5BTW/IntrastatBtablecicmpyv4)constraint1fielddebnr *)background)foregroundmarkup0titleBTW/Intrastat |||#{debcode} - #{cmp_name}!presname
BTWtable)debbtwinfov 52 Last1digits 20field)btw_nummer!presname)DataColumntitle)BTW Nummertype1 Last1digits8field%datumctrlformat)d MMM yyyy!presname)DataColumntitle5Controledatumtype2 Last1digits 30fieldufactorcode+' '+factorcode_oms!presname)DataColumntitleMStatistische factortype1 Last0digits 30fieldebtwtrans+' '+btwtrans_oms!presname)DataColumntitle9BTW transactietype1 Last1digits1field%wijz_btwt!presname)DataColumntitleEBTW trans wijzig.type8 Last0digits 30fieldUlandcode+' '+land_oms!presname)DataColumntitle!Landcodetype1 Last1digits1field%wijz_herk!presname)DataColumntitleEHerkomst wijzigb.type8 Last0digits 30fieldetransact+' '+transact_oms!presname)DataColumntitle9CBS transactietype1 Last1digits1field!wijz_trs!presname)DataColumntitle9Trans wijzigb.type8 Last0digits 30field]stelsel+' '+stelsel_oms!presname)DataColumntitleMStatistisch stelseltype1 Last1digits1field%wijz_stel!presname)DataColumntitleAStelsel wijzigb.type8 Last0digits 30field]vervoer+' '+vervoer_oms!presname)DataColumntitle5Vervoerswijzetype1 Last1digits1field%wijz_verv!presname)DataColumntitleAVervoer wijzigb.type8 Last0digits 30field]plts_ll+' '+plts_ll_oms!presname)DataColumntitleMPlaats laden/lossentype4 Last1digits1field wijz_ll!presname)DataColumntitleQLaden/lossen wijzig.type8 )background)foregroundtitle-Google Maps*)background)foregroundmarkup0title7Google Maps (Internetverbinding benodigd)|||#{debcode} - #{cmp_name} field'https://maps.google.nl/maps?q='+cmp_fadd1+',+'+cmp_fcity+'&output=embed'!presname Pictureshrink1tablecicmpyv 51UwebclientAutoDownload0 )background)foregroundtitle Website* )background)foregroundAlookupConstraint9debnr=#{debnr}-lookupTablecicmpymarkup0titleWebsite #{cmp_web}|||#{debcode} - #{cmp_name}!Compress0field cmp_webmarkup0!presname website
field7cmp_web is null?'':(charindex('://',cmp_web)=0?'//'+cmp_web:cmp_web)!presnameFiguurtablecicmpyv 51UwebclientAutoDownload0 )background)foregroundtitle)Financieelvname Deb_fin )expandTabs1v 52)background)foregroundtitleIOpenstaande postenmode0-orientation5horizontalBar!presname!Splitter5splitPosition
350*)background)foregroundmarkup0titleOpenstaande posten |||#{debcode} - #{cmp_name}IdisableExcelExport0=extraConstraint=bdr_na_bkn <> 0!passthru1!presname-Open postentabledbopen
top0v 54 -Aggregation0)Constraint1fieldbkstnr!presname!Boekstuktitle!Boekstuktype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)vervdatfakformat)d MMM yyyy!presname-Vervaldatumtitle-Vervaldatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field)bdr_na_bknformat!#,##0.00!presname)Openstaandtitle)Openstaandtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)val_na_bknformat!#,##0.00!presname9Openstaand valtitle9Openstaand valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field%oorsprbdrformat!#,##0.00!presname9Oorspronkelijktitle9Oorspronkelijktype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldE@today-vervdatfak!presname Te laattitle Te laattype4
fieldE@today-vervdatfakfooterheadermodeValues!presname)backgroundcolorWhite!presname)ColorValuevalue0 color
Red!presname)ColorValuevalue
100 footerheadermodeValues )expandTabs1!presname!Notebookv 52)background)foregroundtitle!Document!presname!Vertalerfrom bkstnr= to OurRef= from debnr=% to!type=14) from9bkstnr is null to
1=2 *)background)foreground-lookupTable=bacodiscussionsIlookupUseIncomming1markup0!presname!DocumenttitleqDocument #{HID} - #{Subject}!Compress0field
HIDmarkup0 !Compress0field Subjectmarkup0 !presname!Vertalerfrom bkstnr= to OurRef= from debnr=% to!type=14) from9bkstnr is null to
1=2 field!document!presname Pictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0 )background)foregroundtitle!Notities!presname Notitiefrom bkstnr= to)faktuurnr= from9bkstnr is null to
1=2 *
)background)foregroundmarkup0!presname!NotitiestitleINotities #{bkstnr}!presname Notitiefrom bkstnr= to)faktuurnr= from9bkstnr is null to
1=2 B=extraConstraintYdocumentid is not nulltablegbkmutv4)constraint1field)documentid from-documentid= to
id= fieldbodytable=bacodiscussions
top0 )background)foregroundtitle=Factuurgegevens from bkstnr= tofaknr= fromdebnr= to
0<> from9bkstnr is null to
1=2 mode2-orientation5horizontalBar!presname!Splitter5splitPosition
200*)background)foregroundmarkup0titleFactuurgegevens factuur #{bkstnr}
IdisableExcelExport0!presnameTabletablefrhkrg
top0v 54 -Aggregation0fieldfakdatformat)d MMM yyyy!presname1Factuurdatumtitle1Factuurdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldrefer!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldUrepresent_id.fullname!presnameEVertegenwoordigertitleEVertegenwoordigertype1footerheadermodeValues!presname)background footerheadermodeValues vnameYFactuurhistoriedetailsmode2-orientation-verticalBar!presname!Verdeler5splitPosition
800*)background)foregroundmarkup0titleYFactuurregels #{faknr} IdisableExcelExport0!presnameorsrxsortByregeltablefrhsrx
top0v 54"-Aggregation0fieldregeltitle R.type4footerheadermodeValues footerheadermodeValues
-Aggregation0field artcode!presname Artikeltitle Artikeltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms45!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field!unitcodetitle Eenheidtype1footerheadermodeValues footerheadermodeValues
-Aggregation0fieldUesr_aantal/unitfactorformat#,##0title1Aantal Eenh.type6footerheadermodeValues footerheadermodeValues -Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitle5Aantal Vk.Vp.type6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldbtw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldbtw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6footerheadermodeValues footerheadermodeValues -Aggregation0field=ordernr.valcodetitleVal.type1footerheadermodeValues footerheadermodeValues -Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presnameBedragtitle)Bedrag Valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation1fieldesr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleBedragtype6footerheadermodeValues footerheadermodeValues -Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field magcode!presname
Magtitle
Magtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldres_id.fullname + ' (' + res_id + ')'title)Medewerkertype1footerheadermodeValues footerheadermodeValues mode0-orientation5horizontalBar!presname)Documenten5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleUGekoppelde documenten!presname)Translatorfromfaknr toOurRef from!dagbknr= to 'xyz'<> from fakdat= to 'xyz'<>
IdisableExcelExport0!presnameTabletable=bacodiscussions
top0v 54
-Aggregation0)Constraint1field
HIDformat#,##0!presname
HIDtitleNummertype3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field-CreatedDateformat)d MMM yyyy!presname-CreatedDatetitle)Aangemaakttype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldAType.Description!presnameTypetitleTypetype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field!JobLevelformat#,##0!presname!JobLeveltitleIBeveiligingsniveautype3footerheadermodeValues!presname)background footerheadermodeValues *
)background)foregroundmarkup0!presnameTitletitle!Document field!document!presname Pictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0 )background)foregroundtitle!Mutaties%hideClear1)hideSearch1!presname-SearchPanelv 54 field!bkjrcodeflags0format 00!presnameJaartitleJaartype9)constraintabkjrcode<=YEAR(@today)+2 groupby!bkjrcode-initialText)-- Alle -- orderby5bkjrcode desc9resetSelection0!selectedbkjrcode=SV_DEFAULTS__pkg__.Jaartableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0
field dagbknrflags0-placeholder1title Dagboektype1
fieldoms25flags1024-placeholder1title1Omschrijvingtype1
field bdr_hflflags8-placeholder1title)Bedrag vantype3
field bdr_hflflags4-placeholder1title
t/mtype3 *)background)foregroundmarkup0title7Mutaties {#name:bkjrcode#prefix:Boekjaar }|||#{debcode} #{cmp_name}
IdisableExcelExport0!presname!Mutatiestabledebmut
top0v 54
-Aggregation0field!bkjrcode!presnameJaartitleJaartype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field periode!presname
Pertitle
Pertype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldbkstnr!presname!Boekstuktitle!Boekstuktype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field bdr_hflformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field bdr_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues )background)foregroundtitle1Betaalgedrag)hideSearch1v 54 field!bkjrcodeflags8format 00!presnameJaartitleJaartype9)constraintabkjrcode<=YEAR(@today)+2 groupby!bkjrcode-initialText)-- Alle -- orderby5bkjrcode desc9resetSelection0!selectedbkjrcode=SV_DEFAULTS__pkg__.Jaar-1tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0 mode0-orientation5horizontalBar5splitPosition
500vname9Deb_BetaalGrafname)Constraint *)background)foregroundmarkup0title5Betaalgedrag !Compress1=extraConstraint1%Constraint%!passthru1!presname!Mutatiestabledebmutv 50fielddatum!presname Periodetype2 !cumulate1field bdr_hfl%graphType4marker1!presnameSaldotitleSaldo color5113, 188, 158 color1252, 153, 49 color-223, 41, 54 color)1, 102, 94 color5102, 207, 228 color5195, 217, 228 color128, 139, 133 color-225, 58, 40 color-127, 33, 27 color)23, 51, 52 color132, 155, 181 color184, 139, 163 *)background)foregroundmarkup0titleMutaties {#name:datum#prefix:Datum }|||#{debcode} #{cmp_name}
IdisableExcelExport0!presname!Mutatiestabledebmut
top0v 54
-Aggregation0field!bkjrcode!presnameJaartitleJaartype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field periode!presname
Pertitle
Pertype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldbkstnr!presname!Boekstuktitle!Boekstuktype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field bdr_hflformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field bdr_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues )background)foregroundtitle%Logistiek )expandTabs1v 52
)background)foregroundtitleOrders)hideSearch1v 54 field1YEAR(orddat)flags0format!#,##0.00!presnameJaartitleJaartype3)constraintabkjrcode<=YEAR(@today)+2 groupbyUcast(bkjrcode as int)-initialText)-- Alle -- orderby5bkjrcode desc9resetSelection0!selectedbkjrcode=SV_DEFAULTS__pkg__.Jaartableperdattitle!bkjrcodevalueUcast(bkjrcode as int)EvalueIsConstraint0
field ordernrflags0-placeholder1title Ordernrtype1
field%docnumberflags1024-placeholder1title)Referentietype1
fieldorddatflags8-placeholder1title-Order datumtype2
fieldorddatflags8-placeholder1title
t/mtype2
fieldafldatflags8-placeholder1title1Afleverdatumtype2
fieldafldatflags8-placeholder1title
t/mtype2 mode0-orientation5horizontalBar5splitPosition
500*)background)foregroundmarkup0titleLopende orders|||#{debcode} #{cmp_name} IdisableExcelExport0!presnameorkrgsortByorddattable%televeren
top0v 54 -Aggregation0!Compress1)Constraint1field ordernr!presnameOrdertitleOrdertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field selcode!presnameSelctitleSelctype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%docnumber!presname)Referentietitle)Referentietype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field-nettobedragformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldYprijs_n_val*esr_aantalformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0!Compress1field-orkrg.koersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0!Compress1fieldorkrg.represent_id.fullname + ' (' + orkrg.represent_id + ')'format#!presname
Vertitle
Vertype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field=orkrg.projectnrtitle Projecttype1footerheadermodeValues footerheadermodeValues
-Aggregation0field=orkrg.routecode!presnameRoutetitleRoutetype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field1orkrg.afldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field(orkrg.fakdebnr)@(cicmpy:ix_debnr.debcode)!presname Factdebtitle Factdebtype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldq(orkrg.fakdebnr)@debitr.naam!presnameNaamtitleNaamtype1footerheadermodeValues!presname)background footerheadermodeValues vnameMVerkooporderdetailsmode2-orientation-verticalBar!presname!Verdeler5splitPosition
800*
)background)foregroundmarkup0!presname%SubregelstitleqOrderregels order #{ordernr} IdisableExcelExport0!presnameorsrxsortByregeltableorsrx
top0v 54(-Aggregation0fieldregeltitle R.type4footerheadermodeValues footerheadermodeValues
-Aggregation0field artcode!presname Artikeltitle Artikeltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms45!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field!unitcodetitle Eenheidtype1footerheadermodeValues footerheadermodeValues
-Aggregation0fieldUesr_aantal/unitfactorformat#,##0title1Aantal Eenh.type6footerheadermodeValues footerheadermodeValues -Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitle5Aantal Vk.Vp.type6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0!Negative1!Positive1fieldqafldat=22991231?esr_aantal:0format#,##0!presname%Backordertitle%Wv. Back.type6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0!Negative1!Positive1field)aant_gelevformat#,##0!presnameGelevtitleGelev.type6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldbtw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldbtw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6footerheadermodeValues footerheadermodeValues -Aggregation0field=ordernr.valcodetitleVal.type1footerheadermodeValues footerheadermodeValues -Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presnameBedragtitle)Bedrag Valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation1fieldesr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleBedragtype6footerheadermodeValues footerheadermodeValues -Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field magcode!presname
Magtitle
Magtype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field-instruction!presname=Instructieregeltitle=Instructieregeltype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldres_id.fullname + ' (' + res_id + ')'title)Medewerkertype1footerheadermodeValues footerheadermodeValues mode0-orientation5horizontalBar!presname)Documenten5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleUGekoppelde documenten!presname)Translatorfrom ordernr to-OrderNumber
IdisableExcelExport0!presnameTabletable=bacodiscussions
top0v 54
-Aggregation0)Constraint1field
HIDformat#,##0!presname
HIDtitleNummertype3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field-CreatedDateformat)d MMM yyyy!presname-CreatedDatetitle)Aangemaakttype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldAType.Description!presnameTypetitleTypetype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field!JobLevelformat#,##0!presname!JobLeveltitleIBeveiligingsniveautype3footerheadermodeValues!presname)background footerheadermodeValues *
)background)foregroundmarkup0!presnameTitletitle!Document field!document!presname Pictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0 )background)foregroundtitle5Orderhistorie)hideSearch1!presname5Orderhistoriev 54 field1YEAR(orddat)flags0format!#,##0.00!presnameJaartitleJaartype3)constraintabkjrcode<=YEAR(@today)+2 groupbyUcast(bkjrcode as int)-initialText)-- Alle -- orderby5bkjrcode desc9resetSelection0!selectedbkjrcode=SV_DEFAULTS__pkg__.Jaartableperdattitle!bkjrcodevalueUcast(bkjrcode as int)EvalueIsConstraint0
field ordernrflags0-placeholder1title Ordernrtype1
field%docnumberflags1024-placeholder1title)Referentietype1
fieldorddatflags8-placeholder1title-Order datumtype2
fieldorddatflags8-placeholder1title
t/mtype2
fieldafldatflags8-placeholder1title1Afleverdatumtype2
fieldafldatflags8-placeholder1title
t/mtype2 mode0-orientation5horizontalBar!presname%Orderhist5splitPosition
500*)background)foregroundmarkup0titleWOrderhistorie {#name:YEAR(orddat)#prefix:Boekjaar #postfix: }|||#{debcode} #{cmp_name} IdisableExcelExport0=extraConstraintafgehandld='J' and ord_soort='V'!presnameorkrgtableorkrg
top0v 54 -Aggregation0)Constraint1field ordernr!presnameOrdertitleOrdertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field selcode!presnameSelctitleSelctype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%docnumber!presname)Referentietitle)Referentietype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1represent_id!presname
Vertitle
Vertype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1fieldAbdr_ev_val*koersformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)bdr_ev_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field]orkrgx.vrachtkost*koersformat!#,##0.00!presnameVrachttitleVrachttype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1fieldYorkrgx.orderkost*koersformat!#,##0.00!presnameOrdertitleOrdertype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)order_kortformat!#,##0.00!presnameKort%titleKort%type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%routecode!presnameRoutetitleRoutetype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field(fakdebnr)@(cicmpy:ix_debnr.debcode)!presname Factdebtitle Factdebtype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldQfakdebnr@debitr.naam!presnameNaamtitleNaamtype1footerheadermodeValues!presname)background footerheadermodeValues x)linkTargetMVerkooporderdetailsv 50 )background)foregroundtitle!Facturenmode0-orientation5horizontalBar!presname!Facturen5splitPosition
500!presname=debnrtofakdebnrfrom debnr=% to(debnr=% and fakdebnr='') or fakdebnr=% )hideSearch1v 54
field%fakt_codeflags0-placeholder1title)Fact. codetype1
field%docnumberflags0-placeholder1title)Referentietype1 *)background)foregroundmarkup0titleNiet-definitief afgedrukte Facturen|||#{debcode} #{cmp_name}
IdisableExcelExport0!presnamefrkrgtablefrkrg
top0v 54 -Aggregation0)Constraint1field%fakt_code!presname Fctitle Fctype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0)Constraint1field)volgnr_fak!presname Nrtitle Nrtype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field ordernr!presnameOrdertitleOrdertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%docnumber!presname)Referentietitle)Referentietype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1represent_id!presname
Vertitle
Vertype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1fieldAbdr_ev_val*koersformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)bdr_ev_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field[inv_in_vv='J']?[[frkrgx.vrachtkost*koers]:frkrgx.vrachtkost]format!#,##0.00!presnameVrachttitleVrachttype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field[inv_in_vv='J']?[[frkrgx.orderkost*koers]:frkrgx.orderkost]format!#,##0.00!presnameOrdertitleOrdertype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field%fakt_kortformat!#,##0.00!presnameKort%titleKort%type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field(debnr)@(cicmpy:ix_debnr.debcode)!presname5Orderdebiteurtitle5Orderdebiteurtype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1footerheadermodeValues!presname)background footerheadermodeValues vnameyFactuurregels (niet afgedrukt)*
)background)foregroundmarkup0!presname!FacturentitleFactuurregels #{fakt_code} #{volgnr_fak} IdisableExcelExport0!presname!FacturensortByregeltablefrsrg
top0v 54 -Aggregation0fieldregeltitle r.type4footerheadermodeValues footerheadermodeValues -Aggregation0field artcodetitle-Artikelcodetype1footerheadermodeValues footerheadermodeValues -Aggregation0fieldoms45title1Omschrijvingtype1footerheadermodeValues footerheadermodeValues -Aggregation0field!unitcodetitle Eenheidtype1footerheadermodeValues footerheadermodeValues
-Aggregation0fieldUesr_aantal/unitfactorformat#,##0title-Aant. Eenh.type6footerheadermodeValues footerheadermodeValues -Aggregation1field)esr_aantalformat#,##0!presnameAantaltitle=Aant. Vk. Verp.type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldbtw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00title=Br. Prijs Val type6footerheadermodeValues footerheadermodeValues -Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldbtw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00!presnamePrijstitle=Netto Pr. Val type6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presname)Bedrag valtitle)Bedrag Valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field5frkrg.valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1fieldesr_aantal*(#nettoprijsval)*koersformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field magcode!presname
Magtitle
Magtype1footerheadermodeValues!presname)background footerheadermodeValues )background)foregroundtitle=Factuurhistorie!presnamepanel1fromdebnr= to%fakdebnr= )hideSearch1v 54 field1YEAR(fakdat)flags0format!#,##0.00!presnameJaartitleJaartype3)constraintabkjrcode<=YEAR(@today)+2 groupbyUcast(bkjrcode as int)-initialText)-- Alle -- orderby5bkjrcode desc9resetSelection0!selectedbkjrcode=SV_DEFAULTS__pkg__.Jaartableperdattitle!bkjrcodevalueUcast(bkjrcode as int)EvalueIsConstraint0
fieldfaknrflags0-placeholder1title!Fact. nrtype1
field ordernrflags0-placeholder1title Ordernrtype1
field%docnumberflags1024-placeholder1title)Referentietype1
fieldorddatflags8-placeholder1title-Order datumtype2
fieldorddatflags8-placeholder1title
t/mtype2
fieldafldatflags8-placeholder1title1Afleverdatumtype2
fieldafldatflags8-placeholder1title
t/mtype2 mode0-orientation5horizontalBar5splitPosition
500*)background)foregroundmarkup0titlewFactuurhistorie {#name:YEAR(fakdat)#prefix:Boekjaar #postfix: }|||#{debcode} #{cmp_name} IdisableExcelExport0=extraConstraint9fakdebnr=debnr!presnamefrhkrgtablefrhkrg
top0v 54 -Aggregation0)Constraint1fieldfaknr!presname Factuurtitle Factuurtype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0)Constraint1fieldfakdatformat)d MMM yyyy!presname1Factuurdatumtitle1Factuurdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field ordernr!presnameOrdertitleOrdertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%docnumber!presname)Referentietitle)Referentietype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field1represent_id!presname
Vertitle
Vertype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field tot_bdrformat!#,##0.00!presnameBedragtitleBedragtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field5tot_bdr/koersformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field[inv_in_vv='J']?[[frhkrgx.vrachtkost*koers]:frhkrgx.vrachtkost]format!#,##0.00!presnameVrachttitleVrachttype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field[inv_in_vv='J']?[[frhkrgx.orderkost*koers]:frhkrgx.orderkost]format!#,##0.00!presnameOrdertitleOrdertype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field%fakt_kortformat!#,##0.00!presnameKort%titleKort%type3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field(orddeb)@(cicmpy:ix_debnr.debcode)!presname5Orderdebiteurtitle5Orderdebiteurtype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldIorddeb@debitr.naam!presnameNaamtitleNaamtype1footerheadermodeValues!presname)background footerheadermodeValues x)linkTargetYFactuurhistoriedetailsv 50 )background)foregroundtitle=Omzetstatistiek)hideSearch1v 54
field9boekjr as yearflags2048format0titleJaartype6 groupbyUCAST(bkjrcode as INT) orderby5bkjrcode desc9resetSelection0!selectedbkjrcode = SV_DEFAULTS__pkg__.JaartablePERDATtitleUCAST(bkjrcode as INT)valueUCAST(bkjrcode as INT)EvalueIsConstraint0
fieldAperiode as monthflags4format0titleMaandtype6 groupby per_fin orderby per_fin9resetSelection0!selected]per_fin = Month(@today)tablePERDATtitle per_finvalue per_finEvalueIsConstraint0 field artcodeflags1024-placeholder1size 10title-Artikelcodetype1 )expandTabs1v 52)background)foregroundtitle1Artikelgroepmode0-orientation5horizontalBar5splitPosition
333vnameAOmz_JrVrg_ArtGrp*
)background-disableMenu0)foregroundmarkup0titleArtikelgroep{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment[Converted from Table on 13-2-2019 13:37:03]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableMSV_OmzetFact__pkg__v 55-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldaartcode@ITEMS.Assortment9fieldLevelType2!sortType1title'Code'footerheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1fieldartcode@ITEMS.Assortment.Description9fieldLevelType2title'Naam'footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title
'%'footerheadermodeValues footerheadermodeValues -Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth
100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54 footerheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor footerheadermodeValues footerheadermodeValues mode0-orientation5horizontalBar5splitPosition
500vnameEOmz_JrVrg_Artikelname5AddConstraint *
)background-disableMenu0)foregroundmarkup0titleArtikel{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment[Converted from Table on 13-2-2019 13:37:03]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint7(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1) %AddConstraint%=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableMSV_OmzetFact__pkg__v 55-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1field artcode9fieldLevelType2!sortType1title'Code'footerheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1fieldeartcode@ITEMS.Description9fieldLevelType2title'Naam'footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title
'%'footerheadermodeValues footerheadermodeValues -Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth
100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54 footerheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor footerheadermodeValues footerheadermodeValues vname5Omz_JrVrg_Detmode0-orientation-verticalBar5splitPosition
200*
)background-disableMenu0)foregroundmarkup0titleMaandn0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment[Converted from Table on 7-2-2019 15:11:52]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style20tableMSV_OmzetFact__pkg__v 55-Aggregation0!Compress1)Constraint1Hidden05crossTreeType3field periode9fieldLevelType2format0!sortType1title 'Maand'kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF(boekjr=#{year},omzet, 0.0)as OmzDJ9fieldLevelType2format!#,##0.00titleI'Omzet ' + #{year}kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldIIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVJ9fieldLevelType2format!#,##0.00title'Omzet ' + (CAST(#{year} as INT)-1)kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldQ#OmzDJ-#OmzVJ as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType 13field#vrsfield2#OmzVJ9fieldLevelType2format0.0%title
'%'footerheadermodeValues footerheadermodeValues -Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth
100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54 footerheadermodeValues footerheadermodeValues
Hidden1fieldiMAX(#{year}-1) as PrevYear9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1 from periode to{(select per_fin from perdat where fakdat >= bgdatum and fakdat <= eddatum)} fromMdebnr.represent_id= to(faknr:fakdat:dagbknr)@FRHKRG.debnr.represent_id= fromdebnr= to(faknr:fakdat:dagbknr)@FRHKRG.debnr= from=debnr.naam LIKE to(faknr:fakdat:dagbknr)@FRHKRG.debnr.naam LIKE from=debnr.landcode= to(faknr:fakdat:dagbknr)@FRHKRG.debnr.landcode= )expandTabs1v 52)background)foregroundtitle #{year}*
)background-disableMenu0)foregroundmarkup0title Detailsn0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment[Converted from Table on 13-2-2019 13:44:17]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintg {(select bkjrcode from perdat where fakdat >= bgdatum and fakdat <= eddatum)} = #{year} AND {(select per_fin from perdat where fakdat >= bgdatum and fakdat <= eddatum)} <= #{periode}=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru01queryHeaders0QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style20tableFRHSRGv 55-Aggregation0!Compress1)Constraint1Hidden05crossTreeType2fieldfakdat9fieldLevelType2format)d MMM yyyy!sortType1titleDatumfooterheadermodeValues footerheadermodeValues -Aggregation0!Compress1Hidden05crossTreeType1fieldfaknr9fieldLevelType2!sortType1title%FaktuurnrfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr9fieldLevelType2titleKlantfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr.naam9fieldLevelType2title)Klant naamfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr.woonpl9fieldLevelType2titlePlaatsfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr.landcode9fieldLevelType2titleLandfooterheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3field)esr_aantal9fieldLevelType2format!#,##0.00titleAantalkcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldq(prijs_n*esr_aantal) * koers9fieldLevelType2format!#,##0.00titleOmzetkcolor5negativeColor footerheadermodeValues footerheadermodeValues )background)foregroundtitle-#{PrevYear}*
)background-disableMenu0)foregroundmarkup0title Detailsn0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment[Converted from Table on 13-2-2019 13:44:17]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint {(select bkjrcode from perdat where fakdat >= bgdatum and fakdat <= eddatum)} = #{year}-1 AND {(select per_fin from perdat where fakdat >= bgdatum and fakdat <= eddatum)} <= #{periode}=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru01queryHeaders0QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style20tableFRHSRGv 55-Aggregation0!Compress1)Constraint1Hidden05crossTreeType2fieldfakdat9fieldLevelType2format)d MMM yyyy!sortType1titleDatumfooterheadermodeValues footerheadermodeValues -Aggregation0!Compress1Hidden05crossTreeType1fieldfaknr9fieldLevelType2!sortType1title%FaktuurnrfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr9fieldLevelType2titleKlantfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr.naam9fieldLevelType2title)Klant naamfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr.woonpl9fieldLevelType2titlePlaatsfooterheadermodeValues footerheadermodeValues -Aggregation0Hidden05crossTreeType1field(faknr:fakdat:dagbknr)@FRHKRG.debnr.landcode9fieldLevelType2titleLandfooterheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3field)esr_aantal9fieldLevelType2format!#,##0.00titleAantalkcolor5negativeColor footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldq(prijs_n*esr_aantal) * koers9fieldLevelType2format!#,##0.00titleOmzetkcolor5negativeColor footerheadermodeValues footerheadermodeValues )background)foregroundtitle Artikelmode0-orientation5horizontalBar5splitPosition
500*
)background)foregroundmarkup0!presname=OmzetstatistiektitleOmzet per jaar per maand|||#{debcode} #{cmp_name}n4IcolHHInSeparateCol1AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=hideColOfTotals0)hideCorner0AhideResultTitles1=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru1!presnamepanel21queryHeaders0ArowLevelExpanded05selectionMode2QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style23tableomzdebv 55!Compress1)Constraint1Hidden05crossTreeType1fieldboekjr9fieldLevelType01footerString
Tot=irr_Aggregation0footerheadermodeValues footerheadermodeValues !Compress1)Constraint1Hidden0%alignment25crossTreeType1field periode9fieldLevelType11footerString
Tot=irr_Aggregation0footerheadermodeValues footerheadermodeValues -Aggregation1Hidden05crossTreeType3fieldomzet9fieldLevelType2format!#,##0.00footerheadermodeValues footerheadermodeValues mode0-orientation-verticalBar5splitPosition
500*
)background)foregroundmarkup0!presname DetailstitleGOmzet per Artikelgroep - {#name:boekjr#prefix:Boekjaar #postfix: } {#name:periode#prefix:Periode #postfix: }|||#{debcode} #{cmp_name}R fieldomzetAotherIsClickable1!passthru1)showLegend1tableMSV_OmzetFact__pkg__v 44[!compress1)constraint1fieldartcode@items.assortment.description color5113, 188, 158 color1252, 153, 49 color-223, 41, 54 color)1, 102, 94 color5102, 207, 228 color5195, 217, 228 color128, 139, 133 color-225, 58, 40 color-127, 33, 27 color)23, 51, 52 color132, 155, 181 color184, 139, 163 *)background)foregroundmarkup0title Details #{artcode@items.assortment.description} {#name:boekjr#prefix:Boekjaar #postfix: } {#name:periode#prefix:Periode #postfix: }|||#{debcode} #{cmp_name}IdisableExcelExport0tableMSV_OmzetFact__pkg__
top0v 54
-Aggregation0!Compress1field artcodetitle-Artikelcodetype1footerheadermodeValues footerheadermodeValues -Aggregation0fieldeartcode@ITEMS.Descriptiontitle1Omschrijvingtype1footerheadermodeValues footerheadermodeValues
-Aggregation1fieldomzetformat!#,##0.00title5Omzet (netto)type6footerheadermodeValues footerheadermodeValues )background)foregroundtitle)Documentenvname Deb_docBtablecicmpyv4)constraint1field cmp_wwn !presname!Vertalerfrom cmp_wwn tocmpwwn )expandTabs1!presname!Kladblokv 52)background)foregroundtitle!Per typemode0-orientation5horizontalBar5splitPosition
300*
)background)foregroundmarkup0!presnameTiteltitleDocument per type|||#{debcode} #{cmp_name}IdisableExcelExport0=extraConstraint1joblevel<=10!passthru1!presnameTabeltable=bacodiscussions
top0v 54 -Aggregation0!Compress1fieldAType.Description!presname5Type Documenttitle5Type Documenttype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0!Compress1)Constraint1Hidden1fieldtype!presname-TableColumntitleTypetype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldsum(1)format#,##0!presnameAantaltitleAantaltype3footerheadermodeValues!presname)background footerheadermodeValues mode0-orientation5horizontalBar!presname!Verdeler5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleDocumenten - #{Type.Description}|||#{debcode} #{cmp_name} IdisableExcelExport0=extraConstraint1joblevel<=10!presnameTabeltable=bacodiscussions
top0v 54 -Aggregation0)Constraint1field
HIDformat#,##0!presname9Documentnummertitle9Documentnummertype3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldECreatedByFullName!presname!Aanmakertitle!Aanmakertype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field-CreatedDateformat)d MMM yyyy!presname1Aanmaakdatumtitle1Aanmaakdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field-OrderNumber!presname-Ordernummertitle-Ordernummertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldOurRef!presname5Factuurnummertitle5Factuurnummertype4footerheadermodeValues!presname)background footerheadermodeValues *
)background)foregroundmarkup0!presnameTiteltitleqDocument #{hid} - #{Subject}
field!document!presnameFiguurtable=bacodiscussionsv 51UwebclientAutoDownload0 )background)foregroundtitleZoeken%hideClear1v 54 field
hidflags0!presnameNummersize 10titleNummertype3
fieldtypeflags0!presname5Type Documenttitle5Type Documenttype1-initialText)-- Alle -- orderby-Description9resetSelection0tableaBACODISCUSSIONFIXEDTYPEStitle-DescriptionvalueTypeIDEvalueIsConstraint0 field-Ordernumberflags0!presname-Ordernummersize8title-Ordernummertype1 fieldOurRefflags0!presname5Factuurnummersize8title5Factuurnummertype1 fieldEcreatedbyfullnameflags1024!presnameAAanmaker (bevat)size 15titleAAanmaker (bevat)type1 field subjectflags1024!presname%Onderwerpsize 15titleEOnderwerp (bevat)type1 mode0-orientation5horizontalBar!presnameZoeken5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleDocumenten|||#{debcode} #{cmp_name} IdisableExcelExport0=extraConstraint1joblevel<=10!presnameTabeltable=bacodiscussions
top0v 54 -Aggregation0)Constraint1field
HIDformat#,##0!presname9Documentnummertitle9Documentnummertype3footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldECreatedByFullName!presname!Aanmakertitle!Aanmakertype1footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field-CreatedDateformat)d MMM yyyy!presname1Aanmaakdatumtitle1Aanmaakdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field-OrderNumber!presname-Ordernummertitle-Ordernummertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldOurRef!presname5Factuurnummertitle5Factuurnummertype4footerheadermodeValues!presname)background footerheadermodeValues *
)background)foregroundmarkup0!presnameTiteltitleqDocument #{hid} - #{Subject}
field!document!presnameFiguurtable=bacodiscussionsv 51UwebclientAutoDownload0 )background)foregroundtitle
PDFvname Deb_pdf*)background)foregroundmarkup0titleqPDF|||#{debcode} #{cmp_name}21bottommargin 10)leftmargin 10-pageNumbers2-paperheight
297)paperwidth
210!presnameERapportverwijzing-rightmargin 10=titleBackgroundAtitleBackground2=titleForeground%topmargin 10UwebclientAutoDownload00!presname5Report Layout\
!presnameIBovenste 4 panelenUreportLayoutAlignmentleftIreportLayoutHeight
135YreportLayoutOccurrencesingleEreportLayoutWidth
180mode2-orientation5horizontalBar!presname!Splitter5splitPosition0mode2-orientation-verticalBar!presname!Splitter5splitPosition
500*)background!fontsize2)foregroundAlookupConstraint9debnr=#{debnr}-lookupTablecicmpymarkup0!presnameTitletitle-#{cmp_name}!presname%Datapaneltablecicmpy Last1digits 25field debcode!presname Relatietitle Relatietype1 Last1digits 25field!cmp_name!presnameNaamtitleNaamtype1 Last1digits 25field%cmp_fadd1!presnameAdrestitleAdrestype1 Last1digits 25field cmp_fpc!presname!Postcodetitle!Postcodetype1 Last1digits 25field%cmp_fcity!presnamePlaatstitlePlaatstype1
Last1digits0field ''!presname)DataColumntype1
Last1digits0field ''!presname)DataColumntype1
Last1digits0field ''!presname)DataColumntype1
Last1digits0field ''!presname)DataColumntype1
Last1digits0field ''!presname)DataColumntype1
Last1digits0field ''!presname)DataColumntype1 *)background!fontsize2)foreground-lookupTable)SYS\$SRNF$markup0!presname1BetaalgedragtitleBetaalgedrag||| Datum #{afdrukdatum}!Compress0fieldcast(@today as date) as afdrukdatummarkup0
!Compress1!fontsize1!passthru1!presname!Mutatiestabledebmutfielddatum!presname Periodetitle Periodetype2 !cumulate1field bdr_hfl!presnameSaldotitle=Debiteurensaldo color5113, 188, 158 color1252, 153, 49 color-223, 41, 54 color)1, 102, 94 color5102, 207, 228 color5195, 217, 228 color128, 139, 133 color-225, 58, 40 color-127, 33, 27 color)23, 51, 52 color132, 155, 181 color184, 139, 163 mode2-orientation-verticalBar!presname!Splitter5splitPosition
500*)background!fontsize2)foreground-lookupTablesetupmarkup0!presnameTitletitleOmzet per artikelgroep #{setup.eaccount_default_boekjaar}!Compress0field}setup.eaccount_default_boekjaarmarkup0 R=extraConstraintboekjr=setup.eaccount_default_boekjaarfieldomzethaving1sum(omzet)>0)showLegend1sortBy=sum(omzet) desctableOMZGRPv 44[!compress1)constraint1fieldartgrp@itemassortment.description color5113, 188, 158%color.alt180, 186, 144 color1252, 153, 49%color.alt1252, 153, 49 color-223, 41, 54%color.alt-255, 43, 56 color)1, 102, 94%color.alt5244, 244, 244 color5102, 207, 228%color.alt138, 161, 219 color5195, 217, 228%color.alt143, 103, 122 color128, 139, 133%color.alt128, 139, 133 color-225, 58, 40%color.alt-218, 113, 4 color-127, 33, 27%color.alt5254, 124, 124 color)23, 51, 52%color.alt5178, 178, 178 color132, 155, 181%color.alt5123, 225, 247 color184, 139, 163%color.alt186, 189, 237 *)background!fontsize2)foreground-lookupTablesetupmarkup0!presname9Omzet per jaartitleOmzet per periode #{vorigjaar}/#{ditjaar}!Compress0fieldsetup.eaccount_default_boekjaar as ditjaarmarkup0 !Compress0fieldcast(setup.eaccount_default_boekjaar as int)-1 as vorigjaarmarkup0 b!Compress1=extraConstraintG(boekjr=setup.eaccount_default_boekjaar OR boekjr=cast(cast(setup.eaccount_default_boekjaar as int)-1 as varchar(4)))!fontsize2legend1!passthru1!presname)2.5D GraphtableMSV_OmzetFact__pkg__field periode!presname Xcolumntitle Periodetype -1 fieldomzet!presnameOmzettitleOmzet fieldboekjr!presnameJaartitleJaartype3 color5113, 188, 158 color1252, 153, 49 color-223, 41, 54 color)1, 102, 94 color5102, 207, 228 color5195, 217, 228 color128, 139, 133 color-225, 58, 40 color-127, 33, 27 color)23, 51, 52 color132, 155, 181 color184, 139, 163 \!presnameIOnderste 2 panelenUreportLayoutAlignmentleftYreportLayoutOccurrencepageEreportLayoutWidth
180mode2-orientation5horizontalBar!presname!Splitter5splitPosition0*)background!fontsize2)foreground-lookupTabledbopenIlookupUseIncomming1markup0!presnameTitletitleOpenstaande posten |||Saldo {#name:sum(bdr_na_bkn)#amount:2#init:-,--#format:##,####0.00}!Compress0field=sum(bdr_na_bkn)markup0!presname-TitleColumn IdisableExcelExport0=extraConstraint=bdr_na_bkn <> 0!fontsize2!passthru1!presname-Open postentabledbopen
top0v 54 -Aggregation0)Constraint1fieldbkstnr!presname!Boekstuktitle!Boekstuktype4footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field)vervdatfakformat)d MMM yyyy!presname-Vervaldatumtitle-Vervaldatumtype2footerheadermodeValues!presname)background footerheadermodeValues -Aggregation1field)bdr_na_bknformat!#,##0.00!presname)Openstaandtitle)Openstaandtype6footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field%oorsprbdrformat!#,##0.00!presname9Oorspronkelijktitle9Oorspronkelijktype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0fieldE@today-vervdatfak!presname Te laattitle Te laattype4
fieldE@today-vervdatfakfooterheadermodeValues!presname)backgroundcolorWhite!presname)ColorValuevalue0 color
Red!presname)ColorValuevalue
100 footerheadermodeValues * )background!fontsize2)foregroundmarkup0!presnameOrderstitle9Lopende ordersIdisableExcelExport0!fontsize2!presnameorkrgsortByorddattable%televeren
top0v 54-Aggregation0!Compress1)Constraint1field ordernr!presnameOrdertitleOrdertype4footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field%docnumber!presname)Referentietitle)Referentietype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation1field-nettobedragformat!#,##0.00titleiTotaalbedrag incl. kortingtype6footerheadermodeValues footerheadermodeValues -Aggregation0fieldYprijs_n_val*esr_aantalformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6footerheadermodeValues!presname)background footerheadermodeValues
-Aggregation0field valcode!presname
Valtitle
Valtype1footerheadermodeValues!presname)background footerheadermodeValues -Aggregation0field1orkrg.afldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2footerheadermodeValues!presname)background footerheadermodeValues +)resourceIdd8d4f34aaf53d7c56ee505ab120bc9db ;
Version: 5.5.1367
View created by Sumatra Software B.V.
<TableList disableExcelExport="0" extraConstraint="debcode is not null and cmp_type<>'E'" presname="cicmpy" sortBy="debcode" table="cicmpy" top="0" v="54"><TableColumn Aggregation="0" field="debcode" presname="Debiteur" title="%Label2%" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cmp_name" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cmp_fpc" presname="Postcode" title="Postcode" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cmp_fcity" presname="Plaats" title="Plaats" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Constraint="1" Hidden="1" field="debnr" presname="Debiteurnummer" title="Debiteurnummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Notebook expandTabs="1" v="52"><NotebookPage background="" foreground="" title="Status"><Splitter mode="0" orientation="horizontalBar" splitPosition="500"><Title background="" disableMenu="0" foreground="" markup="0" title="#{debcode} {#name:cmp_name#prefix: - }"><Layout columns="1" v="50"><LayoutPanel><LookupTranslator lookupUseIncoming="0" passthru="1" table="SV_DEFAULTS__pkg__" top="1" v="7"><LookupTranslatorField field="jaar" /><LookupTranslatorField field="Jaar-1 as Jr1" /><LookupTranslatorField field="maand" /><TableCache extraConstraint="(boekjr=#{jaar} OR boekjr=#{Jr1}) AND periode<=#{maand}" name="cOMZET" passIncoming="1" rowNum="0" table="SV_OmzetFact__pkg__" top="0" v="51"><TableCacheField Compress="1" field="boekjr" /><TableCacheField Compress="1" field="artcode" /><TableCacheField field="artcode@artbst.oms30 Description" /><TableCacheField Compress="1" field="periode" /><TableCacheField field="omzet" /><TableCacheField Compress="1" field="debnr" /><Layout columns="30" v="50"><LayoutPanel colspan="8"><Title background="" disableMenu="0" foreground="" markup="0" title="Omzet #{jaar} {#name:Maand#prefix: t/m maand }"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="10"><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="10"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="2"><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="6"><Tile clickConstraint="debnr=#{debnr}" comment="<font color=#173334>" content="<B>{#name:ODJ#format:##,####0}</B>" fontsize="4" horizontalAlignment="1" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="1"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout></LayoutPanel><LayoutPanel colspan="10"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="3"><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel><Tile content="<font color=#{fc}><B>#{icon}</B>" horizontalAlignment="0" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="2"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><TileField field="#ODJ-#OVJ as vrs" /><TileField field="iif(#vrs > 0, ' ▲ ' , ' ▼ ') as icon" /><TileField field="iif(#vrs >= 0, '#50BA90' , '#FF2B38') as fc" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile content="<B>{#name:vp#postfix:%#format:0.0}</B>" horizontalAlignment="2" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="2"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><TileField field="#ODJ-#OVJ as vrs" /><TileField field="iif(#OVJ=0,100,((#vrs/#OVJ)*100)) as vp" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="3"><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout></LayoutPanel><LayoutPanel colspan="10"><Tile horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout><TitleColumn Compress="0" field="#{Jr1} as VJ" markup="0" /><TitleColumn Compress="0" field="#{jaar} as Jr" markup="0" /><Graph Compress="1" legend="1" legendOverPlot="1" passthru="1" queryHeaders="1" table=":cOMZET" v="50" yAxisTitle="'Omzet'"><GraphColumnX field="periode" type="-1" /><GraphColumnY field="IIF(boekjr=#{jaar},omzet, 0.0) as ODJ" graphType="5" title="{#name:jaar#init:YEAR(@today)}" /><GraphColumnY field="IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OVJ" graphType="4" marker="1" title="{#name:jaar#init:YEAR(@today)}-1" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" fontsize="2" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" sortBy="SUM(#vrs)" style="3" style2="2" table=":cOMZET" top="25" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" title="'Artikel'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="Description" fieldLevelType="2" 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="IIF(boekjr=#{jaar},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="max(#{maand} ) as periode" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><Graph Compress="1" extraConstraint="(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)<DATEPART(DAYOFYEAR,SV_DEFAULTS__PKG__.vandaag)" legend="1" legendOverPlot="1" passthru="1" table="SV_VERKOOPORDERS__PKG__" v="50"><GraphColumnX field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,orddat,DATEADD(YY,+1,orddat))" type="2" /><GraphColumnY cumulate="1" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,0,nettobedrag)" graphType="7" marker="1" title="Vorig jaar" /><GraphColumnY cumulate="1" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,nettobedrag,0)" graphType="4" marker="1" title="Jaar" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><Layout columns="3" syncPanels="1" v="50"><LayoutPanel rowspan="3"><Tile clickConstraint="2=2" content="��" fontsize="4" horizontalAlignment="1" passIncoming="1" table="DBOPEN" verticalAlignment="1"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2" rowspan="2"><Tile clickConstraint="2=2" content="Saldo: {#name:bdr#format:€ ##,####0.00}" horizontalAlignment="0" passIncoming="1" table="DBOPEN" verticalAlignment="1"><TileField field="SUM(bdr_na_bkn) as bdr" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile clickConstraint="2=2" content="Vervallen: {#name:bdr#format:€ ##,####0.00}" extraConstraint="vervdatfak<=@Today" horizontalAlignment="0" passIncoming="1" table="DBOPEN" verticalAlignment="1"><TileField field="SUM(bdr_na_bkn) as bdr" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="debnr = #{debnr} AND (boekjr=#{year} OR boekjr=CAST(#{year} as INT)-1) AND periode<=#{month}" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="SV_OmzetFact__pkg__" v="44"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Description" fieldLevelType="2" 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="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><TitleColumn Compress="0" field="#{year} as JaarTm" markup="0" /><TitleColumn Compress="0" field="#{year}-2 as JaarFrom" markup="0" /><Graph extraConstraint="debnr = #{debnr} AND (boekjr=#{year} AND periode<=#{month}) OR ( boekjr<#{year} AND boekjr>=CAST(#{year} as INT)-2)" table="SV_OmzetFact__pkg__" v="50"><GraphColumnX field="CAST(boekjr as VARCHAR) + '-' + periode" type="1" /><GraphColumnY field="omzet" graphType="7" title="omzet" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)<DATEPART(DAYOFYEAR,SV_DEFAULTS__PKG__.vandaag) and debnr=#{debnr}" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="SV_VERKOOPORDERS__PKG__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Description" fieldLevelType="2" 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="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,nettobedrag,0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Intake ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,0,nettobedrag) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Intake ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,esr_aantal,0) as Aan" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,0,esr_aantal) as AanVj" fieldLevelType="2" format="#,##0" title="'Aantal ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><TableList disableExcelExport="0" extraConstraint="bdr_na_bkn <> 0" fontsize="2" passthru="1" presname="Open posten" table="dbopen" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="bkstnr" presname="Boekstuk" title="Boekstuk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="datum" format="d MMM yyyy" presname="Datum" title="Datum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms25" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="vervdatfak" format="d MMM yyyy" presname="Vervaldatum" title="Vervaldatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_na_bkn" format="#,##0.00" presname="Openstaand" title="Openstaand" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="dagbknr" presname="Dgbk" title="Dgbk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="@today-vervdatfak" presname="Te laat" title="Te laat" type="4"><ColorScheme field="@today-vervdatfak" footer="" header="" mode="Values" presname="background"><ColorValue color="White" presname="ColorValue" value="0" /><ColorValue color="Red" presname="ColorValue" value="100" /></ColorScheme><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><InfoPage presname="Debiteur" table="cicmpy" v="43"><DataColumn Last="0" digits="10" field="debcode" presname="Debiteur" title="Debiteur" type="1" /><DataColumn Last="1" digits="1" field="cmp_status='B'?"Geblokkeerd":""" format="00" presname="Geblokkeerd?" type="9" /><DataColumn Last="0" digits="32" field="cmp_name" presname="Naam" title="Naam" type="1" /><DataColumn Last="1" digits="20" field="ClassificationId+' '+ClassificationId.ml_desc" presname="Categorie" title="Categorie" type="1" /><DataColumn Last="0" digits="32" field="cmp_fadd1" presname="Adres" title="Adres" type="1" /><DataColumn Last="1" digits="20" field="cmp_type+' '+('cicmpy':'cmp_type':cmp_type)@ddtests.description" presname="Type" title="Type" type="1" /><DataColumn Last="1" digits="32" field="cmp_fadd2" presname=" " title=" " type="1" /><DataColumn Last="0" digits="30" field="cmp_fpc+' '+cmp_fcity" presname="Woonplaats" title="Woonplaats" type="1" /><DataColumn Last="1" digits="20" field="cmp_fctry+' '+ cmp_fctry.oms60" presname="Land" title="Land" type="1" /><DataColumn Last="0" digits="15" field="cmp_tel" presname="Telefoon" title="Telefoon" type="1" /><DataColumn Last="1" digits="15" field="InvoiceDebtor" presname="Factuurdeb" title="Factuurdeb" type="1" /><DataColumn Last="0" digits="15" field="BankAccountNumber@BNKACC.IBAN<>'' ? BankAccountNumber@BNKACC.IBAN : BankAccountNumber" presname="Bankrek" title="Bankrek" type="1" /><DataColumn Last="1" digits="10" field="CreditLine" presname="Kredietlimiet" title="Kredietlimiet" type="1" /><DataColumn Last="1" digits="5" field="Discount" presname="Kort%" title="Kort%" type="1" /><DataColumn Last="0" digits="15" field="cmp_acc_man.fullname" presname="Vertegenw" title="Vertegenw" type="1" /><DataColumn Last="1" digits="3" field="Currency" presname="Valuta" title="Valuta" type="1" /><DataColumn Last="0" digits="30" field="PriceList+' '+PriceList.oms30" presname="Prijslijst" title="Prijslijst" type="1" /><DataColumn Last="1" digits="20" field="PaymentCondition+' '+PaymentCondition.oms30" presname="Bet.conditie" title="Bet.conditie" type="1" /><DataColumn irr_Last="0" irr_digits="0" field="cmp_e_mail<>''?'mailto:'+cmp_e_mail:''" presname="Link naar e-mail" type="12" /><DataColumn Last="1" digits="40" field="cmp_e_mail" presname="e-mail adres" title="e-mail adres" type="1" /><DataColumn irr_Last="0" irr_digits="0" field="cmp_web<>''?(charindex('://',cmp_web)=0?'//'+cmp_web:cmp_web):''" presname="Link naar Website" title="_new" type="12" /><DataColumn Last="0" digits="40" field="cmp_web" presname="Website" title="Website" type="1" /></InfoPage><TableList disableExcelExport="0" presname="Table" table="CICNTP" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" Hidden="1" field="cnt_id" presname="ID" title="ID" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Predcode" presname="Titel" title="Titel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Initials" presname="Voorletters" title="Initialen" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="FullName" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Gender" presname="Geslacht" title="M/V" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cnt_job_desc" presname="Functieomschrijving" title="Functie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cnt_f_tel" presname="Telefoon" title="Telefoon" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cnt_f_mobile" presname="Mobiele telefoon" title="Mobiel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="cnt_email<>''?'mailto:'+cnt_email:''" presname="Link naar e-mail" type="12"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cnt_email" presname="E-mail" title="E-mail" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="active_y" presname="Actief" title="Actief" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cnt_id=cmp_wwn.cnt_id?'J':'N'" presname="Hoofd" title="Hoofd" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="Table" table="addresses" top="0" v="54"><TableColumn Aggregation="0" field="Type" presname="Type" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="AddressLine1" presname="Adresregel 1" title="Adresregel 1" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="PostCode" presname="Postcode" title="Postcode" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="City" presname="Plaats" title="Plaats" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Country" presname="Landcode" title="Landcode" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Main" presname="Hoofd" title="Hoofd" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="KeepSameAsVisit" presname="Kopie Bezoekadr." title="Kopie Bezoekadr." type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><ImagePanel field="picture" presname="Picture" table="cicntp" v="51" webclientAutoDownload="0" /><Translator presname="Translator"><FromTo from="cmp_wwn" to="Account" /><TableList disableExcelExport="0" extraConstraint="main='J'" presname="Table" table="addresses" top="0" v="54"><TableColumn Aggregation="0" field="Type" presname="Type" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="AddressLine1" presname="Adresregel 1" title="Adresregel 1" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="AddressLine2" presname="Adresregel 2" title="Adresregel 2" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="PostCode" presname="Postcode" title="Postcode" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="City" presname="Plaats" title="Plaats" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Country" presname="Landcode" title="Landcode" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ContactPerson.FullName" presname="Contact" title="Contactpersoon" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></Translator><NotitiePage field="cmp_note" presname="Notities" table="cicmpy" top="0" /><InfoPage presname="BTW" table="debbtwinfo" v="52"><DataColumn Last="1" digits="20" field="btw_nummer" presname="DataColumn" title="BTW Nummer" type="1" /><DataColumn Last="1" digits="8" field="datumctrl" format="d MMM yyyy" presname="DataColumn" title="Controledatum" type="2" /><DataColumn Last="1" digits="30" field="factorcode+' '+factorcode_oms" presname="DataColumn" title="Statistische factor" type="1" /><DataColumn Last="0" digits="30" field="btwtrans+' '+btwtrans_oms" presname="DataColumn" title="BTW transactie" type="1" /><DataColumn Last="1" digits="1" field="wijz_btwt" presname="DataColumn" title="BTW trans wijzig." type="8" /><DataColumn Last="0" digits="30" field="landcode+' '+land_oms" presname="DataColumn" title="Landcode" type="1" /><DataColumn Last="1" digits="1" field="wijz_herk" presname="DataColumn" title="Herkomst wijzigb." type="8" /><DataColumn Last="0" digits="30" field="transact+' '+transact_oms" presname="DataColumn" title="CBS transactie" type="1" /><DataColumn Last="1" digits="1" field="wijz_trs" presname="DataColumn" title="Trans wijzigb." type="8" /><DataColumn Last="0" digits="30" field="stelsel+' '+stelsel_oms" presname="DataColumn" title="Statistisch stelsel" type="1" /><DataColumn Last="1" digits="1" field="wijz_stel" presname="DataColumn" title="Stelsel wijzigb." type="8" /><DataColumn Last="0" digits="30" field="vervoer+' '+vervoer_oms" presname="DataColumn" title="Vervoerswijze" type="1" /><DataColumn Last="1" digits="1" field="wijz_verv" presname="DataColumn" title="Vervoer wijzigb." type="8" /><DataColumn Last="0" digits="30" field="plts_ll+' '+plts_ll_oms" presname="DataColumn" title="Plaats laden/lossen" type="4" /><DataColumn Last="1" digits="1" field="wijz_ll" presname="DataColumn" title="Laden/lossen wijzig." type="8" /></InfoPage><ImagePanel field="'https://maps.google.nl/maps?q='+cmp_fadd1+',+'+cmp_fcity+'&output=embed'" presname="Picture" shrink="1" table="cicmpy" v="51" webclientAutoDownload="0" /><TitleColumn Compress="0" field="cmp_web" markup="0" presname="website" /><ImagePanel field="cmp_web is null?'':(charindex('://',cmp_web)=0?'//'+cmp_web:cmp_web)" presname="Figuur" table="cicmpy" v="51" webclientAutoDownload="0" /><TableList disableExcelExport="0" extraConstraint="bdr_na_bkn <> 0" passthru="1" presname="Open posten" table="dbopen" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="bkstnr" presname="Boekstuk" title="Boekstuk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="datum" format="d MMM yyyy" presname="Datum" title="Datum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms25" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="vervdatfak" format="d MMM yyyy" presname="Vervaldatum" title="Vervaldatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_na_bkn" format="#,##0.00" presname="Openstaand" title="Openstaand" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="val_na_bkn" format="#,##0.00" presname="Openstaand val" title="Openstaand val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oorsprbdr" format="#,##0.00" presname="Oorspronkelijk" title="Oorspronkelijk" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="dagbknr" presname="Dgbk" title="Dgbk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="@today-vervdatfak" presname="Te laat" title="Te laat" type="4"><ColorScheme field="@today-vervdatfak" footer="" header="" mode="Values" presname="background"><ColorValue color="White" presname="ColorValue" value="0" /><ColorValue color="Red" presname="ColorValue" value="100" /></ColorScheme><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TitleColumn Compress="0" field="HID" markup="0" /><TitleColumn Compress="0" field="Subject" markup="0" /><Translator presname="Vertaler"><FromTo from="bkstnr=" to="OurRef=" /><FromTo from="debnr=%" to="type=14)" /><FromTo from="bkstnr is null" to="1=2" /><ImagePanel field="document" presname="Picture" shrink="1" table="Bacodiscussions" v="51" webclientAutoDownload="0" /></Translator><Translator presname="Notitie"><FromTo from="bkstnr=" to="faktuurnr=" /><FromTo from="bkstnr is null" to="1=2" /><LookupTranslator extraConstraint="documentid is not null" table="gbkmut" v="4"><LookupTranslatorField constraint="1" field="documentid" /><Translator><FromTo from="documentid=" to="id=" /><NotitiePage field="body" table="bacodiscussions" top="0" /></Translator></LookupTranslator></Translator><TableList disableExcelExport="0" presname="Table" table="frhkrg" top="0" v="54"><TableColumn Aggregation="0" field="fakdat" format="d MMM yyyy" presname="Factuurdatum" title="Factuurdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="refer" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id.fullname" presname="Vertegenwoordiger" title="Vertegenwoordiger" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="orsrx" sortBy="regel" table="frhsrx" top="0" v="54"><TableColumn Aggregation="0" field="regel" title="R." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode" presname="Artikel" title="Artikel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms45" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="unitcode" title="Eenheid" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="esr_aantal/unitfactor" format="#,##0" title="Aantal Eenh." type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal Vk.Vp." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="korting/100" format="#,##0%" presname="Kort%" title="Kort%" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr.valcode" title="Val." type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)" format="#,##0.00" presname="Bedrag" title="Bedrag Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.btwper" format="#,##0.00" presname="BTW%" title="BTW%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijslijst" presname="Prijsl" title="Prijsl" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="magcode" presname="Mag" title="Mag" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="res_id.fullname + ' (' + res_id + ')'" title="Medewerker" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo from="faknr" to="OurRef" /><FromTo from="dagbknr=" to="'xyz'<>" /><FromTo from="fakdat=" to="'xyz'<>" /><TableList disableExcelExport="0" presname="Table" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="HID" format="#,##0" presname="HID" title="Nummer" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Subject" presname="Onderwerp" title="Onderwerp" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedDate" format="d MMM yyyy" presname="CreatedDate" title="Aangemaakt" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Type.Description" presname="Type" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="JobLevel" format="#,##0" presname="JobLevel" title="Beveiligingsniveau" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></Translator><ImagePanel field="document" presname="Picture" shrink="1" table="Bacodiscussions" v="51" webclientAutoDownload="0" /><TableList disableExcelExport="0" presname="Mutaties" table="debmut" top="0" v="54"><TableColumn Aggregation="0" field="bkjrcode" presname="Jaar" title="Jaar" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="periode" presname="Per" title="Per" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="datum" format="d MMM yyyy" presname="Datum" title="Datum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="dagbknr" presname="Dgbk" title="Dgbk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bkstnr" presname="Boekstuk" title="Boekstuk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms25" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_hfl" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Graph Compress="1" extraConstraint="%Constraint%" passthru="1" presname="Mutaties" table="debmut" v="50"><GraphColumnX field="datum" presname="Periode" type="2" /><GraphColumnY cumulate="1" field="bdr_hfl" graphType="4" marker="1" presname="Saldo" title="Saldo" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph><TableList disableExcelExport="0" presname="Mutaties" table="debmut" top="0" v="54"><TableColumn Aggregation="0" field="bkjrcode" presname="Jaar" title="Jaar" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="periode" presname="Per" title="Per" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="datum" format="d MMM yyyy" presname="Datum" title="Datum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="dagbknr" presname="Dgbk" title="Dgbk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bkstnr" presname="Boekstuk" title="Boekstuk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms25" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_hfl" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="orkrg" sortBy="orddat" table="televeren" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="nettobedrag" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijs_n_val*esr_aantal" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="orkrg.koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="orkrg.represent_id.fullname + ' (' + orkrg.represent_id + ')'" format="#" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(orkrg.fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(orkrg.fakdebnr)@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="orsrx" sortBy="regel" table="orsrx" top="0" v="54"><TableColumn Aggregation="0" field="regel" title="R." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode" presname="Artikel" title="Artikel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms45" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="unitcode" title="Eenheid" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="esr_aantal/unitfactor" format="#,##0" title="Aantal Eenh." type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal Vk.Vp." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="afldat=22991231?esr_aantal:0" format="#,##0" presname="Backorder" title="Wv. Back." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="aant_gelev" format="#,##0" presname="Gelev" title="Gelev." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="korting/100" format="#,##0%" presname="Kort%" title="Kort%" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr.valcode" title="Val." type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)" format="#,##0.00" presname="Bedrag" title="Bedrag Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.btwper" format="#,##0.00" presname="BTW%" title="BTW%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijslijst" presname="Prijsl" title="Prijsl" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="magcode" presname="Mag" title="Mag" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="instruction" presname="Instructieregel" title="Instructieregel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="res_id.fullname + ' (' + res_id + ')'" title="Medewerker" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo from="ordernr" to="OrderNumber" /><TableList disableExcelExport="0" presname="Table" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="HID" format="#,##0" presname="HID" title="Nummer" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Subject" presname="Onderwerp" title="Onderwerp" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedDate" format="d MMM yyyy" presname="CreatedDate" title="Aangemaakt" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Type.Description" presname="Type" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="JobLevel" format="#,##0" presname="JobLevel" title="Beveiligingsniveau" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></Translator><ImagePanel field="document" presname="Picture" shrink="1" table="Bacodiscussions" v="51" webclientAutoDownload="0" /><TableList disableExcelExport="0" extraConstraint="afgehandld='J' and ord_soort='V'" presname="orkrg" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_ev_val*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_ev_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.vrachtkost*koers" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.orderkost*koers" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="order_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdebnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="frkrg" table="frkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="fakt_code" presname="Fc" title="Fc" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Constraint="1" field="volgnr_fak" presname="Nr" title="Nr" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_ev_val*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_ev_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="[inv_in_vv='J']?[[frkrgx.vrachtkost*koers]:frkrgx.vrachtkost]" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="[inv_in_vv='J']?[[frkrgx.orderkost*koers]:frkrgx.orderkost]" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakt_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdebiteur" title="Orderdebiteur" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="Facturen" sortBy="regel" table="frsrg" top="0" v="54"><TableColumn Aggregation="0" field="regel" title="r." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode" title="Artikelcode" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms45" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="unitcode" title="Eenheid" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="esr_aantal/unitfactor" format="#,##0" title="Aant. Eenh." type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aant. Vk. Verp." type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" title="Br. Prijs Val " type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="korting/100" format="#,##0%" presname="Kort%" title="Kort%" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" presname="Prijs" title="Netto Pr. Val " type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)" format="#,##0.00" presname="Bedrag val" title="Bedrag Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="frkrg.valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.btwper" format="#,##0.00" presname="BTW%" title="BTW%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijslijst" presname="Prijsl" title="Prijsl" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="magcode" presname="Mag" title="Mag" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="fakdebnr=debnr" presname="frhkrg" table="frhkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="faknr" presname="Factuur" title="Factuur" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Constraint="1" field="fakdat" format="d MMM yyyy" presname="Factuurdatum" title="Factuurdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="tot_bdr" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="tot_bdr/koers" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="[inv_in_vv='J']?[[frhkrgx.vrachtkost*koers]:frhkrgx.vrachtkost]" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="[inv_in_vv='J']?[[frhkrgx.orderkost*koers]:frhkrgx.orderkost]" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakt_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(orddeb)@(cicmpy:ix_debnr.debcode)" presname="Orderdebiteur" title="Orderdebiteur" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddeb@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03]
" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="SV_OmzetFact__pkg__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Assortment" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Assortment.Description" fieldLevelType="2" 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="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03]
" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1) %AddConstraint%" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="SV_OmzetFact__pkg__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Description" fieldLevelType="2" 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="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 7-2-2019 15:11:52]
" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table="SV_OmzetFact__pkg__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="3" field="periode" fieldLevelType="2" format="0" sortType="1" title="'Maand'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},omzet, 0.0)as OmzDJ" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + #{year}"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVJ" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + (CAST(#{year} as INT)-1)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="#OmzDJ-#OmzVJ as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="13" field="#vrs" field2="#OmzVJ" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="MAX(#{year}-1) as PrevYear" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:44:17]
" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="{(select bkjrcode from perdat where fakdat >= bgdatum and fakdat <= eddatum)} = #{year} AND {(select per_fin from perdat where fakdat >= bgdatum and fakdat <= eddatum)} <= #{periode}" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="0" queryHeaders="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table="FRHSRG" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="2" field="fakdat" fieldLevelType="2" format="d MMM yyyy" sortType="1" title="Datum"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Compress="1" Hidden="0" crossTreeType="1" field="faknr" fieldLevelType="2" sortType="1" title="Faktuurnr"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr" fieldLevelType="2" title="Klant"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr.naam" fieldLevelType="2" title="Klant naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr.woonpl" fieldLevelType="2" title="Plaats"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr.landcode" fieldLevelType="2" title="Land"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="esr_aantal" fieldLevelType="2" format="#,##0.00" title="Aantal"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(prijs_n*esr_aantal) * koers" fieldLevelType="2" format="#,##0.00" title="Omzet"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:44:17]
" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="{(select bkjrcode from perdat where fakdat >= bgdatum and fakdat <= eddatum)} = #{year}-1 AND {(select per_fin from perdat where fakdat >= bgdatum and fakdat <= eddatum)} <= #{periode}" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="0" queryHeaders="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table="FRHSRG" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="2" field="fakdat" fieldLevelType="2" format="d MMM yyyy" sortType="1" title="Datum"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Compress="1" Hidden="0" crossTreeType="1" field="faknr" fieldLevelType="2" sortType="1" title="Faktuurnr"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr" fieldLevelType="2" title="Klant"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr.naam" fieldLevelType="2" title="Klant naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr.woonpl" fieldLevelType="2" title="Plaats"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="(faknr:fakdat:dagbknr)@FRHKRG.debnr.landcode" fieldLevelType="2" title="Land"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="esr_aantal" fieldLevelType="2" format="#,##0.00" title="Aantal"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(prijs_n*esr_aantal) * koers" fieldLevelType="2" format="#,##0.00" title="Omzet"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="1" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" hideColOfTotals="0" hideCorner="0" hideResultTitles="1" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" presname="panel2" queryHeaders="0" rowLevelExpanded="0" selectionMode="2" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="3" table="omzdeb" v="55"><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="boekjr" fieldLevelType="0" footerString="Tot"><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="periode" fieldLevelType="1" footerString="Tot"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="omzet" fieldLevelType="2" format="#,##0.00"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><Pie field="omzet" otherIsClickable="1" passthru="1" showLegend="1" table="SV_OmzetFact__pkg__" v="44"><PieField compress="1" constraint="1" field="artcode@items.assortment.description" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Pie><TableList disableExcelExport="0" table="SV_OmzetFact__pkg__" top="0" v="54"><TableColumn Aggregation="0" Compress="1" field="artcode" title="Artikelcode" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode@ITEMS.Description" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" title="Omzet (netto)" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="joblevel<=10" passthru="1" presname="Tabel" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Compress="1" field="Type.Description" presname="Type Document" title="Type Document" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" Hidden="1" field="type" presname="TableColumn" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="sum(1)" format="#,##0" presname="Aantal" title="Aantal" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="joblevel<=10" presname="Tabel" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="HID" format="#,##0" presname="Documentnummer" title="Documentnummer" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedByFullName" presname="Aanmaker" title="Aanmaker" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Subject" presname="Onderwerp" title="Onderwerp" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedDate" format="d MMM yyyy" presname="Aanmaakdatum" title="Aanmaakdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="OrderNumber" presname="Ordernummer" title="Ordernummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="OurRef" presname="Factuurnummer" title="Factuurnummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><ImagePanel field="document" presname="Figuur" table="bacodiscussions" v="51" webclientAutoDownload="0" /><TableList disableExcelExport="0" extraConstraint="joblevel<=10" presname="Tabel" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="HID" format="#,##0" presname="Documentnummer" title="Documentnummer" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedByFullName" presname="Aanmaker" title="Aanmaker" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Subject" presname="Onderwerp" title="Onderwerp" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedDate" format="d MMM yyyy" presname="Aanmaakdatum" title="Aanmaakdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="OrderNumber" presname="Ordernummer" title="Ordernummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="OurRef" presname="Factuurnummer" title="Factuurnummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><ImagePanel field="document" presname="Figuur" table="bacodiscussions" v="51" webclientAutoDownload="0" /><ReportGenerator bottommargin="10" leftmargin="10" pageNumbers="2" paperheight="297" paperwidth="210" presname="Rapportverwijzing" rightmargin="10" titleBackground="" titleBackground2="" titleForeground="" topmargin="10" webclientAutoDownload="0"><ReportLayout presname="Report Layout"><ReportItem presname="Bovenste 4 panelen" reportLayoutAlignment="left" reportLayoutHeight="135" reportLayoutOccurrence="single" reportLayoutWidth="180"><Splitter mode="2" orientation="horizontalBar" presname="Splitter" splitPosition="0"><Splitter mode="2" orientation="verticalBar" presname="Splitter" splitPosition="500"><Title background="" fontsize="2" foreground="" lookupConstraint="debnr=#{debnr}" lookupTable="cicmpy" markup="0" presname="Title" title="#{cmp_name}"><InfoPage presname="Datapanel" table="cicmpy"><DataColumn Last="1" digits="25" field="debcode" presname="Relatie" title="Relatie" type="1" /><DataColumn Last="1" digits="25" field="cmp_name" presname="Naam" title="Naam" type="1" /><DataColumn Last="1" digits="25" field="cmp_fadd1" presname="Adres" title="Adres" type="1" /><DataColumn Last="1" digits="25" field="cmp_fpc" presname="Postcode" title="Postcode" type="1" /><DataColumn Last="1" digits="25" field="cmp_fcity" presname="Plaats" title="Plaats" type="1" /><DataColumn Last="1" digits="0" field="''" presname="DataColumn" type="1" /><DataColumn Last="1" digits="0" field="''" presname="DataColumn" type="1" /><DataColumn Last="1" digits="0" field="''" presname="DataColumn" type="1" /><DataColumn Last="1" digits="0" field="''" presname="DataColumn" type="1" /><DataColumn Last="1" digits="0" field="''" presname="DataColumn" type="1" /><DataColumn Last="1" digits="0" field="''" presname="DataColumn" type="1" /></InfoPage><TitleColumn Compress="0" field="cast(@today as date) as afdrukdatum" markup="0" /><Graph Compress="1" fontsize="1" passthru="1" presname="Mutaties" table="debmut"><GraphColumnX field="datum" presname="Periode" title="Periode" type="2" /><GraphColumnY cumulate="1" field="bdr_hfl" presname="Saldo" title="Debiteurensaldo" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph><TitleColumn Compress="0" field="setup.eaccount_default_boekjaar" markup="0" /><Pie extraConstraint="boekjr=setup.eaccount_default_boekjaar" field="omzet" having="sum(omzet)>0" showLegend="1" sortBy="sum(omzet) desc" table="OMZGRP" v="44"><PieField compress="1" constraint="1" field="artgrp@itemassortment.description" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Pie><TitleColumn Compress="0" field="setup.eaccount_default_boekjaar as ditjaar" markup="0" /><TitleColumn Compress="0" field="cast(setup.eaccount_default_boekjaar as int)-1 as vorigjaar" markup="0" /><Graph25D Compress="1" extraConstraint="(boekjr=setup.eaccount_default_boekjaar OR boekjr=cast(cast(setup.eaccount_default_boekjaar as int)-1 as varchar(4)))" fontsize="2" legend="1" passthru="1" presname="2.5D Graph" table="SV_OmzetFact__pkg__"><GraphColumnX field="periode" presname="Xcolumn" title="Periode" type="-1" /><GraphColumnY25D field="omzet" presname="Omzet" title="Omzet" /><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="3" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TitleColumn Compress="0" field="sum(bdr_na_bkn)" markup="0" presname="TitleColumn" /><TableList disableExcelExport="0" extraConstraint="bdr_na_bkn <> 0" fontsize="2" passthru="1" presname="Open posten" table="dbopen" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="bkstnr" presname="Boekstuk" title="Boekstuk" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="datum" format="d MMM yyyy" presname="Datum" title="Datum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms25" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="vervdatfak" format="d MMM yyyy" presname="Vervaldatum" title="Vervaldatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_na_bkn" format="#,##0.00" presname="Openstaand" title="Openstaand" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oorsprbdr" format="#,##0.00" presname="Oorspronkelijk" title="Oorspronkelijk" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="@today-vervdatfak" presname="Te laat" title="Te laat" type="4"><ColorScheme field="@today-vervdatfak" footer="" header="" mode="Values" presname="background"><ColorValue color="White" presname="ColorValue" value="0" /><ColorValue color="Red" presname="ColorValue" value="100" /></ColorScheme><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" fontsize="2" presname="orkrg" sortBy="orddat" table="televeren" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="nettobedrag" format="#,##0.00" title="Totaalbedrag incl. korting" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijs_n_val*esr_aantal" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList>
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
IIF(k.afgehandld=0 AND uitgifte=0,1,0) as Televeren,
k.ordernr ordernr,
k.debnr,
k.refer,
k.docnumber,
k.orddat,
k.ordbv_afgd,
k.ordbv_afdr,
k.selcode,
k.represent_id,
s.regel,
s.afldat,
s.artcode,
s.ar_soort,
s.oms45,
s.oms45_f,
s.magcode,
s.esr_aantal,
s.unitfactor,
s.unitcode,
s.esr_aantal / s.unitfactor aantverp,
s.prijslijst,
s.projectnr,
s.gip * k.koers gip,
s.gip * s.esr_aantal * k.koers gipbedrag,
s.vvp * k.koers vvp,
s.vvp * s.esr_aantal * k.koers vvpbedrag,
s.korting korting,
case b.exclus
when 'I' then s.prijs83 / ((100 + s.bdr_vat_val) /100)
else prijs83 end * k.koers prijs83,
case b.exclus
when 'I' then s.prijs83 / ((100 + s.bdr_vat_val) /100)
else prijs83 end * k.koers * s.esr_aantal brutobedrag,
case b.exclus
when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100)
else s.prijs_n end * k.koers prijs_n,
case b.exclus
when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100)
else s.prijs_n end * s.esr_aantal * k.koers nettobedrag,
k.valcode,
case b.exclus
when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100)
else s.prijs_n end prijs_n_val,
s.btw_code,
s.bdr_vat_val,
s.bdr_vat_val/100*((case b.exclus
when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100)
else s.prijs_n end) * s.esr_aantal * k.koers) bdr_vat,
((s.bdr_vat_val/100)+1) * ((case b.exclus
when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100)
else s.prijs_n end) * s.esr_aantal * k.koers) bdr_incl_vat,
s.PlannedDate,
s.RequestedDate,
s.OriginalPlannedDate,
s.purchaseordernr,
s.regel_hfda
FROM orsrg s INNER JOIN orkrg k ON s.ordernr = k.ordernr
INNER JOIN btwtrs b on s.btw_code=b.btwtrans
WHERE k.ord_soort IN('V','A') AND s.ar_soort<>'P'
artcode
debnr
represent_id
btw_code
valcode
magcode
projectnr
SELECT *
,NettoPrijs * aantal as omzet
,BrutoMarge * aantal as marge
,BrutoPrijs * aantal as OmzetBruto
,bkjrcode boekjr
,fakdebnr debnr
FROM (
SELECT artcode, assortment artgrp, s.fakdat Datum, k.fakdebnr, esr_aantal aantal
,CASE b.exclus
WHEN 'E' THEN (prijs83)
WHEN 'I' THEN prijs83 / ((100 + b.btwper) /100)
ELSE prijs83 END
* s.koers as BrutoPrijs
,CASE b.exclus
WHEN 'E' THEN (prijs_n)
WHEN 'I' THEN prijs_n / ((100 + b.btwper) /100)
ELSE prijs_n END
* s.koers as NettoPrijs
,(CASE b.exclus
WHEN 'E' THEN prijs_n
WHEN 'I' THEN (prijs_n/ ((100 + b.btwper) /100))
ELSE prijs_n END - vvp )
* s.koers as BrutoMarge
,(SELECT top 1 bkjrcode FROM perdat WHERE s.fakdat<=eddatum ORDER BY eddatum) bkjrcode
,(SELECT top 1 per_fin FROM perdat WHERE s.fakdat<=eddatum ORDER BY eddatum) periode
FROM frhsrg s
INNER JOIN frhkrg k ON s.faknr = k.faknr and s.fakdat = k.fakdat
INNER JOIN btwtrs b ON s.btw_code = b.btwtrans
INNER JOIN items i ON s.artcode=i.itemcode and i.type <> 'P'
) a
artcode
debnr
artgrp