-- MySQL dump 10.11
--
-- Host: 178.1.0.202    Database: eprs_master
-- ------------------------------------------------------
-- Server version	4.1.20-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `eprs_master`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `eprs_master` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `eprs_master`;

--
-- Table structure for table `budget_atribut`
--

DROP TABLE IF EXISTS `budget_atribut`;
CREATE TABLE `budget_atribut` (
  `id` varchar(10) NOT NULL default '',
  `bulan` varchar(15) NOT NULL default '',
  `real` varchar(25) NOT NULL default '',
  `term` int(4) NOT NULL default '0',
  `term_value` varchar(4) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `budget_atribut`
--

LOCK TABLES `budget_atribut` WRITE;
/*!40000 ALTER TABLE `budget_atribut` DISABLE KEYS */;
INSERT INTO `budget_atribut` VALUES ('1','JAN','RealizationN1',1,'I'),('2','FEB','RealizationN2',1,'I'),('3','MAR','RealizationN3',1,'I'),('4','APR','RealizationN4',2,'II'),('5','MEI','RealizationN5',2,'II'),('6','JUN','RealizationN6',2,'II'),('7','JUL','RealizationN7',3,'III'),('8','AGS','RealizationN8',3,'III'),('9','SEP','RealizationN9',3,'III'),('10','OKT','RealizationN10',4,'IV'),('11','NOP','RealizationN11',4,'IV'),('12','DES','RealizationN12',4,'IV');
/*!40000 ALTER TABLE `budget_atribut` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fui`
--

DROP TABLE IF EXISTS `fui`;
CREATE TABLE `fui` (
  `id` int(50) NOT NULL auto_increment,
  `tgl_buat` date NOT NULL default '0000-00-00',
  `no_urut` int(20) NOT NULL default '0',
  `no_fui` varchar(75) NOT NULL default '',
  `user` int(20) NOT NULL default '0',
  `kategori` varchar(100) NOT NULL default '',
  `jangka_waktu` int(10) NOT NULL default '0',
  `satuan` varchar(20) NOT NULL default '',
  `nama` varchar(255) NOT NULL default '',
  `deskripsi` text NOT NULL,
  `kode_beban` varchar(20) NOT NULL default '',
  `total` double NOT NULL default '0',
  `atas_perintah` int(10) NOT NULL default '0',
  `status` varchar(5) NOT NULL default '',
  `uom` varchar(50) NOT NULL default '',
  `status_po` enum('1','2') NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fui`
--

LOCK TABLES `fui` WRITE;
/*!40000 ALTER TABLE `fui` DISABLE KEYS */;
INSERT INTO `fui` VALUES (1,'2010-08-19',1,'2010/MB/FUI-DPR/1/PA/08',1359,'Prasarana',4,'Tahun','Renovasi Puri Ayu Karawaci menjadi Martha Tilaar Shop','001/NOO-KWC/VIII/10','11-641-03-215-OKC',216013685,972,'O','','1'),(2,'2010-09-30',2,'2010/MB/FUI-DPR/2/CPP/09',931,'Prasarana',4,'Tahun','4 TAHUN','INTERNAL MEMO NO. 002/DSS/IX/2010','11-641-03-221-DSS',39999998,972,'O','','1'),(3,'2010-10-11',3,'2010/MB/FUI-DPR/3/PA/10',1359,'Prasarana',4,'Tahun','Renovasi New Open Outlet MTS Bali','002/NOO-Bali/X/10','11-641-03-215-NEW',398545920,972,'O','','1'),(4,'2010-10-13',4,'2010/MB/FUI-DPR/4/PA/10',1359,'Prasarana',4,'Tahun','Perlengkapan facial dan reflexiologi utk MTS Bali','002/NOO-Bali /X/10','11-641-03-215-NEW',31537296,972,'O','','1'),(5,'2010-11-09',5,'2010/MB/FUI-DPR/5/PA/11',1359,'Prasarana',2,'Tahun','DP sewa amortisasi NOO MTS Botani Square sebesar 20% dari total sewa dibayar 2x','DP sewa amortisasi NOO MTS Botani Square sebesar 20% dari total sewa dibayar 2x ','11-641-02-215-NEW',216000000,972,'O','','1'),(6,'2010-11-12',6,'2010/MB/FUI-DPR/6/PA/11',1359,'Prasarana',4,'Tahun','Tambahan pekerjaan MTS Bali','Tambahan pekerjaan MTS Bali ','11-641-03-215-NEW',55000008,972,'O','','1'),(7,'2010-11-12',7,'2010/MB/FUI-DPR/7/PA/11',1359,'Prasarana',4,'Tahun','Pekerjaan tambahan acrylic untuk MTS Bali','Pekerjaan tambahan acrylic untuk MTS Bali','11-641-03-215-NEW',2200000,972,'O','','1');
/*!40000 ALTER TABLE `fui` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fui_detail`
--

DROP TABLE IF EXISTS `fui_detail`;
CREATE TABLE `fui_detail` (
  `id` int(50) NOT NULL auto_increment,
  `no_fui` varchar(59) NOT NULL default '',
  `nama` varchar(255) NOT NULL default '',
  `deskripsi` varchar(255) NOT NULL default '',
  `ke` int(10) NOT NULL default '0',
  `ke_value` varchar(20) NOT NULL default '',
  `ke_tahun` int(4) NOT NULL default '0',
  `ke_desc` varchar(30) NOT NULL default '',
  `nilai` double NOT NULL default '0',
  `no_pp` varchar(50) NOT NULL default '',
  `tgl_insert` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fui_detail`
--

LOCK TABLES `fui_detail` WRITE;
/*!40000 ALTER TABLE `fui_detail` DISABLE KEYS */;
INSERT INTO `fui_detail` VALUES (1,'2010/MB/FUI-DPR/1/PA/08','','',1,'2010',2010,'2010',24001520,'','2010-08-19'),(2,'2010/MB/FUI-DPR/1/PA/08','','',2,'2011',2010,'2011',72004562,'','2010-08-19'),(3,'2010/MB/FUI-DPR/1/PA/08','','',3,'2012',2010,'2012',72004562,'','2010-08-19'),(4,'2010/MB/FUI-DPR/1/PA/08','','',4,'2013',2010,'2013',48003041,'','2010-08-19'),(5,'2010/MB/FUI-DPR/2/CPP/09','PEMBUATAN PROPERTY COUNTER DEWI SRI SPA DI SOGO CENTRAL PARK :\r\n- POSTER LIGT BOX DSS\r\n- BACKWALL DSS 3 SET','PEMBUATAN PROPERTY COUNTER DEWI SRI SPA DI SOGO CENTRAL PARK :\r\n- POSTER LIGT BOX DSS\r\n- BACKWALL DSS 3 SET',1,'2010',2010,'2010',3333333,'PP/2010/MB/18846/CPP/10','2010-09-30'),(6,'2010/MB/FUI-DPR/2/CPP/09','','',2,'2011',2010,'2011',13333333,'','2010-09-30'),(7,'2010/MB/FUI-DPR/2/CPP/09','','',3,'2012',2010,'2012',13333333,'','2010-09-30'),(8,'2010/MB/FUI-DPR/2/CPP/09','','',4,'2013',2010,'2013',9999999,'','2010-09-30'),(9,'2010/MB/FUI-DPR/3/PA/10','Renovasi New Open Outlet MTS Legian Bali','Renovasi New Open Outlet MTS Legian Bali',1,'2010',2010,'2010',33212160,'PP/2010//19911//11','2010-10-11'),(10,'2010/MB/FUI-DPR/3/PA/10','','',2,'2011',2010,'2011',132848640,'','2010-10-11'),(11,'2010/MB/FUI-DPR/3/PA/10','','',3,'2012',2010,'2012',132848640,'','2010-10-11'),(12,'2010/MB/FUI-DPR/3/PA/10','','',4,'2013',2010,'2013',99636480,'','2010-10-11'),(13,'2010/MB/FUI-DPR/4/PA/10','Perlengkapan facial untuk MTS Bali','Kursi reflexiologi kursi facial portable steamer trolly untuk opening New Open Outlet MTS Bali',1,'2010',2010,'2010',2628108,'PP/2010/MB/18891/PA/10','2010-10-13'),(14,'2010/MB/FUI-DPR/4/PA/10','','',2,'2011',2010,'2011',10512432,'','2010-10-13'),(15,'2010/MB/FUI-DPR/4/PA/10','','',3,'2012',2010,'2012',10512432,'','2010-10-13'),(16,'2010/MB/FUI-DPR/4/PA/10','','',4,'2013',2010,'2013',7884324,'','2010-10-13'),(17,'2010/MB/FUI-DPR/5/PA/11','DP sewa amortisasi 10% kesatu dan kedua untuk Botani Square','New Open Outlet MTS Botani Square',1,'2010',2010,'2010',36000000,'PP/2010/MB/21390/PA/11','2010-11-09'),(18,'2010/MB/FUI-DPR/5/PA/11','','',2,'2011',2010,'2011',180000000,'','2010-11-09'),(19,'2010/MB/FUI-DPR/6/PA/11','Pekerjaan tambahan renovasi MTS Bali','New Open Outlet MTS Bali',1,'2010',2010,'2010',3055556,'PP/2010/MB/21305/PA/11','2010-11-12'),(20,'2010/MB/FUI-DPR/6/PA/11','','',2,'2011',2010,'2011',18333336,'','2010-11-12'),(21,'2010/MB/FUI-DPR/6/PA/11','','',3,'2012',2010,'2012',18333336,'','2010-11-12'),(22,'2010/MB/FUI-DPR/6/PA/11','','',4,'2013',2010,'2013',15277780,'','2010-11-12'),(23,'2010/MB/FUI-DPR/7/PA/11','Acrylic untuk MTS Bali','New Open Outlet MTS Bali',1,'2010',2010,'2010',122222,'PP/2010/MB/21311/PA/11','2010-11-12'),(24,'2010/MB/FUI-DPR/7/PA/11','','',2,'2011',2010,'2011',733332,'','2010-11-12'),(25,'2010/MB/FUI-DPR/7/PA/11','','',3,'2012',2010,'2012',733332,'','2010-11-12'),(26,'2010/MB/FUI-DPR/7/PA/11','','',4,'2013',2010,'2013',611114,'','2010-11-12');
/*!40000 ALTER TABLE `fui_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jenis_pp`
--

DROP TABLE IF EXISTS `jenis_pp`;
CREATE TABLE `jenis_pp` (
  `id` int(11) NOT NULL default '0',
  `nama` varchar(100) NOT NULL default '',
  `tgl_insert` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jenis_pp`
--

LOCK TABLES `jenis_pp` WRITE;
/*!40000 ALTER TABLE `jenis_pp` DISABLE KEYS */;
INSERT INTO `jenis_pp` VALUES (1,'P2','2010-04-20 12:03:50'),(2,'P3','2010-04-20 12:03:57'),(3,'NON-P2-P3','2010-04-20 12:04:30');
/*!40000 ALTER TABLE `jenis_pp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `referensi_pp`
--

DROP TABLE IF EXISTS `referensi_pp`;
CREATE TABLE `referensi_pp` (
  `id` int(25) NOT NULL auto_increment,
  `nama` varchar(150) NOT NULL default '',
  `tgl_insert` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `referensi_pp`
--

LOCK TABLES `referensi_pp` WRITE;
/*!40000 ALTER TABLE `referensi_pp` DISABLE KEYS */;
INSERT INTO `referensi_pp` VALUES (1,'Proposal','2010-09-15 09:17:51'),(2,'Kwitansi','2010-09-15 09:17:51'),(3,'Invoice','2010-09-16 04:27:35'),(4,'Surat Tugas','2010-10-11 08:52:24'),(5,'Penawaran Harga','2010-10-13 08:35:51'),(6,'Lainnya','2010-10-13 08:36:06');
/*!40000 ALTER TABLE `referensi_pp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipe_budget`
--

DROP TABLE IF EXISTS `tipe_budget`;
CREATE TABLE `tipe_budget` (
  `id` int(12) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tipe_budget`
--

LOCK TABLES `tipe_budget` WRITE;
/*!40000 ALTER TABLE `tipe_budget` DISABLE KEYS */;
INSERT INTO `tipe_budget` VALUES (1,'Expense'),(2,'FUI Biasa'),(3,'FUI Amortisasi'),(4,'Allocation'),(5,'Payroll'),(6,'Depresiasi/Amortisasi');
/*!40000 ALTER TABLE `tipe_budget` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-03-25 11:20:55