-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.1.30 /*!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 */; /*!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' */; -- -- Create schema optimus -- CREATE DATABASE IF NOT EXISTS optimus; USE optimus; -- -- Definition of table `core_parameter_master` -- DROP TABLE IF EXISTS `core_parameter_master`; CREATE TABLE `core_parameter_master` ( `parameter_id` int(10) NOT NULL AUTO_INCREMENT, `param_code` varchar(35) NOT NULL, `sequence_number` int(4) NOT NULL, `param_description` varchar(255) NOT NULL, `value_data_type` char(1) DEFAULT NULL, `value_text` varchar(255) DEFAULT NULL, `value_numeric` float(14,4) DEFAULT NULL, `value_date` date DEFAULT NULL, `editable` int(10) DEFAULT NULL, `record_deleted` int(10) DEFAULT NULL, `effective_date_from` date DEFAULT NULL, `effective_date_to` date DEFAULT NULL, `created_by` varchar(15) NOT NULL, `created_date` datetime NOT NULL, `modified_by` varchar(15) NOT NULL, `modified_date` datetime NOT NULL, PRIMARY KEY (`parameter_id`), KEY `UK_core_parameter_master_param_code_sequence_number` (`param_code`,`sequence_number`) USING BTREE, KEY `index_3` (`value_text`) ) ENGINE=InnoDB AUTO_INCREMENT=10665 DEFAULT CHARSET=utf8; -- -- Dumping data for table `core_parameter_master` -- /*!40000 ALTER TABLE `core_parameter_master` DISABLE KEYS */; INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (1,'YES_NO',1,'Yes',NULL,'YES',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (2,'YES_NO',2,'No',NULL,'NO',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (3,'ENABLE_DISABLE',1,'Enable',NULL,'ENABLE',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (4,'ENABLE_DISABLE',2,'Disable',NULL,'DISABLE',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (5,'PROCESS_CATEGORY',1,'PD AND PPC',NULL,'PD & PPC',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (6,'PROCESS_CATEGORY',2,'Production',NULL,'PRODUCTION',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (7,'PROCESS_CATEGORY',3,'Inventory',NULL,'INVENTORY',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (8,'PROCESS_CATEGORY',4,'Procurement',NULL,'PROCUREMENT',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (9,'PROCESS_CATEGORY',5,'Costing',NULL,'COSTING',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (10,'PROCESS_CATEGORY',6,'Concept',NULL,'CONCEPT',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (11,'PROCESS_CATEGORY',7,'Design',NULL,'DESIGN',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (12,'ACCESS_LEVEL',1,'Group',NULL,'GROUP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (13,'ACCESS_LEVEL',2,'Organisation',NULL,'ORGANISATION',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (14,'ACCESS_LEVEL',3,'Unit',NULL,'UNIT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (15,'ACCESS_LEVEL',4,'Location',NULL,'LOCATION',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (16,'ACCESS_LEVEL_OPTION',1,'Selected',NULL,'SELECTED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (17,'ACCESS_LEVEL_OPTION',2,'All',NULL,'ALL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (18,'ALERT_ASSIGNMENT_RULE',1,'Assigned to all the users with the defined Role',NULL,'ROLE ALL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (19,'ALERT_ASSIGNMENT_RULE',2,'Assigned to defined number of users with the role',NULL,'ROLE-NO-OF-USERS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (20,'ALERT_ASSIGNMENT_RULE',3,'Individual',NULL,'INDIVIDUAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (21,'ALERT_OVERRIDE_RULE',1,'Indicates whether approval level can be overidden',NULL,'LAST LEVEL OVERIDE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (22,'ALERT_OVERRIDE_RULE',2,'Indicates whether approval level can be overidden',NULL,'NO OVERIDE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (23,'ALERT_RAISE_TO',1,'Indicates whether approval alerts are to all the levels or 1',NULL,'ALL LEVELS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (24,'ALERT_RAISE_TO',2,'Indicates whether approval alerts are to all the levels or 1',NULL,'ONE LEVEL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (25,'ALERT_STATUS_PROGRESSION_RULE',1,'Min Number of Approvals',NULL,'MINIMUM',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (26,'ALERT_STATUS_PROGRESSION_RULE',2,'Max Number of Approvals',NULL,'MAXIMUM',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (27,'ALERT_STATUS_PROGRESSION_RULE',3,'All',NULL,'ALL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (28,'ALERT_STATUS_PROGRESSION_RULE',4,'Rule as mapped in detail table',NULL,'DETAIL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (29,'ALERT_STATUS_PROGRESSION_RULE',5,'None',NULL,'None',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (30,'ALERT_TYPE',1,'Normal',NULL,'NORMAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (31,'ALERT_TYPE',2,'Notification',NULL,'NOTIFICATION',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (32,'BAGTYPE',1,'Normal Bag',NULL,'NORMAL BAG',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (34,'BAGTYPE',2,'Repair Bag',NULL,'REPAIR BAG',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (44,'CONCEPT_CATEGORY_LEVEL',1,'Stores the level from which details for Part and Variant needs to be mapped.',NULL,NULL,1.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (45,'CONCEPT_HIERARCHY_ALLWD',1,'Stores the maximum hierarchies that could be defined for a Concept. ',NULL,NULL,10.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (46,'CUSTOMER_TYPE',1,'Retail',NULL,'RETAIL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (47,'CUSTOMER_TYPE',2,'Others',NULL,'OTHERS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (48,'DATA_TYPE',1,'Data Types',NULL,'TEXT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (49,'DATA_TYPE',2,'Data Types',NULL,'NUMBER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (50,'DATA_TYPE',3,'Data Types',NULL,'DATE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (51,'DESIGN_CATEGORY',1,'Indicates the Design Type',NULL,'PARENT DESIGN',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (52,'DESIGN_CATEGORY',2,'Indicates the Design Type',NULL,'SUB DESIGN',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (53,'DESIGN_CATEGORY',3,'Indicates the Design Type',NULL,'FINDING',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (54,'DESIGN_FORMAT',1,'JPEG',NULL,'JPEG',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (55,'DESIGN_FORMAT',2,'GIF',NULL,'GIF',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (56,'DESIGN_FORMAT',3,'TIF',NULL,'TIF',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (57,'DESIGN_FORMAT',4,'BMP',NULL,'BMP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (58,'EMPLOYEE_STATUS',1,'Active',NULL,'ACTIVE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (59,'EMPLOYEE_STATUS',2,'Resigned',NULL,'RESIGNED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (60,'ENABLE_DISABLE_ENTERED',3,'Entered',NULL,'ENTERED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (61,'ENTITY_RANKING',1,'Rank 1',NULL,'1',NULL,NULL,1,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (62,'ENTITY_RANKING',2,'Rank 2',NULL,'2',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (63,'ENTITY_RANKING',3,'Rank 3',NULL,'3',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (64,'ENTITY_RANKING',4,'Rank 4',NULL,'4',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (65,'ENTITY_RANKING',5,'Rank 5',NULL,'5',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (66,'GENDER',1,'Male',NULL,'MALE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (67,'GENDER',2,'Female',NULL,'FEMALE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (68,'GEOGRAPHY_TYPE',1,'Primary',NULL,'PRIMARY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (69,'GEOGRAPHY_TYPE',2,'Secondary',NULL,'SECONDARY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (70,'GEOGRAPHY_TYPE',3,'Tertiary',NULL,'TERTIARY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (71,'ITEM_CATEGORY_LEVEL',1,'Stores the level from which the Item category needs to be considered',NULL,NULL,1.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (72,'ITEM_SUB_CATEGORY_LEVEL',1,'Stores the Item Sub Category details',NULL,NULL,2.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (73,'MOULD_TYPES',2,'mould type',NULL,'HTV MOULD',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (74,'MOULD_TYPES',1,'Mould type',NULL,'RTV Mould',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (75,'NDR_REQUEST_TYPE',1,'Ndr request type',NULL,'NEW DESIGN',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (76,'NDR_REQUEST_TYPE',2,'Ndr request type',NULL,'NEW VARIANT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (77,'ORDER_TYPE',1,'Stores the Order Type',NULL,'INTERNAL ORDER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (78,'ORDER_TYPE',2,'Stores the Order Type',NULL,'CUSTOMER ORDER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (79,'PART_DIMENSION_CODE',1,'Stores Part Dimension Code',NULL,'A',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (80,'PART_DIMENSION_CODE_1',2,'Stores Part Dimension Code',NULL,'B',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (81,'PART_DIMENSION_CODE_1',3,'Stores Part Dimension Code',NULL,'C',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (82,'PART_DIMENSION_CODE_1',4,'Stores Part Dimension Code',NULL,'D',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (83,'PART_DIMENSION_CODE_1',5,'Stores Part Dimension Code',NULL,'E',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (84,'PART_DIMENSION_CODE_1',6,'Stores Part Dimension Code',NULL,'F',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (85,'PART_DIMENSION_CODE_1',7,'Stores Part Dimension Code',NULL,'G',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (86,'PART_DIMENSION_CODE_1',8,'Stores Part Dimension Code',NULL,'H',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (87,'PART_DIMENSION_CODE_1',9,'Stores Part Dimension Code',NULL,'I',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (88,'PART_DIMENSION_CODE_1',10,'Stores Part Dimension Code',NULL,'J',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (89,'PART_DIMENSION_CODE_1',11,'Stores Part Dimension Code',NULL,'K',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (90,'PART_DIMENSION_CODE_1',12,'Stores Part Dimension Code',NULL,'L',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (91,'PART_DIMENSION_CODE_1',13,'Stores Part Dimension Code',NULL,'M',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (92,'PART_DIMENSION_CODE_1',14,'Stores Part Dimension Code',NULL,'N',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (93,'PART_DIMENSION_CODE_1',15,'Stores Part Dimension Code',NULL,'O',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (94,'PROCESS_AT_DESIGN_CREATE',1,'Indicates the process after which the design needs to be created',NULL,'COREL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (95,'PRODUCTION_LEVEL',1,'production level',NULL,'VOLUMINOUS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (96,'PRODUCTION_LEVEL',2,'production level',NULL,'LIMITED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (97,'SHIFT_CLASSIFICATION',1,'Shift 1',NULL,'General Shift',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (98,'SHIFT_CLASSIFICATION',2,'Shift 2',NULL,'Shift 2',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (99,'SHIFT_CLASSIFICATION',3,'Shift 3',NULL,'Shift 3',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (101,'SHIFT_STATUS',1,'Indicates Normal or Overtime Hours',NULL,'NORMAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (102,'SOURCE_TYPE',2,'Source Type',NULL,'Website',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (103,'SOURCE_TYPE',4,'Source Type',NULL,'Others',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (104,'SPRUE_DIMENSION_ID',1,'Sprue dimension',NULL,'A',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (105,'SPRUE_DIMENSION_ID',2,'Sprue dimension',NULL,'B',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (106,'SPRUE_DIMENSION_ID',3,'Sprue dimension',NULL,'C',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (107,'SPRUE_DIMENSION_ID',4,'Sprue dimension',NULL,'D',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (108,'SPRUE_DIMENSION_ID',5,'Sprue dimension',NULL,'E',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (109,'SPRUE_DIMENSION_ID',6,'Sprue dimension',NULL,'F',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (110,'SPRUE_DIMENSION_ID',7,'Sprue dimension',NULL,'G',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (111,'TRUE_FALSE',1,'TRUE',NULL,'TRUE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (112,'TRUE_FALSE',2,'FALSE',NULL,'FALSE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (113,'USER_CATEGORY',1,'Type of User',NULL,'EMPLOYEE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (114,'USER_CATEGORY',2,'Type of User',NULL,'CONSULTANT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (115,'USER_CATEGORY',3,'Type of User',NULL,'Retail Customer',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (116,'BOM_TYPE',1,'Type of BOM',NULL,'Main BOM',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (117,'BOM_TYPE',2,'Type of BOM',NULL,'Alternate BOM - 1',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (118,'BOM_TYPE',3,'Type of BOM',NULL,'Alternate BOM - 2',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (119,'BOM_TYPE',4,'Type of BOM',NULL,'Alternate BOM - 3',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (120,'BOM_TYPE',5,'Type of BOM',NULL,'Alternate BOM - 4',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (121,'BOM_TYPE',6,'Type of BOM',NULL,'Alternate BOM - 5',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (122,'CUSTOMER_TYPE',1,'Customer Type',NULL,'RETAIL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (123,'CUSTOMER_TYPE',2,'Customer Type',NULL,'OTHERS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (124,'ITEM_CATEGORY',1,'Item Category',NULL,'Raw Materials',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (125,'ITEM_CATEGORY',2,'Item Category',NULL,'Tools',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (126,'ITEM_CATEGORY',3,'Item Category',NULL,'Consumables',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (127,'ITEM_CATEGORY',4,'Item Category',NULL,'Accessories',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (128,'CONCEPT_RANKING',1,'Concept Ranking',NULL,NULL,1.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (129,'CONCEPT_RANKING',2,'Concept Ranking',NULL,NULL,2.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (130,'CONCEPT_RANKING',3,'Concept Ranking',NULL,NULL,3.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (131,'CONCEPT_RANKING',4,'Concept Ranking',NULL,NULL,4.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (132,'CONCEPT_RANKING',5,'Concept Ranking',NULL,NULL,5.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (133,'BAG_TRANSFER_ACTION_INITIATED',1,'Stores Bag Transfer Action that can be taken',NULL,'For Acceptance from Process',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (134,'BAG_TRANSFER_ACTION_INITIATED',2,'Stores Bag Transfer Action that can be taken',NULL,'For Acceptance from Inventory',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (135,'BAG_TRANSFER_ACTION_INITIATED',3,'Stores Bag Transfer Action that can be taken',NULL,'For Transfer to Next Process',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (136,'BAG_TRANSFER_ACTION_INITIATED',4,'Stores Bag Transfer Action that can be taken',NULL,'For Transfer to Inventory',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (137,'BAG_TRANSFER_ACTION_INITIATED',5,'Stores Bag Transfer Action that can be taken',NULL,'For Return',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (138,'BAG_TRANSFER_ACTION_TAKEN',1,'Bag Transfer Action taken',NULL,'For Return',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (139,'BAG_TRANSFER_ACTION_TAKEN',2,'Bag Transfer Action taken',NULL,'Accept Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (140,'INVENTORY_LOCATION_TYPE',1,'Inventory Location Type','S','Transfer Location',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (141,'INVENTORY_LOCATION_TYPE',2,'Inventory Location Type','S','Diamond Stone Allocation',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (142,'INVENTORY_LOCATION_TYPE',3,'Inventory Location Type','S','Accessory Location',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (143,'INVENTORY_LOCATION_TYPE',4,'Inventory Location Type','S','Metals & Others Location',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (144,'BAG_TRANSFER_STATUS',1,'Bag Transfer Status',NULL,'Active',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (145,'BAG_TRANSFER_STATUS',2,'Bag Transfer Status',NULL,'Closed',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (146,'BAG_TRANSFER_STATUS',3,'Bag Transfer Status',NULL,'Cancel',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (147,'BAG_INTERIM_STATUS',1,'Bag Interim Status',NULL,'In Process',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (148,'BAG_INTERIM_STATUS',2,'Bag Interim Status',NULL,'Pending Acceptance',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (149,'BAG_INTERIM_STATUS',3,'Bag Interim Status',NULL,'Bag Returned',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (150,'BAG_INTERIM_STATUS',4,'Bag Interim Status',NULL,'Process Complete',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (151,'BAG_INTERIM_STATUS',5,'Bag Interim Status',NULL,'In Inventory',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (152,'BAG_FLOW_TYPE',1,'Bag Flow Type',NULL,'Main Flow',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (153,'BAG_FLOW_TYPE',2,'Bag Flow Type',NULL,'Sub Flow',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (154,'INTERNAL_ORDER_TYPE',1,'Internal Order Type',NULL,'Normal Order',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (155,'INTERNAL_ORDER_TYPE',2,'Internal Order Type',NULL,'Repair Order',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (156,'BAG_TRANSACTION_TYPE',1,'Bag Transaction Type',NULL,'Issue',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (157,'BAG_TRANSACTION_TYPE',2,'Bag Transaction Type',NULL,'Return',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (158,'BAG_TRANSACTION_TYPE',3,'Bag Transaction Type',NULL,'Transfer',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (159,'INVENTORY_STOCK_BLOCK_TYPE',1,'Inventory Stock Block Type',NULL,'Production',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'), (160,'ENTITY_TYPE',1,'Entity Type',NULL,'Internal Order',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-06-29 19:11:46','system','2008-06-29 19:11:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (161,'ALERT_ASSIGNMENT_RULE',4,'Assigned to all the users with the defined Role',NULL,'NONE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-08 19:13:01','system','2008-07-08 19:13:01'), (162,'ALERT_APPROVAL_PROGRESSION',1,'Alert Approval Progression',NULL,'NONE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-08 19:13:01','system','2008-07-08 19:13:01'), (10089,'SPRUE_CATEGORY',1,'Stores the uom to which Sprue needs to be mapped',NULL,'LENGTH',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-08 19:13:01','system','2008-07-08 19:13:01'), (10090,'DESIGN_TRANS_DIMENSION_DETAILS',1,'Used in Design BOM to display item properties',NULL,'DIAMETER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10091,'DESIGN_TRANS_DIMENSION_DETAILS',2,'Used in Design BOM to display item properties',NULL,'WIDTH',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10092,'DESIGN_TRANS_DIMENSION_DETAILS',3,'Used in Design BOM to display item properties',NULL,'BREADTH',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10093,'DESIGN_TRANS_DIMENSION_DETAILS',4,'Used in Design BOM to display item properties',NULL,'LENGTH',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10094,'DESIGN_TRANS_DIMENSION_DETAILS',5,'Used in Design BOM to display item properties',NULL,'HEIGHT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10095,'DESIGN_TRANS_DIMENSION_DETAILS',6,'Used in Design BOM to display item properties',NULL,'PERUNITWEIGHT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10096,'ENTITY_TRANS_DIMENSION_DETAILS',2,'Used in Entity BOM to display item properties',NULL,'DIAMETER',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10097,'ENTITY_TRANS_DIMENSION_DETAILS',3,'Used in Entity BOM to display item properties',NULL,'WIDTH',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10098,'ENTITY_TRANS_DIMENSION_DETAILS',4,'Used in Entity BOM to display item properties',NULL,'BREADTH',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10099,'ENTITY_TRANS_DIMENSION_DETAILS',5,'Used in Entity BOM to display item properties',NULL,'LENGTH',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10100,'ENTITY_TRANS_DIMENSION_DETAILS',6,'Used in Entity BOM to display item properties',NULL,'HEIGHT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10101,'ENTITY_TRANS_DIMENSION_DETAILS',7,'Used in Entity BOM to display item properties',NULL,'PERUNITWEIGHT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10102,'BAG_TRANS_DIMENSION_DETAILS',1,'Used in Entity BOM to display item properties',NULL,'DIAMETER',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10103,'BAG_TRANS_DIMENSION_DETAILS',2,'Used in Entity BOM to display item properties',NULL,'WIDTH',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10104,'BAG_TRANS_DIMENSION_DETAILS',3,'Used in Entity BOM to display item properties',NULL,'BREADTH',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10105,'BAG_TRANS_DIMENSION_DETAILS',4,'Used in Entity BOM to display item properties',NULL,'LENGTH',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10106,'BAG_TRANS_DIMENSION_DETAILS',5,'Used in Entity BOM to display item properties',NULL,'HEIGHT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10107,'BAG_TRANS_DIMENSION_DETAILS',6,'Used in Entity BOM to display item properties',NULL,'PERUNITWEIGHT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 18:54:42','system','2008-07-09 18:54:42'), (10108,'ENTITY_TRANS_DIMENSION_DETAILS',1,'Used in Entity BOM to display item properties',NULL,'RMQUALITY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 20:16:56','system','2008-07-09 20:16:56'), (10109,'BAG_TRANS_DIMENSION_DETAILS',7,'Used in Bag BOM to display item properties',NULL,'RMQUALITY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 20:16:56','system','2008-07-09 20:16:56'), (10110,'DESIGN_TRANS_DIMENSION_DETAILS',7,'Used in Design BOM to display item properties',NULL,'RMQUALITY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-09 20:16:56','system','2008-07-09 20:16:56'), (10111,'PART_CATEGORY',1,'Part Category',NULL,'DIMENSIONS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-11 15:41:08','system','2008-07-11 15:41:08'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10112,'ITEM_PROPERTY_NAME',1,'Colour',NULL,'COLOUR',NULL,NULL,1,NULL,'1900-01-01','2999-12-31','system','2008-07-14 15:31:24','system','2008-07-14 15:31:24'), (10113,'ITEM_PROPERTY_NAME',2,'Karatage',NULL,'KARATAGE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-14 15:31:24','system','2008-07-14 15:31:24'), (10123,'BAG_TYPE',1,'Normal Bag','S','Normal Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-21 13:16:23','system','2008-07-21 13:16:23'), (10124,'BAG_TYPE',2,'Duplicate Bag','S','Duplicate Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-21 13:16:23','system','2008-07-21 13:16:23'), (10125,'BAG_TYPE',3,'Repair Bag','S','Repair Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-21 13:16:23','system','2008-07-21 13:16:23'), (10126,'BAG_TYPE',4,'Linked Bag','S','Linked Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-21 13:16:23','system','2008-07-21 13:16:23'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10130,'BLOCK_TYPE',1,'PRODUCTION','S','Production',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-23 12:01:35','system','2008-07-21 13:16:23'), (10133,'PROCESS_CATEGORY',8,'General','S','GENERAL',0.0000,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10134,'BAG_CATEGORY_INVENTORY_TRANSFER',1,'Outgoing Bag','S','Outgoing Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10135,'TREE_CATEGORY_INVENTORY_TRANSFER',1,'Outgoing Tree','S','Outgoing Tree',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10136,'BAG_CATEGORY_INVENTORY_TRANSFER',2,'WIP Bag','S','WIP Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10137,'TREE_CATEGORY_INVENTORY_TRANSFER',2,'WIP Tree','S','WIP Tree',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10138,'BAG_CATEGORY_ACCEPT_TRANSFER',1,'Incoming Bag','S','Incoming Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10139,'TREE_CATEGORY_ACCEPT_TRANSFER',1,'Incoming Tree','S','Incoming Tree',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10140,'BAG_CATEGORY_FGIT_TRANSFER',1,'Outgoing Bag','S','Outgoing Bag',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10141,'TREE_CATEGORY_FGIT_TRANSFER',1,'Outgoing Tree','S','Outgoing Tree',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10142,'PRODUCTION_BAG_QC_STATUS',1,'OK','S','OK',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10143,'PRODUCTION_BAG_QC_STATUS',2,'NOT OK','S','NOT OK',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-25 13:31:07','system','2008-07-25 13:31:07'), (10144,'MIN_SHIFT_MINUTES',1,'Minimum Productive time per shift','S','0',420.0000,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-07-29 17:21:34','system','2008-07-29 17:21:34'), (10145,'PRODUCTION_BAG_HEADER_STATUS',1,'CREATED','S','CREATED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-29 17:21:34','system','2008-07-29 17:21:34'), (10146,'PRODUCTION_BAG_HEADER_STATUS',2,'NEW','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-29 17:21:34','system','2008-07-29 17:21:34'), (10147,'PRODUCTION_BAG_HEADER_STATUS',3,'HOLD','S','HOLD',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-29 17:21:34','system','2008-07-29 17:21:34'), (10148,'PRODUCTION_BAG_HEADER_STATUS',4,'COMPLETE','S','COMPLETED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-29 17:21:34','system','2008-07-29 17:21:34'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10149,'INVENTORY_LOCATION_TYPE',5,'Inventory Location Type','S','Finished Goods',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-07-29 17:21:34','system','2008-07-29 17:21:34'), (10150,'PRODUCTION_BAG_DEPARTMENTAL_STATUS',1,'New','S','NEW',NULL,NULL,2,2,'2008-01-01','2010-01-01','libin','2008-07-08 00:00:00','libin','2008-07-08 00:00:00'), (10151,'PRODUCTION_BAG_DEPARTMENTAL_STATUS',2,'Pending QC','S','PENDING QC',NULL,NULL,2,2,'2008-01-01','2010-01-01','libin','2008-07-08 00:00:00','libin','2008-07-08 00:00:00'), (10152,'PRODUCTION_BAG_DEPARTMENTAL_STATUS',3,'QC Cleared','S','QC CLEARED',NULL,NULL,2,2,'2008-01-01','2010-01-01','libin','2008-07-08 00:00:00','libin','2008-07-08 00:00:00'), (10153,'PRODUCTION_BAG_DEPARTMENTAL_STATUS',4,'Approved','S','APPROVED',NULL,NULL,2,2,'2008-01-01','2010-01-01','libin','2008-07-08 00:00:00','libin','2008-07-08 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10154,'PRODUCTION_BAG_DEPARTMENTAL_STATUS',5,'Rejected','S','REJECT',NULL,NULL,2,2,'2008-01-01','2010-01-01','libin','2008-07-08 00:00:00','libin','2008-07-08 00:00:00'), (10155,'PRODUCTION_PROCESS',1,'In Process','S','Process',NULL,NULL,1,2,'2008-08-01','2099-08-30','abhidnya.k','2008-08-01 12:16:16','abhidnya.k','2008-08-01 12:16:16'), (10157,'PRODUCTION_BAG_DEPARTMENTAL_STATUS',6,'Cancelled','S','CANCEL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2008-08-01 15:53:26','system','2008-08-01 15:53:26'), (10162,'PRODUCTION_BAG_REPAIR_QUANTITY',1,'Stores the number of bags that can be created for Repair bag',NULL,NULL,1.0000,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-02 22:19:20','system','2008-09-02 22:19:20'), (10163,'PRODUCTION_WORKFLOW_PROCESS_STATUS',1,'The status of a process that a bag is passing through',NULL,'IN_PROGRESS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-02 22:19:20','system','2008-09-02 22:19:20'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10164,'PRODUCTION_WORKFLOW_PROCESS_STATUS',2,'The status of a process that a bag is passing through',NULL,'COMPLETED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-02 22:19:20','system','2008-09-02 22:19:20'), (10165,'PRODUCTION_WORKFLOW_PROCESS_STATUS',3,'The status of a process that a bag is passing through',NULL,'NOT_STARTED_YET',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-02 22:19:20','system','2008-09-02 22:19:20'), (10166,'PRODUCTION_TREE_DEPARTMENTAL_STATUS',1,'Stores the Status applicable for Tree','','NEW',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-17 23:25:36','system','2008-09-17 23:25:36'), (10167,'PRODUCTION_TREE_DEPARTMENTAL_STATUS',2,'Stores the Status applicable for Tree','','PENDING QC',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-17 23:25:39','system','2008-09-17 23:25:39'), (10168,'PRODUCTION_TREE_DEPARTMENTAL_STATUS',3,'Stores the Status applicable for Tree','','QC CLEARED',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10169,'PRODUCTION_TREE_DEPARTMENTAL_STATUS',4,'Stores the Status applicable for Tree','','APPROVED',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'), (10170,'PRODUCTION_TREE_DEPARTMENTAL_STATUS',5,'Stores the Status applicable for Tree','','REJECTED',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'), (10171,'PRODUCTION_TREE_HEADER_STATUS',1,'CREATED','','CREATED',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'), (10172,'PRODUCTION_TREE_HEADER_STATUS',2,'NEW','','NEW',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'), (10173,'PRODUCTION_TREE_HEADER_STATUS',3,'COMPLETED','','COMPLETED',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10174,'PRODUCTION_TREE_HEADER_STATUS',4,'REJECTED','','REJECTED',NULL,'0000-00-00',NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 18:57:06','system','2008-09-12 18:57:06'), (10175,'PROD_TREE_DEFAULT_PROCESS_CODE',1,'Default Process Code while creating a tree','S','TREE_MAKE',NULL,'0000-00-00',NULL,2,'1900-01-01','3009-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10176,'TREE_TRANSFER_STATUS',1,'Tree Transfer Status','S','Active',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10177,'TREE_TRANSFER_STATUS',2,'Tree Transfer Status','S','Closed',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10178,'TREE_TRANSFER_STATUS',3,'Tree Transfer Status','S','Cancel',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10179,'TREE_TRANSFER_ACTION_TAKEN',1,'Tree Transfer Action taken','S','For Return',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10180,'TREE_TRANSFER_ACTION_TAKEN',2,'Tree Transfer Action taken','S','Accept Tree',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10181,'TREE_TRANSFER_ACTION_INITIATED',1,'Stores Tree Transfer Action that can be taken','S','For Acceptance from Process',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10182,'TREE_TRANSFER_ACTION_INITIATED',2,'Stores Tree Transfer Action that can be taken','S','For Acceptance from Inventory',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10183,'TREE_TRANSFER_ACTION_INITIATED',3,'Stores Tree Transfer Action that can be taken','S','For Transfer to Next Process',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10184,'TREE_TRANSFER_ACTION_INITIATED',4,'Stores Tree Transfer Action that can be taken','S','For Transfer to Inventory',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10185,'TREE_TRANSFER_ACTION_INITIATED',5,'Stores Tree Transfer Action that can be taken','S','For Return',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10186,'PRODUCTION_ASSAYING_METHOD',1,'Production Assaying Method ','S','Fire Assay',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10187,'PRODUCTION_ASSAYING_METHOD',2,'Production Assaying Method ','S','Machine Assay',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10188,'INCRESE_DECRESE',1,'Increse','S','INCRESE',NULL,NULL,2,2,'1900-01-01','2999-12-31','satyapal','2008-09-12 00:00:00','satyapal','2008-09-12 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10189,'INCRESE_DECRESE',2,'Decrese','S','DECRESE',NULL,NULL,2,2,'1900-01-01','2999-12-31','satyapal','2008-09-12 00:00:00','satyapal','2008-09-12 00:00:00'), (10190,'TREE_INTERIM_STATUS',1,'Tree Interim Status',NULL,'In Process',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10191,'TREE_INTERIM_STATUS',2,'Tree Interim Status',NULL,'Pending Acceptance',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10192,'TREE_INTERIM_STATUS',3,'Tree Interim Status',NULL,'Tree Returned',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10193,'TREE_INTERIM_STATUS',4,'Tree Interim Status',NULL,'Process Complete',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10194,'TREE_INTERIM_STATUS',5,'Tree Interim Status',NULL,'In Inventory',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10196,'TRIAL_PRODUCTION_HEADER_STATUS',1,'Statuses for a trial production run','S','ACTIVE',NULL,NULL,NULL,NULL,'2008-01-01','2099-01-01','abhidnya.k','0000-00-00 00:00:00','abhidnya.k','0000-00-00 00:00:00'), (10197,'TRIAL_PRODUCTION_HEADER_STATUS',2,'Statuses for a trial production run','S','COMPLETED',NULL,NULL,NULL,NULL,'2008-01-01','2099-01-01','abhidnya.k','0000-00-00 00:00:00','abhidnya.k','0000-00-00 00:00:00'), (10198,'TRIAL_PRODUCTION_HEADER_STATUS',3,'Statuses for a trial production run','S','CANCEL',NULL,NULL,NULL,NULL,'2008-01-01','2099-01-01','abhidnya.k','0000-00-00 00:00:00','abhidnya.k','0000-00-00 00:00:00'), (10199,'TRL_PROD_DEFAULT_NO_DESIGN_PER_BAG',1,'Default number of designs per bag','N',NULL,1.0000,NULL,NULL,NULL,'2008-01-01','2099-01-01','abhidnya.k','0000-00-00 00:00:00','abhidnya.k','0000-00-00 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10200,'PD_SCHEDULE_STATUS',1,'Scheduled','S','SCHEDULED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10201,'PD_SCHEDULE_STATUS',2,'Pending Scheduled','S','PENDING_SCHEDULE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10202,'PD_SCHEDULE_STATUS',3,'Allocated','S','ALLOCATED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-09-12 00:00:00','system','2008-09-12 00:00:00'), (10203,'SPRUE_IMAGE_LOCATION',1,'Image location for sprue','S','design/',NULL,NULL,2,2,'1900-01-01','2999-12-31','parwej','2008-10-30 11:45:00','parwej','2008-10-30 11:45:00'), (10204,'SPRUE_IMAGE_LOCATION',2,'Image location for sprue','S','design/subdesign/',NULL,NULL,2,2,'1900-01-01','2999-12-31','parwej','2008-10-30 11:45:00','parwej','2008-10-30 11:45:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10205,'PART_IMAGE_LOCATION',1,'Image location for part','S','design/',NULL,NULL,2,2,'1900-01-01','2999-12-31','parwej','2008-10-30 11:45:00','parwej','2008-10-30 11:45:00'), (10206,'PART_IMAGE_LOCATION',2,'Image location for part','S','design/subdesign/',NULL,NULL,2,2,'1900-01-01','2999-12-31','parwej','2008-10-30 11:45:00','parwej','2008-10-30 11:45:00'), (10207,'ALERT_REJECTION_PROGRESSION_RULE',1,'Max Number of Approvals',NULL,'MAXIMUM',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10208,'ALERT_REJECTION_PROGRESSION_RULE',2,'ALL',NULL,'All',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10209,'ENTITY_FULL_IMAGE_PATH',1,'Stores the path for the entity image',NULL,'cad/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10210,'SPRUE_FULL_IMAGE_PATH',1,'Stores the path for the entity image',NULL,'/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10211,'PART_FULL_IMAGE_PATH',1,'Stores the path for the entity image',NULL,'/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10212,'ENTITY_FULL_IMAGE_PATH',2,'Stores the path for the entity image',NULL,'corel/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10213,'ENTITY_FULL_IMAGE_PATH',3,'Stores the path for the entity image',NULL,'handsketch/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10214,'ENTITY_FULL_IMAGE_PATH',4,'Stores the path for the entity image',NULL,'Design/NDR Reference images/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10215,'ENTITY_FULL_IMAGE_PATH',5,'Stores the path for the entity image',NULL,'rpt/',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-04 17:02:46','system','2008-12-04 17:02:46'), (10216,'PDSCHEDULEFREEZE',1,'Indicates when the schedule needs to ready for allocation',NULL,NULL,0.0000,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10217,'MODIFICATION_REQUEST_TYPE_ENTITY',1,'Modification Request - Single Entity',NULL,'Modification Request - Single Entity',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10218,'MODIFICATION_REQUEST_TYPE_ENTITY',2,'Modification Request - Multiple Entity',NULL,'Modification Request - Multiple Entity',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10219,'MODIFICATION_REQUEST_TYPE_DESIGN',3,'Modification Request - Design',NULL,'Modification Request - Design',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10220,'MODIFY_REQUEST_DESIGN_ENTITY',1,'Modification Request type for Entity or Design',NULL,'Entity',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10221,'MODIFY_REQUEST_DESIGN_ENTITY',2,'Modification Request type for Entity or Design',NULL,'Design',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10222,'PD_SCHEDULE_STATUS',4,'PD Scheduling Status used in Search',NULL,'FREEZED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10223,'PD_SCHEDULE_STATUS',5,'PD Scheduling Status used in Search',NULL,'HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10224,'MODIFY_REQUEST_ENTITY_STATUS',1,'Modification Request Entity Status',NULL,'NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10225,'MODIFY_REQUEST_ENTITY_STATUS',2,'Modification Request Entity Status',NULL,'INPROGRESS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10226,'MODIFY_REQUEST_ENTITY_STATUS',3,'Modification Request Entity Status',NULL,'COMPLETE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10227,'MODIFY_REQUEST_STATUS',1,'Modification Request Status',NULL,'NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10228,'MODIFY_REQUEST_STATUS',2,'Modification Request Status',NULL,'PENDING_APPROVAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10229,'MODIFY_REQUEST_STATUS',3,'Modification Request Status',NULL,'APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10230,'MODIFY_REQUEST_STATUS',4,'Modification Request Status',NULL,'REJECTED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10231,'MODIFY_REQUEST_STATUS',5,'Modification Request Status',NULL,'REWORK',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2008-12-16 18:39:11','system','2008-12-16 18:39:11'), (10232,'PD_ENTITY_STATUS',1,'PD Entity Status used in Search',NULL,'NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-05 18:58:44','system','2009-01-05 18:58:44'), (10233,'PD_ENTITY_STATUS',2,'PD Entity Status used in Search',NULL,'PENDING_APPROVAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-05 18:58:44','system','2009-01-05 18:58:44'), (10234,'PD_ENTITY_STATUS',3,'PD Entity Status used in Search',NULL,'APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-05 18:58:44','system','2009-01-05 18:58:44'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10235,'PD_ENTITY_STATUS',4,'PD Entity Status used in Search',NULL,'HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-05 18:58:44','system','2009-01-05 18:58:44'), (10236,'PD_ENTITY_STATUS',5,'PD Entity Status used in Search',NULL,'REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-05 18:58:44','system','2009-01-05 18:58:44'), (10237,'INTIMATE_ON_STATUS_OF',1,'Intimation on status of ',NULL,'ENTITY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10238,'INTIMATE_ON_STATUS_OF',2,'Intimation on status of ',NULL,'ENTITY-STATUS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10239,'INTIMATE_ON_STATUS_OF',3,'Intimation on status of ',NULL,'ALL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10240,'INTIMATE_ON_STATUS_CODE',1,'Intimation on status code ',NULL,'APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10241,'INTIMATE_ON_STATUS_CODE',2,'Intimation on status code ',NULL,'REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10242,'INTIMATE_ON_STATUS_CODE',3,'Intimation on status code ',NULL,'ALL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10243,'INTIMATE_ASSIGNMENT_RULE',1,'Intimation Assignment rule ',NULL,'ROLE-ALL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10244,'INTIMATE_ASSIGNMENT_RULE',2,'Intimation Assignment rule ',NULL,'ROLE-NO-OF-USERS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10245,'INTIMATE_ASSIGNMENT_RULE',3,'Intimation Assignment rule ',NULL,'INDIVIDUAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-01-12 19:37:02','system','2009-01-12 19:37:02'), (10247,'PD_REPORT_TYPE',1,'Location Analysis',NULL,'TOTAL_WIP_LOCATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-02-11 10:48:39','system','2009-02-11 10:48:39'), (10248,'PD_REPORT_TYPE',2,'WIP Bag Pieces Report',NULL,'WIP_BAG_PIECE_MONTHLY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-02-11 10:48:39','system','2009-02-11 10:48:39'), (10250,'PRODUCTION_BAG_APPROVED_REASON_CODE',1,'Auto Approved',NULL,'AUTO_APPROVED_REASON_CODE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-02-21 17:09:04','system','2009-02-21 17:09:04'), (10254,'PRODUCTION_REPORT_TYPE',4,'Wip Drill Down Report','S','WIP_DRILL_DOWN',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-02-11 15:11:57','system','2009-02-11 15:11:57'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10255,'PD_DESIGN_STATUS',1,'PD Design Status used in Search',NULL,'NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:21:45','system','2009-04-17 20:21:45'), (10256,'PD_DESIGN_STATUS',2,'PD Design Status used in Search',NULL,'PENDING_APPROVAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:21:45','system','2009-04-17 20:21:45'), (10257,'PD_DESIGN_STATUS',3,'PD Design Status used in Search',NULL,'APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:21:45','system','2009-04-17 20:21:45'), (10258,'PD_DESIGN_STATUS',4,'PD Design Status used in Search',NULL,'HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:21:45','system','2009-04-17 20:21:45'), (10259,'PD_DESIGN_STATUS',5,'PD Design Status used in Search',NULL,'REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:21:45','system','2009-04-17 20:21:45'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10260,'QUOTATION_METAL_RATE_DATE',1,'Based on this ,apply metal rate as of Date in quotation will populate','S','ORDER DATE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10261,'QUOTATION_METAL_RATE_DATE',2,'Based on this ,apply metal rate as of Date in quotation will populate','S','DELIVERY DATE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10262,'QUOTATION_COSTING_METHOD',1,'Whether to choose process cost or overallcost','S','Process cost',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10263,'QUOTATION_COSTING_METHOD',2,'Whether to choose process cost or overallcost','S','Overall cost',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10264,'QUOTATION_CALC_CONSTANTS',1,'OZTROY_CONSTANT','N',NULL,31.1035,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10265,'QUOTATION_TOTAL_METALWEIGHT_BASEUOM',1,'QUOTATION_TOTAL_METALWEIGHT_BASEUOM','S','GMS1',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10266,'QUOTATION_TOTAL_STONEWEIGHT_BASEUOM',1,'QUOTATION_TOTAL_STONEWEIGHT_BASEUOM','S','CENTS1',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10267,'QUOTATION_TIME_BASEUOM',1,'QUOTATION_TIME_BASEUOM','S','HOURS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10268,'DESIGN_OR_ENTITY',1,'Design','S','DESIGN',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10269,'DESIGN_OR_ENTITY',2,'Entity','S','ENTITY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10270,'QUOTATION_BOM_TYPE',1,'Describes the bom for diamond','S','DIAMOND',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10271,'QUOTATION_BOM_TYPE',2,'Describes the bom for metal','S','METAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10272,'QUOTATION_BOM_TYPE',3,'Describes the bom for others','S','OTHERS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10273,'QUOTATION_HDR_STATUS',1,'VALUE FOR Quotation header status','S','NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10274,'QUOTATION_HDR_STATUS',2,'VALUE FOR Quotation header status','S','APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10275,'QUOTATION_HDR_STATUS',3,'VALUE FOR Quotation header status','S','PENDING_APPROVAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10276,'QUOTATION_HDR_STATUS',4,'VALUE FOR Quotation header status','S','REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10277,'QUOTATION_HDR_STATUS',5,'VALUE FOR Quotation header status','S','HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10278,'INV_ISSUE_ACK_STATUS',1,'Inventory Acknowledgement Status','S','ACCEPT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10279,'INV_ISSUE_ACK_STATUS',2,'Inventory Acknowledgement Status','S','REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10280,'INV_FG_RECEIPT_TYPE',1,'Inventory finish good receipt type','S','FROM PRODUCTION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10281,'INV_FG_RECEIPT_TYPE',2,'Inventory finish good receipt type','S','FROM VENDOR',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10282,'INV_FG_RECEIPT_TYPE',3,'Inventory finish good receipt type','S','FROM INVENTORY LOCATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10283,'INV_FG_STOCK_REQ_MAP',1,'Inventory stock request internal order mapping unmapping status','S','MAP',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10284,'INV_FG_STOCK_REQ_MAP',2,'Inventory stock request internal order mapping unmapping status','S','UNMAP',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10285,'INV_DIAMOND_STOCK_STATUS',1,'Inventory diamond stone status','S','GOOD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10286,'INV_DIAMOND_STOCK_STATUS',2,'Inventory diamond stone status','S','FROSTED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10287,'INV_DIAMOND_STOCK_STATUS',3,'Inventory diamond stone status','S','CHIPPED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10288,'INV_DIAMOND_STOCK_STATUS',4,'Inventory diamond stone status','S','BROKEN',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10289,'INV_DIAMOND_STOCK_STATUS',5,'Inventory diamond stone status','S','DAMAGED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10290,'INV_DIAMOND_STOCK_STATUS',6,'Inventory diamond stone status','S','QUARANTINED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10291,'INVENTORY_ITEM_TYPE',4,'Inventory Item Type','S','Diamond and Stones',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10292,'INVENTORY_RECEIPT_TYPE',4,'Inventory receipt type','S','INTERNAL REQUESTS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10293,'INVENTORY_LIB_ITEM_STOCK_REQUEST',1,'Internal Request','S','Internal Request',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10294,'INVENTORY_LIB_ITEM_STOCK_REQUEST',2,'Outsourec To Vendor','S','Outsourec To Vendor',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10295,'INVENTORY_LIB_ITEM_STOCK_REQUEST',3,'Store','S','Store',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10296,'INVENTORY_ISSUE_TO_TYPE',1,'Inventory Issue to type','S','BAG',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10297,'INVENTORY_ISSUE_TO_TYPE',2,'Inventory Issue to type','S','Individual User',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10298,'INVENTORY_ISSUE_TO_TYPE',3,'Inventory Issue to type','S','Tree',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10299,'INVENTORY_ISSUE_TYPE',3,'Inventory Issue type','S','Individual User',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10300,'INVENTORY_ITEM_TYPE',1,'Inventory Item Type','S','Raw Material',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10301,'INVENTORY_ITEM_TYPE',2,'Inventory Item Type','S','Library Items',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10302,'INVENTORY_ITEM_TYPE',3,'Inventory Item Type','S','Finished Goods',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10303,'INVENTORY_WIP_RECEIPT_TYPE',1,'Inventory wip receipt type','S','PRODUCTION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10304,'INVENTORY_WIP_RECEIPT_TYPE',2,'Inventory wip receipt type','S','INVENTORY LOCATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10305,'INVENTORY_WIP_RECEIPT_TYPE',3,'Inventory wip receipt type','S','VENDOR',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10306,'INVENTORY_RECEIPT_TYPE',1,'Inventory receipt type','S','VENDOR',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10307,'INVENTORY_RECEIPT_TYPE',2,'Inventory receipt type','S','INVENTORY LOCATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10308,'INVENTORY_RECEIPT_TYPE',3,'Inventory receipt type','S','INDIVIDUAL USER',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10309,'INVENTORY_ISSUE_TYPE',1,'Inventory issue type','S','ISSUE_WITH_STOCK_REQUEST',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10310,'INVENTORY_ISSUE_TYPE',2,'Inventory issue type','S','ISSUE_WITHOUT_STOCK_REQUEST',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10311,'INVENTORY_TRANSACTION_TYPE',1,'Inventory transaction type','S','RECEIPT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10312,'INVENTORY_TRANSACTION_TYPE',2,'Inventory transaction type','S','ISSUE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10313,'INVENTORY_RUNNING_STATUS',1,'Inventory transaction status','S','RECEIPT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10314,'INVENTORY_RUNNING_STATUS',2,'Inventory transaction status','S','ISSUE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10315,'INVENTORY_BLOCK_STATUS',1,'Inventory transaction staus','S','BLOCKED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10316,'INVENTORY_BLOCK_STATUS',2,'Inventory transaction staus','S','UNBLOCKED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10317,'ITEM_ALLOCATION_LOGIC',1,'Inventory item allocation logic','S','LIFO',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10318,'ITEM_ALLOCATION_LOGIC',2,'Inventory item allocation logic','S','FIFO',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10319,'ITEM_ALLOCATION_LOGIC',3,'Inventory item allocation logic','S','RANDOM',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10320,'INVENTORY_HIERARCHY_LEVEL',1,'Inventory Location Hierarchy levels','S','1',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10321,'INVENTORY_HIERARCHY_LEVEL',2,'Inventory Location Hierarchy levels','S','2',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10322,'INVENTORY_HIERARCHY_LEVEL',3,'Inventory Location Hierarchy levels','S','3',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10323,'INVENTORY_HIERARCHY_LEVEL',4,'Inventory Location Hierarchy levels','S','4',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10324,'INVENTORY_HIERARCHY_LEVEL',5,'Inventory Location Hierarchy levels','S','5',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10325,'INVENTORY_DELIVERY_STATUS',1,'Inventory delivery status ','S','OPEN',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10326,'INVENTORY_DELIVERY_STATUS',2,'Inventory delivery status ','S','CLOSED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10327,'INVENTORY_DELIVERY_STATUS',3,'Inventory delivery status ','S','PARTIALLY_FULFILLED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10328,'INVENTORY_ISSUE_STATUS',1,'Inventory issue status ','S','NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10329,'INVENTORY_ISSUE_STATUS',2,'Inventory issue status ','S','CONFIRMED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10330,'INVENTORY_ISSUE_STATUS',3,'Inventory issue status ','S','CANCEL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10331,'INVENTORY_STOCK_REQUEST_STATUS',1,'Inventory stock request headerstatus ','S','NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10332,'INVENTORY_STOCK_REQUEST_STATUS',2,'Inventory stock request headerstatus ','S','PENDING_APPROVAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10333,'INVENTORY_STOCK_REQUEST_STATUS',3,'Inventory stock request headerstatus ','S','APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10334,'INVENTORY_STOCK_REQUEST_STATUS',4,'Inventory stock request headerstatus ','S','CANCEL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10335,'INVENTORY_STOCK_REQUEST_STATUS',5,'Inventory stock request headerstatus ','S','REWORK',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10336,'INVENTORY_STOCK_REQUEST_STATUS',6,'Inventory stock request headerstatus ','S','HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10337,'INVENTORY_STOCK_STATUS',1,'Inventory stock status ','S','GOOD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10338,'INVENTORY_STOCK_STATUS',2,'Inventory stock status ','S','DAMAGED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10339,'INVENTORY_STOCK_STATUS',3,'Inventory stock status ','S','QUARANTINED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10340,'INVENTORY_RECEIPT_STATUS',1,'Inventory receipt status ','S','NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10341,'INVENTORY_RECEIPT_STATUS',2,'Inventory receipt status ','S','CONFIRMED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10342,'INVENTORY_RECEIPT_STATUS',3,'Inventory receipt status ','S','CANCEL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10343,'INVENTORY_ISSUE_BAG',1,'Inventory bag issue code prefix','S','BAG',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10344,'INVENTORY_ISSUE_TYPE',4,'Inventory issue type','S','ISSUE TO PRODUCTION BAG',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10347,'DIAMOND_STONE_RANGE_LEVEL',1,'Diamond Stone Range Level','S','LEVEL1',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10348,'DIAMOND_STONE_RANGE_LEVEL',2,'Diamond Stone Range Level','S','LEVEL2',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10349,'INVENTORY_RECEIPT_TYPE',5,'Inventory receipt type','S','PRODUCTION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10350,'INCREASE_DECREASE',1,'Increase decrease ','S','INCREASE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10351,'INCREASE_DECREASE',2,'Increase decrease ','S','DECREASE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10352,'INVENTORY_WIP_ITEM_TYPE',1,'Inventory WIP item type','S','BAG',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10353,'INVENTORY_WIP_ITEM_TYPE',2,'Inventory WIP item type ','S','TREE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10354,'INVENTORY_ISSUE_TYPE',5,'Inventory issue type','S','ADJ_LOCATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10355,'INVENTORY_RECEIPT_TYPE',6,'Inventory receipt type','S','ADJ_LOCATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10356,'INVENTORY_ADJ_LOC_TYPE',1,'Inventory adjustment location type','S','DIAMOND_ADJ_LOC',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10357,'INVENTORY_ADJ_LOC_TYPE',2,'Inventory adjustment location type','S','METAL_ADJ_LOC',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10358,'INVENTORY_ADJ_LOC_TYPE',3,'Inventory adjustment location type','S','OTHERS_ADJ_LOC',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10359,'INVENTORY_RECEIPT_TYPE',7,'Inventory receipt type','S','ADJ_LOCATION_DUMMY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10360,'INVENTORY_ISSUE_TYPE',6,'Inventory issue type','S','ISSUE_TO_INV_LOC_WITH_INVOICE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'), (10361,'INVENTORY_ISSUE_TO_TYPE',4,'Inventory Issue to type','S','FG_ISSUE_TO_SALES_INVOICE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:36:12','system','2009-04-17 20:36:12'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10362,'COSTING_STONE_TAB',1,'VALUE FOR STONE TAB','S','DIAMOND',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10363,'COSTING_STONE_TAB',2,'VALUE FOR STONE TAB','S','STONE',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10364,'COSTING_METAL_TAB',1,'VALUE FOR METAL TAB','S','METAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10365,'COSTING_METAL_TAB',2,'VALUE FOR METAL TAB','S','ALLOY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10366,'COSTING_TEMPLATE_STATUS',1,'VALUE FOR INTERNAL TEMPLATE TAB STATUS','S','REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10367,'COSTING_TEMPLATE_STATUS',3,'VALUE FOR INTERNAL TEMPLATE TAB STATUS','S','APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10368,'COSTING_TEMPLATE_STATUS',2,'VALUE FOR INTERNAL TEMPLATE TAB STATUS','S','REWORK',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10369,'COSTING_TEMPLATE_STATUS',4,'VALUE FOR INTERNAL TEMPLATE TAB STATUS','S','MODIFY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10370,'COSTING_STONE_UOM',1,'VALUE FOR STONE UOM','S','STONE_UOM',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10371,'COSTING_ADDITIONAL_COST_TAB',1,'VALUE FOR ADDITIONAL COST TAB','S','OVER HEAD COST',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10372,'COSTING_OVER_ALL_COST_TAB',1,'VALUE FORADDITIONAL COST TAB','S','PRODUCT MAKING',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10373,'COSTING_OVER_ALL_COST_TAB',2,'VALUE FORADDITIONAL COST TAB','S','DIAMOND HANDLING',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10374,'COSTING_PROCESS',1,'VALUE FOR ADDITIONAL COST TAB','S','PROCESS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10377,'COSTING_UOM_CATEGORY',1,'Costing Uom Category','S','TIME',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10378,'COSTING_UOM_CATEGORY',2,'Costing Uom Category','S','VOLUME',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10379,'COSTING_UOM_CATEGORY',3,'Costing Uom Category','S','WEIGHT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10380,'COSTING_TEMPLATE_HDR_STATUS',1,'VALUE FOR template header status','S','NEW',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10381,'COSTING_TEMPLATE_HDR_STATUS',2,'VALUE FOR template header status','S','APPROVED',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10382,'COSTING_TEMPLATE_HDR_STATUS',3,'VALUE FOR template header status','S','PENDING_APPROVAL',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10383,'COSTING_TEMPLATE_HDR_STATUS',4,'VALUE FOR template header status','S','HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10384,'COSTING_TEMPLATE_HDR_STATUS',5,'VALUE FOR template header status','S','REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10385,'PRODUCTIONSCHEDULEFREEZE',1,'Prouction Schduling freeze period',NULL,NULL,1.0000,NULL,1,2,'2001-01-01','2999-12-31','tsd','2009-04-17 00:00:00','tsd','2009-04-17 00:00:00'), (10386,'INVENTORY_LOCATION_TYPE',6,'Inventory Location Type','S','Finished Goods - Trial Production',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-06 19:22:32','system','2009-05-06 19:22:32'), (10387,'INVENTORY_LOCATION_TYPE',7,'Inventory Location Type','S','Rejected Production Items',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-06 19:22:32','system','2009-05-06 19:22:32'), (10388,'INVENTORY_LOCATION_TYPE',8,'Inventory Location Type','S','Production Items For Melting',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-06 19:22:32','system','2009-05-06 19:22:32'), (10389,'BAG_CATEGORY_INVENTORY_TRANSFER',3,'Rejected Bag','S','Rejected Bag',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-06 19:22:32','system','2009-05-06 19:22:32'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10390,'TREE_CATEGORY_INVENTORY_TRANSFER',3,'Rejected Tree','S','Rejected Tree',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-06 19:22:32','system','2009-05-06 19:22:32'), (10391,'PRODUCT_CATALOG',1,'PRODUCT CATALOG','S','Retail Catalog',NULL,NULL,9,9,'1900-01-01','2999-12-31','system','2009-05-13 20:49:49','system','2009-05-13 20:49:49'), (10392,'PRODUCT_CATALOG',2,'PRODUCT CATALOG','S','Customer Catalog',NULL,NULL,9,9,'1900-01-01','2999-12-31','system','2009-05-13 20:49:49','system','2009-05-13 20:49:49'), (10393,'PRODUCT_CATALOG',3,'PRODUCT CATALOG','S','Export Catalog',NULL,NULL,9,9,'1900-01-01','2999-12-31','system','2009-05-13 20:49:49','system','2009-05-13 20:49:49'), (10394,'PRODUCT_CATALOG',4,'PRODUCT CATALOG','S','WholeSale Catalog',NULL,NULL,9,9,'1900-01-01','2999-12-31','system','2009-05-13 20:49:49','system','2009-05-13 20:49:49'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10395,'INVENTORY_ITEM_ALOC_BSD_ON',1,'Inventory allocation based on ','S','QUANTITY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:39:32','system','2009-05-15 19:39:32'), (10396,'INVENTORY_ITEM_ALOC_BSD_ON',2,'Inventory allocation based on ','S','WEIGHT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:39:32','system','2009-05-15 19:39:32'), (10403,'INVOICE_VALUATION_TYPE',1,'Value for the invoice valuation','S','Actuals',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:55:28','system','2009-05-15 19:55:28'), (10404,'INVOICE_VALUATION_TYPE',2,'Value for the invoice valuation','S','Designs',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:55:28','system','2009-05-15 19:55:28'), (10405,'INVOICE_VALUATION_TYPE',3,'Value for the invoice valuation','S','Zero',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:55:28','system','2009-05-15 19:55:28'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10406,'INVOICE_TYPE',1,'Value for the invoice type','S','Consignment based',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:55:28','system','2009-05-15 19:55:28'), (10407,'INVOICE_TYPE',2,'Value for the invoice type','S','Salesinvoice',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:55:28','system','2009-05-15 19:55:28'), (10408,'INVOICE_TYPE',3,'Value for the invoice type','S','Memo sales',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-05-15 19:55:28','system','2009-05-15 19:55:28'), (10409,'COSTING_ACCESSORIES_TAB',1,'VALUE FOR ACCESSORIES TAB','S','ACCESSORIES',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-05-22 18:45:48','system','2009-05-22 18:45:48'), (10410,'DISPATCH_HEADER_STATUS',1,'VALUE FOR Dispatch header status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-05-22 18:45:48','system','2009-05-22 18:45:48'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10411,'DISPATCH_HEADER_STATUS',2,'VALUE FOR Dispatch header status','S','CONFIRMED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-05-22 18:45:48','system','2009-05-22 18:45:48'), (10412,'PRODUCTION_MANUAL_BAG_NEXT_ACTION',1,'Action chosen for the manual bag process flow','S','Send to Next Process',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-06 18:15:47','system','2009-06-06 18:15:47'), (10413,'PRODUCTION_MANUAL_BAG_NEXT_ACTION',2,'Action chosen for the manual bag process flow','S','Transfer to Finished Goods after this process',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-06 18:15:47','system','2009-06-06 18:15:47'), (10414,'PRODUCTION_MANUAL_BAG_NEXT_ACTION',3,'Action chosen for the manual bag process flow','S','Merge with another bag in this process',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-06 18:15:47','system','2009-06-06 18:15:47'), (10415,'INVENTORY_REPORT_TYPE',1,'RM Stock Reconciliation','S','RM_STOCK_RECONCILIATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-06 18:17:38','system','2009-06-06 18:17:38'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10416,'INVENTORY_REPORT_TYPE',2,'Diamond Stock Reconciliation','S','DIAMOND_STOCK_RECONCILIATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-06 18:17:41','system','2009-06-06 18:17:41'), (10433,'PD_REPORT_TYPE',4,'Gold Loss','S','GOLD_LOSS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'), (10434,'PD_REPORT_TYPE',5,'Process Register','S','PROCESS_REGISTER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'), (10435,'PD_REPORT_TYPE',6,'Wip Drill Down Report','S','WIP_DRILL_DOWN',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'), (10436,'PD_REPORT_TYPE',7,'Delay analysis','S','TOTAL_WIP_DELAY_PROCESS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10437,'PD_REPORT_TYPE',8,'Delay process WIP','S','TOTAL_WIP_DELAY_PROCESS',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'), (10439,'PD_REPORT_TYPE',9,'Total WIP','S','TOTAL_WIP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'), (10440,'PRODUCTION_REPORT_TYPE',5,'Total WIP Bag Pieces','S','TOTAL_WIP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-12 22:16:24','system','2009-06-12 22:16:24'), (10441,'PROD_EXTERNAL_ORDER_REQUEST_TYPE',1,'Production External Order Request Type',NULL,'New Order',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-30 19:45:16','system','2009-06-30 19:45:16'), (10442,'DESIGN_FULL_IMAGE_PATH',1,'Stores the path for the design image','S','FJImages/Ring/Fashion/',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:45:16','system','2009-06-30 19:45:16'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10443,'INVENTORY_ISSUE_TYPE',7,'Inventory issue type ','S','ISSUE TO STOCK TRANSFER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10444,'INVENTORY_RECEIPT_TYPE',8,'Inventory receipt type','S','RECEIPT FROM STOCK TRANSFER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10445,'INVENTORY_ITEM_TYPE',5,'Inventory Item Type','S','WIP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10446,'INVENTORY_RECEIPT_TYPE',9,'Inventory receipt type','S','FROM RECOVERY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10447,'INVENTORY_ISSUE_TYPE',8,'Inventory issue type ','S','ISSUE TO DIAMOND RECOVERY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10448,'INV_FG_RECEIPT_TYPE',4,'Inventory finish good receipt type','S','FROM CUSTOMER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10449,'INV_FG_RECEIPT_TYPE',5,'Inventory finish good receipt type','S','FROM IN-HOUSE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10450,'INV_FG_REPAIR_RETURN_TYPE',1,'Return type for Repair Item','S','REPAIR',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10451,'INV_FG_REPAIR_RETURN_TYPE',2,'Return type for Repair Item','S','SALES-RETURN',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10452,'SALESINV_SOLD_ITEM_PRICE_TYPE',1,'sold item price detail ','S','MRP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10453,'SALESINV_SOLD_ITEM_PRICE_TYPE',2,'sold item price detail ','S','DISCOUNT_VALUE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10454,'SALESINV_SOLD_ITEM_PRICE_TYPE',3,'sold item price detail ','S','NET_SALE_VALUE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10455,'SALESINV_SOLD_ITEM_PRICE_TYPE',4,'sold item price detail ','S','GIFT_ITEM',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10456,'SALESINV_SOLD_ITEM_HDR_STATUS',1,'sold item header status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10457,'SALESINV_SOLD_ITEM_HDR_STATUS',2,'sold item header status','S','CONFIRMED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10458,'SALES_ORDER_TYPE',1,'This param code decides wheteher order is new order or repair order','S','NEW ORDER',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10459,'SALES_ORDER_TYPE',2,'This param code decides wheteher order is new order or repair order','S','REPAIR ORDER',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-06-30 19:54:15','system','2009-06-30 19:54:15'), (10460,'INVENTORY_RECEIPT_TYPE',10,'Inventory receipt type','S','FROM CUSTOMER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10461,'INVENTORY_QC_STATUS',1,'Inventory quality check status ','S','OK',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10462,'INVENTORY_QC_STATUS',2,'Inventory quality check status ','S','NOT_OK',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10463,'INV_FG_WEIGHT_CAPTURE_STATUS',1,'Inventory weight capture status ','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10464,'INV_FG_WEIGHT_CAPTURE_STATUS',2,'Inventory weight capture status ','S','CONFIRMED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10465,'SALESINV_TRANSACTION_TYPE',1,'Buyback','S','BUYBACK',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10466,'SALESINV_TRANSACTION_TYPE',2,'Exchange ','S','EXCHANGE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10467,'SALESINV_DOCUMENT_TYPE',1,'Stock Request ','S','STOCKREQUEST',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10468,'SALESINV_DOCUMENT_TYPE',2,'Invoice','S','INVOICE',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-07 19:33:58','system','2009-07-07 19:33:58'), (10469,'INVENTORY_ISSUE_TYPE',9,'Inventory issue type ','S','ISSUE_TO_SOLD_ITEM_WITH_CUSTOMER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-10 20:12:33','system','2009-07-10 20:12:33'), (10470,'INVENTORY_ISSUE_TO_TYPE',5,'Inventory Issue to type ','S','FG_ISSUE_TO_SOLD_ITEM_WITH_CUSTOMER',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-10 20:12:33','system','2009-07-10 20:12:33'), (10471,'QUICK_QUOTE_CUSTOMER',1,'Individual customer','S','INDIVIDUAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-17 19:42:56','system','2009-07-17 19:42:56'), (10472,'QUICK_QUOTE_CUSTOMER',2,'Customer mapped to organisation','S','ORGANISATION',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-17 19:42:56','system','2009-07-17 19:42:56'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10473,'PRODUCTION_REPORT_TYPE',6,'Bag Status Summary','S','BAG_STATUS_SUMMARY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-17 19:43:07','system','2009-07-17 19:43:07'), (10474,'PD_REPORT_TYPE',12,'Pd Bag Status Summary','S','PD_BAG_STATUS_SUMMARY',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-07-17 19:43:07','system','2009-07-17 19:43:07'), (10475,'INVENTORY_REPORT_TYPE',3,'RM Stock Reconciliation Summary','S','RM_STOCK_RECONCILIATION_SUMMARY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-07-17 19:43:15','system','2009-07-17 19:43:15'), (10476,'INVENTORY_REPORT_TYPE',4,'Diamond Stock Reconciliation Summary','S','DIAMOND_STOCK_RECONCILIATION_SUMMARY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-07-17 19:43:15','system','2009-07-17 19:43:15'), (10477,'SALES_ORDER_DELIVERY_TYPE',1,'Sales Order Delivery Type','S','DNW',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-18 18:19:56','ratnadeepr','2010-05-07 16:25:50'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10478,'SALES_ORDER_DELIVERY_TYPE',2,'Sales Order Delivery Type','S','DNM',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-18 18:19:56','ratnadeepr','2010-05-07 16:25:50'), (10479,'SALES_ORDER_DELIVERY_TYPE',3,'Sales Order Delivery Type','S','SPL',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-20 13:17:06','ratnadeepr','2010-05-07 16:25:50'), (10480,'SALES_ORDER_DELIVERY_TYPE',4,'Sales Order Delivery Type','S','SDN',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-20 13:17:09','ratnadeepr','2010-05-07 16:25:50'), (10481,'SALES_ORDER_DELIVERY_TYPE',5,'Sales Order Delivery Type','S','SDS',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-20 13:17:12','ratnadeepr','2010-05-07 16:25:50'), (10482,'SALES_ORDER_DELIVERY_TYPE',6,'Sales Order Delivery Type','S','SMR',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-20 13:17:14','ratnadeepr','2010-05-07 16:25:50'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10483,'SALES_ORDER_DELIVERY_TYPE',7,'Sales Order Delivery Type','S','SWJ',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-20 13:17:17','ratnadeepr','2010-05-07 16:25:50'), (10484,'SALES_ORDER_DELIVERY_TYPE',8,'Sales Order Delivery Type','S','COJ',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-07-20 13:17:21','ratnadeepr','2010-05-07 16:25:50'), (10485,'INVENTORY_ISSUE_TYPE',10,'Inventory issue type ','S','ISSUE TO PD BAG',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-08-14 21:06:14','system','2009-08-14 21:06:14'), (10486,'INVENTORY_RECEIPT_TYPE',11,'Inventory receipt type','S','RECEIPT FROM PD ',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-08-14 21:06:14','system','2009-08-14 21:06:14'), (10487,'INVENTORY_REPORT_TYPE',5,'FG Stock Reconciliation Summary','S','FG_STOCK_RECONCILIATION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-08-14 21:07:08','system','2009-08-14 21:07:08'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10488,'INVENTORY_ISSUE_LOC_MANDATORY',1,'Inventory issue location mandatory not manndatory param ','S','REQUIRED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-09-04 20:45:22','system','2009-09-04 20:45:22'), (10489,'INVENTORY_REPORT_TYPE',6,'Rm Diamond_stock_position','S','RM_DIAMOND_STOCK_POSITION',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-09-04 20:46:45','system','2009-09-04 20:46:45'), (10490,'SALES_ORDER_DELIVERY_TYPE',9,'Sales Order Delivery Type','S','SAM',NULL,NULL,1,2,'2009-09-22','2999-12-31','system','2009-09-23 13:17:21','ratnadeepr','2010-05-07 16:25:50'), (10491,'INVENTORY_ISSUE_LOCATION',1,'Inventory issue location ','S','inventry issue location for tree stock',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-09-25 13:30:36','system','2009-09-25 13:30:36'), (10492,'INVENTORY_ISSUE_LOCATION',2,'Inventory issue location ','S','inventry issue location for sprue',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-09-25 13:30:36','system','2009-09-25 13:30:36'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10493,'INVENTORY_RECEIPT_LOCATION',1,'Inventory receipt location','S','inventry receipt location for tree stock',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-09-25 13:30:36','system','2009-09-25 13:30:36'), (10494,'INVENTORY_RECEIPT_LOCATION',2,'Inventory receipt location','S','inventry receipt location for sprue',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-09-25 13:30:36','system','2009-09-25 13:30:36'), (10495,'INVENTORY_RECEIPT_LOCATION',3,'Inventory receipt location','S','inventry receipt location for dust ',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-09-25 13:30:36','system','2009-09-25 13:30:36'), (10496,'TREE_TRANSACTION_TYPE',1,'Tree Transaction Type ','S','Issue',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-10-04 23:07:52','system','2009-10-04 23:07:52'), (10497,'TREE_TRANSACTION_TYPE',2,'Tree Transaction Type ','S','Return',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-10-04 23:07:52','system','2009-10-04 23:07:52'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10498,'INVENTORY_RECEIPT_STATUS',4,'Inventory receipt status','S','PARTIALLY_ACCEPTED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-10-10 19:41:20','system','2009-10-10 19:41:20'), (10499,'PD_NDR_REPORT_TYPE',1,'prd ndr report type','S','SUMMARY',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-10-22 21:44:36','system','2009-10-22 21:44:36'), (10500,'PD_NDR_REPORT_TYPE',2,'prd ndr report type','S','DETAIL',NULL,NULL,NULL,NULL,'2010-01-01','2999-12-31','system','2009-10-22 21:44:36','system','2009-10-22 21:44:36'), (10501,'PD_NDR_REPORT_ENTITY_TYPE',1,'prd ndr report entity type ','S','PARENT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-10-22 21:44:36','system','2009-10-22 21:44:36'), (10502,'PD_NDR_REPORT_ENTITY_TYPE',2,'prd ndr report entity type ','S','SUB',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-10-22 21:44:36','system','2009-10-22 21:44:36'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10503,'PD_REPORT_TYPE_MODIFIED',1,'PD NEW REPORT','S','DESIGN_CATALOG',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-06 19:53:51','system','2009-11-06 19:53:51'), (10504,'PD_REPORT_TYPE_MODIFIED',2,'PD NEW REPORT','S','DESIGN_STATUS_REPORT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-06 19:53:51','system','2009-11-06 19:53:51'), (10505,'PD_DES_CAT_RPT_ROW',1,'No of desihn in row ','S','4',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-06 19:53:51','system','2009-11-06 19:53:51'), (10506,'PD_DES_CAT_RPT_ROW',2,'No of desihn in row ','S','6',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-06 19:53:51','system','2009-11-06 19:53:51'), (10508,'DESIGN_FULL_IMAGE_PATH',3,' Stores the path for the design image','S','FJImages/Ring/Fashion/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10509,'DESIGN_FULL_IMAGE_PATH',4,' Stores the path for the design image','S','FJImages/Ring/Mystery/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10510,'DESIGN_FULL_IMAGE_PATH',5,' Stores the path for the design image','S','FJImages/Ring/Mystique/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10511,'DESIGN_FULL_IMAGE_PATH',6,' Stores the path for the design image','S','FJImages/Ring/Presure/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10514,'DESIGN_FULL_IMAGE_PATH',9,' Stores the path for the design image','S','FJImages/Ring/ColorDiamonds/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10515,'DESIGN_FULL_IMAGE_PATH',10,' Stores the path for the design image','S','FJImages/Ring/Men\'sRing/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10516,'DESIGN_FULL_IMAGE_PATH',11,' Stores the path for the design image','S','FJImages/Ring/Bands/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10518,'DESIGN_FULL_IMAGE_PATH',16,' Stores the path for the design image','S','FJImages/Pendant/Fashion/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10519,'DESIGN_FULL_IMAGE_PATH',17,' Stores the path for the design image','S','FJImages/Pendant/Mystery/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10520,'DESIGN_FULL_IMAGE_PATH',18,' Stores the path for the design image','S','FJImages/Pendant/Mystique/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10521,'DESIGN_FULL_IMAGE_PATH',19,' Stores the path for the design image','S','FJImages/Pendant/Presure/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10524,'DESIGN_FULL_IMAGE_PATH',20,' Stores the path for the design image','S','FJImages/Pendant/ColorDaimonds/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10525,'DESIGN_FULL_IMAGE_PATH',21,' Stores the path for the design image','S','FJImages/Pendant/Cross/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10526,'DESIGN_FULL_IMAGE_PATH',22,' Stores the path for the design image','S','FJImages/Pendant/Heart/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10528,'DESIGN_FULL_IMAGE_PATH',28,' Stores the path for the design image','S','FJImages/Earring/Fashion/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10529,'DESIGN_FULL_IMAGE_PATH',29,' Stores the path for the design image','S','FJImages/Earring/Mystery/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10530,'DESIGN_FULL_IMAGE_PATH',30,' Stores the path for the design image','S','FJImages/Earring/Mystique/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10531,'DESIGN_FULL_IMAGE_PATH',31,' Stores the path for the design image','S','FJImages/Earring/Presure/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10534,'DESIGN_FULL_IMAGE_PATH',32,' Stores the path for the design image','S','FJImages/Earring/ColorDiamonds/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10535,'DESIGN_FULL_IMAGE_PATH',33,' Stores the path for the design image','S','FJImages/Earring/Hoop/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10536,'DESIGN_FULL_IMAGE_PATH',34,' Stores the path for the design image','S','FJImages/Earring/Chandeliers/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10538,'DESIGN_FULL_IMAGE_PATH',39,' Stores the path for the design image','S','FJImages/Bangle/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10546,'DESIGN_FULL_IMAGE_PATH',49,' Stores the path for the design image','S','FJImages/Necklace/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10554,'DESIGN_FULL_IMAGE_PATH',59,' Stores the path for the design image','S','FJImages/Bracelet/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10555,'DESIGN_FULL_IMAGE_PATH',60,' Stores the path for the design image','S','FJImages/NeckTanmani/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10557,'DESIGN_FULL_IMAGE_PATH',62,' Stores the path for the design image','S','FJImages/Components/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10558,'DESIGN_FULL_IMAGE_PATH',63,' Stores the path for the design image','S','FJImages/Collet/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10559,'DESIGN_FULL_IMAGE_PATH',64,' Stores the path for the design image','S','FJImages/Chain/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10560,'DESIGN_FULL_IMAGE_PATH',65,' Stores the path for the design image','S','FJImages/CuffLinks/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10561,'DESIGN_FULL_IMAGE_PATH',66,' Stores the path for the design image','S','FJImages/NosePin/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10562,'DESIGN_FULL_IMAGE_PATH',67,' Stores the path for the design image','S','FJImages/CoatPin/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10563,'DESIGN_FULL_IMAGE_PATH',68,' Stores the path for the design image','S','FJImages/Findings/',NULL,NULL,2,2,'1900-01-01','2099-12-31','tsd','2007-11-09 00:00:00','tsd','2007-11-09 00:00:00'), (10564,'PROCUREMENT_REQUEST_TYPE',1,'Procurement Request Type','S','Raw Material',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10565,'PROCUREMENT_REQUEST_TYPE',2,'Procurement Request Type','S','Diamond & Stones',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10566,'PROCUREMENT_REQUEST_TYPE',3,'Procurement Request Type','S','Design Variant',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10567,'SHIPMENT_MODE',1,'Shipment Mode','S','Road',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10568,'SHIPMENT_MODE',2,'Shipment Mode','S','Air',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10569,'SHIPMENT_MODE',3,'Shipment Mode','S','Sea',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10570,'PROCUREMENT_PO_STATUS',1,'Purchase Order Status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10571,'PROCUREMENT_PO_STATUS',2,'Purchase Order Status','S','PENDING_APPROVAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10572,'PROCUREMENT_PO_STATUS',3,'Purchase Order Status','S','APPROVED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10573,'PROCUREMENT_PO_STATUS',4,'Purchase Order Status','S','CANCEL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10574,'PROCUREMENT_PO_STATUS',5,'Purchase Order Status','S','HOLD',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10575,'PROCUREMENT_PO_TYPE',1,'Purchase Order Type','S','Normal P.O',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10576,'PROCUREMENT_PO_TYPE',2,'Purchase Order Type','S','For Samples',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:29:38','system','2009-11-08 18:29:38'), (10577,'PROCUREMENT_REQUEST_STATUS',1,'Procurement Request Status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'), (10578,'PROCUREMENT_REQUEST_STATUS',2,'Procurement Request Status','S','PENDING_APPROVAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10579,'PROCUREMENT_REQUEST_STATUS',3,'Procurement Request Status','S','APPROVED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'), (10580,'PROCUREMENT_REQUEST_STATUS',4,'Procurement Request Status','S','CANCEL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'), (10581,'PROCUREMENT_REQUEST_STATUS',5,'Procurement Request Status','S','HOLD',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'), (10582,'PROCUREMENT_REQUEST_STATUS',6,'Procurement Request Status','S','CLOSED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'), (10583,'PROCUREMENT_REQUEST_STATUS',7,'Procurement Request Status','S','REJECT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:32:20','system','2009-11-08 18:32:20'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10584,'QUOTATION_CAPTURE_STATUS',1,'Quotation Capture Status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:33:22','system','2009-11-08 18:33:22'), (10585,'QUOTATION_CAPTURE_STATUS',2,'Quotation Capture Status','S','PENDING_APPROVAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:33:22','system','2009-11-08 18:33:22'), (10586,'QUOTATION_CAPTURE_STATUS',3,'Quotation Capture Status','S','APPROVED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:33:22','system','2009-11-08 18:33:22'), (10587,'QUOTATION_CAPTURE_STATUS',4,'Quotation Capture Status','S','CANCEL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:33:22','system','2009-11-08 18:33:22'), (10588,'QUOTATION_CAPTURE_STATUS',5,'Quotation Capture Status','S','HOLD',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:33:22','system','2009-11-08 18:33:22'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10589,'PROC_QUOTATION_REQUEST_STATUS',1,'Procurement Quotation Request Status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:34:24','system','2009-11-08 18:34:24'), (10590,'PROC_QUOTATION_REQUEST_STATUS',2,'Procurement Quotation Request Status','S','PENDING_APPROVAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:34:24','system','2009-11-08 18:34:24'), (10591,'PROC_QUOTATION_REQUEST_STATUS',3,'Procurement Quotation Request Status','S','APPROVED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:34:24','system','2009-11-08 18:34:24'), (10592,'PROC_QUOTATION_REQUEST_STATUS',4,'Procurement Quotation Request Status','S','CANCEL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:34:24','system','2009-11-08 18:34:24'), (10593,'PROC_QUOTATION_REQUEST_STATUS',5,'Procurement Quotation Request Status','S','HOLD',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 18:34:24','system','2009-11-08 18:34:24'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10594,'PROCUREMENT_VENDOR_STATUS',1,'Procurement Vendor Status','S','NEW',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 20:05:02','system','2009-11-08 20:05:02'), (10595,'PROCUREMENT_VENDOR_STATUS',2,'Procurement Vendor Status','S','PENDING_APPROVAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 20:05:02','system','2009-11-08 20:05:02'), (10596,'PROCUREMENT_VENDOR_STATUS',3,'Procurement Vendor Status','S','APPROVED',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-08 20:05:02','system','2009-11-08 20:05:02'), (10597,'PD_REPORT_TYPE_MODIFIED',3,'PD NEW REPORT','S','DESIGN_DETAIL_CARD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-12 21:35:35','system','2009-11-12 21:35:35'), (10598,'PD_NEW_REPORT_TYPE ',1,'PD REPORT NEW','S','PD_REJECTION_ANALYSIS',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-12 21:35:35','system','2009-11-12 21:35:35'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10599,'PD_REJECTION_ANALYSIS_STATUS ',1,'Pd rejection analysis search status','S','REJECT',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-12 21:35:35','system','2009-11-12 21:35:35'), (10600,'PD_REJECTION_ANALYSIS_STATUS ',2,'Pd rejection analysis search status ','S','REWORK',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-12 21:35:35','system','2009-11-12 21:35:35'), (10601,'PD_REJECTION_ANALYSIS_STATUS ',3,'Pd rejection analysis search status ','S','HOLD',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2009-11-12 21:35:35','system','2009-11-12 21:35:35'), (10603,'DESIGN_FULL_IMAGE_PATH',7,'Stores the path for the design image','S','FJImages/Ring/FineExclusive/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10604,'DESIGN_FULL_IMAGE_PATH',8,'Stores the path for the design image','S','FJImages/Ring/MRM/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10605,'DESIGN_FULL_IMAGE_PATH',12,'Stores the path for the design image','S','FJImages/Ring/EndoEuro/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10606,'DESIGN_FULL_IMAGE_PATH',13,'Stores the path for the design image','S','FJImages/Ring/Local/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10607,'DESIGN_FULL_IMAGE_PATH',14,'Stores the path for the design image','S','FJImages/Ring/Bridal/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10608,'DESIGN_FULL_IMAGE_PATH',23,'Stores the path for the design image','S','FJImages/Pendant/FineExclusive/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10609,'DESIGN_FULL_IMAGE_PATH',24,'Stores the path for the design image','S','FJImages/Pendant/MRM/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10610,'DESIGN_FULL_IMAGE_PATH',25,'Stores the path for the design image','S','FJImages/Pendant/EndoEuro/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10611,'DESIGN_FULL_IMAGE_PATH',26,'Stores the path for the design image','S','FJImages/Pendant/Local/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10612,'DESIGN_FULL_IMAGE_PATH',35,'Stores the path for the design image','S','FJImages/Earring/FineExclusive/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10613,'DESIGN_FULL_IMAGE_PATH',36,'Stores the path for the design image','S','FJImages/Earring/MRM/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10614,'DESIGN_FULL_IMAGE_PATH',37,'Stores the path for the design image','S','FJImages/Earring/EndoEuro/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10615,'DESIGN_FULL_IMAGE_PATH',38,'Stores the path for the design image','S','FJImages/Earring/Local/',NULL,NULL,2,2,'2009-11-18','2099-12-31',' tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10624,'DESIGN_FULL_IMAGE_PATH',70,'Stores the path for the design image','S','corel/',NULL,NULL,2,2,'2009-11-18','2099-12-31','tsd','2009-11-17 00:00:00',' tsd','2009-11-17 00:00:00'), (10625,'COSTING_UOM_CATEGORY',4,'Costing Uom Category','S','DIAMONDWEIGHT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-20 18:05:42','system','2009-11-20 18:05:42'), (10626,'DESIGN_MOULD_TYPE',1,'Design Mould Type','S','RTV Mould',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-20 20:00:36','system','2009-11-20 20:00:36'), (10627,'DESIGN_MOULD_TYPE',2,'Design Mould Type','S','HTV Mould',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2009-11-20 20:00:36','system','2009-11-20 20:00:36'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10628,'COSTING_ADDITIONAL_COST_TAB',2,'Loss Percentage','S','LOSS PERCENTAGE',NULL,NULL,NULL,2,'1900-01-01','2999-12-31','system','2009-04-17 20:57:42','system','2009-04-17 20:57:42'), (10629,'INVENTORY_LOCATION_TYPE',9,'Inventory Location Type ','S','Return Items production ',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-01-17 03:37:07','system','2010-01-17 03:37:07'), (10630,'CORE_DOCUMENT_TYPE',1,'Document Type','S','Purchase Order',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-02-02 20:07:55','system','2010-02-02 20:07:55'), (10631,'CORE_DOCUMENT_TYPE',2,'Document Type','S','Invoice',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-02-02 20:07:55','system','2010-02-02 20:07:55'), (10632,'DESIGN_FULL_IMAGE_PATH',71,'Stores the path for the design image','S','FJImages/Ensembles/',NULL,NULL,2,2,'2010-03-08','2099-12-31','tsd','2010-03-08 00:00:00','tsd','2010-03-08 00:00:00'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10633,'SALES_INV_REPORT_TYPE',1,'Sales invoice report type','S','Profitability Summary Report',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2010-03-08 20:07:19','system','2010-03-08 20:07:19'), (10634,'SALES_INV_REPORT_TYPE',2,'Sales invoice report type','S','Profitability Detail Report',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2010-03-08 20:07:19','system','2010-03-08 20:07:19'), (10635,'SALES_INV_REPORT_TYPE',3,'Sales invoice report type','S','Pending Sales Order Report',NULL,NULL,NULL,NULL,'1900-01-01','2999-12-31','system','2010-03-08 20:07:19','system','2010-03-08 20:07:19'), (10636,'INVENTORY_ISSUE_TO_TYPE',6,'Inventory issue to type ','S','Inventory Location',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-03-11 20:05:56','system','2010-03-11 20:05:56'), (10637,'INVENTORY_ISSUE_TO_TYPE',7,'Inventory issue to type','S','Back to Production Process',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-03-11 20:05:56','system','2010-03-11 20:05:56'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10638,'SALES_ORDER_DELIVERY_TYPE',10,'Sales Order Delivery Type','S','SSL',NULL,NULL,1,2,'2009-09-22','2999-12-31','tsd','2010-04-07 16:14:34','ratnadeepr','2010-05-07 16:25:50'), (10639,'RM_REQUIREMENT_REPORT',1,'Rm Requirmrnt Report','S','Rm requirement on Location',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-05-01 16:45:05','system','2010-05-01 16:45:05'), (10640,'RM_REQUIREMENT_REPORT',2,'Rm Requirmrnt Report','S','Rm Requirmrnt on Static',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-05-01 16:45:05','system','2010-05-01 16:45:05'), (10641,'TRIAL_PRODUCTION_REPORT',1,'Trial production report','S','TOTAL_WIP',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-05-05 19:55:03','system','2010-05-05 19:55:03'), (10642,'TRIAL_PRODUCTION_REPORT',2,'Trial production report','S','DAILY_OUTPUT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-05-05 19:55:03','system','2010-05-05 19:55:03'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10643,'TRIAL_PRODUCTION_REPORT',3,'Trial production report','S','PRODUCTION_CYCLE_TIME_MODEL_TRIAL',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-05-05 19:55:03','system','2010-05-05 19:55:03'), (10644,'TRIAL_PRODUCTION_REPORT',4,'Trial production report','S','BAG_MOVEMENT_REPORT',NULL,NULL,2,2,'1900-01-01','2999-12-31','system','2010-05-05 19:55:03','system','2010-05-05 19:55:03'), (10645,'SALES_ORDER_DELIVERY_TYPE',11,'Sales Order Delivery Type','S','MTR',NULL,NULL,1,2,'2009-09-22','2999-12-31','ratnadeepr','2010-05-07 16:25:50','ratnadeepr','2010-05-07 16:25:50'), (10646,'COSTING_ADDITIONAL_COST_TAB',3,'Alloy handling cost','S','Alloy handling cost',NULL,NULL,NULL,NULL,'2010-05-18','2999-12-31','tsd','2009-04-17 20:29:39','system','2009-04-17 20:29:39'), (10647,'COSTING_UOM_CATEGORY',5,'Costing Uom Category','S','GOLDWEIGHT',NULL,NULL,NULL,NULL,'2010-05-18','2999-12-31','tsd','2009-04-17 20:29:39','system','2009-04-17 20:29:39'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10648,'COSTING_UOM_CATEGORY',6,'Costing Uom Category','S','PER_PIECE',NULL,'0000-00-00',NULL,NULL,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10649,'COSTING_UOM_CATEGORY',7,'Costing Uom Category','S','PER_DIAMOND',NULL,'0000-00-00',NULL,NULL,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10650,'COSTING_UOM_CATEGORY',8,'Costing Uom Category','S','PER_COLOR_STONE',NULL,'0000-00-00',NULL,NULL,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10651,'DISPATCHMODE',1,'DISPATCHMODE','S','FOB',NULL,NULL,1,2,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10652,'DISPATCHMODE',2,'DISPATCHMODE','S','CIF',NULL,NULL,1,2,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10653,'DISPATCHMODE',3,'DISPATCHMODE','S','C&F',NULL,NULL,1,2,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10654,'INVOICE_TEMPLATE_TYPE',1,'INVOICE_TEMPLATE_TYPE','S','template1',NULL,NULL,1,2,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10655,'INVOICE_TEMPLATE_TYPE',2,'INVOICE_TEMPLATE_TYPE','S','template2',NULL,NULL,1,2,'2010-05-18','2999-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10656,'COSTING_ADDITIONAL_COST_TAB',4,'Gold Handling Cost','S','Gold Handling Cost',NULL,NULL,1,2,'2010-06-03','2099-12-31','tsd','2009-05-28 20:29:39','system','2009-05-28 20:29:39'), (10657,'DMS_OBJECT',1,'Entity','S','Entity',NULL,'0000-00-00',2,NULL,'1900-01-01','2999-12-31','system','2010-06-21 19:38:44','system','2010-06-21 19:38:44'), (10658,'DMS_OBJECT',2,'Design','S','Design',NULL,'0000-00-00',2,NULL,'1900-01-01','2999-12-31','system','2010-06-21 19:42:24','system','2010-06-21 19:42:24'); INSERT INTO `core_parameter_master` (`parameter_id`,`param_code`,`sequence_number`,`param_description`,`value_data_type`,`value_text`,`value_numeric`,`value_date`,`editable`,`record_deleted`,`effective_date_from`,`effective_date_to`,`created_by`,`created_date`,`modified_by`,`modified_date`) VALUES (10659,'ABC',1,'abc','S','one',NULL,NULL,2,2,'1900-01-01','2999-12-31','tsd','2010-06-22 17:27:16','tsd','2010-06-22 17:27:16'), (10660,'ENTITY_FULL_IMAGE_PATH',6,'Stores the path for the entity image','S','cad1/',NULL,NULL,2,2,'1900-02-01','3000-01-31','tsd','2010-06-22 17:54:22','tsd','2010-06-22 17:54:22'), (10661,'ENTITY_FULL_IMAGE_PATH',7,'Stores the path for the entity image','S','cad1/cad2/',NULL,NULL,2,2,'1900-02-01','3000-01-31','tsd','2010-06-22 17:55:01','tsd','2010-06-22 17:55:01'), (10662,'ENTITY_FULL_IMAGE_PATH',8,'Stores the path for the entity image','S','cad1/cad2/Vijay/',NULL,NULL,2,2,'1900-02-01','3000-01-31','tsd','2010-06-22 20:40:34','tsd','2010-06-22 20:40:34'), (10663,'ENTITY_FULL_IMAGE_PATH',9,'Stores the path for the entity image','S','cad1/cad2/Vijay/Raghav/',NULL,NULL,2,2,'1900-02-01','3000-01-31','tsd','2010-06-22 20:49:33','tsd','2010-06-22 20:49:33'), (10664,'ENTITY_FULL_IMAGE_PATH',10,'Stores the path for the entity image','S','VII/',NULL,NULL,2,2,'1900-02-01','3000-01-31','tsd','2010-06-24 11:31:20','tsd','2010-06-24 11:31:20'); /*!40000 ALTER TABLE `core_parameter_master` ENABLE KEYS */; /*!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 */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;