Sumatra_Package 'cJ p 1
¾jg˜£m0¡E™¢ç4æTÄà ž cc``cPÉÌKIÐwI,qËÌIõM-IÔ«ÈÍab0ܽ¯Gþ>Œ„© .IÌ-(†(2åØ ¾ÿî=s(-‡¢(8/± 8#¿¤X?7?Å@/)3‰ÁªÒ JKÀt8çç•$fæ¥!œ¯Q“¥yróSJsR!æ10,†Š/ÒB )‰%‰¹ù)©9ú¥Å©E Sø×@< ¥š „ „ *¤xhõ‚u ¤|ÊdÁCue…©O2‡ÏÏà
ïø–¹þ°º? Ìõ£Cý_ ; ×w‡ ¥FPiL· Ð + Xî Xî ÂP zã ëbÅY¸.Òñ×ZT[¬×¹Í»Ÿ—m˜ ƒ
› › ®ûbDxÃ~xíÇ| ×p¦áÁó.LP±ã|¦u¦Õù‹ ÚR ÚR n•»c÷‡NÇcŽ®ªQˆ FÀSx§g˜Þ;+¹~@
Q ø] )q D6Vö/Å9¼×vÔËþ¼ìéNm¶Eýï "¥§"Å â`@vqâÌó°ªS8MMƒp;2²Õw¹9¼Pò‚±Î
0505a
__pkg_Debiteuren11_s6n4m29s8hq6c__pp__
This version of the Builder is no longer supported and cannot be used to open this file.
Please update to version 5.1.8580 or later to open this file.
This file was created with version 5.5.1355 of the Builder.
Continuing will downgrade the file and may cause minor differences in functionality.
Debiteuren
LightPlusDark
Placeholder
1
mod0
CMJQIHrjoOtixVkRuC7S8ddaVFus17kRzbuflxJtBpg=
540
2026-07-09T13:36:56.7099085Z
https://licensejwt1.vault.azure.net/keys/ModuleStamping/9d40d28b9c73483bb45c07d9d85b9bfa
0VrAL/WwhZAt4FiTj/dncc3KY7ib06gSuwi439xlAvh1jnXjFB4O5YcGnTK90elrHjP5VXsknxLIZkwpjMFV+wxmgJXj4AtjSjPiHE9v1hTRIer8uykgGBMLF8INzMywU/ErAFoQD1GW14BWO7bjpitX7H3qu0SG6OYNMkSNydFO0TzoM7OFh2Yc58rtZCJRReR2oitmXxPzJfURhfsijjx4orjeOVvQqYnPcv63u2HoHL51OEXVklNi16GUoPHE/IYOd+Xs4Y/QAr7Ocmq3Jg4xS1H4H2wFnTrSFTnPn/Mgcn0BcZVGBy86A4VS0Pfxwnq1eEoEfYklu7A5JRfvvA==
ProdVer
5.5
Ver0505acolor5113, 188, 158color2180, 186, 144)colorTheme3IdisableExcelExport0iconid:14!presname)Debiteurentouch2v 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_lijstînameLabel2valueKlant î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=extraConstraint•debcode is not null and cmp_type<>'E'!presnamecicmpysortBy debcodetablecicmpy
top0v 54
Ê
-Aggregation0field debcode!presname!Debiteurtitle!%Label2%type4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!cmp_name!presnameNaamtitleNaamtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field cmp_fpc!presname!Postcodetitle!Postcodetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field%cmp_fcity!presnamePlaatstitlePlaatstype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0)Constraint1Hidden1fielddebnr!presname9Debiteurnummertitle9Debiteurnummertype4àfooterheadermodeValues!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__
top1v7Ëfieldjaar Ëfield5Jaar-1 as Jr1 Ëfieldmaand | =extraConstraintÝ(boekjr=#{jaar} OR boekjr=#{Jr1}) AND periode<=#{maand}namecOMZETrowNum0tableISV_OMZETFIN__PKG__
top0v 51{fieldboekjr {field artcode {field¡artcode@ITEMS.Description as Description {field periode {fieldomzet {fieldreknr {fieldQreknr.oms25 as oms25 {fielddebnr V columns 30v 50» colspan8*
)background-disableMenu0)foregroundmarkup0title¹Omzet #{jaar} {#name:Maand#prefix: t/m maand }V columns 10)syncPanels1v 50» colspan 10€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 » colspan 10V columns 10)syncPanels1v 50» colspan2€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 » colspan6€=clickConstraint9debnr=#{debnr} commentQ content‰{#name:ODJ#format:##,####0}!fontsize4MhorizontalAlignment11marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table :cOMZETEverticalAlignment1«field©sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ «fieldísum(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 » colspan2€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 » colspan 10V columns 10)syncPanels1v 50
» colspan3€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 » € content#{icon}MhorizontalAlignment01marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table :cOMZETEverticalAlignment2 «field©sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ «fieldísum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ «fieldA#ODJ-#OVJ as vrs «field¡iif(#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
«field©sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ «fieldísum(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 » colspan3€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 » colspan 10€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 » 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 field•IIF(boekjr=#{jaar},omzet, 0.0) as ODJ%graphType5titley{#name:jaar#init:YEAR(@today)} fieldÙIIF((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)foregroundmarkup0title¹Omzet #{jaar} {#name:Maand#prefix: t/m maand }R=extraConstraint9boekjr=#{jaar}fieldomzet!passthru1)showLegend2sortBy)SUM(omzet)table :cOMZETv 44 [fieldireknr+' - '+oms25 as label [!compress1)constraint1fieldreknr [!compress1fieldoms25 [!compress1field9boekjr as jaar [!compress1)constraint1fielddebnr 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 » V columns 30v 50» colspan 16x)linkTarget9Deb_BetaalGrafv 50îname)Constraintvaluebkjrcode>=SV_DEFAULTS__pkg__.jaar-1 » colspan 14vname1Deb_OpenPost*)background)foregroundmarkup0titleIOpenstaande postenV columns3)syncPanels1v 50» rowspan3€=clickConstraint
2=2 content📥!fontsize4MhorizontalAlignment11passIncoming1tableDBOPENEverticalAlignment1 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 rowspan2€ =clickConstraint
2=2 content¥Saldo: {#name:bdr#format:€ ##,####0.00}MhorizontalAlignment01passIncoming1tableDBOPENEverticalAlignment1«fieldYSUM(bdr_na_bkn) as bdr 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€=clickConstraint
2=2 contentµVervallen: {#name:bdr#format:€ ##,####0.00}=extraConstraintIvervdatfak<=@TodayMhorizontalAlignment01passIncoming1tableDBOPENEverticalAlignment1«fieldYSUM(bdr_na_bkn) as bdr 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 Ì%conditiondebnr=B
ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__
top1v7Ëfield9Jaar as {year} ËfieldU#{periode} as {month} mode0-orientation5horizontalBar5splitPosition
500vnameQOmz_JrVrg_ArtGrp_FIN*
)background-disableMenu0)foregroundmarkup0title±Artikelgroep{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment¹[Converted from Table on 13-2-2019 13:37:03]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintg(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1) and debnr=#{debnr}=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableISV_OmzetFin__pkg__v 55è-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldaartcode@ITEMS.Assortment9fieldLevelType2!sortType1title'Code'àfooterheadermodeValues æfooterheadermodeValues è -Aggregation0Hidden05crossTreeType1field‘artcode@ITEMS.Assortment.Description9fieldLevelType2title'Naam'àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3field•IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title©'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3fieldáIIF((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 vnameEOmz_JrVrg_Art_FIN*
)background-disableMenu0)foregroundmarkup0titleArtikel{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 comment¹[Converted from Table on 13-2-2019 13:37:03]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintg(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1) and debnr=#{debnr}=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableISV_OmzetFin__pkg__v 55è-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1field artcode9fieldLevelType2!sortType1title'Code'àfooterheadermodeValues æfooterheadermodeValues è -Aggregation0Hidden05crossTreeType1fieldeartcode@ITEMS.Description9fieldLevelType2title'Naam'àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3field•IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title©'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3fieldáIIF((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 Ì%condition!periode=B
ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__
top1v7Ëfield9Jaar as {year} ËfieldU#{periode} as {month} mode0-orientation5horizontalBar5splitPosition
500x)linkTargetQOmz_JrVrg_ArtGrp_FINv 50 x)linkTargetEOmz_JrVrg_Art_FINv 50 Ì%condition%(artcode=B
ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__
top1v7Ëfield9Jaar as {year} ËfieldU#{periode} as {month} vnameEOmz_JrVrg_Artikelîname5AddConstraint *
)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 è-Aggregation1Hidden05crossTreeType3field•IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title©'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3fieldáIIF((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 Ì%condition (datum=*)background)foregroundmarkup0titleùMutaties {#name:datum#prefix:Datum }|||#{debcode} #{cmp_name}
IdisableExcelExport0!presname!Mutatiestabledebmut
top0v 54Ê
-Aggregation0field!bkjrcode!presnameJaartitleJaartype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field periode!presname
Pertitle
Pertype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldbkstnr!presname!Boekstuktitle!Boekstuktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation1field bdr_hflformat!#,##0.00!presnameBedragtitleBedragtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field bdr_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field valcode!presname
Valtitle
Valtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ì%condition(2=2*)background)foregroundmarkup0title¹Openstaande posten |||#{debcode} - #{cmp_name}IdisableExcelExport0=extraConstraint=bdr_na_bkn <> 0!fontsize2!passthru1!presname-Open postentabledbopen
top0v 54Ê -Aggregation0)Constraint1fieldbkstnr!presname!Boekstuktitle!Boekstuktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field)vervdatfakformat)d MMM yyyy!presname-Vervaldatumtitle-Vervaldatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation1field)bdr_na_bknformat!#,##0.00!presname)Openstaandtitle)Openstaandtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldE@today-vervdatfak!presname Te laattitle Te laattype4à
fieldE@today-vervdatfakfooterheadermodeValues!presname)backgroundâcolorWhite!presname)ColorValuevalue0 âcolor
Red!presname)ColorValuevalue
100 æfooterheadermodeValues Ì%conditionreknr=*
)background-disableMenu0)foregroundmarkup0titleOmzet n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3 commentµ[Converted from Table on 7-2-2019 15:11:52]
5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraintÑ(boekjr<=#{jaar} AND boekjr>=CAST(#{jaar} as INT)-1)=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style20tableISV_OMZETFIN__PKG__v 55è-Aggregation0!Compress1)Constraint1Hidden05crossTreeType3field periode9fieldLevelType2format0!sortType1title 'Maand'kcolor5negativeColor àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3field™IIF(boekjr=#{jaar},omzet, 0.0)as OmzDJ9fieldLevelType2format!#,##0.00titleI'Omzet ' + #{year}kcolor5negativeColor àfooterheadermodeValues æfooterheadermodeValues è-Aggregation1Hidden05crossTreeType3fieldáIIF((boekjr=CAST(#{jaar} 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(#{jaar}-1) as PrevYear9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1 Ì%condition!ordernr=vnameMVerkooporderdetailsmode2-orientation-verticalBar!presname!Verdeler5splitPosition
800*
)background)foregroundmarkup0!presname%SubregelstitleqOrderregels order #{ordernr} IdisableExcelExport0!presnameorsrxsortByregeltableorsrx
top0v 54(Ê-Aggregation0fieldregeltitle R.type4àfooterheadermodeValues æfooterheadermodeValues Ê
-Aggregation0field artcode!presname Artikeltitle Artikeltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms45!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0field!unitcodetitle Eenheidtype1àfooterheadermodeValues æfooterheadermodeValues Ê
-Aggregation0fieldUesr_aantal/unitfactorformat#,##0title1Aantal Eenh.type6àfooterheadermodeValues æfooterheadermodeValues Ê-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitle5Aantal Vk.Vp.type6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0!Negative1!Positive1fieldqafldat=22991231?esr_aantal:0format#,##0!presname%Backordertitle%Wv. Back.type6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0!Negative1!Positive1field)aant_gelevformat#,##0!presnameGelevtitleGelev.type6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field·btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field·btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6àfooterheadermodeValues æfooterheadermodeValues Ê-Aggregation0field=ordernr.valcodetitleVal.type1àfooterheadermodeValues æfooterheadermodeValues Ê -Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presnameBedragtitle)Bedrag Valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation1field…esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleBedragtype6àfooterheadermodeValues æfooterheadermodeValues Ê -Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field magcode!presname
Magtitle
Magtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field-instruction!presname=Instructieregeltitle=Instructieregeltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0field•res_id.fullname + ' (' + res_id + ')'title)Medewerkertype1àfooterheadermodeValues æfooterheadermodeValues mode0-orientation5horizontalBar!presname)Documenten5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleUGekoppelde documenten!presname)TranslatorÎfrom ordernr to-OrderNumber
IdisableExcelExport0!presnameTabletable=bacodiscussions
top0v 54
Ê-Aggregation0)Constraint1field
HIDformat#,##0!presname
HIDtitleNummertype3àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field-CreatedDateformat)d MMM yyyy!presname-CreatedDatetitle)Aangemaakttype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldAType.Description!presnameTypetitleTypetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field!JobLevelformat#,##0!presname!JobLeveltitleIBeveiligingsniveautype3àfooterheadermodeValues!presname)background æfooterheadermodeValues *
)background)foregroundmarkup0!presnameTitletitle!Document field!document!presname Pictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0 Ì . ì)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 20fieldµClassificationId+' '+ClassificationId.ml_desc!presname%Categorietitle%Categorietype1 Ê Last0digits 32field%cmp_fadd1!presnameAdrestitleAdrestype1 Ê Last1digits 20fieldçcmp_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 Ê
field™cmp_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 Ê field÷cmp_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)foregroundmarkup0title©Contactpersonen|||#{debcode} - #{cmp_name}
IdisableExcelExport0!presnameTabletableCICNTP
top0v 54Ê-Aggregation0)Constraint1Hidden1fieldcnt_id!presname IDtitle IDtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!Predcode!presnameTiteltitleTiteltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!Initials!presname-Voorletterstitle%Initialentype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!FullName!presnameNaamtitleNaamtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldGender!presname!Geslachttitle
M/Vtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field1cnt_job_desc!presnameMFunctieomschrijvingtitle Functietype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field%cnt_f_tel!presname!Telefoontitle!Telefoontype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field1cnt_f_mobile!presnameAMobiele telefoontitleMobieltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0Hidden1field‘cnt_email<>''?'mailto:'+cnt_email:''!presnameALink naar e-mailtype 12àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field%cnt_email!presnameE-mailtitleE-mailtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!active_y!presnameActieftitleActieftype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fielducnt_id=cmp_wwn.cnt_id?'J':'N'!presnameHoofdtitleHoofdtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues )expandTabs1!presname!Notebookv 52ì)background)foregroundtitle!Adressen Îfromcnt_id to5contactperson *
)background)foregroundmarkup0!presnameTitletitleYAdressen|||#{FullName}
IdisableExcelExport0!presnameTabletable%addresses
top0v 54Ê
-Aggregation0fieldType!presnameTypetitleTypetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field1AddressLine1!presname1Adresregel 1title1Adresregel 1type1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!PostCode!presname!Postcodetitle!Postcodetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldCity!presnamePlaatstitlePlaatstype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field Country!presname!Landcodetitle!Landcodetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldMain!presnameHoofdtitleHoofdtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field=KeepSameAsVisit!presnameAKopie Bezoekadr.titleAKopie Bezoekadr.type1àfooterheadermodeValues!presname)background æfooterheadermodeValues ì)background)foregroundtitle5Visitekaartje*)background)foregroundmarkup0titlemVisitekaartje|||#{FullName}
field picture!presname Picturetablecicntpv 51UwebclientAutoDownload0 ì)background)foregroundtitle!Adressen*)background)foregroundmarkup0title¡Hoofdadressen|||#{debcode} - #{cmp_name}!presname)TranslatorÎfrom cmp_wwn to Account IdisableExcelExport0=extraConstraint!main='J'!presnameTabletable%addresses
top0v 54Ê
-Aggregation0fieldType!presnameTypetitleTypetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field1AddressLine1!presname1Adresregel 1title1Adresregel 1type1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field1AddressLine2!presname1Adresregel 2title1Adresregel 2type1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field!PostCode!presname!Postcodetitle!Postcodetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldCity!presnamePlaatstitlePlaatstype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field Country!presname!Landcodetitle!Landcodetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldYContactPerson.FullName!presname Contacttitle9Contactpersoontype1àfooterheadermodeValues!presname)background æfooterheadermodeValues ì)background)foregroundtitle!Notities*)background)foregroundmarkup0titleNotities|||#{debcode} - #{cmp_name}field!cmp_note!presname!Notitiestablecicmpy
top0 ì)background)foregroundtitle5BTW/IntrastatBtablecicmpyv4Ë)constraint1fielddebnr *)background)foregroundmarkup0title¥BTW/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}-lookupTablecicmpymarkup0titleµWebsite #{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)foregroundmarkup0title¹Openstaande posten |||#{debcode} - #{cmp_name}IdisableExcelExport0=extraConstraint=bdr_na_bkn <> 0!passthru1!presname-Open postentabledbopen
top0v 54Ê -Aggregation0)Constraint1fieldbkstnr!presname!Boekstuktitle!Boekstuktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field)vervdatfakformat)d MMM yyyy!presname-Vervaldatumtitle-Vervaldatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation1field)bdr_na_bknformat!#,##0.00!presname)Openstaandtitle)Openstaandtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field)val_na_bknformat!#,##0.00!presname9Openstaand valtitle9Openstaand valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field valcode!presname
Valtitle
Valtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field%oorsprbdrformat!#,##0.00!presname9Oorspronkelijktitle9Oorspronkelijktype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldE@today-vervdatfak!presname Te laattitle Te laattype4à
fieldE@today-vervdatfakfooterheadermodeValues!presname)backgroundâcolorWhite!presname)ColorValuevalue0 âcolor
Red!presname)ColorValuevalue
100 æfooterheadermodeValues )expandTabs1!presname!Notebookv 52ì)background)foregroundtitle!Document!presname!VertalerÎfrom 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!VertalerÎfrom bkstnr= to OurRef= Îfrom debnr=% to!type=14) Îfrom9bkstnr is null to
1=2 field!document!presname Pictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0 ì)background)foregroundtitle!Notities!presname NotitieÎfrom bkstnr= to)faktuurnr= Îfrom9bkstnr is null to
1=2 *
)background)foregroundmarkup0!presname!NotitiestitleINotities #{bkstnr}!presname NotitieÎfrom 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)foregroundmarkup0title…Factuurgegevens factuur #{bkstnr}
IdisableExcelExport0!presnameTabletablefrhkrg
top0v 54Ê -Aggregation0fieldfakdatformat)d MMM yyyy!presname1Factuurdatumtitle1Factuurdatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldrefer!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldUrepresent_id.fullname!presnameEVertegenwoordigertitleEVertegenwoordigertype1àfooterheadermodeValues!presname)background æfooterheadermodeValues vnameYFactuurhistoriedetailsmode2-orientation-verticalBar!presname!Verdeler5splitPosition
800*)background)foregroundmarkup0titleYFactuurregels #{faknr} IdisableExcelExport0!presnameorsrxsortByregeltablefrhsrx
top0v 54"Ê-Aggregation0fieldregeltitle R.type4àfooterheadermodeValues æfooterheadermodeValues Ê
-Aggregation0field artcode!presname Artikeltitle Artikeltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms45!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0field!unitcodetitle Eenheidtype1àfooterheadermodeValues æfooterheadermodeValues Ê
-Aggregation0fieldUesr_aantal/unitfactorformat#,##0title1Aantal Eenh.type6àfooterheadermodeValues æfooterheadermodeValues Ê-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitle5Aantal Vk.Vp.type6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field·btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field·btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6àfooterheadermodeValues æfooterheadermodeValues Ê-Aggregation0field=ordernr.valcodetitleVal.type1àfooterheadermodeValues æfooterheadermodeValues Ê -Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presnameBedragtitle)Bedrag Valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation1field…esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleBedragtype6àfooterheadermodeValues æfooterheadermodeValues Ê -Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field magcode!presname
Magtitle
Magtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0field•res_id.fullname + ' (' + res_id + ')'title)Medewerkertype1àfooterheadermodeValues æfooterheadermodeValues mode0-orientation5horizontalBar!presname)Documenten5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleUGekoppelde documenten!presname)TranslatorÎfromfaknr toOurRef Îfrom!dagbknr= to 'xyz'<> Îfrom fakdat= to 'xyz'<>
IdisableExcelExport0!presnameTabletable=bacodiscussions
top0v 54
Ê-Aggregation0)Constraint1field
HIDformat#,##0!presname
HIDtitleNummertype3àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field-CreatedDateformat)d MMM yyyy!presname-CreatedDatetitle)Aangemaakttype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldAType.Description!presnameTypetitleTypetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field!JobLevelformat#,##0!presname!JobLeveltitleIBeveiligingsniveautype3àfooterheadermodeValues!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!presnameJaartitleJaartype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field periode!presname
Pertitle
Pertype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldbkstnr!presname!Boekstuktitle!Boekstuktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation1field bdr_hflformat!#,##0.00!presnameBedragtitleBedragtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field bdr_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field valcode!presname
Valtitle
Valtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6àfooterheadermodeValues!presname)background æfooterheadermodeValues ì)background)foregroundtitle1Betaalgedrag)hideSearch1v 54Ê field!bkjrcodeflags8format 00!presnameJaartitleJaartype9ø)constraintabkjrcode<=YEAR(@today)+2 groupby!bkjrcode-initialText)-- Alle -- orderby5bkjrcode desc9resetSelection0!selected‰bkjrcode=SV_DEFAULTS__pkg__.Jaar-1tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0 mode0-orientation5horizontalBar5splitPosition
500vname9Deb_BetaalGrafîname)Constraint *)background)foregroundmarkup0title5Betaalgedrag !Compress1=extraConstraint1%Constraint%!passthru1!presname!Mutatiestabledebmutv 50ûfielddatum!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)foregroundmarkup0titleùMutaties {#name:datum#prefix:Datum }|||#{debcode} #{cmp_name}
IdisableExcelExport0!presname!Mutatiestabledebmut
top0v 54Ê
-Aggregation0field!bkjrcode!presnameJaartitleJaartype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field periode!presname
Pertitle
Pertype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fielddatumformat)d MMM yyyy!presnameDatumtitleDatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field dagbknr!presnameDgbktitleDgbktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldbkstnr!presname!Boekstuktitle!Boekstuktype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldoms25!presname1Omschrijvingtitle1Omschrijvingtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation1field bdr_hflformat!#,##0.00!presnameBedragtitleBedragtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field bdr_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field valcode!presname
Valtitle
Valtype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6àfooterheadermodeValues!presname)background æfooterheadermodeValues ì)background)foregroundtitle)Documentenvname Deb_docBtablecicmpyv4Ë)constraint1field cmp_wwn !presname!VertalerÎfrom cmp_wwn tocmpwwn )expandTabs1!presname!Kladblokv 52ì)background)foregroundtitle!Per typemode0-orientation5horizontalBar5splitPosition
300*
)background)foregroundmarkup0!presnameTiteltitle©Document per type|||#{debcode} #{cmp_name}IdisableExcelExport0=extraConstraint1joblevel<=10!passthru1!presnameTabeltable=bacodiscussions
top0v 54Ê -Aggregation0!Compress1fieldAType.Description!presname5Type Documenttitle5Type Documenttype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê-Aggregation0!Compress1)Constraint1Hidden1fieldtype!presname-TableColumntitleTypetype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0fieldsum(1)format#,##0!presnameAantaltitleAantaltype3àfooterheadermodeValues!presname)background æfooterheadermodeValues mode0-orientation5horizontalBar!presname!Verdeler5splitPosition
500*
)background)foregroundmarkup0!presnameTiteltitleåDocumenten - #{Type.Description}|||#{debcode} #{cmp_name} IdisableExcelExport0=extraConstraint1joblevel<=10!presnameTabeltable=bacodiscussions
top0v 54 Ê-Aggregation0)Constraint1field
HIDformat#,##0!presname9Documentnummertitle9Documentnummertype3àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldECreatedByFullName!presname!Aanmakertitle!Aanmakertype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field-CreatedDateformat)d MMM yyyy!presname1Aanmaakdatumtitle1Aanmaakdatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field-OrderNumber!presname-Ordernummertitle-Ordernummertype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldOurRef!presname5Factuurnummertitle5Factuurnummertype4àfooterheadermodeValues!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!presname9Documentnummertitle9Documentnummertype3àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldECreatedByFullName!presname!Aanmakertitle!Aanmakertype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field Subject!presname%Onderwerptitle%Onderwerptype1àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê -Aggregation0field-CreatedDateformat)d MMM yyyy!presname1Aanmaakdatumtitle1Aanmaakdatumtype2àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0field-OrderNumber!presname-Ordernummertitle-Ordernummertype4àfooterheadermodeValues!presname)background æfooterheadermodeValues Ê
-Aggregation0fieldOurRef!presname5Factuurnummertitle5Factuurnummertype4àfooterheadermodeValues!presname)background æfooterheadermodeValues *
)background)foregroundmarkup0!presnameTiteltitleqDocument #{hid} - #{Subject}
field!document!presnameFiguurtable=bacodiscussionsv 51UwebclientAutoDownload0 + ; 
Version: 5.5.1355
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" rowNum="0" table="SV_OMZETFIN__PKG__" top="0" v="51"><TableCacheField field="boekjr" /><TableCacheField field="artcode" /><TableCacheField field="artcode@ITEMS.Description as Description" /><TableCacheField field="periode" /><TableCacheField field="omzet" /><TableCacheField field="reknr" /><TableCacheField field="reknr.oms25 as oms25" /><TableCacheField 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><Pie extraConstraint="boekjr=#{jaar}" field="omzet" passthru="1" showLegend="2" sortBy="SUM(omzet)" table=":cOMZET" v="44"><PieField field="reknr+' - '+oms25 as label" /><PieField compress="1" constraint="1" field="reknr" /><PieField compress="1" field="oms25" /><PieField compress="1" field="boekjr as jaar" /><PieField compress="1" constraint="1" field="debnr" /><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><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" 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) 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_OmzetFin__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) 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_OmzetFin__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 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><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" 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><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<=#{jaar} AND boekjr>=CAST(#{jaar} 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_OMZETFIN__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=#{jaar},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(#{jaar} 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(#{jaar}-1) as PrevYear" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><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" /><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" 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" />
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 *
,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
SELECT g.bkjrcode as boekjr,g.artcode,debnr,periode,g.reknr,
CASE WHEN transtype = 'N' or transtype = 'C' THEN -bdr_hfl ELSE 0.0 END as omzet,
CASE WHEN transtype = 'N' or transtype = 'C' THEN aantal ELSE 0.0 END as aantal,
CASE WHEN transtype = 'B' THEN -bdr_hfl ELSE 0 END as budget,
CASE WHEN transtype = 'B' THEN -aantal ELSE 0 END as budaant,
datum,artgrp,debnr fakdebnr, g.bkjrcode
FROM gbkmut g
INNER JOIN grtbk as gb on gb.reknr=g.reknr AND gb.omzrek='J' and gb.bal_vw='W'
LEFT JOIN bdgvrs bud on bud.bud_vers=g.bud_vers
LEFT JOIN artbst i on i.artcode=G.artcode
WHERE (g.bud_vers is null or bud.vers_stat = 'A')
AND (transtype = 'N' or transtype = 'C' or (transtype = 'B' and entryorigin='U'))
artcode
debnr
reknr
artgrp