INSERT INTO `barang` VALUES 
('0101', '1231241231', 'Buku Tulis Sinar Dunia', '5000', '0', '4000', '0', '01', '100', '10'),
('0102', '3732742323', 'Buku Tulis Papeline', '6000', '0', '5000', '0', '01', '90', '10'),
('0103', '8271818233', 'Pencil 2B', '2000', '0', '1500', '0', '02', '20', '5'),
('0104', '8273123123', 'Pencil biasa', '1000', '0', '800', '0', '02', '80', '5'),
('K001', 'BARK001', 'Buku Manajemen Database', '15000', '0', '12000', '0', '01', '100', '100'),
('K002', 'BARK002', 'Buku Sistem Informasi', '20000', '0', '18000', '0', '01', '100', '100'),
('K003', 'BARK003', 'Tipex Xerox', '5000', '0', '4500', '0', '02', '500', '500'),
('K004', 'BARK004', 'Buku Desain Website', '15000', '0', '12000', '0', '01', '200', '200');
INSERT INTO `customer` VALUES 
('01', 'NA', 'NA', 'NA', 'NA', 'Perorangan'),
('02', 'CV Margana', 'Jl. Slamet Riyadi', 'Solo', '0814847237', 'CV'),
('03', 'CV Merdeka', 'Jl.Kerinci', 'Jogja', '0834273423', 'CV');
INSERT INTO `faktur_pembelian` VALUES 
('fb01', 'S01', '2009-11-21', '100000'),
('fb02', 'S02', '2009-11-20', '200000'),
('fp01', '01', '2009-11-20', '300000'),
('fp02', '03', '2009-11-19', '500000');
INSERT INTO `jenis_barang` VALUES 
('01', 'Buku'),
('02', 'Pensil');
INSERT INTO `order_customer` VALUES 
('oc01', '2009-11-20', '2009-11-23', '01', 'K001'),
('oc02', '2009-11-19', '2009-11-24', '02', '0103');
INSERT INTO `order_supplier` VALUES 
('os01', '2009-11-21', '2009-11-23', 'S01', '0101'),
('os02', '2009-11-21', '2009-11-24', 'S02', '0102'),
('os03', '2009-11-21', '2009-11-23', 'S02', '0103');
INSERT INTO `pembelian` VALUES 
('fb01', 'os01', '0101', '4', '4000', '16000', '0'),
('fb01', 'os01', '0102', '5', '5000', '25000', '0'),
('fb02', 'os03', '0103', '10', '1500', '15000', '0'),
('fp01', 'K001', '01', '10', '15000', '150000', '0'),
('fp01', 'K002', '02', '5', '20000', '100000', '0'),
('fp02', '0103', '03', '7', '2000', '14000', '0');
INSERT INTO `supplier` VALUES 
('S01', 'Matkomindo', 'Solo', '023812412', 'CV'),
('S02', 'Multi Gama', 'Jogja', '394234234', 'CV'),
('S03', 'Medikatama', 'semarang', '012412412', 'PT'),
('S04', 'Sunda Kelapa', 'jakarta', '023423423', 'PT');