backup.sql
This file has been truncated, but you can view the full file.
| -- MySQL Administrator dump 1.4 | |
| -- | |
| -- ------------------------------------------------------ | |
| -- Server version 5.1.56-community | |
| /*!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 */; | |
| /*!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' */; | |
| -- | |
| -- Create schema eisdata | |
| -- | |
| CREATE DATABASE IF NOT EXISTS eisdata; | |
| USE eisdata; | |
| -- | |
| -- Definition of table `absensi` | |
| -- | |
| DROP TABLE IF EXISTS `absensi`; | |
| CREATE TABLE `absensi` ( | |
| `cabsuser` varchar(10) DEFAULT NULL, | |
| `cabsdate` date DEFAULT NULL, | |
| `cabstime` varchar(8) DEFAULT NULL, | |
| `cabspk` varchar(23) NOT NULL, | |
| `cabstype` decimal(1,0) DEFAULT NULL, | |
| PRIMARY KEY (`cabspk`) USING BTREE, | |
| KEY `cabsuser` (`cabsuser`), | |
| KEY `cabsdate` (`cabsdate`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='abs'; | |
| -- | |
| -- Dumping data for table `absensi` | |
| -- | |
| /*!40000 ALTER TABLE `absensi` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `absensi` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `android2` | |
| -- | |
| DROP TABLE IF EXISTS `android2`; | |
| CREATE TABLE `android2` ( | |
| `candpk` char(23) NOT NULL, | |
| `canddesc` varchar(40) NOT NULL, | |
| `candpw` varchar(40) DEFAULT NULL, | |
| `nandbeli` int(1) unsigned DEFAULT '1', | |
| `nandjual` int(1) unsigned DEFAULT '1', | |
| `nandstock` int(1) unsigned DEFAULT '1', | |
| `nandsuspend` int(1) unsigned DEFAULT '0', | |
| `nandpos` int(1) DEFAULT '0', | |
| `nandopname` int(1) DEFAULT '0', | |
| `nandlaporan` int(1) DEFAULT '0', | |
| `candfkwhs` varchar(23) DEFAULT '', | |
| `nandresto` int(1) DEFAULT '0', | |
| PRIMARY KEY (`candpk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='and'; | |
| -- | |
| -- Dumping data for table `android2` | |
| -- | |
| /*!40000 ALTER TABLE `android2` DISABLE KEYS */; | |
| INSERT INTO `android2` (`candpk`,`canddesc`,`candpw`,`nandbeli`,`nandjual`,`nandstock`,`nandsuspend`,`nandpos`,`nandopname`,`nandlaporan`,`candfkwhs`,`nandresto`) VALUES | |
| ('5SvEMno+mXGcE1QZcPuV6TX','bos','05b1f356646c24bf1765f6f1b65aea3bde7247e1',1,1,1,0,1,1,1,'0MjEgB87sNEMjZr7az0FuAX',0); | |
| /*!40000 ALTER TABLE `android2` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `bank` | |
| -- | |
| DROP TABLE IF EXISTS `bank`; | |
| CREATE TABLE `bank` ( | |
| `cBANpk` char(23) NOT NULL, | |
| `cBANdesc` varchar(40) NOT NULL, | |
| `cBANgl` char(23) DEFAULT NULL, | |
| `cBANacc` varchar(20) DEFAULT NULL, | |
| `serino` varchar(10) DEFAULT NULL, | |
| PRIMARY KEY (`cBANpk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | |
| -- | |
| -- Dumping data for table `bank` | |
| -- | |
| /*!40000 ALTER TABLE `bank` DISABLE KEYS */; | |
| INSERT INTO `bank` (`cBANpk`,`cBANdesc`,`cBANgl`,`cBANacc`,`serino`) VALUES | |
| ('..default..............','Bank ',NULL,'',NULL), | |
| ('1or4kGNO6XGfV8u5IA9VeNX','Bank BCA ',NULL,'102.02 ',NULL), | |
| ('3iNr38S7SjE+fvqkCUwfPkX','Bank Lippo ',NULL,'102.03 ',NULL); | |
| /*!40000 ALTER TABLE `bank` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `bantu` | |
| -- | |
| DROP TABLE IF EXISTS `bantu`; | |
| CREATE TABLE `bantu` ( | |
| `cINVrefno` varchar(20) DEFAULT NULL, | |
| `dINVdate` date DEFAULT NULL, | |
| `cINVfkWHS` char(23) DEFAULT NULL, | |
| `cINVremark` varchar(40) DEFAULT NULL COMMENT 'remark', | |
| `cINVpk` char(23) NOT NULL, | |
| `cINVuser` varchar(10) DEFAULT NULL, | |
| `nINVoption` int(1) unsigned DEFAULT NULL, | |
| `ninvcetak` decimal(1,0) DEFAULT '0' COMMENT 'apakah sudah pernah cetak', | |
| `kunci` int(1) unsigned DEFAULT NULL, | |
| `oleh` text, | |
| `serino` varchar(10) DEFAULT NULL, | |
| `kunci2` int(1) DEFAULT NULL, | |
| PRIMARY KEY (`cINVpk`), | |
| KEY `cINVfkWHS` (`cINVfkWHS`) USING BTREE, | |
| KEY `dINVdate` (`dINVdate`) USING BTREE, | |
| KEY `cINVrefno` (`cINVrefno`) USING BTREE | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='BTU'; | |
| -- | |
| -- Dumping data for table `bantu` | |
| -- | |
| /*!40000 ALTER TABLE `bantu` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `bantu` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `bantudetail` | |
| -- | |
| DROP TABLE IF EXISTS `bantudetail`; | |
| CREATE TABLE `bantudetail` ( | |
| `cIVDpk` char(23) NOT NULL DEFAULT 'def', | |
| `cIVDfkINV` char(23) DEFAULT 'def', | |
| `cIVDfkSTK` char(23) DEFAULT 'def', | |
| `nIVDqtyin` decimal(17,3) DEFAULT '0.000', | |
| `nIVDqtyout` decimal(17,3) DEFAULT '0.000', | |
| `nIVDzqtyin` decimal(17,3) DEFAULT '0.000', | |
| `nIVDzqtyout` decimal(17,3) DEFAULT '0.000', | |
| `nIVDorder` int(10) unsigned DEFAULT '0', | |
| `cIVDcode` varchar(20) DEFAULT 'def' COMMENT 'Stock Code', | |
| `nIvdFactor` decimal(10,4) DEFAULT '0.0000', | |
| `cIVDunit` varchar(40) DEFAULT 'def', | |
| `cIVDfkporder` char(23) DEFAULT '', | |
| `nIVDstkppn` int(1) DEFAULT '0', | |
| `nIVDkirim` int(1) DEFAULT '0', | |
| `serino` varchar(10) DEFAULT NULL, | |
| PRIMARY KEY (`cIVDpk`) USING BTREE, | |
| KEY `cIVDfkINV` (`cIVDfkINV`) USING BTREE, | |
| KEY `cIVDfkSTK` (`cIVDfkSTK`) USING BTREE, | |
| KEY `cIVDfkporder` (`cIVDfkporder`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='BTD'; | |
| -- | |
| -- Dumping data for table `bantudetail` | |
| -- | |
| /*!40000 ALTER TABLE `bantudetail` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `bantudetail` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `batch` | |
| -- | |
| DROP TABLE IF EXISTS `batch`; | |
| CREATE TABLE `batch` ( | |
| `cbatpk` char(23) NOT NULL, | |
| `civdbatch` varchar(15) DEFAULT '', | |
| `divdexpire` date DEFAULT NULL, | |
| `nbatqty` decimal(15,2) DEFAULT NULL, | |
| `cbatfkstk` varchar(23) DEFAULT '', | |
| `cbatfkwhs` varchar(23) DEFAULT '', | |
| PRIMARY KEY (`cbatpk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='BTU'; | |
| -- | |
| -- Dumping data for table `batch` | |
| -- | |
| /*!40000 ALTER TABLE `batch` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `batch` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `bonus` | |
| -- | |
| DROP TABLE IF EXISTS `bonus`; | |
| CREATE TABLE `bonus` ( | |
| `cbonpk` varchar(23) NOT NULL, | |
| `cbonfkstk1` varchar(23) NOT NULL, | |
| `cbonfkstk2` varchar(23) NOT NULL, | |
| `nbonqty1` decimal(5,0) DEFAULT NULL, | |
| `nbonqty2` decimal(5,0) DEFAULT NULL, | |
| `nbondisc` decimal(6,2) DEFAULT NULL, | |
| `nbonsuspend` decimal(2,0) DEFAULT NULL, | |
| `dbonstart` date DEFAULT NULL, | |
| `dbonend` date DEFAULT NULL, | |
| `cbonfkstk3` varchar(23) DEFAULT NULL, | |
| `cbonfkstk4` varchar(23) DEFAULT NULL, | |
| `cbonfkstk5` varchar(23) DEFAULT NULL, | |
| `cbonfkstk6` varchar(23) DEFAULT NULL, | |
| `cbonfkgrp` varchar(23) DEFAULT NULL, | |
| `cbonfkbrd` varchar(23) DEFAULT NULL, | |
| `nbonstart` varchar(4) DEFAULT NULL, | |
| `nbonend` varchar(4) DEFAULT NULL, | |
| `nbonjatah` int(8) DEFAULT NULL, | |
| `nbondisc1` decimal(16,2) DEFAULT '0.00', | |
| `cbonfkwhs` varchar(23) DEFAULT '', | |
| PRIMARY KEY (`cbonpk`), | |
| KEY `dbonstart` (`dbonstart`), | |
| KEY `dbonend` (`dbonend`), | |
| KEY `cbonfkstk1` (`cbonfkstk1`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='bon'; | |
| -- | |
| -- Dumping data for table `bonus` | |
| -- | |
| /*!40000 ALTER TABLE `bonus` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `bonus` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `bonusrp` | |
| -- | |
| DROP TABLE IF EXISTS `bonusrp`; | |
| CREATE TABLE `bonusrp` ( | |
| `cbonpk` varchar(23) NOT NULL, | |
| `cbonfkstk2` varchar(23) NOT NULL, | |
| `nbonqty2` decimal(5,0) DEFAULT NULL, | |
| `nbonsuspend` decimal(2,0) DEFAULT NULL, | |
| `dbonstart` date DEFAULT NULL, | |
| `dbonend` date DEFAULT NULL, | |
| `nbonstart` varchar(4) DEFAULT NULL, | |
| `nbonend` varchar(4) DEFAULT NULL, | |
| `nbonrp` decimal(10,2) DEFAULT NULL, | |
| `nbonharga` decimal(10,2) DEFAULT NULL, | |
| `cbonfkwhs` varchar(23) DEFAULT '', | |
| PRIMARY KEY (`cbonpk`), | |
| KEY `dbonstart` (`dbonstart`), | |
| KEY `dbonend` (`dbonend`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='bon'; | |
| -- | |
| -- Dumping data for table `bonusrp` | |
| -- | |
| /*!40000 ALTER TABLE `bonusrp` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `bonusrp` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `brand` | |
| -- | |
| DROP TABLE IF EXISTS `brand`; | |
| CREATE TABLE `brand` ( | |
| `cBRDpk` char(23) NOT NULL, | |
| `cBRDdesc` varchar(40) NOT NULL COMMENT 'ID', | |
| `serino` varchar(10) DEFAULT NULL, | |
| PRIMARY KEY (`cBRDpk`), | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='BRD'; | |
| -- | |
| -- Dumping data for table `brand` | |
| -- | |
| /*!40000 ALTER TABLE `brand` DISABLE KEYS */; | |
| INSERT INTO `brand` (`cBRDpk`,`cBRDdesc`,`serino`) VALUES | |
| ('1cNWOOFQWWFsauo5jEcVSmX','Sony ',NULL), | |
| ('2ouDYxf9iSHM31NDUn6EdOX','LG ',NULL), | |
| ('1I4cxs8MIhHfUemztgfbJfX','Samsung ',NULL); | |
| /*!40000 ALTER TABLE `brand` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `cabang` | |
| -- | |
| DROP TABLE IF EXISTS `cabang`; | |
| CREATE TABLE `cabang` ( | |
| `ccabpk` char(23) NOT NULL, | |
| `ccabid` varchar(10) DEFAULT NULL, | |
| `ccabfkwhs` char(23) DEFAULT NULL, | |
| `ccabpass1` varchar(10) DEFAULT NULL, | |
| `ccabpass2` varchar(10) DEFAULT NULL, | |
| `ccabhead` text, | |
| `ncabcek` int(1) DEFAULT NULL, | |
| `ccabpass3` varchar(10) DEFAULT NULL, | |
| `ccabpass4` varchar(10) DEFAULT NULL, | |
| `ccabpass8` varchar(10) DEFAULT NULL, | |
| `ncabsemua` int(1) DEFAULT NULL, | |
| `mycabangp` int(1) DEFAULT NULL, | |
| `nbebas` int(1) DEFAULT NULL, | |
| PRIMARY KEY (`ccabpk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='cab'; | |
| -- | |
| -- Dumping data for table `cabang` | |
| -- | |
| /*!40000 ALTER TABLE `cabang` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `cabang` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `city` | |
| -- | |
| DROP TABLE IF EXISTS `city`; | |
| CREATE TABLE `city` ( | |
| `cCITpk` char(23) NOT NULL, | |
| `cCITdesc` varchar(40) NOT NULL COMMENT 'ID', | |
| `serino` varchar(10) DEFAULT NULL, | |
| PRIMARY KEY (`cCITpk`), | |
| UNIQUE KEY `cCITdesc` (`cCITdesc`) USING BTREE, | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='CIT'; | |
| -- | |
| -- Dumping data for table `city` | |
| -- | |
| /*!40000 ALTER TABLE `city` DISABLE KEYS */; | |
| INSERT INTO `city` (`cCITpk`,`cCITdesc`,`serino`) VALUES | |
| ('..default..............','default ',NULL), | |
| ('0Hm2-aX0jBFOkRFYe5ABM4X','Jakarta ',NULL), | |
| ('1sLmMgNUSoG-PjbICeei2BX','Semarang ',NULL), | |
| ('1zuI85mrjnE-h3ZYgm4kbMX','Bandung ',NULL), | |
| ('0WcPONBkJrGNiU-vHTYsgXX','Surabaya ',NULL), | |
| ('3uIwquhHwUHfDvqF8fZ8drX','Denpasar ',NULL); | |
| /*!40000 ALTER TABLE `city` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `company` | |
| -- | |
| DROP TABLE IF EXISTS `company`; | |
| CREATE TABLE `company` ( | |
| `cCAMpk` char(23) NOT NULL, | |
| `cCAMdesc` varchar(40) NOT NULL, | |
| PRIMARY KEY (`cCAMpk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='CAM'; | |
| -- | |
| -- Dumping data for table `company` | |
| -- | |
| /*!40000 ALTER TABLE `company` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `company` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `custbrd` | |
| -- | |
| DROP TABLE IF EXISTS `custbrd`; | |
| CREATE TABLE `custbrd` ( | |
| `ccuspk` char(23) NOT NULL, | |
| `ccusfkent` char(23) NOT NULL, | |
| `ccusfkBRD` char(23) NOT NULL, | |
| `ncusdisc1` decimal(6,2) DEFAULT NULL, | |
| `ncusdisc2` decimal(6,2) DEFAULT NULL, | |
| `ncusdisc3` decimal(6,2) DEFAULT NULL, | |
| PRIMARY KEY (`ccuspk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='cBR'; | |
| -- | |
| -- Dumping data for table `custbrd` | |
| -- | |
| /*!40000 ALTER TABLE `custbrd` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `custbrd` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `custgrp` | |
| -- | |
| DROP TABLE IF EXISTS `custgrp`; | |
| CREATE TABLE `custgrp` ( | |
| `ccuspk` char(23) NOT NULL, | |
| `ccusfkent` char(23) NOT NULL, | |
| `ccusfkgrp` char(23) NOT NULL, | |
| `ncusdisc1` decimal(6,2) DEFAULT NULL, | |
| `ncusdisc2` decimal(6,2) DEFAULT NULL, | |
| `ncusdisc3` decimal(6,2) DEFAULT NULL, | |
| PRIMARY KEY (`ccuspk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='cus'; | |
| -- | |
| -- Dumping data for table `custgrp` | |
| -- | |
| /*!40000 ALTER TABLE `custgrp` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `custgrp` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `delog` | |
| -- | |
| DROP TABLE IF EXISTS `delog`; | |
| CREATE TABLE `delog` ( | |
| `cLOGpk` char(23) NOT NULL, | |
| `cLOGrefno` varchar(20) DEFAULT NULL, | |
| `dLOGdate` date DEFAULT NULL, | |
| `cLOGuser` varchar(10) DEFAULT NULL, | |
| `dLOGdelete` date DEFAULT NULL, | |
| `cLOGspecial` varchar(2) DEFAULT NULL, | |
| `nLOGitem` decimal(9,0) DEFAULT NULL, | |
| `nLOGqty` decimal(9,0) DEFAULT NULL, | |
| `nLOGvalue` decimal(15,2) DEFAULT NULL, | |
| `dLOGstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | |
| `clogremark` text, | |
| `clogent` varchar(40) DEFAULT NULL, | |
| PRIMARY KEY (`cLOGpk`), | |
| KEY `dLOGdate` (`dLOGdate`) USING BTREE, | |
| KEY `cLOGspecial` (`cLOGspecial`), | |
| KEY `cLOGrefno` (`cLOGrefno`) USING BTREE | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='LOG'; | |
| -- | |
| -- Dumping data for table `delog` | |
| -- | |
| /*!40000 ALTER TABLE `delog` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `delog` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `drawer` | |
| -- | |
| DROP TABLE IF EXISTS `drawer`; | |
| CREATE TABLE `drawer` ( | |
| `dDRAdate` date DEFAULT NULL, | |
| `cDRAuser` varchar(10) DEFAULT NULL, | |
| `nDRAopen` decimal(15,2) DEFAULT NULL, | |
| `nDRAdraw` decimal(15,2) DEFAULT NULL, | |
| `cDRApk` char(23) NOT NULL, | |
| `serino` varchar(10) DEFAULT NULL, | |
| `xkirim` int(2) unsigned DEFAULT NULL, | |
| `okirim` int(2) DEFAULT NULL, | |
| `nnosale` int(5) DEFAULT NULL, | |
| `ncancel` int(5) DEFAULT NULL, | |
| `ndradraw1` decimal(15,2) DEFAULT '0.00', | |
| `cdramemo` varchar(250) DEFAULT '', | |
| `ndranilai` decimal(15,2) DEFAULT '0.00', | |
| PRIMARY KEY (`cDRApk`), | |
| KEY `dDRAdate` (`dDRAdate`), | |
| KEY `cDRAuser` (`cDRAuser`), | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='DRA'; | |
| -- | |
| -- Dumping data for table `drawer` | |
| -- | |
| /*!40000 ALTER TABLE `drawer` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `drawer` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `entity` | |
| -- | |
| DROP TABLE IF EXISTS `entity`; | |
| CREATE TABLE `entity` ( | |
| `cENTpk` char(23) NOT NULL, | |
| `cENTdesc` varchar(40) NOT NULL, | |
| `cENTfkCIT` char(23) NOT NULL, | |
| `cENTadd1` varchar(40) DEFAULT NULL, | |
| `cENTadd2` varchar(40) DEFAULT NULL, | |
| `cENTadd3` varchar(40) DEFAULT NULL, | |
| `cENTadd4` varchar(40) DEFAULT NULL, | |
| `cENTadd5` varchar(40) DEFAULT NULL, | |
| `cENTnpwp` varchar(16) DEFAULT '', | |
| `cENTnppkp` varchar(16) DEFAULT '', | |
| `nENTlimit` decimal(15,2) DEFAULT '0.00' COMMENT 'credit limit', | |
| `nENTdisc` decimal(6,2) DEFAULT '0.00', | |
| `nENTterm` int(4) unsigned DEFAULT '0', | |
| `nENTsame` int(1) unsigned DEFAULT '1', | |
| `cENTbill` varchar(40) DEFAULT NULL, | |
| `cENTbadd1` varchar(40) DEFAULT NULL, | |
| `cENTbadd2` varchar(40) DEFAULT NULL, | |
| `cENTbadd3` varchar(40) DEFAULT NULL, | |
| `cENTbadd4` varchar(40) DEFAULT NULL, | |
| `nENToption` int(2) DEFAULT NULL, | |
| `dENTcreate` date DEFAULT NULL, | |
| `dENTlast` date DEFAULT NULL, | |
| `nENTsuspend` int(1) unsigned DEFAULT '0', | |
| `cENTmemo` text, | |
| `nENTcust` int(1) unsigned DEFAULT '0', | |
| `nENTsupp` int(1) unsigned DEFAULT '0', | |
| `cENTcode` char(20) DEFAULT 'id' COMMENT 'ID', | |
| `cENTspecial` varchar(2) DEFAULT NULL, | |
| `cENTimage` varchar(45) DEFAULT NULL, | |
| `serino` varchar(10) DEFAULT NULL, | |
| `ongkos` decimal(15,2) DEFAULT NULL, | |
| `xongkos` decimal(15,2) DEFAULT NULL, | |
| `dEnthut` date DEFAULT NULL, | |
| `nENTgovt` int(1) DEFAULT NULL, | |
| `cENTgl` varchar(23) DEFAULT NULL, | |
| `cENTacc` varchar(20) DEFAULT NULL, | |
| `cENTdescp` varchar(60) DEFAULT NULL, | |
| `cENTadd1p` varchar(60) DEFAULT NULL, | |
| `cENTadd2p` varchar(60) DEFAULT NULL, | |
| `cENTadd3p` varchar(60) DEFAULT NULL, | |
| `cENTadd4p` varchar(60) DEFAULT NULL, | |
| `cENTadd5p` varchar(60) DEFAULT NULL, | |
| `dENTmexpire` date DEFAULT NULL, | |
| `nENTtop` int(5) DEFAULT NULL, | |
| `cENTfkCAM` varchar(23) DEFAULT '', | |
| `nENTfix` int(1) DEFAULT NULL, | |
| `cENTfkSAL` varchar(23) DEFAULT NULL, | |
| `cENTrek` varchar(40) DEFAULT ' ', | |
| `nentasuransi` int(1) DEFAULT NULL, | |
| `cent3` varchar(20) DEFAULT NULL, | |
| `centclass3` char(6) DEFAULT NULL, | |
| `cent2` varchar(20) DEFAULT NULL, | |
| `centclass2` char(20) DEFAULT NULL, | |
| `cent4` varchar(20) DEFAULT NULL, | |
| `centclass4` char(20) DEFAULT NULL, | |
| `keyid` char(4) DEFAULT NULL, | |
| `cent5` varchar(20) DEFAULT NULL, | |
| `centclass5` char(20) DEFAULT NULL, | |
| `nentvisit` int(1) DEFAULT NULL, | |
| `centfkjns` varchar(23) DEFAULT NULL, | |
| `nenttipe` int(2) DEFAULT NULL, | |
| `nlimitrp` decimal(15,2) DEFAULT NULL, | |
| `nlimitdisc` decimal(5,2) DEFAULT NULL, | |
| `nentpopup` int(1) DEFAULT NULL, | |
| `nentnodisc` int(1) DEFAULT NULL, | |
| `nentkontan` int(1) DEFAULT NULL, | |
| `nefaktur` int(1) DEFAULT NULL, | |
| `centfkjmm` char(23) DEFAULT NULL, | |
| `centpdf` varchar(60) DEFAULT NULL, | |
| `centagama` varchar(10) DEFAULT NULL, | |
| `nentpilih` int(1) DEFAULT NULL, | |
| `centadds` varchar(60) DEFAULT NULL, | |
| `centadd1s` varchar(60) DEFAULT NULL, | |
| `centadd2s` varchar(60) DEFAULT NULL, | |
| `centadd3s` varchar(60) DEFAULT NULL, | |
| `centadd4s` varchar(60) DEFAULT NULL, | |
| `centadd5s` varchar(60) DEFAULT NULL, | |
| `nentjenis` int(1) DEFAULT NULL, | |
| `centfkout` char(23) DEFAULT NULL, | |
| `centfkday` char(23) DEFAULT NULL, | |
| `nentisx` int(1) DEFAULT NULL, | |
| `cent6` varchar(20) DEFAULT NULL, | |
| `centclass6` char(5) DEFAULT NULL, | |
| `centclass6a` char(5) DEFAULT NULL, | |
| `nentpkp` int(1) DEFAULT NULL, | |
| `nentloncat` int(1) DEFAULT NULL, | |
| `nentgender` int(1) DEFAULT NULL, | |
| `centijin` varchar(50) DEFAULT NULL, | |
| `centijin1` varchar(50) DEFAULT NULL, | |
| `dentsipa` date DEFAULT NULL, | |
| `dentpbf` date DEFAULT NULL, | |
| `nentsipa` int(1) DEFAULT '3', | |
| `cent9` varchar(20) DEFAULT '', | |
| `centch` varchar(20) DEFAULT '', | |
| `centsubch` varchar(20) DEFAULT '', | |
| `centsubch2` varchar(20) DEFAULT '', | |
| `centcity` varchar(20) DEFAULT '', | |
| `centfrek` varchar(5) DEFAULT '', | |
| `cent8` varchar(20) DEFAULT '', | |
| `centlong` varchar(15) DEFAULT '', | |
| `centlat` varchar(15) DEFAULT '', | |
| `nenttas` int(1) DEFAULT '1', | |
| `centscan` text, | |
| `cENTibu` varchar(40) DEFAULT ' ', | |
| `nENTjarak` int(4) DEFAULT '0', | |
| `centchannel` varchar(20) DEFAULT 'AGEN', | |
| `cent10` varchar(20) DEFAULT ' ', | |
| `centsuku` varchar(20) DEFAULT ' ', | |
| `nentjatah` decimal(15,2) DEFAULT '0.00', | |
| `nenttidak` int(1) DEFAULT '0', | |
| `centemail` varchar(40) DEFAULT '', | |
| `centemail2` varchar(40) DEFAULT '', | |
| `centemail3` varchar(40) DEFAULT '', | |
| `cent50` varchar(20) DEFAULT '', | |
| `cent51` varchar(20) DEFAULT '', | |
| `cENTnpwp1` varchar(15) DEFAULT '', | |
| `centjenis` varchar(20) DEFAULT 'TIN', | |
| `centid` varchar(3) DEFAULT 'IDN', | |
| `centdok` varchar(20) DEFAULT '-', | |
| `centtku` varchar(22) DEFAULT '000000', | |
| `cent52` varchar(20) DEFAULT '', | |
| `nentdiscrp` decimal(18,2) DEFAULT '0.00', | |
| `centcdob` varchar(30) DEFAULT '', | |
| `dentcdob` date DEFAULT NULL, | |
| `centip` varchar(20) DEFAULT '', | |
| PRIMARY KEY (`cENTpk`), | |
| UNIQUE KEY `cENTcode` (`cENTcode`) USING BTREE, | |
| KEY `cENTdesc` (`cENTdesc`), | |
| KEY `cENTfkCIT` (`cENTfkCIT`), | |
| KEY `cENTsuspend` (`nENTsuspend`) USING BTREE, | |
| KEY `cENTcust` (`nENTcust`) USING BTREE, | |
| KEY `cENTsupp` (`nENTsupp`) USING BTREE, | |
| KEY `cENTspecial` (`cENTspecial`), | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ENT'; | |
| -- | |
| -- Dumping data for table `entity` | |
| -- | |
| /*!40000 ALTER TABLE `entity` DISABLE KEYS */; | |
| INSERT INTO `entity` (`cENTpk`,`cENTdesc`,`cENTfkCIT`,`cENTadd1`,`cENTadd2`,`cENTadd3`,`cENTadd4`,`cENTadd5`,`cENTnpwp`,`cENTnppkp`,`nENTlimit`,`nENTdisc`,`nENTterm`,`nENTsame`,`cENTbill`,`cENTbadd1`,`cENTbadd2`,`cENTbadd3`,`cENTbadd4`,`nENToption`,`dENTcreate`,`dENTlast`,`nENTsuspend`,`cENTmemo`,`nENTcust`,`nENTsupp`,`cENTcode`,`cENTspecial`,`cENTimage`,`serino`,`ongkos`,`xongkos`,`dEnthut`,`nENTgovt`,`cENTgl`,`cENTacc`,`cENTdescp`,`cENTadd1p`,`cENTadd2p`,`cENTadd3p`,`cENTadd4p`,`cENTadd5p`,`dENTmexpire`,`nENTtop`,`cENTfkCAM`,`nENTfix`,`cENTfkSAL`,`cENTrek`,`nentasuransi`,`cent3`,`centclass3`,`cent2`,`centclass2`,`cent4`,`centclass4`,`keyid`,`cent5`,`centclass5`,`nentvisit`,`centfkjns`,`nenttipe`,`nlimitrp`,`nlimitdisc`,`nentpopup`,`nentnodisc`,`nentkontan`,`nefaktur`,`centfkjmm`,`centpdf`,`centagama`,`nentpilih`,`centadds`,`centadd1s`,`centadd2s`,`centadd3s`,`centadd4s`,`centadd5s`,`nentjenis`,`centfkout`,`centfkday`,`nentisx`,`cent6`,`centclass6`,`centclass6a`,`nentpkp`,`nentloncat`,`nentgender`,`centijin`,`centijin1`,`dentsipa`,`dentpbf`,`nentsipa`,`cent9`,`centch`,`centsubch`,`centsubch2`,`centcity`,`centfrek`,`cent8`,`centlong`,`centlat`,`nenttas`,`centscan`,`cENTibu`,`nENTjarak`,`centchannel`,`cent10`,`centsuku`,`nentjatah`,`nenttidak`,`centemail`,`centemail2`,`centemail3`,`cent50`,`cent51`,`cENTnpwp1`,`centjenis`,`centid`,`centdok`,`centtku`,`cent52`,`nentdiscrp`,`centcdob`,`dentcdob`,`centip`) VALUES | |
| ('..awal.................','awal ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'AWAL','SA',' ',NULL,'0.00','0.00','1980-01-01',1,'','','awal ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'awal ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..hapus................','hapus ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'HAPUS','HP',' ',NULL,'0.00','0.00','1980-01-01',1,'','','hapus ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'hapus ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..pemindahan...........','pemindahan ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'PEMINDAHAN','PD',' ',NULL,'0.00','0.00','1980-01-01',1,'','','pemindahan ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'pemindahan ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..opname...............','opname ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'OPNAME','OP',' ',NULL,'0.00','0.00','1980-01-01',1,'','','opname ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'opname ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..produksi.............','produksi ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'PRODUKSI','PR',' ',NULL,'0.00','0.00','1980-01-01',1,'','','produksi ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'produksi ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..terima...............','terima ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'TERIMA','TM',' ',NULL,'0.00','0.00','1980-01-01',1,'','','terima ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'terima ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..pakai................','pakai ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'PAKAI','PK',' ',NULL,'0.00','0.00','1980-01-01',1,'','','pakai ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'pakai ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..kembali..............','kembali ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'KEMBALI','KB',' ',NULL,'0.00','0.00','1980-01-01',1,'','','kembali ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'kembali ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('..konsinyasi...........','konsinyasi ','..default..............',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,0,'KONSINYASI','KS',' ',NULL,'0.00','0.00','1980-01-01',1,'','','konsinyasi ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'konsinyasi ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('0sxzr20-TpEcuZOihD2manX','MANDY ','0Hm2-aX0jBFOkRFYe5ABM4X',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',1,0,'MANDY',NULL,'c:\\isx\\pic\\MANDY.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','103.04 ','MANDY ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'MANDY ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,2,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN ','IDN','- ','0000000000000000000000','','0.00','',NULL,''), | |
| ('1TLr5okV-GFvD5boAIVA1lX','NATALIE ','1sLmMgNUSoG-PjbICeei2BX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',1,0,'NATALIE',NULL,'c:\\isx\\pic\\NATALIE.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','103.06 ','NATALIE ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'NATALIE ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,2,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN ','IDN','- ','0000000000000000000000','','0.00','',NULL,''), | |
| ('38SwO4PYukHN6kNHOwxkaRX','MILA ','1zuI85mrjnE-h3ZYgm4kbMX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',1,0,'MILA',NULL,'c:\\isx\\pic\\MILA.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','103.05 ','MILA ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'MILA ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,2,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN ','IDN','- ','0000000000000000000000','','0.00','',NULL,''), | |
| ('1Wg8YhIYJJHdE583R+rSZWX','JANET ','0WcPONBkJrGNiU-vHTYsgXX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',1,0,'JANET',NULL,'c:\\isx\\pic\\JANET.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','103.03 ','JANET ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'JANET ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,2,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN ','IDN','- ','0000000000000000000000','','0.00','',NULL,''), | |
| ('2Lng1RENk6GNVSptS4tQCSX','EMILY ','3uIwquhHwUHfDvqF8fZ8drX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',1,0,'EMILY',NULL,'c:\\isx\\pic\\EMILY.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','103.02 ','EMILY ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'EMILY ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,2,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN ','IDN','- ','0000000000000000000000','','0.00','',NULL,''), | |
| ('2noJMzQulHGdeo9Ik2wSayX','BEN ','0Hm2-aX0jBFOkRFYe5ABM4X',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,1,'BEN',NULL,'c:\\isx\\pic\\BEN.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','301.02 ','BEN ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'BEN ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('1Eql9LOqeTHt3blX2RVxW0X','JEFF ','1sLmMgNUSoG-PjbICeei2BX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,1,'JEFF',NULL,'c:\\isx\\pic\\JEFF.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','301.03 ','JEFF ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'JEFF ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('1da5Tli4kbG9LGPtFEOyIMX','ROBERT ','1zuI85mrjnE-h3ZYgm4kbMX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,1,'ROBERT',NULL,'c:\\isx\\pic\\ROBERT.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','301.06 ','ROBERT ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'ROBERT ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('3cbFzGuOGWGfxKPJunORRAX','JUSTIN ','0WcPONBkJrGNiU-vHTYsgXX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,1,'JUSTIN',NULL,'c:\\isx\\pic\\JUSTIN.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','301.04 ','JUSTIN ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'JUSTIN ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''), | |
| ('3mNMtlQBwkE+GX7Z15KGDrX','MATT ','3uIwquhHwUHfDvqF8fZ8drX',' ',' ',' ',' ',' ','','','0.00','0.00',0,1,'',' ',' ',' ',' ',1,NULL,NULL,0,' ',0,1,'MATT',NULL,'c:\\isx\\pic\\MATT.jpg ',NULL,'0.00','0.00','1980-01-01',1,'','301.05 ','MATT ',' ',' ',' ',' ',' ',NULL,0,'',0,'..default..............',' ',1,'','Sedang','','C203 Grosir','','GRO Grosir','','','',2,'..default..............',0,NULL,NULL,0,0,3,0,'','','Tidak Tahu',0,'MATT ',' ',' ',' ',' ',' ',1,'..default..............','..default..............',3,'','','',1,0,1,NULL,NULL,NULL,NULL,3,'','','','','','','','','',1,NULL,' ',0,'AGEN',' ',' ','0.00',0,'','','','','','','TIN','IDN','-','000000','','0.00','',NULL,''); | |
| /*!40000 ALTER TABLE `entity` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `exchange` | |
| -- | |
| DROP TABLE IF EXISTS `exchange`; | |
| CREATE TABLE `exchange` ( | |
| `cEXCpk` char(23) NOT NULL, | |
| `cEXCdesc` varchar(10) NOT NULL COMMENT 'ID', | |
| `nEXCvalue` decimal(15,4) NOT NULL DEFAULT '0.0000', | |
| `nEXCtaxvalue` decimal(15,4) DEFAULT '0.0000', | |
| `serino` varchar(10) DEFAULT NULL, | |
| PRIMARY KEY (`cEXCpk`), | |
| UNIQUE KEY `cEXCdesc` (`cEXCdesc`) USING BTREE, | |
| KEY `nEXCvalue` (`nEXCvalue`), | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='EXC'; | |
| -- | |
| -- Dumping data for table `exchange` | |
| -- | |
| /*!40000 ALTER TABLE `exchange` DISABLE KEYS */; | |
| INSERT INTO `exchange` (`cEXCpk`,`cEXCdesc`,`nEXCvalue`,`nEXCtaxvalue`,`serino`) VALUES | |
| ('..rupiah...............','Rp. ','1.0000','1.0000',NULL), | |
| ('2aEaN11e+iHt1D-hIEOAgjX','USD ','16000.0000','16000.0000',NULL); | |
| /*!40000 ALTER TABLE `exchange` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `expedisi` | |
| -- | |
| DROP TABLE IF EXISTS `expedisi`; | |
| CREATE TABLE `expedisi` ( | |
| `cexppk` char(23) NOT NULL, | |
| `cexpdesc` varchar(40) DEFAULT NULL, | |
| `nexpfee` decimal(15,2) DEFAULT NULL, | |
| `serino` varchar(10) DEFAULT NULL, | |
| PRIMARY KEY (`cexppk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='xpd'; | |
| -- | |
| -- Dumping data for table `expedisi` | |
| -- | |
| /*!40000 ALTER TABLE `expedisi` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `expedisi` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `formula` | |
| -- | |
| DROP TABLE IF EXISTS `formula`; | |
| CREATE TABLE `formula` ( | |
| `cINVrefno` varchar(20) DEFAULT NULL, | |
| `cINVfkEXC` char(23) DEFAULT NULL, | |
| `cINVremark` varchar(40) DEFAULT NULL COMMENT 'remark', | |
| `cINVpk` char(23) NOT NULL, | |
| `cINVuser` varchar(10) DEFAULT NULL, | |
| `cINVspecial` varchar(2) DEFAULT NULL, | |
| `serino` varchar(10) DEFAULT NULL, | |
| `xkirim` int(2) unsigned DEFAULT NULL, | |
| `kunci` int(1) unsigned DEFAULT NULL, | |
| `oleh` text, | |
| PRIMARY KEY (`cINVpk`), | |
| KEY `cINVfkEXC` (`cINVfkEXC`) USING BTREE, | |
| KEY `cINVspecial` (`cINVspecial`), | |
| KEY `cINVrefno` (`cINVrefno`) USING BTREE, | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='FOR'; | |
| -- | |
| -- Dumping data for table `formula` | |
| -- | |
| /*!40000 ALTER TABLE `formula` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `formula` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `formuladetail` | |
| -- | |
| DROP TABLE IF EXISTS `formuladetail`; | |
| CREATE TABLE `formuladetail` ( | |
| `cIVDpk` char(23) NOT NULL DEFAULT 'def', | |
| `cIVDfkINV` char(23) DEFAULT 'def', | |
| `cIVDfkSTK` char(23) DEFAULT 'def', | |
| `nIVDqtyin` decimal(17,4) DEFAULT '0.0000', | |
| `nIVDqtyout` decimal(17,4) DEFAULT '0.0000', | |
| `nIVDzqtyin` decimal(17,4) DEFAULT '0.0000', | |
| `nIVDzqtyout` decimal(17,4) DEFAULT '0.0000', | |
| `nIVDprice` decimal(18,4) DEFAULT '0.0000', | |
| `nIVDdisc1` decimal(6,2) DEFAULT '0.00' COMMENT 'Disc in %', | |
| `nIVDdisc2` decimal(6,2) DEFAULT '0.00' COMMENT 'Disc in %', | |
| `nIVDdisc3` decimal(6,2) DEFAULT '0.00' COMMENT 'Disc in %', | |
| `nIVDdisc` decimal(18,4) DEFAULT '0.0000' COMMENT 'Disc in value', | |
| `nIVDorder` int(10) unsigned DEFAULT '0', | |
| `cIVDcode` varchar(20) DEFAULT 'def' COMMENT 'Stock Code', | |
| `nIvdFactor` decimal(10,4) DEFAULT '0.0000', | |
| `cIVDunit` varchar(40) DEFAULT 'def', | |
| `nIVDAmount` decimal(18,4) DEFAULT '0.0000', | |
| `nIVDpokok` decimal(18,4) DEFAULT NULL, | |
| `nIVDstkppn` int(1) DEFAULT '0', | |
| `serino` varchar(10) DEFAULT NULL, | |
| `xkirim` int(2) unsigned DEFAULT NULL, | |
| `cIVDmemo` text, | |
| `nIVDkirim` int(1) DEFAULT NULL, | |
| `cIVDmenu` char(23) DEFAULT NULL, | |
| `nivdpersen` decimal(6,2) DEFAULT '0.00', | |
| `nivdpokok8` decimal(15,2) DEFAULT '0.00', | |
| PRIMARY KEY (`cIVDpk`) USING BTREE, | |
| KEY `cIVDfkINV` (`cIVDfkINV`) USING BTREE, | |
| KEY `cIVDfkSTK` (`cIVDfkSTK`) USING BTREE, | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='FOD'; | |
| -- | |
| -- Dumping data for table `formuladetail` | |
| -- | |
| /*!40000 ALTER TABLE `formuladetail` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `formuladetail` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `gift` | |
| -- | |
| DROP TABLE IF EXISTS `gift`; | |
| CREATE TABLE `gift` ( | |
| `cGIFpk` char(23) NOT NULL, | |
| `cGIFdesc` varchar(40) NOT NULL, | |
| PRIMARY KEY (`cGIFpk`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | |
| -- | |
| -- Dumping data for table `gift` | |
| -- | |
| /*!40000 ALTER TABLE `gift` DISABLE KEYS */; | |
| /*!40000 ALTER TABLE `gift` ENABLE KEYS */; | |
| -- | |
| -- Definition of table `invoice` | |
| -- | |
| DROP TABLE IF EXISTS `invoice`; | |
| CREATE TABLE `invoice` ( | |
| `cINVrefno` varchar(20) DEFAULT NULL, | |
| `dINVdate` date DEFAULT NULL, | |
| `cINVfkENT` char(23) DEFAULT NULL, | |
| `cINVfkSAM` char(23) DEFAULT '..default..............', | |
| `cINVfkWHS` char(23) DEFAULT NULL, | |
| `cINVfkEXC` char(23) DEFAULT '..rupiah...............', | |
| `nINVcash` int(2) unsigned DEFAULT '0' COMMENT 'cash = 1 (cash), 0 (credit)', | |
| `dINVdue` date DEFAULT NULL COMMENT 'due date', | |
| `cinvserie` varchar(40) DEFAULT ' ', | |
| `cinvtaxinv` varchar(40) DEFAULT ' ', | |
| `cinvpo` varchar(40) DEFAULT ' ', | |
| `cinvremark` varchar(40) DEFAULT ' ', | |
| `nINVdisc1` decimal(6,2) DEFAULT '0.00', | |
| `nINVdisc2` decimal(6,2) DEFAULT '0.00', | |
| `nINVdisc3` decimal(6,2) DEFAULT '0.00', | |
| `nINVdisc` decimal(15,2) DEFAULT '0.00', | |
| `nINVtax` decimal(6,2) DEFAULT '0.00', | |
| `nINVpaid` int(1) unsigned DEFAULT '0' COMMENT '1 = Paid, so don''t have to count for A/R acc', | |
| `cINVpk` char(23) NOT NULL, | |
| `cINVuser` varchar(10) DEFAULT NULL, | |
| `cINVspecial` varchar(2) DEFAULT NULL, | |
| `cINVTransfer` char(23) DEFAULT 'n/a', | |
| `dINVtaxdate` date DEFAULT NULL, | |
| `nINVfreight` decimal(15,2) DEFAULT '0.00', | |
| `cInvFkEntCode` char(20) DEFAULT NULL, | |
| `nInvOpening` decimal(15,2) NOT NULL DEFAULT '0.00', | |
| `cinvremark1` varchar(45) DEFAULT ' ', | |
| `cInvReturnto` char(23) DEFAULT '', | |
| `ninvoption` int(2) DEFAULT '0', | |
| `ninvcetak` decimal(1,0) DEFAULT '0' COMMENT 'apakah sudah pernah cetak', | |
| `nINVdp` decimal(15,2) DEFAULT '0.00', | |
| `nINVvoucher` decimal(15,2) DEFAULT '0.00', | |
| `nINVtunai` decimal(15,2) DEFAULT '0.00', | |
| `nINVpiutang` decimal(15,2) DEFAULT '0.00', | |
| `nINVCredit` decimal(15,2) DEFAULT '0.00', | |
| `nINVdebit` decimal(15,2) DEFAULT '0.00', | |
| `nINVjam` int(2) DEFAULT '0', | |
| `ninvno_card` varchar(20) DEFAULT ' ', | |
| `ninvjenis_card` varchar(20) DEFAULT ' ', | |
| `ninvccard_nama` varchar(30) DEFAULT ' ', | |
| `ninvccard_oto` varchar(20) DEFAULT ' ', | |
| `nINVccard_nilai` decimal(15,2) DEFAULT '0.00', | |
| `nINVkembali` decimal(15,2) DEFAULT '0.00', | |
| `serino` varchar(10) DEFAULT NULL, | |
| `xkirim` int(2) DEFAULT '0', | |
| `kunci` int(1) DEFAULT '0', | |
| `oleh` text, | |
| `ninvpoint` decimal(10,0) DEFAULT '0', | |
| `nINVpax` int(4) DEFAULT '0', | |
| `cINVdine` varchar(10) DEFAULT ' ', | |
| `nINVvalue` decimal(15,2) DEFAULT '0.00', | |
| `npostransfer` int(1) DEFAULT '0', | |
| `cINVhadiah` text, | |
| `cinvmeja` varchar(6) DEFAULT ' ', | |
| `cINVfkMOB` varchar(23) DEFAULT ' ', | |
| `nINVpromov` decimal(15,2) DEFAULT '0.00', | |
| `nINVpromod` decimal(15,2) DEFAULT '0.00', | |
| `nINVpromos` decimal(15,2) DEFAULT '0.00', | |
| `cINVsedan` varchar(23) DEFAULT ' ', | |
| `nINVkm` int(10) DEFAULT '0', | |
| `cINVsedancode` varchar(20) DEFAULT ' ', | |
| `niNVpawal` decimal(10,0) DEFAULT '0', | |
| `okirim` int(2) DEFAULT NULL, | |
| `nINVrate` decimal(15,2) DEFAULT '1.00', | |
| `nIVDtime` datetime DEFAULT NULL, | |
| `ninvcetak1` int(2) DEFAULT '0', | |
| `cINVfkKLI` varchar(23) DEFAULT ' ', | |
| `cINVfkPOS` varchar(23) DEFAULT ' ', | |
| `cINVfkCAM` varchar(23) DEFAULT ' ', | |
| `cinvpromog` varchar(250) DEFAULT '', | |
| `nINVwaste` decimal(15,2) DEFAULT '0.00', | |
| `nINVgratis` decimal(15,2) DEFAULT '0.00', | |
| `cinvsj` varchar(20) DEFAULT '', | |
| `dinvtglsj` date DEFAULT NULL, | |
| `ninvpilih` int(1) DEFAULT NULL, | |
| `nINVvalue1` decimal(15,2) DEFAULT '0.00', | |
| `ninvratep` decimal(15,2) DEFAULT '1.00', | |
| `cinvepajak` text, | |
| `ninvpersen` decimal(5,2) DEFAULT '0.00', | |
| `ninvmobile` decimal(15,2) DEFAULT '0.00', | |
| `ninvfg` int(1) DEFAULT '0', | |
| `ninvpo` decimal(15,2) DEFAULT '0.00', | |
| `ninvexpire` int(1) DEFAULT '0', | |
| `ninvapp` int(1) DEFAULT '0', | |
| `ninvzap` int(1) DEFAULT '0', | |
| `cinvlain` varchar(23) DEFAULT '', | |
| `cinvscan1` varchar(50) DEFAULT '', | |
| `cinvscan2` varchar(50) DEFAULT '', | |
| `cinvscan3` varchar(50) DEFAULT '', | |
| `cinvscan4` varchar(50) DEFAULT '', | |
| `ninv12` int(1) DEFAULT '1', | |
| `ninvcanvas` varchar(2) DEFAULT '01', | |
| `cinvtambah` varchar(20) DEFAULT '', | |
| `ninvfee` decimal(15,2) DEFAULT '0.00', | |
| `cinvkode` varchar(2) DEFAULT '04', | |
| `cinvcap` varchar(8) DEFAULT '', | |
| `cinvket` varchar(8) DEFAULT '', | |
| `cinvjasa` varchar(1) DEFAULT 'A', | |
| `ninvtidak` int(1) DEFAULT '0', | |
| `cinvnamapc` varchar(10) DEFAULT '', | |
| `dinvterima` date DEFAULT NULL, | |
| `ninvlog` int(1) DEFAULT '2', | |
| PRIMARY KEY (`cINVpk`), | |
| KEY `cINVfkENT` (`cINVfkENT`) USING BTREE, | |
| KEY `cINVfkSAM` (`cINVfkSAM`) USING BTREE, | |
| KEY `cINVfkWHS` (`cINVfkWHS`) USING BTREE, | |
| KEY `cINVfkEXC` (`cINVfkEXC`) USING BTREE, | |
| KEY `dINVdate` (`dINVdate`) USING BTREE, | |
| KEY `nINVcash` (`nINVcash`) USING BTREE, | |
| KEY `dINVdue` (`dINVdue`) USING BTREE, | |
| KEY `cINVspecial` (`cINVspecial`), | |
| KEY `nINVpaid` (`nINVpaid`), | |
| KEY `cInvTransfer` (`cINVTransfer`), | |
| KEY `cINVfkEntCode` (`cInvFkEntCode`), | |
| KEY `cINVrefno` (`cINVrefno`) USING BTREE, | |
| KEY `serino` (`serino`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='INV'; | |
| -- | |
| -- Dumping data for table `invoice` | |
| -- | |
| /*!40000 ALTER TABLE `invoice` DISABLE KEYS */; | |
| INSERT INTO `invoice` (`cINVrefno`,`dINVdate`,`cINVfkENT`,`cINVfkSAM`,`cINVfkWHS`,`cINVfkEXC`,`nINVcash`,`dINVdue`,`cinvserie`,`cinvtaxinv`,`cinvpo`,`cinvremark`,`nINVdisc1`,`nINVdisc2`,`nINVdisc3`,`nINVdisc`,`nINVtax`,`nINVpaid`,`cINVpk`,`cINVuser`,`cINVspecial`,`cINVTransfer`,`dINVtaxdate`,`nINVfreight`,`cInvFkEntCode`,`nInvOpening`,`cinvremark1`,`cInvReturnto`,`ninvoption`,`ninvcetak`,`nINVdp`,`nINVvoucher`,`nINVtunai`,`nINVpiutang`,`nINVCredit`,`nINVdebit`,`nINVjam`,`ninvno_card`,`ninvjenis_card`,`ninvccard_nama`,`ninvccard_oto`,`nINVccard_nilai`,`nINVkembali`,`serino`,`xkirim`,`kunci`,`oleh`,`ninvpoint`,`nINVpax`,`cINVdine`,`nINVvalue`,`npostransfer`,`cINVhadiah`,`cinvmeja`,`cINVfkMOB`,`nINVpromov`,`nINVpromod`,`nINVpromos`,`cINVsedan`,`nINVkm`,`cINVsedancode`,`niNVpawal`,`okirim`,`nINVrate`,`nIVDtime`,`ninvcetak1`,`cINVfkKLI`,`cINVfkPOS`,`cINVfkCAM`,`cinvpromog`,`nINVwaste`,`nINVgratis`,`cinvsj`,`dinvtglsj`,`ninvpilih`,`nINVvalue1`,`ninvratep`,`cinvepajak`,`ninvpersen`,`ninvmobile`,`ninvfg`,`ninvpo`,`ninvexpire`,`ninvapp`,`ninvzap`,`cinvlain`,`cinvscan1`,`cinvscan2`,`cinvscan3`,`cinvscan4`,`ninv12`,`ninvcanvas`,`cinvtambah`,`ninvfee`,`cinvkode`,`cinvcap`,`cinvket`,`cinvjasa`,`ninvtidak`,`cinvnamapc`,`dinvterima`,`ninvlog`) VALUES | |
| ('0000000501 ','2026-09-18','0sxzr20-TpEcuZOihD2manX','2pzGtT2Av0Es-+JgYR6ti1X','0MjEgB87sNEMjZr7az0FuAX','..rupiah...............',0,'2026-09-28','','','',' ','0.00','0.00','0.00','0.00','11.00',0,'2zSn96EHk8GvRC9NKLdrV0X','tester ','JL','n/a','2026-09-18','0.00','MANDY','0.00','','',1,'0','0.00','0.00','0.00','0.00','0.00','0.00',0,'','','','','0.00','0.00',NULL,0,1,' ','0',0,'','64158000.00',0,'','',' ','0.00','0.00','0.00','',0,'','0',NULL,'1.00',NULL,0,' ',' ',' ','','0.00','0.00','',NULL,0,'0.00','1.00','','0.00','0.00',0,'0.00',0,0,0,'','','','','',1,'01','','0.00','04','','','A',0,'',NULL,2), | |
| ('0000000502 ','2026-09-20','1TLr5okV-GFvD5boAIVA1lX','06UrWbhapcEu-8xNTc9x+QX','2L2QpBF7jhFsQscenboFd+X','2aEaN11e+iHt1D-hIEOAgjX',0,'2026-09-30','','','',' ','0.00','0.00','0.00','0.00','11.00',0,'24w-3hCPsZG-iK0djBdS+VX','tester ','JL','n/a','2026-09-20','0.00','NATALIE','0.00','','',1,'0','0.00','0.00','0.00','0.00','0.00','0.00',0,'','','','','0.00','0.00',NULL,0,1,' ','0',0,'','4648.13',0,'','',' ','0.00','0.00','0.00','',0,'','0',NULL,'16000.00',NULL,0,' ',' ',' ','','0.00','0.00','',NULL,0,'0.00','1.00','','0.00','0.00',0,'0.00',0,0,0,'','','','','',1,'01','','0.00','04','','','A',0,'',NULL,2), | |
| ('0000000503 ','2026-09-22','38SwO4PYukHN6kNHOwxkaRX','3zVBa7wEo4ENpRMj8CsyO4X','1r1w+O8wYVEeQzXWs+heTmX','..rupiah...............',0,'2026-10-02','','','',' ','0.00','0.00','0.00','0.00','11.00',0,'1qZtqJouUIFv0oLfRESAY8X','tester ','JL','n/a','2026-09-22','0.00','MILA','0.00','','',1,'0','0.00','0.00','0.00','0.00','0.00','0.00',0,'','','','','0.00','0.00',NULL,0,1,' ','0',0,'','71928000.00',0,'','',' ','0.00','0.00','0.00','',0,'','0',NULL,'1.00',NULL,0,' ',' ',' ','','0.00','0.00','',NULL,0,'0.00','1.00','','0.00','0.00',0,'0.00',0,0,0,'','','','','',1,'01','','0.00','04','','','A',0,'',NULL,2), | |
| ('0000000504 ','2026-09-24','1Wg8YhIYJJHdE583R+rSZWX','2pzGtT2Av0Es-+JgYR6ti1X','0MjEgB87sNEMjZr7az0FuAX','2aEaN11e+iHt1D-hIEOAgjX',0,'2026-10-04','','','',' ','0.00','0.00','0.00','0.00','11.00',0,'3xuujAuO0AEt8jmF-UknYhX','tester ','JL','n/a','2026-09-24','0.00','JANET','0.00','','',1,'0','0.00','0.00','0.00','0.00','0.00','0.00',0,'','','','','0.00','0.00',NULL,0,1,' ','0',0,'','1803.75',0,'','',' ','0.00','0.00','0.00','',0,'','0',NULL,'16000.00',NULL,0,' ',' ',' ','','0.00','0.00','',NULL,0,'0.00','1.00','','0.00','0.00',0,'0.00',0,0,0,'','','','','',1,'01','','0.00','04','','','A',0,'',NULL,2), | |
| ('0000000505 ','2026-09-26','2Lng1RENk6GNVSptS4tQCSX','06UrWbhapcEu-8xNTc9x+QX','2L2QpBF7jhFsQscenboFd+X','..rupiah...............',0,'2026-10-06','','','',' ','0.00','0.00','0.00','0.00','11.00',0,'3rR7GJGNOEHNARea-msrupX','tester ','JL','n/a','2026-09-26','0.00','EMILY','0.00','','',1,'0','0.00','0.00','0.00','0.00','0.00','0.00',0,'','','','','0.00','0.00',NULL,0,1,' ','0',0,'','87468000.00',0,'','',' ','0.00','0.00','0.00','',0,'','0',NULL,'1.00',NULL,0,' ',' ',' ','','0.00','0.00','',NULL,0,'0.00','1.00','','0.00','0.00',0,'0.00',0,0,0,'','','','','',1,'01','','0.00','04','','','A',0,'',NULL,2), | |
| ('0000000506 ','2026-09-28','0sxzr20-TpEcuZOihD2manX','3zVBa7wEo4ENpRMj8CsyO4X','1r1w+O8wYVEeQzXWs+heTmX','2aEaN11e+iHt1D-hIEOAgjX',0,'2026-10-08','','','',' ','0.00','0.00','0.00','0.00','11.00',0,'1YdexzvyIiF977hPMppeoLX','tester ','JL','n/a','2026-09-28','0.00','MANDY','0.00','','',1,'0','0.00','0.00','0.00','0.00','0.00','0.00',0,'','' |
点赞
收藏
点踩
分享评论
?
参与讨论