Langsung aja, untuk database silahkan dibuat terlebih dahulu biar bisa bertahap dan ga lompat - lompat :
NB: Jangan ditanyakan dulu ttg normalisasi database karna aplikasi yang ane rancang ini belum final... Segala hal berhubungan dengan anomali database bertujuan untuk pengembangan ketahap berikutnya meskipun ada beberapa hal yang emang ga penting sih :p
# --------------------------------------------------------
# Host: localhost
# Server version: 5.5.8
# Server OS: Win32
# HeidiSQL version: 6.0.0.3603
# Date/time: 2013-09-04 22:46:38
# --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
# Dumping database structure for db_esa_vita
CREATE DATABASE IF NOT EXISTS `db_esa_vita` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `db_esa_vita`;
# Dumping structure for view db_esa_vita.hist_hutang
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `hist_hutang` (
`kode_dist` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_dist` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tgl` TIMESTAMP NULL DEFAULT NULL,
`ket` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`barang` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`awal` BIGINT(20) NOT NULL DEFAULT '0',
`masuk` DOUBLE NULL DEFAULT NULL,
`keluar` DOUBLE NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(5) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.hist_piutang
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `hist_piutang` (
`kode_cust` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_cust` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tgl` DATETIME NULL DEFAULT NULL,
`ket` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
`barang` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`awal` BIGINT(20) NOT NULL DEFAULT '0',
`masuk` DOUBLE NULL DEFAULT NULL,
`keluar` DOUBLE NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci'
) ENGINE=MyISAM;
# Dumping structure for table db_esa_vita.tmbarang
CREATE TABLE IF NOT EXISTS `tmbarang` (
`kode_brg` varchar(50) NOT NULL DEFAULT '',
`nama_brg` varchar(50) DEFAULT 'X',
`satuan` varchar(50) DEFAULT 'X',
`harga_jual` double DEFAULT '0' COMMENT 'Harga Untuk penjualan Cash',
`smin` int(4) DEFAULT '0',
`smax` int(4) DEFAULT '0',
`berubah` tinyint(4) DEFAULT '0',
`kode_kel` varchar(5) DEFAULT 'X',
`tgl_input` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_id` varchar(50) DEFAULT NULL,
`harga_jual_credit` double DEFAULT '0' COMMENT 'Harga untuk penjualan Kredit',
`ref_barang` varchar(50) DEFAULT '0',
`isi` int(11) DEFAULT '0',
`kons` enum('0','1') DEFAULT '0',
PRIMARY KEY (`kode_brg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmcustomer
CREATE TABLE IF NOT EXISTS `tmcustomer` (
`kode_cust` varchar(50) NOT NULL DEFAULT '',
`nama_cust` varchar(50) DEFAULT NULL,
`alamat_cust` varchar(50) DEFAULT NULL,
`telp_cust` varchar(50) DEFAULT NULL,
`cp_cust` varchar(50) DEFAULT NULL,
`ref_cust` varchar(50) DEFAULT NULL,
`tgl_daftar` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_id` varchar(50) DEFAULT NULL,
`jabatan` varchar(50) DEFAULT NULL,
`pengurus` enum('0','1') DEFAULT '0',
`saldo_max` double DEFAULT '0',
`anggota` enum('0','1') DEFAULT '0',
PRIMARY KEY (`kode_cust`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmdistributor
CREATE TABLE IF NOT EXISTS `tmdistributor` (
`kode_dist` varchar(50) NOT NULL DEFAULT '',
`nama_dist` varchar(50) DEFAULT NULL,
`alamat_dist` varchar(50) DEFAULT NULL,
`telp_dist` varchar(50) DEFAULT NULL,
`cp_dist` varchar(50) DEFAULT NULL,
`tgl_daftar` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_id` varchar(50) DEFAULT NULL,
PRIMARY KEY (`kode_dist`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmharga_jual
CREATE TABLE IF NOT EXISTS `tmharga_jual` (
`kode_brg` varchar(50) DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`min_jual` tinyint(4) DEFAULT NULL,
`id_toko` varchar(5) DEFAULT 'TK001'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmhutang
CREATE TABLE IF NOT EXISTS `tmhutang` (
`id_hutang` varchar(25) NOT NULL,
`ket` varchar(50) NOT NULL DEFAULT '',
`tgl_hutang` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`kode_dist` varchar(50) NOT NULL,
`tgl_tempo` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`jml_hutang` double DEFAULT NULL,
`lunas` tinyint(4) DEFAULT '0',
`batal` tinyint(4) DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`id_hutang`),
KEY `FK_tmhutang_tmunit` (`kode_unit`),
KEY `FK_tmhutang_tmdistributor` (`kode_dist`),
KEY `FK_tmhutang_tmuser` (`user_id`),
CONSTRAINT `FK_tmhutang_tmdistributor` FOREIGN KEY (`kode_dist`) REFERENCES `tmdistributor` (`kode_dist`),
CONSTRAINT `FK_tmhutang_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_tmhutang_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmhutang_hapus
CREATE TABLE IF NOT EXISTS `tmhutang_hapus` (
`id_hutang` varchar(25) NOT NULL,
`ket` varchar(50) NOT NULL DEFAULT '',
`tgl_hutang` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`kode_dist` varchar(50) NOT NULL,
`tgl_tempo` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`jml_hutang` double DEFAULT NULL,
`lunas` tinyint(4) DEFAULT '0',
`batal` tinyint(4) DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`id_hutang`),
KEY `kode_dist` (`kode_dist`),
KEY `kode_unit` (`kode_unit`),
KEY `user_id` (`user_id`),
CONSTRAINT `tmhutang_hapus_ibfk_1` FOREIGN KEY (`kode_dist`) REFERENCES `tmdistributor` (`kode_dist`),
CONSTRAINT `tmhutang_hapus_ibfk_2` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `tmhutang_hapus_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmkelompok
CREATE TABLE IF NOT EXISTS `tmkelompok` (
`kode_kel` varchar(5) NOT NULL DEFAULT '',
`nama_kel` varchar(50) DEFAULT NULL,
`tgl_input` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_id` varchar(50) DEFAULT NULL,
PRIMARY KEY (`kode_kel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmmodal
CREATE TABLE IF NOT EXISTS `tmmodal` (
`id_stock` varchar(25) NOT NULL,
`tgl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`kode_brg` varchar(50) NOT NULL DEFAULT '',
`harga_modal` double DEFAULT NULL,
`stock_awal` int(10) DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`id_stock`),
KEY `FK_tmmodal_tmbarang` (`kode_brg`),
KEY `FK_tmmodal_tmuser` (`user_id`),
KEY `FK_tmmodal_tmunit` (`kode_unit`),
CONSTRAINT `FK_tmmodal_tmbarang` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `FK_tmmodal_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_tmmodal_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmmodal_hapus
CREATE TABLE IF NOT EXISTS `tmmodal_hapus` (
`id_stock` varchar(25) NOT NULL,
`tgl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`kode_brg` varchar(50) NOT NULL DEFAULT '',
`harga_modal` double DEFAULT NULL,
`stock_awal` int(10) DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
KEY `FK_tmmodal_tmbarang` (`kode_brg`),
KEY `FK_tmmodal_tmuser` (`user_id`),
KEY `FK_tmmodal_tmunit` (`kode_unit`),
CONSTRAINT `tmmodal_hapus_ibfk_1` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `tmmodal_hapus_ibfk_2` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `tmmodal_hapus_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmpiutang
CREATE TABLE IF NOT EXISTS `tmpiutang` (
`id_piutang` varchar(25) NOT NULL,
`ket` varchar(50) NOT NULL DEFAULT '',
`tgl_piutang` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`kode_cust` varchar(50) NOT NULL,
`tgl_tempo` timestamp NULL DEFAULT NULL,
`jml_piutang` double DEFAULT NULL,
`lunas` tinyint(4) DEFAULT '0',
`batal` tinyint(4) DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`id_piutang`),
KEY `FK_tmpiutang_tmcustomer` (`kode_cust`),
KEY `FK_tmpiutang_tmunit` (`kode_unit`),
KEY `FK_tmpiutang_tmuser` (`user_id`),
CONSTRAINT `FK_tmpiutang_tmcustomer` FOREIGN KEY (`kode_cust`) REFERENCES `tmcustomer` (`kode_cust`),
CONSTRAINT `FK_tmpiutang_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_tmpiutang_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmpiutang_hapus
CREATE TABLE IF NOT EXISTS `tmpiutang_hapus` (
`id_piutang` varchar(25) NOT NULL,
`ket` varchar(50) NOT NULL DEFAULT '',
`tgl_piutang` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`kode_cust` varchar(50) NOT NULL,
`tgl_tempo` timestamp NULL DEFAULT NULL,
`jml_piutang` double DEFAULT NULL,
`lunas` tinyint(4) DEFAULT '0',
`batal` tinyint(4) DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`id_piutang`),
KEY `FK_tmpiutang_tmcustomer` (`kode_cust`),
KEY `FK_tmpiutang_tmunit` (`kode_unit`),
KEY `FK_tmpiutang_tmuser` (`user_id`),
CONSTRAINT `tmpiutang_hapus_ibfk_1` FOREIGN KEY (`kode_cust`) REFERENCES `tmcustomer` (`kode_cust`),
CONSTRAINT `tmpiutang_hapus_ibfk_2` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `tmpiutang_hapus_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmpromo
CREATE TABLE IF NOT EXISTS `tmpromo` (
`id_promo` varchar(25) NOT NULL,
`tgl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`kode_brg` varchar(50) DEFAULT NULL,
`jml_jual` int(10) DEFAULT '0',
`disk_jual` float DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
`harga_jual` double DEFAULT '0',
`harga_jual_credit` double DEFAULT '0',
PRIMARY KEY (`id_promo`),
KEY `FK_tmpromo_tmbarang` (`kode_brg`),
KEY `FK_tmpromo_tmunit` (`kode_unit`),
KEY `FK_tmpromo_tmuser` (`user_id`),
CONSTRAINT `FK_tmpromo_tmbarang` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `FK_tmpromo_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_tmpromo_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmunit
CREATE TABLE IF NOT EXISTS `tmunit` (
`kode_unit` varchar(5) NOT NULL DEFAULT '',
`nama_unit` varchar(50) DEFAULT NULL,
PRIMARY KEY (`kode_unit`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tmuser
CREATE TABLE IF NOT EXISTS `tmuser` (
`user_id` varchar(20) NOT NULL DEFAULT '',
`pass` varchar(50) DEFAULT NULL,
`kode_unit` varchar(5) DEFAULT 'TK001',
`c` enum('0','1') DEFAULT '0',
`r` enum('0','1') DEFAULT '0',
`u` enum('0','1') DEFAULT '0',
`d` enum('0','1') DEFAULT '0',
PRIMARY KEY (`user_id`),
KEY `FK_tmuser_tmunit` (`kode_unit`),
CONSTRAINT `tmuser_ibfk_1` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttbayar_hutang
CREATE TABLE IF NOT EXISTS `ttbayar_hutang` (
`nofak_bayar` varchar(25) NOT NULL,
`tgl_bayar` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`nofak_beli` varchar(50) DEFAULT '0',
`kode_dist` varchar(50) DEFAULT NULL,
`jml_bayar` double DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
`id_hutang` varchar(25) DEFAULT NULL,
PRIMARY KEY (`nofak_bayar`),
KEY `FK_ttbayar_hutang_tmunit` (`kode_unit`),
KEY `FK_ttbayar_hutang_tmuser` (`user_id`),
CONSTRAINT `FK_ttbayar_hutang_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_ttbayar_hutang_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttbayar_hutang_hapus
CREATE TABLE IF NOT EXISTS `ttbayar_hutang_hapus` (
`nofak_bayar` varchar(20) NOT NULL,
`tgl_bayar` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`nofak_beli` varchar(50) DEFAULT '0',
`kode_dist` varchar(50) DEFAULT NULL,
`jml_bayar` double DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
`id_hutang` int(11) DEFAULT NULL,
PRIMARY KEY (`nofak_bayar`),
KEY `FK_ttbayar_hutang_tmunit` (`kode_unit`),
KEY `FK_ttbayar_hutang_hapus_tmuser` (`user_id`),
CONSTRAINT `FK_ttbayar_hutang_hapus_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`),
CONSTRAINT `ttbayar_hutang_hapus_ibfk_1` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttbayar_titipan
CREATE TABLE IF NOT EXISTS `ttbayar_titipan` (
`nofak_bayar` varchar(25) NOT NULL,
`tgl_bayar` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`no_titip` varchar(50) DEFAULT '0',
`kode_dist` varchar(50) DEFAULT NULL,
`jml_bayar` double DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
`id_hutang` varchar(25) DEFAULT NULL,
PRIMARY KEY (`nofak_bayar`),
KEY `FK_ttbayar_hutang_tmunit` (`kode_unit`),
KEY `FK_ttbayar_hutang_tmuser` (`user_id`),
CONSTRAINT `ttbayar_titipan_ibfk_1` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `ttbayar_titipan_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttbeli
CREATE TABLE IF NOT EXISTS `ttbeli` (
`nofak_beli` varchar(50) NOT NULL DEFAULT '',
`tgl_beli` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`kode_dist` varchar(50) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`disk_fak` float DEFAULT '0',
`ppn` float DEFAULT '0',
`cash` tinyint(4) DEFAULT '1',
`batal` tinyint(4) DEFAULT '0',
`tutup` tinyint(4) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
`kons` enum('0','1') DEFAULT '0',
`tempo` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`nofak_beli`),
KEY `FK_ttbeli_tmdistributor` (`kode_dist`),
KEY `FK_ttbeli_tmunit` (`kode_unit`),
KEY `FK_ttbeli_tmuser` (`user_id`),
CONSTRAINT `FK_ttbeli_tmdistributor` FOREIGN KEY (`kode_dist`) REFERENCES `tmdistributor` (`kode_dist`),
CONSTRAINT `FK_ttbeli_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_ttbeli_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttbeli_hapus
CREATE TABLE IF NOT EXISTS `ttbeli_hapus` (
`nofak_beli` varchar(50) NOT NULL DEFAULT '',
`tgl_beli` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`kode_dist` varchar(50) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`disk_fak` float DEFAULT '0',
`ppn` float DEFAULT '0',
`cash` tinyint(4) DEFAULT '1',
`batal` tinyint(4) DEFAULT '0',
`tutup` tinyint(4) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`nofak_beli`),
KEY `FK_ttbeli_tmdistributor` (`kode_dist`),
KEY `FK_ttbeli_tmunit` (`kode_unit`),
KEY `FK_ttbeli_tmuser` (`user_id`),
CONSTRAINT `FK_ttbeli_hapus_tmdistributor` FOREIGN KEY (`kode_dist`) REFERENCES `tmdistributor` (`kode_dist`),
CONSTRAINT `FK_ttbeli_hapus_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_ttbeli_hapus_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttjual
CREATE TABLE IF NOT EXISTS `ttjual` (
`nofak_jual` varchar(50) NOT NULL DEFAULT '',
`tgl_jual` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`kode_cust` varchar(50) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`disk_fak` float DEFAULT '0',
`ppn` float DEFAULT '0',
`cash` enum('0','1') DEFAULT '1',
`batal` tinyint(4) DEFAULT '0',
`tutup` tinyint(4) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
`tempo` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`nofak_jual`),
KEY `FK_ttjual_tmcustomer` (`kode_cust`),
KEY `FK_ttjual_tmunit` (`kode_unit`),
KEY `FK_ttjual_tmuser` (`user_id`),
CONSTRAINT `FK_ttjual_tmcustomer` FOREIGN KEY (`kode_cust`) REFERENCES `tmcustomer` (`kode_cust`),
CONSTRAINT `FK_ttjual_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_ttjual_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttjual_hapus
CREATE TABLE IF NOT EXISTS `ttjual_hapus` (
`nofak_jual` varchar(50) NOT NULL DEFAULT '',
`tgl_jual` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`kode_cust` varchar(50) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`disk_fak` float DEFAULT '0',
`ppn` float DEFAULT '0',
`cash` tinyint(4) DEFAULT '1',
`batal` tinyint(4) DEFAULT '0',
`tutup` tinyint(4) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`nofak_jual`),
KEY `FK_ttjual_hapus_tmcustomer` (`kode_cust`),
KEY `FK_ttjual_hapus_tmuser` (`user_id`),
KEY `FK_ttjual_hapus_tmunit` (`kode_unit`),
CONSTRAINT `FK_ttjual_hapus_tmcustomer` FOREIGN KEY (`kode_cust`) REFERENCES `tmcustomer` (`kode_cust`),
CONSTRAINT `FK_ttjual_hapus_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_ttjual_hapus_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttrbeli
CREATE TABLE IF NOT EXISTS `ttrbeli` (
`nofak_beli` varchar(50) DEFAULT NULL COMMENT 'id_stock',
`kode_brg` varchar(50) DEFAULT NULL,
`jml_beli` int(10) DEFAULT NULL,
`harga_beli` double DEFAULT NULL,
`disk_beli` float DEFAULT '0',
`id_stock` varchar(50) DEFAULT '0',
`disk_beli2` float DEFAULT '0',
KEY `FK_ttrbeli_ttbeli` (`nofak_beli`),
KEY `FK_ttrbeli_tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrbeli_tmbarang` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrbeli_ttbeli` FOREIGN KEY (`nofak_beli`) REFERENCES `ttbeli` (`nofak_beli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttrbeli_hapus
CREATE TABLE IF NOT EXISTS `ttrbeli_hapus` (
`nofak_beli` varchar(50) DEFAULT NULL COMMENT 'id_stock',
`kode_brg` varchar(50) DEFAULT NULL,
`jml_beli` int(10) DEFAULT NULL,
`harga_beli` double DEFAULT NULL,
`disk_beli` float DEFAULT '0',
`id_stock` varchar(50) DEFAULT '0',
`disk_beli2` float DEFAULT '0',
KEY `FK_ttrbeli_ttbeli` (`nofak_beli`),
KEY `FK_ttrbeli_tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrbeli_hapus_tmbarang` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrbeli_hapus_ttbeli_hapus` FOREIGN KEY (`nofak_beli`) REFERENCES `ttbeli_hapus` (`nofak_beli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttretur
CREATE TABLE IF NOT EXISTS `ttretur` (
`nofak_retur` varchar(50) NOT NULL DEFAULT '',
`tgl_retur` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`kode_dist` varchar(50) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`batal` tinyint(4) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT 'TK001',
PRIMARY KEY (`nofak_retur`),
KEY `FK_ttretur_tmdistributor` (`kode_dist`),
KEY `FK_ttretur_tmunit` (`kode_unit`),
KEY `FK_ttretur_tmuser` (`user_id`),
CONSTRAINT `FK_ttretur_tmdistributor` FOREIGN KEY (`kode_dist`) REFERENCES `tmdistributor` (`kode_dist`),
CONSTRAINT `FK_ttretur_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_ttretur_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttrjual
CREATE TABLE IF NOT EXISTS `ttrjual` (
`nofak_jual` varchar(50) DEFAULT NULL,
`kode_brg` varchar(50) DEFAULT NULL,
`id_stock` varchar(50) DEFAULT '0',
`jml_jual` int(10) DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`disk_jual` float DEFAULT '0',
`kons` enum('0','1') DEFAULT '0',
KEY `FK_ttrjual_ttjual` (`nofak_jual`),
KEY `FK_ttrjual_tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrjual_tmbarang` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrjual_ttjual` FOREIGN KEY (`nofak_jual`) REFERENCES `ttjual` (`nofak_jual`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttrjual_hapus
CREATE TABLE IF NOT EXISTS `ttrjual_hapus` (
`nofak_jual` varchar(50) DEFAULT NULL,
`kode_brg` varchar(50) DEFAULT NULL,
`id_stock` varchar(11) DEFAULT '0',
`jml_jual` int(10) DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`disk_jual` float DEFAULT '0',
KEY `FK_ttrjual_hapus_tmbarang` (`kode_brg`),
KEY `FK_ttrjual_hapus_ttjual_hapus` (`nofak_jual`),
CONSTRAINT `FK_ttrjual_hapus_tmbarang` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `FK_ttrjual_hapus_ttjual_hapus` FOREIGN KEY (`nofak_jual`) REFERENCES `ttjual_hapus` (`nofak_jual`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.ttrjual_kons
CREATE TABLE IF NOT EXISTS `ttrjual_kons` (
`nofak_jual` varchar(50) DEFAULT NULL,
`kode_brg` varchar(50) DEFAULT NULL,
`jml_jual` int(10) DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`disk_jual` float DEFAULT '0',
`no_titip` varchar(50) DEFAULT '0',
KEY `FK_ttrjual_ttjual` (`nofak_jual`),
KEY `FK_ttrjual_tmbarang` (`kode_brg`),
CONSTRAINT `ttrjual_kons_ibfk_1` FOREIGN KEY (`kode_brg`) REFERENCES `tmbarang` (`kode_brg`),
CONSTRAINT `ttrjual_kons_ibfk_2` FOREIGN KEY (`nofak_jual`) REFERENCES `ttjual` (`nofak_jual`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_bayar_piutang_unit
CREATE TABLE IF NOT EXISTS `tt_bayar_piutang_unit` (
`no_kas` varchar(50) NOT NULL DEFAULT '',
`tgl` datetime DEFAULT NULL,
`kode_cust` varchar(50) DEFAULT NULL,
`jml` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` int(10) DEFAULT NULL,
PRIMARY KEY (`no_kas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_bayar_piutang_unit_hapus
CREATE TABLE IF NOT EXISTS `tt_bayar_piutang_unit_hapus` (
`no_kas` varchar(50) NOT NULL DEFAULT '',
`tgl` datetime DEFAULT NULL,
`kode_cust` varchar(50) DEFAULT NULL,
`jml` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_bayar_titipan
CREATE TABLE IF NOT EXISTS `tt_bayar_titipan` (
`no_kas` varchar(50) NOT NULL DEFAULT '',
`no_titip` varchar(50) DEFAULT NULL,
`tgl` datetime DEFAULT NULL,
`sisa` int(10) DEFAULT NULL,
`jml_bayar` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` int(10) DEFAULT NULL,
PRIMARY KEY (`no_kas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_modal
CREATE TABLE IF NOT EXISTS `tt_modal` (
`no_kas` varchar(50) NOT NULL DEFAULT '',
`tgl` datetime DEFAULT NULL,
`perkiraan` varchar(50) DEFAULT NULL,
`ket` varchar(50) DEFAULT NULL,
`jml` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` int(10) DEFAULT NULL,
PRIMARY KEY (`no_kas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_operasional
CREATE TABLE IF NOT EXISTS `tt_operasional` (
`no_kas` varchar(50) NOT NULL DEFAULT '',
`tgl` datetime DEFAULT NULL,
`perkiraan` varchar(50) DEFAULT NULL,
`ket` varchar(50) DEFAULT NULL,
`jml` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` int(10) DEFAULT NULL,
PRIMARY KEY (`no_kas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_pemotongan_unit
CREATE TABLE IF NOT EXISTS `tt_pemotongan_unit` (
`no_doc` int(50) NOT NULL AUTO_INCREMENT,
`tgl` datetime DEFAULT NULL,
`kode_cust` varchar(50) DEFAULT NULL,
`jml_bayar` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` varchar(50) DEFAULT NULL,
PRIMARY KEY (`no_doc`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_piutang_bayar
CREATE TABLE IF NOT EXISTS `tt_piutang_bayar` (
`nofak_bayar` varchar(50) NOT NULL DEFAULT '',
`tgl` datetime DEFAULT NULL,
`kode_cust` varchar(50) DEFAULT NULL,
`jml_bayar` double DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` int(10) DEFAULT NULL,
PRIMARY KEY (`nofak_bayar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='khusus untuk primkoppol';
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.tt_titipan
CREATE TABLE IF NOT EXISTS `tt_titipan` (
`no_titip` varchar(50) NOT NULL DEFAULT '',
`tgl` timestamp NULL DEFAULT NULL,
`kode_dist` varchar(50) DEFAULT NULL,
`ket` varchar(50) DEFAULT NULL,
`kode_brg` varchar(50) DEFAULT NULL,
`harga_modal` double DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`jml` int(10) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`kode_unit` varchar(50) DEFAULT NULL,
`ambil` enum('0','1') DEFAULT '0',
PRIMARY KEY (`no_titip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_akun
CREATE TABLE IF NOT EXISTS `t_akun` (
`kode_akun` int(20) NOT NULL AUTO_INCREMENT,
`nama_akun` varchar(50) DEFAULT NULL,
`id_kel` int(11) DEFAULT NULL,
PRIMARY KEY (`kode_akun`),
KEY `FK_t_akun_t_sia_kel` (`id_kel`),
CONSTRAINT `FK_t_akun_t_sia_kel` FOREIGN KEY (`id_kel`) REFERENCES `t_sia_kel` (`id_kel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_nota_bon
CREATE TABLE IF NOT EXISTS `t_nota_bon` (
`no_nota` varchar(25) NOT NULL DEFAULT '',
`tgl_nota` timestamp NULL DEFAULT NULL,
`kode_cust` varchar(20) DEFAULT NULL,
`kode_dist` varchar(20) DEFAULT NULL,
`harga_modal` double DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`user_id` varchar(20) DEFAULT NULL,
`kode_unit` varchar(5) DEFAULT NULL,
`ket` text,
`tempo_hutang` timestamp NULL DEFAULT NULL,
`tempo_piutang` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`no_nota`),
KEY `FK_t_nota_bon_tmcustomer` (`kode_cust`),
KEY `FK_t_nota_bon_tmdistributor` (`kode_dist`),
KEY `FK_t_nota_bon_tmuser` (`user_id`),
KEY `FK_t_nota_bon_tmunit` (`kode_unit`),
CONSTRAINT `FK_t_nota_bon_tmcustomer` FOREIGN KEY (`kode_cust`) REFERENCES `tmcustomer` (`kode_cust`),
CONSTRAINT `FK_t_nota_bon_tmdistributor` FOREIGN KEY (`kode_dist`) REFERENCES `tmdistributor` (`kode_dist`),
CONSTRAINT `FK_t_nota_bon_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_t_nota_bon_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_pulsa_deposit
CREATE TABLE IF NOT EXISTS `t_pulsa_deposit` (
`no_depo` varchar(25) NOT NULL DEFAULT '',
`tgl_depo` timestamp NULL DEFAULT NULL,
`jml_depo` double DEFAULT NULL,
`user_id` varchar(20) DEFAULT NULL,
`kode_unit` varchar(5) DEFAULT NULL,
`cash` enum('0','1') DEFAULT '1',
`kode_dist` varchar(50) DEFAULT 'RMW',
`tempo` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`no_depo`),
KEY `FK_t_pulsa_deposit_tmuser` (`user_id`),
KEY `FK_t_pulsa_deposit_tmunit` (`kode_unit`),
CONSTRAINT `FK_t_pulsa_deposit_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_t_pulsa_deposit_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_pulsa_deposit_awal
CREATE TABLE IF NOT EXISTS `t_pulsa_deposit_awal` (
`no_depo` varchar(25) NOT NULL DEFAULT '',
`tgl_depo` timestamp NULL DEFAULT NULL,
`jml_depo` double DEFAULT NULL,
`user_id` varchar(20) DEFAULT NULL,
`kode_unit` varchar(5) DEFAULT NULL,
`cash` int(11) DEFAULT '1',
PRIMARY KEY (`no_depo`),
KEY `FK_t_pulsa_deposit_tmuser` (`user_id`),
KEY `FK_t_pulsa_deposit_tmunit` (`kode_unit`),
CONSTRAINT `t_pulsa_deposit_awal_ibfk_1` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `t_pulsa_deposit_awal_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_pulsa_deposit_hapus
CREATE TABLE IF NOT EXISTS `t_pulsa_deposit_hapus` (
`no_depo` varchar(25) NOT NULL DEFAULT '',
`tgl_depo` timestamp NULL DEFAULT NULL,
`jml_depo` double DEFAULT NULL,
`user_id` varchar(20) DEFAULT NULL,
`kode_unit` varchar(5) DEFAULT NULL,
`cash` enum('0','1') DEFAULT '1',
`kode_dist` varchar(50) DEFAULT 'RMW',
`tempo` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_pulsa_harga
CREATE TABLE IF NOT EXISTS `t_pulsa_harga` (
`kode_pulsa` varchar(10) NOT NULL DEFAULT '',
`ket_pulsa` varchar(50) DEFAULT NULL,
`harga_modal` double DEFAULT NULL,
`harga_jual_cash` double DEFAULT NULL,
`harga_jual_credit` double DEFAULT NULL,
PRIMARY KEY (`kode_pulsa`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_pulsa_jual
CREATE TABLE IF NOT EXISTS `t_pulsa_jual` (
`no_jual` varchar(50) NOT NULL DEFAULT '',
`tgl_jual` timestamp NULL DEFAULT NULL,
`kode_pulsa` varchar(50) DEFAULT NULL,
`harga_modal` double DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`cash` enum('0','1') DEFAULT '0',
`batal` enum('0','1') DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_cust` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT '1',
`tempo` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`no_jual`),
KEY `FK_t_pulsa_jual_tmuser` (`user_id`),
KEY `FK_t_pulsa_jual_tmunit` (`kode_unit`),
CONSTRAINT `FK_t_pulsa_jual_tmunit` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `FK_t_pulsa_jual_tmuser` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_pulsa_jual_hapus
CREATE TABLE IF NOT EXISTS `t_pulsa_jual_hapus` (
`no_jual` varchar(50) NOT NULL DEFAULT '',
`tgl_jual` timestamp NULL DEFAULT NULL,
`kode_pulsa` varchar(50) DEFAULT NULL,
`harga_modal` double DEFAULT NULL,
`harga_jual` double DEFAULT NULL,
`cash` enum('0','1') DEFAULT '0',
`batal` enum('0','1') DEFAULT '0',
`user_id` varchar(50) DEFAULT '0',
`kode_cust` varchar(50) DEFAULT '0',
`kode_unit` varchar(5) DEFAULT '1',
PRIMARY KEY (`no_jual`),
KEY `FK_t_pulsa_jual_tmuser` (`user_id`),
KEY `FK_t_pulsa_jual_tmunit` (`kode_unit`),
CONSTRAINT `t_pulsa_jual_hapus_ibfk_1` FOREIGN KEY (`kode_unit`) REFERENCES `tmunit` (`kode_unit`),
CONSTRAINT `t_pulsa_jual_hapus_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `tmuser` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
# Data exporting was unselected.
# Dumping structure for table db_esa_vita.t_setting
CREATE TABLE IF NOT EXISTS `t_setting` (
`nama1` varchar(50) DEFAULT NULL,
`nama2` varchar(50) DEFAULT NULL,
`telp` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for view db_esa_vita.v_faktur_beli
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_faktur_beli` (
`nofak_beli` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
`tgl_beli` TIMESTAMP NULL DEFAULT NULL,
`kode_dist` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_dist` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_brg` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_brg` VARCHAR(50) NULL DEFAULT 'X' COLLATE 'latin1_swedish_ci',
`satuan` VARCHAR(50) NULL DEFAULT 'X' COLLATE 'latin1_swedish_ci',
`jml_beli` INT(10) NULL DEFAULT NULL,
`harga_beli` DOUBLE NULL DEFAULT NULL,
`disk_beli` FLOAT NULL DEFAULT '0',
`nom_disk_beli` DOUBLE NULL DEFAULT NULL,
`harga_disk_beli` DOUBLE NULL DEFAULT NULL,
`disk_fak` FLOAT NULL DEFAULT '0',
`nom_disk_fak` DOUBLE NULL DEFAULT NULL,
`harga_disk_fak` DOUBLE NULL DEFAULT NULL,
`ppn` FLOAT NULL DEFAULT '0',
`nom_ppn` DOUBLE NULL DEFAULT NULL,
`harga_ppn` DOUBLE NULL DEFAULT NULL,
`total_beli` DOUBLE NULL DEFAULT NULL,
`cash` TINYINT(4) NULL DEFAULT '1',
`batal` TINYINT(4) NULL DEFAULT '0',
`tutup` TINYINT(4) NULL DEFAULT '0',
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`id_stock` VARCHAR(50) NULL DEFAULT '0' COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(5) NULL DEFAULT 'TK001' COLLATE 'latin1_swedish_ci',
`kons` ENUM('0','1') NULL DEFAULT '0' COLLATE 'latin1_swedish_ci',
`tempo` TIMESTAMP NULL DEFAULT NULL,
`tabel` VARCHAR(6) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.v_faktur_jual
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_faktur_jual` (
`nofak_jual` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
`tgl_jual` TIMESTAMP NULL DEFAULT NULL,
`kode_cust` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_cust` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_brg` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_brg` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`satuan` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`jml_jual` INT(11) NULL DEFAULT NULL,
`harga_jual` DOUBLE NULL DEFAULT NULL,
`disk_jual` FLOAT NULL DEFAULT NULL,
`nom_disk_jual` DOUBLE NULL DEFAULT NULL,
`harga_disk_jual` DOUBLE NULL DEFAULT NULL,
`disk_fak` FLOAT NULL DEFAULT NULL,
`nom_disk_fak` DOUBLE NULL DEFAULT NULL,
`harga_disk_fak` DOUBLE NULL DEFAULT NULL,
`ppn` FLOAT NULL DEFAULT NULL,
`nom_ppn` DOUBLE NULL DEFAULT NULL,
`harga_ppn` DOUBLE NULL DEFAULT NULL,
`total_jual` DOUBLE NULL DEFAULT NULL,
`cash` VARCHAR(1) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`batal` TINYINT(4) NULL DEFAULT NULL,
`tutup` TINYINT(4) NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`id_stock` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(5) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kons` VARCHAR(1) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`tempo` TIMESTAMP NULL DEFAULT NULL,
`tabel` VARCHAR(7) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.v_hpp
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_hpp` (
`nofak_jual` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
`tgl_jual` TIMESTAMP NULL DEFAULT NULL,
`kode_brg` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_brg` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`jml_jual` INT(11) NULL DEFAULT NULL,
`harga_jual` DOUBLE NULL DEFAULT NULL,
`total_jual` DOUBLE NULL DEFAULT NULL,
`harga_modal` DOUBLE NULL DEFAULT NULL,
`hpp_terjual` DOUBLE NULL DEFAULT NULL,
`tot_untung` DOUBLE NULL DEFAULT NULL,
`kode_unit` VARCHAR(5) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.v_hutang
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_hutang` (
`id_hutang` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`ket` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tgl_hutang` TIMESTAMP NULL DEFAULT NULL,
`kode_dist` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`nama_dist` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`jml_hutang` DOUBLE NULL DEFAULT NULL,
`jml_bayar` DOUBLE NULL DEFAULT NULL,
`sisa_hutang` DOUBLE NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(5) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tabel` VARCHAR(16) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`tempo` VARCHAR(19) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.v_kas
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_kas` (
`no_trans` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
`tgl` DATETIME NULL DEFAULT NULL,
`ket` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`ket2` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kas_masuk` DOUBLE NULL DEFAULT NULL,
`kas_keluar` DOUBLE NULL DEFAULT NULL,
`kas_akhir` DOUBLE NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tabel` VARCHAR(18) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.v_piutang_unit
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_piutang_unit` (
`kode_cust` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tgl` DATETIME NULL DEFAULT NULL,
`jml` DOUBLE NULL DEFAULT NULL,
`bayar` DOUBLE NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`ket` VARCHAR(16) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.v_stock
# Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `v_stock` (
`id_stock` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tgl` DATETIME NULL DEFAULT NULL,
`kode_brg` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`harga_modal` DOUBLE NULL DEFAULT NULL,
`harga_jual` DOUBLE NULL DEFAULT NULL,
`stock_awal` BIGINT(20) NULL DEFAULT NULL,
`stock_masuk` BIGINT(20) NULL DEFAULT NULL,
`stock_keluar` BIGINT(20) NULL DEFAULT NULL,
`stock_akhir` BIGINT(20) NULL DEFAULT NULL,
`saldo_akhir` DOUBLE NULL DEFAULT NULL,
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`kode_unit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`tabel` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`kons` VARCHAR(1) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;
# Dumping structure for view db_esa_vita.hist_hutang
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `hist_hutang`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `hist_hutang` AS select `p`.`kode_dist` AS `kode_dist`,`c`.`nama_dist` AS `nama_dist`,`p`.`tgl_hutang` AS `tgl`,`p`.`ket` AS `ket`,'' AS `barang`,0 AS `awal`,`p`.`jml_hutang` AS `masuk`,0 AS `keluar`,`p`.`user_id` AS `user_id`,`p`.`kode_unit` AS `kode_unit` from (`tmhutang` `p` join `tmdistributor` `c`) where (`p`.`kode_dist` = `c`.`kode_dist`) union all select `tj`.`kode_dist` AS `kode_dist`,`c`.`nama_dist` AS `nama_dist`,`tj`.`tgl_beli` AS `tgl`,'PEMBELIAN BARANG' AS `ket`,`b`.`nama_brg` AS `barang`,0 AS `awal`,((((`trj`.`harga_beli` - ((`trj`.`disk_beli` * `trj`.`harga_beli`) / 100)) - (((`trj`.`harga_beli` - ((`trj`.`disk_beli` * `trj`.`harga_beli`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_beli` - ((`trj`.`disk_beli` * `trj`.`harga_beli`) / 100)) - (((`trj`.`harga_beli` - ((`trj`.`disk_beli` * `trj`.`harga_beli`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) * `trj`.`jml_beli`) AS `masuk`,0 AS `keluar`,`tj`.`user_id` AS `user_id`,`tj`.`kode_unit` AS `kode_unit` from (((`ttbeli` `tj` join `ttrbeli` `trj`) join `tmdistributor` `c`) join `tmbarang` `b`) where ((`tj`.`nofak_beli` = `trj`.`nofak_beli`) and (`tj`.`kode_dist` = `c`.`kode_dist`) and (`trj`.`kode_brg` = `b`.`kode_brg`) and (`tj`.`cash` = '0')) union all select `nb`.`kode_dist` AS `kode_dist`,`c`.`nama_dist` AS `nama_dist`,`nb`.`tgl_nota` AS `tgl_nota`,`d`.`nama_dist` AS `ket`,`nb`.`ket` AS `ket`,0 AS `awal`,`nb`.`harga_modal` AS `harga_modal`,0 AS `keluar`,`nb`.`user_id` AS `user_id`,`nb`.`kode_unit` AS `kode_unit` from ((`t_nota_bon` `nb` join `tmdistributor` `c`) join `tmdistributor` `d`) where ((`nb`.`kode_dist` = `c`.`kode_dist`) and (`nb`.`kode_dist` = `d`.`kode_dist`)) union all select `bp`.`kode_dist` AS `kode_dist`,`c`.`nama_dist` AS `nama_dist`,`bp`.`tgl_bayar` AS `tgl_bayar`,'BAYAR LANGSUNG' AS `ket`,'' AS `barang`,0 AS `awal`,0 AS `masuk`,`bp`.`jml_bayar` AS `keluar`,`bp`.`user_id` AS `user_id`,`bp`.`kode_unit` AS `kode_unit` from (`ttbayar_hutang` `bp` join `tmdistributor` `c`) where (`bp`.`kode_dist` = `c`.`kode_dist`);
# Dumping structure for view db_esa_vita.hist_piutang
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `hist_piutang`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `hist_piutang` AS select `p`.`kode_cust` AS `kode_cust`,`c`.`nama_cust` AS `nama_cust`,`p`.`tgl_piutang` AS `tgl`,`p`.`ket` AS `ket`,'' AS `barang`,0 AS `awal`,`p`.`jml_piutang` AS `masuk`,0 AS `keluar`,`p`.`user_id` AS `user_id`,`p`.`kode_unit` AS `kode_unit` from (`tmpiutang` `p` join `tmcustomer` `c`) where (`p`.`kode_cust` = `c`.`kode_cust`) union all select `tj`.`kode_cust` AS `kode_cust`,`c`.`nama_cust` AS `nama_cust`,`tj`.`tgl_jual` AS `tgl`,'PENJUALAN BARANG' AS `ket`,`b`.`nama_brg` AS `barang`,0 AS `awal`,((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) * `trj`.`jml_jual`) AS `masuk`,0 AS `keluar`,`tj`.`user_id` AS `user_id`,`tj`.`kode_unit` AS `kode_unit` from (((`ttjual` `tj` join `ttrjual` `trj`) join `tmcustomer` `c`) join `tmbarang` `b`) where ((`tj`.`nofak_jual` = `trj`.`nofak_jual`) and (`tj`.`kode_cust` = `c`.`kode_cust`) and (`trj`.`kode_brg` = `b`.`kode_brg`) and (`tj`.`cash` = '0')) union all select `pj`.`kode_cust` AS `kode_cust`,`c`.`nama_cust` AS `nama_cust`,`pj`.`tgl_jual` AS `tgl_jual`,'PENJUALAN PULSA' AS `ket`,`ph`.`ket_pulsa` AS `ket_pulsa`,0 AS `awal`,`pj`.`harga_jual` AS `harga_jual`,0 AS `keluar`,`pj`.`user_id` AS `user_id`,`pj`.`kode_unit` AS `kode_unit` from ((`t_pulsa_jual` `pj` join `t_pulsa_harga` `ph`) join `tmcustomer` `c`) where ((`pj`.`kode_pulsa` = `ph`.`kode_pulsa`) and (`pj`.`kode_cust` = `c`.`kode_cust`) and (`pj`.`cash` = '0')) union all select `nb`.`kode_cust` AS `kode_cust`,`c`.`nama_cust` AS `nama_cust`,`nb`.`tgl_nota` AS `tgl_nota`,'NOTA BON' AS `ket`,`nb`.`ket` AS `ket`,0 AS `awal`,`nb`.`harga_jual` AS `harga_jual`,0 AS `keluar`,`nb`.`user_id` AS `user_id`,`nb`.`kode_unit` AS `kode_unit` from (`t_nota_bon` `nb` join `tmcustomer` `c`) where (`nb`.`kode_cust` = `c`.`kode_cust`) union all select `bp`.`kode_cust` AS `kode_cust`,`c`.`nama_cust` AS `nama_cust`,`bp`.`tgl` AS `tgl`,'BAYAR LANGSUNG' AS `ket`,'' AS `barang`,0 AS `awal`,0 AS `masuk`,`bp`.`jml` AS `keluar`,`bp`.`user_id` AS `user_id`,`bp`.`kode_unit` AS `kode_unit` from (`tt_bayar_piutang_unit` `bp` join `tmcustomer` `c`) where (`bp`.`kode_cust` = `c`.`kode_cust`) union all select `tp`.`kode_cust` AS `kode_cust`,`c`.`nama_cust` AS `nama_cust`,`tp`.`tgl` AS `tgl`,'PEMOTONGAN PIUTANG' AS `ket`,'' AS `barang`,0 AS `awal`,0 AS `masuk`,`tp`.`jml_bayar` AS `keluar`,`tp`.`user_id` AS `user_id`,`tp`.`kode_unit` AS `kode_unit` from (`tt_pemotongan_unit` `tp` join `tmcustomer` `c`) where (`tp`.`kode_cust` = `c`.`kode_cust`);
# Dumping structure for view db_esa_vita.v_faktur_beli
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_faktur_beli`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_faktur_beli` AS select `ttbeli`.`nofak_beli` AS `nofak_beli`,`ttbeli`.`tgl_beli` AS `tgl_beli`,`ttbeli`.`kode_dist` AS `kode_dist`,`tmdistributor`.`nama_dist` AS `nama_dist`,`ttrbeli`.`kode_brg` AS `kode_brg`,`tmbarang`.`nama_brg` AS `nama_brg`,`tmbarang`.`satuan` AS `satuan`,`ttrbeli`.`jml_beli` AS `jml_beli`,`ttrbeli`.`harga_beli` AS `harga_beli`,`ttrbeli`.`disk_beli` AS `disk_beli`,((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100) AS `nom_disk_beli`,(`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) AS `harga_disk_beli`,`ttbeli`.`disk_fak` AS `disk_fak`,(((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100) AS `nom_disk_fak`,((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) AS `harga_disk_fak`,`ttbeli`.`ppn` AS `ppn`,((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) * `ttbeli`.`ppn`) / 100) AS `nom_ppn`,(((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) + ((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) * `ttbeli`.`ppn`) / 100)) AS `harga_ppn`,((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) + ((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) * `ttbeli`.`ppn`) / 100)) * `ttrbeli`.`jml_beli`) AS `total_beli`,`ttbeli`.`cash` AS `cash`,`ttbeli`.`batal` AS `batal`,`ttbeli`.`tutup` AS `tutup`,`ttbeli`.`user_id` AS `user_id`,`ttrbeli`.`id_stock` AS `id_stock`,`ttbeli`.`kode_unit` AS `kode_unit`,`ttbeli`.`kons` AS `kons`,`ttbeli`.`tempo` AS `tempo`,'ttbeli' AS `tabel` from (((`ttbeli` join `tmdistributor`) join `ttrbeli`) join `tmbarang`) where ((`ttbeli`.`nofak_beli` = `ttrbeli`.`nofak_beli`) and (`ttbeli`.`kode_dist` = `tmdistributor`.`kode_dist`) and (`ttrbeli`.`kode_brg` = `tmbarang`.`kode_brg`));
# Dumping structure for view db_esa_vita.v_faktur_jual
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_faktur_jual`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_faktur_jual` AS select `tj`.`nofak_jual` AS `nofak_jual`,`tj`.`tgl_jual` AS `tgl_jual`,`tj`.`kode_cust` AS `kode_cust`,`tmcustomer`.`nama_cust` AS `nama_cust`,`trj`.`kode_brg` AS `kode_brg`,`tmbarang`.`nama_brg` AS `nama_brg`,`tmbarang`.`satuan` AS `satuan`,`trj`.`jml_jual` AS `jml_jual`,`trj`.`harga_jual` AS `harga_jual`,`trj`.`disk_jual` AS `disk_jual`,((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100) AS `nom_disk_jual`,(`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) AS `harga_disk_jual`,`tj`.`disk_fak` AS `disk_fak`,(((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100) AS `nom_disk_fak`,((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) AS `harga_disk_fak`,`tj`.`ppn` AS `ppn`,((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100) AS `nom_ppn`,(((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) AS `harga_ppn`,((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) * `trj`.`jml_jual`) AS `total_jual`,`tj`.`cash` AS `cash`,`tj`.`batal` AS `batal`,`tj`.`tutup` AS `tutup`,`tj`.`user_id` AS `user_id`,`trj`.`id_stock` AS `id_stock`,`tj`.`kode_unit` AS `kode_unit`,'0' AS `kons`,`tj`.`tempo` AS `tempo`,'tt_jual' AS `tabel` from (((`ttjual` `tj` join `tmcustomer`) join `ttrjual` `trj`) join `tmbarang`) where ((`tj`.`nofak_jual` = `trj`.`nofak_jual`) and (`tj`.`kode_cust` = `tmcustomer`.`kode_cust`) and (`trj`.`kode_brg` = `tmbarang`.`kode_brg`)) union all select `tj`.`nofak_jual` AS `nofak_jual`,`tj`.`tgl_jual` AS `tgl_jual`,`tj`.`kode_cust` AS `kode_cust`,`tmcustomer`.`nama_cust` AS `nama_cust`,`trj`.`kode_brg` AS `kode_brg`,`tmbarang`.`nama_brg` AS `nama_brg`,`tmbarang`.`satuan` AS `satuan`,`trj`.`jml_jual` AS `jml_jual`,`trj`.`harga_jual` AS `harga_jual`,`trj`.`disk_jual` AS `disk_jual`,((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100) AS `nom_disk_jual`,(`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) AS `harga_disk_jual`,`tj`.`disk_fak` AS `disk_fak`,(((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100) AS `nom_disk_fak`,((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) AS `harga_disk_fak`,`tj`.`ppn` AS `ppn`,((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100) AS `nom_ppn`,(((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) AS `harga_ppn`,((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) * `trj`.`jml_jual`) AS `total_jual`,`tj`.`cash` AS `cash`,`tj`.`batal` AS `batal`,`tj`.`tutup` AS `tutup`,`tj`.`user_id` AS `user_id`,`trj`.`no_titip` AS `id_stock`,`tj`.`kode_unit` AS `kode_unit`,'1' AS `kons`,`tj`.`tempo` AS `tempo`,'tt_jual' AS `tabel` from (((`ttjual` `tj` join `tmcustomer`) join `ttrjual_kons` `trj`) join `tmbarang`) where ((`tj`.`nofak_jual` = `trj`.`nofak_jual`) and (`tj`.`kode_cust` = `tmcustomer`.`kode_cust`) and (`trj`.`kode_brg` = `tmbarang`.`kode_brg`));
# Dumping structure for view db_esa_vita.v_hpp
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_hpp`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `v_hpp` AS select `vj`.`nofak_jual` AS `nofak_jual`,`vj`.`tgl_jual` AS `tgl_jual`,`vj`.`kode_brg` AS `kode_brg`,`vj`.`nama_brg` AS `nama_brg`,`vj`.`jml_jual` AS `jml_jual`,`vj`.`harga_ppn` AS `harga_jual`,`vj`.`total_jual` AS `total_jual`,`vb`.`harga_ppn` AS `harga_modal`,(`vb`.`harga_ppn` * `vj`.`jml_jual`) AS `hpp_terjual`,(`vj`.`total_jual` - (`vb`.`harga_ppn` * `vj`.`jml_jual`)) AS `tot_untung`,`vj`.`kode_unit` AS `kode_unit` from (`v_faktur_jual` `vj` join `v_faktur_beli` `vb`) where ((`vj`.`id_stock` = `vb`.`id_stock`) and (`vj`.`id_stock` <> 'PULSA')) union all select `vj`.`nofak_jual` AS `nofak_jual`,`vj`.`tgl_jual` AS `tgl_jual`,`vj`.`kode_brg` AS `kode_brg`,`vj`.`nama_brg` AS `nama_brg`,`vj`.`jml_jual` AS `jml_jual`,`vj`.`harga_ppn` AS `harga_jual`,`vj`.`total_jual` AS `total_jual`,`m`.`harga_modal` AS `harga_modal`,(`vj`.`jml_jual` * `m`.`harga_modal`) AS `hpp_terjual`,(`vj`.`total_jual` - (`m`.`harga_modal` * `vj`.`jml_jual`)) AS `tot_untung`,`vj`.`kode_unit` AS `kode_unit` from (`v_faktur_jual` `vj` join `tmmodal` `m`) where ((`vj`.`id_stock` = `m`.`id_stock`) and (`vj`.`id_stock` <> 'PULSA')) union all select `vj`.`nofak_jual` AS `nofak_jual`,`vj`.`tgl_jual` AS `tgl_jual`,`vj`.`kode_brg` AS `kode_brg`,`vj`.`nama_brg` AS `nama_brg`,`vj`.`jml_jual` AS `jml_jual`,`vj`.`harga_ppn` AS `harga_jual`,`vj`.`total_jual` AS `total_jual`,`ph`.`harga_modal` AS `harga_modal`,`ph`.`harga_modal` AS `hpp_terjual`,(`vj`.`harga_ppn` - `ph`.`harga_modal`) AS `tot_untung`,`vj`.`kode_unit` AS `kode_unit` from (`v_faktur_jual` `vj` join `t_pulsa_harga` `ph`) where ((`vj`.`kode_brg` = `ph`.`kode_pulsa`) and (`vj`.`id_stock` = 'PULSA'));
# Dumping structure for view db_esa_vita.v_hutang
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_hutang`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_hutang` AS select `h`.`id_hutang` AS `id_hutang`,`h`.`ket` AS `ket`,`h`.`tgl_hutang` AS `tgl_hutang`,`h`.`kode_dist` AS `kode_dist`,`d`.`nama_dist` AS `nama_dist`,`h`.`jml_hutang` AS `jml_hutang`,0 AS `jml_bayar`,`h`.`jml_hutang` AS `sisa_hutang`,`h`.`user_id` AS `user_id`,`h`.`kode_unit` AS `kode_unit`,'tmhutang' AS `tabel`,`h`.`tgl_tempo` AS `tempo` from (`tmhutang` `h` join `tmdistributor` `d`) where (`h`.`kode_dist` = `d`.`kode_dist`) union all select `tb`.`nofak_beli` AS `nofak_beli`,`trb`.`kode_brg` AS `kode_brg`,`tb`.`tgl_beli` AS `tgl_beli`,`tb`.`kode_dist` AS `kode_dist`,`d`.`nama_dist` AS `nama_dist`,((((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) - (((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) * `tb`.`disk_fak`) / 100)) + ((((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) - (((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) * `tb`.`disk_fak`) / 100)) * `tb`.`ppn`) / 100)) * `trb`.`jml_beli`) AS `jml_hutang`,0 AS `jml_bayar`,((((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) - (((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) * `tb`.`disk_fak`) / 100)) + ((((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) - (((`trb`.`harga_beli` - ((`trb`.`disk_beli` * `trb`.`harga_beli`) / 100)) * `tb`.`disk_fak`) / 100)) * `tb`.`ppn`) / 100)) * `trb`.`jml_beli`) AS `sisa_hutang`,`tb`.`user_id` AS `user_id`,`tb`.`kode_unit` AS `kode_unit`,'PEMBELIAN BARANG' AS `tabel`,`tb`.`tempo` AS `tempo` from ((`ttbeli` `tb` join `ttrbeli` `trb`) join `tmdistributor` `d`) where ((`tb`.`nofak_beli` = `trb`.`nofak_beli`) and (`tb`.`kode_dist` = `d`.`kode_dist`) and (`tb`.`cash` = '0')) union all select `nb`.`no_nota` AS `no_nota`,`nb`.`ket` AS `ket`,`nb`.`tgl_nota` AS `tgl_nota`,`nb`.`kode_dist` AS `kode_dist`,`d`.`nama_dist` AS `nama_dist`,`nb`.`harga_modal` AS `harga_modal`,0 AS `jml_bayar`,`nb`.`harga_modal` AS `sisa_hutang`,`nb`.`user_id` AS `user_id`,`nb`.`kode_unit` AS `kode_unit`,'nota bon' AS `tabel`,`nb`.`tempo_hutang` AS `tempo_hutang` from (`t_nota_bon` `nb` join `tmdistributor` `d`) where (`nb`.`kode_dist` = `d`.`kode_dist`) union all select `bh`.`id_hutang` AS `id_hutang`,`bh`.`nofak_bayar` AS `ket`,`bh`.`tgl_bayar` AS `tgl_hutang`,`bh`.`kode_dist` AS `kode_dist`,`d`.`nama_dist` AS `nama_dist`,0 AS `jml_hutang`,`bh`.`jml_bayar` AS `jml_bayar`,-(`bh`.`jml_bayar`) AS `sisa_hutang`,`bh`.`user_id` AS `user_id`,`bh`.`kode_unit` AS `kode_unit`,'ttbayar_hutang' AS `tabel`,'0000-00-00' AS `tempo` from (`ttbayar_hutang` `bh` join `tmdistributor` `d`) where (`bh`.`kode_dist` = `d`.`kode_dist`);
# Dumping structure for view db_esa_vita.v_kas
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_kas`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `v_kas` AS select `km`.`no_kas` AS `no_trans`,`km`.`tgl` AS `tgl`,`km`.`perkiraan` AS `ket`,`km`.`ket` AS `ket2`,`km`.`jml` AS `kas_masuk`,0 AS `kas_keluar`,`km`.`jml` AS `kas_akhir`,`km`.`user_id` AS `user_id`,`km`.`kode_unit` AS `kode_unit`,'tt_modal' AS `tabel` from `tt_modal` `km` union all select `tp`.`no_doc` AS `no_doc`,`tp`.`tgl` AS `tgl`,'PEMOTONGAN PIUTANG' AS `ket`,`c`.`nama_cust` AS `ket2`,`tp`.`jml_bayar` AS `jml_bayar`,0 AS `keluar`,`tp`.`jml_bayar` AS `sisa`,`tp`.`user_id` AS `user_id`,`tp`.`kode_unit` AS `kode_unit`,'tt_pemotongan_unit' AS `tabel` from (`tt_pemotongan_unit` `tp` join `tmcustomer` `c`) where (`tp`.`kode_cust` = `c`.`kode_cust`) union all select `ttjual`.`nofak_jual` AS `nofak_jual`,`ttjual`.`tgl_jual` AS `tgl_jual`,`tmbarang`.`nama_brg` AS `ket`,`tmcustomer`.`nama_cust` AS `ket2`,((((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) - (((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) * `ttjual`.`disk_fak`) / 100)) + ((((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) - (((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) * `ttjual`.`disk_fak`) / 100)) * `ttjual`.`ppn`) / 100)) * `ttrjual`.`jml_jual`) AS `kas_masuk`,0 AS `kas_keluar`,((((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) - (((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) * `ttjual`.`disk_fak`) / 100)) + ((((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) - (((`ttrjual`.`harga_jual` - ((`ttrjual`.`disk_jual` * `ttrjual`.`harga_jual`) / 100)) * `ttjual`.`disk_fak`) / 100)) * `ttjual`.`ppn`) / 100)) * `ttrjual`.`jml_jual`) AS `kas_akhir`,`ttjual`.`user_id` AS `user_id`,`ttjual`.`kode_unit` AS `kode_unit`,'tt_jual' AS `tabel` from (((`ttjual` join `tmcustomer`) join `ttrjual`) join `tmbarang`) where ((`ttjual`.`nofak_jual` = `ttrjual`.`nofak_jual`) and (`ttjual`.`kode_cust` = `tmcustomer`.`kode_cust`) and (`ttrjual`.`kode_brg` = `tmbarang`.`kode_brg`) and (`ttjual`.`cash` = '1')) union all select `pj`.`no_jual` AS `no_trans`,`pj`.`tgl_jual` AS `tgl`,`ph`.`ket_pulsa` AS `ket`,`c`.`nama_cust` AS `ket2`,`pj`.`harga_jual` AS `kas_masuk`,0 AS `kas_keluar`,`pj`.`harga_jual` AS `kas_akhir`,`pj`.`user_id` AS `user_id`,`pj`.`kode_unit` AS `kode_unit`,'t_pulsa_jual' AS `tabel` from ((`t_pulsa_jual` `pj` join `t_pulsa_harga` `ph`) join `tmcustomer` `c`) where ((`pj`.`kode_pulsa` = `ph`.`kode_pulsa`) and (`pj`.`kode_cust` = `c`.`kode_cust`) and (`pj`.`cash` = '1')) union all select `bp`.`no_kas` AS `no_kas`,`bp`.`tgl` AS `tgl`,'BAYAR LANGSUNG' AS `ket`,`c`.`nama_cust` AS `ket2`,`bp`.`jml` AS `kas_masuk`,0 AS `kas_keluar`,`bp`.`jml` AS `kas_akhir`,`bp`.`user_id` AS `user_id`,`bp`.`kode_unit` AS `kode_unit`,'ttbayar_piutang' AS `tabel` from (`tt_bayar_piutang_unit` `bp` join `tmcustomer` `c`) where (`bp`.`kode_cust` = `c`.`kode_cust`) union all select `ttbeli`.`nofak_beli` AS `no_trans`,`ttbeli`.`tgl_beli` AS `tgl`,`tmbarang`.`nama_brg` AS `ket`,`tmdistributor`.`nama_dist` AS `ket2`,0 AS `kas_masuk`,((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) + ((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) * `ttbeli`.`ppn`) / 100)) * `ttrbeli`.`jml_beli`) AS `kas_keluar`,-(((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) + ((((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) - (((`ttrbeli`.`harga_beli` - ((`ttrbeli`.`disk_beli` * `ttrbeli`.`harga_beli`) / 100)) * `ttbeli`.`disk_fak`) / 100)) * `ttbeli`.`ppn`) / 100)) * `ttrbeli`.`jml_beli`)) AS `kas_akhir`,`ttbeli`.`user_id` AS `user_id`,`ttbeli`.`kode_unit` AS `kode_unit`,'ttbeli' AS `tabel` from (((`ttbeli` join `tmdistributor`) join `ttrbeli`) join `tmbarang`) where ((`ttbeli`.`nofak_beli` = `ttrbeli`.`nofak_beli`) and (`ttbeli`.`kode_dist` = `tmdistributor`.`kode_dist`) and (`ttrbeli`.`kode_brg` = `tmbarang`.`kode_brg`) and (`ttbeli`.`cash` = '1')) union all select `pd`.`no_depo` AS `no_trans`,`pd`.`tgl_depo` AS `tgl_depo`,'Deposit Pulsa' AS `ket`,`d`.`nama_dist` AS `ket2`,0 AS `kas_masuk`,`pd`.`jml_depo` AS `kas_keluar`,-(`pd`.`jml_depo`) AS `kas_akhir`,`pd`.`user_id` AS `user_id`,`pd`.`kode_unit` AS `kode_unit`,'t_pulsa_deposit' AS `tabel` from (`t_pulsa_deposit` `pd` join `tmdistributor` `d`) where (`pd`.`kode_dist` = `d`.`kode_dist`) union all select `bh`.`nofak_bayar` AS `nofak_bayar`,`bh`.`tgl_bayar` AS `tgl_bayar`,`bh`.`id_hutang` AS `ket`,`d`.`nama_dist` AS `ket2`,0 AS `kas_masuk`,`bh`.`jml_bayar` AS `kas_keluar`,-(`bh`.`jml_bayar`) AS `kas_akhir`,`bh`.`user_id` AS `user_id`,`bh`.`kode_unit` AS `kode_unit`,'ttbayar_hutang' AS `tabel` from (`ttbayar_hutang` `bh` join `tmdistributor` `d`) where (`bh`.`kode_dist` = `d`.`kode_dist`) union all select `tp`.`no_kas` AS `no_kas`,`tp`.`tgl` AS `tgl`,`tp`.`perkiraan` AS `Perkiraan`,`tp`.`ket` AS `ket`,0 AS `masuk`,`tp`.`jml` AS `keluar`,-(`tp`.`jml`) AS `sisa`,`tp`.`user_id` AS `user_id`,`tp`.`kode_unit` AS `kode_unit`,'tt_operasional' AS `tabel` from `tt_operasional` `tp`;
# Dumping structure for view db_esa_vita.v_piutang_unit
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_piutang_unit`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `v_piutang_unit` AS select `p`.`kode_cust` AS `kode_cust`,`p`.`tgl_piutang` AS `tgl`,`p`.`jml_piutang` AS `jml`,0 AS `bayar`,`p`.`user_id` AS `user_id`,`p`.`kode_unit` AS `kode_unit`,'PIUTANG AWAL' AS `ket` from `tmpiutang` `p` union all select `tj`.`kode_cust` AS `kode_cust`,max(`tj`.`tgl_jual`) AS `tgl`,sum(((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) + ((((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) - (((`trj`.`harga_jual` - ((`trj`.`disk_jual` * `trj`.`harga_jual`) / 100)) * `tj`.`disk_fak`) / 100)) * `tj`.`ppn`) / 100)) * `trj`.`jml_jual`)) AS `jml`,0 AS `bayar`,`tj`.`user_id` AS `user_id`,`tj`.`kode_unit` AS `kode_unit`,'PENJUALAN BARANG' AS `ket` from (`ttjual` `tj` join `ttrjual` `trj`) where ((`tj`.`nofak_jual` = `trj`.`nofak_jual`) and (`tj`.`cash` = '0')) group by `tj`.`kode_cust`,month(`tj`.`tgl_jual`),`tj`.`kode_unit`,`tj`.`user_id` union all select `pj`.`kode_cust` AS `kode_cust`,max(`pj`.`tgl_jual`) AS `tgl`,sum(`pj`.`harga_jual`) AS `jml`,0 AS `bayar`,`pj`.`user_id` AS `user_id`,`pj`.`kode_unit` AS `kode_unit`,'PENJUALAN PULSA' AS `ket` from `t_pulsa_jual` `pj` where (`pj`.`cash` = '0') group by `pj`.`kode_cust`,month(`pj`.`tgl_jual`),`pj`.`kode_unit`,`pj`.`user_id` union all select `nb`.`kode_cust` AS `kode_cust`,max(`nb`.`tgl_nota`) AS `tgl`,sum(`nb`.`harga_jual`) AS `jml`,0 AS `bayar`,`nb`.`user_id` AS `user_id`,`nb`.`kode_unit` AS `kode_unit`,'NOTA BON' AS `ket` from `t_nota_bon` `nb` group by `nb`.`kode_cust`,`nb`.`tgl_nota`,`nb`.`user_id`,`nb`.`kode_unit` union all select `pb`.`kode_cust` AS `kode_cust`,`pb`.`tgl` AS `tgl`,0 AS `jml`,`pb`.`jml` AS `bayar`,`pb`.`user_id` AS `user_id`,`pb`.`kode_unit` AS `kode_unit`,'BAYAR LANGSUNG' AS `ket` from `tt_bayar_piutang_unit` `pb` union all select `tp`.`kode_cust` AS `kode_cust`,`tp`.`tgl` AS `tgl`,0 AS `jml`,`tp`.`jml_bayar` AS `bayar`,`tp`.`user_id` AS `user_id`,`tp`.`kode_unit` AS `kode_unit`,'PEMOTONGAN' AS `ket` from `tt_pemotongan_unit` `tp`;
# Dumping structure for view db_esa_vita.v_stock
# Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `v_stock`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `v_stock` AS select `m`.`id_stock` AS `id_stock`,`m`.`tgl` AS `tgl`,`m`.`kode_brg` AS `kode_brg`,`m`.`harga_modal` AS `harga_modal`,0 AS `harga_jual`,`m`.`stock_awal` AS `stock_awal`,0 AS `stock_masuk`,0 AS `stock_keluar`,`m`.`stock_awal` AS `stock_akhir`,(`m`.`harga_modal` * `m`.`stock_awal`) AS `saldo_akhir`,`m`.`user_id` AS `user_id`,`m`.`kode_unit` AS `kode_unit`,'tmmodal' AS `tabel`,'0' AS `kons` from `tmmodal` `m` union all select `vb`.`id_stock` AS `id_stock`,`vb`.`tgl_beli` AS `tgl_beli`,`vb`.`kode_brg` AS `kode_brg`,`vb`.`harga_ppn` AS `harga_modal`,0 AS `harga_jual`,0 AS `stock_awal`,`vb`.`jml_beli` AS `stock_masuk`,0 AS `stock_keluar`,`vb`.`jml_beli` AS `stock_akhir`,(`vb`.`jml_beli` * `vb`.`harga_ppn`) AS `saldo_ahhir`,`vb`.`user_id` AS `user_id`,`vb`.`kode_unit` AS `kode_unit`,'v_faktur_beli' AS `tabel`,'0' AS `kons` from `v_faktur_beli` `vb` union all select `vj`.`id_stock` AS `id_stock`,`vj`.`tgl_jual` AS `tgl_jual`,`vj`.`kode_brg` AS `kode_brg`,`m`.`harga_modal` AS `harga_modal`,`vj`.`harga_ppn` AS `harga_jual`,0 AS `stock_awal`,0 AS `stock_masuk`,`vj`.`jml_jual` AS `stock_keluar`,-(`vj`.`jml_jual`) AS `stock_akhir`,(-(`vj`.`jml_jual`) * `m`.`harga_modal`) AS `saldo_akhir`,`vj`.`user_id` AS `user_id`,`vj`.`kode_unit` AS `kode_unit`,'v_faktur_jual' AS `tabel`,`vj`.`kons` AS `kons` from (`v_faktur_jual` `vj` join `tmmodal` `m`) where (`vj`.`id_stock` = `m`.`id_stock`) union all select `vj`.`id_stock` AS `id_stock`,`vj`.`tgl_jual` AS `tgl_jual`,`vj`.`kode_brg` AS `kode_brg`,`vb`.`harga_ppn` AS `harga_modal`,`vj`.`harga_ppn` AS `harga_jual`,0 AS `stock_awal`,0 AS `stock_masuk`,`vj`.`jml_jual` AS `stock_keluar`,-(`vj`.`jml_jual`) AS `stock_akhir`,(-(`vj`.`jml_jual`) * `vb`.`harga_ppn`) AS `saldo_akhir`,`vj`.`user_id` AS `user_id`,`vj`.`kode_unit` AS `kode_unit`,'v_faktur_jual' AS `tabel`,`vj`.`kons` AS `kons` from (`v_faktur_jual` `vj` join `v_faktur_beli` `vb`) where (`vj`.`id_stock` = `vb`.`id_stock`) union all select `tt`.`no_titip` AS `no_titip`,`tt`.`tgl` AS `tgl`,`tt`.`kode_brg` AS `kode_brg`,`tt`.`harga_modal` AS `harga_modal`,0 AS `harga_jual`,0 AS `awal`,`tt`.`jml` AS `masuk`,0 AS `keluar`,`tt`.`jml` AS `akhir`,(`tt`.`jml` * `tt`.`harga_modal`) AS `saldo_akhir`,`tt`.`user_id` AS `user_id`,`tt`.`kode_unit` AS `kode_unit`,'TITIPAN' AS `tabel`,'1' AS `kons` from `tt_titipan` `tt` union all select `vj`.`id_stock` AS `id_stock`,`vj`.`tgl_jual` AS `tgl_jual`,`vj`.`kode_brg` AS `kode_brg`,`tt`.`harga_modal` AS `harga_modal`,`vj`.`harga_ppn` AS `harga_jual`,0 AS `stock_awal`,0 AS `stock_masuk`,`vj`.`jml_jual` AS `stock_keluar`,-(`vj`.`jml_jual`) AS `stock_akhir`,(-(`vj`.`jml_jual`) * `tt`.`harga_modal`) AS `saldo_akhir`,`vj`.`user_id` AS `user_id`,`vj`.`kode_unit` AS `kode_unit`,'v_faktur_jual' AS `tabel`,`vj`.`kons` AS `kons` from (`v_faktur_jual` `vj` join `tt_titipan` `tt`) where (`vj`.`id_stock` = `tt`.`no_titip`) union all select `bt`.`no_titip` AS `no_titip`,`bt`.`tgl` AS `tgl`,`tt`.`kode_brg` AS `kode_brg`,`tt`.`harga_modal` AS `harga_modal`,0 AS `harga_jual`,0 AS `awal`,0 AS `masuk`,`bt`.`sisa` AS `keluar`,-(`bt`.`sisa`) AS `akhir`,(-(`bt`.`sisa`) * `tt`.`harga_modal`) AS `saldo_akhir`,`bt`.`user_id` AS `user_id`,`bt`.`kode_unit` AS `kode_unit`,'bayar titipan' AS `tabel`,'1' AS `kons` from (`tt_bayar_titipan` `bt` join `tt_titipan` `tt`) where (`bt`.`no_titip` = `tt`.`no_titip`) union all select 'PULSA' AS `id_stock`,`da`.`tgl_depo` AS `tgl`,'PULSA' AS `kode_brg`,0 AS `harga_modal`,0 AS `harga_jual`,0 AS `stock_awal`,0 AS `stock_masuk`,0 AS `stock_keluar`,0 AS `stock_akhir`,`da`.`jml_depo` AS `saldo_akhir`,`da`.`user_id` AS `user_id`,`da`.`kode_unit` AS `kode_unit`,'t_pulsa_deposit_awal' AS `tabel`,'0' AS `kons` from `t_pulsa_deposit_awal` `da` union all select 'PULSA' AS `id_stock`,`dp`.`tgl_depo` AS `tgl`,'PULSA' AS `kode_brg`,0 AS `harga_modal`,0 AS `harga_jual`,0 AS `stock_awal`,0 AS `stock_masuk`,0 AS `stock_keluar`,0 AS `stock_akhir`,`dp`.`jml_depo` AS `saldo_akhir`,`dp`.`user_id` AS `user_id`,`dp`.`kode_unit` AS `kode_unit`,'t_pulsa_deposit' AS `tabel`,'0' AS `kons` from `t_pulsa_deposit` `dp` union all select 'PULSA' AS `id_stock`,`pj`.`tgl_jual` AS `tgl_jual`,'PULSA' AS `kode_barang`,`pj`.`harga_modal` AS `harga_modal`,`pj`.`harga_jual` AS `harga_jual`,0 AS `stock_awal`,0 AS `stock_masuk`,0 AS `stock_keluar`,0 AS `stock_akhir`,-(`pj`.`harga_modal`) AS `saldo_akhir`,`pj`.`user_id` AS `user_id`,`pj`.`kode_unit` AS `kode_unit`,'pulsa jual' AS `tabel`,'0' AS `kons` from `t_pulsa_jual` `pj`;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
No comments:
Post a Comment