# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 25, 2008 at 07:55 PM
# Server version: 4.0.15
# PHP Version: 4.3.3
#
# Database : `cosy`
#

# --------------------------------------------------------

#
# Table structure for table `cpl`
#
# Creation: Mar 28, 2008 at 11:43 PM
# Last update: Apr 10, 2008 at 06:46 PM
#

DROP TABLE IF EXISTS `cpl`;
CREATE TABLE `cpl` (
`cpl_id` int(10) NOT NULL auto_increment,
`cpl_code` varchar(10) NOT NULL default '',
`cpl_description` varchar(30) NOT NULL default '',
`cpl_remark` varchar(30) NOT NULL default '',
`cpl_prn` char(1) NOT NULL default '',
`cpl_valid` char(1) NOT NULL default '',
`cpl_subtot` float NOT NULL default '0',
`cpl_creusr` varchar(10) NOT NULL default '',
`cpl_creda` datetime NOT NULL default '0000-00-00 00:00:00',
`cpl_updusr` varchar(10) NOT NULL default '',
`cpl_updda` datetime NOT NULL default '0000-00-00 00:00:00',
UNIQUE KEY `cpl_id` (`cpl_id`,`cpl_code`),
UNIQUE KEY `cpl_code` (`cpl_code`)
) TYPE=MyISAM COMMENT='costplace' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `inv`
#
# Creation: Apr 24, 2008 at 02:29 PM
# Last update: Apr 25, 2008 at 11:53 AM
#

DROP TABLE IF EXISTS `inv`;
CREATE TABLE `inv` (
`inv_id` int(10) NOT NULL auto_increment,
`sup_id` int(11) NOT NULL default '0',
`inv_description` varchar(30) NOT NULL default '',
`inv_amount` float NOT NULL default '0',
`inv_currency` varchar(5) NOT NULL default '',
`inv_bkamount` float(16,4) NOT NULL default '0.0000',
`inv_decr` char(1) NOT NULL default '',
`inv_docseq` varchar(10) NOT NULL default '',
`inv_docdate` date NOT NULL default '0000-00-00',
`inv_remark` varchar(10) NOT NULL default '',
`inv_prn` char(1) NOT NULL default '',
`inv_creusr` varchar(10) NOT NULL default '',
`inv_creda` datetime NOT NULL default '0000-00-00 00:00:00',
`inv_updusr` varchar(10) NOT NULL default '',
`inv_updda` datetime NOT NULL default '0000-00-00 00:00:00',
`inv_ok` char(1) NOT NULL default '',
UNIQUE KEY `inv_id` (`inv_id`)
) TYPE=MyISAM COMMENT='Incoming invoices' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `ixc`
#
# Creation: Apr 25, 2008 at 02:45 PM
# Last update: Apr 25, 2008 at 02:45 PM
#

DROP TABLE IF EXISTS `ixc`;
CREATE TABLE `ixc` (
`ixc_id` int(11) NOT NULL auto_increment,
`inv_id` int(11) NOT NULL default '0',
`ixc_year` varchar(4) NOT NULL default '',
`ixc_amount` float(16,4) NOT NULL default '0.0000',
`cpl_code` varchar(10) NOT NULL default '',
`ixc_remark` varchar(80) NOT NULL default '',
`ixc_creusr` varchar(10) NOT NULL default '',
`ixc_creda` datetime NOT NULL default '0000-00-00 00:00:00',
`ixc_updusr` varchar(10) NOT NULL default '',
`ixc_updda` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ixc_id`)
) TYPE=MyISAM COMMENT='invoiceamount assigned to costcenter' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `sup`
#
# Creation: Apr 01, 2008 at 11:34 PM
# Last update: Apr 01, 2008 at 11:35 PM
#

DROP TABLE IF EXISTS `sup`;
CREATE TABLE `sup` (
`sup_id` int(10) NOT NULL auto_increment,
`sup_name` varchar(30) NOT NULL default '',
`sup_description` varchar(30) NOT NULL default '',
`sup_lastcurrency` varchar(5) NOT NULL default '',
`sup_subcount` int(10) NOT NULL default '0',
`adr_id` varchar(10) NOT NULL default '',
`sup_extid` varchar(10) NOT NULL default '',
`sup_lastcpl` varchar(10) NOT NULL default '',
`sup_mostcpl` varchar(10) NOT NULL default '',
`sup_creusr` varchar(10) NOT NULL default '',
`sup_creda` datetime NOT NULL default '0000-00-00 00:00:00',
`sup_updusr` varchar(10) NOT NULL default '',
`sup_updda` datetime NOT NULL default '0000-00-00 00:00:00',
`sup_prn` char(1) NOT NULL default '',
UNIQUE KEY `sup_id` (`sup_id`)
) TYPE=MyISAM COMMENT='Supplier Invoice data' AUTO_INCREMENT=1 ;