QRY|INSERT IGNORE INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
(88, 'Docket Number', 'courier/docketNumber', 2, 14, 'docket_no', 1, 13, '2019-11-25 15:14:31'),
(89, 'Customer Type', 'customerCategory', 2, 0, 'customer_category', 1, 13, '2019-12-10 12:43:32'),
(90, 'Pincode Service', 'courier/pincode', 2, 15, '', 1, 13, '2020-01-02 12:17:23'),
(91, 'Payment Gateway', 'PaymentGateway', 2, 16, 'point-of-service', 1, 1, '2020-01-24 13:26:13');
**
ADD_CLM|tel_item_master|md_date|DATETIME||Y|NULL|ip_address
**
CRT_TBL|tel_item_rate_master|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`item_id` INT(11) NULL DEFAULT NULL,
	`customer_type` INT(11) NULL DEFAULT NULL,
	`item_rate` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	`item_total_rate` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	PRIMARY KEY (`id`)
**
CRT_TBL|tel_courier_pincode|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`courier_id` INT(11) NULL DEFAULT NULL,
	`pin_code` VARCHAR(50) NULL DEFAULT NULL,
	`origin_area` VARCHAR(255) NULL DEFAULT NULL,
	`process_code` VARCHAR(255) NULL DEFAULT NULL,
	`cr_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`cr_usr` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
**
ADD_CLM|tel_order_master|order_created_by_id|INT|11|Y|NULL|courier_expected_del_date
**
ADD_CLM|tel_order_master|expected_carrier_id|INT|11|Y|NULL|order_created_by_id
**
ADD_CLM|cds_users_master|orderby_change_rights|TINYINT|4|N|0|master_type
**
ADD_CLM|tel_courier_api|pincode_servicability_url|VARCHAR|255|Y|NULL|api_tracking_url
**
ADD_CLM|cds_company|razorpay_api_key|VARCHAR|255|Y|NULL|courier_slip_product_name
**
ADD_CLM|cds_company|razorpay_api_secret|VARCHAR|255|Y|NULL|razorpay_api_key
**
ADD_CLM|tel_order_master|paymentgateway|TINYINT|4|Y|NULL|expected_carrier_id
**
ADD_CLM|tel_order_master|payment_confirm_id|VARCHAR|255|Y|NULL|paymentgateway
**
ADD_CLM|tel_order_master|payment_response_json|TEXT||Y|NULL|payment_confirm_id
**
ADD_CLM|tel_branch_master|isDefault|TINYINT|4|N|0|updated_time 
**
ADD_CLM|tel_lead_type|isDefault|TINYINT|4|N|0|status 
**
ADD_CLM|tel_payment_type|isDefault|TINYINT|4|N|0|created_by_website
**
DRP_CLM|cds_company|razorpay_api_key
**
DRP_CLM|cds_company|razorpay_api_secret
**
ADD_CLM|tel_order_master|transaction_date_time|DATETIME||Y|NULL|payment_response_json
**
CRT_TBL|tel_payment_gateway|`id` int(11) NOT NULL AUTO_INCREMENT,
  `api` varchar(255) DEFAULT NULL,
  `mode` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `key` varchar(255) DEFAULT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `channel` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `productionUrl` varchar(255) DEFAULT NULL,
  `stageUrl` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `client` varchar(255) DEFAULT NULL,
  `isDefault` enum('1','0') NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1 active 2 inactive',
  PRIMARY KEY (`id`)
**
ADD_CLM|tel_quotation_master|paymentgateway|VARCHAR|50|Y|NULL|pdfline_count
**
ADD_CLM|tel_quotation_master|payment_confirm_id|TEXT||Y|NULL|paymentgateway
**
ADD_CLM|tel_quotation_master|payment_response_json|TEXT||Y|NULL|payment_confirm_id
**
ADD_CLM|tel_quotation_master|transaction_date_time|DATETIME||Y|NULL|payment_response_json
**
ADD_CLM|tel_order_message_template|tempKey|TEXT||Y|NULL|time_updated 
**
ADD_CLM|cds_company|public_url|VARCHAR|255|Y|NULL|courier_slip_product_name 
**
ADD_CLM|cds_company|custom_order_url|VARCHAR|500|Y|NULL|public_url
**
ADD_CLM|tel_order_master|vpp_disc_percentage|DECIMAL|10,2|N|0.00|round_off_amt
**
ADD_CLM|tel_order_master|vpp_disc_amt|DECIMAL|10,2|N|0.00|vpp_disc_percentage
**
CRT_TBL|tel_purchasereturn_master|`id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `vendor_id` int(11) DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `voucher_date` date DEFAULT NULL,
  `invoice_number` varchar(70) DEFAULT NULL,
  `no_gst` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 gst applicable 1 not applicable',
  `notes` text,
  `total_no_item` int(11) DEFAULT NULL,
  `gross_amt` decimal(20,2) DEFAULT NULL,
  `discount_amt` decimal(20,2) DEFAULT NULL,
  `tax_amt` decimal(20,2) DEFAULT NULL,
  `round_off_amt` decimal(20,2) DEFAULT NULL,
  `net_amt` decimal(20,2) DEFAULT NULL,
  `md_usr` int(11) DEFAULT NULL,
  `md_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `cr_usr` int(11) DEFAULT NULL,
  `cr_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `purchase_update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
**
CRT_TBL|tel_purchasereturn_itemlist|`list_id` int(11) NOT NULL AUTO_INCREMENT,
  `prtn_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `hsn_sac_code` varchar(20) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `final_rate` decimal(20,2) DEFAULT NULL,
  `discount` decimal(20,2) DEFAULT NULL,
  `discount_amount` decimal(20,2) DEFAULT NULL,
  `qty` decimal(20,2) DEFAULT NULL,
  `free_qty` decimal(20,2) NOT NULL DEFAULT '0.00',
  `unit` varchar(20) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `tax_percentage` decimal(20,2) DEFAULT NULL,
  `tax_amount` decimal(20,2) DEFAULT NULL,
  `total_amount` decimal(20,2) DEFAULT NULL,
  `cr_usr` int(11) DEFAULT '0',
  PRIMARY KEY (`list_id`)
**
CRT_TBL|tel_purchasereturn_taxlist| `list_id` int(11) NOT NULL AUTO_INCREMENT,
  `prtn_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(200) DEFAULT NULL,
  `tax_id` int(11) DEFAULT NULL,
  `tax_name` varchar(100) DEFAULT NULL,
  `tax_percentage` decimal(20,2) DEFAULT NULL,
  `taxable_amount` decimal(20,2) DEFAULT NULL,
  `tax_amount` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`list_id`)
**
QRY|INSERT IGNORE INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
(92, 'Purchase return', 'javascript:void(0)', 0, 6, 'purchase_return', 0, 1, '2020-02-21 10:28:11'),
(93, 'Purchase Return Entry', 'purchasereturn/entry', 92, 1, 'to-do-list', 1, 1, '2020-02-21 10:21:03'),
(94, 'Purchase return List', 'purchasereturn', 92, 2, 'rent', 1, 1, '2020-02-21 10:21:42'),
(95, 'Stockout Inventory', 'stockoutInventory', 2, 17, 'add_inventory', 1, 1, '2020-03-25 18:36:32');
**
ADD_CLM|tel_branch_master|agent_dial_url|VARCHAR|1000|Y|NULL|dial_api_url
**
ADD_CLM|cds_company|order_limit_for_pending|INT||N|0|custom_order_url
**
ADD_CLM|cds_company|order_limit_for_rto|INT||N|0|order_limit_for_pending
**
ADD_CLM|cds_company|order_limit_for_rto_continue|TINYINT||N|1|order_limit_for_rto
**
ADD_CLM|tel_order_courier|courier_voulmetric_weight|DECIMAL|10,2|N|0.00|customer_origin_area
**
ADD_CLM|tel_order_courier|courier_packing_type|VARCHAR|150|Y|NULL|courier_voulmetric_weight
**
CRT_TBL|tel_stockout_inventory|`inv_id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `inventory_date` date DEFAULT NULL,
  `notes` text,
  `item_count` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cr_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `md_date` datetime DEFAULT NULL,
  `cr_usr` int(11) DEFAULT NULL,
  `md_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`inv_id`)
**
CRT_TBL|tel_stockout_inventory_item|`list_id` INT(11) NOT NULL AUTO_INCREMENT,
	`inv_id` INT(11) NULL DEFAULT NULL,
	`item_id` INT(11) NULL DEFAULT NULL,
	`qty` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`rto_qty` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
	`md_date` DATETIME NULL DEFAULT NULL,
	`cr_usr` INT(11) NULL DEFAULT NULL,
	`md_usr` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`list_id`)
**
ADD_CLM|tel_item_master|allow_negative_stock|TINYINT||N|1|including_tax
**
ADD_CLM|tel_order_courier|totime_hour|VARCHAR|50|Y|NULL|pickup_minutes
**
ADD_CLM|tel_order_courier|totime_minutes|VARCHAR|50|Y|NULL|totime_hour
**
CRT_TBL|tel_inventory_type|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`inventory_type_name` VARCHAR(250) NULL COLLATE 'latin1_swedish_ci',
	`status` INT(11) NOT NULL DEFAULT '1' COMMENT '1 active 2 inactive',
	`ip_address` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
	`time_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`time_updated` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`created_by_website` TINYINT(4) NOT NULL DEFAULT '0',
	`isDefault` TINYINT(4) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|tel_stockout_inventory|inventory_type_id|INT||Y|NULL|branch_id
**
ADD_CLM|tel_order_master|rto_date|DATE||Y|NULL|payment_date
**
CRT_TBL|tel_dashboard_data|`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
	`title` VARCHAR(250) NULL COLLATE 'latin1_swedish_ci',
	`data` LONGTEXT NULL COLLATE 'latin1_swedish_ci',
	`cr_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`cr_usr` INT(11) NULL,
	PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|tel_order_item_list|including_tax|TINYINT||N|0|rate
**
ADD_CLM|tel_order_item_list|mrp|DECIMAL|20,2|N|0.00|including_tax
**
QRY|INSERT IGNORE INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
(97, 'Open Orders', 'itemOrder/openedOrder', 70, 5, 'order_open', 1, 1, '2020-07-14 17:03:48');
**
ADD_CLM|tel_order_master|is_open|TINYINT||N|0|transaction_date_time
**
ADD_CLM|tel_order_master|opened_by|INT||Y|NULL|is_open
**
ADD_CLM|tel_order_master|opened_time|DATETIME||Y|NULL|opened_by
**
ADD_CLM|notification|response|TEXT||Y|NULL|time
**
ADD_CLM|notification|cron_job|TINYINT||N|0|response
**
CRT_TBL|tel_order_ewaybill|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_id` BIGINT(20) NULL,
	`transporter_name` VARCHAR(250) NULL COLLATE 'latin1_swedish_ci',
	`transporter_id` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
	`distance` INT(11) NOT NULL DEFAULT '0',
	`mode` INT(50) NULL,
	`vehicle_type` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
	`vehicle_no` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
	`trans_docno` VARCHAR(250) NULL COLLATE 'latin1_swedish_ci',
	`trans_docdate` DATE NULL,
	PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|tel_branch_master|vpp_address|TEXT||Y|NULL|isDefault
**
ALT_CLM|notification|send_to|send_to|VARCHAR|1000|Y|NULL|message_type
**
QRY|INSERT IGNORE INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
	(98, 'Email Logs', 'userLogs/emailLogs', 4, 6, 'email_logs', 1, 1, '2020-08-14 14:25:59')