-- MySQL dump 9.09 -- -- Host: localhost Database: erpzionitcom -- ------------------------------------------------------ -- Server version 4.0.16-nt -- -- -- Table structure for table `accountgroups` -- CREATE TABLE accountgroups ( GroupName char(30) NOT NULL default '', SectionInAccounts smallint(6) NOT NULL default '0', PandL tinyint(4) NOT NULL default '1', SequenceInTB smallint(6) NOT NULL default '0', PRIMARY KEY (GroupName), KEY SequenceInTB (SequenceInTB) ) TYPE=InnoDB; -- -- Dumping data for table `accountgroups` -- INSERT INTO accountgroups VALUES ('Current Assets',20,0,150); INSERT INTO accountgroups VALUES ('Current Liabilites',30,0,160); INSERT INTO accountgroups VALUES ('Equity',50,1,300); INSERT INTO accountgroups VALUES ('Materials & Supplies',2,1,10); INSERT INTO accountgroups VALUES ('sales',1,1,1); INSERT INTO accountgroups VALUES ('Selling Expenses',5,1,95); -- -- Table structure for table `areas` -- CREATE TABLE areas ( AreaCode char(2) NOT NULL default '', AreaDescription varchar(25) NOT NULL default '', PRIMARY KEY (AreaCode) ) TYPE=InnoDB; -- -- Dumping data for table `areas` -- INSERT INTO areas VALUES ('NL','Nederland'); -- -- Table structure for table `bankaccounts` -- CREATE TABLE bankaccounts ( AccountCode int(11) NOT NULL auto_increment, BankAccountName char(50) NOT NULL default '', BankAccountNumber char(50) NOT NULL default '', BankAddress char(50) default NULL, PRIMARY KEY (AccountCode), KEY BankAccountName (BankAccountName), KEY BankAccountNumber (BankAccountNumber), CONSTRAINT `0_1292` FOREIGN KEY (`AccountCode`) REFERENCES `chartmaster` (`AccountCode`) ) TYPE=InnoDB; -- -- Dumping data for table `bankaccounts` -- INSERT INTO bankaccounts VALUES (1012,'ABN AMRO DEPOSITO','58.78.12.060','Postbus 30, 3800 AA Amersfoort, The Netherlands'); INSERT INTO bankaccounts VALUES (1013,'ABN AMRO lopende rekening','57.52.72.066','Postbus 30, 3800 AA Amersfoort, The Netherlands'); -- -- Table structure for table `banktrans` -- CREATE TABLE banktrans ( BankTransID bigint(20) NOT NULL auto_increment, Type smallint(6) NOT NULL default '0', TransNo bigint(20) NOT NULL default '0', BankAct int(11) NOT NULL default '0', Ref varchar(50) NOT NULL default '', AmountCleared float NOT NULL default '0', ExRate double NOT NULL default '1', TransDate date NOT NULL default '0000-00-00', BankTransType varchar(30) NOT NULL default '', Amount float NOT NULL default '0', CurrCode char(3) NOT NULL default '', PRIMARY KEY (BankTransID), KEY BankAct (BankAct,Ref), KEY TransDate (TransDate), KEY TransType (BankTransType), KEY Type (Type,TransNo), KEY CurrCode (CurrCode), CONSTRAINT `0_1294` FOREIGN KEY (`BankAct`) REFERENCES `bankaccounts` (`AccountCode`), CONSTRAINT `0_1295` FOREIGN KEY (`Type`) REFERENCES `systypes` (`TypeID`) ) TYPE=InnoDB; -- -- Dumping data for table `banktrans` -- -- -- Table structure for table `bom` -- CREATE TABLE bom ( Parent char(20) NOT NULL default '', Component char(20) NOT NULL default '', WorkCentreAdded char(5) NOT NULL default '', LocCode char(5) NOT NULL default '', EffectiveAfter date NOT NULL default '0000-00-00', EffectiveTo date NOT NULL default '9999-12-31', Quantity double(16,4) NOT NULL default '1.0000', PRIMARY KEY (Parent,Component,WorkCentreAdded,LocCode), KEY Component (Component), KEY EffectiveAfter (EffectiveAfter), KEY EffectiveTo (EffectiveTo), KEY LocCode (LocCode), KEY Parent (Parent,EffectiveAfter,EffectiveTo,LocCode), KEY Parent_2 (Parent), KEY WorkCentreAdded (WorkCentreAdded), CONSTRAINT `0_1287` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`), CONSTRAINT `0_1288` FOREIGN KEY (`Parent`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1289` FOREIGN KEY (`Component`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1290` FOREIGN KEY (`WorkCentreAdded`) REFERENCES `workcentres` (`Code`) ) TYPE=InnoDB; -- -- Dumping data for table `bom` -- -- -- Table structure for table `buckets` -- CREATE TABLE buckets ( WorkCentre char(5) NOT NULL default '', AvailDate datetime NOT NULL default '0000-00-00 00:00:00', Capacity float(10,2) NOT NULL default '0.00', PRIMARY KEY (WorkCentre,AvailDate), KEY WorkCentre (WorkCentre), KEY AvailDate (AvailDate), CONSTRAINT `0_1297` FOREIGN KEY (`WorkCentre`) REFERENCES `workcentres` (`Code`) ) TYPE=InnoDB; -- -- Dumping data for table `buckets` -- -- -- Table structure for table `chartdetails` -- CREATE TABLE chartdetails ( AccountCode int(11) NOT NULL default '0', Period smallint(6) NOT NULL default '0', Budget float NOT NULL default '0', Actual float NOT NULL default '0', BFwd float NOT NULL default '0', BFwdBudget float NOT NULL default '0', PRIMARY KEY (AccountCode,Period), KEY Period (Period), CONSTRAINT `0_1300` FOREIGN KEY (`Period`) REFERENCES `periods` (`PeriodNo`), CONSTRAINT `0_1301` FOREIGN KEY (`AccountCode`) REFERENCES `chartmaster` (`AccountCode`) ) TYPE=InnoDB; -- -- Dumping data for table `chartdetails` -- INSERT INTO chartdetails VALUES (1012,51,0,148.155,0,0); INSERT INTO chartdetails VALUES (1012,52,0,-148.155,148.155,0); INSERT INTO chartdetails VALUES (1013,51,0,0,0,0); INSERT INTO chartdetails VALUES (1013,52,0,249.305,0,0); INSERT INTO chartdetails VALUES (1300,37,0,0,0,0); INSERT INTO chartdetails VALUES (1300,38,0,0,0,0); INSERT INTO chartdetails VALUES (1300,39,0,0,0,0); INSERT INTO chartdetails VALUES (1300,40,0,0,0,0); INSERT INTO chartdetails VALUES (1300,41,0,0,0,0); INSERT INTO chartdetails VALUES (1300,42,0,0,0,0); INSERT INTO chartdetails VALUES (1300,43,0,0,0,0); INSERT INTO chartdetails VALUES (1300,44,0,0,0,0); INSERT INTO chartdetails VALUES (1300,45,0,0,0,0); INSERT INTO chartdetails VALUES (1300,46,0,0,0,0); INSERT INTO chartdetails VALUES (1300,47,0,0,0,0); INSERT INTO chartdetails VALUES (1300,48,0,0,0,0); INSERT INTO chartdetails VALUES (1300,49,0,0,0,0); INSERT INTO chartdetails VALUES (1300,50,0,0,0,0); INSERT INTO chartdetails VALUES (1300,51,0,0,0,0); INSERT INTO chartdetails VALUES (1300,52,0,0,0,0); INSERT INTO chartdetails VALUES (1300,53,0,0,0,0); INSERT INTO chartdetails VALUES (1300,54,0,0,0,0); INSERT INTO chartdetails VALUES (1300,55,0,0,0,0); INSERT INTO chartdetails VALUES (1300,56,0,0,0,0); INSERT INTO chartdetails VALUES (1300,57,0,0,0,0); INSERT INTO chartdetails VALUES (1300,58,0,0,0,0); INSERT INTO chartdetails VALUES (1300,59,0,0,0,0); INSERT INTO chartdetails VALUES (1300,60,0,0,0,0); INSERT INTO chartdetails VALUES (1300,61,0,0,0,0); INSERT INTO chartdetails VALUES (1300,62,0,0,0,0); INSERT INTO chartdetails VALUES (1300,63,0,0,0,0); INSERT INTO chartdetails VALUES (1300,64,0,0,0,0); INSERT INTO chartdetails VALUES (1300,65,0,0,0,0); INSERT INTO chartdetails VALUES (1300,66,0,0,0,0); INSERT INTO chartdetails VALUES (1300,67,0,0,0,0); INSERT INTO chartdetails VALUES (1300,68,0,0,0,0); INSERT INTO chartdetails VALUES (1301,51,0,0,0,0); INSERT INTO chartdetails VALUES (1301,52,0,0,0,0); INSERT INTO chartdetails VALUES (1600,51,0,0,0,0); INSERT INTO chartdetails VALUES (1600,52,0,0,0,0); INSERT INTO chartdetails VALUES (1815,51,0,0,0,0); INSERT INTO chartdetails VALUES (1815,52,0,0,0,0); INSERT INTO chartdetails VALUES (1816,51,0,-23.655,0,0); INSERT INTO chartdetails VALUES (1816,52,0,-16.15,-23.655,0); INSERT INTO chartdetails VALUES (1900,51,0,0,0,0); INSERT INTO chartdetails VALUES (1900,52,0,0,0,0); INSERT INTO chartdetails VALUES (7000,51,0,0,0,0); INSERT INTO chartdetails VALUES (7000,52,0,0,0,0); INSERT INTO chartdetails VALUES (7090,51,0,0,0,0); INSERT INTO chartdetails VALUES (7090,52,0,0,0,0); INSERT INTO chartdetails VALUES (7098,51,0,0,0,0); INSERT INTO chartdetails VALUES (7098,52,0,0,0,0); INSERT INTO chartdetails VALUES (8000,51,0,-124.5,0,0); INSERT INTO chartdetails VALUES (8000,52,0,-85,-124.5,0); INSERT INTO chartdetails VALUES (8010,51,0,0,0,0); INSERT INTO chartdetails VALUES (8010,52,0,0,0,0); INSERT INTO chartdetails VALUES (8020,51,0,0,0,0); INSERT INTO chartdetails VALUES (8020,52,0,0,0,0); INSERT INTO chartdetails VALUES (8098,51,0,0,0,0); INSERT INTO chartdetails VALUES (8098,52,0,0,0,0); -- -- Table structure for table `chartmaster` -- CREATE TABLE chartmaster ( AccountCode int(11) NOT NULL default '0', AccountName char(50) NOT NULL default '', Group_ char(30) NOT NULL default '', PRIMARY KEY (AccountCode), KEY AccountCode (AccountCode), KEY AccountName (AccountName), KEY Group_ (Group_), CONSTRAINT `0_1303` FOREIGN KEY (`Group_`) REFERENCES `accountgroups` (`GroupName`) ) TYPE=InnoDB; -- -- Dumping data for table `chartmaster` -- INSERT INTO chartmaster VALUES (1012,'ABN AMRO DEPOSITO','Current Assets'); INSERT INTO chartmaster VALUES (1013,'ABN AMRO lopende rekening','Current Assets'); INSERT INTO chartmaster VALUES (1300,'Debiteuren','Current Assets'); INSERT INTO chartmaster VALUES (1301,'Debiteuren','Equity'); INSERT INTO chartmaster VALUES (1600,'Crediteuren','Current Assets'); INSERT INTO chartmaster VALUES (1815,'BTW voordruk (terug te vragen btw)','Equity'); INSERT INTO chartmaster VALUES (1816,'BTW afdrachten (te betalen gefaktureerde btw)','Equity'); INSERT INTO chartmaster VALUES (1900,'Netto Lonen','Equity'); INSERT INTO chartmaster VALUES (7000,'Inkopen','Equity'); INSERT INTO chartmaster VALUES (7090,'Mutatie voorraad','Current Assets'); INSERT INTO chartmaster VALUES (7098,'Inkopen Kortingen/bet. verschillen','Equity'); INSERT INTO chartmaster VALUES (8000,'Omzet hoog','sales'); INSERT INTO chartmaster VALUES (8010,'Omzet laag','sales'); INSERT INTO chartmaster VALUES (8020,'Omzet buitenland','sales'); INSERT INTO chartmaster VALUES (8030,'Inkoopwaarde van de verkopen','sales'); INSERT INTO chartmaster VALUES (8098,'Verkoop Kortingen/bet.verschillen','sales'); -- -- Table structure for table `cogsglpostings` -- CREATE TABLE cogsglpostings ( ID int(11) NOT NULL auto_increment, Area char(2) NOT NULL default '', StkCat varchar(6) NOT NULL default '', GLCode int(11) NOT NULL default '0', SalesType char(2) NOT NULL default 'AN', PRIMARY KEY (ID), UNIQUE KEY Area_StkCat (Area,StkCat,SalesType), KEY Area (Area), KEY StkCat (StkCat), KEY GLCode (GLCode), KEY SalesType (SalesType) ) TYPE=InnoDB; -- -- Dumping data for table `cogsglpostings` -- -- -- Table structure for table `companies` -- CREATE TABLE companies ( CoyCode int(11) NOT NULL default '1', CoyName varchar(50) NOT NULL default '', GSTNo varchar(20) NOT NULL default '', CompanyNumber varchar(20) NOT NULL default '0', PostalAddress varchar(50) NOT NULL default '', RegOffice1 varchar(50) NOT NULL default '', RegOffice2 varchar(50) NOT NULL default '', RegOffice3 varchar(50) NOT NULL default '', Telephone varchar(25) NOT NULL default '', Fax varchar(25) NOT NULL default '', Email varchar(55) NOT NULL default '', CurrencyDefault varchar(4) NOT NULL default '', DebtorsAct int(11) NOT NULL default '70000', PytDiscountAct int(11) NOT NULL default '55000', CreditorsAct int(11) NOT NULL default '80000', PayrollAct int(11) NOT NULL default '84000', GRNAct int(11) NOT NULL default '72000', ExchangeDiffAct int(11) NOT NULL default '65000', PurchasesExchangeDiffAct int(11) NOT NULL default '0', RetainedEarnings int(11) NOT NULL default '90000', GLLink_Debtors tinyint(1) default '1', GLLink_Creditors tinyint(1) default '1', GLLink_Stock tinyint(1) default '1', FreightAct int(11) NOT NULL default '0', PRIMARY KEY (CoyCode) ) TYPE=InnoDB; -- -- Dumping data for table `companies` -- INSERT INTO companies VALUES (1,'Zion-IT b.v.','NL808988372B01','kvk 32080547','Postbus 28048, 3828 ZG Hoogland, The Netherlands','loefzijde 38, 3823 TD, Amersfoort, The Netherlands','Bank: ABN-AMRO Branche: Amersfoort, Netherlands','Account name: Zion-IT b.v. Accountnr: 57.52.72.066','+31 (0) 33 455 1334','+31 (0) 84 864 9395','Admin@Zion-IT.com Website: www.Zion-IT.com','EUR',1300,7098,1600,1013,7090,8098,7098,1013,1,1,0,8000); -- -- Table structure for table `contractbom` -- CREATE TABLE contractbom ( ContractRef char(20) NOT NULL default '', Component char(20) NOT NULL default '', WorkCentreAdded char(5) NOT NULL default '', LocCode char(5) NOT NULL default '', Quantity double(16,4) NOT NULL default '1.0000', PRIMARY KEY (ContractRef,Component,WorkCentreAdded,LocCode), KEY Component (Component), KEY LocCode (LocCode), KEY ContractRef (ContractRef), KEY WorkCentreAdded (WorkCentreAdded), KEY WorkCentreAdded_2 (WorkCentreAdded), CONSTRAINT `0_1306` FOREIGN KEY (`Component`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1307` FOREIGN KEY (`WorkCentreAdded`) REFERENCES `workcentres` (`Code`), CONSTRAINT `0_1308` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `contractbom` -- -- -- Table structure for table `contractreqts` -- CREATE TABLE contractreqts ( ContractReqID int(11) NOT NULL auto_increment, Contract char(20) NOT NULL default '', Component char(40) NOT NULL default '', Quantity double(16,4) NOT NULL default '1.0000', PricePerUnit decimal(20,4) NOT NULL default '0.0000', PRIMARY KEY (ContractReqID), KEY Contract (Contract), CONSTRAINT `0_1310` FOREIGN KEY (`Contract`) REFERENCES `contracts` (`ContractRef`) ) TYPE=InnoDB; -- -- Dumping data for table `contractreqts` -- -- -- Table structure for table `contracts` -- CREATE TABLE contracts ( ContractRef varchar(20) NOT NULL default '', ContractDescription varchar(50) NOT NULL default '', DebtorNo varchar(10) NOT NULL default '', BranchCode varchar(10) NOT NULL default '', Status varchar(10) NOT NULL default 'Quotation', CategoryID varchar(6) NOT NULL default '', TypeAbbrev char(2) NOT NULL default '', OrderNo int(11) NOT NULL default '0', QuotedPriceFX decimal(20,4) NOT NULL default '0.0000', Margin double(16,4) NOT NULL default '1.0000', WORef varchar(20) NOT NULL default '', RequiredDate datetime NOT NULL default '0000-00-00 00:00:00', CancelDate datetime NOT NULL default '0000-00-00 00:00:00', QuantityReqd double(16,4) NOT NULL default '1.0000', Specifications longblob NOT NULL, DateQuoted datetime NOT NULL default '0000-00-00 00:00:00', Units varchar(15) NOT NULL default 'Each', Drawing longblob NOT NULL, Rate double(16,4) NOT NULL default '1.0000', PRIMARY KEY (ContractRef), KEY OrderNo (OrderNo), KEY CategoryID (CategoryID), KEY Status (Status), KEY TypeAbbrev (TypeAbbrev), KEY WORef (WORef), KEY DebtorNo (DebtorNo,BranchCode), CONSTRAINT `0_1312` FOREIGN KEY (`TypeAbbrev`) REFERENCES `salestypes` (`TypeAbbrev`), CONSTRAINT `0_1313` FOREIGN KEY (`DebtorNo`, `BranchCode`) REFERENCES `custbranch` (`DebtorNo`, `BranchCode`), CONSTRAINT `0_1314` FOREIGN KEY (`CategoryID`) REFERENCES `stockcategory` (`CategoryID`) ) TYPE=InnoDB; -- -- Dumping data for table `contracts` -- -- -- Table structure for table `currencies` -- CREATE TABLE currencies ( Currency char(20) NOT NULL default '', CurrAbrev char(3) NOT NULL default '', Country char(50) NOT NULL default '', HundredsName char(15) NOT NULL default 'Cents', Rate double(16,4) NOT NULL default '1.0000', PRIMARY KEY (CurrAbrev), KEY Country (Country) ) TYPE=InnoDB; -- -- Dumping data for table `currencies` -- INSERT INTO currencies VALUES ('Euro','EUR','Several European Countries','cent',1.0000); INSERT INTO currencies VALUES ('US Dollars','USD','United States','Cents',1.2300); -- -- Table structure for table `custallocns` -- CREATE TABLE custallocns ( ID int(11) NOT NULL auto_increment, Amt decimal(20,4) NOT NULL default '0.0000', DateAlloc date NOT NULL default '0000-00-00', TransID_AllocFrom int(11) NOT NULL default '0', TransID_AllocTo int(11) NOT NULL default '0', PRIMARY KEY (ID), KEY DateAlloc (DateAlloc), KEY TransID_AllocFrom (TransID_AllocFrom), KEY TransID_AllocTo (TransID_AllocTo), CONSTRAINT `0_1317` FOREIGN KEY (`TransID_AllocTo`) REFERENCES `debtortrans` (`ID`), CONSTRAINT `0_1318` FOREIGN KEY (`TransID_AllocFrom`) REFERENCES `debtortrans` (`ID`) ) TYPE=InnoDB; -- -- Dumping data for table `custallocns` -- INSERT INTO custallocns VALUES (1,148.1550,'2004-04-01',13,12); -- -- Table structure for table `custbranch` -- CREATE TABLE custbranch ( BranchCode varchar(10) NOT NULL default '', DebtorNo varchar(10) NOT NULL default '', BrName varchar(40) NOT NULL default '', BrAddress1 varchar(40) NOT NULL default '', BrAddress2 varchar(40) NOT NULL default '', BrAddress3 varchar(40) NOT NULL default '', BrAddress4 varchar(50) NOT NULL default '', EstDeliveryDays smallint(6) NOT NULL default '1', Area char(2) NOT NULL default '', Salesman varchar(4) NOT NULL default '', FwdDate smallint(6) NOT NULL default '0', PhoneNo varchar(20) NOT NULL default '', FaxNo varchar(20) NOT NULL default '', ContactName varchar(30) NOT NULL default '', Email varchar(55) NOT NULL default '', DefaultLocation varchar(5) NOT NULL default '', TaxAuthority tinyint(4) NOT NULL default '1', DefaultShipVia int(11) NOT NULL default '1', DisableTrans tinyint(4) NOT NULL default '0', BrPostAddr1 varchar(40) NOT NULL default '', BrPostAddr2 varchar(40) NOT NULL default '', BrPostAddr3 varchar(30) NOT NULL default '', BrPostAddr4 varchar(20) NOT NULL default '', CustBranchCode varchar(30) NOT NULL default '', PRIMARY KEY (BranchCode,DebtorNo), KEY BranchCode (BranchCode), KEY BrName (BrName), KEY DebtorNo (DebtorNo), KEY Salesman (Salesman), KEY Area (Area), KEY Area_2 (Area), KEY DefaultLocation (DefaultLocation), KEY TaxAuthority (TaxAuthority), KEY DefaultShipVia (DefaultShipVia), CONSTRAINT `0_1320` FOREIGN KEY (`DefaultShipVia`) REFERENCES `shippers` (`Shipper_ID`), CONSTRAINT `0_1321` FOREIGN KEY (`DebtorNo`) REFERENCES `debtorsmaster` (`DebtorNo`), CONSTRAINT `0_1322` FOREIGN KEY (`Area`) REFERENCES `areas` (`AreaCode`), CONSTRAINT `0_1323` FOREIGN KEY (`Salesman`) REFERENCES `salesman` (`SalesmanCode`), CONSTRAINT `0_1324` FOREIGN KEY (`DefaultLocation`) REFERENCES `locations` (`LocCode`), CONSTRAINT `0_1325` FOREIGN KEY (`TaxAuthority`) REFERENCES `taxauthorities` (`TaxID`) ) TYPE=InnoDB; -- -- Dumping data for table `custbranch` -- INSERT INTO custbranch VALUES ('DAP','DAP','Dierenartsenpraktijk Groesbeek e.o.','Heumensebaan 23','6561 CJ','Groesbeek','Nederland',1,'NL','DRS',0,'','','drs. P.G. Stins','','AM',0,10,0,'','','','',''); INSERT INTO custbranch VALUES ('SMS','SMS','SportsMarketingServices','Erve Geusendam 37','7463 CS','Rijssen','The Netherlands',1,'NL','DRS',0,'+31 (0) 548-543590','+31 (0) 548-543590','Iwan Spekenbrink/Marloes Poelm','DRStins@Zion-IT.com','USAS',0,10,0,'','','','',''); -- -- Table structure for table `debtorsmaster` -- CREATE TABLE debtorsmaster ( DebtorNo varchar(10) NOT NULL default '', Name varchar(40) NOT NULL default '', Address1 varchar(40) NOT NULL default '', Address2 varchar(40) NOT NULL default '', Address3 varchar(40) NOT NULL default '', Address4 varchar(50) NOT NULL default '', CurrCode char(3) NOT NULL default '', SalesType char(2) NOT NULL default '', ClientSince datetime NOT NULL default '0000-00-00 00:00:00', HoldReason smallint(6) NOT NULL default '0', PaymentTerms char(2) NOT NULL default 'f', Discount double(16,4) NOT NULL default '0.0000', PymtDiscount double(16,4) NOT NULL default '0.0000', LastPaid double(16,4) NOT NULL default '0.0000', LastPaidDate datetime default NULL, CreditLimit float NOT NULL default '1000', InvAddrBranch tinyint(4) NOT NULL default '0', DiscountCode char(2) NOT NULL default '', EDIInvoices tinyint(4) NOT NULL default '0', EDIOrders tinyint(4) NOT NULL default '0', EDIReference varchar(20) NOT NULL default '', EDITransport varchar(5) NOT NULL default 'email', EDIAddress varchar(50) NOT NULL default '', EDIServerUser varchar(20) NOT NULL default '', EDIServerPwd varchar(20) NOT NULL default '', PRIMARY KEY (DebtorNo), KEY Currency (CurrCode), KEY HoldReason (HoldReason), KEY Name (Name), KEY PaymentTerms (PaymentTerms), KEY SalesType (SalesType), KEY EDIInvoices (EDIInvoices), KEY EDIOrders (EDIOrders), CONSTRAINT `0_1331` FOREIGN KEY (`SalesType`) REFERENCES `salestypes` (`TypeAbbrev`), CONSTRAINT `0_1332` FOREIGN KEY (`HoldReason`) REFERENCES `holdreasons` (`ReasonCode`), CONSTRAINT `0_1333` FOREIGN KEY (`CurrCode`) REFERENCES `currencies` (`CurrAbrev`), CONSTRAINT `0_1334` FOREIGN KEY (`PaymentTerms`) REFERENCES `paymentterms` (`TermsIndicator`) ) TYPE=InnoDB; -- -- Dumping data for table `debtorsmaster` -- INSERT INTO debtorsmaster VALUES ('DAP','Dierenartsenpraktijk Groesbeek e.o.','Heumensebaan 23','6561 CJ','Groesbeek','Nederland','EUR','HO','2003-10-30 00:00:00',1,'14',0.0000,0.0000,0.0000,NULL,1000,0,'',0,0,'','email','','',''); INSERT INTO debtorsmaster VALUES ('SMS','SportsMarketingServices','Erve Geusendam 37','7463 CS','Rijssen','The Netherlands','EUR','HO','2004-02-14 00:00:00',1,'14',0.0000,0.0000,0.0000,NULL,1000,0,'',0,0,'','email','','',''); -- -- Table structure for table `debtortrans` -- CREATE TABLE debtortrans ( ID int(11) NOT NULL auto_increment, TransNo int(11) NOT NULL default '0', Type smallint(6) NOT NULL default '0', DebtorNo varchar(10) NOT NULL default '', BranchCode varchar(10) NOT NULL default '', TranDate datetime NOT NULL default '0000-00-00 00:00:00', Prd smallint(6) NOT NULL default '0', Settled tinyint(4) NOT NULL default '0', Reference varchar(20) NOT NULL default '', Tpe char(2) NOT NULL default '', Order_ int(11) NOT NULL default '0', Rate double(16,6) NOT NULL default '0.000000', OvAmount float NOT NULL default '0', OvGST float NOT NULL default '0', OvFreight float NOT NULL default '0', OvDiscount float NOT NULL default '0', DiffOnExch float NOT NULL default '0', Alloc float NOT NULL default '0', InvText text, ShipVia varchar(10) NOT NULL default '', EDISent tinyint(4) NOT NULL default '0', PRIMARY KEY (ID), KEY DebtorNo (DebtorNo,BranchCode), KEY Order_ (Order_), KEY Prd (Prd), KEY Tpe (Tpe), KEY Type (Type), KEY Settled (Settled), KEY TranDate (TranDate), KEY TransNo (TransNo), KEY Type_2 (Type,TransNo), KEY EDISent (EDISent), CONSTRAINT `0_1327` FOREIGN KEY (`Prd`) REFERENCES `periods` (`PeriodNo`), CONSTRAINT `0_1328` FOREIGN KEY (`DebtorNo`) REFERENCES `custbranch` (`DebtorNo`), CONSTRAINT `0_1329` FOREIGN KEY (`Type`) REFERENCES `systypes` (`TypeID`) ) TYPE=InnoDB; -- -- Dumping data for table `debtortrans` -- INSERT INTO debtortrans VALUES (12,27,10,'SMS','SMS','2004-03-15 00:00:00',51,1,'','HO',1,1.000000,124.5,23.655,0,0,0,148.155,'Periode 1 jaar met als ingangsdatum contractdatum.\r\nElf maanden fakturen voor eerste jaar.\r\nVijf extra domeinen: \r\n11 * 5 = 55 - 2 extra maanden korting ivm later registratie = 53\r\n','10',0); INSERT INTO debtortrans VALUES (13,12,11,'SMS','SMS','2004-04-01 00:00:00',52,1,'','HO',0,1.000000,-124.5,-23.655,0,0,0,-148.155,'foute aangemaakte order. Order/faktuur wordt opnieuw aangemaakt.','',0); INSERT INTO debtortrans VALUES (14,28,10,'SMS','SMS','2004-04-02 00:00:00',52,0,'','HO',2,1.000000,138,26.22,0,0,0,0,'Alle betalingen zijn al ontvangen.\r\nVoor details verwijs ik u naar het contract 0402-1a\r\n(a=wijzigingscode).\r\nConform afspraak is twaalf maanden gefaktureerd ivm extra service voor Tiscali probleempjes.','10',0); INSERT INTO debtortrans VALUES (15,29,10,'DAP','DAP','2004-04-10 00:00:00',52,0,'','HO',3,1.000000,71.5,13.585,0,0,0,0,'Internet hosting www.dapgroesbeek.nl. Periode 30-10-2003 tot 30-10-2004','10',0); -- -- Table structure for table `discountmatrix` -- CREATE TABLE discountmatrix ( SalesType char(2) NOT NULL default '', DiscountCategory char(2) NOT NULL default '', QuantityBreak int(11) NOT NULL default '1', DiscountRate double(16,4) NOT NULL default '0.0000', PRIMARY KEY (SalesType,DiscountCategory,QuantityBreak), KEY QuantityBreak (QuantityBreak), KEY DiscountCategory (DiscountCategory), KEY SalesType (SalesType), CONSTRAINT `0_1336` FOREIGN KEY (`SalesType`) REFERENCES `salestypes` (`TypeAbbrev`) ) TYPE=InnoDB; -- -- Dumping data for table `discountmatrix` -- -- -- Table structure for table `ediitemmapping` -- CREATE TABLE ediitemmapping ( SuppOrCust varchar(4) NOT NULL default '', PartnerCode varchar(10) NOT NULL default '', StockID varchar(20) NOT NULL default '', PartnerStockID varchar(50) NOT NULL default '', PRIMARY KEY (SuppOrCust,PartnerCode,StockID), KEY PartnerCode (PartnerCode), KEY StockID (StockID), KEY PartnerStockID (PartnerStockID), KEY SuppOrCust (SuppOrCust) ) TYPE=InnoDB; -- -- Dumping data for table `ediitemmapping` -- -- -- Table structure for table `edimessageformat` -- CREATE TABLE edimessageformat ( ID int(11) NOT NULL auto_increment, PartnerCode varchar(10) NOT NULL default '', MessageType varchar(6) NOT NULL default '', Section varchar(7) NOT NULL default '', SequenceNo int(11) NOT NULL default '0', LineText varchar(70) NOT NULL default '', PRIMARY KEY (ID), UNIQUE KEY PartnerCode (PartnerCode,MessageType,SequenceNo), KEY Section (Section) ) TYPE=InnoDB; -- -- Dumping data for table `edimessageformat` -- -- -- Table structure for table `freightcosts` -- CREATE TABLE freightcosts ( ShipCostFromID int(11) NOT NULL auto_increment, LocationFrom varchar(5) NOT NULL default '', Destination varchar(40) NOT NULL default '', ShipperID int(11) NOT NULL default '0', CubRate double(16,2) NOT NULL default '0.00', KGRate double(16,2) NOT NULL default '0.00', MAXKGs double(16,2) NOT NULL default '999999.00', MAXCub double(16,2) NOT NULL default '999999.00', FixedPrice double(16,2) NOT NULL default '0.00', MinimumChg double(16,2) NOT NULL default '0.00', PRIMARY KEY (ShipCostFromID), KEY Destination (Destination), KEY LocationFrom (LocationFrom), KEY ShipperID (ShipperID), KEY Destination_2 (Destination,LocationFrom,ShipperID), CONSTRAINT `0_1340` FOREIGN KEY (`ShipperID`) REFERENCES `shippers` (`Shipper_ID`), CONSTRAINT `0_1341` FOREIGN KEY (`LocationFrom`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `freightcosts` -- -- -- Table structure for table `gltrans` -- CREATE TABLE gltrans ( CounterIndex int(11) NOT NULL auto_increment, Type smallint(6) NOT NULL default '0', TypeNo bigint(16) NOT NULL default '1', ChequeNo int(11) NOT NULL default '0', TranDate date NOT NULL default '0000-00-00', PeriodNo smallint(6) NOT NULL default '0', Account int(11) NOT NULL default '0', Narrative varchar(200) NOT NULL default '', Amount float NOT NULL default '0', Posted tinyint(4) NOT NULL default '0', JobRef varchar(20) NOT NULL default '', PRIMARY KEY (CounterIndex), KEY Account (Account), KEY ChequeNo (ChequeNo), KEY PeriodNo (PeriodNo), KEY Posted (Posted), KEY TranDate (TranDate), KEY TypeNo (TypeNo), KEY Type_and_Number (Type,TypeNo), KEY JobRef (JobRef), CONSTRAINT `0_1343` FOREIGN KEY (`PeriodNo`) REFERENCES `periods` (`PeriodNo`), CONSTRAINT `0_1344` FOREIGN KEY (`Account`) REFERENCES `chartmaster` (`AccountCode`), CONSTRAINT `0_1345` FOREIGN KEY (`Type`) REFERENCES `systypes` (`TypeID`) ) TYPE=InnoDB; -- -- Dumping data for table `gltrans` -- INSERT INTO gltrans VALUES (1,10,27,0,'2004-03-15',51,8000,'SMS - HBUS x 11 @ 6.5000',-71.5,1,''); INSERT INTO gltrans VALUES (2,10,27,0,'2004-03-15',51,8000,'SMS - HDOM x 53 @ 1.0000',-53,1,''); INSERT INTO gltrans VALUES (3,10,27,0,'2004-03-15',51,1012,'SMS',148.155,1,''); INSERT INTO gltrans VALUES (4,10,27,0,'2004-03-15',51,1816,'SMS',-23.655,1,''); INSERT INTO gltrans VALUES (5,11,12,0,'2004-04-01',52,8000,'SMS - hbus x 11 @ 6.5000',71.5,1,''); INSERT INTO gltrans VALUES (6,11,12,0,'2004-04-01',52,8000,'SMS - hdom x 53 @ 1.0000',53,1,''); INSERT INTO gltrans VALUES (7,11,12,0,'2004-04-01',52,1012,'SMS',-148.155,1,''); INSERT INTO gltrans VALUES (8,11,12,0,'2004-04-01',52,1816,'SMS',23.655,1,''); INSERT INTO gltrans VALUES (9,10,28,0,'2004-04-02',52,8000,'SMS - HBUS x 12 @ 6.5000',-78,1,''); INSERT INTO gltrans VALUES (10,10,28,0,'2004-04-02',52,8000,'SMS - HDOM x 60 @ 1.0000',-60,1,''); INSERT INTO gltrans VALUES (11,10,28,0,'2004-04-02',52,1013,'SMS',164.22,1,''); INSERT INTO gltrans VALUES (12,10,28,0,'2004-04-02',52,1816,'SMS',-26.22,1,''); INSERT INTO gltrans VALUES (13,10,29,0,'2004-04-10',52,8000,'DAP - HBUS x 11 @ 6.5000',-71.5,1,''); INSERT INTO gltrans VALUES (14,10,29,0,'2004-04-10',52,1013,'DAP',85.085,1,''); INSERT INTO gltrans VALUES (15,10,29,0,'2004-04-10',52,1816,'DAP',-13.585,1,''); -- -- Table structure for table `grns` -- CREATE TABLE grns ( GRNBatch smallint(6) NOT NULL default '0', GRNNo int(11) NOT NULL auto_increment, PODetailItem int(11) NOT NULL default '0', ItemCode varchar(20) NOT NULL default '', DeliveryDate date NOT NULL default '0000-00-00', ItemDescription varchar(100) NOT NULL default '', QtyRecd double(16,4) NOT NULL default '0.0000', QuantityInv double(16,4) NOT NULL default '0.0000', SupplierID varchar(10) NOT NULL default '', PRIMARY KEY (GRNNo), KEY DeliveryDate (DeliveryDate), KEY ItemCode (ItemCode), KEY PODetailItem (PODetailItem), KEY SupplierID (SupplierID), CONSTRAINT `0_1347` FOREIGN KEY (`PODetailItem`) REFERENCES `purchorderdetails` (`PODetailItem`), CONSTRAINT `0_1348` FOREIGN KEY (`SupplierID`) REFERENCES `suppliers` (`SupplierID`) ) TYPE=InnoDB; -- -- Dumping data for table `grns` -- -- -- Table structure for table `holdreasons` -- CREATE TABLE holdreasons ( ReasonCode smallint(6) NOT NULL default '1', ReasonDescription char(30) NOT NULL default '', DissallowInvoices tinyint(4) NOT NULL default '-1', PRIMARY KEY (ReasonCode), KEY ReasonCode (ReasonCode), KEY ReasonDescription (ReasonDescription) ) TYPE=InnoDB; -- -- Dumping data for table `holdreasons` -- INSERT INTO holdreasons VALUES (1,'Good History',0); INSERT INTO holdreasons VALUES (10,'Refresh Credit Check',0); INSERT INTO holdreasons VALUES (20,'Watch',0); INSERT INTO holdreasons VALUES (30,'No more work until payment rec',1); INSERT INTO holdreasons VALUES (51,'In liquidation',1); -- -- Table structure for table `lastcostrollup` -- CREATE TABLE lastcostrollup ( StockID char(20) NOT NULL default '', TotalOnHand double(16,4) NOT NULL default '0.0000', MatCost decimal(20,4) NOT NULL default '0.0000', LabCost decimal(20,4) NOT NULL default '0.0000', OheadCost decimal(20,4) NOT NULL default '0.0000', CategoryID char(6) NOT NULL default '', StockAct int(11) NOT NULL default '0', AdjGLAct int(11) NOT NULL default '0', NewMatCost decimal(20,4) NOT NULL default '0.0000', NewLabCost decimal(20,4) NOT NULL default '0.0000', NewOheadCost decimal(20,4) NOT NULL default '0.0000' ) TYPE=InnoDB; -- -- Dumping data for table `lastcostrollup` -- -- -- Table structure for table `locations` -- CREATE TABLE locations ( LocCode varchar(5) NOT NULL default '', LocationName varchar(50) NOT NULL default '', DelAdd1 varchar(40) NOT NULL default '', DelAdd2 varchar(40) NOT NULL default '', DelAdd3 varchar(40) NOT NULL default '', Tel varchar(30) NOT NULL default '', Fax varchar(30) NOT NULL default '', Email varchar(55) NOT NULL default '', Contact varchar(30) NOT NULL default '', TaxAuthority tinyint(4) NOT NULL default '1', PRIMARY KEY (LocCode) ) TYPE=InnoDB; -- -- Dumping data for table `locations` -- INSERT INTO locations VALUES ('AM','Amersfoort Netherlands','Loefzijde 38','3823TD','Amersfoort','+31 (0) 33 455 1334','+31 (0) 84 864 9395','Amersfoort@Zion-IT.com','Dick Stins',0); INSERT INTO locations VALUES ('USAS','USA hosting Servers','Loefzijde 38','3828 ZG','Amersfoort','+31 (0) 33 4551334','+31 (0) 84 864 93 95','hostadmin@Zion-IT.com','Dick Stins',2); -- -- Table structure for table `locstock` -- CREATE TABLE locstock ( LocCode char(5) NOT NULL default '', StockID char(20) NOT NULL default '', Quantity double(16,1) NOT NULL default '0.0', ReorderLevel bigint(20) NOT NULL default '0', PRIMARY KEY (LocCode,StockID), KEY StockID (StockID), CONSTRAINT `0_1352` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1353` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `locstock` -- INSERT INTO locstock VALUES ('AM','HBUS',0.0,0); INSERT INTO locstock VALUES ('AM','HDOM',0.0,0); INSERT INTO locstock VALUES ('AM','HDOMFREE',0.0,0); INSERT INTO locstock VALUES ('USAS','HBUS',0.0,0); INSERT INTO locstock VALUES ('USAS','HDOM',0.0,0); INSERT INTO locstock VALUES ('USAS','HDOMFREE',0.0,0); -- -- Table structure for table `orderdeliverydifferenceslog` -- CREATE TABLE orderdeliverydifferenceslog ( OrderNo int(11) NOT NULL default '0', InvoiceNo int(11) NOT NULL default '0', StockID varchar(20) NOT NULL default '', QuantityDiff double(16,4) NOT NULL default '0.0000', DebtorNo varchar(10) NOT NULL default '', Branch varchar(10) NOT NULL default '', Can_or_BO char(3) NOT NULL default 'CAN', PRIMARY KEY (OrderNo,InvoiceNo,StockID), KEY StockID (StockID), KEY DebtorNo (DebtorNo,Branch), KEY Can_or_BO (Can_or_BO), KEY OrderNo (OrderNo), CONSTRAINT `0_1356` FOREIGN KEY (`OrderNo`) REFERENCES `salesorders` (`OrderNo`), CONSTRAINT `0_1357` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1358` FOREIGN KEY (`DebtorNo`, `Branch`) REFERENCES `custbranch` (`DebtorNo`, `BranchCode`) ) TYPE=InnoDB; -- -- Dumping data for table `orderdeliverydifferenceslog` -- -- -- Table structure for table `paymentterms` -- CREATE TABLE paymentterms ( TermsIndicator char(2) NOT NULL default '', Terms char(40) NOT NULL default '', DaysBeforeDue smallint(6) NOT NULL default '0', DayInFollowingMonth smallint(6) NOT NULL default '0', PRIMARY KEY (TermsIndicator), KEY DaysBeforeDue (DaysBeforeDue), KEY DayInFollowingMonth (DayInFollowingMonth) ) TYPE=InnoDB; -- -- Dumping data for table `paymentterms` -- INSERT INTO paymentterms VALUES ('14','binnen 14 dagen',15,0); INSERT INTO paymentterms VALUES ('31','maand',32,0); INSERT INTO paymentterms VALUES ('CA','Cash Only',1,0); -- -- Table structure for table `periods` -- CREATE TABLE periods ( PeriodNo smallint(6) NOT NULL default '0', LastDate_in_Period date NOT NULL default '0000-00-00', PRIMARY KEY (PeriodNo), KEY LastDate_in_Period (LastDate_in_Period) ) TYPE=InnoDB; -- -- Dumping data for table `periods` -- INSERT INTO periods VALUES (37,'2003-01-31'); INSERT INTO periods VALUES (38,'2003-02-28'); INSERT INTO periods VALUES (39,'2003-03-31'); INSERT INTO periods VALUES (40,'2003-04-30'); INSERT INTO periods VALUES (41,'2003-05-31'); INSERT INTO periods VALUES (42,'2003-06-30'); INSERT INTO periods VALUES (43,'2003-07-31'); INSERT INTO periods VALUES (44,'2003-08-31'); INSERT INTO periods VALUES (45,'2003-09-30'); INSERT INTO periods VALUES (46,'2003-10-31'); INSERT INTO periods VALUES (47,'2003-11-30'); INSERT INTO periods VALUES (48,'2003-12-31'); INSERT INTO periods VALUES (49,'2004-01-31'); INSERT INTO periods VALUES (50,'2004-02-29'); INSERT INTO periods VALUES (51,'2004-03-31'); INSERT INTO periods VALUES (52,'2004-04-30'); INSERT INTO periods VALUES (53,'2004-05-31'); INSERT INTO periods VALUES (54,'2004-06-30'); INSERT INTO periods VALUES (55,'2004-07-31'); INSERT INTO periods VALUES (56,'2004-08-31'); INSERT INTO periods VALUES (57,'2004-09-30'); INSERT INTO periods VALUES (58,'2004-10-31'); INSERT INTO periods VALUES (59,'2004-11-30'); INSERT INTO periods VALUES (60,'2004-12-31'); INSERT INTO periods VALUES (61,'2005-01-31'); INSERT INTO periods VALUES (62,'2005-02-28'); INSERT INTO periods VALUES (63,'2005-03-31'); INSERT INTO periods VALUES (64,'2005-04-30'); INSERT INTO periods VALUES (65,'2005-05-31'); INSERT INTO periods VALUES (66,'2005-06-30'); INSERT INTO periods VALUES (67,'2005-07-31'); INSERT INTO periods VALUES (68,'2005-08-31'); -- -- Table structure for table `prices` -- CREATE TABLE prices ( StockID varchar(20) NOT NULL default '', TypeAbbrev char(2) NOT NULL default '', CurrAbrev char(3) NOT NULL default '', DebtorNo varchar(10) NOT NULL default '', Price decimal(20,4) NOT NULL default '0.0000', BranchCode varchar(10) NOT NULL default '', PRIMARY KEY (StockID,TypeAbbrev,CurrAbrev,DebtorNo), KEY CurrAbrev (CurrAbrev), KEY DebtorNo (DebtorNo), KEY StockID (StockID), KEY TypeAbbrev (TypeAbbrev), CONSTRAINT `0_1362` FOREIGN KEY (`TypeAbbrev`) REFERENCES `salestypes` (`TypeAbbrev`), CONSTRAINT `0_1363` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1364` FOREIGN KEY (`CurrAbrev`) REFERENCES `currencies` (`CurrAbrev`) ) TYPE=InnoDB; -- -- Dumping data for table `prices` -- INSERT INTO prices VALUES ('HBUS','HO','EUR','',6.5000,''); INSERT INTO prices VALUES ('HDOM','HO','EUR','',1.0000,''); INSERT INTO prices VALUES ('HDOMFREE','HO','EUR','',0.0000,''); -- -- Table structure for table `purchdata` -- CREATE TABLE purchdata ( SupplierNo char(10) NOT NULL default '', StockID char(20) NOT NULL default '', Price decimal(20,4) NOT NULL default '0.0000', SuppliersUOM char(50) NOT NULL default '', ConversionFactor double(16,4) NOT NULL default '1.0000', SupplierDescription char(50) NOT NULL default '', LeadTime smallint(6) NOT NULL default '1', Preferred tinyint(4) NOT NULL default '0', PRIMARY KEY (SupplierNo,StockID), KEY StockID (StockID), KEY SupplierNo (SupplierNo), KEY Preferred (Preferred), CONSTRAINT `0_1366` FOREIGN KEY (`SupplierNo`) REFERENCES `suppliers` (`SupplierID`), CONSTRAINT `0_1367` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`) ) TYPE=InnoDB; -- -- Dumping data for table `purchdata` -- -- -- Table structure for table `purchorderdetails` -- CREATE TABLE purchorderdetails ( PODetailItem int(11) NOT NULL auto_increment, OrderNo int(11) NOT NULL default '0', ItemCode varchar(20) NOT NULL default '', DeliveryDate date NOT NULL default '0000-00-00', ItemDescription varchar(100) NOT NULL default '', GLCode int(11) NOT NULL default '0', QtyInvoiced double(16,4) NOT NULL default '0.0000', UnitPrice double(16,4) NOT NULL default '0.0000', ActPrice double(16,4) NOT NULL default '0.0000', StdCostUnit double(16,4) NOT NULL default '0.0000', QuantityOrd double(16,4) NOT NULL default '0.0000', QuantityRecd double(16,4) NOT NULL default '0.0000', ShiptRef int(1) NOT NULL default '0', JobRef varchar(20) NOT NULL default '', Completed tinyint(4) NOT NULL default '0', PRIMARY KEY (PODetailItem), KEY DeliveryDate (DeliveryDate), KEY GLCode (GLCode), KEY ItemCode (ItemCode), KEY JobRef (JobRef), KEY OrderNo (OrderNo), KEY ShiptRef (ShiptRef), KEY Completed (Completed), CONSTRAINT `0_1369` FOREIGN KEY (`OrderNo`) REFERENCES `purchorders` (`OrderNo`) ) TYPE=InnoDB; -- -- Dumping data for table `purchorderdetails` -- -- -- Table structure for table `purchorders` -- CREATE TABLE purchorders ( OrderNo int(11) NOT NULL auto_increment, SupplierNo varchar(10) NOT NULL default '', Comments longblob, OrdDate datetime NOT NULL default '0000-00-00 00:00:00', Rate double(16,4) NOT NULL default '1.0000', DatePrinted datetime default NULL, AllowPrint tinyint(4) NOT NULL default '1', Initiator varchar(10) default NULL, RequisitionNo varchar(15) default NULL, IntoStockLocation varchar(5) NOT NULL default '', DelAdd1 varchar(40) NOT NULL default '', DelAdd2 varchar(40) NOT NULL default '', DelAdd3 varchar(40) NOT NULL default '', DelAdd4 varchar(40) NOT NULL default '', PRIMARY KEY (OrderNo), KEY OrdDate (OrdDate), KEY SupplierNo (SupplierNo), KEY IntoStockLocation (IntoStockLocation), KEY AllowPrintPO (AllowPrint), CONSTRAINT `0_1371` FOREIGN KEY (`IntoStockLocation`) REFERENCES `locations` (`LocCode`), CONSTRAINT `0_1372` FOREIGN KEY (`SupplierNo`) REFERENCES `suppliers` (`SupplierID`) ) TYPE=InnoDB; -- -- Dumping data for table `purchorders` -- -- -- Table structure for table `reportcolumns` -- CREATE TABLE reportcolumns ( ReportID smallint(6) NOT NULL default '0', ColNo smallint(6) NOT NULL default '0', Heading1 varchar(15) NOT NULL default '', Heading2 varchar(15) default NULL, Calculation tinyint(1) NOT NULL default '0', PeriodFrom smallint(6) default NULL, PeriodTo smallint(6) default NULL, DataType varchar(15) default NULL, ColNumerator tinyint(4) default NULL, ColDenominator tinyint(4) default NULL, CalcOperator char(1) default NULL, BudgetOrActual tinyint(1) NOT NULL default '0', ValFormat char(1) NOT NULL default 'N', Constant float NOT NULL default '0', PRIMARY KEY (ReportID,ColNo), CONSTRAINT `0_1374` FOREIGN KEY (`ReportID`) REFERENCES `reportheaders` (`ReportID`) ) TYPE=InnoDB; -- -- Dumping data for table `reportcolumns` -- INSERT INTO reportcolumns VALUES (1,1,'HEADING','HEADING 2',0,23,68,'Net Value',0,0,'',1,'N',0); -- -- Table structure for table `reportheaders` -- CREATE TABLE reportheaders ( ReportID smallint(6) NOT NULL auto_increment, ReportHeading varchar(80) NOT NULL default '', GroupByData1 varchar(15) NOT NULL default '', NewPageAfter1 tinyint(1) NOT NULL default '0', Lower1 varchar(10) NOT NULL default '', Upper1 varchar(10) NOT NULL default '', GroupByData2 varchar(15) default NULL, NewPageAfter2 tinyint(1) NOT NULL default '0', Lower2 varchar(10) default NULL, Upper2 varchar(10) default NULL, GroupByData3 varchar(15) default NULL, NewPageAfter3 tinyint(1) NOT NULL default '0', Lower3 varchar(10) default NULL, Upper3 varchar(10) default NULL, GroupByData4 varchar(15) NOT NULL default '', NewPageAfter4 tinyint(1) NOT NULL default '0', Upper4 varchar(10) NOT NULL default '', Lower4 varchar(10) NOT NULL default '', PRIMARY KEY (ReportID), KEY ReportHeading (ReportHeading) ) TYPE=InnoDB; -- -- Dumping data for table `reportheaders` -- INSERT INTO reportheaders VALUES (1,'HH','Sales Area',0,'1','2','Not Used',0,'','','Not Used',0,'','','Not Used',0,'',''); -- -- Table structure for table `salesanalysis` -- CREATE TABLE salesanalysis ( TypeAbbrev char(2) NOT NULL default '', PeriodNo smallint(6) NOT NULL default '0', Amt double(16,4) NOT NULL default '0.0000', Cost double(16,4) NOT NULL default '0.0000', Cust varchar(10) NOT NULL default '', CustBranch varchar(10) NOT NULL default '', Qty double(16,4) NOT NULL default '0.0000', Disc double(16,4) NOT NULL default '0.0000', StockID varchar(20) NOT NULL default '', Area char(2) NOT NULL default '', BudgetOrActual tinyint(1) NOT NULL default '0', Salesperson char(3) NOT NULL default '', StkCategory varchar(6) NOT NULL default '', ID int(11) NOT NULL auto_increment, PRIMARY KEY (ID), KEY CustBranch (CustBranch), KEY Cust (Cust), KEY PeriodNo (PeriodNo), KEY StkCategory (StkCategory), KEY StockID (StockID), KEY TypeAbbrev (TypeAbbrev), KEY Area (Area), KEY BudgetOrActual (BudgetOrActual), KEY Salesperson (Salesperson), CONSTRAINT `0_1377` FOREIGN KEY (`PeriodNo`) REFERENCES `periods` (`PeriodNo`) ) TYPE=InnoDB; -- -- Dumping data for table `salesanalysis` -- INSERT INTO salesanalysis VALUES ('HO',51,71.5000,0.0000,'SMS','SMS',11.0000,0.0000,'HBUS','NL',1,'DRS','IH',11); INSERT INTO salesanalysis VALUES ('HO',51,53.0000,0.0000,'SMS','SMS',53.0000,0.0000,'HDOM','NL',1,'DRS','IH',12); INSERT INTO salesanalysis VALUES ('HO',52,6.5000,0.0000,'SMS','SMS',1.0000,0.0000,'hbus','NL',1,'DRS','IH',13); INSERT INTO salesanalysis VALUES ('HO',52,7.0000,0.0000,'SMS','SMS',7.0000,0.0000,'hdom','NL',1,'DRS','IH',14); INSERT INTO salesanalysis VALUES ('HO',52,0.0000,0.0000,'SMS','SMS',11.0000,0.0000,'HDOMFREE','NL',1,'DRS','IH',15); INSERT INTO salesanalysis VALUES ('HO',52,71.5000,0.0000,'DAP','DAP',11.0000,0.0000,'HBUS','NL',1,'DRS','IH',16); INSERT INTO salesanalysis VALUES ('HO',52,0.0000,0.0000,'DAP','DAP',11.0000,0.0000,'HDOMFREE','NL',1,'DRS','IH',17); -- -- Table structure for table `salesglpostings` -- CREATE TABLE salesglpostings ( ID int(11) NOT NULL auto_increment, Area char(2) NOT NULL default '', StkCat varchar(6) NOT NULL default '', DiscountGLCode int(11) NOT NULL default '0', SalesGLCode int(11) NOT NULL default '0', SalesType char(2) NOT NULL default 'AN', PRIMARY KEY (ID), UNIQUE KEY Area_StkCat (Area,StkCat,SalesType), KEY Area (Area), KEY StkCat (StkCat), KEY SalesType (SalesType) ) TYPE=InnoDB; -- -- Dumping data for table `salesglpostings` -- INSERT INTO salesglpostings VALUES (1,'AN','ANY',1,1,'AN'); INSERT INTO salesglpostings VALUES (3,'NL','IL',8098,8010,'AN'); INSERT INTO salesglpostings VALUES (4,'NL','IL',8098,8020,'HS'); INSERT INTO salesglpostings VALUES (5,'NL','LH',8098,8000,'CO'); INSERT INTO salesglpostings VALUES (6,'NL','IH',8098,8000,'HS'); INSERT INTO salesglpostings VALUES (7,'AN','IH',8098,8000,'HO'); INSERT INTO salesglpostings VALUES (8,'NL','IH',8098,8000,'HO'); -- -- Table structure for table `salesman` -- CREATE TABLE salesman ( SalesmanCode char(3) NOT NULL default '', SalesmanName char(30) NOT NULL default '', SManTel char(20) NOT NULL default '', SManFax char(20) NOT NULL default '', CommissionRate1 double(16,4) NOT NULL default '0.0000', Breakpoint decimal(20,4) NOT NULL default '0.0000', CommissionRate2 double(16,4) NOT NULL default '0.0000', PRIMARY KEY (SalesmanCode) ) TYPE=InnoDB; -- -- Dumping data for table `salesman` -- INSERT INTO salesman VALUES ('DRS','Dick Stins','06-19640701','084-8649395',0.0000,0.0000,0.0000); -- -- Table structure for table `salesorderdetails` -- CREATE TABLE salesorderdetails ( OrderNo int(11) NOT NULL default '0', StkCode char(20) NOT NULL default '', QtyInvoiced double(16,4) NOT NULL default '0.0000', UnitPrice double(16,4) NOT NULL default '0.0000', Quantity double(16,4) NOT NULL default '0.0000', Estimate tinyint(4) NOT NULL default '0', DiscountPercent double(16,4) NOT NULL default '0.0000', ActualDispatchDate datetime NOT NULL default '0000-00-00 00:00:00', Completed tinyint(1) NOT NULL default '0', PRIMARY KEY (OrderNo,StkCode), KEY OrderNo (OrderNo), KEY StkCode (StkCode), KEY Completed (Completed), CONSTRAINT `0_1380` FOREIGN KEY (`StkCode`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1381` FOREIGN KEY (`OrderNo`) REFERENCES `salesorders` (`OrderNo`) ) TYPE=InnoDB; -- -- Dumping data for table `salesorderdetails` -- INSERT INTO salesorderdetails VALUES (1,'HBUS',11.0000,6.5000,11.0000,0,0.0000,'2004-03-15 00:00:00',1); INSERT INTO salesorderdetails VALUES (1,'HDOM',53.0000,1.0000,53.0000,0,0.0000,'2004-03-15 00:00:00',1); INSERT INTO salesorderdetails VALUES (2,'HBUS',12.0000,6.5000,12.0000,0,0.0000,'2004-04-02 00:00:00',1); INSERT INTO salesorderdetails VALUES (2,'HDOM',60.0000,1.0000,60.0000,0,0.0000,'2004-04-02 00:00:00',1); INSERT INTO salesorderdetails VALUES (2,'HDOMFREE',12.0000,0.0000,12.0000,0,0.0000,'2004-04-02 00:00:00',1); INSERT INTO salesorderdetails VALUES (3,'HBUS',11.0000,6.5000,11.0000,0,0.0000,'2004-04-10 00:00:00',1); INSERT INTO salesorderdetails VALUES (3,'HDOMFREE',11.0000,0.0000,11.0000,0,0.0000,'2004-04-10 00:00:00',1); -- -- Table structure for table `salesorders` -- CREATE TABLE salesorders ( OrderNo int(11) NOT NULL auto_increment, DebtorNo varchar(10) NOT NULL default '', BranchCode varchar(10) NOT NULL default '', CustomerRef varchar(50) NOT NULL default '', BuyerName varchar(50) default NULL, Comments longblob, OrdDate date NOT NULL default '0000-00-00', OrderType char(2) NOT NULL default '', ShipVia int(11) NOT NULL default '0', DelAdd1 varchar(40) NOT NULL default '', DelAdd2 varchar(20) NOT NULL default '', DelAdd3 varchar(15) NOT NULL default '', DelAdd4 varchar(15) default NULL, ContactPhone varchar(25) default NULL, ContactEmail varchar(25) default NULL, DeliverTo varchar(40) NOT NULL default '', FreightCost float(10,2) NOT NULL default '0.00', FromStkLoc varchar(5) NOT NULL default '', DeliveryDate date NOT NULL default '0000-00-00', PrintedPackingSlip tinyint(4) NOT NULL default '0', DatePackingSlipPrinted date NOT NULL default '0000-00-00', PRIMARY KEY (OrderNo), KEY DebtorNo (DebtorNo), KEY OrdDate (OrdDate), KEY OrderType (OrderType), KEY LocationIndex (FromStkLoc), KEY BranchCode (BranchCode,DebtorNo), KEY ShipVia (ShipVia), CONSTRAINT `0_1383` FOREIGN KEY (`FromStkLoc`) REFERENCES `locations` (`LocCode`), CONSTRAINT `0_1384` FOREIGN KEY (`BranchCode`, `DebtorNo`) REFERENCES `custbranch` (`BranchCode`, `DebtorNo`), CONSTRAINT `0_1385` FOREIGN KEY (`ShipVia`) REFERENCES `shippers` (`Shipper_ID`) ) TYPE=InnoDB; -- -- Dumping data for table `salesorders` -- INSERT INTO salesorders VALUES (1,'SMS','SMS','contract 0402-1b',NULL,'Zie contract.\r\nPeriode ... t/m ...\r\n\r\n5 extra domeinnamen voor 12 euro per jaar.\r\n5 * 11 maanden - 2 maanden extra korting = 53\r\n\r\nBedrag is al voldaan. Inv 27','2004-03-14','HO',10,'Erve Geusendam 37','7463 CS','Rijssen','The Netherlands','','','SportsMarketingServices',0.00,'USAS','2004-03-15',0,'0000-00-00'); INSERT INTO salesorders VALUES (2,'SMS','SMS','contract 0402-1a',NULL,'Alle betalingen zijn al ontvangen.\r\nIn verband met de toevoeging van de twee domeinnamen ontvangt u het gewijzigde contract 0402-1a\r\n(a=wijzigingscode). Inv 28','2004-02-18','HO',10,'Erve Geusendam 37','7463 CS','Rijssen','The Netherlands','+31 (0) 548-543590','','SportsMarketingServices',0.00,'AM','2004-04-02',0,'0000-00-00'); INSERT INTO salesorders VALUES (3,'DAP','DAP','contract 0310-1',NULL,' Inv 29','2004-04-09','HO',10,'Heumensebaan 23','6561 CJ','Groesbeek','Nederland','','','Dierenartsenpraktijk Groesbeek e.o.',0.00,'AM','2004-04-10',0,'0000-00-00'); -- -- Table structure for table `salestypes` -- CREATE TABLE salestypes ( TypeAbbrev char(2) NOT NULL default '', Sales_Type char(20) NOT NULL default '', PRIMARY KEY (TypeAbbrev), KEY Sales_Type (Sales_Type) ) TYPE=InnoDB; -- -- Dumping data for table `salestypes` -- INSERT INTO salestypes VALUES ('CO','Consultancy'); INSERT INTO salestypes VALUES ('HS','Hard and or software'); INSERT INTO salestypes VALUES ('HO','Hosting'); -- -- Table structure for table `shipmentcharges` -- CREATE TABLE shipmentcharges ( ShiptChgID int(11) NOT NULL auto_increment, ShiptRef int(11) NOT NULL default '0', TransType smallint(6) NOT NULL default '0', TransNo int(11) NOT NULL default '0', StockID varchar(20) NOT NULL default '', Value float NOT NULL default '0', PRIMARY KEY (ShiptChgID), KEY TransType (TransType,TransNo), KEY ShiptRef (ShiptRef), KEY StockID (StockID), KEY TransType_2 (TransType), CONSTRAINT `0_1389` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1390` FOREIGN KEY (`ShiptRef`) REFERENCES `shipments` (`ShiptRef`), CONSTRAINT `0_1391` FOREIGN KEY (`TransType`) REFERENCES `systypes` (`TypeID`) ) TYPE=InnoDB; -- -- Dumping data for table `shipmentcharges` -- -- -- Table structure for table `shipments` -- CREATE TABLE shipments ( ShiptRef int(11) NOT NULL default '0', VoyageRef varchar(20) NOT NULL default '0', Vessel varchar(50) NOT NULL default '', ETA datetime NOT NULL default '0000-00-00 00:00:00', AccumValue double(16,4) NOT NULL default '0.0000', SupplierID varchar(10) NOT NULL default '', Closed tinyint(4) NOT NULL default '0', PRIMARY KEY (ShiptRef), KEY ETA (ETA), KEY SupplierID (SupplierID), KEY ShipperRef (VoyageRef), KEY Vessel (Vessel), CONSTRAINT `0_1393` FOREIGN KEY (`SupplierID`) REFERENCES `suppliers` (`SupplierID`) ) TYPE=InnoDB; -- -- Dumping data for table `shipments` -- -- -- Table structure for table `shippers` -- CREATE TABLE shippers ( Shipper_ID int(11) NOT NULL auto_increment, ShipperName char(40) NOT NULL default '', MinCharge double(16,4) NOT NULL default '0.0000', PRIMARY KEY (Shipper_ID) ) TYPE=InnoDB; -- -- Dumping data for table `shippers` -- INSERT INTO shippers VALUES (1,'Courier Post',0.0000); INSERT INTO shippers VALUES (10,'Not Specified',0.0000); -- -- Table structure for table `stockcategory` -- CREATE TABLE stockcategory ( CategoryID char(6) NOT NULL default '', CategoryDescription char(20) NOT NULL default '', StockType char(1) NOT NULL default 'F', StockAct int(11) NOT NULL default '0', AdjGLAct int(11) NOT NULL default '0', PurchPriceVarAct int(11) NOT NULL default '80000', MaterialUseageVarAc int(11) NOT NULL default '80000', WIPAct int(11) NOT NULL default '0', PRIMARY KEY (CategoryID), KEY CategoryDescription (CategoryDescription), KEY StockType (StockType) ) TYPE=InnoDB; -- -- Dumping data for table `stockcategory` -- INSERT INTO stockcategory VALUES ('IH','Item VAT high','F',1013,7090,7098,8098,1013); INSERT INTO stockcategory VALUES ('IL','Item VAT low','F',1013,7090,7098,8098,1013); INSERT INTO stockcategory VALUES ('LH','Labour VAT high','D',1013,7000,7098,8098,1013); INSERT INTO stockcategory VALUES ('LL','Labour VAT Low','L',1013,1301,1301,1301,1013); INSERT INTO stockcategory VALUES ('LZ','Labour VAT Zero','L',1013,1301,7098,8098,1013); -- -- Table structure for table `stockcheckfreeze` -- CREATE TABLE stockcheckfreeze ( StockID varchar(20) NOT NULL default '', LocCode varchar(5) NOT NULL default '', QOH float NOT NULL default '0', PRIMARY KEY (StockID), KEY LocCode (LocCode), CONSTRAINT `0_1397` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`), CONSTRAINT `0_1398` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`) ) TYPE=InnoDB; -- -- Dumping data for table `stockcheckfreeze` -- -- -- Table structure for table `stockcounts` -- CREATE TABLE stockcounts ( ID int(11) NOT NULL auto_increment, StockID varchar(20) NOT NULL default '', LocCode varchar(5) NOT NULL default '', QtyCounted float NOT NULL default '0', Reference varchar(20) NOT NULL default '', PRIMARY KEY (ID), KEY StockID (StockID), KEY LocCode (LocCode), CONSTRAINT `0_1400` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`), CONSTRAINT `0_1401` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`) ) TYPE=InnoDB; -- -- Dumping data for table `stockcounts` -- -- -- Table structure for table `stockmaster` -- CREATE TABLE stockmaster ( StockID varchar(20) NOT NULL default '', CategoryID varchar(6) NOT NULL default '', Description varchar(50) NOT NULL default '', LongDescription text NOT NULL, Units varchar(20) NOT NULL default 'each', MBflag char(1) NOT NULL default 'B', LastCurCostDate date NOT NULL default '1800-01-01', ActualCost decimal(20,4) NOT NULL default '0.0000', LastCost decimal(20,4) NOT NULL default '0.0000', Materialcost decimal(20,4) NOT NULL default '0.0000', Labourcost decimal(20,4) NOT NULL default '0.0000', Overheadcost decimal(20,4) NOT NULL default '0.0000', lowestlevel smallint(6) NOT NULL default '0', Discontinued tinyint(4) NOT NULL default '0', Controlled tinyint(4) NOT NULL default '0', EOQ double(10,2) NOT NULL default '0.00', Volume decimal(20,4) NOT NULL default '0.0000', KGS decimal(20,4) NOT NULL default '0.0000', BarCode varchar(50) NOT NULL default '', DiscountCategory char(2) NOT NULL default '', TaxLevel tinyint(4) NOT NULL default '1', PRIMARY KEY (StockID), KEY CategoryID (CategoryID), KEY Description (Description), KEY LastCurCostDate (LastCurCostDate), KEY MBflag (MBflag), KEY StockID (StockID,CategoryID), KEY Controlled (Controlled), KEY DiscountCategory (DiscountCategory), CONSTRAINT `0_1403` FOREIGN KEY (`CategoryID`) REFERENCES `stockcategory` (`CategoryID`) ) TYPE=InnoDB; -- -- Dumping data for table `stockmaster` -- INSERT INTO stockmaster VALUES ('HBUS','IH','Hosting business package','Hosting business package (per month, minimum 12 months contract)','each','D','1800-01-01',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,1.00,0.0000,0.0000,'','',2); INSERT INTO stockmaster VALUES ('HDOM','IH','Domain name registration','Only as add on for business hosting package in one order.','each','D','1800-01-01',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,1.00,0.0000,0.0000,'','',2); INSERT INTO stockmaster VALUES ('HDOMFREE','IH','Domain name as part of a hosting package.','Domain name as part of a hosting package.\r\nThe price is zero, because the hosting package is inclusive 1 domainname.','each','D','1800-01-01',0.0000,0.0000,0.0000,0.0000,0.0000,0,0,0,1.00,0.0000,0.0000,'','',2); -- -- Table structure for table `stockmoves` -- CREATE TABLE stockmoves ( StkMoveNo int(11) NOT NULL auto_increment, StockID char(20) NOT NULL default '', Type smallint(6) NOT NULL default '0', TransNo int(11) NOT NULL default '0', LocCode char(5) NOT NULL default '', Bundle char(8) NOT NULL default '1', TranDate date NOT NULL default '0000-00-00', DebtorNo char(10) NOT NULL default '', BranchCode char(10) NOT NULL default '', Price decimal(20,4) NOT NULL default '0.0000', Prd smallint(6) NOT NULL default '0', Reference char(40) NOT NULL default '', Qty double(16,4) NOT NULL default '1.0000', DiscountPercent double(16,4) NOT NULL default '0.0000', StandardCost double(16,4) NOT NULL default '0.0000', Show_On_Inv_Crds tinyint(4) NOT NULL default '1', NewQOH double NOT NULL default '0', HideMovt tinyint(4) NOT NULL default '0', TaxRate float NOT NULL default '0', PRIMARY KEY (StkMoveNo), KEY Bundle (Bundle), KEY DebtorNo (DebtorNo), KEY LocCode (LocCode), KEY Prd (Prd), KEY StockID (StockID,LocCode), KEY StockID_2 (StockID), KEY TranDate (TranDate), KEY TransNo (TransNo), KEY Type (Type), KEY Show_On_Inv_Crds (Show_On_Inv_Crds), KEY Hide (HideMovt), CONSTRAINT `0_1405` FOREIGN KEY (`Prd`) REFERENCES `periods` (`PeriodNo`), CONSTRAINT `0_1406` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1407` FOREIGN KEY (`Type`) REFERENCES `systypes` (`TypeID`), CONSTRAINT `0_1408` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `stockmoves` -- INSERT INTO stockmoves VALUES (11,'HBUS',10,27,'USAS','1','2004-03-15','SMS','SMS',6.5000,51,'1',-11.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (12,'HDOM',10,27,'USAS','1','2004-03-15','SMS','SMS',1.0000,51,'1',-53.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (13,'hbus',11,12,'USAS','1','2004-04-01','SMS','SMS',6.5000,52,'foute aangemaakte order. Order/faktuur w',11.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (14,'hdom',11,12,'USAS','1','2004-04-01','SMS','SMS',1.0000,52,'foute aangemaakte order. Order/faktuur w',53.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (15,'HBUS',10,28,'AM','1','2004-04-02','SMS','SMS',6.5000,52,'2',-12.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (16,'HDOM',10,28,'AM','1','2004-04-02','SMS','SMS',1.0000,52,'2',-60.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (17,'HDOMFREE',10,28,'AM','1','2004-04-02','SMS','SMS',0.0000,52,'2',-11.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (18,'HBUS',10,29,'AM','1','2004-04-10','DAP','DAP',6.5000,52,'3',-11.0000,0.0000,0.0000,1,0,0,0.19); INSERT INTO stockmoves VALUES (19,'HDOMFREE',10,29,'AM','1','2004-04-10','DAP','DAP',0.0000,52,'3',-11.0000,0.0000,0.0000,1,0,0,0.19); -- -- Table structure for table `suppallocs` -- CREATE TABLE suppallocs ( ID int(11) NOT NULL auto_increment, Amt float(20,2) NOT NULL default '0.00', DateAlloc date NOT NULL default '0000-00-00', TransID_AllocFrom int(11) NOT NULL default '0', TransID_AllocTo int(11) NOT NULL default '0', PRIMARY KEY (ID), KEY TransID_AllocFrom (TransID_AllocFrom), KEY TransID_AllocTo (TransID_AllocTo), KEY DateAlloc (DateAlloc), CONSTRAINT `0_1410` FOREIGN KEY (`TransID_AllocTo`) REFERENCES `supptrans` (`ID`), CONSTRAINT `0_1411` FOREIGN KEY (`TransID_AllocFrom`) REFERENCES `supptrans` (`ID`) ) TYPE=InnoDB; -- -- Dumping data for table `suppallocs` -- -- -- Table structure for table `suppliercontacts` -- CREATE TABLE suppliercontacts ( SupplierID varchar(10) NOT NULL default '', Contact varchar(30) NOT NULL default '', Position varchar(30) NOT NULL default '', Tel varchar(30) NOT NULL default '', Fax varchar(30) NOT NULL default '', Mobile varchar(30) NOT NULL default '', Email varchar(55) NOT NULL default '', OrderContact tinyint(1) NOT NULL default '0', PRIMARY KEY (SupplierID,Contact), KEY Contact (Contact), KEY SupplierID (SupplierID), CONSTRAINT `0_1416` FOREIGN KEY (`SupplierID`) REFERENCES `suppliers` (`SupplierID`) ) TYPE=InnoDB; -- -- Dumping data for table `suppliercontacts` -- -- -- Table structure for table `suppliers` -- CREATE TABLE suppliers ( SupplierID char(10) NOT NULL default '', SuppName char(40) NOT NULL default '', Address1 char(40) NOT NULL default '', Address2 char(40) NOT NULL default '', Address3 char(40) NOT NULL default '', Address4 char(50) NOT NULL default '', CurrCode char(3) NOT NULL default '', SupplierSince date NOT NULL default '0000-00-00', PaymentTerms char(2) NOT NULL default '', LastPaid double(16,4) NOT NULL default '0.0000', LastPaidDate datetime default NULL, BankAct char(16) NOT NULL default '', BankRef char(12) NOT NULL default '', BankPartics char(12) NOT NULL default '', Remittance tinyint(4) NOT NULL default '1', TaxAuthority tinyint(4) NOT NULL default '1', PRIMARY KEY (SupplierID), KEY CurrCode (CurrCode), KEY PaymentTerms (PaymentTerms), KEY SupplierID (SupplierID), KEY SuppName (SuppName), KEY TaxAuthority (TaxAuthority), CONSTRAINT `0_1418` FOREIGN KEY (`TaxAuthority`) REFERENCES `taxauthorities` (`TaxID`), CONSTRAINT `0_1419` FOREIGN KEY (`CurrCode`) REFERENCES `currencies` (`CurrAbrev`), CONSTRAINT `0_1420` FOREIGN KEY (`PaymentTerms`) REFERENCES `paymentterms` (`TermsIndicator`) ) TYPE=InnoDB; -- -- Dumping data for table `suppliers` -- -- -- Table structure for table `supptrans` -- CREATE TABLE supptrans ( TransNo int(11) NOT NULL default '0', Type smallint(6) NOT NULL default '0', SupplierNo varchar(10) NOT NULL default '', SuppReference varchar(20) NOT NULL default '', TranDate date NOT NULL default '0000-00-00', DueDate date NOT NULL default '0000-00-00', Settled tinyint(4) NOT NULL default '0', Rate double(16,6) NOT NULL default '1.000000', OvAmount double(16,4) NOT NULL default '0.0000', OvGST double(16,4) NOT NULL default '0.0000', DiffOnExch double(16,4) NOT NULL default '0.0000', Alloc double(16,4) NOT NULL default '0.0000', TransText longblob, Hold tinyint(4) NOT NULL default '0', ID int(11) NOT NULL auto_increment, PRIMARY KEY (ID), UNIQUE KEY TypeTransNo (TransNo,Type), KEY DueDate (DueDate), KEY Hold (Hold), KEY SupplierNo (SupplierNo), KEY Settled (Settled), KEY SupplierNo_2 (SupplierNo,SuppReference), KEY SuppReference (SuppReference), KEY TranDate (TranDate), KEY TransNo (TransNo), KEY Type (Type), CONSTRAINT `0_1413` FOREIGN KEY (`SupplierNo`) REFERENCES `suppliers` (`SupplierID`), CONSTRAINT `0_1414` FOREIGN KEY (`Type`) REFERENCES `systypes` (`TypeID`) ) TYPE=InnoDB; -- -- Dumping data for table `supptrans` -- -- -- Table structure for table `systypes` -- CREATE TABLE systypes ( TypeID smallint(6) NOT NULL default '0', TypeName char(50) NOT NULL default '', TypeNo int(11) NOT NULL default '1', PRIMARY KEY (TypeID), KEY TypeNo (TypeNo) ) TYPE=InnoDB; -- -- Dumping data for table `systypes` -- INSERT INTO systypes VALUES (0,'Journal - GL',9); INSERT INTO systypes VALUES (1,'Payment - GL',17); INSERT INTO systypes VALUES (2,'Receipt - GL',3); INSERT INTO systypes VALUES (3,'Standing Journal',0); INSERT INTO systypes VALUES (10,'Sales Invoice',29); INSERT INTO systypes VALUES (11,'Credit Note',12); INSERT INTO systypes VALUES (12,'Receipt',18); INSERT INTO systypes VALUES (15,'Journal - Debtors',0); INSERT INTO systypes VALUES (16,'Location Transfer',4); INSERT INTO systypes VALUES (17,'Stock Adjustment',5); INSERT INTO systypes VALUES (18,'Purchase Order',0); INSERT INTO systypes VALUES (20,'Purchase Invoice',13); INSERT INTO systypes VALUES (21,'Debit Note',3); INSERT INTO systypes VALUES (22,'Creditors Payment',3); INSERT INTO systypes VALUES (23,'Creditors Journal',0); INSERT INTO systypes VALUES (25,'Purchase Order Delivery',7); INSERT INTO systypes VALUES (26,'Work Order Receipt',0); INSERT INTO systypes VALUES (28,'Work Order Issue',0); INSERT INTO systypes VALUES (29,'Work Order Variance',0); INSERT INTO systypes VALUES (30,'Sales Order',0); INSERT INTO systypes VALUES (31,'Shipment Close',2); INSERT INTO systypes VALUES (35,'Cost Update',3); INSERT INTO systypes VALUES (50,'Opening Balance',0); -- -- Table structure for table `taxauthlevels` -- CREATE TABLE taxauthlevels ( TaxAuthority tinyint(4) NOT NULL default '1', DispatchTaxAuthority tinyint(4) NOT NULL default '1', Level tinyint(4) NOT NULL default '0', TaxRate double NOT NULL default '0', PRIMARY KEY (TaxAuthority,DispatchTaxAuthority,Level), KEY TaxAuthority (TaxAuthority), KEY DispatchTaxAuthority (DispatchTaxAuthority), CONSTRAINT `0_1423` FOREIGN KEY (`DispatchTaxAuthority`) REFERENCES `taxauthorities` (`TaxID`), CONSTRAINT `0_1424` FOREIGN KEY (`TaxAuthority`) REFERENCES `taxauthorities` (`TaxID`) ) TYPE=InnoDB; -- -- Dumping data for table `taxauthlevels` -- INSERT INTO taxauthlevels VALUES (0,0,0,0); INSERT INTO taxauthlevels VALUES (0,0,1,0.06); INSERT INTO taxauthlevels VALUES (0,0,2,0.19); INSERT INTO taxauthlevels VALUES (2,2,1,0.19); INSERT INTO taxauthlevels VALUES (2,2,2,0.19); -- -- Table structure for table `taxauthorities` -- CREATE TABLE taxauthorities ( TaxID tinyint(4) NOT NULL default '0', Description char(20) NOT NULL default '', TaxGLCode int(11) NOT NULL default '0', PurchTaxGLAccount int(11) NOT NULL default '0', PRIMARY KEY (TaxID) ) TYPE=InnoDB; -- -- Dumping data for table `taxauthorities` -- INSERT INTO taxauthorities VALUES (0,'NL VAT',1816,1815); INSERT INTO taxauthorities VALUES (2,'USAH',1816,1815); -- -- Table structure for table `woissues` -- CREATE TABLE woissues ( IssueNo int(11) NOT NULL default '0', WORef char(20) NOT NULL default '', StockID char(20) NOT NULL default '', IssueType char(1) NOT NULL default 'M', WorkCentre char(5) NOT NULL default '', QtyIssued double(16,4) NOT NULL default '0.0000', StdCost decimal(20,4) NOT NULL default '0.0000', KEY WorkCentre (WorkCentre), KEY IssueNo (IssueNo), KEY IssueNo_2 (IssueNo,WORef,StockID), KEY StockID (StockID), KEY IssueType (IssueType), KEY WORef (WORef), CONSTRAINT `0_1427` FOREIGN KEY (`WorkCentre`) REFERENCES `workcentres` (`Code`), CONSTRAINT `0_1428` FOREIGN KEY (`WORef`) REFERENCES `worksorders` (`WORef`), CONSTRAINT `0_1429` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`) ) TYPE=InnoDB; -- -- Dumping data for table `woissues` -- -- -- Table structure for table `worequirements` -- CREATE TABLE worequirements ( ID int(11) NOT NULL auto_increment, WORef char(20) NOT NULL default '', StockID char(20) NOT NULL default '', WrkCentre char(5) NOT NULL default '', UnitsReq double(16,4) NOT NULL default '1.0000', StdCost decimal(20,4) NOT NULL default '0.0000', ResourceType char(1) NOT NULL default 'M', PRIMARY KEY (ID), KEY WrkCentre (WrkCentre), KEY ResourceType (ResourceType), KEY WORef (WORef,StockID), KEY StockID (StockID), KEY WORef_2 (WORef), CONSTRAINT `0_1431` FOREIGN KEY (`WrkCentre`) REFERENCES `workcentres` (`Code`), CONSTRAINT `0_1432` FOREIGN KEY (`WORef`) REFERENCES `worksorders` (`WORef`), CONSTRAINT `0_1433` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`) ) TYPE=InnoDB; -- -- Dumping data for table `worequirements` -- -- -- Table structure for table `workcentres` -- CREATE TABLE workcentres ( Code char(5) NOT NULL default '', Location char(5) NOT NULL default '', Description char(20) NOT NULL default '', Capacity double(16,4) NOT NULL default '1.0000', OverheadPerHour decimal(20,4) NOT NULL default '0.0000', OverheadRecoveryAct int(11) NOT NULL default '0', SetUpHrs decimal(20,4) NOT NULL default '0.0000', PRIMARY KEY (Code), KEY Description (Description), KEY Location (Location), CONSTRAINT `0_1437` FOREIGN KEY (`Location`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `workcentres` -- -- -- Table structure for table `worksorders` -- CREATE TABLE worksorders ( WORef char(20) NOT NULL default '', LocCode char(5) NOT NULL default '', UnitsReqd smallint(6) NOT NULL default '1', StockID char(20) NOT NULL default '', StdCost decimal(20,4) NOT NULL default '0.0000', RequiredBy date NOT NULL default '0000-00-00', ReleasedDate date NOT NULL default '1800-01-01', AccumValueIssued decimal(20,4) NOT NULL default '0.0000', AccumValueTrfd decimal(20,4) NOT NULL default '0.0000', Closed tinyint(4) NOT NULL default '0', Released tinyint(4) NOT NULL default '0', PRIMARY KEY (WORef), KEY StockID (StockID), KEY LocCode (LocCode), KEY ReleasedDate (ReleasedDate), KEY RequiredBy (RequiredBy), KEY WORef (WORef,LocCode), CONSTRAINT `0_1439` FOREIGN KEY (`StockID`) REFERENCES `stockmaster` (`StockID`), CONSTRAINT `0_1440` FOREIGN KEY (`LocCode`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `worksorders` -- -- -- Table structure for table `www_users` -- CREATE TABLE www_users ( UserID varchar(20) NOT NULL default '', Password varchar(20) NOT NULL default '', RealName varchar(35) NOT NULL default '', CustomerID varchar(10) NOT NULL default '', Phone varchar(30) NOT NULL default '', Email varchar(55) default NULL, DefaultLocation varchar(5) NOT NULL default '', FullAccess int(11) NOT NULL default '1', LastVisitDate datetime default NULL, BranchCode varchar(10) NOT NULL default '', PageSize varchar(20) NOT NULL default 'A4', ModulesAllowed varchar(20) NOT NULL default '', Blocked tinyint(4) NOT NULL default '0', PRIMARY KEY (UserID), KEY CustomerID (CustomerID), KEY DefaultLocation (DefaultLocation), CONSTRAINT `0_1435` FOREIGN KEY (`DefaultLocation`) REFERENCES `locations` (`LocCode`) ) TYPE=InnoDB; -- -- Dumping data for table `www_users` -- INSERT INTO www_users VALUES ('DRStins','johan','Dick Stins','','+31 (0) 33 4551334','erp@zion-it.com','AM',7,'2004-04-14 23:16:42','','A4','1,1,1,1,1,1,1,1,',0); -- -- Table structure for table `zh_articles` -- CREATE TABLE zh_articles ( id int(10) unsigned NOT NULL auto_increment, nm varchar(40) default NULL, price float(8,2) default NULL, PRIMARY KEY (id), UNIQUE KEY zh_i_ate_nm (nm) ) TYPE=InnoDB; -- -- Dumping data for table `zh_articles` -- INSERT INTO zh_articles VALUES (1,'HDOM',0.00); INSERT INTO zh_articles VALUES (2,'HBUS',6.50); -- -- Table structure for table `zh_contracttypes` -- CREATE TABLE zh_contracttypes ( code varchar(10) NOT NULL default '', ate_id int(10) unsigned default NULL, koptekst text, voorwaarden text, voettekst text, chng_dt datetime default NULL, cr_dt datetime default NULL, PRIMARY KEY (code), UNIQUE KEY zh_i_cte_code (code), KEY zh_i_cte_fk_ate (ate_id), CONSTRAINT `0_1444` FOREIGN KEY (`ate_id`) REFERENCES `zh_articles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; -- -- Dumping data for table `zh_contracttypes` -- INSERT INTO zh_contracttypes VALUES ('SIDN',1,'Registratiecontract .nl-domeinnaam\nAangevraagde domeinnaam: sportsmarketingservices.nl\nPartij I, Domeinnaamaanvrager:\nI. naam: Sportsmarketingservices\nII. adres (geen postbus)1: Erve Geusendam 37\nIII. postcode, plaats en land: 7463 CS Rijssen, Nederland\nIV. adres in Nederland (geen postbus)2:\nV.\nVI. administratieve contact, naam: D.R. Stins\nVII. telefoonnummer3: +31 33 455 1334\nVIII. e-mail: sportsmarketingservices.admin@Zion-IT.com\nIX. technische contact, naam: D.R. Stins\nX. telefoonnummer4: +31 33 455 1334\nXI. e-mail: sportsmarketingservices.tech@Zion-IT.com','XII.\nXIII. Partij II, \"SIDN\"; Stichting Internet Domeinregistratie Nederland, statutair gevestigd te Amsterdam\nXIV. Partijen zijn het volgende overeengekomen:\nXV.\n1. Op dit Registratiecontract zijn de definities zoals neergelegd in artikel 1 van het “Reglement voor registratie van .nl-domeinnamen” van\ntoepassing.\n2. Dit Registratiecontract wordt tussen partijen aangegaan met betrekking tot de aangevraagde domeinnaam.\n3. Domeinnaamaanvrager verklaart kennis te hebben genomen van het “Reglement voor registratie van .nl-domeinnamen” en dit te aanvaarden.\n4. Domeinnaamaanvrager staat ervoor in dat de door hem verstrekte gegevens in dit Registratiecontract juist zijn vermeld en volledig zijn en staat\ner voorts voor in dat hij er zorg voor zal dragen gedurende de periode van geregistreerd zijn van de aangevraagde Domeinnaam wijzigingen in\ndeze gegevens onverwijld via zijn Deelnemer aan SIDN te zullen doorgeven.\n5.1 Domeinnaamaanvrager staat ervoor in gerechtigd te zijn de aangevraagde Domeinnaam te gebruiken.\n5.2 Domeinnaamaanvrager verklaart dat naar zijn beste weten hij door de registratie en (eventueel later) gebruik van de aangevraagde Domeinnaam\ngeen inbreuk maakt op rechten van derden.\n6. Domeinnaamaanvrager zal SIDN steeds onmiddellijk op de hoogte stellen van iedere vordering van een derde dat de registratie en/of het gebruik\nvan de aangevraagde Domeinnaam inbreuk maakt op diens rechten.\n7. Domeinnaamaanvrager aanvaardt dat Nederlands recht van toepassing is op ieder geschil over de aangevraagde Domeinnaam.\n8. Domeinnaamaanvrager verklaart bij voorbaat dat hij zich zal onderwerpen aan het oordeel van het Scheidsgerecht Domeinnamen, indien een\nderde een geschil over de aangevraagde Domeinnaam aan het Scheidsgerecht Domeinnamen voorlegt.\n9. Domeinnaamaanvrager verklaart bij voorbaat dat hij zich zal onderwerpen aan het oordeel van een Nederlandse rechter, indien een derde een\ngerechtelijke procedure aanhangig maakt met betrekking tot een geschil over de aangevraagde Domeinnaam.\n10. Domeinnaamaanvrager vrijwaart SIDN, de bestuursleden van SIDN, het personeel van SIDN en alle Deelnemers terzake van, en zal hen\nschadeloos stellen voor, alle kosten en schade die voor ieder van hen voortvloeien uit een aanspraak van een derde dat de registratie en/of het\ngebruik van de aangevraagde Domeinnaam inbreuk maakt op diens rechten.\n11. Indien de aangevraagde Domeinnaam overeenkomstig de voorgeschreven wijze in het Reglement voor Registratie van .nl-domeinnamen is\naangevraagd, zal SIDN deze in het Register opnemen en opgenomen houden. Nadat de Domeinnaam is opgenomen in het Register, zal SIDN\ndeze opnemen in de .nl-zonefile.\n12. Degene die namens domeinnaamaanvrager dit Registratiecontract ondertekent verklaart dat hij bevoegd is namens de Domeinnaamaanvrager\nde aangevraagde Domeinnaam aan te vragen.\n13. Domeinnaamaanvrager verklaart dat het door hem opgegeven Administratieve Contact hem vertegenwoordigt. Tevens verklaart hij dat\nmededelingen gedaan aan het Administratieve Contact via het Admin-C e-mailadres worden geacht hem te hebben bereikt.\n14. In dit document aangebrachte wijzigingen zijn slechts van kracht als deze door beide partijen expliciet zijn aanvaard.\n15. Dit contract eindigt in de in het Reglement voor registratie beschreven gevallen.','Domeinnaamaanvrager Namens SIDN\nhandtekening ……………………………………handtekening Bart Boswinkel, directeur SIDN\ndatum 04-03-2004……………………………………\nDe gegevens die de domeinnaamaanvrager verstrekt op grond van dit Registratiecontract worden opgenomen in het Domeinnamen- en\nPersoonsdomeinnamenregister (het Register). Conform de Wet bescherming persoonsgegevens is deze verwerking gemeld bij het College\nbescherming persoonsgegevens, en wel onder nummer M1051464. Informatie over deze verwerking, en de overige SIDN privacyregelingen is\nopgenomen op de SIDN homepage onder SIDN en Privacy.\n1 Straat, huisnummer en eventuele toevoegingen\n2 Verplicht ingevolge artikel 3 van het Reglement voor Registratie voor niet in Nederland gevestigden of woonachtigen\n3 Inclusief landnummer\n4 Inclusief landnummer',NULL,NULL); INSERT INTO zh_contracttypes VALUES ('SIDNPS',1,NULL,'%!PS-Adobe-3.0\n%%Title: sidntemplate.rtf\n%%Creator: PScript5.dll Version 5.2\n%%CreationDate: 3/30/2004 23:37:26\n%%For: Administrator\n%%BoundingBox: (atend)\n%%Pages: (atend)\n%%Orientation: Portrait\n%%PageOrder: Special\n%%DocumentNeededResources: (atend)\n%%DocumentSuppliedResources: (atend)\n%%DocumentData: Clean7Bit\n%%TargetDevice: (Color LaserWriter 12/660 PS) (2014.108) 2\n%%LanguageLevel: 2\n%%EndComments\n\n%%BeginDefaults\n%%PageBoundingBox: 15 15 582 819\n%%ViewingOrientation: 1 0 0 1\n%%EndDefaults\n\n\n%%BeginProlog\n%%BeginResource: file Pscript_WinNT_VMErrorHandler 5.0 0\n/currentpacking where{pop/oldpack currentpacking def/setpacking where{pop false\nsetpacking}if}if/$brkpage 64 dict def $brkpage begin/prnt{dup type/stringtype\nne{=string cvs}if dup length 6 mul/tx exch def/ty 10 def currentpoint/toy exch\ndef/tox exch def 1 setgray newpath tox toy 2 sub moveto 0 ty rlineto tx 0\nrlineto 0 ty neg rlineto closepath fill tox toy moveto 0 setgray show}bind def\n/nl{currentpoint exch pop lmargin exch moveto 0 -10 rmoveto}def/=={/cp 0 def\ntypeprint nl}def/typeprint{dup type exec}readonly def/lmargin 72 def/rmargin 72\ndef/tprint{dup length cp add rmargin gt{nl/cp 0 def}if dup length cp add/cp\nexch def prnt}readonly def/cvsprint{=string cvs tprint( )tprint}readonly def\n/integertype{cvsprint}readonly def/realtype{cvsprint}readonly def/booleantype\n{cvsprint}readonly def/operatortype{(--)tprint =string cvs tprint(-- )tprint}\nreadonly def/marktype{pop(-mark- )tprint}readonly def/dicttype{pop\n(-dictionary- )tprint}readonly def/nulltype{pop(-null- )tprint}readonly def\n/filetype{pop(-filestream- )tprint}readonly def/savetype{pop(-savelevel- )\ntprint}readonly def/fonttype{pop(-fontid- )tprint}readonly def/nametype{dup\nxcheck not{(/)tprint}if cvsprint}readonly def/stringtype{dup rcheck{(\\()tprint\ntprint(\\))tprint}{pop(-string- )tprint}ifelse}readonly def/arraytype{dup rcheck\n{dup xcheck{({)tprint{typeprint}forall(})tprint}{([)tprint{typeprint}forall(])\ntprint}ifelse}{pop(-array- )tprint}ifelse}readonly def/packedarraytype{dup\nrcheck{dup xcheck{({)tprint{typeprint}forall(})tprint}{([)tprint{typeprint}\nforall(])tprint}ifelse}{pop(-packedarray- )tprint}ifelse}readonly def/courier\n/Courier findfont 10 scalefont def end errordict/handleerror{systemdict begin\n$error begin $brkpage begin newerror{/newerror false store vmstatus pop pop 0\nne{grestoreall}if initgraphics courier setfont lmargin 720 moveto errorname\n(VMerror)eq{version cvi 2016 ge{userdict/ehsave known{clear userdict/ehsave get\nrestore 2 vmreclaim}if vmstatus exch pop exch pop PrtVMMsg}if}if systemdict\n/showpage get exec(%%[ Error: )print errorname =print(; OffendingCommand: )\nprint/command load =print( ]%%)= flush}if end end end}dup 0 systemdict put dup\n4 $brkpage put bind readonly put/currentpacking where{pop/setpacking where{pop\noldpack setpacking}if}if\n%%EndResource\nuserdict /Pscript_WinNT_Incr 230 dict dup begin put\n%%BeginResource: file Pscript_FatalError 5.0 0\nuserdict begin/FatalErrorIf{{initgraphics findfont 1 index 0 eq{exch pop}{dup\nlength dict begin{1 index/FID ne{def}{pop pop}ifelse}forall/Encoding\n{ISOLatin1Encoding}stopped{StandardEncoding}if def currentdict end\n/ErrFont-Latin1 exch definefont}ifelse exch scalefont setfont counttomark 3 div\ncvi{moveto show}repeat showpage quit}{cleartomark}ifelse}bind def end\n%%EndResource\nuserdict begin/PrtVMMsg{vmstatus exch sub exch pop gt{[\n(This job requires more memory than is available in this printer.)100 500\n(Try one or more of the following, and then print again:)100 485\n(For the output format, choose Optimize For Portability.)115 470\n(In the Device Settings page, make sure the Available PostScript Memory is accurate.)\n115 455(Reduce the number of fonts in the document.)115 440\n(Print the document in parts.)115 425 12/Times-Roman showpage\n(%%[ PrinterError: Low Printer VM ]%%)= true FatalErrorIf}if}bind def end\nversion cvi 2016 ge{/VM?{pop}bind def}{/VM? userdict/PrtVMMsg get def}ifelse\n105000 VM?\n%%BeginResource: file Pscript_Win_Basic 5.0 0\n/d/def load def/,/load load d/~/exch , d/?/ifelse , d/!/pop , d/`/begin , d/^\n/index , d/@/dup , d/+/translate , d/$/roll , d/U/userdict , d/M/moveto , d/-\n/rlineto , d/&/currentdict , d/:/gsave , d/;/grestore , d/F/false , d/T/true ,\nd/N/newpath , d/E/end , d/Ac/arc , d/An/arcn , d/A/ashow , d/D/awidthshow , d/C\n/closepath , d/V/div , d/O/eofill , d/L/fill , d/I/lineto , d/-c/curveto , d/-M\n/rmoveto , d/+S/scale , d/Ji/setfont , d/Lc/setlinecap , d/Lj/setlinejoin , d\n/Lw/setlinewidth , d/Lm/setmiterlimit , d/sd/setdash , d/S/show , d/LH/showpage\n, d/K/stroke , d/W/widthshow , d/R/rotate , d/L2? false/languagelevel where{pop\nlanguagelevel 2 ge{pop true}if}if d L2?{/xS/xshow , d/yS/yshow , d/zS/xyshow ,\nd}if/b{bind d}bind d/bd{bind d}bind d/xd{~ d}bd/ld{, d}bd/bn/bind ld/lw/Lw ld\n/lc/Lc ld/lj/Lj ld/sg/setgray ld/ADO_mxRot null d/self & d/OrgMx matrix\ncurrentmatrix d/reinitialize{: OrgMx setmatrix[/TextInit/GraphInit/UtilsInit\ncounttomark{@ where{self eq}{F}?{cvx exec}{!}?}repeat cleartomark ;}b\n/initialize{`{/Pscript_Win_Data where{!}{U/Pscript_Win_Data & put}?/ADO_mxRot ~\nd/TextInitialised? F d reinitialize E}{U/Pscript_Win_Data 230 dict @ ` put\n/ADO_mxRot ~ d/TextInitialised? F d reinitialize}?}b/terminate{!{& self eq\n{exit}{E}?}loop E}b/suspend/terminate , d/resume{` Pscript_Win_Data `}b U `\n/lucas 21690 d/featurebegin{countdictstack lucas[}b/featurecleanup{stopped\n{cleartomark @ lucas eq{! exit}if}loop countdictstack ~ sub @ 0 gt{{E}repeat}\n{!}?}b E/snap{transform 0.25 sub round 0.25 add ~ 0.25 sub round 0.25 add ~\nitransform}b/dsnap{dtransform round ~ round ~ idtransform}b/nonzero_round{@ 0.5\nge{round}{@ -0.5 lt{round}{0 ge{1}{-1}?}?}?}b/nonzero_dsnap{dtransform\nnonzero_round ~ nonzero_round ~ idtransform}b U<04>cvn{}put/rr{1 ^ 0 - 0 ~ -\nneg 0 - C}b/irp{4 -2 $ + +S fx 4 2 $ M 1 ^ 0 - 0 ~ - neg 0 -}b/rp{4 2 $ M 1 ^ 0\n- 0 ~ - neg 0 -}b/solid{[]0 sd}b/g{@ not{U/DefIf_save save put}if U/DefIf_bool\n2 ^ put}b/DefIf_El{if U/DefIf_bool get not @{U/DefIf_save get restore}if}b/e\n{DefIf_El !}b/UDF{L2?{undefinefont}{!}?}b/UDR{L2?{undefineresource}{! !}?}b\n/freeVM{/Courier findfont[40 0 0 -40 0 0]makefont Ji 2 vmreclaim}b/hfRedefFont\n{findfont @ length dict `{1 ^/FID ne{d}{! !}?}forall & E @ ` ~{/CharStrings 1\ndict `/.notdef 0 d & E d}if/Encoding 256 array 0 1 255{1 ^ ~/.notdef put}for d\nE definefont !}bind d/hfMkCIDFont{/CIDFont findresource @ length 2 add dict `{1\n^ @/FID eq ~ @/XUID eq ~/UIDBase eq or or{! !}{d}?}forall/CDevProc ~ d/Metrics2\n16 dict d/CIDFontName 1 ^ d & E 1 ^ ~/CIDFont defineresource ![~]composefont !}\nbind d\n%%EndResource\n%%BeginResource: file Pscript_Win_Utils_L2 5.0 0\n/rf/rectfill , d/fx{1 1 dtransform @ 0 ge{1 sub 0.5}{1 add -0.5}? 3 -1 $ @ 0 ge\n{1 sub 0.5}{1 add -0.5}? 3 1 $ 4 1 $ idtransform 4 -2 $ idtransform}b/BZ{4 -2 $\nsnap + +S fx rf}b/rs/rectstroke , d/rc/rectclip , d/UtilsInit{currentglobal{F\nsetglobal}if}b/scol{! setcolor}b/colspA/DeviceGray d/colspABC/DeviceRGB d\n/colspRefresh{colspABC setcolorspace}b/SetColSpace{colspABC setcolorspace}b\n/resourcestatus where{!/ColorRendering/ProcSet resourcestatus{! ! T}{F}?}{F}?\nnot{/ColorRendering<>/defineresource where{!/ProcSet\ndefineresource !}{! !}?}if/buildcrdname{/ColorRendering/ProcSet findresource `\nmark GetHalftoneName @ type @/nametype ne ~/stringtype ne and{!/none}if(.)\nGetPageDeviceName @ type @/nametype ne ~/stringtype ne and{!/none}if(.)5 ^ 0 5\n-1 1{^ length add}for string 6 1 $ 5 ^ 5{~ 1 ^ cvs length 1 ^ length 1 ^ sub\ngetinterval}repeat ! cvn 3 1 $ ! ! E}b/definecolorrendering{~ buildcrdname ~\n/ColorRendering defineresource !}b/findcolorrendering where{!}{\n/findcolorrendering{buildcrdname @/ColorRendering resourcestatus{! ! T}{\n/ColorRendering/ProcSet findresource ` GetSubstituteCRD E F}?}b}?\n/selectcolorrendering{findcolorrendering !/ColorRendering findresource\nsetcolorrendering}b/G2UBegin{findresource/FontInfo get/GlyphNames2Unicode get\n`}bind d/G2CCBegin{findresource/FontInfo get/GlyphNames2HostCode get `}bind d\n/G2UEnd{E}bind d/AddFontInfoBegin{/FontInfo 8 dict @ `}bind d/AddFontInfo{\n/GlyphNames2Unicode 16 dict d/GlyphNames2HostCode 16 dict d}bind d\n/AddFontInfoEnd{E d}bind d/T0AddCFFMtx2{/CIDFont findresource/Metrics2 get ` d\nE}bind d\n%%EndResource\nend\n%%EndProlog\n\n%%BeginSetup\nstatusdict begin (%%[ ProductName: ) print product print ( ]%%)= flush end\n[ 1 0 0 1 0 0 ] false Pscript_WinNT_Incr dup /initialize get exec\nfeaturebegin{\n%%BeginNonPPDFeature: JobTimeout 0\n0 /languagelevel where{pop languagelevel}{1}ifelse 2 ge{1 dict dup/JobTimeout 4 -1 roll put setuserparams}{statusdict/setjobtimeout get exec}ifelse\n%%EndNonPPDFeature\n}featurecleanup\n\nfeaturebegin{\n%%BeginNonPPDFeature: WaitTimeout 300\n300 /languagelevel where{pop languagelevel}{1}ifelse 2 ge{1 dict dup/WaitTimeout 4 -1 roll put setuserparams}{statusdict/waittimeout 3 -1 roll put}ifelse\n%%EndNonPPDFeature\n}featurecleanup\n\nfeaturebegin{\n%%BeginFeature: *TraySwitch False\n1 dict dup /TraySwitch false put setpagedevice\n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *OutputMode Best\n\n 1 dict dup /PostRenderingEnhanceDetails \n 2 dict dup /Type 19 put dup /OutputMode /Best put put\n setpagedevice \n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *PageSize A4\n\n 2 dict dup /PageSize [595 842] put dup /ImagingBBox null put setpagedevice\n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *MediaType Plain\n\n 2 dict\n dup /MediaType (Plain) put\n dup /InputAttributes mark\n currentpagedevice /InputAttributes get\n {\n dup type /dicttype eq {\n dup length 1 add dict begin {def} forall\n /MediaType (Plain) def\n currentdict end\n } if\n } forall\n counttomark 2 idiv dup dict begin {def} repeat\n pop currentdict end\n put\n setpagedevice\n\n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *OutputBin OnlyOne\n\n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *InstalledMemory 16Meg\n\n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *OptionalCassette1 False\n\n%%EndFeature\n}featurecleanup\nfeaturebegin{\n%%BeginFeature: *Resolution 600dpi\n\n%%EndFeature\n}featurecleanup\n1 setlinecap 1 setlinejoin\n/mysetup [ 72 600 V 0 0 -72 600 V 15.00094 819 ] def \n%%EndSetup\n\nuserdict begin /ehsave save def end\n%%Page: 1 1\n%%PageBoundingBox: 15 15 582 819\n%%EndPageComments\n%%BeginPageSetup\n/DeviceRGB dup setcolorspace /colspABC exch def\nmysetup concat colspRefresh\n%%EndPageSetup\n\n0 0 0 1 scol Pscript_WinNT_Incr begin\n%%BeginResource: file Pscript_Text 5.0 0\n/TextInit{TextInitialised? not{/Pscript_Windows_Font & d/TextInitialised? T d\n/fM[1 0 0 1 0 0]d/mFM matrix d/iMat[1 0 0.212557 1 0 0]d}if}b/copyfont{1 ^\nlength add dict `{1 ^/FID ne{d}{! !}?}forall & E}b/EncodeDict 11 dict d/bullets\n{{/bullet}repeat}b/rF{3 copyfont @ ` ~ EncodeDict ~ get/Encoding ~ 3 ^/0 eq{&\n/CharStrings known{CharStrings/Eth known not{! EncodeDict/ANSIEncodingOld get}\nif}if}if d E}b/mF{@ 7 1 $ findfont ~{@/Encoding get @ StandardEncoding eq{! T}{\n{ISOLatin1Encoding}stopped{! F}{eq}?{T}{@ ` T 32 1 127{Encoding 1 ^ get\nStandardEncoding 3 -1 $ get eq and}for E}?}?}{F}?{1 ^ ~ rF}{0 copyfont}? 6 -2 $\n! ! ~ !/pd_charset @ where{~ get 128 eq{@ FDV 2 copy get @ length array copy\nput pd_CoverFCRange}if}{!}? 2 ^ ~ definefont fM 5 4 -1 $ put fM 4 0 put fM\nmakefont Pscript_Windows_Font 3 1 $ put}b/sLT{: Lw -M currentpoint snap M 0 - 0\nLc K ;}b/xUP null d/yUP null d/uW null d/xSP null d/ySP null d/sW null d/sSU{N\n/uW ~ d/yUP ~ d/xUP ~ d}b/sU{xUP yUP uW sLT}b/sST{N/sW ~ d/ySP ~ d/xSP ~ d}b/sT\n{xSP ySP sW sLT}b/sR{: + R 0 0 M}b/sRxy{: matrix astore concat 0 0 M}b/eR/; , d\n/AddOrigFP{{&/FontInfo known{&/FontInfo get length 6 add}{6}? dict `\n/WinPitchAndFamily ~ d/WinCharSet ~ d/OrigFontType ~ d/OrigFontStyle ~ d\n/OrigFontName ~ d & E/FontInfo ~ d}{! ! ! ! !}?}b/mFS{makefont\nPscript_Windows_Font 3 1 $ put}b/mF42D{0 copyfont `/FontName ~ d 2 copy ~ sub 1\nadd dict `/.notdef 0 d 2 copy 1 ~{@ 3 ^ sub Encoding ~ get ~ d}for & E\n/CharStrings ~ d ! ! & @ E/FontName get ~ definefont}b/mF42{15 dict ` @ 4 1 $\nFontName ~ d/FontType 0 d/FMapType 2 d/FontMatrix[1 0 0 1 0 0]d 1 ^ 254 add 255\nidiv @ array/Encoding ~ d 0 1 3 -1 $ 1 sub{@ Encoding 3 1 $ put}for/FDepVector\nEncoding length array d/CharStrings 2 dict `/.notdef 0 d & E d 0 1 Encoding\nlength 1 sub{@ @ 10 lt{! FontName length 1 add string}{100 lt{FontName length 2\nadd string}{FontName length 3 add string}?}? @ 0 FontName @ length string cvs\nputinterval @ 3 -1 $ @ 4 1 $ 3 string cvs FontName length ~ putinterval cvn 1 ^\n256 mul @ 255 add 3 -1 $ 4 ^ findfont mF42D FDepVector 3 1 $ put}for & @ E\n/FontName get ~ definefont ! ! ! mF}b/mF_OTF_V{~ ! ~ ! 4 -1 $ ! findfont 2 ^ ~\ndefinefont fM @ @ 4 6 -1 $ neg put 5 0 put 90 matrix R matrix concatmatrix\nmakefont Pscript_Windows_Font 3 1 $ put}b/mF_TTF_V{3{~ !}repeat 3 -1 $ !\nfindfont 1 ^ ~ definefont Pscript_Windows_Font 3 1 $ put}b/UmF{L2?\n{Pscript_Windows_Font ~ undef}{!}?}b/UmF42{@ findfont/FDepVector get{/FontName\nget undefinefont}forall undefinefont}b\n%%EndResource\nend reinitialize\nPscript_WinNT_Incr begin\n%%BeginResource: file Pscript_Encoding256 5.0 0\n/CharCol256Encoding[/.notdef/breve/caron/dotaccent/dotlessi/fi/fl/fraction\n/hungarumlaut/Lslash/lslash/minus/ogonek/ring/Zcaron/zcaron/.notdef/.notdef\n/.notdef/.notdef/.notdef/.notdef/.notdef/.notdef/.notdef/.notdef/.notdef\n/.notdef/.notdef/.notdef/.notdef/.notdef/space/exclam/quotedbl/numbersign\n/dollar/percent/ampersand/quotesingle/parenleft/parenright/asterisk/plus/comma\n/hyphen/period/slash/zero/one/two/three/four/five/six/seven/eight/nine/colon\n/semicolon/less/equal/greater/question/at/A/B/C/D/E/F/G/H/I/J/K/L/M/N/O/P/Q/R/S\n/T/U/V/W/X/Y/Z/bracketleft/backslash/bracketright/asciicircum/underscore/grave\n/a/b/c/d/e/f/g/h/i/j/k/l/m/n/o/p/q/r/s/t/u/v/w/x/y/z/braceleft/bar/braceright\n/asciitilde/.notdef/Euro/.notdef/quotesinglbase/florin/quotedblbase/ellipsis\n/dagger/daggerdbl/circumflex/perthousand/Scaron/guilsinglleft/OE/.notdef\n/.notdef/.notdef/.notdef/quoteleft/quoteright/quotedblleft/quotedblright/bullet\n/endash/emdash/tilde/trademark/scaron/guilsinglright/oe/.notdef/.notdef\n/Ydieresis/.notdef/exclamdown/cent/sterling/currency/yen/brokenbar/section\n/dieresis/copyright/ordfeminine/guillemotleft/logicalnot/.notdef/registered\n/macron/degree/plusminus/twosuperior/threesuperior/acute/mu/paragraph\n/periodcentered/cedilla/onesuperior/ordmasculine/guillemotright/onequarter\n/onehalf/threequarters/questiondown/Agrave/Aacute/Acircumflex/Atilde/Adieresis\n/Aring/AE/Ccedilla/Egrave/Eacute/Ecircumflex/Edieresis/Igrave/Iacute\n/Icircumflex/Idieresis/Eth/Ntilde/Ograve/Oacute/Ocircumflex/Otilde/Odieresis\n/multiply/Oslash/Ugrave/Uacute/Ucircumflex/Udieresis/Yacute/Thorn/germandbls\n/agrave/aacute/acircumflex/atilde/adieresis/aring/ae/ccedilla/egrave/eacute\n/ecircumflex/edieresis/igrave/iacute/icircumflex/idieresis/eth/ntilde/ograve\n/oacute/ocircumflex/otilde/odieresis/divide/oslash/ugrave/uacute/ucircumflex\n/udieresis/yacute/thorn/ydieresis]def EncodeDict/256 CharCol256Encoding put\n%%EndResource\nend reinitialize\n\n%%IncludeResource: font Helvetica-Bold\nPscript_WinNT_Incr begin\n%%BeginResource: file Pscript_Win_Euro_L2 5.0 0\n/UseT3EuroFont{/currentdistillerparams where{pop currentdistillerparams\n/CoreDistVersion get 4000 le}{false}ifelse}bind def/NewEuroT3Font?{dup/FontType\nget 3 eq{dup/EuroFont known exch/BaseFont known and}{pop false}ifelse}bind def\n/T1FontHasEuro{dup/CharStrings known not{dup NewEuroT3Font?{dup/EuroGlyphName\nget exch/EuroFont get/CharStrings get exch known{true}{false}ifelse}{pop false}\nifelse}{dup/FontType get 1 eq{/CharStrings get/Euro known}{dup/InfoDict known{\n/InfoDict get/Euro known}{/CharStrings get/Euro known}ifelse}ifelse}ifelse}bind\ndef/FontHasEuro{findfont dup/Blend known{pop true}{T1FontHasEuro}ifelse}bind\ndef/EuroEncodingIdx 1 def/EuroFontHdr{12 dict begin/FontInfo 10 dict dup begin\n/version(001.000)readonly def/Notice(Copyright (c)1999 Adobe Systems\nIncorporated. All Rights Reserved.)readonly def/FullName(Euro)readonly def\n/FamilyName(Euro)readonly def/Weight(Regular)readonly def/isFixedPitch false\ndef/ItalicAngle 0 def/UnderlinePosition -100 def/UnderlineThickness 50 def end\nreadonly def/FontName/Euro def/Encoding 256 array 0 1 255{1 index exch/.notdef\nput}for def/PaintType 0 def/FontType 1 def/FontMatrix[0.001 0 0 0.001 0 0]def\n/FontBBox{-25 -23 1500 804}readonly def currentdict end dup/Private 20 dict dup\nbegin/ND{def}def/NP{put}def/lenIV -1 def/RD{string currentfile exch\nreadhexstring pop}def/-|{string currentfile exch readstring pop}executeonly def\n/|-{def}executeonly def/|{put}executeonly def/BlueValues[-20 0 706 736 547 572]\n|-/OtherBlues[-211 -203]|-/BlueScale 0.0312917 def/MinFeature{16 16}|-/StdHW\n[60]|-/StdVW[71]|-/ForceBold false def/password 5839 def/Erode{8.5 dup 3 -1\nroll 0.1 mul exch 0.5 sub mul cvi sub dup mul 71 0 dtransform dup mul exch dup\nmul add le{pop pop 1.0 1.0}{pop pop 0.0 1.5}ifelse}def/OtherSubrs[{}{}{}\n{systemdict/internaldict known not{pop 3}{1183615869 systemdict/internaldict\nget exec dup/startlock known{/startlock get exec}{dup/strtlck known{/strtlck\nget exec}{pop 3}ifelse}ifelse}ifelse}executeonly]|-/Subrs 5 array dup 0\n<8E8B0C100C110C110C210B>put dup 1<8B8C0C100B>put dup 2<8B8D0C100B>put dup 3<0B>\nput dup 4<8E8C8E0C100C110A0B>put |- 2 index/CharStrings 256 dict dup begin\n/.notdef<8b8b0d0e>def end end put put dup/FontName get exch definefont pop}bind\ndef/AddEuroGlyph{2 index exch EuroEncodingIdx 1 eq{EuroFontHdr}if systemdict\nbegin/Euro findfont dup dup/Encoding get 5 1 roll/Private get begin/CharStrings\nget dup 3 index known{pop pop pop pop end end}{begin 1 index exch def end end\nend EuroEncodingIdx dup 1 add/EuroEncodingIdx exch def exch put}ifelse}bind def\n/GetNewXUID{currentdict/XUID known{[7 XUID aload pop]true}{currentdict/UniqueID\nknown{[7 UniqueID]true}{false}ifelse}ifelse}bind def/BuildT3EuroFont{exch 16\ndict begin dup/FontName exch def findfont dup/Encoding get/Encoding exch def\ndup length 1 add dict copy dup/FID undef begin dup dup/FontName exch def\n/Encoding 256 array 0 1 255{1 index exch/.notdef put}for def GetNewXUID{/XUID\nexch def}if currentdict end definefont pop/BaseFont exch findfont 1000\nscalefont def/EuroFont exch findfont 1000 scalefont def pop/EuroGlyphName exch\ndef/FontType 3 def/FontMatrix[.001 0 0 .001 0 0]def/FontBBox BaseFont/FontBBox\nget def/Char 1 string def/BuildChar{exch dup begin/Encoding get 1 index get\n/Euro eq{BaseFont T1FontHasEuro{false}{true}ifelse}{false}ifelse{EuroFont\nsetfont pop userdict/Idx 0 put EuroFont/Encoding get{EuroGlyphName eq{exit}\n{userdict/Idx Idx 1 add put}ifelse}forall userdict/Idx get}{dup dup Encoding\nexch get BaseFont/Encoding get 3 1 roll put BaseFont setfont}ifelse Char 0 3 -1\nroll put Char stringwidth newpath 0 0 moveto Char true charpath flattenpath\npathbbox setcachedevice 0 0 moveto Char show end}bind def currentdict end dup\n/FontName get exch definefont pop}bind def/AddEuroToT1Font{dup findfont dup\nlength 10 add dict copy dup/FID undef begin/EuroFont 3 -1 roll findfont 1000\nscalefont def CharStrings dup length 1 add dict copy begin/Euro{EuroFont\nsetfont pop EuroGBBox aload pop setcachedevice 0 0 moveto EuroGName glyphshow}\nbind def currentdict end/CharStrings exch def GetNewXUID{/XUID exch def}if 3 1\nroll/EuroGBBox exch def/EuroGName exch def currentdict end definefont pop}bind\ndef/BuildNewFont{UseT3EuroFont{BuildT3EuroFont}{pop AddEuroToT1Font}ifelse}bind\ndef/UseObliqueEuro{findfont/FontMatrix get dup 2 get 0 eq exch dup 0 get exch 3\nget eq and UseT3EuroFont or}bind def\n%%EndResource\nend reinitialize\n7500 VM?\n/Helvetica-Bold FontHasEuro not\n{\n/Euro.Helvetica-Bold\n [556 0 12 -19 563 710 ] \n<97F8C00DDBF7240378F70401F774EA01F803EA01F8EAF70401F8BBF9011571B141BE278B\n08FB278B303173FB32085906642C05DB0676078B828C828B82086206632C05E506A8FB3A\nEC3EF71B8B08C18BC192B9A908F71407676C54754C8B083B8B6ED483C508F72C06B3EA05\nFB5E06BB07F77106B3EA05FB91069AE5B2B9CC8B08C98BB26FA17408A07691828F830809\n0E>\nAddEuroGlyph\n/Euro /Helvetica-Bold /Helvetica-Bold-Copy BuildNewFont\n} if\nF /F0 0 /256 T /Helvetica-Bold mF \n/F0S64 F0 [100 0 0 -100 0 0 ] mFS\nF0S64 Ji \n111 206 M (Registratiecontract .nl-domeinnaam)[72 56 61 28 56 33 39 56 33 28 56 56 61 61 33 39 56 56 33 28 28 61 28 33 61 61 89 56 28 61 61 56\n56 0]xS \nPscript_WinNT_Incr begin\n%%BeginResource: file Pscript_Win_Dib_L2 5.0 0\n/iw 0 d/ih 0 d/im_save 0 d/s 0 d/polarity 0 d/smoothflag 0 d/mystring 0 d/bpc 0\nd/maskcolor 0 d/mask? F d/setup1asciiproc{[currentfile mystring/readhexstring\ncvx/! cvx]cvx bind}b/setup1binaryproc{[currentfile mystring/readstring cvx/!\ncvx]cvx bind}b/setup2asciiproc{currentfile/ASCII85Decode filter/RunLengthDecode\nfilter}b/setup2binaryproc{currentfile/RunLengthDecode filter}b/jpegasciiproc\n{currentfile/ASCII85Decode filter<>/DCTDecode filter}b/jpegbinaryproc\n{currentfile<>/DCTDecode filter}b/mycolorspace{colspABC}d/myimagedict\n{/myimagedict 10 dict d myimagedict @ `/ImageType 1 d/MultipleDataSource F d E}\nb/imageprocarray[/setup1binaryproc/setup1asciiproc/setup2binaryproc\n/setup2asciiproc/setup1binarydecodeproc/setup1asciidecodeproc]d/jpegprocarray[\n/jpegasciiproc/jpegbinaryproc]d/Q{/im_save save d scol imageprocarray ~ get/s ~\n, d/polarity ~ d/smoothflag ~ d +/dx 2 ^ d/dy 1 ^ d +S/mystring ~ string d/bpc\n~ d/ih ~ d/iw ~ d fx rf}b/X{/im_save save d/mask? ~ d/maskcolor ~ d\nimageprocarray ~ get/s ~ , d/polarity ~ d/smoothflag ~ d +/dx 2 ^ d/dy 1 ^ d +S\n/mystring ~ string d/bpc ~ d/ih ~ d/iw ~ d}b/Z{im_save restore}b/beginjpeg{\n/jpeg_save save d jpegprocarray ~ get/jpegimageproc ~ , d + +S/bpc ~ d/ih ~ d\n/iw ~ d bpc 24 eq{/DeviceRGB}{/DeviceGray}? setcolorspace myimagedict @ `\n/ImageType 1 d/Width iw d/Height ih d/Decode bpc 24 eq{[0 1 0 1 0 1]}{[0 1]}? d\n/ImageMatrix[iw 0 0 ih 0 0]d/BitsPerComponent 8 d/DataSource jpegimageproc d E\nimage}b/endjpeg{jpeg_save restore}b/Y{scol myimagedict @ ` mask?{/polarity\nmaskcolor 0 get 0 eq{T}{F}? d}if/Width iw d/Height ih d/Decode polarity{[1 0]}{\n[0 1]}? d/ImageMatrix[iw 0 0 ih 0 0]d/DataSource s d/BitsPerComponent 1 d\n/Interpolate smoothflag d E imagemask}bd/doclutimage{/rgbclut ~ d bpc @ 8 eq{!\n255}{@ 4 eq{! 15}{2 eq{3}{1}?}?}?/hival ~ d[/Indexed currentcolorspace hival\nrgbclut]setcolorspace myimagedict @ ` mask?{/ImageType 4 d/MaskColor maskcolor\nd}if/Width iw d/Height ih d/Decode[0 hival]d/ImageMatrix[iw 0 0 ih 0 0]d\n/DataSource s d/BitsPerComponent bpc d/Interpolate smoothflag d E image}b\n/doCMYKclutimage{/CMYKclut ~ d bpc @ 8 eq{! 255}{4 eq{15}{3}?}?/hival ~ d[\n/Indexed/DeviceCMYK hival CMYKclut]setcolorspace myimagedict @ ` mask?{\n/ImageType 4 d/MaskColor maskcolor d}if/Width iw d/Height ih d/Decode[0 hival]d\n/ImageMatrix[iw 0 0 ih 0 0]d/DataSource s d/BitsPerComponent bpc d/Interpolate\nsmoothflag d E image}b/doNimage{bpc 24 eq{currentcolorspace}{colspA}?\nsetcolorspace myimagedict @ ` mask?{/ImageType 4 d/MaskColor maskcolor d}if\n/Width iw d/Height ih d/Decode bpc 24 eq{[0 1 0 1 0 1]}{[0 1]}? d/ImageMatrix\n[iw 0 0 ih 0 0]d/DataSource s d/BitsPerComponent bpc 24 eq{8}{bpc}? d\n/Interpolate smoothflag d E image}b/doCMYKimage{/DeviceCMYK setcolorspace\nmyimagedict @ ` mask?{/ImageType 4 d/MaskColor maskcolor d}if/Width iw d/Height\nih d/Decode[0 1 0 1 0 1 0 1]d/ImageMatrix[iw 0 0 ih 0 0]d/DataSource s d\n/BitsPerComponent 8 d/Interpolate smoothflag d E image}b\n%%EndResource\nend reinitialize\n: 38 29 24 114 211 162 3946 44 F F 3 [ 0 0 0 ] F \nX\ndoNimage\n\"8)Wmo)J^iq#C?pnb)n]1B%7Jj8\\Sjs7sn=o?.+%_Z0#/s6-?[oW%rYWW2A!s7ak>psB\'>h#I<=\nr9i\\HrUg-hs8*&ss#rSQ(DKUD!X(Ip&hs7`rrW)tl2UbelMpk`q=ajg!<2Ng!W2osq?-cps8N&u\n!<)rt2\"To1r8I\\Qe#nO5^QEHHL1J8bB\"j.)\\qs2$Qsn75HE)^3ViPW\"U4hmgc2[_6s8)9RlKSs8CjTm+;:6kl:M=s7+nEr:Bsao`+mas8N<%rr)llq>^I8!)NUp\">Am\"\nrqufr!ri5es8NAls8)c`lM1DYnc\'[1pXfH6eGo7&a.8!nM.HY]bl@L_s7tFLp@@nEpAFsj)X[4m\nqu?N^oBQATs7>OAs8;HfrUKOGk5YDWs8N5um-a9?(%Ltsq#C?oo`+q\"%iIJN+$C,G-2dcBqu?Zuj6Q+-s8N)o\ns8Ni>%jVMp/,B2Eq#16js82H_m/?qZs7u]p!;uls!<)Hf$Gi$Bs5q2up[%qUs7ufhpAFsj!;HNn\n!:p0i\"TerR-S%af!\"T\\P$lT*Es/W-%&Iorj\"ss9P#:L#m0*2@sp](6nq#C@&o_ngSo)B(2-jL2+\nq>^HppAb$lqZ$?jrrDinrrN,qs8N)ss8N)unc\'?1RXG/)g&Lj;s6JqLqt0peo_\\R\\q>^Hpo`+q-\nh!4nH(H2[4-=U@m*>/on9N(oZrs]2brr<0J%i-Vgs8N2mrr;`mrs?WdhujB2$kXc[s8N)rs8N9!\ns7lQlq>^\'jpAb\'jrV?Kn!<2Ng&[\\\'Ys7kURp[S:XoDe41c?9aD:TpAb-mp](7%o_e^h\"WnEs1]RUnqu?[\"n+?,Is7lWo#lXf&s82Qj\nrqcZp!<2Ng&Zg^qs7b7IkM6+1nGi:Os8;EerrMols8NPopAY*u0*N\"I!!4)1p](6nrr;uuqZ$RA\no)B:34TGL6lLFo;nFuAFs7uZo#7;me%P&bN2u*@OoD%nSs7lQm#6+YmnG*%_mf+i[RVr/f`W,So\ns7Z*bqY\'sgq!7>4pAP$crr3BA2@:*O%2C;_r;ZWms5rMBs5!bUrt,B$!!+YHs8N)ps8N)ps8N/[\njSAfn!\'U>i\">009s8;os\"oeQ!o_7kRrs&K&q\"OaerpKdss6mbBQZ`>tkl9u=oBu8Js8N)ns8N)l\ns8NMnnc&Ri)Aa5?oC`.Zs8N)ls8N)gs8NK.%QXk\'4q\\PkpA4gds8N/oqZ$T8\'Aa?53\"HHTr;HZ`\nn+6PYqtg9brrUs8N<\"r:g3jqYpNp#k[fc\nrr;rrs82ir!<)Kg&,c+h*\"s#,\'dOG$*p)DKrrb6a(C^KNhUBgGmcFKHoDe[W#Qk&@&f(?Err_]^rV$9k!;-L?hr;Zff\n!;-^?ls8Md$qtKa_rVHQmqt9LKrr2urs8N,nq>^H`s#KZ<\nli6t\\s8DZkq!\\7[mJm(Ks7YHGL2j/OGlHgPs8(sZqs=@WlMpeRs7l-ar:^\'ep&+jdnbVqRs8N)l\ns8N)ns8N)ls8N/ip%\\Re$iU,)qu?Tjs8;corVum#rVuQ_r;Zcas$-DWq#C?js8)B^mH\"Nr;ZWjs8DZkr:Kj\\o_.nVrt,&,rqQNmq#C*\\q=XIWq#1-j\nrrDusrrE&frrDoqrr_rir;Q`r0DkV@s8Mlpqt0pZl2U\\Ms7>@Pqs=@XkPtDCWg/7BS;[FAk5Y)7\ns8D#ds8N)qs8N<#rr)Wlr:Bsg\"8)WjnGiLkp&>!gq>^Hpp](6qoD\\dfr;ZQkrr2ums8N)ns8N)o\ns8N)os8N)rs8N)sqYrAMs8MlprqQNioDea[s8;Kgr:0gZl29i\'[@WK.\\uttri;`WCs8D`mrqcZk\npAXmZs8MZjrrDZjrrDQgrrDZjrsSPprqH\'br:Bsequ?8ls8DZk\nq!S1Vkl:MDs8MHdrs\\Jrs7H3gqYUURVp?;PQl2U\"u\na/k]AVNLE(bQ%7us8;Kdq\"=X_rqucoqu-~> Z\n; Pscript_WinNT_Incr begin\n%%BeginResource: file Pscript_Win_GdiObject 5.0 0\n/SavedCTM null d/CTMsave{/SavedCTM SavedCTM currentmatrix d}b/CTMrestore\n{SavedCTM setmatrix}b/mp null d/ADO_mxRot null d/GDIHMatrix null d\n/GDIHPatternDict 22 dict d GDIHPatternDict `/PatternType 1 d/PaintType 2 d/Reps\nL2?{1}{5}? d/XStep 8 Reps mul d/YStep XStep d/BBox[0 0 XStep YStep]d/TilingType\n1 d/PaintProc{` 1 Lw[]0 sd PaintData , exec E}b/FGnd null d/BGnd null d\n/HS_Horizontal{horiz}b/HS_Vertical{vert}b/HS_FDiagonal{fdiag}b/HS_BDiagonal\n{biag}b/HS_Cross{horiz vert}b/HS_DiagCross{fdiag biag}b/MaxXYStep XStep YStep\ngt{XStep}{YStep}? d/horiz{Reps{0 4 M XStep 0 - 0 8 +}repeat 0 -8 Reps mul + K}b\n/vert{Reps{4 0 M 0 YStep - 8 0 +}repeat 0 -8 Reps mul + K}b/biag{Reps{0 0 M\nMaxXYStep @ - 0 YStep neg M MaxXYStep @ - 0 8 +}repeat 0 -8 Reps mul + 0 YStep\nM 8 8 - K}b/fdiag{Reps{0 0 M MaxXYStep @ neg - 0 YStep M MaxXYStep @ neg - 0 8\n+}repeat 0 -8 Reps mul + MaxXYStep @ M 8 -8 - K}b E/makehatch{4 -2 $/yOrg ~ d\n/xOrg ~ d GDIHPatternDict/PaintData 3 -1 $ put CTMsave GDIHMatrix setmatrix\nGDIHPatternDict matrix xOrg yOrg + mp CTMrestore ~ U ~ 2 ^ put}b/h0{/h0\n/HS_Horizontal makehatch}b/h1{/h1/HS_Vertical makehatch}b/h2{/h2/HS_FDiagonal\nmakehatch}b/h3{/h3/HS_BDiagonal makehatch}b/h4{/h4/HS_Cross makehatch}b/h5{/h5\n/HS_DiagCross makehatch}b/GDIBWPatternMx null d/pfprep{save 8 1 $\n/PatternOfTheDay 8 1 $ GDIBWPatternDict `/yOrg ~ d/xOrg ~ d/PaintData ~ d/yExt\n~ d/Width ~ d/BGnd ~ d/FGnd ~ d/Height yExt RepsV mul d/mx[Width 0 0 Height 0\n0]d E build_pattern ~ !}b/pfbf{/fEOFill ~ d pfprep hbf fEOFill{O}{L}? restore}b\n/GraphInit{GDIHMatrix null eq{/SavedCTM matrix d : ADO_mxRot concat 0 0 snap +\n: 0.48 @ GDIHPatternDict ` YStep mul ~ XStep mul ~ nonzero_dsnap YStep V ~\nXStep V ~ E +S/GDIHMatrix matrix currentmatrix readonly d ; : 0.24 -0.24 +S\nGDIBWPatternDict ` Width Height E nonzero_dsnap +S/GDIBWPatternMx matrix\ncurrentmatrix readonly d ; ;}if}b\n%%EndResource\n%%BeginResource: file Pscript_Win_GdiObject_L2 5.0 0\n/GDIBWPatternDict 25 dict @ `/PatternType 1 d/PaintType 1 d/RepsV 1 d/RepsH 1 d\n/BBox[0 0 RepsH 1]d/TilingType 1 d/XStep 1 d/YStep 1 d/Height 8 RepsV mul d\n/Width 8 d/mx[Width 0 0 Height neg 0 Height]d/FGnd null d/BGnd null d\n/SetBGndFGnd{BGnd null ne{BGnd aload ! scol BBox aload ! 2 ^ sub ~ 3 ^ sub ~\nrf}if FGnd null ne{FGnd aload ! scol}if}b/PaintProc{` SetBGndFGnd RepsH{Width\nHeight F mx PaintData imagemask Width 0 +}repeat E}b E d/mp/makepattern , d\n/build_pattern{CTMsave GDIBWPatternMx setmatrix/nupangle where{! nupangle -90\neq{nupangle R}if}if GDIBWPatternDict @ ` Width Height ne{Width Height gt{Width\nHeight V 1}{1 Height Width V}? +S}if xOrg yOrg E matrix + mp CTMrestore}b/hbf\n{setpattern}b/hf{:/fEOFill ~ d ~ ! setpattern fEOFill{O}{L}? ;}b/pbf{: !\n/fEOFill ~ d GDIBWPatternDict `/yOrg ~ d/xOrg ~ d/PaintData ~ d/OutputBPP ~ d\n/Height ~ d/Width ~ d/PaintType 1 d/PatternType 1 d/TilingType 1 d/BBox[0 0\nWidth Height]d/XStep Width d/YStep Height d/mx xOrg yOrg matrix + d 20 dict @ `\n/ImageType 1 d/Width Width d/Height Height d/ImageMatrix[1 0 0 1 0 0]d\n/BitsPerComponent 8 d OutputBPP 24 eq{/Decode[0 1 0 1 0 1]d}{OutputBPP 8 eq{\n/Decode[0 1]d}{/Decode[0 1 0 1 0 1 0 1]d}?}?/DataSource{PaintData}d E/ImageDict\n~ d/PaintProc{` ImageDict image E}b & mx makepattern setpattern E fEOFill{O}{L}\n? ;}b/mask_pbf{:/fEOFill ~ d 20 dict `/yOrg ~ d/xOrg ~ d/PaintData ~ d/Height ~\nd/Width ~ d/PatternType 1 d/PaintType 2 d/TilingType 1 d/BBox[0 0 Width Height]\nd/XStep Width d/YStep Height d/mx xOrg yOrg matrix + d/PaintProc{` Width Height\nT 1 1 dtransform abs ~ abs ~ 0 0 3 -1 $ 0 0 6 array astore{PaintData}imagemask\nE}b & mx makepattern setpattern E fEOFill{O}{L}? ;}b\n%%EndResource\nend reinitialize\n: N 112 236 4487 1 rp C \n L ; : N 112 4670 4487 1 rp C \n L ; : N 112 4753 4487 1 rp C \n L ; : N 112 5336 4487 1 rp C \n L ; : N 111 6273 1123 4 rp C \n L ; \n%%IncludeResource: font Helvetica\n7500 VM?\n/Helvetica FontHasEuro not\n{\n/Euro.Helvetica\n [556 0 24 -19 541 703 ] \n\nAddEuroGlyph\n/Euro /Helvetica /Helvetica-Copy BuildNewFont\n} if\nF /F1 0 /256 T /Helvetica mF \n/F1S64 F1 [100 0 0 -100 0 0 ] mFS\nF1S64 Ji \n111 340 M (Aangevraagde domeinnaam:)[67 56 56 55 56 49 33 56 56 55 56 56 28 56 56 84 56 22 56 56 56 56 84 0]xS \n1881 340 M (#domeinnaam#.nl)[56 56 56 84 56 22 56 56 56 56 84 56 28 56 0]xS \n/F1S53 F1 [83 0 0 -83 0 0 ] mFS\nF1S53 Ji \n111 594 M (Partij I, Domeinnaamaanvrager:)[55 46 28 23 18 19 23 23 23 23 60 46 71 46 18 46 46 46 46 71 46 46 46 41 28 46 46 46 28 0]xS \n\n%%IncludeResource: font Times-Roman\n7500 VM?\n/Times-Roman FontHasEuro not\n{\n/Euro.Times-Roman\n [500 0 24 -14 493 676 ] \n\nAddEuroGlyph\n/Euro /Times-Roman /Times-Roman-Copy BuildNewFont\n} if\nF /F2 0 /256 T /Times-Roman mF \n/F2S64 F2 [100 0 0 -100 0 0 ] mFS\nF2S64 Ji \n111 713 M (I.)[31 0]xS \nF1S53 Ji \n418 713 M (naam:)[46 46 46 71 0]xS \n1881 713 M (#bedrijf#)[46 46 46 46 28 18 19 24 0]xS \nF2S64 Ji \n111 838 M (II.)[31 31 0]xS \nF1S53 Ji \n418 838 M (adres \\(geen postbus\\))[46 46 28 46 42 23 28 46 46 46 46 23 46 46 42 23 46 46 42 0]xS \n/F1S30 F1 [48 0 0 -48 0 0 ] mFS\nF1S30 Ji \n1203 800 M (1)S \nF1S53 Ji \n1230 838 M (:)S \n1881 838 M (#adres#)[46 46 46 28 46 42 0]xS \nF2S64 Ji \n111 963 M (III.)[31 31 31 0]xS \nF1S53 Ji \n418 963 M (postcode, plaats en land:)[46 46 42 23 42 46 46 46 23 23 46 18 46 46 23 42 23 46 46 23 18 46 46 46 0]xS \n1881 963 M (#postcode# #plaats# #land#)[46 46 46 42 23 42 46 46 46 46 23 46 46 18 46 46 23 42 46 23 46 18 46 46 46 0]xS \nF2S64 Ji \n111 1088 M (IV.)[31 72 0]xS \nF1S53 Ji \n418 1088 M (adres in Nederland \\(geen postbus\\))[46 46 28 46 42 23 18 46 23 60 46 46 46 28 18 46 46 46 23 28 46 46 46 46 23 46 46 42 23 46 46 42\n 0]xS \nF1S30 Ji \n1695 1050 M (2)S \nF1S53 Ji \n1723 1088 M (:)S \nF2S64 Ji \n111 1213 M (V.)[72 0]xS \n111 1338 M (VI.)[72 31 0]xS \n/F0S53 F0 [83 0 0 -83 0 0 ] mFS\nF0S53 Ji \n418 1338 M (administratieve contact)[46 51 74 23 51 23 46 28 32 46 28 23 46 47 46 23 46 51 51 28 46 46 0]xS \nF1S53 Ji \n1348 1338 M (, naam:)[23 23 46 46 46 71 0]xS \nF2S64 Ji \n111 1463 M (VII.)[72 31 31 0]xS \nF1S53 Ji \n418 1463 M (telefoonnummer)[23 46 18 46 24 46 46 46 46 46 71 71 46 0]xS \nF1S30 Ji \n1021 1425 M (3)S \nF1S53 Ji \n1048 1463 M (:)S \n1881 1463 M (+31334551334)[48 46 46 46 46 46 46 46 46 46 46 0]xS \nF2S64 Ji \n111 1588 M (VIII.)[72 31 31 31 0]xS \nF1S53 Ji \n418 1588 M (e-mail:)[46 28 71 46 18 18 0]xS \nF0S53 Ji \n1881 1588 M (#domainnaam#.admin@zion-it.com)[46 51 51 74 46 23 51 51 46 46 74 46 23 46 51 74 23 51 81 42 23 51 51 28 23 28 23 46 51 0]xS \nF2S64 Ji \n111 1713 M (IX.)[31 72 0]xS \nF0S53 Ji \n418 1713 M (technische contact)[28 46 46 51 51 23 46 46 51 46 23 46 51 51 28 46 46 0]xS \nF1S53 Ji \n1171 1713 M (, naam:)[23 23 46 46 46 71 0]xS \nF2S64 Ji \n111 1838 M (X.)[72 0]xS \nF1S53 Ji \n418 1838 M (telefoonnummer)[23 46 18 46 24 46 46 46 46 46 71 71 46 0]xS \nF1S30 Ji \n1021 1800 M (4)S \nF1S53 Ji \n1048 1838 M (:)S \n1881 1838 M (+31334551334)[48 46 46 46 46 46 46 46 46 46 46 0]xS \nF2S64 Ji \n111 1963 M (XI.)[72 31 0]xS \nF1S53 Ji \n418 1963 M (e-mail:)[46 28 71 46 18 18 0]xS \n1881 1963 M (#domeinnaam#.admin@zion-it.com)[46 46 46 71 46 18 46 46 46 46 71 46 23 46 46 71 18 46 84 40 18 46 46 28 18 23 23 42 46 0]xS \nF2S64 Ji \n111 2088 M (XII.)[72 31 31 0]xS \n111 2213 M (XIII.)[72 31 31 31 0]xS \nF0S53 Ji \n418 2213 M (Partij II, \"SIDN\")[55 46 32 28 23 23 23 23 23 23 23 39 55 23 60 60 0]xS \nF1S53 Ji \n1016 2213 M (;)S \n1291 2213 M (Stichting Internet Domeinregistratie Nederland, statutair gevestigd te Amsterdam)\n[55 23 18 42 46 23 18 46 46 23 23 46 23 46 28 46 46 23 23 60 46 71 46 18 46 28 46 46 18 42 23 28\n46 23 18 46 23 60 46 46 46 28 18 46 46 46 23 23 42 23 46 23 46 23 46 18 28 23 46 46 41 46 42 23\n18 46 46 23 23 46 23 55 71 42 23 46 28 46 46 0]xS \n\n%%IncludeResource: font Times-Bold\n7500 VM?\n/Times-Bold FontHasEuro not\n{\n/Euro.Times-Bold\n [500 0 19 -13 492 688 ] \n<9EF8880DF84CA6037EA701F791C801F7FFC801F928A7018F0AC3F73203F852A6037EA701\nF791C801F7FFC801F928A701F86DF89C15F73A0770068875877D778B08858B749A799308\n7E916E946B8B08358BFB144773FB58086506774E05C1065A076706774E05C7069DFB27E1\nFB0BF7188B088F0AC3F73203F84CA6037EA701F791C801F7FFC801F928A701B88BAA9F91\n8E089C939892908B089F8B8F7D8E7508A606F7450772067A3F5240538B084F8B68EC89F7\n2108F72F06A0C805FB4506BC07F75506A0C805FB690690F71CA9EFC88B088F0AF852A603\n7EA701F791C801F7FFC801F928A701D58BB93A9C5008090E>\nAddEuroGlyph\n/Euro /Times-Bold /Times-Bold-Copy BuildNewFont\n} if\nF /F3 0 /256 T /Times-Bold mF \n/F3S64 F3 [100 0 0 -100 0 0 ] mFS\nF3S64 Ji \n111 2340 M (XIV.)[72 39 72 0]xS \n/F0S43 F0 [67 0 0 -67 0 0 ] mFS\nF0S43 Ji \n418 2340 M (Partijen zijn het volgende overeengekomen:)[45 37 26 22 19 18 37 41 19 34 19 18 41 19 41 37 22 19 37 41 19 41 37 41 41 37 19 41 37 37 26 37\n37 41 41 37 37 41 60 37 41 0]xS \nF3S64 Ji \n111 2465 M (XV.)[72 72 0]xS \n/F1S43 F1 [67 0 0 -67 0 0 ] mFS\nF1S43 Ji \n111 2547 M (1.)[37 0]xS \n289 2547 M (Op dit Registratiecontract zijn de definities zoals neergelegd in artikel 1 van het \\223Reglement voor registratie van .nl-domeinnamen\\224 van)\n[52 37 19 37 15 19 19 48 37 37 15 34 19 22 37 19 15 37 34 37 37 19 22 37 34 19 19 33 15 15 37 19\n37 37 19 37 37 19 15 37 15 19 15 37 34 19 33 37 37 15 34 19 37 37 37 22 37 37 15 37 37 37 19 15\n37 19 37 22 19 15 34 37 15 19 37 19 33 37 37 19 37 37 19 19 22 48 37 37 15 37 57 37 37 19 19 33\n37 37 22 19 22 37 37 15 34 19 22 37 19 15 37 19 33 37 37 19 19 37 15 22 37 37 57 37 15 37 37 37\n57 37 37 22 19 33 37 0]xS \n289 2622 M (toepassing.)[19 37 37 37 37 34 34 15 37 37 0]xS \n111 2697 M (2.)[37 0]xS \n289 2697 M (Dit Registratiecontract wordt tussen partijen aangegaan met betrekking tot de aangevraagde domeinnaam.)\n[48 15 19 19 48 37 37 15 34 19 22 37 19 15 37 34 37 37 19 22 37 34 19 19 47 37 22 37 19 19 19 37\n34 34 37 37 19 37 37 22 19 15 15 37 37 19 37 37 37 37 37 37 37 37 37 19 57 37 19 19 37 37 19 22\n37 34 34 15 37 37 19 19 37 19 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 37 37 57 37 15\n37 37 37 37 57 0]xS \n111 2772 M (3.)[37 0]xS \n289 2772 M (Domeinnaamaanvrager verklaart kennis te hebben genomen van het \\223Reglement voor registratie van .nl-domeinnamen\\224 en dit te aanvaarden.)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 37 22 34 15 37 37 22 19 19 34 37\n37 37 15 34 19 19 37 19 37 37 37 37 37 37 19 37 37 37 37 57 37 37 19 33 37 37 19 37 37 19 19 22\n48 37 37 15 37 57 37 37 19 19 33 37 37 22 19 22 37 37 15 34 19 22 37 19 15 37 19 33 37 37 19 19\n37 15 22 37 37 57 37 15 37 37 37 57 37 37 22 19 37 37 19 37 15 19 19 19 37 19 37 37 37 33 37 37\n22 37 37 37 0]xS \n111 2847 M (4.)[37 0]xS \n289 2847 M (Domeinnaamaanvrager staat ervoor in dat de door hem verstrekte gegevens in dit Registratiecontract juist zijn vermeld en volledig zijn en staat)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 34 19 37 37 19 19 37 22 33 37 37 22\n19 15 37 19 37 37 19 19 37 37 19 37 37 37 22 19 37 37 57 19 33 37 22 34 19 22 37 34 19 37 19 37\n37 37 37 33 37 37 34 19 15 37 19 37 15 19 19 48 37 37 15 34 19 22 37 19 15 37 34 37 37 19 22 37\n34 19 19 15 37 15 34 19 19 33 15 15 37 19 33 37 22 57 37 15 37 19 37 37 19 33 37 15 15 37 37 15\n37 19 33 15 15 37 19 37 37 19 34 19 37 37 0]xS \n289 2922 M (er voorts voor in dat hij er zorg voor zal dragen gedurende de periode van geregistreerd zijn van de aangevraagde Domeinnaam wijzigingen in)\n[37 22 19 33 37 37 22 19 34 19 33 37 37 22 19 15 37 19 37 37 19 19 37 15 15 19 37 22 19 33 37 22\n37 19 33 37 37 22 19 33 37 15 19 37 22 37 37 37 37 19 37 37 37 37 22 37 37 37 37 19 37 37 19 37\n37 22 15 37 37 37 19 33 37 37 19 37 37 22 37 37 15 34 19 22 37 37 22 37 19 33 15 15 37 19 33 37\n37 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37 57 19 47 15 15\n33 15 37 15 37 37 37 37 19 15 0]xS \n289 2997 M (deze gegevens onverwijld via zijn Deelnemer aan SIDN te zullen doorgeven.)\n[37 37 33 37 19 37 37 37 37 33 37 37 34 19 37 37 33 37 22 47 15 15 15 37 19 33 15 37 19 33 15 15\n37 19 48 37 37 15 37 37 57 37 22 19 37 37 37 19 45 19 48 48 19 19 37 19 33 37 15 15 37 37 19 37\n37 37 22 37 37 33 37 37 0]xS \n111 3072 M (5.1)[37 19 0]xS \n289 3072 M (Domeinnaamaanvrager staat ervoor in gerechtigd te zijn de aangevraagde Domeinnaam te gebruiken.)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 34 19 37 37 19 19 37 22 33 37 37 22\n19 15 37 19 37 37 22 37 34 37 19 15 37 37 19 19 37 19 33 15 15 37 19 37 37 19 37 37 37 37 37 33\n22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37 57 19 19 37 19 37 37 37 22 37 15 34 37 37 0]xS \n111 3147 M (5.2)[37 19 0]xS \n289 3147 M (Domeinnaamaanvrager verklaart dat naar zijn beste weten hij door de registratie en \\(eventueel later\\) gebruik van de aangevraagde Domeinnaam)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 37 22 34 15 37 37 22 19 19 37 37\n19 19 37 37 37 22 19 33 15 15 37 19 37 37 34 19 37 19 47 37 19 37 37 19 37 15 15 19 37 37 37 22\n19 37 37 19 22 37 37 15 34 19 22 37 19 15 37 19 37 37 19 22 37 33 37 37 19 37 37 37 15 19 15 37\n19 37 22 22 19 37 37 37 22 37 15 34 19 33 37 37 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37\n19 48 37 57 37 15 37 37 37 37 0]xS \n289 3222 M (geen inbreuk maakt op rechten van derden.)[37 37 37 37 19 15 37 37 22 37 37 34 19 57 37 37 34 19 19 37 37 19 22 37 34 37 19 37 37 19 33 37\n37 19 37 37 22 37 37 37 0]xS \n111 3297 M (6.)[37 0]xS \n289 3297 M (Domeinnaamaanvrager zal SIDN steeds onmiddellijk op de hoogte stellen van iedere vordering van een derde dat de registratie en/of het gebruik)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 37 15 19 45 19 48 48 19 34 19 37\n37 37 34 19 37 37 57 15 37 37 37 15 15 15 15 34 19 37 37 19 37 37 19 37 37 37 37 19 37 19 34 19\n37 15 15 37 37 19 33 37 37 19 15 37 37 37 22 37 19 33 37 22 37 37 22 15 37 37 19 33 37 37 19 37\n37 37 19 37 37 22 37 37 19 37 37 19 19 37 37 19 22 37 37 15 34 19 22 37 19 15 37 19 37 37 19 37\n19 19 37 37 19 19 37 37 37 22 37 15 0]xS \n289 3372 M (van de aangevraagde Domeinnaam inbreuk maakt op diens rechten.)\n[33 37 37 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37 57 19 15\n37 37 22 37 37 34 19 57 37 37 34 19 19 37 37 19 37 15 37 37 34 19 22 37 34 37 19 37 37 0]xS \n111 3447 M (7.)[37 0]xS \n289 3447 M (Domeinnaamaanvrager aanvaardt dat Nederlands recht van toepassing is op ieder geschil over de aangevraagde Domeinnaam.)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 37 37 37 33 37 37 22 37 19 19 37 37\n19 19 48 37 37 37 22 15 37 37 37 34 19 22 37 34 37 19 19 33 37 37 19 19 37 37 37 37 34 34 15 37\n37 19 15 34 19 37 37 19 15 37 37 37 22 19 37 37 34 34 37 15 15 19 37 33 37 22 19 37 37 19 37 37\n37 37 37 33 22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37 57 0]xS \n111 3522 M (8.)[37 0]xS \n289 3522 M (Domeinnaamaanvrager verklaart bij voorbaat dat hij zich zal onderwerpen aan het oordeel van het Scheidsgerecht Domeinnamen, indien een)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 37 22 34 15 37 37 22 19 19 37 15\n15 19 33 37 37 22 37 37 37 19 19 37 37 19 19 37 15 15 19 33 15 34 37 19 33 37 15 19 37 37 37 37\n22 47 37 22 37 37 37 19 37 37 37 19 37 37 19 19 37 37 22 37 37 37 15 19 33 37 37 19 37 37 19 19\n45 34 37 37 15 37 34 37 37 22 37 34 37 19 19 48 37 57 37 15 37 37 37 57 37 37 19 19 15 37 37 15\n37 37 19 37 37 0]xS \n289 3597 M (derde een geschil over de aangevraagde Domeinnaam aan het Scheidsgerecht Domeinnamen voorlegt.)\n[37 37 22 37 37 19 37 37 37 19 37 37 34 34 37 15 15 19 37 33 37 22 19 37 37 19 37 37 37 37 37 33\n22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37 57 19 37 37 37 19 37 37 19 19 45 34 37 37 15 37\n34 37 37 22 37 34 37 19 19 48 37 57 37 15 37 37 37 57 37 37 19 33 37 37 22 15 37 37 19 0]xS \n111 3672 M (9.)[37 0]xS \n289 3672 M (Domeinnaamaanvrager verklaart bij voorbaat dat hij zich zal onderwerpen aan het oordeel van een Nederlandse rechter, indien een derde een)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 37 22 34 15 37 37 22 19 19 37 15\n15 19 33 37 37 22 37 37 37 19 19 37 37 19 19 37 15 15 19 33 15 34 37 19 33 37 15 19 37 37 37 37\n22 47 37 22 37 37 37 19 37 37 37 19 37 37 19 19 37 37 22 37 37 37 15 19 33 37 37 19 37 37 37 19\n48 37 37 37 22 15 37 37 37 34 37 19 22 37 34 37 19 37 22 19 19 15 37 37 15 37 37 19 37 37 37 19\n37 37 22 37 37 19 37 37 0]xS \n289 3747 M (gerechtelijke procedure aanhangig maakt met betrekking tot een geschil over de aangevraagde Domeinnaam.)\n[37 37 22 37 34 37 19 37 15 15 15 34 37 19 37 22 37 34 37 37 37 22 37 19 37 37 37 37 37 37 37 15\n37 19 57 37 37 34 19 19 57 37 19 19 37 37 19 22 37 34 34 15 37 37 19 19 37 19 19 37 37 37 19 37\n37 34 34 37 15 15 19 37 33 37 22 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 48 37 57 37\n15 37 37 37 37 57 0]xS \n111 3822 M (10.)[37 37 0]xS \n289 3822 M (Domeinnaamaanvrager vrijwaart SIDN, de bestuursleden van SIDN, het personeel van SIDN en alle Deelnemers terzake van, en zal hen)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 22 15 15 47 37 37 22 19 19 45 19\n48 48 19 19 37 37 19 37 37 34 19 37 37 22 34 15 37 37 37 37 19 33 37 37 19 45 19 48 48 19 19 37\n37 19 19 37 37 22 34 37 37 37 37 15 19 33 37 37 19 45 19 48 48 19 37 37 19 37 15 15 37 19 48 37\n37 15 37 37 57 37 22 34 19 19 37 22 33 37 34 37 19 33 37 37 19 19 37 37 19 33 37 15 19 37 37 0]xS \n289 3897 M (schadeloos stellen voor, alle kosten en schade die voor ieder van hen voortvloeien uit een aanspraak van een derde dat de registratie en/of het)\n[34 34 37 37 37 37 15 37 37 34 19 34 19 37 15 15 37 37 19 33 37 37 22 19 19 37 15 15 37 19 34 37\n34 19 37 37 19 37 37 19 34 34 37 37 37 37 19 37 15 37 19 33 37 37 22 19 15 37 37 37 22 19 33 37\n37 19 37 37 37 19 33 37 37 22 19 33 15 37 37 15 37 37 19 37 15 19 19 37 37 37 19 37 37 37 34 37\n22 37 37 34 19 33 37 37 19 37 37 37 19 37 37 22 37 37 19 37 37 19 19 37 37 19 22 37 37 15 34 19\n22 37 19 15 37 19 37 37 19 37 19 19 37 37 0]xS \n289 3972 M (gebruik van de aangevraagde Domeinnaam inbreuk maakt op diens rechten.)\n[37 37 37 22 37 15 34 19 33 37 37 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 48 37 57 37\n15 37 37 37 37 57 19 15 37 37 22 37 37 34 19 57 37 37 34 19 19 37 37 19 37 15 37 37 34 19 22 37\n34 37 19 37 37 0]xS \n111 4047 M (11.)[37 37 0]xS \n289 4047 M (Indien de aangevraagde Domeinnaam overeenkomstig de voorgeschreven wijze in het Reglement voor Registratie van .nl-domeinnamen is)\n[19 37 37 15 37 37 19 37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37\n57 19 37 33 37 22 37 37 37 34 37 57 34 19 15 37 19 37 37 19 33 37 37 22 37 37 34 34 37 22 37 33\n37 37 19 47 15 15 33 37 19 15 37 19 37 37 19 19 48 37 37 15 37 57 37 37 19 19 33 37 37 22 19 48\n37 37 15 34 19 22 37 19 15 37 19 33 37 37 19 19 37 15 22 37 37 57 37 15 37 37 37 57 37 37 19 15\n 0]xS \n289 4122 M (aangevraagd, zal SIDN deze in het Register opnemen en opgenomen houden. Nadat de Domeinnaam is opgenomen in het Register, zal SIDN)\n[37 37 37 37 37 33 22 37 37 37 37 19 19 33 37 15 19 45 19 48 48 19 37 37 33 37 19 15 37 19 37 37\n19 19 48 37 37 15 34 19 37 22 19 37 37 37 37 57 37 37 19 37 37 19 37 37 37 37 37 37 57 37 37 19\n37 37 37 37 37 37 19 19 48 37 37 37 19 19 37 37 19 48 37 57 37 15 37 37 37 37 57 19 15 34 19 37\n37 37 37 37 37 57 37 37 19 15 37 19 37 37 19 19 48 37 37 15 34 19 37 22 19 19 33 37 15 19 45 19\n48 0]xS \n289 4197 M (deze opnemen in de .nl)[37 37 33 37 19 37 37 37 37 57 37 37 19 15 37 19 37 37 19 19 37 0]xS \n985 4197 M (-)S \n1007 4197 M (zonefile.)[33 37 37 37 19 15 15 37 0]xS \n111 4272 M (12.)[37 37 0]xS \n289 4272 M (Degene die namens domeinnaamaanvrager dit Registratiecontract ondertekent verklaart dat hij bevoegd is namens de Domeinnaamaanvrager)\n[48 37 37 37 37 37 19 37 15 37 19 37 37 57 37 37 34 19 37 37 57 37 15 37 37 37 37 57 37 37 37 33\n22 37 37 37 22 19 37 15 19 19 48 37 37 15 34 19 22 37 19 15 37 34 37 37 19 22 37 34 19 19 37 37\n37 37 22 19 37 34 37 37 19 19 33 37 22 34 15 37 37 22 19 19 37 37 19 19 37 15 15 19 37 37 33 37\n37 37 37 19 15 34 19 37 37 57 37 37 34 19 37 37 19 48 37 57 37 15 37 37 37 37 57 37 37 37 33 22\n37 37 37 0]xS \n289 4347 M (de aangevraagde Domeinnaam aan te vragen.)[37 37 19 37 37 37 37 37 33 22 37 37 37 37 37 19 48 37 57 37 15 37 37 37 37 57 19 37 37 37 19 19\n37 19 33 22 37 37 37 37 0]xS \n111 4422 M (13.)[37 37 0]xS \n289 4422 M (Domeinnaamaanvrager verklaart dat het door hem opgegeven Administratieve Contact hem vertegenwoordigt. Tevens verklaart hij dat)\n[48 37 57 37 15 37 37 37 37 57 37 37 37 33 22 37 37 37 22 19 33 37 22 34 15 37 37 22 19 19 37 37\n19 19 37 37 19 19 37 37 37 22 19 37 37 57 19 37 37 37 37 37 37 33 37 37 19 45 37 57 15 37 15 34\n19 22 37 19 15 37 33 37 19 48 37 37 19 37 34 19 19 37 37 57 19 33 37 22 19 37 37 37 37 47 37 37\n22 37 15 37 19 19 19 41 37 33 37 37 34 19 33 37 22 34 15 37 37 22 19 19 37 15 15 19 37 37 0]xS \n289 4497 M (mededelingen gedaan aan het Administratieve Contact via het Admin-C e-mailadres worden geacht hem te hebben bereikt.)\n[57 37 37 37 37 37 15 15 37 37 37 37 19 37 37 37 37 37 37 19 37 37 37 19 37 37 19 19 45 37 57 15\n37 15 34 19 22 37 19 15 37 33 37 19 48 37 37 19 37 34 19 19 33 15 37 19 37 37 19 19 45 37 57 15\n37 22 48 19 37 22 57 37 15 15 37 37 22 37 34 19 47 37 22 37 37 37 19 37 37 37 34 37 19 19 37 37\n57 19 19 37 19 37 37 37 37 37 37 19 37 37 22 37 15 34 19 0]xS \n111 4572 M (14.)[37 37 0]xS \n289 4572 M (In dit document aangebrachte wijzigingen zijn slechts van kracht als deze door beide partijen expliciet zijn aanvaard.)\n[19 37 19 37 15 19 19 37 37 34 37 57 37 37 19 19 37 37 37 37 37 37 22 37 34 37 19 37 19 47 15 15\n33 15 37 15 37 37 37 37 19 33 15 15 37 19 34 15 37 34 37 19 34 19 33 37 37 19 34 22 37 34 37 19\n19 37 15 34 19 37 37 33 37 19 37 37 37 22 19 37 37 15 37 37 19 37 37 22 19 15 15 37 37 19 37 32\n37 15 15 34 15 37 19 19 33 15 15 37 19 37 37 37 33 37 37 22 37 0]xS \n111 4647 M (15.)[37 37 0]xS \n289 4647 M (Dit contract eindigt in de in het Reglement voor registratie beschreven gevallen.)\n[48 15 19 19 34 37 37 19 22 37 34 19 19 37 15 37 37 15 37 19 19 15 37 19 37 37 19 15 37 19 37 37\n19 19 48 37 37 15 37 57 37 37 19 19 33 37 37 22 19 22 37 37 15 34 19 22 37 19 15 37 19 37 37 34\n34 37 22 37 33 37 37 19 37 37 33 37 15 15 37 37 0]xS \nF1S53 Ji \n111 4861 M (Domeinnaamaanvrager)[60 46 71 46 18 46 46 46 46 71 46 46 46 41 28 46 46 46 0]xS \n1881 4861 M (Namens SIDN)[60 46 71 46 46 42 23 55 23 60 0]xS \n111 5183 M (handtekening)[46 46 46 46 23 46 43 46 46 18 46 0]xS \n701 5183 M <8585858585858585858585858585>[83 83 83 83 83 83 83 83 83 83 83 83 83 0]xS \n1881 5183 M (handtekening)[46 46 46 46 23 46 43 46 46 18 46 0]xS \n: 125 55 24 375 696 304 2471 4879 F F 3 [ 0 0 0 ] F \nX\ndoNimage\nJcCl4rr2osrql]nqu?Zkrr)ioqtg/U&Y,Wqu?Zerql9d\nrr)icrq?6hrqYgYrr2fprpfmcrqucln,NC\\rr;u`rY#21o)J^Zrr2lsrr2oirr;ufqu?WqrpTjc\np&G!srql]Tqu?Z^]`4T\'rqucfqu?Z^rr;ukrr2o`qu?Zlrq??krqYgYrpojarpfRZrp]pbrposd\nrW)rtrpp\'grql]orr;uirq?UVrql]krX]#.rquc^rr;ucrr2oorr;urrql]p\nqZ-TtrWiGsrr;rtqu?ZnrWN5hqu?ZhrqQ9grql]mrr2opp&G$iqu?Zirqucqrr0e7dJs4Err2ol\nqu?Zlrr;unrqucmqu?Zfrr;rtrr;ujrr;uqrpfmcrpfmcrqcWnrr;udqu?Zlrr)irrqucfqu?Zg\nrr;rtrr;umrqcWorr2osrp]perpB^brqZQerr;rtrqu`srW)rtrq-3irW)rlJcGKEdJs4:q#C?^\nrr;usp&G!rrqucqrr2okrr;urrr2osrp9X[rr;ukrpTaarq60grqHUqu?Zgrr;usqu?Zfqu?ZYrX/Z#\nrqH Z\n; /F2S53 F2 [83 0 0 -83 0 0 ] mFS\nF2S53 Ji \n3167 5183 M (Bart Boswinkel, directeur SIDN)[56 37 28 23 21 56 42 32 58 23 41 41 37 23 21 21 42 23 28 37 37 23 37 41 28 21 46 28 60 0]xS \nF1S53 Ji \n111 5310 M (datum)[46 46 23 46 0]xS \n701 5310 M <8585858585858585858585858585>[83 83 83 83 83 83 83 83 83 83 83 83 83 0]xS \n\n%%IncludeResource: font Helvetica-Oblique\n7500 VM?\n/Helvetica-Oblique FontHasEuro not\n{\n/Euro.Helvetica-Oblique\n/Helvetica-Oblique UseObliqueEuro {\n [556 0 73 -19 674 703 ] \n\n} {\n [556 0 24 -19 541 703 ] \n\n} ifelse\nAddEuroGlyph\n/Euro /Helvetica-Oblique /Helvetica-Oblique-Copy BuildNewFont\n} if\nF /F4 0 /256 T /Helvetica-Oblique mF \n/F4S43 F4 [67 0 0 -67 0 0 ] mFS\nF4S43 Ji \n111 5447 M ( De gegevens die de domeinnaamaanvrager verstrekt op grond van dit Registratiecontract worden opgenomen in het Domeinnamen- en)\n[19 48 37 19 37 37 37 37 34 37 37 34 19 37 15 37 19 37 37 19 37 37 55 37 15 37 37 37 37 55 37 37\n37 34 22 37 37 37 22 19 34 37 22 34 19 22 37 34 19 19 37 37 19 37 22 37 37 37 19 34 37 37 19 37\n15 19 19 48 37 37 15 34 19 22 37 19 15 37 34 37 37 19 22 37 34 19 19 49 37 22 37 37 37 19 37 37\n37 37 37 37 55 37 37 19 15 37 19 37 37 19 19 48 37 55 37 15 37 37 37 55 37 37 22 19 37 0]xS \n111 5572 M (Persoonsdomeinnamenregister \\(het Register\\). Conform de Wet bescherming persoonsgegevens is deze verwerking gemeld bij het College)\n[45 37 22 34 37 37 37 34 37 37 55 37 15 37 37 37 55 37 37 22 37 37 15 34 19 37 22 19 22 37 37 19\n19 48 37 37 15 34 19 37 22 22 19 19 48 37 37 19 37 22 55 19 37 37 19 64 37 19 19 37 37 34 34 37\n37 22 55 15 37 37 19 37 37 22 34 37 37 37 34 37 37 37 37 34 37 37 34 19 15 34 19 37 37 31 37 19\n34 37 22 49 37 22 34 15 37 37 19 37 37 55 37 15 37 19 37 15 15 19 37 37 19 19 48 37 15 15 37 37\n 0]xS \n111 5697 M (bescherming persoonsgegevens, en wel onder nummer M1051464. Informatie over deze verwerking, en de overige SIDN privacyregelingen is)\n[37 37 34 34 37 37 22 55 15 37 37 19 37 37 22 34 37 37 37 34 37 37 37 37 34 37 37 34 19 19 37 37\n19 49 37 15 19 37 37 37 37 22 19 37 37 55 55 37 22 19 56 37 37 37 37 37 37 37 19 19 19 37 19 37\n22 55 37 19 15 37 19 37 34 37 22 19 37 37 31 37 19 34 37 22 49 37 22 34 15 37 37 19 19 37 37 19\n37 37 19 37 34 37 22 15 37 37 19 45 19 48 48 19 37 22 15 34 37 34 34 22 37 37 37 15 15 37 37 37\n37 19 15 0]xS \n111 5820 M (opgenomen op de SIDN homepage onder SIDN en Privacy)[37 37 37 37 37 37 55 37 37 19 37 37 19 37 37 19 45 19 48 48 19 37 37 55 37 37 37 37 37 19 37 37\n37 37 22 19 45 19 48 48 19 37 37 19 45 22 15 34 37 34 0]xS \n/F4S4B F4 [75 0 0 -75 0 0 ] mFS\nF4S4B Ji \n1861 5820 M (.)S \n/F1S22 F1 [34 0 0 -34 0 0 ] mFS\nF1S22 Ji \n111 6333 M (1)S \n/F1S3A F1 [58 0 0 -58 0 0 ] mFS\nF1S3A Ji \n130 6359 M ( )S \n348 6359 M (Straat, huisnummer en eventuele toevoegingen)[39 16 19 32 32 16 16 16 32 32 13 29 32 32 49 49 32 19 16 32 32 16 32 29 32 32 16 32 32 13 32 16\n16 32 32 29 32 32 32 13 32 32 32 0]xS \nF1S22 Ji \n111 6404 M (2)S \nF1S3A Ji \n348 6431 M ( Verplicht ingevolge artikel 3 van het Reglement voor Registratie voor niet in Nederland gevestigden of woonachtigen)\n[16 39 32 19 32 13 13 29 32 16 16 13 32 32 32 29 32 13 32 32 16 32 19 16 13 30 32 13 16 32 16 29\n32 32 16 32 32 16 16 42 32 32 13 32 49 32 32 16 16 29 32 32 19 16 42 32 32 13 29 16 19 32 16 13\n32 16 29 32 32 19 16 32 13 32 16 16 13 32 16 42 32 32 32 19 13 32 32 32 16 32 32 29 32 29 16 13\n32 32 32 32 16 32 16 16 41 32 32 32 32 29 32 16 13 32 32 0]xS \nF1S22 Ji \n111 6476 M (3)S \nF1S3A Ji \n130 6503 M ( )S \n348 6503 M (Inclusief landnummer)[15 32 29 13 32 29 13 32 16 16 13 32 32 32 32 32 49 49 32 0]xS \nF1S22 Ji \n111 6548 M (4)S \nF1S3A Ji \n130 6574 M ( )S \n348 6574 M (Inclusief landnummer)[15 32 29 13 32 29 13 32 16 16 13 32 32 32 32 32 49 49 32 0]xS \nLH\n(%%[Page: 1]%%) = \n%%PageTrailer\n\n%%Trailer\n%%BoundingBox: 15 15 582 819\n%%DocumentNeededResources: \n%%+ font Helvetica-Bold\n%%+ font Helvetica\n%%+ font Times-Roman\n%%+ font Times-Bold\n%%+ font Helvetica-Oblique\n%%DocumentSuppliedResources: \n%%+ procset Pscript_WinNT_VMErrorHandler 5.0 0\n%%+ procset Pscript_FatalError 5.0 0\n%%+ procset Pscript_Win_Basic 5.0 0\n%%+ procset Pscript_Win_Utils_L2 5.0 0\n%%+ procset Pscript_Text 5.0 0\n%%+ procset Pscript_Encoding256 5.0 0\n%%+ procset Pscript_Win_Euro_L2 5.0 0\n%%+ procset Pscript_Win_Dib_L2 5.0 0\n%%+ procset Pscript_Win_GdiObject 5.0 0\n%%+ procset Pscript_Win_GdiObject_L2 5.0 0\nPscript_WinNT_Incr dup /terminate get exec\nehsave restore\n%%Pages: 1\n(%%[LastPage]%%) = \n%%EOF\n ',NULL,NULL,NULL); -- -- Table structure for table `zh_cte_lines` -- CREATE TABLE zh_cte_lines ( id int(10) unsigned NOT NULL auto_increment, ate_id int(10) unsigned NOT NULL default '0', hct_id int(10) unsigned NOT NULL default '0', domain_nm varchar(60) default NULL, domain_suffix varchar(10) default NULL, invoice tinyint(1) NOT NULL default '0', PRIMARY KEY (id), KEY zh_i_cle_fk_hct (domain_suffix), KEY zh_i_fk_ate (ate_id), KEY zh_i_fk_hct (hct_id), CONSTRAINT `0_1454` FOREIGN KEY (`hct_id`) REFERENCES `zh_hostingcontracts` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `0_1455` FOREIGN KEY (`ate_id`) REFERENCES `zh_articles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; -- -- Dumping data for table `zh_cte_lines` -- -- -- Table structure for table `zh_customers` -- CREATE TABLE zh_customers ( id int(10) unsigned NOT NULL auto_increment, code varchar(10) default NULL, company_nm varchar(40) NOT NULL default '', contact_nm varchar(40) default NULL, address1 varchar(40) NOT NULL default '', address2 varchar(40) default NULL, postcode varchar(40) NOT NULL default '', city varchar(40) NOT NULL default '', country varchar(40) NOT NULL default '', telephone_nr varchar(20) default NULL, fax_nr varchar(20) default NULL, email varchar(100) default NULL, vat_nr varchar(40) default NULL, chambre_com_nr varchar(40) default NULL, PRIMARY KEY (id), UNIQUE KEY zh_i_csr_company_nm (company_nm), UNIQUE KEY zh_i_csr_code (code), UNIQUE KEY zh_i_csr_chambre (chambre_com_nr), UNIQUE KEY zh_i_csr_vat_nr (vat_nr) ) TYPE=InnoDB; -- -- Dumping data for table `zh_customers` -- -- -- Table structure for table `zh_hostingcontracts` -- CREATE TABLE zh_hostingcontracts ( id int(10) unsigned NOT NULL auto_increment, csr_id int(10) unsigned NOT NULL default '0', cte_code varchar(10) NOT NULL default '', zh_ref varchar(10) default NULL, cust_ref varchar(10) default NULL, remarks text, start_dt date NOT NULL default '0000-00-00', end_dt date default NULL, start_period_disct int(10) unsigned default NULL, start_amt_disct float(10,2) default NULL, start_prcnt_disct float(5,4) default NULL, prcnt_disct float(5,4) default NULL, amt_disct float(10,2) default NULL, blocked tinyint(1) NOT NULL default '0', PRIMARY KEY (id), KEY zh_i_hct_csr_id (csr_id), KEY zh_i_hct_cte_code (cte_code), CONSTRAINT `0_1446` FOREIGN KEY (`cte_code`) REFERENCES `zh_contracttypes` (`code`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `0_1447` FOREIGN KEY (`csr_id`) REFERENCES `zh_customers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; -- -- Dumping data for table `zh_hostingcontracts` --