invoice	CREATE TABLE `invoice` (
  `idx` int(11) NOT NULL auto_increment,
  `InvoiceNo` varchar(30) default NULL,
  `InvoiceStatus` varchar(30) default NULL,
  `Period` varchar(30) default NULL,
  `SourceBilling` varchar(30) default NULL,
  `InvoiceDate` date default NULL,
  `InvoiceType` varchar(30) default NULL,
  `SourceID` varchar(30) default NULL,
  `SystemEntryDate` datetime default NULL,
  `CustomerID` varchar(30) default NULL,
  `TaxPayable` varchar(30) default NULL,
  `NetTotal` varchar(30) default NULL,
  `GrossTotal` varchar(30) default NULL,
  PRIMARY KEY  (`idx`),
  UNIQUE KEY `index1` (`InvoiceNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1	;
