CREATE DATABASE IF NOT EXISTS `test` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test`; -- MySQL dump 10.13 Distrib 5.5.24, for osx10.5 (i386) -- -- Host: 127.0.0.1 Database: test -- ------------------------------------------------------ -- Server version 5.5.25a /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `APP_AUTO_LABELLER` -- DROP TABLE IF EXISTS `APP_AUTO_LABELLER`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_AUTO_LABELLER` ( `LINE` varchar(20) NOT NULL, `DESCRIPTION` varchar(45) DEFAULT NULL, `PROCESS_ORDER` varchar(10) DEFAULT NULL, `OVERRIDE_EXPIRY` varchar(1) DEFAULT NULL, `OVERRIDE_EXPIRY_DATE` datetime DEFAULT NULL, `OVERRIDE_BATCH` varchar(1) DEFAULT NULL, `OVERRIDE_BATCH_NUMBER` varchar(12) DEFAULT NULL, `BATCH_OPTIONAL` varchar(12) DEFAULT NULL, PRIMARY KEY (`LINE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_AUTO_LABELLER` -- LOCK TABLES `APP_AUTO_LABELLER` WRITE; /*!40000 ALTER TABLE `APP_AUTO_LABELLER` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_AUTO_LABELLER` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_CUSTOMER` -- DROP TABLE IF EXISTS `APP_CUSTOMER`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_CUSTOMER` ( `CUSTOMER_ID` varchar(20) NOT NULL, `CUSTOMER_NAME` varchar(50) DEFAULT NULL, `PRINT_ON_LABEL` varchar(1) DEFAULT 'Y', PRIMARY KEY (`CUSTOMER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_CUSTOMER` -- LOCK TABLES `APP_CUSTOMER` WRITE; /*!40000 ALTER TABLE `APP_CUSTOMER` DISABLE KEYS */; INSERT INTO `APP_CUSTOMER` VALUES ('SELF','My Company','Y'); /*!40000 ALTER TABLE `APP_CUSTOMER` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_DESPATCH` -- DROP TABLE IF EXISTS `APP_DESPATCH`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_DESPATCH` ( `DESPATCH_NO` varchar(10) NOT NULL, `DESPATCH_DATE` datetime DEFAULT NULL, `LOCATION_ID_FROM` varchar(15) DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `TOTAL_PALLETS` decimal(22,0) DEFAULT NULL, `LOCATION_ID_TO` varchar(15) DEFAULT NULL, `TRAILER` varchar(15) DEFAULT NULL, `HAULIER` varchar(15) DEFAULT NULL, `TRANSACTION_REF` decimal(22,0) DEFAULT NULL, `LOAD_NO` varchar(20) DEFAULT NULL, `USER_ID` varchar(20) DEFAULT NULL, PRIMARY KEY (`DESPATCH_NO`), UNIQUE KEY `PK_MATERIAL_DESPATCH` (`DESPATCH_NO`), KEY `DESPATCH_TXN_NDX` (`TRANSACTION_REF`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_DESPATCH` -- LOCK TABLES `APP_DESPATCH` WRITE; /*!40000 ALTER TABLE `APP_DESPATCH` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_DESPATCH` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_LOCATION` -- DROP TABLE IF EXISTS `APP_LOCATION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_LOCATION` ( `LOCATION_ID` varchar(15) NOT NULL, `PLANT` varchar(10) DEFAULT NULL, `WAREHOUSE` varchar(10) DEFAULT NULL, `GLN` varchar(14) DEFAULT NULL, `DESCRIPTION` varchar(45) DEFAULT NULL, `STORAGE_LOCATION` varchar(10) DEFAULT NULL, `STORAGE_TYPE` varchar(10) DEFAULT NULL, `STORAGE_SECTION` varchar(10) DEFAULT NULL, `STORAGE_BIN` varchar(10) DEFAULT NULL, `EQUIPMENT_TRACKING_ID` varchar(15) DEFAULT NULL, `MSG_DESPATCH_CONFIRM` varchar(1) DEFAULT 'Y', `MSG_DESPATCH_PREADVICE` varchar(1) DEFAULT 'Y', `MSG_DESPATCH_EQUIP_TRACK` varchar(1) DEFAULT 'Y', `MSG_PROD_CONFIRM` varchar(1) DEFAULT 'Y', `PERMITTED_PALLET_STATUS` varchar(200) DEFAULT NULL, `PERMITTED_BATCH_STATUS` varchar(200) DEFAULT NULL, `MSG_PALLET_STATUS` varchar(1) DEFAULT 'Y', `MSG_PALLET_SPLIT` varchar(1) DEFAULT 'N', `MSG_PALLET_DELETE` varchar(1) DEFAULT 'N', PRIMARY KEY (`LOCATION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_LOCATION` -- LOCK TABLES `APP_LOCATION` WRITE; /*!40000 ALTER TABLE `APP_LOCATION` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_LOCATION` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MATERIAL` -- DROP TABLE IF EXISTS `APP_MATERIAL`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MATERIAL` ( `MATERIAL` varchar(20) NOT NULL, `MATERIAL_TYPE` varchar(5) DEFAULT NULL, `DESCRIPTION` varchar(80) DEFAULT NULL, `BASE_UOM` varchar(3) DEFAULT NULL, `SHELF_LIFE_UOM` varchar(1) DEFAULT 'D', `SHELF_LIFE` decimal(22,0) DEFAULT '0', `SHELF_LIFE_RULE` varchar(1) DEFAULT '+', `GROSS_WEIGHT` decimal(22,3) DEFAULT '0.000', `NET_WEIGHT` decimal(22,3) DEFAULT '0.000', `WEIGHT_UOM` varchar(3) DEFAULT NULL, `OLD_MATERIAL` varchar(20) DEFAULT NULL, `DEFAULT_BATCH_STATUS` varchar(20) DEFAULT NULL, `EQUIPMENT_TYPE` varchar(15) DEFAULT NULL, `UPDATED` datetime DEFAULT NULL, `INSPECTION_ID` varchar(20) DEFAULT NULL, PRIMARY KEY (`MATERIAL`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MATERIAL` -- LOCK TABLES `APP_MATERIAL` WRITE; /*!40000 ALTER TABLE `APP_MATERIAL` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_MATERIAL` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MATERIAL_BATCH` -- DROP TABLE IF EXISTS `APP_MATERIAL_BATCH`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MATERIAL_BATCH` ( `MATERIAL` varchar(20) NOT NULL, `BATCH_NUMBER` varchar(12) NOT NULL, `STATUS` varchar(20) DEFAULT NULL, `EXPIRY_DATE` datetime DEFAULT NULL, PRIMARY KEY (`MATERIAL`,`BATCH_NUMBER`), UNIQUE KEY `BATCH_PK` (`MATERIAL`,`BATCH_NUMBER`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MATERIAL_BATCH` -- LOCK TABLES `APP_MATERIAL_BATCH` WRITE; /*!40000 ALTER TABLE `APP_MATERIAL_BATCH` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_MATERIAL_BATCH` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MATERIAL_LOCATION` -- DROP TABLE IF EXISTS `APP_MATERIAL_LOCATION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MATERIAL_LOCATION` ( `MATERIAL` varchar(20) NOT NULL, `LOCATION_ID` varchar(15) NOT NULL, `STATUS` varchar(20) DEFAULT NULL, PRIMARY KEY (`MATERIAL`,`LOCATION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MATERIAL_LOCATION` -- LOCK TABLES `APP_MATERIAL_LOCATION` WRITE; /*!40000 ALTER TABLE `APP_MATERIAL_LOCATION` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_MATERIAL_LOCATION` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MATERIAL_TYPE` -- DROP TABLE IF EXISTS `APP_MATERIAL_TYPE`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MATERIAL_TYPE` ( `MATERIAL_TYPE` varchar(5) NOT NULL, `DESCRIPTION` varchar(80) DEFAULT NULL, PRIMARY KEY (`MATERIAL_TYPE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MATERIAL_TYPE` -- LOCK TABLES `APP_MATERIAL_TYPE` WRITE; /*!40000 ALTER TABLE `APP_MATERIAL_TYPE` DISABLE KEYS */; INSERT INTO `APP_MATERIAL_TYPE` VALUES ('FERT','Finished Goods'),('HALB','Intermediate'),('RAW','Raw Materials'); /*!40000 ALTER TABLE `APP_MATERIAL_TYPE` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MATERIAL_UOM` -- DROP TABLE IF EXISTS `APP_MATERIAL_UOM`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MATERIAL_UOM` ( `MATERIAL` varchar(20) NOT NULL, `UOM` varchar(3) NOT NULL, `EAN` varchar(14) DEFAULT NULL, `VARIANT` varchar(2) DEFAULT NULL, `NUMERATOR` decimal(22,0) DEFAULT '1', `DENOMINATOR` decimal(22,0) DEFAULT '1', PRIMARY KEY (`MATERIAL`,`UOM`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MATERIAL_UOM` -- LOCK TABLES `APP_MATERIAL_UOM` WRITE; /*!40000 ALTER TABLE `APP_MATERIAL_UOM` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_MATERIAL_UOM` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MHN` -- DROP TABLE IF EXISTS `APP_MHN`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MHN` ( `MHN_NUMBER` varchar(10) NOT NULL, `INITIATOR` varchar(20) DEFAULT NULL, `RECORDER` varchar(20) DEFAULT NULL, `AUTHORISOR` varchar(20) DEFAULT NULL, `REASON1` varchar(10) DEFAULT NULL, `REASON2` varchar(10) DEFAULT NULL, `REASON3` varchar(10) DEFAULT NULL, `DATE_CREATED` datetime DEFAULT NULL, `DATE_EXPECTED` datetime DEFAULT NULL, `DATE_RESOLVED` datetime DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `REQUIRED_RESOURCE` varchar(50) DEFAULT NULL, `COMMENTS` varchar(250) DEFAULT NULL, PRIMARY KEY (`MHN_NUMBER`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MHN` -- LOCK TABLES `APP_MHN` WRITE; /*!40000 ALTER TABLE `APP_MHN` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_MHN` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MHN_DECISIONS` -- DROP TABLE IF EXISTS `APP_MHN_DECISIONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MHN_DECISIONS` ( `DECISION` varchar(10) NOT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, `COLOR_FOREGROUND` int(11) DEFAULT NULL, `COLOR_BACKGROUND` int(11) DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, PRIMARY KEY (`DECISION`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MHN_DECISIONS` -- LOCK TABLES `APP_MHN_DECISIONS` WRITE; /*!40000 ALTER TABLE `APP_MHN_DECISIONS` DISABLE KEYS */; INSERT INTO `APP_MHN_DECISIONS` VALUES ('Destroy','Destroy',-1,-65536,'Blocked'),('Donate','Donate',-16777216,-3355393,'Blocked'),('Pending','Pending',-16777216,-13312,'Blocked'),('Release','Release',-16777216,-16711936,'Unrestricted'),('Repack','Reject',-16777216,-205,'Blocked'),('Secondary','Secondary',-16777216,-205,'Blocked'); /*!40000 ALTER TABLE `APP_MHN_DECISIONS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_MHN_REASONS` -- DROP TABLE IF EXISTS `APP_MHN_REASONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_MHN_REASONS` ( `REASON` varchar(10) NOT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, PRIMARY KEY (`REASON`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_MHN_REASONS` -- LOCK TABLES `APP_MHN_REASONS` WRITE; /*!40000 ALTER TABLE `APP_MHN_REASONS` DISABLE KEYS */; INSERT INTO `APP_MHN_REASONS` VALUES ('PS','Pre Process Spoilage'),('WT','Weights'); /*!40000 ALTER TABLE `APP_MHN_REASONS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_PALLET` -- DROP TABLE IF EXISTS `APP_PALLET`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_PALLET` ( `SSCC` varchar(18) NOT NULL, `LOCATION_ID` varchar(15) DEFAULT NULL, `MATERIAL` varchar(20) DEFAULT NULL, `BATCH_NUMBER` varchar(12) DEFAULT NULL, `PROCESS_ORDER` varchar(10) DEFAULT NULL, `QUANTITY` decimal(22,3) NOT NULL DEFAULT '0.000', `UOM` varchar(10) DEFAULT NULL, `DATE_OF_MANUFACTURE` datetime DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `EAN` varchar(14) DEFAULT NULL, `VARIANT` varchar(2) DEFAULT NULL, `DESPATCH_NO` varchar(10) DEFAULT NULL, `CONFIRMED` varchar(1) DEFAULT NULL, `LAYERS` int(11) DEFAULT NULL, `SSCC_EXPIRY_DATE` datetime DEFAULT NULL, `CUSTOMER_ID` varchar(20) DEFAULT NULL, `MHN_NUMBER` varchar(10) DEFAULT NULL, `DECISION` varchar(10) DEFAULT NULL, `DATE_CREATED` datetime DEFAULT NULL, `CREATED_BY_USER_ID` varchar(20) DEFAULT NULL, `DATE_UPDATED` datetime DEFAULT NULL, `UPDATED_BY_USER_ID` varchar(20) DEFAULT NULL, PRIMARY KEY (`SSCC`), KEY `BATCH_NUMBER_IDX` (`BATCH_NUMBER`), KEY `PROCESS_ORDER_IDX` (`PROCESS_ORDER`), KEY `PALLET_MATERIAL_LOOKUP` (`MATERIAL`), KEY `PALLET_DESPATCH_NDX` (`DESPATCH_NO`), KEY `PALLET_DOM_IDX` (`DATE_OF_MANUFACTURE`), KEY `PALLET_MHN_IDX` (`MHN_NUMBER`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_PALLET` -- LOCK TABLES `APP_PALLET` WRITE; /*!40000 ALTER TABLE `APP_PALLET` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_PALLET` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_PALLET_HISTORY` -- DROP TABLE IF EXISTS `APP_PALLET_HISTORY`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_PALLET_HISTORY` ( `TRANSACTION_REF` decimal(22,0) NOT NULL, `TRANSACTION_TYPE` varchar(15) NOT NULL, `TRANSACTION_SUBTYPE` varchar(15) NOT NULL, `TRANSACTION_DATE` datetime NOT NULL, `SSCC` varchar(18) NOT NULL, `LOCATION_ID` varchar(15) DEFAULT NULL, `MATERIAL` varchar(20) DEFAULT NULL, `BATCH_NUMBER` varchar(12) DEFAULT NULL, `PROCESS_ORDER` varchar(10) DEFAULT NULL, `QUANTITY` decimal(22,3) DEFAULT '0.000', `UOM` varchar(10) DEFAULT NULL, `DATE_OF_MANUFACTURE` datetime DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `EAN` varchar(14) DEFAULT NULL, `VARIANT` varchar(2) DEFAULT NULL, `DESPATCH_NO` varchar(10) DEFAULT NULL, `USER_ID` varchar(20) DEFAULT NULL, `CONFIRMED` varchar(1) DEFAULT NULL, `LAYERS` int(11) DEFAULT NULL, `SSCC_EXPIRY_DATE` datetime DEFAULT NULL, `CUSTOMER_ID` varchar(20) DEFAULT NULL, `MHN_NUMBER` varchar(10) DEFAULT NULL, `DECISION` varchar(10) DEFAULT NULL, UNIQUE KEY `PK_APP_PALLET_HISTORY` (`TRANSACTION_REF`,`TRANSACTION_TYPE`,`TRANSACTION_SUBTYPE`,`TRANSACTION_DATE`,`SSCC`), KEY `PALLET_HISTORY_DESPATCH_NDX` (`DESPATCH_NO`), KEY `PH_TXN_SSCC_NDX` (`TRANSACTION_REF`,`SSCC`), KEY `PH_SSCC_NDX` (`SSCC`,`TRANSACTION_DATE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_PALLET_HISTORY` -- LOCK TABLES `APP_PALLET_HISTORY` WRITE; /*!40000 ALTER TABLE `APP_PALLET_HISTORY` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_PALLET_HISTORY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_PROCESS_ORDER` -- DROP TABLE IF EXISTS `APP_PROCESS_ORDER`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_PROCESS_ORDER` ( `PROCESS_ORDER` varchar(10) NOT NULL, `MATERIAL` varchar(20) DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `DUE_DATE` datetime DEFAULT NULL, `DESCRIPTION` varchar(60) DEFAULT NULL, `LOCATION_ID` varchar(15) DEFAULT NULL, `RECIPE_ID` varchar(20) DEFAULT NULL, `REQUIRED_QUANTITY` decimal(22,3) DEFAULT '0.000', `REQUIRED_UOM` varchar(10) DEFAULT NULL, `UPDATED` datetime DEFAULT NULL, `DEFAULT_PALLET_STATUS` varchar(20) DEFAULT NULL, `REQUIRED_RESOURCE` varchar(50) DEFAULT NULL, `CUSTOMER_ID` varchar(20) DEFAULT NULL, `INSPECTION_ID` varchar(20) DEFAULT NULL, PRIMARY KEY (`PROCESS_ORDER`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_PROCESS_ORDER` -- LOCK TABLES `APP_PROCESS_ORDER` WRITE; /*!40000 ALTER TABLE `APP_PROCESS_ORDER` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_PROCESS_ORDER` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_ACTIVITY` -- DROP TABLE IF EXISTS `APP_QM_ACTIVITY`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_ACTIVITY` ( `INSPECTION_ID` varchar(20) NOT NULL, `ACTIVITY_ID` varchar(10) NOT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, `EXTENSION_ID` int(11) DEFAULT NULL, PRIMARY KEY (`INSPECTION_ID`,`ACTIVITY_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_ACTIVITY` -- LOCK TABLES `APP_QM_ACTIVITY` WRITE; /*!40000 ALTER TABLE `APP_QM_ACTIVITY` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_ACTIVITY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_DICTIONARY` -- DROP TABLE IF EXISTS `APP_QM_DICTIONARY`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_DICTIONARY` ( `TEST_ID` varchar(50) NOT NULL, `FIELD_ALIGNMENT` int(11) DEFAULT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, `DATATYPE` varchar(15) DEFAULT NULL, `UOM` varchar(10) DEFAULT NULL, `REQUIRED` varchar(1) DEFAULT NULL, `SELECT_LIST_ID` varchar(20) DEFAULT NULL, `VISIBLE` varchar(1) DEFAULT NULL, `EXTENSION_ID` int(11) DEFAULT NULL, `FIELD_WIDTH` int(11) DEFAULT NULL, `FIELD_MAX_CHARS` int(11) DEFAULT NULL, PRIMARY KEY (`TEST_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_DICTIONARY` -- LOCK TABLES `APP_QM_DICTIONARY` WRITE; /*!40000 ALTER TABLE `APP_QM_DICTIONARY` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_DICTIONARY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_DICTIONARY_GROUP` -- DROP TABLE IF EXISTS `APP_QM_DICTIONARY_GROUP`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_DICTIONARY_GROUP` ( `GROUP_ID` varchar(20) NOT NULL, `TEST_ID` varchar(50) DEFAULT NULL, `ACCESS` varchar(20) DEFAULT NULL, PRIMARY KEY (`GROUP_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_DICTIONARY_GROUP` -- LOCK TABLES `APP_QM_DICTIONARY_GROUP` WRITE; /*!40000 ALTER TABLE `APP_QM_DICTIONARY_GROUP` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_DICTIONARY_GROUP` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_EXTENSION` -- DROP TABLE IF EXISTS `APP_QM_EXTENSION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_EXTENSION` ( `EXTENSION_ID` int(11) NOT NULL, `LINKED_TABLE` varchar(50) NOT NULL, `FIELDNAME` varchar(50) NOT NULL, `VALUE` varchar(50) DEFAULT NULL, PRIMARY KEY (`EXTENSION_ID`,`LINKED_TABLE`,`FIELDNAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_EXTENSION` -- LOCK TABLES `APP_QM_EXTENSION` WRITE; /*!40000 ALTER TABLE `APP_QM_EXTENSION` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_EXTENSION` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_INSPECTION` -- DROP TABLE IF EXISTS `APP_QM_INSPECTION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_INSPECTION` ( `INSPECTION_ID` varchar(20) NOT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, `EXTENSION_ID` int(11) DEFAULT NULL, PRIMARY KEY (`INSPECTION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_INSPECTION` -- LOCK TABLES `APP_QM_INSPECTION` WRITE; /*!40000 ALTER TABLE `APP_QM_INSPECTION` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_INSPECTION` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_RESULT` -- DROP TABLE IF EXISTS `APP_QM_RESULT`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_RESULT` ( `SAMPLE_ID` int(11) NOT NULL, `TEST_ID` varchar(50) NOT NULL, `VALUE` varchar(50) DEFAULT NULL, `UPDATED` datetime DEFAULT NULL, `USER_ID` varchar(20) DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `PROCESSED` datetime DEFAULT NULL, PRIMARY KEY (`SAMPLE_ID`,`TEST_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_RESULT` -- LOCK TABLES `APP_QM_RESULT` WRITE; /*!40000 ALTER TABLE `APP_QM_RESULT` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_RESULT` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_SAMPLE` -- DROP TABLE IF EXISTS `APP_QM_SAMPLE`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_SAMPLE` ( `SAMPLE_ID` int(11) NOT NULL, `PROCESS_ORDER` varchar(10) DEFAULT NULL, `MATERIAL` varchar(20) DEFAULT NULL, `INSPECTION_ID` varchar(20) DEFAULT NULL, `ACTIVITY_ID` varchar(10) DEFAULT NULL, `SAMPLE_DATE` datetime DEFAULT NULL, `USER_ID` varchar(20) DEFAULT NULL, `USER_DATA_1` varchar(20) DEFAULT NULL, `USER_DATA_2` varchar(20) DEFAULT NULL, PRIMARY KEY (`SAMPLE_ID`), KEY `GETSAMPLES` (`PROCESS_ORDER`,`INSPECTION_ID`,`ACTIVITY_ID`,`SAMPLE_DATE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_SAMPLE` -- LOCK TABLES `APP_QM_SAMPLE` WRITE; /*!40000 ALTER TABLE `APP_QM_SAMPLE` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_SAMPLE` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_SELECTLIST` -- DROP TABLE IF EXISTS `APP_QM_SELECTLIST`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_SELECTLIST` ( `SELECT_LIST_ID` varchar(20) NOT NULL, `VALUE` varchar(20) NOT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, `SEQUENCE` int(11) DEFAULT NULL, PRIMARY KEY (`SELECT_LIST_ID`,`VALUE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_SELECTLIST` -- LOCK TABLES `APP_QM_SELECTLIST` WRITE; /*!40000 ALTER TABLE `APP_QM_SELECTLIST` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_SELECTLIST` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_QM_TEST` -- DROP TABLE IF EXISTS `APP_QM_TEST`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_QM_TEST` ( `INSPECTION_ID` varchar(20) NOT NULL, `ACTIVITY_ID` varchar(10) NOT NULL, `TEST_ID` varchar(50) NOT NULL, `SEQUENCE_ID` int(11) NOT NULL, `EXTENSION_ID` int(11) NOT NULL, PRIMARY KEY (`INSPECTION_ID`,`ACTIVITY_ID`,`TEST_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_QM_TEST` -- LOCK TABLES `APP_QM_TEST` WRITE; /*!40000 ALTER TABLE `APP_QM_TEST` DISABLE KEYS */; /*!40000 ALTER TABLE `APP_QM_TEST` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `APP_UOM` -- DROP TABLE IF EXISTS `APP_UOM`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `APP_UOM` ( `UOM` varchar(3) NOT NULL, `ISO_UOM` varchar(3) DEFAULT NULL, `LOCAL_UOM` varchar(3) DEFAULT NULL, `DESCRIPTION` varchar(50) DEFAULT NULL, PRIMARY KEY (`UOM`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `APP_UOM` -- LOCK TABLES `APP_UOM` WRITE; /*!40000 ALTER TABLE `APP_UOM` DISABLE KEYS */; INSERT INTO `APP_UOM` VALUES ('%','P1','%','percent'),('%O','','%O','per thousand'),('1','','1','One'),('1/G','','1/G','per gram'),('10','DAY','10','Day'),('22S','','22S','square millimetre per second'),('2M','2M','2M','centimetre per second'),('2X','2X','2X','metre per minute'),('3RT','','3RT','Third Party Service Rate/Costs'),('4G','4G','4G','microlitre'),('4O','4O','4O','Microfarad'),('4T','4T','4T','Picofarad'),('A','AMP','A','ampere'),('A87','A87','A87','gigaohm'),('A93','A93','A93','gram per cubic metre'),('ACR','ACR','ACR','Acre'),('B34','B34','B34','kilogram per cubic decimetre'),('B45','B45','B45','kilomole'),('B47','B47','B47','Kilonewton'),('B73','B73','B73','Meganewton'),('B75','B75','B75','Megaohm'),('B78','B78','B78','megavolt'),('B84','B84','B84','Microampere'),('BAG','BG','BAG','Bag'),('BAR','BAR','BAR','bar'),('BOT','BO','BOT','Bottle'),('BQK','A18','BQK','becquerel per kilogram'),('C10','C10','C10','millifarad'),('C36','C36','C36','mole per cubic metre'),('C38','C38','C38','mole per litre'),('C39','C39','C39','Nanoampere'),('C3S','2J','C3S','cubic centimetre per second'),('C41','C41','C41','nanofarad'),('C56','C56','C56','newton per square millimetre'),('CCM','CMQ','CCM','cubic centimetre'),('CD','CDL','CD','candela'),('CDM','DMQ','CDM','cubic decimetre'),('CFU','','CFU','Colony forming Unit'),('CM','CMT','CM','centimetre'),('CM2','CMK','CM2','square centimetre'),('CMH','','CMH','centimetre per hour'),('CNT','','CNT','count'),('CS','CS','CS','Case'),('CTL','CLT','CTL','centilitre'),('D10','D10','D10','siemens per metre'),('D41','D41','D41','ton per cubic metre'),('D46','D46','D46','volt ampere'),('DEG','DD','DEG','Degree'),('DM','DMT','DM','decimetre'),('DR','DR','DR','Drum'),('DZ','DZN','DZ','dozen'),('EA','EA','EA','each'),('EE','','EE','enzyme unit'),('EML','','EML','enzyme unit/millilitre'),('F','FAR','F','Farad'),('FA','FAH','FA','degree Fahrenheit'),('FT','FOT','FT','foot'),('FT2','FTK','FT2','square foot'),('FT3','FTQ','FT3','cubic foot'),('G','GRM','G','Gram'),('GC','CEL','GC','degree Celsius'),('GHG','','GHG','gram per hectogram'),('GJ','GV','GJ','gigajoule'),('GKG','GK','GKG','gram per kilogram'),('GLI','GL','GLI','gram per litre'),('GLL','GLL','GLL','gallon US (liquid)'),('GM','A94','GM','gram per mole'),('GM2','GM','GM2','gram per square metre'),('GPH','','GPH','gallon per hour (US)'),('GQ','GQ','GQ','microgram per cubic metre'),('H','HUR','H','hour'),('HAR','HAR','HAR','hectare'),('HL','HLT','HL','hectolitre'),('HPA','A97','HPA','Hectopascal'),('HUM','ZZ1','HUM','Handling unit movement'),('HZ','HTZ','HZ','hertz'),('IN','INH','IN','inch'),('IN2','INK','IN2','square inch'),('IN3','INQ','IN3','cubic inch'),('J','JOU','J','Joule'),('JHR','ANN','JHR','year'),('JKG','J2','JKG','joule per kilogram'),('JMO','B15','JMO','joule per mole'),('K','KEL','K','Kelvin'),('KA','B22','KA','Kiloampere'),('KAN','CA','KAN','can'),('KAR','CT','KAR','carton'),('KBK','B25','KBK','Kilobecquerel per kilogram'),('KG','KGM','KG','Kilogram'),('KGF','','KGF','kilogram per square metre'),('KGK','3H','KGK','kilogram per kilogram'),('KGM','D74','KGM','kilogram per mole'),('KGS','KGS','KGS','kilogram per second'),('KGV','KMQ','KGV','kilogram per cubic metre'),('KGW','','KGW','kg Active Ingredient'),('KHZ','KHZ','KHZ','Kilohertz'),('KI','CR','KI','Crate'),('KJ','KJO','KJ','Kilojoule'),('KJK','B42','KJK','kilojoule per kilogram'),('KJM','B44','KJM','kilojoule per mole'),('KM','KTM','KM','kilometre'),('KM2','KMK','KM2','square kilometre'),('KMH','KMH','KMH','kilometre per hour'),('KMK','','KMK','cubic metre per cubic metre'),('KMN','','KMN','kelvin per minute'),('KMS','','KMS','kelvin per second'),('KNM','','KNM','kilonewton per square metre'),('KOH','B49','KOH','kiloohm'),('KPA','KPA','KPA','Kilopascal'),('KT','KTN','KT','kilotonne'),('KV','KVT','KV','Kilovolt'),('KVA','KVA','KVA','kilovolt ampere'),('KW','KWT','KW','Kilowatt'),('KWH','KWH','KWH','Kilowatt hour'),('L','LTR','L','litre'),('L2','L2','L2','litre per minute'),('LAG','LR','LAG','layer of a pallet'),('LAY','LAY','LAY','Layers'),('LB','LBR','LB','pound'),('LE','ZZ3','LE','activity unit'),('LPH','','LPH','litre per hour'),('M','MTR','M','metre'),('M%','','M%','Percent mass'),('M%O','','M%O','per thousand mass'),('M/S','MTS','M/S','metre per second'),('M2','MTK','M2','square metre'),('M2I','','M2I','per square metre'),('M2S','S4','M2S','metre squared per second'),('M3','MTQ','M3','cubic metre'),('M3S','MQS','M3S','cubic metre per second'),('MA','4K','MA','Milliampere'),('MBA','MBR','MBA','millibar'),('MBZ','','MBZ','metrebar per second'),('MEJ','3B','MEJ','megajoule'),('MG','MGM','MG','Milligram'),('MGF','','MGF','milligram/square centimetre'),('MGG','','MGG','milligram per gram'),('MGK','NA','MGK','milligram per kilogram'),('MGL','M1','MGL','milligram per litre'),('MGQ','GP','MGQ','milligram per cubic metre'),('MGW','MAW','MGW','megawatt'),('MHZ','MHZ','MHZ','megahertz'),('MI','SMI','MI','Mile'),('MI2','MIK','MI2','square mile'),('MIM','4H','MIM','micrometre'),('MIN','MIN','MIN','minute'),('MIS','B98','MIS','Microsecond'),('MJ','C15','MJ','millijoule'),('ML','MLT','ML','millilitre'),('MLK','','MLK','millilitre per cubic metre'),('MM','MMT','MM','millimetre'),('MM2','MMK','MM2','square millimetre'),('MMA','','MMA','millimetre per year'),('MMG','','MMG','millimole per gram'),('MMH','','MMH','millimetre per hour'),('MMK','D87','MMK','millimole per kilogram'),('MMO','C18','MMO','millimole'),('MMQ','MMQ','MMQ','cubic millimetre'),('MMS','C16','MMS','millimetre per second'),('MNM','C22','MNM','millinewton per metre'),('MOK','C19','MOK','mole per kilogram'),('MOL','C34','MOL','mole'),('MON','MON','MON','Month'),('MPA','MPA','MPA','megapascal'),('MPB','','MPB','parts per billion (mass)'),('MPM','','MPM','parts per million (mass)'),('MPS','C24','MPS','millipascal second'),('MPT','','MPT','parts per trillion (mass)'),('MPZ','','MPZ','metrepascal/second'),('MQH','MQH','MQH','cubic metre per hour'),('MS','C26','MS','Millisecond'),('MS2','MSK','MS2','metre per second squared'),('MTE','C29','MTE','millitesla'),('MTS','','MTS','metre per hour'),('MV','2Z','MV','millivolt'),('MVA','MVA','MVA','megavolt ampere'),('MW','C31','MW','milliwatt'),('MWH','MWH','MWH','megawatt hour'),('N','NEW','N','newton'),('NAM','C45','NAM','nanometre'),('NM','4P','NM','newton per metre'),('NS','C47','NS','Nanosecond'),('OHM','OHM','OHM','Ohm'),('OZ','ONZ','OZ','ounce'),('OZA','OZA','OZA','fluid ounce US'),('P','','P','point'),('PA','PAL','PA','pascal'),('PAA','PR','PAA','pair'),('PAK','PK','PAK','pack'),('PAL','D97','PAL','pallet (unit load)'),('PAS','C65','PAS','pascal second'),('PMI','','PMI','per minute'),('PPB','','PPB','parts per billion (units)'),('PPM','','PPM','parts per million (units)'),('PPT','','PPT','parts per trillion (units)'),('PRS','IE','PRS','number of persons'),('PS','','PS','Picosecond'),('PT','PT','PT','pint US (liquid)'),('PUM','ZZ2','PUM','planning unit measure'),('QT','QT','QT','quart US (liquid)'),('RHO','','RHO','gram per cubic centimetre'),('ROL','RO','ROL','Roll'),('S','SEC','S','second'),('SIL','','SIL','silo'),('ST','C62','ST','piece'),('STD','HUR','STD','Hours'),('SUD','C62','SUD','storage unit day'),('TAG','DAY','TAG','Days'),('TC3','','TC3','per cubic centimetre'),('TES','D33','TES','tesla'),('TH','MIL','TH','thousand'),('TM3','','TM3','per cubic metre'),('TNK','','TNK','tanker'),('TO','TNE','TO','tonne (metric ton)'),('TON','STN','TON','ton US'),('UGL','','UGL','microgram per litre'),('V','VLT','V','volt'),('V%','','V%','Percent volume'),('V%O','','V%O','per thousand volume'),('V01','','V01','Microsiemens per centimetre'),('V02','','V02','millimole per litre'),('VPB','','VPB','parts per billion volume'),('VPM','','VPM','parts per million volume'),('VPT','','VPT','parts per trillion volume'),('W','WTT','W','watt'),('WCH','WEE','WCH','Week'),('YD','YRD','YD','yard'),('YD2','YDK','YD2','square yard'),('YD3','YDQ','YD3','cubic yard'),('Z01','','Z01','kilojoule per 100 gram'),('Z02','','Z02','kilocalorie per 100 gram'),('Z03','','Z03','kilocalorie'),('Z04','','Z04','microgram per 100 gram'),('Z06','','Z06','cubic centimetre/sq metre day'),('Z07','HR','Z07','Hardness Rockwell'),('Z08','','Z08','brabender unit'),('Z09','','Z09','flute per metre'),('Z10','','Z10','per 100 milligram'),('Z12','','Z12','per 25 gram'),('Z13','','Z13','per 50 gram'),('Z14','','Z14','per 100 gram'),('Z15','','Z15','decanewton'),('Z16','','Z16','milliequivalent O2/kilogram'),('Z17','','Z17','Dornic degree'),('Z18','','Z18','cubic centimetre/sq metre sec'),('Z19','','Z19','milliequivalent per 100 gram'),('Z20','','Z20','milliequivalent'),('Z21','','Z21','milliequivalent per kilogram'),('Z24','','Z24','per 10 gram'),('Z25','','Z25','milligram per 100 gram'),('Z26','','Z26','gram per unit'),('Z27','','Z27','decanewton per centimetre'),('Z28','','Z28','picogram per gram'),('Z29','','Z29','litre per kilogram'),('Z33','','Z33','gram per minute'),('Z34','','Z34','kilogram per minute'),('Z40','GC','Z40','gram per 100 gram'),('Z41','','Z41','milliequivalent per millilitre'),('Z42','C20','Z42','millinewton'),('Z43','','Z43','milliequivalent H/100 gram'),('Z44','','Z44','milliequivalent OH/100 gram'),('Z45','','Z45','gram per cubic decimetre'),('Z46','','Z46','millilitre per 100g'),('Z47','','Z47','gram per 100 millilitre'),('Z48','','Z48','microgram per gram'),('Z49','','Z49','millilitre per 100 millilitre'),('Z50','','Z50','Kolbach unit per gram'),('Z51','','Z51','Windisch Kolbach unit per gram'),('Z52','','Z52','amyloglucosidase unit per gram'),('Z53','','Z53','Nestle unit per gram'),('Z54','','Z54','trypsin inhibitor unit/gram'),('Z55','','Z55','US pharmacopoeia unit per gram'),('Z58','','Z58','per cubic decimetre'),('Z59','D5','Z59','kilogram per square centimetre'),('Z60','','Z60','kilonewton per metre'),('Z61','','Z61','newton per 15 millimetre'),('Z62','','Z62','millinewton metre'),('Z63','','Z63','newton square millimetre'),('Z64','','Z64','gram per centimetre'),('Z65','','Z65','French degree'),('Z66','','Z66','German degree'),('Z67','','Z67','centinewton square centimetre'),('Z68','','Z68','micrometre per pascal second'),('Z69','','Z69','international unit vit A/100g'),('Z70','','Z70','international unit vit D/100g'),('Z71','','Z71','international unit vit E/100g'),('Z72','','Z72','microgram ß carotene/100g'),('Z73','','Z73','microgram RE/100g'),('Z74','','Z74','milligram TE per 100g'),('Z75','','Z75','microgram vitamin D/100g'),('Z76','GO','Z76','milligram per square metre'),('Z77','D21','Z77','square metre per kilogram'),('Z78','','Z78','millipascal'),('Z79','','Z79','gram per square metre day'),('Z80','','Z80','milliosmole per litre solution'),('Z81','','Z81','milliosmole per kilogram water'),('Z82','','Z82','US pharmacopoeia unit per mg'),('Z83','','Z83','trypsin inhibitor unit/mg N'),('Z84','','Z84','Nestle unit per kilogram'),('Z85','','Z85','kiloNovo unit per gram'),('Z86','','Z86','microgram per kilogram'),('Z87','','Z87','millilitre per minute'),('Z88','PO','Z88','pound per inch'),('Z89','','Z89','pound per square inch'),('Z90','','Z90','kilogram per hour'),('Z91','','Z91','per kilogram'),('Z92','','Z92','degree Celcius per minute'),('Z93','','Z93','newton centimetre'),('Z94','','Z94','kilogram per 100 square metre'),('Z95','','Z95','per metre'),('Z96','DS','Z96','display'),('Z97','','Z97','per millilitre'),('Z98','','Z98','per 10 millilitre'),('Z99','','Z99','international unit vitamin A'),('ZA0','IA','IA','inch pound'),('ZA1','','ZA1','microgram beta carotene'),('ZA2','','ZA2','microgram retinol equivalent'),('ZA3','','ZA3','international unit vitamin D'),('ZA4','','ZA4','microgram vitamin D'),('ZA5','','ZA5','International unit vitamin E'),('ZA6','','ZA6','mg tocopherol equivalent'),('ZA7','','ZA7','millilitre per gram'),('ZA8','','ZA8','degree brix'),('ZA9','','ZA9','degree Soxhlet Henkel'),('ZB0','NU','ZB0','newton metre'),('ZB1','GJ','ZB1','gram per millilitre'),('ZB2','NE','ZB2','net litre'),('ZB3','','ZB3','per 25 millilitre'),('ZB4','','ZB4','per 50 millilitre'),('ZB5','','ZB5','per 100 millilitre'),('ZB6','','ZB6','per gross rating point'),('ZB7','','ZB7','unit per day'),('ZB8','','ZB8','litre per day'),('ZB9','','ZB9','gram per day'),('ZC0','CP','ZC0','centipoise'),('ZC1','','ZC1','per day'),('ZC2','','ZC2','per week'),('ZC3','','ZC3','per month'),('ZC4','','ZC4','gross rating point'),('ZC5','','ZC5','targeted rating point'),('ZC6','','ZC6','advertising spot'),('ZC7','','ZC7','newton millimetre'),('ZC8','','ZC8','per 5 gram'),('ZC9','MC','ZC9','microgram'),('ZD0','','ZD0','milligram retinol equivalent'),('ZD1','','ZD1','milligram beta carotene'),('ZD2','','ZD2','x1000 international unit vit A'),('ZD3','','ZD3','milligram vitamin D'),('ZD4','','ZD4','x1000 international unit vit D'),('ZD7','G/M','ZD7','gram per meter'),('ZD8','','ZD8','milligram per square decimetre'),('ZD9','','ZD9','milligram per end'),('ZE1','','ZE1','pinhole per square metre'),('ZE2','','ZE2','milligram per 1000 cycles'),('ZE3','','ZE3','unit per centimetre'),('ZF1','ZZA','IEA','IP Each'),('ZF2','ZZB','IDP','IP Display'),('ZF3','ZZC','ICS','IP Case'),('ZF4','ZZD','ICT','IP Carton'),('ZF5','ZZE','ILY','IP Layer'),('ZF6','ZZF','IPL','IP Pallet'),('ZF7','ZZG','IBG','IP Bag'),('ZF8','ZZH','IDR','IP Drum'),('ZF9','ZZI','IRL','IP Roll'),('ZG0','ZZJ','ITH','IP 1000'),('ZG1','ZZK','IPR','IP Pair'),('ZG2','ZZL','IPK','IP Pack'),('ZG3','ZZM','IBT','IP Bottle'),('ZG4','ZZN','IDZ','IP Dozen'),('ZG5','ZZO','ICN','IP Can'),('ZG6','ZZP','ICR','IP Crate'); /*!40000 ALTER TABLE `APP_UOM` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `BAR_EAN_DEFS` -- DROP TABLE IF EXISTS `BAR_EAN_DEFS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BAR_EAN_DEFS` ( `APPLICATION_ID` varchar(4) NOT NULL, `DESCRIPTION` varchar(80) DEFAULT NULL, `DATA_TYPE` varchar(1) DEFAULT NULL, `DECIMAL_INDICATOR` varchar(1) DEFAULT NULL, `MAX_DATA_LENGTH` bigint(10) DEFAULT NULL, `FIXED_VARIABLE` varchar(1) DEFAULT NULL, `CHECK_DIGIT` varchar(1) DEFAULT NULL, PRIMARY KEY (`APPLICATION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `BAR_EAN_DEFS` -- LOCK TABLES `BAR_EAN_DEFS` WRITE; /*!40000 ALTER TABLE `BAR_EAN_DEFS` DISABLE KEYS */; INSERT INTO `BAR_EAN_DEFS` VALUES ('00','SSCC-18','S','N',18,'F','Y'),('01','SCC-14','S','N',14,'F','N'),('02','Item Number of Goods Contained Within Another Unit (Must Use with AI 37)','S','N',14,'F','N'),('10','Batch or Lot Number','S','N',20,'V','N'),('11','Production Date (YYMMDD)','D','N',6,'F','N'),('13','Packaging Date (YYMMDD)','D','N',6,'F','N'),('15','Sell By Date (Quality) (YYMMDD)','D','N',6,'F','N'),('17','Expiration Date (Safety) (YYMMDD)','D','N',6,'F','N'),('20','Product Variant','S','N',2,'F','N'),('21','Serial Number','S','N',20,'V','N'),('22','HIBCC - Quantity, Date, Batch and Link','S','N',29,'V','N'),('230','Lot Number (Transitional Use)','S','N',1,'F','N'),('231','Lot Number (Transitional Use)','S','N',3,'F','N'),('232','Lot Number (Transitional Use)','S','N',5,'F','N'),('233','Lot Number (Transitional Use)','S','N',7,'F','N'),('234','Lot Number (Transitional Use)','S','N',9,'F','N'),('235','Lot Number (Transitional Use)','S','N',11,'F','N'),('236','Lot Number (Transitional Use)','S','N',13,'F','N'),('237','Lot Number (Transitional Use)','S','N',15,'F','N'),('238','Lot Number (Transitional Use)','S','N',17,'F','N'),('239','Lot Number (Transitional Use)','S','N',19,'F','N'),('240','Additional Product Identification assigned by the Manufacturer','S','N',30,'V','N'),('250','Secondary Serial Number','S','N',30,'V','N'),('30','Quantity','N','N',8,'V','N'),('310','Net Weight, Kilograms','N','Y',7,'F','N'),('311','Length or 1st Dimension, Meters','N','Y',7,'F','N'),('312','Width, Diameter or 2nd Dimension, Meters','N','Y',7,'F','N'),('313','Depth, Thickness, Height or 3rd Dimension, Meters','N','Y',7,'F','N'),('314','Area, Square Meters','N','Y',7,'F','N'),('315','Volume, Liters','N','Y',7,'F','N'),('316','Volume, Cubic Meters','N','Y',7,'F','N'),('320','Net Weight, Pounds','N','Y',7,'F','N'),('321','Length or 1st Dimension, Inches','N','Y',7,'F','N'),('322','Length or 1st Dimension, Feet','N','Y',7,'F','N'),('323','Length or 1st Dimension, Yards','N','Y',7,'F','N'),('324','Width, Diameter, or 2nd Dimension, Inches','N','Y',7,'F','N'),('325','Width, Diameter, or 2nd Dimension, Feet','N','Y',7,'F','N'),('326','Width, Diameter, or 2nd Dimension, Yards','N','Y',7,'F','N'),('327','Depth, Thickness, Height or 3rd Dimension, Inches','N','Y',7,'F','N'),('328','Depth, Thickness, Height or 3rd Dimension, Feet','N','Y',7,'F','N'),('329','Depth, Thickness, Height or 3rd Dimension, Yards','N','Y',7,'F','N'),('330','Gross Weight, Kilograms','N','Y',7,'F','N'),('331','Length or 1st Dimension, Meters, Logistics','N','Y',7,'F','N'),('332','Width, Diameter or 2nd Dimension, Meters, Logistics','N','Y',7,'F','N'),('333','Depth, Thickness, Height or 3rd Dimension, Meters, Logistics','N','Y',7,'F','N'),('334','Area, Square Meters, Logistics','N','Y',7,'F','N'),('335','Gross Volume, Liters','N','Y',7,'F','N'),('336','Gross Volume, Cubic Meters','N','Y',7,'F','N'),('340','Gross Weight, Pounds','N','Y',7,'F','N'),('341','Length or 1st Dimension, Inches, Logistics','N','Y',7,'F','N'),('342','Length or 1st Dimension, Feet, Logistics','N','Y',7,'F','N'),('343','Length or 1st Dimension, Yards, Logistics','N','Y',7,'F','N'),('344','Width, Diameter or 2nd Dimension, Inches, Logistics','N','Y',7,'F','N'),('345','Width, Diameter or 2nd Dimension, Feet, Logistics','N','Y',7,'F','N'),('346','Width, Diameter or 2nd Dimension, Yards, Logistics','N','Y',7,'F','N'),('347','Depth, Thickness, Height or 3rd Dimension, Inches, Logistics','N','Y',7,'F','N'),('348','Depth, Thickness, Height or 3rd Dimension, Feet, Logistics','N','Y',7,'F','N'),('349','Depth, Thickness, Height or 3rd Dimension, Yards, Logistics','N','Y',7,'F','N'),('350','Area, Square Inches','N','Y',7,'F','N'),('351','Area, Square Feet','N','Y',7,'F','N'),('352','Area, Square Yards','N','Y',7,'F','N'),('353','Area, Square Inches, Logistics','N','Y',7,'F','N'),('354','Area, Square Feet, Logistics','N','Y',7,'F','N'),('355','Area, Square Yards, Logistics','N','Y',7,'F','N'),('356','Net Weight, Troy Ounce','N','Y',7,'F','N'),('360','Volume, Quarts','N','Y',7,'F','N'),('361','Volume, Gallons','N','Y',7,'F','N'),('362','Gross Volume, Quarts','N','Y',7,'F','N'),('363','Gross Volume, Gallons','N','Y',7,'F','N'),('364','Volume, Cubic Inches','N','Y',7,'F','N'),('365','Volume, Cubic Feet','N','Y',7,'F','N'),('366','Volume, Cubic Yards','N','Y',7,'F','N'),('367','Gross Volume, Cubic Inches','N','Y',7,'F','N'),('368','Gross Volume, Cubic Feet','N','Y',7,'F','N'),('369','Gross Volume, Cubic Yards','N','Y',7,'F','N'),('37','Quantity of Units Contained (For Use With AI 02 Only)','N','N',8,'V','N'),('400','Customer Purchase Order Number','S','N',30,'V','N'),('410','Ship To (Deliver To) Location Code Using EAN-13','S','N',13,'F','N'),('411','Bill To (Invoice To) Location Code Using EAN-13','S','N',13,'F','N'),('412','Purchase From (Location Code of Party from Whom Goods are Purchased)','S','N',13,'F','N'),('414','EAN Location Code for Physical Identification','S','N',13,'F','N'),('420','Ship To (Deliver To) Postal Code Within a Single Postal Authority','S','N',9,'V','N'),('421','Ship To (Deliver To) Postal Code With 3-Digit ISO Country Code Prefix','S','N',12,'V','N'),('8001','Roll products - Width, Length, Core Diameter, Direction and Splices','S','N',14,'F','N'),('8002','Electronic Serial Number for Cellular Mobile Telephones','S','N',20,'V','N'),('8003','UPC/EAN Number and Serial Number of Returnable Asset','S','N',30,'V','N'),('8004','UCC/EAN Serial Identification','S','N',30,'V','N'),('8005','Identifies the Price Per Unit of Measure','N','N',6,'F','N'),('8100','Coupon Extended Code - Number System Character and Offer','S','N',6,'F','N'),('8101','Coupon Extended Code - Number System Character, Offer, and End of Offer','S','N',10,'F','N'),('8102','Coupon Extended Code - Number System Character preceded by zero','S','N',2,'F','N'),('90','Mutually Agreed, Between Trading Partners or FACT DIs','S','N',30,'V','N'),('91','Intra-Company (Internal)','S','N',30,'V','N'),('92','Intra-Company (Internal)','S','N',30,'V','N'),('93','Intra-Company (Internal)','S','N',30,'V','N'),('94','Intra-Company (Internal)','S','N',30,'V','N'),('95','Internal-Carriers','S','N',30,'V','N'),('96','Internal-Carriers','S','N',30,'V','N'),('97','Intra-Company (Internal)','S','N',30,'V','N'),('98','Intra-Company (Internal)','S','N',30,'V','N'),('99','Internal','S','N',30,'V','N'); /*!40000 ALTER TABLE `BAR_EAN_DEFS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_CONTROL` -- DROP TABLE IF EXISTS `SYS_CONTROL`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_CONTROL` ( `SYSTEM_KEY` varchar(40) NOT NULL, `KEY_VALUE` varchar(80) DEFAULT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, PRIMARY KEY (`SYSTEM_KEY`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_CONTROL` -- LOCK TABLES `SYS_CONTROL` WRITE; /*!40000 ALTER TABLE `SYS_CONTROL` DISABLE KEYS */; INSERT INTO `SYS_CONTROL` VALUES ('BATCH FORMAT','{YEAR1}{JULIAN_DAY}{PLANT}','Format for Batch Number'),('BATCH REGEX','','Regular Expression to Validate Batch Format'),('COMPANY NAME','My Company','Company Name as printed on Reports'),('DEFAULT BATCH STATUS','Restricted','Used if Material has no default batch status defined'),('DEFAULT HELPSET ID','UsingHelp','Default Help Page'),('DEFAULT PALLET STATUS','Unrestricted','Used if Material has no default pallet status defined'),('DEFAULT_LOCATION','default','Home.'),('DESPATCH NUMBER','1','Despatch Number'),('DESPATCH NUMBER FORMAT','WI{NNNNN}','Format of Despatch Number'),('EXPIRY DATE MODE','BATCH','Can be SSCC or BATCH'),('HELPSET FILENAME','help/helpset.hs','Location and name of the HelpSet'),('INTERFACE LOG ID','1',''),('INTERFACE REQUEST ID','1',''),('LABEL_HEADER_COMMENT','Free format text','Comment on barcode label header.'),('MHN NUMBER','1',''),('MHN NUMBER FORMAT','MH{NNNNN}',''),('PASSWORD ATTEMPTS','3','Max password tries before account locked'),('PASSWORD EXPIRY','30','Password expiry in days.'),('PLANT','0929','SAP Plant'),('PROCESS ORDER NUMBER','1',''),('PROCESS ORDER NUMBER FORMAT','{NNNNNNNN}',''),('PROGRAM VERSION','4.02','Program Version'),('REPORT REQUEST ID','1',''),('SCHEMA VERSION','63','Database Version'),('SSCC PREFIX','3500016122','Pallet Number Prefix'),('SSCC SEQUENCE','1','Next Pallet Number'),('SSCC_LOCATION_VALIDATION','False','Check SSCC Material Locations'),('TRANSACTION REF','1',''); /*!40000 ALTER TABLE `SYS_CONTROL` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_GROUPS` -- DROP TABLE IF EXISTS `SYS_GROUPS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_GROUPS` ( `GROUP_ID` varchar(20) NOT NULL, `DESCRIPTION` varchar(80) DEFAULT NULL, PRIMARY KEY (`GROUP_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_GROUPS` -- LOCK TABLES `SYS_GROUPS` WRITE; /*!40000 ALTER TABLE `SYS_GROUPS` DISABLE KEYS */; INSERT INTO `SYS_GROUPS` VALUES ('ADMIN','Admin'),('CUSTOMER','Customer Admin'),('INTERFACE','Interfaces'),('MHN','Master Holds Admin'),('PALLET','Finished Goods'),('PUBLIC','Public'),('QM','Quality Module'),('REPORT_DESIGN','Report Designers'),('TOOLS','Tools'),('XADMIN_BATCH','Batch Admin'),('XADMIN_INTERFACE','Interface Admin'),('XADMIN_LOCATION','Locaton Admin'),('XADMIN_MATERIAL','Purina Material Admin'),('XADMIN_PALLET','Pallet Admin'),('XADMIN_PO','Process Order Admin'),('XADMIN_SYSTEM','System Admin'),('XADMIN_UOM','Purina UOM Admin'),('XPUBLIC',''),('XREAD_BATCH','Read Only Batch'),('XREAD_INTERFACE','Read Only Interface'),('XREAD_LOCATION','Read Only Location'),('XREAD_MATERIAL','Read Only Material'),('XREAD_PALLET',''),('XREAD_PO',''),('XREAD_SYSTEM',''),('XREAD_UOM',''),('XTRANSACT_PALLET',''); /*!40000 ALTER TABLE `SYS_GROUPS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_GROUP_PERMISSIONS` -- DROP TABLE IF EXISTS `SYS_GROUP_PERMISSIONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_GROUP_PERMISSIONS` ( `GROUP_ID` varchar(20) NOT NULL, `MODULE_ID` varchar(35) NOT NULL, PRIMARY KEY (`GROUP_ID`,`MODULE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_GROUP_PERMISSIONS` -- LOCK TABLES `SYS_GROUP_PERMISSIONS` WRITE; /*!40000 ALTER TABLE `SYS_GROUP_PERMISSIONS` DISABLE KEYS */; INSERT INTO `SYS_GROUP_PERMISSIONS` VALUES ('ADMIN','FRM_ADMIN_AUTO_LABELLER'),('ADMIN','FRM_ADMIN_CONTROL_EDIT'),('ADMIN','FRM_ADMIN_CUSTOMER'),('ADMIN','FRM_ADMIN_CUSTOMER_ADD'),('ADMIN','FRM_ADMIN_CUSTOMER_DELETE'),('ADMIN','FRM_ADMIN_CUSTOMER_EDIT'),('ADMIN','FRM_ADMIN_CUSTOMER_RENAME'),('ADMIN','FRM_ADMIN_DESPATCH'),('ADMIN','FRM_ADMIN_GROUPS'),('ADMIN','FRM_ADMIN_GROUP_ADD'),('ADMIN','FRM_ADMIN_GROUP_DELETE'),('ADMIN','FRM_ADMIN_GROUP_EDIT'),('ADMIN','FRM_ADMIN_GROUP_PERM'),('ADMIN','FRM_ADMIN_GROUP_RENAME'),('ADMIN','FRM_ADMIN_INTERFACE'),('ADMIN','FRM_ADMIN_INTERFACE_ADD'),('ADMIN','FRM_ADMIN_INTERFACE_DELETE'),('ADMIN','FRM_ADMIN_INTERFACE_EDIT'),('ADMIN','FRM_ADMIN_INTERFACE_LOG'),('ADMIN','FRM_ADMIN_INTERFACE_PROCESS'),('ADMIN','FRM_ADMIN_INTERFACE_REQUEST'),('ADMIN','FRM_ADMIN_LANGUAGE'),('ADMIN','FRM_ADMIN_LANGUAGE_ADD'),('ADMIN','FRM_ADMIN_LANGUAGE_DELETE'),('ADMIN','FRM_ADMIN_LANGUAGE_EDIT'),('ADMIN','FRM_ADMIN_LOCATIONS'),('ADMIN','FRM_ADMIN_LOCATION_ADD'),('ADMIN','FRM_ADMIN_LOCATION_DELETE'),('ADMIN','FRM_ADMIN_LOCATION_EDIT'),('ADMIN','FRM_ADMIN_MATERIALS'),('ADMIN','FRM_ADMIN_MATERIAL_ADD'),('ADMIN','FRM_ADMIN_MATERIAL_BATCH'),('ADMIN','FRM_ADMIN_MATERIAL_BATCH_EDIT'),('ADMIN','FRM_ADMIN_MATERIAL_DELETE'),('ADMIN','FRM_ADMIN_MATERIAL_EDIT'),('ADMIN','FRM_ADMIN_MATERIAL_LOCATION'),('ADMIN','FRM_ADMIN_MATERIAL_LOCATION_EDIT'),('ADMIN','FRM_ADMIN_MATERIAL_TYPE'),('ADMIN','FRM_ADMIN_MATERIAL_TYPE_ADD'),('ADMIN','FRM_ADMIN_MATERIAL_TYPE_DELETE'),('ADMIN','FRM_ADMIN_MATERIAL_TYPE_EDIT'),('ADMIN','FRM_ADMIN_MATERIAL_TYPE_PRINT'),('ADMIN','FRM_ADMIN_MATERIAL_TYPE_RENAME'),('ADMIN','FRM_ADMIN_MATERIAL_UOM'),('ADMIN','FRM_ADMIN_MATERIAL_UOM_ADD'),('ADMIN','FRM_ADMIN_MATERIAL_UOM_DELETE'),('ADMIN','FRM_ADMIN_MATERIAL_UOM_EDIT'),('ADMIN','FRM_ADMIN_MENU'),('ADMIN','FRM_ADMIN_MHN'),('ADMIN','FRM_ADMIN_MODULES'),('ADMIN','FRM_ADMIN_MODULE_ADD'),('ADMIN','FRM_ADMIN_MODULE_DELETE'),('ADMIN','FRM_ADMIN_MODULE_EDIT'),('ADMIN','FRM_ADMIN_MODULE_RENAME'),('ADMIN','FRM_ADMIN_PALLETS'),('ADMIN','FRM_ADMIN_PALLET_ADD'),('ADMIN','FRM_ADMIN_PALLET_DELETE'),('ADMIN','FRM_ADMIN_PALLET_EDIT'),('ADMIN','FRM_ADMIN_PALLET_EDIT_BATCH'),('ADMIN','FRM_ADMIN_PALLET_EDIT_LOCATION'),('ADMIN','FRM_ADMIN_PALLET_EDIT_MATERIAL'),('ADMIN','FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER'),('ADMIN','FRM_ADMIN_PALLET_EDIT_PROD_DATE'),('ADMIN','FRM_ADMIN_PALLET_EDIT_QUANTITY'),('ADMIN','FRM_ADMIN_PALLET_EDIT_STATUS'),('ADMIN','FRM_ADMIN_PALLET_EDIT_UOM'),('ADMIN','FRM_ADMIN_PALLET_HISTORY'),('ADMIN','FRM_ADMIN_PALLET_PRINT'),('ADMIN','FRM_ADMIN_PROCESS_ORDER'),('ADMIN','FRM_ADMIN_PROCESS_ORDER_ADD'),('ADMIN','FRM_ADMIN_PROCESS_ORDER_DELETE'),('ADMIN','FRM_ADMIN_PROCESS_ORDER_EDIT'),('ADMIN','FRM_ADMIN_QM_DICTIONARY'),('ADMIN','FRM_ADMIN_QM_INSPECTION'),('ADMIN','FRM_ADMIN_QM_SELECTLIST'),('ADMIN','FRM_ADMIN_RF_MENU'),('ADMIN','FRM_ADMIN_TOOLBAR'),('ADMIN','FRM_ADMIN_UOM'),('ADMIN','FRM_ADMIN_UOM_ADD'),('ADMIN','FRM_ADMIN_UOM_DELETE'),('ADMIN','FRM_ADMIN_UOM_EDIT'),('ADMIN','FRM_ADMIN_UOM_PRINT'),('ADMIN','FRM_ADMIN_UOM_RENAME'),('ADMIN','FRM_ADMIN_USERS'),('ADMIN','FRM_ADMIN_USER_ADD'),('ADMIN','FRM_ADMIN_USER_DELETE'),('ADMIN','FRM_ADMIN_USER_EDIT'),('ADMIN','FRM_ADMIN_USER_PERM'),('ADMIN','FRM_ADMIN_USER_RENAME'),('ADMIN','FRM_CM_PRINTERS'),('ADMIN','FRM_PAL_DELETE'),('ADMIN','FRM_PAL_PROD_CONFIRM'),('ADMIN','FRM_PAL_PROD_DEC'),('ADMIN','FRM_PAL_SPLIT'),('ADMIN','FRM_PRODDEC_CONFIRM'),('ADMIN','FRM_PRODDEC_PREVIEW'),('ADMIN','FRM_PRODDEC_PRINT'),('ADMIN','FRM_QM_ACTIVITY'),('ADMIN','FRM_QM_DICTIONARY'),('ADMIN','FRM_QM_INSPECTION'),('ADMIN','FRM_QM_RESULT_ENQUIRY'),('ADMIN','FRM_QM_SAMPLE_EDIT'),('ADMIN','FRM_QM_SAMPLE_LABEL'),('ADMIN','FRM_QM_SAMPLE_RESULTS'),('ADMIN','FRM_QM_SELECTLIST'),('ADMIN','FRM_QM_TEST'),('ADMIN','FRM_SYSTEM_KEYS'),('ADMIN','FRM_SYSTEM_KEYS_ADD'),('ADMIN','FRM_SYSTEM_KEYS_DELETE'),('ADMIN','FRM_SYSTEM_KEYS_EDIT'),('ADMIN','MENU_ADMIN'),('ADMIN','MENU_CUSTOMISE'),('ADMIN','MENU_DATA_MAINT'),('ADMIN','MENU_INTERFACE'),('ADMIN','MENU_PAL'),('ADMIN','MENU_PAL_REPORTS'),('ADMIN','MENU_PERMISSIONS'),('ADMIN','MENU_QM'),('ADMIN','MENU_SETUP'),('ADMIN','MENU_TOOLS'),('ADMIN','root'),('ADMIN','RPT_CONTROL'),('ADMIN','RPT_DESPATCH'),('ADMIN','RPT_GROUPS'),('ADMIN','RPT_HIST_SUMMARY'),('ADMIN','RPT_LOCATIONS'),('ADMIN','RPT_MATERIALS'),('ADMIN','RPT_MATERIAL_UOM'),('ADMIN','RPT_MODULES'),('ADMIN','RPT_PALLETS'),('ADMIN','RPT_PALLET_HISTORY'),('ADMIN','RPT_PALLET_LABEL'),('ADMIN','RPT_PAL_SUMMARY'),('ADMIN','RPT_PROCESS_ORDERS'),('ADMIN','RPT_SAMPLE_LABEL'),('ADMIN','RPT_SAMPLE_LABEL_200'),('ADMIN','RPT_SAMPLE_LABEL_300'),('ADMIN','RPT_TYPES'),('ADMIN','RPT_UNITS'),('ADMIN','RPT_USERS'),('CUSTOMER','FRM_ADMIN_CUSTOMER'),('CUSTOMER','FRM_ADMIN_CUSTOMER_ADD'),('CUSTOMER','FRM_ADMIN_CUSTOMER_DELETE'),('CUSTOMER','FRM_ADMIN_CUSTOMER_EDIT'),('CUSTOMER','FRM_ADMIN_CUSTOMER_RENAME'),('INTERFACE','FRM_ADMIN_INTERFACE'),('INTERFACE','FRM_ADMIN_INTERFACE_EDIT'),('INTERFACE','FRM_ADMIN_INTERFACE_LOG'),('INTERFACE','FRM_ADMIN_INTERFACE_REQUEST'),('INTERFACE','MENU_INTERFACE'),('MHN','FRM_ADMIN_MHN'),('MHN','FRM_ADMIN_MHN_ADD'),('MHN','FRM_ADMIN_MHN_ASSIGN'),('MHN','FRM_ADMIN_MHN_DECISION'),('MHN','FRM_ADMIN_MHN_DECISION_ADD'),('MHN','FRM_ADMIN_MHN_DECISION_ASSIGN'),('MHN','FRM_ADMIN_MHN_DECISION_DELETE'),('MHN','FRM_ADMIN_MHN_DECISION_EDIT'),('MHN','FRM_ADMIN_MHN_DECISION_RENAME'),('MHN','FRM_ADMIN_MHN_DELETE'),('MHN','FRM_ADMIN_MHN_EDIT'),('MHN','FRM_ADMIN_MHN_REASON'),('MHN','FRM_ADMIN_MHN_REASON_ADD'),('MHN','FRM_ADMIN_MHN_REASON_DELETE'),('MHN','FRM_ADMIN_MHN_REASON_EDIT'),('MHN','FRM_ADMIN_MHN_REASON_RENAME'),('MHN','FRM_ADMIN_MHN_STATUS_ASSIGN'),('MHN','MENU_MHN'),('MHN','RPT_MHN'),('MHN','RPT_MHNS'),('PALLET','FRM_ADMIN_AUTO_LABELLER'),('PALLET','FRM_ADMIN_DESPATCH'),('PALLET','FRM_ADMIN_PALLETS'),('PALLET','FRM_ADMIN_PALLET_ADD'),('PALLET','FRM_ADMIN_PALLET_DELETE'),('PALLET','FRM_ADMIN_PALLET_EDIT'),('PALLET','FRM_ADMIN_PALLET_EDIT_BATCH'),('PALLET','FRM_ADMIN_PALLET_EDIT_LOCATION'),('PALLET','FRM_ADMIN_PALLET_EDIT_MATERIAL'),('PALLET','FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER'),('PALLET','FRM_ADMIN_PALLET_EDIT_PROD_DATE'),('PALLET','FRM_ADMIN_PALLET_EDIT_QUANTITY'),('PALLET','FRM_ADMIN_PALLET_EDIT_STATUS'),('PALLET','FRM_ADMIN_PALLET_EDIT_UOM'),('PALLET','FRM_ADMIN_PALLET_HISTORY'),('PALLET','FRM_ADMIN_PALLET_PRINT'),('PALLET','FRM_ADMIN_PROCESS_ORDER'),('PALLET','FRM_PAL_INFO'),('PALLET','FRM_PAL_LABEL_COPIES'),('PALLET','FRM_PAL_PROD_CONFIRM'),('PALLET','FRM_PAL_PROD_DEC'),('PALLET','FRM_PAL_SPLIT'),('PALLET','FRM_PROCESS_ORDER_LABEL'),('PALLET','FRM_PRODDEC_PREVIEW'),('PALLET','FRM_PRODDEC_PRINT'),('PALLET','MENU_PAL'),('PALLET','MENU_PAL_REPORTS'),('PALLET','RPT_DESPATCH'),('PALLET','RPT_HIST_SUMMARY'),('PALLET','RPT_PALLETS'),('PALLET','RPT_PALLET_HISTORY'),('PALLET','RPT_PAL_SUMMARY'),('PALLET','RPT_PROCESS_ORDER_LABEL'),('PUBLIC','FRM_CM_PRINTERS'),('PUBLIC','FRM_PAL_LABEL_COPIES'),('PUBLIC','FRM_PROCESS_ORDER_LABEL'),('PUBLIC','root'),('PUBLIC','RPT_DESPATCH_SERVICE'),('PUBLIC','RPT_PROCESS_ORDER_LABEL'),('QM','FRM_ADMIN_QM_DICTIONARY'),('QM','FRM_ADMIN_QM_INSPECTION'),('QM','FRM_ADMIN_QM_SELECTLIST'),('QM','FRM_QM_ACTIVITY'),('QM','FRM_QM_DICTIONARY'),('QM','FRM_QM_INSPECTION'),('QM','FRM_QM_RESULT_ENQUIRY'),('QM','FRM_QM_SAMPLE_EDIT'),('QM','FRM_QM_SAMPLE_LABEL'),('QM','FRM_QM_SAMPLE_RESULTS'),('QM','FRM_QM_SELECTLIST'),('QM','FRM_QM_TEST'),('QM','MENU_QM'),('QM','RPT_SAMPLE_LABEL'),('QM','RPT_SAMPLE_LABEL_200'),('QM','RPT_SAMPLE_LABEL_300'),('REPORT_DESIGN','EXEC_IREPORT'),('REPORT_DESIGN','MENU_TOOLS'),('TOOLS','EXEC_CONFIG'),('TOOLS','EXEC_IREPORT'),('XADMIN_BATCH','FRM_ADMIN_MATERIAL_BATCH'),('XADMIN_BATCH','FRM_ADMIN_MATERIAL_BATCH_ADD'),('XADMIN_BATCH','FRM_ADMIN_MATERIAL_BATCH_EDIT'),('XADMIN_BATCH','FRM_ADMIN_MATERIAL_LOCATION'),('XADMIN_BATCH','FRM_ADMIN_MATERIAL_LOCATION_ADD'),('XADMIN_BATCH','FRM_ADMIN_MATERIAL_LOCATION_EDIT'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE_ADD'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE_DELETE'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE_EDIT'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE_LOG'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE_PROCESS'),('XADMIN_INTERFACE','FRM_ADMIN_INTERFACE_REQUEST'),('XADMIN_LOCATION','FRM_ADMIN_LOCATIONS'),('XADMIN_LOCATION','FRM_ADMIN_LOCATION_ADD'),('XADMIN_LOCATION','FRM_ADMIN_LOCATION_DELETE'),('XADMIN_LOCATION','FRM_ADMIN_LOCATION_EDIT'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIALS'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_ADD'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_BATCH'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_BATCH_EDIT'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_DELETE'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_EDIT'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_LOCATION'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_LOCATION_EDIT'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_TYPE'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_TYPE_ADD'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_TYPE_DELETE'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_TYPE_EDIT'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_TYPE_PRINT'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_TYPE_RENAME'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_UOM'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_UOM_ADD'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_UOM_DELETE'),('XADMIN_MATERIAL','FRM_ADMIN_MATERIAL_UOM_EDIT'),('XADMIN_PALLET','FRM_ADMIN_PALLETS'),('XADMIN_PALLET','FRM_ADMIN_PALLET_ADD'),('XADMIN_PALLET','FRM_ADMIN_PALLET_DELETE'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_BATCH'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_LOCATION'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_MATERIAL'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_PROD_DATE'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_QUANTITY'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_STATUS'),('XADMIN_PALLET','FRM_ADMIN_PALLET_EDIT_UOM'),('XADMIN_PALLET','FRM_ADMIN_PALLET_HISTORY'),('XADMIN_PALLET','FRM_ADMIN_PALLET_PRINT'),('XADMIN_PALLET','FRM_PAL_INFO'),('XADMIN_UOM','FRM_ADMIN_UOM'),('XADMIN_UOM','FRM_ADMIN_UOM_ADD'),('XADMIN_UOM','FRM_ADMIN_UOM_DELETE'),('XADMIN_UOM','FRM_ADMIN_UOM_EDIT'),('XADMIN_UOM','FRM_ADMIN_UOM_PRINT'),('XADMIN_UOM','FRM_ADMIN_UOM_RENAME'),('XPUBLIC','FRM_CM_PRINTERS'),('XPUBLIC','MENU_ADMIN'),('XPUBLIC','MENU_CUSTOMISE'),('XPUBLIC','MENU_DATA_MAINT'),('XPUBLIC','MENU_INTERFACE'),('XPUBLIC','MENU_PAL'),('XPUBLIC','MENU_PAL_REPORTS'),('XPUBLIC','MENU_PERMISSIONS'),('XPUBLIC','MENU_SETUP'),('XPUBLIC','MENU_TOOLS'),('XPUBLIC','root'),('XPUBLIC','RPT_CONTROL'),('XPUBLIC','RPT_DESPATCH'),('XPUBLIC','RPT_GROUPS'),('XPUBLIC','RPT_LOCATIONS'),('XPUBLIC','RPT_MATERIALS'),('XPUBLIC','RPT_MATERIAL_UOM'),('XPUBLIC','RPT_MODULES'),('XPUBLIC','RPT_PALLETS'),('XPUBLIC','RPT_PALLET_HISTORY'),('XPUBLIC','RPT_PALLET_LABEL'),('XPUBLIC','RPT_PROCESS_ORDERS'),('XPUBLIC','RPT_TYPES'),('XPUBLIC','RPT_UNITS'),('XREAD_BATCH','FRM_ADMIN_MATERIAL_BATCH'),('XREAD_BATCH','FRM_ADMIN_MATERIAL_LOCATION'),('XREAD_INTERFACE','FRM_ADMIN_INTERFACE_LOG'),('XREAD_LOCATION','FRM_ADMIN_LOCATIONS'),('XREAD_MATERIAL','FRM_ADMIN_MATERIALS'),('XREAD_MATERIAL','FRM_ADMIN_MATERIAL_BATCH'),('XREAD_MATERIAL','FRM_ADMIN_MATERIAL_LOCATION'),('XREAD_MATERIAL','FRM_ADMIN_MATERIAL_TYPE'),('XREAD_MATERIAL','FRM_ADMIN_MATERIAL_TYPE_PRINT'),('XREAD_MATERIAL','FRM_ADMIN_MATERIAL_UOM'),('XREAD_MATERIAL','FRM_ADMIN_UOM'),('XREAD_PALLET','FRM_ADMIN_PALLETS'),('XREAD_PALLET','FRM_ADMIN_PALLET_PRINT'),('XREAD_PALLET','FRM_PAL_INFO'),('XREAD_PO','FRM_ADMIN_PROCESS_ORDER'),('XREAD_SYSTEM','FRM_ADMIN_MODULES'),('XREAD_SYSTEM','FRM_ADMIN_USERS'),('XREAD_SYSTEM','FRM_SYSTEM_KEYS'),('XREAD_SYSTEM','MENU_CUSTOMISE'),('XREAD_SYSTEM','MENU_PERMISSIONS'),('XREAD_SYSTEM','MENU_SETUP'),('XREAD_SYSTEM','MENU_TOOLS'),('XREAD_SYSTEM','RPT_CONTROL'),('XREAD_SYSTEM','RPT_GROUPS'),('XREAD_SYSTEM','RPT_MODULES'),('XREAD_UOM','FRM_ADMIN_UOM'),('XREAD_UOM','FRM_ADMIN_UOM_PRINT'),('XTRANSACT_PALLET','FRM_ADMIN_DESPATCH'),('XTRANSACT_PALLET','FRM_PAL_PROD_CONFIRM'),('XTRANSACT_PALLET','FRM_PAL_PROD_DEC'); /*!40000 ALTER TABLE `SYS_GROUP_PERMISSIONS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_INTERFACE` -- DROP TABLE IF EXISTS `SYS_INTERFACE`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_INTERFACE` ( `INTERFACE_TYPE` varchar(50) NOT NULL, `INTERFACE_DIRECTION` varchar(50) NOT NULL, `PATH` varchar(255) DEFAULT NULL, `ENABLED` varchar(1) DEFAULT NULL, `DEVICE` varchar(15) DEFAULT NULL, `SUBJECT` varchar(100) DEFAULT NULL, `TOPIC` varchar(100) DEFAULT NULL, `SERVER` varchar(45) DEFAULT NULL, `USERNAME` varchar(45) DEFAULT NULL, `PASSWORD` varchar(45) DEFAULT NULL, `FORMAT` varchar(15) DEFAULT NULL, `UOM_CONVERSION` varchar(30) DEFAULT NULL, `ENABLE_EMAIL_NOTIFICATIONS` varchar(1) DEFAULT NULL, `EMAIL_FLAGS` varchar(10) DEFAULT NULL, `EMAIL_ADDRESSES` varchar(250) DEFAULT NULL, PRIMARY KEY (`INTERFACE_TYPE`,`INTERFACE_DIRECTION`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_INTERFACE` -- LOCK TABLES `SYS_INTERFACE` WRITE; /*!40000 ALTER TABLE `SYS_INTERFACE` DISABLE KEYS */; INSERT INTO `SYS_INTERFACE` VALUES ('Batch Status Change','Input','{base_dir}\\xml\\interface\\input\\Batch Status Change','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML','None',NULL,'',''),('Despatch Confirmation','Output','{base_dir}\\xml\\interface\\output\\Despatch Confirmation','Y','Disk',NULL,NULL,NULL,NULL,NULL,'EANCOM','None',NULL,'',''),('Material Definition','Input','{base_dir}\\xml\\interface\\input\\Material Definition','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML',NULL,NULL,'',''),('Pallet Status Change','Input','{base_dir}\\xml\\interface\\input\\Pallet Status Change','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML','None',NULL,'',''),('Process Order','Input','{base_dir}\\xml\\interface\\input\\Process Order','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML','None',NULL,'',''),('Process Order Status Change','Input','{base_dir}\\xml\\interface\\input\\Process Order Status Change','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML','None',NULL,'',''),('Production Declaration','Input','{base_dir}\\xml\\interface\\input\\Production Declaration','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML','None',NULL,'',''),('Production Declaration','Output','{base_dir}\\xml\\interface\\output\\Production Declaration','Y','Disk',NULL,NULL,NULL,NULL,NULL,'XML','None',NULL,'',''); /*!40000 ALTER TABLE `SYS_INTERFACE` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_INTERFACE_LOG` -- DROP TABLE IF EXISTS `SYS_INTERFACE_LOG`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_INTERFACE_LOG` ( `EVENT_TIME` datetime NOT NULL, `INTERFACE_LOG_ID` decimal(22,0) NOT NULL DEFAULT '0', `MESSAGE_REF` varchar(45) DEFAULT NULL, `INTERFACE_TYPE` varchar(50) DEFAULT NULL, `MESSAGE_INFORMATION` varchar(45) DEFAULT NULL, `INTERFACE_DIRECTION` varchar(50) DEFAULT NULL, `ACTION` varchar(45) DEFAULT NULL, `MESSAGE_DATE` datetime DEFAULT NULL, `MESSAGE_STATUS` varchar(45) DEFAULT NULL, `MESSAGE_ERROR` varchar(150) DEFAULT NULL, `WORKSTATION_ID` varchar(45) DEFAULT NULL, `FILENAME` varchar(150) DEFAULT NULL, PRIMARY KEY (`EVENT_TIME`,`INTERFACE_LOG_ID`), KEY `SYS_INT_LOG_FILENAME_IDX` (`FILENAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_INTERFACE_LOG` -- LOCK TABLES `SYS_INTERFACE_LOG` WRITE; /*!40000 ALTER TABLE `SYS_INTERFACE_LOG` DISABLE KEYS */; /*!40000 ALTER TABLE `SYS_INTERFACE_LOG` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_INTERFACE_REQUEST` -- DROP TABLE IF EXISTS `SYS_INTERFACE_REQUEST`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_INTERFACE_REQUEST` ( `EVENT_TIME` datetime NOT NULL, `INTERFACE_REQUEST_ID` decimal(22,0) NOT NULL, `INTERFACE_TYPE` varchar(50) DEFAULT NULL, `WORKSTATION_ID` varchar(45) DEFAULT NULL, `TRANSACTION_REF` decimal(22,0) DEFAULT NULL, `STATUS` varchar(20) DEFAULT NULL, `FILENAME` varchar(150) DEFAULT NULL, `REQUEST_MODE` varchar(25) DEFAULT NULL, PRIMARY KEY (`EVENT_TIME`,`INTERFACE_REQUEST_ID`), KEY `SYS_INTERFACE_REQUEST_IDX` (`STATUS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_INTERFACE_REQUEST` -- LOCK TABLES `SYS_INTERFACE_REQUEST` WRITE; /*!40000 ALTER TABLE `SYS_INTERFACE_REQUEST` DISABLE KEYS */; /*!40000 ALTER TABLE `SYS_INTERFACE_REQUEST` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_LANGUAGE` -- DROP TABLE IF EXISTS `SYS_LANGUAGE`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_LANGUAGE` ( `RESOURCE_KEY` varchar(50) NOT NULL, `LANGUAGE_ID` varchar(2) NOT NULL, `TEXT` varchar(150) DEFAULT NULL, `MNEMONIC` varchar(1) DEFAULT NULL, PRIMARY KEY (`RESOURCE_KEY`,`LANGUAGE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_LANGUAGE` -- LOCK TABLES `SYS_LANGUAGE` WRITE; /*!40000 ALTER TABLE `SYS_LANGUAGE` DISABLE KEYS */; INSERT INTO `SYS_LANGUAGE` VALUES ('btn_Add','EN','Add','A'),('btn_Add','HU','Hozzáad','H'),('btn_Add','IT','Aggiungi','A'),('btn_Add','NL','Toevoegen','T'),('btn_Archive','EN','Archive','A'),('btn_Archive','HU','Ment','M'),('btn_Archive','IT','Archivio','A'),('btn_Archive','NL','Archief','A'),('btn_Assign_SSCC','EN','Assign SSCC','0'),('btn_Assign_SSCC','HU','Assign SSCC','0'),('btn_Assign_SSCC','IT','Assegna SSCC','0'),('btn_Assign_SSCC','NL','Assign SSCC','0'),('btn_Assign_to_MHN','EN','Assign to MHN','0'),('btn_Assign_to_MHN','HU','Assign to MHN','0'),('btn_Assign_to_MHN','IT','Assegna a MHN','0'),('btn_Assign_to_MHN','NL','Assign to MHN','0'),('btn_Clear_Data','EN','Clear Data','C'),('btn_Clear_Data','HU','Aadatok Törlése','A'),('btn_Clear_Data','IT','Cancella dati','C'),('btn_Clear_Data','NL','Gegevens Wissen','G'),('btn_Clear_Filter','EN','Clear Filter','F'),('btn_Clear_Filter','HU','Szurés törlés','S'),('btn_Clear_Filter','IT','Pulisci Filtro','F'),('btn_Clear_Filter','NL','Clear Filter','F'),('btn_Close','EN','Close','C'),('btn_Close','HU','Lezár','L'),('btn_Close','IT','Chiudi','C'),('btn_Close','NL','Sluiten','S'),('btn_Confirm','EN','Confirm','f'),('btn_Confirm','HU','Megerosít','T'),('btn_Confirm','IT','Conferma','f'),('btn_Confirm','NL','Bevestig','B'),('btn_Decision_Assign','EN','Assign Decision','0'),('btn_Decision_Assign','HU','Assign Decision','0'),('btn_Decision_Assign','IT','Assegna Decisione','0'),('btn_Decision_Assign','NL','Assign Decision','0'),('btn_Delete','EN','Delete','D'),('btn_Delete','HU','Töröl','D'),('btn_Delete','IT','Elimina','D'),('btn_Delete','NL','Verwijder','V'),('btn_Dictionary','EN','Dictionary','P'),('btn_Dictionary','HU','Szótár','P'),('btn_Dictionary','IT','Dizionario','P'),('btn_Dictionary','NL','Woordenboek','P'),('btn_Edit','EN','Edit','E'),('btn_Edit','HU','Szerkeszt','B'),('btn_Edit','IT','Modifica','E'),('btn_Edit','NL','Bewerk','w'),('btn_Edit_Batch','EN','Edit Batch',''),('btn_Edit_Batch','HU','Batch Szerkeztés',''),('btn_Edit_Batch','IT','Modifica Batch',''),('btn_Edit_Batch','NL','Bewerk Batch','b'),('btn_Edit_Location','EN','Edit Location',''),('btn_Edit_Location','HU','Lokáció Szerkeztés',''),('btn_Edit_Location','IT','Modifica Location',''),('btn_Edit_Location','NL','Bewerk Locatie','l'),('btn_Edit_Material','EN','Edit Material',''),('btn_Edit_Material','HU','Anyag Szerkeztés',''),('btn_Edit_Material','IT','Modifica Materiale',''),('btn_Edit_Material','NL','Bewerk Produkt','P'),('btn_Edit_MHN','EN','Edit MHN','0'),('btn_Edit_MHN','HU','Edit MHN','0'),('btn_Edit_MHN','IT','Modifica MHN','0'),('btn_Edit_MHN','NL','Edit MHN','0'),('btn_Edit_Pallet','EN','Edit Pallet',''),('btn_Edit_Pallet','HU','Palletta Szerkeztés',''),('btn_Edit_Pallet','IT','Modifica Pallet',''),('btn_Edit_Pallet','NL','Bewerk Pallet','a'),('btn_Edit_Process_Order','EN','Edit Process Order',''),('btn_Edit_Process_Order','HU','PO Szerkesztés',''),('btn_Edit_Process_Order','IT','Modifica Process Order',''),('btn_Edit_Process_Order','NL','Bewerk Process Order','O'),('btn_Excel','EN','Excel','x'),('btn_Excel','HU','Excel','x'),('btn_Excel','IT','Excel','x'),('btn_Excel','NL','Excel','x'),('btn_Find','EN','Find','F'),('btn_Find','HU','Keres','K'),('btn_Find','IT','Trova','F'),('btn_Find','NL','Zoek','Z'),('btn_Help','EN','Help','H'),('btn_Help','HU','Segítség','S'),('btn_Help','IT','Aiuto','H'),('btn_Help','NL','Help','H'),('btn_Hold','EN','Hold',''),('btn_Hold','HU','Tart',''),('btn_Hold','IT','Tenere',''),('btn_Hold','NL','Houd',''),('btn_Interface_Start','EN','Start Interface',''),('btn_Interface_Start','HU','Interfész indítás','I'),('btn_Interface_Start','IT','Avvia Interfaccia',''),('btn_Interface_Start','NL','Start Interface','S'),('btn_Interface_Stop','EN','Stop Interface',''),('btn_Interface_Stop','HU','Interfész leállítás',''),('btn_Interface_Stop','IT','Ferma Interfaccia',''),('btn_Interface_Stop','NL','Stop Interface','t'),('btn_Label','EN','Label',''),('btn_Label','HU','Label',''),('btn_Label','IT','Etichetta',''),('btn_Label','NL','Label','L'),('btn_Material_Batches','EN','Batches',''),('btn_Material_Batches','HU','Batch-ek',''),('btn_Material_Batches','IT','Batches',''),('btn_Material_Batches','NL','Batches','B'),('btn_Material_Locations','EN','Material Locations',''),('btn_Material_Locations','HU','Anyag Helyszínek',''),('btn_Material_Locations','IT','Materiale Sedi',''),('btn_Material_Locations','NL','Materiaal Locaties',''),('btn_Material_UOM_Conversions','EN','UOM Conversions',''),('btn_Material_UOM_Conversions','HU','UOM Konverzió',''),('btn_Material_UOM_Conversions','IT','Conversioni UdM',''),('btn_Material_UOM_Conversions','NL','UOM Conversies','U'),('btn_New','EN','New','N'),('btn_New','HU','Új','U'),('btn_New','IT','Nuovo','N'),('btn_New','NL','Nieuw','N'),('btn_New','Új','HU','U'),('btn_Ok','EN','Ok','O'),('btn_Ok','HU','OK','O'),('btn_Ok','IT','OK','O'),('btn_Ok','NL','Oke','O'),('btn_Ok','OK','HU','O'),('btn_Permissions','EN','Permissions',''),('btn_Permissions','HU','Engedélyek',''),('btn_Permissions','IT','Autorizzazioni',''),('btn_Permissions','NL','Machtigingen','M'),('btn_Print','EN','Print','P'),('btn_Print','HU','Nyomtat','N'),('btn_Print','IT','Stampa','P'),('btn_Print','NL','Afdrukken','A'),('btn_Print_Summary','EN','Summary',''),('btn_Print_Summary','HU','Összeg',''),('btn_Print_Summary','IT','Sommario',''),('btn_Print_Summary','NL','Summary',''),('btn_Refresh','EN','Refresh','R'),('btn_Refresh','HU','Frissít','F'),('btn_Refresh','IT','Aggiorna','R'),('btn_Refresh','NL','Vernieuwen','w'),('btn_Rename','EN','Rename',''),('btn_Rename','HU','Átnevez',''),('btn_Rename','IT','Rinomina',''),('btn_Rename','NL','Hernoem','H'),('btn_Resubmit','EN','Resubmit','R'),('btn_Resubmit','HU','Újraküld','U'),('btn_Resubmit','IT','Reinvia','R'),('btn_Resubmit','NL','Verzend Opnieuw','V'),('btn_Re_Print','EN','Re-Print',''),('btn_Re_Print','HU','Újra-Nyomtat',''),('btn_Re_Print','IT','Ristampa',''),('btn_Re_Print','NL','Re-Print',''),('btn_Save','EN','Save','S'),('btn_Save','HU','Ment','M'),('btn_Save','IT','Salva','S'),('btn_Save','NL','Opslaan','O'),('btn_Search','EN','Search','S'),('btn_Search','HU','Keres','K'),('btn_Search','IT','Cerca','S'),('btn_Search','NL','Zoeken','Z'),('btn_Select','EN','Select','S'),('btn_Select','HU','Kiválaszt','K'),('btn_Select','IT','Seleziona','S'),('btn_Select','NL','Selecteer','S'),('btn_Split','EN','Split','P'),('btn_Split','HU','Split','P'),('btn_Split','IT','Split','P'),('btn_Split','NL','Split','P'),('btn_Status_Assign','EN','Assign Status','0'),('btn_Status_Assign','HU','Assign Status','0'),('btn_Status_Assign','IT','Assegna Stato','0'),('btn_Status_Assign','NL','Assign Status','0'),('btn_Undo','EN','Undo','U'),('btn_Undo','HU','Vissza','V'),('btn_Undo','IT','Annulla','U'),('btn_Undo','NL','Ongedaan maken','U'),('dlg_Confirm','EN','Confirm',''),('dlg_Confirm','HU','Megerosít',''),('dlg_Confirm','IT','Conferma',''),('dlg_Confirm','NL','Bevestig',''),('dlg_Customer_Add','EN','Add Customer',''),('dlg_Customer_Add','HU','Add Customer',''),('dlg_Customer_Add','IT','Aggiungi Cliente',''),('dlg_Customer_Add','NL','Add Customer',''),('dlg_Customer_Delete','EN','Delete Customer',''),('dlg_Customer_Delete','HU','Delete Customer',''),('dlg_Customer_Delete','IT','Elimina Cliente',''),('dlg_Customer_Delete','NL','Delete Customer',''),('dlg_Customer_Rename','EN','Rename Customer To',''),('dlg_Customer_Rename','HU','Rename Customer To',''),('dlg_Customer_Rename','IT','Rinomina Cliente a',''),('dlg_Customer_Rename','NL','Rename Customer To',''),('dlg_Decision_Add','EN','Add Decision',NULL),('dlg_Decision_Add','HU','Add Decision',NULL),('dlg_Decision_Add','IT','Aggiungi Decisione',''),('dlg_Decision_Add','NL','Add Decision',NULL),('dlg_Decision_Delete','EN','Delete Decision ?',NULL),('dlg_Decision_Delete','HU','Delete Decision ?',NULL),('dlg_Decision_Delete','IT','Eliminare Decisione?',''),('dlg_Decision_Delete','NL','Delete Decision ?',NULL),('dlg_Decision_Rename','EN','Rename Decision to',NULL),('dlg_Decision_Rename','HU','Rename Decision to',NULL),('dlg_Decision_Rename','IT','Rinomina Decisione a',''),('dlg_Decision_Rename','NL','Rename Decision to',NULL),('dlg_Despatch_Confirm','EN','Confirm Despatch ',''),('dlg_Despatch_Confirm','HU','Despath Megerosítés',''),('dlg_Despatch_Confirm','IT','Conferma Spedizione',''),('dlg_Despatch_Confirm','NL','Bevestig Despatch',''),('dlg_Despatch_Create','EN','Create Despatch ?',''),('dlg_Despatch_Create','HU','Despatch elkészítés?',''),('dlg_Despatch_Create','IT','Creare Spedizione?',''),('dlg_Despatch_Create','NL','Maak despatch?',''),('dlg_Despatch_Delete','EN','Delete Despatch',''),('dlg_Despatch_Delete','HU','Despatch törlés',''),('dlg_Despatch_Delete','IT','Elimina Spedizione',''),('dlg_Despatch_Delete','NL','Verwijderen Despatch',''),('dlg_Dictionary_Delete','EN','Delete Dictionary item ','P'),('dlg_Dictionary_Delete','HU','Szótár elem törlése','P'),('dlg_Dictionary_Delete','IT','Eliminare la voce Dictionary','P'),('dlg_Dictionary_Delete','NL','Verwijder Woordenboek post','P'),('dlg_Error','EN','Error',''),('dlg_Error','HU','Hiba',''),('dlg_Error','IT','Errore',''),('dlg_Error','NL','Fout',''),('dlg_Information','EN','Information',''),('dlg_Information','HU','Információ',''),('dlg_Information','IT','Informazione',''),('dlg_Information','NL','Informatie',''),('dlg_Material_Batch_Input','EN','Input Batch',''),('dlg_Material_Batch_Input','HU','Bejövo Batch',''),('dlg_Material_Batch_Input','IT','Inserire Batch',''),('dlg_Material_Batch_Input','NL','Vul batch in',''),('dlg_Material_Input','EN','Input Material',''),('dlg_Material_Input','HU','Bejövo Anyag',''),('dlg_Material_Input','IT','Inserire Materiale',''),('dlg_Material_Input','NL','Vul Produkt in',''),('dlg_Material_Location_Input','EN','Locatio',''),('dlg_Material_Location_Input','HU','Helyszí',''),('dlg_Material_Location_Input','IT','Posizione',''),('dlg_Material_Location_Input','NL','Locatie',''),('dlg_Material_Type_Add','EN','Add Material Type',''),('dlg_Material_Type_Add','HU','Anyag típus hozzáadása',''),('dlg_Material_Type_Add','IT','Aggiungi Tipo Materiale',''),('dlg_Material_Type_Add','NL','Voeg Produkt type toe',''),('dlg_Material_Type_Delete','EN','Delete Type',''),('dlg_Material_Type_Delete','HU','Típus törlése',''),('dlg_Material_Type_Delete','IT','Elimina Tipo',''),('dlg_Material_Type_Delete','NL','Verwijder type',''),('dlg_Material_Type_Rename','EN','Rename Type To',''),('dlg_Material_Type_Rename','HU','Átnevezés más típusra',''),('dlg_Material_Type_Rename','IT','Rinomina Tipo a ',''),('dlg_Material_Type_Rename','NL','Hernoem type naar',''),('dlg_Material_UOM_Input','EN','Enter UOM',''),('dlg_Material_UOM_Input','HU','UOM bevitele',''),('dlg_Material_UOM_Input','IT','Inserire UdM',''),('dlg_Material_UOM_Input','NL','Voer UOM in',''),('dlg_Process_Order_Add','EN','Enter Process Order No (Blank = Auto)',''),('dlg_Process_Order_Add','HU','PO Bevitele',''),('dlg_Process_Order_Add','IT','Inserire PO (Blank = Auto)',''),('dlg_Process_Order_Add','NL','Voer Processorder nummer in (blank = Auto)',''),('dlg_Quantity_Confirm','EN','Specified pallet quantity is greater than the default full pallet quantity - are you sure ?',''),('dlg_Quantity_Confirm','HU','Specified pallet quantity is greater than the default full pallet quantity - are you sure ?',''),('dlg_Quantity_Confirm','IT','La quantità inserita è maggiore della quantità di default - sei sicuro?',''),('dlg_Quantity_Confirm','NL','Specified pallet quantity is greater than the default full pallet quantity - are you sure ?',''),('dlg_Reason_Add','EN','Add Reason',NULL),('dlg_Reason_Add','HU','Add Reason',NULL),('dlg_Reason_Add','IT','Aggiungi Reason',''),('dlg_Reason_Add','NL','Add Reason',NULL),('dlg_Reason_Delete','EN','Delete Reason Code',NULL),('dlg_Reason_Delete','HU','Delete Reason Code',NULL),('dlg_Reason_Delete','IT','Elimina Reason Code',''),('dlg_Reason_Delete','NL','Delete Reason Code',NULL),('dlg_Reason_Rename','EN','Rename Reason Code to',NULL),('dlg_Reason_Rename','HU','Rename Reason Code to',NULL),('dlg_Reason_Rename','IT','Rinomina Reason Code a',''),('dlg_Reason_Rename','NL','Rename Reason Code to',NULL),('dlg_SelectList_Delete','EN','Delete item from List','P'),('dlg_SelectList_Delete','HU','Elem törlése listából','P'),('dlg_SelectList_Delete','IT','Eliminare la voce dall elenco','P'),('dlg_SelectList_Delete','NL','Verwijder item uit lijst','P'),('dlg_SSCC_Add','EN','Enter SSCC or AUTO',''),('dlg_SSCC_Add','HU','SSCC bevitel (vagy auto)',''),('dlg_SSCC_Add','IT','Inserire SSCC o AUTO',''),('dlg_SSCC_Add','NL','Voer SSCC in of AUTO',''),('dlg_SSCC_Delete','EN','Delete SSCC',''),('dlg_SSCC_Delete','HU','SSCC törlés',''),('dlg_SSCC_Delete','IT','Elimina SSCC',''),('dlg_SSCC_Delete','NL','Verwijderen SSCC',''),('dlg_SSCC_Print_Maximum','EN','Maxiumum number of labels which can be printed is 100. Change criterial or limit of records.',''),('dlg_SSCC_Print_Maximum','HU','Maximális címke nyomtatási szám 100. változtasd meg a mennyiséget',''),('dlg_SSCC_Print_Maximum','IT','Il numero massimo di etichette è 100. Cambia i criteri o il limite di record',''),('dlg_SSCC_Print_Maximum','NL','Maxiumum aantal labels dat kan worden afgedrukt is 100. Wijzig criterial of pas het aantal aan.',''),('dlg_UOM_Add','EN','Add UOM',''),('dlg_UOM_Add','HU','UOM hozzáadás',''),('dlg_UOM_Add','IT','Aggiungi UdM',''),('dlg_UOM_Add','NL','Voeg UOM toe',''),('dlg_UOM_Delete','EN','Delete UOM',''),('dlg_UOM_Delete','HU','UOM törlés',''),('dlg_UOM_Delete','IT','Elimina UdM',''),('dlg_UOM_Delete','NL','Verwijder UOM',''),('dlg_UOM_Rename','EN','Rename UOM to',''),('dlg_UOM_Rename','HU','UOM átnevezés',''),('dlg_UOM_Rename','IT','Rinomina UdM a',''),('dlg_UOM_Rename','NL','Hernoem UOM naar',''),('err_Batch_Blank','EN','Batch is Blank',''),('err_Batch_Blank','HU','Batch üres',''),('err_Batch_Blank','IT','Il Batch è Blank',''),('err_Batch_Blank','NL','Batch is leeg',''),('err_Customer_Blank','EN','Process Order is Blank',''),('err_Customer_Blank','HU','Process Order is Blank',''),('err_Customer_Blank','IT','Il Cliente è Blank',''),('err_Customer_Blank','NL','Process Order is Blank',''),('err_Location_Blank','EN','Location is Blank',''),('err_Location_Blank','HU','Lokáció üres',''),('err_Location_Blank','IT','La Location è Blank',''),('err_Location_Blank','NL','Locatie is leeg',''),('err_Material_Blank','EN','Material is Blank',''),('err_Material_Blank','HU','Anyag üres',''),('err_Material_Blank','IT','Il Materiale è Blank',''),('err_Material_Blank','NL','Produkt is leeg',''),('err_Process_Order_Blank','EN','Process Order is Blank',''),('err_Process_Order_Blank','HU','PO üres',''),('err_Process_Order_Blank','IT','Il PO è Blank',''),('err_Process_Order_Blank','NL','Process Order is leeg',''),('lbl_Activity','EN','Activity','P'),('lbl_Activity','HU','Activity','P'),('lbl_Activity','IT','Activity','P'),('lbl_Activity','NL','Activity','P'),('lbl_Activity_ID','EN','Activity ID',''),('lbl_Activity_ID','HU','Tevékenység ID',''),('lbl_Activity_ID','IT','Attività ID',''),('lbl_Activity_ID','NL','Activiteit ID',''),('lbl_Assigned','EN','Assigned',''),('lbl_Assigned','HU','Hozzáadva',''),('lbl_Assigned','IT','Assegnato',''),('lbl_Assigned','NL','Toegekend',''),('lbl_Assign_to_MHN','EN','Assign to MHN','0'),('lbl_Assign_to_MHN','HU','Assign to MHN','0'),('lbl_Assign_to_MHN','IT','Assegna a MHN','0'),('lbl_Assign_to_MHN','NL','Assign to MHN','0'),('lbl_Authorisor','EN','Authorised By','0'),('lbl_Authorisor','HU','Authorised By','0'),('lbl_Authorisor','IT','Autorizzato da','0'),('lbl_Authorisor','NL','Authorised By','0'),('lbl_Base_UOM','EN','Base UOM',''),('lbl_Base_UOM','HU','Alap UOM',''),('lbl_Base_UOM','IT','UdM Base',''),('lbl_Base_UOM','NL','Base UOM',''),('lbl_Batch','EN','Batch',''),('lbl_Batch','HU','Batch',''),('lbl_Batch','IT','Batch',''),('lbl_Batch','NL','Batch',''),('lbl_Batch_Status','EN','Batch Status',''),('lbl_Batch_Status','HU','Batch állapot',''),('lbl_Batch_Status','IT','Batch di stato',''),('lbl_Batch_Status','NL','Batch Status',''),('lbl_Comment','EN','Comment','0'),('lbl_Comment','HU','Comment','0'),('lbl_Comment','IT','Commento','0'),('lbl_Comment','NL','Comment','0'),('lbl_Confirmed','EN','Confirmed',''),('lbl_Confirmed','HU','Megerosítve',''),('lbl_Confirmed','IT','Confermato',''),('lbl_Confirmed','NL','Bevestigd',''),('lbl_Created','EN','Created','0'),('lbl_Created','HU','Created','0'),('lbl_Created','IT','Creato','0'),('lbl_Created','NL','Created','0'),('lbl_Created_By','EN','Date Created','Q'),('lbl_Created_By','HU','Létrehozta','Q'),('lbl_Created_By','IT','Creato da','Q'),('lbl_Created_By','NL','Gemaakt door','Q'),('lbl_Customer_Admin','EN','Customer Admin',''),('lbl_Customer_Admin','HU','Customer Admin',''),('lbl_Customer_Admin','IT','Gestione Cliente',''),('lbl_Customer_Admin','NL','Customer Admin',''),('lbl_Customer_Edit','EN','Edit Customer',''),('lbl_Customer_Edit','HU','Ügyfél szerkesztése',''),('lbl_Customer_Edit','IT','Modifica del cliente',''),('lbl_Customer_Edit','NL','Klant bewerken',''),('lbl_Customer_ID','EN','Customer ID',''),('lbl_Customer_ID','HU','Customer ID',''),('lbl_Customer_ID','IT','ID Cliente',''),('lbl_Customer_ID','NL','Customer ID',''),('lbl_Customer_Name','EN','Customer Name',''),('lbl_Customer_Name','HU','Customer Name',''),('lbl_Customer_Name','IT','Nome Cliente',''),('lbl_Customer_Name','NL','Customer Name',''),('lbl_DataType','EN','Data Type','P'),('lbl_DataType','HU','Data Type','P'),('lbl_DataType','IT','Data Type','P'),('lbl_DataType','NL','Data Type','P'),('lbl_Date_Created','EN','Created By','Q'),('lbl_Date_Created','HU','Létrehozás dátuma','Q'),('lbl_Date_Created','IT','Data di creazione','Q'),('lbl_Date_Created','NL','Aanmaakdatum','Q'),('lbl_Date_Updated','EN','Date Updated','Q'),('lbl_Date_Updated','HU','Frissítés dátuma','Q'),('lbl_Date_Updated','IT','Data aggiornamento','Q'),('lbl_Date_Updated','NL','Datum bijgewerkt','Q'),('lbl_Decision','EN','Decision','0'),('lbl_Decision','HU','Decision','0'),('lbl_Decision','IT','Decisione','0'),('lbl_Decision','NL','Decision','0'),('lbl_Deleted','EN','Deleted','Q'),('lbl_Deleted','HU','Törölt','Q'),('lbl_Deleted','IT','Soppresso','Q'),('lbl_Deleted','NL','Verwijderde','Q'),('lbl_Description','EN','Description',''),('lbl_Description','HU','Leírás',''),('lbl_Description','IT','Descrizione',''),('lbl_Description','NL','Beschrijving',''),('lbl_Despatches','EN','Depatches',''),('lbl_Despatches','HU','Depatchek',''),('lbl_Despatches','IT','Spedizioni',''),('lbl_Despatches','NL','Depatches',''),('lbl_Despatch_Date','EN','Despatch Date',''),('lbl_Despatch_Date','HU','Despatch Dátum',''),('lbl_Despatch_Date','IT','Data Spedizione',''),('lbl_Despatch_Date','NL','Despatch Date',''),('lbl_Despatch_No','EN','Despatch No',''),('lbl_Despatch_No','HU','Despatch Szám',''),('lbl_Despatch_No','IT','Numero Spedizione',''),('lbl_Despatch_No','NL','Despatch nr.',''),('lbl_Despatch_Status','EN','Despatch Status',''),('lbl_Despatch_Status','HU','Despatch Státusz',''),('lbl_Despatch_Status','IT','Stato Spedizione',''),('lbl_Despatch_Status','NL','Despatch Status',''),('lbl_Destination_SSCC','EN','Destination SSCC','P'),('lbl_Destination_SSCC','HU','Célállomás SSCC','P'),('lbl_Destination_SSCC','IT','Destinazione SSCC','P'),('lbl_Destination_SSCC','NL','Bestemming SSCC','P'),('lbl_Email_Addresses','EN','Email Addresses',''),('lbl_Email_Addresses','HU','Email cím',''),('lbl_Email_Addresses','IT','Indirizzi Email',''),('lbl_Email_Addresses','NL','E-mailadressen',''),('lbl_Email_Error','EN','Error',''),('lbl_Email_Error','HU','Hiba',''),('lbl_Email_Error','IT','Errore',''),('lbl_Email_Error','NL','Fout',''),('lbl_Email_Notifications','EN','Email Notifications',''),('lbl_Email_Notifications','HU','Email notifikáció',''),('lbl_Email_Notifications','IT','Notifiche Email',''),('lbl_Email_Notifications','NL','E-mail notificaties',''),('lbl_Email_Success','EN','Success',''),('lbl_Email_Success','HU','Sikeres',''),('lbl_Email_Success','IT','Successo',''),('lbl_Email_Success','NL','Succes',''),('lbl_Email_Warning','EN','Warning',''),('lbl_Email_Warning','HU','Figyelmezetés',''),('lbl_Email_Warning','IT','Avviso',''),('lbl_Email_Warning','NL','Waarschuwing',''),('lbl_Expected','EN','Expected Resolution','0'),('lbl_Expected','HU','Expected Resolution','0'),('lbl_Expected','IT','Risoluzione Attesa','0'),('lbl_Expected','NL','Expected Resolution','0'),('lbl_Filter_By','EN','Filter By',''),('lbl_Filter_By','HU','Szurés -re',''),('lbl_Filter_By','IT','Filtra Per',''),('lbl_Filter_By','NL','Filter op',''),('lbl_Find','EN','Find',''),('lbl_Find','HU','Keres',''),('lbl_Find','IT','Trova',''),('lbl_Find','NL','Zoeken',''),('lbl_From_Location','EN','From Location',''),('lbl_From_Location','HU','Lokációról',''),('lbl_From_Location','IT','Da Location',''),('lbl_From_Location','NL','Van locatie',''),('lbl_Group_ID','EN','Group ID',''),('lbl_Group_ID','HU','Csoport ID',''),('lbl_Group_ID','IT','ID Gruppo',''),('lbl_Group_ID','NL','Groeps-ID',''),('lbl_Haulier','EN','Haulier',''),('lbl_Haulier','HU','Szállító',''),('lbl_Haulier','IT','Trasportatore',''),('lbl_Haulier','NL','Verhuizer',''),('lbl_Initiator','EN','Initiator','0'),('lbl_Initiator','HU','Initiator','0'),('lbl_Initiator','IT','Initiator','0'),('lbl_Initiator','NL','Initiator','0'),('lbl_Inspection','EN','Inspection','Q'),('lbl_Inspection','HU','Inspection','Q'),('lbl_Inspection','IT','Inspection','Q'),('lbl_Inspection','NL','Inspection','Q'),('lbl_Inspection_ID','EN','Inspection ID',''),('lbl_Inspection_ID','HU','Ellen?rzés ID',''),('lbl_Inspection_ID','IT','Ispezione ID',''),('lbl_Inspection_ID','NL','Inspectie ID',''),('lbl_Interface_Device','EN','Device',''),('lbl_Interface_Device','HU','Eszköz',''),('lbl_Interface_Device','IT','Dispositivo',''),('lbl_Interface_Device','NL','Apparaat',''),('lbl_Interface_Direction','EN','Interface Direction',''),('lbl_Interface_Direction','HU','Interfész irány',''),('lbl_Interface_Direction','IT','Direzione Interfaccia',''),('lbl_Interface_Direction','NL','Interface Richting',''),('lbl_Interface_Enabled','EN','Enabled',''),('lbl_Interface_Enabled','HU','Engedélyezve',''),('lbl_Interface_Enabled','IT','Abilitato',''),('lbl_Interface_Enabled','NL','Ingeschakeld',''),('lbl_Interface_Filename','EN','Filename',''),('lbl_Interface_Filename','HU','Fájlnév',''),('lbl_Interface_Filename','IT','Nome File',''),('lbl_Interface_Filename','NL','Bestandsnaam',''),('lbl_Interface_Format','EN','Format',''),('lbl_Interface_Format','HU','Formázás',''),('lbl_Interface_Format','IT','Formato',''),('lbl_Interface_Format','NL','Formaat',''),('lbl_Interface_Path','EN','Path',''),('lbl_Interface_Path','HU','Útvonal',''),('lbl_Interface_Path','IT','Percorso',''),('lbl_Interface_Path','NL','Pad',''),('lbl_Interface_Type','EN','Interface Type',''),('lbl_Interface_Type','HU','Interface Típus',''),('lbl_Interface_Type','IT','Tipo Interfaccia',''),('lbl_Interface_Type','NL','Interfacetype',''),('lbl_Labels_Per_SSCC','EN','Labels per SSCC',''),('lbl_Labels_Per_SSCC','HU','SSCC Címkénként',''),('lbl_Labels_Per_SSCC','IT','Etichette per SSCC',''),('lbl_Labels_Per_SSCC','NL','Labels per SSCC',''),('lbl_Label_Header_Text','EN','Label Header Text',''),('lbl_Label_Header_Text','HU','Címke Focím Szöveg',''),('lbl_Label_Header_Text','IT','Intestazione Etichetta',''),('lbl_Label_Header_Text','NL','Label Header Text',''),('lbl_Language','EN','Language',''),('lbl_Language','HU','Nyelv',''),('lbl_Language','IT','Lingua',''),('lbl_Language','NL','Taal',''),('lbl_Language_ID','EN','Language ID',''),('lbl_Language_ID','HU','Nyelv ID',''),('lbl_Language_ID','IT','ID Lingua',''),('lbl_Language_ID','NL','Language ID',''),('lbl_Language_Key','EN','Resource Key',''),('lbl_Language_Key','HU','Forrás kulcs',''),('lbl_Language_Key','IT','Chiave Risorsa',''),('lbl_Language_Key','NL','Resource Key',''),('lbl_Language_Mnemonic','EN','Mnemonic',''),('lbl_Language_Mnemonic','HU','Emlékezteto',''),('lbl_Language_Mnemonic','IT','Mnemonico',''),('lbl_Language_Mnemonic','NL','Mnemonic',''),('lbl_Limit','EN','Limit',''),('lbl_Limit','HU','Határ',''),('lbl_Limit','IT','Limite',''),('lbl_Limit','NL','Limiet',''),('lbl_List_ID','EN','List ID','Q'),('lbl_List_ID','HU','List ID','Q'),('lbl_List_ID','IT','List ID','Q'),('lbl_List_ID','NL','List ID','Q'),('lbl_Load_No','EN','Load No',''),('lbl_Load_No','HU','Rakodási Szám',''),('lbl_Load_No','IT','Numero Carico',''),('lbl_Load_No','NL','Load nr.',''),('lbl_Location_ID','EN','Location ID',''),('lbl_Location_ID','HU','Rakodási ID',''),('lbl_Location_ID','IT','ID Location',''),('lbl_Location_ID','NL','Locatie ID',''),('lbl_Material','EN','Material',''),('lbl_Material','HU','Anyag',''),('lbl_Material','IT','Materiale',''),('lbl_Material','NL','Materiaal',''),('lbl_Material_Base_UOM','EN','Base UOM',''),('lbl_Material_Base_UOM','HU','Alap UOM',''),('lbl_Material_Base_UOM','IT','UdM Base',''),('lbl_Material_Base_UOM','NL','Base UOM',''),('lbl_Material_Batch','EN','Batch',''),('lbl_Material_Batch','HU','Batch',''),('lbl_Material_Batch','IT','Batch',''),('lbl_Material_Batch','NL','Batch',''),('lbl_Material_Batch_Expiry_Date','EN','Expiry Date',''),('lbl_Material_Batch_Expiry_Date','HU','Lejárati ido',''),('lbl_Material_Batch_Expiry_Date','IT','Data Scadenza',''),('lbl_Material_Batch_Expiry_Date','NL','Houdbaar tot',''),('lbl_Material_Batch_Expiry_From','EN','Expiry From',''),('lbl_Material_Batch_Expiry_From','HU','Lejáratiido -tol',''),('lbl_Material_Batch_Expiry_From','IT','Da Scadenza',''),('lbl_Material_Batch_Expiry_From','NL','Houdbaar van',''),('lbl_Material_Batch_Expiry_To','EN','Expiry To',''),('lbl_Material_Batch_Expiry_To','HU','Lejárati ido -ig',''),('lbl_Material_Batch_Expiry_To','IT','A Scadenza',''),('lbl_Material_Batch_Expiry_To','NL','Houdbaar tot',''),('lbl_Material_Batch_Status','EN','Status',''),('lbl_Material_Batch_Status','HU','Státusz',''),('lbl_Material_Batch_Status','IT','Stato',''),('lbl_Material_Batch_Status','NL','Status',''),('lbl_Material_Default_Batch_Status','EN','Default Batch Status',''),('lbl_Material_Default_Batch_Status','HU','Alapértelmezett batch státusz',''),('lbl_Material_Default_Batch_Status','IT','Stato Batch Default',''),('lbl_Material_Default_Batch_Status','NL','Standaard Batch status',''),('lbl_Material_Equipment_Type','EN','Equipment Type',''),('lbl_Material_Equipment_Type','HU','Eszköz típus',''),('lbl_Material_Equipment_Type','IT','Tipo Richiesta',''),('lbl_Material_Equipment_Type','NL','Equipment Type',''),('lbl_Material_Gross_Weight','EN','Gross Weight',''),('lbl_Material_Gross_Weight','HU','Bruttó tömeg',''),('lbl_Material_Gross_Weight','IT','Peso Lordo',''),('lbl_Material_Gross_Weight','NL','Brutogewicht',''),('lbl_Material_Legacy_Code','EN','Legacy Code',''),('lbl_Material_Legacy_Code','HU','Régi kód',''),('lbl_Material_Legacy_Code','IT','Codice Legacy',''),('lbl_Material_Legacy_Code','NL','Legacy Code',''),('lbl_Material_Location_Status','EN','Status',''),('lbl_Material_Location_Status','HU','Állapot',''),('lbl_Material_Location_Status','IT','Status',''),('lbl_Material_Location_Status','NL','Status',''),('lbl_Material_Net_Weight','EN','Net Weight',''),('lbl_Material_Net_Weight','HU','Nettó tömeg',''),('lbl_Material_Net_Weight','IT','Peso Netto',''),('lbl_Material_Net_Weight','NL','Nettogewicht',''),('lbl_Material_Shelf_Life','EN','Shelf Life',''),('lbl_Material_Shelf_Life','HU','Lejárati ido hosz ',''),('lbl_Material_Shelf_Life','IT','Durata',''),('lbl_Material_Shelf_Life','NL','Houdbaarheid',''),('lbl_Material_Shelf_Life_Rounding_Rule','EN','Rounding Rule',''),('lbl_Material_Shelf_Life_Rounding_Rule','HU','Lejárat kerekítési szabály',''),('lbl_Material_Shelf_Life_Rounding_Rule','IT','Regola Arrotondamento',''),('lbl_Material_Shelf_Life_Rounding_Rule','NL','Afronding artikel',''),('lbl_Material_Shelf_Life_UOM','EN','Shelf Life UOM',''),('lbl_Material_Shelf_Life_UOM','HU','Lejárat UOM',''),('lbl_Material_Shelf_Life_UOM','IT','UdM Durata',''),('lbl_Material_Shelf_Life_UOM','NL','Houdbaarheid UOM',''),('lbl_Material_Type','EN','Material Type',''),('lbl_Material_Type','HU','Anyag típus ',''),('lbl_Material_Type','IT','Tipo Materiale',''),('lbl_Material_Type','NL','Produkt type',''),('lbl_Material_UOM','EN','UOM',''),('lbl_Material_UOM','HU','UOM',''),('lbl_Material_UOM','IT','UdM',''),('lbl_Material_UOM','NL','UOM',''),('lbl_Material_UOM_Denominator','EN','Denominator',''),('lbl_Material_UOM_Denominator','HU','Névadó',''),('lbl_Material_UOM_Denominator','IT','Denominatore',''),('lbl_Material_UOM_Denominator','NL','Noemer',''),('lbl_Material_UOM_EAN','EN','EAN',''),('lbl_Material_UOM_EAN','HU','EAN',''),('lbl_Material_UOM_EAN','IT','EAN',''),('lbl_Material_UOM_EAN','NL','EAN',''),('lbl_Material_UOM_Numerator','EN','Numerator',''),('lbl_Material_UOM_Numerator','HU','Számláló',''),('lbl_Material_UOM_Numerator','IT','Numeratore',''),('lbl_Material_UOM_Numerator','NL','Teller',''),('lbl_Material_UOM_Variant','EN','Variant',''),('lbl_Material_UOM_Variant','HU','Variáns',''),('lbl_Material_UOM_Variant','IT','Variante',''),('lbl_Material_UOM_Variant','NL','Variant',''),('lbl_Material_Weight_UOM','EN','Weight UOM',''),('lbl_Material_Weight_UOM','HU','UOM tömeg',''),('lbl_Material_Weight_UOM','IT','UdM Peso',''),('lbl_Material_Weight_UOM','NL','Gewicht UOM',''),('lbl_Message_Date','EN','Message Date',''),('lbl_Message_Date','HU','Üzenet dátum',''),('lbl_Message_Date','IT','Data Messaggio',''),('lbl_Message_Date','NL','Message date',''),('lbl_Message_Despatch_Confirm','EN','Msg Despatch Confirm',''),('lbl_Message_Despatch_Confirm','HU','Despatch Üzenet Megerosítés',''),('lbl_Message_Despatch_Confirm','IT','Msg Despatch Confirm',''),('lbl_Message_Despatch_Confirm','NL','Msg Despatch Confirm',''),('lbl_Message_Despatch_Pre_Advice','EN','Msg Despatch Pre Advice',''),('lbl_Message_Despatch_Pre_Advice','HU','Despatch Üzenet elo-jelzés',''),('lbl_Message_Despatch_Pre_Advice','IT','Msg Despatch Pre Advice',''),('lbl_Message_Despatch_Pre_Advice','NL','Pre Msg Despatch Advice',''),('lbl_Message_Equipment_Tracking','EN','Msg Equipment Tracking',''),('lbl_Message_Equipment_Tracking','HU','Eszköz üzenet keresés',''),('lbl_Message_Equipment_Tracking','IT','Msg Equipment Tracking',''),('lbl_Message_Equipment_Tracking','NL','Msg Equipment Tracking',''),('lbl_Message_Error','EN','Result',''),('lbl_Message_Error','HU','Eredmény',''),('lbl_Message_Error','IT','Risultato',''),('lbl_Message_Error','NL','Resultaat',''),('lbl_Message_Event_Date','EN','Event Date',''),('lbl_Message_Event_Date','HU','Esemény Dátum',''),('lbl_Message_Event_Date','IT','Data Evento',''),('lbl_Message_Event_Date','NL','Event Date',''),('lbl_Message_Information','EN','Message Information',''),('lbl_Message_Information','HU','Info Üzenet',''),('lbl_Message_Information','IT','Informazioni Messaggio',''),('lbl_Message_Information','NL','Bericht Informatie',''),('lbl_Message_Production_Confirmation','EN','Msg Production Confirm',''),('lbl_Message_Production_Confirmation','HU','Üzenet Elkészítés Megerosítése',''),('lbl_Message_Production_Confirmation','IT','Msg Production Confirm',''),('lbl_Message_Production_Confirmation','NL','Msg Productie Bevestig',''),('lbl_Message_Reference','EN','Message Reference',''),('lbl_Message_Reference','HU','Üzenet Referencia',''),('lbl_Message_Reference','IT','Riferimento Messaggio',''),('lbl_Message_Reference','NL','Berichtreferentie',''),('lbl_Message_Status','EN','Message Status',''),('lbl_Message_Status','HU','Üzenet Státusz',''),('lbl_Message_Status','IT','Stato Messaggio',''),('lbl_Message_Status','NL','Bericht Status',''),('lbl_Message_Type','EN','Message Type',''),('lbl_Message_Type','HU','Üzenet Típus',''),('lbl_Message_Type','IT','Tipo Messaggio',''),('lbl_Message_Type','NL','Berichttype',''),('lbl_MHN_Number','EN','MHN Number','0'),('lbl_MHN_Number','HU','MHN Number','0'),('lbl_MHN_Number','IT','Numero MHN','0'),('lbl_MHN_Number','NL','MHN Number','0'),('lbl_Mnemonic','EN','Mnemonic',''),('lbl_Mnemonic','HU','Emlékezteto',''),('lbl_Mnemonic','IT','Mnemonico',''),('lbl_Mnemonic','NL','Mnemonic',''),('lbl_Module_ALL','EN','All',''),('lbl_Module_ALL','HU','Minden',''),('lbl_Module_ALL','IT','Tutto',''),('lbl_Module_ALL','NL','Alle',''),('lbl_Module_Desktop','EN','Desktop',''),('lbl_Module_Desktop','HU','Képernyo',''),('lbl_Module_Desktop','IT','Desktop',''),('lbl_Module_Desktop','NL','Desktop',''),('lbl_Module_Executable','EN','Executables',''),('lbl_Module_Executable','HU','Futtatások',''),('lbl_Module_Executable','IT','Eseguibili',''),('lbl_Module_Executable','NL','Executable',''),('lbl_Module_Executable_Directory','EN','Executable Directory',''),('lbl_Module_Executable_Directory','HU','Futtató Könyvtár',''),('lbl_Module_Executable_Directory','IT','Directory Eseguibili',''),('lbl_Module_Executable_Directory','NL','Executable Directory',''),('lbl_Module_Executable_Filename','EN','Executable Filename',''),('lbl_Module_Executable_Filename','HU','Futtató Fáljnév',''),('lbl_Module_Executable_Filename','IT','Nome Eseguibile',''),('lbl_Module_Executable_Filename','NL','Executable Bestandsnaam',''),('lbl_Module_Form','EN','Forms',''),('lbl_Module_Form','HU','Formok',''),('lbl_Module_Form','IT','Moduli',''),('lbl_Module_Form','NL','Formulieren',''),('lbl_Module_Function','EN','Functions',''),('lbl_Module_Function','HU','Funkciók',''),('lbl_Module_Function','IT','Funzioni',''),('lbl_Module_Function','NL','Functies',''),('lbl_Module_Help','EN','Help',''),('lbl_Module_Help','HU','Segítség',''),('lbl_Module_Help','IT','Aiuto',''),('lbl_Module_Help','NL','Help',''),('lbl_Module_Icon_Filename','EN','Icon Filename',''),('lbl_Module_Icon_Filename','HU','Ikon Fáljnév',''),('lbl_Module_Icon_Filename','IT','Nome File Icona',''),('lbl_Module_Icon_Filename','NL','Icon Bestandsnaam',''),('lbl_Module_ID','EN','Module ID',''),('lbl_Module_ID','HU','Modul ID',''),('lbl_Module_ID','IT','ID Modulo',''),('lbl_Module_ID','NL','Module ID',''),('lbl_Module_Menu','EN','Menus',''),('lbl_Module_Menu','HU','Menük',''),('lbl_Module_Menu','IT','Menu',''),('lbl_Module_Menu','NL','Menu',''),('lbl_Module_Print_Copies','EN','Print Copies',''),('lbl_Module_Print_Copies','HU','Nyomtatás',''),('lbl_Module_Print_Copies','IT','Stampa Copie',''),('lbl_Module_Print_Copies','NL','Print Exemplaren',''),('lbl_Module_Print_Dialog','EN','Print Dialog',''),('lbl_Module_Print_Dialog','HU','Nyomató Kiválasztás',''),('lbl_Module_Print_Dialog','IT','Dialog di Stampa',''),('lbl_Module_Print_Dialog','NL','Print Dialog',''),('lbl_Module_Print_Preview','EN','Print Preview',''),('lbl_Module_Print_Preview','HU','Nyomtató Elonézet',''),('lbl_Module_Print_Preview','IT','Anteprima di Stampa',''),('lbl_Module_Print_Preview','NL','Afdrukvoorbeeld',''),('lbl_Module_Report','EN','Reports',''),('lbl_Module_Report','HU','Riportok',''),('lbl_Module_Report','IT','Reports',''),('lbl_Module_Report','NL','Rapporten',''),('lbl_Module_Report_Filename','EN','Report Filename',''),('lbl_Module_Report_Filename','HU','Riport Fáljnév',''),('lbl_Module_Report_Filename','IT','Nome File Report',''),('lbl_Module_Report_Filename','NL','Rapport bestandsnaam',''),('lbl_Module_Report_Type','EN','Report Type',''),('lbl_Module_Report_Type','HU','Riport típus',''),('lbl_Module_Report_Type','IT','Tipo Report',''),('lbl_Module_Report_Type','NL','Rapport type',''),('lbl_Module_Scanner','EN','Scanner',''),('lbl_Module_Scanner','HU','Scanner',''),('lbl_Module_Scanner','IT','Scanner',''),('lbl_Module_Scanner','NL','Scanner',''),('lbl_Module_Type','EN','Module Type',''),('lbl_Module_Type','HU','Modul típus',''),('lbl_Module_Type','IT','Tipo Modulo',''),('lbl_Module_Type','NL','Module Type',''),('lbl_No_Of_Labels','EN','Number of Labels',''),('lbl_No_Of_Labels','IT','Numero Etichette',''),('lbl_No_Of_Labels','NL','Number of Labels',''),('lbl_No_Of_Pallets','EN','No Of Pallets',''),('lbl_No_Of_Pallets','HU','Palletták száma',''),('lbl_No_Of_Pallets','IT','Numero Pallets',''),('lbl_No_Of_Pallets','NL','Aantal pallets',''),('lbl_Number_Of_Labels','EN','Number of Labels',''),('lbl_Number_Of_Labels','HU','Címkék darabszáma',''),('lbl_Number_Of_Labels','IT','Numero Etichette',''),('lbl_Number_Of_Labels','NL','Number of Labels',''),('lbl_Number_of_SSCCs','EN','Number of SSCCs',''),('lbl_Number_of_SSCCs','HU','SSCC széma',''),('lbl_Number_of_SSCCs','IT','Numero di SSCC',''),('lbl_Number_of_SSCCs','NL','Aantal SSCCs',''),('lbl_Options','EN','Options',''),('lbl_Options','HU','Opciók',''),('lbl_Options','IT','Opzioni',''),('lbl_Options','NL','Opties',''),('lbl_Pallet','EN','Pallet',''),('lbl_Pallet','HU','Palletták',''),('lbl_Pallet','IT','Pallet',''),('lbl_Pallet','NL','Pallet',''),('lbl_Pallet_Base_Quantity','EN','Base Quantity',''),('lbl_Pallet_Base_Quantity','HU','Alap Mennyiség',''),('lbl_Pallet_Base_Quantity','IT','Quantità Base',''),('lbl_Pallet_Base_Quantity','NL','Basishoeveelheid',''),('lbl_Pallet_Base_UOM','EN','Base UOM',''),('lbl_Pallet_Base_UOM','HU','Alap UOM',''),('lbl_Pallet_Base_UOM','IT','UdM Base',''),('lbl_Pallet_Base_UOM','NL','Base UOM',''),('lbl_Pallet_DOM','EN','Date of Manufacture',''),('lbl_Pallet_DOM','HU','Gyártás napja',''),('lbl_Pallet_DOM','IT','Data di Produzione',''),('lbl_Pallet_DOM','NL','Produktiedatum',''),('lbl_Pallet_Layers','EN','Layers',''),('lbl_Pallet_Layers','HU','Rétegek',''),('lbl_Pallet_Layers','IT','Strati',''),('lbl_Pallet_Layers','NL','Lagen',''),('lbl_Pallet_Quantity','EN','Quantity',''),('lbl_Pallet_Quantity','HU','Mennyiség',''),('lbl_Pallet_Quantity','IT','Quantità',''),('lbl_Pallet_Quantity','NL','Aantal',''),('lbl_Pallet_SSCC','EN','SSCC',''),('lbl_Pallet_SSCC','HU','SSCC',''),('lbl_Pallet_SSCC','IT','SSCC',''),('lbl_Pallet_SSCC','NL','SSCC',''),('lbl_Pallet_Status','EN','Pallet Status',''),('lbl_Pallet_Status','HU','Palleta ',''),('lbl_Pallet_Status','IT','Stato Pallet',''),('lbl_Pallet_Status','NL','Pallet Status',''),('lbl_Pallet_UOM','EN','UOM',''),('lbl_Pallet_UOM','HU','UOM',''),('lbl_Pallet_UOM','IT','UdM',''),('lbl_Pallet_UOM','NL','UOM',''),('lbl_Preview','EN','Preview',''),('lbl_Preview','HU','Elonézet',''),('lbl_Preview','IT','Anteprima',''),('lbl_Preview','NL','Voorbeeld',''),('lbl_Print','EN','Print',''),('lbl_Print','HU','Nyomtat',''),('lbl_Print','IT','Stampa',''),('lbl_Print','NL','Afdrukken',''),('lbl_Print_Customer_on_Label','EN','Print Name on Label',''),('lbl_Print_Customer_on_Label','HU','Print Name on Label',''),('lbl_Print_Customer_on_Label','IT','Stampa Nome su Etichetta',''),('lbl_Print_Customer_on_Label','NL','Print Name on Label',''),('lbl_Print_Queue','EN','Print Queue',''),('lbl_Print_Queue','HU','Nyomtatási sor',''),('lbl_Print_Queue','IT','Coda di Stampa',''),('lbl_Print_Queue','NL','Afdrukwachtrij',''),('lbl_Process_Order','EN','Process Order',''),('lbl_Process_Order','HU','PO',''),('lbl_Process_Order','IT','Process Order',''),('lbl_Process_Order','NL','Process Order',''),('lbl_Process_Order_Default_Pallet_Status','EN','Default Pallet Status',''),('lbl_Process_Order_Default_Pallet_Status','HU','Alap Printer Státusza',''),('lbl_Process_Order_Default_Pallet_Status','IT','Stato Pallet di Default',''),('lbl_Process_Order_Default_Pallet_Status','NL','Standaard Pallet Status',''),('lbl_Process_Order_Due_Date','EN','Due Date',''),('lbl_Process_Order_Due_Date','HU','Lejárati ido',''),('lbl_Process_Order_Due_Date','IT','Data Prevista',''),('lbl_Process_Order_Due_Date','NL','Einddatum',''),('lbl_Process_Order_Recipe','EN','Recipe',''),('lbl_Process_Order_Recipe','HU','Recept',''),('lbl_Process_Order_Recipe','IT','Recipe',''),('lbl_Process_Order_Recipe','NL','Recept',''),('lbl_Process_Order_Required_Quantity','EN','Quantity',''),('lbl_Process_Order_Required_Quantity','HU','Mennyiség',''),('lbl_Process_Order_Required_Quantity','IT','Quantità',''),('lbl_Process_Order_Required_Quantity','NL','Aantal',''),('lbl_Process_Order_Required_Resource','EN','Required Resource',''),('lbl_Process_Order_Required_Resource','HU','Szükséges Eroforrás',''),('lbl_Process_Order_Required_Resource','IT','Risorsa Richiesta',''),('lbl_Process_Order_Required_Resource','NL','Required Resource',''),('lbl_Process_Order_Required_UOM','EN','UOM',''),('lbl_Process_Order_Required_UOM','HU','UOM',''),('lbl_Process_Order_Required_UOM','IT','UdM',''),('lbl_Process_Order_Required_UOM','NL','UOM',''),('lbl_Process_Order_Status','EN','Status',''),('lbl_Process_Order_Status','HU','Státusz',''),('lbl_Process_Order_Status','IT','Stato',''),('lbl_Process_Order_Status','NL','Status',''),('lbl_Reason','EN','Reason Code','0'),('lbl_Reason','HU','Reason Code','0'),('lbl_Reason','IT','Reason Code','0'),('lbl_Reason','NL','Reason Code','0'),('lbl_Recorder','EN','Recorder','0'),('lbl_Recorder','HU','Recorder','0'),('lbl_Recorder','IT','Recorder','0'),('lbl_Recorder','NL','Recorder','0'),('lbl_Referenced_Data','EN','Referenced Data',''),('lbl_Referenced_Data','HU','Referencia Adat',''),('lbl_Referenced_Data','IT','Dati di Riferimento',''),('lbl_Referenced_Data','NL','Referenced Data',''),('lbl_Required_Quantity','EN','Required Quantity','P'),('lbl_Required_Quantity','HU','Szükséges mennyiség','P'),('lbl_Required_Quantity','IT','Quantità richiesta','P'),('lbl_Required_Quantity','NL','Gewenst aantal','P'),('lbl_Resolved','EN','Resolved','0'),('lbl_Resolved','HU','Resolved','0'),('lbl_Resolved','IT','Risolto','0'),('lbl_Resolved','NL','Resolved','0'),('lbl_Resource_Key','EN','Resource Key',''),('lbl_Resource_Key','HU','Forrás kulcs',''),('lbl_Resource_Key','IT','Chiave Risorsa',''),('lbl_Resource_Key','NL','Resource Key',''),('lbl_SampleID','EN','Sample ID','P'),('lbl_SampleID','HU','Minta Azonosító','P'),('lbl_SampleID','IT','ID Campione','P'),('lbl_SampleID','NL','Voorbeeld ID','P'),('lbl_Sample_Date','EN','Sample Date',''),('lbl_Sample_Date','HU','Minta dátum',''),('lbl_Sample_Date','IT','Campione Date',''),('lbl_Sample_Date','NL','Voorbeeld datum',''),('lbl_Sample_ID','EN','Sample ID',''),('lbl_Sample_ID','HU','Minta ID',''),('lbl_Sample_ID','IT','Campione ID',''),('lbl_Sample_ID','NL','Voorbeeld ID',''),('lbl_Sequence_ID','EN','Sequence','Q'),('lbl_Sequence_ID','HU','Sequence','Q'),('lbl_Sequence_ID','IT','Sequence','Q'),('lbl_Sequence_ID','NL','Sequence','Q'),('lbl_Sort_By','EN','Sort By',''),('lbl_Sort_By','HU','Szurve',''),('lbl_Sort_By','IT','Ordina Per',''),('lbl_Sort_By','NL','Sorteren op',''),('lbl_Source_SSCC','EN','Source SSCC','P'),('lbl_Source_SSCC','HU','Forrás SSCC','P'),('lbl_Source_SSCC','IT','Fonte SSCC','P'),('lbl_Source_SSCC','NL','Bron SSCC','P'),('lbl_Status','EN','MHN Status','0'),('lbl_Status','HU','MHN Status','0'),('lbl_Status','IT','Stato MHN','0'),('lbl_Status','NL','MHN Status','0'),('lbl_Storage_Bin','EN','Bin',''),('lbl_Storage_Bin','HU','Bin',''),('lbl_Storage_Bin','IT','Bin',''),('lbl_Storage_Bin','NL','Bin',''),('lbl_Storage_Equipment_Tracking_ID','EN','Equipment Tracking ID',''),('lbl_Storage_Equipment_Tracking_ID','HU','Eszköz kereso ID',''),('lbl_Storage_Equipment_Tracking_ID','IT','Equipment Tracking ID',''),('lbl_Storage_Equipment_Tracking_ID','NL','Equipment Tracking ID',''),('lbl_Storage_GLN','EN','GLN',''),('lbl_Storage_GLN','HU','GLN',''),('lbl_Storage_GLN','IT','GLN',''),('lbl_Storage_GLN','NL','GLN',''),('lbl_Storage_Location','EN','Location',''),('lbl_Storage_Location','HU','Lokáció',''),('lbl_Storage_Location','IT','Location',''),('lbl_Storage_Location','NL','Locatie',''),('lbl_Storage_Location_Permit_Batch_Status','EN','Permit Batch Status',''),('lbl_Storage_Location_Permit_Batch_Status','HU','Batch Státusz Engedélyezés',''),('lbl_Storage_Location_Permit_Batch_Status','IT','Permetti Stato Batch',''),('lbl_Storage_Location_Permit_Batch_Status','NL','Permit Batch status',''),('lbl_Storage_Location_Permit_Pallet_Status','EN','Permit Pallet Status',''),('lbl_Storage_Location_Permit_Pallet_Status','HU','Pallet Státusz Engedélyezés',''),('lbl_Storage_Location_Permit_Pallet_Status','IT','Permetti Stato Pallet',''),('lbl_Storage_Location_Permit_Pallet_Status','NL','Permit Pallet Status',''),('lbl_Storage_Plant','EN','Plant',''),('lbl_Storage_Plant','HU','Gyártás napja',''),('lbl_Storage_Plant','IT','Plant',''),('lbl_Storage_Plant','NL','Plant',''),('lbl_Storage_Section','EN','Section',''),('lbl_Storage_Section','HU','Részleg',''),('lbl_Storage_Section','IT','Sezione',''),('lbl_Storage_Section','NL','Afdeling',''),('lbl_Storage_Type','EN','Type',''),('lbl_Storage_Type','HU','Típus',''),('lbl_Storage_Type','IT','Tipo',''),('lbl_Storage_Type','NL','Type',''),('lbl_Storage_Warehouse','EN','Warehouse',''),('lbl_Storage_Warehouse','HU','Raktár',''),('lbl_Storage_Warehouse','IT','Magazzino',''),('lbl_Storage_Warehouse','NL','Warehouse',''),('lbl_Test','EN','Test','P'),('lbl_Test','HU','Test','P'),('lbl_Test','IT','Test','P'),('lbl_Test','NL','Test','P'),('lbl_Test_ID','EN','Test ID',''),('lbl_Test_ID','HU','Teszt ID',''),('lbl_Test_ID','IT','Prova ID',''),('lbl_Test_ID','NL','Test ID',''),('lbl_Text','EN','Text',''),('lbl_Text','HU','Szöveg',''),('lbl_Text','IT','Testo',''),('lbl_Text','NL','Text',''),('lbl_To_Location','EN','To Location',''),('lbl_To_Location','HU','Lokáció',''),('lbl_To_Location','IT','A Locazione',''),('lbl_To_Location','NL','Naar locatie',''),('lbl_Trailer','EN','Trailer',''),('lbl_Trailer','HU','Vontató',''),('lbl_Trailer','IT','Rimorchio',''),('lbl_Trailer','NL','Trailer',''),('lbl_Transaction_Date','EN','Transaction Date',''),('lbl_Transaction_Date','HU','Tranzakció dátuma',''),('lbl_Transaction_Date','IT','Data Transazione',''),('lbl_Transaction_Date','NL','Transactie Datum',''),('lbl_Transaction_Ref','EN','Transaction Ref',''),('lbl_Transaction_Ref','HU','Tranzakció referencia',''),('lbl_Transaction_Ref','IT','Rif. Transazione',''),('lbl_Transaction_Ref','NL','Transactie Ref',''),('lbl_Transaction_Subtype','EN','Transaction Subtype',''),('lbl_Transaction_Subtype','HU','Tranzakció altípusa',''),('lbl_Transaction_Subtype','IT','SottoTipo Transazione',''),('lbl_Transaction_Subtype','NL','Transactie subtype',''),('lbl_Transaction_Type','EN','Transaction Type',''),('lbl_Transaction_Type','HU','Tranzakció típusa',''),('lbl_Transaction_Type','IT','Tipo Transazione',''),('lbl_Transaction_Type','NL','Transactie type',''),('lbl_Unassigned','EN','Unassigned',''),('lbl_Unassigned','HU','Nincs hozzáfuzve',''),('lbl_Unassigned','IT','Non Assegnato',''),('lbl_Unassigned','NL','Niet toegewezen',''),('lbl_Unassigned_Filter','EN','Unassigned Filter',''),('lbl_Unassigned_Filter','HU','Nincs hozzáfuzve_Szuro',''),('lbl_Unassigned_Filter','IT','Filtro Non Assegnato',''),('lbl_Unassigned_Filter','NL','Niet toegewezen filter',''),('lbl_Unconfirmed','EN','Unconfirmed',''),('lbl_Unconfirmed','HU','Nincs Megerosítve',''),('lbl_Unconfirmed','IT','Non Confermato',''),('lbl_Unconfirmed','NL','Niet bevestigd',''),('lbl_UOM_Conversion','EN','UOM Conversion',''),('lbl_UOM_Conversion','HU','UOM Konverzió',''),('lbl_UOM_Conversion','IT','Conversioni UdM',''),('lbl_UOM_Conversion','NL','UOM Conversie',''),('lbl_UOM_Internal','EN','Internal UOM',''),('lbl_UOM_Internal','HU','Belso UOM',''),('lbl_UOM_Internal','IT','UdM Interna',''),('lbl_UOM_Internal','NL','Interne UOM',''),('lbl_UOM_ISO','EN','ISO UOM',''),('lbl_UOM_ISO','HU','ISO UOM',''),('lbl_UOM_ISO','IT','UdM ISO',''),('lbl_UOM_ISO','NL','ISO UOM',''),('lbl_UOM_Local','EN','Local UOM',''),('lbl_UOM_Local','HU','Helyi UOM',''),('lbl_UOM_Local','IT','UdM Locale',''),('lbl_UOM_Local','NL','Lokale UOM',''),('lbl_Updated_By','EN','Updated By','Q'),('lbl_Updated_By','HU','Módosította','Q'),('lbl_Updated_By','IT','Aggiornato da','Q'),('lbl_Updated_By','NL','bijgewerkt door','Q'),('lbl_User_Account','EN','Account',''),('lbl_User_Account','HU','Felhasználónév',''),('lbl_User_Account','IT','Account',''),('lbl_User_Account','NL','Account',''),('lbl_User_Account_Bad_Passwords','EN','Bad Passwords',''),('lbl_User_Account_Bad_Passwords','HU','Rossz Jelszó',''),('lbl_User_Account_Bad_Passwords','IT','Password Sbagliate',''),('lbl_User_Account_Bad_Passwords','NL','Slechte wachtwoorden',''),('lbl_User_Account_Email','EN','Email',''),('lbl_User_Account_Email','HU','Email',''),('lbl_User_Account_Email','IT','Email',''),('lbl_User_Account_Email','NL','E-mail',''),('lbl_User_Account_Expires','EN','Account Expires',''),('lbl_User_Account_Expires','HU','Account Lejár',''),('lbl_User_Account_Expires','IT','Account Scade',''),('lbl_User_Account_Expires','NL','Account verloopt',''),('lbl_User_Account_Expiry_Date','EN','Expiry Date',''),('lbl_User_Account_Expiry_Date','HU','Lejárati dátum',''),('lbl_User_Account_Expiry_Date','IT','Data Scadenza',''),('lbl_User_Account_Expiry_Date','NL','Houdbaar',''),('lbl_User_Account_Last_Logon','EN','Last Logon',''),('lbl_User_Account_Last_Logon','HU','Útolsó belépés',''),('lbl_User_Account_Last_Logon','IT','Ultimo Logon',''),('lbl_User_Account_Last_Logon','NL','Laatste Logon',''),('lbl_User_Account_Last_Password_Change','EN','Last Password Change',''),('lbl_User_Account_Last_Password_Change','HU','Útolsó Password csere',''),('lbl_User_Account_Last_Password_Change','IT','Ultimo Cambio Password',''),('lbl_User_Account_Last_Password_Change','NL','Laatste wachtwoord wijziging',''),('lbl_User_Account_Lock','EN','Lock',''),('lbl_User_Account_Lock','HU','Lezár',''),('lbl_User_Account_Lock','IT','Blocco',''),('lbl_User_Account_Lock','NL','Lock',''),('lbl_User_Account_Locked','EN','Locked',''),('lbl_User_Account_Locked','HU','Lezárva',''),('lbl_User_Account_Locked','IT','Bloccato',''),('lbl_User_Account_Locked','NL','Gesloten',''),('lbl_User_Account_Password','EN','Password',''),('lbl_User_Account_Password','HU','Jelszó',''),('lbl_User_Account_Password','IT','Password',''),('lbl_User_Account_Password','NL','Wachtwoord',''),('lbl_User_Account_Password_Change_Allowed','EN','Password Change Allowed',''),('lbl_User_Account_Password_Change_Allowed','HU','Jelszó csere engedélyezve',''),('lbl_User_Account_Password_Change_Allowed','IT','Modifica Password Consentita',''),('lbl_User_Account_Password_Change_Allowed','NL','Wachtwoord wijzigen toegestaan',''),('lbl_User_Account_Password_Expires','EN','Password Expires',''),('lbl_User_Account_Password_Expires','HU','Jelszó lejár',''),('lbl_User_Account_Password_Expires','IT','Password Scade',''),('lbl_User_Account_Password_Expires','NL','Wachtwoord verloopt',''),('lbl_User_Account_Password_Verify','EN','Verify',''),('lbl_User_Account_Password_Verify','HU','Ellenoríz',''),('lbl_User_Account_Password_Verify','IT','Verifica',''),('lbl_User_Account_Password_Verify','NL','Controleer',''),('lbl_User_Account_Unlock','EN','Unlock',''),('lbl_User_Account_Unlock','HU','Engedélyez',''),('lbl_User_Account_Unlock','IT','Sblocca',''),('lbl_User_Account_Unlock','NL','Unlock',''),('lbl_User_Data1','EN','User Data 1','Q'),('lbl_User_Data1','HU','Felhasználói adatok 1','Q'),('lbl_User_Data1','IT','Dati utente 1','Q'),('lbl_User_Data1','NL','Gebruikersgegevens 1','Q'),('lbl_User_Data2','EN','User Data 2','Q'),('lbl_User_Data2','HU','Felhasználói adatok 2','Q'),('lbl_User_Data2','IT','Dati utente 2','Q'),('lbl_User_Data2','NL','Gebruikersgegevens 2','Q'),('lbl_User_ID','EN','User ID',''),('lbl_User_ID','HU','Felhasználó ID',''),('lbl_User_ID','IT','User ID',''),('lbl_User_ID','NL','User ID',''),('lbl_Value','EN','Value','Q'),('lbl_Value','HU','Value','Q'),('lbl_Value','IT','Value','Q'),('lbl_Value','NL','Value','Q'),('lbl_Visible','EN','Visible','P'),('lbl_Visible','HU','Látható','P'),('lbl_Visible','IT','Visibile','P'),('lbl_Visible','NL','Zichtbaar','P'),('lbl_Workstation','EN','Workstation',''),('lbl_Workstation','HU','Munkaállomás',''),('lbl_Workstation','IT','Workstation',''),('lbl_Workstation','NL','Workstation',''),('mod_EXEC_CONFIG','EN','Host Configuration',''),('mod_EXEC_CONFIG','HU','Host Konfiguráció',''),('mod_EXEC_CONFIG','IT','Configurazione Host',''),('mod_EXEC_CONFIG','NL','Host Configuration',''),('mod_EXEC_IREPORT','EN','iReports',''),('mod_EXEC_IREPORT','HU','iRiportok',''),('mod_EXEC_IREPORT','IT','iReports',''),('mod_EXEC_IREPORT','NL','ireports',''),('mod_FRM_ADMIN_CONTROL_EDIT','EN','System Controls','C'),('mod_FRM_ADMIN_CONTROL_EDIT','HU','Rendszer Beállítások','R'),('mod_FRM_ADMIN_CONTROL_EDIT','IT','Controlli Sistema','C'),('mod_FRM_ADMIN_CONTROL_EDIT','NL','System Controls',''),('mod_FRM_ADMIN_DESPATCH','EN','Despatch Pallets','D'),('mod_FRM_ADMIN_DESPATCH','HU','Despatch Pallets','D'),('mod_FRM_ADMIN_DESPATCH','IT','Spedizione','D'),('mod_FRM_ADMIN_DESPATCH','NL','Despatch Pallets',''),('mod_FRM_ADMIN_GROUPS','EN','Groups','G'),('mod_FRM_ADMIN_GROUPS','HU','Csoportok','C'),('mod_FRM_ADMIN_GROUPS','IT','Gruppi','G'),('mod_FRM_ADMIN_GROUPS','NL','Groepen',''),('mod_FRM_ADMIN_GROUP_ADD','EN','Add a Group',''),('mod_FRM_ADMIN_GROUP_ADD','HU','Csoport hozzáadása',''),('mod_FRM_ADMIN_GROUP_ADD','IT','Aggiungi un Gruppo',''),('mod_FRM_ADMIN_GROUP_ADD','NL','Een groep toevoegen',''),('mod_FRM_ADMIN_GROUP_DELETE','EN','Delete a Group',''),('mod_FRM_ADMIN_GROUP_DELETE','HU','Csoport törlése',''),('mod_FRM_ADMIN_GROUP_DELETE','IT','Elimina un Gruppo',''),('mod_FRM_ADMIN_GROUP_DELETE','NL','Verwijderen van een groep',''),('mod_FRM_ADMIN_GROUP_EDIT','EN','Group Properties',''),('mod_FRM_ADMIN_GROUP_EDIT','HU','Csoport beállításai',''),('mod_FRM_ADMIN_GROUP_EDIT','IT','Proprietà Gruppo',''),('mod_FRM_ADMIN_GROUP_EDIT','NL','Groep eigenschappen',''),('mod_FRM_ADMIN_GROUP_PERM','EN','Group Permissions',''),('mod_FRM_ADMIN_GROUP_PERM','HU','Csoport engedélyei',''),('mod_FRM_ADMIN_GROUP_PERM','IT','Autorizzazioni Gruppo',''),('mod_FRM_ADMIN_GROUP_PERM','NL','Groepsrechten',''),('mod_FRM_ADMIN_GROUP_RENAME','EN','Rename a Group',''),('mod_FRM_ADMIN_GROUP_RENAME','HU','Csoport átnevezése',''),('mod_FRM_ADMIN_GROUP_RENAME','IT','Rinomina Gruppo',''),('mod_FRM_ADMIN_GROUP_RENAME','NL','Groep hernoemen',''),('mod_FRM_ADMIN_INTERFACE','EN','Interface Admin','I'),('mod_FRM_ADMIN_INTERFACE','HU','Interface Admin','I'),('mod_FRM_ADMIN_INTERFACE','IT','Amministrazione Interfaccia','I'),('mod_FRM_ADMIN_INTERFACE','NL','Interface Admin',''),('mod_FRM_ADMIN_INTERFACE_EDIT','EN','Edit Interface',''),('mod_FRM_ADMIN_INTERFACE_EDIT','HU','Interface szerkesztés',''),('mod_FRM_ADMIN_INTERFACE_EDIT','IT','Modifica Interfaccia',''),('mod_FRM_ADMIN_INTERFACE_EDIT','NL','Edit Interface',''),('mod_FRM_ADMIN_INTERFACE_LOG','EN','Interface Log',''),('mod_FRM_ADMIN_INTERFACE_LOG','HU','Interface Log',''),('mod_FRM_ADMIN_INTERFACE_LOG','IT','Log Interfaccia',''),('mod_FRM_ADMIN_INTERFACE_LOG','NL','Interface log',''),('mod_FRM_ADMIN_INTERFACE_PROCESS','EN','Process Interface Messages',''),('mod_FRM_ADMIN_INTERFACE_PROCESS','HU','Interface üzenet feldolgozása',''),('mod_FRM_ADMIN_INTERFACE_PROCESS','IT','Process Interface Messages',''),('mod_FRM_ADMIN_INTERFACE_PROCESS','NL','Verwerk inteface berichten',''),('mod_FRM_ADMIN_INTERFACE_REQUEST','EN','Interface Request Administration',''),('mod_FRM_ADMIN_INTERFACE_REQUEST','HU','Interface Kérés Adminisztrálása',''),('mod_FRM_ADMIN_INTERFACE_REQUEST','IT','Interface Request Administration',''),('mod_FRM_ADMIN_INTERFACE_REQUEST','NL','Aanvraag Administratie Interface',''),('mod_FRM_ADMIN_LANGUAGE','EN','Translations',''),('mod_FRM_ADMIN_LANGUAGE','HU','Fordítások','F'),('mod_FRM_ADMIN_LANGUAGE','IT','Traduzioni',''),('mod_FRM_ADMIN_LANGUAGE','NL','Translations',''),('mod_FRM_ADMIN_LOCATIONS','EN','Administer Locations','L'),('mod_FRM_ADMIN_LOCATIONS','HU','Lokáció Adminisztrációja','L'),('mod_FRM_ADMIN_LOCATIONS','IT','Gestione Location','L'),('mod_FRM_ADMIN_LOCATIONS','NL','Beheer locaties',''),('mod_FRM_ADMIN_LOCATION_ADD','EN','Add a new location',''),('mod_FRM_ADMIN_LOCATION_ADD','HU','Új lokáció hozzáadása',''),('mod_FRM_ADMIN_LOCATION_ADD','IT','Aggiungi Location',''),('mod_FRM_ADMIN_LOCATION_ADD','NL','Voeg nieuwe locatie toe',''),('mod_FRM_ADMIN_LOCATION_DELETE','EN','Delete a location',''),('mod_FRM_ADMIN_LOCATION_DELETE','HU','Lokáció törlése',''),('mod_FRM_ADMIN_LOCATION_DELETE','IT','Elimina Location',''),('mod_FRM_ADMIN_LOCATION_DELETE','NL','Verwijder locatie',''),('mod_FRM_ADMIN_LOCATION_EDIT','EN','Edit a location',''),('mod_FRM_ADMIN_LOCATION_EDIT','HU','Lokáció szerkesztése',''),('mod_FRM_ADMIN_LOCATION_EDIT','IT','Modifica Location',''),('mod_FRM_ADMIN_LOCATION_EDIT','NL','Bewerk een locatie',''),('mod_FRM_ADMIN_MATERIALS','EN','Administer Materials','M'),('mod_FRM_ADMIN_MATERIALS','HU','Anyagok Szerkesztése','M'),('mod_FRM_ADMIN_MATERIALS','IT','Gestione Materiali','M'),('mod_FRM_ADMIN_MATERIALS','NL','Beheer produkten',''),('mod_FRM_ADMIN_MATERIAL_ADD','EN','Add a Material',''),('mod_FRM_ADMIN_MATERIAL_ADD','HU','Material hozzáadása',''),('mod_FRM_ADMIN_MATERIAL_ADD','IT','Aggiungi un Materiale',''),('mod_FRM_ADMIN_MATERIAL_ADD','NL','Voeg Produkt toe',''),('mod_FRM_ADMIN_MATERIAL_BATCH','EN','Administer Batches','B'),('mod_FRM_ADMIN_MATERIAL_BATCH','HU','Batch hozzáadása','B'),('mod_FRM_ADMIN_MATERIAL_BATCH','IT','Gestione Batch','B'),('mod_FRM_ADMIN_MATERIAL_BATCH','NL','Beheer batches',''),('mod_FRM_ADMIN_MATERIAL_BATCH_EDIT','EN','Edit a Material Batch Record',''),('mod_FRM_ADMIN_MATERIAL_BATCH_EDIT','HU','Anyag Rekord Szerkesztése',''),('mod_FRM_ADMIN_MATERIAL_BATCH_EDIT','IT','Modifica Batch Materiale',''),('mod_FRM_ADMIN_MATERIAL_BATCH_EDIT','NL','Bewerk produkt batch record',''),('mod_FRM_ADMIN_MATERIAL_DELETE','EN','Delete a Material',''),('mod_FRM_ADMIN_MATERIAL_DELETE','HU','Anyag törlése',''),('mod_FRM_ADMIN_MATERIAL_DELETE','IT','Elimina Materiale',''),('mod_FRM_ADMIN_MATERIAL_DELETE','NL','Verwijder Produkt',''),('mod_FRM_ADMIN_MATERIAL_EDIT','EN','Edit a Material',''),('mod_FRM_ADMIN_MATERIAL_EDIT','HU','Anyag Szerkesztése',''),('mod_FRM_ADMIN_MATERIAL_EDIT','IT','Modifica Materiale',''),('mod_FRM_ADMIN_MATERIAL_EDIT','NL','Bewerk Produkt',''),('mod_FRM_ADMIN_MATERIAL_LOCATION','EN','Administer Material Locations','B'),('mod_FRM_ADMIN_MATERIAL_LOCATION','HU','Anyag Helyszínek','B'),('mod_FRM_ADMIN_MATERIAL_LOCATION','IT','Gestione Posizione','B'),('mod_FRM_ADMIN_MATERIAL_LOCATION','NL','Beheer Materiaal Locaties',''),('mod_FRM_ADMIN_MATERIAL_LOCATION_EDIT','EN','Edit a Material Material Location Record',''),('mod_FRM_ADMIN_MATERIAL_LOCATION_EDIT','HU','Edit anyag helye',''),('mod_FRM_ADMIN_MATERIAL_LOCATION_EDIT','IT','Modifica Posizione Materiale',''),('mod_FRM_ADMIN_MATERIAL_LOCATION_EDIT','NL','Bewerk Materiaal Locaties record',''),('mod_FRM_ADMIN_MATERIAL_TYPE','EN','Administer Material Types','T'),('mod_FRM_ADMIN_MATERIAL_TYPE','HU','Anyag típus Szerkesztése','A'),('mod_FRM_ADMIN_MATERIAL_TYPE','IT','Gestione Tipi Materiale','T'),('mod_FRM_ADMIN_MATERIAL_TYPE','NL','Beheer Produkt soorten',''),('mod_FRM_ADMIN_MATERIAL_TYPE_ADD','EN','Add a Material Type',''),('mod_FRM_ADMIN_MATERIAL_TYPE_ADD','HU','Anyag típus hozzáadása',''),('mod_FRM_ADMIN_MATERIAL_TYPE_ADD','IT','Aggiungi Tipo Materiale',''),('mod_FRM_ADMIN_MATERIAL_TYPE_ADD','NL','Voeg Produkt type toe',''),('mod_FRM_ADMIN_MATERIAL_TYPE_DELETE','EN','Delete a Material Type',''),('mod_FRM_ADMIN_MATERIAL_TYPE_DELETE','HU','Anyag típus törlése',''),('mod_FRM_ADMIN_MATERIAL_TYPE_DELETE','IT','Elimina Tipo Materiale',''),('mod_FRM_ADMIN_MATERIAL_TYPE_DELETE','NL','Verwijder Produkt type',''),('mod_FRM_ADMIN_MATERIAL_TYPE_EDIT','EN','Add or Update a Material Type',''),('mod_FRM_ADMIN_MATERIAL_TYPE_EDIT','HU','Anyag típus hozzáadása/szerkesztése',''),('mod_FRM_ADMIN_MATERIAL_TYPE_EDIT','IT','Aggiungi o Modifica Tipo Materiale',''),('mod_FRM_ADMIN_MATERIAL_TYPE_EDIT','NL','Toevoegen of bijwerken een produkt type',''),('mod_FRM_ADMIN_MATERIAL_TYPE_PRINT','EN','Print Material Types',''),('mod_FRM_ADMIN_MATERIAL_TYPE_PRINT','HU','Anyag típusok Szerkesztése',''),('mod_FRM_ADMIN_MATERIAL_TYPE_PRINT','IT','Stampa Tipi Materiale',''),('mod_FRM_ADMIN_MATERIAL_TYPE_PRINT','NL','Print produkt soorten',''),('mod_FRM_ADMIN_MATERIAL_TYPE_RENAME','EN','Rename a Material Type',''),('mod_FRM_ADMIN_MATERIAL_TYPE_RENAME','HU','Anyag típusok Átnevezése',''),('mod_FRM_ADMIN_MATERIAL_TYPE_RENAME','IT','Rinomina Tipo Materiale',''),('mod_FRM_ADMIN_MATERIAL_TYPE_RENAME','NL','Wijzig naam van een Produkt type',''),('mod_FRM_ADMIN_MATERIAL_UOM','EN','Administer UOMs for a Material','U'),('mod_FRM_ADMIN_MATERIAL_UOM','HU','Anyagok UOM Szerkesztése','U'),('mod_FRM_ADMIN_MATERIAL_UOM','IT','Gestione UdM Materiale','U'),('mod_FRM_ADMIN_MATERIAL_UOM','NL','Beheer UOM voor een Produkt',''),('mod_FRM_ADMIN_MATERIAL_UOM_ADD','EN','Add a Material UOM',''),('mod_FRM_ADMIN_MATERIAL_UOM_ADD','HU','Anyag UOM Hozzáadása',''),('mod_FRM_ADMIN_MATERIAL_UOM_ADD','IT','Aggiungi UdM Materiale',''),('mod_FRM_ADMIN_MATERIAL_UOM_ADD','NL','Voeg Produkt UOM toe',''),('mod_FRM_ADMIN_MATERIAL_UOM_DELETE','EN','Delete a Material UOM',''),('mod_FRM_ADMIN_MATERIAL_UOM_DELETE','HU','Anyag UOM Törlése',''),('mod_FRM_ADMIN_MATERIAL_UOM_DELETE','IT','Elimina UdM Materiale',''),('mod_FRM_ADMIN_MATERIAL_UOM_DELETE','NL','Verwijder een Produkt UOM',''),('mod_FRM_ADMIN_MATERIAL_UOM_EDIT','EN','Edit Material UOM Properties',''),('mod_FRM_ADMIN_MATERIAL_UOM_EDIT','HU','Edit Material UOM Properties',''),('mod_FRM_ADMIN_MATERIAL_UOM_EDIT','IT','Modifica Proprietà UdM Materiale',''),('mod_FRM_ADMIN_MATERIAL_UOM_EDIT','NL','Edit Materiaal UOM Eigenschappen',''),('mod_FRM_ADMIN_MENU','EN','Menu Maintenance',''),('mod_FRM_ADMIN_MENU','HU','Menü Szerkesztése',''),('mod_FRM_ADMIN_MENU','IT','Menu Gestione',''),('mod_FRM_ADMIN_MENU','NL','Menu Onderhoud',''),('mod_FRM_ADMIN_MHN','EN','Administer Master Holds','0'),('mod_FRM_ADMIN_MHN','HU','Administer Master Holds','0'),('mod_FRM_ADMIN_MHN','IT','Gestione Master Holds','0'),('mod_FRM_ADMIN_MHN','NL','Administer Master Holds','0'),('mod_FRM_ADMIN_MHN_ASSIGN','EN','Assign SSCC to MHN','0'),('mod_FRM_ADMIN_MHN_ASSIGN','HU','Assign SSCC to MHN','0'),('mod_FRM_ADMIN_MHN_ASSIGN','IT','Assegna SSCC a MHN','0'),('mod_FRM_ADMIN_MHN_ASSIGN','NL','Assign SSCC to MHN','0'),('mod_FRM_ADMIN_MHN_DECISION','EN','Decision Admin',NULL),('mod_FRM_ADMIN_MHN_DECISION','HU','Decision Admin',NULL),('mod_FRM_ADMIN_MHN_DECISION','IT','Gestione Decisioni',''),('mod_FRM_ADMIN_MHN_DECISION','NL','Decision Admin',NULL),('mod_FRM_ADMIN_MHN_DECISION_EDIT','EN','Edit Decision',''),('mod_FRM_ADMIN_MHN_DECISION_EDIT','HU','edit Decision',''),('mod_FRM_ADMIN_MHN_DECISION_EDIT','IT','Modifica la decisione',''),('mod_FRM_ADMIN_MHN_DECISION_EDIT','NL','edit Decision',''),('mod_FRM_ADMIN_MHN_EDIT','EN','Edit MHN',NULL),('mod_FRM_ADMIN_MHN_EDIT','HU','Edit MHN',NULL),('mod_FRM_ADMIN_MHN_EDIT','IT','Modifica MHN',''),('mod_FRM_ADMIN_MHN_EDIT','NL','Edit MHN',NULL),('mod_FRM_ADMIN_MHN_REASON','EN','Reason Admin',NULL),('mod_FRM_ADMIN_MHN_REASON','HU','Reason Admin',NULL),('mod_FRM_ADMIN_MHN_REASON','IT','Gestione Reason',''),('mod_FRM_ADMIN_MHN_REASON','NL','Reason Admin',NULL),('mod_FRM_ADMIN_MHN_REASON_EDIT','EN','Edit Reason',''),('mod_FRM_ADMIN_MHN_REASON_EDIT','HU','Szerkesztés oka',''),('mod_FRM_ADMIN_MHN_REASON_EDIT','IT','Modifica ragione',''),('mod_FRM_ADMIN_MHN_REASON_EDIT','NL','Reden bewerken',''),('mod_FRM_ADMIN_MODULES','EN','Modules','M'),('mod_FRM_ADMIN_MODULES','HU','Modulok ','M'),('mod_FRM_ADMIN_MODULES','IT','Moduli','M'),('mod_FRM_ADMIN_MODULES','NL','Modules',''),('mod_FRM_ADMIN_MODULE_ADD','EN','Add a Module',''),('mod_FRM_ADMIN_MODULE_ADD','HU','Modul Hozzáadása',''),('mod_FRM_ADMIN_MODULE_ADD','IT','Aggiungi Modulo',''),('mod_FRM_ADMIN_MODULE_ADD','NL','Voeg een module toe',''),('mod_FRM_ADMIN_MODULE_DELETE','EN','Delete a Module',''),('mod_FRM_ADMIN_MODULE_DELETE','HU','Modul Törlése',''),('mod_FRM_ADMIN_MODULE_DELETE','IT','Elimina Modulo',''),('mod_FRM_ADMIN_MODULE_DELETE','NL','Verwijder een module',''),('mod_FRM_ADMIN_MODULE_EDIT','EN','Edit the Module Properties',''),('mod_FRM_ADMIN_MODULE_EDIT','HU','Modulok Szerkesztése',''),('mod_FRM_ADMIN_MODULE_EDIT','IT','Modifica Proprietà Modulo',''),('mod_FRM_ADMIN_MODULE_EDIT','NL','Bewerk module eigenschappen',''),('mod_FRM_ADMIN_MODULE_RENAME','EN','Rename a Module',''),('mod_FRM_ADMIN_MODULE_RENAME','HU','Modilok Átnevezése',''),('mod_FRM_ADMIN_MODULE_RENAME','IT','Rinomina Modulo',''),('mod_FRM_ADMIN_MODULE_RENAME','NL','Naam van een module',''),('mod_FRM_ADMIN_PALLETS','EN','Administer Pallets','P'),('mod_FRM_ADMIN_PALLETS','HU','Paletták Adminisztrálása','P'),('mod_FRM_ADMIN_PALLETS','IT','Info Pallet','P'),('mod_FRM_ADMIN_PALLETS','NL','Beheer pallets',''),('mod_FRM_ADMIN_PALLET_ADD','EN','Add a Pallet',''),('mod_FRM_ADMIN_PALLET_ADD','HU','Palletta hozzáadása',''),('mod_FRM_ADMIN_PALLET_ADD','IT','Aggiungi Pallet',''),('mod_FRM_ADMIN_PALLET_ADD','NL','Voeg pallet toe',''),('mod_FRM_ADMIN_PALLET_DELETE','EN','Delete a Pallet',''),('mod_FRM_ADMIN_PALLET_DELETE','HU','Palleta törlése',''),('mod_FRM_ADMIN_PALLET_DELETE','IT','Elimina Pallet',''),('mod_FRM_ADMIN_PALLET_DELETE','NL','Verwijderen van een pallet',''),('mod_FRM_ADMIN_PALLET_EDIT','EN','Edit Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT','HU','Paletta Törlése',''),('mod_FRM_ADMIN_PALLET_EDIT','IT','Modifica Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT','NL','Edit Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_BATCH','EN','Edit Pallet Batch',''),('mod_FRM_ADMIN_PALLET_EDIT_BATCH','HU','Paletta Bathc törlése',''),('mod_FRM_ADMIN_PALLET_EDIT_BATCH','IT','Modifica Batch Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_BATCH','NL','Edit Pallet Batch',''),('mod_FRM_ADMIN_PALLET_EDIT_LOCATION','EN','Edit Pallet Location',''),('mod_FRM_ADMIN_PALLET_EDIT_LOCATION','HU','Paletta Lokáció Törlése',''),('mod_FRM_ADMIN_PALLET_EDIT_LOCATION','IT','Modifica Locazione Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_LOCATION','NL','Edit Pallet Locatie',''),('mod_FRM_ADMIN_PALLET_EDIT_MATERIAL','EN','Edit Material of Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_MATERIAL','HU','Paletta Anyag Szerkesztése',''),('mod_FRM_ADMIN_PALLET_EDIT_MATERIAL','IT','Modifica Materiale Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_MATERIAL','NL','Edit Materiaal van Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER','EN','Edit Process Order',''),('mod_FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER','HU','PO Szerkesztése',''),('mod_FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER','IT','Modifica Process Order',''),('mod_FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER','NL','Edit Process Order',''),('mod_FRM_ADMIN_PALLET_EDIT_PROD_DATE','EN','Edit Production Date',''),('mod_FRM_ADMIN_PALLET_EDIT_PROD_DATE','HU','Gyártás ido Szerkesztése',''),('mod_FRM_ADMIN_PALLET_EDIT_PROD_DATE','IT','Modifica Data Produzione',''),('mod_FRM_ADMIN_PALLET_EDIT_PROD_DATE','NL','Edit Productie Datum',''),('mod_FRM_ADMIN_PALLET_EDIT_QUANTITY','EN','Edit Pallet Quantity',''),('mod_FRM_ADMIN_PALLET_EDIT_QUANTITY','HU','Palleta Menyiség Szerkesztése',''),('mod_FRM_ADMIN_PALLET_EDIT_QUANTITY','IT','Modifica Quantità Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_QUANTITY','NL','Edit pallets',''),('mod_FRM_ADMIN_PALLET_EDIT_STATUS','EN','Edit Pallet Status',''),('mod_FRM_ADMIN_PALLET_EDIT_STATUS','HU','Paletta Státusz Szerkesztése',''),('mod_FRM_ADMIN_PALLET_EDIT_STATUS','IT','Modifica Stato Pallet',''),('mod_FRM_ADMIN_PALLET_EDIT_STATUS','NL','Edit Pallet Status',''),('mod_FRM_ADMIN_PALLET_EDIT_UOM','EN','Edit a Material UOM',''),('mod_FRM_ADMIN_PALLET_EDIT_UOM','HU','Anyag UOM Szerkesztése',''),('mod_FRM_ADMIN_PALLET_EDIT_UOM','IT','Modifica UdM Materiale',''),('mod_FRM_ADMIN_PALLET_EDIT_UOM','NL','Bewerk een Material UOM',''),('mod_FRM_ADMIN_PALLET_HISTORY','EN','Pallet History',''),('mod_FRM_ADMIN_PALLET_HISTORY','HU','Paletta Történet',''),('mod_FRM_ADMIN_PALLET_HISTORY','IT','Storia Pallet',''),('mod_FRM_ADMIN_PALLET_HISTORY','NL','Pallet Geschiedenis',''),('mod_FRM_ADMIN_PALLET_PRINT','EN','Pallet Print',''),('mod_FRM_ADMIN_PALLET_PRINT','HU','Paletta nyomtatás',''),('mod_FRM_ADMIN_PALLET_PRINT','IT','Stampa Pallet',''),('mod_FRM_ADMIN_PALLET_PRINT','NL','Pallet Print',''),('mod_FRM_ADMIN_PROCESS_ORDER','EN','Administer Process Orders','O'),('mod_FRM_ADMIN_PROCESS_ORDER','HU','PO k Adminisztrálása','O'),('mod_FRM_ADMIN_PROCESS_ORDER','IT','Gestione Process Order','O'),('mod_FRM_ADMIN_PROCESS_ORDER','NL','Beheer Process Orders',''),('mod_FRM_ADMIN_PROCESS_ORDER_ADD','EN','Add a process order',''),('mod_FRM_ADMIN_PROCESS_ORDER_ADD','HU','PO Hozzáadása',''),('mod_FRM_ADMIN_PROCESS_ORDER_ADD','IT','Aggiungi Process Order',''),('mod_FRM_ADMIN_PROCESS_ORDER_ADD','NL','Voeg Process Order toe',''),('mod_FRM_ADMIN_PROCESS_ORDER_DELETE','EN','Delete a process order',''),('mod_FRM_ADMIN_PROCESS_ORDER_DELETE','HU','PO Törlése',''),('mod_FRM_ADMIN_PROCESS_ORDER_DELETE','IT','Elimina Process Order',''),('mod_FRM_ADMIN_PROCESS_ORDER_DELETE','NL','Verwijder Process Order',''),('mod_FRM_ADMIN_PROCESS_ORDER_EDIT','EN','Edit a Process Order',''),('mod_FRM_ADMIN_PROCESS_ORDER_EDIT','HU','PO Szerkesztése',''),('mod_FRM_ADMIN_PROCESS_ORDER_EDIT','IT','Modifica Process Order',''),('mod_FRM_ADMIN_PROCESS_ORDER_EDIT','NL','Bewerk een Process Order',''),('mod_FRM_ADMIN_QM_DICTIONARY','EN','Administer Dictionary','P'),('mod_FRM_ADMIN_QM_DICTIONARY','HU','Adminisztrálás Szótár','P'),('mod_FRM_ADMIN_QM_DICTIONARY','IT','Amministrare Dictionary','P'),('mod_FRM_ADMIN_QM_DICTIONARY','NL','Dien Woordenboek','P'),('mod_FRM_ADMIN_QM_INSPECTION','EN','Administer Inspections','P'),('mod_FRM_ADMIN_QM_INSPECTION','HU','Ellen?rzések Adminisztrálás','P'),('mod_FRM_ADMIN_QM_INSPECTION','IT','Amministrare Ispezioni','P'),('mod_FRM_ADMIN_QM_INSPECTION','NL','Dien Inspecties','P'),('mod_FRM_ADMIN_QM_SELECTLIST','EN','Administer Selection Lists','P'),('mod_FRM_ADMIN_QM_SELECTLIST','HU','Adminisztrálás választólistákban','P'),('mod_FRM_ADMIN_QM_SELECTLIST','IT','Amministrare elenchi di selezione','P'),('mod_FRM_ADMIN_QM_SELECTLIST','NL','Dien Selectie Lijsten','P'),('mod_FRM_ADMIN_RF_MENU','EN','RF Menu Maintenance','F'),('mod_FRM_ADMIN_RF_MENU','HU','RF Menü Szerkesztése','R'),('mod_FRM_ADMIN_RF_MENU','IT','Menu Gestione RF','F'),('mod_FRM_ADMIN_RF_MENU','NL','RF Menu Onderhoud',''),('mod_FRM_ADMIN_TOOLBAR','EN','Toolbar Maintenance','T'),('mod_FRM_ADMIN_TOOLBAR','HU','Eszköztár Szerkesztése','E'),('mod_FRM_ADMIN_TOOLBAR','IT','Gestione Toolbar','T'),('mod_FRM_ADMIN_TOOLBAR','NL','Toolbar Onderhoud',''),('mod_FRM_ADMIN_UOM','EN','Administer Units of Measure','U'),('mod_FRM_ADMIN_UOM','HU','UOM Szerkesztése','U'),('mod_FRM_ADMIN_UOM','IT','Gestione UdM','U'),('mod_FRM_ADMIN_UOM','NL','Beheer maateenheden',''),('mod_FRM_ADMIN_UOM_ADD','EN','Add a new UOM',''),('mod_FRM_ADMIN_UOM_ADD','HU','Új UOM hozzáadása',''),('mod_FRM_ADMIN_UOM_ADD','IT','Aggiungi UdM',''),('mod_FRM_ADMIN_UOM_ADD','NL','Voeg een nieuwe UOM toe',''),('mod_FRM_ADMIN_UOM_DELETE','EN','Delete a UOM',''),('mod_FRM_ADMIN_UOM_DELETE','HU','UOM Törlése',''),('mod_FRM_ADMIN_UOM_DELETE','IT','Elimina UdM',''),('mod_FRM_ADMIN_UOM_DELETE','NL','Verwijder een UOM',''),('mod_FRM_ADMIN_UOM_EDIT','EN','Edit a UOM',''),('mod_FRM_ADMIN_UOM_EDIT','HU','UOM Szerkesztése',''),('mod_FRM_ADMIN_UOM_EDIT','IT','Modifica UdM',''),('mod_FRM_ADMIN_UOM_EDIT','NL','Bewerk UOM',''),('mod_FRM_ADMIN_UOM_PRINT','EN','Print UOMs',''),('mod_FRM_ADMIN_UOM_PRINT','HU','UOM Nyomtatása',''),('mod_FRM_ADMIN_UOM_PRINT','IT','Stampa UdM',''),('mod_FRM_ADMIN_UOM_PRINT','NL','Print UOMs',''),('mod_FRM_ADMIN_UOM_RENAME','EN','Rename a UOM',''),('mod_FRM_ADMIN_UOM_RENAME','HU','UOM Átnevezése',''),('mod_FRM_ADMIN_UOM_RENAME','IT','Rinomina UdM',''),('mod_FRM_ADMIN_UOM_RENAME','NL','De naam van een UOM',''),('mod_FRM_ADMIN_USERS','EN','Users','S'),('mod_FRM_ADMIN_USERS','HU','Felhasználók','F'),('mod_FRM_ADMIN_USERS','IT','Utenti','S'),('mod_FRM_ADMIN_USERS','NL','Gebruikers',''),('mod_FRM_ADMIN_USER_ADD','EN','Add a new User',''),('mod_FRM_ADMIN_USER_ADD','HU','Új felhasználó hozzáadása',''),('mod_FRM_ADMIN_USER_ADD','IT','Aggiungi Utente',''),('mod_FRM_ADMIN_USER_ADD','NL','Voeg een nieuwe gebruiker',''),('mod_FRM_ADMIN_USER_DELETE','EN','Delete a User',''),('mod_FRM_ADMIN_USER_DELETE','HU','Felhasználó Törlése',''),('mod_FRM_ADMIN_USER_DELETE','IT','Elimina Utente',''),('mod_FRM_ADMIN_USER_DELETE','NL','Verwijderen van een gebruiker',''),('mod_FRM_ADMIN_USER_EDIT','EN','User Properties',''),('mod_FRM_ADMIN_USER_EDIT','HU','Felhasználó Szerkesztése',''),('mod_FRM_ADMIN_USER_EDIT','IT','Proprietà Utente',''),('mod_FRM_ADMIN_USER_EDIT','NL','Gebruikerseigenschappen',''),('mod_FRM_ADMIN_USER_PERM','EN','User Permissions',''),('mod_FRM_ADMIN_USER_PERM','HU','Felhasználó Beállítása',''),('mod_FRM_ADMIN_USER_PERM','IT','Autorizzazioni Utente',''),('mod_FRM_ADMIN_USER_PERM','NL','Gebruikersrechten',''),('mod_FRM_ADMIN_USER_RENAME','EN','Rename a User',''),('mod_FRM_ADMIN_USER_RENAME','HU','Felhasználó Átnevezése',''),('mod_FRM_ADMIN_USER_RENAME','IT','Rinomina Utente',''),('mod_FRM_ADMIN_USER_RENAME','NL','Hernoem gebruiker',''),('mod_FRM_AUTO_LABELLER','EN','Auto Labeller','A'),('mod_FRM_AUTO_LABELLER','HU','Auto Labeller','A'),('mod_FRM_AUTO_LABELLER','IT','Auto Labeller','A'),('mod_FRM_AUTO_LABELLER','NL','Auto Labeller','A'),('mod_FRM_CM_PRINTERS','EN','Default Printer',''),('mod_FRM_CM_PRINTERS','HU','Alapértelmezett nyomtató ',''),('mod_FRM_CM_PRINTERS','IT','Stampante di Default',''),('mod_FRM_CM_PRINTERS','NL','Standaardprinter',''),('mod_FRM_PAL_INFO','EN','Pallet Info',''),('mod_FRM_PAL_INFO','HU','Paletta Info',''),('mod_FRM_PAL_INFO','IT','Info Pallet',''),('mod_FRM_PAL_INFO','NL','Pallet Info',''),('mod_FRM_PAL_LABEL_COPIES','EN','Label Print',''),('mod_FRM_PAL_LABEL_COPIES','HU','Címke nyomtatás',''),('mod_FRM_PAL_LABEL_COPIES','IT','Stampa Etichetta',''),('mod_FRM_PAL_LABEL_COPIES','NL','Label Print',''),('mod_FRM_PAL_PROD_CONFIRM','EN','Production Confirmation','C'),('mod_FRM_PAL_PROD_CONFIRM','HU','Gyártás Konfirmálás','G'),('mod_FRM_PAL_PROD_CONFIRM','IT','Completamento Pallet','C'),('mod_FRM_PAL_PROD_CONFIRM','NL','Bevestig produktie',''),('mod_FRM_PAL_PROD_DEC','EN','Production Declaration','D'),('mod_FRM_PAL_PROD_DEC','HU','Gyártás Deklarálás','D'),('mod_FRM_PAL_PROD_DEC','IT','Etichetta Prodotti Finiti','D'),('mod_FRM_PAL_PROD_DEC','NL','Productie Verklaring',''),('mod_FRM_PAL_SPLIT','EN','Split Pallet','P'),('mod_FRM_PAL_SPLIT','HU','Split Pallet','P'),('mod_FRM_PAL_SPLIT','IT','Split Pallet','P'),('mod_FRM_PAL_SPLIT','NL','Split Pallet','P'),('mod_FRM_PROCESS_ORDER_LABEL','EN','Process Order Label Print',''),('mod_FRM_PROCESS_ORDER_LABEL','IT','Process Order Label Print',''),('mod_FRM_PROCESS_ORDER_LABEL','NL','Process Order Label Print',''),('mod_FRM_PRODDEC_CONFIRM','EN','Permits user to check the Confirmed Box','C'),('mod_FRM_PRODDEC_CONFIRM','HU','Engedélyezzük a felszanáló konfirmáló dobozát','E'),('mod_FRM_PRODDEC_CONFIRM','IT','Permits user to check the Confirmed Box','C'),('mod_FRM_PRODDEC_CONFIRM','NL','User mag confirmed box aanvinken',''),('mod_FRM_PRODDEC_PREVIEW','EN','Permits user to click preview box','P'),('mod_FRM_PRODDEC_PREVIEW','HU','Engedélyezük a felhasználó nyomtató elonézetet','E'),('mod_FRM_PRODDEC_PREVIEW','IT','Permits user to click preview box','P'),('mod_FRM_PRODDEC_PREVIEW','NL','User mag preview box gebruiken',''),('mod_FRM_PRODDEC_PRINT','EN','Permits user to enable/disable print box',''),('mod_FRM_PRODDEC_PRINT','HU','Engedélyezük a felhasználó nyomtató dobozát',''),('mod_FRM_PRODDEC_PRINT','IT','Permits user to enable/disable print box',''),('mod_FRM_PRODDEC_PRINT','NL','User mag print box aan/uit zetten',''),('mod_FRM_QM_ACTIVITY','EN','Activity Properties','P'),('mod_FRM_QM_ACTIVITY','HU','Activity Ingatlan','P'),('mod_FRM_QM_ACTIVITY','IT','Attività Proprietà','P'),('mod_FRM_QM_ACTIVITY','NL','Activiteiten Onroerend goed','P'),('mod_FRM_QM_DICTIONARY','EN','Dictionary Properties','P'),('mod_FRM_QM_DICTIONARY','HU','Szótár tulajdonságai','P'),('mod_FRM_QM_DICTIONARY','IT','Proprietà dizionario','P'),('mod_FRM_QM_DICTIONARY','NL','Dictionary-eigenschappen','P'),('mod_FRM_QM_INSPECTION','EN','Inspection Properties','P'),('mod_FRM_QM_INSPECTION','HU','Ellen?rzés tulajdonságok','P'),('mod_FRM_QM_INSPECTION','IT','Ispezione Proprietà','P'),('mod_FRM_QM_INSPECTION','NL','Inspectie Eigenschappen','P'),('mod_FRM_QM_RESULT_ENQUIRY','EN','Results Enquiry','P'),('mod_FRM_QM_RESULT_ENQUIRY','HU','Eredmények Érdekl?dés','P'),('mod_FRM_QM_RESULT_ENQUIRY','IT','Risultati Richiesta','P'),('mod_FRM_QM_RESULT_ENQUIRY','NL','Resultaten Aanvraag','P'),('mod_FRM_QM_SAMPLE_EDIT','EN','Edit Sample','P'),('mod_FRM_QM_SAMPLE_EDIT','HU','Szerkesztése Minta','P'),('mod_FRM_QM_SAMPLE_EDIT','IT','Modifica del Campione','P'),('mod_FRM_QM_SAMPLE_EDIT','NL','Bewerken Monster','P'),('mod_FRM_QM_SAMPLE_LABEL','EN','Print Sample Labels','P'),('mod_FRM_QM_SAMPLE_LABEL','HU','Minta címkék nyomtatása','P'),('mod_FRM_QM_SAMPLE_LABEL','IT','Stampa Etichette campione','P'),('mod_FRM_QM_SAMPLE_LABEL','NL','Print Sample Labels','P'),('mod_FRM_QM_SAMPLE_RESULTS','EN','Update Sample Results','P'),('mod_FRM_QM_SAMPLE_RESULTS','HU','Frissítés Mintaeredmények','P'),('mod_FRM_QM_SAMPLE_RESULTS','IT','Aggiornare i risultati del campione','P'),('mod_FRM_QM_SAMPLE_RESULTS','NL','Werk Voorbeeld resultaten','P'),('mod_FRM_QM_SELECTLIST','EN','Selection List Admin','P'),('mod_FRM_QM_SELECTLIST','HU','Selection List Properties','P'),('mod_FRM_QM_SELECTLIST','IT','Lista di selezione Proprietà','P'),('mod_FRM_QM_SELECTLIST','NL','Selectie Lijsteigenschappen','P'),('mod_FRM_QM_TEST','EN','Test Properties','P'),('mod_FRM_QM_TEST','HU','Teszt Tulajdonságai','P'),('mod_FRM_QM_TEST','IT','Proprietà di prova','P'),('mod_FRM_QM_TEST','NL','Test Eigenschappen','P'),('mod_FRM_SYSTEM_KEYS','EN','System Keys Maintenance','S'),('mod_FRM_SYSTEM_KEYS','HU','Rendszerkulcs adminisztráció','R'),('mod_FRM_SYSTEM_KEYS','IT','Gestione Chiavi di Sistema','S'),('mod_FRM_SYSTEM_KEYS','NL','System Keys Onderhoud',''),('mod_FRM_SYSTEM_KEYS_ADD','EN','Add a System Key',''),('mod_FRM_SYSTEM_KEYS_ADD','HU','Rendszerkulcs hozzáadás',''),('mod_FRM_SYSTEM_KEYS_ADD','IT','Aggiungi Chiave di Sistema',''),('mod_FRM_SYSTEM_KEYS_ADD','NL','Voeg system key toe',''),('mod_FRM_SYSTEM_KEYS_DELETE','EN','Delete a System Key',''),('mod_FRM_SYSTEM_KEYS_DELETE','HU','Rendszerkulcs törlés',''),('mod_FRM_SYSTEM_KEYS_DELETE','IT','Elimina Chiave di Sistema',''),('mod_FRM_SYSTEM_KEYS_DELETE','NL','Verwijderen van een System Key',''),('mod_FRM_SYSTEM_KEYS_EDIT','EN','Edit a System Key',''),('mod_FRM_SYSTEM_KEYS_EDIT','HU','Rendszerkulcs Szerkeztés',''),('mod_FRM_SYSTEM_KEYS_EDIT','IT','Modifica Chiave di Sistema',''),('mod_FRM_SYSTEM_KEYS_EDIT','NL','Bewerk een System Key',''),('mod_MENU_ADMIN','EN','Administration','A'),('mod_MENU_ADMIN','HU','Adminisztráció','A'),('mod_MENU_ADMIN','IT','Amministrazione','A'),('mod_MENU_ADMIN','NL','Administratie',''),('mod_MENU_CUSTOMISE','EN','Customise Application','C'),('mod_MENU_CUSTOMISE','HU','Program testreszabás','P'),('mod_MENU_CUSTOMISE','IT','Personalizza Applicazione','C'),('mod_MENU_CUSTOMISE','NL','Aanpassen Toepassing',''),('mod_MENU_DATA_MAINT','EN','Data Maintenance','D'),('mod_MENU_DATA_MAINT','HU','Adat karbantartás','A'),('mod_MENU_DATA_MAINT','IT','Gestione Dati','D'),('mod_MENU_DATA_MAINT','NL','Data Onderhoud',''),('mod_MENU_INTERFACE','EN','Interfaces','I'),('mod_MENU_INTERFACE','HU','Interfészek','I'),('mod_MENU_INTERFACE','IT','Interfacce','I'),('mod_MENU_INTERFACE','NL','Interfaces',''),('mod_MENU_MHN','EN','Master Holds','0'),('mod_MENU_MHN','HU','Master Holds','0'),('mod_MENU_MHN','IT','Master Holds','0'),('mod_MENU_MHN','NL','Master Holds','0'),('mod_MENU_PAL','EN','Pallet Transactions','P'),('mod_MENU_PAL','HU','Paletta Tranzakció','P'),('mod_MENU_PAL','IT','Transazioni Pallet','P'),('mod_MENU_PAL','NL','Pallet Transacties',''),('mod_MENU_PAL_REPORTS','EN','Reports Menu',''),('mod_MENU_PAL_REPORTS','HU','Menü Riport',''),('mod_MENU_PAL_REPORTS','IT','Menu Report',''),('mod_MENU_PAL_REPORTS','NL','Rapporten Menu',''),('mod_MENU_PERMISSIONS','EN','Permissions','R'),('mod_MENU_PERMISSIONS','HU','Hozzáférések','H'),('mod_MENU_PERMISSIONS','IT','Autorizzazioni','R'),('mod_MENU_PERMISSIONS','NL','Bevoegdheden',''),('mod_MENU_QM','EN','Quality Management','Q'),('mod_MENU_QM','HU','Min?ségbiztosítás','Q'),('mod_MENU_QM','IT','Gestione della qualità','Q'),('mod_MENU_QM','NL','Quality Management','Q'),('mod_MENU_SETUP','EN','Setup','S'),('mod_MENU_SETUP','HU','Beállíás','B'),('mod_MENU_SETUP','IT','Setup','S'),('mod_MENU_SETUP','NL','Setup',''),('mod_MENU_TOOLS','EN','Tools','T'),('mod_MENU_TOOLS','HU','Eszköz','E'),('mod_MENU_TOOLS','IT','Strumenti','T'),('mod_MENU_TOOLS','NL','Gereedschap',''),('mod_root','EN','Main Menu',''),('mod_root','HU','Fomenu',''),('mod_root','IT','Principale',''),('mod_root','NL','Hoofdmenu',''),('web_Add','EN','Add',''),('web_Add','HU','Hozzáadása',''),('web_Add','IT','Aggiungi',''),('web_Add','NL','Toe te voegen',''),('web_Add_SSCC','EN','Add SSCC',''),('web_Add_SSCC','HU','Hozzáadása SSCC',''),('web_Add_SSCC','IT','Aggiungi SSCC',''),('web_Add_SSCC','NL','Voeg SSCC',''),('web_Amend','EN','Amend',''),('web_Amend','HU','Módosítandó',''),('web_Amend','IT','Modificare',''),('web_Amend','NL','Wijzigen',''),('web_Cancel','EN','Cancel',''),('web_Cancel','HU','Mégsem',''),('web_Cancel','IT','Annulla',''),('web_Cancel','NL','Annuleren',''),('web_Confirm_STN','EN','Confirm STN',''),('web_Confirm_STN','HU','Er?sítse STN',''),('web_Confirm_STN','IT','Conferma STN',''),('web_Confirm_STN','NL','Te bevestigen STN',''),('web_Count','EN','Count',''),('web_Count','HU','Gróf',''),('web_Count','IT','Conte',''),('web_Count','NL','Tellen',''),('web_Create','EN','Create',''),('web_Create','HU','Létrehozása',''),('web_Create','IT','Crea',''),('web_Create','NL','Creëren',''),('web_DOM','EN','D.O.M.',''),('web_DOM','HU','D.O.M.',''),('web_DOM','IT','D.O.M.',''),('web_DOM','NL','D.O.M.',''),('web_Exit','EN','Exit',''),('web_Exit','HU','Kijárat',''),('web_Exit','IT','Esci',''),('web_Exit','NL','Afslag',''),('web_From','EN','From',''),('web_From','HU','-Tól',''),('web_From','IT','Da',''),('web_From','NL','Uit',''),('web_Next_Page','EN','Next Page',''),('web_Next_Page','HU','Következ? oldal',''),('web_Next_Page','IT','Pagina successiva',''),('web_Next_Page','NL','Volgende pagina',''),('web_No','EN','No',''),('web_No','HU','No',''),('web_No','IT','No',''),('web_No','NL','No',''),('web_Previous_Page','EN','Prev Page',''),('web_Previous_Page','HU','El?z? oldal',''),('web_Previous_Page','IT','Pagina Precedente',''),('web_Previous_Page','NL','Vorige pagina',''),('web_Print_STN','EN','Print STN',''),('web_Print_STN','HU','Nyomtatás STN',''),('web_Print_STN','IT','Stampa STN',''),('web_Print_STN','NL','Print STN',''),('web_Prod_Dec_Confirm','EN','Production Confirmation',''),('web_Prod_Dec_Confirm','HU','Production Confirmation',''),('web_Prod_Dec_Confirm','IT','Production Confirmation',''),('web_Prod_Dec_Confirm','NL','Production Confirmation',''),('web_Remove','EN','Remove',''),('web_Remove','HU','Eltávolítás',''),('web_Remove','IT','Rimuovere',''),('web_Remove','NL','Verwijder',''),('web_SSCC','EN','SSCC',''),('web_SSCC','HU','SSCC',''),('web_SSCC','IT','SSCC',''),('web_SSCC','NL','SSCC',''),('web_Submit','EN','Submit',''),('web_Submit','HU','Elküld',''),('web_Submit','IT','Invia',''),('web_Submit','NL','Indienen',''),('web_To','EN','To',''),('web_To','HU','-hoz',''),('web_To','IT','Per',''),('web_To','NL','Op',''),('web_Yes','EN','Yes',''),('web_Yes','HU','Yes',''),('web_Yes','IT','Yes',''),('web_Yes','NL','Yes',''); /*!40000 ALTER TABLE `SYS_LANGUAGE` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_MENUS` -- DROP TABLE IF EXISTS `SYS_MENUS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_MENUS` ( `MODULE_ID` varchar(35) NOT NULL, `MENU_ID` varchar(35) NOT NULL, `SEQUENCE_ID` decimal(22,0) DEFAULT NULL, PRIMARY KEY (`MODULE_ID`,`MENU_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_MENUS` -- LOCK TABLES `SYS_MENUS` WRITE; /*!40000 ALTER TABLE `SYS_MENUS` DISABLE KEYS */; INSERT INTO `SYS_MENUS` VALUES ('EXEC_CONFIG','MENU_TOOLS',1),('EXEC_IREPORT','MENU_TOOLS',0),('FRM_ADMIN_AUTO_LABELLER','MENU_PAL',7),('FRM_ADMIN_CUSTOMER','MENU_DATA_MAINT',6),('FRM_ADMIN_DESPATCH','MENU_PAL',2),('FRM_ADMIN_GROUPS','MENU_PERMISSIONS',1),('FRM_ADMIN_INTERFACE','MENU_INTERFACE',0),('FRM_ADMIN_INTERFACE_LOG','MENU_INTERFACE',2),('FRM_ADMIN_INTERFACE_PROCESS','MENU_INTERFACE',1),('FRM_ADMIN_INTERFACE_REQUEST','MENU_INTERFACE',4),('FRM_ADMIN_LANGUAGE','MENU_SETUP',4),('FRM_ADMIN_LOCATIONS','MENU_DATA_MAINT',0),('FRM_ADMIN_MATERIALS','MENU_DATA_MAINT',1),('FRM_ADMIN_MATERIAL_BATCH','MENU_DATA_MAINT',2),('FRM_ADMIN_MATERIAL_LOCATION','MENU_DATA_MAINT',2),('FRM_ADMIN_MATERIAL_TYPE','MENU_DATA_MAINT',3),('FRM_ADMIN_MENU','MENU_CUSTOMISE',0),('FRM_ADMIN_MHN','MENU_MHN',0),('FRM_ADMIN_MHN_DECISION','MENU_MHN',2),('FRM_ADMIN_MHN_REASON','MENU_MHN',1),('FRM_ADMIN_MODULES','MENU_SETUP',1),('FRM_ADMIN_PALLETS','MENU_PAL',3),('FRM_ADMIN_PALLET_HISTORY','MENU_PAL',4),('FRM_ADMIN_PROCESS_ORDER','MENU_DATA_MAINT',4),('FRM_ADMIN_QM_DICTIONARY','MENU_DATA_MAINT',9),('FRM_ADMIN_QM_INSPECTION','MENU_DATA_MAINT',7),('FRM_ADMIN_QM_SELECTLIST','MENU_DATA_MAINT',8),('FRM_ADMIN_RF_MENU','MENU_CUSTOMISE',3),('FRM_ADMIN_TOOLBAR','MENU_CUSTOMISE',1),('FRM_ADMIN_UOM','MENU_DATA_MAINT',5),('FRM_ADMIN_USERS','MENU_PERMISSIONS',0),('FRM_CM_PRINTERS','MENU_PAL_REPORTS',5),('FRM_CM_PRINTERS','root',4),('FRM_PAL_PROD_CONFIRM','MENU_PAL',1),('FRM_PAL_PROD_DEC','MENU_PAL',0),('FRM_PAL_SPLIT','MENU_PAL',6),('FRM_QM_RESULT_ENQUIRY','MENU_QM',3),('FRM_QM_SAMPLE_EDIT','MENU_QM',4),('FRM_QM_SAMPLE_LABEL','MENU_QM',1),('FRM_QM_SAMPLE_RESULTS','MENU_QM',2),('FRM_SYSTEM_KEYS','MENU_SETUP',0),('MENU_ADMIN','root',2),('MENU_CUSTOMISE','MENU_ADMIN',0),('MENU_DATA_MAINT','root',1),('MENU_INTERFACE','root',1),('MENU_MHN','root',1),('MENU_PAL','root',0),('MENU_PERMISSIONS','MENU_ADMIN',1),('MENU_QM','root',2),('MENU_SETUP','MENU_ADMIN',2),('MENU_TOOLS','root',3); /*!40000 ALTER TABLE `SYS_MENUS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_MODULES` -- DROP TABLE IF EXISTS `SYS_MODULES`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_MODULES` ( `MODULE_ID` varchar(35) NOT NULL, `RF_ACTIVE` varchar(1) DEFAULT 'Y', `DK_ACTIVE` varchar(1) DEFAULT 'Y', `MODULE_TYPE` varchar(10) DEFAULT NULL, `HINT` varchar(80) DEFAULT NULL, `MNEMONIC` decimal(22,0) DEFAULT '0', `ICON_FILENAME` varchar(40) DEFAULT NULL, `HELPSET_ID` varchar(250) DEFAULT NULL, `REPORT_FILENAME` varchar(40) DEFAULT NULL, `EXEC_FILENAME` varchar(80) DEFAULT NULL, `EXEC_DIR` varchar(80) DEFAULT NULL, `PRINT_PREVIEW` varchar(1) DEFAULT 'Y', `PRINT_DIALOG` varchar(1) DEFAULT 'N', `PRINT_COPIES` decimal(22,0) DEFAULT '1', `REPORT_TYPE` varchar(15) DEFAULT '', `RESOURCE_KEY` varchar(50) DEFAULT NULL, PRIMARY KEY (`MODULE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_MODULES` -- LOCK TABLES `SYS_MODULES` WRITE; /*!40000 ALTER TABLE `SYS_MODULES` DISABLE KEYS */; INSERT INTO `SYS_MODULES` VALUES ('EXEC_CONFIG','N','Y','EXEC',NULL,0,NULL,NULL,NULL,'C:\\Java\\eclipse\\workspace\\b4\\Setup_Commander.cmd','C:\\Java\\eclipse\\workspace\\b4','Y','N',1,'','mod_EXEC_CONFIG'),('EXEC_IREPORT','N','Y','EXEC','',0,'','','','C:\\Java\\iReport\\iReport.bat','C:\\Java\\iReport','Y','N',1,'','mod_EXEC_IREPORT'),('FRM_ADMIN_AUTO_LABELLER','N','Y','FORM','Auto Labeller',77,'auto_labeller.png','','','','','Y','N',1,'','mod_FRM_AUTO_LABELLER'),('FRM_ADMIN_CONTROL_EDIT','N','Y','FUNCTION',NULL,0,NULL,'http://www.commander4j.com/mw/index.php?title=System_Keys',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_CONTROL_EDIT'),('FRM_ADMIN_CUSTOMER','N','Y','FORM',NULL,0,'customer.gif','http://www.commander4j.com/mw/index.php?title=Customers',NULL,NULL,NULL,'N','N',1,NULL,'lbl_Customer_Edit'),('FRM_ADMIN_CUSTOMER_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'N','N',1,NULL,NULL),('FRM_ADMIN_CUSTOMER_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'N','N',1,NULL,NULL),('FRM_ADMIN_CUSTOMER_EDIT','N','Y','FUNCTION',NULL,0,NULL,'http://www.commander4j.com/mw/index.php?title=Customers',NULL,NULL,NULL,'N','N',1,NULL,'lbl_Customer_Edit'),('FRM_ADMIN_CUSTOMER_RENAME','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'N','N',1,NULL,NULL),('FRM_ADMIN_DESPATCH','Y','Y','FORM','Despatch Pallets',0,'despatch.gif','http://www.commander4j.com/mw/index.php?title=Despatch',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_DESPATCH'),('FRM_ADMIN_GROUPS','N','Y','FORM','Administer User Groups',71,'admingroups.gif','http://www.commander4j.com/mw/index.php?title=Groups',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_GROUPS'),('FRM_ADMIN_GROUP_ADD','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4japplicationadministrationPermissionsGroupsGroupAdminAdd.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_GROUP_ADD'),('FRM_ADMIN_GROUP_DELETE','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4japplicationadministrationPermissionsGroupsGroupAdminDelete.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_GROUP_DELETE'),('FRM_ADMIN_GROUP_EDIT','N','Y','FUNCTION','Edit Group Properties',0,NULL,'http://www.commander4j.com/mw/index.php?title=Groups',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_GROUP_EDIT'),('FRM_ADMIN_GROUP_PERM','N','Y','FUNCTION','Assign Modules to Group',0,NULL,'{base_dir}helphtmlcommander4japplicationadministrationPermissionsGroupsGroupAdminPermissions.html',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_GROUP_PERM'),('FRM_ADMIN_GROUP_RENAME','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4japplicationadministrationPermissionsGroupsGroupAdminRename.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_GROUP_RENAME'),('FRM_ADMIN_INTERFACE','N','Y','FORM','',0,'interface.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_INTERFACE'),('FRM_ADMIN_INTERFACE_ADD','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'','mod_FRM_ADMIN_INTERFACE_ADD'),('FRM_ADMIN_INTERFACE_DELETE','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'','mod_FRM_ADMIN_INTERFACE_DELETE'),('FRM_ADMIN_INTERFACE_EDIT','N','Y','FUNCTION','',0,'','','','','','Y','N',1,'','mod_FRM_ADMIN_INTERFACE_EDIT'),('FRM_ADMIN_INTERFACE_LOG','N','Y','FORM',NULL,79,'interface.gif',NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_INTERFACE_LOG'),('FRM_ADMIN_INTERFACE_PROCESS','N','Y','FORM','',0,'connect.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_INTERFACE_PROCESS'),('FRM_ADMIN_INTERFACE_REQUEST','N','Y','FORM','',0,'connect.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_INTERFACE_REQUEST'),('FRM_ADMIN_LANGUAGE','N','Y','FORM','',0,'translate.gif','http://www.commander4j.com/mw/index.php?title=User_Guide','','','','N','N',1,'','mod_FRM_ADMIN_LANGUAGE'),('FRM_ADMIN_LANGUAGE_ADD','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_LANGUAGE_DELETE','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_LANGUAGE_EDIT','N','Y','FUNCTION','',0,'','http://www.commander4j.com/mw/index.php?title=User_Guide','','','','Y','Y',1,'',''),('FRM_ADMIN_LOCATIONS','N','Y','FORM','Maintain the locations table',76,'locations.gif','http://www.commander4j.com/mw/index.php?title=Locations',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_LOCATIONS'),('FRM_ADMIN_LOCATION_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_LOCATION_ADD'),('FRM_ADMIN_LOCATION_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_LOCATION_DELETE'),('FRM_ADMIN_LOCATION_EDIT','N','Y','FUNCTION',NULL,0,NULL,'http://www.commander4j.com/mw/index.php?title=Locations',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_LOCATION_EDIT'),('FRM_ADMIN_MATERIALS','N','Y','FORM','Create and update Materials',77,'materials.gif','http://www.commander4j.com/mw/index.php?title=Materials',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIALS'),('FRM_ADMIN_MATERIAL_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_ADD'),('FRM_ADMIN_MATERIAL_BATCH','N','Y','FORM','Maintain Material Batches',66,'batches.gif','http://www.commander4j.com/mw/index.php?title=Material_Batches',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_BATCH'),('FRM_ADMIN_MATERIAL_BATCH_ADD','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'','mod_FRM_ADMIN_MATERIAL_BATCH_ADD'),('FRM_ADMIN_MATERIAL_BATCH_EDIT','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_BATCH_EDIT'),('FRM_ADMIN_MATERIAL_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_DELETE'),('FRM_ADMIN_MATERIAL_EDIT','N','Y','FUNCTION',NULL,0,NULL,'http://www.commander4j.com/mw/index.php?title=Material_Batches',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_EDIT'),('FRM_ADMIN_MATERIAL_LOCATION','','Y','FORM','Maintain Material Locations',0,'materials.gif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','mod_FRM_ADMIN_MATERIAL_LOCATION'),('FRM_ADMIN_MATERIAL_LOCATION_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'',NULL),('FRM_ADMIN_MATERIAL_LOCATION_EDIT','','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('FRM_ADMIN_MATERIAL_TYPE','N','Y','FORM','Material Types',84,'types.gif','http://www.commander4j.com/mw/index.php?title=Material_Types',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_TYPE'),('FRM_ADMIN_MATERIAL_TYPE_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_TYPE_ADD'),('FRM_ADMIN_MATERIAL_TYPE_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_TYPE_DELETE'),('FRM_ADMIN_MATERIAL_TYPE_EDIT','N','Y','FUNCTION','Add or Update a Material Type',0,NULL,'{base_dir}helphtmlcommander4jdataMaintenanceMaterialTypesMaterialTypesDelete.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_TYPE_EDIT'),('FRM_ADMIN_MATERIAL_TYPE_PRINT','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_TYPE_PRINT'),('FRM_ADMIN_MATERIAL_TYPE_RENAME','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_TYPE_RENAME'),('FRM_ADMIN_MATERIAL_UOM','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4jdataMaintenanceUOMsUomAdmin.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_UOM'),('FRM_ADMIN_MATERIAL_UOM_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_UOM_ADD'),('FRM_ADMIN_MATERIAL_UOM_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_UOM_DELETE'),('FRM_ADMIN_MATERIAL_UOM_EDIT','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4jdataMaintenanceUOMsUomAdminEdit.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MATERIAL_UOM_EDIT'),('FRM_ADMIN_MENU','N','Y','FORM','Change menu structure',97,'menustruct.gif','http://www.commander4j.com/mw/index.php?title=Menu_Maintenance',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MENU'),('FRM_ADMIN_MHN','N','Y','FORM','Administer Master Holds',0,'mhn.gif','http://www.commander4j.com/mw/index.php?title=Quality_Control','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN'),('FRM_ADMIN_MHN_ADD','N','Y','FUNCTION','',0,'','http://www.commander4j.com/mw/index.php?title=Quality_Control','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_ASSIGN','N','Y','FUNCTION','Assign SSCC to MHN',0,'','http://www.commander4j.com/mw/index.php?title=Quality_Control','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN_ASSIGN'),('FRM_ADMIN_MHN_DECISION','N','Y','FORM','mod_FRM_ADMIN_MHN_DECISION',0,'mhn.gif','http://www.commander4j.com/mw/index.php?title=Quality_Control_Decisions','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN_DECISION'),('FRM_ADMIN_MHN_DECISION_ADD','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_DECISION_ASSIGN','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_DECISION_DELETE','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_DECISION_EDIT','N','Y','FUNCTION','mod_FRM_ADMIN_MHN_EDIT',0,'','http://www.commander4j.com/mw/index.php?title=Quality_Control_Decisions','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN_DECISION_EDIT'),('FRM_ADMIN_MHN_DECISION_RENAME','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_DELETE','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_EDIT','N','Y','FUNCTION','Edit MHN',0,'','http://www.commander4j.com/mw/index.php?title=Quality_Control','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN_EDIT'),('FRM_ADMIN_MHN_REASON','N','Y','FORM','Reason Admin',0,'mhn.gif','http://www.commander4j.com/mw/index.php?title=Quality_Control_Reasons','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN_REASON'),('FRM_ADMIN_MHN_REASON_ADD','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_REASON_DELETE','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_REASON_EDIT','N','Y','FUNCTION','mod_FRM_ADMIN_REASON_EDIT',0,'','http://www.commander4j.com/mw/index.php?title=Quality_Control_Reasons','','','','Y','Y',1,'','mod_FRM_ADMIN_MHN_REASON_EDIT'),('FRM_ADMIN_MHN_REASON_RENAME','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MHN_STATUS_ASSIGN','N','Y','FUNCTION','',0,'','','','','','Y','Y',1,'',''),('FRM_ADMIN_MODULES','N','Y','FORM','Administer Modules',77,'adminmodules.gif','http://www.commander4j.com/mw/index.php?title=Modules',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MODULES'),('FRM_ADMIN_MODULE_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MODULE_ADD'),('FRM_ADMIN_MODULE_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MODULE_DELETE'),('FRM_ADMIN_MODULE_EDIT','N','Y','FUNCTION','Edit a Module',0,NULL,'http://www.commander4j.com/mw/index.php?title=Modules',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MODULE_EDIT'),('FRM_ADMIN_MODULE_RENAME','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_MODULE_RENAME'),('FRM_ADMIN_PALLETS','N','Y','FORM',NULL,80,'pallet.gif',NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLETS'),('FRM_ADMIN_PALLET_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_ADD'),('FRM_ADMIN_PALLET_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_DELETE'),('FRM_ADMIN_PALLET_EDIT','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT'),('FRM_ADMIN_PALLET_EDIT_BATCH','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_BATCH'),('FRM_ADMIN_PALLET_EDIT_LOCATION','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_LOCATION'),('FRM_ADMIN_PALLET_EDIT_MATERIAL','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_MATERIAL'),('FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_PROCESS_ORDER'),('FRM_ADMIN_PALLET_EDIT_PROD_DATE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_PROD_DATE'),('FRM_ADMIN_PALLET_EDIT_QUANTITY','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_QUANTITY'),('FRM_ADMIN_PALLET_EDIT_STATUS','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_STATUS'),('FRM_ADMIN_PALLET_EDIT_UOM','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_EDIT_UOM'),('FRM_ADMIN_PALLET_HISTORY','N','Y','FORM',NULL,0,'pallet_history.gif','http://www.commander4j.com/mw/index.php?title=Pallet_History',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_HISTORY'),('FRM_ADMIN_PALLET_PRINT','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PALLET_PRINT'),('FRM_ADMIN_PROCESS_ORDER','N','Y','FORM',NULL,79,'process_order.gif','http://www.commander4j.com/mw/index.php?title=Process_Orders',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PROCESS_ORDER'),('FRM_ADMIN_PROCESS_ORDER_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PROCESS_ORDER_ADD'),('FRM_ADMIN_PROCESS_ORDER_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PROCESS_ORDER_DELETE'),('FRM_ADMIN_PROCESS_ORDER_EDIT','N','Y','FUNCTION','Create and update Process Orders',0,NULL,'http://www.commander4j.com/mw/index.php?title=Process_Orders',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_PROCESS_ORDER_EDIT'),('FRM_ADMIN_QM_DICTIONARY','N','Y','FORM','Activity Properties',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_QM_DICTIONARY'),('FRM_ADMIN_QM_INSPECTION','N','Y','FORM','Inspection Admin',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_QM_INSPECTION'),('FRM_ADMIN_QM_SELECTLIST','N','Y','FORM','Selection List Admin',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_QM_SELECTLIST'),('FRM_ADMIN_RF_MENU','N','Y','FORM','Change the Toolbar contents',84,'rf_menu.gif','http://www.commander4j.com/mw/index.php?title=RF_Menu_Maintenance',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_RF_MENU'),('FRM_ADMIN_TOOLBAR','N','Y','FORM','Change the Toolbar contents',84,'toolbar.gif','http://www.commander4j.com/mw/index.php?title=Toolbar_Maintenance',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_TOOLBAR'),('FRM_ADMIN_UOM','N','Y','FORM','Setup standard UOM\'s',85,'units.gif','http://www.commander4j.com/mw/index.php?title=Units_of_Measure',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_UOM'),('FRM_ADMIN_UOM_ADD','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4jdataMaintenanceUOMsUomAdminAdd.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_UOM_ADD'),('FRM_ADMIN_UOM_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_UOM_DELETE'),('FRM_ADMIN_UOM_EDIT','N','Y','FUNCTION',NULL,0,NULL,'http://www.commander4j.com/mw/index.php?title=Units_of_Measure',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_UOM_EDIT'),('FRM_ADMIN_UOM_PRINT','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_UOM_PRINT'),('FRM_ADMIN_UOM_RENAME','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_UOM_RENAME'),('FRM_ADMIN_USERS','N','Y','FORM','Administer User Accounts',85,'adminusers.gif','http://www.commander4j.com/mw/index.php?title=Users',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_USERS'),('FRM_ADMIN_USER_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_USER_ADD'),('FRM_ADMIN_USER_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_USER_DELETE'),('FRM_ADMIN_USER_EDIT','N','Y','FUNCTION','Edit User Details',0,NULL,'http://www.commander4j.com/mw/index.php?title=Users',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_USER_EDIT'),('FRM_ADMIN_USER_PERM','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4japplicationadministrationPermissionsUsersUserAdminPermissions.htm',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_USER_PERM'),('FRM_ADMIN_USER_RENAME','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_ADMIN_USER_RENAME'),('FRM_CM_PRINTERS','Y','Y','FORM','Select default printer for reports.',68,'print.gif',NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_CM_PRINTERS'),('FRM_PAL_DELETE','Y','N','FORM','Delete Pallet',77,'split.gif','','','','','Y','N',1,'','mod_FRM_ADMIN_PALLET_DELETE'),('FRM_PAL_INFO','Y','N','FORM',NULL,0,NULL,NULL,'',NULL,NULL,'N','N',1,'','mod_FRM_PAL_INFO'),('FRM_PAL_LABEL_COPIES','Y','N','FORM',NULL,0,NULL,NULL,'',NULL,NULL,'N','N',1,'','mod_FRM_PAL_LABEL_COPIES'),('FRM_PAL_PROD_CONFIRM','Y','Y','FORM',NULL,0,'ok.gif','http://www.commander4j.com/mw/index.php?title=Production_Confirmation',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_PAL_PROD_CONFIRM'),('FRM_PAL_PROD_DEC','N','Y','FORM',NULL,0,'scanner.gif','http://www.commander4j.com/mw/index.php?title=Production_Declaration',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_PAL_PROD_DEC'),('FRM_PAL_SPLIT','N','Y','FORM','Split Pallet',77,'split.gif','','','','','Y','N',1,'','mod_FRM_PAL_SPLIT'),('FRM_PROCESS_ORDER_LABEL','Y','N','FORM',NULL,0,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,'','mod_FRM_PROCESS_ORDER_LABEL'),('FRM_PRODDEC_CONFIRM','N','Y','FUNCTION','',0,'','','','','','Y','N',1,'','mod_FRM_PRODDEC_CONFIRM'),('FRM_PRODDEC_PREVIEW','N','Y','FUNCTION','',0,'','','','','','Y','N',1,'','mod_FRM_PRODDEC_PREVIEW'),('FRM_PRODDEC_PRINT','N','Y','FUNCTION','',0,'','','','','','Y','N',1,'','mod_FRM_PRODDEC_PRINT'),('FRM_PRODDEC_REPRINT','Y','N','FUNCTION',NULL,0,NULL,NULL,'',NULL,NULL,'N','N',1,'','btn_Re_Print'),('FRM_QM_ACTIVITY','N','Y','FORM','Activity Properties',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_ACTIVITY'),('FRM_QM_DICTIONARY','N','Y','FORM','Activity Properties',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_DICTIONARY'),('FRM_QM_INSPECTION','N','Y','FORM','Inspection Properties',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_INSPECTION'),('FRM_QM_RESULT_ENQUIRY','N','Y','FORM','Results Enquiries',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_RESULT_ENQUIRY'),('FRM_QM_SAMPLE_EDIT','N','Y','FORM','Edit Sample',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_SAMPLE_EDIT'),('FRM_QM_SAMPLE_LABEL','N','Y','FORM','Print Sample Labels',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_SAMPLE_LABEL'),('FRM_QM_SAMPLE_RESULTS','N','Y','FORM','Enter Sample Results',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_SAMPLE_RESULTS'),('FRM_QM_SELECTLIST','N','Y','FORM','Selection List Properties',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_SELECTLIST'),('FRM_QM_TEST','N','Y','FORM','Test Properties',77,'qm.gif','','','','','Y','N',1,'','mod_FRM_QM_TEST'),('FRM_SYSTEM_KEYS','N','Y','FORM','Maintain System Keys',0,'settings.gif','http://www.commander4j.com/mw/index.php?title=System_Keys',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_SYSTEM_KEYS'),('FRM_SYSTEM_KEYS_ADD','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_SYSTEM_KEYS_ADD'),('FRM_SYSTEM_KEYS_DELETE','N','Y','FUNCTION',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_FRM_SYSTEM_KEYS_DELETE'),('FRM_SYSTEM_KEYS_EDIT','N','Y','FUNCTION',NULL,0,NULL,'{base_dir}helphtmlcommander4japplicationadministrationSetupSystemKeysSystemKeyAdmin.html',NULL,NULL,NULL,'Y','N',1,'','mod_FRM_SYSTEM_KEYS_EDIT'),('MENU_ADMIN','N','Y','MENU',NULL,65,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_ADMIN'),('MENU_CUSTOMISE','N','Y','MENU','Customise Application',67,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_CUSTOMISE'),('MENU_DATA_MAINT','N','Y','MENU',NULL,68,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_DATA_MAINT'),('MENU_INTERFACE','N','Y','MENU','',65,'','','','','','Y','N',1,'','mod_MENU_INTERFACE'),('MENU_MHN','N','Y','MENU','mod_MENU_MHN',0,'','','','','','Y','Y',1,'','mod_MENU_MHN'),('MENU_PAL','N','Y','MENU',NULL,71,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_PAL'),('MENU_PAL_REPORTS','N','Y','MENU',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_PAL_REPORTS'),('MENU_PERMISSIONS','N','Y','MENU',NULL,80,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_PERMISSIONS'),('MENU_QM','N','Y','MENU',NULL,65,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_QM'),('MENU_SETUP','N','Y','MENU',NULL,83,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_SETUP'),('MENU_TOOLS','N','Y','MENU',NULL,84,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_MENU_TOOLS'),('root','N','Y','MENU',NULL,0,NULL,NULL,NULL,NULL,NULL,'Y','N',1,'','mod_root'),('RPT_CONTROL','N','Y','REPORT',NULL,0,NULL,NULL,'control.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_CONTROL'),('RPT_CUSTOMER','N','Y','REPORT',NULL,0,NULL,NULL,'customers.jrxml',NULL,NULL,'Y','N',1,NULL,'lbl_Customer_Admin'),('RPT_DECISIONS','N','Y','REPORT','',0,'','','decisions.jrxml','','','Y','Y',1,'Standard',''),('RPT_DESPATCH','N','Y','REPORT',NULL,0,NULL,NULL,'Despatch.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_DESPATCH'),('RPT_DESPATCH_SERVICE','N','Y','REPORT',NULL,0,NULL,NULL,'Despatch.jrxml',NULL,NULL,'N','N',1,'',NULL),('RPT_GROUPS','N','Y','REPORT',NULL,0,NULL,NULL,'groups.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_GROUPS'),('RPT_HIST_SUMMARY','N','Y','REPORT',NULL,0,NULL,NULL,'ProductionSummary.jrxml',NULL,NULL,'Y','N',1,'',NULL),('RPT_LOCATIONS','N','Y','REPORT',NULL,0,NULL,NULL,'locations.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_LOCATIONS'),('RPT_MATERIALS','N','Y','REPORT',NULL,0,NULL,NULL,'materials.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_MATERIALS'),('RPT_MATERIAL_UOM','N','Y','REPORT',NULL,0,NULL,NULL,'material_uom.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_MATERIAL_UOM'),('RPT_MHN','N','Y','REPORT','',0,'','','MHN.jrxml','','','Y','Y',1,'Standard',''),('RPT_MHNS','N','Y','REPORT','',0,'','','MHN_List.jrxml','','','Y','Y',1,'Standard',''),('RPT_MODULES','N','Y','REPORT',NULL,0,NULL,NULL,'modules.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_MODULES'),('RPT_PALLETS','N','Y','REPORT',NULL,0,NULL,NULL,'pallets.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_PALLETS'),('RPT_PALLET_HISTORY','N','Y','REPORT',NULL,0,NULL,NULL,'pallet_history.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_PALLET_HISTORY'),('RPT_PALLET_LABEL','N','Y','REPORT',NULL,0,NULL,NULL,'pallet_a4_x2.jrxml',NULL,NULL,NULL,NULL,NULL,'Standard','mod_RPT_PALLET_LABEL'),('RPT_PAL_SUMMARY','N','Y','REPORT',NULL,0,NULL,NULL,'ProductionSummary2.jrxml',NULL,NULL,'Y','N',1,'',NULL),('RPT_PROCESS_ORDERS','N','Y','REPORT',NULL,0,NULL,NULL,'process_orders.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_PROCESS_ORDERS'),('RPT_PROCESS_ORDER_LABEL','N','Y','REPORT','',0,NULL,NULL,'Zebra_Process_Order.lbl','','','Y','N',1,'Label','mod_FRM_PROCESS_ORDER_LABEL'),('RPT_REASONS','N','Y','REPORT','',0,'','','reasons.jrxml','','','Y','Y',1,'Standard',''),('RPT_SAMPLE_LABEL','N','Y','REPORT','Sample Label Print',0,'','','Sample_Label_200dpi.lbl','','','Y','N',1,'Label','mod_FRM_QM_SAMPLE_LABEL'),('RPT_SAMPLE_LABEL_200','N','Y','REPORT','Sample Label Print',0,'','','Sample_Label_200dpi.lbl','','','Y','N',1,'Label','mod_FRM_QM_SAMPLE_LABEL'),('RPT_SAMPLE_LABEL_300','N','Y','REPORT','Sample Label Print',0,'','','Sample_Label_300dpi.lbl','','','Y','N',1,'Label','mod_FRM_QM_SAMPLE_LABEL'),('RPT_TYPES','N','Y','REPORT',NULL,0,NULL,NULL,'types.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_TYPES'),('RPT_UNITS','N','Y','REPORT',NULL,0,NULL,NULL,'units.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_UNITS'),('RPT_USERS','N','Y','REPORT',NULL,0,NULL,NULL,'users.jrxml',NULL,NULL,'Y','N',1,'Standard','mod_RPT_USERS'); /*!40000 ALTER TABLE `SYS_MODULES` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_REPORT_REQUEST` -- DROP TABLE IF EXISTS `SYS_REPORT_REQUEST`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_REPORT_REQUEST` ( `REPORT_REQUEST_ID` decimal(22,0) NOT NULL, `MODULE_ID` varchar(35) DEFAULT NULL, `INVOCATION_MODE` varchar(35) DEFAULT NULL, `PARAMETER_COUNT` int(10) unsigned zerofill DEFAULT NULL, `PARAMETER_DELIMITER` varchar(1) DEFAULT NULL, `PARAMETER_NAMES` varchar(250) DEFAULT NULL, `PARAMETER_TYPES` varchar(250) DEFAULT NULL, `PARAMETER_VALUES` varchar(250) DEFAULT NULL, `SQL` varchar(2000) DEFAULT NULL, `PRINT_QUEUE_NAME` varchar(250) DEFAULT NULL, `PRINT_COPIES` int(10) unsigned zerofill DEFAULT NULL, PRIMARY KEY (`REPORT_REQUEST_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_REPORT_REQUEST` -- LOCK TABLES `SYS_REPORT_REQUEST` WRITE; /*!40000 ALTER TABLE `SYS_REPORT_REQUEST` DISABLE KEYS */; /*!40000 ALTER TABLE `SYS_REPORT_REQUEST` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_RF_MENU` -- DROP TABLE IF EXISTS `SYS_RF_MENU`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_RF_MENU` ( `MODULE_ID` varchar(35) NOT NULL DEFAULT '', `SEQUENCE_ID` decimal(22,0) NOT NULL DEFAULT '0', PRIMARY KEY (`MODULE_ID`,`SEQUENCE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_RF_MENU` -- LOCK TABLES `SYS_RF_MENU` WRITE; /*!40000 ALTER TABLE `SYS_RF_MENU` DISABLE KEYS */; INSERT INTO `SYS_RF_MENU` VALUES ('FRM_ADMIN_DESPATCH',2),('FRM_CM_PRINTERS',4),('FRM_PAL_DELETE',3),('FRM_PAL_INFO',3),('FRM_PAL_PROD_CONFIRM',1); /*!40000 ALTER TABLE `SYS_RF_MENU` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_TOOLBAR` -- DROP TABLE IF EXISTS `SYS_TOOLBAR`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_TOOLBAR` ( `MODULE_ID` varchar(35) NOT NULL, `SEQUENCE_ID` decimal(22,0) NOT NULL, PRIMARY KEY (`MODULE_ID`,`SEQUENCE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_TOOLBAR` -- LOCK TABLES `SYS_TOOLBAR` WRITE; /*!40000 ALTER TABLE `SYS_TOOLBAR` DISABLE KEYS */; INSERT INTO `SYS_TOOLBAR` VALUES ('FRM_ADMIN_CUSTOMER',6),('FRM_ADMIN_DESPATCH',14),('FRM_ADMIN_GROUPS',1),('FRM_ADMIN_INTERFACE_PROCESS',17),('FRM_ADMIN_LOCATIONS',10),('FRM_ADMIN_MATERIALS',7),('FRM_ADMIN_MATERIAL_BATCH',9),('FRM_ADMIN_MATERIAL_TYPE',8),('FRM_ADMIN_MENU',4),('FRM_ADMIN_MHN',20),('FRM_ADMIN_MODULES',2),('FRM_ADMIN_PALLETS',12),('FRM_ADMIN_PALLET_HISTORY',13),('FRM_ADMIN_PROCESS_ORDER',11),('FRM_ADMIN_TOOLBAR',5),('FRM_ADMIN_UOM',6),('FRM_ADMIN_USERS',0),('FRM_CM_PRINTERS',18),('FRM_PAL_PROD_CONFIRM',16),('FRM_PAL_PROD_DEC',15),('FRM_SYSTEM_KEYS',3); /*!40000 ALTER TABLE `SYS_TOOLBAR` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_USERS` -- DROP TABLE IF EXISTS `SYS_USERS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_USERS` ( `USER_ID` varchar(20) NOT NULL DEFAULT '', `PASSWORD` varchar(10) DEFAULT NULL, `LANGUAGE_ID` varchar(2) DEFAULT 'EN', `USER_COMMENT` varchar(40) DEFAULT NULL, `LAST_LOGON` datetime DEFAULT NULL, `LAST_PASSWORD_CHANGE` datetime DEFAULT NULL, `ACCOUNT_LOCKED` varchar(1) DEFAULT 'N', `PASSWORD_EXPIRES` varchar(1) DEFAULT 'Y', `PASSWORD_CHANGE_ALLOWED` varchar(1) DEFAULT 'Y', `BAD_PASSWORD_ATTEMPTS` decimal(22,0) DEFAULT '0', `ACCOUNT_EXPIRES` varchar(1) DEFAULT 'N', `ACCOUNT_EXPIRY_DATE` datetime DEFAULT NULL, `EMAIL_ADDRESS` varchar(45) DEFAULT NULL, `APP_VERSION` varchar(10) DEFAULT NULL, PRIMARY KEY (`USER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_USERS` -- LOCK TABLES `SYS_USERS` WRITE; /*!40000 ALTER TABLE `SYS_USERS` DISABLE KEYS */; INSERT INTO `SYS_USERS` VALUES ('ADMIN','password','EN','Administrator','2005-09-01 20:34:49','2005-01-05 19:16:51','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('BUDDYJ','*','EN','Beagle','2006-02-25 18:41:20','2006-02-25 12:37:26','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('CHANDRAE','ADMIN','EN','Dave Garratt','2005-02-07 13:57:22','2004-12-29 18:34:34','N','N','Y',0,'N','2005-10-01 00:00:00','',NULL),('DAVID','*','EN','David Garratt','2009-10-11 20:06:37','2006-03-05 16:08:53','N','N','Y',0,'N','2005-06-29 20:25:00','',NULL),('DREADJ','password','EN',NULL,NULL,'2005-01-11 19:40:36','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('FOGELK','password','EN','Generic User',NULL,'2005-01-08 16:58:48','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('FRED','password','EN','Fred',NULL,'2007-09-06 19:47:17','N','Y','Y',0,'N','2007-09-06 19:47:17','',NULL),('GOODMANB','PASS','EN','Tim','2005-02-13 21:23:13','2005-02-13 15:51:51','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('HANNAC','password','EN','',NULL,'2005-01-11 19:40:47','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('HORTONI','*','EN','Mandy','2005-08-13 20:43:03','2005-08-12 14:18:57','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('INTERFACE','INTERFACE','EN',NULL,NULL,NULL,'N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('JOHNSONA','*','EN','Debbie','2005-04-05 22:41:25','2005-04-05 22:41:09','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('LEWISD','password','EN',NULL,'2005-08-09 19:33:21','2005-01-11 19:37:47','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('MANDY','*','EN','','2009-06-02 13:04:35','2009-05-29 12:37:45','N','Y','Y',0,'N',NULL,'',NULL),('OKUDAD','password','EN','Ivan',NULL,'2005-01-11 19:41:58','Y','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('OREILLYW','*','EN',NULL,'2005-09-22 20:18:26','2005-09-22 20:17:26','N','Y','Y',0,'Y','2005-07-16 17:13:00','',NULL),('ROBINSONM','password','EN',NULL,NULL,'2005-01-11 19:43:00','N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL),('YOUNGS','ADMIN','EN',NULL,NULL,NULL,'N','Y','Y',0,'N','2005-10-01 00:00:00','',NULL); /*!40000 ALTER TABLE `SYS_USERS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SYS_USER_GROUP_MEMBERSHIP` -- DROP TABLE IF EXISTS `SYS_USER_GROUP_MEMBERSHIP`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SYS_USER_GROUP_MEMBERSHIP` ( `USER_ID` varchar(20) NOT NULL DEFAULT '', `GROUP_ID` varchar(20) NOT NULL, PRIMARY KEY (`USER_ID`,`GROUP_ID`), UNIQUE KEY `user_group_membership_pk` (`USER_ID`,`GROUP_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SYS_USER_GROUP_MEMBERSHIP` -- LOCK TABLES `SYS_USER_GROUP_MEMBERSHIP` WRITE; /*!40000 ALTER TABLE `SYS_USER_GROUP_MEMBERSHIP` DISABLE KEYS */; INSERT INTO `SYS_USER_GROUP_MEMBERSHIP` VALUES ('ADMIN','ADMIN'),('ADMIN','INTERFACE'),('ADMIN','MHN'),('ADMIN','PALLET'),('ADMIN','PUBLIC'),('BUDDYJ','PUBLIC'),('CHANDRAE','ADMIN'),('CHANDRAE','PALLET'),('CHANDRAE','PUBLIC'),('DAVID','ADMIN'),('DAVID','CUSTOMER'),('DAVID','INTERFACE'),('DAVID','MHN'),('DAVID','PALLET'),('DAVID','PUBLIC'),('DAVID','REPORT_DESIGN'),('DAVID','TOOLS'),('DREADJ','ADMIN'),('DREADJ','PALLET'),('DREADJ','PUBLIC'),('FOGELK','PALLET'),('FOGELK','PUBLIC'),('FRED','PALLET'),('FRED','PUBLIC'),('GOODMANB','ADMIN'),('GOODMANB','PALLET'),('GOODMANB','PUBLIC'),('HANNAC','PUBLIC'),('HORTONI','ADMIN'),('HORTONI','PALLET'),('HORTONI','PUBLIC'),('JOHNSONA','PALLET'),('JOHNSONA','PUBLIC'),('LEWISD','PALLET'),('LEWISD','PUBLIC'),('MANDY','PALLET'),('MANDY','PUBLIC'),('OKUDAD','PALLET'),('OKUDAD','PUBLIC'),('OREILLYW','PUBLIC'),('ROBINSONM','ADMIN'),('ROBINSONM','PALLET'),('ROBINSONM','PUBLIC'),('YOUNGS','ADMIN'),('YOUNGS','PALLET'),('YOUNGS','PUBLIC'); /*!40000 ALTER TABLE `SYS_USER_GROUP_MEMBERSHIP` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `view_auto_labeller` -- DROP TABLE IF EXISTS `view_auto_labeller`; /*!50001 DROP VIEW IF EXISTS `view_auto_labeller`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `view_auto_labeller` ( `LINE` varchar(20), `PROCESS_ORDER` varchar(10), `STATUS` varchar(20), `MATERIAL` varchar(20), `REQUIRED_UOM` varchar(10), `MATERIAL_TYPE` varchar(5), `DESCRIPTION` varchar(80), `EAN` varchar(14), `VARIANT` varchar(2), `OLD_MATERIAL` varchar(20), `SHELF_LIFE` decimal(22,0), `SHELF_LIFE_UOM` varchar(1), `SHELF_LIFE_RULE` varchar(1), `CUSTOMER_ID` varchar(20), `CUSTOMER_NAME` varchar(50), `MATERIAL_UPDATED` datetime, `PROCESS_ORDER_UPDATED` datetime, `BATCH_NUMBER` varchar(100), `EXPIRY_DATE` datetime, `DEFAULT_LAYERS` int(11), `DEFAULT_QUANTITY` decimal(22,3) ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `view_auto_labeller_full` -- DROP TABLE IF EXISTS `view_auto_labeller_full`; /*!50001 DROP VIEW IF EXISTS `view_auto_labeller_full`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `view_auto_labeller_full` ( `PROCESS_ORDER` varchar(10), `STATUS` varchar(20), `MATERIAL` varchar(20), `REQUIRED_UOM` varchar(10), `MATERIAL_TYPE` varchar(5), `DESCRIPTION` varchar(80), `EAN` varchar(14), `VARIANT` varchar(2), `OLD_MATERIAL` varchar(20), `SHELF_LIFE` decimal(22,0), `SHELF_LIFE_UOM` varchar(1), `SHELF_LIFE_RULE` varchar(1), `CUSTOMER_ID` varchar(20), `CUSTOMER_NAME` varchar(50), `MATERIAL_UPDATED` datetime, `PROCESS_ORDER_UPDATED` datetime, `BATCH_NUMBER` varchar(100), `EXPIRY_DATE` datetime, `DEFAULT_LAYERS` int(11), `DEFAULT_QUANTITY` decimal(22,3) ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `view_pallet_expiry` -- DROP TABLE IF EXISTS `view_pallet_expiry`; /*!50001 DROP VIEW IF EXISTS `view_pallet_expiry`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `view_pallet_expiry` ( `SSCC` varchar(18), `LOCATION_ID` varchar(15), `MATERIAL` varchar(20), `BATCH_NUMBER` varchar(12), `PROCESS_ORDER` varchar(10), `QUANTITY` decimal(22,3), `UOM` varchar(10), `DATE_OF_MANUFACTURE` datetime, `STATUS` varchar(20), `EAN` varchar(14), `VARIANT` varchar(2), `DESPATCH_NO` varchar(10), `CONFIRMED` varchar(1), `LAYERS` int(11), `SSCC_EXPIRY_DATE` datetime, `CUSTOMER_ID` varchar(20), `MHN_NUMBER` varchar(10), `DECISION` varchar(10), `EXPIRY_DATE` datetime, `DESCRIPTION` varchar(80), `OLD_MATERIAL` varchar(20), `CUSTOMER_NAME` varchar(50), `PRINT_ON_LABEL` varchar(1), `DATE_CREATED` datetime, `CREATED_BY_USER_ID` varchar(20), `DATE_UPDATED` datetime, `UPDATED_BY_USER_ID` varchar(20), `GROSS_WEIGHT` decimal(22,3), `NET_WEIGHT` decimal(22,3), `WEIGHT_UOM` varchar(3) ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `view_qm_results` -- DROP TABLE IF EXISTS `view_qm_results`; /*!50001 DROP VIEW IF EXISTS `view_qm_results`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `view_qm_results` ( `PROCESS_ORDER` varchar(10), `MATERIAL` varchar(20), `SAMPLE_ID` int(11), `INSPECTION_ID` varchar(20), `ACTIVITY_ID` varchar(10), `SAMPLE_DATE` datetime, `USER_DATA_1` varchar(20), `USER_DATA_2` varchar(20), `TEST_ID` varchar(50), `TEST_DESCRIPTION` varchar(50), `VALUE` varchar(50), `RESULT` varchar(50) ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Dumping routines for database 'test' -- /*!50003 DROP FUNCTION IF EXISTS `c4j_GetBaseQuantity` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetBaseQuantity`(XMATERIAL varchar(20),XPRODUCTION_QUANTITY decimal(22,3),XPRODUCTION_UOM varchar(3)) RETURNS decimal(22,3) BEGIN DECLARE XBASE_UOM varchar(3); DECLARE XBASE_QUANTITY decimal(22,3); SET XBASE_UOM = (SELECT BASE_UOM FROM APP_MATERIAL WHERE MATERIAL = XMATERIAL); SET XBASE_QUANTITY = (SELECT (XPRODUCTION_QUANTITY * NUMERATOR / DENOMINATOR) FROM APP_MATERIAL_UOM WHERE MATERIAL = XMATERIAL AND UOM = XPRODUCTION_UOM); RETURN XBASE_QUANTITY; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetControlValue` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetControlValue`(XNAME varchar(50)) RETURNS varchar(50) CHARSET utf8 BEGIN DECLARE result varchar(50); SET result = (SELECT key_value FROM SYS_CONTROL where system_key = XNAME); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetDay` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetDay`(XDATE datetime) RETURNS varchar(2) CHARSET utf8 BEGIN DECLARE result varchar(2); DECLARE dom int; SET dom = DAYOFMONTH(XDATE); SET result = RIGHT(CONCAT('0',convert(dom,CHAR)),2); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetExpiryDate` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetExpiryDate`(XPRODUCTION_DATE datetime,XSHELF_LIFE int,XSHELF_LIFE_UOM varchar(1),XSHELF_LIFE_ROUNDING varchar(1)) RETURNS datetime BEGIN DECLARE result datetime; SET result = XPRODUCTION_DATE; IF XSHELF_LIFE_UOM = 'D' THEN SET result = DATE_ADD(result,INTERVAL XSHELF_LIFE DAY); END IF; IF XSHELF_LIFE_UOM = 'M' THEN SET result = DATE_ADD(result,INTERVAL XSHELF_LIFE MONTH); END IF; IF XSHELF_LIFE_UOM = 'Y' THEN SET result = DATE_ADD(result,INTERVAL XSHELF_LIFE YEAR); END IF; IF XSHELF_LIFE_ROUNDING = '+' THEN SET result = LAST_DAY(result); END IF; IF XSHELF_LIFE_ROUNDING = '-' THEN SET result = ADDDATE(LAST_DAY(SUBDATE(result, INTERVAL 1 MONTH)), 1); END IF; SET result = DATE(result); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetFinalBatchNumber` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetFinalBatchNumber`(XPRODUCTION_DATE datetime,XOVERRIDE_BATCH varchar(1),XOVERRIDE_BATCH_NUMBER varchar(40),XBATCH_OPTIONAL varchar(40)) RETURNS varchar(100) CHARSET utf8 BEGIN DECLARE result varchar(100); DECLARE batchformat varchar(100); IF XOVERRIDE_BATCH = 'Y' THEN SET result = XOVERRIDE_BATCH_NUMBER; END IF; IF XOVERRIDE_BATCH = 'N' THEN SET batchformat = c4j_GetControlValue('BATCH FORMAT'); SET result = batchformat; SET result = REPLACE(result,'{PLANT}',c4j_GetPlant()); SET result = REPLACE(result,'{YEAR4}',c4j_GetYear(XPRODUCTION_DATE,4)); SET result = REPLACE(result,'{YEAR2}',c4j_GetYear(XPRODUCTION_DATE,2)); SET result = REPLACE(result,'{YEAR1}',c4j_GetYear(XPRODUCTION_DATE,1)); SET result = REPLACE(result,'{MONTH}',c4j_GetMonth(XPRODUCTION_DATE)); SET result = REPLACE(result,'{DAY}',c4j_GetDay(XPRODUCTION_DATE)); SET result = REPLACE(result,'{JULIAN_DAY}',c4j_GetJulian(XPRODUCTION_DATE,1)); SET result = REPLACE(result,'{JULIAN0_DAY}',c4j_GetJulian(XPRODUCTION_DATE,0)); SET result = REPLACE(result,'{JULIAN1_DAY}',c4j_GetJulian(XPRODUCTION_DATE,1)); END IF; SET result = CONCAT(result,XBATCH_OPTIONAL); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetFinalExpiryDate` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetFinalExpiryDate`(XPRODUCTION_DATE datetime,XSHELF_LIFE int,XSHELF_LIFE_UOM varchar(1),XSHELF_LIFE_ROUNDING varchar(1),XOVERRIDE_EXPIRY varchar(1),XOVERRIDE_EXPIRY_DATE datetime) RETURNS datetime BEGIN DECLARE result datetime; IF XOVERRIDE_EXPIRY = 'Y' THEN SET result = XOVERRIDE_EXPIRY_DATE; END IF; IF XOVERRIDE_EXPIRY = 'N' THEN SET result = c4j_GetExpiryDate(XPRODUCTION_DATE,XSHELF_LIFE,XSHELF_LIFE_UOM,XSHELF_LIFE_ROUNDING); END IF; RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetFullPalletQuantity` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetFullPalletQuantity`(XPROCESS_ORDER varchar(40)) RETURNS decimal(22,3) BEGIN DECLARE result decimal(22,3); DECLARE xmaterial varchar(40); DECLARE xpal_uom varchar(3); DECLARE xpal_numerator decimal(22,3); DECLARE xpal_denominator decimal(22,3); DECLARE xrequired_uom varchar(3); DECLARE xrequired_denominator decimal(22,3); DECLARE xrequired_numerator decimal(22,3); SET xpal_uom = c4j_GetControlValue('UOM FULL PALLET QTY'); SET xrequired_uom = (SELECT REQUIRED_UOM FROM APP_PROCESS_ORDER WHERE PROCESS_ORDER = XPROCESS_ORDER); SET xmaterial = (SELECT MATERIAL FROM APP_PROCESS_ORDER WHERE PROCESS_ORDER = XPROCESS_ORDER); SET xrequired_denominator = (SELECT DENOMINATOR FROM APP_MATERIAL_UOM WHERE MATERIAL = xmaterial and UOM = xrequired_uom); SET xrequired_numerator = (SELECT NUMERATOR FROM APP_MATERIAL_UOM WHERE MATERIAL = xmaterial and UOM = xrequired_uom); SET xpal_denominator = (SELECT DENOMINATOR FROM APP_MATERIAL_UOM WHERE MATERIAL = xmaterial and UOM = xpal_uom); SET xpal_numerator = (SELECT NUMERATOR FROM APP_MATERIAL_UOM WHERE MATERIAL = xmaterial and UOM = xpal_uom); SET result = (xpal_numerator/xpal_denominator) * (xrequired_denominator/xrequired_numerator); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetJulian` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetJulian`(XDATE datetime,XOFFSET int) RETURNS varchar(6) CHARSET utf8 BEGIN DECLARE result VARCHAR(6); DECLARE dayofyear int; SET dayofyear = DAYOFYEAR(XDATE)-1+XOFFSET; SET result = RIGHT(CONCAT('000',convert(dayofyear,CHAR)),3); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetLayers` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetLayers`(XPROCESS_ORDER varchar(20)) RETURNS int(11) BEGIN DECLARE result int; DECLARE xlayers_uom varchar(3); DECLARE xpallet_uom varchar(3); DECLARE xbase_quantity decimal(22,3); DECLARE xmaterial varchar(20); DECLARE xproduction_uom varchar(3); DECLARE xproduction_quantity decimal(22,3); SET xproduction_quantity = c4j_GetFullPalletQuantity(XPROCESS_ORDER); SET xmaterial = (SELECT MATERIAL FROM APP_PROCESS_ORDER WHERE PROCESS_ORDER = XPROCESS_ORDER); SET xproduction_uom = (SELECT REQUIRED_UOM FROM APP_PROCESS_ORDER WHERE PROCESS_ORDER = XPROCESS_ORDER); SET xbase_quantity = c4j_GetBaseQuantity(XMATERIAL,XPRODUCTION_QUANTITY,XPRODUCTION_UOM); SET xlayers_uom = c4j_GetControlValue('UOM BASE QTY PER LAYER'); SET result = (SELECT (xbase_quantity / NUMERATOR * DENOMINATOR) FROM APP_MATERIAL_UOM WHERE MATERIAL = xmaterial AND UOM = xlayers_uom); SET result = CEILING(result); SET result = COALESCE(result,1); IF result = 0 THEN SET result = 1; END IF; RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetMonth` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetMonth`(XDATE datetime) RETURNS varchar(2) CHARSET utf8 BEGIN DECLARE result varchar(6); DECLARE moy int; SET moy = MONTH(XDATE); SET result = RIGHT(CONCAT('0',convert(moy,CHAR)),2); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetPlant` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetPlant`() RETURNS varchar(10) CHARSET utf8 BEGIN DECLARE result varchar(10); SET result = c4j_GetControlValue('PLANT'); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP FUNCTION IF EXISTS `c4j_GetYear` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = latin1 */ ; /*!50003 SET character_set_results = latin1 */ ; /*!50003 SET collation_connection = latin1_swedish_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`testuser`@`localhost`*/ /*!50003 FUNCTION `c4j_GetYear`(XDATE datetime,XSIZE int) RETURNS int(11) BEGIN DECLARE result varchar(4); SET result = RIGHT(CAST(YEAR(XDATE) AS CHAR(4)) ,XSIZE); RETURN result; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Final view structure for view `view_auto_labeller` -- /*!50001 DROP TABLE IF EXISTS `view_auto_labeller`*/; /*!50001 DROP VIEW IF EXISTS `view_auto_labeller`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`testuser`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `view_auto_labeller` AS select `AL`.`LINE` AS `LINE`,`AL`.`PROCESS_ORDER` AS `PROCESS_ORDER`,`PO`.`STATUS` AS `STATUS`,`PO`.`MATERIAL` AS `MATERIAL`,`PO`.`REQUIRED_UOM` AS `REQUIRED_UOM`,`MAT`.`MATERIAL_TYPE` AS `MATERIAL_TYPE`,`MAT`.`DESCRIPTION` AS `DESCRIPTION`,right(concat('00000000000000',`MATUOM`.`EAN`),14) AS `EAN`,right(concat('00',`MATUOM`.`VARIANT`),2) AS `VARIANT`,`MAT`.`OLD_MATERIAL` AS `OLD_MATERIAL`,`MAT`.`SHELF_LIFE` AS `SHELF_LIFE`,`MAT`.`SHELF_LIFE_UOM` AS `SHELF_LIFE_UOM`,`MAT`.`SHELF_LIFE_RULE` AS `SHELF_LIFE_RULE`,`PO`.`CUSTOMER_ID` AS `CUSTOMER_ID`,`CUST`.`CUSTOMER_NAME` AS `CUSTOMER_NAME`,`MAT`.`UPDATED` AS `MATERIAL_UPDATED`,`PO`.`UPDATED` AS `PROCESS_ORDER_UPDATED`,`c4j_GetFinalBatchNumber`(curdate(),`AL`.`OVERRIDE_BATCH`,`AL`.`OVERRIDE_BATCH_NUMBER`,`AL`.`BATCH_OPTIONAL`) AS `BATCH_NUMBER`,`c4j_GetFinalExpiryDate`(curdate(),`MAT`.`SHELF_LIFE`,`MAT`.`SHELF_LIFE_UOM`,`MAT`.`SHELF_LIFE_RULE`,`AL`.`OVERRIDE_EXPIRY`,`AL`.`OVERRIDE_EXPIRY_DATE`) AS `EXPIRY_DATE`,`c4j_GetLayers`(`PO`.`PROCESS_ORDER`) AS `DEFAULT_LAYERS`,`c4j_GetFullPalletQuantity`(`PO`.`PROCESS_ORDER`) AS `DEFAULT_QUANTITY` from ((((`app_auto_labeller` `AL` join `app_process_order` `PO`) join `app_material` `MAT`) join `app_customer` `CUST`) join `app_material_uom` `MATUOM`) where ((`PO`.`PROCESS_ORDER` = `AL`.`PROCESS_ORDER`) and (`MAT`.`MATERIAL` = `PO`.`MATERIAL`) and (`CUST`.`CUSTOMER_ID` = `PO`.`CUSTOMER_ID`) and (`MATUOM`.`MATERIAL` = `PO`.`MATERIAL`) and (`MATUOM`.`UOM` = `PO`.`REQUIRED_UOM`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `view_auto_labeller_full` -- /*!50001 DROP TABLE IF EXISTS `view_auto_labeller_full`*/; /*!50001 DROP VIEW IF EXISTS `view_auto_labeller_full`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`testuser`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `view_auto_labeller_full` AS select `PO`.`PROCESS_ORDER` AS `PROCESS_ORDER`,`PO`.`STATUS` AS `STATUS`,`PO`.`MATERIAL` AS `MATERIAL`,`PO`.`REQUIRED_UOM` AS `REQUIRED_UOM`,`MAT`.`MATERIAL_TYPE` AS `MATERIAL_TYPE`,`MAT`.`DESCRIPTION` AS `DESCRIPTION`,right(concat('00000000000000',`MATUOM`.`EAN`),14) AS `EAN`,right(concat('00',`MATUOM`.`VARIANT`),2) AS `VARIANT`,`MAT`.`OLD_MATERIAL` AS `OLD_MATERIAL`,`MAT`.`SHELF_LIFE` AS `SHELF_LIFE`,`MAT`.`SHELF_LIFE_UOM` AS `SHELF_LIFE_UOM`,`MAT`.`SHELF_LIFE_RULE` AS `SHELF_LIFE_RULE`,`PO`.`CUSTOMER_ID` AS `CUSTOMER_ID`,`CUST`.`CUSTOMER_NAME` AS `CUSTOMER_NAME`,`MAT`.`UPDATED` AS `MATERIAL_UPDATED`,`PO`.`UPDATED` AS `PROCESS_ORDER_UPDATED`,`c4j_GetFinalBatchNumber`(curdate(),'N','N','') AS `BATCH_NUMBER`,`c4j_GetFinalExpiryDate`(curdate(),`MAT`.`SHELF_LIFE`,`MAT`.`SHELF_LIFE_UOM`,`MAT`.`SHELF_LIFE_RULE`,'N',curdate()) AS `EXPIRY_DATE`,`c4j_GetLayers`(`PO`.`PROCESS_ORDER`) AS `DEFAULT_LAYERS`,`c4j_GetFullPalletQuantity`(`PO`.`PROCESS_ORDER`) AS `DEFAULT_QUANTITY` from (((`app_process_order` `PO` join `app_material` `MAT`) join `app_customer` `CUST`) join `app_material_uom` `MATUOM`) where ((`MAT`.`MATERIAL` = `PO`.`MATERIAL`) and (`CUST`.`CUSTOMER_ID` = `PO`.`CUSTOMER_ID`) and (`MATUOM`.`MATERIAL` = `PO`.`MATERIAL`) and (`MATUOM`.`UOM` = `PO`.`REQUIRED_UOM`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `view_pallet_expiry` -- /*!50001 DROP TABLE IF EXISTS `view_pallet_expiry`*/; /*!50001 DROP VIEW IF EXISTS `view_pallet_expiry`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`testuser`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `view_pallet_expiry` AS select `p`.`SSCC` AS `SSCC`,`p`.`LOCATION_ID` AS `LOCATION_ID`,`p`.`MATERIAL` AS `MATERIAL`,`p`.`BATCH_NUMBER` AS `BATCH_NUMBER`,`p`.`PROCESS_ORDER` AS `PROCESS_ORDER`,`p`.`QUANTITY` AS `QUANTITY`,`p`.`UOM` AS `UOM`,`p`.`DATE_OF_MANUFACTURE` AS `DATE_OF_MANUFACTURE`,`p`.`STATUS` AS `STATUS`,`p`.`EAN` AS `EAN`,`p`.`VARIANT` AS `VARIANT`,`p`.`DESPATCH_NO` AS `DESPATCH_NO`,`p`.`CONFIRMED` AS `CONFIRMED`,`p`.`LAYERS` AS `LAYERS`,`p`.`SSCC_EXPIRY_DATE` AS `SSCC_EXPIRY_DATE`,`p`.`CUSTOMER_ID` AS `CUSTOMER_ID`,`p`.`MHN_NUMBER` AS `MHN_NUMBER`,`p`.`DECISION` AS `DECISION`,`b`.`EXPIRY_DATE` AS `EXPIRY_DATE`,`m`.`DESCRIPTION` AS `DESCRIPTION`,`m`.`OLD_MATERIAL` AS `OLD_MATERIAL`,`c`.`CUSTOMER_NAME` AS `CUSTOMER_NAME`,`c`.`PRINT_ON_LABEL` AS `PRINT_ON_LABEL`,`p`.`DATE_CREATED` AS `DATE_CREATED`,`p`.`CREATED_BY_USER_ID` AS `CREATED_BY_USER_ID`,`p`.`DATE_UPDATED` AS `DATE_UPDATED`,`p`.`UPDATED_BY_USER_ID` AS `UPDATED_BY_USER_ID`,`m`.`GROSS_WEIGHT` AS `GROSS_WEIGHT`,`m`.`NET_WEIGHT` AS `NET_WEIGHT`,`m`.`WEIGHT_UOM` AS `WEIGHT_UOM` from (((`app_pallet` `p` left join `app_material_batch` `b` on(((`b`.`MATERIAL` = `p`.`MATERIAL`) and (`b`.`BATCH_NUMBER` = `p`.`BATCH_NUMBER`)))) left join `app_material` `m` on((`m`.`MATERIAL` = `p`.`MATERIAL`))) left join `app_customer` `c` on((`c`.`CUSTOMER_ID` = `p`.`CUSTOMER_ID`))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `view_qm_results` -- /*!50001 DROP TABLE IF EXISTS `view_qm_results`*/; /*!50001 DROP VIEW IF EXISTS `view_qm_results`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`testuser`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `view_qm_results` AS select `samp`.`PROCESS_ORDER` AS `PROCESS_ORDER`,`samp`.`MATERIAL` AS `MATERIAL`,`samp`.`SAMPLE_ID` AS `SAMPLE_ID`,`samp`.`INSPECTION_ID` AS `INSPECTION_ID`,`samp`.`ACTIVITY_ID` AS `ACTIVITY_ID`,`samp`.`SAMPLE_DATE` AS `SAMPLE_DATE`,`samp`.`USER_DATA_1` AS `USER_DATA_1`,`samp`.`USER_DATA_2` AS `USER_DATA_2`,`result`.`TEST_ID` AS `TEST_ID`,`dict`.`DESCRIPTION` AS `TEST_DESCRIPTION`,`result`.`VALUE` AS `VALUE`,coalesce(`valist`.`DESCRIPTION`,`result`.`VALUE`) AS `RESULT` from (((`app_qm_sample` `samp` left join `app_qm_result` `result` on((`result`.`SAMPLE_ID` = `samp`.`SAMPLE_ID`))) left join `app_qm_dictionary` `dict` on((`dict`.`TEST_ID` = `result`.`TEST_ID`))) left join `app_qm_selectlist` `valist` on(((`valist`.`SELECT_LIST_ID` = `dict`.`SELECT_LIST_ID`) and (`valist`.`VALUE` = `result`.`VALUE`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2013-02-11 15:51:28