· 6 years ago · Jul 31, 2019, 01:34 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : LOCALHOST
5Source Server Version : 50620
6Source Host : 127.0.0.1:3306
7Source Database : mydb
8
9Target Server Type : MYSQL
10Target Server Version : 50620
11File Encoding : 65001
12
13Date: 2019-07-31 21:30:55
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for inventory_transaction
20-- ----------------------------
21DROP TABLE IF EXISTS `inventory_transaction`;
22CREATE TABLE `inventory_transaction` (
23 `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
24 `inventory_id` int(11) NOT NULL,
25 `branch_code` varchar(50) DEFAULT NULL,
26 `purchase_order_number` varchar(50) NOT NULL,
27 `reference_number` varchar(50) DEFAULT NULL,
28 `destination` varchar(50) DEFAULT NULL,
29 `item_id` int(11) NOT NULL,
30 `unit_cost` double NOT NULL,
31 `discount_unit_cost` double NOT NULL,
32 `SRP` double NOT NULL,
33 `quantity` int(11) NOT NULL,
34 `old_quantity` int(11) NOT NULL DEFAULT '0',
35 `new_quantity` int(11) NOT NULL DEFAULT '0',
36 `dest_old_quantity` int(11) NOT NULL DEFAULT '0',
37 `dest_new_quantity` int(11) NOT NULL DEFAULT '0',
38 `status` tinyint(4) NOT NULL,
39 `remarks` varchar(100) DEFAULT NULL,
40 `status_update_at` datetime DEFAULT NULL,
41 `status_update_by` varchar(50) DEFAULT NULL,
42 `created_by` varchar(50) DEFAULT NULL,
43 `created_at` date DEFAULT NULL,
44 `server_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
45 PRIMARY KEY (`transaction_id`)
46) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
47
48-- ----------------------------
49-- Records of inventory_transaction
50-- ----------------------------
51INSERT INTO `inventory_transaction` VALUES ('1', '1', 'B001', 'B00100000001', null, 'B001', '1', '3328', '3328', '0', '15', '0', '15', '0', '0', '6', null, null, null, 'khsangel', '2019-07-10', '2019-07-10 17:54:11');
52INSERT INTO `inventory_transaction` VALUES ('2', '2', 'B001', 'B00100000001', null, 'B001', '2', '2752', '2752', '0', '1', '0', '1', '0', '0', '2', null, null, null, 'khsangel', '2019-07-10', '2019-07-10 17:54:15');
53INSERT INTO `inventory_transaction` VALUES ('3', '3', 'B001', 'B00100000001', null, 'B001', '8', '4185.6', '4185.6', '0', '15', '0', '15', '0', '0', '2', null, null, null, 'khsangel', '2019-07-10', '2019-07-10 17:54:17');
54INSERT INTO `inventory_transaction` VALUES ('4', '1', 'B001', 'B00100000001', null, 'B001', '1', '3328', '3328', '0', '15', '15', '30', '0', '0', '6', null, null, null, 'khsangel', '2019-07-10', '2019-07-10 17:57:34');
55INSERT INTO `inventory_transaction` VALUES ('5', '0', 'B001', '', 'PIA00000001', 'B001', '4', '0', '0', '0', '10', '0', '10', '0', '0', '9', '', '2019-07-15 22:11:08', 'khsangel', 'khsangel', '2019-07-15', '2019-07-15 22:04:09');
56INSERT INTO `inventory_transaction` VALUES ('6', '0', 'B001', '', 'MTF00000001', 'B002', '1', '3328', '3328', '0', '15', '30', '15', '0', '0', '1', '', null, null, 'khsangel', '2019-07-16', '2019-07-16 22:11:32');
57INSERT INTO `inventory_transaction` VALUES ('7', '0', 'B001', '', 'MTF00000001', 'B002', '2', '2752', '2752', '0', '1', '1', '0', '0', '0', '1', '', null, null, 'khsangel', '2019-07-16', '2019-07-16 22:11:33');
58INSERT INTO `inventory_transaction` VALUES ('8', '4', 'B001', 'B00100000002', null, 'B001', '1', '100', '100', '0', '10', '15', '25', '0', '0', '2', null, null, null, 'khsangel', '2019-07-29', '2019-07-29 21:33:26');
59INSERT INTO `inventory_transaction` VALUES ('9', '5', 'B001', 'B00100000002', null, 'B001', '2', '100', '100', '0', '2', '0', '2', '0', '0', '6', null, null, null, 'khsangel', '2019-07-29', '2019-07-29 21:33:49');
60INSERT INTO `inventory_transaction` VALUES ('10', '5', 'B001', 'B00100000002', null, 'B001', '2', '100', '100', '0', '2', '2', '4', '0', '0', '6', null, null, null, 'khsangel', '2019-07-29', '2019-07-29 21:36:34');
61INSERT INTO `inventory_transaction` VALUES ('11', '5', 'B001', 'B00100000002', null, 'B001', '2', '100', '100', '0', '2', '4', '6', '0', '0', '6', null, null, null, 'khsangel', '2019-07-29', '2019-07-29 21:36:47');
62INSERT INTO `inventory_transaction` VALUES ('12', '0', 'B001', '', 'SALES000001', 'B001001', '1', '300', '300', '0', '0', '0', '0', '0', '0', '8', null, null, null, 'khsangel', '2019-07-29', '2019-07-29 22:30:49');
63INSERT INTO `inventory_transaction` VALUES ('13', '0', 'B001', '', 'SALES000001', 'B001001', '2', '300', '300', '0', '0', '0', '0', '0', '0', '8', null, null, null, 'khsangel', '2019-07-29', '2019-07-29 22:30:50');