ADD_CLM|tel_itemcategory_master|total_tax|DECIMAL|20,2|N|0.00|hsn_code
**
ADD_CLM|tel_item_master|total_rate|DECIMAL|20,2|N|0.00|rate
**
ADD_CLM|tel_item_master|including_tax|TINYINT|4|N|0|total_rate
**
ADD_CLM|tel_item_master|image|VARCHAR|500|Y|NULL|including_tax
**
ADD_CLM|tel_order_master|quotation_id|INT|11|Y|NULL|dealer_id
**
QRY|DELETE FROM `cds_menu_master`
**
QRY|INSERT INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
	(1, 'Home', 'home', 0, 1, 'home', 1, 8, '2018-08-02 17:22:27'),
	(2, 'Master', 'javascript:void(0)', 0, 4, 'master', 0, 8, '2018-08-02 17:38:06'),
	(3, 'Users & Roles', 'javascript:void(0)', 0, 3, 'team', 0, 8, '2018-08-02 17:23:43'),
	(4, 'Setting', 'javascript:void(0)', 0, 10, 'settings', 0, 8, '2018-08-02 18:23:04'),
	(5, 'Logout', 'logout', 0, 18, 'exit', 1, 8, '2018-08-03 11:24:43'),
	(6, 'All Users', 'users', 3, 3, 'collaboration', 1, 8, '2018-08-02 17:32:08'),
	(7, 'Users Permissions', 'users/userpermissions', 3, 4, 'left-luggage', 1, 8, '2018-08-02 17:35:13'),
	(8, 'Company Details', 'company', 4, 1, 'enterprise', 1, 8, '2018-08-02 18:27:13'),
	(9, 'Menu Master', 'menu', 4, 0, 'menu-list', 1, 8, '2018-08-02 18:25:00'),
	(11, 'Changes Password', 'users/changepassword', 4, 4, 'key', 1, 0, '2018-02-14 01:52:38'),
	(49, 'Group Permission', 'users/group', 3, 2, 'key', 1, 8, '2018-08-02 17:27:59'),
	(50, 'Location', 'javascript:void(0)', 0, 7, 'placeholder', 0, 11, '2018-08-31 16:16:59'),
	(51, 'State', 'state', 50, 1, 'state', 1, 11, '2018-08-03 12:55:21'),
	(52, 'City', 'city', 50, 2, 'city', 1, 11, '2018-08-03 12:55:34'),
	(53, 'Pincode', 'pincode', 50, 3, 'pincode', 1, 11, '2018-08-03 12:48:42'),
	(54, 'Tax Master', 'tax', 2, 1, 'tax', 1, 8, '2018-08-02 17:40:22'),
	(55, 'Item Category', 'itemcategory', 2, 2, 'to-do', 1, 8, '2018-08-02 17:42:00'),
	(56, 'Item', 'item', 2, 4, 'item-group', 1, 8, '2018-08-02 17:43:05'),
	(57, 'Customer/Vendor', 'customer', 2, 0, 'customer', 1, 8, '2018-08-02 17:39:03'),
	(58, 'Order Status', 'orderStatus', 2, 6, 'stairs', 1, 8, '2018-09-14 11:47:13'),
	(59, 'Payment Master', 'paymentType', 2, 7, 'point-of-service', 1, 8, '2018-08-02 17:52:43'),
	(60, 'Courier Master', 'courier', 2, 7, 'courier', 1, 8, '2018-08-02 17:50:16'),
	(61, 'User Group', 'users/userGroup', 3, 1, 'workers', 1, 8, '2018-09-10 12:48:17'),
	(62, 'Item Group Master', 'itemGroup', 2, 3, 'check-mark', 1, 8, '2018-08-02 17:44:40'),
	(63, 'Item Package Master', 'ItemPackage', 2, 5, 'sent', 1, 8, '2018-08-02 17:46:39'),
	(64, 'Branch', 'branch', 4, 2, 'company', 1, 8, '2018-08-02 18:36:16'),
	(65, 'Item Stock', 'itemStock', 2, 10, 'stock', 1, 8, '2018-09-14 11:43:39'),
	(66, 'Purchase', 'javascript:void(0)', 0, 6, 'delivery-cart', 0, 8, '2018-08-02 18:50:27'),
	(67, 'Entry', 'purchase/entry', 66, 1, 'to-do-list', 1, 8, '2018-08-02 18:51:58'),
	(68, 'Purchase list', 'purchase', 66, 2, 'rent', 1, 8, '2018-08-02 18:19:07'),
	(69, 'Message Templates', 'template', 2, 6, 'email', 1, 8, '2018-08-02 17:49:11'),
	(70, 'Orders', 'javascript:void(0)', 0, 4, 'order-sent', 0, 11, '2018-08-31 16:15:57'),
	(71, 'Place Order', 'itemOrder/entry', 70, 3, 'choice', 1, 1, '2018-12-19 11:41:17'),
	(72, 'Lead Type Master', 'leadtype', 2, 11, 'meeting', 1, 8, '2018-08-02 17:56:18'),
	(73, 'Order List', 'itemOrder', 70, 4, 'list', 1, 1, '2018-12-19 11:41:41'),
	(74, 'User Logs', 'userLogs', 4, 6, 'boss', 1, 8, '2018-08-03 11:22:58'),
	(75, 'Order Logic', 'orderLogic', 4, 5, 'list-order', 1, 8, '2018-08-03 11:20:08'),
	(76, 'Report & Analysis', 'javascript:void(0)', 0, 5, 'charts', 0, 1, '2018-10-10 17:51:25'),
	(77, 'Item Inventory', 'report/itemReport', 76, 1, 'report_item', 1, 8, '2018-08-24 13:58:06'),
	(78, 'Order', 'report/orderReport', 76, 2, 'graph', 1, 8, '2018-08-24 13:58:31'),
	(79, 'Coupons', 'coupons', 2, 12, 'discount', 1, 1, '2018-09-21 10:04:18'),
	(80, 'License', 'softwareLicense', 4, 7, 'license', 1, 1, '2018-10-05 10:10:38'),
	(81, 'Current Login User', 'users/currentLoginUsers', 4, 6, 'current_login', 1, 1, '2018-10-04 11:05:28'),
	(82, 'Update softwares', 'updatesoft', 4, 9, 'refresh', 1, 1, '2018-10-08 13:22:19'),
	(83, 'Analytics', 'orderAnalytics', 76, 3, 'analytics', 1, 1, '2018-10-10 17:53:43'),
	(84, 'GST Report', 'report/gstReport', 76, 4, 'gst_report', 1, 1, '2018-12-05 10:20:12'),
	(85, 'Create Quotation', 'Quotation/entry', 70, 1, 'add_quotation', 1, 1, '2018-12-19 11:40:18'),
	(86, 'View Quotations', 'Quotation', 70, 2, 'view_quotation', 1, 1, '2018-12-19 11:40:57')
**
CRT_TBL|tel_quotation_master|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`customer_order_id` VARCHAR(70) NULL DEFAULT NULL,
	`branch_id` INT(11) NULL DEFAULT NULL,
	`customer_id` INT(11) NULL DEFAULT NULL,
	`address_id` INT(11) NULL DEFAULT NULL,
	`customer_address` TEXT NULL,
	`same_as_shipping` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1 Same as Billing 0 diffrent',
	`customer_billing_address` TEXT NULL,
	`customer_detail` TEXT NULL,
	`customer_type` VARCHAR(15) NULL DEFAULT 'Customer',
	`package_id` VARCHAR(50) NULL DEFAULT NULL COMMENT 'Comma seprated Multiple package IDs',
	`dealer_id` INT(11) NULL DEFAULT NULL,
	`order_assign_type` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0 self 1 dealer',
	`lead_type` INT(11) NULL DEFAULT NULL,
	`payment_type` INT(11) NULL DEFAULT NULL,
	`notes` TEXT NULL,
	`total_no_item` INT(11) NULL DEFAULT NULL,
	`gross_amt` DECIMAL(20,2) NULL DEFAULT NULL,
	`discount_amt` DECIMAL(20,2) NULL DEFAULT '0.00',
	`tax_amt` DECIMAL(20,2) NULL DEFAULT NULL,
	`round_off_amt` DECIMAL(20,2) NULL DEFAULT NULL,
	`net_amt` DECIMAL(20,2) NULL DEFAULT NULL,
	`order_booked_by_id` INT(11) NULL DEFAULT NULL,
	`order_booked_by_name` VARCHAR(70) NULL DEFAULT NULL,
	`updated_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`update_order_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`booking_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`current_order_status` INT(11) NULL DEFAULT NULL COMMENT 'Order Status ID',
	`order_summary` TEXT NULL,
	`invoice_number` VARCHAR(70) NULL DEFAULT NULL,
	`invoice_date` DATE NULL DEFAULT NULL,
	`dispatch_date` DATE NULL DEFAULT NULL,
	`delivery_terms` TEXT NULL,
	`payment_terms` TEXT NULL,
	`courier_name` VARCHAR(30) NULL DEFAULT NULL,
	`courier_id` INT(11) NULL DEFAULT NULL,
	`order_coupon_id` INT(11) NULL DEFAULT NULL,
	`coupon_code` VARCHAR(30) NULL DEFAULT NULL,
	`docket_number` VARCHAR(30) NULL DEFAULT NULL,
	`payment_date` DATE NULL DEFAULT NULL,
	`delivery_date` DATETIME NULL DEFAULT NULL,
	`last_allocate_uid` INT(11) NULL DEFAULT NULL,
	`stock_status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1 stock in eg return,cancel - 2 stock out on new order place',
	`ip_address` VARCHAR(15) NULL DEFAULT NULL,
	`pdfline_count` INT(11) NULL DEFAULT '5',
	PRIMARY KEY (`id`),
	INDEX `FK_tel_purchase_master_tel_branch_master` (`branch_id`),
	INDEX `FK_tel_purchase_master_tel_customer_master` (`customer_id`),
	INDEX `FK_tel_order_master_tel_customer_address_master` (`address_id`),
	INDEX `FK_tel_order_master_tel_lead_type` (`lead_type`),
	INDEX `FK_tel_order_master_tel_payment_type` (`payment_type`),
	INDEX `FK_tel_order_master_cds_users_master` (`order_booked_by_id`),
	INDEX `customer_order_id` (`customer_order_id`),
	INDEX `branch_id` (`branch_id`),
	INDEX `customer_id` (`customer_id`),
	INDEX `address_id` (`address_id`),
	INDEX `dealer_id` (`dealer_id`),
	INDEX `dispatch_date` (`dispatch_date`),
	INDEX `last_allocate_uid` (`last_allocate_uid`),
	INDEX `FK_tel_order_master_tel_coupon_list` (`order_coupon_id`),
	CONSTRAINT `FK101` FOREIGN KEY (`customer_id`) REFERENCES `tel_customer_master` (`id`) ON UPDATE NO ACTION,
	CONSTRAINT `FK102` FOREIGN KEY (`lead_type`) REFERENCES `tel_lead_type` (`id`) ON UPDATE NO ACTION,
	CONSTRAINT `FK103` FOREIGN KEY (`payment_type`) REFERENCES `tel_payment_type` (`id`) ON UPDATE NO ACTION
 **
CRT_TBL|tel_quotation_item_list|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_id` INT(11) NULL DEFAULT NULL,
	`category_id` INT(11) NULL DEFAULT NULL,
	`item_id` INT(11) NULL DEFAULT NULL,
	`item_name` VARCHAR(250) NULL DEFAULT NULL,
	`item_package_id` INT(11) NULL DEFAULT NULL COMMENT 'Package ID',
	`hsn_code` VARCHAR(250) NULL DEFAULT NULL,
	`rate` DECIMAL(20,2) NULL DEFAULT '0.00',
	`qty` DECIMAL(10,2) NULL DEFAULT '0.00',
	`discount` DECIMAL(10,2) NULL DEFAULT '0.00',
	`discount_amount` DECIMAL(10,2) NULL DEFAULT '0.00',
	`discount_type` TINYINT(4) NULL DEFAULT '1' COMMENT '1 Percentage 2 Fixed',
	`amount` DECIMAL(20,2) NULL DEFAULT '0.00',
	`tax_percentage` DECIMAL(20,2) NULL DEFAULT '0.00',
	`tax_amount` DECIMAL(20,2) NULL DEFAULT '0.00',
	`total_amount` DECIMAL(20,2) NULL DEFAULT NULL,
	`item_detail` TEXT NULL,
	`updated_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`time_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`ip_address` VARCHAR(15) NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `FK_tel_order_item_list_tel_order_master` (`order_id`),
	INDEX `FK_tel_order_item_list_tel_item_master` (`item_id`),
	INDEX `FK_tel_order_item_list_tel_itemcategory_master` (`category_id`),
	INDEX `order_id` (`order_id`),
	INDEX `item_id` (`item_id`),
	INDEX `FK_tel_order_item_list_tel_item_package_master` (`item_package_id`)
**
CRT_TBL|tel_quotation_taxlist|`list_id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_id` INT(11) NULL DEFAULT NULL,
	`item_id` INT(11) NULL DEFAULT NULL,
	`item_name` VARCHAR(200) NULL DEFAULT NULL,
	`tax_id` INT(11) NULL DEFAULT NULL,
	`tax_name` VARCHAR(100) NULL DEFAULT NULL,
	`tax_percentage` DECIMAL(20,2) NULL DEFAULT NULL,
	`taxable_amount` DECIMAL(20,2) NULL DEFAULT NULL,
	`tax_amount` DECIMAL(20,2) NULL DEFAULT NULL,
	PRIMARY KEY (`list_id`),
	INDEX `FK_tel_purchase_taxlist_tel_purchase_master` (`order_id`),
	INDEX `FK_tel_purchase_taxlist_tel_item_master` (`item_id`),
	INDEX `FK_tel_purchase_taxlist_tel_tax_master` (`tax_id`),
	INDEX `order_id` (`order_id`),
	INDEX `item_id` (`item_id`),
	INDEX `tax_id` (`tax_id`),
	INDEX `item_name` (`item_name`)
**
ADD_CLM|cds_company|captch_rights|INT|11|N|1|apply_coupon
**
ADD_CLM|tel_order_master|transaction_id|VARCHAR|250|Y|NULL|payment_type