-- 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 '',
  `startdate` date NOT NULL DEFAULT '0000-00-00',
  `enddate` date NOT NULL DEFAULT '9999-12-31',
  PRIMARY KEY (`stockid`,`typeabbrev`,`currabrev`,`debtorno`,`branchcode`,`startdate`,`enddate`),
  KEY `CurrAbrev` (`currabrev`),
  KEY `DebtorNo` (`debtorno`),
  KEY `StockID` (`stockid`),
  KEY `TypeAbbrev` (`typeabbrev`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` VALUES ('1','DF','FJD','',225.0000,'','2019-06-05','0000-00-00'),('2','DF','FJD','',5.2500,'','2019-06-08','0000-00-00'),('CIT1','04','FJD','',140.0000,'','2017-11-07','0000-00-00'),('CIT10','04','FJD','',0.0063,'','2017-11-07','0000-00-00'),('CIT11','04','FJD','',0.8000,'','2017-11-07','0000-00-00'),('CIT12','04','FJD','',700.0000,'','2017-11-07','0000-00-00'),('CIT13','04','FJD','',25.0000,'','2017-11-07','0000-00-00'),('CIT14','DF','FJD','',0.0063,'','2017-12-06','0000-00-00'),('CIT15','DF','FJD','',300.0000,'','2017-12-06','0000-00-00'),('CIT2','04','FJD','',0.0063,'','2017-11-07','0000-00-00'),('CIT3','04','FJD','',130.0000,'','2017-11-07','0000-00-00'),('CIT4','04','FJD','',300.0000,'','2017-11-07','0000-00-00'),('CIT5','04','FJD','',140.0000,'','2017-11-07','0000-00-00'),('CIT6','04','FJD','',3.5000,'','2017-11-07','0000-00-00'),('CIT7','04','FJD','',0.0063,'','2017-11-07','0000-00-00'),('CIT8','04','FJD','',0.8000,'','2017-11-07','0000-00-00'),('CIT9','04','FJD','',1.6000,'','2017-11-07','0000-00-00'),('FIRESERVICE','DF','FJD','',150.0000,'','2018-06-04','0000-00-00'),('LABOUR','DF','FJD','',22.5000,'','2019-05-10','0000-00-00');

--
-- Table structure for table `prodspecs`
--

CREATE TABLE `prodspecs` (
  `keyval` varchar(25) NOT NULL,
  `testid` int(11) NOT NULL,
  `defaultvalue` varchar(150) NOT NULL DEFAULT '',
  `targetvalue` varchar(30) NOT NULL DEFAULT '',
  `rangemin` float DEFAULT NULL,
  `rangemax` float DEFAULT NULL,
  `showoncert` tinyint(11) NOT NULL DEFAULT '1',
  `showonspec` tinyint(4) NOT NULL DEFAULT '1',
  `showontestplan` tinyint(4) NOT NULL DEFAULT '1',
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`keyval`,`testid`),
  KEY `testid` (`testid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prodspecs`
--


--
-- Table structure for table `productivity`
--

CREATE TABLE `productivity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeid` int(5) NOT NULL,
  `date` date NOT NULL,
  `targets` varchar(100) NOT NULL,
  `achieved` tinyint(1) NOT NULL,
  `remarks` text NOT NULL,
  `entered_date` datetime NOT NULL,
  `entered_by` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `productivity`
--


--
-- Table structure for table `progressive_billing`
--

CREATE TABLE `progressive_billing` (
  `pgid` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `phase_name` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `actual_material` decimal(10,2) NOT NULL,
  `actual_labor` decimal(10,2) DEFAULT '0.00',
  `actual_others` decimal(10,2) DEFAULT '0.00',
  `total_actual_cost` decimal(10,2) NOT NULL,
  `costing_no` int(11) DEFAULT NULL,
  `bill_rate` decimal(10,2) NOT NULL,
  `billing_amount_vep` decimal(10,2) NOT NULL,
  `billing_amount_vip` decimal(10,2) NOT NULL,
  `narrative` varchar(1000) DEFAULT NULL,
  `comments` varchar(200) DEFAULT NULL,
  `status` varchar(100) NOT NULL,
  PRIMARY KEY (`pgid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `progressive_billing`
--

INSERT INTO `progressive_billing` VALUES (1,41,'phase1/month1','2018-02-01','2018-02-28',2687.08,0.00,2500.00,5187.08,37,0.37,8711.79,9495.85,'Install fire system. claim: 345','test2','approved'),(2,57,'month1','2018-09-01','2018-09-30',0.00,0.00,0.00,0.00,52,0.00,0.00,0.00,NULL,NULL,'approved');

--
-- Table structure for table `project_actual_labor_cost`
--

CREATE TABLE `project_actual_labor_cost` (
  `actuallaborcostid` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `projectperiodid` int(11) NOT NULL,
  `date_entered` date NOT NULL,
  `timesheet_id` decimal(10,0) NOT NULL,
  `employee_name` varchar(20) NOT NULL,
  `hours` decimal(10,0) NOT NULL,
  `rate_paid` decimal(10,0) NOT NULL,
  `total_paid` decimal(10,0) NOT NULL,
  PRIMARY KEY (`actuallaborcostid`),
  KEY `projectid` (`projectid`),
  KEY `projectperiodid` (`projectperiodid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_actual_labor_cost`
--


--
-- Table structure for table `project_notes`
--

CREATE TABLE `project_notes` (
  `notes_id` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `date` date NOT NULL,
  `notes` varchar(100) NOT NULL,
  PRIMARY KEY (`notes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_notes`
--


--
-- Table structure for table `project_report`
--

CREATE TABLE `project_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `project_value` decimal(10,2) NOT NULL,
  `budgeted_cost` decimal(10,2) NOT NULL,
  `actual_cost_till _date` decimal(10,2) NOT NULL,
  `cost_to_complete` decimal(10,2) NOT NULL,
  `total_invoiced_till_date` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_report`
--


--
-- Table structure for table `project_stages`
--

CREATE TABLE `project_stages` (
  `stage_id` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `date` date NOT NULL,
  `name` varchar(100) NOT NULL,
  `phase_name` varchar(100) NOT NULL,
  `duration_days` int(11) NOT NULL,
  PRIMARY KEY (`stage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_stages`
--

INSERT INTO `project_stages` VALUES (1,1,'2019-05-01','First meetings','Meeting',3),(2,59,'2019-05-02','setting up customer','Setup',2),(3,59,'2019-05-07','Costing job','Costing',1),(4,59,'2019-05-09','Quoting for job','Quotation',2),(5,60,'2019-05-29','costing','Costing phase',2);

--
-- Table structure for table `project_stock`
--

CREATE TABLE `project_stock` (
  `project_stock_id` int(11) NOT NULL AUTO_INCREMENT,
  `stockid` varchar(200) NOT NULL,
  `projectid` int(11) NOT NULL,
  `date_received` date NOT NULL,
  `location_received_from` varchar(100) NOT NULL,
  `department_received_from` tinyint(4) NOT NULL,
  `qty_received` decimal(10,2) NOT NULL,
  PRIMARY KEY (`project_stock_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf32;

--
-- Dumping data for table `project_stock`
--

INSERT INTO `project_stock` VALUES (1,'03650D-1',2,'2018-04-03','SUVA',52,10.00),(2,'1418',2,'2018-05-03','SUVA',52,10.00);

--
-- Table structure for table `project_tally`
--

CREATE TABLE `project_tally` (
  `id` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `actual_cost_till_date` decimal(10,2) NOT NULL,
  `cost_to_complete` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_tally`
--


--
-- Table structure for table `projectactualmaterials`
--

CREATE TABLE `projectactualmaterials` (
  `actualmaterialsid` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `projectperiodid` tinyint(4) NOT NULL,
  `cost_name` varchar(20) NOT NULL,
  `qty` decimal(10,0) NOT NULL,
  `unit_price` decimal(10,0) NOT NULL,
  `total_cost` decimal(10,0) NOT NULL,
  `tax_type` varchar(20) NOT NULL,
  `vat_paid` decimal(10,0) NOT NULL,
  PRIMARY KEY (`actualmaterialsid`),
  KEY `projectid` (`projectid`),
  KEY `projectperiodid` (`projectperiodid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectactualmaterials`
--


--
-- Table structure for table `projectactualperiod`
--

CREATE TABLE `projectactualperiod` (
  `projectperiodid` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `period_name` varchar(20) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `actual_material_cost` decimal(10,2) NOT NULL,
  `actual_labor_cost` decimal(10,2) NOT NULL,
  `actual_total_cost` decimal(10,2) NOT NULL,
  `sales_ratio` decimal(10,2) NOT NULL,
  `sales_revenue` decimal(10,0) NOT NULL,
  `margin` decimal(10,2) NOT NULL,
  `status` varchar(20) NOT NULL,
  PRIMARY KEY (`projectperiodid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectactualperiod`
--


--
-- Table structure for table `projectadjustments`
--

CREATE TABLE `projectadjustments` (
  `ac_id` int(11) NOT NULL AUTO_INCREMENT,
  `pgid` int(11) NOT NULL,
  `sector` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `comment` varchar(100) NOT NULL,
  `costed_by` varchar(100) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  `approved_by` varchar(100) NOT NULL,
  PRIMARY KEY (`ac_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectadjustments`
--

INSERT INTO `projectadjustments` VALUES (1,1,'Project Manager',2000.00,'testing','sachin',0,''),(2,1,'Finance Team',500.00,'test3','sachin',0,'');

--
-- Table structure for table `projectattachments`
--

CREATE TABLE `projectattachments` (
  `projectattachid` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `file` blob NOT NULL,
  PRIMARY KEY (`projectattachid`),
  KEY `projectid` (`projectid`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectattachments`
--

INSERT INTO `projectattachments` VALUES (1,6,'',''),(2,21,'','Quote_MHCC_upgrade_sample.pdf'),(3,24,'Abhinesh','W2720-17_Peninsula_International_Hotel_FAS_FP1600_rev_2.xlsx'),(4,24,'Abhinesh','W2720-17_Peninsula_International_Hotel_FAS_FP1600_REV.pdf'),(5,24,'Abhinesh','Peninsula_LPO.pdf'),(6,31,'','Housing_Annual_Survey_Defects_FAS.doc'),(7,32,'Value City, Valelevu',''),(8,35,'','JOB_COSTING.csv'),(9,38,'',''),(10,42,'Holiday Inn',''),(11,35,'lawhill limited','jobcosting_36rp8xj4o5kww.csv'),(12,43,'',''),(13,44,'Shop N Save Nabua',''),(14,45,'ShopNSaveWarehsNabua','LPO215191ShopNSave.pdf'),(15,47,'AHCRes Hs#3 42RsrvRd',''),(16,48,'6 Waimate',''),(18,49,'Pacific Power Ass.','Inv_8870_PACIFIC_POWER_ASSOCIATION.pdf'),(19,50,'21 Burerua St',''),(20,51,'27 Salato',''),(21,52,'9 Vere Road',''),(22,52,'9 Vere',''),(23,53,'6 Waimate',''),(24,56,'FAS Costing Sheet','W3399-18_Burger_King_Suva_Central_Level_2_FAS_FE_SPK_383gowh6g0000.xlsx'),(25,56,'Quotation','W3399-18_Burger_King_Suva_Central_Level_2_FAS_FE_SPK.pdf'),(26,56,'LPO','LPO_Copy.pdf'),(27,1,'','afterhours-receiversupport.pdf');

--
-- Table structure for table `projectcosting`
--

CREATE TABLE `projectcosting` (
  `pcid` int(11) NOT NULL AUTO_INCREMENT,
  `projectid` int(11) NOT NULL,
  `date` date NOT NULL,
  `name` varchar(100) NOT NULL,
  `gl_type` varchar(100) NOT NULL,
  `sales_gl` varchar(100) NOT NULL,
  `cogs_gl` varchar(100) NOT NULL,
  `budgeted_material` decimal(10,2) NOT NULL,
  `budgeted_labor` decimal(10,2) NOT NULL,
  `budgeted_others` decimal(10,2) NOT NULL,
  `budgeted_total_cost` decimal(10,2) NOT NULL,
  `contract_value` decimal(10,2) NOT NULL,
  `estimated_profit` decimal(10,2) NOT NULL,
  `contract_vip` decimal(10,2) NOT NULL,
  `notes` varchar(1000) NOT NULL,
  `status` varchar(100) NOT NULL,
  PRIMARY KEY (`pcid`),
  UNIQUE KEY `projectid` (`projectid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectcosting`
--


--
-- Table structure for table `projectcostingdetail`
--

CREATE TABLE `projectcostingdetail` (
  `projectcostingid` int(11) NOT NULL AUTO_INCREMENT,
  `pcid` int(11) NOT NULL,
  `cost_type` varchar(100) NOT NULL,
  `item_id` varchar(100) DEFAULT NULL,
  `item_details` varchar(1000) NOT NULL,
  `narrative` varchar(500) DEFAULT NULL,
  `unit_cost` decimal(10,2) NOT NULL,
  `qty` decimal(10,0) NOT NULL,
  `uom` varchar(20) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `margin` decimal(10,2) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `sales_gl` varchar(100) NOT NULL,
  `cogs_gl` varchar(100) NOT NULL,
  PRIMARY KEY (`projectcostingid`),
  KEY `projectid` (`pcid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectcostingdetail`
--


--
-- Table structure for table `projectcostingdetailbackup`
--

CREATE TABLE `projectcostingdetailbackup` (
  `projectcostingid` int(11) NOT NULL AUTO_INCREMENT,
  `pcid` int(11) NOT NULL,
  `cost_type` varchar(100) NOT NULL,
  `job_costing_sheet_category` char(6) NOT NULL,
  `product_details_nonstock` int(11) DEFAULT NULL,
  `nonstocknarrative` varchar(100) NOT NULL,
  `unit_price` int(11) DEFAULT NULL,
  `stock_details` varchar(20) NOT NULL,
  `stocknarrative` varchar(100) NOT NULL,
  `stock_unit_cost` varchar(20) NOT NULL,
  `other_description` varchar(100) NOT NULL,
  `other_cost` decimal(10,2) NOT NULL,
  `other_narrative` varchar(100) NOT NULL,
  `labor_type` varchar(100) DEFAULT NULL,
  `labor_rate` decimal(10,2) DEFAULT NULL,
  `qty` decimal(10,0) NOT NULL,
  `uom` varchar(20) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `margin` decimal(10,2) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `nonstockprice` decimal(10,2) NOT NULL,
  `stockprice` decimal(20,2) NOT NULL,
  `stockname` varchar(50) NOT NULL,
  `nonstockname` varchar(100) NOT NULL,
  PRIMARY KEY (`projectcostingid`),
  KEY `projectid` (`pcid`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectcostingdetailbackup`
--

INSERT INTO `projectcostingdetailbackup` VALUES (1,1,'materials','ANAL',438,'Testing',438,'','','','',0.00,'','',0.00,5,'each',174.05,40.00,243.67,48.73,0.00,'','DHM-5B Deckhead Mount'),(3,4,'materials','CONVEN',8,'',8,'','','','',0.00,'','',0.00,10,'each',446.70,40.00,625.38,0.00,0.00,'',''),(4,3,'materials','RC',315,'',315,'','','0.00','',0.00,'','',0.00,0,'bag',0.00,50.00,0.00,0.00,0.00,'',''),(5,4,'materials','CONVEN',22,'',22,'','','0.00','',0.00,'','',0.00,10,'each',72.60,40.00,101.64,0.00,0.00,'',''),(8,6,'materials','',NULL,'',NULL,'','','0.00','',0.00,'','',0.00,0,'each',0.00,50.00,0.00,0.00,0.00,'',''),(11,1,'materials','FIRE-S',NULL,'',NULL,'03650D-1','Cabinet','03650D-1','',0.00,'','',0.00,2,'each',90.00,40.00,126.00,0.00,63.00,'FULL CABINET REEL C/',''),(13,1,'labour','',NULL,'',NULL,'','','','',0.00,'','4',25.00,7,'each',175.00,40.00,245.00,0.00,0.00,'',''),(14,2,'labour','',NULL,'',NULL,'','','','',0.00,'','3',17.50,320,'hours',5600.00,40.00,7840.00,0.00,0.00,'',''),(15,2,'materials','ANAL',328,'',328,'','','','',0.00,'',NULL,NULL,15,'each',1506.75,40.00,2109.45,140.63,0.00,'','MX Smoke Detector'),(16,2,'materials','ANAL',403,'',403,'','','','',0.00,'',NULL,NULL,30,'each',480.00,40.00,672.00,22.40,0.00,'','Standard 5 inch base Conventinal '),(17,2,'materials','ANAL',329,'',329,'','','','',0.00,'',NULL,NULL,15,'each',1175.85,40.00,1646.19,109.75,0.00,'','MX Heat Detector'),(18,2,'materials','ANAL',379,'',379,'','','','',0.00,'',NULL,NULL,5,'each',600.00,40.00,840.00,168.00,0.00,'','1.5MM 7/0.50 2 CORE CABLE tps red'),(19,2,'others','TRADE',142,'',142,'','','','',0.00,'',NULL,NULL,25,'each',141.25,40.00,197.75,7.91,0.00,'','25mm conduit'),(21,5,'materials','SEC',NULL,'',NULL,'100','testing','','CONTINGENCY',0.00,'',NULL,NULL,10,'each',0.00,40.00,0.00,0.00,0.00,'PARADOX PRO DETECTOR',''),(22,4,'labour','FIRE-S',NULL,'',NULL,'','','','',0.00,'','3',17.50,15,'hours',262.50,40.00,367.50,0.00,0.00,'',''),(23,5,'labour','',NULL,'',NULL,'','','','',0.00,'','3',17.50,4,'hours',70.00,40.00,98.00,0.00,0.00,'',''),(24,4,'materials','',NULL,'',NULL,'','','','',0.00,'',NULL,NULL,0,'each',0.00,40.00,0.00,0.00,0.00,'',''),(25,5,'materials','SEC',NULL,'',NULL,'10411MG','','','CONTINGENCY',0.00,'',NULL,NULL,5,'each',0.00,40.00,0.00,0.00,0.00,'MAGELIAN WIRELESS SENSOR',''),(26,5,'others','',NULL,'',NULL,'','','','CONTINGENCY',200.00,'',NULL,NULL,1,'each',200.00,40.00,280.00,0.00,0.00,'',''),(27,5,'others','',NULL,'',NULL,'','','','CONTINGENCY',0.00,'','1',150.00,5,'hours',750.00,40.00,1050.00,0.00,0.00,'',''),(28,3,'materials','SEC',NULL,'',NULL,'20307','','','CONTINGENCY',0.00,'',NULL,NULL,0,'each',0.00,40.00,0.00,0.00,0.00,'ELITE TERMINAL FOR 3000/4',''),(29,3,'materials','SEC',NULL,'',NULL,'65120','','65120','CONTINGENCY',0.00,'','3',17.50,1,'each',17.50,40.00,24.50,0.00,0.00,'SP5500 SMART PACK',''),(30,7,'materials','SEC-W',NULL,'Cables',NULL,'60100','QTY 4','','CONTINGENCY',0.00,'','3',17.50,2,'hours',35.00,40.00,49.00,0.00,0.00,'CABLE 4 CORE 2MM-100M',''),(31,9,'materials','FIRE-W',NULL,'',NULL,'2351E','Detectors','','CONTINGENCY',0.00,'',NULL,NULL,10,'each',0.00,40.00,0.00,0.00,0.00,'OPITCAL 300 SERIES SMOKE D',''),(32,9,'materials','',NULL,'',NULL,'','','','CONTINGENCY',0.00,'','3',17.50,90,'hours',1575.00,40.00,2205.00,0.00,0.00,'',''),(33,8,'materials','SEC-W',NULL,'',NULL,'ADCA5DWOC4RP','','ADCA5DWOC4RP','CONTINGENCY',0.00,'',NULL,NULL,0,'each',0.00,40.00,0.00,0.00,0.00,'18205 DISC500 700TVL OUTDO',''),(34,12,'materials','SEC',NULL,'none.',NULL,'65120','Returned items - 2 x DG Pro & 1 x Piezo','','CONTINGENCY',41.91,'','3',17.50,8,'hours',475.28,40.00,665.39,0.00,0.00,'SP5500 SMART PACK',''),(35,12,'materials','SEC',NULL,'',NULL,'100','to be excluded from pack','','CONTINGENCY',0.00,'',NULL,NULL,-2,'each',0.00,40.00,0.00,0.00,0.00,'PARADOX PRO DETECTOR',''),(36,12,'materials','SEC',NULL,'',NULL,'40200','to be excluded from pack.','','CONTINGENCY',0.00,'',NULL,NULL,-1,'each',0.00,40.00,0.00,0.00,0.00,'TOP HAT PIEZO',''),(37,14,'materials','SEC',NULL,'',NULL,'30202','','','CONTINGENCY',0.00,'',NULL,NULL,0,'each',0.00,40.00,0.00,0.00,0.00,'POSIPROX STD CARD',''),(38,16,'materials','CONVEN',5,'',5,'','','','CONTINGENCY',0.00,'','3',NULL,1,'each',1302.06,35.00,1757.78,1757.78,0.00,'','FRONT SERVICE PANEL FP1600'),(39,16,'materials','CONVEN',8,'',8,'','','','CONTINGENCY',0.00,'',NULL,NULL,160,'each',7147.20,35.00,9648.72,60.30,0.00,'','Smoke Detector  '),(40,16,'materials','CONVEN',22,'',22,'','','','CONTINGENCY',0.00,'',NULL,NULL,160,'each',1161.60,35.00,1568.16,9.80,0.00,'','B401 Base'),(41,16,'materials','CONVEN',9,'',9,'','','','CONTINGENCY',0.00,'',NULL,NULL,70,'each',2167.90,35.00,2926.67,41.81,0.00,'','Indi-VIGIL Blue Heat Detector'),(42,16,'materials','CONVEN',26,'',26,'','','','CONTINGENCY',0.00,'',NULL,NULL,21,'each',1204.77,35.00,1626.44,77.45,0.00,'','MCP Indicating Type Surface'),(43,16,'materials','CONVEN',32,'',32,'','','','CONTINGENCY',0.00,'',NULL,NULL,1,'each',374.50,35.00,505.58,505.58,0.00,'','T-Gen 50 24volts'),(44,16,'materials','CONVEN',38,'',38,'','','','CONTINGENCY',0.00,'',NULL,NULL,1,'each',114.88,35.00,155.09,155.09,0.00,'','Hand Held Microphone T Gen 50'),(45,16,'materials','CONVEN',40,'',40,'','','','CONTINGENCY',0.00,'',NULL,NULL,1,'each',584.25,35.00,788.74,788.74,0.00,'','Power Supply 12V/24volts'),(46,16,'materials','CONVEN',43,'',43,'','','','CONTINGENCY',0.00,'',NULL,NULL,21,'each',1355.55,35.00,1829.99,87.14,0.00,'','Horn speaker'),(47,16,'materials','CONVEN',45,'',45,'','','','CONTINGENCY',0.00,'',NULL,NULL,3,'each',96.57,35.00,130.37,43.46,0.00,'','Speakers'),(48,16,'materials','CONVEN',46,'',46,'','','','CONTINGENCY',0.00,'',NULL,NULL,1,'each',83.34,35.00,112.51,112.51,0.00,'','External Fire Alarm Strobe'),(49,16,'materials','CONVEN',52,'',52,'','','','CONTINGENCY',0.00,'',NULL,NULL,3,'each',136.71,35.00,184.56,61.52,0.00,'','12V 6.5 AMP BATTERY'),(50,16,'materials','CONVEN',66,'',66,'','','','CONTINGENCY',0.00,'',NULL,NULL,30,'each',3600.00,35.00,4860.00,162.00,0.00,'','1.5MM 7/0.50 2 CORE CABLE tps red'),(51,16,'materials','CONVEN',67,'',67,'','','','CONTINGENCY',0.00,'',NULL,NULL,18,'each',3564.00,35.00,4811.40,267.30,0.00,'','2.5MM 7/0.67 PVC TPS CABLE tps red'),(52,16,'labour','CONVEN',NULL,'',NULL,'','','','CONTINGENCY',0.00,'','3',17.50,600,'hours',10500.00,35.00,14175.00,0.00,0.00,'',''),(53,16,'others','CONVEN',NULL,'',NULL,'','','','VEHICLE',330.00,'',NULL,NULL,1,'each',330.00,35.00,445.50,0.00,0.00,'',''),(54,16,'others','CONVEN',NULL,'',NULL,'','','','OTHER',2500.00,'',NULL,NULL,1,'each',2500.00,35.00,3375.00,0.00,0.00,'',''),(55,16,'others','CONVEN',NULL,'',NULL,'','','','SHROULD',800.00,'',NULL,NULL,1,'each',800.00,35.00,1080.00,0.00,0.00,'',''),(56,16,'others','CONVEN',NULL,'',NULL,'','','','INDEX ENGRAVING',250.00,'',NULL,NULL,1,'each',250.00,35.00,337.50,0.00,0.00,'',''),(57,16,'others','CONVEN',NULL,'',NULL,'','','','CONTINGENCY',1300.00,'',NULL,NULL,1,'each',1300.00,35.00,1755.00,0.00,0.00,'',''),(58,16,'others','CONVEN',NULL,'',NULL,'','','','FPIS INSPECTION/ICONZ',200.00,'',NULL,NULL,1,'each',200.00,35.00,270.00,0.00,0.00,'','');

--
-- Table structure for table `projectcostingdetaillabor`
--

CREATE TABLE `projectcostingdetaillabor` (
  `pclaborid` int(11) NOT NULL AUTO_INCREMENT,
  `pcid` int(11) NOT NULL,
  `labortypeid` tinyint(4) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `hours` decimal(10,0) NOT NULL,
  `total_labor` decimal(10,2) NOT NULL,
  `margin` decimal(10,2) NOT NULL,
  `labor_price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`pclaborid`),
  KEY `projectid` (`pcid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectcostingdetaillabor`
--

INSERT INTO `projectcostingdetaillabor` VALUES (1,1,1,150.00,2,300.00,40.00,420.00),(2,2,3,17.50,16,280.00,50.00,420.00),(3,3,2,50.00,30,1500.00,40.00,2100.00),(4,5,3,17.50,80,1400.00,40.00,1960.00),(5,4,3,17.50,45,787.50,40.00,1102.50);

--
-- Table structure for table `projectdetails`
--

CREATE TABLE `projectdetails` (
  `projectid` int(11) NOT NULL AUTO_INCREMENT,
  `project_type` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `prospectid` int(11) NOT NULL,
  `project_name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `employees_allocated` text NOT NULL,
  `customer` varchar(10) NOT NULL,
  `branch` varchar(100) DEFAULT NULL,
  `account_number` varchar(100) NOT NULL,
  `sys_account_number` int(11) DEFAULT NULL,
  `department` varchar(100) NOT NULL,
  `purchase_order` varchar(100) NOT NULL,
  `contact_person` varchar(20) NOT NULL,
  `contact_number` varchar(20) NOT NULL,
  `project_manager` varchar(20) NOT NULL,
  `required_date` date NOT NULL,
  `retention_rate` decimal(10,2) NOT NULL,
  `tender_close_date` date DEFAULT NULL,
  `start_date` date NOT NULL,
  `age` decimal(10,2) NOT NULL,
  `comments` text NOT NULL,
  `reviewers_comments` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `managed_by` varchar(100) DEFAULT NULL,
  `completed` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`projectid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectdetails`
--

INSERT INTO `projectdetails` VALUES (1,'Small Jobs','2019-06-01',0,'test','','','162','162','',NULL,'12','','','','','0000-00-00',0.00,NULL,'0000-00-00',0.00,'','','Project Started','admin',NULL);

--
-- Table structure for table `projectdetailsreports`
--

CREATE TABLE `projectdetailsreports` (
  `projectid` int(11) NOT NULL AUTO_INCREMENT,
  `budgeted_labor` decimal(10,2) NOT NULL,
  `budgeted_material` decimal(10,2) NOT NULL,
  `budgeted_others` decimal(10,2) NOT NULL,
  `budgeted_total_cost` decimal(10,2) NOT NULL,
  `budgeted_total_price` decimal(10,2) NOT NULL,
  `budgeted_profit` decimal(10,2) NOT NULL,
  `margin` decimal(10,2) NOT NULL,
  `actual_labor_cost` decimal(10,2) NOT NULL,
  `actual_material_cost` decimal(10,2) NOT NULL,
  `actual_other_cost` decimal(10,2) NOT NULL,
  `actual_total_cost` decimal(10,2) NOT NULL,
  `estimate_ctc_project_manager` decimal(10,2) NOT NULL,
  `estimate_ctc_accs` decimal(10,2) NOT NULL,
  `estimate_ctc_total` decimal(10,2) NOT NULL,
  `estimate_final_cost` decimal(10,2) NOT NULL,
  `variance_estimate_finalcost_to_buget` decimal(10,2) NOT NULL,
  `estimate_final_profit` decimal(10,2) NOT NULL,
  `estimate_gp` decimal(10,2) NOT NULL,
  `profit_taken_up_to_date` decimal(10,2) NOT NULL,
  `wip_crosscheck` decimal(10,2) NOT NULL,
  `profit_to_come` decimal(10,2) NOT NULL,
  `invoiced` decimal(10,2) NOT NULL,
  `invoicing_to_come` decimal(10,2) NOT NULL,
  `nett_wip` decimal(10,2) NOT NULL,
  `labor_usage` decimal(10,0) NOT NULL,
  `material_usage` decimal(10,0) NOT NULL,
  `others_usage` decimal(10,0) NOT NULL,
  `sales_taken_up` decimal(10,2) NOT NULL,
  `cos_taken_up` decimal(10,2) NOT NULL,
  `profit_taken_up` decimal(10,2) NOT NULL,
  `ctc_invoiced` decimal(10,0) NOT NULL,
  `actual_cost_spent_against_est_final_cost` decimal(10,0) NOT NULL,
  `sales_based_on_cost_spent` decimal(10,0) NOT NULL,
  `cos_based_on_ctc` decimal(10,0) NOT NULL,
  `gm_based_on_ctc` decimal(10,0) NOT NULL,
  `sales_taken_upto_date` decimal(10,2) NOT NULL,
  `cos_taken_upto_date` decimal(10,2) NOT NULL,
  `gm_taken_upto_date` decimal(10,2) NOT NULL,
  `cd_taken_upto_date` decimal(10,2) NOT NULL,
  `sales_to_be_taken_up` decimal(10,2) NOT NULL,
  `cos_to_be_taken_up` decimal(10,2) NOT NULL,
  `gm_to_be_taken_up` decimal(10,2) NOT NULL,
  `cd_to_be_taken_up` decimal(10,2) NOT NULL,
  `sales_progress` decimal(10,2) NOT NULL,
  `cos_progress` decimal(10,2) NOT NULL,
  `profit_or_loss_progress` decimal(10,2) NOT NULL,
  `cd_progress` decimal(10,2) NOT NULL,
  `progress_ratio` decimal(10,2) NOT NULL,
  PRIMARY KEY (`projectid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectdetailsreports`
--

INSERT INTO `projectdetailsreports` VALUES (2,750.00,1394.00,0.00,2144.00,3366.67,1346.67,40.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0.00,0.00,0.00,0,0,0,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00);

--
-- Table structure for table `prospect_notes`
--

CREATE TABLE `prospect_notes` (
  `notes_id` int(11) NOT NULL AUTO_INCREMENT,
  `prospectid` int(11) NOT NULL,
  `date` date NOT NULL,
  `notes` varchar(100) NOT NULL,
  PRIMARY KEY (`notes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prospect_notes`
--


--
-- Table structure for table `prospect_stages`
--

CREATE TABLE `prospect_stages` (
  `stage_id` int(11) NOT NULL AUTO_INCREMENT,
  `prospectid` int(11) NOT NULL,
  `date` date NOT NULL,
  `name` varchar(100) NOT NULL,
  `phase_name` varchar(100) NOT NULL,
  `duration_days` int(11) NOT NULL,
  PRIMARY KEY (`stage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prospect_stages`
--

INSERT INTO `prospect_stages` VALUES (1,1,'2019-05-01','First meetings','Meeting',3);

--
-- Table structure for table `prospecting`
--

CREATE TABLE `prospecting` (
  `prospectid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `date_entered` date NOT NULL,
  `customer` int(11) NOT NULL,
  `business_name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `contact_person` varchar(100) CHARACTER SET utf8 NOT NULL,
  `phone` int(11) NOT NULL,
  `mobile` int(11) NOT NULL,
  `email` varchar(100) CHARACTER SET utf8 NOT NULL,
  `address` varchar(100) CHARACTER SET utf8 NOT NULL,
  `suburb` varchar(100) CHARACTER SET utf8 NOT NULL,
  `department` int(11) NOT NULL,
  `products_interested_in` varchar(100) CHARACTER SET utf8 NOT NULL,
  `probability_of_conversion` varchar(100) CHARACTER SET utf8 NOT NULL,
  `phases` varchar(100) CHARACTER SET utf8 NOT NULL,
  `deal_value` decimal(10,2) NOT NULL,
  `lead_source` varchar(100) NOT NULL,
  `prospect_type` varchar(100) NOT NULL,
  `revenue_projection_date` date NOT NULL,
  `margin` decimal(10,2) NOT NULL DEFAULT '0.00',
  `jan_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `feb_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `mar_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `apr_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `may_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `jun_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `jul_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `aug_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `sept_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `oct_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `nov_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `dec_projection` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cy_total_year1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cy_total_year2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cy_total_year3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tender_close_date` date NOT NULL,
  PRIMARY KEY (`prospectid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prospecting`
--

INSERT INTO `prospecting` VALUES (1,'2016-07-12',383,'Westpac Bank-suva headoffice','Mr something',3311664,9223300,'info@westpac.com.au','main street','Suva',18,'Cameras with  monitoring','60%','Discussion',10000000.00,'Existing Customer','','2016-08-10',0.30,0.00,0.00,0.00,0.00,0.00,0.00,0.00,50000.00,30000.00,30000.00,30000.00,30000.00,170000.00,340000.00,340000.00,'0000-00-00'),(2,'2016-07-13',0,'ANZ bank','Happy Smitch',3213000,9996850,'happy@anz.com.au','kalabo','Valelevu',18,'Security Seal Chambers','40%','Negotiating',25000000.00,'Networking Events','','2017-01-03',0.20,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,70000.00,840000.00,1680000.00,2520000.00,'0000-00-00'),(3,'2019-05-13',0,'Capital Insurance','Tevita',0,0,'','','',6,'','','Lead',25000.00,'facebook','','0000-00-00',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'0000-00-00'),(4,'2019-01-02',1996,'Suva Campus','',0,0,'','','',6,'','','Tender Won',3000000.00,'Existing Customer','Tender','0000-00-00',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'0000-00-00'),(5,'2019-05-03',0,'New customer test','test',9223300,0,'','','sachinebusiness@gmail.com',11,'','','Discussion',2500.00,'facebook','General','0000-00-00',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'0000-00-00'),(6,'2019-05-29',2052,'WALT SMITH - LAUTOKA','DEB',0,0,'','','LAUTOKA',10,'','','Discussion',0.00,'Existing Customer','General','0000-00-00',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'0000-00-00'),(7,'2019-07-11',0,'Test','test name',954786,9223300,'','','suva',0,'test','60%','Lead',50000.00,'Networking Events','General','2019-08-01',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'0000-00-00');

--
-- Table structure for table `provisional_tax_management`
--

CREATE TABLE `provisional_tax_management` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `name` varchar(100) NOT NULL,
  `invoice` varchar(100) NOT NULL,
  `invoice_amount` decimal(10,2) NOT NULL,
  `ptax` decimal(10,2) NOT NULL,
  `comment` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `provisional_tax_management`
--

INSERT INTO `provisional_tax_management` VALUES (1,'2017-12-18','612','3454',4.50,0.23,''),(2,'0000-00-00','383','3443',53376.00,2448.44,'');

--
-- Table structure for table `provisional_tax_management_manual`
--

CREATE TABLE `provisional_tax_management_manual` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `name` varchar(100) NOT NULL,
  `invoice` varchar(100) NOT NULL,
  `invoice_amount` decimal(10,2) NOT NULL,
  `ptax` decimal(10,2) NOT NULL,
  `comment` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `provisional_tax_management_manual`
--

INSERT INTO `provisional_tax_management_manual` VALUES (1,'2017-10-30','433','6678',23.70,1.19,'');

--
-- Table structure for table `publicholidaycalender`
--

CREATE TABLE `publicholidaycalender` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `ocassion` varchar(100) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `publicholidaycalender`
--

INSERT INTO `publicholidaycalender` VALUES (1,'New YearÔÇÖs Day','2017-01-02'),(2,'Good Friday','2017-04-14'),(3,'Easter Saturday','2017-04-15'),(4,'Easter Monday','2017-04-17'),(5,'National Sports Day','2017-06-30'),(6,'Constitution Day','2017-09-07'),(7,'Fiji Day','2017-10-10'),(8,'Diwali','2017-10-19'),(9,'Prophet MohammedÔÇÖs Birthday','2017-12-04'),(10,'Christmas Day','2017-12-25'),(11,'Boxing Day','2017-12-26');

--
-- 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 NOT NULL DEFAULT '1',
  `supplierdescription` char(50) NOT NULL DEFAULT '',
  `leadtime` smallint(6) NOT NULL DEFAULT '1',
  `preferred` tinyint(4) NOT NULL DEFAULT '0',
  `effectivefrom` date NOT NULL,
  `suppliers_partno` varchar(50) NOT NULL DEFAULT '',
  `minorderqty` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`supplierno`,`stockid`,`effectivefrom`),
  KEY `StockID` (`stockid`),
  KEY `SupplierNo` (`supplierno`),
  KEY `Preferred` (`preferred`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchdata`
--


--
-- Table structure for table `purchorderauth`
--

CREATE TABLE `purchorderauth` (
  `userid` varchar(20) NOT NULL DEFAULT '',
  `currabrev` char(3) NOT NULL DEFAULT '',
  `cancreate` smallint(2) NOT NULL DEFAULT '0',
  `authlevel` double NOT NULL DEFAULT '0',
  `offhold` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`,`currabrev`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchorderauth`
--

INSERT INTO `purchorderauth` VALUES ('admin','FJD',0,10000,0),('akumar','FJD',0,0,0);

--
-- 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 '0',
  `deliverydate` date NOT NULL DEFAULT '0000-00-00',
  `itemdescription` varchar(100) NOT NULL,
  `glcode` varchar(20) NOT NULL DEFAULT '0',
  `qtyinvoiced` double NOT NULL DEFAULT '0',
  `unitprice` double NOT NULL DEFAULT '0',
  `actprice` double NOT NULL DEFAULT '0',
  `stdcostunit` double NOT NULL DEFAULT '0',
  `quantityord` double NOT NULL DEFAULT '0',
  `quantityrecd` double NOT NULL DEFAULT '0',
  `shiptref` int(11) NOT NULL DEFAULT '0',
  `jobref` varchar(20) NOT NULL DEFAULT '',
  `completed` tinyint(4) NOT NULL DEFAULT '0',
  `suppliersunit` varchar(50) DEFAULT NULL,
  `suppliers_partno` varchar(50) NOT NULL DEFAULT '',
  `assetid` int(11) NOT NULL DEFAULT '0',
  `conversionfactor` double NOT NULL DEFAULT '1',
  PRIMARY KEY (`podetailitem`),
  KEY `DeliveryDate` (`deliverydate`),
  KEY `GLCode` (`glcode`),
  KEY `ItemCode` (`itemcode`),
  KEY `JobRef` (`jobref`),
  KEY `OrderNo` (`orderno`),
  KEY `ShiptRef` (`shiptref`),
  KEY `Completed` (`completed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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 NOT NULL DEFAULT '1',
  `dateprinted` datetime DEFAULT NULL,
  `allowprint` tinyint(4) NOT NULL DEFAULT '1',
  `initiator` varchar(20) 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 '',
  `deladd5` varchar(20) NOT NULL DEFAULT '',
  `deladd6` varchar(15) NOT NULL DEFAULT '',
  `tel` varchar(30) NOT NULL DEFAULT '',
  `suppdeladdress1` varchar(40) NOT NULL DEFAULT '',
  `suppdeladdress2` varchar(40) NOT NULL DEFAULT '',
  `suppdeladdress3` varchar(40) NOT NULL DEFAULT '',
  `suppdeladdress4` varchar(40) NOT NULL DEFAULT '',
  `suppdeladdress5` varchar(20) NOT NULL DEFAULT '',
  `suppdeladdress6` varchar(15) NOT NULL DEFAULT '',
  `suppliercontact` varchar(30) NOT NULL DEFAULT '',
  `supptel` varchar(30) NOT NULL DEFAULT '',
  `contact` varchar(30) NOT NULL DEFAULT '',
  `version` decimal(3,2) NOT NULL DEFAULT '1.00',
  `revised` date NOT NULL DEFAULT '0000-00-00',
  `realorderno` varchar(16) NOT NULL DEFAULT '',
  `deliveryby` varchar(100) NOT NULL DEFAULT '',
  `deliverydate` date NOT NULL DEFAULT '0000-00-00',
  `status` varchar(12) NOT NULL DEFAULT '',
  `stat_comment` text NOT NULL,
  `paymentterms` char(2) NOT NULL DEFAULT '',
  `port` varchar(40) NOT NULL DEFAULT '',
  `projectid` tinyint(4) NOT NULL,
  `projectperiodid` tinyint(4) NOT NULL,
  `department` varchar(100) NOT NULL,
  PRIMARY KEY (`orderno`),
  KEY `OrdDate` (`orddate`),
  KEY `SupplierNo` (`supplierno`),
  KEY `IntoStockLocation` (`intostocklocation`),
  KEY `AllowPrintPO` (`allowprint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchorders`
--


--
-- Table structure for table `qasamples`
--

CREATE TABLE `qasamples` (
  `sampleid` int(11) NOT NULL AUTO_INCREMENT,
  `prodspeckey` varchar(25) NOT NULL DEFAULT '',
  `lotkey` varchar(25) NOT NULL DEFAULT '',
  `identifier` varchar(10) NOT NULL DEFAULT '',
  `createdby` varchar(15) NOT NULL DEFAULT '',
  `sampledate` date NOT NULL DEFAULT '0000-00-00',
  `comments` varchar(255) NOT NULL DEFAULT '',
  `cert` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sampleid`),
  KEY `prodspeckey` (`prodspeckey`,`lotkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qasamples`
--


--
-- Table structure for table `qatests`
--

CREATE TABLE `qatests` (
  `testid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `method` varchar(20) DEFAULT NULL,
  `groupby` varchar(20) DEFAULT NULL,
  `units` varchar(20) NOT NULL,
  `type` varchar(15) NOT NULL,
  `defaultvalue` varchar(150) NOT NULL DEFAULT '''''',
  `numericvalue` tinyint(4) NOT NULL DEFAULT '0',
  `showoncert` int(11) NOT NULL DEFAULT '1',
  `showonspec` int(11) NOT NULL DEFAULT '1',
  `showontestplan` tinyint(4) NOT NULL DEFAULT '1',
  `active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`testid`),
  KEY `name` (`name`),
  KEY `groupname` (`groupby`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qatests`
--


--
-- Table structure for table `quickpay_bank`
--

CREATE TABLE `quickpay_bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(100) NOT NULL,
  `code` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quickpay_bank`
--

INSERT INTO `quickpay_bank` VALUES (1,'Westpac',3),(2,'ANZ',9),(3,'Bank of South Pacific',7),(4,'Bank of Baroda',5),(5,'BRED Bank',11);

--
-- Table structure for table `quickpay_bank_branch`
--

CREATE TABLE `quickpay_bank_branch` (
  `branch_id` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` int(3) NOT NULL,
  PRIMARY KEY (`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quickpay_bank_branch`
--


--
-- Table structure for table `quickpay_batchnumbers`
--

CREATE TABLE `quickpay_batchnumbers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batchtype` int(11) NOT NULL,
  `batch_#` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quickpay_batchnumbers`
--

INSERT INTO `quickpay_batchnumbers` VALUES (1,1,201),(2,1,202),(3,1,203),(4,1,204),(5,1,205),(6,1,206),(7,1,207),(8,1,208),(9,1,209),(10,1,210),(11,2,211),(12,2,212),(13,2,213),(14,2,214),(15,2,215),(16,2,216),(17,2,217),(18,2,218),(19,2,219),(20,2,220),(21,3,221),(22,3,222),(23,3,223),(24,3,224),(25,3,225),(26,3,226),(27,3,227),(28,3,228),(29,3,229),(30,3,230),(31,4,231),(32,4,232),(33,4,233),(34,4,234),(35,4,235),(36,4,236),(37,4,237),(38,4,238),(39,4,239),(40,4,240),(41,5,241),(42,5,242),(43,5,243),(44,5,244),(45,5,245),(46,5,246),(47,5,247),(48,5,248),(49,5,249),(50,5,250),(51,6,251),(52,6,252),(53,6,253),(54,6,254),(55,6,255),(56,6,256),(57,6,257),(58,6,258),(59,6,259),(60,6,260);

--
-- Table structure for table `quickpay_batchtype`
--

CREATE TABLE `quickpay_batchtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quickpay_batchtype`
--

INSERT INTO `quickpay_batchtype` VALUES (1,'Weekly pays'),(2,'Fortnightly pays'),(3,'Monthly pays'),(4,'Casual/Temp pays'),(5,'Bonus Pays'),(6,'Other');

--
-- Table structure for table `quoteorderdetails`
--

CREATE TABLE `quoteorderdetails` (
  `orderlineno` int(11) NOT NULL,
  `orderno` int(11) NOT NULL,
  `stkcode` int(11) NOT NULL,
  `stock_name` varchar(100) DEFAULT NULL,
  `qtyinvoiced` double NOT NULL DEFAULT '0',
  `unitprice` decimal(10,4) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `taxlabel` varchar(50) NOT NULL,
  `uom` varchar(100) DEFAULT NULL,
  `cost_price` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `sales_gl` varchar(100) NOT NULL,
  `cogs_gl` varchar(100) NOT NULL,
  `estimate` tinyint(4) NOT NULL DEFAULT '0',
  `discountpercent` double NOT NULL DEFAULT '0',
  `actualdispatchdate` datetime DEFAULT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `narrative` text,
  `itemdue` date DEFAULT NULL COMMENT 'Due date for line item.  Some customers require \r\nacknowledgements with due dates by line item',
  `poline` varchar(10) DEFAULT NULL COMMENT 'Some Customers require acknowledgements with a PO line number for each sales line',
  PRIMARY KEY (`orderlineno`,`orderno`),
  KEY `OrderNo` (`orderno`),
  KEY `StkCode` (`stkcode`),
  KEY `Completed` (`completed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quoteorderdetails`
--


--
-- Table structure for table `quoteorderdetailsrefund`
--

CREATE TABLE `quoteorderdetailsrefund` (
  `orderlineno` int(11) NOT NULL,
  `orderno` int(11) NOT NULL,
  `stkcode` int(11) NOT NULL,
  `stock_name` varchar(100) DEFAULT NULL,
  `qtyinvoiced` double NOT NULL DEFAULT '0',
  `unitprice` decimal(10,4) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `taxlabel` varchar(50) NOT NULL,
  `uom` varchar(100) DEFAULT NULL,
  `cost_price` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `sales_gl` varchar(100) NOT NULL,
  `cogs_gl` varchar(100) NOT NULL,
  `estimate` tinyint(4) NOT NULL DEFAULT '0',
  `discountpercent` double NOT NULL DEFAULT '0',
  `actualdispatchdate` datetime DEFAULT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `narrative` text,
  `itemdue` date DEFAULT NULL COMMENT 'Due date for line item.  Some customers require \r\nacknowledgements with due dates by line item',
  `poline` varchar(10) DEFAULT NULL COMMENT 'Some Customers require acknowledgements with a PO line number for each sales line',
  PRIMARY KEY (`orderlineno`,`orderno`),
  KEY `OrderNo` (`orderno`),
  KEY `StkCode` (`stkcode`),
  KEY `Completed` (`completed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quoteorderdetailsrefund`
--

INSERT INTO `quoteorderdetailsrefund` VALUES (0,1,1,'consulting fees',1,225.0000,1,'','each',0.00,225.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-10',''),(0,2,1,'consulting fees',1,225.0000,1,'','each',0.00,225.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-10',''),(0,3,2,'Whiteboard Cleaner 118ml',150,5.2000,150,'','each',0.00,780.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(0,4,1,'service consulting fees',1,225.0000,1,'','each',0.00,225.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(0,5,1,'service consulting fees',1,225.0000,1,'','each',0.00,225.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(0,6,1,'service consulting fees',1,225.0000,1,'','each',0.00,225.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(0,7,2,'Whiteboard Cleaner 118ml',15,5.2000,15,'','each',0.00,78.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-18',''),(1,1,4,'Test for 3 tax',1,8.4000,1,'','each',0.00,8.40,0.00,'','',0,0,NULL,0,NULL,'2019-07-10',''),(1,2,2,'Whiteboard Cleaner 118ml',4,5.2000,4,'','each',0.00,20.80,0.00,'','',0,0,NULL,0,NULL,'2019-07-10',''),(1,3,1,'consulting fees',5,225.0000,5,'','each',0.00,1125.00,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(1,4,4,'Test for 3 tax',1,8.4000,1,'','each',0.00,8.40,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(1,5,5,'test for 2 tax',1,18.5000,1,'','each',0.00,18.50,0.00,'','',0,0,NULL,0,NULL,'2019-07-11',''),(1,6,4,'Test for 3 tax',1,8.4000,1,'','each',0.00,8.40,0.00,'','',0,0,NULL,0,NULL,'2019-07-11','');

--
-- Table structure for table `quoteorders`
--

CREATE TABLE `quoteorders` (
  `orderno` int(11) NOT NULL,
  `invoice_type` varchar(50) NOT NULL,
  `lpo` varchar(100) DEFAULT NULL,
  `debtorno` varchar(10) NOT NULL DEFAULT '',
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `account_number` varchar(11) DEFAULT NULL,
  `job_no` tinyint(4) DEFAULT NULL,
  `billing_id` int(11) DEFAULT NULL,
  `bill_id` int(11) DEFAULT NULL,
  `customerref` varchar(50) DEFAULT NULL,
  `buyername` varchar(50) DEFAULT NULL,
  `comments` longblob,
  `orddate` date NOT NULL,
  `ordertype` char(2) NOT NULL DEFAULT '',
  `shipvia` int(11) NOT NULL DEFAULT '0',
  `delivery_address` varchar(200) NOT NULL,
  `deladd1` varchar(40) NOT NULL DEFAULT '',
  `deladd2` varchar(40) NOT NULL DEFAULT '',
  `deladd3` varchar(40) NOT NULL DEFAULT '',
  `deladd4` varchar(40) DEFAULT NULL,
  `deladd5` varchar(20) NOT NULL DEFAULT '',
  `deladd6` varchar(15) NOT NULL DEFAULT '',
  `contactphone` varchar(25) DEFAULT NULL,
  `contactemail` varchar(40) DEFAULT NULL,
  `deliverto` varchar(100) DEFAULT NULL,
  `deliverblind` tinyint(1) DEFAULT '1',
  `freightcost` double NOT NULL DEFAULT '0',
  `fromstkloc` varchar(5) NOT NULL DEFAULT '',
  `deliverydate` date DEFAULT NULL,
  `confirmeddate` date DEFAULT NULL,
  `printedpackingslip` tinyint(4) NOT NULL DEFAULT '0',
  `datepackingslipprinted` date DEFAULT NULL,
  `quotation` tinyint(4) NOT NULL DEFAULT '0',
  `amount` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `retention_rate` decimal(10,2) NOT NULL,
  `retention_amount` decimal(10,2) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `status` varchar(100) DEFAULT NULL,
  `quotedate` date NOT NULL,
  `sdc_invoice_no` varchar(2000) NOT NULL,
  `poplaced` tinyint(4) NOT NULL DEFAULT '0',
  `department` varchar(100) DEFAULT NULL,
  `preparedby` varchar(20) NOT NULL,
  `gl_posted` tinyint(1) NOT NULL,
  `cancelled` tinyint(1) NOT NULL,
  `cancelled_by` int(100) NOT NULL,
  `cancel_reason` varchar(100) NOT NULL,
  PRIMARY KEY (`orderno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quoteorders`
--


--
-- Table structure for table `quoteordersrefund`
--

CREATE TABLE `quoteordersrefund` (
  `orderno` int(11) NOT NULL,
  `invoice_type` varchar(50) NOT NULL,
  `lpo` varchar(100) DEFAULT NULL,
  `debtorno` varchar(10) NOT NULL DEFAULT '',
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `account_number` varchar(11) DEFAULT NULL,
  `job_no` tinyint(4) DEFAULT NULL,
  `billing_id` int(11) DEFAULT NULL,
  `bill_id` int(11) DEFAULT NULL,
  `customerref` varchar(50) DEFAULT NULL,
  `buyername` varchar(50) DEFAULT NULL,
  `comments` longblob,
  `orddate` date NOT NULL,
  `ordertype` char(2) NOT NULL DEFAULT '',
  `shipvia` int(11) NOT NULL DEFAULT '0',
  `delivery_address` varchar(200) NOT NULL,
  `deladd1` varchar(40) NOT NULL DEFAULT '',
  `deladd2` varchar(40) NOT NULL DEFAULT '',
  `deladd3` varchar(40) NOT NULL DEFAULT '',
  `deladd4` varchar(40) DEFAULT NULL,
  `deladd5` varchar(20) NOT NULL DEFAULT '',
  `deladd6` varchar(15) NOT NULL DEFAULT '',
  `contactphone` varchar(25) DEFAULT NULL,
  `contactemail` varchar(40) DEFAULT NULL,
  `deliverto` varchar(100) DEFAULT NULL,
  `deliverblind` tinyint(1) DEFAULT '1',
  `freightcost` double NOT NULL DEFAULT '0',
  `fromstkloc` varchar(5) NOT NULL DEFAULT '',
  `deliverydate` date DEFAULT NULL,
  `confirmeddate` date DEFAULT NULL,
  `printedpackingslip` tinyint(4) NOT NULL DEFAULT '0',
  `datepackingslipprinted` date DEFAULT NULL,
  `quotation` tinyint(4) NOT NULL DEFAULT '0',
  `amount` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `retention_rate` decimal(10,2) NOT NULL,
  `retention_amount` decimal(10,2) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `status` varchar(100) DEFAULT NULL,
  `quotedate` date NOT NULL,
  `sdc_invoice_no` varchar(2000) NOT NULL,
  `poplaced` tinyint(4) NOT NULL DEFAULT '0',
  `department` varchar(100) DEFAULT NULL,
  `preparedby` varchar(20) NOT NULL,
  `gl_posted` tinyint(1) NOT NULL,
  `cancelled` tinyint(1) NOT NULL,
  `cancelled_by` int(100) NOT NULL,
  `cancel_reason` varchar(100) NOT NULL,
  PRIMARY KEY (`orderno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quoteordersrefund`
--

INSERT INTO `quoteordersrefund` VALUES (1,'','','1','','1',0,NULL,NULL,NULL,NULL,'trsbfbsf','2019-07-10','DF',1,'','','','','','','','','','Six Sigma Academy',1,0,'SUVA','2019-07-10','2019-07-10',0,NULL,1,233.40,233.40,0.00,0.00,0.00,'Not Invoiced','2019-07-10','ECEZSZXZ-T5UX48AJ-672',0,'26','E-Business',0,0,0,''),(2,'','','1','','1',0,NULL,NULL,NULL,NULL,'','2019-07-10','DF',1,'','','','','','','','','','Six Sigma Academy',1,0,'SUVA','2019-07-10','2019-07-10',0,NULL,1,245.80,245.80,0.00,0.00,0.00,'Not Invoiced','2019-07-10','ECEZSZXZ-T5UX48AJ-702',0,'0','E-Business',0,0,0,''),(3,'Proforma','','1','','1',0,NULL,NULL,NULL,NULL,'','2019-07-11','DF',1,'','','','','','','','','','Six Sigma Academy',1,0,'SUVA','2019-07-11','2019-07-11',0,NULL,1,1905.00,1905.00,0.00,0.00,0.00,'Not Invoiced','2019-07-11','ECEZSZXZ-T5UX48AJ-713',0,'0','E-Business',0,0,0,''),(4,'Proforma','','4','','2',0,NULL,NULL,NULL,NULL,'','2019-07-11','DF',1,'','','','','','','','','','Fantastic Pte Ltd',1,0,'SUVA','2019-07-11','2019-07-11',0,NULL,1,233.40,233.40,0.00,0.00,0.00,'Not Invoiced','2019-07-11','ECEZSZXZ-T5UX48AJ-727',0,'27','E-Business',0,0,0,''),(5,'Proforma','','4','','2',0,NULL,NULL,NULL,NULL,'','2019-07-11','DF',1,'','','','','','','','','','Fantastic Pte Ltd',1,0,'SUVA','2019-07-11','2019-07-11',0,NULL,1,243.50,243.50,0.00,0.00,0.00,'Not Invoiced','2019-07-11','ECEZSZXZ-T5UX48AJ-730',0,'0','E-Business',0,0,0,''),(6,'Proforma','','4','','2',0,NULL,NULL,NULL,NULL,'','2019-07-11','DF',1,'','','','','','','','','','Fantastic Pte Ltd',1,0,'SUVA','2019-07-11','2019-07-11',0,NULL,1,233.40,233.40,0.00,0.00,0.00,'Not Invoiced','2019-07-11','ECEZSZXZ-T5UX48AJ-731',0,'26','E-Business',0,0,0,''),(7,'Proforma','','5','','',0,NULL,NULL,NULL,NULL,'','2019-07-18','DF',1,'','','','','','','','','','consumer test',1,0,'SUVA','2019-07-18','2019-07-18',0,NULL,1,78.00,78.00,0.00,0.00,0.00,'Not Invoiced','2019-07-18','DWBYJ7SE-T5UX48AJ-36',0,'26','E-Business',0,0,0,'');

--
-- Table structure for table `recurringsalesorders`
--

CREATE TABLE `recurringsalesorders` (
  `recurrorderno` int(11) NOT NULL,
  `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(40) NOT NULL DEFAULT '',
  `deladd3` varchar(40) NOT NULL DEFAULT '',
  `deladd4` varchar(40) DEFAULT NULL,
  `deladd5` varchar(20) NOT NULL DEFAULT '',
  `deladd6` varchar(15) NOT NULL DEFAULT '',
  `contactphone` varchar(25) DEFAULT NULL,
  `contactemail` varchar(25) DEFAULT NULL,
  `deliverto` varchar(40) NOT NULL DEFAULT '',
  `freightcost` double NOT NULL DEFAULT '0',
  `fromstkloc` varchar(5) NOT NULL DEFAULT '',
  `lastrecurrence` date NOT NULL DEFAULT '0000-00-00',
  `stopdate` date NOT NULL DEFAULT '0000-00-00',
  `frequency` tinyint(4) NOT NULL DEFAULT '1',
  `autoinvoice` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`recurrorderno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `recurringsalesorders`
--


--
-- Table structure for table `recurrsalesorderdetails`
--

CREATE TABLE `recurrsalesorderdetails` (
  `recurrorderno` int(11) NOT NULL DEFAULT '0',
  `stkcode` varchar(20) NOT NULL DEFAULT '',
  `unitprice` double NOT NULL DEFAULT '0',
  `quantity` double NOT NULL DEFAULT '0',
  `discountpercent` double NOT NULL DEFAULT '0',
  `narrative` text NOT NULL,
  KEY `orderno` (`recurrorderno`),
  KEY `stkcode` (`stkcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `recurrsalesorderdetails`
--


--
-- Table structure for table `refund_item_details`
--

CREATE TABLE `refund_item_details` (
  `orderlineno` int(11) NOT NULL,
  `orderno` int(11) NOT NULL,
  `stkcode` int(11) NOT NULL,
  `stock_name` varchar(100) DEFAULT NULL,
  `qtyinvoiced` double NOT NULL DEFAULT '0',
  `unitprice` decimal(10,4) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `taxlabel` varchar(50) NOT NULL,
  `uom` varchar(100) DEFAULT NULL,
  `cost_price` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `total_cost` decimal(10,2) NOT NULL,
  `sales_gl` varchar(100) NOT NULL,
  `cogs_gl` varchar(100) NOT NULL,
  `estimate` tinyint(4) NOT NULL DEFAULT '0',
  `discountpercent` double NOT NULL DEFAULT '0',
  `actualdispatchdate` datetime DEFAULT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `narrative` text,
  `itemdue` date DEFAULT NULL COMMENT 'Due date for line item.  Some customers require \r\nacknowledgements with due dates by line item',
  `poline` varchar(10) DEFAULT NULL COMMENT 'Some Customers require acknowledgements with a PO line number for each sales line',
  PRIMARY KEY (`orderlineno`,`orderno`),
  KEY `OrderNo` (`orderno`),
  KEY `StkCode` (`stkcode`),
  KEY `Completed` (`completed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `refund_item_details`
--


--
-- Table structure for table `relateditems`
--

CREATE TABLE `relateditems` (
  `stockid` varchar(20) CHARACTER SET utf8 NOT NULL,
  `related` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`stockid`,`related`),
  UNIQUE KEY `Related` (`related`,`stockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `relateditems`
--


--
-- 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` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`reportid`,`colno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reportcolumns`
--


--
-- Table structure for table `reportfields`
--

CREATE TABLE `reportfields` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `reportid` int(5) NOT NULL DEFAULT '0',
  `entrytype` varchar(15) NOT NULL DEFAULT '',
  `seqnum` int(3) NOT NULL DEFAULT '0',
  `fieldname` varchar(80) NOT NULL DEFAULT '',
  `displaydesc` varchar(25) NOT NULL DEFAULT '',
  `visible` enum('1','0') NOT NULL DEFAULT '1',
  `columnbreak` enum('1','0') NOT NULL DEFAULT '1',
  `params` text,
  PRIMARY KEY (`id`),
  KEY `reportid` (`reportid`)
) ENGINE=MyISAM AUTO_INCREMENT=1805 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reportfields`
--


--
-- 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reportheaders`
--


--
-- Table structure for table `reportlinks`
--

CREATE TABLE `reportlinks` (
  `table1` varchar(25) NOT NULL DEFAULT '',
  `table2` varchar(25) NOT NULL DEFAULT '',
  `equation` varchar(75) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reportlinks`
--

INSERT INTO `reportlinks` VALUES ('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation'),('accountgroups','accountsection','accountgroups.sectioninaccounts=accountsection.sectionid'),('accountsection','accountgroups','accountsection.sectionid=accountgroups.sectioninaccounts'),('bankaccounts','chartmaster','bankaccounts.accountcode=chartmaster.accountcode'),('chartmaster','bankaccounts','chartmaster.accountcode=bankaccounts.accountcode'),('banktrans','systypes','banktrans.type=systypes.typeid'),('systypes','banktrans','systypes.typeid=banktrans.type'),('banktrans','bankaccounts','banktrans.bankact=bankaccounts.accountcode'),('bankaccounts','banktrans','bankaccounts.accountcode=banktrans.bankact'),('bom','stockmaster','bom.parent=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.parent'),('bom','stockmaster','bom.component=stockmaster.stockid'),('stockmaster','bom','stockmaster.stockid=bom.component'),('bom','workcentres','bom.workcentreadded=workcentres.code'),('workcentres','bom','workcentres.code=bom.workcentreadded'),('bom','locations','bom.loccode=locations.loccode'),('locations','bom','locations.loccode=bom.loccode'),('buckets','workcentres','buckets.workcentre=workcentres.code'),('workcentres','buckets','workcentres.code=buckets.workcentre'),('chartdetails','chartmaster','chartdetails.accountcode=chartmaster.accountcode'),('chartmaster','chartdetails','chartmaster.accountcode=chartdetails.accountcode'),('chartdetails','periods','chartdetails.period=periods.periodno'),('periods','chartdetails','periods.periodno=chartdetails.period'),('chartmaster','accountgroups','chartmaster.group_=accountgroups.groupname'),('accountgroups','chartmaster','accountgroups.groupname=chartmaster.group_'),('contractbom','workcentres','contractbom.workcentreadded=workcentres.code'),('workcentres','contractbom','workcentres.code=contractbom.workcentreadded'),('contractbom','locations','contractbom.loccode=locations.loccode'),('locations','contractbom','locations.loccode=contractbom.loccode'),('contractbom','stockmaster','contractbom.component=stockmaster.stockid'),('stockmaster','contractbom','stockmaster.stockid=contractbom.component'),('contractreqts','contracts','contractreqts.contract=contracts.contractref'),('contracts','contractreqts','contracts.contractref=contractreqts.contract'),('contracts','custbranch','contracts.debtorno=custbranch.debtorno'),('custbranch','contracts','custbranch.debtorno=contracts.debtorno'),('contracts','stockcategory','contracts.branchcode=stockcategory.categoryid'),('stockcategory','contracts','stockcategory.categoryid=contracts.branchcode'),('contracts','salestypes','contracts.typeabbrev=salestypes.typeabbrev'),('salestypes','contracts','salestypes.typeabbrev=contracts.typeabbrev'),('custallocns','debtortrans','custallocns.transid_allocfrom=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocfrom'),('custallocns','debtortrans','custallocns.transid_allocto=debtortrans.id'),('debtortrans','custallocns','debtortrans.id=custallocns.transid_allocto'),('custbranch','debtorsmaster','custbranch.debtorno=debtorsmaster.debtorno'),('debtorsmaster','custbranch','debtorsmaster.debtorno=custbranch.debtorno'),('custbranch','areas','custbranch.area=areas.areacode'),('areas','custbranch','areas.areacode=custbranch.area'),('custbranch','salesman','custbranch.salesman=salesman.salesmancode'),('salesman','custbranch','salesman.salesmancode=custbranch.salesman'),('custbranch','locations','custbranch.defaultlocation=locations.loccode'),('locations','custbranch','locations.loccode=custbranch.defaultlocation'),('custbranch','shippers','custbranch.defaultshipvia=shippers.shipper_id'),('shippers','custbranch','shippers.shipper_id=custbranch.defaultshipvia'),('debtorsmaster','holdreasons','debtorsmaster.holdreason=holdreasons.reasoncode'),('holdreasons','debtorsmaster','holdreasons.reasoncode=debtorsmaster.holdreason'),('debtorsmaster','currencies','debtorsmaster.currcode=currencies.currabrev'),('currencies','debtorsmaster','currencies.currabrev=debtorsmaster.currcode'),('debtorsmaster','paymentterms','debtorsmaster.paymentterms=paymentterms.termsindicator'),('paymentterms','debtorsmaster','paymentterms.termsindicator=debtorsmaster.paymentterms'),('debtorsmaster','salestypes','debtorsmaster.salestype=salestypes.typeabbrev'),('salestypes','debtorsmaster','salestypes.typeabbrev=debtorsmaster.salestype'),('debtortrans','custbranch','debtortrans.debtorno=custbranch.debtorno'),('custbranch','debtortrans','custbranch.debtorno=debtortrans.debtorno'),('debtortrans','systypes','debtortrans.type=systypes.typeid'),('systypes','debtortrans','systypes.typeid=debtortrans.type'),('debtortrans','periods','debtortrans.prd=periods.periodno'),('periods','debtortrans','periods.periodno=debtortrans.prd'),('debtortranstaxes','taxauthorities','debtortranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','debtortranstaxes','taxauthorities.taxid=debtortranstaxes.taxauthid'),('debtortranstaxes','debtortrans','debtortranstaxes.debtortransid=debtortrans.id'),('debtortrans','debtortranstaxes','debtortrans.id=debtortranstaxes.debtortransid'),('discountmatrix','salestypes','discountmatrix.salestype=salestypes.typeabbrev'),('salestypes','discountmatrix','salestypes.typeabbrev=discountmatrix.salestype'),('freightcosts','locations','freightcosts.locationfrom=locations.loccode'),('locations','freightcosts','locations.loccode=freightcosts.locationfrom'),('freightcosts','shippers','freightcosts.shipperid=shippers.shipper_id'),('shippers','freightcosts','shippers.shipper_id=freightcosts.shipperid'),('gltrans','chartmaster','gltrans.account=chartmaster.accountcode'),('chartmaster','gltrans','chartmaster.accountcode=gltrans.account'),('gltrans','systypes','gltrans.type=systypes.typeid'),('systypes','gltrans','systypes.typeid=gltrans.type'),('gltrans','periods','gltrans.periodno=periods.periodno'),('periods','gltrans','periods.periodno=gltrans.periodno'),('grns','suppliers','grns.supplierid=suppliers.supplierid'),('suppliers','grns','suppliers.supplierid=grns.supplierid'),('grns','purchorderdetails','grns.podetailitem=purchorderdetails.podetailitem'),('purchorderdetails','grns','purchorderdetails.podetailitem=grns.podetailitem'),('locations','taxprovinces','locations.taxprovinceid=taxprovinces.taxprovinceid'),('taxprovinces','locations','taxprovinces.taxprovinceid=locations.taxprovinceid'),('locstock','locations','locstock.loccode=locations.loccode'),('locations','locstock','locations.loccode=locstock.loccode'),('locstock','stockmaster','locstock.stockid=stockmaster.stockid'),('stockmaster','locstock','stockmaster.stockid=locstock.stockid'),('loctransfers','locations','loctransfers.shiploc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.shiploc'),('loctransfers','locations','loctransfers.recloc=locations.loccode'),('locations','loctransfers','locations.loccode=loctransfers.recloc'),('loctransfers','stockmaster','loctransfers.stockid=stockmaster.stockid'),('stockmaster','loctransfers','stockmaster.stockid=loctransfers.stockid'),('orderdeliverydifferencesl','stockmaster','orderdeliverydifferenceslog.stockid=stockmaster.stockid'),('stockmaster','orderdeliverydifferencesl','stockmaster.stockid=orderdeliverydifferenceslog.stockid'),('orderdeliverydifferencesl','custbranch','orderdeliverydifferenceslog.debtorno=custbranch.debtorno'),('custbranch','orderdeliverydifferencesl','custbranch.debtorno=orderdeliverydifferenceslog.debtorno'),('orderdeliverydifferencesl','salesorders','orderdeliverydifferenceslog.branchcode=salesorders.orderno'),('salesorders','orderdeliverydifferencesl','salesorders.orderno=orderdeliverydifferenceslog.branchcode'),('prices','stockmaster','prices.stockid=stockmaster.stockid'),('stockmaster','prices','stockmaster.stockid=prices.stockid'),('prices','currencies','prices.currabrev=currencies.currabrev'),('currencies','prices','currencies.currabrev=prices.currabrev'),('prices','salestypes','prices.typeabbrev=salestypes.typeabbrev'),('salestypes','prices','salestypes.typeabbrev=prices.typeabbrev'),('purchdata','stockmaster','purchdata.stockid=stockmaster.stockid'),('stockmaster','purchdata','stockmaster.stockid=purchdata.stockid'),('purchdata','suppliers','purchdata.supplierno=suppliers.supplierid'),('suppliers','purchdata','suppliers.supplierid=purchdata.supplierno'),('purchorderdetails','purchorders','purchorderdetails.orderno=purchorders.orderno'),('purchorders','purchorderdetails','purchorders.orderno=purchorderdetails.orderno'),('purchorders','suppliers','purchorders.supplierno=suppliers.supplierid'),('suppliers','purchorders','suppliers.supplierid=purchorders.supplierno'),('purchorders','locations','purchorders.intostocklocation=locations.loccode'),('locations','purchorders','locations.loccode=purchorders.intostocklocation'),('recurringsalesorders','custbranch','recurringsalesorders.branchcode=custbranch.branchcode'),('custbranch','recurringsalesorders','custbranch.branchcode=recurringsalesorders.branchcode'),('recurrsalesorderdetails','recurringsalesorders','recurrsalesorderdetails.recurrorderno=recurringsalesorders.recurrorderno'),('recurringsalesorders','recurrsalesorderdetails','recurringsalesorders.recurrorderno=recurrsalesorderdetails.recurrorderno'),('recurrsalesorderdetails','stockmaster','recurrsalesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','recurrsalesorderdetails','stockmaster.stockid=recurrsalesorderdetails.stkcode'),('reportcolumns','reportheaders','reportcolumns.reportid=reportheaders.reportid'),('reportheaders','reportcolumns','reportheaders.reportid=reportcolumns.reportid'),('salesanalysis','periods','salesanalysis.periodno=periods.periodno'),('periods','salesanalysis','periods.periodno=salesanalysis.periodno'),('salescatprod','stockmaster','salescatprod.stockid=stockmaster.stockid'),('stockmaster','salescatprod','stockmaster.stockid=salescatprod.stockid'),('salescatprod','salescat','salescatprod.salescatid=salescat.salescatid'),('salescat','salescatprod','salescat.salescatid=salescatprod.salescatid'),('salesorderdetails','salesorders','salesorderdetails.orderno=salesorders.orderno'),('salesorders','salesorderdetails','salesorders.orderno=salesorderdetails.orderno'),('salesorderdetails','stockmaster','salesorderdetails.stkcode=stockmaster.stockid'),('stockmaster','salesorderdetails','stockmaster.stockid=salesorderdetails.stkcode'),('salesorders','custbranch','salesorders.branchcode=custbranch.branchcode'),('custbranch','salesorders','custbranch.branchcode=salesorders.branchcode'),('salesorders','shippers','salesorders.debtorno=shippers.shipper_id'),('shippers','salesorders','shippers.shipper_id=salesorders.debtorno'),('salesorders','locations','salesorders.fromstkloc=locations.loccode'),('locations','salesorders','locations.loccode=salesorders.fromstkloc'),('securitygroups','securityroles','securitygroups.secroleid=securityroles.secroleid'),('securityroles','securitygroups','securityroles.secroleid=securitygroups.secroleid'),('securitygroups','securitytokens','securitygroups.tokenid=securitytokens.tokenid'),('securitytokens','securitygroups','securitytokens.tokenid=securitygroups.tokenid'),('shipmentcharges','shipments','shipmentcharges.shiptref=shipments.shiptref'),('shipments','shipmentcharges','shipments.shiptref=shipmentcharges.shiptref'),('shipmentcharges','systypes','shipmentcharges.transtype=systypes.typeid'),('systypes','shipmentcharges','systypes.typeid=shipmentcharges.transtype'),('shipments','suppliers','shipments.supplierid=suppliers.supplierid'),('suppliers','shipments','suppliers.supplierid=shipments.supplierid'),('stockcheckfreeze','stockmaster','stockcheckfreeze.stockid=stockmaster.stockid'),('stockmaster','stockcheckfreeze','stockmaster.stockid=stockcheckfreeze.stockid'),('stockcheckfreeze','locations','stockcheckfreeze.loccode=locations.loccode'),('locations','stockcheckfreeze','locations.loccode=stockcheckfreeze.loccode'),('stockcounts','stockmaster','stockcounts.stockid=stockmaster.stockid'),('stockmaster','stockcounts','stockmaster.stockid=stockcounts.stockid'),('stockcounts','locations','stockcounts.loccode=locations.loccode'),('locations','stockcounts','locations.loccode=stockcounts.loccode'),('stockmaster','stockcategory','stockmaster.categoryid=stockcategory.categoryid'),('stockcategory','stockmaster','stockcategory.categoryid=stockmaster.categoryid'),('stockmaster','taxcategories','stockmaster.taxcatid=taxcategories.taxcatid'),('taxcategories','stockmaster','taxcategories.taxcatid=stockmaster.taxcatid'),('stockmoves','stockmaster','stockmoves.stockid=stockmaster.stockid'),('stockmaster','stockmoves','stockmaster.stockid=stockmoves.stockid'),('stockmoves','systypes','stockmoves.type=systypes.typeid'),('systypes','stockmoves','systypes.typeid=stockmoves.type'),('stockmoves','locations','stockmoves.loccode=locations.loccode'),('locations','stockmoves','locations.loccode=stockmoves.loccode'),('stockmoves','periods','stockmoves.prd=periods.periodno'),('periods','stockmoves','periods.periodno=stockmoves.prd'),('stockmovestaxes','taxauthorities','stockmovestaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','stockmovestaxes','taxauthorities.taxid=stockmovestaxes.taxauthid'),('stockserialitems','stockmaster','stockserialitems.stockid=stockmaster.stockid'),('stockmaster','stockserialitems','stockmaster.stockid=stockserialitems.stockid'),('stockserialitems','locations','stockserialitems.loccode=locations.loccode'),('locations','stockserialitems','locations.loccode=stockserialitems.loccode'),('stockserialmoves','stockmoves','stockserialmoves.stockmoveno=stockmoves.stkmoveno'),('stockmoves','stockserialmoves','stockmoves.stkmoveno=stockserialmoves.stockmoveno'),('stockserialmoves','stockserialitems','stockserialmoves.stockid=stockserialitems.stockid'),('stockserialitems','stockserialmoves','stockserialitems.stockid=stockserialmoves.stockid'),('suppallocs','supptrans','suppallocs.transid_allocfrom=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocfrom'),('suppallocs','supptrans','suppallocs.transid_allocto=supptrans.id'),('supptrans','suppallocs','supptrans.id=suppallocs.transid_allocto'),('suppliercontacts','suppliers','suppliercontacts.supplierid=suppliers.supplierid'),('suppliers','suppliercontacts','suppliers.supplierid=suppliercontacts.supplierid'),('suppliers','currencies','suppliers.currcode=currencies.currabrev'),('currencies','suppliers','currencies.currabrev=suppliers.currcode'),('suppliers','paymentterms','suppliers.paymentterms=paymentterms.termsindicator'),('paymentterms','suppliers','paymentterms.termsindicator=suppliers.paymentterms'),('suppliers','taxgroups','suppliers.taxgroupid=taxgroups.taxgroupid'),('taxgroups','suppliers','taxgroups.taxgroupid=suppliers.taxgroupid'),('supptrans','systypes','supptrans.type=systypes.typeid'),('systypes','supptrans','systypes.typeid=supptrans.type'),('supptrans','suppliers','supptrans.supplierno=suppliers.supplierid'),('suppliers','supptrans','suppliers.supplierid=supptrans.supplierno'),('supptranstaxes','taxauthorities','supptranstaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','supptranstaxes','taxauthorities.taxid=supptranstaxes.taxauthid'),('supptranstaxes','supptrans','supptranstaxes.supptransid=supptrans.id'),('supptrans','supptranstaxes','supptrans.id=supptranstaxes.supptransid'),('taxauthorities','chartmaster','taxauthorities.taxglcode=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.taxglcode'),('taxauthorities','chartmaster','taxauthorities.purchtaxglaccount=chartmaster.accountcode'),('chartmaster','taxauthorities','chartmaster.accountcode=taxauthorities.purchtaxglaccount'),('taxauthrates','taxauthorities','taxauthrates.taxauthority=taxauthorities.taxid'),('taxauthorities','taxauthrates','taxauthorities.taxid=taxauthrates.taxauthority'),('taxauthrates','taxcategories','taxauthrates.taxcatid=taxcategories.taxcatid'),('taxcategories','taxauthrates','taxcategories.taxcatid=taxauthrates.taxcatid'),('taxauthrates','taxprovinces','taxauthrates.dispatchtaxprovince=taxprovinces.taxprovinceid'),('taxprovinces','taxauthrates','taxprovinces.taxprovinceid=taxauthrates.dispatchtaxprovince'),('taxgrouptaxes','taxgroups','taxgrouptaxes.taxgroupid=taxgroups.taxgroupid'),('taxgroups','taxgrouptaxes','taxgroups.taxgroupid=taxgrouptaxes.taxgroupid'),('taxgrouptaxes','taxauthorities','taxgrouptaxes.taxauthid=taxauthorities.taxid'),('taxauthorities','taxgrouptaxes','taxauthorities.taxid=taxgrouptaxes.taxauthid'),('workcentres','locations','workcentres.location=locations.loccode'),('locations','workcentres','locations.loccode=workcentres.location'),('worksorders','locations','worksorders.loccode=locations.loccode'),('locations','worksorders','locations.loccode=worksorders.loccode'),('worksorders','stockmaster','worksorders.stockid=stockmaster.stockid'),('stockmaster','worksorders','stockmaster.stockid=worksorders.stockid'),('www_users','locations','www_users.defaultlocation=locations.loccode'),('locations','www_users','locations.loccode=www_users.defaultlocation');

--
