-- --------------------------------------------------------
-- Versi server:                 10.3.39-MariaDB - mariadb.org binary distribution
-- OS Server:                    Win64
-- HeidiSQL Versi:               12.10.0.7000
-- --------------------------------------------------------



-- Membuang struktur basisdata untuk jaya_makmur
DROP DATABASE IF EXISTS `jaya_makmur`;
CREATE DATABASE IF NOT EXISTS `jaya_makmur` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `jaya_makmur`;

-- membuang struktur untuk view jaya_makmur.barang_stok_view
-- Membuat tabel sementara untuk menangani kesalahan ketergantungan VIEW
CREATE TABLE `barang_stok_view` (
	`kode_barang` VARCHAR(1) NOT NULL COLLATE 'utf8mb4_general_ci',
	`nama_barang` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`stok` DOUBLE NULL,
	`satuan` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci'
) ENGINE=MyISAM;

-- membuang struktur untuk view jaya_makmur.barang_view
-- Membuat tabel sementara untuk menangani kesalahan ketergantungan VIEW
CREATE TABLE `barang_view` (
	`kode_barang` VARCHAR(1) NOT NULL COLLATE 'utf8mb4_general_ci',
	`nama_barang` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci'
) ENGINE=MyISAM;

-- membuang struktur untuk table jaya_makmur.tb_barang
CREATE TABLE IF NOT EXISTS `tb_barang` (
  `kode_barang` varchar(50) NOT NULL,
  `nama_barang` varchar(50) DEFAULT NULL,
  `jenis` varchar(50) DEFAULT NULL,
  `merk` varchar(50) DEFAULT NULL,
  `satuan` varchar(50) DEFAULT NULL,
  `hargapokok` double DEFAULT NULL,
  `harga_jual1` double DEFAULT NULL,
  `harga_jual2` double DEFAULT NULL,
  `harga_jual3` double DEFAULT NULL,
  `harga_jual4` double DEFAULT NULL,
  `harga_jual5` double DEFAULT NULL,
  `stok` double DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `isJual` enum('Y','N') DEFAULT NULL,
  PRIMARY KEY (`kode_barang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_barang: ~545 rows (lebih kurang)
DELETE FROM `tb_barang`;
INSERT INTO `tb_barang` (`kode_barang`, `nama_barang`, `jenis`, `merk`, `satuan`, `hargapokok`, `harga_jual1`, `harga_jual2`, `harga_jual3`, `harga_jual4`, `harga_jual5`, `stok`, `keterangan`, `isJual`) VALUES
	('001', 'Swallow black M02 SR', 'SWL', 'SW', 'LUSIN', 113500, 120000, 119000, 118000, 117000, 0, -5, '1 karung isi 20', 'Y'),
	('002', 'Swallow Army', 'SWL', 'SW', 'LUSIN', 113000, 123000, 120000, 118000, 117000, 0, 2, '1 karung isi 20', 'Y'),
	('003', 'Swallow Floral', 'SWL', 'SW', 'LUSIN', 109000, 119000, 117000, 114000, 113000, 0, 4, '', 'Y'),
	('004', 'Swallow 05 Seri', 'SWL', 'SW', 'LUSIN', 105000, 112000, 110000, 109000, 108500, 0, 0, '1 karung isi 20', 'Y'),
	('005', 'Swallow 05 Ukr 11', 'SWL', 'SW', 'LUSIN', 112000, 119000, 118000, 117000, 116000, 0, 5, '1 karung isi 20', 'Y'),
	('006', 'Pearl Swallow 05 Seri', 'PSWL', 'PEARL', 'LUSIN', 97000, 107000, 104000, 103000, 102000, 101000, 6, '1 karung isi 20', 'Y'),
	('007', 'Pearl Swallow 05 Khusus', 'PSWL', 'PEARL', 'LUSIN', 99000, 109000, 106000, 105000, 104000, 103000, 0, '1 karung isi 20', 'Y'),
	('008', 'Pearl Swallow 05 11', 'PSWL', 'PEARL', 'LUSIN', 103000, 113000, 110000, 109000, 108000, 107500, 9, '1 karung isi 20', 'Y'),
	('009', 'Sun Swallow Wave', 'SSWL', 'SUN SW', 'LUSIN', 114000, 125000, 123000, 121000, 120000, 0, 2, '1 karung isi 20', 'Y'),
	('010', 'Sun Swallow London', 'SSWL', 'SUN SW', 'LUSIN', 114000, 125000, 124000, 122000, 121000, 0, 0, '1 karung isi 20', 'Y'),
	('011', 'Sun Swallow Trek', 'SSWL', 'SUN SW', 'LUSIN', 121000, 130000, 129000, 128000, 127000, 0, 0, '1 karung isi 20', 'Y'),
	('012', 'Mely HB Khusus', 'MLY', 'MELLY', 'LUSIN', 72500, 77000, 76000, 75000, 74500, 0, 0, '1 karung isi 18', 'Y'),
	('013', 'Mely HB Seri', 'MLY', 'MELLY', 'LUSIN', 69500, 74000, 73000, 72000, 71500, 0, 0, '1 karung isi 18', 'Y'),
	('014', 'Mely Black Panther', 'MLY', 'MELLY', 'LUSIN', 73500, 82000, 81000, 80000, 79500, 0, 0, '1 karung isi 18', 'Y'),
	('015', 'Pearl Dark Seri', 'PSWL', 'PEARL', 'LUSIN', 105000, 116000, 115000, 114000, 113000, 0, 0, '1 karung isi 20', 'Y'),
	('016', 'Pearl Dark Khusus 11', 'PSWL', 'PEARL', 'LUSIN', 110000, 123000, 122000, 121000, 120000, 0, 0, '1 karung isi 20', 'Y'),
	('017', 'Swallow Legian', 'SWL', 'SW', 'LUSIN', 140000, 148000, 147000, 146000, 145000, 0, 0, '1 karung isi 20', 'Y'),
	('018', 'Swallow 05 Khusus', 'SWL', 'SW', 'LUSIN', 107000, 114000, 112000, 111000, 110500, 0, 0, '1 karung isi 20', 'Y'),
	('019', 'Swallow Nice', 'SWL', 'SW', 'LUSIN', 119000, 128000, 126000, 124000, 123000, 0, 0, '', 'Y'),
	('020', 'Swallow Ice Cream Tg', 'SWL', 'SW', 'LUSIN', 104000, 114000, 112000, 110000, 109000, 0, 0, '1 karung isi 25', 'Y'),
	('021', 'Swallow Boba', 'SWL', 'SW', 'LUSIN', 115000, 123000, 121000, 119000, 118000, 0, 0, '1 karung isi 20', 'Y'),
	('022', 'Sun Swallow Polkadot', 'SSWL', 'SUN SW', 'LUSIN', 116000, 128000, 126000, 125000, 124000, 0, 0, '1 karung isi 20', 'Y'),
	('023', 'Sun Swallow Commando', 'SSWL', 'SUN SW', 'LUSIN', 108000, 126000, 124000, 122000, 121000, 0, 0, '1 karung isi 20', 'Y'),
	('024', 'Sun Swallow Aster', 'SSWL', 'SUN SW', 'LUSIN', 112000, 126000, 124000, 123000, 122000, 0, 0, '1 karung isi 20', 'Y'),
	('025', 'Pearl Swallow 05 Ukr 12', 'PSWL', 'PEARL', 'LUSIN', 106000, 116000, 113000, 112000, 111000, 110500, 0, '1 karung isi 20', 'Y'),
	('026', 'Sky Way Battleship', 'SKYWY', 'SKYWAY', 'LUSIN', 90000, 103000, 101000, 100000, 99000, 98000, 0, '', 'Y'),
	('027', 'Khogie HB Seri', 'KHG', 'KHOGIE', 'LUSIN', 58000, 65000, 64000, 63000, 62000, 0, 0, '1 karung isi 20', 'Y'),
	('028', 'Khogie HB 11-12', 'KHG', 'KHOGIE', 'LUSIN', 68000, 76000, 74000, 72000, 71000, 0, 0, '1 karung isi 20', 'Y'),
	('029', 'Miraga Rematik Hitam', 'MIR', 'MIRAGA', 'LUSIN', 53000, 65000, 62000, 61000, 60000, 0, 0, '1 karung isi 15 lusin', 'Y'),
	('030', 'Newera Miami', 'NEW', 'NEWERA', 'LUSIN', 140000, 150000, 148000, 147000, 146000, 0, 0, '1 Karung isi 20', 'Y'),
	('031', 'Swallow 05 Ukuran 11,5-12', 'SWL', 'SW', 'LUSIN', 114000, 125000, 122000, 121000, 120000, 0, 0, '1 Karung isi 18', 'Y'),
	('032', 'Skyboat Online', 'SKYBT', 'SKYBOAT', 'LUSIN', 96000, 104000, 103000, 102000, 101000, 0, 0, '1 Karung isi 20', 'Y'),
	('033', 'Skyboat Tokyo', 'SKYBT', 'SKYBOAT', 'LUSIN', 91000, 104000, 103000, 102000, 101000, 0, 0, '1 Karung isi 20', 'Y'),
	('034', 'Skyboat Top Banget', 'SKYBT', 'SKYBOAT', 'LUSIN', 103000, 115000, 114000, 110000, 109500, 0, 0, '1 Karung isi 16', 'Y'),
	('035', 'Sepatu AP 963 Putih', 'SPT AP', 'SPT AP', 'LUSIN', 310000, 342000, 336000, 330000, 325000, 0, 0, '1 Karton isi 2 lusin', 'Y'),
	('036', 'Sarung Tangan Matahari', 'PAL', 'MTH', 'PAK', 24000, 27500, 27000, 26500, 25000, 0, 0, '1 KARUNG ISI 50', 'Y'),
	('037', 'Newera Reino Tanggung', 'NEW', 'NEWERA', 'LUSIN', 80000, 95000, 90000, 88000, 85000, 0, 0, '', 'Y'),
	('038', 'Newera Spider Tanggung', 'NEW', 'NEWERA', 'LUSIN', 80000, 95000, 90000, 88000, 85000, 0, 0, '', 'Y'),
	('039', 'Newera Racing Tanggung', 'NEW', 'NEWERA', 'LUSIN', 80000, 95000, 90000, 88000, 85000, 85000, 0, '', 'Y'),
	('040', 'Swallow Toya Tanggung', 'SWL', 'SW', 'LUSIN', 95000, 114000, 112000, 110000, 109000, 0, 0, '', 'Y'),
	('041', 'Dahlia Kecil', 'DHL', 'DAHLIA', 'LUSIN', 35000, 42000, 41000, 40000, 38000, 0, 0, '', 'Y'),
	('042', 'Dahlia Tanggung', 'DHL', 'DAHLIA', 'LUSIN', 40000, 47000, 46000, 45000, 43000, 0, 0, '', 'Y'),
	('043', 'Newera Idol Seri', 'NEW', 'NEWERA', 'LUSIN', 75000, 85000, 84000, 83000, 82000, 0, 0, '', 'Y'),
	('044', 'Newera Queen Seri', 'NEW', 'NEWERA', 'LUSIN', 85000, 105000, 103000, 102000, 100000, 0, 0, '', 'Y'),
	('045', 'Newera Fuji Seri', 'NEW', 'NEWERA', 'LUSIN', 85000, 105000, 103000, 102000, 100000, 0, 0, '', 'Y'),
	('046', 'Newera Fantastic Black Seri', 'NEW', 'NEWERA', 'LUSIN', 85000, 105000, 103000, 102000, 100000, 0, 0, '', 'Y'),
	('047', 'Newera Baim Seri', 'NEW', 'NEWERA', 'LUSIN', 80000, 95000, 93000, 92000, 90000, 0, 0, '', 'Y'),
	('048', 'Newera Reino Besar', 'NEW', 'NEWERA', 'LUSIN', 80000, 100000, 98000, 97000, 95000, 0, 0, '', 'Y'),
	('049', 'Skyboat Newyork Seri', 'SKYBT', 'SKYBOAT', 'LUSIN', 75000, 90000, 88000, 86000, 85000, 0, 0, '', 'Y'),
	('050', 'Ardiles 4G', 'ARD', 'ARDILES', 'LUSIN', 75000, 90000, 88000, 87000, 85000, 0, 0, '', 'Y'),
	('051', 'Ardiles Step on It', 'ARD', 'ARDILES', 'LUSIN', 86000, 96000, 94000, 93000, 92000, 0, 0, '', 'Y'),
	('052', 'Ardiles Beach', 'ARD', 'ARDILES', 'LUSIN', 75000, 90000, 88000, 87000, 85000, 0, 0, '', 'Y'),
	('053', 'Boloni Hummer', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('054', 'Boloni Murgan', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('055', 'Boloni Las Vegas', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('056', 'Boloni Rematik pentol Besar', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('057', 'Boloni Tik tok', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('058', 'Boloni Shera', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('059', 'Boloni Love Bird', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('060', 'Boloni Unicorn', 'BOL', 'BOLONI', 'LUSIN', 75000, 85000, 0, 0, 0, 0, 0, '', 'Y'),
	('061', 'Boloni 081 Besar', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('062', 'Boloni Bendera', 'BOL', 'BOLONI', 'LUSIN', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('063', 'Boloni Hitam 054 B', 'BOL', 'BOLONI', 'PAK', 75000, 87000, 86000, 85000, 84000, 0, 0, '', 'Y'),
	('064', 'Boloni Sandal Gunung Rinjani B', 'BOL', 'BOLONI', 'PAK', 100000, 130000, 128000, 126000, 125000, 0, 0, '', 'Y'),
	('065', 'Boloni Sandal Gunung Rinjani T', 'BOL', 'BOLONI', 'PAK', 100000, 125000, 124000, 123000, 122000, 0, 0, '', 'Y'),
	('066', 'Shandy Batik', 'SHAN', 'SHANDY', 'LUSIN', 60000, 75000, 74000, 73000, 72000, 0, 0, '', 'Y'),
	('067', 'Bellair Flower', 'BEL', 'BELLAIR', 'LUSIN', 75000, 100000, 98000, 96000, 95000, 0, 0, '', 'Y'),
	('068', 'Skyboat 07 Duri', 'SKYBT', 'SKYBOAT', 'LUSIN', 85000, 98000, 97000, 96000, 95000, 0, 0, '', 'Y'),
	('069', 'Savilo Zig Zag', 'SWL', 'SW', 'LUSIN', 100000, 110000, 109000, 107000, 105000, 0, 0, '1 karung isi 20', 'Y'),
	('070', 'Sun Swallow Ladies Nice', 'SSWL', 'SUN SW', 'LUSIN', 112000, 121000, 120000, 119000, 118000, 0, 0, '1 karung isi 20', 'Y'),
	('071', 'Sun Swallow Osaka', 'SSWL', 'SUN SW', 'LUSIN', 111000, 125000, 124000, 123000, 122000, 0, 0, '1 karung isi 20', 'Y'),
	('072', 'Sun Swallow Kuta', 'SSWL', 'SUN SW', 'LUSIN', 134000, 145000, 144000, 143000, 142000, 0, 0, '1 karung isi 20', 'Y'),
	('073', 'Dulux 511 Besar', 'DLX', 'DULUX', 'PAK', 23000, 25000, 0, 0, 0, 0, 0, 'Sandal Pilon Selop Cewek Dewasa', 'Y'),
	('074', 'Dulux 518 Besar', 'DLX', 'DULUX', 'PAK', 22000, 24000, 0, 0, 0, 0, 0, 'Sandal Pilon Selop Cewek Dewasa', 'Y'),
	('075', 'Golfer 229 Tanggung', 'GOL', 'GOLFER', 'PAK', 17000, 19000, 0, 0, 0, 0, 0, 'Sandal Pilon Selop Anak Cowok', 'Y'),
	('076', 'Inkayni 2008 Kecil', 'IKY', 'INKAYNI', 'PAK', 13000, 15000, 0, 0, 0, 0, 0, 'Sandal Pilon Selop Anak Cowok', 'Y'),
	('077', 'Inkayni 5008 Besar', 'IKY', 'INKAYNI', 'PAK', 19000, 21000, 0, 0, 0, 0, 0, '', 'Y'),
	('078', 'Inkayni 5013 Besar', 'IKY', 'INKAYNI', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('079', 'Inkayni 5017 Japit Besar', 'IKY', 'INKAYNI', 'PAK', 19500, 21500, 0, 0, 0, 0, 0, 'Sandal Jepit Pilon Wanita Dewasa', 'Y'),
	('080', 'Inkayni 5017 Selop Besar', 'IKY', 'INKAYNI', 'PAK', 19000, 21000, 0, 0, 0, 0, 0, 'Sandal Selop Pilon Wanita Dewasa', 'Y'),
	('081', 'Komin 058 Besar', 'KMN', 'KMN', 'PAK', 16500, 18500, 0, 0, 0, 0, 0, 'Sandal Selop Pilon Wanita Dewasa', 'Y'),
	('082', 'Komin 060 Besar', 'KMN', 'KMN', 'PAK', 18500, 20500, 0, 0, 0, 0, 0, '', 'Y'),
	('083', 'Komin 065-2 Tanggung', 'KMN', 'KMN', 'PAK', 17500, 19500, 0, 0, 0, 0, 0, '', 'Y'),
	('084', 'LSH 3613 Besar', 'LSH', 'LSH', 'PAK', 22000, 24000, 0, 0, 0, 0, 0, '', 'Y'),
	('085', 'Morego 1601 Besar', 'MOR', 'MOREGO', 'PAK', 19000, 22000, 0, 0, 0, 0, 0, '', 'Y'),
	('086', 'Morego 1838 Besar', 'MOR', 'MOREGO', 'PAK', 13000, 15000, 0, 0, 0, 0, 0, '', 'Y'),
	('087', 'New Era 5121 LB', 'NEW', 'NEWERA', 'PAK', 20000, 22000, 0, 0, 0, 0, 0, '', 'Y'),
	('088', 'Porto 1006 Tanggung', 'POR', 'PORTO', 'PAK', 19000, 21000, 0, 0, 0, 0, 0, '', 'Y'),
	('089', 'Porto 3005 Besar', 'POR', 'PORTO', 'PAK', 22500, 24500, 0, 0, 0, 0, 0, '', 'Y'),
	('090', 'Porto 3010 Besar', 'POR', 'PORTO', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('091', 'Porto 518 Besar', 'POR', 'PORTO', 'PAK', 22000, 24000, 0, 0, 0, 0, 0, '', 'Y'),
	('092', 'Porto 602 Tanggung', 'POR', 'PORTO', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('093', 'Porto 602 Ladies Besar', 'POR', 'PORTO', 'PAK', 20000, 22000, 0, 0, 0, 0, 0, '', 'Y'),
	('094', 'Collin Jelly B81 Besar', 'COLL', 'COLLIN', 'PAK', 31000, 33000, 0, 0, 0, 0, 0, '', 'Y'),
	('095', 'Collin Jelly B17 Besar', 'COLL', 'COLLIN', 'PAK', 25000, 27000, 0, 0, 0, 0, 0, '', 'Y'),
	('096', 'Collin Jelly B88 Besar', 'COLL', 'COLLIN', 'PAK', 21000, 23000, 0, 0, 0, 0, 0, '', 'Y'),
	('097', 'New Era 13004 LB', 'NEW', 'NEWERA', 'PAK', 25000, 27000, 0, 0, 0, 0, 0, '', 'Y'),
	('098', 'New Era 13001 LB', 'NEW', 'NEWERA', 'PAK', 25000, 27000, 0, 0, 0, 0, 0, '', 'Y'),
	('099', 'Boloni Elmo Putih Selop Besar', 'BOL', 'BOLONI', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('100', 'Mokaya 817-2 Besar', 'MOK', 'MOKAYA', 'PAK', 20500, 22500, 0, 0, 0, 0, 0, '', 'Y'),
	('101', 'Porto Lady ANT Besar', 'POR', 'PORTO', 'PAK', 28000, 30000, 0, 0, 0, 0, 0, '', 'Y'),
	('102', 'Golfer 322 Tanggung', 'GOL', 'GOLFER', 'PAK', 15000, 17000, 0, 0, 0, 0, 0, '', 'Y'),
	('103', 'Gosome 928 Kecil', 'GOS', 'GOSOME', 'PAK', 15500, 17500, 0, 0, 0, 0, 0, '', 'Y'),
	('104', 'Cit-cit Superman Kecil', 'CIT', 'CIT', 'PAK', 7000, 8500, 0, 0, 0, 0, 0, '', 'Y'),
	('105', 'Cit-cit Topeng Kecil', 'CIT', 'CIT', 'PAK', 7000, 8500, 0, 0, 0, 0, 0, '', 'Y'),
	('106', 'Cit-cit Unicorn Kecil', 'CIT', 'CIT', 'PAK', 7000, 8500, 0, 0, 0, 0, 0, '', 'Y'),
	('107', 'KananKiri K87 Kecil', 'KK', 'KANANKIRI', 'PAK', 11000, 13000, 0, 0, 0, 0, 0, '', 'Y'),
	('108', 'Ceoiu 095 Kecil', 'CEO', 'CEOIU', 'PAK', 14000, 16000, 0, 0, 0, 0, 0, '', 'Y'),
	('109', 'Dulux 085D Kecil', 'DLX', 'DULUX', 'PAK', 19000, 21000, 0, 0, 0, 0, 0, '', 'Y'),
	('110', 'New Era 10039 LB', 'NEW', 'NEWERA', 'PAK', 21000, 23000, 0, 0, 0, 0, 0, '', 'Y'),
	('111', 'New Era 8853 LB', 'NEW', 'NEWERA', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('112', 'New Era 8854 LB', 'NEW', 'NEWERA', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('113', 'Dulux 190C', 'DLX', 'DULUX', 'PAK', 14500, 16500, 0, 0, 0, 0, 0, '', 'Y'),
	('114', 'New Era 732 LB', 'NEW', 'NEWERA', 'PAK', 16000, 18000, 0, 0, 0, 0, 0, '', 'Y'),
	('115', 'Porto 3005 Ladies', 'POR', 'PORTO', 'PAK', 12500, 14500, 0, 0, 0, 0, 0, '', 'Y'),
	('116', 'Dulux 539E', 'DLX', 'DULUX', 'PAK', 18000, 20000, 0, 0, 0, 0, 0, '', 'Y'),
	('117', 'Balacca 044 Mini', 'BAL', 'BALACCA', 'PAK', 15500, 17500, 0, 0, 0, 0, 0, '', 'Y'),
	('118', 'KananKiri 585', 'KK', 'KANANKIRI', 'PAK', 14000, 16000, 0, 0, 0, 0, 0, '', 'Y'),
	('119', 'XDL A109 Tanggung', 'XDL', 'XDL', 'PAK', 4500, 5000, 0, 0, 0, 0, 0, '', 'Y'),
	('120', 'New Era 1530 TK', 'NEW', 'NEWERA', 'PAK', 14500, 16500, 0, 0, 0, 0, 0, '', 'Y'),
	('121', 'New Era 5102 TK', 'NEW', 'NEWERA', 'PAK', 14500, 16500, 0, 0, 0, 0, 0, '', 'Y'),
	('122', 'Dulux 089C', 'DLX', 'DULUX', 'PAK', 16500, 18500, 0, 0, 0, 0, 0, '', 'Y'),
	('123', 'Feima 507 Tanggung', 'FEI', 'FEIMA', 'PAK', 11000, 13000, 0, 0, 0, 0, 0, '', 'Y'),
	('124', 'Balance 002 Besar', 'BAL', 'BALANCE', 'PAK', 24000, 26000, 0, 0, 0, 0, 0, '', 'Y'),
	('125', 'New Era 8855 KC', 'NEW', 'NEWERA', 'PAK', 15500, 17500, 0, 0, 0, 0, 0, '', 'Y'),
	('126', 'Sepatu Cewek OB', 'OB', 'OB', 'PAK', 9500, 10000, 0, 0, 0, 0, 0, '', 'Y'),
	('127', 'Balet Tanggung OB', 'OB', 'OB', 'PAK', 8000, 8500, 0, 0, 0, 0, 0, '', 'Y'),
	('128', 'Balet Mackers Putih Besar', 'MAC', 'MACKERS', 'PAK', 8000, 8500, 0, 0, 0, 0, 0, '', 'Y'),
	('129', 'Balet Mackers Hitam Besar', 'MAC', 'MACKERS', 'PAK', 8000, 8500, 0, 0, 0, 0, 0, '', 'Y'),
	('130', 'New Era 8858 LB', 'NEW', 'NEWERA', 'PAK', 13000, 15000, 0, 0, 0, 0, 0, '', 'Y'),
	('131', 'Youken Hoki 104 Besar', 'YKN', 'YOUKEN', 'PAK', 11000, 12500, 0, 0, 0, 0, 0, '', 'Y'),
	('132', 'Sun Swallow Hitam Khusus', 'SSWL', 'SUN SW', 'LUSIN', 99000, 107000, 106000, 105000, 104000, 0, 0, '1 karung isi 20', 'Y'),
	('133', 'Sun Swallow Trek Ukr 11', 'SSWL', 'SUN SW', 'LUSIN', 124000, 135000, 134000, 133000, 132000, 0, 0, '1 karung isi 20', 'Y'),
	('134', 'Mely Mild', 'MLY', 'MELLY', 'LUSIN', 74000, 81000, 80000, 79000, 78000, 0, 0, '1 karung isi 18', 'Y'),
	('135', 'Mely 2014 Warna', 'MLY', 'MELLY', 'LUSIN', 71000, 81000, 80000, 79000, 78000, 0, 0, '1 karung isi 18', 'Y'),
	('136', 'Mely 217 Doreng', 'MLY', 'MELLY', 'LUSIN', 72000, 81000, 80000, 79000, 78000, 0, 0, '1 karung isi 18', 'Y'),
	('137', 'Mely 818', 'MLY', 'MELLY', 'LUSIN', 71000, 81000, 80000, 79000, 78000, 0, 0, '1 karung isi 18', 'Y'),
	('138', 'Ardiles Miami', 'ARD', 'ARDILES', 'LUSIN', 96000, 105000, 0, 0, 0, 0, 0, '1 karung isi 16', 'Y'),
	('139', 'Kaplir Tali Sandal Seri', 'KAP', 'KAP', 'PAK', 8000, 10000, 9500, 9250, 9000, 0, 0, '1 sak isi 50', 'Y'),
	('140', 'Kaplir Tali Sandal Khusus', 'KAP', 'KAP', 'PAK', 8500, 11000, 10500, 10000, 9500, 0, 0, '1 sak isi 50', 'Y'),
	('141', 'Korek gas roda', 'PAL', 'YUKIT', 'PAK', 38500, 46000, 45000, 44000, 42500, 0, 0, '1 karton isi 20', 'Y'),
	('142', 'Lem G Barcode Merah 806', 'PAL', 'BRG OLD', 'PAK', 155000, 195000, 180000, 165000, 160000, 0, 0, '1 karton isi 10', 'Y'),
	('143', 'Swallow Black M02 Tanggung', 'SWL', 'SW', 'LUSIN', 96000, 102000, 101000, 100500, 100000, 0, 0, '1 karung isi 25\n', 'Y'),
	('144', 'Mely HB Tanggung', 'MLY', 'MELLY', 'LUSIN', 64500, 73000, 72000, 70000, 69000, 0, 0, '1 Karung isi 25', 'Y'),
	('145', 'Swallow 938 Warna Tebal Seri', 'SWL', 'SW', 'LUSIN', 120000, 135000, 132000, 131000, 130000, 0, 0, '1 karung isi 16', 'Y'),
	('146', 'Sun Swallow Tokyo B', 'SSWL', 'SUN SW', 'LUSIN', 116000, 128000, 126000, 125000, 124000, 0, 0, '1 karung isi 20', 'Y'),
	('147', 'Mely 717 Coklat', 'MLY', 'MELLY', 'LUSIN', 75500, 83000, 82000, 81000, 80000, 0, 0, '', 'Y'),
	('148', 'Boloni Murano size 39-44', 'BOL', 'BOLONI', 'PSG', 21000, 23500, 23000, 22500, 22000, 0, 0, '1 karton isi 60 pasang', 'Y'),
	('149', 'Boloni Locotre size 39-44', 'BOL', 'BOLONI', 'PSG', 26500, 29000, 28500, 28000, 27500, 0, 0, '1 karton isi 60 pasang', 'Y'),
	('150', 'Boloni Convince size 39-44', 'BOL', 'BOLONI', 'PSG', 26500, 29000, 28500, 28000, 27500, 0, 0, '1 karton isi 60 pasang', 'Y'),
	('151', 'Boloni Pinjam Seratus size 39-44', 'BOL', 'BOLONI', 'PSG', 26500, 29000, 28500, 28000, 27500, 0, 0, '1 karton isi 60 pasang', 'Y'),
	('152', 'Boloni Assamble size 39-44', 'BOL', 'BOLONI', 'PSG', 26500, 29000, 28500, 28000, 27500, 0, 0, '1 karton isi 60 pasang', 'Y'),
	('153', 'Mely HB Kecil', 'MLY', 'MELLY', 'LUSIN', 61000, 69000, 68000, 67000, 66000, 0, 0, '1 karung isi 30', 'Y'),
	('154', 'Skyboat Top Spirit', 'SKYBT', 'SKYBOAT', 'LUSIN', 102000, 115000, 114000, 110000, 109500, 0, 0, '1 karung isi 16', 'Y'),
	('155', 'Skyboat Top Legit', 'SKYBT', 'SKYBOAT', 'LUSIN', 104000, 115000, 114000, 110000, 109500, 0, 0, '1 karung isi 16', 'Y'),
	('156', 'Payung Saten 16 jari', 'PAL', 'PELANGI', 'LUSIN', 240000, 280000, 275000, 273000, 270000, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('157', 'Payung Jumbo Pelangi', 'PAL', 'PELANGI', 'LUSIN', 340000, 390000, 385000, 380000, 370000, 0, 0, '1 karton isi 5 lusin', 'Y'),
	('158', 'Payung Jumbo Silver', 'PAL', 'SILVER', 'LUSIN', 340000, 390000, 385000, 380000, 370000, 0, 0, '1 karton isi 5 lusin', 'Y'),
	('159', 'Payung Lipat 2', 'PAL', 'SATEN', 'LUSIN', 215000, 240000, 230000, 225000, 220000, 0, 0, '1 karton isi 10 lusin', 'Y'),
	('160', 'Rabbite All Black Cowok', 'RAB', 'RABBITE', 'LUSIN', 100000, 112000, 110000, 109000, 108000, 0, 0, '1 karung isi 10', 'Y'),
	('161', 'Rabbite All Black Cewek', 'RAB', 'RABBITE', 'LUSIN', 97000, 110000, 108000, 107000, 106000, 0, 0, '1 karung isi 10', 'Y'),
	('162', 'Rabbite Stripe Cowok', 'RAB', 'RABBITE', 'LUSIN', 105000, 118000, 116000, 115000, 114000, 0, 0, '1 karung isi 10', 'Y'),
	('163', 'Rabbite Stripe Cewek', 'RAB', 'RABBITE', 'LUSIN', 100000, 115000, 113000, 112000, 111000, 0, 0, '1 karung isi 10', 'Y'),
	('164', 'Rabbite Full Colour Cowok', 'RAB', 'RABBITE', 'LUSIN', 120000, 133000, 132000, 131000, 130000, 0, 0, '1 karung isi 10', 'Y'),
	('165', 'Rabbite Full Colour Cewek', 'RAB', 'RABBITE', 'LUSIN', 115000, 130000, 128000, 127000, 126000, 0, 0, '1 karung isi 10', 'Y'),
	('166', 'Rabbite Top Up Cowok', 'RAB', 'RABBITE', 'LUSIN', 110000, 123000, 122000, 121000, 120000, 0, 0, '1 karung isi 10', 'Y'),
	('167', 'Rabbite Top Up Cewek', 'RAB', 'RABBITE', 'LUSIN', 107000, 120000, 118000, 117000, 116000, 0, 0, '1 karung isi 10', 'Y'),
	('168', 'Skyboat Legit Tanggung', 'SKYBT', 'SKYBOAT', 'LUSIN', 87000, 101000, 100000, 99000, 98000, 0, 0, '1 karung isi 25', 'Y'),
	('169', 'Skyboat Gambar Tanggung', 'SKYBT', 'SKYBOAT', 'LUSIN', 86000, 97000, 94000, 93500, 93000, 0, 0, '1 karung isi 25', 'Y'),
	('170', 'Sepatu AP 967 Hitam', 'SPT AP', 'SPT AP', 'LUSIN', 195000, 225000, 220000, 215000, 210000, 0, 0, '1 karton isi 2 lusin', 'Y'),
	('171', 'Sun Swallow Ladies Animal Besar', 'SSWL', 'SUN SW', 'LUSIN', 125500, 137000, 136000, 135000, 134000, 133000, 0, '1 karung isi 20', 'Y'),
	('172', 'Spon Gosok Unik', 'PAL', 'PALEN', 'LUSIN', 19500, 22000, 21500, 20666.67, 20166.67, 0, 0, '1 karton isi 3 lusin', 'Y'),
	('173', 'Kit Poles', 'PAL', 'PALEN', 'PAK', 16458.34, 19000, 18500, 18000, 18000, 0, 0, '1 karton isi 12 Pak', 'Y'),
	('174', 'Kit Ban', 'PAL', 'PALEN', 'PAK', 25416.67, 28000, 27500, 27000, 26250, 0, 0, '1 karton isi 12 Pak', 'Y'),
	('175', 'Bola Plastik lurik', 'PAL', 'PALEN', 'LUSIN', 25000, 35000, 33000, 32000, 31000, 0, 0, '1 ikat isi 2,5 lusin', 'Y'),
	('176', 'Bola Plastik Fifa', 'PAL', 'PALEN', 'LUSIN', 25000, 35000, 33000, 32000, 31000, 0, 0, '1 ikat isi 2,5 lusin', 'Y'),
	('177', 'Bola Spon', 'PAL', 'PALEN', 'LUSIN', 53000, 58000, 56000, 55000, 54500, 0, 0, '1 ikat isi 2,5 lusin', 'Y'),
	('178', 'Busa Spon Polos', 'PAL', 'PALEN', 'LUSIN', 10000, 15000, 12500, 12000, 11500, 0, 0, '1 ball isi 40 lusin', 'Y'),
	('179', 'Spon Busa Karpet Polos', 'PAL', 'PALEN', 'LUSIN', 10000, 15000, 12500, 12000, 11500, 0, 0, '1 ball isi 48 lusin', 'Y'),
	('180', 'Spon Busa Bulat Polos', 'PAL', 'PALEN', 'LUSIN', 23000, 28000, 26000, 25500, 25000, 0, 0, '1 ball isi 21 lusin', 'Y'),
	('181', 'Knop Kayu', 'PAL', 'PALEN', 'PAK', 15000, 21000, 20000, 19000, 18000, 0, 0, '1 dus isi 30 Pack', 'Y'),
	('182', 'Knop Plastik', 'PAL', 'PALEN', 'LBR', 11000, 15000, 13000, 12500, 12000, 0, 0, '1 Plastik isi 10 lembar', 'Y'),
	('183', 'Swallow 938 Warna Tebal Khusus', 'SWL', 'SW', 'LUSIN', 122000, 137000, 135000, 134000, 132000, 0, 0, '1 karung isi 16', 'Y'),
	('184', 'Payung Jumbo Kembang', 'PAL', 'PALEN', 'LUSIN', 340000, 390000, 0, 0, 0, 0, 0, '', 'Y'),
	('185', 'Shampo Nosy', 'PAL', 'PALEN', 'PAK', 9791.67, 12500, 11000, 10250, 10166.67, 0, 0, '1 karton isi 24 Pak', 'Y'),
	('186', 'Newera Kenzo', 'NEW', 'NEWERA', 'LUSIN', 108000, 115000, 114000, 113000, 112000, 0, 0, '1 karung isi 20', 'Y'),
	('187', 'Newera Lexus', 'NEW', 'NEWERA', 'LUSIN', 104000, 115000, 114000, 113000, 112000, 0, 0, '1 karung isi 20', 'Y'),
	('188', 'Newera Habitat', 'NEW', 'NEWERA', 'LUSIN', 98000, 115000, 114000, 113000, 112000, 0, 0, '1 karung isi 20', 'Y'),
	('189', 'Newera Zebra', 'NEW', 'NEWERA', 'LUSIN', 98000, 115000, 114000, 113000, 112000, 0, 0, '1 karung isi 20', 'Y'),
	('190', 'Sarung Tangan Polos Abu-abu', 'PAL', 'PALEN', 'PAK', 12500, 15000, 0, 0, 0, 0, 0, '', 'Y'),
	('191', 'Sarung Tangan Bintik Kuning', 'PAL', 'PALEN', 'PAK', 21000, 25000, 23500, 23000, 22500, 0, 0, '', 'Y'),
	('192', 'Isolasi Hitam Biasa', 'PAL', 'PALEN', 'PAK', 2500, 4500, 4000, 3750, 3500, 0, 0, '', 'Y'),
	('193', 'Isolasi Hitam Abro Tebal', 'PAL', 'PALEN', 'PAK', 11000, 15500, 15000, 14500, 14000, 0, 0, '', 'Y'),
	('194', 'Isolasi Bening', 'PAL', 'PALEN', 'PAK', 6500, 9000, 8500, 8000, 7750, 0, 0, '', 'Y'),
	('195', 'Lakban Hitam Tebal', 'PAL', 'PALEN', 'PCS', 7000, 10000, 9500, 9000, 8500, 0, 0, '', 'Y'),
	('196', 'Saput Bedak', 'PAL', 'PALEN', 'PAK', 19000, 22000, 0, 0, 0, 0, 0, '', 'Y'),
	('197', 'Buku Gambar A4 Vision', 'ALT', 'VISION', 'PAK', 21000, 26000, 25000, 24000, 23500, 0, 0, '', 'Y'),
	('198', 'Spon Magic', 'PAL', 'PALEN', 'PAK', 3500, 5000, 0, 0, 0, 0, 0, '', 'Y'),
	('199', 'Shuanglu Starbucks', 'SHU', 'SHUANGLU', 'LUSIN', 103000, 115000, 112000, 110000, 109000, 0, 0, '', 'Y'),
	('200', 'Shuanglu Palmer', 'SHU', 'SHUANGLU', 'LUSIN', 103000, 115000, 112000, 110000, 109000, 0, 0, '', 'Y'),
	('201', 'Sun Swallow Hitam Seri', 'SSWL', 'SUN SW', 'LUSIN', 97000, 109000, 108000, 107000, 106000, 0, 0, '1 karung isi 20', 'Y'),
	('202', 'Sun Swallow Lumina', 'SSWL', 'SUN SW', 'LUSIN', 107000, 120000, 118000, 116000, 115000, 0, 0, '1 karung isi 20', 'Y'),
	('203', 'Sun Swallow Crystal', 'SSWL', 'SUN SW', 'LUSIN', 141000, 150000, 148000, 147000, 146000, 0, 0, '1 karung isi 20', 'Y'),
	('204', 'Sun Swallow Crystal Gold', 'SSWL', 'SUN SW', 'LUSIN', 138000, 148000, 146000, 145000, 144000, 0, 0, '1 karung isi 20', 'Y'),
	('205', 'Pearl Swallow Spike', 'PSWL', 'PEARL', 'LUSIN', 135000, 145000, 143000, 142000, 141000, 0, 0, '1 karung isi 20', 'Y'),
	('206', 'Skyboat Hiba Besar', 'SKYBT', 'SKYBOAT', 'LUSIN', 86000, 99000, 94000, 93000, 92000, 0, 0, '', 'Y'),
	('207', 'Skyboat Funny Besar', 'SKYBT', 'SKYBOAT', 'LUSIN', 86000, 99000, 94000, 93000, 92000, 0, 0, '', 'Y'),
	('208', 'Skyboat Mata Besar', 'SKYBT', 'SKYBOAT', 'LUSIN', 86000, 99000, 94000, 93000, 92000, 0, 0, '', 'Y'),
	('209', 'Sarung Tangan Badak Loreng', 'PAL', 'PALEN', 'PAK', 25000, 30000, 28000, 27000, 26500, 0, 0, '1 karung isi 50', 'Y'),
	('210', 'Dua Kaki H V-05 SLOP Ukuran 36-40', 'DK', 'DUA KAKI', 'PSG', 19500, 22500, 22000, 21500, 21000, 0, 0, '', 'Y'),
	('211', 'Oricon 520 SLOP GARIS Ukuran 39-44', 'ORIC', 'ORICON', 'PSG', 19000, 22000, 21500, 21000, 20500, 0, 0, '', 'Y'),
	('212', 'FH Nike N803 H Slop Ukuran 39-44', 'PVC', 'NIKE', 'PSG', 15500, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('213', 'Sepatu AP 969 Pentil', 'SPT AP', 'SPT AP', 'LUSIN', 345000, 370000, 365000, 360000, 360000, 0, 0, '1 karton isi 2 lusin', 'Y'),
	('214', 'Baterai ABC Photo', 'PAL', 'PALEN', 'PAK', 35555.56, 38500, 38000, 37500, 37000, 0, 0, '1 karton isi 18', 'Y'),
	('215', 'Baterai ABC Remote Biru', 'PAL', 'PALEN', 'LBR', 16666.67, 19500, 18500, 18000, 17750, 0, 0, '1 karton isi 48', 'Y'),
	('216', 'Alkohol 70% AFI', 'PAL', 'PALEN', 'LUSIN', 35000, 46000, 45000, 44500, 44000, 0, 0, '1 karton isi 8', 'Y'),
	('217', 'Rivanol AFI', 'PAL', 'PALEN', 'LUSIN', 35000, 45000, 44000, 43500, 43000, 0, 0, '1 karton isi 8', 'Y'),
	('218', 'Lem Bakar Bening', 'PAL', 'PALEN', 'PAK', 40000, 70000, 65000, 55000, 50000, 0, 0, '1 karton isi 25', 'Y'),
	('219', 'Gosok Panci Honaga T50', 'PAL', 'PALEN', 'LBR', 16100, 19000, 18500, 18000, 17500, 0, 0, '1 karton isi 60', 'Y'),
	('220', 'Gosok Panci VanArt Vacum Cepok', 'PAL', 'PALEN', 'LBR', 15000, 19000, 18000, 17500, 17000, 0, 0, '1 karton isi 60', 'Y'),
	('221', 'Sun Swallow Hitam Ukuran 11', 'SSWL', 'SUN SW', 'LUSIN', 103000, 115000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('222', 'Swallow Parodi', 'SWL', 'SW', 'LUSIN', 133000, 145000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('223', 'Swallow Nice Emoji', 'SWL', 'SW', 'LUSIN', 122000, 135000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('224', 'Newera AgnesMo', 'NEW', 'NEWERA', 'LUSIN', 120000, 132000, 131000, 130000, 129000, 0, 0, '1 karung isi 20', 'Y'),
	('225', 'Newera BCL', 'NEW', 'NEWERA', 'LUSIN', 120000, 132000, 131000, 130000, 129000, 0, 0, '1 karung isi 20', 'Y'),
	('226', 'Newera Vegas', 'NEW', 'NEWERA', 'LUSIN', 108000, 115000, 114000, 113000, 112000, 0, 0, '1 karung isi 20', 'Y'),
	('227', 'Ardiles Rhino', 'ARD', 'ARDILES', 'LUSIN', 93000, 105000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('228', 'Ardiles Neon', 'ARD', 'ARDILES', 'LUSIN', 91000, 102000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('229', 'Ardiles Smile', 'ARD', 'ARDILES', 'LUSIN', 86000, 98000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('230', 'Ardiles Lentera Seri', 'ARD', 'ARDILES', 'LUSIN', 83000, 95000, 0, 0, 0, 0, 0, '1 karung isi 20', 'Y'),
	('231', 'Newera MB 99672', 'NEW', 'NEWERA', 'PSG', 20000, 23500, 23000, 22500, 22000, 0, 0, '1karton isi 4 lusin', 'Y'),
	('232', 'Newera MB 8014', 'NEW', 'NEWERA', 'PSG', 20500, 25000, 24000, 23500, 23000, 0, 0, '1karton isi 4 lusin', 'Y'),
	('233', 'Newera MB 1117', 'NEW', 'NEWERA', 'PSG', 24000, 27000, 26500, 26000, 25500, 0, 0, '1karton isi 4 lusin', 'Y'),
	('234', 'Newera LB 90371', 'NEW', 'NEWERA', 'PSG', 20000, 24000, 23500, 23000, 22500, 0, 0, '1karton isi 4 lusin', 'Y'),
	('235', 'Newera LB 10060', 'NEW', 'NEWERA', 'PSG', 16500, 20000, 19000, 18500, 18000, 0, 0, '1karton isi 4 lusin', 'Y'),
	('236', 'Newera LB 10049', 'NEW', 'NEWERA', 'PSG', 18000, 22000, 21000, 20500, 20000, 0, 0, '1karton isi 4 lusin', 'Y'),
	('237', 'Newera Tk E 20211', 'NEW', 'NEWERA', 'PSG', 16500, 20000, 19000, 18500, 18000, 0, 0, '1karton isi 4 lusin', 'Y'),
	('238', 'Newera TG CNC 11312', 'NEW', 'NEWERA', 'PSG', 17500, 21500, 21000, 20500, 20000, 0, 0, '1karton isi 4 lusin', 'Y'),
	('239', 'Newera BB KC 2030', 'NEW', 'NEWERA', 'PSG', 14000, 18000, 17000, 16500, 16000, 0, 0, '1karton isi 5 lusin', 'Y'),
	('240', 'Golfer 328', 'GOL', 'GOLFER', 'PSG', 17500, 21500, 0, 0, 0, 0, 0, '', 'Y'),
	('241', 'Sandal AGRET 002 M', 'OB', 'OB', 'LUSIN', 145000, 180000, 0, 0, 0, 0, 0, '', 'Y'),
	('242', 'Sepatu Toyobo Cream Pentil', 'OB', 'OB', 'LUSIN', 325000, 350000, 345000, 342500, 340000, 0, 0, '1 karton isi 2 lusin', 'Y'),
	('243', 'Bolpen Ulir', 'ATK', 'NEVADA', 'PAK', 4000, 7000, 6000, 5500, 5000, 0, 0, '', 'Y'),
	('244', 'Lem Bakar Bening Ecer', 'PAL', 'PALEN', 'LUSIN', 5750, 12000, 11000, 10500, 10000, 0, 0, '', 'Y'),
	('245', 'Shuanglu Jordan', 'SHU', 'SHUANGLU', 'LUSIN', 103000, 115000, 112000, 110000, 109000, 0, 0, '1 karung isi 20', 'Y'),
	('246', 'Shuanglu Orio', 'SHU', 'SHUANGLU', 'LUSIN', 102000, 115000, 112000, 110000, 109000, 0, 0, '1 karung isi 20', 'Y'),
	('247', 'Swallow Nice Polkadot', 'SWL', 'SW', 'LUSIN', 123000, 135000, 133000, 132000, 131000, 0, 0, '1 karung isi 20', 'Y'),
	('248', 'Newera LB 51161 B', 'NEW', 'NEWERA', 'PSG', 18000, 22000, 21000, 20500, 20000, 0, 0, '', 'Y'),
	('249', 'Newera LB 9041 B', 'NEW', 'NEWERA', 'PSG', 17000, 21000, 20000, 19500, 19000, 0, 0, '', 'Y'),
	('250', 'Newera LB 90213 B', 'NEW', 'NEWERA', 'PSG', 15000, 19000, 18000, 17500, 17000, 0, 0, '', 'Y'),
	('251', 'Newera LB 12007 B', 'NEW', 'NEWERA', 'PSG', 22000, 26000, 25000, 24500, 24000, 0, 0, '', 'Y'),
	('252', 'Newera LB CNC 508', 'NEW', 'NEWERA', 'PSG', 17500, 21000, 20500, 20000, 20000, 0, 0, '', 'Y'),
	('253', 'Newera MB 1128 WB', 'NEW', 'NEWERA', 'PSG', 23000, 26500, 25500, 25000, 24500, 0, 0, '', 'Y'),
	('254', 'Newera MB 12462 B', 'NEW', 'NEWERA', 'PSG', 23000, 27000, 26000, 25500, 25000, 0, 0, '', 'Y'),
	('255', 'Newera MB CNC 112', 'NEW', 'NEWERA', 'PSG', 20500, 24000, 23000, 22500, 22000, 0, 0, '', 'Y'),
	('256', 'Newera MB 5022 B', 'NEW', 'NEWERA', 'PSG', 21000, 24500, 23500, 23000, 22500, 0, 0, '', 'Y'),
	('257', 'Newera MB 1133 B', 'NEW', 'NEWERA', 'PSG', 19500, 23500, 22500, 22000, 21500, 0, 0, '', 'Y'),
	('258', 'Newera TG 3006', 'NEW', 'NEWERA', 'PSG', 17500, 21000, 20000, 19500, 19000, 0, 0, '', 'Y'),
	('259', 'Newera TG CNC 508', 'NEW', 'NEWERA', 'PSG', 15500, 19000, 18000, 17500, 17000, 0, 0, '', 'Y'),
	('260', 'Newera TK 43002', 'NEW', 'NEWERA', 'PSG', 17500, 21000, 20000, 19500, 19000, 0, 0, '', 'Y'),
	('261', 'Spidol Snowman AG 12 Permanent', 'ATK', 'SNOWMAN', 'LUSIN', 49000, 58000, 55000, 54500, 54000, 0, 0, '', 'Y'),
	('262', 'Spidol Snowman ABG Boardmarker', 'ATK', 'SNOWMAN', 'LUSIN', 61500, 69000, 67000, 66500, 66000, 0, 0, '', 'Y'),
	('263', 'Gunting Renteng SDC 140', 'PAL', 'PALEN', 'LUSIN', 22000, 30000, 28000, 27000, 26000, 0, 0, '', 'Y'),
	('264', 'Gunting Renteng SDC 160', 'PAL', 'PALEN', 'LUSIN', 28000, 40000, 38000, 37000, 36000, 0, 0, '', 'Y'),
	('265', 'Gunting Renteng M2000 680', 'PAL', 'PALEN', 'LUSIN', 57500, 69000, 65000, 64000, 63000, 0, 0, '', 'Y'),
	('266', 'Gunting Kuku Kecil', 'PAL', 'PALEN', 'PAK', 18000, 25000, 23000, 22000, 21000, 0, 0, '', 'Y'),
	('267', 'Gunting Kuku Besar', 'PAL', 'PALEN', 'PAK', 34000, 45000, 42000, 40000, 38000, 0, 0, '', 'Y'),
	('268', 'Cutter K', 'PAL', 'PALEN', 'LUSIN', 8000, 12000, 10000, 9500, 9000, 0, 0, '', 'Y'),
	('269', 'Cutter B', 'PAL', 'PALEN', 'LUSIN', 12000, 18000, 15000, 14500, 14000, 0, 0, '', 'Y'),
	('270', 'Jarum Karung', 'PAL', 'PALEN', 'PAK', 8500, 12000, 11000, 10500, 10000, 0, 0, '', 'Y'),
	('271', 'Jarum Monte', 'PAL', 'PALEN', 'PAK', 25000, 35000, 32000, 31000, 30000, 0, 0, '', 'Y'),
	('272', 'Peniti', 'PAL', 'PALEN', 'PAK', 24000, 30000, 28500, 27000, 26000, 0, 0, '', 'Y'),
	('273', 'Hansaplast', 'PAL', 'PALEN', 'PAK', 25500, 28500, 27500, 27000, 27000, 0, 0, '', 'Y'),
	('274', 'Lakban Tipis Superfix', 'PAL', 'PALEN', 'PAK', 13750, 17500, 16000, 15500, 15000, 0, 0, '', 'Y'),
	('275', 'Sikat Cuci Kayu 414', 'PAL', 'PALEN', 'PAK', 18000, 22000, 20000, 19500, 19000, 0, 0, '', 'Y'),
	('276', 'Amplop Merpati K', 'PAL', 'PALEN', 'PAK', 30000, 35000, 33000, 32500, 32000, 0, 0, '', 'Y'),
	('277', 'Spidol Snowman Kecil Khusus', 'ATK', 'SNOWMAN', 'LUSIN', 12500, 16000, 14500, 13500, 13250, 0, 0, '', 'Y'),
	('278', 'Kit Shampo', 'PAL', 'PALEN', 'PAK', 9166.67, 14000, 12500, 12000, 11500, 0, 0, '', 'Y'),
	('279', 'Kotak Pensil Gambar Lucu', 'ATK', 'PALEN', 'PCS', 7500, 10000, 0, 0, 0, 0, 0, '', 'Y'),
	('280', 'Skyboat ALL M01', 'SKYBT', 'SKYBOAT', 'LUSIN', 95000, 108000, 106000, 104000, 103000, 0, 0, '1 karung isi 20', 'Y'),
	('281', 'Korek Tokai', 'PAL', 'PALEN', 'PAK', 84250, 88000, 87000, 86500, 86000, 0, 0, '1 karton isi 20', 'Y'),
	('282', 'Benang Renteng Butterfly Warna', 'PAL', 'PALEN', 'RTG', 9500, 13500, 12500, 12000, 11750, 0, 0, '1 pak isi 2 renteng', 'Y'),
	('283', 'Benang Renteng Butterfly Putih', 'PAL', 'PALEN', 'RTG', 10250, 14500, 13500, 13000, 12750, 0, 0, '1 pak isi 2 renteng', 'Y'),
	('284', 'Benang Renteng Butterfly Hitam', 'PAL', 'PALEN', 'RTG', 10250, 14500, 13500, 13000, 12750, 0, 0, '1 pak isi 2 renteng', 'Y'),
	('285', 'Korek Magnet Neolite Rokok', 'PAL', 'PALEN', 'PAK', 41250, 50000, 46000, 45000, 44000, 0, 0, '1 karton isi 20', 'Y'),
	('286', 'LE ZO 672 Putih 39-44', 'SUB', 'SUB', 'PSG', 14000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('287', 'LE ZO 747 Putih/Hitam 39-44', 'SUB', 'SUB', 'PSG', 14000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('288', 'LE ZO 573 Hitam 39-44', 'SUB', 'SUB', 'PSG', 14000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('289', 'CLARUDO 004 Hitam 39-44', 'CLARUDO', 'CLARUDO', 'PSG', 11000, 15000, 14000, 13500, 12500, 0, 0, '', 'Y'),
	('290', 'CLARUDO 005 Hitam 39-44', 'CLARUDO', 'CLARUDO', 'PSG', 11000, 15000, 13500, 13000, 12500, 0, 0, '', 'Y'),
	('291', 'Pearl Dark Khusus 10-10,5', 'PSWL', 'PEARL', 'LUSIN', 108000, 118000, 117000, 116000, 115000, 0, 0, '1 karung isi 20', 'Y'),
	('292', 'Sarung Tangan Banteng Jumbo', 'PAL', 'PALEN', 'LUSIN', 26000, 32000, 29000, 28000, 27500, 0, 0, '1 karung isi 50', 'Y'),
	('293', 'Sarung Tangan Apel Putih', 'PAL', 'PALEN', 'LUSIN', 20500, 25000, 24000, 23000, 22500, 0, 0, '1 karung isi 50', 'Y'),
	('294', 'Sepatu Boots Panfix Panjang', 'PANFIX', 'PANFIX', 'PSG', 47000, 58000, 55000, 54000, 53000, 0, 0, '', 'Y'),
	('295', 'Kamper Seagul Renteng Putih', 'PAL', 'PALEN', 'PAK', 24000, 32000, 30000, 29500, 29000, 28500, 0, '1 karton isi 25', 'Y'),
	('296', 'Skyboat ALL M02', 'SKYBT', 'SKYBOAT', 'LUSIN', 96000, 108000, 106000, 104000, 103000, 0, 0, '1 karung isi 20\n', 'Y'),
	('297', 'FH Nike N 808 H 39-44', 'PVC', 'NIKE', 'PSG', 15500, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('298', 'FH Gucci G 810 H 39-44', 'PVC', 'GUCCI', 'PSG', 15500, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('299', 'Inkayni YK 6027 Ukr 40-44', 'IKY', 'INKAYNI', 'PSG', 19000, 23000, 22500, 22000, 21000, 0, 0, '', 'Y'),
	('300', 'Knop Kayu Renteng', 'PAL', 'PALEN', 'RTG', 11000, 18000, 17000, 16000, 15000, 0, 0, '', 'Y'),
	('301', 'Keset Anti Slip', 'PAL', 'PALEN', 'PCS', 4500, 7000, 6000, 5500, 5500, 0, 0, '1 ball isi 20 lembar', 'Y'),
	('302', 'Spon Busa Star', 'PAL', 'PALEN', 'LUSIN', 15000, 20000, 18000, 17500, 17000, 0, 0, '', 'Y'),
	('303', 'Panadol Merah', 'OBAT', 'PALEN', 'PAK', 100000, 125000, 123000, 122000, 122000, 0, 0, '', 'Y'),
	('304', 'Panadol Biru', 'OBAT', 'PALEN', 'PAK', 90000, 122000, 120000, 119500, 119000, 0, 0, '', 'Y'),
	('305', 'Contrexin', 'OBAT', 'PALEN', 'PAK', 19000, 24000, 22000, 21500, 21000, 0, 0, '', 'Y'),
	('306', 'Bodrex', 'OBAT', 'PALEN', 'PAK', 85000, 96000, 94000, 93500, 93000, 0, 0, '', 'Y'),
	('307', 'Bodrex Extra', 'OBAT', 'PALEN', 'PAK', 47000, 52000, 51000, 50500, 50000, 0, 0, '', 'Y'),
	('308', 'Bodrex Migra', 'OBAT', 'PALEN', 'PAK', 48000, 53000, 52000, 51500, 51000, 0, 0, '', 'Y'),
	('309', 'Entrostop', 'OBAT', 'PALEN', 'PAK', 75000, 83000, 81000, 80500, 80000, 0, 0, '', 'Y'),
	('310', 'Ultraflu', 'OBAT', 'PALEN', 'PAK', 73000, 75000, 74000, 74000, 74000, 0, 0, '', 'Y'),
	('311', 'Promag', 'OBAT', 'PALEN', 'PAK', 83000, 87000, 86000, 85500, 85000, 0, 0, '', 'Y'),
	('312', 'Neu Rhemacyl', 'OBAT', 'PALEN', 'PAK', 178000, 210000, 205000, 204000, 203000, 0, 0, '', 'Y'),
	('313', 'Procold', 'OBAT', 'PALEN', 'PAK', 78000, 102000, 100000, 99500, 99000, 0, 0, '', 'Y'),
	('314', 'Oskadon', 'OBAT', 'PALEN', 'PAK', 74000, 86000, 84000, 83500, 83000, 0, 0, '', 'Y'),
	('315', 'Oskadon SP', 'OBAT', 'PALEN', 'PAK', 37500, 42000, 41000, 40500, 40000, 0, 0, '', 'Y'),
	('316', 'Kartu Remi Las Vegas', 'PAL', 'PALEN', 'PAK', 40000, 45000, 44000, 43000, 42500, 0, 0, '1 karton isi 12 pak', 'Y'),
	('317', 'Nota 2 Ply', 'PAL', 'PALEN', 'PAK', 19500, 25000, 23000, 22500, 22000, 0, 0, '', 'Y'),
	('318', 'Korek Roda Nagoya', 'PAL', 'PALEN', 'PAK', 38000, 44000, 42000, 41000, 40000, 0, 0, '1 karton isi 20', 'Y'),
	('319', 'Lakban OPP Bona 30Y', 'PAL', 'PALEN', 'PAK', 13500, 19000, 17000, 15500, 15000, 0, 0, '1 karton isi 24', 'Y'),
	('320', 'LE Zo 637 SatSet HTM/WRN 39-44', 'SUB', 'SUB', 'PSG', 14000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('321', 'LE SB 749 Mindset WRN 39-44', 'SUB', 'SUB', 'PSG', 13000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('322', 'Korek Gas Roda Neolite B8', 'PAL', 'PALEN', 'PAK', 38750, 45000, 43000, 42500, 42000, 0, 0, '1 karton isi 20', 'Y'),
	('323', 'Gunting Kecil M2000 145 Kotak', 'PAL', 'PALEN', 'PAK', 30000, 40000, 38000, 33000, 33000, 0, 0, '', 'Y'),
	('324', 'Gunting Tanggung M2000 165 Kotak', 'PAL', 'PALEN', 'PAK', 37500, 48000, 46000, 43000, 42500, 0, 0, '', 'Y'),
	('325', 'Gunting Besar M2000 180 Kotak', 'PAL', 'PALEN', 'PAK', 58000, 68000, 66000, 63000, 62500, 0, 0, '', 'Y'),
	('326', 'Gunting Jumbo M2000 185 Kotak', 'PAL', 'PALEN', 'PAK', 62500, 75000, 73000, 72000, 70000, 0, 0, '', 'Y'),
	('327', 'Sun Swallow Ladies Soft', 'SSWL', 'SUN SW', 'LUSIN', 114000, 126000, 124000, 123000, 122000, 0, 0, '1 karung isi 20', 'Y'),
	('328', 'Savilo Black Gold Seri', 'SWL', 'SW', 'LUSIN', 100000, 115000, 113000, 112000, 111000, 0, 0, '1 karung isi 20', 'Y'),
	('329', 'Savilo Batik Seri', 'SWL', 'SW', 'LUSIN', 103000, 118000, 116000, 115000, 114000, 0, 0, '1 karung isi 20', 'Y'),
	('330', 'Jas Hujan Etes', 'PAL', 'PALEN', 'LUSIN', 46000, 55000, 53000, 52000, 51000, 0, 0, '1 karung isi 48', 'Y'),
	('331', 'FH Adidas A812 Slop 39-44', 'PVC', 'ADIDAS', 'PSG', 15500, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('332', 'FH PUMA P803 Slop 39-44', 'PVC', 'PUMA', 'PSG', 15500, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('333', 'Newera 742 MB', 'NEW', 'NEWERA', 'PSG', 20500, 25000, 24000, 23500, 23000, 0, 0, '', 'Y'),
	('334', 'Amplop Merpati Tanggung', 'PAL', 'PALEN', 'PAK', 49000, 57000, 54000, 53000, 52000, 0, 0, '1 karton isi 18', 'Y'),
	('335', 'Spirtus', 'PAL', 'PALEN', 'LUSIN', 13000, 17500, 16500, 15000, 14500, 14000, 0, '', 'Y'),
	('336', 'Korek Gas Roda Fox', 'PAL', 'PALEN', 'PAK', 41250, 50000, 45000, 43500, 43000, 42500, 0, '1 karton isi 20', 'Y'),
	('337', 'Lakban Hitam Tipis', 'PAL', 'PALEN', 'PAK', 18666.67, 27500, 25000, 24000, 23000, 0, 0, '1 karton isi 90 pcs (15 pak)', 'Y'),
	('338', 'Hitop 15 ML', 'PAL', 'PALEN', 'LUSIN', 122500, 130000, 129000, 128000, 127000, 0, 0, '1 karton isi 12 lusin', 'Y'),
	('339', 'Hitop 25 ML', 'PAL', 'PALEN', 'LUSIN', 127500, 132000, 131000, 130000, 129000, 0, 0, '1 karton isi 12 lusin', 'Y'),
	('340', 'Minico', 'PAL', 'PALEN', 'LUSIN', 83500, 90000, 89000, 88000, 87000, 0, 0, '1 karton isi 20 lusin', 'Y'),
	('341', 'Sabun JF Sulfur 90gr', 'PAL', 'PALEN', 'LUSIN', 133000, 145000, 144000, 143000, 142000, 0, 0, '1 karton isi 5 lusin', 'Y'),
	('342', 'Sabun Asepso', 'PAL', 'PALEN', 'LUSIN', 88500, 95000, 94000, 93000, 92500, 0, 0, '1 karton isi 12 lusin', 'Y'),
	('343', 'CTM', 'OBAT', 'PALEN', 'PAK', 17500, 20000, 19500, 19000, 18500, 0, 0, '', 'Y'),
	('344', 'Sepatu Sankyo SAF 1115 B', 'ATT', 'ATT', 'LUSIN', 270000, 290000, 288000, 285000, 282000, 0, 0, '', 'Y'),
	('345', 'Sepatu ATT SAF 1146 B', 'ATT', 'ATT', 'LUSIN', 270000, 290000, 288000, 285000, 282000, 0, 0, '', 'Y'),
	('346', 'LE SB 749 WRN 39-44', 'SUB', 'SUB', 'PSG', 13000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('347', 'LE ZO 746 PUTIH 39-44', 'SUB', 'SUB', 'PSG', 14000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('348', 'CF 006 WARNA 36-41', 'SUB', 'SUB', 'PSG', 11000, 15000, 14000, 13000, 12500, 0, 0, '', 'Y'),
	('349', 'CF 001 HITAM 38-43', 'SUB', 'SUB', 'PSG', 11000, 15000, 14000, 13000, 12500, 0, 0, '', 'Y'),
	('350', 'CF 002 HITAM 38-43', 'SUB', 'SUB', 'PSG', 11000, 15000, 14000, 13000, 12500, 0, 0, '', 'Y'),
	('351', 'CF 014 HITAM 39-44', 'SUB', 'SUB', 'PSG', 12000, 16500, 15500, 14500, 13500, 0, 0, '', 'Y'),
	('352', 'LE ZO 672 WRN 39-44', 'SUB', 'SUB', 'PSG', 19500, 23000, 22500, 22000, 21500, 0, 0, '', 'Y'),
	('353', 'Porto 1006 K', 'POR', 'PORTO', 'PSG', 18000, 21000, 0, 0, 0, 0, 0, '', 'Y'),
	('354', 'Porto 602 L', 'POR', 'PORTO', 'PSG', 19000, 22500, 0, 0, 0, 0, 0, '', 'Y'),
	('355', 'Porto 1023 K-9 Captain Amerika', 'POR', 'PORTO', 'PSG', 14500, 17500, 0, 0, 0, 0, 0, '', 'Y'),
	('356', 'Porto W05', 'POR', 'PORTO', 'PSG', 25500, 28000, 0, 0, 0, 0, 0, '', 'Y'),
	('357', 'Porto 602 T', 'POR', 'PORTO', 'PSG', 14000, 17000, 0, 0, 0, 0, 0, '', 'Y'),
	('358', 'Porto 1023 K Spiderman', 'POR', 'PORTO', 'PSG', 14000, 17000, 0, 0, 0, 0, 0, '', 'Y'),
	('359', 'Porto 1029 T-3', 'POR', 'PORTO', 'PSG', 14000, 17000, 0, 0, 0, 0, 0, '', 'Y'),
	('360', 'Porto 1031 K', 'POR', 'PORTO', 'PSG', 14500, 18500, 18000, 17500, 17500, 0, 0, '', 'Y'),
	('361', 'Porto 1028 M', 'POR', 'PORTO', 'PSG', 23000, 27000, 26000, 25000, 24500, 0, 0, '', 'Y'),
	('362', 'Porto 1023 B Spiderman', 'POR', 'PORTO', 'PSG', 16000, 19000, 0, 0, 0, 0, 0, '', 'Y'),
	('363', 'Porto ANT 3', 'POR', 'PORTO', 'PSG', 26000, 30000, 0, 0, 0, 0, 0, '', 'Y'),
	('364', 'Porto 1023 B Captain Amerika', 'POR', 'PORTO', 'PSG', 16000, 19000, 0, 0, 0, 0, 0, '', 'Y'),
	('365', 'Kanan Kiri K38', 'KK', 'KANANKIRI', 'PSG', 14000, 17000, 0, 0, 0, 0, 0, '', 'Y'),
	('366', 'Kanan Kiri 50125', 'KK', 'KANANKIRI', 'PSG', 15500, 18500, 0, 0, 0, 0, 0, '', 'Y'),
	('367', 'Kanan Kiri 5010', 'KK', 'KANANKIRI', 'PSG', 15500, 18500, 0, 0, 0, 0, 0, '', 'Y'),
	('368', 'Newera LB E 9128', 'NEW', 'NEWERA', 'PSG', 19000, 22500, 22000, 21500, 21500, 0, 0, '', 'Y'),
	('369', 'Newera MB E 7038', 'NEW', 'NEWERA', 'PSG', 20500, 25000, 24500, 24000, 23500, 0, 0, '', 'Y'),
	('370', 'Newera MB E 7040', 'NEW', 'NEWERA', 'PSG', 21000, 25000, 24500, 24000, 23500, 0, 0, '', 'Y'),
	('371', 'Newera TK E 37042', 'NEW', 'NEWERA', 'PSG', 16000, 20000, 19500, 19000, 19000, 0, 0, '', 'Y'),
	('372', 'Newera TG E 37042', 'NEW', 'NEWERA', 'PSG', 18000, 22000, 21500, 21000, 20500, 0, 0, '', 'Y'),
	('373', 'Newera TG E 49128', 'NEW', 'NEWERA', 'PSG', 16000, 20000, 19500, 19000, 18500, 0, 0, '', 'Y'),
	('374', 'Newera TK E 49128', 'NEW', 'NEWERA', 'PSG', 14500, 18500, 18000, 17500, 17000, 0, 0, '', 'Y'),
	('375', 'Newera TK CNC 410069 POP', 'NEW', 'NEWERA', 'PSG', 14000, 18000, 17500, 17000, 16500, 0, 0, '', 'Y'),
	('376', 'Newera TG CNC 410069 POP', 'NEW', 'NEWERA', 'PSG', 15500, 20000, 19500, 19000, 18500, 0, 0, '', 'Y'),
	('377', 'Newera LB 12065 B', 'NEW', 'NEWERA', 'PSG', 20500, 25000, 24500, 22500, 22500, 0, 0, '', 'Y'),
	('378', 'Newera LB 12063 B', 'NEW', 'NEWERA', 'PSG', 19500, 25000, 24500, 21500, 21500, 0, 0, '', 'Y'),
	('379', 'Newera LB 12064 B', 'NEW', 'NEWERA', 'PSG', 19500, 25000, 24500, 24000, 23000, 0, 0, '', 'Y'),
	('380', 'Newera MB 80602', 'NEW', 'NEWERA', 'PSG', 21500, 26000, 25500, 25000, 24500, 0, 0, '', 'Y'),
	('381', 'Newera MB 8058', 'NEW', 'NEWERA', 'PSG', 21500, 26000, 25500, 25000, 24500, 0, 0, '', 'Y'),
	('382', 'Newera MB 8057 (80572)', 'NEW', 'NEWERA', 'PSG', 21000, 26000, 25000, 23000, 23000, 0, 0, '', 'Y'),
	('383', 'Newera MB 8066', 'NEW', 'NEWERA', 'PSG', 18000, 23000, 22500, 22000, 21000, 0, 0, '', 'Y'),
	('384', 'Newera MB 9108', 'NEW', 'NEWERA', 'PSG', 18000, 22500, 22000, 21500, 21000, 0, 0, '', 'Y'),
	('385', 'Newera MB 9109', 'NEW', 'NEWERA', 'PSG', 18000, 22500, 22000, 21500, 21000, 0, 0, '', 'Y'),
	('386', 'Dua Kaki 1502 Ukr 40-44', 'DK', 'DUA KAKI', 'PSG', 17500, 21500, 21000, 20500, 20000, 0, 0, '1 dus isi 60 psg', 'Y'),
	('387', 'Dua Kaki 589-1 Ukr 39-43', 'DK', 'DUA KAKI', 'PSG', 23500, 27500, 27000, 26500, 26000, 0, 0, '1 dus isi 60 psg', 'Y'),
	('388', 'Dua Kaki 508 A Ukr 40-43', 'DK', 'DUA KAKI', 'PSG', 17500, 21500, 21000, 20500, 20000, 0, 0, '1 dus isi 72 psg', 'Y'),
	('389', 'Inkayni 6027-5 Ukr 40-44', 'IKY', 'INKAYNI', 'PSG', 18000, 23000, 22500, 22000, 21000, 0, 0, '1 dus isi 72 psg', 'Y'),
	('390', 'Inkayni 6119 Ukr 40-44', 'IKY', 'INKAYNI', 'PSG', 20500, 25000, 24500, 24000, 23000, 0, 0, '1 dus isi 72 psg', 'Y'),
	('391', 'Collin B7835-T3 Ukr 30-35', 'COLL', 'COLLIN', 'PSG', 16500, 21000, 20500, 20000, 19000, 0, 0, '1 dus isi 96 psg', 'Y'),
	('392', 'Tissue Paseo isi 6', 'PAL', 'PASEO', 'PAK', 4250, 5500, 5250, 5000, 4750, 0, 0, '1 karton isi 40', 'Y'),
	('393', 'Tissue Paseo Refil 500', 'PAL', 'PASEO', 'PAK', 9500, 11000, 10500, 10000, 10000, 0, 0, '1 karton isi 48', 'Y'),
	('394', 'Tissue Paseo Travelpack', 'PAL', 'PASEO', 'IKAT', 19000, 23000, 22000, 20500, 20000, 0, 0, '1 karton isi 80', 'Y'),
	('395', 'Lakban Sedang 72 yard Seven Star', 'PAL', 'PALEN', 'SLOP', 22750, 36000, 35000, 32000, 30000, 0, 0, '1  karton isi 12 slop', 'Y'),
	('396', 'Gosok Panci Good Wife Besr', 'PAL', 'PALEN', 'RTG', 30000, 38000, 35000, 34000, 33000, 0, 0, '1 karton isi 30', 'Y'),
	('397', 'Kamper Seagul Renteng Warna', 'PAL', 'PALEN', 'PAK', 24000, 32000, 30000, 29500, 29000, 28500, 0, '1 karton isi 25', 'Y'),
	('398', 'Shuanglu Niklaus', 'SHU', 'SHUANGLU', 'LUSIN', 102000, 115000, 112000, 110000, 109000, 0, 0, '1 karung isi 20', 'Y'),
	('399', 'Skyboat Pol 1', 'SKYBT', 'SKYBOAT', 'LUSIN', 99000, 115000, 113000, 112000, 110000, 0, 0, '1 karung isi 20', 'Y'),
	('400', 'Sepatu AP 963 CREAM', 'SPT AP', 'SPT AP', 'LUSIN', 322000, 360000, 355000, 345000, 340000, 0, 0, '1 karton isi 2 lusin', 'Y'),
	('401', 'LE SB 709 HTM 39-44', 'SUB', 'SUB', 'PSG', 14000, 19000, 18500, 18000, 17500, 0, 0, '', 'Y'),
	('402', 'Newera LB 10048', 'NEW', 'NEWERA', 'PSG', 18000, 22000, 0, 0, 0, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('403', 'Newera LB 10056', 'NEW', 'NEWERA', 'PSG', 21500, 26500, 0, 0, 0, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('404', 'Newera LB 10038', 'NEW', 'NEWERA', 'PSG', 18000, 22000, 21500, 21000, 21000, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('405', 'Newera LB 10021', 'NEW', 'NEWERA', 'PSG', 21000, 25000, 0, 0, 0, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('406', 'Newera LB 90371', 'NEW', 'NEWERA', 'PSG', 20000, 24000, 23500, 23000, 22500, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('407', 'Newera MB 5018', 'NEW', 'NEWERA', 'PSG', 23000, 27000, 26500, 26000, 25500, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('408', 'Newera MB 75002', 'NEW', 'NEWERA', 'PSG', 22000, 28500, 28000, 27500, 27500, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('409', 'Newera TG 49015', 'NEW', 'NEWERA', 'PSG', 19500, 23500, 0, 0, 0, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('410', 'Newera TG 51163', 'NEW', 'NEWERA', 'PSG', 18000, 22000, 21500, 21000, 21000, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('411', 'Newera TG CNC 11312', 'NEW', 'NEWERA', 'PSG', 17500, 21500, 21000, 20500, 20000, 0, 0, '1 karton isi 4 lusin', 'Y'),
	('412', 'Surfs M-001', 'SURFS', 'SURFS', 'PSG', 16000, 20000, 19500, 19000, 18500, 0, 0, '1 karton isi 60 psg', 'Y'),
	('413', 'Surfs M-002', 'SURFS', 'SURFS', 'PSG', 17500, 22000, 21500, 21000, 20500, 0, 0, '1 karton isi 54 psg', 'Y'),
	('414', 'Surfs M-003', 'SURFS', 'SURFS', 'PSG', 17500, 22000, 21500, 21000, 20500, 0, 0, '1 karton isi 54 psg', 'Y'),
	('415', 'Ceqiu EH 8A-5', 'CEQIU', 'CEOIU', 'PSG', 20000, 24000, 23500, 23000, 22500, 0, 0, '1 karton isi 60 psg', 'Y'),
	('416', 'Dulux 656 A', 'DLX', 'DULUX', 'PSG', 20000, 24000, 23500, 23000, 22500, 0, 0, '1 karton isi 60 psg', 'Y'),
	('417', 'Dua Kaki 516 Ukr 40-44', 'DK', 'DUA KAKI', 'PSG', 20000, 24000, 23500, 22500, 22500, 0, 0, '1 karton isi 72 psg', 'Y'),
	('418', 'Dua Kaki C237 BU Ukr 24-29', 'DK', 'DUA KAKI', 'PSG', 15500, 19500, 19000, 18000, 18000, 0, 0, '1 karton isi 60 psg', 'Y'),
	('419', 'Inkayni 2130 Ukr 24-29', 'IKY', 'INKAYNI', 'PSG', 15500, 19500, 19000, 18000, 18000, 0, 0, '1 karton isi 144 psg', 'Y'),
	('420', 'Gosome 8831-1 Ukr 39-43', 'GOS', 'GOSOME', 'PSG', 18500, 22500, 22000, 21000, 21000, 0, 0, '1 karton isi 72 psg', 'Y'),
	('421', 'Inkayni 6030 Ukr 40-44', 'IKY', 'INKAYNI', 'PSG', 19500, 23500, 23000, 22000, 22000, 0, 0, '1 karton isi 72 psg', 'Y'),
	('422', 'Dua Kaki 519-1 Ukr 39-44', 'DK', 'DUA KAKI', 'PSG', 21500, 25500, 25000, 24000, 24000, 0, 0, '1 karton isi 72 psg', 'Y'),
	('423', 'Korek Gas Bara Dolphin', 'PAL', 'PALEN', 'PAK', 60500, 70000, 68000, 65000, 64000, 0, 0, '1 karton isi 20', 'Y'),
	('424', 'Lakban Tebal 90 yard Bona', 'PAL', 'PALEN', 'SLOP', 32500, 42000, 41000, 38000, 36000, 0, 0, '1 karton isi 12', 'Y'),
	('425', 'Isolasi Bolak-Balik double tape', 'PAL', 'PALEN', 'SLOP', 19000, 28000, 26000, 25000, 24000, 0, 0, '1 karton isi 12', 'Y'),
	('426', 'Tembel Panci Roll', 'PAL', 'PALEN', 'PCS', 19000, 26000, 25000, 24000, 23000, 0, 0, '', 'Y'),
	('427', 'Tembel Panci Renteng', 'PAL', 'PALEN', 'RTG', 9500, 15000, 14000, 12500, 12000, 0, 0, '', 'Y'),
	('428', 'Korek Gas Magnet Rokok Osaka', 'PAL', 'PALEN', 'PAK', 40750, 50000, 48000, 45000, 44000, 0, 0, '1 karton isi 20', 'Y'),
	('429', 'Lakban Hitam Sedang 8 yard Bona', 'PAL', 'PALEN', 'PAK', 19500, 30000, 28000, 26000, 25000, 0, 0, '1 karton isi 144 pcs (24 pack)', 'Y'),
	('430', 'Rafia 1000', 'PAL', 'PALEN', 'IKAT', 9000, 16000, 15000, 12000, 11000, 0, 0, '', 'Y'),
	('431', 'Rafia 2000', 'PAL', 'PALEN', 'IKAT', 16000, 21000, 20000, 19000, 18000, 0, 0, '', 'Y'),
	('432', 'Rafia 5000', 'PAL', 'PALEN', 'IKAT', 24000, 30000, 29000, 26000, 26000, 0, 0, '', 'Y'),
	('433', 'Rafia 10.000', 'PAL', 'PALEN', 'IKAT', 52500, 68000, 67000, 65000, 64000, 0, 0, '', 'Y'),
	('434', 'Rafia 15.000', 'PAL', 'PALEN', 'IKAT', 90000, 102000, 100000, 99000, 98000, 0, 0, '', 'Y'),
	('435', 'Pensil Warna Panjang Safari', 'ATK', 'SAFARI', 'LUSIN', 57500, 75000, 74000, 73000, 72500, 0, 0, '1 karton isi 20 lusin', 'Y'),
	('436', 'Pensil Warna Pendek Safari', 'ATK', 'SAFARI', 'LUSIN', 37500, 47500, 46000, 45000, 44000, 0, 0, '1 karton isi 40 lusin', 'Y'),
	('437', 'Spidol Warna Set Safari', 'ATK', 'SAFARI', 'LUSIN', 38500, 47500, 46000, 45000, 43000, 0, 0, '1 karton isi 24 lusin', 'Y'),
	('438', 'Penghapus Setip isi 40 Hitam Safari', 'ATK', 'SAFARI', 'PAK', 14000, 18000, 17500, 17000, 16500, 0, 0, '1 karton isi 50 pak', 'Y'),
	('439', 'Penghapus Setip isi 40 Putih Orlee', 'ATK', 'ORLEE', 'PAK', 14000, 18000, 17500, 17000, 16500, 0, 0, '', 'Y'),
	('440', 'Lem Bakar Kecil Safari', 'PAL', 'SAFARI', 'PAK', 42500, 75000, 68000, 57500, 52500, 0, 0, '1 karton isi 25', 'Y'),
	('441', 'Peniti Swan', 'PAL', 'SWAN', 'PAK', 28750, 35000, 34000, 33000, 32500, 0, 0, '', 'Y'),
	('442', 'Gunting Renteng Hitam Kecil Pacman', 'PAL', 'PACMAN', 'RTG', 25000, 30000, 29000, 28500, 28000, 0, 0, '1 karton isi 60 renteng', 'Y'),
	('443', 'Gunting Renteng Hitam Tanggung Pacman', 'PAL', 'PACMAN', 'RTG', 27500, 35000, 34000, 32000, 30000, 0, 0, '1 karton isi 60 renteng', 'Y'),
	('444', 'Kertas Kado Fancy GK', 'ATK', 'GK', 'PAK', 32500, 38000, 37000, 36000, 35000, 0, 0, '1 karton isi10 pak', 'Y'),
	('445', 'Kertas Kado Batik GK', 'ATK', 'GK', 'PAK', 32500, 38000, 37000, 36000, 35000, 0, 0, '1 karton isi10 pak', 'Y'),
	('446', 'Buku Oktavo 100 GK', 'ATK', 'GK', 'PAK', 45000, 55000, 54000, 52000, 50000, 0, 0, '1 karton isi16 pak', 'Y'),
	('447', 'Buku Tulis Bestone GK isi 32', 'ATK', 'GK', 'PAK', 19450, 24000, 23500, 23000, 22500, 0, 0, '1 karton isi 40 pak', 'Y'),
	('448', 'Buku Tulis Bestone GK isi 38', 'ATK', 'GK', 'PAK', 21500, 26000, 25500, 25000, 24500, 0, 0, '1 karton isi 32 pak', 'Y'),
	('449', 'Buku Tulis Bestone GK isi 58', 'ATK', 'GK', 'PAK', 32800, 40000, 39500, 39000, 38500, 0, 0, '1 karton isi 24 pak', 'Y'),
	('450', 'Buku Gambar A4 GK', 'ATK', 'GK', 'PAK', 17000, 23500, 23000, 22500, 22000, 0, 0, '1 karton isi 30 pak', 'Y'),
	('451', 'Nota NCR 2 ply GK', 'ATK', 'GK', 'PAK', 26250, 31000, 30000, 29000, 28500, 0, 0, '1 karton isi 56 pak', 'Y'),
	('452', 'Swallow Black Diamond', 'SWL', 'SW', 'LUSIN', 109000, 120000, 118000, 115000, 114000, 0, 0, '1 karung isi 20 ls', 'Y'),
	('453', 'Skyboat K03 Labubu B', 'SKYBT', 'SKYBOAT', 'LUSIN', 85000, 95000, 94000, 93000, 92000, 0, 0, '1 karung isi 20 ls', 'Y'),
	('454', 'Inkayni 3120 Ukr 30-35', 'IKY', 'INKAYNI', 'PSG', 15000, 19000, 18500, 17500, 17500, 0, 0, '1 karton isi 96', 'Y'),
	('455', 'Inkayni 1018 G-1 Ukr 18-23', 'IKY', 'INKAYNI', 'PSG', 16000, 20000, 19500, 18500, 18500, 0, 0, '1 karton isi 144', 'Y'),
	('456', 'Inkayni 2120 Ukr 24-29', 'IKY', 'INKAYNI', 'PSG', 14000, 18000, 17500, 16500, 16500, 0, 0, '1 karton isi 144', 'Y'),
	('457', 'Inkayni 1055B Ukr 18-23', 'IKY', 'INKAYNI', 'PSG', 15000, 19000, 18500, 17500, 17500, 0, 0, '1 karton isi 144', 'Y'),
	('458', 'Inkayni 5106 Ukr 35-40', 'IKY', 'INKAYNI', 'PSG', 23000, 27000, 26500, 25500, 25500, 0, 0, '1 karton isi 72', 'Y'),
	('459', 'Inkayni 2009 Ukr 24-29', 'IKY', 'INKAYNI', 'PSG', 14000, 18000, 17500, 16500, 16500, 0, 0, '1 karton isi 144', 'Y'),
	('460', 'Inkayni 5115 Ukr 36-40', 'IKY', 'INKAYNI', 'PSG', 15000, 19000, 18500, 17500, 17500, 0, 0, '1 karton isi 72', 'Y'),
	('461', 'Inkayni 6058-1 Ukr 40-44', 'IKY', 'INKAYNI', 'PSG', 19000, 23000, 22500, 21500, 21500, 0, 0, '1 karton isi 72', 'Y'),
	('462', 'Inkayni 3009 Ukr 30-35', 'IKY', 'INKAYNI', 'PSG', 15000, 19000, 18500, 17500, 17500, 0, 0, '1 karton isi 96', 'Y'),
	('463', 'Inkayni 6009-6 Ukr 40-44', 'IKY', 'INKAYNI', 'PSG', 18500, 23000, 22500, 21500, 21500, 0, 0, '1 karton isi 72', 'Y'),
	('464', 'Newera MB E 11137 Ukr 40-43', 'NEW', 'NEWERA', 'PSG', 19500, 24000, 23500, 23000, 23000, 0, 0, '', 'Y'),
	('465', 'Newera MB CNC 8065 Ukr 39-44', 'NEW', 'NEWERA', 'PSG', 18000, 22500, 22000, 20500, 20500, 0, 0, '', 'Y'),
	('466', 'Newera MB E 5050 Ukr 39-43', 'NEW', 'NEWERA', 'PSG', 18500, 23000, 22500, 22000, 22000, 0, 0, '', 'Y'),
	('467', 'Newera MB E 71253 Ukr 39-43', 'NEW', 'NEWERA', 'PSG', 21000, 25500, 25000, 23000, 23000, 0, 0, '', 'Y'),
	('468', 'Newera MB E 7027 Ukr 39-43', 'NEW', 'NEWERA', 'PSG', 18000, 22500, 22000, 21500, 21500, 0, 0, '', 'Y'),
	('469', 'Newera MB E 7024 Ukr 39-43', 'NEW', 'NEWERA', 'PSG', 17500, 22000, 21500, 21000, 21000, 0, 0, '', 'Y'),
	('470', 'Newera MB E 99581 Ukr 40-43', 'NEW', 'NEWERA', 'PSG', 22500, 27000, 26500, 26000, 26000, 0, 0, '', 'Y'),
	('471', 'Newera MB 8030 Ukr 39-43', 'NEW', 'NEWERA', 'PSG', 19000, 23500, 23000, 22500, 22500, 0, 0, '', 'Y'),
	('472', 'Newera LB 12066 Ukr 37-40', 'NEW', 'NEWERA', 'PSG', 16000, 21000, 20500, 20000, 20000, 0, 0, '', 'Y'),
	('473', 'Newera LB E 11031 Ukr 37-41', 'NEW', 'NEWERA', 'PSG', 19500, 24000, 23500, 23000, 23000, 0, 0, '', 'Y'),
	('474', 'Newera LB E 9134 Ukr 37-41', 'NEW', 'NEWERA', 'PSG', 18000, 22500, 22000, 20000, 20000, 0, 0, '', 'Y'),
	('475', 'Newera LB 10062 Ukr 37-41', 'NEW', 'NEWERA', 'PSG', 14500, 19000, 18500, 16500, 16500, 0, 0, '', 'Y'),
	('476', 'Newera LB E 1520V Ukr 37-40', 'NEW', 'NEWERA', 'PSG', 20000, 24500, 24000, 23500, 23500, 0, 0, '', 'Y'),
	('477', 'Newera LB E 11023 Ukr 37-40', 'NEW', 'NEWERA', 'PSG', 16500, 21000, 20500, 20000, 20000, 0, 0, '', 'Y'),
	('478', 'Newera LB E 11509 Ukr 37-41', 'NEW', 'NEWERA', 'PSG', 17000, 21500, 21000, 20500, 20500, 0, 0, '', 'Y'),
	('479', 'Newera TG 8030', 'NEW', 'NEWERA', 'PSG', 17500, 22000, 21500, 21000, 21000, 0, 0, '', 'Y'),
	('480', 'Newera TK E 37013', 'NEW', 'NEWERA', 'PSG', 17000, 21500, 21000, 20500, 20500, 0, 0, '', 'Y'),
	('481', 'Dua Kaki V30 Ukr 36-40', 'DK', 'DUA KAKI', 'PSG', 26500, 31000, 30500, 29000, 29000, 0, 0, '1 karton isi 42', 'Y'),
	('482', 'Celion 1102-1 Ukr 36-41', 'CELION', 'CELION', 'PSG', 20500, 25000, 24500, 23500, 23000, 0, 0, '1 karton isi 60', 'Y'),
	('483', 'Celion 2102-1A Ukr 39-44', 'CELION', 'CELION', 'PSG', 18000, 22000, 21500, 21000, 21000, 0, 0, '1 karton isi 72', 'Y'),
	('484', 'Celion 1106-1 Ukr 36-41', 'CELION', 'CELION', 'PSG', 21500, 26000, 25500, 24500, 24500, 0, 0, '1 karton isi 60', 'Y'),
	('485', 'Celion 3108-4 K Ukr 24-29', 'CELION', 'CELION', 'PSG', 15500, 20000, 19500, 18500, 18500, 0, 0, '1 karton isi 120', 'Y'),
	('486', 'Celion 3108-1 T Ukr 30-35', 'CELION', 'CELION', 'PSG', 17500, 22000, 21500, 20500, 20500, 0, 0, '1 karton isi 120', 'Y'),
	('487', 'Celion 3104-2 T Ukr 30-35', 'CELION', 'CELION', 'PSG', 15500, 20000, 19500, 18500, 18500, 0, 0, '1 karton isi 126', 'Y'),
	('488', 'Celion 3101-D3 S  Ukr 18-23', 'CELION', 'CELION', 'PSG', 13000, 17500, 17000, 16000, 16000, 0, 0, '1 karton isi 120', 'Y'),
	('489', 'Celion 3101-D3 K Ukr 24-29', 'CELION', 'CELION', 'PSG', 14000, 19000, 18500, 17000, 17000, 0, 0, '1 karton isi 120', 'Y'),
	('490', 'Pensil 2B Montana', 'ATK', 'Montana', 'LUSIN', 4458.34, 7500, 7000, 6500, 6000, 0, 0, '1 karton isi 30 Gross', 'Y'),
	('491', 'Sun Swallow Ladies Black Seri', 'SSWL', 'SUN SW', 'LUSIN', 101000, 115000, 114000, 112000, 111000, 0, 0, '1 karung isi 20', 'Y'),
	('492', 'Sun Swallow Ladies Cat Seri', 'SSWL', 'SUN SW', 'LUSIN', 116000, 130000, 129000, 128000, 126000, 0, 0, '1 karung isi 20', 'Y'),
	('493', 'Sarung Tangan Apel Abu Bintik', 'PAL', 'PALEN', 'PAK', 20500, 25000, 24000, 23000, 22500, 0, 0, '1 karung isi 50', 'Y'),
	('494', 'Collin B 6305 K2 Ukr 24-29', 'COLL', 'COLLIN', 'PSG', 19500, 24000, 23500, 22500, 22500, 0, 0, '1 karton isi 108', 'Y'),
	('495', 'Collin B 6150 18T Ukr 30-35', 'COLL', 'COLLIN', 'PSG', 17500, 22000, 21500, 20500, 20500, 0, 0, '1 karton isi 96', 'Y'),
	('496', 'Kamifa AJ 2347 L-H Ukr 35-40', 'KAMIFA', 'KAMIFA', 'PSG', 19000, 23500, 23000, 22000, 22000, 0, 0, '1 karton isi 72', 'Y'),
	('497', 'Lakban OPP Nachi Tebal', 'PAL', 'NACHI', 'SLOP', 45000, 50000, 49000, 48000, 47500, 0, 0, '1 karton isi 12 slop', 'Y'),
	('498', 'Lem Glue Stick', 'ATK', 'WINSTAR', 'PAK', 17100, 26000, 25000, 21000, 20000, 0, 0, '1 karton isi 45 pak', 'Y'),
	('499', 'Pemes Renteng', 'ATK', 'WINSTAR', 'RTG', 2607, 5000, 4500, 4000, 3500, 0, 0, '1 karton isi 500 renteng', 'Y'),
	('500', 'Alat Lem Tembak Biasa', 'PAL', 'WINSTAR', 'PCS', 6500, 10000, 9500, 8500, 8000, 0, 0, '1 karton isi 180 pcs', 'Y'),
	('501', 'Alat Lem Tembak 20 W', 'PAL', 'WINSTAR', 'PCS', 14500, 20000, 19000, 18000, 17500, 0, 0, '1 karton isi 120 pcs', 'Y'),
	('502', 'Pisau Buah', 'PAL', 'WINSTAR', 'RTG', 23940, 35000, 34000, 30000, 30000, 0, 0, '1 karton isi 80 renteng', 'Y'),
	('503', 'Spidol Warna Khusus Hitam Winstar', 'ATK', 'WINSTAR', 'LUSIN', 5343.75, 10000, 9000, 7000, 6750, 0, 0, '1 karton isi 20 Gross', 'Y'),
	('504', 'Spidol Warna Khusus Biru Winstar', 'ATK', 'WINSTAR', 'LUSIN', 5343.75, 10000, 9000, 7000, 6750, 0, 0, '1 karton isi 20 Gross', 'Y'),
	('505', 'Spidol Warna Khusus Merah Winstar', 'ATK', 'WINSTAR', 'LUSIN', 5343.75, 10000, 9000, 7000, 6750, 0, 0, '1 karton isi 20 Gross', 'Y'),
	('506', 'Penggaris Besi 30cm isi 2 lusin', 'ATK', 'WINSTAR', 'PAK', 32489, 40000, 0, 0, 0, 0, 0, '1 karton isi 25 Pak', 'Y'),
	('507', 'Kartu Remi Win Star', 'PAL', 'WINSTAR', 'PAK', 32775, 45000, 0, 0, 0, 0, 0, '1 karton isi 12 Pak', 'Y'),
	('508', 'Penghapus Setip isi 24 Win Star', 'ATK', 'WINSTAR', 'PAK', 8763.75, 15000, 14500, 14000, 13500, 0, 0, '1 karton isi 60 Pak', 'Y'),
	('509', 'Lakban Hitam 10 Y Winstar', 'PAL', 'WINSTAR', 'PCS', 6198.75, 10000, 9500, 9000, 8500, 0, 0, '1 karton isi 72 Pcs', 'Y'),
	('510', 'Masking Tape White 24mm', 'PAL', 'WINSTAR', 'PCS', 2907, 4500, 4250, 4000, 3750, 0, 0, '1 karton isi 144 Pcs', 'Y'),
	('511', 'Masking Tape White 45mm', 'PAL', 'WINSTAR', 'PCS', 5687, 7500, 7000, 6500, 6250, 0, 0, '1 karton isi 72 Pcs', 'Y'),
	('512', 'Double Tape 12mm Winstar', 'PAL', 'WINSTAR', 'PCS', 726.75, 1250, 0, 0, 0, 0, 0, '1 karton isi 288 Pcs', 'Y'),
	('513', 'Double Tape 24mm Winstar', 'PAL', 'WINSTAR', 'PCS', 1453.5, 2500, 2400, 2083.34, 2000, 0, 0, '1 karton isi 144 Pcs', 'Y'),
	('514', 'Lakban OPP 90 Y Winstar', 'PAL', 'WINSTAR', 'SLOP', 24793.29, 35000, 0, 0, 0, 0, 0, '1 karton isi 12 Slop', 'Y'),
	('515', 'Lem Bakar 800 Gr M-one', 'PAL', 'WINSTAR', 'PAK', 31635, 65000, 60000, 50000, 45000, 0, 0, '1 karton isi 30 Pak', 'Y'),
	('516', 'Kaos Kaki Bola Tusso', 'PAL', 'PALEN', 'LUSIN', 61000, 75000, 74000, 70000, 68000, 0, 0, '', 'Y'),
	('517', 'Rafia 10.000 Warna', 'PAL', 'PALEN', 'IKAT', 55000, 70000, 68000, 65000, 64000, 0, 0, '', 'Y'),
	('518', 'Skyboat Miami', 'SKYBT', 'SKYBOAT', 'LUSIN', 122000, 137000, 136000, 135000, 134000, 0, 0, '1 karung isi 16', 'Y'),
	('519', 'Skyboat All M04', 'SKYBT', 'SKYBOAT', 'LUSIN', 94000, 108000, 106000, 104000, 103000, 0, 0, '1 karung isi 20', 'Y'),
	('520', 'Inkayni 6022 Ukr 36-40', 'IKY', 'INKAYNI', 'PSG', 19500, 24000, 23500, 23000, 23000, 0, 0, '1 karton isi 72', 'Y'),
	('521', 'Newera 5055 MBE', 'NEW', 'NEWERA', 'PSG', 20500, 25000, 24500, 23500, 23500, 0, 0, '1 karton isi 48', 'Y'),
	('522', 'Newera 11381 MBE', 'NEW', 'NEWERA', 'PSG', 19500, 24000, 23500, 22500, 22500, 0, 0, '1 karton isi 48', 'Y'),
	('523', 'Newera 11035 LBE', 'NEW', 'NEWERA', 'PSG', 19500, 24000, 23500, 22500, 22500, 0, 0, '1 karton isi 48', 'Y'),
	('524', 'Newera 91041 LBE', 'NEW', 'NEWERA', 'PSG', 20000, 24500, 24000, 23500, 23500, 0, 0, '1 karton isi 48', 'Y'),
	('525', 'Newera 90951 LBE', 'NEW', 'NEWERA', 'PSG', 20000, 24500, 24000, 23500, 23500, 0, 0, '1 karton isi 48', 'Y'),
	('526', 'Newera 8039 MB', 'NEW', 'NEWERA', 'PSG', 20000, 24500, 24000, 21500, 21500, 0, 0, '1 karton isi 48', 'Y'),
	('527', 'Newera 9123 LB', 'NEW', 'NEWERA', 'PSG', 19000, 23500, 23000, 21000, 21000, 0, 0, '1 karton isi 48', 'Y'),
	('528', 'Newera 9135 LB', 'NEW', 'NEWERA', 'PSG', 19000, 23500, 23000, 21000, 21000, 0, 0, '1 karton isi 48', 'Y'),
	('529', 'Newera 9132 LB', 'NEW', 'NEWERA', 'PSG', 17500, 22000, 21500, 21000, 21000, 0, 0, '1 karton isi 48', 'Y'),
	('530', 'Newera 8040 MB', 'NEW', 'NEWERA', 'PSG', 20500, 26000, 25500, 23000, 23000, 0, 0, '1 karton isi 48', 'Y'),
	('531', 'Newera 6046 MB', 'NEW', 'NEWERA', 'PSG', 18500, 23500, 23000, 21000, 21000, 0, 0, '1 karton isi 48', 'Y'),
	('532', 'Korek Gas Roda Fighter', 'PAL', 'FIGHTER', 'PAK', 38250, 45000, 44000, 41000, 40000, 0, 0, '1 karton isi 20', 'Y'),
	('533', 'Amplop BGAIN Kecil', 'PAL', 'PALEN', 'SLOP', 20000, 28000, 27000, 26000, 25000, 0, 0, '1 karton isi 30', 'Y'),
	('534', 'Amplop BGAIN Tanggung', 'PAL', 'PALEN', 'SLOP', 30000, 38000, 37000, 36000, 35000, 0, 0, '1 karton isi 10', 'Y'),
	('535', 'Buku Gambar A4 Biasa', 'ATK', 'PALEN', 'PAK', 12500, 18000, 17000, 16000, 15000, 0, 0, '1 karton isi 60', 'Y'),
	('536', 'Lem Bakar M-One 1kg', 'PAL', 'WINSTAR', 'PAK', 38475, 75000, 70000, 55000, 50000, 0, 0, '1 karton isi 24', 'Y'),
	('537', 'Lem G Barcode Merah 303', 'PAL', 'PALEN', 'PAK', 145000, 185000, 175000, 165000, 160000, 0, 0, '1 karton isi 10', 'Y'),
	('538', 'Dulux 563 A-5', 'DLX', 'DULUX', 'PSG', 20000, 24000, 23500, 22500, 22000, 0, 0, '1 karton isi 60 ', 'Y'),
	('539', 'Surfs M-006', 'SURFS', 'SURFS', 'PSG', 16000, 20000, 19500, 18500, 18500, 0, 0, '1 karton isi 72', 'Y'),
	('540', 'Skyboat K02 Animal B', 'SKYBT', 'SKYBOAT', 'LUSIN', 81000, 95000, 94000, 93000, 92000, 0, 0, '1 karung isi 20', 'Y'),
	('541', 'Shuanglu Marvel', 'SHU', 'SHUANGLU', 'LUSIN', 102000, 115000, 112000, 110000, 109000, 0, 0, '1 karung isi 20', 'Y'),
	('542', 'Hansaplast Koyo Hot Renteng', 'PAL', 'PALEN', 'PAK', 22500, 27500, 26500, 25500, 25000, 0, 0, '1 karton isi 50', 'Y'),
	('543', 'Tissue Joly 250', 'PAL', 'PALEN', 'PCS', 6500, 8500, 8250, 8000, 7750, 0, 0, '1 karton isi 48\n', 'Y'),
	('544', 'Mely NB 118 Kaplir Double', 'MLY', 'MELLY', 'LUSIN', 74000, 88000, 87000, 85000, 84000, 0, 0, '1 karung isi 18', 'Y'),
	('545', 'Sandal Lawas', 'SWL', 'SWL', 'Lusin', 10000, 40000, 30000, 25000, 23000, 20000, 0, 'Isi 12 saja', 'Y'),
	('546', 'Sandal Terbang', 'terbang', 'terbang', 'SWL', 10000, 20000, 18000, 0, 0, 0, 0, 'Sandal bisa Terbang', 'Y');

-- membuang struktur untuk table jaya_makmur.tb_beli
CREATE TABLE IF NOT EXISTS `tb_beli` (
  `id_beli` varchar(50) NOT NULL,
  `tgl_beli` datetime NOT NULL,
  `tgl_tempo` datetime NOT NULL,
  `kode_supplier` varchar(50) DEFAULT NULL,
  `status_bayar` enum('Y','N') DEFAULT 'N',
  `total_hpp` double DEFAULT NULL,
  PRIMARY KEY (`id_beli`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_beli: ~1 rows (lebih kurang)
DELETE FROM `tb_beli`;
INSERT INTO `tb_beli` (`id_beli`, `tgl_beli`, `tgl_tempo`, `kode_supplier`, `status_bayar`, `total_hpp`) VALUES
	('B25040001', '2025-04-09 22:11:27', '2025-04-09 22:11:27', '001', 'Y', 2144000),
	('B25040002', '2025-04-09 22:13:26', '2025-04-09 22:13:26', '001', 'Y', 1155000);

-- membuang struktur untuk table jaya_makmur.tb_beli_detail
CREATE TABLE IF NOT EXISTS `tb_beli_detail` (
  `id_nota` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL,
  `kode_barang` varchar(50) NOT NULL,
  `nama_barang` varchar(150) NOT NULL,
  `qty` double NOT NULL,
  `harga_beli` double DEFAULT NULL,
  `subtotal` double DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `kode_barang` (`kode_barang`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_beli_detail: ~7 rows (lebih kurang)
DELETE FROM `tb_beli_detail`;
INSERT INTO `tb_beli_detail` (`id_nota`, `id`, `kode_barang`, `nama_barang`, `qty`, `harga_beli`, `subtotal`) VALUES
	('B25040001', '661f24f0-b1c7-45f9-8dbf-523bf37798a2', '002', 'Swallow Army', 3, 113000, 339000),
	('B25040001', '989a8bf2-c34c-459f-b2a4-cda89b680671', '003', 'Swallow Floral', 4, 109000, 436000),
	('B25040001', '9fce0db4-e3aa-4a80-8c2d-eae53e00abf6', '006', 'Pearl Swallow 05 Seri', 6, 97000, 582000),
	('B25040002', 'ab31a6eb-3132-41f0-93b2-e27ded6e7bd3', '008', 'Pearl Swallow 05 11', 9, 103000, 927000),
	('B25040001', 'c42ac0de-3871-4369-bd39-2108e02a7212', '005', 'Swallow 05 Ukr 11', 5, 112000, 560000),
	('B25040002', 'cac81428-3cd2-4f1d-b264-d38d9af26eea', '009', 'Sun Swallow Wave', 2, 114000, 228000),
	('B25040001', 'd609250c-c5d9-4ea5-b60b-a2b3735561be', '001', 'Swallow black M02 SR', 2, 113500, 227000);

-- membuang struktur untuk view jaya_makmur.tb_beli_view
-- Membuat tabel sementara untuk menangani kesalahan ketergantungan VIEW
CREATE TABLE `tb_beli_view` (
	`id_beli` VARCHAR(1) NOT NULL COLLATE 'utf8mb4_general_ci',
	`tgl_beli` DATETIME NOT NULL,
	`tgl_tempo` DATETIME NOT NULL,
	`nama` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`status_bayar` VARCHAR(1) NULL COLLATE 'utf8_general_ci',
	`total_hpp` DOUBLE NULL
) ENGINE=MyISAM;

-- membuang struktur untuk table jaya_makmur.tb_jual
CREATE TABLE IF NOT EXISTS `tb_jual` (
  `id_jual` varchar(50) NOT NULL,
  `tgl_jual` datetime NOT NULL,
  `kode_konsumen` varchar(50) DEFAULT NULL,
  `status_bayar` enum('Y','N') DEFAULT 'N',
  `total_transaksi` double DEFAULT NULL,
  `total_hpp` double DEFAULT NULL,
  `total_bayar` double DEFAULT NULL,
  PRIMARY KEY (`id_jual`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_jual: ~6 rows (lebih kurang)
DELETE FROM `tb_jual`;
INSERT INTO `tb_jual` (`id_jual`, `tgl_jual`, `kode_konsumen`, `status_bayar`, `total_transaksi`, `total_hpp`, `total_bayar`) VALUES
	('J25040001', '2025-04-10 23:51:52', '01', NULL, 356000, 340000, NULL),
	('J25040002', '2025-04-11 12:48:48', '01', NULL, 119000, 113500, NULL),
	('J25040003', '2025-04-12 11:46:46', '06', NULL, 119000, 113500, NULL),
	('J25040004', '2025-04-12 12:56:34', '01', NULL, 118000, 113500, NULL),
	('J25040005', '2025-04-12 12:58:24', '01', NULL, 118000, 113500, NULL),
	('J25040006', '2025-04-12 13:10:20', '01', NULL, 120000, 113500, 120000);

-- membuang struktur untuk table jaya_makmur.tb_jualtitip_detail
CREATE TABLE IF NOT EXISTS `tb_jualtitip_detail` (
  `id_jual_titip` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL,
  `kode_barang` varchar(50) NOT NULL,
  `qty_titip` double NOT NULL,
  `qty_kembali` double NOT NULL,
  `harga_jual` double DEFAULT NULL,
  `tipe_harga` varchar(50) DEFAULT NULL,
  `subtotal` double DEFAULT NULL,
  `harga_hpp` double DEFAULT NULL,
  `subtotal_hpp` double DEFAULT NULL,
  `nama_barang` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kode_barang` (`kode_barang`) USING BTREE,
  KEY `id_jual` (`id_jual_titip`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_jualtitip_detail: ~0 rows (lebih kurang)
DELETE FROM `tb_jualtitip_detail`;

-- membuang struktur untuk table jaya_makmur.tb_jual_detail
CREATE TABLE IF NOT EXISTS `tb_jual_detail` (
  `id_jual` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL,
  `kode_barang` varchar(50) NOT NULL,
  `id_member` varchar(50) NOT NULL,
  `qty` double NOT NULL,
  `harga_jual` double DEFAULT NULL,
  `tipe_harga` varchar(50) DEFAULT NULL,
  `subtotal` double DEFAULT NULL,
  `harga_hpp` double DEFAULT NULL,
  `subtotal_hpp` double DEFAULT NULL,
  `tgl_tambah` datetime NOT NULL,
  `nama_barang` varchar(255) DEFAULT NULL,
  KEY `id_jual` (`id_jual`),
  KEY `kode_barang` (`kode_barang`),
  KEY `id_member` (`id_member`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_jual_detail: ~6 rows (lebih kurang)
DELETE FROM `tb_jual_detail`;
INSERT INTO `tb_jual_detail` (`id_jual`, `id`, `kode_barang`, `id_member`, `qty`, `harga_jual`, `tipe_harga`, `subtotal`, `harga_hpp`, `subtotal_hpp`, `tgl_tambah`, `nama_barang`) VALUES
	('J25040001', '0246a2f4-84c3-42ad-be55-25ab92e61de9', '001', '01', 2, 118000, 'H3', 236000, 113500, 227000, '2025-04-10 23:51:52', 'Swallow black M02 SR'),
	('J25040002', '9fd0883c-6b33-44ad-af1e-479ffc93f162', '001', '01', 1, 119000, 'H2', 119000, 113500, 113500, '2025-04-11 12:48:54', 'Swallow black M02 SR'),
	('J25040003', 'ef580244-b2cd-480b-aefa-b97461a8c3e4', '001', '06', 1, 119000, 'H2', 119000, 113500, 113500, '2025-04-12 11:46:50', 'Swallow black M02 SR'),
	('J25040004', '302d08c2-0dda-4937-9a1a-d614a50b7c61', '001', '01', 1, 118000, 'H3', 118000, 113500, 113500, '2025-04-12 12:56:38', 'Swallow black M02 SR'),
	('J25040005', 'a96427f7-5bfd-465b-afb0-c74d36f4b033', '001', '01', 1, 118000, 'H3', 118000, 113500, 113500, '2025-04-12 12:58:45', 'Swallow black M02 SR'),
	('J25040006', '41fec624-1f5c-4192-9050-af3233e51f6e', '001', '01', 1, 120000, 'H1', 120000, 113500, 113500, '2025-04-12 13:10:24', 'Swallow black M02 SR');

-- membuang struktur untuk table jaya_makmur.tb_jual_titip
CREATE TABLE IF NOT EXISTS `tb_jual_titip` (
  `id_jual_titip` varchar(50) NOT NULL,
  `tgl_jual` datetime NOT NULL,
  `kode_konsumen` varchar(50) DEFAULT NULL,
  `status_bayar` enum('Y','N') DEFAULT 'N',
  `total_transaksi` double DEFAULT NULL,
  `total_hpp` double DEFAULT NULL,
  `total_bayar` double DEFAULT NULL,
  PRIMARY KEY (`id_jual_titip`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_jual_titip: ~0 rows (lebih kurang)
DELETE FROM `tb_jual_titip`;

-- membuang struktur untuk table jaya_makmur.tb_kartu_stok
CREATE TABLE IF NOT EXISTS `tb_kartu_stok` (
  `id` varchar(50) NOT NULL,
  `tanggal` datetime DEFAULT NULL,
  `id_nota` varchar(50) DEFAULT NULL,
  `kode_barang` varchar(50) DEFAULT NULL,
  `masuk` double DEFAULT NULL,
  `keluar` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_kartu_stok: ~14 rows (lebih kurang)
DELETE FROM `tb_kartu_stok`;
INSERT INTO `tb_kartu_stok` (`id`, `tanggal`, `id_nota`, `kode_barang`, `masuk`, `keluar`) VALUES
	('11bf6136-17b6-4991-9e3b-69e7e48415e6', '2025-04-11 12:48:48', 'J25040002', '001', 1, 0),
	('16657018-8fa3-4396-8b24-09db1dfd29d7', '2025-04-12 13:10:20', 'J25040006', '001', 1, 0),
	('5b5bd8b8-d52d-4393-9d2a-586038d0cf22', '2025-04-09 22:11:27', NULL, '001', 2, 0),
	('65794fdf-cbfc-44c1-9b58-82019143f406', '2025-04-09 22:11:27', NULL, '005', 5, 0),
	('75962a26-a777-40e0-bbc0-72871f01f509', '2025-04-09 22:11:27', NULL, '002', 3, 0),
	('7b343add-de22-4975-84d8-a67e6c055376', '2025-04-09 22:13:26', NULL, '009', 2, 0),
	('816fa871-b52f-4985-8175-85714e19be75', '2025-04-12 11:46:46', 'J25040003', '001', 1, 0),
	('b5255aa7-4cfb-4118-b5be-814aba0538c5', '2025-04-09 22:13:26', NULL, '008', 9, 0),
	('bf0b77c1-85a1-45d5-970a-ace23b6c7765', '2025-04-10 23:51:52', 'J25040001', '001', 2, 0),
	('d5b41953-f4a1-4b8d-ab7e-bd4f7e0d6b25', '2025-04-09 22:11:27', NULL, '003', 4, 0),
	('da2bda2e-e575-4f86-b4bf-0291ea1945b5', '2025-04-09 22:11:27', NULL, '006', 6, 0),
	('ed068e8a-b7a3-4e1c-ad81-f5502a406143', '2025-04-12 12:56:34', 'J25040004', '001', 1, 0),
	('f49d7f37-9d4a-4a3d-91ea-5b71525f3031', '2025-04-10 23:51:52', 'J25040001', '002', 1, 0),
	('f7b50acd-c0b5-4cfb-9f4d-4fd4916baa76', '2025-04-12 12:58:24', 'J25040005', '001', 1, 0);

-- membuang struktur untuk table jaya_makmur.tb_konsumen
CREATE TABLE IF NOT EXISTS `tb_konsumen` (
  `kode` varchar(50) NOT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `alamat` varchar(50) DEFAULT NULL,
  `provinsi` varchar(50) DEFAULT NULL,
  `kota` varchar(50) DEFAULT NULL,
  `grupharga` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_konsumen: ~31 rows (lebih kurang)
DELETE FROM `tb_konsumen`;
INSERT INTO `tb_konsumen` (`kode`, `nama`, `alamat`, `provinsi`, `kota`, `grupharga`) VALUES
	('01', 'Tk Lancar Jaya', 'Madiun', 'Jawa Timur', '', 'H4'),
	('02', 'Pak Didik', 'Ponorogo', '', '', 'H4'),
	('03', 'Koh Hin Tk Abadi', 'Jl Jendral Sudirman', 'Ponorogo', '', 'H4'),
	('04', 'Pak Karju', 'Ponorogo', '', '', 'H4'),
	('05', 'Pak Ikhsan', 'Ponorogo', '', '', 'H3'),
	('06', 'BU SRI Po', '', '', '', 'H2'),
	('07', 'Pak Faizal', 'Sampit Ponorogo', '', '', 'H4'),
	('08', 'Tk Murah', 'Ponorogo', '', '', 'H4'),
	('09', 'Pak Anton', 'Pulung, Ponorogo', '', '', 'H3'),
	('10', 'OM JOKO', 'PARANG', 'MAGETAN', 'JAWA TIMUR', 'H4'),
	('11', 'Pak Nuril', 'Sampung', 'PONOROGO', '', 'H4'),
	('12', 'Pak Said', 'Pulung', '', '', 'H4'),
	('13', 'OM BROTO', 'Parang', 'Magetan', '', 'H3'),
	('14', 'OM RATNO', 'DANYANG', '', '', 'H4'),
	('15', 'TANTE YULI', 'CARUBAN', 'CARUBAN', 'JAWA TIMUR', 'H2'),
	('16', 'OM SUKRI', 'ARIA TOYS', 'CARUBAN', '', 'H2'),
	('17', 'PAK MARSONO', 'SLAHUNG', 'PONOROGO', '', 'H4'),
	('18', 'Mas Agus Darmawan', 'Ponorogo', 'Ponorogo', '', 'H3'),
	('19', 'Sendy', 'Ponorogo', 'Ponorogo', '', 'H3'),
	('20', 'PAK UNTUNG', '', 'PONOROGO', '', 'H3'),
	('21', 'PAK AGUNG', '', 'PONOROGO', '', 'H3'),
	('22', 'PAK ARIF', '', 'PONOROGO', '', 'H3'),
	('Aku', 'Aku Laku', '', '', '', 'H1'),
	('BL', 'Buka Lapak', '', '', '', 'H1'),
	('Jago', 'Jago', '', '', '', 'H1'),
	('Sales', 'Sales', '', '', '', 'H3'),
	('Sales 2', 'Sales 2', '', '', '', 'H4'),
	('Shopee', 'Shopee- Umum', '', '', '', 'H1'),
	('Shopee kjk', 'Shopee KJK Shop', '', '', '', 'H1'),
	('Toped', 'Tokopedia', '', '', '', 'H1'),
	('UMUM', 'UMUM/CASH', '', '', '', 'H1'),
	('UMUM 1', 'SHOPEE CASH', '', '', '', 'H1');

-- membuang struktur untuk view jaya_makmur.tb_nota_view
-- Membuat tabel sementara untuk menangani kesalahan ketergantungan VIEW
CREATE TABLE `tb_nota_view` 
) ENGINE=MyISAM;

-- membuang struktur untuk table jaya_makmur.tb_supplier
CREATE TABLE IF NOT EXISTS `tb_supplier` (
  `kode` varchar(50) NOT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `alamat` varchar(225) DEFAULT NULL,
  `kota` varchar(225) DEFAULT NULL,
  `provinsi` varchar(225) DEFAULT NULL,
  `bank` varchar(225) DEFAULT NULL,
  `norek` varchar(225) DEFAULT NULL,
  `atasnama` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_supplier: ~13 rows (lebih kurang)
DELETE FROM `tb_supplier`;
INSERT INTO `tb_supplier` (`kode`, `nama`, `alamat`, `kota`, `provinsi`, `bank`, `norek`, `atasnama`) VALUES
	('001', 'Kenny Podo Murni', 'Kediri', '', '', '', '', ''),
	('002', 'EKA DAYA', 'JL. PASAR TURI KOMPLEK PERTOKOAN SINAR GALAXY A38', 'SURABAYA', 'JATIM', 'BCA', '1007255888', 'ROBERT SETIOSO'),
	('003', 'Pak Agus', 'Surabaya', '', '', '', '', ''),
	('004', 'Rahayu', 'Kediri', '', '', '', '', ''),
	('005', 'Sinar Jaya', 'Kediri', '', '', '', '', ''),
	('006', 'Om Gun', 'Kediri', '', '', '', '', ''),
	('007', 'KARUNIA JAYA', 'SURABAYA', '', '', '', '', ''),
	('008', 'Tk Satu', 'KEDIRI', '', '', '', '', ''),
	('009', 'Om Agus Celion', 'Surabaya Jakarta', '', '', '', '', ''),
	('010', 'Lima Pilar Asia (Pak Gun)', 'Surabaya', '', '', '', '', ''),
	('KL', 'Kunci Laris', 'Solo', '', '', '', '', ''),
	('SP0001', 'SPL', '', '', '', '', '', '');

-- membuang struktur untuk table jaya_makmur.tb_usaha
CREATE TABLE IF NOT EXISTS `tb_usaha` (
  `nama` varchar(50) NOT NULL,
  `alamat` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`nama`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Membuang data untuk tabel jaya_makmur.tb_usaha: ~0 rows (lebih kurang)
DELETE FROM `tb_usaha`;
INSERT INTO `tb_usaha` (`nama`, `alamat`) VALUES
	('Toko Jaya Murni', 'Jl. Gatot Subroto 82 Ponorogo');

-- Menghapus tabel sementara dan menciptakan struktur VIEW terakhir
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `barang_stok_view` AS SELECT tb_barang.kode_barang,tb_barang.nama_barang,tb_barang.stok,tb_barang.satuan FROM tb_barang 
WHERE tb_barang.isJual='Y' 
;

-- Menghapus tabel sementara dan menciptakan struktur VIEW terakhir
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `barang_view` AS SELECT tb_barang.kode_barang,tb_barang.nama_barang FROM tb_barang 
WHERE tb_barang.isJual='Y' 
;

-- Menghapus tabel sementara dan menciptakan struktur VIEW terakhir
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `tb_beli_view` AS SELECT
	  `tb_beli`.`id_beli` AS `id_beli`,
	  `tb_beli`.`tgl_beli` AS `tgl_beli`,
	  `tb_beli`.`tgl_tempo` AS `tgl_tempo`,
	  `tb_supplier`.`nama` AS `nama`,
	  IF(`tb_beli`.`status_bayar` = 'Y', 'L', 'BL') AS `status_bayar`,
	  `tb_beli`.`total_hpp` AS `total_hpp`
	FROM (`tb_supplier`
	  JOIN `tb_beli`
	    ON (`tb_supplier`.`kode` = `tb_beli`.`kode_supplier`)) 
;

-- Menghapus tabel sementara dan menciptakan struktur VIEW terakhir
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `tb_nota_view` AS SELECT
	  `tb_jual`.`id_jual` AS `id_jual`,
	  `tb_jual`.`tgl_jual` AS `tgl_jual`,
	  `tb_konsumen`.`nama` AS `nama`,
	  `tb_jual`.`status_bayar` AS `status_bayar`,
	  `tb_jual`.`total_transaksi` AS `total_transaksi`,
	  `tb_jual_detail`.`kode_barang` AS `kode_barang`,
	  `tb_jual_detail`.`qty` AS `qty`,
	  `tb_jual_detail`.`harga_jual` AS `harga_jual`,
	  `tb_jual_detail`.`subtotal` AS `subtotal`,
	  `bayar`
	FROM ((`tb_jual`
	  JOIN `tb_jual_detail`
	    ON (`tb_jual`.`id_jual` = `tb_jual_detail`.`id_jual`))
	  JOIN `tb_konsumen`
	    ON (`tb_konsumen`.`kode` = `tb_jual`.`kode_konsumen`)) 
;

