-- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 24, 2024 at 06:49 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `ctecomco_htran` -- -- -------------------------------------------------------- -- -- Table structure for table `t_ictmast` -- CREATE TABLE `t_ictmast` ( `ictsno` int(4) NOT NULL auto_increment, `ictict` varchar(40) NOT NULL, `ictdes` varchar(50) default NULL, `ictucdnew` varchar(30) default NULL, `ictentddt` date default NULL, `ictenttime` time default NULL, `ictucdame` varchar(30) default NULL, `ictameddt` date default NULL, `ictametime` time default NULL, PRIMARY KEY (`ictict`), UNIQUE KEY `ictdes` (`ictdes`), KEY `ictsno_2` (`ictsno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `t_ictmast` -- INSERT INTO `t_ictmast` (`ictsno`, `ictict`, `ictdes`, `ictucdnew`, `ictentddt`, `ictenttime`, `ictucdame`, `ictameddt`, `ictametime`) VALUES (2, 'BEV', 'BEV', '2000', '2024-04-20', '17:24:57', NULL, NULL, NULL), (1, 'FOOD', 'FOOD', '2000', '2024-04-20', '17:24:57', NULL, NULL, NULL); -- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 24, 2024 at 06:52 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `ctecomco_htran` -- -- -------------------------------------------------------- -- -- Table structure for table `t_inhtran` -- CREATE TABLE `t_inhtran` ( `inhsno` int(4) NOT NULL auto_increment, `inhcomsno` int(11) NOT NULL default '0', `inhfacsno` int(11) NOT NULL default '0', `inhcussno` int(11) NOT NULL, `inhdispsno` int(11) NOT NULL, `inhtyp` char(2) NOT NULL default '', `inhinvtyp` varchar(20) NOT NULL, `inhisstyp` varchar(8) NOT NULL, `inhdno` varchar(25) NOT NULL default '', `inhdlvddt` date default NULL, `inhrentfrddt` date NOT NULL, `inhrenttoddt` date NOT NULL, `inhdlvtosno` int(6) NOT NULL default '0', `inhtovlcsno` int(11) NOT NULL, `inhporeqsno` int(11) NOT NULL, `inhextrfsno` int(11) NOT NULL, `inhporeqoddnos` varchar(200) NOT NULL, `inhpoqty` int(11) NOT NULL, `inhddt` date default NULL, `inhdes` varchar(100) default NULL, `inhpodtyp` varchar(10) NOT NULL default '', `inhgrntyp` varchar(10) NOT NULL default '', `inhreqtyp` varchar(10) NOT NULL, `inhgrnbulk` varchar(1) NOT NULL, `inhrem` text NOT NULL, `inhmrnno` varchar(20) NOT NULL, `inhaodno` varchar(20) NOT NULL, `inhdepsno` int(11) NOT NULL default '0', `inhagnsno` int(8) NOT NULL default '0', `inhbuysno` int(8) NOT NULL default '0', `inhsupsno` int(4) default NULL, `inhtofacsno` int(11) NOT NULL default '0', `inhfrfacsno` int(8) NOT NULL, `inhfrlocsno` int(11) NOT NULL, `inhtolocsno` int(11) NOT NULL, `inhordsno` int(11) NOT NULL, `inhattention` varchar(40) NOT NULL default '0', `inhourref` varchar(40) NOT NULL default '', `inhourcon` varchar(40) NOT NULL default '', `inhsupinvno` varchar(20) NOT NULL default '', `inhsupdono` varchar(30) NOT NULL, `inhpmttermssno` int(11) NOT NULL, `inhporeqordsno` int(11) NOT NULL, `inhgrnsno` int(11) NOT NULL, `inhisssno` int(11) NOT NULL, `inhfsl` char(1) NOT NULL default '', `inhval` double(10,2) NOT NULL default '0.00', `inhvatpcn` double(5,2) NOT NULL, `inhvatamt` double(12,2) NOT NULL default '0.00', `inhnbtpcn` double(5,2) NOT NULL, `inhnbtamt` double(12,2) NOT NULL, `inhcursno` int(11) NOT NULL default '0', `inhexrate` double(10,4) NOT NULL default '0.0000', `inhreqno` varchar(15) default '0', `inhiffno` varchar(20) NOT NULL, `inhconp` varchar(50) NOT NULL, `inhfalsno` int(11) NOT NULL default '0', `inhcicuspo` varchar(20) NOT NULL default '', `inhciinctm` varchar(20) NOT NULL default '', `inhcifit` varchar(20) NOT NULL default '', `inhcidlvref` varchar(100) NOT NULL default '', `inhcisoa` varchar(10) NOT NULL default '', `inhmobno` varchar(15) NOT NULL, `inhcivsv` varchar(20) NOT NULL default '', `inhcishtfr` varchar(20) NOT NULL default '', `inhcishtto` varchar(20) NOT NULL default '', `inhcimpo` varchar(100) NOT NULL default '', `inhvehno` varchar(15) NOT NULL, `inhdispcn` double(7,2) NOT NULL, `inhdisamt` double(8,2) NOT NULL, `inhdisreason` varchar(25) NOT NULL, `inhlinedisamt` double(10,2) NOT NULL, `inhpromamt` double(10,2) NOT NULL, `inhpromreason` varchar(25) NOT NULL, `inhgiftvamt` double(10,2) NOT NULL, `inhgiftvreason` varchar(25) NOT NULL, `inhothdedamt` double(10,2) NOT NULL, `inhothdedreason` varchar(25) NOT NULL, `inhchqamt` double NOT NULL, `inhcrdamt` double NOT NULL, `inhcashamt` double NOT NULL, `inhccamt1` double NOT NULL, `inhpayamt` double(10,2) NOT NULL, `inhbalamt` double(10,2) NOT NULL, `inhvehpass` varchar(15) NOT NULL, `inhdrvnam` varchar(15) NOT NULL, `inhvehtype` varchar(15) NOT NULL, `inhpayterm` varchar(100) NOT NULL, `inhplhsno` int(11) NOT NULL default '0', `inhacctby` varchar(40) NOT NULL, `inhprtucd` varchar(30) default NULL, `inhprtddt` date default NULL, `inhprttime` time default NULL, `inhgrhsno` int(11) NOT NULL, `inhlocsno` int(11) NOT NULL, `inhpodsno` int(11) NOT NULL, `inhtoagnsno` int(11) NOT NULL, `inhgrhgrh` varchar(25) NOT NULL, `inhlocto` varchar(30) NOT NULL, `inhtypsno` int(3) NOT NULL, `inhfrrentsno` int(8) NOT NULL, `inhtrncnfucd` varchar(15) NOT NULL, `inhtrncnfddt` date NOT NULL, `inhtrncnftime` varchar(10) NOT NULL, `inhsalcnfucd` varchar(15) NOT NULL, `inhsalcnfddt` date NOT NULL, `inhsalcnftime` varchar(10) NOT NULL, `inhgodrecddt` date NOT NULL, `inhpodappucd` varchar(15) NOT NULL, `inhucdnew` varchar(30) default NULL, `inhentddt` date default NULL, `inhenttime` time default NULL, `inhucdame` varchar(30) default NULL, `inhameddt` date default '0000-00-00', `inhametime` time default '00:00:00', `inhamereason` varchar(100) NOT NULL, `inhcanucd` varchar(30) NOT NULL default '', `inhcanddt` date NOT NULL default '0000-00-00', `inhcantime` time NOT NULL default '00:00:00', `inhcanreason` varchar(50) NOT NULL default '', `inhauthucd` varchar(12) NOT NULL, `inhauthddt` date NOT NULL, `inhauthtime` time NOT NULL, `inhauthrem` text NOT NULL, `inhunauthucd` varchar(30) NOT NULL, `inhunauthddt` date NOT NULL, `inhunauthtime` time NOT NULL, `inhunauthrem` text NOT NULL, `inhinvcnfucd` varchar(30) NOT NULL, `inhinvcnfddt` date NOT NULL, `inhinvcnftime` time NOT NULL, `inhgrnpmntconfyn` varchar(1) NOT NULL, `inhgrnpmntconfrem` varchar(50) NOT NULL, `inhgrnpmntconfucd` varchar(12) NOT NULL, `inhgrnpmntconfddt` date NOT NULL, `inhgrnpmntconftime` time NOT NULL, `inhgrnrecddt` date NOT NULL, `printst` varchar(1) NOT NULL, PRIMARY KEY (`inhcomsno`,`inhfacsno`,`inhtyp`,`inhdno`), UNIQUE KEY `inhsno` (`inhsno`), KEY `inhddt` (`inhddt`), KEY `inhtyp` (`inhtyp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `t_inhtran` -- -- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 24, 2024 at 06:52 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `ctecomco_htran` -- -- -------------------------------------------------------- -- -- Table structure for table `t_inltran` -- CREATE TABLE `t_inltran` ( `inlsno` int(4) NOT NULL auto_increment, `inlinhsno` int(4) NOT NULL default '0', `inllno` int(3) NOT NULL default '0', `inloddsno` int(11) NOT NULL, `inloddsnoci` int(11) NOT NULL, `inlordsno` int(6) NOT NULL default '0', `inlmphmph` varchar(30) NOT NULL default '', `inlictsno` int(6) NOT NULL default '0', `inlcnssno` int(6) NOT NULL default '0', `inlpodsno` int(11) NOT NULL default '0', `inlreqsno` int(11) NOT NULL default '0', `inlgrnsno` int(11) NOT NULL, `inlmphsno` int(11) NOT NULL default '0', `inlempsno` int(11) NOT NULL, `inlsctsno` int(11) NOT NULL, `inldes` varchar(130) NOT NULL, `inldes2` varchar(50) NOT NULL, `inlrem` varchar(100) NOT NULL, `inlstksno` int(6) NOT NULL default '0', `inlqty` double(8,2) NOT NULL default '0.00', `inlfreeqty` double(10,2) NOT NULL, `inlisssno` int(11) NOT NULL, `inlinvqty` int(10) NOT NULL, `inlcpr` double(12,5) NOT NULL default '0.00000', `inlavgcpr` double(10,2) NOT NULL, `inlspr` double(10,2) NOT NULL, `inldisamt` double(10,2) NOT NULL, `inlval` double(12,5) NOT NULL default '0.00000', `inlsupinvcpr` double(12,6) NOT NULL, `inluntsno` int(6) NOT NULL default '0', `inlbinno` varchar(15) NOT NULL, `inltrffrqty` double(10,2) NOT NULL, `inltrffrdes` varchar(100) NOT NULL, `inltrftoqty` double(10,2) NOT NULL, `inltrftodes` varchar(100) NOT NULL, `inlfgqltsno` int(11) NOT NULL, `inlsalsno` int(11) NOT NULL, `inlcolour` varchar(100) NOT NULL, `inlcolours` text NOT NULL, `inlsizes` text NOT NULL, `inlcolwseyn` char(1) NOT NULL default '', `inlgrnconfyn` char(1) NOT NULL default '', `inlgrnconfucd` varchar(12) NOT NULL default '', `inlgrnconfddt` date NOT NULL default '0000-00-00', `inlgrnconftime` time NOT NULL default '00:00:00', `inlorgbulkqty` double(12,2) NOT NULL, `inlorgbulksno` int(11) NOT NULL, `inltrfqty` double(12,2) NOT NULL, `inltrforggrnsno` int(11) NOT NULL, `inlictostsno` int(11) NOT NULL, `inlmctsno` int(11) NOT NULL, `inlmacserno` varchar(40) NOT NULL, `inlmaciou` char(1) NOT NULL, `inlmodel` varchar(40) NOT NULL, `inlourserno` varchar(40) NOT NULL, `inlbrdsno` int(4) NOT NULL, `inlref` varchar(50) NOT NULL, `inlcusliaqty` int(11) NOT NULL, `inldstliaqty` int(11) NOT NULL, `inlrentfrddt` date NOT NULL, `inlrenttoddt` date NOT NULL, `inlorgcpr` double(10,2) NOT NULL, `inlfrctn` int(11) default NULL, `inltoctn` int(11) default NULL, `inlcsqty` int(11) default NULL, `inlgrswgt` int(11) default NULL, `inlnetwgt` int(11) default NULL, `inlporeqsupnam` varchar(30) NOT NULL, `inlporeqrem` varchar(200) NOT NULL, `inlucdnew` varchar(30) default NULL, `inlentddt` date default NULL, `inlenttime` time default NULL, `inlucdame` varchar(30) default NULL, `inlameddt` date default NULL, `inlametime` time default NULL, `inldelflg` char(1) NOT NULL default '', PRIMARY KEY (`inlinhsno`,`inllno`), UNIQUE KEY `inlsno` (`inlsno`), KEY `inlcnssno` (`inlcnssno`), KEY `inlpodsno` (`inlpodsno`), KEY `inlreqsno` (`inlreqsno`), KEY `inlmctsno` (`inlmctsno`,`inlmacserno`,`inlmodel`,`inlourserno`,`inlbrdsno`), KEY `inlmacserno` (`inlmacserno`), KEY `inlstksno` (`inlstksno`), KEY `inlfgqltsno` (`inlfgqltsno`), KEY `inloddsno` (`inloddsno`,`inlordsno`), KEY `inlordsno` (`inlordsno`,`inluntsno`), KEY `inlinhsno` (`inlinhsno`,`inloddsno`,`inlfgqltsno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `t_inltran` -- -- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 24, 2024 at 06:53 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `ctecomco_htran` -- -- -------------------------------------------------------- -- -- Table structure for table `t_stkmast` -- CREATE TABLE `t_stkmast` ( `stksno` int(4) NOT NULL auto_increment, `stkstk` varchar(60) NOT NULL default '', `stkdes` varchar(60) default NULL, `stkdes2` varchar(60) default NULL, `stkcpr` double(9,2) default '0.00', `stkopcpr` double(9,2) default NULL, `stkspr` double(9,2) default NULL, `stkpurprice` double default NULL, `stkictsno` int(12) default NULL, `stksctsno` int(12) default NULL, `stkigpsno` int(11) NOT NULL, `stkuntsno` int(12) default NULL, `stkdisqty` int(11) NOT NULL, `stkdisreducedprice` double(10,2) NOT NULL, `stkostcpr` double(12,2) default '0.00', `stkavgcpr` double(12,2) default '0.00', `stkuntconvrate` int(11) default NULL, `stkvatyn` char(1) default NULL, `stklastavgcpr` double(10,2) default NULL, `stklastavgqty` double(10,2) default NULL, `stklastavgddt` date default NULL, `stklastavgtime` time default NULL, `stkucdnew` varchar(30) default NULL, `stkentddt` date default NULL, `stkenttime` time default NULL, `stkucdame` varchar(30) default NULL, `stkameddt` date default '0000-00-00', `stkametime` time default '00:00:00', PRIMARY KEY (`stkstk`), UNIQUE KEY `stksno` (`stksno`), UNIQUE KEY `stkdes` (`stkdes`), KEY `stkcatdes` (`stkictsno`,`stkdes`), KEY `stkstk` (`stkstk`,`stkdes`), KEY `stksno_2` (`stksno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ; -- -- Dumping data for table `t_stkmast` -- INSERT INTO `t_stkmast` (`stksno`, `stkstk`, `stkdes`, `stkdes2`, `stkcpr`, `stkopcpr`, `stkspr`, `stkpurprice`, `stkictsno`, `stksctsno`, `stkigpsno`, `stkuntsno`, `stkdisqty`, `stkdisreducedprice`, `stkostcpr`, `stkavgcpr`, `stkuntconvrate`, `stkvatyn`, `stklastavgcpr`, `stklastavgqty`, `stklastavgddt`, `stklastavgtime`, `stkucdnew`, `stkentddt`, `stkenttime`, `stkucdame`, `stkameddt`, `stkametime`) VALUES (1, '01', 'CHICKEN KOTTU', NULL, 0.00, NULL, 350.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (2, '02', 'CHICKEN SAUSAGES', NULL, 0.00, NULL, 200.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (3, '03', 'FISH CHINES ROLL', NULL, 0.00, NULL, 50.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (4, '04', 'FRENCH FRIES', NULL, 0.00, NULL, 300.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (5, '05', 'HOT DOG BUN', NULL, 0.00, NULL, 150.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (6, '06', 'VEGE KOTTU', NULL, 0.00, NULL, 300.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (7, '07', 'DEVILLED CHICKEN', NULL, 0.00, NULL, 350.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (8, '08', 'PORK STEW', NULL, 0.00, NULL, 400.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (9, '09', 'DEVILLED FISH', NULL, 0.00, NULL, 350.00, NULL, 1, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (10, '40', 'VAT 69', NULL, 0.00, NULL, 17100.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (11, '41', 'OLD KEG', NULL, 0.00, NULL, 7100.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (12, '42', 'V & A', NULL, 0.00, NULL, 6600.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (13, '43', 'GALERIE', NULL, 0.00, NULL, 6800.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (14, '44', 'RITZ', NULL, 0.00, NULL, 6500.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (15, '45', 'FRANKLINE', NULL, 0.00, NULL, 6200.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (16, '46', 'ASCOT PINK GIN', NULL, 0.00, NULL, 7500.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (17, '47', 'ROCKLAND DRY GIN', NULL, 0.00, NULL, 7300.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (18, '48', 'ROCKLAND LEMON GIN', NULL, 0.00, NULL, 7300.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (19, '49', 'ASCOT  DRY GIN', NULL, 0.00, NULL, 7100.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (20, '50', 'ASCOT LEMON GIN', NULL, 0.00, NULL, 7100.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (21, '51', 'SMIRNOFF RED', NULL, 0.00, NULL, 13200.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (22, '52', 'ERISTOFF', NULL, 0.00, NULL, 6600.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (23, '53', 'CELEBRATION', NULL, 0.00, NULL, 6500.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (24, '54', 'PETROFF VODKA', NULL, 0.00, NULL, 5700.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (25, '55', 'BACARDI', NULL, 0.00, NULL, 7800.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (26, '56', 'ROCKLAND WHITE RUM', NULL, 0.00, NULL, 7600.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (27, '57', 'ROCKLAND DARK RUM', NULL, 0.00, NULL, 7600.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (28, '58', 'BACARDI BLACK', NULL, 0.00, NULL, 7400.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (29, '59', 'VAT 09', NULL, 0.00, NULL, 6900.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (30, '60', 'OLD RESERVE', NULL, 0.00, NULL, 6300.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (31, '61', 'ROCKLAND OLD', NULL, 0.00, NULL, 5400.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (32, '62', 'DCSL OLD', NULL, 0.00, NULL, 5300.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (33, '63', 'DOUBLE DISTRILED', NULL, 0.00, NULL, 5300.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (34, '64', 'BLACK OPEL', NULL, 0.00, NULL, 5000.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (35, '65', 'IDL W/D GREEN APPLE', NULL, 0.00, NULL, 4900.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (36, '66', 'RED WINE ', NULL, 0.00, NULL, 5100.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (37, '67', 'WHITE WINE', NULL, 0.00, NULL, 5100.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (38, '68', 'LION STOUT', NULL, 0.00, NULL, 900.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (39, '69', 'CARLS. SPECIAL BREW', NULL, 0.00, NULL, 900.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (40, '70', 'STRONG BEER', NULL, 0.00, NULL, 880.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (41, '71', 'CARLSBERG', NULL, 0.00, NULL, 780.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (42, '72', 'LION LAGER', NULL, 0.00, NULL, 680.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (43, '73', 'COCA COLA 300 ML', NULL, 0.00, NULL, 250.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (44, '74', 'SPRITE 300 ML', NULL, 0.00, NULL, 250.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (45, '75', 'TONIC 400 ML', NULL, 0.00, NULL, 260.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (46, '76', 'GINGER ALE 400 ML', NULL, 0.00, NULL, 260.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (47, '77', 'CREAM SODA 400 ML', NULL, 0.00, NULL, 260.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (48, '78', 'GINGER BEER 400 ML', NULL, 0.00, NULL, 280.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (49, '79', 'LEMONAD 400 ML', NULL, 0.00, NULL, 260.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (50, '80', 'SODA 400 ML', NULL, 0.00, NULL, 200.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (51, '81', 'COCA COLA 1000 ML', NULL, 0.00, NULL, 450.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (52, '82', 'SPRITE  1000 ML', NULL, 0.00, NULL, 450.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (53, '83', 'SODA 1500 ML', NULL, 0.00, NULL, 420.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'), (54, '84', 'WATER 1000 ML ', NULL, 0.00, NULL, 200.00, NULL, 2, 0, 0, 4, 0, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, '2000', '2024-07-24', '17:02:59', NULL, '0000-00-00', '00:00:00'); -- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 24, 2024 at 06:53 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `ctecomco_htran` -- -- -------------------------------------------------------- -- -- Table structure for table `t_stpmast` -- CREATE TABLE `t_stpmast` ( `stpsno` int(4) NOT NULL auto_increment, `stpstksno` int(11) NOT NULL, `stpddt` date NOT NULL default '0000-00-00', `stpcpr` double(9,2) default '0.00', `stpspr` double(9,2) NOT NULL default '0.00', `stpucdnew` varchar(30) default NULL, `stpentddt` date default NULL, `stpenttime` time default NULL, `stpucdame` varchar(30) default NULL, `stpameddt` date default '0000-00-00', `stpametime` time default '00:00:00', PRIMARY KEY (`stpstksno`,`stpddt`,`stpspr`), UNIQUE KEY `stpsno` (`stpsno`), KEY `stpcatdes` (`stpddt`), KEY `stpstp` (`stpstksno`,`stpddt`), KEY `stpsno_2` (`stpsno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `t_stpmast` --