
/*Table structure for table `tabtrans` */

DROP TABLE IF EXISTS `tabtrans`;

CREATE TABLE `tabtrans` (
  `TABTRANS_ID` int(11) NOT NULL,
  `TGL_TRANS` date DEFAULT NULL,
  `NO_REKENING` char(20) DEFAULT NULL,
  `KODE_TRANS` char(3) DEFAULT NULL,
  `MY_KODE_TRANS` smallint(6) DEFAULT NULL,
  `POKOK` decimal(18,4) DEFAULT NULL,
  `ADM` decimal(18,2) DEFAULT NULL,
  `KUITANSI` char(20) DEFAULT NULL,
  `USERID` int(11) DEFAULT NULL,
  `KETERANGAN` char(120) DEFAULT NULL,
  `VERIFIKASI` char(1) DEFAULT NULL,
  `MODUL_ID_SOURCE` char(3) DEFAULT NULL,
  `TRANS_ID_SOURCE` int(11) DEFAULT NULL,
  `TOB` char(1) DEFAULT NULL,
  `PRINT_BUKU` char(1) DEFAULT NULL,
  `PRINT_KARTU` char(1) DEFAULT NULL,
  `TABTRANS_TAG` int(11) DEFAULT NULL,
  `SANDI_TRANS` char(3) DEFAULT NULL,
  `OTORISASI` int(11) DEFAULT NULL,
  `FLAG` smallint(6) DEFAULT NULL,
  `KODE_PERK_OB` char(20) DEFAULT NULL,
  `KODE_PERK_RAK` char(20) DEFAULT NULL,
  `NO_REKENING_VS` char(20) DEFAULT NULL,
  `POSTED_TO_GL` tinyint(1) DEFAULT '1',
  `KODE_KOLEKTOR` char(3) DEFAULT NULL,
  `KODE_KANTOR` char(4) DEFAULT NULL,
  `counter_sign` int(11) DEFAULT NULL,
  `ADM_PENUTUPAN` decimal(18,2) DEFAULT NULL,
  `common_id` int(11) DEFAULT NULL,
  `TITIPAN_BUNGA` decimal(18,2) DEFAULT NULL,
  `jam` time DEFAULT NULL,
  `ip_add` char(35) DEFAULT NULL,
  `flag_insentif` char(1) DEFAULT NULL,
  `flag_jt` char(1) DEFAULT NULL,
  PRIMARY KEY (`TABTRANS_ID`),
  KEY `TGL_TRANS` (`TGL_TRANS`),
  KEY `NO_REKENING` (`NO_REKENING`),
  KEY `MY_KODE_TRANS` (`MY_KODE_TRANS`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tabtrans` */

insert  into `tabtrans`(`TABTRANS_ID`,`TGL_TRANS`,`NO_REKENING`,`KODE_TRANS`,`MY_KODE_TRANS`,`POKOK`,`ADM`,`KUITANSI`,`USERID`,`KETERANGAN`,`VERIFIKASI`,`MODUL_ID_SOURCE`,`TRANS_ID_SOURCE`,`TOB`,`PRINT_BUKU`,`PRINT_KARTU`,`TABTRANS_TAG`,`SANDI_TRANS`,`OTORISASI`,`FLAG`,`KODE_PERK_OB`,`KODE_PERK_RAK`,`NO_REKENING_VS`,`POSTED_TO_GL`,`KODE_KOLEKTOR`,`KODE_KANTOR`,`counter_sign`,`ADM_PENUTUPAN`,`common_id`,`TITIPAN_BUNGA`,`jam`,`ip_add`,`flag_insentif`,`flag_jt`) values 
(1008496,'2010-09-30','06-100-000001','900',100,100222.2300,NULL,NULL,8,'Saldo Awal Tabungan Pra Migrasi',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,NULL,'06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1008497,'2010-09-30','06-100-000002','900',100,116000.0000,NULL,NULL,8,'Saldo Awal Tabungan Pra Migrasi',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1008498,'2010-09-30','06-100-000003','900',100,4000.0000,NULL,NULL,8,'Saldo Awal Tabungan Pra Migrasi',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1008499,'2010-09-30','06-100-000004','900',100,60000.0000,NULL,NULL,8,'Saldo Awal Tabungan Pra Migrasi',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);


/*Table structure for table `tabung` */

CREATE TABLE `tabung` (
  `NO_REKENING` char(20) NOT NULL COMMENT 'nomor rekening tabungan',
  `NO_ALTERNATIF` char(20) DEFAULT NULL,
  `NASABAH_ID` char(20) DEFAULT NULL COMMENT 'nomor keanggotaan (DIN - Debitur Identification Number)',
  `KODE_PRODUK` char(3) DEFAULT NULL COMMENT 'kode produk tabungan',
  `KODE_BI_PEMILIK` char(3) DEFAULT NULL COMMENT 'kode pemilik (untuk pengelompokan laporan ke Bank Indonesia)',
  `SUKU_BUNGA` decimal(5,2) DEFAULT NULL,
  `PERSEN_PPH` decimal(5,2) DEFAULT NULL,
  `TGL_REGISTER` date DEFAULT NULL,
  `SALDO_AKHIR` decimal(18,2) DEFAULT NULL,
  `SALDO_EFEKTIF_BLN_INI` decimal(18,2) DEFAULT NULL,
  `SUKU_BUNGA_EFEKTIF_BLN_INI` decimal(5,2) DEFAULT NULL,
  `BUNGA_BLN_INI` decimal(18,2) DEFAULT NULL,
  `PAJAK_BLN_INI` decimal(20,2) DEFAULT NULL,
  `ADM_BLN_INI` decimal(18,2) DEFAULT NULL,
  `KODE_GROUP1` char(5) DEFAULT NULL,
  `KODE_GROUP2` char(5) DEFAULT NULL,
  `KODE_GROUP3` char(5) DEFAULT NULL,
  `KETERANGAN` char(40) DEFAULT NULL,
  `MINIMUM` decimal(18,2) DEFAULT NULL,
  `LAST_TGL_ADM` date DEFAULT NULL,
  `SETORAN_MINIMUM` decimal(18,2) DEFAULT NULL,
  `TGL_JT` date DEFAULT NULL,
  `SETORAN_PER_BLN` decimal(18,2) DEFAULT NULL,
  `JKW` int(11) DEFAULT NULL,
  `LAST_TGL_TRANS` date DEFAULT NULL,
  `ABP` smallint(6) DEFAULT NULL,
  `BARIS_BUKU` int(11) DEFAULT NULL,
  `BARIS_KARTU` int(11) DEFAULT NULL,
  `BARIS_BUKU_ALT` int(11) DEFAULT NULL,
  `BARIS_KARTU_ALT` int(11) DEFAULT NULL,
  `VERIFIKASI` char(1) DEFAULT NULL,
  `MIGRASI_SALDO_AWAL` decimal(18,4) DEFAULT NULL,
  `STATUS` smallint(6) DEFAULT NULL,
  `SETORAN_WAJIB` decimal(18,2) DEFAULT NULL,
  `ADM_PER_BLN` decimal(18,2) DEFAULT NULL,
  `STATUS_EFEKTIF_BLN_INI` char(1) DEFAULT NULL,
  `SALDO_AKHIR_TEMP1` decimal(15,2) DEFAULT NULL,
  `SALDO_AKHIR_TEMP2` decimal(15,2) DEFAULT NULL,
  `SALDO_AKHIR_TEMP3` decimal(15,2) DEFAULT NULL,
  `SALDO_AKHIR_TEMP4` decimal(15,2) DEFAULT NULL,
  `SALDO_AKHIR_TEMP5` decimal(15,2) DEFAULT NULL,
  `TANGGAL_TEMP1` date DEFAULT NULL,
  `TANGGAL_TEMP2` date DEFAULT NULL,
  `PERSEN_PPH_EFEKTIF_BLN_INI` decimal(5,2) DEFAULT NULL,
  `TANGGAL_TEMP3` date DEFAULT NULL,
  `TANGGAL_TEMP4` date DEFAULT NULL,
  `TANGGAL_TEMP5` date DEFAULT NULL,
  `NO_REK_JAM_KREDIT` char(20) DEFAULT NULL,
  `SALDO_JAM_KREDIT` decimal(18,2) DEFAULT NULL,
  `BUNGA_NASABAH` decimal(18,2) DEFAULT NULL,
  `BUNGA_PROMOSI` decimal(18,2) DEFAULT NULL,
  `KODE_KANTOR` char(4) DEFAULT NULL,
  `KODE_INTEGRASI` char(3) DEFAULT NULL,
  `no_rekening_baru` char(20) DEFAULT NULL,
  `USERID` int(11) DEFAULT NULL,
  `SETORAN_AWAL` decimal(18,2) DEFAULT NULL,
  `P2P_STATUS` int(11) DEFAULT NULL,
  `target_nominal` decimal(18,2) DEFAULT NULL,
  `JML_UNDIAN` int(11) DEFAULT NULL,
  `NOREK_TAB_PROGRAM` char(20) DEFAULT NULL,
  `SALDO_AKHIR_TITIPAN_BUNGA` decimal(18,2) DEFAULT NULL,
  `MIGRASI_SALDO_AWAL_TITIPAN` decimal(18,2) DEFAULT NULL,
  `tunggakan_setoran` decimal(18,2) DEFAULT NULL,
  `saldo_seharusnya` decimal(18,2) DEFAULT NULL,
  `ft_tunggakan` int(11) DEFAULT NULL,
  `saldo_penyesuaian` decimal(18,2) DEFAULT NULL,
  `kode_bi_lokasi` char(3) DEFAULT NULL,
  `POTONGAN_TABUNGAN` decimal(15,2) DEFAULT NULL,
  `POTONGAN_SP` decimal(15,2) DEFAULT NULL,
  `POTONGAN_SW` decimal(15,2) DEFAULT NULL,
  `POTONGAN_SS` decimal(15,2) DEFAULT NULL,
  `POTONGAN_LAINNYA` decimal(15,2) DEFAULT NULL,
  `saldo_titipan_pokok` decimal(18,2) DEFAULT NULL,
  `migrasi_saldo_titipan_pokok` decimal(18,2) DEFAULT NULL,
  `setoran_insentif_per_bln` decimal(18,2) DEFAULT NULL,
  `migrasi_titipan_bunga_ks` decimal(18,2) DEFAULT NULL,
  `saldo_titipan_bunga_ks` decimal(18,2) DEFAULT NULL,
  `potongan_tab` decimal(18,2) DEFAULT NULL,
  `adm_tab_pasif_bln_ini` decimal(18,2) DEFAULT NULL,
  PRIMARY KEY (`NO_REKENING`),
  KEY `NASABAH_ID` (`NASABAH_ID`),
  KEY `KODE_PRODUK` (`KODE_PRODUK`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tabung` */

insert  into `tabung`(`NO_REKENING`,`NO_ALTERNATIF`,`NASABAH_ID`,`KODE_PRODUK`,`KODE_BI_PEMILIK`,`SUKU_BUNGA`,`PERSEN_PPH`,`TGL_REGISTER`,`SALDO_AKHIR`,`SALDO_EFEKTIF_BLN_INI`,`SUKU_BUNGA_EFEKTIF_BLN_INI`,`BUNGA_BLN_INI`,`PAJAK_BLN_INI`,`ADM_BLN_INI`,`KODE_GROUP1`,`KODE_GROUP2`,`KODE_GROUP3`,`KETERANGAN`,`MINIMUM`,`LAST_TGL_ADM`,`SETORAN_MINIMUM`,`TGL_JT`,`SETORAN_PER_BLN`,`JKW`,`LAST_TGL_TRANS`,`ABP`,`BARIS_BUKU`,`BARIS_KARTU`,`BARIS_BUKU_ALT`,`BARIS_KARTU_ALT`,`VERIFIKASI`,`MIGRASI_SALDO_AWAL`,`STATUS`,`SETORAN_WAJIB`,`ADM_PER_BLN`,`STATUS_EFEKTIF_BLN_INI`,`SALDO_AKHIR_TEMP1`,`SALDO_AKHIR_TEMP2`,`SALDO_AKHIR_TEMP3`,`SALDO_AKHIR_TEMP4`,`SALDO_AKHIR_TEMP5`,`TANGGAL_TEMP1`,`TANGGAL_TEMP2`,`PERSEN_PPH_EFEKTIF_BLN_INI`,`TANGGAL_TEMP3`,`TANGGAL_TEMP4`,`TANGGAL_TEMP5`,`NO_REK_JAM_KREDIT`,`SALDO_JAM_KREDIT`,`BUNGA_NASABAH`,`BUNGA_PROMOSI`,`KODE_KANTOR`,`KODE_INTEGRASI`,`no_rekening_baru`,`USERID`,`SETORAN_AWAL`,`P2P_STATUS`,`target_nominal`,`JML_UNDIAN`,`NOREK_TAB_PROGRAM`,`SALDO_AKHIR_TITIPAN_BUNGA`,`MIGRASI_SALDO_AWAL_TITIPAN`,`tunggakan_setoran`,`saldo_seharusnya`,`ft_tunggakan`,`saldo_penyesuaian`,`kode_bi_lokasi`,`POTONGAN_TABUNGAN`,`POTONGAN_SP`,`POTONGAN_SW`,`POTONGAN_SS`,`POTONGAN_LAINNYA`,`saldo_titipan_pokok`,`migrasi_saldo_titipan_pokok`,`setoran_insentif_per_bln`,`migrasi_titipan_bunga_ks`,`saldo_titipan_bunga_ks`,`potongan_tab`,`adm_tab_pasif_bln_ini`) values 
('06-100-000001','','005989','100','874',0.10,0.00,'2010-01-01',184113.23,2215411.80,0.10,185.00,0.00,0.00,'','','','',0.00,NULL,0.00,'1899-12-30',0.00,0,NULL,0,11,NULL,NULL,NULL,'1',100222.2300,1,0.00,0.00,'',0.00,NULL,NULL,NULL,NULL,'2021-06-30',NULL,NULL,NULL,NULL,NULL,'',0.00,NULL,NULL,'06','100','',NULL,0.00,0,0.00,0,'',0.00,NULL,NULL,NULL,NULL,183911.23,'',NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,0.00,NULL,NULL),
('06-100-000002','','000002','100','874',0.10,0.00,'2010-01-01',327627.17,-57969220.46,0.10,0.00,0.00,-3552372.83,'','','','',0.00,NULL,0.00,'1899-12-30',0.00,0,NULL,0,30,NULL,NULL,NULL,'1',116000.0000,1,0.00,0.00,'',0.00,NULL,NULL,NULL,NULL,'2021-06-30',NULL,NULL,NULL,NULL,NULL,'',0.00,NULL,NULL,'06','100','',NULL,0.00,0,0.00,0,'',0.00,NULL,NULL,NULL,NULL,-5000372.83,'',NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,0.00,NULL,NULL),
('06-100-000003','','000003','100','874',0.10,0.00,'2010-01-01',115683.17,618083.51,0.10,52.00,0.00,0.00,'001','001','001','',0.00,NULL,0.00,'1899-12-30',0.00,0,NULL,0,25,NULL,NULL,NULL,'1',4000.0000,1,0.00,0.00,'',0.00,NULL,NULL,NULL,NULL,'2021-06-30',NULL,NULL,NULL,NULL,NULL,'',0.00,NULL,NULL,'06','100','',NULL,0.00,0,0.00,0,'',0.00,NULL,NULL,NULL,NULL,15666.17,'',NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,0.00,NULL,NULL);