-- MySQL dump 10.11
--
-- Host: 178.1.0.202    Database: mbf
-- ------------------------------------------------------
-- 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: `mbf`
--

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

USE `mbf`;

--
-- Table structure for table `address`
--

DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `objType` smallint(6) NOT NULL default '0',
  `ownerCode` varchar(15) NOT NULL default '',
  `addrCode` varchar(10) NOT NULL default '',
  `addrTypeCode` varchar(10) NOT NULL default '',
  `dscription` varchar(255) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `city` varchar(100) NOT NULL default '',
  `state` varchar(100) NOT NULL default '',
  `zipCode` varchar(5) NOT NULL default '',
  `cntctPrsn` varchar(100) default NULL,
  `BpCustId` varchar(15) default NULL,
  PRIMARY KEY  (`objType`,`ownerCode`,`addrCode`,`addrTypeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (0,'1','1','1','1','1','1','1','1',NULL,NULL);
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `addrtype`
--

DROP TABLE IF EXISTS `addrtype`;
CREATE TABLE `addrtype` (
  `addrTypeCode` varchar(10) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  `objType` char(2) default NULL,
  `auditDate` datetime default NULL,
  `auditUser` varchar(10) default NULL,
  `backupSts` char(1) default NULL,
  PRIMARY KEY  (`addrTypeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `addrtype`
--

LOCK TABLES `addrtype` WRITE;
/*!40000 ALTER TABLE `addrtype` DISABLE KEYS */;
INSERT INTO `addrtype` VALUES ('1','1','1','0000-00-00 00:00:00','1','1');
/*!40000 ALTER TABLE `addrtype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `custmrCode` varchar(15) NOT NULL default '',
  `custmrName` varchar(100) NOT NULL default '',
  `notes` varchar(100) NOT NULL default '',
  `balance` double(19,6) NOT NULL default '0.000000',
  `dNotesBal` double(19,6) default '0.000000',
  `ordersBal` double(19,6) NOT NULL default '0.000000',
  `goodsissuesBal` double(19,6) default '0.000000',
  `credLimit` double(19,6) NOT NULL default '0.000000',
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `termCode` char(3) NOT NULL default '',
  `discCode` char(1) NOT NULL default '',
  `whsCode` varchar(8) NOT NULL default '',
  `locked` char(1) NOT NULL default 'N',
  `priceCode` varchar(8) NOT NULL default '',
  `objType` smallint(6) NOT NULL default '13',
  `regDate` date NOT NULL default '0000-00-00',
  `taxInSameMonth` char(1) NOT NULL default 'N',
  `incTax` char(1) NOT NULL default 'N',
  `grpOltTypeCode` char(2) NOT NULL default '',
  `bpCustId` varchar(10) NOT NULL default '',
  `pkpSts` char(1) NOT NULL default 'N',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `custmrcodeprn` varchar(15) default NULL,
  `salessts` char(1) default 'Y',
  PRIMARY KEY  (`custmrCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES ('1','1','1',0.000000,0.000000,0.000000,0.000000,0.000000,'1','1','1','1','1','N','1',13,'0000-00-00','N','N','','','N','2009-02-09 09:23:03','','N',NULL,'Y');
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custoptinfo`
--

DROP TABLE IF EXISTS `custoptinfo`;
CREATE TABLE `custoptinfo` (
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `dscription` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`,`optDtlCode`,`objType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `custoptinfo`
--

LOCK TABLES `custoptinfo` WRITE;
/*!40000 ALTER TABLE `custoptinfo` DISABLE KEYS */;
INSERT INTO `custoptinfo` VALUES ('1','1',0,'1');
/*!40000 ALTER TABLE `custoptinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custoptsett`
--

DROP TABLE IF EXISTS `custoptsett`;
CREATE TABLE `custoptsett` (
  `optionalCode` varchar(10) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `custoptsett`
--

LOCK TABLES `custoptsett` WRITE;
/*!40000 ALTER TABLE `custoptsett` DISABLE KEYS */;
INSERT INTO `custoptsett` VALUES ('1','1');
/*!40000 ALTER TABLE `custoptsett` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custoptsettdetail1`
--

DROP TABLE IF EXISTS `custoptsettdetail1`;
CREATE TABLE `custoptsettdetail1` (
  `optionalCode` char(10) NOT NULL default '',
  `ownerCode` char(20) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `optDtlCode` char(10) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`,`ownerCode`,`objType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `custoptsettdetail1`
--

LOCK TABLES `custoptsettdetail1` WRITE;
/*!40000 ALTER TABLE `custoptsettdetail1` DISABLE KEYS */;
INSERT INTO `custoptsettdetail1` VALUES ('1','1',0,'1');
/*!40000 ALTER TABLE `custoptsettdetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delivery`
--

DROP TABLE IF EXISTS `delivery`;
CREATE TABLE `delivery` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `whsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `shipToCode` varchar(10) NOT NULL default '',
  `billToCode` varchar(10) NOT NULL default '',
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `taxPercent` double(19,6) NOT NULL default '0.000000',
  `totalAmount` double(19,6) NOT NULL default '0.000000',
  `discAmount` double(19,6) NOT NULL default '0.000000',
  `bfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `taxAmount` double(19,6) NOT NULL default '0.000000',
  `aftTaxAmount` double(19,6) NOT NULL default '0.000000',
  `pkpSts` char(1) NOT NULL default '',
  `npwpNo` varchar(20) NOT NULL default '',
  `npwpDate` date default NULL,
  `receiptNo` varchar(25) NOT NULL default '',
  `discSumP1` double(19,6) NOT NULL default '0.000000',
  `discSumP2` double(19,6) NOT NULL default '0.000000',
  `discSumP3` double(19,6) NOT NULL default '0.000000',
  `paidToDate` double(19,6) NOT NULL default '0.000000',
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '27',
  `termCode` char(3) NOT NULL default '',
  `printCounter` int(4) default NULL,
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `taxReport` double(19,6) NOT NULL default '0.000000',
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNum` (`docNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delivery`
--

LOCK TABLES `delivery` WRITE;
/*!40000 ALTER TABLE `delivery` DISABLE KEYS */;
/*!40000 ALTER TABLE `delivery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deliverydetail1`
--

DROP TABLE IF EXISTS `deliverydetail1`;
CREATE TABLE `deliverydetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default '0',
  `baseEntry` int(11) default '0',
  `baseLine` int(11) default '0',
  `lineStatus` char(1) NOT NULL default '',
  `itemCode` varchar(20) NOT NULL default '',
  `dscription` varchar(100) NOT NULL default '',
  `quantity` decimal(9,0) NOT NULL default '0',
  `shipDate` date default NULL,
  `openQty` decimal(9,0) NOT NULL default '0',
  `cost` decimal(9,0) NOT NULL default '0',
  `price` decimal(9,0) NOT NULL default '0',
  `discPrcnt1` double(9,6) NOT NULL default '0.000000',
  `discPrcnt2` double(9,6) NOT NULL default '0.000000',
  `discPrcnt3` double(9,6) NOT NULL default '0.000000',
  `isItemBns` char(1) NOT NULL default '',
  `lineTotal` decimal(9,0) NOT NULL default '0',
  `openSum` decimal(9,0) NOT NULL default '0',
  `whsCode` varchar(8) NOT NULL default '',
  `docDate` date default NULL,
  `baseDocNum` int(11) default '0',
  `visOrder` int(11) default '0',
  `backOrdr` char(1) default NULL,
  `pickStatus` char(1) default NULL,
  `pickIdNo` int(11) default '0',
  `baseQty` decimal(9,0) default '0',
  `baseOpnQty` decimal(9,0) default '0',
  `objType` smallint(2) NOT NULL default '0',
  `pickQty` decimal(9,0) default '0',
  `backupSts` char(1) NOT NULL default 'N',
  `priceCode` varchar(10) default NULL,
  PRIMARY KEY  (`docEntry`,`lineNum`),
  KEY `baseEntry` (`baseEntry`,`baseLine`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `deliverydetail1`
--

LOCK TABLES `deliverydetail1` WRITE;
/*!40000 ALTER TABLE `deliverydetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `deliverydetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsissue`
--

DROP TABLE IF EXISTS `goodsissue`;
CREATE TABLE `goodsissue` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `whsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `ShipToCode` varchar(8) NOT NULL default '',
  `TaxPercent` double(19,6) default NULL,
  `BfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `TaxAmount` double(19,6) default NULL,
  `AftTaxAmount` double(19,6) default NULL,
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '35',
  `auditDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `TranType` char(1) default NULL,
  `backupSts` char(1) NOT NULL default 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goodsissue`
--

LOCK TABLES `goodsissue` WRITE;
/*!40000 ALTER TABLE `goodsissue` DISABLE KEYS */;
/*!40000 ALTER TABLE `goodsissue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsissuedetail1`
--

DROP TABLE IF EXISTS `goodsissuedetail1`;
CREATE TABLE `goodsissuedetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default '-1',
  `baseEntry` int(11) default '0',
  `baseLine` int(11) default '0',
  `lineStatus` char(1) NOT NULL default 'O',
  `itemCode` varchar(20) NOT NULL default '',
  `quantity` decimal(9,0) NOT NULL default '0',
  `openQty` decimal(9,0) NOT NULL default '0',
  `cost` decimal(9,0) NOT NULL default '0',
  `price` decimal(9,0) NOT NULL default '0',
  `isItemBns` char(1) NOT NULL default 'N',
  `lineTotal` decimal(9,0) NOT NULL default '0',
  `whsCode` varchar(8) NOT NULL default '',
  `baseDocNum` int(11) default '0',
  `visOrder` int(11) default '0',
  `backOrdr` char(1) default 'N',
  `pickStatus` char(1) default 'N',
  `pickIdNo` int(11) default '0',
  `baseQty` decimal(9,0) default '0',
  `baseOpnQty` decimal(9,0) default '0',
  `objType` smallint(2) default '35',
  `pickQty` decimal(9,0) default '0',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`docEntry`,`lineNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goodsissuedetail1`
--

LOCK TABLES `goodsissuedetail1` WRITE;
/*!40000 ALTER TABLE `goodsissuedetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `goodsissuedetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsreceipt`
--

DROP TABLE IF EXISTS `goodsreceipt`;
CREATE TABLE `goodsreceipt` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date default NULL,
  `docDueDate` date default NULL,
  `priceCode` varchar(8) default NULL,
  `custmrCode` varchar(15) default NULL,
  `shipToCode` varchar(8) default NULL,
  `docTotal` double(19,6) NOT NULL default '0.000000',
  `ref1` varchar(30) default NULL,
  `ref2` varchar(30) default NULL,
  `comments` varchar(255) default NULL,
  `objType` smallint(2) NOT NULL default '36',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `TranType` char(1) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `TaxPercent` double(19,6) NOT NULL default '0.000000',
  `BfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `TaxAmount` double(19,6) NOT NULL default '0.000000',
  `AftTaxAmount` double(19,6) NOT NULL default '0.000000',
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNum` (`docNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goodsreceipt`
--

LOCK TABLES `goodsreceipt` WRITE;
/*!40000 ALTER TABLE `goodsreceipt` DISABLE KEYS */;
/*!40000 ALTER TABLE `goodsreceipt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsreceiptdetail1`
--

DROP TABLE IF EXISTS `goodsreceiptdetail1`;
CREATE TABLE `goodsreceiptdetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default '-1',
  `baseType` int(11) default NULL,
  `baseEntry` int(11) default NULL,
  `baseLine` int(11) default NULL,
  `itemCode` varchar(20) NOT NULL default '',
  `quantity` double(19,6) NOT NULL default '0.000000',
  `openQty` double(19,6) NOT NULL default '0.000000',
  `cost` double(19,6) NOT NULL default '0.000000',
  `price` double(19,6) NOT NULL default '0.000000',
  `lineTotal` double(19,6) NOT NULL default '0.000000',
  `whsCode` varchar(8) NOT NULL default '',
  `visOrder` int(11) default NULL,
  `pickIdNo` int(11) default NULL,
  `baseQty` double(19,6) default NULL,
  `baseOpnQty` double(19,6) default NULL,
  `objType` smallint(2) NOT NULL default '36',
  `pickQty` double(19,6) default NULL,
  `backupSts` char(1) NOT NULL default 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goodsreceiptdetail1`
--

LOCK TABLES `goodsreceiptdetail1` WRITE;
/*!40000 ALTER TABLE `goodsreceiptdetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `goodsreceiptdetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodstransfer`
--

DROP TABLE IF EXISTS `goodstransfer`;
CREATE TABLE `goodstransfer` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `FrWhsCode` varchar(8) default NULL,
  `ToWhsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `ShipToCode` varchar(8) NOT NULL default '',
  `TaxPercent` double(19,6) default NULL,
  `BfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `TaxAmount` double(19,6) default NULL,
  `AftTaxAmount` double(19,6) default NULL,
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '35',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `TranType` char(1) default NULL,
  `backupSts` char(1) NOT NULL default 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goodstransfer`
--

LOCK TABLES `goodstransfer` WRITE;
/*!40000 ALTER TABLE `goodstransfer` DISABLE KEYS */;
/*!40000 ALTER TABLE `goodstransfer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodstransferdetail1`
--

DROP TABLE IF EXISTS `goodstransferdetail1`;
CREATE TABLE `goodstransferdetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default '-1',
  `baseEntry` int(11) default '0',
  `baseLine` int(11) default '0',
  `lineStatus` char(1) NOT NULL default 'O',
  `itemCode` varchar(20) NOT NULL default '',
  `quantity` decimal(9,0) NOT NULL default '0',
  `openQty` decimal(9,0) NOT NULL default '0',
  `cost` decimal(9,0) NOT NULL default '0',
  `price` decimal(9,0) NOT NULL default '0',
  `isItemBns` char(1) NOT NULL default 'N',
  `lineTotal` decimal(9,0) NOT NULL default '0',
  `ToWhsCode` varchar(8) default NULL,
  `FrWhsCode` varchar(8) NOT NULL default '',
  `baseDocNum` int(11) default '0',
  `visOrder` int(11) default '0',
  `backOrdr` char(1) default 'N',
  `pickStatus` char(1) default 'N',
  `pickIdNo` int(4) default '0',
  `baseQty` decimal(9,0) default '0',
  `baseOpnQty` decimal(9,0) default '0',
  `objType` smallint(2) default '35',
  `pickQty` decimal(9,0) default '0',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`docEntry`,`lineNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goodstransferdetail1`
--

LOCK TABLES `goodstransferdetail1` WRITE;
/*!40000 ALTER TABLE `goodstransferdetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `goodstransferdetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_stockopname`
--

DROP TABLE IF EXISTS `inv_stockopname`;
CREATE TABLE `inv_stockopname` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) default NULL,
  `docdate` datetime default NULL,
  `custmrCodeFr` varchar(10) default NULL,
  `custmrCodeTo` varchar(10) default NULL,
  `docDueDateFr` date default NULL,
  `docDueDateTo` date default NULL,
  `docNumFr` int(11) default NULL,
  `docNumTo` int(11) default NULL,
  `optionalCode` varchar(10) default NULL,
  `optDetailCodeFr` varchar(10) default NULL,
  `optDetailCodeTo` varchar(10) default NULL,
  `ref1` varchar(30) default NULL,
  `ref2` varchar(30) default NULL,
  `comments` varchar(30) default NULL,
  `transDate` datetime default NULL,
  `auditDate` datetime default NULL,
  `auditUser` varchar(10) default NULL,
  `objType` smallint(2) default NULL,
  `backupSts` char(1) default NULL,
  PRIMARY KEY  (`docEntry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inv_stockopname`
--

LOCK TABLES `inv_stockopname` WRITE;
/*!40000 ALTER TABLE `inv_stockopname` DISABLE KEYS */;
/*!40000 ALTER TABLE `inv_stockopname` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inv_stockopnamedetail1`
--

DROP TABLE IF EXISTS `inv_stockopnamedetail1`;
CREATE TABLE `inv_stockopnamedetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `lineStatus` char(1) default 'O',
  `docNum` int(15) default NULL,
  `status` char(1) default '0',
  `note` varchar(25) default NULL,
  `auditDate` datetime default NULL,
  `auditUser` varchar(10) default NULL,
  `objType` smallint(2) default '99',
  `backupSts` char(1) default 'N',
  PRIMARY KEY  (`docEntry`,`lineNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `inv_stockopnamedetail1`
--

LOCK TABLES `inv_stockopnamedetail1` WRITE;
/*!40000 ALTER TABLE `inv_stockopnamedetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `inv_stockopnamedetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inventory`
--

DROP TABLE IF EXISTS `inventory`;
CREATE TABLE `inventory` (
  `itemCode` varchar(20) NOT NULL default '',
  `whsCode` varchar(8) NOT NULL default '',
  `location` varchar(8) NOT NULL default '',
  `onHand` double(19,6) NOT NULL default '0.000000',
  `isCommited` double(19,6) NOT NULL default '0.000000',
  `consig` double(19,6) NOT NULL default '0.000000',
  `onOrder` double(19,6) NOT NULL default '0.000000',
  `counted` double(19,6) NOT NULL default '0.000000',
  `wasCounted` char(1) NOT NULL default 'N',
  `trackDate` date NOT NULL default '0000-00-00',
  `minStock` double(19,6) NOT NULL default '0.000000',
  `maxStock` double(19,6) NOT NULL default '0.000000',
  `minOrder` double(19,6) NOT NULL default '0.000000',
  `reOrderQty` decimal(19,6) NOT NULL default '0.000000',
  `locked` char(1) NOT NULL default 'N',
  `auditDate` timestamp NULL default CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`itemCode`,`whsCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`
--

LOCK TABLES `inventory` WRITE;
/*!40000 ALTER TABLE `inventory` DISABLE KEYS */;
INSERT INTO `inventory` VALUES ('1','1','1',0.000000,0.000000,0.000000,0.000000,0.000000,'N','0000-00-00',0.000000,0.000000,0.000000,'0.000000','N','2009-02-09 09:23:56','','N');
/*!40000 ALTER TABLE `inventory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice`
--

DROP TABLE IF EXISTS `invoice`;
CREATE TABLE `invoice` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `whsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `shipToCode` varchar(10) NOT NULL default '',
  `billToCode` varchar(10) NOT NULL default '',
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `taxPercent` double(19,6) NOT NULL default '0.000000',
  `totalAmount` double(19,6) NOT NULL default '0.000000',
  `discAmount` double(19,6) NOT NULL default '0.000000',
  `bfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `taxAmount` double(19,6) NOT NULL default '0.000000',
  `aftTaxAmount` double(19,6) NOT NULL default '0.000000',
  `pkpSts` char(1) NOT NULL default '',
  `npwpNo` varchar(20) NOT NULL default '',
  `npwpDate` date default NULL,
  `receiptNo` varchar(25) NOT NULL default '',
  `discSumP1` double(19,6) NOT NULL default '0.000000',
  `discSumP2` double(19,6) NOT NULL default '0.000000',
  `discSumP3` double(19,6) NOT NULL default '0.000000',
  `paidToDate` double(19,6) NOT NULL default '0.000000',
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '27',
  `termCode` char(3) NOT NULL default '',
  `payment` double(9,0) default NULL,
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `taxReport` double(19,6) NOT NULL default '0.000000',
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNum` (`docNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice`
--

LOCK TABLES `invoice` WRITE;
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
INSERT INTO `invoice` VALUES (0,0,'N','O','0000-00-00','0000-00-00','1','1','1','1','1','1','1',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'1','1','0000-00-00','1',0.000000,0.000000,0.000000,0.000000,'1','1','1',27,'',NULL,'2009-02-09 09:24:55','','N',0.000000);
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoicedetail1`
--

DROP TABLE IF EXISTS `invoicedetail1`;
CREATE TABLE `invoicedetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default '0',
  `baseEntry` int(11) default '0',
  `baseLine` int(11) default '0',
  `lineStatus` char(1) NOT NULL default '',
  `itemCode` varchar(20) NOT NULL default '',
  `dscription` varchar(100) NOT NULL default '',
  `quantity` decimal(9,0) NOT NULL default '0',
  `shipDate` date default NULL,
  `openQty` decimal(9,0) NOT NULL default '0',
  `cost` decimal(9,0) NOT NULL default '0',
  `price` decimal(9,0) NOT NULL default '0',
  `discPrcnt1` double(9,6) NOT NULL default '0.000000',
  `discPrcnt2` double(9,6) NOT NULL default '0.000000',
  `discPrcnt3` double(9,6) NOT NULL default '0.000000',
  `isItemBns` char(1) NOT NULL default '',
  `lineTotal` decimal(9,0) NOT NULL default '0',
  `openSum` decimal(9,0) NOT NULL default '0',
  `whsCode` varchar(8) NOT NULL default '',
  `docDate` date default NULL,
  `baseDocNum` int(11) default '0',
  `visOrder` int(11) default '0',
  `backOrdr` char(1) default NULL,
  `pickStatus` char(1) default NULL,
  `pickIdNo` int(11) default '0',
  `baseQty` decimal(9,0) default '0',
  `baseOpnQty` decimal(9,0) default '0',
  `objType` smallint(2) NOT NULL default '0',
  `pickQty` decimal(9,0) default '0',
  `backupSts` char(1) NOT NULL default 'N',
  `priceCode` varchar(10) default NULL,
  PRIMARY KEY  (`docEntry`,`lineNum`),
  KEY `baseEntry` (`baseEntry`,`baseLine`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoicedetail1`
--

LOCK TABLES `invoicedetail1` WRITE;
/*!40000 ALTER TABLE `invoicedetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoicedetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `itemCode` varchar(20) NOT NULL default '',
  `dscription` varchar(100) NOT NULL default '',
  `LatinName` varchar(100) default NULL,
  `SinonimName` longtext,
  `UomName` varchar(20) default NULL,
  `NamaProses` varchar(100) default NULL,
  `codeBars` varchar(20) default NULL,
  `mnfctrCode` char(2) NOT NULL default '',
  `salesItem` char(1) NOT NULL default '',
  `purchItem` char(1) NOT NULL default '',
  `returnItem` char(1) NOT NULL default '',
  `classCode` char(2) NOT NULL default '',
  `uom1` double(19,6) NOT NULL default '0.000000',
  `uom2` double(19,6) NOT NULL default '0.000000',
  `uom3` double(19,6) NOT NULL default '0.000000',
  `length` double(19,6) NOT NULL default '0.000000',
  `length1` double(19,6) NOT NULL default '0.000000',
  `width` double(19,6) NOT NULL default '0.000000',
  `width1` double(19,6) NOT NULL default '0.000000',
  `height` double(19,6) NOT NULL default '0.000000',
  `height1` double(19,6) NOT NULL default '0.000000',
  `weight1` double(19,6) default NULL,
  `weight2` double(19,6) default NULL,
  `lstSalDate` date default NULL,
  `lstPurDate` date default NULL,
  `regDate` date default NULL,
  `locked` char(1) NOT NULL default '',
  `objType` smallint(6) NOT NULL default '6',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`itemCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item`
--

LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` VALUES ('1','1',NULL,NULL,NULL,NULL,'1','1','1','1','1','1',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,NULL,NULL,NULL,NULL,NULL,'',6,'2009-02-09 09:26:39','','N');
/*!40000 ALTER TABLE `item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemdiscount`
--

DROP TABLE IF EXISTS `itemdiscount`;
CREATE TABLE `itemdiscount` (
  `itemCode` varchar(20) NOT NULL default '',
  `discCode` char(2) NOT NULL default '',
  `discount` double(19,6) NOT NULL default '0.000000',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`itemCode`,`discCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemdiscount`
--

LOCK TABLES `itemdiscount` WRITE;
/*!40000 ALTER TABLE `itemdiscount` DISABLE KEYS */;
INSERT INTO `itemdiscount` VALUES ('','',0.000000,'2009-02-09 09:26:06','','N'),('1','1',0.000000,'2009-02-09 09:26:06','1','N'),('1','2',0.000000,'2009-02-09 09:27:40','1','N');
/*!40000 ALTER TABLE `itemdiscount` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemoptdetail1`
--

DROP TABLE IF EXISTS `itemoptdetail1`;
CREATE TABLE `itemoptdetail1` (
  `optionalCode` varchar(10) NOT NULL default '',
  `ownerCode` varchar(10) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `optDtlCode` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`,`ownerCode`,`objType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptdetail1`
--

LOCK TABLES `itemoptdetail1` WRITE;
/*!40000 ALTER TABLE `itemoptdetail1` DISABLE KEYS */;
INSERT INTO `itemoptdetail1` VALUES ('1','1',0,'1'),('1','2',0,'3');
/*!40000 ALTER TABLE `itemoptdetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemoptdisc`
--

DROP TABLE IF EXISTS `itemoptdisc`;
CREATE TABLE `itemoptdisc` (
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `discCode` char(2) NOT NULL default '',
  `discount` double(19,6) NOT NULL default '0.000000',
  `auditDate` datetime default NULL,
  `auditUser` varchar(10) default NULL,
  PRIMARY KEY  (`optionalCode`,`optDtlCode`,`objType`,`discCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptdisc`
--

LOCK TABLES `itemoptdisc` WRITE;
/*!40000 ALTER TABLE `itemoptdisc` DISABLE KEYS */;
INSERT INTO `itemoptdisc` VALUES ('1','1',0,'1',0.000000,NULL,'1');
/*!40000 ALTER TABLE `itemoptdisc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemoptionalinfo`
--

DROP TABLE IF EXISTS `itemoptionalinfo`;
CREATE TABLE `itemoptionalinfo` (
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `dscription` varchar(50) NOT NULL default '',
  `priority` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`optionalCode`,`optDtlCode`,`objType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptionalinfo`
--

LOCK TABLES `itemoptionalinfo` WRITE;
/*!40000 ALTER TABLE `itemoptionalinfo` DISABLE KEYS */;
INSERT INTO `itemoptionalinfo` VALUES ('1','1',0,'1',0);
/*!40000 ALTER TABLE `itemoptionalinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemoptsett`
--

DROP TABLE IF EXISTS `itemoptsett`;
CREATE TABLE `itemoptsett` (
  `optionalCode` varchar(10) NOT NULL default '',
  `dscription` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptsett`
--

LOCK TABLES `itemoptsett` WRITE;
/*!40000 ALTER TABLE `itemoptsett` DISABLE KEYS */;
INSERT INTO `itemoptsett` VALUES ('1','1');
/*!40000 ALTER TABLE `itemoptsett` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemprice`
--

DROP TABLE IF EXISTS `itemprice`;
CREATE TABLE `itemprice` (
  `itemCode` varchar(20) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `price` decimal(19,6) default '0.000000',
  `currentPrice` char(1) default 'Y',
  `startDate` date default NULL,
  `endDate` date default NULL,
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) default 'N',
  PRIMARY KEY  (`itemCode`,`priceCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemprice`
--

LOCK TABLES `itemprice` WRITE;
/*!40000 ALTER TABLE `itemprice` DISABLE KEYS */;
INSERT INTO `itemprice` VALUES ('1','1','0.000000','Y',NULL,NULL,'2009-02-09 09:31:26','1','N');
/*!40000 ALTER TABLE `itemprice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemprice_tmp`
--

DROP TABLE IF EXISTS `itemprice_tmp`;
CREATE TABLE `itemprice_tmp` (
  `itemCode` varchar(20) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `price` decimal(19,6) default '0.000000',
  `currentPrice` char(1) default 'Y',
  `startDate` date default NULL,
  `endDate` date default NULL,
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) default 'N',
  PRIMARY KEY  (`itemCode`,`priceCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemprice_tmp`
--

LOCK TABLES `itemprice_tmp` WRITE;
/*!40000 ALTER TABLE `itemprice_tmp` DISABLE KEYS */;
/*!40000 ALTER TABLE `itemprice_tmp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itempricehistory`
--

DROP TABLE IF EXISTS `itempricehistory`;
CREATE TABLE `itempricehistory` (
  `yop` int(11) NOT NULL default '0',
  `mop` int(11) NOT NULL default '0',
  `priceCode` varchar(8) NOT NULL default '',
  `itemCode` varchar(20) NOT NULL default '',
  `price` decimal(19,6) default '0.000000',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) default 'N',
  PRIMARY KEY  (`yop`,`mop`,`priceCode`,`itemCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itempricehistory`
--

LOCK TABLES `itempricehistory` WRITE;
/*!40000 ALTER TABLE `itempricehistory` DISABLE KEYS */;
INSERT INTO `itempricehistory` VALUES (0,0,'1','1','0.000000','2009-02-09 09:31:58','1','N');
/*!40000 ALTER TABLE `itempricehistory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itempricehistorybackup`
--

DROP TABLE IF EXISTS `itempricehistorybackup`;
CREATE TABLE `itempricehistorybackup` (
  `yop` int(11) NOT NULL default '0',
  `mop` int(11) NOT NULL default '0',
  `priceCode` varchar(8) NOT NULL default '',
  `itemCode` varchar(20) NOT NULL default '',
  `price` decimal(19,6) default '0.000000',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) default 'N',
  PRIMARY KEY  (`yop`,`mop`,`priceCode`,`itemCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itempricehistorybackup`
--

LOCK TABLES `itempricehistorybackup` WRITE;
/*!40000 ALTER TABLE `itempricehistorybackup` DISABLE KEYS */;
/*!40000 ALTER TABLE `itempricehistorybackup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemstockbalance`
--

DROP TABLE IF EXISTS `itemstockbalance`;
CREATE TABLE `itemstockbalance` (
  `yop` int(11) default NULL,
  `mop` int(11) default NULL,
  `whsCode` varchar(5) default NULL,
  `itemCode` varchar(15) default NULL,
  `onHand` int(11) default NULL,
  `auditDate` datetime default NULL,
  `auditUser` varchar(10) default NULL,
  `objType` smallint(2) default NULL,
  `backupSts` char(1) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemstockbalance`
--

LOCK TABLES `itemstockbalance` WRITE;
/*!40000 ALTER TABLE `itemstockbalance` DISABLE KEYS */;
INSERT INTO `itemstockbalance` VALUES (1,1,'1','1',1,'0000-00-00 00:00:00','1',1,'1');
/*!40000 ALTER TABLE `itemstockbalance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemsupplier`
--

DROP TABLE IF EXISTS `itemsupplier`;
CREATE TABLE `itemsupplier` (
  `itemCode` varchar(20) NOT NULL default '',
  `suppCode` varchar(15) NOT NULL default '',
  `priority` int(4) NOT NULL default '0',
  `active` char(1) NOT NULL default 'Y',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`itemCode`,`suppCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemsupplier`
--

LOCK TABLES `itemsupplier` WRITE;
/*!40000 ALTER TABLE `itemsupplier` DISABLE KEYS */;
INSERT INTO `itemsupplier` VALUES ('1','1',0,'Y','2009-02-09 09:55:58','1','N');
/*!40000 ALTER TABLE `itemsupplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phone`
--

DROP TABLE IF EXISTS `phone`;
CREATE TABLE `phone` (
  `ownerCode` varchar(15) NOT NULL default '',
  `addrCode` varchar(10) NOT NULL default '',
  `addrTypeCode` varchar(10) NOT NULL default '',
  `phoneTypeCode` char(2) NOT NULL default '',
  `phone` varchar(25) NOT NULL default '',
  `objType` smallint(6) NOT NULL default '0',
  `auditDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backSts` char(1) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phone`
--

LOCK TABLES `phone` WRITE;
/*!40000 ALTER TABLE `phone` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phonetype`
--

DROP TABLE IF EXISTS `phonetype`;
CREATE TABLE `phonetype` (
  `phoneTypeCode` varchar(10) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  `objType` char(2) default NULL,
  `auditDate` datetime default NULL,
  `auditUser` varchar(8) default NULL,
  `backupSts` char(1) default NULL,
  PRIMARY KEY  (`phoneTypeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phonetype`
--

LOCK TABLES `phonetype` WRITE;
/*!40000 ALTER TABLE `phonetype` DISABLE KEYS */;
/*!40000 ALTER TABLE `phonetype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `preference`
--

DROP TABLE IF EXISTS `preference`;
CREATE TABLE `preference` (
  `cmpnyID` varchar(20) NOT NULL default '',
  `cmpnyName` varchar(100) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `city` varchar(100) default NULL,
  `state` varchar(100) default NULL,
  `zipCode` varchar(8) default NULL,
  `phone1` varchar(20) default NULL,
  `phone2` varchar(20) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(50) default NULL,
  `manager` varchar(50) default NULL,
  `faSpv` varchar(50) default NULL,
  `edpo` varchar(50) default NULL,
  `npwpNumber` varchar(50) default NULL,
  `pkpDate` date default NULL,
  `ordrDocNum` int(5) NOT NULL default '0',
  `dlvrDocNum` int(5) NOT NULL default '0',
  `rtrnDocNum` int(5) NOT NULL default '0',
  `invDocNum` int(5) NOT NULL default '0',
  `poDocNum` int(5) NOT NULL default '0',
  `pRcvDocNum` int(5) NOT NULL default '0',
  `pRtrDocNum` int(5) NOT NULL default '0',
  `trnfDocNum` int(5) NOT NULL default '0',
  `gIssDocNum` int(5) NOT NULL default '0',
  `gRcvDocNum` int(5) NOT NULL default '0',
  `crmmDocNum` int(5) NOT NULL default '0',
  `pymtDocNum` int(5) NOT NULL default '0',
  `registerNum` int(5) NOT NULL default '0',
  `consignDocNum` int(5) NOT NULL default '0',
  `seri1` varchar(5) default NULL,
  `seri2` char(3) default NULL,
  `lstMnthPrc` date default '0000-00-00',
  `lstMnthPrAR` date default '0000-00-00',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `penetDocNum` int(5) NOT NULL default '0',
  `taxDt1Month` char(1) default 'N',
  `logServices` char(1) default 'N',
  `headOffice` char(1) default NULL,
  `custmrCode` varchar(15) default NULL,
  `backOrder` char(1) NOT NULL default 'N',
  `haveDepo` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`cmpnyID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `preference`
--

LOCK TABLES `preference` WRITE;
/*!40000 ALTER TABLE `preference` DISABLE KEYS */;
/*!40000 ALTER TABLE `preference` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `price`
--

DROP TABLE IF EXISTS `price`;
CREATE TABLE `price` (
  `priceCode` varchar(8) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  `factor` double(19,6) NOT NULL default '0.000000',
  `objType` smallint(2) NOT NULL default '10',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`priceCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `price`
--

LOCK TABLES `price` WRITE;
/*!40000 ALTER TABLE `price` DISABLE KEYS */;
/*!40000 ALTER TABLE `price` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pricehistory`
--

DROP TABLE IF EXISTS `pricehistory`;
CREATE TABLE `pricehistory` (
  `bulan` int(2) NOT NULL default '0',
  `tahun` int(4) NOT NULL default '0',
  `itemCode` varchar(40) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `price` double(18,0) NOT NULL default '0',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`bulan`,`tahun`,`itemCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pricehistory`
--

LOCK TABLES `pricehistory` WRITE;
/*!40000 ALTER TABLE `pricehistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `pricehistory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchaseorder`
--

DROP TABLE IF EXISTS `purchaseorder`;
CREATE TABLE `purchaseorder` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `whsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `shipToCode` varchar(10) default NULL,
  `billToCode` varchar(10) default NULL,
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `taxPercent` double(19,6) NOT NULL default '0.000000',
  `discSumP1` double(19,6) NOT NULL default '0.000000',
  `discSumP2` double(19,6) NOT NULL default '0.000000',
  `discSumP3` double(19,6) NOT NULL default '0.000000',
  `totalAmount` double(19,6) NOT NULL default '0.000000',
  `discAmount` double(19,6) NOT NULL default '0.000000',
  `bfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `taxAmount` double(19,6) NOT NULL default '0.000000',
  `aftTaxAmount` double(19,6) NOT NULL default '0.000000',
  `pkpSts` char(1) NOT NULL default '',
  `npwpNo` varchar(20) NOT NULL default '',
  `npwpDate` date default NULL,
  `paidToDate` double(19,6) NOT NULL default '0.000000',
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `receiptNo` varchar(25) default NULL,
  `objType` smallint(2) default '32',
  `termCode` char(3) NOT NULL default '',
  `payment` double(9,0) NOT NULL default '0',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `taxReport` double(19,6) default NULL,
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNum` (`docNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchaseorder`
--

LOCK TABLES `purchaseorder` WRITE;
/*!40000 ALTER TABLE `purchaseorder` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchaseorder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchaseorderdetail1`
--

DROP TABLE IF EXISTS `purchaseorderdetail1`;
CREATE TABLE `purchaseorderdetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default NULL,
  `baseEntry` int(11) default NULL,
  `baseLine` int(11) default NULL,
  `lineStatus` char(1) default NULL,
  `itemCode` varchar(20) NOT NULL default '',
  `quantity` double(19,6) NOT NULL default '0.000000',
  `openQty` double(19,6) NOT NULL default '0.000000',
  `cost` double(19,6) NOT NULL default '0.000000',
  `price` double(19,6) NOT NULL default '0.000000',
  `discPrcnt1` double(19,6) NOT NULL default '0.000000',
  `discPrcnt2` double(19,6) NOT NULL default '0.000000',
  `discPrcnt3` double(19,6) NOT NULL default '0.000000',
  `isItemBns` char(1) NOT NULL default 'N',
  `lineTotal` double(19,6) NOT NULL default '0.000000',
  `whsCode` varchar(8) NOT NULL default '',
  `baseDocNum` int(11) default NULL,
  `visOrder` int(11) default NULL,
  `baseQty` double(19,6) default NULL,
  `baseOpnQty` double(19,6) default NULL,
  `objType` smallint(2) default '27',
  `pickQty` double(19,6) default NULL,
  `backupSts` char(1) NOT NULL default 'N',
  `priceCode` varchar(10) default 'HJP'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchaseorderdetail1`
--

LOCK TABLES `purchaseorderdetail1` WRITE;
/*!40000 ALTER TABLE `purchaseorderdetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchaseorderdetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchasereceive`
--

DROP TABLE IF EXISTS `purchasereceive`;
CREATE TABLE `purchasereceive` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `whsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `shipToCode` varchar(10) NOT NULL default '',
  `billToCode` varchar(10) NOT NULL default '',
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `taxPercent` double(19,6) NOT NULL default '0.000000',
  `discSumP1` double(19,6) NOT NULL default '0.000000',
  `discSumP2` double(19,6) NOT NULL default '0.000000',
  `discSumP3` double(19,6) NOT NULL default '0.000000',
  `totalAmount` double(19,6) NOT NULL default '0.000000',
  `discAmount` double(19,6) NOT NULL default '0.000000',
  `bfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `taxAmount` double(19,6) NOT NULL default '0.000000',
  `aftTaxAmount` double(19,6) NOT NULL default '0.000000',
  `pkpSts` char(1) NOT NULL default '',
  `npwpNo` varchar(20) NOT NULL default '',
  `npwpDate` date default NULL,
  `paidToDate` double(19,6) NOT NULL default '0.000000',
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `receiptNo` varchar(25) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '32',
  `termCode` char(3) NOT NULL default '',
  `payment` double(9,0) NOT NULL default '0',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `taxReport` double(19,6) default NULL,
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNum` (`docNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasereceive`
--

LOCK TABLES `purchasereceive` WRITE;
/*!40000 ALTER TABLE `purchasereceive` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchasereceive` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchasereceivedetail1`
--

DROP TABLE IF EXISTS `purchasereceivedetail1`;
CREATE TABLE `purchasereceivedetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default NULL,
  `baseEntry` int(11) default NULL,
  `baseLine` int(11) default NULL,
  `lineStatus` char(1) default NULL,
  `itemCode` varchar(20) NOT NULL default '',
  `quantity` double(19,6) NOT NULL default '0.000000',
  `openQty` double(19,6) NOT NULL default '0.000000',
  `cost` double(19,6) NOT NULL default '0.000000',
  `price` double(19,6) NOT NULL default '0.000000',
  `discPrcnt1` double(19,6) NOT NULL default '0.000000',
  `discPrcnt2` double(19,6) NOT NULL default '0.000000',
  `discPrcnt3` double(19,6) NOT NULL default '0.000000',
  `isItemBns` char(1) NOT NULL default 'N',
  `lineTotal` double(19,6) NOT NULL default '0.000000',
  `whsCode` varchar(8) NOT NULL default '',
  `baseDocNum` int(11) default NULL,
  `visOrder` int(11) default NULL,
  `baseQty` double(19,6) default NULL,
  `baseOpnQty` double(19,6) default NULL,
  `objType` smallint(2) default '27',
  `pickQty` double(19,6) default NULL,
  `backupSts` char(1) NOT NULL default 'N',
  `priceCode` varchar(10) default 'HJP'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasereceivedetail1`
--

LOCK TABLES `purchasereceivedetail1` WRITE;
/*!40000 ALTER TABLE `purchasereceivedetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchasereceivedetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchasereturn`
--

DROP TABLE IF EXISTS `purchasereturn`;
CREATE TABLE `purchasereturn` (
  `docEntry` int(11) NOT NULL default '0',
  `docNum` int(11) NOT NULL default '0',
  `printed` char(1) NOT NULL default 'N',
  `docStatus` char(1) NOT NULL default 'O',
  `docDate` date NOT NULL default '0000-00-00',
  `docDueDate` date NOT NULL default '0000-00-00',
  `whsCode` varchar(8) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `custmrCode` varchar(15) NOT NULL default '',
  `shipToCode` varchar(10) NOT NULL default '',
  `billToCode` varchar(10) NOT NULL default '',
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `taxPercent` double(19,6) NOT NULL default '0.000000',
  `discSumP1` double(19,6) NOT NULL default '0.000000',
  `discSumP2` double(19,6) NOT NULL default '0.000000',
  `discSumP3` double(19,6) NOT NULL default '0.000000',
  `totalAmount` double(19,6) NOT NULL default '0.000000',
  `discAmount` double(19,6) NOT NULL default '0.000000',
  `bfrTaxAmount` double(19,6) NOT NULL default '0.000000',
  `taxAmount` double(19,6) NOT NULL default '0.000000',
  `aftTaxAmount` double(19,6) NOT NULL default '0.000000',
  `pkpSts` char(1) NOT NULL default '',
  `npwpNo` varchar(20) NOT NULL default '',
  `npwpDate` date default NULL,
  `paidToDate` double(19,6) NOT NULL default '0.000000',
  `ref1` varchar(30) NOT NULL default '',
  `ref2` varchar(30) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `receiptNo` varchar(25) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '27',
  `termCode` char(3) NOT NULL default '',
  `payment` double(9,0) NOT NULL default '0',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `taxReport` double(19,6) default NULL,
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNum` (`docNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasereturn`
--

LOCK TABLES `purchasereturn` WRITE;
/*!40000 ALTER TABLE `purchasereturn` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchasereturn` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchasereturndetail1`
--

DROP TABLE IF EXISTS `purchasereturndetail1`;
CREATE TABLE `purchasereturndetail1` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `baseRef` varchar(30) default NULL,
  `baseType` int(11) default NULL,
  `baseEntry` int(11) default NULL,
  `baseLine` int(11) default NULL,
  `lineStatus` char(1) default NULL,
  `itemCode` varchar(20) NOT NULL default '',
  `quantity` double(19,6) NOT NULL default '0.000000',
  `openQty` double(19,6) NOT NULL default '0.000000',
  `cost` double(19,6) NOT NULL default '0.000000',
  `price` double(19,6) NOT NULL default '0.000000',
  `discPrcnt1` double(19,6) NOT NULL default '0.000000',
  `discPrcnt2` double(19,6) NOT NULL default '0.000000',
  `discPrcnt3` double(19,6) NOT NULL default '0.000000',
  `isItemBns` char(1) NOT NULL default 'N',
  `lineTotal` double(19,6) NOT NULL default '0.000000',
  `whsCode` varchar(8) NOT NULL default '',
  `baseDocNum` int(11) default NULL,
  `visOrder` int(11) default NULL,
  `baseQty` double(19,6) default NULL,
  `baseOpnQty` double(19,6) default NULL,
  `objType` smallint(2) default '27',
  `pickQty` double(19,6) default NULL,
  `backupSts` char(1) NOT NULL default 'N',
  `priceCode` varchar(10) default 'HJP'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasereturndetail1`
--

LOCK TABLES `purchasereturndetail1` WRITE;
/*!40000 ALTER TABLE `purchasereturndetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchasereturndetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `supplier`
--

DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
  `suppCode` varchar(15) NOT NULL default '',
  `suppName` varchar(100) NOT NULL default '',
  `termCode` char(3) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `notes` varchar(100) NOT NULL default '',
  `locked` char(1) NOT NULL default 'N',
  `destType` char(1) NOT NULL default '',
  `serverNMDest` varchar(35) NOT NULL default '',
  `databaseNMDest` varchar(35) NOT NULL default '',
  `uid` varchar(20) NOT NULL default '',
  `pwd` varchar(20) NOT NULL default '',
  `balance` double(19,6) NOT NULL default '0.000000',
  `dNotesBal` double(19,6) NOT NULL default '0.000000',
  `ordersBal` double(19,6) NOT NULL default '0.000000',
  `credLimit` double(19,6) NOT NULL default '0.000000',
  `taxInSameMonth` char(1) NOT NULL default 'Y',
  `incTax` char(1) NOT NULL default 'Y',
  `objType` smallint(2) NOT NULL default '0',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`suppCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier`
--

LOCK TABLES `supplier` WRITE;
/*!40000 ALTER TABLE `supplier` DISABLE KEYS */;
INSERT INTO `supplier` VALUES ('1','1','1','1','1','N','1','1','1','1','1',0.000000,0.000000,0.000000,0.000000,'Y','Y',0,'2009-02-09 09:56:16','','N');
/*!40000 ALTER TABLE `supplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxnoreg`
--

DROP TABLE IF EXISTS `taxnoreg`;
CREATE TABLE `taxnoreg` (
  `docEntry` smallint(4) NOT NULL default '0',
  `docNo` varchar(20) NOT NULL default '',
  `docDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ref1` varchar(50) default NULL,
  `ref2` varchar(50) default NULL,
  `dscription` varchar(50) NOT NULL default '',
  `fromNo` int(11) default NULL,
  `toNo` int(11) default NULL,
  `noCounted` int(11) default NULL,
  `noUsed` int(11) default NULL,
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `docStatus` char(1) NOT NULL default 'O',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`docEntry`),
  UNIQUE KEY `docNo` (`docNo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxnoreg`
--

LOCK TABLES `taxnoreg` WRITE;
/*!40000 ALTER TABLE `taxnoreg` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxnoreg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxnoregdetail1`
--

DROP TABLE IF EXISTS `taxnoregdetail1`;
CREATE TABLE `taxnoregdetail1` (
  `docEntry` int(9) NOT NULL default '0',
  `lineNum` int(9) NOT NULL default '0',
  `noseri` varchar(10) default NULL,
  `docNum` int(9) NOT NULL default '0',
  `objType` int(11) default NULL,
  `NPWPNumber` varchar(20) default NULL,
  `taxDate` date NOT NULL default '0000-00-00',
  `kodeSeri` varchar(10) default NULL,
  `kodeSts` int(4) default NULL,
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`docEntry`,`lineNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxnoregdetail1`
--

LOCK TABLES `taxnoregdetail1` WRITE;
/*!40000 ALTER TABLE `taxnoregdetail1` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxnoregdetail1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxnoregdetail1_repair`
--

DROP TABLE IF EXISTS `taxnoregdetail1_repair`;
CREATE TABLE `taxnoregdetail1_repair` (
  `docEntry` int(11) NOT NULL default '0',
  `lineNum` int(11) NOT NULL default '0',
  `docNum` int(11) default NULL,
  `npwpNumber` varchar(255) default NULL,
  `taxDate` date default NULL,
  PRIMARY KEY  (`docEntry`,`lineNum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxnoregdetail1_repair`
--

LOCK TABLES `taxnoregdetail1_repair` WRITE;
/*!40000 ALTER TABLE `taxnoregdetail1_repair` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxnoregdetail1_repair` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxnoregdetail1_tmp`
--

DROP TABLE IF EXISTS `taxnoregdetail1_tmp`;
CREATE TABLE `taxnoregdetail1_tmp` (
  `docEntry` int(9) NOT NULL default '0',
  `lineNum` int(9) NOT NULL default '0',
  `noseri` varchar(10) default NULL,
  `docNum` int(9) NOT NULL default '0',
  `objType` int(11) default NULL,
  `NPWPNumber` varchar(20) default NULL,
  `taxDate` date NOT NULL default '0000-00-00',
  `kodeSeri` varchar(10) default NULL,
  `kodeSts` int(4) default NULL,
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`docEntry`,`lineNum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxnoregdetail1_tmp`
--

LOCK TABLES `taxnoregdetail1_tmp` WRITE;
/*!40000 ALTER TABLE `taxnoregdetail1_tmp` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxnoregdetail1_tmp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxnoregdetail2`
--

DROP TABLE IF EXISTS `taxnoregdetail2`;
CREATE TABLE `taxnoregdetail2` (
  `docentry` int(11) NOT NULL default '0',
  `linenum` int(11) NOT NULL default '0',
  `docnum` int(11) NOT NULL default '0',
  `status` varchar(25) default NULL,
  PRIMARY KEY  (`docentry`,`linenum`,`docnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxnoregdetail2`
--

LOCK TABLES `taxnoregdetail2` WRITE;
/*!40000 ALTER TABLE `taxnoregdetail2` DISABLE KEYS */;
/*!40000 ALTER TABLE `taxnoregdetail2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehouse`
--

DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
  `whsCode` varchar(8) NOT NULL default '',
  `dscription` varchar(100) NOT NULL default '',
  `whsType` char(1) NOT NULL default '',
  `locked` char(1) NOT NULL default 'N',
  `checkOnHand` char(1) default 'N',
  `objType` smallint(2) NOT NULL default '0',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`whsCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warehouse`
--

LOCK TABLES `warehouse` WRITE;
/*!40000 ALTER TABLE `warehouse` DISABLE KEYS */;
INSERT INTO `warehouse` VALUES ('1','1','1','N','N',0,'2009-02-09 09:56:31','1','N');
/*!40000 ALTER TABLE `warehouse` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehousetype`
--

DROP TABLE IF EXISTS `warehousetype`;
CREATE TABLE `warehousetype` (
  `whsType` char(1) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '25',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `altWhsType` char(1) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `checkOnHand` char(1) NOT NULL default 'Y',
  PRIMARY KEY  (`whsType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warehousetype`
--

LOCK TABLES `warehousetype` WRITE;
/*!40000 ALTER TABLE `warehousetype` DISABLE KEYS */;
INSERT INTO `warehousetype` VALUES ('1','1',25,'2009-02-09 09:56:44','1','1','N','Y');
/*!40000 ALTER TABLE `warehousetype` 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:21:47