invoiceline	CREATE TABLE `invoiceline` (
  `idx` int(11) NOT NULL auto_increment,
  `InvoiceNo` varchar(30) default NULL,
  `LineNumber` varchar(30) default NULL,
  `ProductCode` varchar(30) default NULL,
  `ProductDescription` varchar(30) default NULL,
  `Quantity` varchar(30) default NULL,
  `UnitOfMeasure` varchar(30) default NULL,
  `UnitPrice` varchar(30) default NULL,
  `TaxPointDate` varchar(30) default NULL,
  `Description` varchar(30) default NULL,
  `CreditAmount` varchar(30) default NULL,
  `TaxType` varchar(30) default NULL,
  `TaxCountryRegion` varchar(30) default NULL,
  `TaxCode` varchar(30) default NULL,
  `TaxPercentage` varchar(30) default NULL,
  `SettlementAmount` varchar(30) default NULL,
  `OriginatingON` varchar(30) default NULL,
  `OrderDate` varchar(30) default NULL,
  `DebitAmount` varchar(30) default NULL,
  `TaxExemptionReason` varchar(30) default NULL,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `index1` (`InvoiceNo`,`LineNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1	;
