Loading component...
[NZ] ibs.network SQL dump 09.2024
SQL dump
date: 09.2024
size: ~19GB sql/csv files
zipped - 1.3GB
thanks to: 108111118101
Sample
[code]
Dump list
Name Size Date modified
stahl_portal/ 17/01/2025, 08:26:52
--invlines_1.csv 660 MB 29/09/2024, 12:29:50
--invlines_2.csv 758 MB 29/09/2024, 12:40:08
--invlines_3.csv 767 MB 29/09/2024, 12:48:22
--invlines_4.csv 1013 MB 29/09/2024, 13:01:08
--invlines_5.csv 89.6 MB 29/09/2024, 13:08:46
--stihl_portal_1.sql 707 MB 28/09/2024, 23:30:38
--stihl_portal_assetdx.sql 191 MB 28/09/2024, 23:19:26
--stihl_portal_customers.csv 344 MB 02/10/2024, 11:10:14
--stihl_portal_customers.sql 431 MB 27/09/2024, 23:55:04
--stihl_portal_invidx.sql 2.7 GB 29/09/2024, 13:20:00
_adams.sql 407 MB 27/09/2024, 23:43:14
_adrientestsite.sql 1.2 MB 27/09/2024, 23:43:40
_advs.sql 2.4 MB 27/09/2024, 23:44:04
_akoncopy.sql 33.7 MB 27/09/2024, 23:44:48
_als.sql 65.0 MB 27/09/2024, 23:45:52
_alwin.sql 2.3 MB 27/09/2024, 23:46:20
_aqua.sql 59.9 MB 27/09/2024, 23:47:16
_ats.sql 18.2 MB 27/09/2024, 23:47:56
_award.sql 110 MB 27/09/2024, 23:49:22
_backup.sql 1.1 MB 27/09/2024, 23:49:48
bacslcopy.sql 39.7 MB 28/09/2024, 23:36:14
_bacsl.sql 49.0 MB 27/09/2024, 23:50:38
_baypak.sql 33.0 MB 28/09/2024, 23:36:48
_bls.sql 269 MB 28/09/2024, 23:38:46
_blstringer.sql 122 MB 28/09/2024, 23:40:16
_carter.sql 594 MB 28/09/2024, 23:46:54
_ccw.sql 87.5 MB 28/09/2024, 23:48:32
_cfooncall.sql 1020 kB 28/09/2024, 23:48:58
_cfs.sql 31.1 MB 28/09/2024, 23:49:42
_clean.sql 32.6 MB 28/09/2024, 23:50:18
_devine.sql 99.4 MB 28/09/2024, 23:51:28
_devplumb.sql 126 MB 28/09/2024, 23:52:54
_dieselturbo.sql 97.8 MB 28/09/2024, 23:54:28
_diskites.sql 1.1 MB 28/09/2024, 23:56:48
_dtil.sql 19.0 MB 28/09/2024, 23:57:22
_ecs.sql 264 MB 29/09/2024, 00:00:14
_ehlbackup.sql 78.2 MB 29/09/2024, 00:02:48
_eidnz.sql 21.0 MB 29/09/2024, 00:03:24
_eslnorthland.sql 70.9 MB 29/09/2024, 00:04:20
_ethan.sql 883 kB 29/09/2024, 00:05:10
_euromarc.sql 150 MB 29/09/2024, 00:06:40
_ewl.sql 136 MB 29/09/2024, 00:08:06
_farmquip.sql 71.0 MB 29/09/2024, 00:09:00
_freetest.sql 29.3 MB 29/09/2024, 00:09:58
_gands.sql 73.8 MB 29/09/2024, 00:11:06
_gcl.sql 95.1 MB 29/09/2024, 00:12:24
_gftar.sql 84.0 MB 29/09/2024, 00:13:58
_gilmac.sql 51.9 MB 29/09/2024, 00:14:58
_good.sql 62.1 MB 29/09/2024, 00:16:38
_hallmach.sql 56.4 MB 29/09/2024, 00:17:32
_holme.sql 139 MB 29/09/2024, 00:19:08
_honar.sql 27.8 MB 29/09/2024, 00:21:00
_hyspecsak.sql 69.8 MB 29/09/2024, 11:05:08
_hyspecsch.sql 110 MB 29/09/2024, 11:06:52
_ice.sql 26.1 MB 29/09/2024, 11:07:36
_iddoors.sql 167 MB 29/09/2024, 11:09:12
_iiassist.sql 1.4 MB 29/09/2024, 11:09:38
_infusionnz.sql 192 MB 29/09/2024, 11:11:54
_jacdev.sql 40.4 MB 29/09/2024, 11:12:50
_lspdcopy.sql 2.7 MB 29/09/2024, 11:13:16
_mcgreg.sql 77.2 MB 29/09/2024, 11:14:22
_mcindoe.sql 52.7 MB 29/09/2024, 11:15:12
_mcivor.sql 83.2 MB 29/09/2024, 11:16:14
_mcquinn.sql 36.3 MB 29/09/2024, 11:17:10
_metcon.sql 52.1 MB 29/09/2024, 11:19:06
_mettech.sql 90.0 MB 29/09/2024, 11:20:32
_mikesbikes.sql 1.1 MB 29/09/2024, 11:20:56
_milkwater.sql 58.4 MB 29/09/2024, 11:21:40
_mypdf.sql 25.1 MB 29/09/2024, 11:22:32
_myplumb.sql 39.3 MB 29/09/2024, 11:23:26
_mzg.sql 108 MB 29/09/2024, 11:24:32
_npsl.sql 68.8 MB 29/09/2024, 11:25:22
_obrienpen.sql 409 kB 29/09/2024, 11:25:50
_obrienrot.sql 69.8 MB 29/09/2024, 11:26:36
_obriens.sql 43.8 MB 29/09/2024, 11:27:24
_obriensman.sql 37.7 MB 29/09/2024, 11:28:16
_obrienwakld.sql 45.3 MB 29/09/2024, 11:29:16
_obrienwh.sql 28.5 MB 29/09/2024, 11:30:08
_ontoit.sql 1.2 MB 29/09/2024, 11:30:32
_para.sql 105 MB 29/09/2024, 11:31:36
_pcoast.sql 38.2 MB 29/09/2024, 11:32:20
_peol.sql 159 MB 29/09/2024, 11:33:52
_petl.sql 93.7 MB 29/09/2024, 11:35:04
_pgw.sql 250 MB 29/09/2024, 11:38:00
_plad.sql 68.3 MB 29/09/2024, 11:40:36
_pspas.sql 22.5 MB 29/09/2024, 11:41:06
_pump.sql 9.5 MB 29/09/2024, 11:41:34
_ricom.sql 46.6 MB 29/09/2024, 11:42:16
_robelec.sql 65.5 MB 29/09/2024, 11:43:16
_seaharvester.sql 56.5 MB 29/09/2024, 11:44:04
_serv.sql 87.8 MB 29/09/2024, 11:45:20
_sohb.sql 123 MB 29/09/2024, 11:47:02
_spjs.sql 20.2 MB 29/09/2024, 11:48:00
_spl.sql 85.5 MB 29/09/2024, 11:49:14
_sportco.sql 67.0 MB 29/09/2024, 11:50:10
_sps.sql 51.4 MB 29/09/2024, 11:51:14
_taniascars.sql 1.0 MB 29/09/2024, 11:51:46
_tpst.sql 34.1 MB 29/09/2024, 11:52:26
_tron.sql 112 MB 29/09/2024, 11:53:54
_tsc.sql 49.5 MB 29/09/2024, 11:54:50
_tsscopy.sql 83.7 MB 29/09/2024, 11:56:20
_vandam.sql 39.8 MB 29/09/2024, 11:57:20
_waipa.sql 153 MB 29/09/2024, 11:59:54
_wairua.sql 976 kB 29/09/2024, 12:00:22
_wassco.sql 82.1 MB 29/09/2024, 12:01:32
_wds.sql 9.5 MB 29/09/2024, 12:02:06
_wpp.sql 89.0 MB 29/09/2024, 12:04:24
_zipnz.sql 417 MB 29/09/2024, 12:10:56
_zipnzcopy.sql 332 MB 29/09/2024, 12:14:58
_zippetone.sql 340 MB 29/09/2024, 12:18:28
bi_portal_2.sql 169 MB 02/10/2024, 11:48:48
bi_portal_customers.csv 24.4 MB 02/10/2024, 11:04:04
bi_portal.sql 1.3 GB 27/09/2024, 23:29:58
bi2_portal_customers.csv 14.1 MB 02/10/2024, 11:04:40
bi2_portal.sql 41.4 MB 27/09/2024, 23:17:00
customer_portal_customers.csv 6.2 MB 02/10/2024, 11:02:36
customer_portal_invlines.sql 1.3 GB 28/09/2024, 23:12:44
customer_portal_users.csv 239 kB 02/10/2024, 11:03:18
customer_portal.sql 258 MB 28/09/2024, 22:58:28
dashboard.sql 3.0 MB 27/09/2024, 23:33:08
development_management_portal.sql 34.6 MB 27/09/2024, 23:33:48
exports_portal.sql 1.7 kB 28/09/2024, 23:15:18
FACTORY.sql 444 kB 27/09/2024, 23:34:44
helpdesk.sql 17.1 MB 27/09/2024, 23:35:14
ibstest.sql 373 kB 28/09/2024, 23:16:04
mobile.sql 1.2 MB 27/09/2024, 23:36:26
mtd_portal.sql 580 kB 27/09/2024, 23:36:48
mysql.sql 763 kB 27/09/2024, 23:37:12
phpmyadmin.sql 133 kB 28/09/2024, 23:17:08
portal.sql 4.4 MB 27/09/2024, 23:38:20
INSERT INTO `accounts` (`seqno`, `alphakey`, `accountref`, `stopcredit`, `accounttype`, `name`, `dadd1`, `dadd2`, `dadd3`, `dadd4`, `dcity`, `dstate`, `dpostcode`, `dcountry`, `phone`, `fax`, `mobile`, `email`, `current`, `days30`, `days60`, `days90`, `bname`, `badd1`, `badd2`, `badd3`, `badd4`, `bcity`, `bstate`, `bpostcode`, `bcountry`, `notes`, `lng`, `lat`, `twitterid`, `facebookid`, `linkedinid`, `website`, `lastmodified`, `taxclass`, `crlimit`, `imported`, `userid`, `allowrestricted`, `need_orderno`, `modifiedflag`, `alert`, `syncuserid`, `leadsource`, `text1`, `text2`, `text3`, `text4`, `text5`, `text6`, `char1`, `char2`, `char3`, `char4`, `char5`, `char6`, `num1`, `num2`, `num3`, `num4`, `num5`, `num6`, `check1`, `check2`, `check3`, `check4`, `check5`, `check6`, `date1`, `date2`, `date3`, `date4`, `date5`, `date6`, `repcode`, `first`, `last`, `defdisc`, `pricelevel`, `xml`, `passwd`, `active`, `epo1`, `lastsale`, `defloc`, `type`, `group`, `marketing`, `industry`, `region`) VALUES
(170, '1', '1', 0, 'C', 'STEVE WARR FLOORING', '34 NAPIER STREET', NULL, NULL, NULL, 'NAPIER', '', '4112', '', '', '', '021 185 2234', 'smwarr@nowmail.co.nz', '96.1900', '0.0000', '0.0000', '0.0000', NULL, '34 NAPIER STREET', NULL, NULL, NULL, 'NAPIER', '', '4112', '', '20240408 - Sent copy of odue feb inv', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '33', '', 'STEVE WARR FLOORING', '0.00', 1, NULL, '', 0, NULL, '2024-09-03', 1, 'D Customers (2-5)', 'Flooring Contractors', NULL, NULL, NULL),
(171, '2', '2', 0, 'C', 'LOOKUP A/C', '', NULL, NULL, NULL, '', '', '', '', '', '', '', '', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '', NULL, NULL, NULL, '', '', '', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '', '', 'LOOKUP A/C', '0.00', 1, NULL, '', 0, NULL, '2012-11-21', 1, NULL, 'Retail Shop', NULL, NULL, NULL),
(172, '100', '100', 0, 'C', 'RAVENSDOWN FERTILISER CO-OPERATIVE LTD', 'RAVENSDOWN FERTILISER CO-OP LT', NULL, NULL, NULL, 'WAITANGI ROAD', 'AWATOTO', '', 'NAPIER', '835 5469', '834 1758', '025 641 4912', 'accountspayable@ravensdown.co.nz', '0.0000', '0.0000', '0.0000', '0.0000', NULL, 'P O BOX 16921', NULL, NULL, NULL, 'HORNBY', 'CHRISTCHURCH', '8441', '', '02.07.2014 - Emailed a copy of our Credit Application for completion as we do not have one on file - Ursula', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'JUANITA THORNE 0335', 'STEVE 025 6414912', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '29', '', 'RAVENSDOWN FERTILISER CO-OPERATIVE LTD', '0.00', 1, NULL, '', 0, NULL, '2018-06-29', 1, 'F Customers (0)', 'TRADE', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(173, '1000', '1000', 0, 'C', 'APM STONE & TILE SERVICES LTD', '712 GORDON ROAD', NULL, NULL, NULL, 'HASTINGS', '', '4120', '', '876 8012', '876 8012', '021 425 892', 'antonleona@dreamnet.co.nz', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '712 GORDON ROAD', NULL, NULL, NULL, 'HASTINGS', '', '4120', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'ANTON MOU', '', '', '', '', '', 'BSB&T', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '29', '', 'APM STONE & TILE SERVICES LTD', '0.00', 1, NULL, '', 0, NULL, '2020-01-27', 1, 'F Customers (0)', 'BSUB Brick & Tilers', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(174, '1001', '1001', 0, 'C', 'AFFORDAFLOOR', '452 SEAFIELD RD', NULL, NULL, NULL, 'RD 2', 'NAPIER', '4182', '', '836 6926', '', '0274 466 888', 'graeme.dimick@gmail.com', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '452 SEAFIELD RD', NULL, NULL, NULL, 'RD 2', 'NAPIER', '4182', '', '20161020 - PROMPT PMT WINNER\r\n\r\n\r\n20150803 - STOP CREDIT LTR SENT\r\n\r\n26.02.2014 - Sent copy of statement highlighting overdue\r\n28.02.2014 - STOP CREDIT LTR SENT\r\n06.05.2014 - Graeme was in will get me chq for overdue', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 12, 0, 0, 0, '', NULL, NULL, 'GRAEME', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '33', '', 'AFFORDAFLOOR', '0.00', 1, NULL, '', 0, NULL, '2023-08-02', 1, 'E Customers (0-2)', 'Flooring Contractors', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(175, '1002', '1002', 0, 'C', 'CONTINUOUS SPOUTING HB LTD', 'CONTINUOUS SPOUTING H.B. LTD', NULL, NULL, NULL, '36 THAMES STREET', 'ONEKAWA', '', 'NAPIER', '842 1180', '877 1635', '0274 746 383', 'sales@contspoutinghawkesbay.co.nz', '0.0000', '0.0000', '0.0000', '0.0000', NULL, 'P O BOX 28123', NULL, NULL, NULL, 'HAVELOCK NORTH', '', '4157', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'TERRY ROWE' 'KAREN ROWE A/C', '', '', '', '', 'BSCONT', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '', '', 'CONTINUOUS SPOUTING HB LTD', '0.00', 1, NULL, '', 0, NULL, '0000-00-00', 1, NULL, 'BSUB Contractors', NULL, NULL, NULL),
(176, '1004', '1004', 0, 'C', 'TWO TONE PAINTING', 'TWO TONE PAINTING', NULL, NULL, NULL, '31 CAMERON ROAD', 'NAPIER HILL', '', '', '835 2177', '835 2177', '0274 948 680', '', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '31 CAMERON ROAD', NULL, NULL, NULL, 'NAPIER', '', '4110', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'ANTHONY HIKO', '', '', '', '', '', 'BSP&D', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '', '', 'TWO TONE PAINTING', '0.00', 1, NULL, '', 0, NULL, '0000-00-00', 1, NULL, 'BSUB Painting & Decorating', NULL, NULL, NULL),
(177, '1006', '1006', 0, 'C', 'R BRACE', '542 NOTTINGLEY ROAD', NULL, NULL, NULL, 'FRIMLEY', 'HASTINGS', '4120', '', '878 8845', '', '027 444 9169', '', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '542 NOTTINGLEY ROAD', NULL, NULL, NULL, 'FRIMLEY', 'HASTINGS', '4120', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'RING MARIA AT HOME', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '33', '', 'R BRACE', '0.00', 1, NULL, '', 0, NULL, '2024-07-26', 1, 'E Customers (0-2)', 'Flooring Contractors', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(178, '1009', '1009', 0, 'C', 'TENNESSEE PLASTERING', 'TENNESSEE PLASTERING', NULL, NULL, NULL, '3 HILL ROAD', 'BAY VIEW', '', '', '0800 225873', '836 6477', '021 468 27', '', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '3 HILL ROAD', NULL, NULL, NULL, 'BAY VIEW', '', '4104', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'BRYAN TONG', '', '', '', '', '', 'BSPLAST', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '', '', 'TENNESSEE PLASTERING', '0.00', 1, NULL, '', 0, NULL, '0000-00-00', 1, NULL, 'BSUB Plasterer', NULL, NULL, NULL),
(179, '1011', '1011', 0, 'C', 'CLASSIC NZ LIMITED', '22 THAMES STREET', NULL, NULL, NULL, 'PANDORA', 'NAPIER', '', '', '835 9662', '835 7089', '', 'info@classicsheepskins.co.nz', '0.0000', '0.0000', '0.0000', '0.0000', NULL, 'P O BOX 126', NULL, NULL, NULL, 'NAPIER', '', '4140', '', '20220121 - PROMPT PMT WINNER\r\n20191021 - PROMPT PMT WINNER\r\n20170203 Rg Jean will pay everything up to day by 25th of month\r\n20170201 - STOP CREDIT LTR SENT\r\n20161101 - STOP CREDIT LTR SENT\r\n20161017 - Rg Jean we will be paid by EOM - we on the list\r\n20160920 - Jean will put us on list for PMT b4 EOM\r\n20160801 - STOP CREDIT LTR SENT\r\n20160427 Emailed copy of o/due stmt\r\n20151113 - Rg Jean will sort by EOM\r\n20151016 - Rg Jean will sort by EOM\r\n20150930 - Spoke to Jean will sort as soon as\r\n20150930 - STOP CREDIT LTR SENT\r\n\r\n19.12.2012 - Ursula rang and spoke to Jean, she will put on her urgent list\r\n22.02.2013 - Ursula rang and left a message for Jean as away, chasing nov/dec/jan invs and advised they are on stop credit.\r\n28.02.2013 - STOP CREDIT LTR SENT\r\n08.05.2013 - URSH SPOKE TO JEAN - MARCH WILL BE PAID THIS MTH - WE ON LIST\r\n6.6.13 Spoke with Alex re sprayable adhesive for leather/leather. MR recommended N105 and 555.\r\n7.6.13 Took pricing back to Wendy. She is leaving and Alex is the contact. Requested samples of both adhesives for trial.\r\n19.07.2013 Ursula spoke to Jean will be paid Monday night 22.07.2013\r\n18.09.2013 - Rg Jean - will pay by EOM so doesnt go on STOP\r\n11.10.2013 - Rg - Jean not there - Spoke to Valerie to check with Jean we on list for payment b4 EOM otherwise will go on STOP\r\n02.12.2013 - STOP CREDIT LTR SENT\r\n12.03.2014 - SPOKE TO JEAN - WILL SORT FOR US AS SOON AS SHE CAN.\r\n14.05.2014 - Emailed copy of stmt as at todays date with a note\r\n01.07.2014 - STOP CREDIT LTR SENT\r\n14.08.2014 - Rg and spoke to Jean - advised will go on STOP if June invoice not paid by EOM\r\n01.10.2014 - STOP CREDIT LTR SENT\r\n17.12.2014 - Rg Jean we on list to pay - no date though, advised EOM will be on STOP\r\n24.04.2015 - Ursula rg, no a/cs payable there spoke to Valerie and left message re overdue and if not paid Feb Inv by EOM will go on Stop credit', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'JEAN - ACCOUNTS', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '75', '', 'CLASSIC NZ LIMITED', '0.00', 1, NULL, '', 0, NULL, '2024-08-08', 1, 'D Customers (2-5)', 'TRADE', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(180, '1013', '1013', 0, 'C', 'EURO TILE LIMITED', '16 DROVERS WAY', NULL, NULL, NULL, 'FRIMLEY', 'HASTINGS', '4120', '', '', '', '027 5455 825', 'steve.eurotile@gmail.com', '151.5100', '0.0000', '0.0000', '0.0000', NULL, 'STEPHEN MOORE', NULL, NULL, NULL, '16 DROVERS WAY', 'FRIMLEY', '4120', 'HASTINGS', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'MURRAY NATTRASS A/', 'MIKE / SHARON', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '24', '', 'EURO TILE LIMITED', '0.00', 1, NULL, '', 0, NULL, '2024-09-27', 1, 'E Customers (0-2)', 'BSUB Brick & Tilers', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(181, '1019', '1019', 0, 'C', 'TEMPLE FLOORING LTD', '18 OWEN STREET', NULL, NULL, NULL, 'NAPIER SOUTH', 'NAPIER', '4110', '', '835 1156', '835 1156', '0274 852 944', '', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '18 OWEN STREET', NULL, NULL, NULL, 'NAPIER SOUTH', 'NAPIER', '4110', '', '20171114 - Helen rg had sent chq for $630.66 last month not arrive here, so have sent chq for $969.13 both months - rip up chq for $630.66 if arrives\r\n20170309 - Rg and left message for Rob to come in and change date on cheque\r\n20160220 PROMPT PMT WINNER\r\nRobbie rang he had posted cheq for November invoices 20.12.2012. Obviously got lost in post he going to organise a new chq.\r\n04.07.2014 Rob sent chq 002148 for $808.81 on 20.06.2014-told him to cancel and send again\r\n20.01.2015 - PROMPT PMT WINNER', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, 'ROBBIE A/H 835-1156', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '29', '', 'TEMPLE FLOORING LTD', '0.00', 1, NULL, '', 0, NULL, '2019-03-13', 1, 'F Customers (0)', 'Flooring Contractors', NULL, NULL, 'Napier, Hastings, CHB, Wairoa'),
(1536965399, '13377', '9887', 'Liquorland - South Colombo Liqour Ltd', '161 Colombo Street Sydenham', 'Christchurch', '', 'New Zealand 8023', '161 Colombo Street Sydenham', 'Christchurch', '8023', '', '(03) 332 0095', '', '', 'beckenham@liquorland.co.nz', 'LIQ SOUTH', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965400, '13377', '9888', 'Tyremax - Hamilton', '50 Chalmers Road Burbush', 'Christchurch', '', 'New Zealand 8441', '50 Chalmers Road Burbush', 'Hamilton', '3200', 'New Zealand', '', '', '', 'accounts@tyremax.co.nz', 'TYREMAX 1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965401, '13377', '9889', 'NZ Access', '21 Park Terrace Blenheim Central', 'Blenheim', '', 'New Zealand 7201', '21 Park Terrace Blenheim Central', 'Blenheim', '7201', 'New Zealand', '0800 083 348', '', '', 'adam@nzaccess.co.nz', 'NZ ACCES1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965402, '13377', '9890', 'Hortiecentre Group - Cromwell', '22 Pinot Noir Drive', 'Cromwell', '', 'New Zealand 9310', '22 Pinot Noir Drive', 'Cromwell', '9310', 'New Zealand', '0800 855 255', '', '', 'accounts@horticentre.co.nz', 'HORTIECEN1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965403, '13377', '9891', 'Next Level Civil', '1210B Alfriston Road', 'Auckland', '', 'New Zealand 2576', '1210B Alfriston Road', 'Auckland', '2576', 'New Zealand', '021 0292 2216', '', '', 'accounts@nextlevelcivil.co.nz', 'NEXT LEVE1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965404, '13377', '9892', 'Waratah Forestry Services', 'PO Box 375', 'Tokoroa', '', 'New Zealand 3240', '108 Sala St Whakawerawera', 'Rotorua', '3010', 'New Zealand', '07 343 1551', '', '', 'wfsinvoices@waratah.com', 'WARATAH F1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965405, '13377', '9893', 'The Bottle-O Ashhurst', '62 Cambridge Avenue', 'Ashhurst', '', 'New Zealand 4810', '62 Cambridge Avenue', 'Ashhurst', '4810', 'New Zealand', '(06) 777 5119', '', '', 'tboashhurst@gmail.com', 'THE BOTTL1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965406, '13377', '9894', 'Sands Maintenance', '3 Brightside Road Epsom', 'Auckland', '', 'New Zealand 1023', '3 Brightside Road Epsom', 'Auckland', '1023', 'New Zealand', '', '', '', 'philsands@xtra.co.nz', 'SANDS MAI1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965407, '13377', '9895', 'Sharp As Linehaul Ltd', '97 Mosston Road Castlecliff', 'Whanganui', '', 'New Zealand 4501', '13-15 Rakau Road Castlecliff', 'Whanganui', '4501', 'New Zealand', '027 243 9336', '', '', 'admin@sharpaslinehaul.co.nz', 'SHARP AS 1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965408, '13377', '9896', 'Clarksons Electrical - Hamilton', '20A Perclo Place Saint Andrews', 'Hamilton', '', 'New Zealand 3200', '20A Perclo Place Saint Andrews', 'Hamilton', '3200', 'New Zealand', '(07) 847 7274', '', '', 'accounts@clarksons.co.nz', 'CLARKSON1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965409, '13377', '9897', 'Pristine Drycleaners', '305 Cameron Road', 'Tauranga', '', '3110', '305 Cameron Road', 'Tauranga', '3110', '', '(07) 578 5703', '', '', 'admin@pristinetauranga.com', 'PRISTINE 1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965410, '13377', '9898', 'Sunson - Bishopsdale', '283 Greers Road Bishopsdale', 'Christchurch', '', 'New Zealand 8053', '283 Greers Road Bishopsdale', 'Christchurch', '8053', 'New Zealand', '', '', '', 'sunson-nz@hotmail.com', 'SUNSON - 1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965411, '13377', '9899', 'Cobden School', '53 Fox Street', 'Greymouth', '', 'New Zealand 7802', '53 Fox Street', 'Greymouth', '7802', 'New Zealand', '021 336 174', '', '', 'noulak@cobden.school.nz', 'COBDEN SC1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965412, '13377', '9900', 'Skill Lab - Christchurch', 'Ferrymead', 'Chrsitchurch', '', 'New Zealand 0000', 'Ferrymead', 'Christchurch', '0000', 'New Zealand', '(03) 550 1645', '', '', 'mike@skilllab.nz', 'SKILL LA1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965413, '13377', '9901', 'NZ Police - Paraparaumu', 'Shared Services PO Box 2797', 'Wellington', '', 'New Zealand 6140', '43 Ihakara Street Kapiti', 'Paraparaumu', '5032', 'New Zealand', '', '', '', 'accountsprocessing@police.govt.nz', 'NZ POLIC1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(1536965414, '13377', '9902', 'Hillcut Contracting', '211 Hokianga Road', 'Dargaville', '', 'New Zealand 0310', '211 Hokianga Road', 'Dargaville', '0310', 'New Zealand', '021 226 4652', '', '', 'tom@hillcutcontracting.co.nz', 'HILLCUT C1', '0.00', '', '', '', 0, '', '2024-02-26 03:30:03', '0000-00-00 00:00:00'),
(857, '1056', '1056', 0, 'C', 'Justin McKenzie Drainage', 'Justin McKenize', NULL, NULL, NULL, '255 Fernside Road', '', '', 'Rangiora', '', '', '021650967', 'justinmcknz15@gmail.com', '0.0000', '0.0000', '0.0000', '4799.0200', NULL, '2
55 Fernisde Road', NULL, NULL, NULL, '', '', '', 'Rangiora', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '15000.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.0
0', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', 'AM', '', 'Justin McKenzie Drainage', '0.00', 1, NULL, '', 0, NULL, '2023-09-29', 1, 'Drainage',
'Drainage Tier 1', NULL, NULL, 'Canterbury'),
(858, '1057', '1057', 0, 'C', 'Kere Marshall Drainage Services Ltd', '57 Bridge RD', NULL, NULL, NULL, 'RD 5', 'Rangiora', '7475', 'New Zealand', '', '', '0274359005', 'kmdrainage@hotmail.com', '0.0000', '0.0000', '0.0000', '8291.8600'
, NULL, '57 Bridge RD', NULL, NULL, NULL, 'RD 5', 'Rangiora', '7475', 'New Zealand', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '20000.0000', 1, 0, 0, 0, 0, 'Must have order number + name of person collecting'
, NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', 'AM', '', 'Kere Marshal
l Drainage Services Ltd', '0.00', 1, NULL, '', 0, NULL, '2023-09-29', 1, 'Drainage', 'Drainage Tier 2', NULL, NULL, 'Canterbury'),
(859, '1058', '1058', 0, 'C', 'Kevins Contractors', '', NULL, NULL, NULL, '', '', '', '', '0210508822', '', '0210508822', 'elaine_kevin@xtra.co.nz', '0.0000', '0.0000', '0.0000', '1921.6400', NULL, '302 Greers Road', NULL, NULL, NULL,
'Bishopdale', 'Christchurch', '8053', '', '1.7.22 Name changed from Kevins Contracting and Drainage and moved to Sandyford\r\n\r\n31.3.21 Wrote off outstanding balance as a bad debt\r\n\r\n24 September 2020\r\nTelephone contact with Ke
vin\r\nHe is very quiet at present. I have requested he looked to us for any drainage quoting we could proviide him with.\r\nI Will forward an updated staff Paramount Plumbing profile to him today.', '0.000000', '0.000000', NULL, NULL
, NULL, '', NULL, 'TaxableEx', '2000.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '000
0-00-00', '0000-00-00', '0000-00-00', 'NH', '', 'Kevins Contractors', '0.00', 1, NULL, '', 0, NULL, '2023-09-28', 4, 'Drainage', 'Drainage Tier 1', NULL, NULL, 'Canterbury'),
(860, '1059', '1059', 0, 'C', 'High Pressure Plumbing Ltd', '3/135 Johnson Road', NULL, NULL, NULL, 'RD 5', '', '7675', 'West Melton', '027-220-1818', '', '', 'andy.loretta@gmail.com', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '3/1
35 Johnson Road', NULL, NULL, NULL, 'RD 5', '', '7675', 'West Melton', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '0.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00'
, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', 'RO', '', 'High Pressure Plumbing Ltd', '0.00', 1, NULL, '', 0, NULL, '2022-02-03', 2, 'Plu
mber', 'Plumber Tier 1 - Secura', NULL, NULL, 'Canterbury'),
(861, '1060', '1060', 0, 'C', 'Linkup Plumbing', '120 Kippenburger Avenue', NULL, NULL, NULL, '', 'Rangiora', '', '', '', '', '0212755509', 'linkupplumbing@gmail.com', '0.0000', '0.0000', '0.0000', '38887.9600', NULL, '120 Kippenburger
Avenue', NULL, NULL, NULL, '', 'Rangiora', '', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '35000.0000', 1, 0, 0, 0, 0, 'Loyalty 5% Rebate', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '946321'
, '3833.56', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '2021-11-14', 'AM', '', 'Linkup Plumbing', '0.00', 1, NULL, '', 0, NULL, '2023-09-29', 1, 'Plu
mber', 'Plumber Tier 1 - Pex', NULL, NULL, 'Canterbury'),
(862, '1061', '1061', 0, 'C', 'M & H Contracting Ltd', '', NULL, NULL, NULL, '', '', '', '', '0272294022', '', '0272294022', 'mhcontractingltd@gmail.com', '0.0000', '0.0000', '0.0000', '2356.5000', NULL, '567 Mt Thomas Rd', NULL, NULL,
NULL, '', '', '', '', '', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '2500.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0,
0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', 'SH', '', 'M & H Contracting Ltd', '0.00', 1, NULL, '', 0, NULL, '2023-08-25', 1, 'Other', 'Drainage Tier 1', NULL, NULL, 'Canterbury'),
(863, '1062', '1062', 1, 'C', 'M J Drainage & Earthworks Ltd - Cash Acc', '205 Cones Road', NULL, NULL, NULL, '', '', '', 'Loburn', '', '', '027 3729007', 'Christy@mjde.co.nz', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '205 Cones R
oad', NULL, NULL, NULL, '', '', '', 'Loburn', 'M J Drainage CC\r\n4715 4030 0109 0244\r\nExp 09/24\r\ncsv 968', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '5000.0000', 1, 0, 0, 0, 0, 'Cash Sale only - review July
2022', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', 'JM', '', 'M J Dra
inage & Earthworks Ltd - Cash Acc', '0.00', 1, NULL, '', 0, NULL, '2023-04-24', 1, 'Drainage', 'Drainage Tier 1', NULL, NULL, 'Canterbury'),
(864, '1063', '1063', 0, 'C', 'Macefield Drainage', '139a Mandeville Road', NULL, NULL, NULL, '', '', '7692', 'Kaiapoi', '03 312 0560', '', '0274 363 712', 'jeff.macefield@gmail.com', '0.0000', '0.0000', '0.0000', '0.0000', NULL, '139a
Mandeville Road', NULL, NULL, NULL, '', '', '7692', 'Kaiapoi', '30.4.20 phoned, Jeff''s OK, gettting back on to unfinished jobs now, has confidence in his work streams traditional clients in residential homes and multi units at prese
nt. Expects itll be a few weeks before clear picture emerges but has a positive outlook. Down to 2 from 3 to cover contingencies. Concerned at how Fletchers (Humes) might respond to the market potentially impacting cashflows if trading
terms become restricted. He hasnt seen Humes or Hynds since lockdown. Updated our status at Rolly and Rangiora, will keep in touch. Probably a weekly phone call', '0.000000', '0.000000', NULL, NULL, NULL, '', NULL, 'TaxableEx', '10000
.0000', 1, 0, 0, 0, 0, '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00'
, 'SM', '', 'Macefield Drainage', '0.00', 1, NULL, '', 0, NULL, '2023-01-24', 4, 'Drainage', 'Drainage Tier 1', NULL, NULL, 'Canterbury'),
[/code]