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;