- <ROOT>
- <row>
  <field name="Name">banktrans</field> 
  <field name="Engine">MyISAM</field> 
  <field name="Version">10</field> 
  <field name="Row_format">Dynamic</field> 
  <field name="Rows">19055</field> 
  <field name="Avg_row_length">111</field> 
  <field name="Data_length">2131980</field> 
  <field name="Max_data_length">281474976710655</field> 
  <field name="Index_length">1436672</field> 
  <field name="Data_free">92</field> 
  <field name="Auto_increment">19065</field> 
  <field name="Create_time">2006-04-04 00:01:32</field> 
  <field name="Update_time">2006-04-04 00:39:43</field> 
  <field name="Check_time">2006-04-04 00:01:33</field> 
  <field name="Collation">latin1_swedish_ci</field> 
  <Checksum /> 
  <field name="Create_options" /> 
  <field name="Comment" /> 
  </row>
  </ROOT>



CREATE TABLE `banktrans` (
  `AUTONUM` int(11) NOT NULL auto_increment,
  `BANK_ACCOUNT` varchar(10) NOT NULL default '',
  `TRAFILENUM` int(11) NOT NULL default '0',
  `SELECTED` char(1) NOT NULL default '',
  `DATE` date NOT NULL default '0000-00-00',
  `TRANS_TYPE` char(1) NOT NULL default '',
  `OUR_CHK_NO` int(11) NOT NULL default '0',
  `DEPOSIT_NO` int(11) NOT NULL default '0',
  `oldU_TRANO` int(11) NOT NULL default '0',
  `FITID` varchar(12) NOT NULL default '',
  `PAYEE_ID` varchar(10) NOT NULL default '',
  `NAME` varchar(30) NOT NULL default '',
  `BANK_CAT` varchar(15) NOT NULL default '',
  `AMOUNT` decimal(13,2) NOT NULL default '0.00',
  `ORIG_AMOUNT` decimal(11,2) NOT NULL default '0.00',
  `BALANCE` decimal(11,2) NOT NULL default '0.00',
  `BAL_EST` char(1) NOT NULL default '',
  `BOUNCED_DEP` int(11) NOT NULL default '0',
  `CLIENT_NO` varchar(10) NOT NULL default '',
  `STAT` char(1) NOT NULL default '',
  `POSTED` char(1) NOT NULL default '',
  `OPENDATE` date default '0000-00-00',
  `OPENDEPNO` int(11) NOT NULL default '0',
  `OPENCHKNO` int(11) NOT NULL default '0',
  `OPENMISC` date default '0000-00-00',
  `DATE_ENTERED` date default '0000-00-00',
  `TIME_ENTERED` time default '00:00:00',
  `DATE_CHANGED` date default '0000-00-00',
  `TIME_CHANGED` time default '00:00:00',
  `TRANS_NUMBER` int(11) NOT NULL default '0',
  `PAYMENT` decimal(11,2) NOT NULL default '0.00',
  `DEPOSIT` decimal(11,2) NOT NULL default '0.00',
  `CR_BATCH` int(11) NOT NULL default '0',
  `CD_BATCH` int(11) NOT NULL default '0',
  `RECON_BATCH` int(11) NOT NULL default '0',
  `DATECLEARED` date default '0000-00-00',
  `VerisignSilentPostBack` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`AUTONUM`),
  KEY `DEPOSIT_KEY` (`BANK_ACCOUNT`,`DEPOSIT_NO`),
  KEY `OUR_CHK_KEY` (`BANK_ACCOUNT`,`OUR_CHK_NO`),
  KEY `CR_BAT_KEY` (`BANK_ACCOUNT`,`CR_BATCH`),
  KEY `DATE_KEY` (`BANK_ACCOUNT`,`DATE`,`AUTONUM`),
  KEY `CD_BAT_KEY` (`BANK_ACCOUNT`,`CD_BATCH`),
  KEY `BANK_CAT_KEY` (`BANK_ACCOUNT`,`BANK_CAT`,`DATE`,`AUTONUM`),
  KEY `SELECT_KEY` (`BANK_ACCOUNT`,`SELECTED`),
  KEY `POSTED_KEY` (`BANK_ACCOUNT`,`POSTED`,`DATE`,`AUTONUM`),
  KEY `PAYEE_KEY` (`BANK_ACCOUNT`,`PAYEE_ID`,`DATE`,`AUTONUM`),
  KEY `byFitid` (`FITID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1