setColumnsState is broken (and getColumnsState as well)

[StephanWald]

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