"IASSALITEM"	"CREATE TABLE `IASSALITEM` (
  `CLIENT` char(2) collate latin1_german1_ci NOT NULL default '',
  `COMPANY` char(3) collate latin1_german1_ci NOT NULL default '',
  `DOCTYPE` char(2) collate latin1_german1_ci NOT NULL default '',
  `DOCNUM` varchar(8) collate latin1_german1_ci NOT NULL default '',
  `ITEMNUM` int(11) NOT NULL default '0',
  `ITEMTYPE` char(1) collate latin1_german1_ci default NULL,
  `VALIDFROM` datetime default NULL,
  `VALIDUNTIL` datetime default NULL,
  `BUSAREA` char(3) collate latin1_german1_ci default NULL,
  `REFDOCTYPE` char(2) collate latin1_german1_ci default NULL,
  `REFDOCNUM` varchar(8) collate latin1_german1_ci default NULL,
  `REFITEMNUM` int(11) default NULL,
  `REFSUBITEM` int(11) default NULL,
  `CREATEDBY` varchar(12) collate latin1_german1_ci default NULL,
  `CREATEDAT` datetime default NULL,
  `CHANGEDBY` varchar(12) collate latin1_german1_ci default NULL,
  `CHANGEDAT` datetime default NULL,
  `ISOFFCHAR` int(11) default NULL,
  `ISORDCHAR` int(11) default NULL,
  `ISDELCHAR` int(11) default NULL,
  `ISINVCHAR` int(11) default NULL,
  `OFFTYPE` int(11) default NULL,
  `ORDTYPE` int(11) default NULL,
  `DELTYPE` int(11) default NULL,
  `INVTYPE` int(11) default NULL,
  `OFFSTAT` int(11) default NULL,
  `ORDSTAT` int(11) default NULL,
  `DELSTAT` int(11) default NULL,
  `INVSTAT` int(11) default NULL,
  `PAYMSTAT` int(11) default NULL,
  `RESSTAT` int(11) default NULL,
  `ISSUEDSTAT` int(11) default NULL,
  `ISDELETE` int(11) default NULL,
  `ISTEXT` int(11) default NULL,
  `ISPRINT` int(11) default NULL,
  `ISEXPORT` int(11) default NULL,
  `ISPACKITEM` int(11) default NULL,
  `ISAVAILCHK` int(11) default NULL,
  `ISREQSET` int(11) default NULL,
  `ISGOODSISSUE` int(11) default NULL,
  `ISINVOICEITEM` int(11) default NULL,
  `ISDISCOUNT` int(11) default NULL,
  `ISCASHDISC` int(11) default NULL,
  `ISCUSTSPECIFIC` int(11) default NULL,
  `MATERIAL` varchar(25) collate latin1_german1_ci default NULL,
  `PLANT` char(3) collate latin1_german1_ci default NULL,
  `WAREHOUSE` char(3) collate latin1_german1_ci default NULL,
  `STOCKPLACE` varchar(10) collate latin1_german1_ci default NULL,
  `SPECIALSTOCK` char(1) collate latin1_german1_ci default NULL,
  `BATCHNUM` varchar(12) collate latin1_german1_ci default NULL,
  `MTEXT` varchar(40) collate latin1_german1_ci default NULL,
  `QUANTITY` decimal(21,8) default NULL,
  `QUNIT` char(3) collate latin1_german1_ci default NULL,
  `QUANTITYX` decimal(21,8) default NULL,
  `QUNITX` char(3) collate latin1_german1_ci default NULL,
  `SELQUNITX` int(11) default NULL,
  `ISSUEDQTY` decimal(21,8) default NULL,
  `RESERVEDQTY` decimal(21,8) default NULL,
  `INVOICEDQTY` decimal(21,8) default NULL,
  `AVAILQTY` decimal(21,8) default NULL,
  `AVAILAMNT` decimal(21,2) default NULL,
  `ORDEREDQTY` decimal(21,8) default NULL,
  `SHIPDATE` datetime default NULL,
  `DESDLVDATE` datetime default NULL,
  `PRODDATE` datetime default NULL,
  `TIMEKEY` int(11) default NULL,
  `REQDATE` datetime default NULL,
  `REQTYPE` char(2) collate latin1_german1_ci default NULL,
  `REQNUM` int(11) default NULL,
  `REQENDDATE` datetime default NULL,
  `TRANTYPEGI` char(3) collate latin1_german1_ci default NULL,
  `TRANTYPEGR` char(3) collate latin1_german1_ci default NULL,
  `SPRICE` decimal(21,2) default NULL,
  `PRICEFACTOR` decimal(21,10) default NULL,
  `SUBTOTAL` decimal(21,2) default NULL,
  `GRANDTOTAL` decimal(21,2) default NULL,
  `GROSS` decimal(21,2) default NULL,
  `VATKEY` char(2) collate latin1_german1_ci default NULL,
  `VATRATE` decimal(5,2) default NULL,
  `VATAMNT` decimal(21,2) default NULL,
  `DISCKEY1` char(3) collate latin1_german1_ci default NULL,
  `DISCKEY2` char(3) collate latin1_german1_ci default NULL,
  `DISCKEY3` char(3) collate latin1_german1_ci default NULL,
  `DISCKEY4` char(3) collate latin1_german1_ci default NULL,
  `DISCKEY5` char(3) collate latin1_german1_ci default NULL,
  `DISCTYPE1` int(11) default NULL,
  `DISCTYPE2` int(11) default NULL,
  `DISCTYPE3` int(11) default NULL,
  `DISCTYPE4` int(11) default NULL,
  `DISCTYPE5` int(11) default NULL,
  `DISCRATE1` decimal(21,2) default NULL,
  `DISCRATE2` decimal(21,2) default NULL,
  `DISCRATE3` decimal(21,2) default NULL,
  `DISCRATE4` decimal(21,2) default NULL,
  `DISCRATE5` decimal(21,2) default NULL,
  `DISCAMNT1` decimal(21,2) default NULL,
  `DISCAMNT2` decimal(21,2) default NULL,
  `DISCAMNT3` decimal(21,2) default NULL,
  `DISCAMNT4` decimal(21,2) default NULL,
  `DISCAMNT5` decimal(21,2) default NULL,
  `TDISCAMNT` decimal(21,2) default NULL,
  `DISCFROMHEAD` decimal(21,2) default NULL,
  `PARPAYAMNT` decimal(21,2) default NULL,
  `PARPAYVAT` decimal(21,2) default NULL,
  `OPENINVAMNT` decimal(21,2) default NULL,
  `CURRENCY` char(3) collate latin1_german1_ci default NULL,
  `HCURRENCY` char(3) collate latin1_german1_ci default NULL,
  `MCURRENCY` char(3) collate latin1_german1_ci default NULL,
  `EXCHRATE` decimal(21,10) default NULL,
  `PRICING` varchar(10) collate latin1_german1_ci default NULL,
  `PRICELIST` char(2) collate latin1_german1_ci default NULL,
  `SALDEPT` char(3) collate latin1_german1_ci default NULL,
  `HIERARCHY` char(3) collate latin1_german1_ci default NULL,
  `ACCOUNT` varchar(25) collate latin1_german1_ci default NULL,
  `CUSTOMER` varchar(8) collate latin1_german1_ci default NULL,
  `PACKTYPE` varchar(4) collate latin1_german1_ci default NULL,
  `NUMOFPACKS` decimal(21,8) default NULL,
  `GROSSWEIGHT` decimal(21,8) default NULL,
  `GROSWEIGHTUNIT` char(3) collate latin1_german1_ci default NULL,
  `NETWEIGHT` decimal(21,8) default NULL,
  `NETWEIGHTUNIT` char(3) collate latin1_german1_ci default NULL,
  `VOLUME` decimal(21,8) default NULL,
  `VOLUMEUNIT` char(3) collate latin1_german1_ci default NULL,
  `CUSTOMNUM` varchar(10) collate latin1_german1_ci default NULL,
  `CUSTOMRATE` decimal(21,10) default NULL,
  `EXPORTTEXT` varchar(40) collate latin1_german1_ci default NULL,
  `EUROMAT` varchar(13) collate latin1_german1_ci default NULL,
  `STATMATNUM` varchar(15) collate latin1_german1_ci default NULL,
  `ORGCOUNTRY` char(3) collate latin1_german1_ci default NULL,
  `REFCOMPANY` char(2) collate latin1_german1_ci default NULL,
  `COMMISSIONER` varchar(8) collate latin1_german1_ci default NULL,
  `COMMISRATE` decimal(5,2) default NULL,
  `GROSWEIGHTPRC` decimal(21,2) default NULL,
  `NETWEIGHTPRC` decimal(21,2) default NULL,
  `VOLUMEPRC` decimal(21,2) default NULL,
  `STEXT` varchar(40) collate latin1_german1_ci default NULL,
  `LTEXT` text collate latin1_german1_ci,
  `PROJECT` varchar(8) collate latin1_german1_ci default NULL,
  `COSTCENTER` varchar(8) collate latin1_german1_ci default NULL,
  `CCPLANT` char(3) collate latin1_german1_ci default NULL,
  `PLANORDER` varchar(8) collate latin1_german1_ci default NULL,
  `CUSTORDERTYPE` char(2) collate latin1_german1_ci default NULL,
  `CUSTORDERNUM` varchar(8) collate latin1_german1_ci default NULL,
  `CUSTORDERITEM` int(11) default NULL,
  `ASSETTYPE` varchar(4) collate latin1_german1_ci default NULL,
  `ASSETNUMBER` varchar(8) collate latin1_german1_ci default NULL,
  `ASSETITEM` int(11) default NULL,
  `INTORDERNUM` varchar(8) collate latin1_german1_ci default NULL,
  `INTORDERITEM` int(11) default NULL,
  `ISRESFORDEL` int(11) default NULL,
  `COSTOBJECT` varchar(8) collate latin1_german1_ci default NULL,
  `COSTITEM` int(11) default NULL,
  `ISSTOP` int(11) default NULL,
  `ISTOLERANCE` int(11) default NULL,
  `LOWERTOL` decimal(5,2) default NULL,
  `UPPERTOL` decimal(5,2) default NULL,
  `SKUNIT` char(3) collate latin1_german1_ci default NULL,
  `FACTOR` decimal(21,10) default NULL,
  `SUBCHFROMHEAD` decimal(21,2) default NULL,
  `ISCALCFROMGROSS` int(11) default NULL,
  `NORESERV` int(11) default NULL,
  `CONSPLACE` varchar(14) collate latin1_german1_ci default NULL,
  `DLOADPLACE` varchar(5) collate latin1_german1_ci default NULL,
  `KANBAN` varchar(22) collate latin1_german1_ci default NULL,
  `CARRYFROM` datetime default NULL,
  `CARRYUNTIL` datetime default NULL,
  `ISCOMPLETE` int(11) default NULL,
  `SETITEMNUM` int(11) NOT NULL default '0',
  `REFSETITEM` int(11) default NULL,
  `ITEMISS` int(11) default NULL,
  `ISSET` int(11) default NULL,
  `ISVARIANT` int(11) default NULL,
  `VARIANTKEY` varchar(20) collate latin1_german1_ci default NULL,
  `VOPTIONS` varchar(255) collate latin1_german1_ci default NULL,
  `ISLEASE` int(11) default NULL,
  `ISPRDORDER` int(11) default NULL,
  `ISSIMULATION` int(11) default NULL,
  `POTYPE` char(2) collate latin1_german1_ci default NULL,
  `PRDORDER` varchar(8) collate latin1_german1_ci default NULL,
  `ISPROTECT` int(11) default NULL,
  `PROTPER` int(11) default NULL,
  `RESERVINC` int(11) default NULL,
  `LASTPROTDATE` datetime default NULL,
  `TERMINAL` varchar(8) collate latin1_german1_ci default NULL,
  `DEPARTMENT` varchar(8) collate latin1_german1_ci default NULL,
  `WORKLEVEL` varchar(4) collate latin1_german1_ci default NULL,
  `STATION` varchar(8) collate latin1_german1_ci default NULL,
  `WARRBEGINDAT` datetime default NULL,
  `WARRENDDAT` datetime default NULL,
  `WARRANTPER` int(11) default NULL,
  `CONTACTNUM` varchar(12) collate latin1_german1_ci default NULL,
  `ROHGEWINN` decimal(21,2) default NULL,
  UNIQUE KEY `IASSALITEM_U1` (`DOCNUM`,`ITEMNUM`,`SETITEMNUM`,`DOCTYPE`,`COMPANY`,`CLIENT`),
  KEY `IASSALITEM_1` (`DOCNUM`,`DOCTYPE`,`COMPANY`,`CLIENT`),
  KEY `IASSALITEM_10` (`CLIENT`,`COMPANY`,`DOCTYPE`,`DOCNUM`,`VALIDFROM`,`ISORDCHAR`,`ORDTYPE`,`ORDSTAT`,`ISTEXT`,`ISSTOP`),
  KEY `IASSALITEM_2` (`MTEXT`,`MATERIAL`,`DOCNUM`,`DOCTYPE`,`COMPANY`,`CLIENT`),
  KEY `IASSALITEM_4` (`CLIENT`,`VALIDFROM`,`MATERIAL`),
  KEY `IASSALITEM_5` (`CLIENT`,`COMPANY`,`DOCTYPE`,`DOCNUM`,`ISTEXT`,`DELSTAT`,`ISDELCHAR`,`ISORDCHAR`,`ISSTOP`),
  KEY `IASSALITEM_6` (`CLIENT`,`COMPANY`,`DOCTYPE`,`DOCNUM`,`MATERIAL`,`MTEXT`,`PLANT`,`WAREHOUSE`),
  KEY `IASSSALITEM_R1` (`CLIENT`,`COMPANY`,`REFDOCTYPE`,`REFDOCNUM`,`SETITEMNUM`),
  KEY `CLIENT` (`CLIENT`,`COMPANY`,`VALIDFROM`,`ISDELCHAR`,`MATERIAL`),
  KEY `IASSALITEM_CUST_MAT` (`CLIENT`,`COMPANY`,`DOCTYPE`,`CUSTOMER`,`ISDELETE`),
  KEY `IASSALITEM_3` (`CLIENT`,`COMPANY`,`CUSTOMER`,`DOCTYPE`,`DOCNUM`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci"