bbj-plugins / bbjgridexwidget Goto Github PK

View Code? Open in Web Editor NEW

5.0 3.0 7.0 70.89 MB

An Advanced BBj Data Grid / Data Table Widget for your BBj projects

Home Page: https://bbj-plugins.github.io/BBjGridExWidget/

License: MIT License

JavaScript 72.01% HTML 0.57% CSS 10.53% Batchfile 0.08% MDX 16.81%

bbj-grid bbj-grid-widget bbj-grid-plugin bbj grid datagrid

bbjgridexwidget's People

Contributors

Stargazers

Watchers

Forkers

mitchneu christianbauer-1998 alainhoule bsauto rodrigoieh shahidur6020 martpfeiffer

bbjgridexwidget's Issues

pass license key to enterprise version

The setLicenseKey is now in and there is a new demo EnterpriseFeaturesDemo.bbj that shows how to set it from BBj side. Now it needs wiring towards the JS side.

CTRL Click for deselecting rows

by Erwin van Aken

With CTRL-click you can select multiple lines in a grid. Ctrl-click on a selected line does not unselect it.
Use SelectionDemo.bbj as sample program.

Implement Advanced Selections Features

Timestamp data is skewed in GUI, okay in BUI

In DatatypesDemo.bbj there is a TIMESTAMP column with value "2018-01-02 12:22:13"
The grid shows 02.01.2018 13:22:13 (as of today, sitting in CET time zone)

created Bug 31491 - The BBjHTMLView (JavaFX WebView) is not initialized with the same time zone as the interpreter

automatically refresh the grid after toggling the filter display

Currently you have to setup the filter before you initially display the grid. If filters are toggled with a finished grid, no refresh is triggered.

add more control over tree

Bonjour,

Je n'ai pas trouvé de paramètre qui me permettrait de déployer un nœud au départ de mon affichage comme la commande du BBjTree . Il me faudrait les méthodes "expandNode" et "expandTreeFromNode"

D'un point de vue général, toutes les méthodes du BBjTree sont intéressantes et si vous pouvez les intégrer au Widget alors ce serait super.

can click and double click events return the column under the click ?

setColumnWidth does not work correctly when left column is pinned or grid is treegrid

setColumnWidth

setColumnsState is broken (and getColumnsState as well)

The columns reported by the state now all have the name "foo_..." which breaks the column state mechanism.

Sample:

use ::BBjGridExWidget/BBjGridExWidget.bbj::BBjGridExWidget
use ::BBjGridExWidget/BBjGridExWidget.bbj::BBjGridExWidgetColumnState
use com.basiscomponents.bc.SqlQueryBC
use com.basiscomponents.db.ResultSet
use java.sql.Types

? 'HIDE'

declare auto BBjTopLevelWindow wnd!
declare auto BBjListButton lb_db!
declare auto BBjListButton lb_tbl!
declare auto BBjToolButton btn_fit!
declare BBjGridExWidget grid!

wnd! = BBjAPI().openSysGui("X0").addWindow(10,10,800,600,"BBj Grid Ex Demo")

grid! = new BBjGridExWidget(wnd!,100,0,30,800,570)

wnd!        .setCallback(BBjAPI.ON_CLOSE,"byebye")
wnd!        .setCallback(BBjAPI.ON_RESIZE,"resize")

if (info(3,6)<>"5") then
    wnd!.setCallback(BBjAPI.ON_KEYPRESS,"onWinKeypress")
fi
 
 

tb_set! = wnd!.addButton(301,220,0,200,25,"fillGrid")

tb_set!.setCallback(BBjAPI.ON_BUTTON_PUSH,"fillGrid")

process_events

   
fillGrid:

state$="[{""colId"":""INVOICENO"",""hide"":false,""aggFunc"":null,""width"":40,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICEDATE"",""hide"":false,""aggFunc"":null,""width"":40,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CURRENCYDESC"",""hide"":false,""aggFunc"":null,""width"":25,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICEAMT"",""hide"":false,""aggFunc"":null,""width"":50,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICEAMTPAID"",""hide"":false,""aggFunc"":null,""width"":50,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""AMTCUROPEN"",""hide"":false,""aggFunc"":null,""width"":50,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DEBTORDESC"",""hide"":false,""aggFunc"":null,""width"":125,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""SALESORDER"",""hide"":false,""aggFunc"":null,""width"":40,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DAYSAGE"",""hide"":false,""aggFunc"":null,""width"":30,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DUE"",""hide"":false,""aggFunc"":null,""width"":30,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICEDUEDATE"",""hide"":false,""aggFunc"":null,""width"":40,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""PERIOD"",""hide"":false,""aggFunc"":null,""width"":30,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CREDCONTSTAT"",""hide"":false,""aggFunc"":null,""width"":30,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""FILEURL"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""SITEDESC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""SITEID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CUSTOMERDESC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CUSTOMERID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CURRENCYID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DAYSDUE"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""LASTPAYMENTDATE"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""AUTORIZID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICELISTID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DISCAMT"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DISC_AMLOC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CREDAMT"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CRED_AMLOC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""COLLECT_ACNO"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""COLLECT_NAME"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""COLLECT"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""IDEALID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICEAMTLOC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""INVOICEAMTEXVAT"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DOCINV"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DEBTORID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DISCDAYS"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CREDDAYS"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CATEGORYID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""CATEGORYDESC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""VATSYSTEMID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""VATSYSTEMDESC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""VATSITEDESC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""VATSITEID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""PAYMENTTERMSDESC"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""PAYMENTTERMSID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""DISPUTE"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""PAID"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null},{""colId"":""NUMPAYMENTS"",""hide"":true,""aggFunc"":null,""width"":20,""pivotIndex"":null,""pinned"":null,""rowGroupIndex"":null}]"
rs! = ResultSet.fromJson("[{""INVOICEDUEDATE"":""2012-12-30"",""CUSTOMERID"":""1400"",""INVOICEAMT"":""278.3"",""PERIOD"":""201211"",""SALESORDER"":""101326"",""INVOICENO"":""6100416"",""INVOICEDATE"":""2012-11-30"",""DEBTORID"":""1410"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Vaadin GmbH, Berlin"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":278.3,""CREDCONTSTAT"":""1"",""DAYSAGE"":1902.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\Factuur_60  70334-01_121130151137.pdf"",""meta"":{""INVOICEDUEDATE"":{""ColumnType"":""91"",""MASK"":""%Dz-%Mz-%Yd"",""LABEL"":""Vervaldatum"",""ALIGN"":""Center"",""FIELDTYPE"":""91""},""CUSTOMERID"":{""ColumnType"":""12""},""INVOICEAMT"":{""ColumnType"":""12"",""MASK"":""-###,###,##0.00"",""LABEL"":""Factuurbedrag"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""PERIOD"":{""ColumnType"":""12"",""LABEL"":""Periode"",""ALIGN"":""Center"",""FIELDTYPE"":""2""},""SALESORDER"":{""ColumnType"":""12"",""LABEL"":""Verkooporder"",""ALIGN"":""Center""},""INVOICENO"":{""ColumnType"":""12"",""LABEL"":""Factuurnr"",""ALIGN"":""Center""},""INVOICEDATE"":{""ColumnType"":""91"",""MASK"":""%Dz-%Mz-%Yd"",""LABEL"":""Fact.datum"",""ALIGN"":""Center"",""FIELDTYPE"":""91""},""DEBTORID"":{""ColumnType"":""12""},""SITEID"":{""ColumnType"":""12""},""PAID"":{""ColumnType"":""16""},""CURRENCYID"":{""ColumnType"":""12""},""CURRENCYDESC"":{""ColumnType"":""12"",""LABEL"":""Val."",""ALIGN"":""Center""},""DEBTORDESC"":{""ColumnType"":""12"",""LABEL"":""Debiteur"",""ALIGN"":""Left""},""INVOICEAMTPAID"":{""ColumnType"":""8"",""MASK"":""-###,###,##0.00"",""LABEL"":""Betaald"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""AMTCUROPEN"":{""ColumnType"":""8"",""MASK"":""-###,###,##0.00"",""LABEL"":""Openstaand"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""CREDCONTSTAT"":{""ColumnType"":""12"",""LABEL"":""Brief"",""ALIGN"":""Center""},""DAYSAGE"":{""ColumnType"":""8"",""MASK"":""##,##0"",""LABEL"":""Oud"",""ALIGN"":""Center"",""FIELDTYPE"":""2""},""DUE"":{""ColumnType"":""8"",""LABEL"":""Vervallen"",""ALIGN"":""Center""},""FILEURL"":{""ColumnType"":""12""}}},{""INVOICEDUEDATE"":""2014-02-25"",""CUSTOMERID"":""1104"",""INVOICEAMT"":""1125"",""PERIOD"":""201401"",""SALESORDER"":""130382"",""INVOICENO"":""6100713"",""INVOICEDATE"":""2014-01-26"",""DEBTORID"":""1104"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""H. Koelewijn, Hilversum"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1125.0,""CREDCONTSTAT"":""1"",""DAYSAGE"":1480.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\Verzamelfactuur_61V   900212_140126112138.pdf""},{""INVOICEDUEDATE"":""2014-09-04"",""CUSTOMERID"":""999901"",""INVOICEAMT"":""298.8"",""PERIOD"":""201407"",""SALESORDER"":""121281"",""INVOICENO"":""6100777"",""INVOICEDATE"":""2014-08-05"",""DEBTORID"":""999901"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""PBS Rotterdam B.V., Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":298.8,""CREDCONTSTAT"":"""",""DAYSAGE"":1289.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\Factuur_60    121281_140805075041.pdf""},{""INVOICEDUEDATE"":""2018-03-13"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""359.98"",""PERIOD"":""201801"",""SALESORDER"":""121409"",""INVOICENO"":""6100797"",""INVOICEDATE"":""2018-01-12"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":359.98,""CREDCONTSTAT"":"""",""DAYSAGE"":33.0,""DUE"":0.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2018\\01 Jan\\Factuur_60    121409_180112204617.pdf""},{""INVOICEDUEDATE"":null,""CUSTOMERID"":""1000"",""INVOICEAMT"":""24200"",""PERIOD"":""201801"",""SALESORDER"":""102399"",""INVOICENO"":""6100798"",""INVOICEDATE"":""2018-01-29"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":24200.0,""CREDCONTSTAT"":"""",""DAYSAGE"":16.0,""DUE"":0.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2018\\01 Jan\\Factuur_60   X008101_180129094826.pdf""},{""INVOICEDUEDATE"":""2018-04-13"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""27225"",""PERIOD"":""201802"",""SALESORDER"":""102432"",""INVOICENO"":""6100799"",""INVOICEDATE"":""2018-02-12"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":27225.0,""CREDCONTSTAT"":"""",""DAYSAGE"":2.0,""DUE"":0.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\Verzamelfactuur_61V   900059_140825143225.pdf""},{""INVOICEDUEDATE"":""2014-12-20"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""585.37"",""PERIOD"":""201411"",""SALESORDER"":""101634"",""INVOICENO"":""6100868"",""INVOICEDATE"":""2014-11-20"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":585.37,""CREDCONTSTAT"":""1"",""DAYSAGE"":1182.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\Factuur_60  70598-01_141120150923.pdf""},{""INVOICEDUEDATE"":""2015-12-10"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""1447.16"",""PERIOD"":""201510"",""SALESORDER"":""101833"",""INVOICENO"":""6101011"",""INVOICEDATE"":""2015-11-10"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1447.16,""CREDCONTSTAT"":""4"",""DAYSAGE"":827.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2015\\11 Nov\\Verzamelfactuur_61V   900403_151110121237.pdf""},{""INVOICEDUEDATE"":""2015-12-18"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""1397.1"",""PERIOD"":""201511"",""SALESORDER"":""101816"",""INVOICENO"":""6101027"",""INVOICEDATE"":""2015-11-18"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1397.1,""CREDCONTSTAT"":""4"",""DAYSAGE"":819.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2015\\11 Nov\\Verzamelfactuur_61V   900404_151118085924.pdf""},{""INVOICEDUEDATE"":""2016-01-29"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""468.88"",""PERIOD"":""201512"",""SALESORDER"":""121324"",""INVOICENO"":""6101056"",""INVOICEDATE"":""2015-12-30"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":468.88,""CREDCONTSTAT"":""4"",""DAYSAGE"":777.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2015\\12 Dec\\Verzamelfactuur_61V   900409_151230171342.pdf""},{""INVOICEDUEDATE"":""2016-03-10"",""CUSTOMERID"":""1410"",""INVOICEAMT"":""287.5"",""PERIOD"":""201602"",""SALESORDER"":""101876"",""INVOICENO"":""6101071"",""INVOICEDATE"":""2016-02-09"",""DEBTORID"":""1410"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Vaadin GmbH, Berlin"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":287.5,""CREDCONTSTAT"":"""",""DAYSAGE"":736.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\02 Feb\\Factuur_60  70830-01_160209203943.pdf""},{""INVOICEDUEDATE"":""2016-06-27"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""278.3"",""PERIOD"":""201611"",""SALESORDER"":""121353"",""INVOICENO"":""6101100"",""INVOICEDATE"":""2016-04-28"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":278.3,""CREDCONTSTAT"":"""",""DAYSAGE"":657.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\04 Apr\\Factuur_60    121353_160428090331.pdf""},{""INVOICEDUEDATE"":""2016-09-25"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""246.84"",""PERIOD"":""201608"",""SALESORDER"":""121377"",""INVOICENO"":""6101148"",""INVOICEDATE"":""2016-08-26"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":246.84,""CREDCONTSTAT"":"""",""DAYSAGE"":537.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\08 Aug\\Factuur_60    121377_160826102449.pdf""},{""INVOICEDUEDATE"":""2016-10-25"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""130"",""PERIOD"":""201608"",""SALESORDER"":""102006"",""INVOICENO"":""6101149"",""INVOICEDATE"":""2016-08-26"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":130.0,""CREDCONTSTAT"":"""",""DAYSAGE"":537.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\08 Aug\\Verzamelfactuur_61V   900416_160826125630.pdf""},{""INVOICEDUEDATE"":""2016-09-28"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""8470"",""PERIOD"":""201608"",""SALESORDER"":""102051"",""INVOICENO"":""6101153"",""INVOICEDATE"":""2016-08-29"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":8470.0,""CREDCONTSTAT"":"""",""DAYSAGE"":534.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\08 Aug\\Factuur_60  70921-01_160829132141.pdf""},{""INVOICEDUEDATE"":""2016-09-28"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""453.15"",""PERIOD"":""201608"",""SALESORDER"":""102052"",""INVOICENO"":""6101154"",""INVOICEDATE"":""2016-08-29"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":453.15,""CREDCONTSTAT"":"""",""DAYSAGE"":534.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\08 Aug\\Factuur_60  70922-01_160829133421.pdf""},{""INVOICEDUEDATE"":""2016-09-29"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""145.2"",""PERIOD"":""201608"",""SALESORDER"":""123074"",""INVOICENO"":""6101157"",""INVOICEDATE"":""2016-08-30"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":145.2,""CREDCONTSTAT"":"""",""DAYSAGE"":533.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\08 Aug\\Factuur_60    123074_160830155636.pdf""},{""INVOICEDUEDATE"":""2016-10-02"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""477.95"",""PERIOD"":""201608"",""SALESORDER"":""123075"",""INVOICENO"":""6101158"",""INVOICEDATE"":""2016-09-02"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":477.95,""CREDCONTSTAT"":"""",""DAYSAGE"":530.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123075_160902105400.pdf""},{""INVOICEDUEDATE"":""2016-10-02"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""302.5"",""PERIOD"":""201608"",""SALESORDER"":""123076"",""INVOICENO"":""6101159"",""INVOICEDATE"":""2016-09-02"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":302.5,""CREDCONTSTAT"":"""",""DAYSAGE"":530.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123076_160902172058.pdf""},{""INVOICEDUEDATE"":""2016-10-02"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""359.98"",""PERIOD"":""201608"",""SALESORDER"":""123077"",""INVOICENO"":""6101160"",""INVOICEDATE"":""2016-09-02"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":359.98,""CREDCONTSTAT"":"""",""DAYSAGE"":530.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123077_160902210440.pdf""},{""INVOICEDUEDATE"":""2016-10-02"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""544.5"",""PERIOD"":""201609"",""SALESORDER"":""123078"",""INVOICENO"":""6101161"",""INVOICEDATE"":""2016-09-02"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":544.5,""CREDCONTSTAT"":"""",""DAYSAGE"":530.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123078_160902211246.pdf""},{""INVOICEDUEDATE"":""2016-10-08"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""586.85"",""PERIOD"":""201609"",""SALESORDER"":""123079"",""INVOICENO"":""6101162"",""INVOICEDATE"":""2016-09-08"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":586.85,""CREDCONTSTAT"":"""",""DAYSAGE"":524.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123079_160908094235.pdf""},{""INVOICEDUEDATE"":""2016-10-08"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""148.1"",""PERIOD"":""201609"",""SALESORDER"":""123080"",""INVOICENO"":""6101163"",""INVOICEDATE"":""2016-09-08"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":148.1,""CREDCONTSTAT"":"""",""DAYSAGE"":524.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123080_160908100432.pdf""},{""INVOICEDUEDATE"":""2016-10-08"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""242"",""PERIOD"":""201609"",""SALESORDER"":""123082"",""INVOICENO"":""6101165"",""INVOICEDATE"":""2016-09-08"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":242.0,""CREDCONTSTAT"":"""",""DAYSAGE"":524.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123082_160908100810.pdf""},{""INVOICEDUEDATE"":""2016-10-14"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""518.36"",""PERIOD"":""201609"",""SALESORDER"":""121381"",""INVOICENO"":""6101166"",""INVOICEDATE"":""2016-09-14"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":518.36,""CREDCONTSTAT"":"""",""DAYSAGE"":518.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    121381_160914083706.pdf""},{""INVOICEDUEDATE"":""2016-10-14"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""1036.73"",""PERIOD"":""201609"",""SALESORDER"":""121382"",""INVOICENO"":""6101167"",""INVOICEDATE"":""2016-09-14"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1036.73,""CREDCONTSTAT"":"""",""DAYSAGE"":518.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    121382_160914083952.pdf""},{""INVOICEDUEDATE"":""2016-10-14"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""518.36"",""PERIOD"":""201609"",""SALESORDER"":""121383"",""INVOICENO"":""6101168"",""INVOICEDATE"":""2016-09-14"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":518.36,""CREDCONTSTAT"":"""",""DAYSAGE"":518.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    121383_160914084310.pdf""},{""INVOICEDUEDATE"":""2016-10-14"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""219.07"",""PERIOD"":""201609"",""SALESORDER"":""121384"",""INVOICENO"":""6101169"",""INVOICEDATE"":""2016-09-14"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":219.07,""CREDCONTSTAT"":"""",""DAYSAGE"":518.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    121384_160914091320.pdf""},{""INVOICEDUEDATE"":""2016-10-14"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""308.55"",""PERIOD"":""201609"",""SALESORDER"":""123083"",""INVOICENO"":""6101170"",""INVOICEDATE"":""2016-09-14"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":308.55,""CREDCONTSTAT"":"""",""DAYSAGE"":518.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123083_160914133534.pdf""},{""INVOICEDUEDATE"":""2016-10-19"",""CUSTOMERID"":"""",""INVOICEAMT"":""245"",""PERIOD"":""201609"",""SALESORDER"":"""",""INVOICENO"":""6101171"",""INVOICEDATE"":""2016-09-19"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":245.0,""CREDCONTSTAT"":""4"",""DAYSAGE"":513.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-10-19"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""338.8"",""PERIOD"":""201609"",""SALESORDER"":""121380"",""INVOICENO"":""6101171"",""INVOICEDATE"":""2016-09-19"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":338.8,""CREDCONTSTAT"":"""",""DAYSAGE"":513.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    121380_160919124256.pdf""},{""INVOICEDUEDATE"":""2016-10-22"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""185.13"",""PERIOD"":""201609"",""SALESORDER"":""121385"",""INVOICENO"":""6101174"",""INVOICEDATE"":""2016-09-22"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":185.13,""CREDCONTSTAT"":"""",""DAYSAGE"":510.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    121385_160922172742.pdf""},{""INVOICEDUEDATE"":""2016-10-27"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""293.12"",""PERIOD"":""201609"",""SALESORDER"":""102071"",""INVOICENO"":""6101175"",""INVOICEDATE"":""2016-09-27"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":293.12,""CREDCONTSTAT"":"""",""DAYSAGE"":505.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60  70954-01_160927164031.pdf""},{""INVOICEDUEDATE"":""2016-10-29"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""429.55"",""PERIOD"":""201609"",""SALESORDER"":""123084"",""INVOICENO"":""6101176"",""INVOICEDATE"":""2016-09-29"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":429.55,""CREDCONTSTAT"":"""",""DAYSAGE"":503.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123084_160929143315.pdf""},{""INVOICEDUEDATE"":""2016-10-29"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""-80.22"",""PERIOD"":""201609"",""SALESORDER"":""123086"",""INVOICENO"":""6101177"",""INVOICEDATE"":""2016-09-29"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-80.22,""CREDCONTSTAT"":"""",""DAYSAGE"":503.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\09 Sep\\Factuur_60    123086_160929150009.pdf""},{""INVOICEDUEDATE"":""2016-12-02"",""CUSTOMERID"":""2012"",""INVOICEAMT"":""664.45"",""PERIOD"":""201609"",""SALESORDER"":""102076"",""INVOICENO"":""6101178"",""INVOICEDATE"":""2016-10-03"",""DEBTORID"":""2012"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""01"",""CURRENCYDESC"":""$"",""DEBTORDESC"":""Yankee Manufacturing Inc., NEW YORK"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":664.45,""CREDCONTSTAT"":"""",""DAYSAGE"":499.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\10 Oct\\Factuur_60  70957-01_161003105641.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""3610.04"",""PERIOD"":""201611"",""SALESORDER"":""102115"",""INVOICENO"":""6101181"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3610.04,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70988-01_161104103008.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1151"",""INVOICEAMT"":""2450"",""PERIOD"":""201611"",""SALESORDER"":""102059"",""INVOICENO"":""6101182"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1151"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Horlogefabrief Zwitserland, Basel"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2450.0,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70931-01_161104103226.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1151"",""INVOICEAMT"":""625"",""PERIOD"":""201611"",""SALESORDER"":""102064"",""INVOICENO"":""6101183"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1151"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Horlogefabrief Zwitserland, Basel"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":625.0,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70939-01_161104103226.pdf""},{""INVOICEDUEDATE"":""2017-01-03"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""520.3"",""PERIOD"":""201611"",""SALESORDER"":""121386"",""INVOICENO"":""6101185"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":520.3,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    121386_161104103229.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-78.65"",""PERIOD"":""201611"",""SALESORDER"":""123085"",""INVOICENO"":""6101186"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-78.65,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123085_161104103230.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-90.75"",""PERIOD"":""201611"",""SALESORDER"":""123087"",""INVOICENO"":""6101187"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-90.75,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123087_161104103230.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-363"",""PERIOD"":""201611"",""SALESORDER"":""123092"",""INVOICENO"":""6101188"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-363.0,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123092_161104103230.pdf""},{""INVOICEDUEDATE"":""2017-01-03"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""665.5"",""PERIOD"":""201611"",""SALESORDER"":""121387"",""INVOICENO"":""6101189"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":517.51,""AMTCUROPEN"":147.99,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    121387_161104105001.pdf""},{""INVOICEDUEDATE"":""2017-01-03"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""9274.65"",""PERIOD"":""201611"",""SALESORDER"":""121388"",""INVOICENO"":""6101190"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":9274.65,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    121388_161104105157.pdf""},{""INVOICEDUEDATE"":""2017-01-03"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""9317"",""PERIOD"":""201611"",""SALESORDER"":""121389"",""INVOICENO"":""6101192"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":9317.0,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    121389_161104105732.pdf""},{""INVOICEDUEDATE"":""2016-12-04"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""836.17"",""PERIOD"":""201611"",""SALESORDER"":""102116"",""INVOICENO"":""6101195"",""INVOICEDATE"":""2016-11-04"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":836.17,""CREDCONTSTAT"":"""",""DAYSAGE"":467.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70989-01_161110112217.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""1943.87"",""PERIOD"":""201611"",""SALESORDER"":""102104"",""INVOICENO"":""6101196"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1943.87,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70990-01_161110112256.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""5953.2"",""PERIOD"":""201611"",""SALESORDER"":""102111"",""INVOICENO"":""6101197"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":5953.2,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70983-01_161110112257.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""1113.87"",""PERIOD"":""201611"",""SALESORDER"":""102117"",""INVOICENO"":""6101198"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1113.87,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70991-01_161110112257.pdf""},{""INVOICEDUEDATE"":""2016-11-21"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""836.17"",""PERIOD"":""201610"",""SALESORDER"":""102092"",""INVOICENO"":""6101199"",""INVOICEDATE"":""2016-10-22"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":836.17,""CREDCONTSTAT"":"""",""DAYSAGE"":480.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70963-01_161110113503.pdf""},{""INVOICEDUEDATE"":""2016-11-24"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""836.17"",""PERIOD"":""201610"",""SALESORDER"":""102093"",""INVOICENO"":""6101200"",""INVOICEDATE"":""2016-10-25"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":836.17,""CREDCONTSTAT"":"""",""DAYSAGE"":477.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70971-01_161110113525.pdf""},{""INVOICEDUEDATE"":""2016-11-20"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""2776.95"",""PERIOD"":""201610"",""SALESORDER"":""102109"",""INVOICENO"":""6101201"",""INVOICEDATE"":""2016-10-21"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2776.95,""CREDCONTSTAT"":"""",""DAYSAGE"":481.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70981-01_161110113557.pdf""},{""INVOICEDUEDATE"":""2016-12-25"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1092.03"",""PERIOD"":""201610"",""SALESORDER"":""102110"",""INVOICENO"":""6101202"",""INVOICEDATE"":""2016-10-26"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1092.03,""CREDCONTSTAT"":"""",""DAYSAGE"":476.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70982-01_161110113620.pdf""},{""INVOICEDUEDATE"":""2016-11-28"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""1113.87"",""PERIOD"":""201610"",""SALESORDER"":""102112"",""INVOICENO"":""6101203"",""INVOICEDATE"":""2016-10-29"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1113.87,""CREDCONTSTAT"":"""",""DAYSAGE"":473.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70984-01_161110113639.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""987.66"",""PERIOD"":""201610"",""SALESORDER"":""102123"",""INVOICENO"":""6101204"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":987.66,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Verzamelfactuur_61V   900417_161110160619.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""179.99"",""PERIOD"":""201610"",""SALESORDER"":""102123"",""INVOICENO"":""6101205"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":179.99,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Verzamelfactuur_61V   900418_161110161251.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""2499.26"",""PERIOD"":""201611"",""SALESORDER"":""102125"",""INVOICENO"":""6101206"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2499.26,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71002-01_161110172024.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""414.58"",""PERIOD"":""201610"",""SALESORDER"":""102118"",""INVOICENO"":""6101207"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":414.58,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70995-01_161110173706.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""1943.87"",""PERIOD"":""201610"",""SALESORDER"":""102119"",""INVOICENO"":""6101208"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1943.87,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70992-01_161110173706.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1905.75"",""PERIOD"":""201610"",""SALESORDER"":""102120"",""INVOICENO"":""6101209"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1905.75,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70993-01_161110173706.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""185.75"",""PERIOD"":""201610"",""SALESORDER"":""102121"",""INVOICENO"":""6101210"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":185.75,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70994-01_161110173707.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""1388.48"",""PERIOD"":""201610"",""SALESORDER"":""102126"",""INVOICENO"":""6101211"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1388.48,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71003-01_161110173707.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1003"",""INVOICEAMT"":""492.15"",""PERIOD"":""201610"",""SALESORDER"":""102130"",""INVOICENO"":""6101212"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Metals \u0026 Residues BV, Bussum"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":492.15,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71006-01_161110194130.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""517.28"",""PERIOD"":""201610"",""SALESORDER"":""101936"",""INVOICENO"":""6101213"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":517.28,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70852-01_161110194631.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""4452.8"",""PERIOD"":""201610"",""SALESORDER"":""102098"",""INVOICENO"":""6101214"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":4452.8,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70976-01_161110194632.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""4295.5"",""PERIOD"":""201610"",""SALESORDER"":""102106"",""INVOICENO"":""6101215"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":4295.5,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70979-01_161110194633.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""96.2"",""PERIOD"":""201610"",""SALESORDER"":""102113"",""INVOICENO"":""6101216"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":96.2,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  70985-01_161110194634.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""836.17"",""PERIOD"":""201610"",""SALESORDER"":""102127"",""INVOICENO"":""6101217"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":836.17,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71004-01_161110194634.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""2450.25"",""PERIOD"":""201610"",""SALESORDER"":""102128"",""INVOICENO"":""6101218"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2450.25,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71005-01_161110194635.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1003"",""INVOICEAMT"":""244.8"",""PERIOD"":""201610"",""SALESORDER"":""102130"",""INVOICENO"":""6101219"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Metals \u0026 Residues BV, Bussum"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":244.8,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71007-01_161110194635.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-90.75"",""PERIOD"":""201610"",""SALESORDER"":""123088"",""INVOICENO"":""6101220"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-90.75,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123088_161110194636.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-181.5"",""PERIOD"":""201610"",""SALESORDER"":""123089"",""INVOICENO"":""6101221"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-181.5,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123089_161110194637.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-272.25"",""PERIOD"":""201610"",""SALESORDER"":""123090"",""INVOICENO"":""6101222"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-272.25,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123090_161110194638.pdf""},{""INVOICEDUEDATE"":""2016-12-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""-363"",""PERIOD"":""201610"",""SALESORDER"":""123091"",""INVOICENO"":""6101223"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-363.0,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60    123091_161110194638.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""583.83"",""PERIOD"":""201610"",""SALESORDER"":""102132"",""INVOICENO"":""6101224"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":583.83,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71008-01_161110201249.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""290.4"",""PERIOD"":""201610"",""SALESORDER"":""102132"",""INVOICENO"":""6101225"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":290.4,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71009-01_161110203612.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""632.23"",""PERIOD"":""201610"",""SALESORDER"":""102134"",""INVOICENO"":""6101226"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":632.23,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71011-01_161110205937.pdf""},{""INVOICEDUEDATE"":""2017-01-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""290.4"",""PERIOD"":""201610"",""SALESORDER"":""102134"",""INVOICENO"":""6101227"",""INVOICEDATE"":""2016-11-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":290.4,""CREDCONTSTAT"":"""",""DAYSAGE"":461.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71012-01_161110210152.pdf""},{""INVOICEDUEDATE"":""2016-12-11"",""CUSTOMERID"":""1005"",""INVOICEAMT"":""384.18"",""PERIOD"":""201701"",""SALESORDER"":""102138"",""INVOICENO"":""6101228"",""INVOICEDATE"":""2016-11-11"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":384.18,""CREDCONTSTAT"":"""",""DAYSAGE"":460.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71014-01_161111100925.pdf""},{""INVOICEDUEDATE"":""2016-12-11"",""CUSTOMERID"":""1005"",""INVOICEAMT"":""136.13"",""PERIOD"":""201701"",""SALESORDER"":""102138"",""INVOICENO"":""6101229"",""INVOICEDATE"":""2016-11-11"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":136.13,""CREDCONTSTAT"":"""",""DAYSAGE"":460.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Verzamelfactuur_61V   900419_161111103111.pdf""},{""INVOICEDUEDATE"":""2016-12-11"",""CUSTOMERID"":""1005"",""INVOICEAMT"":""384.18"",""PERIOD"":""201701"",""SALESORDER"":""102143"",""INVOICENO"":""6101230"",""INVOICEDATE"":""2016-11-11"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":384.18,""CREDCONTSTAT"":"""",""DAYSAGE"":460.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71016-01_161111110259.pdf""},{""INVOICEDUEDATE"":""2016-12-11"",""CUSTOMERID"":""1005"",""INVOICEAMT"":""414.43"",""PERIOD"":""201701"",""SALESORDER"":""102147"",""INVOICENO"":""6101231"",""INVOICEDATE"":""2016-11-11"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":414.43,""CREDCONTSTAT"":"""",""DAYSAGE"":460.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71017-01_161111112005.pdf""},{""INVOICEDUEDATE"":""2017-01-16"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""2450.25"",""PERIOD"":""201701"",""SALESORDER"":""102164"",""INVOICENO"":""6101232"",""INVOICEDATE"":""2016-11-17"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2450.25,""CREDCONTSTAT"":"""",""DAYSAGE"":454.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71033-01_161117212600.pdf""},{""INVOICEDUEDATE"":""2016-12-18"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""1780.33"",""PERIOD"":""201701"",""SALESORDER"":""102166"",""INVOICENO"":""6101233"",""INVOICEDATE"":""2016-11-18"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1780.33,""CREDCONTSTAT"":"""",""DAYSAGE"":453.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2016\\11 Nov\\Factuur_60  71036-01_161118120012.pdf""},{""INVOICEDUEDATE"":""2017-03-16"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""287.38"",""PERIOD"":""201701"",""SALESORDER"":""102168"",""INVOICENO"":""6101234"",""INVOICEDATE"":""2017-01-15"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":287.38,""CREDCONTSTAT"":"""",""DAYSAGE"":395.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71038-01_170115164633.pdf""},{""INVOICEDUEDATE"":""2017-03-16"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""287.38"",""PERIOD"":""201701"",""SALESORDER"":""102169"",""INVOICENO"":""6101235"",""INVOICEDATE"":""2017-01-15"",""DEBTORID"":""1004"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Zantingh BV, Groningen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":287.38,""CREDCONTSTAT"":"""",""DAYSAGE"":395.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71039-01_170115164633.pdf""},{""INVOICEDUEDATE"":""2017-03-16"",""CUSTOMERID"":""1006"",""INVOICEAMT"":""293.12"",""PERIOD"":""201701"",""SALESORDER"":""102170"",""INVOICENO"":""6101236"",""INVOICEDATE"":""2017-01-15"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":293.12,""CREDCONTSTAT"":"""",""DAYSAGE"":395.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71040-01_170115164633.pdf""},{""INVOICEDUEDATE"":""2017-02-15"",""CUSTOMERID"":""1010"",""INVOICEAMT"":""287.38"",""PERIOD"":""201701"",""SALESORDER"":""102172"",""INVOICENO"":""6101237"",""INVOICEDATE"":""2017-01-16"",""DEBTORID"":""1007"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Ypma Fijnmetaal BV, Heerenveen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":287.38,""CREDCONTSTAT"":"""",""DAYSAGE"":394.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71041-01_170116135031.pdf""},{""INVOICEDUEDATE"":""2017-02-15"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""412.84"",""PERIOD"":""201701"",""SALESORDER"":""102173"",""INVOICENO"":""6101238"",""INVOICEDATE"":""2017-01-16"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":412.84,""CREDCONTSTAT"":"""",""DAYSAGE"":394.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71042-01_170116135034.pdf""},{""INVOICEDUEDATE"":""2017-03-17"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""206.31"",""PERIOD"":""201701"",""SALESORDER"":""102175"",""INVOICENO"":""6101239"",""INVOICEDATE"":""2017-01-16"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":206.31,""CREDCONTSTAT"":"""",""DAYSAGE"":394.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71044-01_170116135034.pdf""},{""INVOICEDUEDATE"":""2017-03-17"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""287.38"",""PERIOD"":""201701"",""SALESORDER"":""102174"",""INVOICENO"":""6101240"",""INVOICEDATE"":""2017-01-16"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":287.38,""CREDCONTSTAT"":"""",""DAYSAGE"":394.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Verzamelfactuur_61V   900420_170116135057.pdf""},{""INVOICEDUEDATE"":""2017-03-27"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""2450.25"",""PERIOD"":""201701"",""SALESORDER"":""102137"",""INVOICENO"":""6101241"",""INVOICEDATE"":""2017-01-26"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2450.25,""CREDCONTSTAT"":"""",""DAYSAGE"":384.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71013-01_170126211602.pdf""},{""INVOICEDUEDATE"":""2017-02-25"",""CUSTOMERID"":""1010"",""INVOICEAMT"":""2178"",""PERIOD"":""201701"",""SALESORDER"":""102163"",""INVOICENO"":""6101242"",""INVOICEDATE"":""2017-01-26"",""DEBTORID"":""1007"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Ypma Fijnmetaal BV, Heerenveen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2178.0,""CREDCONTSTAT"":"""",""DAYSAGE"":384.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71032-01_170126211605.pdf""},{""INVOICEDUEDATE"":""2017-02-25"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""2026.75"",""PERIOD"":""201701"",""SALESORDER"":""102165"",""INVOICENO"":""6101243"",""INVOICEDATE"":""2017-01-26"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2026.75,""CREDCONTSTAT"":"""",""DAYSAGE"":384.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Factuur_60  71035-01_170126211606.pdf""},{""INVOICEDUEDATE"":""2017-02-25"",""CUSTOMERID"":""1004"",""INVOICEAMT"":""1331.97"",""PERIOD"":""201701"",""SALESORDER"":""300011"",""INVOICENO"":""6101244"",""INVOICEDATE"":""2017-01-26"",""DEBTORID"":""1004"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Zantingh BV, Groningen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1331.97,""CREDCONTSTAT"":"""",""DAYSAGE"":384.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\01 Jan\\Termijnfactuur_3000110010_170126211639.pdf""},{""INVOICEDUEDATE"":""2017-03-08"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""242.5"",""PERIOD"":""201701"",""SALESORDER"":""102185"",""INVOICENO"":""6101245"",""INVOICEDATE"":""2017-02-06"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":242.5,""CREDCONTSTAT"":"""",""DAYSAGE"":373.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60  71056-01_170206160533.pdf""},{""INVOICEDUEDATE"":""2017-03-08"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""242.5"",""PERIOD"":""201701"",""SALESORDER"":""102186"",""INVOICENO"":""6101246"",""INVOICEDATE"":""2017-02-06"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":242.5,""CREDCONTSTAT"":"""",""DAYSAGE"":373.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60  71057-01_170206161624.pdf""},{""INVOICEDUEDATE"":""2017-04-08"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""320.65"",""PERIOD"":""201702"",""SALESORDER"":""121391"",""INVOICENO"":""6101247"",""INVOICEDATE"":""2017-02-07"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":320.65,""CREDCONTSTAT"":"""",""DAYSAGE"":372.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60    121391_170207111440.pdf""},{""INVOICEDUEDATE"":""2017-04-08"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""671.55"",""PERIOD"":""201702"",""SALESORDER"":""121392"",""INVOICENO"":""6101248"",""INVOICEDATE"":""2017-02-07"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":671.55,""CREDCONTSTAT"":"""",""DAYSAGE"":372.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60    121392_170207111750.pdf""},{""INVOICEDUEDATE"":""2017-04-17"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""592.9"",""PERIOD"":""201701"",""SALESORDER"":""121393"",""INVOICENO"":""6101249"",""INVOICEDATE"":""2017-02-16"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":592.9,""CREDCONTSTAT"":"""",""DAYSAGE"":363.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60    121393_170216135121.pdf""},{""INVOICEDUEDATE"":""2017-04-17"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""435.6"",""PERIOD"":""201701"",""SALESORDER"":""121394"",""INVOICENO"":""6101250"",""INVOICEDATE"":""2017-02-16"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":435.6,""CREDCONTSTAT"":"""",""DAYSAGE"":363.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60    121394_170216143807.pdf""},{""INVOICEDUEDATE"":""2017-04-17"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""514.25"",""PERIOD"":""201703"",""SALESORDER"":""121395"",""INVOICENO"":""6101251"",""INVOICEDATE"":""2017-02-16"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":514.25,""CREDCONTSTAT"":"""",""DAYSAGE"":363.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\02 Feb\\Factuur_60    121395_170216144849.pdf""},{""INVOICEDUEDATE"":""2017-05-12"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1210"",""PERIOD"":""201703"",""SALESORDER"":""102200"",""INVOICENO"":""6101252"",""INVOICEDATE"":""2017-03-13"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1210.0,""CREDCONTSTAT"":"""",""DAYSAGE"":338.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\03 Mar\\Termijnfactuur_1022000010_170313065018.pdf""},{""INVOICEDUEDATE"":""2017-04-28"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""263.66"",""PERIOD"":""201701"",""SALESORDER"":""102210"",""INVOICENO"":""6101253"",""INVOICEDATE"":""2017-03-29"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":263.66,""CREDCONTSTAT"":"""",""DAYSAGE"":322.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\03 Mar\\Factuur_60  71071-01_170329100637.pdf""},{""INVOICEDUEDATE"":""2017-04-28"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""4083.75"",""PERIOD"":""201703"",""SALESORDER"":""102211"",""INVOICENO"":""6101254"",""INVOICEDATE"":""2017-03-29"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":4083.75,""CREDCONTSTAT"":"""",""DAYSAGE"":322.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\03 Mar\\Termijnfactuur_1022110010_170329113443.pdf""},{""INVOICEDUEDATE"":""2017-05-28"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""598.95"",""PERIOD"":""201703"",""SALESORDER"":""121396"",""INVOICENO"":""6101255"",""INVOICEDATE"":""2017-03-29"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":598.95,""CREDCONTSTAT"":"""",""DAYSAGE"":322.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\03 Mar\\Factuur_60    121396_170329165646.pdf""},{""INVOICEDUEDATE"":""2017-04-29"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""3630"",""PERIOD"":""201701"",""SALESORDER"":""102212"",""INVOICENO"":""6101256"",""INVOICEDATE"":""2017-03-30"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3630.0,""CREDCONTSTAT"":"""",""DAYSAGE"":321.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\03 Mar\\Termijnfactuur_1022120010_170330134228.pdf""},{""INVOICEDUEDATE"":""2017-04-29"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""3630"",""PERIOD"":""201703"",""SALESORDER"":""102213"",""INVOICENO"":""6101257"",""INVOICEDATE"":""2017-03-30"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3630.0,""CREDCONTSTAT"":"""",""DAYSAGE"":321.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\03 Mar\\Termijnfactuur_1022130010_170330134855.pdf""},{""INVOICEDUEDATE"":""2017-05-03"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""3630"",""PERIOD"":""201701"",""SALESORDER"":""102220"",""INVOICENO"":""6101258"",""INVOICEDATE"":""2017-04-03"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3630.0,""CREDCONTSTAT"":"""",""DAYSAGE"":317.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Termijnfactuur_1022200010_170403212713.pdf""},{""INVOICEDUEDATE"":""2017-05-03"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""7260"",""PERIOD"":""201701"",""SALESORDER"":""102220"",""INVOICENO"":""6101259"",""INVOICEDATE"":""2017-04-03"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":7260.0,""CREDCONTSTAT"":"""",""DAYSAGE"":317.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Termijnfactuur_1022200020_170403212816.pdf""},{""INVOICEDUEDATE"":""2017-05-06"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""263.66"",""PERIOD"":""201702"",""SALESORDER"":""102225"",""INVOICENO"":""6101260"",""INVOICEDATE"":""2017-04-06"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":263.66,""CREDCONTSTAT"":"""",""DAYSAGE"":314.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Factuur_60  71074-01_170406104833.pdf""},{""INVOICEDUEDATE"":""2017-05-10"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""263.66"",""PERIOD"":""201701"",""SALESORDER"":""102231"",""INVOICENO"":""6101261"",""INVOICEDATE"":""2017-04-10"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":263.66,""CREDCONTSTAT"":"""",""DAYSAGE"":310.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Factuur_60  71077-01_170410092624.pdf""},{""INVOICEDUEDATE"":""2017-06-09"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1261.97"",""PERIOD"":""201704"",""SALESORDER"":""101760"",""INVOICENO"":""6101262"",""INVOICEDATE"":""2017-04-10"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1261.97,""CREDCONTSTAT"":"""",""DAYSAGE"":310.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Factuur_60  70719-01_170410122815.pdf""},{""INVOICEDUEDATE"":""2017-06-12"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""801.63"",""PERIOD"":""201704"",""SALESORDER"":""102236"",""INVOICENO"":""6101263"",""INVOICEDATE"":""2017-04-13"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":801.63,""CREDCONTSTAT"":"""",""DAYSAGE"":307.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Factuur_60  71081-01_170413143401.pdf""},{""INVOICEDUEDATE"":""2017-05-14"",""CUSTOMERID"":""1004"",""INVOICEAMT"":""1210"",""PERIOD"":""201704"",""SALESORDER"":""102180"",""INVOICENO"":""6101264"",""INVOICEDATE"":""2017-04-14"",""DEBTORID"":""1004"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Zantingh BV, Groningen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1210.0,""CREDCONTSTAT"":"""",""DAYSAGE"":306.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Termijnfactuur_1021800010_170414154300.pdf""},{""INVOICEDUEDATE"":""2017-05-14"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""816.75"",""PERIOD"":""201704"",""SALESORDER"":""102246"",""INVOICENO"":""6101265"",""INVOICEDATE"":""2017-04-14"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":816.75,""CREDCONTSTAT"":"""",""DAYSAGE"":306.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\04 Apr\\Termijnfactuur_1022460010_170414154607.pdf""},{""INVOICEDUEDATE"":""2017-06-30"",""CUSTOMERID"":""1004"",""INVOICEAMT"":""100"",""PERIOD"":""201704"",""SALESORDER"":""102199"",""INVOICENO"":""6101266"",""INVOICEDATE"":""2017-05-01"",""DEBTORID"":""1004"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Zantingh BV, Groningen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":289.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Termijnfactuur_102199-0010_170501104930.pdf""},{""INVOICEDUEDATE"":""2017-06-30"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""9075"",""PERIOD"":""201704"",""SALESORDER"":""102209"",""INVOICENO"":""6101267"",""INVOICEDATE"":""2017-05-01"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":9075.0,""CREDCONTSTAT"":"""",""DAYSAGE"":289.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Termijnfactuur_102209-0010_170501104930.pdf""},{""INVOICEDUEDATE"":""2017-05-31"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""2.36"",""PERIOD"":""201704"",""SALESORDER"":""102214"",""INVOICENO"":""6101268"",""INVOICEDATE"":""2017-05-01"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2.36,""CREDCONTSTAT"":"""",""DAYSAGE"":289.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Termijnfactuur_102214-0010_170501104931.pdf""},{""INVOICEDUEDATE"":""2017-05-31"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""412.8"",""PERIOD"":""201704"",""SALESORDER"":""102224"",""INVOICENO"":""6101269"",""INVOICEDATE"":""2017-05-01"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":412.8,""CREDCONTSTAT"":"""",""DAYSAGE"":289.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Termijnfactuur_102224-0010_170501104931.pdf""},{""INVOICEDUEDATE"":""2017-05-31"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1633.5"",""PERIOD"":""201704"",""SALESORDER"":""102246"",""INVOICENO"":""6101270"",""INVOICEDATE"":""2017-05-01"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1633.5,""CREDCONTSTAT"":"""",""DAYSAGE"":289.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Termijnfactuur_102246-0020_170501104932.pdf""},{""INVOICEDUEDATE"":""2017-06-03"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""262.5"",""PERIOD"":""201704"",""SALESORDER"":""102255"",""INVOICENO"":""6101271"",""INVOICEDATE"":""2017-05-04"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":262.5,""CREDCONTSTAT"":"""",""DAYSAGE"":286.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Factuur_60  71094-01_170504120829.pdf""},{""INVOICEDUEDATE"":""2017-07-08"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""108.3"",""PERIOD"":""201704"",""SALESORDER"":""101995"",""INVOICENO"":""6101272"",""INVOICEDATE"":""2017-05-09"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":108.3,""CREDCONTSTAT"":"""",""DAYSAGE"":281.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Factuur_60  70899-01_170509112222.pdf""},{""INVOICEDUEDATE"":""2017-07-08"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""319.03"",""PERIOD"":""201704"",""SALESORDER"":""101997"",""INVOICENO"":""6101273"",""INVOICEDATE"":""2017-05-09"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":319.03,""CREDCONTSTAT"":"""",""DAYSAGE"":281.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\05 May\\Factuur_60  70900-01_170509112229.pdf""},{""INVOICEDUEDATE"":""2017-07-02"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""453.75"",""PERIOD"":""201706"",""SALESORDER"":""121397"",""INVOICENO"":""6101274"",""INVOICEDATE"":""2017-06-02"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":453.75,""CREDCONTSTAT"":""4"",""DAYSAGE"":257.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60    121397_170602105038.pdf""},{""INVOICEDUEDATE"":""2017-08-01"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""242"",""PERIOD"":""201706"",""SALESORDER"":""121398"",""INVOICENO"":""6101275"",""INVOICEDATE"":""2017-06-02"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":242.0,""CREDCONTSTAT"":"""",""DAYSAGE"":257.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60    121398_170602110224.pdf""},{""INVOICEDUEDATE"":""2017-07-12"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""694.24"",""PERIOD"":""201706"",""SALESORDER"":""101762"",""INVOICENO"":""6101276"",""INVOICEDATE"":""2017-06-12"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":694.24,""CREDCONTSTAT"":"""",""DAYSAGE"":247.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70721-01_170612122119.pdf""},{""INVOICEDUEDATE"":""2017-07-12"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""410.37"",""PERIOD"":""201706"",""SALESORDER"":""101764"",""INVOICENO"":""6101277"",""INVOICEDATE"":""2017-06-12"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":410.37,""CREDCONTSTAT"":"""",""DAYSAGE"":247.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70723-01_170612122123.pdf""},{""INVOICEDUEDATE"":""2017-07-20"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""293.12"",""PERIOD"":""201706"",""SALESORDER"":""102278"",""INVOICENO"":""6101278"",""INVOICEDATE"":""2017-06-20"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":293.12,""CREDCONTSTAT"":"""",""DAYSAGE"":239.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  71097-01_170620131404.pdf""},{""INVOICEDUEDATE"":""2017-07-20"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""293.12"",""PERIOD"":""201706"",""SALESORDER"":""102279"",""INVOICENO"":""6101279"",""INVOICEDATE"":""2017-06-20"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":293.12,""CREDCONTSTAT"":"""",""DAYSAGE"":239.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  71098-01_170620132011.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1005"",""INVOICEAMT"":""402.33"",""PERIOD"":""201706"",""SALESORDER"":""101770"",""INVOICENO"":""6101280"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":402.33,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70729-01_170624152108.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1005"",""INVOICEAMT"":""402.33"",""PERIOD"":""201706"",""SALESORDER"":""101771"",""INVOICENO"":""6101281"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":402.33,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70730-01_170624152112.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""842.34"",""PERIOD"":""201706"",""SALESORDER"":""101777"",""INVOICENO"":""6101282"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":842.34,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70733-01_170624152112.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""1006"",""INVOICEAMT"":""3375.54"",""PERIOD"":""201706"",""SALESORDER"":""101808"",""INVOICENO"":""6101283"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Valk Machinefabriek BV, Valkenswaard"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3375.54,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70754-01_170624152113.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1442.71"",""PERIOD"":""201706"",""SALESORDER"":""101906"",""INVOICENO"":""6101284"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1442.71,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70836-01_170624152113.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""517.28"",""PERIOD"":""201706"",""SALESORDER"":""101934"",""INVOICENO"":""6101285"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":517.28,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70851-01_170624152114.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""293.43"",""PERIOD"":""201706"",""SALESORDER"":""101969"",""INVOICENO"":""6101286"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":293.43,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70876-01_170624152114.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1116.23"",""PERIOD"":""201706"",""SALESORDER"":""101973"",""INVOICENO"":""6101287"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1116.23,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70882-01_170624152114.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""299.29"",""PERIOD"":""201706"",""SALESORDER"":""101977"",""INVOICENO"":""6101288"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":299.29,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70886-01_170624152115.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""517.28"",""PERIOD"":""201706"",""SALESORDER"":""101981"",""INVOICENO"":""6101289"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":517.28,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70890-01_170624152115.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""325.41"",""PERIOD"":""201706"",""SALESORDER"":""101983"",""INVOICENO"":""6101290"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1002"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Barosta BV, Woerden"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":325.41,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  70894-01_170624152116.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1148"",""INVOICEAMT"":""263.66"",""PERIOD"":""201706"",""SALESORDER"":""102229"",""INVOICENO"":""6101291"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":263.66,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  71076-01_170624152116.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1092.03"",""PERIOD"":""201706"",""SALESORDER"":""102248"",""INVOICENO"":""6101292"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1092.03,""CREDCONTSTAT"":"""",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60  71090-01_170624152117.pdf""},{""INVOICEDUEDATE"":""2017-07-24"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""242"",""PERIOD"":""201706"",""SALESORDER"":""121399"",""INVOICENO"":""6101293"",""INVOICEDATE"":""2017-06-24"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":242.0,""CREDCONTSTAT"":""4"",""DAYSAGE"":235.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\06 Jun\\Factuur_60    121399_170624152117.pdf""},{""INVOICEDUEDATE"":""2017-09-01"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""200"",""PERIOD"":""201706"",""SALESORDER"":""102290"",""INVOICENO"":""6101296"",""INVOICEDATE"":""2017-07-03"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":200.0,""CREDCONTSTAT"":"""",""DAYSAGE"":226.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\07 Jul\\Factuur_60  71108-01_170703170948.pdf""},{""INVOICEDUEDATE"":""2017-09-02"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""13090.58"",""PERIOD"":""201706"",""SALESORDER"":""5001"",""INVOICENO"":""6101297"",""INVOICEDATE"":""2017-07-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":13090.58,""CREDCONTSTAT"":"""",""DAYSAGE"":225.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\07 Jul\\Verzamelfactuur_61V   900421_170704152102.pdf""},{""INVOICEDUEDATE"":""2017-07-11"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""166.98"",""PERIOD"":""201706"",""SALESORDER"":""101044"",""INVOICENO"":""6101298"",""INVOICEDATE"":""2017-07-11"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":166.98,""CREDCONTSTAT"":"""",""DAYSAGE"":218.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\07 Jul\\Termijnfactuur_1010440010_170711210950.pdf""},{""INVOICEDUEDATE"":""2017-07-11"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""95.71"",""PERIOD"":""201706"",""SALESORDER"":""102266"",""INVOICENO"":""6101299"",""INVOICEDATE"":""2017-07-11"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":95.71,""CREDCONTSTAT"":"""",""DAYSAGE"":218.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\07 Jul\\Termijnfactuur_1022660010_170711210950.pdf""},{""INVOICEDUEDATE"":""2017-09-22"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""5747.5"",""PERIOD"":""201706"",""SALESORDER"":""102176"",""INVOICENO"":""6101300"",""INVOICEDATE"":""2017-07-24"",""DEBTORID"":""1003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Metals \u0026 Residues BV, Bussum"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":5747.5,""CREDCONTSTAT"":"""",""DAYSAGE"":205.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\07 Jul\\Verzamelfactuur_61V   900422_170724141049.pdf""},{""INVOICEDUEDATE"":""2017-08-23"",""CUSTOMERID"":""2008"",""INVOICEAMT"":""504.82"",""PERIOD"":""201706"",""SALESORDER"":""102314"",""INVOICENO"":""6101301"",""INVOICEDATE"":""2017-07-24"",""DEBTORID"":""2008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""TNT Post, DEN HAAG"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":504.82,""CREDCONTSTAT"":"""",""DAYSAGE"":205.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\07 Jul\\Factuur_60  71137-01_170724141611.pdf""},{""INVOICEDUEDATE"":""2017-10-07"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""536.88"",""PERIOD"":""201709"",""SALESORDER"":""121402"",""INVOICENO"":""6101302"",""INVOICEDATE"":""2017-09-07"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":536.88,""CREDCONTSTAT"":"""",""DAYSAGE"":160.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\09 Sep\\Factuur_60    121402_170907205953.pdf""},{""INVOICEDUEDATE"":""2017-10-07"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""376.43"",""PERIOD"":""201709"",""SALESORDER"":""121403"",""INVOICENO"":""6101303"",""INVOICEDATE"":""2017-09-07"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":376.43,""CREDCONTSTAT"":"""",""DAYSAGE"":160.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\09 Sep\\Factuur_60    121403_170907210332.pdf""},{""INVOICEDUEDATE"":""2017-10-07"",""CUSTOMERID"":""1002"",""INVOICEAMT"":""876.28"",""PERIOD"":""201709"",""SALESORDER"":""121404"",""INVOICENO"":""6101304"",""INVOICEDATE"":""2017-09-07"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":876.28,""CREDCONTSTAT"":"""",""DAYSAGE"":160.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\09 Sep\\Factuur_60    121404_170907210333.pdf""},{""INVOICEDUEDATE"":""2017-11-17"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""825.83"",""PERIOD"":""201709"",""SALESORDER"":""102019"",""INVOICENO"":""6101305"",""INVOICEDATE"":""2017-09-18"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":825.83,""CREDCONTSTAT"":"""",""DAYSAGE"":149.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\09 Sep\\Factuur_60    102019_170918191012.pdf""},{""INVOICEDUEDATE"":""2017-11-27"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1092.03"",""PERIOD"":""201709"",""SALESORDER"":""102337"",""INVOICENO"":""6101306"",""INVOICEDATE"":""2017-09-28"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1092.03,""CREDCONTSTAT"":"""",""DAYSAGE"":139.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\09 Sep\\Factuur_60  71163-01_170928111621.pdf""},{""INVOICEDUEDATE"":""2017-11-05"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""399.3"",""PERIOD"":""201710"",""SALESORDER"":""121405"",""INVOICENO"":""6101307"",""INVOICEDATE"":""2017-10-06"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":399.3,""CREDCONTSTAT"":"""",""DAYSAGE"":131.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60    121405_171006121706.pdf""},{""INVOICEDUEDATE"":""2017-12-05"",""CUSTOMERID"":""2012"",""INVOICEAMT"":""301.88"",""PERIOD"":""201706"",""SALESORDER"":""102347"",""INVOICENO"":""6101308"",""INVOICEDATE"":""2017-10-06"",""DEBTORID"":""2012"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""01"",""CURRENCYDESC"":""$"",""DEBTORDESC"":""Yankee Manufacturing Inc., NEW YORK"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":301.88,""CREDCONTSTAT"":"""",""DAYSAGE"":131.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71170-01_171006123405.pdf""},{""INVOICEDUEDATE"":""2017-12-11"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1191.85"",""PERIOD"":""201710"",""SALESORDER"":""5010005"",""INVOICENO"":""6101309"",""INVOICEDATE"":""2017-10-12"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1191.85,""CREDCONTSTAT"":"""",""DAYSAGE"":125.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71168-01_171012101132.pdf""},{""INVOICEDUEDATE"":""2017-11-12"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""3542.15"",""PERIOD"":""201710"",""SALESORDER"":""102340"",""INVOICENO"":""6101310"",""INVOICEDATE"":""2017-10-13"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3542.15,""CREDCONTSTAT"":"""",""DAYSAGE"":124.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71166-01_171013144544.pdf""},{""INVOICEDUEDATE"":""2017-11-17"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""2336.27"",""PERIOD"":""201710"",""SALESORDER"":""102333"",""INVOICENO"":""6101312"",""INVOICEDATE"":""2017-10-18"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":2336.27,""CREDCONTSTAT"":"""",""DAYSAGE"":119.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71161-01_171018192807.pdf""},{""INVOICEDUEDATE"":""2017-11-17"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""18469.8"",""PERIOD"":""201710"",""SALESORDER"":""102351"",""INVOICENO"":""6101313"",""INVOICEDATE"":""2017-10-18"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":18469.8,""CREDCONTSTAT"":"""",""DAYSAGE"":119.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71182-01_171018192808.pdf""},{""INVOICEDUEDATE"":""2017-11-17"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""6325.28"",""PERIOD"":""201710"",""SALESORDER"":""102351"",""INVOICENO"":""6101314"",""INVOICEDATE"":""2017-10-18"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":6325.28,""CREDCONTSTAT"":"""",""DAYSAGE"":119.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71181-01_171018192808.pdf""},{""INVOICEDUEDATE"":""2017-12-17"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1415.7"",""PERIOD"":""201710"",""SALESORDER"":""5010009"",""INVOICENO"":""6101315"",""INVOICEDATE"":""2017-10-18"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1415.7,""CREDCONTSTAT"":"""",""DAYSAGE"":119.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71169-01_171018192809.pdf""},{""INVOICEDUEDATE"":""2017-11-18"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""3993"",""PERIOD"":""201712"",""SALESORDER"":""102352"",""INVOICENO"":""6101316"",""INVOICEDATE"":""2017-10-19"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":3993.0,""CREDCONTSTAT"":"""",""DAYSAGE"":118.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\10 Oct\\Factuur_60  71180-01_171019101944.pdf""},{""INVOICEDUEDATE"":""2017-10-31"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201710"",""SALESORDER"":"""",""INVOICENO"":""6101317"",""INVOICEDATE"":""2017-10-01"",""DEBTORID"":""2008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""TNT Post, DEN HAAG"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":136.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-12-06"",""CUSTOMERID"":""2003"",""INVOICEAMT"":""579.29"",""PERIOD"":""201712"",""SALESORDER"":""102374"",""INVOICENO"":""6101318"",""INVOICEDATE"":""2017-11-06"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":500.0,""AMTCUROPEN"":79.29,""CREDCONTSTAT"":"""",""DAYSAGE"":100.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\11 Nov\\Factuur_60  71213-01_171106094900.pdf""},{""INVOICEDUEDATE"":""2018-01-07"",""CUSTOMERID"":""2012"",""INVOICEAMT"":""500.13"",""PERIOD"":""201711"",""SALESORDER"":""102376"",""INVOICENO"":""6101319"",""INVOICEDATE"":""2017-11-08"",""DEBTORID"":""2012"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""01"",""CURRENCYDESC"":""$"",""DEBTORDESC"":""Yankee Manufacturing Inc., NEW YORK"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":500.13,""CREDCONTSTAT"":"""",""DAYSAGE"":98.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\11 Nov\\Factuur_60  71217-01_171108132843.pdf""},{""INVOICEDUEDATE"":""2017-12-24"",""CUSTOMERID"":"""",""INVOICEAMT"":""500"",""PERIOD"":""201710"",""SALESORDER"":"""",""INVOICENO"":""6101320"",""INVOICEDATE"":""2017-10-25"",""DEBTORID"":""2012"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""01"",""CURRENCYDESC"":""$"",""DEBTORDESC"":""Yankee Manufacturing Inc., NEW YORK"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":500.0,""CREDCONTSTAT"":"""",""DAYSAGE"":112.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2018-02-02"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""583.83"",""PERIOD"":""201712"",""SALESORDER"":""102395"",""INVOICENO"":""6101323"",""INVOICEDATE"":""2017-12-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":583.83,""CREDCONTSTAT"":"""",""DAYSAGE"":72.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Factuur_60  71222-01_171204162918.pdf""},{""INVOICEDUEDATE"":""2018-02-02"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""703.62"",""PERIOD"":""201712"",""SALESORDER"":""102396"",""INVOICENO"":""6101324"",""INVOICEDATE"":""2017-12-04"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":703.62,""CREDCONTSTAT"":"""",""DAYSAGE"":72.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Factuur_60  71223-01_171204165118.pdf""},{""INVOICEDUEDATE"":""2018-01-04"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""6050"",""PERIOD"":""201711"",""SALESORDER"":""102398"",""INVOICENO"":""6101325"",""INVOICEDATE"":""2017-12-05"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":6050.0,""CREDCONTSTAT"":"""",""DAYSAGE"":71.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Termijnfactuur_102398-0010_171205110526.pdf""},{""INVOICEDUEDATE"":""2018-01-04"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""6050"",""PERIOD"":""201711"",""SALESORDER"":""102398"",""INVOICENO"":""6101326"",""INVOICEDATE"":""2017-12-05"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":6050.0,""CREDCONTSTAT"":"""",""DAYSAGE"":71.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Termijnfactuur_102398-0020_171205110527.pdf""},{""INVOICEDUEDATE"":""2018-01-06"",""CUSTOMERID"":"""",""INVOICEAMT"":""8000"",""PERIOD"":""201712"",""SALESORDER"":"""",""INVOICENO"":""6101327"",""INVOICEDATE"":""2017-12-07"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":100.0,""AMTCUROPEN"":7900.0,""CREDCONTSTAT"":"""",""DAYSAGE"":69.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2018-01-10"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""517.28"",""PERIOD"":""201712"",""SALESORDER"":""102402"",""INVOICENO"":""6101328"",""INVOICEDATE"":""2017-12-11"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":517.28,""CREDCONTSTAT"":"""",""DAYSAGE"":65.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Factuur_60  71224-01_171211113455.pdf""},{""INVOICEDUEDATE"":""2018-01-14"",""CUSTOMERID"":""1009"",""INVOICEAMT"":""1005.87"",""PERIOD"":""201712"",""SALESORDER"":""102378"",""INVOICENO"":""6101329"",""INVOICEDATE"":""2017-12-15"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1005.87,""CREDCONTSTAT"":"""",""DAYSAGE"":61.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Factuur_60  71219-01_171215100451.pdf""},{""INVOICEDUEDATE"":""2018-01-19"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""1972.3"",""PERIOD"":""201712"",""SALESORDER"":""121406"",""INVOICENO"":""6101330"",""INVOICEDATE"":""2017-12-20"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1972.3,""CREDCONTSTAT"":"""",""DAYSAGE"":56.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Verzamelfactuur_61V   900423_171220092317.pdf""},{""INVOICEDUEDATE"":""2018-02-18"",""CUSTOMERID"":"""",""INVOICEAMT"":""1210"",""PERIOD"":""201711"",""SALESORDER"":"""",""INVOICENO"":""6101331"",""INVOICEDATE"":""2017-12-20"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1210.0,""CREDCONTSTAT"":"""",""DAYSAGE"":56.0,""DUE"":0.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2018-02-18"",""CUSTOMERID"":""1000"",""INVOICEAMT"":""1415.7"",""PERIOD"":""201712"",""SALESORDER"":""102415"",""INVOICENO"":""6101332"",""INVOICEDATE"":""2017-12-20"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1415.7,""CREDCONTSTAT"":"""",""DAYSAGE"":56.0,""DUE"":0.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Factuur_60  71305-01_171220200744.pdf""},{""INVOICEDUEDATE"":""2018-01-20"",""CUSTOMERID"":""1010"",""INVOICEAMT"":""816.75"",""PERIOD"":""201712"",""SALESORDER"":""102417"",""INVOICENO"":""6101333"",""INVOICEDATE"":""2017-12-21"",""DEBTORID"":""1007"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Ypma Fijnmetaal BV, Heerenveen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":816.75,""CREDCONTSTAT"":"""",""DAYSAGE"":55.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2017\\12 Dec\\Factuur_60  71311-01_171221141521.pdf""},{""INVOICEDUEDATE"":""2018-03-04"",""CUSTOMERID"":""1001"",""INVOICEAMT"":""263.66"",""PERIOD"":""201801"",""SALESORDER"":""102422"",""INVOICENO"":""6101334"",""INVOICEDATE"":""2018-01-03"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":263.66,""CREDCONTSTAT"":"""",""DAYSAGE"":42.0,""DUE"":0.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2018\\01 Jan\\Verzamelfactuur_61V   900424_180103134851.pdf""},{""INVOICEDUEDATE"":""2018-02-04"",""CUSTOMERID"":""1011"",""INVOICEAMT"":""517.28"",""PERIOD"":""201801"",""SALESORDER"":""102424"",""INVOICENO"":""6101335"",""INVOICEDATE"":""2018-01-05"",""DEBTORID"":""1011"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Humarbo Machines en Mallen VOF, Vaassen"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":517.28,""CREDCONTSTAT"":"""",""DAYSAGE"":40.0,""DUE"":1.0,""FILEURL"":""\\\\172.19.5.20\\Prodin_documenten\\PCN\\Factuur\\2018\\01 Jan\\Factuur_60  71318-01_180105085602.pdf""},{""INVOICEDUEDATE"":""2018-02-08"",""CUSTOMERID"":"""",""INVOICEAMT"":""1800"",""PERIOD"":""201801"",""SALESORDER"":"""",""INVOICENO"":""6101336"",""INVOICEDATE"":""2018-01-09"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1800.0,""CREDCONTSTAT"":"""",""DAYSAGE"":36.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-12-16"",""CUSTOMERID"":"""",""INVOICEAMT"":""1210"",""PERIOD"":""201710"",""SALESORDER"":"""",""INVOICENO"":""6110048"",""INVOICEDATE"":""2017-10-17"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1210.0,""CREDCONTSTAT"":"""",""DAYSAGE"":120.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2015-04-20"",""CUSTOMERID"":"""",""INVOICEAMT"":""-800"",""PERIOD"":""201504"",""SALESORDER"":"""",""INVOICENO"":""6180082"",""INVOICEDATE"":""2015-04-20"",""DEBTORID"":""2007"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""SKG Trading BV, LIMMEN"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-800.0,""CREDCONTSTAT"":"""",""DAYSAGE"":1031.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2015-07-12"",""CUSTOMERID"":"""",""INVOICEAMT"":""1210"",""PERIOD"":""201506"",""SALESORDER"":"""",""INVOICENO"":""6180085"",""INVOICEDATE"":""2015-06-12"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":-2232.9,""AMTCUROPEN"":3442.9,""CREDCONTSTAT"":""4"",""DAYSAGE"":978.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-03-06"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201602"",""SALESORDER"":"""",""INVOICENO"":""6180107"",""INVOICEDATE"":""2016-02-05"",""DEBTORID"":""1410"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Vaadin GmbH, Berlin"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":740.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-03-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201602"",""SALESORDER"":"""",""INVOICENO"":""6180115"",""INVOICEDATE"":""2016-02-08"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":""4"",""DAYSAGE"":737.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-03-10"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201602"",""SALESORDER"":"""",""INVOICENO"":""6180118"",""INVOICEDATE"":""2016-02-09"",""DEBTORID"":""1410"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Vaadin GmbH, Berlin"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":736.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-03-10"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201602"",""SALESORDER"":"""",""INVOICENO"":""6180120"",""INVOICEDATE"":""2016-02-09"",""DEBTORID"":""1410"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Vaadin GmbH, Berlin"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":736.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-10-23"",""CUSTOMERID"":"""",""INVOICEAMT"":""1200"",""PERIOD"":""201608"",""SALESORDER"":"""",""INVOICENO"":""6180131"",""INVOICEDATE"":""2016-08-24"",""DEBTORID"":""2012"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Yankee Manufacturing Inc., NEW YORK"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":1200.0,""CREDCONTSTAT"":"""",""DAYSAGE"":539.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-09-16"",""CUSTOMERID"":"""",""INVOICEAMT"":""771.12"",""PERIOD"":""201608"",""SALESORDER"":"""",""INVOICENO"":""6180133"",""INVOICEDATE"":""2016-08-17"",""DEBTORID"":""1009"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Dieze Machinebouw BV, \u0027s Hertogenbosch"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":771.12,""CREDCONTSTAT"":"""",""DAYSAGE"":546.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-10-30"",""CUSTOMERID"":"""",""INVOICEAMT"":""8500"",""PERIOD"":""201609"",""SALESORDER"":"""",""INVOICENO"":""6180136"",""INVOICEDATE"":""2016-09-30"",""DEBTORID"":""1151"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Horlogefabrief Zwitserland, Basel"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":8500.0,""CREDCONTSTAT"":"""",""DAYSAGE"":502.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-10-31"",""CUSTOMERID"":"""",""INVOICEAMT"":""1200"",""PERIOD"":""201610"",""SALESORDER"":"""",""INVOICENO"":""6180140"",""INVOICEDATE"":""2016-10-01"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":800.0,""AMTCUROPEN"":400.0,""CREDCONTSTAT"":"""",""DAYSAGE"":501.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2016-10-31"",""CUSTOMERID"":"""",""INVOICEAMT"":""122.39"",""PERIOD"":""201610"",""SALESORDER"":"""",""INVOICENO"":""6180141"",""INVOICEDATE"":""2016-10-01"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":122.39,""CREDCONTSTAT"":"""",""DAYSAGE"":501.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-03-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201702"",""SALESORDER"":"""",""INVOICENO"":""6180143"",""INVOICEDATE"":""2017-02-07"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":372.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-03-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""100"",""PERIOD"":""201702"",""SALESORDER"":"""",""INVOICENO"":""6180144"",""INVOICEDATE"":""2017-02-07"",""DEBTORID"":""1117"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""OTTO KOEHSEL \u0026 SOHN, BERLIJN"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":100.0,""CREDCONTSTAT"":"""",""DAYSAGE"":372.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-02-08"",""CUSTOMERID"":"""",""INVOICEAMT"":""-21.9"",""PERIOD"":""201702"",""SALESORDER"":"""",""INVOICENO"":""6180145"",""INVOICEDATE"":""2017-02-08"",""DEBTORID"":""2008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""TNT Post, DEN HAAG"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":-21.9,""CREDCONTSTAT"":"""",""DAYSAGE"":371.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-04-01"",""CUSTOMERID"":"""",""INVOICEAMT"":""200"",""PERIOD"":""201703"",""SALESORDER"":"""",""INVOICENO"":""6180148"",""INVOICEDATE"":""2017-03-02"",""DEBTORID"":""1148"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Berlin Group, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":200.0,""CREDCONTSTAT"":"""",""DAYSAGE"":349.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-08-08"",""CUSTOMERID"":"""",""INVOICEAMT"":""500"",""PERIOD"":""201706"",""SALESORDER"":"""",""INVOICENO"":""6180151"",""INVOICEDATE"":""2017-06-09"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":500.0,""CREDCONTSTAT"":"""",""DAYSAGE"":250.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-07-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""530"",""PERIOD"":""201706"",""SALESORDER"":"""",""INVOICENO"":""6180153"",""INVOICEDATE"":""2017-06-09"",""DEBTORID"":""1005"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Thermatras BV, Oud Beijerland"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":530.0,""CREDCONTSTAT"":"""",""DAYSAGE"":250.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-07-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""650"",""PERIOD"":""201706"",""SALESORDER"":"""",""INVOICENO"":""6180154"",""INVOICEDATE"":""2017-06-09"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":650.0,""CREDCONTSTAT"":""4"",""DAYSAGE"":250.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-07-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""800"",""PERIOD"":""201706"",""SALESORDER"":"""",""INVOICENO"":""6180156"",""INVOICEDATE"":""2017-06-09"",""DEBTORID"":""2008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""TNT Post, DEN HAAG"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":800.0,""CREDCONTSTAT"":"""",""DAYSAGE"":250.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-08-30"",""CUSTOMERID"":"""",""INVOICEAMT"":""800"",""PERIOD"":""201707"",""SALESORDER"":"""",""INVOICENO"":""6180157"",""INVOICEDATE"":""2017-07-31"",""DEBTORID"":""2008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""TNT Post, DEN HAAG"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":800.0,""CREDCONTSTAT"":"""",""DAYSAGE"":198.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-02-14"",""CUSTOMERID"":"""",""INVOICEAMT"":""800"",""PERIOD"":""201701"",""SALESORDER"":"""",""INVOICENO"":""6180158"",""INVOICEDATE"":""2017-01-31"",""DEBTORID"":""1141"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Duitse Spoorwegen, Berlijn"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":800.0,""CREDCONTSTAT"":"""",""DAYSAGE"":379.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-07-11"",""CUSTOMERID"":"""",""INVOICEAMT"":""95"",""PERIOD"":""201706"",""SALESORDER"":"""",""INVOICENO"":""6180159"",""INVOICEDATE"":""2017-06-11"",""DEBTORID"":""1001"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Combidex BV, Schiedam"",""INVOICEAMTPAID"":0.0,""AMTCUROPEN"":95.0,""CREDCONTSTAT"":"""",""DAYSAGE"":248.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-06-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""0"",""PERIOD"":""201706"",""SALESORDER"":"""",""INVOICENO"":""V000043"",""INVOICEDATE"":""2017-06-09"",""DEBTORID"":""1008"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Valk Machinefabriek BV, Valkenswaard"",""INVOICEAMTPAID"":1000.0,""AMTCUROPEN"":-1000.0,""CREDCONTSTAT"":"""",""DAYSAGE"":250.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-06-12"",""CUSTOMERID"":"""",""INVOICEAMT"":""0"",""PERIOD"":""201706"",""SALESORDER"":""test"",""INVOICENO"":""V000044"",""INVOICEDATE"":""2017-06-12"",""DEBTORID"":""1000"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Brandwerk BV, Rotterdam"",""INVOICEAMTPAID"":1000.0,""AMTCUROPEN"":-1000.0,""CREDCONTSTAT"":"""",""DAYSAGE"":247.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2017-10-13"",""CUSTOMERID"":"""",""INVOICEAMT"":""0"",""PERIOD"":""201710"",""SALESORDER"":"""",""INVOICENO"":""V000045"",""INVOICEDATE"":""2017-10-13"",""DEBTORID"":""2012"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Yankee Manufacturing Inc., NEW YORK"",""INVOICEAMTPAID"":8000.0,""AMTCUROPEN"":-8000.0,""CREDCONTSTAT"":"""",""DAYSAGE"":124.0,""DUE"":1.0,""FILEURL"":""""},{""INVOICEDUEDATE"":""2018-01-09"",""CUSTOMERID"":"""",""INVOICEAMT"":""0"",""PERIOD"":""201801"",""SALESORDER"":"""",""INVOICENO"":""V000049"",""INVOICEDATE"":""2018-01-09"",""DEBTORID"":""2003"",""SITEID"":""01"",""PAID"":false,""CURRENCYID"":""00"",""CURRENCYDESC"":""\u20AC"",""DEBTORDESC"":""Golio Trading BV, NIJMEGEN"",""INVOICEAMTPAID"":500.0,""AMTCUROPEN"":-500.0,""CREDCONTSTAT"":"""",""DAYSAGE"":36.0,""DUE"":1.0,""FILEURL"":""""}]")

state! = new BBjGridExWidgetColumnState()
state!.setString(state$)
    
    grid!.setData(rs!)
    wait .5
    grid!.setColumnsState(state!)

return

byebye:
    bye
    
resize:
    ev! = BBjAPI().getLastEvent()
    grid!.setSize(ev!.getWidth(),ev!.getHeight()-30)
return


onWinKeypress:
    declare auto BBjKeypressEvent key_ev!
    key_ev! = BBjAPI().getLastEvent()
    if key_ev!.getKeyCode() = 342 then
       grid!.showDeveloperConsole()
    fi
return

ag-Grid v15.0 component names have been renamed to be namespaced.

ag-Grid v15.0 component names have been renamed to be namespaced. we should rename filter:number to filter:agNumberColumnFilter and filter:text to filter:agTextColumnFilter

deleting a row changes previously changes row data back

(Updated demo showing the issue in the updataData branch)

See https://www.screencast.com/t/ch5GBcHACAtt

same happens if the update was in a row higher than the removed one

add masking/ cell renderer for Timestamp

see https://raw.githubusercontent.com/BBj-Plugins/BBjGridExWidget/master/Demo/DatatypesDemo.bbj

DATE type works, TIMESTAMP needs attention

The grid remembers selected row from previous filled Grid

By Erwin van Aken

I found a little annoying bug in the AG-grid, it remembers the selected row (double click) from a previous filled grid.
When you run the program, the grid is loaded with data.
Just double click a few times on some rows.
Then click the “fillGrid” button. This reloads the grid data again.
Now, if you double click on a row it shows that 2 rows are selected, but this is not true !

add cell renderer for boolean type

see https://raw.githubusercontent.com/BBj-Plugins/BBjGridExWidget/master/Demo/DatatypesDemo.bbj
we want to show < cross and a check instead of "false" and "true"

Columns can not be moved programmatically

There is no way to allow the programmer to move columns (change index) without performing a full grid re-render

Masking of numbers does not work.

Example mask:-###,###,##0 value= 12345.67 --> Displays: 12345,67 instead of 12.346
mask: ##,##0 value= 1234 --> Displays: 1234,000 instead of 1.234
How do we have to set the mask correctly for the AG-grid, same as in BBj ?

need a cell click and double click event that returns column (name) and row (number)

Invalid Date Mask parsing

The INVOICDATE contains 2002-10-30' the cell shows 03-10-2002 , would expect 30-10-2002.
The INVOICDATE contains 2002-1-29' the cell shows 05-11-2002 , would expect 29-11-2002.

The column mask is set to %Dz-%Mz-%Yd

BBjGridExWidget constructor uses BBjInt should be BBjNumber

No match for method ::/u0/basis/bbj.18x/plugins/BBjGridExWidget/BBjGridExWidget.
bbj::BBjGridExWidget.(com.sun.proxy.$Proxy82, BBjNumber, BBjNumber, BBjNum
ber, BBjNumber, BBjNumber)

The BBjWidget / BBjControl Interface dictates BBjNumber....

allow updating one single row

Currently, the only way to update single values is a setData to the full grid. We want to offer a method that updates a single row:

the developer updates the value(s) inside the existing ResultSet
we add an updateRow(x) that sends the new row data to the grid and re-renders the row only
consider to only redraw the cells that have really changed

EditingDemo: when I click into a date or timestamp cell the date changes to some other date

the boolean toggle is always editable (changes state in click) also in non-editable cells

if a columns / cell is non-editable and you click on a toggle, it changes the state

Optinally Suppress the number of items in a group

ag-grid automatically adds the number of records in a group

Sweden (5)
Germany (17)

HTML is as follows:

<span class="ag-group-value" ref="eValue">English</span>
<span class="ag-group-child-count" ref="eChildCount">(26)</span>

We'd like to add an option to the BBj Plug-In

setShowGroupChildCount( 1/0 )

that toggles the display of the group count.

Extra functionality: Keyup and keydown event

A couple of weeks ago i asked Stephan if it is possible to use the arrow keys to navigate true this grid and select automaticly a row.
That function was not implemented at that time.
Now i see it is already implented.

My compliments. it works fine.

Implement [Enterprise Feature] - Tool Panel

improve row selection event when grid is tree grid

From customer:
J'ai activé l'évènement "ON_GRID_SELECT_ROW"
myGrid!.setSelectionMode(myGrid!.GRID_SELECT_ROW())

Le problème est que je n'ai le retour que sur les lignes de terminaison d'arbres et pas sur les nœuds intermédiaires, ce qui ne nous convient pas.
De plus, le retour de cet évènement "getSelectedRowCount()" est le numéro d'ordre de la terminaison. Ce n'est pas facile de retrouver les données associées

enhance datatypes demo to show different boolean representations

implement getSelectedRow(s)

improve export to excel

...with the visible columns and row, and according widths

Evaluate OPTS string to replace comma and dot character in number masks

This is how to determine it in BBj code:

rem set the values to something else

a$=opts
a$(3,1)=ior(a$(3,1),$02$)
a$(5,1)="c"
a$(6,1)="d"
setopts A$


comma$=","
dot$="."

a$=opts
if AND ( a$(3,1), $02$ ) = $02$ then
    comma$=a$(5,1)
    dot$=a$(6,1)
fi

print "comma$:",comma$
print "dot$:",dot$

grid!.Clear() ? to clear the grid of any data, reset it to an empty grid without the need to destroy and create it again

allow to change selection by simple cursor up-down

when grid!.setMultipleSelection(0) is set, it would be nice if you could move the selection bar with a simple cursor arrow up/down keypress. Can we make that happen?

if a ResultSet contains fields with null values, the rendering is kaputt

Run this sample program, the result set has one row with three fields that are null. (the line in REM has the same row, but the NULL fields have values there)

use ::BBjGridExWidget/BBjGridExWidget.bbj::BBjGridExWidget
use com.basiscomponents.db.ResultSet

use java.sql.Types

wnd! = BBjAPI().openSysGui("X0").addWindow(10,10,800,600,"BBj Grid Ex Demo")
grid! = new BBjGridExWidget(wnd!,100,0,0,800,600)
wnd!        .setCallback(BBjAPI.ON_CLOSE,"byebye")
wnd!        .setCallback(BBjAPI.ON_RESIZE,"resize")

gosub fillGrid

? 'SHOW','RAISE',

process_events

fillGrid:


rs! = ResultSet.fromJson("[{""STATUSDOCUMENTSID"":""A"",""QUANTITYCOLLI"":null,""TOTALWEIGHTCOLLI"":null,""SCHEDULEDSHIPMENTDATE"":""2011-05-06"",""SALESORDERID"":""101029"",""SHIPMENTID"":""70014"",""SITEID"":""01"",""CARRIERID"":""01"",""SHIPMENTTYPEID"":"""",""SHIPMENTTYPEDESC_SHORT"":"""",""CUSTOMERADDRESSID"":""1001"",""DELIVERY_FORMATTEDADDRESS"":""Combidex BV, 3115 HE  SCHIEDAM"",""ALLOWEDTOPRINTPICKLIST"":""0"",""SHIPMENTSTATUSID"":""5"",""TRANSPORT"":false,""SHIPMENTSTATUSDESC"":""Afgehandeld"",""CUSTOMERADDRESSDESC"":""Combidex BV, Schiedam (NL)"",""CARRIERDESC"":""Post NL"",""TRANSPORTID"":null,""meta"":{""STATUSDOCUMENTSID"":{""ColumnType"":""12""},""QUANTITYCOLLI"":{""ColumnType"":""2"",""MASK"":""-##,###,##0"",""LABEL"":""Colli"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""TOTALWEIGHTCOLLI"":{""ColumnType"":""2"",""MASK"":""-##,###,##0.00"",""LABEL"":""Gewicht"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""SCHEDULEDSHIPMENTDATE"":{""ColumnType"":""91"",""MASK"":""%Dz-%Mz-%Yd"",""LABEL"":""Verzenddatum"",""ALIGN"":""Center"",""FIELDTYPE"":""91""},""SALESORDERID"":{""ColumnType"":""12"",""LABEL"":""Verkooporder"",""ALIGN"":""Left""},""SHIPMENTID"":{""ColumnType"":""12"",""LABEL"":""Verzendnr."",""ALIGN"":""Left""},""SITEID"":{""ColumnType"":""12""},""CARRIERID"":{""ColumnType"":""12""},""SHIPMENTTYPEID"":{""ColumnType"":""12""},""SHIPMENTTYPEDESC_SHORT"":{""ColumnType"":""12""},""CUSTOMERADDRESSID"":{""ColumnType"":""12""},""DELIVERY_FORMATTEDADDRESS"":{""ColumnType"":""12"",""LABEL"":""Afleveradres"",""ALIGN"":""Left""},""ALLOWEDTOPRINTPICKLIST"":{""ColumnType"":""12""},""SHIPMENTSTATUSID"":{""ColumnType"":""12""},""TRANSPORT"":{""ColumnType"":""16""},""SHIPMENTSTATUSDESC"":{""ColumnType"":""12"",""LABEL"":""Status"",""ALIGN"":""Left""},""CUSTOMERADDRESSDESC"":{""ColumnType"":""12"",""LABEL"":""Klant"",""ALIGN"":""Left""},""CARRIERDESC"":{""ColumnType"":""12"",""LABEL"":""Vervoerder"",""ALIGN"":""Left""},""TRANSPORTID"":{""ColumnType"":""12""}}}"+"]")

rem this works, has no NULL values inside:
rem rs! = ResultSet.fromJson("[{""STATUSDOCUMENTSID"":""A"",""QUANTITYCOLLI"":3,""TOTALWEIGHTCOLLI"":4,""SCHEDULEDSHIPMENTDATE"":""2011-05-06"",""SALESORDERID"":""101029"",""SHIPMENTID"":""70014"",""SITEID"":""01"",""CARRIERID"":""01"",""SHIPMENTTYPEID"":"""",""SHIPMENTTYPEDESC_SHORT"":"""",""CUSTOMERADDRESSID"":""1001"",""DELIVERY_FORMATTEDADDRESS"":""Combidex BV, 3115 HE  SCHIEDAM"",""ALLOWEDTOPRINTPICKLIST"":""0"",""SHIPMENTSTATUSID"":""5"",""TRANSPORT"":false,""SHIPMENTSTATUSDESC"":""Afgehandeld"",""CUSTOMERADDRESSDESC"":""Combidex BV, Schiedam (NL)"",""CARRIERDESC"":""Post NL"",""TRANSPORTID"":""22"",""meta"":{""STATUSDOCUMENTSID"":{""ColumnType"":""12""},""QUANTITYCOLLI"":{""ColumnType"":""2"",""MASK"":""-##,###,##0"",""LABEL"":""Colli"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""TOTALWEIGHTCOLLI"":{""ColumnType"":""2"",""MASK"":""-##,###,##0.00"",""LABEL"":""Gewicht"",""ALIGN"":""Right"",""FIELDTYPE"":""2""},""SCHEDULEDSHIPMENTDATE"":{""ColumnType"":""91"",""MASK"":""%Dz-%Mz-%Yd"",""LABEL"":""Verzenddatum"",""ALIGN"":""Center"",""FIELDTYPE"":""91""},""SALESORDERID"":{""ColumnType"":""12"",""LABEL"":""Verkooporder"",""ALIGN"":""Left""},""SHIPMENTID"":{""ColumnType"":""12"",""LABEL"":""Verzendnr."",""ALIGN"":""Left""},""SITEID"":{""ColumnType"":""12""},""CARRIERID"":{""ColumnType"":""12""},""SHIPMENTTYPEID"":{""ColumnType"":""12""},""SHIPMENTTYPEDESC_SHORT"":{""ColumnType"":""12""},""CUSTOMERADDRESSID"":{""ColumnType"":""12""},""DELIVERY_FORMATTEDADDRESS"":{""ColumnType"":""12"",""LABEL"":""Afleveradres"",""ALIGN"":""Left""},""ALLOWEDTOPRINTPICKLIST"":{""ColumnType"":""12""},""SHIPMENTSTATUSID"":{""ColumnType"":""12""},""TRANSPORT"":{""ColumnType"":""16""},""SHIPMENTSTATUSDESC"":{""ColumnType"":""12"",""LABEL"":""Status"",""ALIGN"":""Left""},""CUSTOMERADDRESSDESC"":{""ColumnType"":""12"",""LABEL"":""Klant"",""ALIGN"":""Left""},""CARRIERDESC"":{""ColumnType"":""12"",""LABEL"":""Vervoerder"",""ALIGN"":""Left""},""TRANSPORTID"":{""ColumnType"":""12""}}}]")

grid!.setData(rs!)
return

byebye:
bye

resize:
ev! = BBjAPI().getLastEvent()
grid!.setSize(ev!.getWidth(),ev!.getHeight())
return

Once the column is pinned it can not be unpinned

!ERROR=252 (java.lang.IndexOutOfBoundsException: Index: 0, Size: 0)

Error in BBjGridExWidget.bbj in method setData() on line r1! = rs!.getItem(0)
When rs! is empty (but not null()) --> !ERROR=252 (java.lang.IndexOutOfBoundsException: Index: 0, Size: 0)
(First time rs! is >0 items (grid contains lines), the second time rs! = 0 items (grid should be empty) --> Error)

 method public void setData( ResultSet rs!)
        #RS! = rs!
 
        if #AttributesRecord! <> NULL() then
            rem TODO: use the new method of components as soon as implemented
            rem https://github.com/BasisHub/components/issues/87
            r1! = rs!.getItem(0)

pinColumn can not update the grid after it is already rendered

pinColumn method updates the grid columns definition only and is not able to update the grid after the grid is rendered unless we perform a full re-render

Column with NULL value produces error when double-clicked

representation of boolean should be cross / check as default

Since editing was implemented, the toggle is the default display for booleans, also in non-editable cells.
The default should be the check / cross that was in place before, as is renders smaller. TBD if this can even be the default for editable cells (unlike a checkbox field the click event should work)

There is no way to allow data searching in the grid without a full re-render or without using column filter

setFitToGrid disallows the resizing of columns

This used to work before: the setFitToGrid should distribute all columns over the available space, so no horizontal scrollbar is shown. However, a user may still want to change the width of one column, which should reduce the size of one or more other columns in that mode.

setFitToGrid(1) causes rendering problems

run Demo.bbx and hit the fit to grid - Button.

adjust masking / cell renderer to BBx type masks

see https://raw.githubusercontent.com/BBj-Plugins/BBjGridExWidget/master/Demo/DatatypesDemo.bbj

The mask for numeric values does not work as expected.
Customers would want to use BBx specific masking. See http://documentation.basis.com/BASISHelp/WebHelp/usr/numeric_output.htm

add total rows (bottom / and or top)

support setCellImage to change the picture in a cell dynamically

BBj allows to set an image in a grid cell dynamically by code.

Implement a method that allows to set the picture in a cell by code, as follows:

void setCellImage(String rowkey$ String ColumnName$, BBjImage image!)

The method should hide all internal things to extract the image from the image! object, to set the according CSS rules etc so it becomes convenient to upgrade existing code.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.