CREATE TABLE `po_accounts` ( `AccountName` varchar(50) DEFAULT NULL, `AccountType` varchar(50) DEFAULT NULL, `AccountSubType` varchar(50) DEFAULT NULL, `Description` varchar(50) DEFAULT NULL, `Classification` varchar(50) DEFAULT NULL, `TPName` varchar(50) DEFAULT NULL, `AcctNum` varchar(50) DEFAULT NULL, `POnum` varchar(50) DEFAULT NULL, `Item` varchar(50) DEFAULT NULL, `CustomerAccount` varchar(50) DEFAULT NULL, `IDRef` varchar(50) DEFAULT NULL, `ShipAdr` varchar(50) DEFAULT NULL, `ProductID` varchar(50) DEFAULT NULL, `Total` float DEFAULT NULL, `DateCreated` varchar(50) DEFAULT NULL, `ShipmentDate` varchar(50) DEFAULT NULL, `ProducerCode` varchar(50) DEFAULT NULL, `ProducerLocation` varchar(50) DEFAULT NULL, `Quantity` float DEFAULT NULL, `CustomerNumber` varchar(50) DEFAULT NULL, `ContactPhone` varchar(50) DEFAULT NULL, `ContactEmail` varchar(50) DEFAULT NULL, `SalesAgentID` varchar(50) DEFAULT NULL, `DiscountOff` varchar(50) DEFAULT NULL, `ShipmentNoticeID` varchar(50) DEFAULT NULL, `LogisticsProviderCode` varchar(50) DEFAULT NULL, `ServiceAgentID` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;