-- http://www.phpmyadmin.net
--




-- --------------------------------------------------------

--
-- Table structure for table `sc_branch`
--

CREATE TABLE `sc_branch` (
  `sr_id` int(12) NOT NULL,
  `branch_id` varchar(100) NOT NULL,
  `branch_name` varchar(155) NOT NULL,
  `br_parcel` int(50) DEFAULT NULL,
  `br_docs` int(50) DEFAULT NULL,
  `br_vvp` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sc_branch`
--

INSERT INTO `sc_branch` (`sr_id`, `branch_id`, `branch_name`, `br_parcel`, `br_docs`, `br_vvp`) VALUES
(1, 'br_01', 'Sangali', 15, 20, 5),
(2, 'br_02', 'Kolhapur', 13, 20, 5),
(3, 'br_03', 'Satara', 15, 20, 5),
(9, 'br_04', 'Pune', 15, 20, 5),
(10, 'br_05', 'Belgaum', 15, 20, 5),
(11, 'br_06', 'Chiplun', 20, 20, 5),
(12, 'br_07', 'Ratnagiri', 20, 20, 5),
(13, 'br_08', 'Kudal', 20, 20, 5),
(14, 'br_09', 'Ichalkaranji', 15, 20, 5),
(15, 'br_10', 'Islampur', 15, 20, 5),
(16, 'br_11', 'Baramati', 15, 20, 5),
(17, 'br_12', 'Aurangabad', 20, 20, 5),
(18, 'br_13', 'Ahmednagar', 20, 20, 5),
(19, 'br_14', 'Pandharpur', 20, 20, 5),
(20, 'br_15', 'Solapur', 20, 20, 5),
(21, 'br_16', 'Karad', 15, 20, 5);

-- --------------------------------------------------------

--
-- Table structure for table `sc_customers`
--

CREATE TABLE `sc_customers` (
  `sr_id` int(12) NOT NULL,
  `cust_id` varchar(100) NOT NULL,
  `cust_fname` varchar(100) NOT NULL,
  `cust_lname` varchar(100) NOT NULL,
  `cust_fullname` varchar(100) NOT NULL,
  `cust_email` varchar(100) NOT NULL,
  `cust_address` varchar(200) NOT NULL,
  `cust_pan` varchar(10) NOT NULL,
  `cust_gst` varchar(15) NOT NULL,
  `cust_mobile` bigint(10) NOT NULL,
  `cust_rc_no` varchar(100) NOT NULL DEFAULT 'Not Assigned'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sc_customers`
--

INSERT INTO `sc_customers` (`sr_id`, `cust_id`, `cust_fname`, `cust_lname`, `cust_fullname`, `cust_email`, `cust_address`, `cust_pan`, `cust_gst`, `cust_mobile`, `cust_rc_no`) VALUES
(8, 'cs_01', 'Mark', 'Johnson', 'Mark Johnson', 'test@test.com', '21, Link Rd, ', '50550ABCDE', 'ACVBGHJ67890', 9988776655, 'RC-GST/000002'),
(9, 'cs_02', 'David', 'Henry', 'David Henry', 'david@rediffmail.co.in', '34-C/Avenue Street, Nagpur', '123456ASDF', 'ASD4567DS891', 9965874235, 'RC-GST/0000027'),
(11, 'cs_03', 'Cole', 'Nickman', 'Cole Nickman', 'cole@nickman.com', 'Cole St, 33', '45479ASDCX', '54ASSDA458799', 5648795236, 'Not Assigned'),
(12, 'cs_04', 'Mark', 'Henry', 'Mark Henry', 'test@test.in', '21,andheri', 'ASDFG54896', '48S6AS1D54SDA', 4455823695, 'RC-GST/000005'),
(16, 'cs_05', 'vishal', 'salve', 'vishal salve', 'vishal@gmail.com', 'dadar', 'AOVPT5021H', 'GGGGGGGGGGGGGGG', 1111111111, 'RC-GST/000002'),
(17, 'cs_06', 'nilesh', ' thengane', 'nilesh  thengane', 'nilesh@gmail.com', 'andheri', 'AOGTT5029N', '27AOGTT5029N1ZI', 7977245859, 'RC-GST/0000035'),
(18, 'cs_07', 'prashant', 'v', 'prashant v', 'prashant@gmail.com', 'bhuleshwar', 'AOGPT556DD', 'AAAAAAAAAAAAAAA', 9999999999, 'RC-GST/000007'),
(19, 'cs_08', 'Arpana', 'x', 'Arpana x', 'arpana@gmail.com', 'girgaon', 'AAAA55567F', '2344567FFFFFFFF', 9870555555, 'RC-GST/0000031');

-- --------------------------------------------------------

--
-- Table structure for table `sc_receipt`
--

CREATE TABLE `sc_receipt` (
  `sr_id` int(12) NOT NULL,
  `receipt_id` varchar(12) NOT NULL,
  `rc_number` varchar(100) NOT NULL,
  `rc_type` varchar(10) NOT NULL,
  `rc_fromBranch` varchar(100) NOT NULL,
  `rc_toBranch` varchar(100) NOT NULL,
  `rc_date` date NOT NULL,
  `rc_from` varchar(100) NOT NULL,
  `rc_to` varchar(100) NOT NULL,
  `rc_mob` bigint(10) NOT NULL,
  `rc_gst` varchar(15) NOT NULL,
  `rc_particulars` varchar(100) NOT NULL,
  `rc_kg` int(10) NOT NULL,
  `rc_parcels` int(10) NOT NULL,
  `rc_vvp` varchar(50) NOT NULL,
  `rc_cour_total` int(50) DEFAULT NULL,
  `rc_gst_total` int(50) DEFAULT NULL,
  `rc_total` int(50) DEFAULT NULL,
  `rc_remarks` varchar(200) NOT NULL,
  `vvp_amount` varchar(10) DEFAULT NULL,
  `vvp_date` date DEFAULT NULL,
  `to_name` varchar(150) DEFAULT NULL,
  `vvp_payment_status` varchar(50) NOT NULL,
  `cc_status` varchar(10) DEFAULT NULL,
  `vpp_charges` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sc_receipt`
--

INSERT INTO `sc_receipt` (`sr_id`, `receipt_id`, `rc_number`, `rc_type`, `rc_fromBranch`, `rc_toBranch`, `rc_date`, `rc_from`, `rc_to`, `rc_mob`, `rc_gst`, `rc_particulars`, `rc_kg`, `rc_parcels`, `rc_vvp`, `rc_cour_total`, `rc_gst_total`, `rc_total`, `rc_remarks`, `vvp_amount`, `vvp_date`, `to_name`, `vvp_payment_status`, `cc_status`, `vpp_charges`) VALUES
(1, 'rc_00', 'RC-GST/000000', 'GST', 'br_from', 'br_to', '0000-00-00', 'from', 'to', 0, '0', 'others', 0, 0, '0', 0, 0, 0, 'none', NULL, NULL, NULL, 'none', NULL, ''),
(18, 'rc_02', 'RC-GST/000001', 'gst', 'Mumbai', 'Pune', '2019-01-19', 'Mark Johnson', 'Pranay Das', 9988776655, 'ACVBGHJ67890', 'br_docs', 50, 10, '0', 1000, 180, 1180, '', '1500', '2019-01-28', 'nilesh', 'done', 'paid', ''),
(60, 'rc_03', 'RC-GST/000002', 'gst', 'Mumbai', 'Sangali', '2019-01-29', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '0', 0, 0, 75, 'amount paid', NULL, NULL, NULL, 'done', 'paid', ''),
(61, 'rc_04', 'RC-GST/000003', 'gst', 'Mumbai', 'Kolhapur', '2019-01-29', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 4, 652, '20000', 0, 0, 0, '', '20000', '2019-02-07', 'nilesh', 'done', 'topay', '600'),
(62, 'rc_05', 'RC-GST/000004', 'gst', 'Mumbai', 'Belgaum', '2019-01-29', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '10000', 75, 0, 125, '', NULL, NULL, NULL, 'pending', 'topay', '50'),
(63, 'rc_06', 'RC-GST/000005', 'gst', 'Mumbai', 'Belgaum', '2019-01-29', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '10000', 75, 0, 125, '', NULL, NULL, NULL, 'pending', 'topay', '50'),
(75, 'rc_07', 'RC-GST/000006', 'gst', 'Mumbai', 'Baramati', '2019-01-30', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_docs', 5, 2, '120000', 100, 0, 700, '', NULL, NULL, NULL, 'pending', 'paid', '500'),
(76, 'rc_08', 'RC-GST/000007', 'gst', 'Mumbai', 'Ichalkaranji', '2019-01-30', '', '', 0, '', 'br_parcel', 5, 0, '150800', 75, 0, 829, '', NULL, NULL, NULL, 'pending', 'paid', '754'),
(77, 'rc_09', 'RC-GST/000008', 'gst', 'Mumbai', 'Ahmednagar', '2019-01-30', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 3, 2, '10000', 60, 0, 110, '', NULL, NULL, NULL, 'pending', 'topay', '50'),
(78, 'rc_10', 'RC-GST/000009', 'gst', 'Mumbai', 'Ahmednagar', '2019-01-30', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 3, 2, '10000', 60, 0, 110, '', NULL, NULL, NULL, 'pending', 'topay', '50'),
(79, 'rc_11', 'RC-GST/0000010', 'gst', 'Mumbai', 'Ahmednagar', '2019-01-30', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 3, 2, '10000', 60, 0, 110, '', NULL, NULL, NULL, 'pending', 'topay', '50'),
(80, 'rc_12', 'RC-GST/0000011', 'gst', 'Mumbai', 'Sangali', '2019-01-30', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_docs', 5, 0, '10000', 100, 0, 150, '', NULL, NULL, NULL, 'pending', 'paid', '70'),
(81, 'rc_13', 'RC-GST/0000012', 'gst', 'Mumbai', 'Sangali', '2019-01-30', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 0, '150800', 75, 0, 829, 'hieee', NULL, NULL, NULL, 'pending', 'paid', '754'),
(82, 'rc_14', 'RC-GST/0000013', 'gst', 'Mumbai', 'Satara', '2019-01-30', '', '', 0, '', 'br_docs', 5, 0, '10000', 100, 0, 150, '', NULL, NULL, NULL, 'pending', 'paid', '50'),
(83, 'rc_15', 'RC-GST/0000014', 'gst', 'Mumbai', 'Kolhapur', '2019-01-30', '', '', 0, '', 'br_docs', 5, 0, '10000', 100, 0, 150, '', NULL, NULL, NULL, 'pending', 'paid', '50'),
(84, 'rc_16', 'RC-GST/0000015', 'gst', 'Mumbai', 'Chiplun', '2019-01-30', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 0, 0, '10000', 0, 0, 50, '', NULL, NULL, NULL, 'pending', 'paid', '50'),
(85, 'rc_17', 'RC-GST/0000016', 'gst', 'Mumbai', 'Pune', '2019-01-30', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 0, 0, '0', 0, 0, 0, '', NULL, NULL, NULL, 'done', 'paid', ''),
(86, 'rc_18', 'RC-GST/0000017', 'gst', 'Mumbai', 'Select Branch', '2019-01-30', 'yuyuy', 'vaibhav', 7977245859, '', 'br_docs', 5, 2, '10000', 0, 0, 0, '', NULL, NULL, NULL, 'pending', 'paid', '0'),
(87, 'rc_19', 'RC-GST/0000018', 'gst', 'Mumbai', 'Kolhapur', '2019-01-30', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '120555', 65, 0, 667, 'hh', NULL, NULL, NULL, 'pending', 'paid', '602.7750000000001'),
(88, 'rc_20', 'RC-GST/0000019', 'gst', 'Mumbai', 'Kolhapur', '2019-01-30', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '120555', 65, 0, 667, 'hh', NULL, NULL, NULL, 'pending', 'paid', '602.7750000000001'),
(89, 'rc_21', 'RC-GST/0000020', 'gst', 'Mumbai', 'Kolhapur', '2019-01-30', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '120555', 65, 0, 667, 'hh', NULL, NULL, NULL, 'pending', 'topay', '602.7750000000001'),
(90, 'rc_22', 'RC-GST/0000021', 'gst', 'Mumbai', 'Kolhapur', '2019-01-31', 'nilesh  thengane', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 3, '10000', 50, 0, 100, '', NULL, NULL, NULL, 'pending', 'paid', '50.00'),
(91, 'rc_23', 'RC-GST/0000022', 'gst', 'Mumbai', 'Kolhapur', '2019-01-31', '6165', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '10000', 65, 0, 115, 'assss', NULL, NULL, NULL, 'pending', 'paid', '50.00'),
(92, 'rc_24', 'RC-GST/0000023', 'gst', 'Mumbai', 'Kolhapur', '2019-01-31', '6165', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '10000', 65, 0, 115, 'assss', NULL, NULL, NULL, 'pending', 'paid', '50.00'),
(93, 'rc_25', 'RC-GST/0000024', 'gst', 'Mumbai', 'Kolhapur', '2019-01-31', '6165', 'vaibhav', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 2, '10000', 65, 0, 115, 'assss', NULL, NULL, NULL, 'pending', 'paid', '50.00'),
(94, 'rc_26', 'RC-GST/0000025', 'gst', 'Mumbai', 'Sangali', '2019-02-02', 'Sourabh', 'Rahul', 8898325696, 'asdasd4653120', 'br_docs', 12, 10, '5000', 240, 0, 265, '', NULL, NULL, NULL, 'pending', 'topay', '25.00'),
(95, 'rc_27', 'RC-GST/0000026', 'gst', 'Mumbai', 'Kolhapur', '2019-02-02', 'David Henry', 'saxchh', 9965874235, 'ASD4567DS891', 'br_parcel', 10, 100, '5000', 130, 0, 155, '', NULL, NULL, NULL, 'pending', 'topay', '25.00'),
(96, 'rc_28', 'RC-GST/0000027', 'gst', 'Mumbai', 'Kolhapur', '2019-02-02', 'David Henry', 'saxchh', 9965874235, 'ASD4567DS891', 'br_parcel', 10, 100, '0', 130, 0, 130, '', NULL, NULL, NULL, 'done', 'topay', ''),
(97, 'rc_29', 'RC-GST/0000028', 'gst', 'Mumbai', 'Pune', '2019-02-02', 'pranay', 'mark', 5454548455, '', 'br_parcel', 5, 0, '15120', 75, 0, 151, '', NULL, NULL, NULL, 'pending', 'paid', '75.60'),
(98, 'rc_30', 'RC-GST/0000029', 'gst', 'Mumbai', 'Pune', '2019-02-07', 'nilesh  thengane', 'Rahul', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 10, 5, '10000', 150, 0, 200, '', NULL, NULL, NULL, 'pending', 'paid', '50.00'),
(99, 'rc_31', 'RC-GST/0000030', 'gst', 'Mumbai', 'Satara', '2019-02-07', 'Arpana x', 'nilesh', 9870555555, '2344567FFFFFFFF', 'br_parcel', 10, 175, '4500', 0, 0, 0, '', '4500', '2019-02-07', 'aashish', 'done', 'paid', '25.00'),
(100, 'rc_32', 'RC-GST/0000031', 'gst', 'Mumbai', 'Satara', '2019-02-07', 'Arpana x', 'nilesh', 9870555555, '2344567FFFFFFFF', 'br_parcel', 10, 1, '5000', 150, 0, 175, '', NULL, NULL, NULL, 'pending', 'topay', '25.00'),
(106, 'rc_33', 'RC-GST/0000032', 'gst', 'Mumbai', 'Belgaum', '2019-02-21', 'nilesh  thengane', 'saurabh', 7977245859, '27AOGTT5029N1ZI', 'br_docs', 2, 0, '1500', 40, 0, 48, '', NULL, NULL, NULL, 'pending', 'topay', '7.50'),
(107, 'rc_34', 'RC-GST/0000033', 'gst', 'Mumbai', 'Satara', '2019-02-21', 'nilesh  thengane', 'saurabh', 7977245859, '27AOGTT5029N1ZI', 'br_docs', 2, 2, '0', 40, 0, 40, '', NULL, NULL, NULL, 'done', 'paid', ''),
(108, 'rc_35', 'RC-GST/0000034', 'gst', 'Mumbai', 'Belgaum', '2019-02-22', 'nilesh  thengane', 'pd', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 5, '0', 75, 0, 75, '', NULL, NULL, NULL, 'done', 'paid', ''),
(109, 'rc_36', 'RC-GST/0000035', 'gst', 'Mumbai', 'Pune', '2019-02-22', 'nilesh  thengane', 'pranay', 7977245859, '27AOGTT5029N1ZI', 'br_parcel', 5, 5, '0', 75, 0, 75, '', NULL, NULL, NULL, 'done', 'paid', '');

--
-- Indexes for table `sc_branch`
--
ALTER TABLE `sc_branch`
  ADD PRIMARY KEY (`sr_id`);

--
-- Indexes for table `sc_customers`
--
ALTER TABLE `sc_customers`
  ADD PRIMARY KEY (`sr_id`);

--
-- Indexes for table `sc_receipt`
--
ALTER TABLE `sc_receipt`
  ADD PRIMARY KEY (`sr_id`);
--
-- AUTO_INCREMENT for table `sc_branch`
--
ALTER TABLE `sc_branch`
  MODIFY `sr_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `sc_customers`
--
ALTER TABLE `sc_customers`
  MODIFY `sr_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `sc_receipt`
--
ALTER TABLE `sc_receipt`
  MODIFY `sr_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;
