CREATE TABLE %SCHEMA%.G1102ABTLST ( ABLVAB VARCHAR(15) BINARY ,ABLABT VARCHAR(15) BINARY ,ABLSTA DECIMAL(5,0) DEFAULT 1,ABLDAT DATETIME ,ABLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ABLVAB,ABLABT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1103KSTLST ( KSLVKS VARCHAR(30) BINARY ,KSLKST VARCHAR(30) BINARY ,KSLSTA DECIMAL(5,0) DEFAULT 1,KSLDAT DATETIME ,KSLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KSLVKS,KSLKST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1104KTRLST ( KTLVKT VARCHAR(15) BINARY ,KTLKTR VARCHAR(6) BINARY ,KTLSTA DECIMAL(5,0) DEFAULT 1,KTLDAT DATETIME ,KTLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KTLVKT,KTLKTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1105KRTLST ( KRLVKR VARCHAR(15) BINARY ,KRLKRT VARCHAR(4) BINARY ,KRLSTA DECIMAL(5,0) DEFAULT 1,KRLDAT DATETIME ,KRLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KRLVKR,KRLKRT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1202MENUELST ( MELMEN VARCHAR(20) BINARY ,MELFRM VARCHAR(20) BINARY ,MELSFR VARCHAR(15) BINARY ,MELBEA DECIMAL(5,0) DEFAULT 1,MELPOS DECIMAL(5,0) DEFAULT 1000,MELDAR DECIMAL(5,0) DEFAULT 1,MELFLD VARCHAR(9) BINARY ,MELFFR DECIMAL(5,0) DEFAULT 1,MELSTA DECIMAL(5,0) DEFAULT 1,MELDAT DATETIME ,MELERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MELMEN,MELPOS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1301FRMRTE ( FRMRTENUM VARCHAR(20) BINARY ,FRMRTEFRM VARCHAR(20) BINARY ,FRMRTEZUG DECIMAL(1,0) DEFAULT 1,FRMRTESTA DECIMAL(1,0) DEFAULT 1,FRMRTEERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',FRMRTEDAT DATETIME ,FRMRTEBEZ DECIMAL(1,0) DEFAULT 0,FRMRTEMOD DECIMAL(5,0) ,FRMRTEEMS DECIMAL(2,0) ,FRMRTEDTM VARCHAR(8) BINARY  ,PRIMARY KEY(FRMRTENUM,FRMRTEFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1301RTRRTE ( RTRRTENUM VARCHAR(15) BINARY ,RTRRTERTR VARCHAR(20) BINARY ,RTRRTEZUG DECIMAL(1,0) DEFAULT 1,RTRRTESTA DECIMAL(1,0) DEFAULT 1,RTRRTEERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',RTRRTEDAT DATETIME ,RTRRTEBEZ DECIMAL(1,0) DEFAULT 0,RTRRTEMOD DECIMAL(5,0) ,RTRRTELFD DECIMAL(1,0) ,RTRRTEFRM VARCHAR(20) BINARY  ,PRIMARY KEY(RTRRTENUM,RTRRTERTR,RTRRTEMOD,RTRRTELFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1302FRMRTELST ( FRMRTENAM VARCHAR(20) BINARY ,FRMRTEFMR VARCHAR(20) BINARY ,FRMRTEFLD VARCHAR(9) BINARY ,FRMRTEDAR DECIMAL(1,0) DEFAULT 1,FRMRTESTA DECIMAL(1,0) DEFAULT 1,FRMRTEERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',FRMRTEDAT DATETIME ,FRMRTEBKZ DECIMAL(1,0) DEFAULT 0,FRMRTEMDU DECIMAL(5,0)  ,PRIMARY KEY(FRMRTENAM,FRMRTEFMR,FRMRTEFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1303FRMRTESCHALT ( FRTSFLRTE VARCHAR(20) BINARY ,FRTSFLFRM VARCHAR(20) BINARY ,FRTSFLNUM VARCHAR(15) BINARY ,FRTSFLSTA DECIMAL(1,0) DEFAULT 1,FRTSFLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',FRTSFLDAT DATETIME  ,PRIMARY KEY(FRTSFLRTE,FRTSFLFRM,FRTSFLNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1401MENRTELST ( MRLMRT VARCHAR(15) BINARY ,MRLMEN VARCHAR(20) BINARY ,MRLBEA DECIMAL(5,0) DEFAULT 1,MRLZRR DECIMAL(5,0) DEFAULT 1,MRLSTA DECIMAL(5,0) DEFAULT 1,MRLDAT DATETIME ,MRLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MRLMRT,MRLMEN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1402MENFORM ( MFRMRT VARCHAR(15) BINARY ,MFRFRM VARCHAR(20) BINARY ,MFRBEA DECIMAL(5,0) DEFAULT 1,MFRZRR DECIMAL(5,0) DEFAULT 1,MFRSTA DECIMAL(5,0) DEFAULT 1,MFRDAT DATETIME ,MFRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MFRMRT,MFRFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1403MENDATEN ( MDLMRT VARCHAR(15) BINARY ,MDLFLD VARCHAR(9) BINARY ,MDLBEA DECIMAL(5,0) DEFAULT 1,MDLSTA DECIMAL(5,0) DEFAULT 1,MDLDAT DATETIME ,MDLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MDLMRT,MDLFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1501FCDLISTE ( FRLFRT VARCHAR(15) BINARY ,FRLFCD VARCHAR(3) BINARY ,FRLBEA DECIMAL(5,0) DEFAULT 1,FRLSTA DECIMAL(5,0) DEFAULT 1,FRLDAT DATETIME ,FRLERF VARCHAR(50) BINARY DEFAULT 'Timesys',FRLPRZ DECIMAL(5,0) ,FRLMOD DECIMAL(2,0) ,FRLALL DECIMAL(1,0) ,FRLIDX DECIMAL(2,0) ,FRLPLT DECIMAL(1,0)  ,PRIMARY KEY(FRLFRT,FRLFCD,FRLMOD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1601PNRRTEPNR ( RPNPRE VARCHAR(15) BINARY ,RPNPNR VARCHAR(8) BINARY ,RPNSTA DECIMAL(5,0) DEFAULT 1,RPNDAT DATETIME ,RPNERF VARCHAR(50) BINARY DEFAULT 'Timesys',RPNMOD DECIMAL(5,0) ,RPNFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RPNPRE,RPNPNR,RPNMOD,RPNFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1602PNRRTEAKR ( RAKPRE VARCHAR(15) BINARY ,RAKAKR VARCHAR(5) BINARY ,RAKSTA DECIMAL(5,0) DEFAULT 1,RAKDAT DATETIME ,RAKERF VARCHAR(50) BINARY DEFAULT 'Timesys',RAKMOD DECIMAL(5,0) ,RAKFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RAKPRE,RAKAKR,RAKMOD,RAKFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1603PNRRTEABT ( RABPRE VARCHAR(15) BINARY ,RABABT VARCHAR(15) BINARY ,RABSTA DECIMAL(5,0) DEFAULT 1,RABDAT DATETIME ,RABERF VARCHAR(50) BINARY DEFAULT 'Timesys',RABMOD DECIMAL(5,0) ,RABFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RABPRE,RABABT,RABMOD,RABFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1604PNRRTEKST ( RKSPRE VARCHAR(15) BINARY ,RKSKST VARCHAR(30) BINARY ,RKSSTA DECIMAL(5,0) DEFAULT 1,RKSDAT DATETIME ,RKSERF VARCHAR(50) BINARY DEFAULT 'Timesys',RKSMOD DECIMAL(5,0) ,RKSFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RKSPRE,RKSKST,RKSMOD,RKSFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1605PNRRTEDEA ( RDAMOD DECIMAL(5,0) ,RDAPRE VARCHAR(15) BINARY ,RDAPNR VARCHAR(8) BINARY ,RDASTA DECIMAL(5,0) DEFAULT 1,RDADAT DATETIME ,RDAERF VARCHAR(50) BINARY DEFAULT 'Timesys',RDAFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RDAMOD,RDAPRE,RDAPNR,RDAFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1605PNRRTEMAP ( MAPMOD DECIMAL(5,0) ,MAPPRE VARCHAR(15) BINARY ,MAPPNR VARCHAR(8) BINARY ,MAPSTA DECIMAL(5,0) DEFAULT 1,MAPDAT DATETIME ,MAPERF VARCHAR(50) BINARY DEFAULT 'Timesys',MAPFRM VARCHAR(25) BINARY  ,PRIMARY KEY(MAPMOD,MAPPRE,MAPPNR,MAPFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1606PNRRTEKRT ( RKRMOD DECIMAL(5,0) ,RKRPRE VARCHAR(15) BINARY ,RKRKRT VARCHAR(4) BINARY ,RKRDAT DATETIME ,RKRERF VARCHAR(50) BINARY ,RKRSTA DECIMAL(5,0) ,RKRFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RKRMOD,RKRPRE,RKRKRT,RKRFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1607PNRRTEKTR ( RKTMOD DECIMAL(5,0) ,RKTPRE VARCHAR(15) BINARY ,RKTKTR VARCHAR(6) BINARY ,RKTDAT DATETIME ,RKTERF VARCHAR(50) BINARY ,RKTSTA DECIMAL(5,0) ,RKTFRM VARCHAR(25) BINARY  ,PRIMARY KEY(RKTMOD,RKTPRE,RKTKTR,RKTFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1608PNRRTEPLG ( RPLPRE VARCHAR(15) BINARY ,RPLMOD DECIMAL(5,0) ,RPLPLG VARCHAR(5) BINARY ,RPLFRM VARCHAR(25) BINARY ,RPLSTA DECIMAL(5,0) DEFAULT 1,RPLDAT DATETIME ,RPLERF VARCHAR(50) BINARY  ,PRIMARY KEY(RPLPRE,RPLMOD,RPLPLG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1609PNRRTEMOD ( MODFMR VARCHAR(20) BINARY ,MODNAM VARCHAR(200) BINARY ,MODLFD DECIMAL(3,0) ,MODVAL VARCHAR(50) BINARY ,MODABT VARCHAR(15) BINARY ,MODKST VARCHAR(30) BINARY ,MODBEA DECIMAL(2,0) ,MODRF0 VARCHAR(50) BINARY ,MODRF1 VARCHAR(50) BINARY ,MODRF2 VARCHAR(50) BINARY ,MODRF3 VARCHAR(50) BINARY ,MODRF4 VARCHAR(50) BINARY ,MODRF5 VARCHAR(50) BINARY ,MODRF6 VARCHAR(50) BINARY ,MODRF7 VARCHAR(50) BINARY ,MODRF8 VARCHAR(50) BINARY ,MODRF9 VARCHAR(50) BINARY ,MODLIZ VARCHAR(5) BINARY ,MODMND VARCHAR(5) BINARY  ,PRIMARY KEY(MODFMR,MODNAM,MODLFD,MODVAL,MODLIZ,MODMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1701ZKTLST ( ZKLNUM VARCHAR(15) BINARY ,ZKLZKT VARCHAR(5) BINARY ,ZKLSTA DECIMAL(5,0) DEFAULT 1,ZKLDAT DATETIME ,ZKLERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZKLPRZ DECIMAL(5,0)  ,PRIMARY KEY(ZKLNUM,ZKLZKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1802SCHALTLST ( SFGSRT VARCHAR(15) BINARY ,SFGGRP DECIMAL(5,0) DEFAULT 0,SFGNUM VARCHAR(15) BINARY ,SFGLFD DECIMAL(5,0) DEFAULT 0,SFGSTA DECIMAL(5,0) DEFAULT 1,SFGDAT DATETIME ,SFGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SFGSRT,SFGGRP,SFGNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G1901REPTOOLLST ( RTLNAM VARCHAR(50) BINARY ,RTLFLD VARCHAR(9) BINARY ,RTLSTA DECIMAL(5,0) ,RTLERF VARCHAR(80) BINARY ,RTLDAT DATETIME  ,PRIMARY KEY(RTLNAM,RTLFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G2006DATDNLLST ( DDLNAM VARCHAR(50) BINARY ,DDLTYP DECIMAL(5,0) DEFAULT 0,DDLDNM VARCHAR(200) BINARY ,DDLDTV DATETIME ,DDLDTB DATETIME ,DDLUZV DATETIME ,DDLUZB DATETIME ,DDLSTA DECIMAL(1,0) DEFAULT 1,DDLDAT DATETIME ,DDLERF VARCHAR(50) BINARY DEFAULT 'Timesys',DDLZAG DECIMAL(1,0) DEFAULT 1,DDLTRM VARCHAR(255) BINARY ,DDLDLA DECIMAL(1,0) DEFAULT NULL ,PRIMARY KEY(DDLNAM,DDLTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G2006TRMDNLLST ( TDLNAM VARCHAR(50) BINARY ,TDLTYP DECIMAL(5,0) DEFAULT 0,TDLTRM VARCHAR(255) BINARY  ,PRIMARY KEY(TDLNAM,TDLTYP,TDLTRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G2006TXTDNLLST ( TXTNAM VARCHAR(50) BINARY ,TXTTYP DECIMAL(5,0) DEFAULT 0,TXTLFD DECIMAL(5,0) ,TXTTXT VARCHAR(4000) BINARY ,TXTAUS VARCHAR(50) BINARY  ,PRIMARY KEY(TXTNAM,TXTTYP,TXTLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.G2201PRSGRPLST ( PGLNAM VARCHAR(50) BINARY ,PGLUSR VARCHAR(50) BINARY ,PGLPNR VARCHAR(8) BINARY ,PGLSRT DECIMAL(4,0) ,PGLSPC DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(PGLNAM,PGLUSR,PGLPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1000PARM ( PRMNAM DECIMAL(4,0) ,PRMBEZ VARCHAR(50) BINARY ,PRMWRT VARCHAR(50) BINARY ,PRMMOD DECIMAL(2,0) ,PRMSTA DECIMAL(5,0) DEFAULT 1,PRMDAT DATETIME ,PRMERF VARCHAR(50) BINARY DEFAULT 'Timesys'     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1000PSG ( PSGPRT DECIMAL(3,0) ,PSGGRP VARCHAR(5) BINARY ,PSGBEZ VARCHAR(20) BINARY ,PSGZTR DECIMAL(2,0) ,PSGVON DATETIME ,PSGBIS DATETIME ,PSGP01 DECIMAL(2,0) DEFAULT 0,PSGP02 DECIMAL(2,0) DEFAULT 0,PSGP03 DECIMAL(2,0) DEFAULT 0,PSGP04 DECIMAL(2,0) DEFAULT 0,PSGP05 DECIMAL(2,0) DEFAULT 0,PSGP06 DECIMAL(2,0) DEFAULT 0,PSGP07 DECIMAL(2,0) DEFAULT 0,PSGSTA DECIMAL(5,0) DEFAULT 1,PSGDAT DATETIME ,PSGERF VARCHAR(50) BINARY DEFAULT 'Timesys',PSGBRN DECIMAL(2,0) DEFAULT 0 ,PRIMARY KEY(PSGGRP,PSGBEZ,PSGZTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1001ABRKREIS ( AKRNUM VARCHAR(5) BINARY ,AKRVWS VARCHAR(5) BINARY ,AKREBN DECIMAL(5,0) DEFAULT 1,AKRAZR DECIMAL(5,0) DEFAULT 31,AKRTAG DECIMAL(5,0) DEFAULT 0,AKRRRM DECIMAL(5,0) DEFAULT 0,AKRLUG VARCHAR(5) BINARY ,AKRTXT VARCHAR(50) BINARY ,AKRKTX VARCHAR(10) BINARY ,AKRSTA DECIMAL(5,0) DEFAULT 1,AKRDAT DATETIME ,AKRERF VARCHAR(50) BINARY DEFAULT 'Timesys',AKRAZP DECIMAL(5,0) DEFAULT 0,AKRADT DECIMAL(5,0) ,AKRSSL DECIMAL(1,0) DEFAULT 1,AKRANR DECIMAL(3,0) DEFAULT 0 ,PRIMARY KEY(AKRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1002ABTEILUNG ( ABTNUM VARCHAR(15) BINARY ,ABTVWS VARCHAR(15) BINARY ,ABTEBN DECIMAL(5,0) DEFAULT 1,ABTLST VARCHAR(3) BINARY ,ABTTXT VARCHAR(50) BINARY ,ABTKTX VARCHAR(10) BINARY ,ABTSTA DECIMAL(5,0) DEFAULT 1,ABTDAT DATETIME ,ABTERF VARCHAR(50) BINARY DEFAULT 'Timesys',ABTZUO DECIMAL(4,0) ,ABTCOL VARCHAR(20) BINARY  ,PRIMARY KEY(ABTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1003KSTSTELLE ( KSTNUM VARCHAR(30) BINARY ,KSTVWS VARCHAR(30) BINARY ,KSTEBN DECIMAL(5,0) DEFAULT 1,KSTLST VARCHAR(3) BINARY ,KSTTXT VARCHAR(50) BINARY ,KSTKTX VARCHAR(10) BINARY ,KSTSTA DECIMAL(5,0) DEFAULT 1,KSTDAT DATETIME ,KSTERF VARCHAR(50) BINARY DEFAULT 'Timesys',KSTAPZ DECIMAL(7,0) ,KSTGUT VARCHAR(3) BINARY ,KSTZUO DECIMAL(4,0)  ,PRIMARY KEY(KSTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1004KSTTRAEGER ( KTRNUM VARCHAR(6) BINARY ,KTRLST VARCHAR(3) BINARY ,KTRTXT VARCHAR(50) BINARY ,KTRKTX VARCHAR(10) BINARY ,KTRSTA DECIMAL(5,0) DEFAULT 1,KTRDAT DATETIME ,KTRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KTRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1005KSTART ( KRTNUM VARCHAR(4) BINARY ,KRTLST VARCHAR(3) BINARY ,KRTTXT VARCHAR(50) BINARY ,KRTKTX VARCHAR(10) BINARY ,KRTSTA DECIMAL(5,0) DEFAULT 1,KRTDAT DATETIME ,KRTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KRTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1006LEISTUNG ( LSTNUM VARCHAR(3) BINARY ,LSTTXT VARCHAR(50) BINARY ,LSTKTX VARCHAR(10) BINARY ,LSTSTA DECIMAL(5,0) DEFAULT 1,LSTDAT DATETIME ,LSTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(LSTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1102ABTGRUPPEN ( VABABT VARCHAR(15) BINARY ,VABTXT VARCHAR(50) BINARY ,VABKTX VARCHAR(10) BINARY ,VABSTA DECIMAL(5,0) DEFAULT 1,VABDAT DATETIME ,VABERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(VABABT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1103KSTGRUPPEN ( VKSKST VARCHAR(30) BINARY ,VKSTXT VARCHAR(50) BINARY ,VKSKTX VARCHAR(10) BINARY ,VKSSTA DECIMAL(5,0) DEFAULT 1,VKSDAT DATETIME ,VKSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(VKSKST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1104KTRGRUPPEN ( VKTKTR VARCHAR(15) BINARY ,VKTTXT VARCHAR(50) BINARY ,VKTKTX VARCHAR(10) BINARY ,VKTSTA DECIMAL(5,0) DEFAULT 1,VKTDAT DATETIME ,VKTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(VKTKTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1105KRTGRUPPEN ( VKAKRT VARCHAR(15) BINARY ,VKATXT VARCHAR(50) BINARY ,VKAKTX VARCHAR(10) BINARY ,VKASTA DECIMAL(5,0) DEFAULT 1,VKADAT DATETIME ,VKAERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(VKAKRT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1202MENUE ( MENNUM VARCHAR(20) BINARY ,MENTXT VARCHAR(50) BINARY ,MENKTX VARCHAR(10) BINARY ,MENBEA DECIMAL(5,0) DEFAULT 1,MENSTA DECIMAL(5,0) DEFAULT 1,MENDAT DATETIME ,MENERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MENNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1301FRMRECHT ( FRENUM VARCHAR(20) BINARY ,FRETXT VARCHAR(30) BINARY ,FRESTA DECIMAL(1,0) DEFAULT 1,FREDAT DATETIME ,FREERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(FRENUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1401MENRECHT ( MRTNUM VARCHAR(15) BINARY ,MRTTXT VARCHAR(50) BINARY ,MRTKTX VARCHAR(10) BINARY ,MRTSTA DECIMAL(5,0) DEFAULT 1,MRTDAT DATETIME ,MRTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MRTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1501FCDRECHT ( FRTNUM VARCHAR(15) BINARY ,FRTTXT VARCHAR(50) BINARY ,FRTKTX VARCHAR(10) BINARY ,FRTSTA DECIMAL(5,0) DEFAULT 1,FRTDAT DATETIME ,FRTERF VARCHAR(50) BINARY DEFAULT 'Timesys',FRTALL DECIMAL(1,0)  ,PRIMARY KEY(FRTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1601PNRRECHT ( PRENUM VARCHAR(15) BINARY ,PREZUG DECIMAL(5,0) DEFAULT 1,PRETXT VARCHAR(50) BINARY ,PREKTX VARCHAR(10) BINARY ,PRESTA DECIMAL(5,0) DEFAULT 1,PREDAT DATETIME ,PREERF VARCHAR(50) BINARY DEFAULT 'Timesys',PREMOD DECIMAL(5,0) ,PREFRM VARCHAR(25) BINARY  ,PRIMARY KEY(PRENUM,PREMOD,PREFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1602PREKOPF ( PRKERF VARCHAR(50) BINARY ,PRKDAT DATETIME ,PRKSTA DECIMAL(5,0) ,PRKTXT VARCHAR(50) BINARY ,PRKNUM VARCHAR(15) BINARY  ,PRIMARY KEY(PRKNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1701ZKTGRP ( ZKGNUM VARCHAR(15) BINARY ,ZKGTXT VARCHAR(50) BINARY ,ZKGKTX VARCHAR(10) BINARY ,ZKGSTA DECIMAL(5,0) DEFAULT 1,ZKGDAT DATETIME ,ZKGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZKGNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1802SCHALTRTE ( SRTNUM VARCHAR(15) BINARY ,SRTTXT VARCHAR(50) BINARY ,SRTKTX VARCHAR(10) BINARY ,SRTSTA DECIMAL(5,0) DEFAULT 1,SRTDAT DATETIME ,SRTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SRTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O1901REPTOOL ( REPNAM_O VARCHAR(50) BINARY ,REPUEB_O VARCHAR(100) BINARY ,REPSTA_O DECIMAL(5,0) DEFAULT 1,REPERF_O VARCHAR(8) BINARY ,REPDAT_O DATETIME      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O2006TRMDATEI ( TRDNAM VARCHAR(200) BINARY ,TRDTXT VARCHAR(200) BINARY ,TRDART DECIMAL(5,0) DEFAULT 1,TRDTYP DECIMAL(5,0) DEFAULT 0,TRDVER VARCHAR(10) BINARY ,TRDSTA DECIMAL(5,0) DEFAULT 1,TRDDAT DATETIME ,TRDERF VARCHAR(50) BINARY DEFAULT 'Timesys',TRDTCN VARCHAR(32) BINARY  ,PRIMARY KEY(TRDNAM,TRDTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O2106TFK ( TFKTTT VARCHAR(10) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O2201PRSGRP ( PGRNAM VARCHAR(50) BINARY ,PGRUSR VARCHAR(50) BINARY ,PGRDAT DATETIME ,PGRSTA DECIMAL(1,0) DEFAULT 1,PGRERF VARCHAR(50) BINARY ,PGRFMR DECIMAL(1,0)  ,PRIMARY KEY(PGRNAM,PGRUSR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3000AND ( ANDNUM VARCHAR(25) BINARY ,ANDBEZ VARCHAR(50) BINARY ,ANDFRM VARCHAR(20) BINARY ,ANDLFD DECIMAL(5,0) ,ANDFNA VARCHAR(9) BINARY ,ANDFNR DECIMAL(11,0) ,ANDWHL DECIMAL(5,0) ,ANDAUS DECIMAL(5,0) ,ANDLAN DECIMAL(5,0) ,ANDTYP VARCHAR(20) BINARY ,ANDRE1 VARCHAR(50) BINARY ,ANDRE2 VARCHAR(50) BINARY ,ANDRE3 VARCHAR(50) BINARY ,ANDRE4 VARCHAR(50) BINARY ,ANDRE5 VARCHAR(50) BINARY ,ANDTXT VARCHAR(120) BINARY  ,PRIMARY KEY(ANDNUM,ANDFRM,ANDLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3000ANL ( ANLNUM VARCHAR(25) BINARY ,ANLBEZ VARCHAR(50) BINARY ,ANLFRM VARCHAR(20) BINARY ,ANLFNR DECIMAL(11,0) ,ANLFWH DECIMAL(5,0) ,ANLPFR DECIMAL(2,0) ,ANLSWC VARCHAR(3) BINARY ,ANLLOG DECIMAL(1,0) ,ANLANZ DECIMAL(2,0) ,ANLKLI DECIMAL(2,0) ,ANLKLT VARCHAR(50) BINARY ,ANLKMI DECIMAL(2,0) ,ANLKMT VARCHAR(50) BINARY ,ANLKRE DECIMAL(2,0) ,ANLKRT VARCHAR(50) BINARY ,ANLFLI DECIMAL(2,0) ,ANLFLT VARCHAR(50) BINARY ,ANLFMI DECIMAL(2,0) ,ANLFMT VARCHAR(50) BINARY ,ANLFRE DECIMAL(2,0) ,ANLFRT VARCHAR(50) BINARY ,ANLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',ANLDAT DATETIME ,ANLSTA DECIMAL(1,0) DEFAULT 1,ANLSAS DECIMAL(1,0) DEFAULT 1,ANLCOL DECIMAL(2,0) DEFAULT 5,ANLRE1 VARCHAR(50) BINARY ,ANLRE2 VARCHAR(50) BINARY ,ANLRE3 VARCHAR(50) BINARY ,ANLRE4 VARCHAR(50) BINARY ,ANLRE5 VARCHAR(50) BINARY ,ANLART VARCHAR(3) BINARY  ,PRIMARY KEY(ANLNUM,ANLFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3000PRF ( PRFNUM VARCHAR(25) BINARY ,PRFFRM VARCHAR(20) BINARY ,PRFLFD DECIMAL(5,0) ,PRFFNA VARCHAR(9) BINARY ,PRFFNR DECIMAL(11,0) ,PRFWHL DECIMAL(5,0) ,PRFAUS DECIMAL(5,0) ,PRFLAN DECIMAL(5,0) ,PRFTYP VARCHAR(20) BINARY ,PRFRE1 VARCHAR(50) BINARY ,PRFRE2 VARCHAR(50) BINARY ,PRFRE3 VARCHAR(50) BINARY ,PRFRE4 VARCHAR(50) BINARY ,PRFRE5 VARCHAR(50) BINARY ,PRFTXT VARCHAR(120) BINARY  ,PRIMARY KEY(PRFNUM,PRFFRM,PRFLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3000PRT ( PRTNUM VARCHAR(25) BINARY ,PRTFRM VARCHAR(20) BINARY ,PRTFNR DECIMAL(11,0) ,PRTFWH DECIMAL(5,0) ,PRTPFR DECIMAL(2,0) ,PRTSWC VARCHAR(3) BINARY ,PRTLOG DECIMAL(1,0) ,PRTANZ DECIMAL(2,0) ,PRTKLI DECIMAL(2,0) ,PRTKLT VARCHAR(50) BINARY ,PRTKMI DECIMAL(2,0) ,PRTKMT VARCHAR(50) BINARY ,PRTKRE DECIMAL(2,0) ,PRTKRT VARCHAR(50) BINARY ,PRTFLI DECIMAL(2,0) ,PRTFLT VARCHAR(50) BINARY ,PRTFMI DECIMAL(2,0) ,PRTFMT VARCHAR(50) BINARY ,PRTFRE DECIMAL(2,0) ,PRTFRT VARCHAR(50) BINARY ,PRTERF VARCHAR(50) BINARY DEFAULT 'Timesys',PRTDAT DATETIME ,PRTSTA DECIMAL(1,0) DEFAULT 1,PRTSAS DECIMAL(1,0) DEFAULT 1,PRTCOL DECIMAL(2,0) DEFAULT 5,PRTRE1 VARCHAR(50) BINARY ,PRTRE2 VARCHAR(50) BINARY ,PRTRE3 VARCHAR(50) BINARY ,PRTRE4 VARCHAR(50) BINARY ,PRTRE5 VARCHAR(50) BINARY ,PRTART VARCHAR(3) BINARY ,PRTTXT VARCHAR(50) BINARY  ,PRIMARY KEY(PRTNUM,PRTFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3000TKD ( TKDNUM VARCHAR(25) BINARY ,TKDBEZ VARCHAR(50) BINARY ,TKDFRM VARCHAR(20) BINARY ,TKDLFD DECIMAL(5,0) ,TKDFNA VARCHAR(9) BINARY ,TKDFNR DECIMAL(11,0) ,TKDWHL DECIMAL(5,0) ,TKDAUS DECIMAL(5,0) ,TKDLAN DECIMAL(5,0) ,TKDLA2 DECIMAL(5,0) ,TKDMIN DECIMAL(5,0) ,TKDTXT VARCHAR(120) BINARY  ,PRIMARY KEY(TKDNUM,TKDFRM,TKDLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3000TKK ( TKKNUM VARCHAR(25) BINARY ,TKKBEZ VARCHAR(50) BINARY ,TKKFRM VARCHAR(20) BINARY ,TKKSTA DECIMAL(1,0) DEFAULT 1,TKKDAT DATETIME ,TKKERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(TKKNUM,TKKFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3001BCH ( BCHPRF VARCHAR(25) BINARY ,BCHFNR DECIMAL(11,0) ,BCHFCD VARCHAR(3) BINARY ,BCHTXT VARCHAR(50) BINARY ,BCHNUM DECIMAL(11,0) ,BCHWHL DECIMAL(5,0)  ,PRIMARY KEY(BCHPRF,BCHFCD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3001ZIN ( ZINPRF VARCHAR(25) BINARY ,ZINFRM VARCHAR(20) BINARY ,ZINFNR DECIMAL(11,0) ,ZINFLD VARCHAR(8) BINARY ,ZINFTX VARCHAR(25) BINARY ,ZINNUM DECIMAL(11,0) ,ZINWHL DECIMAL(5,0)  ,PRIMARY KEY(ZINPRF,ZINFRM,ZINFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3001ZSD ( ZSDPRF VARCHAR(25) BINARY ,ZSDFRM VARCHAR(20) BINARY ,ZSDFNR DECIMAL(11,0) ,ZSDFLD VARCHAR(8) BINARY ,ZSDFTX VARCHAR(25) BINARY ,ZSDNUM DECIMAL(11,0) ,ZSDWHL DECIMAL(5,0)  ,PRIMARY KEY(ZSDPRF,ZSDFRM,ZSDFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3001ZST ( ZSTPRF VARCHAR(25) BINARY ,ZSTFRM VARCHAR(20) BINARY ,ZSTSNR DECIMAL(11,0) ,ZSTSFL VARCHAR(8) BINARY ,ZSTSTX VARCHAR(50) BINARY ,ZSTSNU DECIMAL(11,0) ,ZSTSWH DECIMAL(5,0) ,ZSTWNR DECIMAL(11,0) ,ZSTWFL VARCHAR(8) BINARY ,ZSTWTX VARCHAR(50) BINARY ,ZSTNUM DECIMAL(11,0) ,ZSTWHL DECIMAL(5,0)  ,PRIMARY KEY(ZSTPRF,ZSTFRM,ZSTSFL,ZSTWFL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.O3001ZZK ( ZZKPRF VARCHAR(25) BINARY ,ZZKFRM VARCHAR(20) BINARY ,ZZKFNR DECIMAL(11,0) ,ZZKZKT VARCHAR(8) BINARY ,ZZKTXT VARCHAR(50) BINARY ,ZZKNUM DECIMAL(11,0) ,ZZKWHL DECIMAL(5,0)  ,PRIMARY KEY(ZZKPRF,ZZKFRM,ZZKZKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.PERSONALSTAMM ( PSTPNRNUM VARCHAR(8) BINARY ,PSTPNRANM VARCHAR(50) BINARY ,PSTPNRAKT DATETIME ,PSTPNREND DATETIME ,PSTPNREML VARCHAR(50) BINARY ,PSTPNRMRT VARCHAR(15) BINARY ,PSTPNRFRT VARCHAR(15) BINARY ,PSTPNRBEA DECIMAL(5,0) ,PSTPNRGEB DATETIME ,PSTPNREIN DATETIME ,PSTPNRNAM VARCHAR(50) BINARY ,PSTPNRSTR VARCHAR(50) BINARY ,PSTPNRPLZ VARCHAR(10) BINARY ,PSTPNRORT VARCHAR(50) BINARY ,PSTPNRTEL VARCHAR(30) BINARY ,PSTPNRMOB VARCHAR(30) BINARY ,PSTPNRTIT DECIMAL(5,0) ,PSTPNRANR DECIMAL(5,0) ,PSTPNRNEB VARCHAR(8) BINARY ,PSTPNRSTA DECIMAL(5,0) ,PSTPNRDAT DATETIME ,PSTPNRERF VARCHAR(50) BINARY ,PSTPNRSPR DECIMAL(5,0) ,PSTPNRFRE VARCHAR(20) BINARY ,PSTPNRGBI DATETIME ,PSTPNRKRD VARCHAR(20) BINARY ,PSTPNRPRT VARCHAR(15) BINARY ,PSTPNRLDA DECIMAL(1,0) ,PSTPNRFMO VARCHAR(30) BINARY ,PSTBSVAKR VARCHAR(5) BINARY ,PSTBSVKAL VARCHAR(5) BINARY ,PSTBSVSAL VARCHAR(5) BINARY ,PSTBSVURL VARCHAR(5) BINARY ,PSTBSVLFZ VARCHAR(5) BINARY ,PSTBSVSFR VARCHAR(5) BINARY ,PSTBSVMON DECIMAL(11,0) ,PSTBSVAGM DECIMAL(11,0) ,PSTBSVABR VARCHAR(5) BINARY ,PSTBSVBGR DECIMAL(5,0) ,PSTBSVLUG VARCHAR(10) BINARY ,PSTBSVAGV DECIMAL(1,0) ,PSTBSVPEP DECIMAL(1,0) ,PSTBSVDMS DECIMAL(11,0) ,PSTBSVPNM VARCHAR(50) BINARY ,PSTBSVRE0 VARCHAR(50) BINARY ,PSTBSVRE1 VARCHAR(50) BINARY ,PSTBSVRE2 VARCHAR(50) BINARY ,PSTBSVRE3 VARCHAR(50) BINARY ,PSTBSVRE4 VARCHAR(50) BINARY ,PSTBSVRE5 VARCHAR(50) BINARY ,PSTBSVDWT DECIMAL(5,2) ,PSTBSVPZM DECIMAL(1,0) ,PSTBSVZUT DECIMAL(1,0) ,PSTBSVMAP DECIMAL(1,0) ,PSTBSVDWH DECIMAL(1,0) ,PSTBSVMMA DECIMAL(5,0) ,PSTBSVPRZ DECIMAL(5,2) ,PSTBSVJAM VARCHAR(5) BINARY ,PSTBSVSUL VARCHAR(10) BINARY ,PSTZUOABT VARCHAR(15) BINARY ,PSTZUOVRA VARCHAR(5) BINARY ,PSTZUOAGR VARCHAR(5) BINARY ,PSTZUOSDT DATETIME ,PSTZUOSTG DECIMAL(5,0) ,PSTZUOKST VARCHAR(30) BINARY ,PSTZUOKTR VARCHAR(6) BINARY ,PSTASWNU1 VARCHAR(50) BINARY ,PSTASWNU2 VARCHAR(50) BINARY ,PSTASWNU3 VARCHAR(50) BINARY ,PSTASWNU4 VARCHAR(50) BINARY ,PSTBSVKSM DECIMAL(1,0) ,PSTASWNU5 VARCHAR(50) BINARY ,STICHTAG DATETIME ,PSTPNRSAL VARCHAR(10) BINARY ,PSTZUOKSB DECIMAL(1,0) ,PSTPNRMTA DECIMAL(2,0) ,PSTPNRAGE DECIMAL(1,0) DEFAULT 0,PSTBSVWAM VARCHAR(5) BINARY ,PSTBSVWPZ DECIMAL(5,2) ,PSTBSVWAR DECIMAL(3,0) ,PSTPNR1NM VARCHAR(50) BINARY ,PSTPNR2NM VARCHAR(50) BINARY ,PSTPNRNBU DECIMAL(1,0) DEFAULT 0,PSTPNRAZU DECIMAL(5,0) DEFAULT 0,PSTPNRABF VARCHAR(150) BINARY ,PSTPNRABE VARCHAR(50) BINARY ,PSTBSVFST VARCHAR(6) BINARY DEFAULT null ,PRIMARY KEY(PSTPNRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS001SDF ( SDFPGM VARCHAR(3) BINARY ,SDFPNR VARCHAR(8) BINARY ,SDFTAG DATETIME ,SDFNUM DECIMAL(11,0) ,SDFWHL DECIMAL(5,0) ,SDFART VARCHAR(3) BINARY ,SDFDAT DATETIME  ,PRIMARY KEY(SDFPGM,SDFPNR,SDFTAG,SDFNUM,SDFWHL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS010HIS ( HISTNR DECIMAL(7,0) ,HISLFD DECIMAL(2,0) ,HISDEF VARCHAR(20) BINARY ,HISUSR VARCHAR(50) BINARY ,HISFLD VARCHAR(9) BINARY ,HISOVL VARCHAR(255) BINARY ,HISNVL VARCHAR(255) BINARY ,HISKEY VARCHAR(255) BINARY ,HISOUS VARCHAR(50) BINARY ,HISIP VARCHAR(15) BINARY ,HISDST VARCHAR(50) BINARY ,HISDAT DATETIME ,HISNUM DECIMAL(11,0) ,HISWHL DECIMAL(5,0)  ,PRIMARY KEY(HISTNR,HISLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS010TAZ ( TAZDEF VARCHAR(20) BINARY ,TAZMSK VARCHAR(20) BINARY ,TAZDAT DATETIME  ,PRIMARY KEY(TAZDEF,TAZMSK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS100BEM ( BEMNUM DECIMAL(11,0) ,BEMBER VARCHAR(3) BINARY ,BEMTXT VARCHAR(1500) BINARY  ,PRIMARY KEY(BEMNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS101SBS ( SBSNAM VARCHAR(15) BINARY ,SBSLFD DECIMAL(5,0) DEFAULT 0,SBSEIN VARCHAR(9) BINARY ,SBSAUS VARCHAR(9) BINARY ,SBSTXT TEXT ,SBSSFD VARCHAR(9) BINARY ,SBSWFD VARCHAR(9) BINARY ,SBSSTA DECIMAL(5,0) DEFAULT 1,SBSDAT DATETIME ,SBSERF VARCHAR(50) BINARY DEFAULT 'Timesys'     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS103DMYPNR ( DMYPNR VARCHAR(8) BINARY ,DMYFRM VARCHAR(20) BINARY ,DMYFLD VARCHAR(9) BINARY ,DMYPOS DECIMAL(5,0) DEFAULT 1,DMYSRT DECIMAL(5,0) DEFAULT 0,DMYRIC VARCHAR(10) BINARY ,DMYKFG DECIMAL(1,0)  ,PRIMARY KEY(DMYPNR,DMYFRM,DMYFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS103FRMFIL ( FILPNR VARCHAR(8) BINARY ,FILFRM VARCHAR(20) BINARY ,FILLFD DECIMAL(5,0) DEFAULT 1,FILART DECIMAL(5,0) DEFAULT 1,FILINH TEXT ,FILSTA DECIMAL(5,0) DEFAULT 1,FILDAT DATETIME ,FILERF VARCHAR(50) BINARY DEFAULT 'Timesys',FILFLD VARCHAR(9) BINARY ,FILGTO DECIMAL(1,0)  ,PRIMARY KEY(FILPNR,FILFRM,FILLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS103FRMKTP ( KTPPNR VARCHAR(8) BINARY ,KTPFRM VARCHAR(20) BINARY ,KTPLFD DECIMAL(5,0) DEFAULT 1,KTPZTR DECIMAL(5,0) DEFAULT 1,KTPPER VARCHAR(8) BINARY ,KTPDTM DATETIME ,KTPSTA DECIMAL(5,0) DEFAULT 1,KTPDAT DATETIME ,KTPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KTPPNR,KTPFRM,KTPLFD,KTPZTR,KTPPER,KTPDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS103FRMKTV ( KTVPNR VARCHAR(8) BINARY ,KTVFRM VARCHAR(20) BINARY ,KTVLFD DECIMAL(5,0) DEFAULT 1,KTVZTR DECIMAL(5,0) DEFAULT 0,KTVINT DECIMAL(5,0) DEFAULT 0,KTVTAG DECIMAL(5,0) DEFAULT 1,KTVUHR DATETIME ,KTVSTA DECIMAL(5,0) DEFAULT 1,KTVDAT DATETIME ,KTVERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KTVPNR,KTVFRM,KTVLFD,KTVZTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS103FRMPNR ( PFRPNR VARCHAR(8) BINARY ,PFRFRM VARCHAR(20) BINARY ,PFRFLD VARCHAR(9) BINARY ,PFRPOS DECIMAL(5,0) DEFAULT 1,PFRSTA DECIMAL(5,0) DEFAULT 1,PFRDAT DATETIME ,PFRERF VARCHAR(50) BINARY DEFAULT 'Timesys',PFRSRT DECIMAL(5,0) DEFAULT 0,PFRRIC VARCHAR(10) BINARY ,PFROST DECIMAL(5,0) ,PFRORI VARCHAR(5) BINARY ,PFRKFG DECIMAL(1,0)  ,PRIMARY KEY(PFRPNR,PFRFRM,PFRFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS108PWA ( PWANUM VARCHAR(10) BINARY ,PWAAZT DECIMAL(1,0) ,PWALKW DECIMAL(3,0) ,PWADTA DECIMAL(3,0) ,PWADAZ DECIMAL(3,0) ,PWASTA DECIMAL(5,0) DEFAULT 1,PWADAT DATETIME ,PWAERF VARCHAR(50) BINARY DEFAULT 'Timesys',PWAALP DECIMAL(1,0) ,PWASPR DECIMAL(3,0)  ,PRIMARY KEY(PWANUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS111PSW ( PSWPNR VARCHAR(8) BINARY ,PSWANZ DECIMAL(5,0) DEFAULT 0,PSWPSW VARCHAR(60) BINARY ,PSWSTA DECIMAL(5,0) DEFAULT 1,PSWDAT DATETIME ,PSWERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PSWPNR,PSWANZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS115DAN ( DANBEN VARCHAR(50) BINARY ,DANFRM VARCHAR(20) BINARY ,DANLFD DECIMAL(5,0) ,DANVAL VARCHAR(20) BINARY ,DANCNT VARCHAR(10) BINARY ,DANDAT DATETIME ,DANKNZ VARCHAR(20) BINARY  ,PRIMARY KEY(DANBEN,DANFRM,DANLFD,DANVAL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS120IMP ( IMPNAM VARCHAR(10) BINARY ,IMPTXT VARCHAR(30) BINARY ,IMPQDT VARCHAR(50) BINARY ,IMPQLB VARCHAR(10) BINARY ,IMPZDT VARCHAR(50) BINARY ,IMPZLB VARCHAR(10) BINARY ,IMPSTA DECIMAL(5,0) ,IMPDAT DATETIME ,IMPERF VARCHAR(50) BINARY  ,PRIMARY KEY(IMPNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS120IMPFIL ( IMPFILNAM VARCHAR(10) BINARY ,IMPFILLFD DECIMAL(5,0) ,IMPFILFLD VARCHAR(50) BINARY ,IMPFILOPR DECIMAL(5,0) ,IMPFILVAL VARCHAR(100) BINARY ,IMPFILLNK VARCHAR(5) BINARY ,IMPFILSTA DECIMAL(1,0) ,IMPFILDAT DATETIME ,IMPFILERF VARCHAR(50) BINARY  ,PRIMARY KEY(IMPFILNAM,IMPFILLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS120IMPFLD ( IMPFLDNAM VARCHAR(10) BINARY ,IMPFLDQFD VARCHAR(30) BINARY ,IMPFLDZFD VARCHAR(30) BINARY ,IMPFLDSTA DECIMAL(1,0) ,IMPFLDDAT DATETIME ,IMPFLDERF VARCHAR(50) BINARY  ,PRIMARY KEY(IMPFLDNAM,IMPFLDQFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS122DIC ( DICKEY VARCHAR(64) BINARY ,DICFNA VARCHAR(9) BINARY ,DICTNA VARCHAR(20) BINARY ,DICFNK VARCHAR(50) BINARY ,DICFNR DECIMAL(11,0) ,DICWHL DECIMAL(5,0) ,DICSTS DECIMAL(5,0) DEFAULT 1,DICDAT DATETIME ,DICERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(DICKEY,DICFNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS122DI2 ( DI2KEY VARCHAR(64) BINARY ,DI2FNA VARCHAR(9) BINARY ,DI2SPR DECIMAL(5,0) ,DI2TXT VARCHAR(120) BINARY ,DI2STS DECIMAL(5,0) DEFAULT 1,DI2DAT DATETIME ,DI2ERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(DI2KEY,DI2FNA,DI2SPR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS130EZK ( EZKAKR VARCHAR(5) BINARY ,EZKZKT VARCHAR(5) BINARY ,EZKEZK VARCHAR(5) BINARY ,EZKDAT DATETIME ,EZKERF VARCHAR(50) BINARY DEFAULT 'Timesys',EZKSTA DECIMAL(1,0) DEFAULT 1,EZKVTP DECIMAL(3,0) DEFAULT 1,EZKWRT DECIMAL(9,2) DEFAULT 1,EZKAEW DECIMAL(2,0) DEFAULT 1,EZKSGR DECIMAL(5,0) ,EZKSKL DECIMAL(5,0)  ,PRIMARY KEY(EZKAKR,EZKZKT,EZKEZK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS130ZKT ( ZKTNUM VARCHAR(5) BINARY ,ZKTTGE DECIMAL(1,0) ,ZKTSTD DECIMAL(1,0) ,ZKTTXT VARCHAR(50) BINARY ,ZKTKTX VARCHAR(10) BINARY ,ZKTAGT DECIMAL(1,0) ,ZKTSNR DECIMAL(5,0) DEFAULT 0,ZKTSTA DECIMAL(5,0) DEFAULT 1,ZKTDAT DATETIME ,ZKTERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZKTPRI DECIMAL(5,0) ,ZKTJAZ DECIMAL(5,0) DEFAULT 1,ZKTJAG DECIMAL(5,0) DEFAULT 1,ZKTSJZ DECIMAL(5,0) DEFAULT 1,ZKTSJG DECIMAL(5,0) DEFAULT 1,ZKTZZ1 VARCHAR(5) BINARY ,ZKTZZ2 VARCHAR(5) BINARY ,ZKTZZ3 VARCHAR(5) BINARY ,ZKTZZ4 VARCHAR(5) BINARY ,ZKTDWH DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(ZKTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS131FCD ( FCDNUM VARCHAR(3) BINARY ,FCDTYP DECIMAL(5,0) DEFAULT 0,FCDKRT VARCHAR(2) BINARY ,FCDZWT DECIMAL(5,0) DEFAULT 1,FCDSTD DECIMAL(5,0) DEFAULT 0,FCDMIN DECIMAL(5,0) DEFAULT 0,FCDMAX DECIMAL(5,0) DEFAULT 0,FCDZKT VARCHAR(5) BINARY ,FCDVHS DECIMAL(1,0) DEFAULT 0,FCDMAB DECIMAL(1,0) DEFAULT 0,FCDFHL DECIMAL(1,0) DEFAULT 0,FCDUNB DECIMAL(1,0) DEFAULT 0,FCDSOL DECIMAL(1,0) DEFAULT 0,FCDPSE DECIMAL(1,0) DEFAULT 0,FCDANW DECIMAL(1,0) DEFAULT 0,FCDZPT DECIMAL(11,0) DEFAULT 1,FCDTRM DECIMAL(1,0) DEFAULT 0,FCDPRI DECIMAL(5,0) DEFAULT 0,FCDLOE DECIMAL(5,0) DEFAULT 0,FCDKOR DECIMAL(1,0) DEFAULT 0,FCDTKT DECIMAL(11,0) DEFAULT 0,FCDWEG DECIMAL(5,0) DEFAULT 0,FCDSTO DECIMAL(1,0) DEFAULT 0,FCDFCD DECIMAL(5,0) DEFAULT 1,FCDSOA DECIMAL(1,0) ,FCDTXT VARCHAR(50) BINARY ,FCDKTX VARCHAR(10) BINARY ,FCDSTA DECIMAL(5,0) DEFAULT 1,FCDDAT DATETIME ,FCDERF VARCHAR(50) BINARY DEFAULT 'Timesys',FCDFLG VARCHAR(3) BINARY ,FCDKSB DECIMAL(1,0) DEFAULT 0,FCDGPU DECIMAL(1,0) ,FCDBZA DECIMAL(1,0) ,FCDMD1 VARCHAR(3) BINARY ,FCDMD2 VARCHAR(3) BINARY ,FCDTFT DECIMAL(1,0) ,FCDINF DECIMAL(5,0) DEFAULT 0,FCDMAP DECIMAL(1,0) DEFAULT 0,FCDAKA DECIMAL(2,0) ,FCDIGN DECIMAL(2,0) ,FCDEVM VARCHAR(3) BINARY ,FCDENM VARCHAR(3) BINARY ,FCDMJS DECIMAL(2,0) ,FCDDWH DECIMAL(1,0) DEFAULT 0,FCDABJ DECIMAL(3,1) ,FCDABM DECIMAL(3,1) ,FCDSTR DECIMAL(1,0) ,FCDKOM DECIMAL(1,0) ,FCDPRF DECIMAL(1,0) ,FCDANZ DECIMAL(1,0) ,FCDCLR DECIMAL(2,0)  ,PRIMARY KEY(FCDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS132ERS ( TTPNUMERS VARCHAR(3) BINARY ,TTPERS VARCHAR(3) BINARY ,TTPTAG DECIMAL(5,0) DEFAULT 1,TTPSTAERS DECIMAL(11,0) DEFAULT 1,TTPDATERS DATETIME ,TTPERFERS VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TTPNUMERS,TTPERS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS132TT2 ( TT2NUM VARCHAR(3) BINARY ,TT2KRT VARCHAR(2) BINARY ,TT2TXT VARCHAR(50) BINARY ,TT2KTX VARCHAR(10) BINARY ,TT2STA DECIMAL(11,0) DEFAULT 1,TT2DAT DATETIME ,TT2ERF VARCHAR(50) BINARY DEFAULT 'Timesys',TT2FTG DECIMAL(1,0)  ,PRIMARY KEY(TT2NUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS133KA2 ( KA2NUM VARCHAR(3) BINARY ,KA2DTM DATETIME ,KA2TTP VARCHAR(3) BINARY ,KA2TXT VARCHAR(50) BINARY ,KA2DAT DATETIME ,KA2ERF VARCHAR(50) BINARY DEFAULT 'Timesys',KA2PTP VARCHAR(3) BINARY ,KA2GWT DECIMAL(3,0) ,KA2BTP VARCHAR(3) BINARY ,KA2CSM VARCHAR(32) BINARY ,KA2STA DECIMAL(5,0) DEFAULT 1,KA2FTG DECIMAL(3,0)  ,PRIMARY KEY(KA2NUM,KA2DTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS134FTG ( FTGKAL VARCHAR(3) BINARY ,FTGNUM DECIMAL(5,0) DEFAULT 0,FTGTTP VARCHAR(3) BINARY DEFAULT '0',FTGSTA DECIMAL(5,0) DEFAULT 1,FTGDAT DATETIME ,FTGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FTGKAL,FTGNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS134FT2 ( FT2KAL VARCHAR(3) BINARY ,FT2TAG VARCHAR(8) BINARY ,FT2NUM DECIMAL(5,0) DEFAULT 0,FT2TTP VARCHAR(3) BINARY DEFAULT '0',FT2ART DECIMAL(1,0) DEFAULT 1 ,PRIMARY KEY(FT2KAL,FT2TAG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS134WFT ( WFTFTG DECIMAL(5,0) DEFAULT 0,WFTTXT VARCHAR(50) BINARY ,WFTSTA DECIMAL(5,0) DEFAULT 1,WFTDAT DATETIME ,WFTERF VARCHAR(50) BINARY DEFAULT 'Timesys',WFTKTX VARCHAR(10) BINARY  ,PRIMARY KEY(WFTFTG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS134WTG ( WTGDTM DATETIME ,WTGFTG DECIMAL(5,0) DEFAULT 0,WTGSTA DECIMAL(5,0) DEFAULT 1,WTGDAT DATETIME ,WTGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(WTGDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS135MU2 ( MU2KAL VARCHAR(3) BINARY ,MU2TXT VARCHAR(50) BINARY ,MU2KTX VARCHAR(10) BINARY ,MU2STA DECIMAL(5,0) DEFAULT 1,MU2DAT DATETIME ,MU2ERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MU2KAL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS136ATG ( ATGNUM VARCHAR(3) BINARY ,ATGDTM DATETIME ,ATGTTP VARCHAR(3) BINARY ,ATGTXT VARCHAR(50) BINARY ,ATGSTA DECIMAL(5,0) DEFAULT 1,ATGDAT DATETIME ,ATGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ATGNUM,ATGDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS137WCH ( WCHKAL VARCHAR(3) BINARY ,WCHTAG DECIMAL(5,0) DEFAULT 0,WCHTTP VARCHAR(3) BINARY DEFAULT '01',WCHSTA DECIMAL(5,0) DEFAULT 1,WCHDAT DATETIME ,WCHERF VARCHAR(50) BINARY DEFAULT 'Timesys',WCHPTP VARCHAR(3) BINARY  ,PRIMARY KEY(WCHKAL,WCHTAG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS140AZT ( AZTNUM VARCHAR(5) BINARY ,AZTVTG DECIMAL(1,0) DEFAULT 0,AZTTXT VARCHAR(50) BINARY ,AZTKTX VARCHAR(10) BINARY ,AZTSTA DECIMAL(5,0) DEFAULT 1,AZTDAT DATETIME ,AZTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(AZTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS140AZV ( AZVNUM VARCHAR(5) BINARY ,AZVGVO DATETIME ,AZVMAV DECIMAL(5,0) DEFAULT 0,AZVMAB DECIMAL(5,0) DEFAULT 0,AZVNOV DECIMAL(5,0) DEFAULT 0,AZVNOB DECIMAL(5,0) DEFAULT 0,AZVGLV DECIMAL(5,0) DEFAULT 0,AZVGLB DECIMAL(5,0) DEFAULT 0,AZVKEV DECIMAL(5,0) DEFAULT 0,AZVKEB DECIMAL(5,0) DEFAULT 0,AZVSOL DECIMAL(5,0) DEFAULT 0,AZVSO2 DECIMAL(5,0) DEFAULT 0,AZVVHS DECIMAL(5,0) DEFAULT 0,AZVHSO DECIMAL(5,0) DEFAULT 0,AZVHS2 DECIMAL(5,0) DEFAULT 0,AZVHTV DECIMAL(5,0) DEFAULT 0,AZVAZP VARCHAR(5) BINARY ,AZVPSM VARCHAR(5) BINARY ,AZVSKZ VARCHAR(2) BINARY ,AZVGLT DECIMAL(5,0) DEFAULT 1,AZVZPZ VARCHAR(2) BINARY ,AZVSTA DECIMAL(5,0) DEFAULT 1,AZVDAT DATETIME ,AZVERF VARCHAR(50) BINARY DEFAULT 'Timesys',AZVGBI DATETIME ,AZVATV DECIMAL(4,0) DEFAULT 0,AZVATB DECIMAL(4,0) DEFAULT 0,AZVSBG DECIMAL(2,0) DEFAULT 1,AZVKMA DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(AZVNUM,AZVGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS141AZP ( AZPNUM VARCHAR(5) BINARY ,AZPMIN DECIMAL(5,0) DEFAULT 0,AZPVOR DECIMAL(5,0) DEFAULT 0,AZPNAC DECIMAL(5,0) DEFAULT 0,AZPVER DECIMAL(5,0) DEFAULT 0,AZPTKT DECIMAL(5,0) DEFAULT 0,AZPTOK DECIMAL(5,0) DEFAULT 0,AZPTOG DECIMAL(5,0) DEFAULT 0,AZPMTK DECIMAL(5,0) DEFAULT 0,AZPMAX DECIMAL(5,0) DEFAULT 0,AZPWEG DECIMAL(5,0) DEFAULT 0,AZPWKT VARCHAR(5) BINARY ,AZPVHM DECIMAL(5,0) DEFAULT 1,AZPVHT DECIMAL(5,0) DEFAULT 0,AZPGMZ DECIMAL(1,0) ,AZPTXT VARCHAR(50) BINARY ,AZPKTX VARCHAR(10) BINARY ,AZPSTA DECIMAL(5,0) DEFAULT 1,AZPDAT DATETIME ,AZPERF VARCHAR(50) BINARY DEFAULT 'Timesys',AZPMAP DECIMAL(5,0) ,AZPZGS DECIMAL(11,0) ,AZPTAK DECIMAL(5,0) ,AZPZMT VARCHAR(5) BINARY  ,PRIMARY KEY(AZPNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS142PSM ( PSMNUM VARCHAR(5) BINARY ,PSMANZ DECIMAL(5,0) DEFAULT 0,PSMVAR DECIMAL(5,0) DEFAULT 0,PSMGEB DECIMAL(1,0) DEFAULT 0,PSMANT DECIMAL(1,0) DEFAULT 0,PSMOPS DECIMAL(1,0) DEFAULT 0,PSMUNT DECIMAL(1,0) DEFAULT 0,PSMANI DECIMAL(1,0) DEFAULT 0,PSMBEZ DECIMAL(5,0) DEFAULT 0,PSMANW DECIMAL(5,0) DEFAULT 0,PSMZSB DECIMAL(1,0) DEFAULT 0,PSMZKT VARCHAR(5) BINARY ,PSMTXT VARCHAR(50) BINARY ,PSMKTX VARCHAR(10) BINARY ,PSMSTA DECIMAL(5,0) DEFAULT 1,PSMDAT DATETIME ,PSMERF VARCHAR(50) BINARY DEFAULT 'Timesys',PSMUZI DECIMAL(1,0) ,PSMBUP DECIMAL(5,0) DEFAULT 0,PSMZUI DECIMAL(1,0) ,PSMGKZ DECIMAL(1,0) ,PSMZPP DECIMAL(1,0)  ,PRIMARY KEY(PSMNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS143PSE ( PSENUM VARCHAR(5) BINARY ,PSELFD DECIMAL(5,0) DEFAULT 1,PSEVON DECIMAL(5,0) DEFAULT 0,PSEBIS DECIMAL(5,0) DEFAULT 0,PSEMIN DECIMAL(5,0) DEFAULT 0,PSEMAX DECIMAL(5,0) DEFAULT 0,PSEINT DECIMAL(5,0) DEFAULT 0,PSEPSE DECIMAL(5,0) DEFAULT 0,PSESTA DECIMAL(5,0) DEFAULT 1,PSEDAT DATETIME ,PSEERF VARCHAR(50) BINARY DEFAULT 'Timesys',PSEBEZ DECIMAL(5,0) DEFAULT 0,PSEZKT VARCHAR(5) BINARY ,PSEAFU DECIMAL(5,0) ,PSEBPU DECIMAL(5,0)  ,PRIMARY KEY(PSENUM,PSELFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS150BSD ( BSDNUM VARCHAR(5) BINARY ,BSDWOA DECIMAL(5,0) ,BSDZFM DECIMAL(1,0) DEFAULT 0,BSDZGA DECIMAL(1,0) ,BSDVHS DECIMAL(1,0) ,BSDZKT VARCHAR(5) BINARY ,BSDAGT DECIMAL(5,0) DEFAULT 0,BSDZKN VARCHAR(5) BINARY ,BSDTGN DECIMAL(5,0) DEFAULT 0,BSDAMP VARCHAR(5) BINARY ,BSDGRV DECIMAL(11,0) DEFAULT 0,BSDGRB DECIMAL(11,0) DEFAULT 0,BSDGEV DECIMAL(11,0) DEFAULT 0,BSDGEB DECIMAL(11,0) DEFAULT 0,BSDZTR DECIMAL(1,0) ,BSDTXT VARCHAR(50) BINARY ,BSDKTX VARCHAR(10) BINARY ,BSDSTA DECIMAL(5,0) DEFAULT 1,BSDDAT DATETIME ,BSDERF VARCHAR(50) BINARY DEFAULT 'Timesys',BSDNPK DECIMAL(11,0) DEFAULT 0,BSDNRM VARCHAR(5) BINARY ,BSDZZU DECIMAL(5,0) DEFAULT 5,BSDZAG DECIMAL(1,0) DEFAULT 1,BSDNPB DECIMAL(11,0) DEFAULT 0,BSDNMV DECIMAL(1,0) DEFAULT 0,BSDSOS DECIMAL(1,0) ,BSDNK1 VARCHAR(5) BINARY ,BSDNK2 VARCHAR(5) BINARY ,BSDNK3 VARCHAR(5) BINARY ,BSDNS1 DECIMAL(11,0) DEFAULT 0,BSDNS2 DECIMAL(11,0) DEFAULT 0,BSDNS3 DECIMAL(11,0) DEFAULT 0 ,PRIMARY KEY(BSDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS150BS1 ( BS1NUM VARCHAR(5) BINARY ,BS1TTP VARCHAR(3) BINARY ,BS1STD DECIMAL(11,0) DEFAULT 0,BS1ZSN VARCHAR(5) BINARY ,BS1ZSM VARCHAR(5) BINARY ,BS1ZKT VARCHAR(5) BINARY ,BS1ZKM VARCHAR(5) BINARY ,BS1ZKZ VARCHAR(5) BINARY ,BS1PRZ DECIMAL(5,0) DEFAULT 0,BS1SUM DECIMAL(1,0) ,BS1ABG DECIMAL(1,0) ,BS1AGT DECIMAL(1,0) ,BS1KZS DECIMAL(1,0) ,BS1TGB DECIMAL(1,0) ,BS1STA DECIMAL(5,0) DEFAULT 1,BS1DAT DATETIME ,BS1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',BS1ZTR DECIMAL(5,0) DEFAULT 6,BS1VON DECIMAL(5,0) DEFAULT 0,BS1BIS DECIMAL(5,0) DEFAULT 1440,BS1GLT DECIMAL(1,0) ,BS1VHS DECIMAL(1,0)  ,PRIMARY KEY(BS1NUM,BS1TTP,BS1STD,BS1ZTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS150BS2 ( BS2NUM VARCHAR(5) BINARY ,BS2STD DECIMAL(11,0) DEFAULT 0,BS2ZKT VARCHAR(5) BINARY ,BS2ZKM VARCHAR(5) BINARY ,BS2ZKZ VARCHAR(5) BINARY ,BS2PRZ DECIMAL(5,0) DEFAULT 0,BS2STA DECIMAL(5,0) DEFAULT 1,BS2DAT DATETIME ,BS2ERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(BS2NUM,BS2STD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS151VRA ( VRANUM VARCHAR(5) BINARY ,VRATXT VARCHAR(50) BINARY ,VRAKTX VARCHAR(10) BINARY ,VRASTA DECIMAL(5,0) DEFAULT 1,VRADAT DATETIME ,VRAERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(VRANUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS151VR1 ( VR1NUM VARCHAR(5) BINARY ,VR1TTP VARCHAR(3) BINARY ,VR1FC1 VARCHAR(3) BINARY ,VR1FC2 VARCHAR(3) BINARY ,VR1FHL VARCHAR(5) BINARY ,VR1ZGS VARCHAR(5) BINARY ,VR1MZP VARCHAR(5) BINARY ,VR1ZZP VARCHAR(5) BINARY ,VR1STA DECIMAL(5,0) DEFAULT 1,VR1DAT DATETIME ,VR1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',VR1VOR DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(VR1NUM,VR1TTP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS152ZSB ( ZSBNUM VARCHAR(5) BINARY ,ZSBTXT VARCHAR(50) BINARY ,ZSBKTX VARCHAR(10) BINARY ,ZSBTAG DECIMAL(1,0) ,ZSBSTA DECIMAL(5,0) DEFAULT 1,ZSBDAT DATETIME ,ZSBERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZSBNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS152ZS1 ( ZS1NUM VARCHAR(5) BINARY ,ZS1LST VARCHAR(3) BINARY DEFAULT '0',ZS1FCD VARCHAR(3) BINARY DEFAULT '0',ZS1ZPZ VARCHAR(2) BINARY ,ZS1VON DECIMAL(5,0) DEFAULT 0,ZS1BIS DECIMAL(5,0) DEFAULT 1440,ZS1ZKT VARCHAR(5) BINARY ,ZS1PRZ DECIMAL(5,0) DEFAULT 0,ZS1STA DECIMAL(5,0) DEFAULT 1,ZS1DAT DATETIME ,ZS1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZS1ZK2 VARCHAR(5) BINARY ,ZS1ZK3 VARCHAR(5) BINARY ,ZS1ZK4 VARCHAR(5) BINARY ,ZS1MKT VARCHAR(5) BINARY ,ZS1MZK VARCHAR(5) BINARY ,ZS1MZP DECIMAL(3,0) ,ZS1Z1G DECIMAL(1,0) ,ZS1Z2G DECIMAL(1,0) ,ZS1Z3G DECIMAL(1,0) ,ZS1Z4G DECIMAL(1,0) ,ZS1PR2 DECIMAL(5,0) DEFAULT 0,ZS1PR3 DECIMAL(5,0) DEFAULT 0,ZS1PR4 DECIMAL(5,0) DEFAULT 0,ZS1Z1N DECIMAL(1,0) DEFAULT 0,ZS1Z2N DECIMAL(1,0) DEFAULT 0,ZS1Z3N DECIMAL(1,0) DEFAULT 0,ZS1Z4N DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(ZS1NUM,ZS1LST,ZS1FCD,ZS1ZPZ,ZS1VON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS153SAL ( SALNUM VARCHAR(5) BINARY ,SALTXT VARCHAR(50) BINARY ,SALKTX VARCHAR(10) BINARY ,SALSTA DECIMAL(5,0) DEFAULT 1,SALDAT DATETIME ,SALERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SALNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS153SA1 ( SA1NUM VARCHAR(5) BINARY ,SA1ZKT VARCHAR(5) BINARY ,SA1ZTR DECIMAL(5,0) DEFAULT 1,SA1LFN DECIMAL(5,0) DEFAULT 0,SA1MAX DECIMAL(11,0) DEFAULT 0,SA1KMX VARCHAR(5) BINARY ,SA1MIN DECIMAL(11,0) DEFAULT 0,SA1KMN VARCHAR(5) BINARY ,SA1PZX DECIMAL(5,0) DEFAULT 0,SA1PZN DECIMAL(5,0) DEFAULT 0,SA1BEG DECIMAL(11,0) DEFAULT 1,SA1GSX DECIMAL(1,0) ,SA1GSN DECIMAL(1,0) ,SA1FKX DECIMAL(5,0) DEFAULT 0,SA1FKN DECIMAL(5,0) DEFAULT 0,SA1TKX DECIMAL(5,0) DEFAULT 0,SA1TKN DECIMAL(5,0) DEFAULT 0,SA1STA DECIMAL(5,0) DEFAULT 1,SA1DAT DATETIME ,SA1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',SA1SDT DATETIME ,SA1EDT DATETIME ,SA1WRT DECIMAL(5,0) ,SA1BSV DECIMAL(1,0) ,SA1NUL DECIMAL(1,0) ,SA1MSB DECIMAL(11,0) ,SA1ZKB VARCHAR(5) BINARY ,SA1UST DECIMAL(1,0) DEFAULT 0,SA1SAM DECIMAL(1,0)  ,PRIMARY KEY(SA1NUM,SA1ZKT,SA1ZTR,SA1LFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS154LFZ ( LFZNUM VARCHAR(5) BINARY ,LFZTG1 DECIMAL(5,0) DEFAULT 0,LFZLT1 DECIMAL(5,0) DEFAULT 0,LFZLZ1 DECIMAL(5,0) DEFAULT 0,LFZTG2 DECIMAL(5,0) DEFAULT 0,LFZLT2 DECIMAL(5,0) DEFAULT 0,LFZLZ2 DECIMAL(5,0) DEFAULT 0,LFZTG3 DECIMAL(5,0) DEFAULT 0,LFZLT3 DECIMAL(5,0) DEFAULT 0,LFZLZ3 DECIMAL(5,0) DEFAULT 0,LFZFCD VARCHAR(3) BINARY ,LFZTXT VARCHAR(50) BINARY ,LFZKTX VARCHAR(10) BINARY ,LFZSTA DECIMAL(5,0) DEFAULT 1,LFZDAT DATETIME ,LFZERF VARCHAR(50) BINARY DEFAULT 'Timesys',LFZTB1 DECIMAL(5,0) DEFAULT 0,LFZFT1 VARCHAR(3) BINARY ,LFZLM1 DECIMAL(5,0) DEFAULT 0,LFZFM1 VARCHAR(3) BINARY ,LFZTB2 DECIMAL(5,0) DEFAULT 0,LFZFT2 VARCHAR(3) BINARY ,LFZLM2 DECIMAL(5,0) DEFAULT 0,LFZFM2 VARCHAR(3) BINARY ,LFZTB3 DECIMAL(5,0) DEFAULT 0,LFZFT3 VARCHAR(3) BINARY ,LFZLM3 DECIMAL(5,0) DEFAULT 0,LFZFM3 VARCHAR(3) BINARY ,LFZTG4 DECIMAL(5,0) ,LFZTB4 DECIMAL(5,0) ,LFZLT4 DECIMAL(5,0) ,LFZFT4 VARCHAR(3) BINARY ,LFZLM4 DECIMAL(5,0) ,LFZFM4 VARCHAR(3) BINARY ,LFZLZ4 DECIMAL(5,0)  ,PRIMARY KEY(LFZNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS154LF1 ( LF1NUM VARCHAR(5) BINARY ,LF1ZRV DECIMAL(5,0) ,LF1ZRB DECIMAL(5,0) ,LF1LT1 DECIMAL(5,0) ,LF1LT2 DECIMAL(5,0) ,LF1FC1 VARCHAR(50) BINARY ,LF1FC2 VARCHAR(50) BINARY ,LF1FZK DECIMAL(5,0) ,LF1STA DECIMAL(5,0) DEFAULT 1,LF1DAT DATETIME ,LF1ERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(LF1NUM,LF1ZRV)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155FTR ( FTRNUM VARCHAR(10) BINARY ,FTRTXT VARCHAR(50) BINARY ,FTRANS VARCHAR(10) BINARY ,FTRR01 VARCHAR(10) BINARY ,FTRR02 VARCHAR(10) BINARY ,FTRR03 VARCHAR(50) BINARY ,FTRSTA DECIMAL(5,0) DEFAULT 1,FTRDAT DATETIME ,FTRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FTRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155SFR ( SFRMOD VARCHAR(5) BINARY ,SFRANZ DECIMAL(5,0) DEFAULT 0,SFRTKT DECIMAL(5,0) DEFAULT 0,SFRMAX DECIMAL(5,0) DEFAULT 0,SFRVMO DECIMAL(5,0) DEFAULT 0,SFRJMO DECIMAL(11,0) DEFAULT 0,SFRTXT VARCHAR(50) BINARY ,SFRKTX VARCHAR(5) BINARY ,SFRSTA DECIMAL(5,0) DEFAULT 1,SFRDAT DATETIME ,SFRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SFRMOD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155SF1 ( SF1NUM VARCHAR(5) BINARY ,SF1AZT VARCHAR(5) BINARY ,SF1ANT DECIMAL(5,0) DEFAULT 0,SF1MIN DECIMAL(5,0) DEFAULT 0,SF1STA DECIMAL(5,0) DEFAULT 1,SF1DAT DATETIME ,SF1ERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SF1NUM,SF1AZT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155SUR ( SURNAM VARCHAR(10) BINARY ,SURTXT VARCHAR(50) BINARY ,SURVMO DECIMAL(2,0) ,SURMAX DECIMAL(5,0) ,SURMIN DECIMAL(5,0) ,SURSTA DECIMAL(5,0) ,SURERF VARCHAR(50) BINARY ,SURDAT DATETIME ,SURMOD DECIMAL(1,0)  ,PRIMARY KEY(SURNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155SU1 ( SU1NAM VARCHAR(10) BINARY ,SU1AGR DECIMAL(5,0) ,SU1MON DECIMAL(2,0) ,SU1TGE DECIMAL(5,0) ,SU1MAX DECIMAL(5,0) ,SU1STA DECIMAL(5,0) ,SU1ERF VARCHAR(50) BINARY ,SU1DAT DATETIME  ,PRIMARY KEY(SU1NAM,SU1AGR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155SU2 ( SU2NAM VARCHAR(10) BINARY ,SU2ZKT VARCHAR(5) BINARY ,SU2STD DECIMAL(5,0) ,SU2TGE DECIMAL(5,0) ,SU2ZK2 VARCHAR(5) BINARY ,SU2ZK3 VARCHAR(5) BINARY ,SU2ZK4 VARCHAR(5) BINARY ,SU2STA DECIMAL(5,0) ,SU2ERF VARCHAR(50) BINARY ,SU2DAT DATETIME  ,PRIMARY KEY(SU2NAM,SU2ZKT,SU2STD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155SU3 ( SU3NAM VARCHAR(10) BINARY ,SU3AGR DECIMAL(5,0) ,SU3STD DECIMAL(5,0) ,SU3TGE DECIMAL(5,0) ,SU3ZKT VARCHAR(5) BINARY ,SU3FKT DECIMAL(3,0) ,SU3ZK1 VARCHAR(5) BINARY ,SU3FK1 DECIMAL(3,0) ,SU3ZK2 VARCHAR(5) BINARY ,SU3FK2 DECIMAL(3,0) ,SU3ZK3 VARCHAR(5) BINARY ,SU3FK3 DECIMAL(3,0) ,SU3STA DECIMAL(5,0) DEFAULT 1,SU3ERF VARCHAR(50) BINARY DEFAULT 'SYSTEM',SU3DAT DATETIME  ,PRIMARY KEY(SU3NAM,SU3AGR,SU3STD,SU3ZKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS155URL ( URLNUM VARCHAR(5) BINARY ,URLVWT DECIMAL(5,0) DEFAULT 1,URLANT DECIMAL(5,0) DEFAULT 1,URLRND DECIMAL(5,0) DEFAULT 1,URLTXT VARCHAR(50) BINARY ,URLKTX VARCHAR(10) BINARY ,URLAL1 DECIMAL(5,0) DEFAULT 0,URLAN1 DECIMAL(7,2) DEFAULT 0,URLAL2 DECIMAL(5,0) DEFAULT 0,URLAN2 DECIMAL(7,2) DEFAULT 0,URLAL3 DECIMAL(5,0) DEFAULT 0,URLAN3 DECIMAL(7,2) DEFAULT 0,URLBZ1 DECIMAL(5,0) DEFAULT 0,URLAB1 DECIMAL(7,2) DEFAULT 0,URLJU1 DECIMAL(7,2) DEFAULT 0,URLBZ2 DECIMAL(5,0) DEFAULT 0,URLAB2 DECIMAL(7,2) DEFAULT 0,URLJU2 DECIMAL(7,2) DEFAULT 0,URLBZ3 DECIMAL(5,0) DEFAULT 0,URLAB3 DECIMAL(7,2) DEFAULT 0,URLJU3 DECIMAL(7,2) DEFAULT 0,URLBG1 DECIMAL(5,0) DEFAULT 0,URLSU1 DECIMAL(7,2) DEFAULT 0,URLBG2 DECIMAL(5,0) DEFAULT 0,URLSU2 DECIMAL(7,2) DEFAULT 0,URLBG3 DECIMAL(5,0) DEFAULT 0,URLSU3 DECIMAL(7,2) DEFAULT 0,URLJMO DECIMAL(5,0) DEFAULT 0,URLVMO DECIMAL(5,0) DEFAULT 0,URLSTA DECIMAL(5,0) DEFAULT 1,URLDAT DATETIME ,URLERF VARCHAR(50) BINARY DEFAULT 'Timesys',URLMAT DECIMAL(2,0) ,URLAST VARCHAR(5) BINARY DEFAULT '31.12',URLBST VARCHAR(5) BINARY DEFAULT '31.12',URLVJB DECIMAL(2,0) ,URLJST VARCHAR(5) BINARY DEFAULT '31.12',URLBJ1 DECIMAL(5,0) DEFAULT 0,URLBJ2 DECIMAL(5,0) DEFAULT 0,URLBJ3 DECIMAL(5,0) DEFAULT 0,URLAJ1 DECIMAL(7,2) DEFAULT 0,URLAJ2 DECIMAL(7,2) DEFAULT 0,URLAJ3 DECIMAL(7,2) DEFAULT 0,URLBMO DECIMAL(1,0) ,URLAVM DECIMAL(2,0)  ,PRIMARY KEY(URLNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS156JAZ ( JAZMOD VARCHAR(5) BINARY ,JAZBEG DATETIME ,JAZEND DATETIME ,JAZTXT VARCHAR(100) BINARY ,JAZSOL DECIMAL(8,0) ,JAZSTD DECIMAL(2,0) ,JAZAGR DECIMAL(1,0) ,JAZWAZ DECIMAL(5,0) ,JAZSTA DECIMAL(1,0) DEFAULT 1,JAZDAT DATETIME ,JAZERF VARCHAR(50) BINARY  ,PRIMARY KEY(JAZMOD,JAZBEG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS156WAZ ( WAZMOD VARCHAR(5) BINARY ,WAZBEG DATETIME ,WAZEND DATETIME ,WAZTXT VARCHAR(100) BINARY ,WAZSOL DECIMAL(8,0) ,WAZSTD DECIMAL(2,0) ,WAZAGR DECIMAL(1,0) ,WAZSTA DECIMAL(1,0) DEFAULT 1,WAZDAT DATETIME ,WAZERF VARCHAR(50) BINARY ,WAZMV1 DECIMAL(5,0) ,WAZMB1 DECIMAL(5,0) ,WAZGV1 DECIMAL(5,0) ,WAZGB1 DECIMAL(5,0) ,WAZNV1 DECIMAL(5,0) ,WAZNB1 DECIMAL(5,0) ,WAZKV1 DECIMAL(5,0) ,WAZKB1 DECIMAL(5,0) ,WAZPM1 VARCHAR(5) BINARY ,WAZAP1 VARCHAR(5) BINARY ,WAZMV2 DECIMAL(5,0) ,WAZMB2 DECIMAL(5,0) ,WAZGV2 DECIMAL(5,0) ,WAZGB2 DECIMAL(5,0) ,WAZNV2 DECIMAL(5,0) ,WAZNB2 DECIMAL(5,0) ,WAZKV2 DECIMAL(5,0) ,WAZKB2 DECIMAL(5,0) ,WAZPM2 VARCHAR(5) BINARY ,WAZAP2 VARCHAR(5) BINARY ,WAZMV3 DECIMAL(5,0) ,WAZMB3 DECIMAL(5,0) ,WAZGV3 DECIMAL(5,0) ,WAZGB3 DECIMAL(5,0) ,WAZNV3 DECIMAL(5,0) ,WAZNB3 DECIMAL(5,0) ,WAZKV3 DECIMAL(5,0) ,WAZKB3 DECIMAL(5,0) ,WAZPM3 VARCHAR(5) BINARY ,WAZAP3 VARCHAR(5) BINARY  ,PRIMARY KEY(WAZMOD,WAZBEG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS157BMD ( BMDNUM VARCHAR(10) BINARY ,BMDTXT VARCHAR(100) BINARY ,BMDKRZ VARCHAR(1) BINARY ,BMDDAT DATETIME ,BMDERF VARCHAR(50) BINARY ,BMDSTA DECIMAL(15,5) DEFAULT 1 ,PRIMARY KEY(BMDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS157BM1 ( BM1NUM VARCHAR(10) BINARY ,BM1LFD DECIMAL(2,0) ,BM1GVO DATETIME ,BM1GBI DATETIME ,BM1BSA DECIMAL(2,0) ,BM1EIN DECIMAL(2,0) ,BM1WTG DECIMAL(2,0) ,BM1TTP VARCHAR(3) BINARY ,BM1GEW DECIMAL(3,0) ,BM1GEE DECIMAL(3,0) ,BM1AZE DECIMAL(1,0) ,BM1UVO DECIMAL(5,0) ,BM1UBI DECIMAL(5,0) ,BM1KKZ VARCHAR(2) BINARY ,BM1ZKT VARCHAR(5) BINARY ,BM1ANW DECIMAL(1,0) ,BM1ZKE VARCHAR(5) BINARY ,BM1DAT DATETIME ,BM1ERF VARCHAR(50) BINARY ,BM1STA DECIMAL(15,5) DEFAULT 1 ,PRIMARY KEY(BM1NUM,BM1LFD,BM1GVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS160AGR ( AGRNUM VARCHAR(5) BINARY ,AGRTGE DECIMAL(5,0) DEFAULT 0,AGRSOL DECIMAL(11,0) DEFAULT 0,AGRSTG DECIMAL(5,0) DEFAULT 0,AGRZUO DECIMAL(1,0) ,AGRTXT VARCHAR(50) BINARY ,AGRKTX VARCHAR(10) BINARY ,AGRSTA DECIMAL(5,0) DEFAULT 1,AGRDAT DATETIME ,AGRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(AGRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS160AG1 ( AG1NUM VARCHAR(5) BINARY ,AG1GVO DATETIME ,AG1GBI DATETIME ,AG1TGE DECIMAL(22,0) ,AG1SOL DECIMAL(22,0) ,AG1STG DECIMAL(22,0) ,AG1ZUO DECIMAL(22,0) ,AG1TXT VARCHAR(50) BINARY ,AG1STA DECIMAL(22,0) ,AG1DAT DATETIME ,AG1ERF VARCHAR(50) BINARY  ,PRIMARY KEY(AG1NUM,AG1GVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS161WPL ( WPLAGR VARCHAR(5) BINARY ,WPLTAG DECIMAL(5,0) DEFAULT 1,WPLAZT VARCHAR(5) BINARY ,WPLVRA VARCHAR(5) BINARY ,WPLAZE DECIMAL(5,0) DEFAULT 1,WPLSTA DECIMAL(5,0) DEFAULT 1,WPLDAT DATETIME ,WPLERF VARCHAR(50) BINARY DEFAULT 'Timesys',WPLVAR DECIMAL(1,0) ,WPLBSD VARCHAR(5) BINARY ,WPLGVO DATETIME ,WPLGBI DATETIME  ,PRIMARY KEY(WPLAGR,WPLTAG,WPLGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS162ERS ( ERSAGR VARCHAR(5) BINARY ,ERSAZT VARCHAR(5) BINARY ,ERSAZE VARCHAR(5) BINARY ,ERSVRA VARCHAR(5) BINARY ,ERSSTA DECIMAL(5,0) DEFAULT 1,ERSDAT DATETIME ,ERSERF VARCHAR(50) BINARY DEFAULT 'Timesys',ERSBSD VARCHAR(5) BINARY ,ERSTLZ DECIMAL(5,0) DEFAULT 0,ERSTLA DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(ERSAGR,ERSAZT,ERSAZE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS170LGP ( LGPNUM VARCHAR(5) BINARY ,LGPTXT VARCHAR(50) BINARY ,LGPKTX VARCHAR(5) BINARY ,LGPSTA DECIMAL(5,0) DEFAULT 1,LGPDAT DATETIME ,LGPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(LGPNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS170LG1 ( LG1NUM VARCHAR(5) BINARY ,LG1STZ VARCHAR(5) BINARY ,LG1TXT VARCHAR(50) BINARY ,LG1KTX VARCHAR(5) BINARY ,LG1STA DECIMAL(5,0) DEFAULT 1,LG1DAT DATETIME ,LG1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',LG1STT DECIMAL(1,0) DEFAULT 0,LG1SVT DECIMAL(1,0) DEFAULT 0,LG1ZES DECIMAL(1,0) DEFAULT 0,LG1P4A DECIMAL(1,0)  ,PRIMARY KEY(LG1NUM,LG1STZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS171LUG ( LUGLUG VARCHAR(5) BINARY ,LUGLGP VARCHAR(5) BINARY ,LUGANZ DECIMAL(5,0) DEFAULT 1,LUGDTM DECIMAL(5,0) DEFAULT 1,LUGMON DECIMAL(5,0) DEFAULT 0,LUGUNT DECIMAL(5,0) DEFAULT 5,LUGFIR VARCHAR(10) BINARY ,LUGAKR VARCHAR(10) BINARY ,LUGPNR DECIMAL(1,0) ,LUGTXT VARCHAR(50) BINARY ,LUGKTX VARCHAR(5) BINARY ,LUGSTA DECIMAL(5,0) DEFAULT 1,LUGDAT DATETIME ,LUGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(LUGLUG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS171LU1 ( LU1NUM VARCHAR(5) BINARY ,LU1STZ VARCHAR(5) BINARY ,LU1ZTK VARCHAR(5) BINARY ,LU1LNA VARCHAR(5) BINARY ,LU1LGR VARCHAR(5) BINARY ,LU1GVO DATETIME ,LU1GBI DATETIME ,LU1RRE DECIMAL(1,0) DEFAULT 0,LU1TGW DECIMAL(1,0) DEFAULT 0,LU1KST DECIMAL(1,0) DEFAULT 0,LU1KTR DECIMAL(1,0) DEFAULT 0,LU1KRT DECIMAL(1,0) DEFAULT 0,LU1TGE DECIMAL(1,0) DEFAULT 0,LU1SOL DECIMAL(1,0) DEFAULT 0,LU1SVK DECIMAL(1,0) DEFAULT 0,LU1FLG DECIMAL(1,0) DEFAULT 0,LU1LFN DECIMAL(5,0) DEFAULT 1,LU1STS DECIMAL(5,0) DEFAULT 1,LU1FKT DECIMAL(5,0) DEFAULT 0,LU1ZTR DECIMAL(1,0) ,LU1MOG DECIMAL(5,2) ,LU1STA DECIMAL(5,0) DEFAULT 1,LU1DAT DATETIME ,LU1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',LU1ART DECIMAL(5,0) DEFAULT 0,LU1FKZ VARCHAR(1) BINARY ,LU1BAU DECIMAL(1,0)  ,PRIMARY KEY(LU1NUM,LU1STZ,LU1ZTK,LU1LNA,LU1GVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS172LGU ( LGULGP VARCHAR(5) BINARY ,LGUZPK VARCHAR(14) BINARY ,LGUFIR VARCHAR(5) BINARY ,LGUPOS DECIMAL(5,0) DEFAULT 0,LGUZPW VARCHAR(14) BINARY DEFAULT ' ',LGUANZ DECIMAL(5,0) DEFAULT 0,LGUERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(LGULGP,LGUZPK,LGUFIR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS173IMP ( IMPUSR VARCHAR(50) BINARY ,IMPPNR VARCHAR(8) BINARY ,IMPNAM VARCHAR(50) BINARY ,IMPVNM VARCHAR(50) BINARY ,IMPORT VARCHAR(50) BINARY ,IMPSTR VARCHAR(50) BINARY ,IMPPLZ VARCHAR(10) BINARY ,IMPGEB VARCHAR(8) BINARY ,IMPEIN VARCHAR(8) BINARY ,IMPAUS VARCHAR(8) BINARY ,IMPGVO VARCHAR(8) BINARY ,IMPGBI VARCHAR(8) BINARY ,IMPKST VARCHAR(30) BINARY ,IMPABT VARCHAR(15) BINARY ,IMPABK VARCHAR(5) BINARY ,IMPTEL VARCHAR(30) BINARY ,IMPLKZ VARCHAR(1) BINARY ,IMPLPN VARCHAR(10) BINARY ,IMPANR VARCHAR(5) BINARY ,IMPFIR VARCHAR(5) BINARY ,IMPBEA VARCHAR(5) BINARY ,IMPERF VARCHAR(50) BINARY DEFAULT 'Timesys',IMPTIT DECIMAL(5,0) ,IMPMOB VARCHAR(30) BINARY ,IMPEML VARCHAR(50) BINARY ,IMPTTX VARCHAR(50) BINARY  ,PRIMARY KEY(IMPUSR,IMPPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS180FSS ( FSSNUM VARCHAR(5) BINARY ,FSSLNA VARCHAR(5) BINARY ,FSSUVO DECIMAL(5,0) DEFAULT 0,FSSSTD DECIMAL(7,2) DEFAULT 0,FSSTXT VARCHAR(50) BINARY ,FSSSTA DECIMAL(5,0) DEFAULT 1,FSSDAT DATETIME ,FSSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FSSNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS181FS1 ( FS1NUM VARCHAR(5) BINARY ,FS1GRP VARCHAR(10) BINARY DEFAULT '(0)',FS1STA DECIMAL(1,0) DEFAULT 1,FS1DAT DATETIME ,FS1ERF VARCHAR(50) BINARY DEFAULT 'Timesys',FS1GRS DECIMAL(2,0) DEFAULT 1,FS1PNR VARCHAR(8) BINARY DEFAULT NULL,FS1VRA VARCHAR(5) BINARY DEFAULT '(0)',FS1ABT VARCHAR(15) BINARY DEFAULT '(0)',FS1AKR VARCHAR(5) BINARY DEFAULT '(0)',FS1KST VARCHAR(10) BINARY DEFAULT '(0)',FS1AGR VARCHAR(5) BINARY DEFAULT '(0)' ,PRIMARY KEY(FS1NUM,FS1GRS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS200PRM ( PRMK01 VARCHAR(50) BINARY ,PRMK02 VARCHAR(50) BINARY ,PRMC01 VARCHAR(50) BINARY ,PRMC02 VARCHAR(50) BINARY ,PRMC03 VARCHAR(50) BINARY ,PRMC04 VARCHAR(50) BINARY ,PRMN01 DECIMAL(11,0) DEFAULT 0,PRMN02 DECIMAL(5,0) DEFAULT 0,PRMSTA DECIMAL(1,0) ,PRMDAT DATETIME ,PRMERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(PRMK01,PRMK02,PRMC01,PRMC02)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS201ZRT ( ZRTANM VARCHAR(50) BINARY ,ZRTPNR VARCHAR(8) BINARY ,ZRTGRP VARCHAR(50) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS202MTL ( MTLNAM VARCHAR(50) BINARY ,MTLTXT VARCHAR(50) BINARY ,MTLGRP DECIMAL(2,0) DEFAULT 0,MTLGAW VARCHAR(2048) BINARY ,MTLGVO VARCHAR(50) BINARY ,MTLGBI VARCHAR(50) BINARY ,MTLINT VARCHAR(20) BINARY ,MTLIVO VARCHAR(10) BINARY ,MTLIBI VARCHAR(10) BINARY ,MTLIWT VARCHAR(30) BINARY ,MTLIUH VARCHAR(20) BINARY ,MTLMTL VARCHAR(2048) BINARY ,MTLVRD VARCHAR(20) BINARY ,MTLNVR VARCHAR(20) BINARY ,MTLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',MTLDAT DATETIME ,MTLSTA DECIMAL(5,0) DEFAULT 1 ,PRIMARY KEY(MTLNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS202MTP ( MTPNAM VARCHAR(50) BINARY ,MTPPNR VARCHAR(50) BINARY ,MTPVRS VARCHAR(1) BINARY ,MTPVRD VARCHAR(14) BINARY ,MTPZUS VARCHAR(1) BINARY ,MTPZUD VARCHAR(14) BINARY ,MTPGLS VARCHAR(1) BINARY ,MTPGLD VARCHAR(14) BINARY  ,PRIMARY KEY(MTPNAM,MTPPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS202MWS ( MWSNAM VARCHAR(50) BINARY ,MWSPNR VARCHAR(50) BINARY ,MWSVRD VARCHAR(14) BINARY ,MWSZUD VARCHAR(14) BINARY ,MWSGLD VARCHAR(14) BINARY ,MWSERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',MWSDAT DATETIME ,MWSSTA DECIMAL(5,0) DEFAULT 1,MWSVAL VARCHAR(2048) BINARY  ,PRIMARY KEY(MWSNAM,MWSPNR,MWSVRD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS300MSG ( MSGART VARCHAR(1) BINARY ,MSGSTS DECIMAL(1,0) ,MSGSBE VARCHAR(8) BINARY ,MSGDTM VARCHAR(8) BINARY ,MSGPNR VARCHAR(8) BINARY ,MSGFTX DECIMAL(11,0) ,MSGWHL DECIMAL(5,0) ,MSGINH VARCHAR(100) BINARY ,MSGSDT VARCHAR(8) BINARY  ,PRIMARY KEY(MSGART,MSGSTS,MSGSBE,MSGDTM,MSGPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS300PKT ( PKTPNR VARCHAR(8) BINARY ,PKTDTM DATETIME ,PKTSOL DECIMAL(5,0) ,PKTKTM DECIMAL(5,1) ,PKTUTM DECIMAL(5,1) ,PKTGLM DECIMAL(5,0) ,PKTMEM DECIMAL(5,0) ,PKTSTA DECIMAL(1,0) ,PKTDAT DATETIME ,PKTERF VARCHAR(50) BINARY DEFAULT 'timesys',PKTKRT DECIMAL(5,1)  ,PRIMARY KEY(PKTPNR,PKTDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS300PNR ( PNRNUM VARCHAR(8) BINARY ,PNRANM VARCHAR(50) BINARY ,PNRAKT DATETIME ,PNREND DATETIME ,PNREML VARCHAR(50) BINARY ,PNRMRT VARCHAR(15) BINARY ,PNRFRT VARCHAR(15) BINARY ,PNRSRT VARCHAR(15) BINARY ,PNRBEA DECIMAL(5,0) ,PNRGEB DATETIME ,PNREIN DATETIME ,PNRNAM VARCHAR(50) BINARY ,PNRSTR VARCHAR(50) BINARY ,PNRPLZ VARCHAR(10) BINARY ,PNRORT VARCHAR(50) BINARY ,PNRTEL VARCHAR(30) BINARY ,PNRMOB VARCHAR(30) BINARY ,PNRTIT DECIMAL(5,0) ,PNRANR DECIMAL(5,0) ,PNRNEB VARCHAR(8) BINARY ,PNRLUG VARCHAR(10) BINARY ,PNRSTA DECIMAL(5,0) ,PNRDAT DATETIME ,PNRERF VARCHAR(50) BINARY ,PNRSAL VARCHAR(10) BINARY ,PNRSPR DECIMAL(5,0) ,PNRFRE VARCHAR(20) BINARY ,PNRMTA DECIMAL(2,0) ,PNRGBI DATETIME ,PNRKRD VARCHAR(20) BINARY ,PNRPRT VARCHAR(15) BINARY ,PNRLDA DECIMAL(1,0) DEFAULT 0,PNRFMO VARCHAR(30) BINARY ,PNRAGE DECIMAL(1,0) DEFAULT 0,PNR1NM VARCHAR(50) BINARY ,PNR2NM VARCHAR(50) BINARY ,PNRNBU DECIMAL(1,0) DEFAULT 0,PNRAZU DECIMAL(5,0) DEFAULT 0,PNRABF VARCHAR(150) BINARY ,PNRABE VARCHAR(50) BINARY  ,PRIMARY KEY(PNRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS300PRD ( PRDPNR VARCHAR(8) BINARY ,PRDVVN VARCHAR(8) BINARY ,PRDVBI VARCHAR(8) BINARY ,PRDAVN VARCHAR(8) BINARY ,PRDABI VARCHAR(8) BINARY ,PRDRVVN VARCHAR(8) BINARY ,PRDRVBI VARCHAR(8) BINARY ,PRDRAVN VARCHAR(8) BINARY ,PRDRABI VARCHAR(8) BINARY ,PRDDVVN DATETIME ,PRDDVBI DATETIME ,PRDDAVN DATETIME ,PRDDABI DATETIME ,PRDDRVVN DATETIME ,PRDDRVBI DATETIME ,PRDDRAVN DATETIME ,PRDDRABI DATETIME ,PRDDAT DATETIME  ,PRIMARY KEY(PRDPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS303SBE ( SBEPNR VARCHAR(8) BINARY ,SBEMRT VARCHAR(15) BINARY ,SBEPRT VARCHAR(15) BINARY ,SBEFRT VARCHAR(15) BINARY ,SBESRT VARCHAR(15) BINARY ,SBEBEA DECIMAL(5,0) DEFAULT 5,SBEDYN DECIMAL(1,0) ,SBESTA DECIMAL(5,0) DEFAULT 1,SBEDAT DATETIME ,SBEERF VARCHAR(50) BINARY DEFAULT 'Timesys',SBEFRE VARCHAR(20) BINARY ,SBETXT DECIMAL(1,0) DEFAULT 0,SBEANM VARCHAR(50) BINARY ,SBETGB DECIMAL(1,0) ,SBEDTQ VARCHAR(50) BINARY ,SBELDA DECIMAL(1,0) DEFAULT 0,SBETGA DECIMAL(5,0) DEFAULT -9,SBEADM DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(SBEPNR,SBEANM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS305BVL ( BVLNAM VARCHAR(50) BINARY ,BVLASW VARCHAR(50) BINARY ,BVLGVD DATETIME ,BVLTRM VARCHAR(255) BINARY ,BVLLES DECIMAL(5,0) DEFAULT 0,BVLSTA DECIMAL(5,0) DEFAULT 1,BVLDAT DATETIME ,BVLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(BVLNAM,BVLASW,BVLGVD,BVLTRM,BVLLES)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS305BVW ( BVWNAM VARCHAR(50) BINARY ,BVWFIR VARCHAR(50) BINARY ,BVWFAD VARCHAR(256) BINARY ,BVWKNZ VARCHAR(30) BINARY ,BVWMOB VARCHAR(30) BINARY ,BVWFAT VARCHAR(30) BINARY ,BVWMAR VARCHAR(50) BINARY ,BVWABT VARCHAR(15) BINARY ,BVWMTE VARCHAR(30) BINARY ,BVWBEM VARCHAR(256) BINARY ,BVWASW VARCHAR(50) BINARY ,BVWGVD DATETIME ,BVWGBD DATETIME ,BVWGVU DECIMAL(5,0) DEFAULT 0,BVWGBU DECIMAL(5,0) DEFAULT 0,BVWSTA DECIMAL(5,0) DEFAULT 1,BVWDAT DATETIME ,BVWERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(BVWNAM,BVWASW,BVWGVD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS310BSV ( BSVPNR VARCHAR(8) BINARY ,BSVGVO DATETIME ,BSVGBI DATETIME ,BSVAKR VARCHAR(5) BINARY ,BSVKAL VARCHAR(5) BINARY ,BSVSAL VARCHAR(5) BINARY ,BSVURL VARCHAR(5) BINARY ,BSVLFZ VARCHAR(5) BINARY ,BSVSFR VARCHAR(5) BINARY ,BSVTGS DECIMAL(11,0) DEFAULT 0,BSVWCH DECIMAL(11,0) DEFAULT 0,BSVMON DECIMAL(11,0) DEFAULT 0,BSVJHR DECIMAL(11,0) DEFAULT 0,BSVAGM DECIMAL(11,0) DEFAULT 0,BSVABR VARCHAR(5) BINARY ,BSVSTA DECIMAL(5,0) DEFAULT 1,BSVDAT DATETIME ,BSVERF VARCHAR(50) BINARY DEFAULT 'Timesys',BSVBGR DECIMAL(5,0) DEFAULT 0,BSVLUG VARCHAR(10) BINARY DEFAULT '0',BSVJAZ DECIMAL(5,0) ,BSVJUR DECIMAL(1,0) ,BSVAGV DECIMAL(1,0) ,BSVBON DECIMAL(5,0) DEFAULT 0,BSVBDE DECIMAL(1,0) DEFAULT 0,BSVPEP DECIMAL(1,0) DEFAULT 0,BSVDMS DECIMAL(11,0) DEFAULT 0,BSVPNM VARCHAR(50) BINARY ,BSVRE0 VARCHAR(50) BINARY ,BSVRE1 VARCHAR(50) BINARY ,BSVRE2 VARCHAR(50) BINARY ,BSVRE3 VARCHAR(50) BINARY ,BSVRE4 VARCHAR(50) BINARY ,BSVRE5 VARCHAR(50) BINARY ,BSVRE6 VARCHAR(50) BINARY ,BSVRE7 VARCHAR(50) BINARY ,BSVRE8 VARCHAR(50) BINARY ,BSVRE9 VARCHAR(50) BINARY ,BSVDWT DECIMAL(5,2) DEFAULT 5,BSVPZM DECIMAL(1,0) DEFAULT 0,BSVZUT DECIMAL(1,0) DEFAULT 0,BSVMAP DECIMAL(1,0) DEFAULT 0,BSVDWH DECIMAL(1,0) DEFAULT 0,BSVPSI DECIMAL(1,0) DEFAULT 0,BSVMMA DECIMAL(5,0) ,BSVPRZ DECIMAL(5,2) ,BSVJAM VARCHAR(5) BINARY ,BSVSUL VARCHAR(10) BINARY ,BSVKSM DECIMAL(1,0) ,BSVKSW DECIMAL(1,0) ,BSVWAM VARCHAR(5) BINARY ,BSVWPZ DECIMAL(5,2) ,BSVWAR DECIMAL(3,0) ,BSVFST VARCHAR(6) BINARY DEFAULT null,BSVNEU VARCHAR(6) BINARY  ,PRIMARY KEY(BSVPNR,BSVGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS311ZUO ( ZUOPNR VARCHAR(8) BINARY ,ZUOGVO DATETIME ,ZUOGBI DATETIME ,ZUOABT VARCHAR(15) BINARY ,ZUOVRA VARCHAR(5) BINARY ,ZUOAGR VARCHAR(5) BINARY ,ZUOSDT DATETIME ,ZUOSTG DECIMAL(5,0) DEFAULT 0,ZUOKST VARCHAR(30) BINARY ,ZUOKTR VARCHAR(6) BINARY DEFAULT '0',ZUOKRT VARCHAR(4) BINARY DEFAULT '0',ZUOSTA DECIMAL(5,0) DEFAULT 1,ZUODAT DATETIME ,ZUOERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZUOKTA VARCHAR(10) BINARY ,ZUOABA VARCHAR(15) BINARY ,ZUOTRG VARCHAR(15) BINARY ,ZUOBRA VARCHAR(5) BINARY ,ZUOKSA VARCHAR(15) BINARY ,ZUOKAA VARCHAR(15) BINARY ,ZUOKSB DECIMAL(1,0) DEFAULT 0,ZUOPNM VARCHAR(50) BINARY  ,PRIMARY KEY(ZUOPNR,ZUOGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS312KSV ( KSVPNR VARCHAR(8) BINARY ,KSVGVO DATETIME ,KSVKST VARCHAR(30) BINARY ,KSVGBI DATETIME ,KSVPZT DECIMAL(5,0) DEFAULT 0,KSVKTR VARCHAR(6) BINARY ,KSVKRT VARCHAR(4) BINARY ,KSVRNG DECIMAL(5,0) DEFAULT 0,KSVSTA DECIMAL(5,0) DEFAULT 1,KSVDAT DATETIME ,KSVERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KSVPNR,KSVGVO,KSVKST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320LBR ( LBRPNR VARCHAR(8) BINARY ,LBRDTM DATETIME ,LBRSPB DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(LBRPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320LB2 ( LB2PNR VARCHAR(8) BINARY ,LB2DVO DATETIME ,LB2DBI DATETIME  ,PRIMARY KEY(LB2PNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320LB3 ( LB3PNR VARCHAR(8) BINARY ,LB3DTM DATETIME  ,PRIMARY KEY(LB3PNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320LB4 ( LBRSBE VARCHAR(8) BINARY ,LBRPNR VARCHAR(8) BINARY ,LBRDTM DATETIME ,LBRSPB DECIMAL(1,0) DEFAULT 0,LBRTGB DECIMAL(1,0) DEFAULT 0,LBRPKT DECIMAL(1,0) DEFAULT 0,LBRBIS DATETIME  ,PRIMARY KEY(LBRSBE,LBRPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320SAL ( SALPNR VARCHAR(8) BINARY ,SALDTM DECIMAL(8,0) ,SALMIN DECIMAL(4,0) DEFAULT 0,SALSA1 DECIMAL(11,0) DEFAULT 0,SALSA2 DECIMAL(11,0) DEFAULT 0,SALSA3 DECIMAL(11,0) DEFAULT 0,SALSA4 DECIMAL(11,0) DEFAULT 0,SALSA5 DECIMAL(11,0) DEFAULT 0,SALSA6 DECIMAL(11,0) DEFAULT 0,SALSA7 DECIMAL(11,0) DEFAULT 0 ,PRIMARY KEY(SALPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320SVT ( SVTPNR VARCHAR(8) BINARY ,SVTDTM DATETIME ,SVTVT1 DECIMAL(11,0) DEFAULT 0,SVTVT2 DECIMAL(11,0) DEFAULT 0,SVTVT3 DECIMAL(11,0) DEFAULT 0,SVTVT4 DECIMAL(11,0) DEFAULT 0,SVTVT5 DECIMAL(11,0) DEFAULT 0,SVTVT6 DECIMAL(11,0) DEFAULT 0,SVTVT7 DECIMAL(11,0) DEFAULT 0,SVTSTA DECIMAL(5,0) DEFAULT 1,SVTDAT DATETIME ,SVTERF VARCHAR(50) BINARY ,SVTNPK DECIMAL(5,0) ,SVTUGL DECIMAL(1,0) DEFAULT 0,SVTUMA DECIMAL(1,0) DEFAULT 0,SVTUVZ DECIMAL(1,0) DEFAULT 0,SVTUJZ DECIMAL(1,0) DEFAULT 0,SVTUS5 DECIMAL(1,0) DEFAULT 0,SVTUS6 DECIMAL(1,0) DEFAULT 0,SVTUS7 DECIMAL(1,0) DEFAULT 0,SVTUNP DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(SVTPNR,SVTDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320SV2 ( SV2PNR VARCHAR(8) BINARY ,SV2DTM DATETIME ,SV2VT1 DECIMAL(11,0) DEFAULT 0,SV2VT2 DECIMAL(11,0) DEFAULT 0,SV2VT3 DECIMAL(11,0) DEFAULT 0,SV2VT4 DECIMAL(11,0) DEFAULT 0,SV2VT5 DECIMAL(11,0) DEFAULT 0,SV2VT6 DECIMAL(11,0) DEFAULT 0,SV2VT7 DECIMAL(11,0) DEFAULT 0,SV2DAT DATETIME ,SV2ERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',SV2UGL DECIMAL(1,0) DEFAULT 0,SV2UMA DECIMAL(1,0) DEFAULT 0,SV2UVZ DECIMAL(1,0) DEFAULT 0,SV2UJZ DECIMAL(1,0) DEFAULT 0,SV2US5 DECIMAL(1,0) DEFAULT 0,SV2US6 DECIMAL(1,0) DEFAULT 0,SV2US7 DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(SV2PNR,SV2DTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS320TGB ( TGBPNR VARCHAR(8) BINARY ,TGBZTR DECIMAL(11,0) DEFAULT 1,TGBDTM DATETIME ,TGBWCH DECIMAL(5,0) DEFAULT 0,TGBMON DECIMAL(5,0) DEFAULT 0,TGBVAB DECIMAL(11,0) DEFAULT 0,TGBVTK DECIMAL(11,0) DEFAULT 0,TGBNAE DECIMAL(11,0) DEFAULT 0,TGBNTK DECIMAL(11,0) DEFAULT 0,TGBMAB DECIMAL(11,0) DEFAULT 0,TGBMTK DECIMAL(11,0) DEFAULT 0,TGBSOL DECIMAL(11,0) DEFAULT 0,TGBVHS DECIMAL(11,0) DEFAULT 0,TGBBEZ DECIMAL(11,0) DEFAULT 0,TGBUNB DECIMAL(11,0) DEFAULT 0,TGBFHZ DECIMAL(11,0) DEFAULT 0,TGBVHI DECIMAL(11,0) DEFAULT 0,TGBZGS DECIMAL(11,0) DEFAULT 0,TGBZSD DECIMAL(11,0) DEFAULT 0,TGBNVZ DECIMAL(11,0) DEFAULT 0,TGBSA1 DECIMAL(11,0) DEFAULT 0,TGBSA2 DECIMAL(11,0) DEFAULT 0,TGBSA3 DECIMAL(11,0) DEFAULT 0,TGBSA4 DECIMAL(11,0) DEFAULT 0,TGBSA5 DECIMAL(11,0) DEFAULT 0,TGBSA6 DECIMAL(11,0) DEFAULT 0,TGBSA7 DECIMAL(11,0) DEFAULT 0,TGBPSE DECIMAL(11,0) DEFAULT 0,TGBPBZ DECIMAL(11,0) DEFAULT 0,TGBZST DECIMAL(11,0) DEFAULT 0,TGBZPR DECIMAL(5,0) DEFAULT 0,TGBZKT VARCHAR(5) BINARY ,TGBFZT DECIMAL(11,0) DEFAULT 0,TGBABG DECIMAL(11,0) DEFAULT 0,TGBMAX DECIMAL(5,0) DEFAULT 0,TGBSOI DECIMAL(5,0) DEFAULT 0,TGBGVA DECIMAL(11,0) DEFAULT 0,TGBGNA DECIMAL(11,0) DEFAULT 0,TGBGZR DECIMAL(5,0) DEFAULT 1,TGBRZT DECIMAL(11,0) DEFAULT 0,TGBSTA DECIMAL(5,0) DEFAULT 1,TGBDAT DATETIME ,TGBERF VARCHAR(50) BINARY DEFAULT 'Timesys',TGBNRM DECIMAL(6,0) ,TGBVT1 DECIMAL(11,0) ,TGBVT2 DECIMAL(11,0) ,TGBVT3 DECIMAL(11,0) ,TGBVT4 DECIMAL(11,0) ,TGBVT5 DECIMAL(11,0) ,TGBVT6 DECIMAL(11,0) ,TGBVT7 DECIMAL(11,0) ,TGBNAF DECIMAL(11,0) ,TGBBEA DECIMAL(2,0) ,TGBSO2 DECIMAL(11,0) ,TGBVO2 DECIMAL(11,0)  ,PRIMARY KEY(TGBPNR,TGBZTR,TGBDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS321BCH ( BCHPNR VARCHAR(8) BINARY ,BCHVON DATETIME ,BCHUHR DATETIME ,BCHFKT DECIMAL(5,0) DEFAULT 1,BCHBIS DATETIME ,BCHVWS DATETIME ,BCHFCD VARCHAR(3) BINARY ,BCHZWT DECIMAL(5,0) DEFAULT 0,BCHABT VARCHAR(15) BINARY ,BCHKST VARCHAR(30) BINARY ,BCHKTR VARCHAR(6) BINARY ,BCHKRT VARCHAR(4) BINARY ,BCHAZT VARCHAR(5) BINARY ,BCHVRA VARCHAR(5) BINARY ,BCHTXT DECIMAL(11,0) DEFAULT null,BCHSTA DECIMAL(5,0) DEFAULT 1,BCHERF VARCHAR(50) BINARY DEFAULT 'Timesys',BCHTRM VARCHAR(255) BINARY ,BCHDAT TIMESTAMP,BCHZPK VARCHAR(14) BINARY  ,PRIMARY KEY(BCHPNR,BCHVON,BCHUHR,BCHFKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS321BEM ( BEMNUM DECIMAL(11,0) ,BEMFCD VARCHAR(3) BINARY ,BEMTXT VARCHAR(255) BINARY ,BEMSTA DECIMAL(5,0) DEFAULT 1,BEMDAT DATETIME ,BEMERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(BEMNUM,BEMFCD,BEMTXT) ,CONSTRAINT TMS321BEM_UK UNIQUE(BEMNUM) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS321KAN ( KANPOR VARCHAR(2) BINARY ,KANFCD VARCHAR(2) BINARY ,KANDTM VARCHAR(8) BINARY ,KANUHR VARCHAR(4) BINARY ,KANMSK VARCHAR(3) BINARY ,KANAWN VARCHAR(13) BINARY ,KANDAT VARCHAR(66) BINARY  ,PRIMARY KEY(KANDTM,KANUHR,KANAWN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS321KTK ( KTKPNR VARCHAR(8) BINARY ,KTKVON DATETIME ,KTKZTR DECIMAL(5,0) DEFAULT 1,KTKZKT VARCHAR(5) BINARY ,KTKSTD DECIMAL(11,0) DEFAULT 0,KTKZKN VARCHAR(5) BINARY ,KTKPRZ DECIMAL(5,0) DEFAULT 0,KTKTXT DECIMAL(11,0) DEFAULT 0,KTKSTA DECIMAL(5,0) DEFAULT 1,KTKDAT DATETIME ,KTKERF VARCHAR(50) BINARY DEFAULT 'Timesys',KTKVTG DECIMAL(1,0) ,KTKSAL DECIMAL(1,0) ,KTKKSV VARCHAR(30) BINARY ,KTKKTV VARCHAR(6) BINARY ,KTKKRV VARCHAR(4) BINARY ,KTKKSN VARCHAR(30) BINARY ,KTKKTN VARCHAR(6) BINARY ,KTKKRN VARCHAR(4) BINARY ,KTKLFN DECIMAL(3,0) DEFAULT 1,KTKBEM VARCHAR(100) BINARY  ,PRIMARY KEY(KTKPNR,KTKVON,KTKZTR,KTKZKT,KTKLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS321UZG ( UZGPNR VARCHAR(8) BINARY ,UZGVON DATETIME ,UZGZTR DECIMAL(5,0) DEFAULT 1,UZGVAZ DECIMAL(11,0) DEFAULT 0,UZGNAZ DECIMAL(11,0) DEFAULT 0,UZGGES DECIMAL(11,0) DEFAULT 0,UZGTKT DECIMAL(1,0) ,UZGTXT DECIMAL(11,0) DEFAULT 0,UZGSTA DECIMAL(5,0) DEFAULT 1,UZGDAT DATETIME ,UZGERF VARCHAR(50) BINARY DEFAULT 'Timesys',UZGGVZ DECIMAL(11,0) DEFAULT 0,UZGGNZ DECIMAL(11,0) DEFAULT 0,UZGMVZ DECIMAL(11,0) DEFAULT 0,UZGMNZ DECIMAL(11,0) DEFAULT 0,UZGTX2 DECIMAL(11,0) ,UZGMAV DECIMAL(11,0) ,UZGMAB DECIMAL(11,0) ,UZGGLV DECIMAL(11,0) ,UZGGLB DECIMAL(11,0) ,UZGUGV VARCHAR(5) BINARY ,UZGUGN VARCHAR(5) BINARY ,UZGUMV VARCHAR(5) BINARY ,UZGUMN VARCHAR(5) BINARY  ,PRIMARY KEY(UZGPNR,UZGVON,UZGZTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS322GAZ ( GAZPNR VARCHAR(8) BINARY ,GAZDTM DATETIME ,GAZMAV DECIMAL(5,0) DEFAULT 0,GAZMAB DECIMAL(5,0) DEFAULT 0,GAZNOV DECIMAL(5,0) DEFAULT 0,GAZNOB DECIMAL(5,0) DEFAULT 0,GAZGLV DECIMAL(5,0) DEFAULT 0,GAZGLB DECIMAL(5,0) DEFAULT 0,GAZKEV DECIMAL(5,0) DEFAULT 0,GAZKEB DECIMAL(5,0) DEFAULT 0,GAZSOL DECIMAL(5,0) DEFAULT 0,GAZSO2 DECIMAL(5,0) DEFAULT 0,GAZVHS DECIMAL(5,0) DEFAULT 0,GAZHTS DECIMAL(5,0) DEFAULT 0,GAZHTV DECIMAL(5,0) DEFAULT 0,GAZHS2 DECIMAL(5,0) DEFAULT 0,GAZNUM VARCHAR(5) BINARY ,GAZAZP VARCHAR(5) BINARY ,GAZPSM VARCHAR(5) BINARY ,GAZSTA DECIMAL(5,0) DEFAULT 1,GAZDAT DATETIME ,GAZERF VARCHAR(50) BINARY DEFAULT 'Timesys',GAZATV DECIMAL(4,0) DEFAULT 0,GAZATB DECIMAL(4,0) DEFAULT 0,GAZCTB DECIMAL(1,0) DEFAULT 0,GAZCMB DECIMAL(1,0) DEFAULT 0,GAZCNB DECIMAL(1,0) DEFAULT 0,GAZCGB DECIMAL(1,0) DEFAULT 0,GAZCKB DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(GAZPNR,GAZDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS323GPS ( GPSPNR VARCHAR(8) BINARY ,GPSDTM DATETIME ,GPSLFD DECIMAL(5,0) DEFAULT 0,GPSVON DECIMAL(5,0) DEFAULT 0,GPSBIS DECIMAL(5,0) DEFAULT 0,GPSMIN DECIMAL(5,0) DEFAULT 0,GPSMAX DECIMAL(5,0) DEFAULT 0,GPSINT DECIMAL(5,0) DEFAULT 0,GPSPSE DECIMAL(5,0) DEFAULT 0,GPSSTA DECIMAL(5,0) DEFAULT 1,GPSDAT DATETIME ,GPSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(GPSPNR,GPSDTM,GPSLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS324BRZ ( BRZPNR VARCHAR(8) BINARY ,BRZDTM DATETIME ,BRZBMD VARCHAR(10) BINARY ,BRZSTA DECIMAL(5,0) ,BRZDAT DATETIME ,BRZERF VARCHAR(50) BINARY ,BRZKEY VARCHAR(20) BINARY  ,PRIMARY KEY(BRZPNR,BRZDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS326VRK ( VRKPNR VARCHAR(8) BINARY ,VRKTAG DATETIME ,VRKKRK DECIMAL(5,0) ,VRKSTA DECIMAL(5,0) DEFAULT 1,VRKDAT DATETIME ,VRKERF VARCHAR(50) BINARY DEFAULT 'Timesys',VRKFCD VARCHAR(3) BINARY ,VRKINT DECIMAL(5,0)  ,PRIMARY KEY(VRKPNR,VRKTAG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS327TAG ( TAGPNR VARCHAR(8) BINARY ,TAGTAG DATETIME ,TAGVON DATETIME ,TAGUHR DATETIME ,TAGBIS DATETIME ,TAGEND DATETIME ,TAGKZV DECIMAL(1,0) ,TAGPZV DECIMAL(1,0) ,TAGONE DECIMAL(1,0) ,TAGKOM DECIMAL(1,0) ,TAGGEH DECIMAL(1,0) ,TAGFHL DECIMAL(1,0) ,TAGAZE DECIMAL(1,0) ,TAGAZT DECIMAL(1,0) ,TAGGAZ DECIMAL(1,0) ,TAGGPS DECIMAL(1,0) ,TAGTGB VARCHAR(3) BINARY ,TAGTGS DECIMAL(5,0) DEFAULT 0,TAGHTV VARCHAR(3) BINARY ,TAGHVS DECIMAL(5,0) DEFAULT 0,TAGHTN VARCHAR(3) BINARY ,TAGHNS DECIMAL(5,0) DEFAULT 0,TAGNPK DECIMAL(5,0) DEFAULT 0,TAGAMP DECIMAL(5,0) DEFAULT 1,TAGSTA DECIMAL(5,0) DEFAULT 1,TAGDAT DATETIME ,TAGERF VARCHAR(50) BINARY DEFAULT 'Timesys',TAGIND DECIMAL(5,0) ,TAGBEM DECIMAL(11,0) ,TAGSDF DECIMAL(15,5) ,TAGVAB DECIMAL(5,0) ,TAGNAE DECIMAL(5,0) ,TAGLTA DATETIME ,TAGUVG DECIMAL(1,0) ,TAGUNG DECIMAL(1,0) ,TAGKEY VARCHAR(8) BINARY ,TAGKYB VARCHAR(12) BINARY ,TAGKYE VARCHAR(12) BINARY ,TAGAKP DECIMAL(5,0) DEFAULT -1,TAGZUM DECIMAL(3,0) DEFAULT 0,TAGKFT VARCHAR(6) BINARY  ,PRIMARY KEY(TAGPNR,TAGTAG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS328BUP ( BUPPNR VARCHAR(8) BINARY ,BUPVON DATETIME ,BUPUHR DATETIME ,BUPFKT DECIMAL(5,0) DEFAULT 21,BUPBIS DATETIME ,BUPEND DATETIME ,BUPFFK DECIMAL(5,0) DEFAULT 0,BUPTVO DECIMAL(5,0) DEFAULT 0,BUPTBI DECIMAL(5,0) DEFAULT 0,BUPAVO DECIMAL(1,0) ,BUPABI DECIMAL(1,0) ,BUPWZV DECIMAL(5,0) DEFAULT 0,BUPWZB DECIMAL(5,0) DEFAULT 0,BUPSTA DECIMAL(5,0) DEFAULT 1,BUPDAT DATETIME ,BUPERF VARCHAR(50) BINARY DEFAULT 'Timesys',BUPKY1 VARCHAR(12) BINARY ,BUPKST VARCHAR(30) BINARY  ,PRIMARY KEY(BUPPNR,BUPVON,BUPUHR,BUPFKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS329ZTG ( ZTGPNR VARCHAR(8) BINARY ,ZTGVON DATETIME ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGTAG DECIMAL(5,0) DEFAULT 0,ZTGBSD VARCHAR(5) BINARY ,ZTGVRA VARCHAR(5) BINARY ,ZTGAZT VARCHAR(5) BINARY ,ZTGSTA DECIMAL(5,0) DEFAULT 1,ZTGDAT DATETIME ,ZTGERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZTGTTP VARCHAR(3) BINARY ,ZTGSCH DECIMAL(1,0) DEFAULT 0,ZTGATV DATETIME ,ZTGATB DATETIME ,ZTGATU DATETIME ,ZTGATE DATETIME ,ZTGEVA VARCHAR(5) BINARY DEFAULT NULL,ZTGEBD VARCHAR(5) BINARY DEFAULT NULL,ZTGPNM VARCHAR(50) BINARY ,ZTGOAZ VARCHAR(5) BINARY ,ZTGLCK DECIMAL(1,0)  ,PRIMARY KEY(ZTGPNR,ZTGVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS330ABR ( ABRAKR VARCHAR(5) BINARY ,ABRNUM DECIMAL(11,0) ,ABRVON DATETIME ,ABRBIS DATETIME ,ABRSTS DECIMAL(1,0) DEFAULT 0,ABRSTA DECIMAL(5,0) DEFAULT 1,ABRDAT DATETIME ,ABRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ABRNUM,ABRVON) ,CONSTRAINT TMS330ABR_UK UNIQUE(ABRNUM) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZKA ( ZKAPNR VARCHAR(8) BINARY ,ZKADTM DATETIME ,ZKALFN DECIMAL(3,0) DEFAULT 1,ZKAKST VARCHAR(30) BINARY ,ZKAKTR VARCHAR(6) BINARY ,ZKAKRT VARCHAR(4) BINARY ,ZKAZKM VARCHAR(5) BINARY ,ZKAZUS VARCHAR(5) BINARY ,ZKAPRZ DECIMAL(3,0) DEFAULT 100,ZKAZK1 VARCHAR(5) BINARY ,ZKAZU1 VARCHAR(5) BINARY ,ZKAPR1 DECIMAL(3,0) DEFAULT 100,ZKAZK2 VARCHAR(5) BINARY ,ZKAZU2 VARCHAR(5) BINARY ,ZKAPR2 DECIMAL(3,0) DEFAULT 100,ZKAZK3 VARCHAR(5) BINARY ,ZKAZU3 VARCHAR(5) BINARY ,ZKAPR3 DECIMAL(3,0) DEFAULT 100,ZKAZK4 VARCHAR(5) BINARY ,ZKAZU4 VARCHAR(5) BINARY ,ZKAPR4 DECIMAL(3,0) DEFAULT 100,ZKASTD DECIMAL(11,0) DEFAULT 0,ZKAMAP DECIMAL(5,0) ,ZKAZUP DECIMAL(5,0) ,ZKAKOR DECIMAL(3,0) DEFAULT 0,ZKAVON DECIMAL(5,0) DEFAULT 0,ZKABIS DECIMAL(5,0) DEFAULT 0,ZKASTO DECIMAL(11,0) DEFAULT 0 ,PRIMARY KEY(ZKAPNR,ZKADTM,ZKALFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZKB ( ZKBPNR VARCHAR(8) BINARY ,ZKBZTR DECIMAL(5,0) DEFAULT 1,ZKBDTM DATETIME ,ZKBKST VARCHAR(30) BINARY ,ZKBKTR VARCHAR(6) BINARY ,ZKBKRT VARCHAR(4) BINARY ,ZKBZKT VARCHAR(5) BINARY ,ZKBSTD DECIMAL(11,0) DEFAULT 0,ZKBTGE DECIMAL(11,0) DEFAULT 0,ZKBSTG DECIMAL(11,0) DEFAULT 0,ZKBSTA DECIMAL(5,0) DEFAULT 1,ZKBDAT DATETIME ,ZKBSTO DECIMAL(11,0) DEFAULT 0,ZKBBEM DECIMAL(11,0)  ,PRIMARY KEY(ZKBPNR,ZKBZTR,ZKBDTM,ZKBKST,ZKBKTR,ZKBKRT,ZKBZKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZKN ( ZKNPNR VARCHAR(8) BINARY ,ZKNDTM DATETIME ,ZKNLFN DECIMAL(3,0) DEFAULT 1,ZKNKST VARCHAR(30) BINARY ,ZKNKTR VARCHAR(6) BINARY ,ZKNKRT VARCHAR(4) BINARY ,ZKNZKN VARCHAR(5) BINARY ,ZKNZUS VARCHAR(5) BINARY ,ZKNPRZ DECIMAL(3,0) DEFAULT 100,ZKNZK1 VARCHAR(5) BINARY ,ZKNZU1 VARCHAR(5) BINARY ,ZKNPR1 DECIMAL(3,0) DEFAULT 100,ZKNZK2 VARCHAR(5) BINARY ,ZKNZU2 VARCHAR(5) BINARY ,ZKNPR2 DECIMAL(3,0) DEFAULT 100,ZKNZK3 VARCHAR(5) BINARY ,ZKNZU3 VARCHAR(5) BINARY ,ZKNPR3 DECIMAL(3,0) DEFAULT 100,ZKNZK4 VARCHAR(5) BINARY ,ZKNZU4 VARCHAR(5) BINARY ,ZKNPR4 DECIMAL(3,0) DEFAULT 100,ZKNSTD DECIMAL(11,0) DEFAULT 0,ZKNMAP DECIMAL(5,0) ,ZKNZUP DECIMAL(5,0) ,ZKNKOR DECIMAL(3,0) DEFAULT 0,ZKNVON DECIMAL(5,0) DEFAULT 0,ZKNBIS DECIMAL(5,0) DEFAULT 0,ZKNSTO DECIMAL(11,0) DEFAULT 0 ,PRIMARY KEY(ZKNPNR,ZKNDTM,ZKNLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZKS ( ZKSPNR VARCHAR(8) BINARY ,ZKSDTM DATETIME ,ZKSZKT VARCHAR(5) BINARY ,ZKSWRT DECIMAL(7,2) ,ZKSDAT DATETIME ,ZKSERF VARCHAR(50) BINARY  ,PRIMARY KEY(ZKSPNR,ZKSDTM,ZKSZKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZKW ( ZKWPNR VARCHAR(8) BINARY ,ZKWDTM DATETIME ,ZKWZKT VARCHAR(6) BINARY ,ZKWVON DECIMAL(6,0) ,ZKWBIS DECIMAL(6,0) ,ZKWPRZ DECIMAL(6,0) ,ZKWMIN DECIMAL(6,0)  ,PRIMARY KEY(ZKWPNR,ZKWDTM,ZKWZKT,ZKWVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZK1 ( ZK1ABR DECIMAL(11,0) DEFAULT 0,ZK1LFN DECIMAL(5,0) DEFAULT 1,ZK1STZ VARCHAR(5) BINARY ,ZK1BDT DATETIME ,ZK1PNR VARCHAR(8) BINARY ,ZK1ZKT VARCHAR(5) BINARY ,ZK1LNA VARCHAR(5) BINARY ,ZK1LGR VARCHAR(5) BINARY ,ZK1KST VARCHAR(30) BINARY ,ZK1KTR VARCHAR(6) BINARY ,ZK1KRT VARCHAR(4) BINARY ,ZK1STD DECIMAL(11,0) DEFAULT 0,ZK1TGE DECIMAL(11,0) DEFAULT 0,ZK1STG DECIMAL(11,0) DEFAULT 0,ZK1VON DATETIME ,ZK1BIS DATETIME ,ZK1STS DECIMAL(5,0) DEFAULT 1,ZK1RRE DECIMAL(1,0) ,ZK1STA DECIMAL(5,0) DEFAULT 1,ZK1DAT DATETIME ,ZK1UPN VARCHAR(8) BINARY ,ZK1INF DECIMAL(1,0) ,ZK1RRN DECIMAL(11,0) ,ZK1SU1 DECIMAL(12,0)  ,PRIMARY KEY(ZK1ABR,ZK1LFN,ZK1STZ,ZK1BDT,ZK1PNR,ZK1ZKT,ZK1LNA,ZK1LGR,ZK1KST,ZK1KTR,ZK1VON,ZK1BIS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZK2 ( ZK2ABR DECIMAL(11,0) ,ZK2PNR VARCHAR(8) BINARY ,ZK2BDT DATETIME ,ZK2STT DECIMAL(5,2) DEFAULT 0,ZK2SVT DECIMAL(5,2) DEFAULT 0,ZK2SLT DECIMAL(5,2) DEFAULT 0,ZK2ANT DECIMAL(5,2) DEFAULT 0,ZK2BZT DECIMAL(5,2) DEFAULT 0,ZK2UNT DECIMAL(5,2) DEFAULT 0,ZK2URT DECIMAL(5,2) DEFAULT 0,ZK2KRT DECIMAL(5,2) DEFAULT 0,ZK2FRT DECIMAL(5,2) DEFAULT 0,ZK2SZT DECIMAL(5,2) DEFAULT 0,ZK2ENT DECIMAL(5,2) DEFAULT 0,ZK2UET DECIMAL(5,2) DEFAULT 0,ZK2UBT DECIMAL(5,2) DEFAULT 0,ZK2SNT DECIMAL(5,2) DEFAULT 0,ZK2SLN DECIMAL(5,2) DEFAULT 0,ZK2ANS DECIMAL(5,2) DEFAULT 0,ZK2BZS DECIMAL(5,2) DEFAULT 0,ZK2UNS DECIMAL(5,2) DEFAULT 0,ZK2URS DECIMAL(5,2) DEFAULT 0,ZK2KRS DECIMAL(5,2) DEFAULT 0,ZK2FRS DECIMAL(5,2) DEFAULT 0,ZK2SZS DECIMAL(5,2) DEFAULT 0,ZK2ENS DECIMAL(5,2) DEFAULT 0,ZK2UES DECIMAL(5,2) DEFAULT 0,ZK2SNS DECIMAL(5,2) DEFAULT 0,ZK2ZES DECIMAL(5,2) DEFAULT 0,ZK2RRE DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(ZK2ABR,ZK2PNR,ZK2BDT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZK3 ( ZK3KEY VARCHAR(19) BINARY ,ZK3ABR DECIMAL(11,0) ,ZK3LFN DECIMAL(5,0) ,ZK3STZ VARCHAR(5) BINARY ,ZK3BDT DATETIME ,ZK3PNR VARCHAR(8) BINARY ,ZK3ZKT VARCHAR(5) BINARY ,ZK3LNA VARCHAR(5) BINARY ,ZK3LGR VARCHAR(5) BINARY ,ZK3KST VARCHAR(30) BINARY ,ZK3KTR VARCHAR(6) BINARY ,ZK3KRT VARCHAR(4) BINARY ,ZK3STD DECIMAL(11,0) ,ZK3TGE DECIMAL(11,0) ,ZK3STG DECIMAL(11,0) ,ZK3VON DATETIME ,ZK3BIS DATETIME ,ZK3STS DECIMAL(5,0) ,ZK3UPN VARCHAR(8) BINARY ,ZK3INF DECIMAL(1,0) ,ZK3SU1 DECIMAL(12,0)  ,PRIMARY KEY(ZK3KEY,ZK3ABR,ZK3LFN,ZK3STZ,ZK3BDT,ZK3PNR,ZK3ZKT,ZK3LNA,ZK3LGR,ZK3KST,ZK3KTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZK4 ( ZK4KEY VARCHAR(19) BINARY ,ZK4ABR DECIMAL(11,0) ,ZK4LFN DECIMAL(5,0) ,ZK4STZ VARCHAR(5) BINARY ,ZK4BDT DATETIME ,ZK4PNR VARCHAR(8) BINARY ,ZK4ZKT VARCHAR(5) BINARY ,ZK4LNA VARCHAR(5) BINARY ,ZK4LGR VARCHAR(5) BINARY ,ZK4KST VARCHAR(30) BINARY ,ZK4KTR VARCHAR(6) BINARY ,ZK4KRT VARCHAR(4) BINARY ,ZK4STD DECIMAL(11,0) ,ZK4TGE DECIMAL(11,0) ,ZK4STG DECIMAL(11,0) ,ZK4VON DATETIME ,ZK4BIS DATETIME ,ZK4STS DECIMAL(5,0) ,ZK4UPN VARCHAR(8) BINARY ,ZK4INF DECIMAL(1,0) ,ZK4SU1 DECIMAL(12,0)  ,PRIMARY KEY(ZK4KEY,ZK4ABR,ZK4LFN,ZK4STZ,ZK4BDT,ZK4PNR,ZK4ZKT,ZK4LNA,ZK4LGR,ZK4KST,ZK4KTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZK5 ( ZK5KEY VARCHAR(19) BINARY ,ZK5ABR DECIMAL(11,0) DEFAULT 0,ZK5LFN DECIMAL(5,0) DEFAULT 1,ZK5STZ VARCHAR(5) BINARY ,ZK5BDT DATETIME ,ZK5PNR VARCHAR(8) BINARY ,ZK5ZKT VARCHAR(5) BINARY ,ZK5LNA VARCHAR(5) BINARY ,ZK5LGR VARCHAR(5) BINARY ,ZK5KST VARCHAR(30) BINARY ,ZK5KTR VARCHAR(6) BINARY ,ZK5KRT VARCHAR(4) BINARY ,ZK5STD DECIMAL(11,0) DEFAULT 0,ZK5TGE DECIMAL(11,0) DEFAULT 0,ZK5STG DECIMAL(11,0) DEFAULT 0,ZK5VON DATETIME ,ZK5BIS DATETIME ,ZK5STS DECIMAL(5,0) DEFAULT 1,ZK5RRE DECIMAL(1,0) ,ZK5STA DECIMAL(5,0) DEFAULT 1,ZK5DAT DATETIME ,ZK5UPN VARCHAR(8) BINARY ,ZK5INF DECIMAL(1,0) ,ZK5SU1 DECIMAL(12,0)  ,PRIMARY KEY(ZK5ABR,ZK5STZ,ZK5PNR,ZK5ZKT,ZK5LNA,ZK5LGR,ZK5KST,ZK5KTR,ZK5VON,ZK5RRE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS331ZK9 ( ZKBPNR VARCHAR(8) BINARY ,ZKBZTR DECIMAL(5,0) DEFAULT 1,ZKBDTM DATETIME ,ZKBKST VARCHAR(10) BINARY ,ZKBKTR VARCHAR(6) BINARY ,ZKBKRT VARCHAR(4) BINARY ,ZKBLFD DECIMAL(5,0) DEFAULT 0,ZKB001 DECIMAL(11,0) DEFAULT 0,ZKB002 DECIMAL(11,0) DEFAULT 0,ZKB003 DECIMAL(11,0) DEFAULT 0,ZKB004 DECIMAL(11,0) DEFAULT 0,ZKB005 DECIMAL(11,0) DEFAULT 0,ZKB006 DECIMAL(11,0) DEFAULT 0,ZKB007 DECIMAL(11,0) DEFAULT 0,ZKB008 DECIMAL(11,0) DEFAULT 0,ZKB009 DECIMAL(11,0) DEFAULT 0,ZKB010 DECIMAL(11,0) DEFAULT 0,ZKB011 DECIMAL(11,0) DEFAULT 0,ZKB012 DECIMAL(11,0) DEFAULT 0,ZKB013 DECIMAL(11,0) DEFAULT 0,ZKB014 DECIMAL(11,0) DEFAULT 0,ZKB015 DECIMAL(11,0) DEFAULT 0,ZKB016 DECIMAL(11,0) DEFAULT 0,ZKB017 DECIMAL(11,0) DEFAULT 0,ZKB018 DECIMAL(11,0) DEFAULT 0,ZKB019 DECIMAL(11,0) DEFAULT 0,ZKB020 DECIMAL(11,0) DEFAULT 0,ZKB021 DECIMAL(11,0) DEFAULT 0,ZKB022 DECIMAL(11,0) DEFAULT 0,ZKB023 DECIMAL(11,0) DEFAULT 0,ZKB024 DECIMAL(11,0) DEFAULT 0,ZKB025 DECIMAL(11,0) DEFAULT 0,ZKB026 DECIMAL(11,0) DEFAULT 0,ZKB027 DECIMAL(11,0) DEFAULT 0,ZKB028 DECIMAL(11,0) DEFAULT 0,ZKB029 DECIMAL(11,0) DEFAULT 0,ZKB030 DECIMAL(11,0) DEFAULT 0,ZKB031 DECIMAL(11,0) DEFAULT 0,ZKB032 DECIMAL(11,0) DEFAULT 0,ZKB033 DECIMAL(11,0) DEFAULT 0,ZKB034 DECIMAL(11,0) DEFAULT 0,ZKB035 DECIMAL(11,0) DEFAULT 0,ZKB036 DECIMAL(11,0) DEFAULT 0,ZKB037 DECIMAL(11,0) DEFAULT 0,ZKB038 DECIMAL(11,0) DEFAULT 0,ZKB039 DECIMAL(11,0) DEFAULT 0,ZKB040 DECIMAL(11,0) DEFAULT 0,ZKBSTA DECIMAL(5,0) DEFAULT 1,ZKBDAT DATETIME  ,PRIMARY KEY(ZKBPNR,ZKBZTR,ZKBDTM,ZKBKST,ZKBKTR,ZKBKRT,ZKBLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332FTG ( FTGPNR VARCHAR(8) BINARY ,FTGDTM DATETIME ,FTGFTG DECIMAL(5,2) ,FTGVTG DECIMAL(5,2) ,FTGRTG DECIMAL(5,2) ,FTGGUT DECIMAL(5,2) ,FTGGKT DECIMAL(5,2) ,FTGDAT DATETIME ,FTGSTA DECIMAL(1,0) DEFAULT 1,FTGERF VARCHAR(50) BINARY DEFAULT 'timesys',FTGVFL DECIMAL(5,2) DEFAULT 0 ,PRIMARY KEY(FTGPNR,FTGDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332FTV ( FTVPNR VARCHAR(8) BINARY ,FTVJHR DECIMAL(5,0) DEFAULT NULL,FTVVJR DECIMAL(7,2) DEFAULT 0,FTVVUR DECIMAL(5,2) DEFAULT 0,FTVVTG DECIMAL(7,2) DEFAULT 0,FTVUAN DECIMAL(7,2) DEFAULT 0,FTVZUS DECIMAL(7,2) ,FTVGUR DECIMAL(7,2) DEFAULT 0,FTVABG DECIMAL(7,2) ,FTVMIN DECIMAL(7,2) ,FTVSTA DECIMAL(5,0) DEFAULT 1,FTVDAT DATETIME ,FTVERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(FTVPNR,FTVJHR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332JAV ( JAVPNR VARCHAR(8) BINARY ,JAVBEG DATETIME ,JAVEND DATETIME ,JAVJAZ DECIMAL(8,0) ,JAVIST DECIMAL(8,0) ,JAVSOL DECIMAL(8,0) ,JAVDIF DECIMAL(8,0) ,JAVSTA DECIMAL(1,0) ,JAVDAT DATETIME ,JAVERF VARCHAR(50) BINARY ,JAVDI2 DECIMAL(8,0) ,JAVSTR DATETIME ,JAVPNM VARCHAR(100) BINARY  ,PRIMARY KEY(JAVPNR,JAVBEG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332SFV ( SFVPNR VARCHAR(8) BINARY ,SFVJHR DECIMAL(4,0) ,SFVVTG DECIMAL(7,2) ,SFVVAN DECIMAL(7,2) ,SFVMAN DECIMAL(1,0) ,SFVSTA DECIMAL(1,0) ,SFVERF VARCHAR(50) BINARY ,SFVDAT DATETIME ,SFVZUS DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(SFVPNR,SFVJHR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332SFZ ( SFZPNR VARCHAR(8) BINARY ,SFZDTM DATETIME ,SFZANT DECIMAL(7,2) ,SFZVTG DECIMAL(7,2) ,SFZVAN DECIMAL(7,2) ,SFZANS DECIMAL(7,2) ,SFZGEN DECIMAL(7,2) ,SFZVPL DECIMAL(7,2) ,SFZRST DECIMAL(7,2) ,SFZSTA DECIMAL(1,0) DEFAULT 1,SFZERF VARCHAR(50) BINARY ,SFZDAT DATETIME ,SFZGVV DECIMAL(5,0)  ,PRIMARY KEY(SFZPNR,SFZDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332SUL ( SULPNR VARCHAR(8) BINARY ,SULDTM DATETIME ,SULVTG DECIMAL(7,2) ,SULVVN DECIMAL(7,2) ,SULANS DECIMAL(7,2) ,SULGEN DECIMAL(7,2) ,SULRST DECIMAL(7,2) ,SULVPL DECIMAL(7,2) ,SULNVT DECIMAL(7,2) ,SULANM DECIMAL(7,2) ,SULUSC DECIMAL(7,2) ,SULUST DECIMAL(7,2) ,SULSTA DECIMAL(5,0) ,SULERF VARCHAR(50) BINARY ,SULDAT DATETIME  ,PRIMARY KEY(SULPNR,SULDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332SUV ( SUVPNR VARCHAR(8) BINARY ,SUVJHR DECIMAL(4,0) ,SUVVTG DECIMAL(7,2) ,SUVVTS DECIMAL(7,2) ,SUVMAN DECIMAL(1,0) ,SUVSTA DECIMAL(5,0) ,SUVERF VARCHAR(50) BINARY ,SUVDAT DATETIME  ,PRIMARY KEY(SUVPNR,SUVJHR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332URV ( URVPNR VARCHAR(8) BINARY ,URVJHR DECIMAL(5,0) DEFAULT NULL,URVVJR DECIMAL(7,2) DEFAULT 0,URVVUR DECIMAL(5,2) DEFAULT 0,URVUAN DECIMAL(7,2) DEFAULT 0,URVJUB DECIMAL(7,2) DEFAULT 0,URVSBH DECIMAL(7,2) DEFAULT 0,URVGUR DECIMAL(7,2) DEFAULT 0,URVSTA DECIMAL(5,0) DEFAULT 1,URVDAT DATETIME ,URVERF VARCHAR(50) BINARY DEFAULT 'Timesys',URVABG DECIMAL(7,2) ,URVZUS DECIMAL(7,2) ,URVJMO DECIMAL(5,0) DEFAULT 0,URVMIN DECIMAL(7,2) ,URVVTG DECIMAL(7,2) DEFAULT 0,URVSUL DECIMAL(7,2) ,URVAFT VARCHAR(7) BINARY ,URVKFT VARCHAR(7) BINARY ,URVGFT VARCHAR(7) BINARY  ,PRIMARY KEY(URVPNR,URVJHR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS332UTG ( UTGPNR VARCHAR(8) BINARY ,UTGDTM DATETIME ,UTGUTG DECIMAL(5,2) ,UTGVTG DECIMAL(5,2) ,UTGRTG DECIMAL(5,2) ,UTGGUT DECIMAL(5,2) ,UTGGKT DECIMAL(5,2) ,UTGDAT DATETIME ,UTGSTA DECIMAL(1,0) DEFAULT 1,UTGERF VARCHAR(50) BINARY DEFAULT 'timesys',UTGVFL DECIMAL(5,2) DEFAULT 0 ,PRIMARY KEY(UTGPNR,UTGDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333ASK ( ASKFIR VARCHAR(3) BINARY ,ASKPNR VARCHAR(6) BINARY ,ASKJHR DECIMAL(4,0) DEFAULT 0,ASKMON DECIMAL(2,0) DEFAULT 0,ASKENR DECIMAL(6,0) DEFAULT 0,ASKGRP VARCHAR(1) BINARY ,ASKAGR VARCHAR(1) BINARY ,ASKART VARCHAR(1) BINARY ,ASKVON VARCHAR(10) BINARY ,ASKBIS VARCHAR(10) BINARY ,ASKEIN VARCHAR(1) BINARY ,ASKMGE DECIMAL(8,4) DEFAULT 0,ASKFKZ VARCHAR(1) BINARY ,ASKLKZ VARCHAR(1) BINARY ,ASKSTS VARCHAR(1) BINARY ,ASKID1 VARCHAR(3) BINARY ,ASKDT1 VARCHAR(10) BINARY ,ASKID2 VARCHAR(3) BINARY ,ASKDT2 VARCHAR(10) BINARY ,ASKUHR VARCHAR(8) BINARY  ,PRIMARY KEY(ASKFIR,ASKPNR,ASKJHR,ASKMON,ASKENR,ASKART,ASKLKZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333ASR ( ASRFIR VARCHAR(3) BINARY ,ASRPNR VARCHAR(6) BINARY ,ASRJHR DECIMAL(4,0) ,ASRMON DECIMAL(2,0) ,ASRLNA VARCHAR(3) BINARY ,ASRGRP VARCHAR(1) BINARY ,ASRAGR VARCHAR(1) BINARY ,ASRLNT VARCHAR(7) BINARY ,ASRLFO VARCHAR(3) BINARY ,ASRSTD DECIMAL(5,2) DEFAULT 0,ASRTAG DECIMAL(5,2) DEFAULT 0,ASRSTK DECIMAL(7,2) DEFAULT 0,ASRVOZ DECIMAL(9,2) DEFAULT 0,ASRFAK DECIMAL(6,2) DEFAULT 0,ASRPRO DECIMAL(5,2) DEFAULT 0,ASRKLM DECIMAL(9,3) DEFAULT 0,ASRMEN DECIMAL(7,2) DEFAULT 0,ASRWOC VARCHAR(2) BINARY ,ASRBTR DECIMAL(9,2) DEFAULT 0,ASRKST VARCHAR(10) BINARY ,ASRTUR VARCHAR(1) BINARY ,ASRAEN DECIMAL(3,0) DEFAULT 0,ASRFLN VARCHAR(3) BINARY ,ASRVMI DECIMAL(7,2) DEFAULT 0,ASRHER VARCHAR(3) BINARY ,ASRDAT VARCHAR(10) BINARY ,ASRFOL VARCHAR(4) BINARY ,ASRGAN VARCHAR(4) BINARY ,ASRTAT VARCHAR(3) BINARY ,ASRBET VARCHAR(7) BINARY ,ASRBLK VARCHAR(10) BINARY ,ASRBST VARCHAR(2) BINARY ,ASRSCH VARCHAR(2) BINARY ,ASRAUS DECIMAL(7,2) DEFAULT 0,ASRRUS DECIMAL(5,2) DEFAULT 0,ASRKTR VARCHAR(18) BINARY ,ASRVFM DECIMAL(2,0) DEFAULT 0,ASRVFJ DECIMAL(4,0) DEFAULT 0,ASRSKT VARCHAR(10) BINARY ,ASRKOA VARCHAR(10) BINARY ,ASRFKZ VARCHAR(1) BINARY ,ASRLKZ VARCHAR(1) BINARY ,ASRABR DECIMAL(6,0) DEFAULT 0,ASRFA1 VARCHAR(1) BINARY ,ASRFA2 VARCHAR(1) BINARY ,ASRFA3 VARCHAR(1) BINARY ,ASRFA4 VARCHAR(1) BINARY ,ASRKZA VARCHAR(1) BINARY ,ASRFA5 VARCHAR(1) BINARY ,ASRFP1 DECIMAL(9,2) DEFAULT 0,ASRFP2 DECIMAL(9,2) DEFAULT 0,ASRFP3 DECIMAL(9,2) DEFAULT 0,ASRFP4 DECIMAL(9,2) DEFAULT 0,ASRFP5 DECIMAL(9,2) DEFAULT 0,ASRMIN VARCHAR(1) BINARY ,ASRTXT VARCHAR(20) BINARY ,ASRVON VARCHAR(10) BINARY ,ASRBIS VARCHAR(10) BINARY ,ASRWHR VARCHAR(3) BINARY ,ASROID DECIMAL(5,0) DEFAULT 0,ASRKZT VARCHAR(1) BINARY ,ASRSAS VARCHAR(1) BINARY ,ASRSBE VARCHAR(3) BINARY ,ASRDTE VARCHAR(10) BINARY ,ASRSBM VARCHAR(3) BINARY ,ASRDTM VARCHAR(10) BINARY ,ASRUHR VARCHAR(8) BINARY  ,PRIMARY KEY(ASRFIR,ASRPNR,ASRJHR,ASRMON,ASRLNA,ASRKST,ASRVFM,ASRVFJ,ASRLKZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333BMN ( BMNSTZ VARCHAR(2) BINARY ,BMNFIR VARCHAR(5) BINARY ,BMNFL1 VARCHAR(3) BINARY ,BMNPNR VARCHAR(4) BINARY ,BMNKST VARCHAR(6) BINARY ,BMNDAT VARCHAR(2) BINARY ,BMNABM VARCHAR(2) BINARY ,BMNLNA VARCHAR(3) BINARY ,BMNSTD DECIMAL(8,2) ,BMNKNZ VARCHAR(1) BINARY ,BMNZF1 DECIMAL(8,2) ,BMNZF2 DECIMAL(8,2) ,BMNFL2 VARCHAR(2) BINARY ,BMNANF VARCHAR(11) BINARY ,BMNPSN VARCHAR(5) BINARY ,BMNFKT DECIMAL(5,2) ,BMNZUS DECIMAL(5,2)  ,PRIMARY KEY(BMNSTZ,BMNPNR,BMNABM,BMNLNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333BZR ( BZRFIR VARCHAR(2) BINARY ,BZRPNR VARCHAR(7) BINARY ,BZRBDT DECIMAL(6,0) DEFAULT 0,BZRT01 VARCHAR(2) BINARY ,BZRT02 VARCHAR(2) BINARY ,BZRT03 VARCHAR(2) BINARY ,BZRT04 VARCHAR(2) BINARY ,BZRT05 VARCHAR(2) BINARY ,BZRT06 VARCHAR(2) BINARY ,BZRT07 VARCHAR(2) BINARY ,BZRT08 VARCHAR(2) BINARY ,BZRT09 VARCHAR(2) BINARY ,BZRT10 VARCHAR(2) BINARY ,BZRT11 VARCHAR(2) BINARY ,BZRT12 VARCHAR(2) BINARY ,BZRT13 VARCHAR(2) BINARY ,BZRT14 VARCHAR(2) BINARY ,BZRT15 VARCHAR(2) BINARY ,BZRT16 VARCHAR(2) BINARY ,BZRT17 VARCHAR(2) BINARY ,BZRT18 VARCHAR(2) BINARY ,BZRT19 VARCHAR(2) BINARY ,BZRT20 VARCHAR(2) BINARY ,BZRT21 VARCHAR(2) BINARY ,BZRT22 VARCHAR(2) BINARY ,BZRT23 VARCHAR(2) BINARY ,BZRT24 VARCHAR(2) BINARY ,BZRT25 VARCHAR(2) BINARY ,BZRT26 VARCHAR(2) BINARY ,BZRT27 VARCHAR(2) BINARY ,BZRT28 VARCHAR(2) BINARY ,BZRT29 VARCHAR(2) BINARY ,BZRT30 VARCHAR(2) BINARY ,BZRT31 VARCHAR(2) BINARY  ,PRIMARY KEY(BZRFIR,BZRPNR,BZRBDT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333B01 ( B01ART VARCHAR(2) BINARY DEFAULT 'B1',B01FIR VARCHAR(2) BINARY ,B01PNR VARCHAR(7) BINARY ,B01FLN DECIMAL(3,0) ,B01BDT DECIMAL(6,0) DEFAULT 0,B01LTT DECIMAL(2,0) DEFAULT 0,B01ARB DECIMAL(2,0) DEFAULT 0,B01SOL DECIMAL(5,2) DEFAULT 0,B01STG VARCHAR(2) BINARY DEFAULT ' ',B01ANW DECIMAL(3,1) DEFAULT 0,B01URL DECIMAL(3,1) DEFAULT 0,B01KRK DECIMAL(3,1) DEFAULT 0,B01FTG DECIMAL(3,1) DEFAULT 0,B01SOZ DECIMAL(3,1) DEFAULT 0,B01ENT DECIMAL(3,1) DEFAULT 0,B01UNT DECIMAL(3,1) DEFAULT 0,B01URS DECIMAL(5,2) DEFAULT 0,B01KRS DECIMAL(5,2) DEFAULT 0,B01FTS DECIMAL(5,2) DEFAULT 0,B01SOS DECIMAL(5,2) DEFAULT 0,B01ENS DECIMAL(5,2) DEFAULT 0,B01UNS DECIMAL(5,2) DEFAULT 0,B01SEZ DECIMAL(5,2) DEFAULT 0,B01GLS DECIMAL(5,2) DEFAULT 0,B01BRU VARCHAR(1) BINARY DEFAULT ' ',B01NET VARCHAR(1) BINARY DEFAULT ' ',B01STD DECIMAL(5,2) DEFAULT 0,B01AUN DECIMAL(3,0) DEFAULT 0,B01RES VARCHAR(48) BINARY DEFAULT ' ' ,PRIMARY KEY(B01FIR,B01PNR,B01FLN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333B05 ( B05ART VARCHAR(2) BINARY DEFAULT 'B5',B05FIR VARCHAR(2) BINARY ,B05PNR VARCHAR(7) BINARY ,B05BLN VARCHAR(5) BINARY ,B05BDT DECIMAL(6,0) DEFAULT 0,B05LTT DECIMAL(2,0) DEFAULT 0,B05AKS VARCHAR(10) BINARY DEFAULT ' ',B05BKS VARCHAR(10) BINARY DEFAULT ' ',B05KTR VARCHAR(10) BINARY DEFAULT ' ',B05LAR VARCHAR(1) BINARY DEFAULT ' ',B05LNA VARCHAR(3) BINARY DEFAULT ' ',B05MNR VARCHAR(5) BINARY DEFAULT ' ',B05ARG VARCHAR(5) BINARY DEFAULT ' ',B05VST DECIMAL(7,0) DEFAULT 0,B05GST DECIMAL(7,0) DEFAULT 0,B05STZ DECIMAL(5,2) DEFAULT 0,B05MSH VARCHAR(1) BINARY DEFAULT ' ',B05RZT DECIMAL(5,2) DEFAULT 0,B05GZT DECIMAL(5,2) DEFAULT 0,B05ZGR DECIMAL(5,2) DEFAULT 0,B05TGR VARCHAR(1) BINARY DEFAULT ' ',B05BZT DECIMAL(5,2) DEFAULT 0,B05AKL VARCHAR(2) BINARY DEFAULT ' ',B05L01 VARCHAR(4) BINARY DEFAULT ' ',B05PRF VARCHAR(1) BINARY DEFAULT ' ',B05LSA DECIMAL(7,2) DEFAULT 0,B05IND DECIMAL(5,0) DEFAULT 0,B05ZPR DECIMAL(5,2) DEFAULT 0,B05LBT DECIMAL(9,2) DEFAULT 0,B05AGP VARCHAR(2) BINARY DEFAULT ' ',B05L02 VARCHAR(6) BINARY DEFAULT ' ' ,PRIMARY KEY(B05FIR,B05PNR,B05BLN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333B06 ( B06ART VARCHAR(2) BINARY DEFAULT 'B6',B06FIR VARCHAR(2) BINARY ,B06PNR VARCHAR(7) BINARY ,B06BLN VARCHAR(5) BINARY ,B06BDT DECIMAL(6,0) DEFAULT 0,B06LTT DECIMAL(2,0) DEFAULT 0,B06AKS VARCHAR(10) BINARY DEFAULT ' ',B06BKS VARCHAR(10) BINARY DEFAULT ' ',B06KTR VARCHAR(10) BINARY DEFAULT ' ',B06LAR VARCHAR(1) BINARY DEFAULT ' ',B06LNA VARCHAR(3) BINARY DEFAULT ' ',B06MNR VARCHAR(5) BINARY DEFAULT ' ',B06ARG VARCHAR(5) BINARY DEFAULT ' ',B06VST DECIMAL(7,0) DEFAULT 0,B06GST DECIMAL(7,0) DEFAULT 0,B06STZ DECIMAL(5,2) DEFAULT 0,B06MSH VARCHAR(1) BINARY DEFAULT ' ',B06RZT DECIMAL(5,2) DEFAULT 0,B06GZT DECIMAL(5,2) DEFAULT 0,B06ZGR DECIMAL(5,2) DEFAULT 0,B06TGR VARCHAR(1) BINARY DEFAULT ' ',B06BZT DECIMAL(5,2) DEFAULT 0,B06AKL VARCHAR(2) BINARY DEFAULT ' ',B06L01 VARCHAR(4) BINARY DEFAULT ' ',B06PRF VARCHAR(1) BINARY DEFAULT ' ',B06LSA DECIMAL(7,2) DEFAULT 0,B06IND DECIMAL(5,0) DEFAULT 0,B06ZPR DECIMAL(5,2) DEFAULT 0,B06LBT DECIMAL(9,2) DEFAULT 0,B06AGP VARCHAR(2) BINARY DEFAULT ' ',B06L02 VARCHAR(6) BINARY DEFAULT ' ' ,PRIMARY KEY(B06FIR,B06PNR,B06BLN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333EMS ( EMSAKR CHAR(5) ,EMSPNR CHAR(10) ,EMSDAT CHAR(6) ,EMSLNA CHAR(5) ,EMSSTD DECIMAL(7,2) ,EMSMIN DECIMAL(7,0) ,EMSTGE DECIMAL(5,2) ,EMSKNZ CHAR(1) DEFAULT 'P' ,PRIMARY KEY(EMSPNR,EMSLNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333FZT ( FZTSTZ VARCHAR(3) BINARY ,FZTMDN VARCHAR(3) BINARY ,FZTFIR VARCHAR(4) BINARY ,FZTPNR VARCHAR(11) BINARY ,FZTFZT VARCHAR(3) BINARY ,FZTBEG VARCHAR(9) BINARY ,FZTEND VARCHAR(9) BINARY ,FZTSTR VARCHAR(2) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333GOD ( GODART VARCHAR(3) BINARY ,GODTNR VARCHAR(4) BINARY ,GODPNR VARCHAR(8) BINARY ,GODLNA VARCHAR(4) BINARY ,GODDVO VARCHAR(4) BINARY ,GODDBI VARCHAR(4) BINARY ,GODSTD DECIMAL(7,2) ,GODEIN VARCHAR(8) BINARY ,GODKST VARCHAR(6) BINARY ,GODEAR VARCHAR(2) BINARY ,GODFVO VARCHAR(6) BINARY ,GODFBI VARCHAR(6) BINARY ,GODFGR VARCHAR(2) BINARY ,GODNAM VARCHAR(50) BINARY  ,PRIMARY KEY(GODART,GODPNR,GODLNA,GODDVO,GODDBI,GODFVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333HAN ( HANSTZ VARCHAR(3) BINARY ,HANFIR VARCHAR(4) BINARY ,HANMDN VARCHAR(3) BINARY ,HANPNR VARCHAR(11) BINARY ,HANLNA VARCHAR(5) BINARY ,HANSCH VARCHAR(2) BINARY ,HANDTM VARCHAR(7) BINARY ,HANKST VARCHAR(13) BINARY ,HANSTD DECIMAL(6,2) ,HANJHR VARCHAR(5) BINARY ,HANMON VARCHAR(3) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333LD1 ( LD1ART VARCHAR(2) BINARY ,LD1PNR VARCHAR(5) BINARY ,LD1AZR DATETIME ,LD1KEY VARCHAR(2) BINARY ,LD1VAL DECIMAL(11,2) ,LD1LNA VARCHAR(3) BINARY ,LD1KST VARCHAR(8) BINARY ,LD1KTR VARCHAR(8) BINARY ,LD1RRE DECIMAL(1,0)  ,PRIMARY KEY(LD1ART,LD1PNR,LD1AZR,LD1KEY,LD1LNA,LD1KST,LD1RRE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333LPC ( LPCFLD VARCHAR(333) BINARY ,LPCIDX DECIMAL(6,0)      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333LP1 ( LP1FLD VARCHAR(433) BINARY ,LP1IDX DECIMAL(6,0)      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333NVL ( NVLSTZ VARCHAR(1) BINARY ,NVLPNR VARCHAR(10) BINARY ,NVLDAT VARCHAR(8) BINARY ,NVLLNA VARCHAR(4) BINARY ,NVLVRZ VARCHAR(1) BINARY ,NVLSTD VARCHAR(5) BINARY ,NVLTGE VARCHAR(4) BINARY  ,PRIMARY KEY(NVLSTZ,NVLPNR,NVLDAT,NVLLNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333NVS ( NVSSTZ VARCHAR(1) BINARY ,NVSPNR VARCHAR(10) BINARY ,NVSDAT VARCHAR(8) BINARY ,NVSVON VARCHAR(8) BINARY ,NVSBIS VARCHAR(8) BINARY ,NVSABW VARCHAR(10) BINARY  ,PRIMARY KEY(NVSSTZ,NVSPNR,NVSDAT,NVSVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PEZ ( PEZMON VARCHAR(2) BINARY DEFAULT ' ',PEZJHR VARCHAR(4) BINARY DEFAULT ' ',PEZRMO VARCHAR(2) BINARY DEFAULT ' ',PEZKST VARCHAR(7) BINARY DEFAULT ' ',PEZPNR VARCHAR(7) BINARY DEFAULT ' ',PEZTUC VARCHAR(1) BINARY DEFAULT ' ',PEZRUC VARCHAR(1) BINARY DEFAULT ' ',PEZS01 VARCHAR(6) BINARY DEFAULT ' ',PEZL01 VARCHAR(3) BINARY DEFAULT ' ',PEZN01 VARCHAR(2) BINARY DEFAULT ' ',PEZS02 VARCHAR(6) BINARY DEFAULT ' ',PEZL02 VARCHAR(3) BINARY DEFAULT ' ',PEZN02 VARCHAR(2) BINARY DEFAULT ' ',PEZS03 VARCHAR(6) BINARY DEFAULT ' ',PEZL03 VARCHAR(3) BINARY DEFAULT ' ',PEZN03 VARCHAR(2) BINARY DEFAULT ' ',PEZS04 VARCHAR(6) BINARY DEFAULT ' ',PEZL04 VARCHAR(3) BINARY DEFAULT ' ',PEZN04 VARCHAR(2) BINARY DEFAULT ' ',PEZS05 VARCHAR(6) BINARY DEFAULT ' ',PEZL05 VARCHAR(3) BINARY DEFAULT ' ',PEZN05 VARCHAR(2) BINARY DEFAULT ' ',PEZS06 VARCHAR(6) BINARY DEFAULT ' ',PEZL06 VARCHAR(3) BINARY DEFAULT ' ',PEZN06 VARCHAR(2) BINARY DEFAULT ' ',PEZS07 VARCHAR(6) BINARY DEFAULT ' ',PEZL07 VARCHAR(3) BINARY DEFAULT ' ',PEZN07 VARCHAR(2) BINARY DEFAULT ' ',PEZS08 VARCHAR(6) BINARY DEFAULT ' ',PEZL08 VARCHAR(3) BINARY DEFAULT ' ',PEZN08 VARCHAR(2) BINARY DEFAULT ' ',PEZS09 VARCHAR(6) BINARY DEFAULT ' ',PEZL09 VARCHAR(3) BINARY DEFAULT ' ',PEZN09 VARCHAR(2) BINARY DEFAULT ' ',PEZS10 VARCHAR(6) BINARY DEFAULT ' ',PEZL10 VARCHAR(3) BINARY DEFAULT ' ',PEZN10 VARCHAR(2) BINARY DEFAULT ' ',PEZS11 VARCHAR(6) BINARY DEFAULT ' ',PEZL11 VARCHAR(3) BINARY DEFAULT ' ',PEZN11 VARCHAR(2) BINARY DEFAULT ' ',PEZS12 VARCHAR(6) BINARY DEFAULT ' ',PEZL12 VARCHAR(3) BINARY DEFAULT ' ',PEZN12 VARCHAR(2) BINARY DEFAULT ' ',PEZS13 VARCHAR(6) BINARY DEFAULT ' ',PEZL13 VARCHAR(3) BINARY DEFAULT ' ',PEZN13 VARCHAR(2) BINARY DEFAULT ' ',PEZS14 VARCHAR(6) BINARY DEFAULT ' ',PEZL14 VARCHAR(3) BINARY DEFAULT ' ',PEZN14 VARCHAR(2) BINARY DEFAULT ' ',PEZS15 VARCHAR(6) BINARY DEFAULT ' ',PEZL15 VARCHAR(3) BINARY DEFAULT ' ',PEZN15 VARCHAR(2) BINARY DEFAULT ' ',PEZS16 VARCHAR(6) BINARY DEFAULT ' ',PEZL16 VARCHAR(3) BINARY DEFAULT ' ',PEZN16 VARCHAR(2) BINARY DEFAULT ' ',PEZS17 VARCHAR(6) BINARY DEFAULT ' ',PEZL17 VARCHAR(3) BINARY DEFAULT ' ',PEZN17 VARCHAR(2) BINARY DEFAULT ' ',PEZC01 VARCHAR(3) BINARY DEFAULT ' ',PEZG01 VARCHAR(2) BINARY DEFAULT ' ',PEZO01 DECIMAL(4,2) DEFAULT 0,PEZC02 VARCHAR(3) BINARY DEFAULT ' ',PEZG02 VARCHAR(2) BINARY DEFAULT ' ',PEZO02 DECIMAL(4,2) DEFAULT 0,PEZC03 VARCHAR(3) BINARY DEFAULT ' ',PEZG03 VARCHAR(2) BINARY DEFAULT ' ',PEZO03 DECIMAL(4,2) DEFAULT 0,PEZC04 VARCHAR(3) BINARY DEFAULT ' ',PEZG04 VARCHAR(2) BINARY DEFAULT ' ',PEZO04 DECIMAL(4,2) DEFAULT 0,PEZC05 VARCHAR(3) BINARY DEFAULT ' ',PEZG05 VARCHAR(2) BINARY DEFAULT ' ',PEZO05 DECIMAL(4,2) DEFAULT 0,PEZC06 VARCHAR(3) BINARY DEFAULT ' ',PEZG06 VARCHAR(2) BINARY DEFAULT ' ',PEZO06 DECIMAL(4,2) DEFAULT 0,PEZC07 VARCHAR(3) BINARY DEFAULT ' ',PEZG07 VARCHAR(2) BINARY DEFAULT ' ',PEZO07 DECIMAL(4,2) DEFAULT 0,PEZC08 VARCHAR(3) BINARY DEFAULT ' ',PEZG08 VARCHAR(2) BINARY DEFAULT ' ',PEZO08 DECIMAL(4,2) DEFAULT 0,PEZC09 VARCHAR(3) BINARY DEFAULT ' ',PEZG09 VARCHAR(2) BINARY DEFAULT ' ',PEZO09 DECIMAL(4,2) DEFAULT 0,PEZC10 VARCHAR(3) BINARY DEFAULT ' ',PEZG10 VARCHAR(2) BINARY DEFAULT ' ',PEZO10 DECIMAL(4,2) DEFAULT 0,PEZC11 VARCHAR(3) BINARY DEFAULT ' ',PEZG11 VARCHAR(2) BINARY DEFAULT ' ',PEZO11 DECIMAL(4,2) DEFAULT 0,PEZC12 VARCHAR(3) BINARY DEFAULT ' ',PEZG12 VARCHAR(2) BINARY DEFAULT ' ',PEZO12 DECIMAL(4,2) DEFAULT 0,PEZC13 VARCHAR(3) BINARY DEFAULT ' ',PEZG13 VARCHAR(2) BINARY DEFAULT ' ',PEZO13 DECIMAL(4,2) DEFAULT 0,PEZC14 VARCHAR(3) BINARY DEFAULT ' ',PEZG14 VARCHAR(2) BINARY DEFAULT ' ',PEZO14 DECIMAL(4,2) DEFAULT 0,PEZC15 VARCHAR(3) BINARY DEFAULT ' ',PEZG15 VARCHAR(2) BINARY DEFAULT ' ',PEZO15 DECIMAL(4,2) DEFAULT 0,PEZC16 VARCHAR(3) BINARY DEFAULT ' ',PEZG16 VARCHAR(2) BINARY DEFAULT ' ',PEZO16 DECIMAL(4,2) DEFAULT 0,PEZC17 VARCHAR(3) BINARY DEFAULT ' ',PEZG17 VARCHAR(2) BINARY DEFAULT ' ',PEZO17 DECIMAL(4,2) DEFAULT 0,PEZC18 VARCHAR(3) BINARY DEFAULT ' ',PEZG18 VARCHAR(2) BINARY DEFAULT ' ',PEZO18 DECIMAL(4,2) DEFAULT 0,PEZC19 VARCHAR(3) BINARY DEFAULT ' ',PEZG19 VARCHAR(2) BINARY DEFAULT ' ',PEZO19 DECIMAL(4,2) DEFAULT 0,PEZC20 VARCHAR(3) BINARY DEFAULT ' ',PEZG20 VARCHAR(2) BINARY DEFAULT ' ',PEZO20 DECIMAL(4,2) DEFAULT 0,PEZC21 VARCHAR(3) BINARY DEFAULT ' ',PEZG21 VARCHAR(2) BINARY DEFAULT ' ',PEZO21 DECIMAL(4,2) DEFAULT 0,PEZC22 VARCHAR(3) BINARY DEFAULT ' ',PEZG22 VARCHAR(2) BINARY DEFAULT ' ',PEZO22 DECIMAL(4,2) DEFAULT 0,PEZC23 VARCHAR(3) BINARY DEFAULT ' ',PEZG23 VARCHAR(2) BINARY DEFAULT ' ',PEZO23 DECIMAL(4,2) DEFAULT 0,PEZC24 VARCHAR(3) BINARY DEFAULT ' ',PEZG24 VARCHAR(2) BINARY DEFAULT ' ',PEZO24 DECIMAL(4,2) DEFAULT 0,PEZC25 VARCHAR(3) BINARY DEFAULT ' ',PEZG25 VARCHAR(2) BINARY DEFAULT ' ',PEZO25 DECIMAL(4,2) DEFAULT 0,PEZC26 VARCHAR(3) BINARY DEFAULT ' ',PEZG26 VARCHAR(2) BINARY DEFAULT ' ',PEZO26 DECIMAL(4,2) DEFAULT 0,PEZC27 VARCHAR(3) BINARY DEFAULT ' ',PEZG27 VARCHAR(2) BINARY DEFAULT ' ',PEZO27 DECIMAL(4,2) DEFAULT 0,PEZC28 VARCHAR(3) BINARY DEFAULT ' ',PEZG28 VARCHAR(2) BINARY DEFAULT ' ',PEZO28 DECIMAL(4,2) DEFAULT 0,PEZC29 VARCHAR(3) BINARY DEFAULT ' ',PEZG29 VARCHAR(2) BINARY DEFAULT ' ',PEZO29 DECIMAL(4,2) DEFAULT 0,PEZC30 VARCHAR(3) BINARY DEFAULT ' ',PEZG30 VARCHAR(2) BINARY DEFAULT ' ',PEZO30 DECIMAL(4,2) DEFAULT 0,PEZC31 VARCHAR(3) BINARY DEFAULT ' ',PEZG31 VARCHAR(2) BINARY DEFAULT ' ',PEZO31 DECIMAL(4,2) DEFAULT 0,PEZGLZ DECIMAL(6,2) DEFAULT 0,PEZVZN VARCHAR(1) BINARY DEFAULT ' ',PEZRES VARCHAR(53) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PE1 ( PE1MON VARCHAR(2) BINARY ,PE1JHR VARCHAR(4) BINARY DEFAULT ' ',PE1RMO VARCHAR(2) BINARY DEFAULT ' ',PE1KST VARCHAR(7) BINARY DEFAULT ' ',PE1PNR VARCHAR(7) BINARY ,PE1TUC VARCHAR(1) BINARY DEFAULT ' ',PE1RUC VARCHAR(1) BINARY DEFAULT ' ',PE1S01 DECIMAL(6,2) DEFAULT 0,PE1L01 VARCHAR(3) BINARY DEFAULT ' ',PE1N01 VARCHAR(2) BINARY DEFAULT ' ',PE1S02 DECIMAL(6,2) DEFAULT 0,PE1L02 VARCHAR(3) BINARY DEFAULT ' ',PE1N02 VARCHAR(2) BINARY DEFAULT ' ',PE1S03 DECIMAL(6,2) DEFAULT 0,PE1L03 VARCHAR(3) BINARY DEFAULT ' ',PE1N03 VARCHAR(2) BINARY DEFAULT ' ',PE1S04 DECIMAL(6,2) DEFAULT 0,PE1L04 VARCHAR(3) BINARY DEFAULT ' ',PE1N04 VARCHAR(2) BINARY DEFAULT ' ',PE1S05 DECIMAL(6,2) DEFAULT 0,PE1L05 VARCHAR(3) BINARY DEFAULT ' ',PE1N05 VARCHAR(2) BINARY DEFAULT ' ',PE1S06 DECIMAL(6,2) DEFAULT 0,PE1L06 VARCHAR(3) BINARY DEFAULT ' ',PE1N06 VARCHAR(2) BINARY DEFAULT ' ',PE1S07 DECIMAL(6,2) DEFAULT 0,PE1L07 VARCHAR(3) BINARY DEFAULT ' ',PE1N07 VARCHAR(2) BINARY DEFAULT ' ',PE1S08 DECIMAL(6,2) DEFAULT 0,PE1L08 VARCHAR(3) BINARY DEFAULT ' ',PE1N08 VARCHAR(2) BINARY DEFAULT ' ',PE1S09 DECIMAL(6,2) DEFAULT 0,PE1L09 VARCHAR(3) BINARY DEFAULT ' ',PE1N09 VARCHAR(2) BINARY DEFAULT ' ',PE1S10 DECIMAL(6,2) DEFAULT 0,PE1L10 VARCHAR(3) BINARY DEFAULT ' ',PE1N10 VARCHAR(2) BINARY DEFAULT ' ',PE1S11 DECIMAL(6,2) DEFAULT 0,PE1L11 VARCHAR(3) BINARY DEFAULT ' ',PE1N11 VARCHAR(2) BINARY DEFAULT ' ',PE1S12 DECIMAL(6,2) DEFAULT 0,PE1L12 VARCHAR(3) BINARY DEFAULT ' ',PE1N12 VARCHAR(2) BINARY DEFAULT ' ',PE1S13 DECIMAL(6,2) DEFAULT 0,PE1L13 VARCHAR(3) BINARY DEFAULT ' ',PE1N13 VARCHAR(2) BINARY DEFAULT ' ',PE1S14 DECIMAL(6,2) DEFAULT 0,PE1L14 VARCHAR(3) BINARY DEFAULT ' ',PE1N14 VARCHAR(2) BINARY DEFAULT ' ',PE1S15 DECIMAL(6,2) DEFAULT 0,PE1L15 VARCHAR(3) BINARY DEFAULT ' ',PE1N15 VARCHAR(2) BINARY DEFAULT ' ',PE1S16 DECIMAL(6,2) DEFAULT 0,PE1L16 VARCHAR(3) BINARY DEFAULT ' ',PE1N16 VARCHAR(2) BINARY DEFAULT ' ',PE1S17 DECIMAL(6,2) DEFAULT 0,PE1L17 VARCHAR(3) BINARY DEFAULT ' ',PE1N17 VARCHAR(2) BINARY DEFAULT ' ',PE1C01 VARCHAR(3) BINARY DEFAULT ' ',PE1G01 VARCHAR(2) BINARY DEFAULT ' ',PE1O01 DECIMAL(4,2) DEFAULT 0,PE1C02 VARCHAR(3) BINARY DEFAULT ' ',PE1G02 VARCHAR(2) BINARY DEFAULT ' ',PE1O02 DECIMAL(4,2) DEFAULT 0,PE1C03 VARCHAR(3) BINARY DEFAULT ' ',PE1G03 VARCHAR(2) BINARY DEFAULT ' ',PE1O03 DECIMAL(4,2) DEFAULT 0,PE1C04 VARCHAR(3) BINARY DEFAULT ' ',PE1G04 VARCHAR(2) BINARY DEFAULT ' ',PE1O04 DECIMAL(4,2) DEFAULT 0,PE1C05 VARCHAR(3) BINARY DEFAULT ' ',PE1G05 VARCHAR(2) BINARY DEFAULT ' ',PE1O05 DECIMAL(4,2) DEFAULT 0,PE1C06 VARCHAR(3) BINARY DEFAULT ' ',PE1G06 VARCHAR(2) BINARY DEFAULT ' ',PE1O06 DECIMAL(4,2) DEFAULT 0,PE1C07 VARCHAR(3) BINARY DEFAULT ' ',PE1G07 VARCHAR(2) BINARY DEFAULT ' ',PE1O07 DECIMAL(4,2) DEFAULT 0,PE1C08 VARCHAR(3) BINARY DEFAULT ' ',PE1G08 VARCHAR(2) BINARY DEFAULT ' ',PE1O08 DECIMAL(4,2) DEFAULT 0,PE1C09 VARCHAR(3) BINARY DEFAULT ' ',PE1G09 VARCHAR(2) BINARY DEFAULT ' ',PE1O09 DECIMAL(4,2) DEFAULT 0,PE1C10 VARCHAR(3) BINARY DEFAULT ' ',PE1G10 VARCHAR(2) BINARY DEFAULT ' ',PE1O10 DECIMAL(4,2) DEFAULT 0,PE1C11 VARCHAR(3) BINARY DEFAULT ' ',PE1G11 VARCHAR(2) BINARY DEFAULT ' ',PE1O11 DECIMAL(4,2) DEFAULT 0,PE1C12 VARCHAR(3) BINARY DEFAULT ' ',PE1G12 VARCHAR(2) BINARY DEFAULT ' ',PE1O12 DECIMAL(4,2) DEFAULT 0,PE1C13 VARCHAR(3) BINARY DEFAULT ' ',PE1G13 VARCHAR(2) BINARY DEFAULT ' ',PE1O13 DECIMAL(4,2) DEFAULT 0,PE1C14 VARCHAR(3) BINARY DEFAULT ' ',PE1G14 VARCHAR(2) BINARY DEFAULT ' ',PE1O14 DECIMAL(4,2) DEFAULT 0,PE1C15 VARCHAR(3) BINARY DEFAULT ' ',PE1G15 VARCHAR(2) BINARY DEFAULT ' ',PE1O15 DECIMAL(4,2) DEFAULT 0,PE1C16 VARCHAR(3) BINARY DEFAULT ' ',PE1G16 VARCHAR(2) BINARY DEFAULT ' ',PE1O16 DECIMAL(4,2) DEFAULT 0,PE1C17 VARCHAR(3) BINARY DEFAULT ' ',PE1G17 VARCHAR(2) BINARY DEFAULT ' ',PE1O17 DECIMAL(4,2) DEFAULT 0,PE1C18 VARCHAR(3) BINARY DEFAULT ' ',PE1G18 VARCHAR(2) BINARY DEFAULT ' ',PE1O18 DECIMAL(4,2) DEFAULT 0,PE1C19 VARCHAR(3) BINARY DEFAULT ' ',PE1G19 VARCHAR(2) BINARY DEFAULT ' ',PE1O19 DECIMAL(4,2) DEFAULT 0,PE1C20 VARCHAR(3) BINARY DEFAULT ' ',PE1G20 VARCHAR(2) BINARY DEFAULT ' ',PE1O20 DECIMAL(4,2) DEFAULT 0,PE1C21 VARCHAR(3) BINARY DEFAULT ' ',PE1G21 VARCHAR(2) BINARY DEFAULT ' ',PE1O21 DECIMAL(4,2) DEFAULT 0,PE1C22 VARCHAR(3) BINARY DEFAULT ' ',PE1G22 VARCHAR(2) BINARY DEFAULT ' ',PE1O22 DECIMAL(4,2) DEFAULT 0,PE1C23 VARCHAR(3) BINARY DEFAULT ' ',PE1G23 VARCHAR(2) BINARY DEFAULT ' ',PE1O23 DECIMAL(4,2) DEFAULT 0,PE1C24 VARCHAR(3) BINARY DEFAULT ' ',PE1G24 VARCHAR(2) BINARY DEFAULT ' ',PE1O24 DECIMAL(4,2) DEFAULT 0,PE1C25 VARCHAR(3) BINARY DEFAULT ' ',PE1G25 VARCHAR(2) BINARY DEFAULT ' ',PE1O25 DECIMAL(4,2) DEFAULT 0,PE1C26 VARCHAR(3) BINARY DEFAULT ' ',PE1G26 VARCHAR(2) BINARY DEFAULT ' ',PE1O26 DECIMAL(4,2) DEFAULT 0,PE1C27 VARCHAR(3) BINARY DEFAULT ' ',PE1G27 VARCHAR(2) BINARY DEFAULT ' ',PE1O27 DECIMAL(4,2) DEFAULT 0,PE1C28 VARCHAR(3) BINARY DEFAULT ' ',PE1G28 VARCHAR(2) BINARY DEFAULT ' ',PE1O28 DECIMAL(4,2) DEFAULT 0,PE1C29 VARCHAR(3) BINARY DEFAULT ' ',PE1G29 VARCHAR(2) BINARY DEFAULT ' ',PE1O29 DECIMAL(4,2) DEFAULT 0,PE1C30 VARCHAR(3) BINARY DEFAULT ' ',PE1G30 VARCHAR(2) BINARY DEFAULT ' ',PE1O30 DECIMAL(4,2) DEFAULT 0,PE1C31 VARCHAR(3) BINARY DEFAULT ' ',PE1G31 VARCHAR(2) BINARY DEFAULT ' ',PE1O31 DECIMAL(4,2) DEFAULT 0,PE1RES VARCHAR(53) BINARY DEFAULT ' ',PE1GLZ DECIMAL(6,2) DEFAULT 0,PE1VZN VARCHAR(1) BINARY DEFAULT ' ' ,PRIMARY KEY(PE1MON,PE1PNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PE2 ( PE2MON VARCHAR(6) BINARY DEFAULT ' ',PE2KST VARCHAR(7) BINARY DEFAULT ' ',PE2PNR VARCHAR(7) BINARY DEFAULT ' ',PE2ARB VARCHAR(1) BINARY DEFAULT ' ',PE2ART VARCHAR(1) BINARY DEFAULT ' ',PE2VON DECIMAL(8,0) DEFAULT 0,PE2BIS DECIMAL(8,0) DEFAULT 0,PE2FIL VARCHAR(42) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PE3 ( PE3MON VARCHAR(2) BINARY ,PE3JHR VARCHAR(4) BINARY ,PE3RMO VARCHAR(2) BINARY DEFAULT ' ',PE3KST VARCHAR(7) BINARY DEFAULT ' ',PE3PNR VARCHAR(7) BINARY ,PE3RUC VARCHAR(1) BINARY DEFAULT ' ',PE3STD DECIMAL(5,2) DEFAULT 0,PE3LOA VARCHAR(3) BINARY ,PE3PRO DECIMAL(5,2) DEFAULT 0,PE3AWS VARCHAR(7) BINARY ,PE3BWS VARCHAR(7) BINARY DEFAULT ' ',PE3ART VARCHAR(6) BINARY DEFAULT ' ',PE3TAG VARCHAR(2) BINARY DEFAULT ' ',PE3RES VARCHAR(23) BINARY DEFAULT ' ' ,PRIMARY KEY(PE3MON,PE3JHR,PE3PNR,PE3LOA,PE3AWS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PE4 ( PE4MON VARCHAR(2) BINARY ,PE4JHR VARCHAR(4) BINARY ,PE4RMO VARCHAR(2) BINARY DEFAULT ' ',PE4KST VARCHAR(7) BINARY DEFAULT ' ',PE4PNR VARCHAR(7) BINARY ,PE4RUC VARCHAR(1) BINARY DEFAULT ' ',PE4STD DECIMAL(4,0) DEFAULT 0,PE4LOA VARCHAR(3) BINARY ,PE4PRO DECIMAL(5,2) DEFAULT 0,PE4AWS VARCHAR(7) BINARY ,PE4BWS VARCHAR(7) BINARY DEFAULT ' ',PE4ART VARCHAR(6) BINARY DEFAULT ' ',PE4TAG VARCHAR(2) BINARY DEFAULT ' ',PE4RES VARCHAR(23) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PM1 ( PM1PNR VARCHAR(7) BINARY ,PM1LNA VARCHAR(20) BINARY ,PM1VAL DECIMAL(11,2) ,PM1KST VARCHAR(30) BINARY ,PM1KTR VARCHAR(6) BINARY  ,PRIMARY KEY(PM1PNR,PM1LNA,PM1KST,PM1KTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PRO ( PROLER VARCHAR(2) BINARY ,PROFIR VARCHAR(10) BINARY ,PROKNZ VARCHAR(1) BINARY ,PROPNR VARCHAR(6) BINARY ,PROTAG DECIMAL(2,0) ,PROMON DECIMAL(2,0) ,PROJHR DECIMAL(4,0) ,PROLNA VARCHAR(3) BINARY ,PROZET DECIMAL(7,2) ,PROMGE DECIMAL(10,2) ,PROSTZ DECIMAL(10,4) ,PROMGS DECIMAL(10,4) ,PROPRZ DECIMAL(6,2) ,PROBTR DECIMAL(10,2) ,PROKST DECIMAL(8,0) ,PROKTR VARCHAR(20) BINARY ,PROBES VARCHAR(60) BINARY  ,PRIMARY KEY(PROFIR,PROPNR,PROTAG,PROMON,PROJHR,PROLNA,PROKST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PS1 ( PS1STZ VARCHAR(2) BINARY ,PS1FRM VARCHAR(2) BINARY ,PS1F02 VARCHAR(2) BINARY ,PS1PRS VARCHAR(6) BINARY ,PS1F04 VARCHAR(4) BINARY ,PS1ABT DECIMAL(2,0) ,PS1ABD DECIMAL(4,0) ,PS1ABN DECIMAL(1,0) ,PS1DNE VARCHAR(1) BINARY ,PS1LHN DECIMAL(3,0) ,PS1ZTD DECIMAL(5,2) ,PS1LHG VARCHAR(5) BINARY ,PS1BTR DECIMAL(7,2) ,PS1F05 VARCHAR(5) BINARY ,PS1KST VARCHAR(6) BINARY ,PS1F25 VARCHAR(25) BINARY  ,PRIMARY KEY(PS1STZ,PS1FRM,PS1PRS,PS1ABD,PS1ABN,PS1LHN,PS1LHG,PS1KST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PS1B ( PS1STZ VARCHAR(2) BINARY ,PS1FRM VARCHAR(2) BINARY ,PS1F02 VARCHAR(2) BINARY ,PS1PRS VARCHAR(6) BINARY ,PS1F04 VARCHAR(4) BINARY ,PS1ABT DECIMAL(2,0) ,PS1ABD DECIMAL(4,0) ,PS1ABN DECIMAL(1,0) ,PS1DNE VARCHAR(1) BINARY ,PS1F10 DECIMAL(2,0) DEFAULT 10,PS1LHN DECIMAL(3,0) ,PS1ST1 VARCHAR(1) BINARY DEFAULT '*',PS1F11 DECIMAL(2,0) DEFAULT 11,PS1ZTD DECIMAL(5,2) ,PS1ST2 VARCHAR(1) BINARY DEFAULT '*',PS1F13 DECIMAL(2,0) DEFAULT 13,PS1LHG VARCHAR(4) BINARY ,PS1ST3 VARCHAR(1) BINARY DEFAULT '*',PS1F14 VARCHAR(6) BINARY ,PS1KST VARCHAR(5) BINARY ,PS1F25 VARCHAR(25) BINARY  ,PRIMARY KEY(PS1STZ,PS1FRM,PS1PRS,PS1ABT,PS1ABD,PS1ABN,PS1LHN,PS1LHG,PS1KST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PS3 ( PS3STZ VARCHAR(2) BINARY ,PS3FRM VARCHAR(2) BINARY ,PS3F02 VARCHAR(2) BINARY DEFAULT ' ',PS3PRS VARCHAR(6) BINARY ,PS3F04 VARCHAR(4) BINARY DEFAULT ' ',PS3BDT VARCHAR(6) BINARY ,PS3ABN VARCHAR(1) BINARY ,PS3F01 VARCHAR(1) BINARY DEFAULT ' ',PS3LNA VARCHAR(3) BINARY ,PS3ZET VARCHAR(5) BINARY ,PS3F05 VARCHAR(5) BINARY DEFAULT ' ',PS3EDT VARCHAR(6) BINARY DEFAULT ' ',PS3RES VARCHAR(37) BINARY DEFAULT ' ' ,PRIMARY KEY(PS3STZ,PS3FRM,PS3PRS,PS3BDT,PS3ABN,PS3LNA,PS3ZET)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PS3B ( PS3STZ VARCHAR(2) BINARY ,PS3FRM VARCHAR(2) BINARY ,PS3F02 VARCHAR(2) BINARY DEFAULT ' ',PS3PRS VARCHAR(6) BINARY ,PS3F04 VARCHAR(4) BINARY DEFAULT ' ',PS3BDT VARCHAR(6) BINARY ,PS3ABN VARCHAR(1) BINARY ,PS3F01 VARCHAR(1) BINARY DEFAULT ' ',PS3ALN VARCHAR(2) BINARY DEFAULT '10',PS3LNA VARCHAR(3) BINARY ,PS3ELN VARCHAR(1) BINARY DEFAULT '*',PS3AZT VARCHAR(2) BINARY DEFAULT '11',PS3ZET VARCHAR(5) BINARY ,PS3EZT VARCHAR(1) BINARY DEFAULT '*',PS3AEN VARCHAR(2) BINARY DEFAULT '15',PS3EDT VARCHAR(6) BINARY ,PS3EEN VARCHAR(1) BINARY DEFAULT '*',PS3RES VARCHAR(41) BINARY DEFAULT ' ' ,PRIMARY KEY(PS3STZ,PS3FRM,PS3PRS,PS3BDT,PS3ABN,PS3LNA,PS3ZET)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PS4 ( PS4STZ VARCHAR(2) BINARY ,PS4FRM VARCHAR(2) BINARY ,PS4F02 VARCHAR(2) BINARY ,PS4PRS VARCHAR(6) BINARY ,PS4F06 VARCHAR(6) BINARY ,PS4ABD DECIMAL(4,0) ,PS4ABN DECIMAL(1,0) ,PS4DNE VARCHAR(1) BINARY ,PS4F37 DECIMAL(2,0) ,PS4BTA DECIMAL(3,1) ,PS4ST1 VARCHAR(1) BINARY ,PS4F33 DECIMAL(2,0) ,PS4BAS DECIMAL(5,2) ,PS4ST2 VARCHAR(1) BINARY ,PS4F12 DECIMAL(2,0) ,PS4STA DECIMAL(3,1) ,PS4ST3 VARCHAR(1) BINARY ,PS4F13 DECIMAL(2,0) ,PS4SVA DECIMAL(3,1) ,PS4ST4 VARCHAR(1) BINARY ,PS4F14 DECIMAL(2,0) ,PS4ANA DECIMAL(3,1) ,PS4ST5 VARCHAR(1) BINARY ,PS4F15 DECIMAL(2,0) ,PS4KRA DECIMAL(3,1) ,PS4ST6 VARCHAR(1) BINARY ,PS4F22 DECIMAL(2,0) ,PS4ARN VARCHAR(1) BINARY ,PS4ST7 VARCHAR(1) BINARY ,PS4F80 VARCHAR(14) BINARY  ,PRIMARY KEY(PS4STZ,PS4FRM,PS4PRS,PS4ABD,PS4ABN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333PS4B ( PS4STZ VARCHAR(2) BINARY ,PS4FRM VARCHAR(2) BINARY ,PS4F02 VARCHAR(2) BINARY ,PS4PRS VARCHAR(6) BINARY ,PS4F06 VARCHAR(6) BINARY ,PS4ABD DECIMAL(4,0) ,PS4ABN DECIMAL(1,0) ,PS4DNE VARCHAR(1) BINARY ,PS4F37 DECIMAL(2,0) DEFAULT 37,PS4BTA DECIMAL(3,1) ,PS4ST1 VARCHAR(1) BINARY DEFAULT '*',PS4F33 DECIMAL(2,0) DEFAULT 33,PS4BAS DECIMAL(5,2) ,PS4ST2 VARCHAR(1) BINARY DEFAULT '*',PS4F12 DECIMAL(2,0) DEFAULT 12,PS4STA DECIMAL(3,1) ,PS4ST3 VARCHAR(1) BINARY DEFAULT '*',PS4F13 DECIMAL(2,0) DEFAULT 13,PS4SVA DECIMAL(3,1) ,PS4ST4 VARCHAR(1) BINARY DEFAULT '*',PS4F14 DECIMAL(2,0) DEFAULT 14,PS4ANA DECIMAL(3,1) ,PS4ST5 VARCHAR(1) BINARY DEFAULT '*',PS4F15 DECIMAL(2,0) DEFAULT 15,PS4KRA DECIMAL(3,1) ,PS4ST6 VARCHAR(1) BINARY DEFAULT '*',PS4F19 VARCHAR(19) BINARY  ,PRIMARY KEY(PS4STZ,PS4FRM,PS4PRS,PS4ABD,PS4ABN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333SAG ( SAGMON VARCHAR(2) BINARY ,SAGPNR VARCHAR(6) BINARY ,SAGLNA VARCHAR(10) BINARY ,SAGSTD DECIMAL(7,2) ,SAGBTR DECIMAL(5,2) ,SAGKST VARCHAR(10) BINARY ,SAGSKT VARCHAR(5) BINARY ,SAGKTR VARCHAR(5) BINARY ,SAGDAT DATETIME ,MDNR VARCHAR(6) BINARY ,ABRJAHR VARCHAR(4) BINARY ,DAT VARCHAR(2) BINARY ,AA1 VARCHAR(6) BINARY ,ANZAHL DECIMAL(5,0) ,ZUSCHLAG DECIMAL(5,0) ,LATEXT VARCHAR(61) BINARY ,LAGTEXT VARCHAR(71) BINARY  ,PRIMARY KEY(SAGMON,SAGPNR,SAGLNA,SAGKST,SAGKTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333SBS ( SBSJHR VARCHAR(2) BINARY ,SBSMON VARCHAR(2) BINARY ,SBSTAG VARCHAR(2) BINARY ,SBSPNR VARCHAR(6) BINARY ,SBSLNA VARCHAR(3) BINARY ,SBSVZN VARCHAR(1) BINARY ,SBSSTD DECIMAL(8,2) ,SBSFKB DECIMAL(8,2) ,SBSFKC DECIMAL(8,2) ,SBSFKD DECIMAL(8,2) ,SBSFKE DECIMAL(8,2) ,SBSKST VARCHAR(12) BINARY ,SBSKTR VARCHAR(12) BINARY ,SBSBAB VARCHAR(3) BINARY ,SBSF01 VARCHAR(1) BINARY ,SBSADA VARCHAR(2) BINARY ,SBSWKZ VARCHAR(1) BINARY ,SBSF63 VARCHAR(63) BINARY  ,PRIMARY KEY(SBSJHR,SBSMON,SBSTAG,SBSPNR,SBSLNA,SBSKST,SBSKTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333SLI ( SLIKON VARCHAR(4) BINARY DEFAULT 'LOAF',SLIPNR VARCHAR(5) BINARY DEFAULT NULL,SLIFNR VARCHAR(2) BINARY DEFAULT '00',SLILNA VARCHAR(3) BINARY DEFAULT NULL,SLIVZB VARCHAR(1) BINARY DEFAULT NULL,SLIBTG VARCHAR(8) BINARY DEFAULT NULL,SLIKST VARCHAR(5) BINARY DEFAULT NULL,SLIPRD VARCHAR(1) BINARY DEFAULT NULL,SLIAMT VARCHAR(6) BINARY DEFAULT NULL,SLIEMT VARCHAR(6) BINARY DEFAULT NULL,SLIVZS VARCHAR(1) BINARY DEFAULT NULL,SLISTD VARCHAR(5) BINARY DEFAULT NULL,SLIVZT VARCHAR(1) BINARY DEFAULT NULL,SLITGE VARCHAR(4) BINARY DEFAULT NULL,SLIVZP VARCHAR(1) BINARY DEFAULT NULL,SLIPRZ VARCHAR(5) BINARY DEFAULT NULL,SLITXT VARCHAR(14) BINARY DEFAULT NULL ,PRIMARY KEY(SLIPNR,SLILNA,SLIAMT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333S01 ( S01ART VARCHAR(4) BINARY ,S01MND VARCHAR(3) BINARY ,S01PNR VARCHAR(8) BINARY ,S01NAM VARCHAR(30) BINARY ,S01LNA VARCHAR(4) BINARY ,S01VON VARCHAR(10) BINARY ,S01BIS VARCHAR(10) BINARY ,S01UZV VARCHAR(5) BINARY ,S01UZB VARCHAR(5) BINARY ,S01HND VARCHAR(1) BINARY ,S01FIL VARCHAR(14) BINARY  ,PRIMARY KEY(S01MND,S01PNR,S01LNA,S01VON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333S10 ( S10ART VARCHAR(4) BINARY ,S10MND VARCHAR(3) BINARY ,S10PNR VARCHAR(8) BINARY ,S10NAM VARCHAR(30) BINARY ,S10LNA VARCHAR(4) BINARY ,S10VON VARCHAR(10) BINARY ,S10STD DECIMAL(7,2) ,S10BTR VARCHAR(13) BINARY ,S10HND VARCHAR(1) BINARY ,S10FIL VARCHAR(14) BINARY  ,PRIMARY KEY(S10MND,S10PNR,S10LNA,S10VON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333TP1 ( TP1FIR VARCHAR(3) BINARY ,TP1PNR VARCHAR(10) BINARY ,TP1JMM VARCHAR(10) BINARY ,TP1JMV VARCHAR(10) BINARY ,TP1LNA VARCHAR(3) BINARY ,TP1BZT DECIMAL(7,2) ,TP1TGE DECIMAL(6,2) ,TP1FAK DECIMAL(10,2) ,TP1GBF DECIMAL(12,2) ,TP1WKZ VARCHAR(3) BINARY ,TP1GSB DECIMAL(12,2) ,TP1STB DECIMAL(12,2) ,TP1SVB DECIMAL(12,2) ,TP1KST VARCHAR(10) BINARY ,TP1KTR VARCHAR(10) BINARY ,TP1ABG VARCHAR(2) BINARY ,TP1BDT VARCHAR(10) BINARY ,TP1KZR VARCHAR(1) BINARY DEFAULT '0',TP1HER VARCHAR(3) BINARY ,TP1LKZ VARCHAR(1) BINARY ,TP1ERF VARCHAR(10) BINARY ,TP1EDT VARCHAR(10) BINARY ,TP1CHG VARCHAR(10) BINARY ,TP1CDT VARCHAR(10) BINARY ,TP1CZT VARCHAR(8) BINARY  ,PRIMARY KEY(TP1FIR,TP1PNR,TP1JMM,TP1LNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333TP2 ( TP2FIR VARCHAR(3) BINARY ,TP2PNR VARCHAR(10) BINARY ,TP2VON VARCHAR(10) BINARY ,TP2BIS VARCHAR(10) BINARY ,TP2FGR VARCHAR(3) BINARY ,TP2FGD VARCHAR(3) BINARY ,TP2TGE DECIMAL(8,2) ,TP2STD DECIMAL(10,2) ,TP2TXT VARCHAR(50) BINARY ,TP2DGR VARCHAR(2) BINARY ,TP2LKZ VARCHAR(1) BINARY ,TP2ERF VARCHAR(10) BINARY ,TP2EDT VARCHAR(10) BINARY ,TP2CHG VARCHAR(10) BINARY ,TP2CDT VARCHAR(10) BINARY ,TP2CZT VARCHAR(8) BINARY  ,PRIMARY KEY(TP2FIR,TP2PNR,TP2VON,TP2BIS,TP2FGR,TP2FGD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333VWW ( VWWSTZ VARCHAR(4) BINARY ,VWWFIR VARCHAR(4) BINARY ,VWWEDT VARCHAR(7) BINARY ,VWWPNR VARCHAR(8) BINARY ,VWWLNA VARCHAR(4) BINARY ,VWWKST VARCHAR(10) BINARY ,VWWIND VARCHAR(7) BINARY ,VWWLGR VARCHAR(3) BINARY ,VWWGUT VARCHAR(2) BINARY ,VWWSTD DECIMAL(7,2)      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS333XXL ( XXLPNR VARCHAR(6) BINARY ,XXLERD VARCHAR(8) BINARY DEFAULT ' ',XXLABD VARCHAR(8) BINARY DEFAULT ' ',XXLLNA VARCHAR(3) BINARY DEFAULT '000',XXLKNZ VARCHAR(2) BINARY DEFAULT '99',XXLVO1 VARCHAR(1) BINARY DEFAULT '+',XXLEIN VARCHAR(12) BINARY DEFAULT '00000000.000',XXLVO2 VARCHAR(1) BINARY DEFAULT '+',XXLSTD VARCHAR(11) BINARY DEFAULT '00000000.00',XXLVO3 VARCHAR(1) BINARY DEFAULT '+',XXLBTR VARCHAR(11) BINARY DEFAULT '00000000.00',XXLKST VARCHAR(8) BINARY DEFAULT '  ',XXLKTR VARCHAR(12) BINARY DEFAULT '  ',XXLVO4 VARCHAR(1) BINARY DEFAULT '+',XXLST2 VARCHAR(12) BINARY DEFAULT '00000000.000',XXLPRZ VARCHAR(10) BINARY DEFAULT '000000.000',XXLFIL VARCHAR(20) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B00 ( B00LNA DECIMAL(3,0) DEFAULT 0,B00KNZ DECIMAL(1,0) DEFAULT 0,B00DAT DECIMAL(8,0) DEFAULT 0,B00BL1 VARCHAR(1) BINARY DEFAULT ' ',B00KST DECIMAL(6,0) DEFAULT 0,B00TR1 VARCHAR(1) BINARY DEFAULT '*',B00PNR VARCHAR(8) BINARY DEFAULT ' ',B00TR2 VARCHAR(1) BINARY DEFAULT '*',B00VRZ VARCHAR(1) BINARY DEFAULT '*',B00STD DECIMAL(4,0) DEFAULT 0,B00TR3 VARCHAR(1) BINARY DEFAULT '*',B00LGR VARCHAR(2) BINARY DEFAULT '  ',B00LST VARCHAR(2) BINARY DEFAULT '  ',B00ANR VARCHAR(16) BINARY DEFAULT ' ',B00TR4 VARCHAR(1) BINARY DEFAULT '*',B00SCH VARCHAR(3) BINARY DEFAULT ' ',B00TR5 VARCHAR(1) BINARY DEFAULT '*',B00BNM DECIMAL(6,0) DEFAULT 0,B00BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B01 ( B01LNA DECIMAL(3,0) DEFAULT 0,B01KNZ DECIMAL(1,0) DEFAULT 0,B01DAT DECIMAL(8,0) DEFAULT 0,B01BL1 VARCHAR(1) BINARY DEFAULT ' ',B01KST DECIMAL(6,0) DEFAULT 0,B01TR1 VARCHAR(1) BINARY DEFAULT '*',B01PNR VARCHAR(8) BINARY DEFAULT ' ',B01TR2 VARCHAR(1) BINARY DEFAULT '*',B01VRZ VARCHAR(1) BINARY DEFAULT '*',B01STD DECIMAL(4,0) DEFAULT 0,B01TR3 VARCHAR(1) BINARY DEFAULT '*',B01LGR VARCHAR(2) BINARY DEFAULT '  ',B01LST VARCHAR(2) BINARY DEFAULT '  ',B01ANR VARCHAR(16) BINARY DEFAULT ' ',B01TR4 VARCHAR(1) BINARY DEFAULT '*',B01SCH VARCHAR(3) BINARY DEFAULT ' ',B01TR5 VARCHAR(1) BINARY DEFAULT '*',B01BNM DECIMAL(6,0) DEFAULT 0,B01BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B02 ( B02LNA DECIMAL(3,0) DEFAULT 0,B02KNZ DECIMAL(1,0) DEFAULT 0,B02DAT DECIMAL(8,0) DEFAULT 0,B02BL1 VARCHAR(1) BINARY DEFAULT ' ',B02KST DECIMAL(6,0) DEFAULT 0,B02TR1 VARCHAR(1) BINARY DEFAULT '*',B02PNR VARCHAR(8) BINARY DEFAULT ' ',B02TR2 VARCHAR(1) BINARY DEFAULT '*',B02VRZ VARCHAR(1) BINARY DEFAULT '*',B02STD DECIMAL(4,0) DEFAULT 0,B02TR3 VARCHAR(1) BINARY DEFAULT '*',B02LGR VARCHAR(2) BINARY DEFAULT '  ',B02LST VARCHAR(2) BINARY DEFAULT '  ',B02ANR VARCHAR(16) BINARY DEFAULT ' ',B02TR4 VARCHAR(1) BINARY DEFAULT '*',B02SCH VARCHAR(3) BINARY DEFAULT ' ',B02TR5 VARCHAR(1) BINARY DEFAULT '*',B02BNM DECIMAL(6,0) DEFAULT 0,B02BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B03 ( B03LNA DECIMAL(3,0) DEFAULT 0,B03KNZ DECIMAL(1,0) DEFAULT 0,B03DAT DECIMAL(8,0) DEFAULT 0,B03BL1 VARCHAR(1) BINARY DEFAULT ' ',B03KST DECIMAL(6,0) DEFAULT 0,B03TR1 VARCHAR(1) BINARY DEFAULT '*',B03PNR VARCHAR(8) BINARY DEFAULT ' ',B03TR2 VARCHAR(1) BINARY DEFAULT '*',B03VRZ VARCHAR(1) BINARY DEFAULT '*',B03STD DECIMAL(4,0) DEFAULT 0,B03TR3 VARCHAR(1) BINARY DEFAULT '*',B03LGR VARCHAR(2) BINARY DEFAULT '  ',B03LST VARCHAR(2) BINARY DEFAULT '  ',B03ANR VARCHAR(16) BINARY DEFAULT ' ',B03TR4 VARCHAR(1) BINARY DEFAULT '*',B03SCH VARCHAR(3) BINARY DEFAULT ' ',B03TR5 VARCHAR(1) BINARY DEFAULT '*',B03BNM DECIMAL(6,0) DEFAULT 0,B03BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B04 ( B04LNA DECIMAL(3,0) DEFAULT 0,B04KNZ DECIMAL(1,0) DEFAULT 0,B04DAT DECIMAL(8,0) DEFAULT 0,B04BL1 VARCHAR(1) BINARY DEFAULT ' ',B04KST DECIMAL(6,0) DEFAULT 0,B04TR1 VARCHAR(1) BINARY DEFAULT '*',B04PNR VARCHAR(8) BINARY DEFAULT ' ',B04TR2 VARCHAR(1) BINARY DEFAULT '*',B04VRZ VARCHAR(1) BINARY DEFAULT '*',B04STD DECIMAL(4,0) DEFAULT 0,B04TR3 VARCHAR(1) BINARY DEFAULT '*',B04LGR VARCHAR(2) BINARY DEFAULT '  ',B04LST VARCHAR(2) BINARY DEFAULT '  ',B04ANR VARCHAR(16) BINARY DEFAULT ' ',B04TR4 VARCHAR(1) BINARY DEFAULT '*',B04SCH VARCHAR(3) BINARY DEFAULT ' ',B04TR5 VARCHAR(1) BINARY DEFAULT '*',B04BNM DECIMAL(6,0) DEFAULT 0,B04BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B05 ( B05LNA DECIMAL(3,0) DEFAULT 0,B05KNZ DECIMAL(1,0) DEFAULT 0,B05DAT DECIMAL(8,0) DEFAULT 0,B05BL1 VARCHAR(1) BINARY DEFAULT ' ',B05KST DECIMAL(6,0) DEFAULT 0,B05TR1 VARCHAR(1) BINARY DEFAULT '*',B05PNR VARCHAR(8) BINARY DEFAULT ' ',B05TR2 VARCHAR(1) BINARY DEFAULT '*',B05VRZ VARCHAR(1) BINARY DEFAULT '*',B05STD DECIMAL(4,0) DEFAULT 0,B05TR3 VARCHAR(1) BINARY DEFAULT '*',B05LGR VARCHAR(2) BINARY DEFAULT '  ',B05LST VARCHAR(2) BINARY DEFAULT '  ',B05ANR VARCHAR(16) BINARY DEFAULT ' ',B05TR4 VARCHAR(1) BINARY DEFAULT '*',B05SCH VARCHAR(3) BINARY DEFAULT ' ',B05TR5 VARCHAR(1) BINARY DEFAULT '*',B05BNM DECIMAL(6,0) DEFAULT 0,B05BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B06 ( B06LNA DECIMAL(3,0) DEFAULT 0,B06KNZ DECIMAL(1,0) DEFAULT 0,B06DAT DECIMAL(8,0) DEFAULT 0,B06BL1 VARCHAR(1) BINARY DEFAULT ' ',B06KST DECIMAL(6,0) DEFAULT 0,B06TR1 VARCHAR(1) BINARY DEFAULT '*',B06PNR VARCHAR(8) BINARY DEFAULT ' ',B06TR2 VARCHAR(1) BINARY DEFAULT '*',B06VRZ VARCHAR(1) BINARY DEFAULT '*',B06STD DECIMAL(4,0) DEFAULT 0,B06TR3 VARCHAR(1) BINARY DEFAULT '*',B06LGR VARCHAR(2) BINARY DEFAULT '  ',B06LST VARCHAR(2) BINARY DEFAULT '  ',B06ANR VARCHAR(16) BINARY DEFAULT ' ',B06TR4 VARCHAR(1) BINARY DEFAULT '*',B06SCH VARCHAR(3) BINARY DEFAULT ' ',B06TR5 VARCHAR(1) BINARY DEFAULT '*',B06BNM DECIMAL(6,0) DEFAULT 0,B06BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B07 ( B07LNA DECIMAL(3,0) DEFAULT 0,B07KNZ DECIMAL(1,0) DEFAULT 0,B07DAT DECIMAL(8,0) DEFAULT 0,B07BL1 VARCHAR(1) BINARY DEFAULT ' ',B07KST DECIMAL(6,0) DEFAULT 0,B07TR1 VARCHAR(1) BINARY DEFAULT '*',B07PNR VARCHAR(8) BINARY DEFAULT ' ',B07TR2 VARCHAR(1) BINARY DEFAULT '*',B07VRZ VARCHAR(1) BINARY DEFAULT '*',B07STD DECIMAL(4,0) DEFAULT 0,B07TR3 VARCHAR(1) BINARY DEFAULT '*',B07LGR VARCHAR(2) BINARY DEFAULT '  ',B07LST VARCHAR(2) BINARY DEFAULT '  ',B07ANR VARCHAR(16) BINARY DEFAULT ' ',B07TR4 VARCHAR(1) BINARY DEFAULT '*',B07SCH VARCHAR(3) BINARY DEFAULT ' ',B07TR5 VARCHAR(1) BINARY DEFAULT '*',B07BNM DECIMAL(6,0) DEFAULT 0,B07BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B08 ( B08LNA DECIMAL(3,0) DEFAULT 0,B08KNZ DECIMAL(1,0) DEFAULT 0,B08DAT DECIMAL(8,0) DEFAULT 0,B08BL1 VARCHAR(1) BINARY DEFAULT ' ',B08KST DECIMAL(6,0) DEFAULT 0,B08TR1 VARCHAR(1) BINARY DEFAULT '*',B08PNR VARCHAR(8) BINARY DEFAULT ' ',B08TR2 VARCHAR(1) BINARY DEFAULT '*',B08VRZ VARCHAR(1) BINARY DEFAULT '*',B08STD DECIMAL(4,0) DEFAULT 0,B08TR3 VARCHAR(1) BINARY DEFAULT '*',B08LGR VARCHAR(2) BINARY DEFAULT '  ',B08LST VARCHAR(2) BINARY DEFAULT '  ',B08ANR VARCHAR(16) BINARY DEFAULT ' ',B08TR4 VARCHAR(1) BINARY DEFAULT '*',B08SCH VARCHAR(3) BINARY DEFAULT ' ',B08TR5 VARCHAR(1) BINARY DEFAULT '*',B08BNM DECIMAL(6,0) DEFAULT 0,B08BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B09 ( B09LNA DECIMAL(3,0) DEFAULT 0,B09KNZ DECIMAL(1,0) DEFAULT 0,B09DAT DECIMAL(8,0) DEFAULT 0,B09BL1 VARCHAR(1) BINARY DEFAULT ' ',B09KST DECIMAL(6,0) DEFAULT 0,B09TR1 VARCHAR(1) BINARY DEFAULT '*',B09PNR VARCHAR(8) BINARY DEFAULT ' ',B09TR2 VARCHAR(1) BINARY DEFAULT '*',B09VRZ VARCHAR(1) BINARY DEFAULT '*',B09STD DECIMAL(4,0) DEFAULT 0,B09TR3 VARCHAR(1) BINARY DEFAULT '*',B09LGR VARCHAR(2) BINARY DEFAULT '  ',B09LST VARCHAR(2) BINARY DEFAULT '  ',B09ANR VARCHAR(16) BINARY DEFAULT ' ',B09TR4 VARCHAR(1) BINARY DEFAULT '*',B09SCH VARCHAR(3) BINARY DEFAULT ' ',B09TR5 VARCHAR(1) BINARY DEFAULT '*',B09BNM DECIMAL(6,0) DEFAULT 0,B09BL2 VARCHAR(14) BINARY DEFAULT ' '     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS336B10 ( B10DAT DECIMAL(8,0) ,B10PNR VARCHAR(8) BINARY ,B10LNA DECIMAL(3,0) DEFAULT 0,B10KNZ DECIMAL(1,0) DEFAULT 0,B10BL1 VARCHAR(1) BINARY DEFAULT ' ',B10KST DECIMAL(6,0) DEFAULT 0,B10TR1 VARCHAR(1) BINARY DEFAULT '*',B10TR2 VARCHAR(1) BINARY DEFAULT '*',B10VRZ VARCHAR(1) BINARY DEFAULT '*',B10STD DECIMAL(4,0) DEFAULT 0,B10TR3 VARCHAR(1) BINARY DEFAULT '*',B10LGR VARCHAR(2) BINARY DEFAULT '  ',B10LST VARCHAR(2) BINARY DEFAULT '  ',B10ANR VARCHAR(16) BINARY DEFAULT ' ',B10TR4 VARCHAR(1) BINARY DEFAULT '*',B10SCH VARCHAR(3) BINARY DEFAULT ' ',B10TR5 VARCHAR(1) BINARY DEFAULT '*',B10BNM DECIMAL(6,0) DEFAULT 0,B10BL2 VARCHAR(14) BINARY DEFAULT ' ',B10SUF DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(B10DAT,B10PNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS350ABP ( ABPPNR VARCHAR(8) BINARY ,ABPTYP VARCHAR(10) BINARY ,ABPVON VARCHAR(14) BINARY ,ABPBIS VARCHAR(14) BINARY ,ABPLFD DECIMAL(6,0) ,ABPABT VARCHAR(15) BINARY ,ABPUEB DECIMAL(3,0) ,ABPGTG DECIMAL(3,0) ,ABPORT VARCHAR(50) BINARY ,ABPBEZ VARCHAR(50) BINARY ,ABPBEM VARCHAR(3000) BINARY ,ABPSTA DECIMAL(5,0) DEFAULT 1,ABPDAT DATETIME ,ABPERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(ABPPNR,ABPTYP,ABPVON,ABPLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS370ZNP ( ZNPNUM VARCHAR(15) BINARY ,ZNPTXT VARCHAR(50) BINARY ,ZNPSTA DECIMAL(5,0) DEFAULT 1,ZNPDAT DATETIME ,ZNPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZNPNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS371ZND ( ZNDZNP VARCHAR(15) BINARY ,ZNDNUM DECIMAL(5,0) ,ZNDZKT VARCHAR(5) BINARY ,ZNDANZ DECIMAL(1,0) ,ZNDLFD DECIMAL(3,0) ,ZNDSTA DECIMAL(5,0) DEFAULT 1,ZNDDAT DATETIME ,ZNDERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZNDTXT VARCHAR(50) BINARY ,ZNDFNU DECIMAL(3,0)  ,PRIMARY KEY(ZNDZNP,ZNDNUM,ZNDZKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS381BVS ( BVSSBE VARCHAR(8) BINARY ,BVSKE1 VARCHAR(3) BINARY ,BVSKE2 VARCHAR(15) BINARY ,BVSTXT VARCHAR(30) BINARY DEFAULT ' ',BVSBER DECIMAL(2,0) DEFAULT 0,BVSSTA DECIMAL(5,0) DEFAULT 1,BVSDAT DATETIME ,BVSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(BVSSBE,BVSKE1,BVSKE2)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS382BVF ( BVFPNR VARCHAR(8) BINARY ,BVFFC1 VARCHAR(3) BINARY DEFAULT ' ',BVFFC2 VARCHAR(3) BINARY DEFAULT ' ',BVFVON DATETIME ,BVFBIS DATETIME ,BVFKOM VARCHAR(1000) BINARY DEFAULT ' ',BVFGEN DECIMAL(2,0) DEFAULT 0,BVFBEM VARCHAR(200) BINARY DEFAULT ' ',BVFSTA DECIMAL(5,0) DEFAULT 1,BVFDAT DATETIME ,BVFERF VARCHAR(50) BINARY DEFAULT NULL,BVFGDA DATETIME ,BVFKDA DATETIME ,BVFGER VARCHAR(50) BINARY DEFAULT NULL,BVFKER VARCHAR(50) BINARY DEFAULT NULL,BVFKST VARCHAR(30) BINARY ,BVFNAM VARCHAR(50) BINARY ,BVFUH1 DATETIME ,BVFUH2 DATETIME ,BVFAND DATETIME ,BVFAER VARCHAR(50) BINARY ,BVFKEY VARCHAR(14) BINARY ,BVFNTG DECIMAL(5,2) ,BVFNNJ DECIMAL(5,2)  ,PRIMARY KEY(BVFPNR,BVFFC1,BVFVON,BVFBIS,BVFGEN,BVFKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS382BVK ( BVKSBE VARCHAR(8) BINARY ,BVKPNR VARCHAR(8) BINARY ,BVKFC1 VARCHAR(3) BINARY ,BVKVON DATETIME ,BVKBIS DATETIME ,BVKGEN DECIMAL(2,0) DEFAULT 0,BVKFC2 VARCHAR(3) BINARY ,BVKKOM VARCHAR(250) BINARY ,BVKBEM VARCHAR(250) BINARY ,BVKSTA DECIMAL(5,0) DEFAULT 1,BVKDAT DATETIME ,BVKERF VARCHAR(50) BINARY ,BVKGDA DATETIME ,BVKKDA DATETIME ,BVKGER VARCHAR(50) BINARY DEFAULT NULL,BVKKER VARCHAR(50) BINARY DEFAULT NULL,BVKKST VARCHAR(10) BINARY ,BVKNAM VARCHAR(100) BINARY ,BVKEIN DECIMAL(1,0) DEFAULT 0,BVKTX1 VARCHAR(100) BINARY ,BVKNU1 DECIMAL(2,0) ,BVKTX2 VARCHAR(100) BINARY ,BVKNU2 DECIMAL(2,0) ,BVKUH1 DATETIME ,BVKUH2 DATETIME ,BVKKEY VARCHAR(14) BINARY ,BVFKEY VARCHAR(14) BINARY  ,PRIMARY KEY(BVKSBE,BVKPNR,BVKFC1,BVKVON,BVKBIS,BVKGEN,BVKKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS382KOM ( KOMKEY VARCHAR(14) BINARY ,KOMZPK VARCHAR(14) BINARY ,KOMPNR VARCHAR(8) BINARY ,KOMKOM VARCHAR(600) BINARY ,KOMERF VARCHAR(50) BINARY ,KOMART VARCHAR(3) BINARY  ,PRIMARY KEY(KOMKEY,KOMZPK,KOMPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS382PRT ( PRTKEY VARCHAR(14) BINARY ,PRTZPK VARCHAR(14) BINARY ,PRTNAM VARCHAR(50) BINARY ,PRTNUM DECIMAL(11,0) ,PRTWHL DECIMAL(5,0) ,PRTVA1 VARCHAR(50) BINARY ,PRTPNR VARCHAR(8) BINARY  ,PRIMARY KEY(PRTKEY,PRTZPK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS401ZLG ( ZLGTRG VARCHAR(10) BINARY ,ZLGTXT VARCHAR(50) BINARY ,ZLGKTX VARCHAR(10) BINARY ,ZLGSTA DECIMAL(5,0) DEFAULT 1,ZLGDAT DATETIME ,ZLGERF VARCHAR(50) BINARY DEFAULT 'Timesys'     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS407ZWG ( ZWGNUM VARCHAR(5) BINARY ,ZWGTXT VARCHAR(50) BINARY ,ZWGKTX VARCHAR(50) BINARY ,ZWGSTA DECIMAL(5,0) DEFAULT 1,ZWGDAT DATETIME ,ZWGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZWGNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS407ZW1 ( ZW1NUM VARCHAR(5) BINARY ,ZW1LFD DECIMAL(5,0) DEFAULT 0,ZW1KBV VARCHAR(5) BINARY ,ZW1KBN VARCHAR(5) BINARY ,ZW1DAU DECIMAL(5,0) DEFAULT 1,ZW1STA DECIMAL(5,0) DEFAULT 1,ZW1DAT DATETIME ,ZW1ERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZW1NUM,ZW1LFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS407ZW2 ( ZW2NUM VARCHAR(5) BINARY ,ZW2ASW VARCHAR(13) BINARY ,ZW2VON DATETIME ,ZW2AKT DATETIME ,ZW2BIS DATETIME ,ZW2RWG DECIMAL(1,0) ,ZW2STA DECIMAL(5,0) DEFAULT 1,ZW2DAT DATETIME ,ZW2ERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZW2NUM,ZW2ASW,ZW2VON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS408BZU ( BZUZAU VARCHAR(5) BINARY ,BZUKST VARCHAR(30) BINARY ,BZUVKS VARCHAR(30) BINARY ,BZUABT VARCHAR(15) BINARY ,BZUVAB VARCHAR(15) BINARY ,BZUAKR VARCHAR(5) BINARY ,BZUGVO DATETIME ,BZUGBI DATETIME ,BZUBKL VARCHAR(5) BINARY ,BZUSTA DECIMAL(5,0) DEFAULT 1,BZUDAT DATETIME ,BZUERF VARCHAR(50) BINARY DEFAULT 'Timesys',BZUZTP DECIMAL(5,0) DEFAULT 1,BZUZVL VARCHAR(30) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS500AUK ( AUKAPK CHAR(12) ,AUKBZ1 CHAR(30) ,AUKBZ2 CHAR(30) ,AUKTXT CHAR(10) ,AUKSTS DECIMAL(5,0) DEFAULT 0,AUKBGS CHAR(8) ,AUKENS CHAR(8) ,AUKAFO DECIMAL(5,0) DEFAULT 0,AUKKUN CHAR(7) ,AUKKB1 CHAR(30) ,AUKKB2 CHAR(30) ,AUKTNR CHAR(20) ,AUKTB1 CHAR(30) ,AUKTB2 CHAR(30) ,AUKSME DECIMAL(11,3) DEFAULT NULL,AUKMEE CHAR(3) ,AUKFBE CHAR(10) DEFAULT 'BDE',AUKKST CHAR(10) ,AUKZF1 CHAR(30) ,AUKZF2 CHAR(30) ,AUKZF3 CHAR(30)  ,PRIMARY KEY(AUKAPK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS501APK ( APKAPK VARCHAR(12) BINARY ,APKBZ1 VARCHAR(30) BINARY ,APKBZ2 VARCHAR(30) BINARY ,APKTXT VARCHAR(10) BINARY ,APKSTS DECIMAL(5,0) DEFAULT 0,APKSIS DECIMAL(5,0) DEFAULT 0,APKKUN VARCHAR(7) BINARY ,APKKB1 VARCHAR(30) BINARY ,APKKB2 VARCHAR(30) BINARY ,APKBGS DATETIME ,APKENS DATETIME ,APKAFO DECIMAL(5,0) DEFAULT 0,APKEAF DECIMAL(5,0) DEFAULT 0,APKTNR VARCHAR(20) BINARY ,APKTB1 VARCHAR(30) BINARY ,APKTB2 VARCHAR(30) BINARY ,APKSME DECIMAL(11,3) DEFAULT 0,APKIME DECIMAL(11,3) DEFAULT 0,APKMEE VARCHAR(3) BINARY ,APKBDI DATETIME ,APKEDI DATETIME ,APKFBE VARCHAR(10) BINARY DEFAULT NULL,APKKST VARCHAR(30) BINARY DEFAULT NULL,APKZF1 VARCHAR(30) BINARY ,APKZF2 VARCHAR(30) BINARY ,APKZF3 VARCHAR(30) BINARY ,APKKNZ VARCHAR(1) BINARY ,APKSSN DECIMAL(5,0) DEFAULT 0,APKDNA VARCHAR(3) BINARY ,APKDWN VARCHAR(8) BINARY ,APKSTA DECIMAL(5,0) DEFAULT 1,APKDAT DATETIME ,APKERF VARCHAR(50) BINARY DEFAULT 'Timesys',APKABA DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(APKAPK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS503AFO ( AFOAPK CHAR(12) ,AFOAPP CHAR(5) ,AFOVAF CHAR(5) ,AFONAF CHAR(5) ,AFOBZ1 CHAR(30) ,AFOBZ2 CHAR(30) ,AFOTXT CHAR(10) ,AFOSTS DECIMAL(3,0) DEFAULT 0,AFOBGS CHAR(8) ,AFOBGZ CHAR(6) ,AFOENS CHAR(8) ,AFOENZ CHAR(6) ,AFOAGS DECIMAL(5,0) DEFAULT 0,AFOSME DECIMAL(11,3) DEFAULT 0,AFOMEE CHAR(3) ,AFOSTA DECIMAL(11,2) ,AFOSTR DECIMAL(11,2) ,AFOSTE DECIMAL(11,2) ,AFOAPG CHAR(10) ,AFOAPL CHAR(10) ,AFOFBE CHAR(10) DEFAULT NULL,AFOKST CHAR(10) ,AFOZF1 CHAR(30) ,AFOZF2 CHAR(30) ,AFOZF3 CHAR(30)  ,PRIMARY KEY(AFOAPK,AFOAPP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS504APP ( APPAPK VARCHAR(12) BINARY ,APPAPP VARCHAR(5) BINARY ,APPVAF VARCHAR(5) BINARY ,APPNAF VARCHAR(5) BINARY ,APPBZ1 VARCHAR(30) BINARY ,APPBZ2 VARCHAR(30) BINARY ,APPTXT VARCHAR(30) BINARY ,APPSTS DECIMAL(5,0) DEFAULT 0,APPSIS DECIMAL(5,0) DEFAULT 0,APPBDI DATETIME ,APPBDS DATETIME ,APPSBD DATETIME ,APPEDI DATETIME ,APPEDS DATETIME ,APPSED DATETIME ,APPRAD DATETIME ,APPRED DATETIME ,APPAGS DECIMAL(5,0) DEFAULT 0,APPABS DECIMAL(5,0) DEFAULT 1,APPAES DECIMAL(5,0) DEFAULT 0,APPSME DECIMAL(11,3) DEFAULT 0,APPIME DECIMAL(11,3) DEFAULT 0,APPAME DECIMAL(11,3) DEFAULT 0,APPMEE VARCHAR(3) BINARY ,APPSZA DECIMAL(11,2) DEFAULT 0,APPSTR DECIMAL(11,2) DEFAULT 0,APPSTE DECIMAL(11,2) DEFAULT 0,APPITA DECIMAL(11,2) DEFAULT 0,APPITR DECIMAL(11,2) DEFAULT 0,APPITE DECIMAL(11,2) DEFAULT 0,APPAPG VARCHAR(10) BINARY ,APPAPL VARCHAR(10) BINARY ,APPKT1 VARCHAR(15) BINARY ,APPKZ1 VARCHAR(3) BINARY ,APPKT2 VARCHAR(15) BINARY ,APPKZ2 VARCHAR(3) BINARY ,APPKT3 VARCHAR(15) BINARY ,APPKZ3 VARCHAR(3) BINARY ,APPKT4 VARCHAR(15) BINARY ,APPKZ4 VARCHAR(3) BINARY ,APPFBE VARCHAR(10) BINARY DEFAULT 'BDE',APPKST VARCHAR(10) BINARY ,APPZF1 VARCHAR(30) BINARY ,APPZF2 VARCHAR(30) BINARY ,APPZF3 VARCHAR(30) BINARY ,APPKNZ VARCHAR(1) BINARY ,APPSSN DECIMAL(5,0) DEFAULT 0,APPDNA VARCHAR(3) BINARY ,APPDWN VARCHAR(8) BINARY ,APPSTA DECIMAL(5,0) DEFAULT 1,APPDAT DATETIME ,APPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(APPAPK,APPAPP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS510PRV ( PRVPNR VARCHAR(8) BINARY ,PRVGVO DATETIME ,PRVGBI DATETIME ,PRVBER DECIMAL(5,0) ,PRVKST VARCHAR(10) BINARY ,PRVFBE VARCHAR(10) BINARY ,PRVMMB DECIMAL(5,0) ,PRVZF1 VARCHAR(30) BINARY ,PRVZF2 VARCHAR(30) BINARY ,PRVZF3 VARCHAR(30) BINARY ,PRVDNA VARCHAR(3) BINARY ,PRVDWN VARCHAR(8) BINARY ,PRVAWA DECIMAL(5,0) DEFAULT 2,PRVAWN VARCHAR(13) BINARY ,PRVANW DECIMAL(5,0) ,PRVAVN DATETIME ,PRVABI DATETIME ,PRVAPL DECIMAL(5,0) ,PRVAPP DECIMAL(5,0) ,PRVPZM DECIMAL(5,0) ,PRVSTA DECIMAL(5,0) ,PRVNAM VARCHAR(50) BINARY ,PRVSTR VARCHAR(50) BINARY ,PRVORT VARCHAR(50) BINARY ,PRVDAT DATETIME ,PRVERF VARCHAR(50) BINARY DEFAULT 'TimeSys' ,PRIMARY KEY(PRVPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS520ASG ( ASGASG VARCHAR(5) BINARY ,ASGFBE VARCHAR(10) BINARY ,ASGBEZ VARCHAR(30) BINARY ,ASGTXT VARCHAR(10) BINARY ,ASGAST DECIMAL(5,0) DEFAULT 0,ASGASF DECIMAL(11,3) DEFAULT 0,ASGMEE VARCHAR(3) BINARY ,ASGST1 VARCHAR(20) BINARY ,ASGST2 VARCHAR(20) BINARY ,ASGST3 VARCHAR(20) BINARY ,ASGSF1 DECIMAL(11,0) DEFAULT 0,ASGSF2 DECIMAL(11,0) DEFAULT 0,ASGSF3 DECIMAL(11,0) DEFAULT 0,ASGDNA VARCHAR(3) BINARY ,ASGDWN VARCHAR(8) BINARY ,ASGSTA DECIMAL(5,0) DEFAULT 0,ASGDAT DATETIME ,ASGERF VARCHAR(50) BINARY DEFAULT 'Timesys',ASGZF1 VARCHAR(30) BINARY ,ASGZF2 VARCHAR(30) BINARY ,ASGZF3 VARCHAR(30) BINARY  ,PRIMARY KEY(ASGASG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS521UBG ( UBGUBG VARCHAR(5) BINARY ,UBGKNZ DECIMAL(5,0) ,UBGFBE VARCHAR(10) BINARY ,UBGBEZ VARCHAR(30) BINARY ,UBGTXT VARCHAR(10) BINARY ,UBGZF1 VARCHAR(30) BINARY ,UBGZF2 VARCHAR(30) BINARY ,UBGZF3 VARCHAR(30) BINARY ,UBGAST DECIMAL(5,0) DEFAULT 0,UBGRST DECIMAL(11,0) DEFAULT 0,UBGASF DECIMAL(11,0) DEFAULT 0,UBGST1 VARCHAR(20) BINARY ,UBGST2 VARCHAR(20) BINARY ,UBGST3 VARCHAR(20) BINARY ,UBGSF1 DECIMAL(11,0) DEFAULT 0,UBGSF2 DECIMAL(11,0) DEFAULT 0,UBGSF3 DECIMAL(11,0) DEFAULT 0,UBGDNA VARCHAR(3) BINARY ,UBGDWN VARCHAR(8) BINARY ,UBGSTA DECIMAL(5,0) DEFAULT 0,UBGDAT DATETIME ,UBGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(UBGUBG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS530APG ( APGAPG VARCHAR(10) BINARY ,APGBEZ VARCHAR(30) BINARY ,APGTXT VARCHAR(10) BINARY ,APGFBE VARCHAR(10) BINARY ,APGKST VARCHAR(10) BINARY ,APGZF1 VARCHAR(30) BINARY ,APGZF2 VARCHAR(30) BINARY ,APGZF3 VARCHAR(30) BINARY ,APGAPL DECIMAL(5,0) DEFAULT 0,APGTAG DECIMAL(5,0) DEFAULT 0,APGKAP DECIMAL(11,2) DEFAULT 0,APGPRD DECIMAL(11,2) DEFAULT 0,APGPAU DECIMAL(11,2) DEFAULT 0,APGRST DECIMAL(11,2) DEFAULT 0,APGUNT DECIMAL(11,2) DEFAULT 0,APGIAK DECIMAL(11,2) DEFAULT 0,APGST1 VARCHAR(10) BINARY ,APGST2 VARCHAR(10) BINARY ,APGST3 VARCHAR(10) BINARY ,APGSF1 DECIMAL(11,2) DEFAULT 0,APGSF2 DECIMAL(11,2) DEFAULT 0,APGSF3 DECIMAL(11,2) DEFAULT 0,APGDNA VARCHAR(3) BINARY ,APGDWN VARCHAR(8) BINARY ,APGSTA DECIMAL(5,0) DEFAULT 0,APGDAT DATETIME ,APGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(APGAPG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS531APL ( APLAPL VARCHAR(10) BINARY ,APLBEZ VARCHAR(30) BINARY ,APLTXT VARCHAR(10) BINARY ,APLAPG VARCHAR(10) BINARY ,APLFBE VARCHAR(10) BINARY DEFAULT 'BDE',APLSTS DECIMAL(5,0) DEFAULT 0,APLSIS DECIMAL(5,0) DEFAULT 0,APLAPR DECIMAL(5,0) DEFAULT 0,APLAAF DECIMAL(5,0) DEFAULT 0,APLUBG VARCHAR(5) BINARY ,APLUDT DATETIME ,APLZF1 VARCHAR(30) BINARY ,APLZF2 VARCHAR(30) BINARY ,APLZF3 VARCHAR(30) BINARY ,APLTAG DECIMAL(5,0) DEFAULT 0,APLVRF DECIMAL(11,2) DEFAULT 0,APLRSP DECIMAL(11,2) DEFAULT 0,APLRSI DECIMAL(11,2) DEFAULT 0,APLAFP DECIMAL(11,2) DEFAULT 0,APLAFI DECIMAL(11,2) DEFAULT 0,APLPAU DECIMAL(11,2) DEFAULT 0,APLUNT DECIMAL(11,2) DEFAULT 0,APLIAK DECIMAL(11,2) DEFAULT 0,APLAVT DECIMAL(5,0) DEFAULT 0,APLKAP DECIMAL(11,2) DEFAULT 0,APLAVR DECIMAL(11,2) DEFAULT 0,APLAVP DECIMAL(11,2) DEFAULT 0,APLST1 VARCHAR(10) BINARY DEFAULT NULL,APLST2 VARCHAR(10) BINARY DEFAULT NULL,APLST3 VARCHAR(10) BINARY DEFAULT NULL,APLSF1 DECIMAL(11,2) DEFAULT 0,APLSF2 DECIMAL(11,2) DEFAULT 0,APLSF3 DECIMAL(11,2) DEFAULT 0,APLDNA VARCHAR(3) BINARY ,APLDWN VARCHAR(8) BINARY ,APLSTA DECIMAL(5,0) DEFAULT 0,APLDAT DATETIME ,APLERF VARCHAR(50) BINARY DEFAULT 'Timesys',APLAFZ DECIMAL(5,0)  ,PRIMARY KEY(APLAPL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS532AEM ( AEMKNG DECIMAL(5,0) ,AEMAPG VARCHAR(10) BINARY ,AEMEMO VARCHAR(10) BINARY ,AEMGVO DATETIME ,AEMBEZ VARCHAR(30) BINARY ,AEMTXT VARCHAR(10) BINARY ,AEMGBI DATETIME ,AEMKAL VARCHAR(5) BINARY ,AEMLKZ DECIMAL(5,0) ,AEMVZT DECIMAL(5,0) ,AEMEZT DECIMAL(5,0) ,AEMPRZ DECIMAL(5,0) ,AEMAFZ DECIMAL(5,0) ,AEMAPZ DECIMAL(5,0) ,AEMPRP DECIMAL(5,0) ,AEMAFP DECIMAL(5,0) ,AEMAPP DECIMAL(5,0) ,AEMMAZ DECIMAL(5,0) ,AEMDNA VARCHAR(3) BINARY ,AEMDWN VARCHAR(8) BINARY ,AEMSTA DECIMAL(5,0) DEFAULT 1,AEMDAT DATETIME ,AEMERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(AEMKNG,AEMAPG,AEMEMO,AEMGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS533EMO ( EMOEMO VARCHAR(10) BINARY ,EMOTTP VARCHAR(3) BINARY ,EMOBEG DECIMAL(5,0) ,EMOEND DECIMAL(5,0) ,EMOBEZ VARCHAR(30) BINARY ,EMOTXT VARCHAR(10) BINARY ,EMOPMO VARCHAR(5) BINARY ,EMOZF1 VARCHAR(30) BINARY ,EMOZF2 VARCHAR(30) BINARY ,EMOZF3 VARCHAR(30) BINARY ,EMODNA VARCHAR(3) BINARY ,EMODWN VARCHAR(8) BINARY ,EMOSTA DECIMAL(5,0) ,EMODAT DATETIME ,EMOERF VARCHAR(50) BINARY DEFAULT 'Timesys',EMOLFN DECIMAL(5,0) ,EMOART DECIMAL(1,0) DEFAULT 1 ,PRIMARY KEY(EMOEMO,EMOTTP,EMOBEG) ,CONSTRAINT TMS533EMO_UK UNIQUE(EMOLFN) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS534PMO ( PMOPMO VARCHAR(5) BINARY ,PMOBEZ VARCHAR(30) BINARY ,PMOTXT VARCHAR(10) BINARY ,PMOBUC DECIMAL(5,0) ,PMOZF1 VARCHAR(30) BINARY ,PMOZF2 VARCHAR(30) BINARY ,PMOZF3 VARCHAR(30) BINARY ,PMODNA VARCHAR(3) BINARY ,PMODWN VARCHAR(8) BINARY ,PMOSTA DECIMAL(5,0) DEFAULT 1,PMODAT DATETIME ,PMOERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PMOPMO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS535PMS ( PMSNUM VARCHAR(5) BINARY ,PMSBEZ VARCHAR(30) BINARY ,PMSTXT VARCHAR(10) BINARY ,PMSBEG DECIMAL(5,0) DEFAULT 0,PMSEND DECIMAL(5,0) DEFAULT 0,PMSINT DECIMAL(5,0) DEFAULT 0,PMSPSE DECIMAL(5,0) DEFAULT 0,PMSBZT DECIMAL(5,0) ,PMSPRZ DECIMAL(5,0) DEFAULT 100,PMSDNA VARCHAR(3) BINARY ,PMSDWN VARCHAR(8) BINARY ,PMSZF1 VARCHAR(30) BINARY ,PMSZF2 VARCHAR(30) BINARY ,PMSZF3 VARCHAR(30) BINARY ,PMSSTA DECIMAL(5,0) DEFAULT 1,PMSDAT DATETIME ,PMSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PMSNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS536PMZ ( PMZPMO VARCHAR(5) BINARY ,PMZPMS VARCHAR(5) BINARY ,PMZGVO DATETIME ,PMZGBI DATETIME ,PMZDNA VARCHAR(3) BINARY ,PMZDWN VARCHAR(8) BINARY ,PMZSTA DECIMAL(5,0) DEFAULT 1,PMZDAT DATETIME ,PMZERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PMZPMO,PMZPMS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS537KSG ( KSGAPG VARCHAR(10) BINARY ,KSGGVO DATETIME ,KSGGBI DATETIME ,KSGKST VARCHAR(30) BINARY ,KSGFBE VARCHAR(10) BINARY ,KSGZF1 VARCHAR(30) BINARY ,KSGZF2 VARCHAR(30) BINARY ,KSGZF3 VARCHAR(30) BINARY ,KSGSTA DECIMAL(5,0) ,KSGDAT DATETIME ,KSGERF VARCHAR(50) BINARY DEFAULT 'TimeSys' ,PRIMARY KEY(KSGAPG,KSGGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS538LMO ( LMOLMO VARCHAR(10) BINARY ,LMOBEZ VARCHAR(30) BINARY ,LMOTXT VARCHAR(10) BINARY ,LMOSTA DECIMAL(5,0) ,LMODAT DATETIME ,LMOERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(LMOLMO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS540DNL ( DNLDTA DATETIME ,DNLLFN DECIMAL(5,0) ,DNLVKZ VARCHAR(3) BINARY ,DNLBER VARCHAR(5) BINARY DEFAULT 'BDE',DNLFUN VARCHAR(3) BINARY ,DNLSKZ VARCHAR(3) BINARY ,DNLPNR VARCHAR(8) BINARY ,DNLAPK VARCHAR(12) BINARY ,DNLAPP VARCHAR(5) BINARY ,DNLAPL VARCHAR(10) BINARY ,DNLDNL VARCHAR(256) BINARY ,DNLDAT DATETIME ,DNLERF VARCHAR(50) BINARY  ,PRIMARY KEY(DNLDTA,DNLLFN,DNLSKZ,DNLERF)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS542DWN ( DWNDTA DATETIME ,DWNAPK DECIMAL(5,0) DEFAULT 0,DWNAPP DECIMAL(5,0) DEFAULT 0,DWNAUK DECIMAL(5,0) DEFAULT 0,DWNAFO DECIMAL(5,0) DEFAULT 0,DWNNEU DECIMAL(5,0) DEFAULT 0,DWNAEN DECIMAL(5,0) DEFAULT 0,DWNLOE DECIMAL(5,0) DEFAULT 0,DWNZF1 VARCHAR(30) BINARY ,DWNZF2 VARCHAR(30) BINARY ,DWNZF3 VARCHAR(30) BINARY ,DWNDAT DATETIME ,DWNERF VARCHAR(50) BINARY  ,PRIMARY KEY(DWNDTA,DWNERF)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS543UPD ( UPDKEY VARCHAR(3) BINARY DEFAULT 'UPD',UPDAPK VARCHAR(10) BINARY DEFAULT 'Tms501Apk',UPD501 VARCHAR(30) BINARY ,UPDAKV VARCHAR(12) BINARY ,UPDAKB VARCHAR(12) BINARY ,UPDAKD DATETIME ,UPDAPP VARCHAR(10) BINARY DEFAULT 'Tms504App',UPD504 VARCHAR(30) BINARY ,UPDAAV VARCHAR(12) BINARY ,UPDAAB VARCHAR(12) BINARY ,UPDAPV VARCHAR(5) BINARY ,UPDAPB VARCHAR(5) BINARY ,UPDAPD DATETIME ,UPDAPL VARCHAR(10) BINARY DEFAULT 'Tms531Apl',UPD531 VARCHAR(30) BINARY ,UPDALV VARCHAR(10) BINARY ,UPDALB VARCHAR(10) BINARY ,UPDALD DATETIME ,UPDAPG VARCHAR(10) BINARY DEFAULT 'Tms530Apg',UPD530 VARCHAR(30) BINARY ,UPDAGV VARCHAR(10) BINARY ,UPDAGB VARCHAR(10) BINARY ,UPDAGD DATETIME ,UPDUBG VARCHAR(10) BINARY DEFAULT 'Tms520Ubg',UPD520 VARCHAR(30) BINARY ,UPDUGV VARCHAR(5) BINARY ,UPDUGB VARCHAR(5) BINARY ,UPDUGD DATETIME ,UPDAUG VARCHAR(10) BINARY DEFAULT 'Tms521Asg',UPD521 VARCHAR(30) BINARY ,UPDAUV VARCHAR(5) BINARY ,UPDAUB VARCHAR(5) BINARY ,UPDAUD DATETIME ,UPDPRV VARCHAR(10) BINARY DEFAULT 'Tms510Prv',UPD510 VARCHAR(30) BINARY ,UPDPVV VARCHAR(8) BINARY ,UPDPVB VARCHAR(8) BINARY ,UPDPRD DATETIME ,UPDKSG VARCHAR(10) BINARY DEFAULT 'Tms537Ksg',UPD537 VARCHAR(30) BINARY ,UPDKSV VARCHAR(5) BINARY ,UPDKSB VARCHAR(5) BINARY ,UPDKSD DATETIME ,UPDSTA DECIMAL(5,0) ,UPDDAT DATETIME ,UPDERF VARCHAR(50) BINARY  ,PRIMARY KEY(UPDKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS552BNR ( BNRKEY VARCHAR(5) BINARY ,BNRBNR DECIMAL(11,0) DEFAULT 0,BNREDT DATETIME ,BNRESB VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(BNRKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS553FZU ( FZUMLD VARCHAR(3) BINARY ,FZUFCD VARCHAR(3) BINARY ,FZUAEC VARCHAR(1) BINARY ,FZUBEZ VARCHAR(30) BINARY ,FZUTXT VARCHAR(10) BINARY ,FZUART DECIMAL(5,0) ,FZUOBJ DECIMAL(5,0) ,FZUUPL DECIMAL(5,0) ,FZUGEN DECIMAL(5,0) ,FZUZF1 VARCHAR(30) BINARY ,FZUZF2 VARCHAR(30) BINARY ,FZUZF3 VARCHAR(30) BINARY ,FZUSTA DECIMAL(5,0) ,FZUDAT DATETIME ,FZUERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FZUMLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS554ERR ( ERRBER VARCHAR(3) BINARY DEFAULT 'BDE',ERRFUN VARCHAR(3) BINARY ,ERREDT DATETIME ,ERRLFN DECIMAL(11,0) ,ERRPNR VARCHAR(8) BINARY ,ERRAPK VARCHAR(12) BINARY ,ERRAPP VARCHAR(5) BINARY ,ERRAPL VARCHAR(10) BINARY ,ERRIP VARCHAR(15) BINARY ,ERRPRT VARCHAR(5) BINARY ,ERRBNR DECIMAL(11,0) DEFAULT 0,ERRFNR DECIMAL(5,0) ,ERRPGM VARCHAR(10) BINARY ,ERRTAB VARCHAR(10) BINARY ,ERRSTA DECIMAL(5,0) ,ERRDAT DATETIME ,ERRERF VARCHAR(50) BINARY DEFAULT 'Timesys',ERROBJ VARCHAR(3) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS557CFG ( CFGDTA DECIMAL(5,0) ,CFGIP VARCHAR(15) BINARY ,CFGPRT VARCHAR(5) BINARY ,CFGBEZ VARCHAR(30) BINARY ,CFGTXT VARCHAR(15) BINARY ,CFGKR1 DECIMAL(5,0) DEFAULT 0,CFGVN1 VARCHAR(10) BINARY ,CFGBI1 VARCHAR(10) BINARY ,CFGBZ1 VARCHAR(30) BINARY ,CFGVN2 VARCHAR(10) BINARY ,CFGBI2 VARCHAR(10) BINARY ,CFGBZ2 VARCHAR(30) BINARY ,CFGVN3 VARCHAR(10) BINARY ,CFGBI3 VARCHAR(10) BINARY ,CFGBZ3 VARCHAR(30) BINARY ,CFGVN4 VARCHAR(10) BINARY ,CFGBI4 VARCHAR(10) BINARY ,CFGBZ4 VARCHAR(30) BINARY ,CFGVN5 VARCHAR(10) BINARY ,CFGBI5 VARCHAR(10) BINARY ,CFGBZ5 VARCHAR(30) BINARY ,CFGSTA DECIMAL(5,0) DEFAULT 0,CFGDAT DATETIME ,CFGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(CFGDTA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS558MEE ( MEEMEE VARCHAR(3) BINARY ,MEETXT VARCHAR(10) BINARY ,MEEART VARCHAR(10) BINARY ,MEEME1 VARCHAR(3) BINARY ,MEEFK1 DECIMAL(12,6) ,MEEKO1 VARCHAR(30) BINARY ,MEEME2 VARCHAR(3) BINARY ,MEEFK2 DECIMAL(12,6) ,MEEKO2 VARCHAR(30) BINARY ,MEEME3 VARCHAR(3) BINARY ,MEEFK3 DECIMAL(12,6) ,MEEKO3 VARCHAR(30) BINARY ,MEEZF1 VARCHAR(30) BINARY ,MEEZF2 VARCHAR(30) BINARY ,MEEZF3 VARCHAR(30) BINARY ,MEEDNA VARCHAR(3) BINARY ,MEEDWN VARCHAR(8) BINARY ,MEESTA DECIMAL(5,0) ,MEEDAT DATETIME ,MEEERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MEEMEE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS559FBE ( FBEFBE VARCHAR(10) BINARY ,FBEBEZ VARCHAR(30) BINARY ,FBETXT VARCHAR(10) BINARY ,FBEZF1 VARCHAR(30) BINARY ,FBEZF2 VARCHAR(30) BINARY ,FBEZF3 VARCHAR(30) BINARY ,FBESTA DECIMAL(5,0) ,FBEDAT DATETIME ,FBEERF VARCHAR(50) BINARY DEFAULT 'Timesys',FBETYP DECIMAL(1,0) DEFAULT 2 ,PRIMARY KEY(FBEFBE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS560MEL ( KEYBNR DECIMAL(11,0) DEFAULT 0,KEYLFN DECIMAL(5,0) DEFAULT 0,OBJTYP VARCHAR(3) BINARY ,KEYPNR VARCHAR(8) BINARY ,KEYAPL VARCHAR(10) BINARY ,KEYAPK VARCHAR(12) BINARY ,KEYAPP VARCHAR(5) BINARY ,STS00E VARCHAR(1) BINARY ,STS00R VARCHAR(1) BINARY ,STS00A VARCHAR(1) BINARY ,STS00U VARCHAR(1) BINARY ,STS00S VARCHAR(1) BINARY ,STS006 VARCHAR(1) BINARY ,STS007 VARCHAR(1) BINARY ,STS008 VARCHAR(1) BINARY ,STS009 VARCHAR(1) BINARY ,STS010 VARCHAR(1) BINARY ,STS011 VARCHAR(1) BINARY ,STS012 VARCHAR(1) BINARY ,STS013 VARCHAR(1) BINARY ,STS014 VARCHAR(1) BINARY ,STS015 VARCHAR(1) BINARY ,STS016 VARCHAR(1) BINARY ,KEYDAT DATETIME ,KEYUHR DATETIME ,KEYSEK VARCHAR(2) BINARY ,KEYUBG VARCHAR(4) BINARY ,KEYAUG VARCHAR(4) BINARY ,MELMSK VARCHAR(3) BINARY ,MELFCD VARCHAR(3) BINARY ,MELAWN VARCHAR(8) BINARY ,MELTRM VARCHAR(2) BINARY ,MELOFF VARCHAR(1) BINARY ,MELFNR DECIMAL(5,0) ,MELGUM DECIMAL(11,3) DEFAULT 0,MELFAM DECIMAL(11,3) DEFAULT 0,MELNAM DECIMAL(11,3) DEFAULT 0,MELMAM DECIMAL(11,3) DEFAULT 0,MELMEE VARCHAR(3) BINARY ,MELZT1 DECIMAL(11,3) DEFAULT 0,MELZT2 DECIMAL(11,3) DEFAULT 0,MELZT3 DECIMAL(11,3) DEFAULT 0,MELAEC VARCHAR(1) BINARY ,MELTRC VARCHAR(1) BINARY ,MELKSB VARCHAR(8) BINARY ,MELKDT DATETIME ,MELKFC VARCHAR(3) BINARY ,MELDAT DATETIME ,MELERF VARCHAR(50) BINARY DEFAULT 'Timesys',MELKGM DECIMAL(11,3) DEFAULT 0,MELKFM DECIMAL(11,3) DEFAULT 0,MELKMM DECIMAL(11,3) DEFAULT 0,MELKNM DECIMAL(11,3) DEFAULT 0,KEYTNR VARCHAR(20) BINARY  ,PRIMARY KEY(KEYBNR,KEYLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS561MLT ( MLTERF VARCHAR(8) BINARY ,MLTDAT VARCHAR(14) BINARY ,MLTLFN DECIMAL(5,0) ,MLTOBJ VARCHAR(3) BINARY ,MLTPNR VARCHAR(8) BINARY ,MLTAPL VARCHAR(10) BINARY ,MLTAPK VARCHAR(12) BINARY ,MLTAPP VARCHAR(5) BINARY ,MLT00E VARCHAR(1) BINARY ,MLT00R VARCHAR(1) BINARY ,MLT00A VARCHAR(1) BINARY ,MLT00U VARCHAR(1) BINARY ,MLT00S VARCHAR(1) BINARY ,MLTBKG VARCHAR(1) BINARY ,MLTPBE VARCHAR(1) BINARY ,MLTARG VARCHAR(10) BINARY ,MLTEMO VARCHAR(10) BINARY ,MLTWTG DECIMAL(5,0) DEFAULT 0,MLTJTG DECIMAL(5,0) DEFAULT 0,MLTTTP VARCHAR(3) BINARY ,MLTJWO VARCHAR(4) BINARY ,MLTWOC DECIMAL(5,0) DEFAULT 0,MLTMDT DATETIME ,MLTUBG VARCHAR(4) BINARY ,MLTTNR VARCHAR(20) BINARY  ,PRIMARY KEY(MLTERF,MLTDAT,MLTLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS562MLD ( MLDPNR VARCHAR(8) BINARY ,MLDMLD DATETIME ,MLDLFN DECIMAL(5,0) DEFAULT 0,MLDOBJ DECIMAL(5,0) ,MLDART VARCHAR(3) BINARY ,MLDARG VARCHAR(10) BINARY ,MLDDAT DATETIME ,MLDERF VARCHAR(8) BINARY ,MLDATG DATETIME ,MLDPBG DATETIME ,MLDPEN DATETIME  ,PRIMARY KEY(MLDPNR,MLDMLD,MLDLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS563MRK ( MRKKNG VARCHAR(3) BINARY ,MRKAPL VARCHAR(10) BINARY ,MRKAPK VARCHAR(12) BINARY ,MRKAPP VARCHAR(5) BINARY ,MRKPNR VARCHAR(8) BINARY ,MRKMDT DATETIME ,MRKDAT DATETIME ,MRKESB VARCHAR(10) BINARY ,MRKOBJ VARCHAR(3) BINARY ,MRKBNR DECIMAL(11,0) DEFAULT 0 ,PRIMARY KEY(MRKKNG,MRKAPL,MRKAPK,MRKAPP,MRKPNR,MRKBNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS565MAP ( MAPBNR DECIMAL(11,0) DEFAULT 0,MAPOBJ VARCHAR(3) BINARY ,MAPPNR VARCHAR(8) BINARY ,MAPAPL VARCHAR(10) BINARY ,MAPAPK VARCHAR(12) BINARY ,MAPAPP VARCHAR(5) BINARY ,MAP00E VARCHAR(1) BINARY ,MAP00R VARCHAR(1) BINARY ,MAP00A VARCHAR(1) BINARY ,MAP00U VARCHAR(1) BINARY ,MAP00S VARCHAR(1) BINARY ,MAP006 VARCHAR(1) BINARY ,MAP007 VARCHAR(1) BINARY ,MAP008 VARCHAR(1) BINARY ,MAP009 VARCHAR(1) BINARY ,MAP010 VARCHAR(1) BINARY ,MAP011 VARCHAR(1) BINARY ,MAP012 VARCHAR(1) BINARY ,MAP013 VARCHAR(1) BINARY ,MAP014 VARCHAR(1) BINARY ,MAP015 VARCHAR(1) BINARY ,MAP016 VARCHAR(1) BINARY ,MAPMDT DATETIME ,MAPMZT DATETIME ,MAPDAT DATETIME ,MAPERF VARCHAR(8) BINARY DEFAULT 'Timesys',MAPSTS VARCHAR(1) BINARY ,MAPUBG VARCHAR(5) BINARY ,MAPTNR VARCHAR(20) BINARY  ,PRIMARY KEY(MAPOBJ,MAPPNR,MAPAPL,MAPAPK,MAPAPP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS570RCV ( RCVMDT DATETIME ,RCVMZT DATETIME ,RCVLFN DECIMAL(5,0) ,RCVDTA VARCHAR(512) BINARY ,RCVESB VARCHAR(8) BINARY DEFAULT 'RcvUpl' ,PRIMARY KEY(RCVMDT,RCVMZT,RCVLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS571RVS ( RVSMDT DATETIME ,RVSMZT DATETIME ,RVSLFN DECIMAL(5,0) ,RVSVKZ VARCHAR(3) BINARY ,RVSVDT DATETIME ,RVSDTA VARCHAR(512) BINARY ,RVSESB VARCHAR(8) BINARY DEFAULT 'RcvUpl' ,PRIMARY KEY(RVSMDT,RVSMZT,RVSLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS580PPS ( PPSDAT CHAR(14) DEFAULT ' ',PPSLFN DECIMAL(11,0) ,PPSVKZ CHAR(3) ,PPSFCD CHAR(3) ,PPSPNR CHAR(8) ,PPSAPL CHAR(10) ,PPSAPK CHAR(12) ,PPSAPP CHAR(5) ,PPSAWN CHAR(8) ,PPSMDT CHAR(8) ,PPSMZT CHAR(6) ,PPSUBG CHAR(4) ,PPSAUG CHAR(4) ,PPSSTS DECIMAL(5,0) DEFAULT 0,PPSSTO CHAR(1) ,PPSGUM DECIMAL(11,3) DEFAULT 0,PPSFAM DECIMAL(11,3) DEFAULT 0,PPSNAM DECIMAL(11,3) DEFAULT 0,PPSMAM DECIMAL(11,3) DEFAULT 0,PPSMEE CHAR(3) ,PPSZT1 DECIMAL(11,2) DEFAULT 0,PPSZT2 DECIMAL(11,2) DEFAULT 0,PPSZT3 DECIMAL(11,2) DEFAULT 0,PPSZF1 CHAR(10) ,PPSZF2 CHAR(20) ,PPSZF3 CHAR(30)      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS590NZA ( NZASA DECIMAL(2,0) ,NZAAPL VARCHAR(10) BINARY ,NZAAPK VARCHAR(12) BINARY ,NZAAPP VARCHAR(5) BINARY ,NZAPNR VARCHAR(10) BINARY ,NZADTM DATETIME ,NZABEG DECIMAL(5,0) ,NZABBN DECIMAL(11,0) DEFAULT 0,NZABLN DECIMAL(5,0) DEFAULT 0,NZABMK VARCHAR(3) BINARY ,NZAEDT DATETIME ,NZAEND DECIMAL(5,0) ,NZAEBN DECIMAL(11,0) DEFAULT 0,NZAELN DECIMAL(5,0) DEFAULT 0,NZAEMK VARCHAR(3) BINARY ,NZAUBG VARCHAR(4) BINARY ,NZARAU DECIMAL(1,0) ,NZAVAR DECIMAL(1,0) ,NZA00A DECIMAL(1,0) ,NZA00U DECIMAL(1,0) ,NZA00S DECIMAL(1,0) ,NZAEMO VARCHAR(10) BINARY ,NZAWTG DECIMAL(5,0) ,NZAJTG DECIMAL(5,0) ,NZATTP VARCHAR(3) BINARY ,NZAJWO VARCHAR(4) BINARY ,NZAWOC DECIMAL(5,0) ,NZAPZM DECIMAL(5,0) ,NZAMAZ DECIMAL(5,0) ,NZAGUM DECIMAL(11,3) DEFAULT 0,NZAAUM DECIMAL(11,3) DEFAULT 0,NZANZR DECIMAL(11,2) DEFAULT 0,NZABZR DECIMAL(11,2) DEFAULT 0,NZAUZR DECIMAL(11,2) DEFAULT 0,NZAPZR DECIMAL(11,2) DEFAULT 0,NZARBZ DECIMAL(11,2) DEFAULT 0,NZANZA DECIMAL(11,2) DEFAULT 0,NZABZA DECIMAL(11,2) DEFAULT 0,NZAUZA DECIMAL(11,2) DEFAULT 0,NZAPZA DECIMAL(11,2) DEFAULT 0,NZAABZ DECIMAL(11,2) DEFAULT 0,NZABZU DECIMAL(11,2) DEFAULT 0,NZANZU DECIMAL(11,2) DEFAULT 0,NZAPZU DECIMAL(11,2) DEFAULT 0,NZAUBZ DECIMAL(11,2) DEFAULT 0,NZAIST DECIMAL(11,2) DEFAULT 0,NZASOL DECIMAL(11,2) DEFAULT 0,NZAPAU DECIMAL(11,2) DEFAULT 0,NZARF1 DECIMAL(11,2) DEFAULT 0,NZARF2 DECIMAL(11,2) DEFAULT 0,NZARF3 DECIMAL(11,2) DEFAULT 0,NZAFNR DECIMAL(5,0) ,NZADAT DATETIME ,NZAERF VARCHAR(50) BINARY DEFAULT 'Timesys',NZATNR VARCHAR(20) BINARY  ,PRIMARY KEY(NZASA,NZAAPL,NZAAPK,NZAAPP,NZAPNR,NZADTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS591NZP ( NZPAKZ DECIMAL(5,0) ,NZPGVN DATETIME ,NZPGBI DATETIME ,NZPAAK DECIMAL(5,0) ,NZPART DECIMAL(5,0) ,NZPAWT DECIMAL(5,0) ,NZPABZ VARCHAR(30) BINARY ,NZPTXT VARCHAR(10) BINARY ,NZPKJH DECIMAL(5,0) ,NZPKMN DECIMAL(5,0) ,NZPKWO DECIMAL(5,0) ,NZPKTG DECIMAL(5,0) ,NZPAAN DECIMAL(9,0) ,NZPADT DATETIME ,NZPAUS VARCHAR(8) BINARY ,NZPZF1 VARCHAR(30) BINARY ,NZPZF2 VARCHAR(30) BINARY ,NZPZF3 VARCHAR(30) BINARY ,NZPSTA DECIMAL(5,0) ,NZPDAT DATETIME ,NZPERF VARCHAR(50) BINARY DEFAULT 'Timesys',NZPVFH DECIMAL(9,0) ,NZPNFH DECIMAL(9,0) ,NZPMRK DECIMAL(1,0)  ,PRIMARY KEY(NZPAKZ,NZPGVN,NZPGBI)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS600KAR ( KARKAR VARCHAR(50) BINARY ,KARLNR DECIMAL(7,0) ,KARSTA DECIMAL(5,0) DEFAULT 1,KARDAT DATETIME ,KARERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KARKAR) ,CONSTRAINT TMS600KAR_UK UNIQUE(KARLNR) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS600KNT ( KNTNUM VARCHAR(20) BINARY ,KNTTXT VARCHAR(50) BINARY ,KNTKOM VARCHAR(70) BINARY ,KNTSTA DECIMAL(5,0) DEFAULT 1,KNTDAT DATETIME ,KNTERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',KNTNWS VARCHAR(30) BINARY ,KNTART VARCHAR(50) BINARY ,KNTMZU DECIMAL(1,0)  ,PRIMARY KEY(KNTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS600KNW ( KNWKNW VARCHAR(30) BINARY ,KNWLNR DECIMAL(7,0) ,KNWSTA DECIMAL(5,0) DEFAULT 1,KNWDAT DATETIME ,KNWERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KNWKNW) ,CONSTRAINT TMS600KNW_UK UNIQUE(KNWLNR) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS601KBZ ( KBZNUM VARCHAR(20) BINARY ,KBZTXT VARCHAR(50) BINARY ,KBZSTA DECIMAL(5,0) DEFAULT 1,KBZDAT DATETIME ,KBZERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KBZNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS601KGR ( KGRNUM VARCHAR(20) BINARY ,KGRKNT VARCHAR(20) BINARY ,KGRSTA DECIMAL(5,0) DEFAULT 1,KGRDAT DATETIME ,KGRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KGRNUM,KGRKNT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS604ARP ( ARPNUM VARCHAR(15) BINARY ,ARPTXT VARCHAR(50) BINARY ,ARPSTA DECIMAL(5,0) DEFAULT 1,ARPDAT DATETIME ,ARPERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',ARPVWS VARCHAR(15) BINARY ,ARPDOT VARCHAR(20) BINARY ,ARPWRS VARCHAR(5) BINARY ,ARPBSR TEXT ,ARPSDT VARCHAR(20) BINARY  ,PRIMARY KEY(ARPNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS604AUS ( AUSARP VARCHAR(15) BINARY ,AUSNUM VARCHAR(15) BINARY ,AUSTXT VARCHAR(30) BINARY ,AUSSTA DECIMAL(5,0) DEFAULT 1,AUSDAT DATETIME ,AUSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(AUSARP,AUSNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS604KAP ( KAPARP VARCHAR(15) BINARY ,KAPKGR VARCHAR(20) BINARY ,KAPANJ DECIMAL(2,0) ,KAPMIN DECIMAL(3,0) ,KAPSOL DECIMAL(3,0) ,KAPGEW DECIMAL(3,0) ,KAPSTA DECIMAL(5,0) DEFAULT 1,KAPDAT DATETIME ,KAPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KAPARP,KAPKGR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS606PRD ( PRDPNR VARCHAR(8) BINARY ,PRDSTR VARCHAR(50) BINARY ,PRDPLZ VARCHAR(10) BINARY ,PRDORT VARCHAR(50) BINARY ,PRDTEL VARCHAR(30) BINARY ,PRDFAX VARCHAR(30) BINARY ,PRDFST VARCHAR(30) BINARY ,PRDKNF VARCHAR(30) BINARY ,PRDSTT VARCHAR(15) BINARY ,PRDABW VARCHAR(15) BINARY ,PRDVON DATETIME ,PRDBIS DATETIME ,PRDBEH VARCHAR(10) BINARY ,PRDZU1 VARCHAR(15) BINARY ,PRDZU2 VARCHAR(15) BINARY ,PRDSTA DECIMAL(5,0) DEFAULT 1,PRDDAT DATETIME ,PRDERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PRDPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS607APM ( APMPNR VARCHAR(8) BINARY ,APMARP VARCHAR(15) BINARY ,APMVON DATETIME ,APMBIS DATETIME ,APMDOT VARCHAR(20) BINARY ,APMSTA DECIMAL(5,0) DEFAULT 1,APMDAT DATETIME ,APMERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(APMPNR,APMARP,APMVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS608KZM ( KZMPNR VARCHAR(8) BINARY ,KZMKGR VARCHAR(20) BINARY ,KZMVON DATETIME ,KZMBIS DATETIME ,KZMJAR DECIMAL(2,0) ,KZMBEW DECIMAL(3,0) ,KZMGEW DECIMAL(3,0) ,KZMKOM VARCHAR(70) BINARY ,KZMSTA DECIMAL(5,0) DEFAULT 1,KZMDAT DATETIME ,KZMERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KZMPNR,KZMKGR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS610DKM ( DKMMTR VARCHAR(8) BINARY ,DKMNUM VARCHAR(8) BINARY ,DKMTXT VARCHAR(50) BINARY ,DKMART DECIMAL(5,0) ,DKMSTA DECIMAL(5,0) DEFAULT 1,DKMDAT DATETIME ,DKMERF VARCHAR(50) BINARY DEFAULT 'Timesys',DKMDOK VARCHAR(100) BINARY  ,PRIMARY KEY(DKMMTR,DKMNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS611ABW ( ABWNUM VARCHAR(15) BINARY ,ABWTXT VARCHAR(50) BINARY ,ABWSTA DECIMAL(5,0) DEFAULT 1,ABWDAT DATETIME ,ABWERF VARCHAR(50) BINARY DEFAULT 'Timesys',ABWTST DECIMAL(1,0) DEFAULT 2 ,PRIMARY KEY(ABWNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS611MAB ( MABABW VARCHAR(15) BINARY ,MABPNR VARCHAR(8) BINARY ,MABVON DATETIME ,MABBIS DATETIME ,MABSTA DECIMAL(5,0) DEFAULT 1,MABDAT DATETIME ,MABERF VARCHAR(50) BINARY DEFAULT 'Timesys',MABTST DECIMAL(1,0)  ,PRIMARY KEY(MABABW,MABPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS612MNA ( MNANAT VARCHAR(15) BINARY ,MNAPNR VARCHAR(8) BINARY ,MNAUVO DATETIME ,MNAUBI DATETIME ,MNARVO DATETIME ,MNARBI DATETIME ,MNASTA DECIMAL(5,0) DEFAULT 1,MNADAT DATETIME ,MNAERF VARCHAR(50) BINARY DEFAULT 'Timesys',MNAPNM VARCHAR(30) BINARY ,MNAPVO DATETIME ,MNAPBI DATETIME ,MNAUBK VARCHAR(50) BINARY ,MNARBK VARCHAR(50) BINARY ,MNAPBK VARCHAR(50) BINARY  ,PRIMARY KEY(MNANAT,MNAPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS612NAT ( NATNUM VARCHAR(15) BINARY ,NATTXT VARCHAR(50) BINARY ,NATSTA DECIMAL(5,0) DEFAULT 1,NATDAT DATETIME ,NATERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(NATNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS613MZF ( MZFZFT VARCHAR(15) BINARY ,MZFPNR VARCHAR(8) BINARY ,MZFVON DATETIME ,MZFBIS DATETIME ,MZFGAM DATETIME ,MZFGBI DATETIME ,MZFFST DECIMAL(3,0) ,MZFKSH DATETIME ,MZFSTA DECIMAL(5,0) DEFAULT 1,MZFDAT DATETIME ,MZFERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MZFZFT,MZFPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS613ZFT ( ZFTNUM VARCHAR(15) BINARY ,ZFTTXT VARCHAR(50) BINARY ,ZFTSTA DECIMAL(5,0) DEFAULT 1,ZFTDAT DATETIME ,ZFTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZFTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650ARZ ( ARZART DECIMAL(5,0) ,ARZAWL DECIMAL(5,0) ,ARZBLG DECIMAL(5,0) ,ARZFIB VARCHAR(50) BINARY ,ARZLON VARCHAR(50) BINARY ,ARZTXT VARCHAR(50) BINARY ,ARZSTA DECIMAL(5,0) DEFAULT 1,ARZDAT DATETIME ,ARZERF VARCHAR(50) BINARY DEFAULT 'Timesys',ARZMWS DECIMAL(4,2)  ,PRIMARY KEY(ARZART)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650CFG ( CFGNUM DECIMAL(5,0) ,CFGWRG DECIMAL(5,0) ,CFGUKS DECIMAL(5,0) ,CFGPRT DECIMAL(5,0) ,CFGSTA DECIMAL(5,0) ,CFGDAT DATETIME ,CFGERF VARCHAR(50) BINARY  ,PRIMARY KEY(CFGNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650FAV ( FAVANM VARCHAR(50) BINARY ,FAVLND VARCHAR(10) BINARY ,FAVNUM DECIMAL(3,0) ,FAVSTA DECIMAL(5,0) DEFAULT 1,FAVDAT DATETIME ,FAVERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FAVANM,FAVLND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650KMG ( KMGNUM VARCHAR(10) BINARY ,KMGVON DATETIME ,KMGKGP DECIMAL(5,2) ,KMGSTA DECIMAL(5,0) DEFAULT 1,KMGDAT DATETIME ,KMGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KMGNUM,KMGVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650MWS ( MWSNUM VARCHAR(5) BINARY ,MWSTXT VARCHAR(50) BINARY ,MWSPRS DECIMAL(4,2) ,MWSSTA DECIMAL(5,0) DEFAULT 1,MWSDAT DATETIME ,MWSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MWSNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650RKA ( RKANUM DECIMAL(5,0) ,RKAPNR VARCHAR(8) BINARY ,RKAJHR DECIMAL(5,0) ,RKAMON DECIMAL(5,0) ,RKABNK VARCHAR(50) BINARY ,RKABLZ VARCHAR(15) BINARY ,RKAKTO VARCHAR(20) BINARY ,RKAFZG VARCHAR(20) BINARY ,RKAKMS DECIMAL(7,0) ,RKAKOM VARCHAR(1000) BINARY ,RKASTS DECIMAL(2,0) ,RKAGER VARCHAR(50) BINARY ,RKAGVO DATETIME ,RKAFER VARCHAR(50) BINARY ,RKAFVO DATETIME ,RKASUM DECIMAL(8,2) ,RKASTA DECIMAL(5,0) DEFAULT 1,RKADAT DATETIME ,RKAERF VARCHAR(50) BINARY DEFAULT 'Timesys',RKAFRG DECIMAL(2,0) ,RKASPN DECIMAL(8,2) ,RKAHOT DECIMAL(8,2) ,RKABBT DECIMAL(8,2) ,RKAKFZ DECIMAL(8,2) ,RKATEL DECIMAL(8,2) ,RKASON DECIMAL(8,2) ,RKAGKM DECIMAL(8,2) ,RKASND DECIMAL(2,0) ,RKAVON DATETIME ,RKABIS DATETIME ,RKAUHR DATETIME ,RKAGPN VARCHAR(8) BINARY ,RKAKST VARCHAR(30) BINARY ,RKAABT VARCHAR(15) BINARY ,RKAASZ DECIMAL(8,2) ,RKAVRS DECIMAL(8,2) ,RKAVRE DECIMAL(8,2) ,RKAVRV DECIMAL(8,2) ,RKAVRB DECIMAL(8,2) ,RKANAE VARCHAR(50) BINARY ,RKANAV VARCHAR(50) BINARY ,RKANAB VARCHAR(50) BINARY ,RKAKOT VARCHAR(1000) BINARY ,RKAAST DECIMAL(8,2) ,RKASUT DECIMAL(8,2) ,RKAVRT DECIMAL(8,2) ,RKAKOV VARCHAR(150) BINARY ,RKAKOB VARCHAR(150) BINARY ,RKANAM VARCHAR(50) BINARY ,RKAVRW VARCHAR(5) BINARY ,RKAASW VARCHAR(5) BINARY ,RKAKEY VARCHAR(14) BINARY  ,PRIMARY KEY(RKANUM,RKAPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650RKB ( RKBNUM DECIMAL(5,0) ,RKBPNR VARCHAR(8) BINARY ,RKBVON DATETIME ,RKBUHR DECIMAL(5,0) ,RKBBIS DECIMAL(5,0) ,RKBRAN VARCHAR(50) BINARY ,RKBLND VARCHAR(10) BINARY ,RKBSTD DECIMAL(5,0) ,RKBPKM DECIMAL(6,0) ,RKBSUM DECIMAL(7,2) ,RKBKOM VARCHAR(50) BINARY ,RKBSTA DECIMAL(5,0) DEFAULT 1,RKBDAT DATETIME ,RKBERF VARCHAR(50) BINARY DEFAULT 'Timesys',RKBLNM DECIMAL(2,0) DEFAULT 1,RKBART DECIMAL(5,0) ,RKBBLG DECIMAL(5,0) ,RKBNAM VARCHAR(50) BINARY ,RKBWRG VARCHAR(5) BINARY ,RKBABR DECIMAL(7,2) ,RKBUKS DECIMAL(7,5)  ,PRIMARY KEY(RKBNUM,RKBPNR,RKBVON,RKBLNM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650RKD ( RKDPNR VARCHAR(8) BINARY ,RKDVON DATETIME ,RKDUHR DECIMAL(5,0) ,RKDBIS DECIMAL(5,0) ,RKDRAN VARCHAR(50) BINARY ,RKDLND VARCHAR(10) BINARY ,RKDSTD DECIMAL(5,0) ,RKDSPN DECIMAL(6,2) ,RKDHOT DECIMAL(6,2) ,RKDBBT DECIMAL(7,2) ,RKDBNR VARCHAR(20) BINARY ,RKDPKM DECIMAL(6,0) ,RKDGKM DECIMAL(5,2) ,RKDKFZ DECIMAL(7,2) ,RKDTEL DECIMAL(7,2) ,RKDSON DECIMAL(7,2) ,RKDSUM DECIMAL(7,2) ,RKDKOM VARCHAR(50) BINARY ,RKDSTA DECIMAL(5,0) DEFAULT 1,RKDDAT DATETIME ,RKDERF VARCHAR(50) BINARY DEFAULT 'Timesys',RKDNUM DECIMAL(5,0) ,RKDLNM DECIMAL(2,0) DEFAULT 1,RKDMWS VARCHAR(5) BINARY ,RKDART DECIMAL(5,0) ,RKDBLG DECIMAL(5,0) ,RKDORI DECIMAL(7,2) ,RKDWRG VARCHAR(5) BINARY ,RKDABR DECIMAL(7,2) ,RKDUKS DECIMAL(7,5)  ,PRIMARY KEY(RKDPNR,RKDVON,RKDNUM,RKDLNM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650RKE ( RKENUM DECIMAL(5,0) ,RKEPNR VARCHAR(8) BINARY ,RKEVON DATETIME ,RKEUHR DECIMAL(5,0) ,RKEBIS DECIMAL(5,0) ,RKERAN VARCHAR(50) BINARY ,RKELND VARCHAR(10) BINARY ,RKESTD DECIMAL(5,0) ,RKEPKM DECIMAL(6,0) ,RKESUM DECIMAL(7,2) ,RKEKOM VARCHAR(50) BINARY ,RKESTA DECIMAL(5,0) DEFAULT 1,RKEDAT DATETIME ,RKEERF VARCHAR(50) BINARY DEFAULT 'Timesys',RKELNM DECIMAL(2,0) DEFAULT 1,RKEART DECIMAL(5,0) ,RKEBLG DECIMAL(5,0) ,RKENAM VARCHAR(50) BINARY ,RKEWRG VARCHAR(5) BINARY ,RKEABR DECIMAL(7,2) ,RKEUKS DECIMAL(7,5)  ,PRIMARY KEY(RKENUM,RKEPNR,RKEVON,RKELNM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS650RKV ( RKVNUM DECIMAL(5,0) ,RKVPNR VARCHAR(8) BINARY ,RKVVON DATETIME ,RKVUHR DECIMAL(5,0) ,RKVBIS DECIMAL(5,0) ,RKVRAN VARCHAR(50) BINARY ,RKVLND VARCHAR(10) BINARY ,RKVSTD DECIMAL(5,0) ,RKVPKM DECIMAL(6,0) ,RKVSUM DECIMAL(7,2) ,RKVKOM VARCHAR(50) BINARY ,RKVSTA DECIMAL(5,0) DEFAULT 1,RKVDAT DATETIME ,RKVERF VARCHAR(50) BINARY DEFAULT 'Timesys',RKVLNM DECIMAL(2,0) DEFAULT 1,RKVART DECIMAL(5,0) ,RKVBLG DECIMAL(5,0) ,RKVNAM VARCHAR(50) BINARY ,RKVWRG VARCHAR(5) BINARY ,RKVABR DECIMAL(7,2) ,RKVUKS DECIMAL(7,5)  ,PRIMARY KEY(RKVNUM,RKVPNR,RKVVON,RKVLNM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS651LND ( LNDNUM VARCHAR(10) BINARY ,LNDTXT VARCHAR(30) BINARY ,LNDSTA DECIMAL(5,0) DEFAULT 1,LNDDAT DATETIME ,LNDERF VARCHAR(50) BINARY DEFAULT 'Timesys',LNDSTD DECIMAL(2,0)  ,PRIMARY KEY(LNDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS652TEL ( TELPNR VARCHAR(8) BINARY ,TELVON DATETIME ,TELGRG DECIMAL(5,2) ,TELVKN DECIMAL(7,2) ,TELGSN DECIMAL(7,2) ,TELSTR DECIMAL(6,2) ,TELGSB DECIMAL(7,2) ,TELKPG DECIMAL(7,2) ,TELKDG DECIMAL(7,2) ,TELPAP DECIMAL(5,2) ,TELPAD DECIMAL(5,2) ,TELAGB DECIMAL(5,2) ,TELAGS DECIMAL(7,2) ,TELAST DECIMAL(6,2) ,TELSUM DECIMAL(7,2) ,TELSTA DECIMAL(5,0) DEFAULT 1,TELDAT DATETIME ,TELERF VARCHAR(50) BINARY DEFAULT 'Timesys',TELRKA DECIMAL(5,0) ,TELTLN VARCHAR(30) BINARY ,TELBRU DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(TELPNR,TELRKA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS653VPS ( VPSLND VARCHAR(10) BINARY ,VPSVON DATETIME ,VPSSP1 DECIMAL(6,2) ,VPSSP2 DECIMAL(6,2) ,VPSSP3 DECIMAL(6,2) ,VPSSTA DECIMAL(5,0) DEFAULT 1,VPSDAT DATETIME ,VPSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(VPSLND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS654FBK ( FBKNUM VARCHAR(15) BINARY ,FBKTXT VARCHAR(50) BINARY ,FBKSTA DECIMAL(5,0) DEFAULT 1,FBKDAT DATETIME ,FBKERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FBKNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS655FRK ( FRKFBK VARCHAR(15) BINARY ,FRKRKA DECIMAL(8,2) ,FRKKST VARCHAR(30) BINARY ,FRKSTA DECIMAL(5,0) DEFAULT 1,FRKDAT DATETIME ,FRKERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FRKFBK,FRKRKA,FRKKST)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS656ZKR ( ZKRZKT VARCHAR(5) BINARY ,ZKRRKA DECIMAL(8,2) ,ZKRSTA DECIMAL(5,0) DEFAULT 1,ZKRDAT DATETIME ,ZKRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZKRZKT,ZKRRKA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS670PTP ( PTPNAM VARCHAR(20) BINARY ,PTPTXT VARCHAR(50) BINARY ,PTPPAA VARCHAR(5) BINARY ,PTPPAM VARCHAR(5) BINARY ,PTPLES DECIMAL(1,0) ,PTPFRE VARCHAR(15) BINARY ,PTPDAT TIMESTAMP,PTPSTA DECIMAL(5,0) ,PTPERF VARCHAR(50) BINARY  ,PRIMARY KEY(PTPNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS670PT1 ( PT1NAM VARCHAR(20) BINARY ,PT1SRC VARCHAR(20) BINARY ,PT1EDT DECIMAL(1,0) ,PT1DAT TIMESTAMP,PT1STA DECIMAL(5,0) ,PT1ERF VARCHAR(50) BINARY  ,PRIMARY KEY(PT1NAM,PT1SRC)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS701PLG ( PLGPLG VARCHAR(5) BINARY ,PLGTXT VARCHAR(50) BINARY ,PLGKAL VARCHAR(3) BINARY ,PLGHZT DECIMAL(3,0) DEFAULT 10,PLGSTA DECIMAL(1,0) DEFAULT 1,PLGDAT DATETIME ,PLGERF VARCHAR(50) BINARY DEFAULT 'Timesys',PLGPDT DATETIME ,PLGPLR VARCHAR(50) BINARY ,PLGPGM VARCHAR(10) BINARY ,PLGUSR VARCHAR(50) BINARY ,PLGBEG DATETIME ,PLGFTS DECIMAL(3,0) DEFAULT 0,PLGPG1 VARCHAR(3) BINARY DEFAULT '100',PLGQU1 DECIMAL(1,0) DEFAULT 0,PLGAR1 DECIMAL(1,0) DEFAULT 0,PLGRU1 DECIMAL(1,0) DEFAULT 0,PLGME1 DECIMAL(1,0) DEFAULT 0,PLGAM1 DECIMAL(1,0) DEFAULT 0,PLGRE1 DECIMAL(1,0) DEFAULT 0,PLGPG2 VARCHAR(3) BINARY DEFAULT '200',PLGQU2 DECIMAL(1,0) DEFAULT 0,PLGAR2 DECIMAL(1,0) DEFAULT 0,PLGRU2 DECIMAL(1,0) DEFAULT 0,PLGME2 DECIMAL(1,0) DEFAULT 0,PLGAM2 DECIMAL(1,0) DEFAULT 0,PLGRE2 DECIMAL(1,0) DEFAULT 0,PLGPG3 VARCHAR(3) BINARY DEFAULT '300',PLGQU3 DECIMAL(1,0) DEFAULT 0,PLGAR3 DECIMAL(1,0) DEFAULT 0,PLGRU3 DECIMAL(1,0) DEFAULT 0,PLGME3 DECIMAL(1,0) DEFAULT 0,PLGAM3 DECIMAL(1,0) DEFAULT 0,PLGRE3 DECIMAL(1,0) DEFAULT 0,PLGMPE VARCHAR(20) BINARY ,PLGMPO VARCHAR(20) BINARY ,PLGMPK VARCHAR(20) BINARY ,PLGKST DECIMAL(3,0) DEFAULT 0,PLGAFG DECIMAL(3,0) DEFAULT 0,PLGOPT DECIMAL(1,0) DEFAULT 0,PLGOPL DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(PLGPLG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS703ESA ( ESAESA VARCHAR(5) BINARY ,ESATXT VARCHAR(50) BINARY ,ESASTA DECIMAL(1,0) DEFAULT 1,ESADAT DATETIME ,ESAERF VARCHAR(50) BINARY DEFAULT 'Timesys',ESATYP DECIMAL(1,0) DEFAULT 1 ,PRIMARY KEY(ESAESA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS705ESO ( ESOESO VARCHAR(5) BINARY ,ESOPLG VARCHAR(5) BINARY ,ESOTXT VARCHAR(50) BINARY ,ESOSTA DECIMAL(1,0) DEFAULT 1,ESODAT DATETIME ,ESOERF VARCHAR(50) BINARY DEFAULT 'Timesys',ESOPDT DATETIME ,ESOPLR VARCHAR(50) BINARY  ,PRIMARY KEY(ESOESO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS707QFK ( QFKQFK VARCHAR(5) BINARY ,QFKTXT VARCHAR(50) BINARY ,QFKSTA DECIMAL(1,0) DEFAULT 1,QFKDAT DATETIME ,QFKERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(QFKQFK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS708KSS ( KSSNUM VARCHAR(5) BINARY ,KSSTXT VARCHAR(50) BINARY ,KSSSTA DECIMAL(1,0) DEFAULT 1,KSSDAT DATETIME ,KSSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KSSNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS708PSS ( PSSKSS VARCHAR(5) BINARY ,PSSGVO DATETIME ,PSSGBI DATETIME ,PSSNUM VARCHAR(5) BINARY ,PSSTXT VARCHAR(50) BINARY ,PSSLHN DECIMAL(7,2) ,PSSWRT DECIMAL(7,2) ,PSSPOZ DECIMAL(5,2) ,PSSDAZ DECIMAL(7,2) ,PSSSTA DECIMAL(1,0) DEFAULT 1,PSSDAT DATETIME ,PSSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PSSKSS,PSSGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS709IDK ( IDKNUM DECIMAL(3,0) ,IDKTXT VARCHAR(50) BINARY ,IDKSTA DECIMAL(1,0) DEFAULT 1,IDKDAT DATETIME ,IDKERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(IDKNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS710PBV ( PBVPNR VARCHAR(8) BINARY ,PBVGVO DATETIME ,PBVGBI DATETIME ,PBVESO VARCHAR(5) BINARY ,PBVESA VARCHAR(5) BINARY ,PBVTXT VARCHAR(50) BINARY ,PBVZRM DECIMAL(1,0) DEFAULT 0,PBVSTA DECIMAL(1,0) DEFAULT 1,PBVDAT DATETIME ,PBVERF VARCHAR(50) BINARY DEFAULT 'Timesys',PBVAWP DECIMAL(1,0) DEFAULT 0,PBVSST VARCHAR(10) BINARY  ,PRIMARY KEY(PBVPNR,PBVGVO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS711PEO ( PEOPNR VARCHAR(8) BINARY ,PEOESO VARCHAR(5) BINARY ,PEOVON DATETIME ,PEOBIS DATETIME ,PEOTXT VARCHAR(50) BINARY ,PEOPRI DECIMAL(3,0) DEFAULT 0,PEOSTA DECIMAL(1,0) DEFAULT 1,PEODAT DATETIME ,PEOERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PEOPNR,PEOESO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS712PGZ ( PGZPLG VARCHAR(5) BINARY ,PGZESO VARCHAR(5) BINARY ,PGZESA VARCHAR(5) BINARY ,PGZTXT VARCHAR(50) BINARY ,PGZKST VARCHAR(30) BINARY ,PGZAZK DECIMAL(3,0) DEFAULT 10,PGZRZK DECIMAL(3,0) DEFAULT 11,PGZSTA DECIMAL(1,0) DEFAULT 1,PGZDAT DATETIME ,PGZERF VARCHAR(50) BINARY DEFAULT 'Timesys',PGZPDT DATETIME ,PGZPLR VARCHAR(50) BINARY  ,PRIMARY KEY(PGZPLG,PGZESO,PGZESA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS716QZP ( QZPPNR VARCHAR(8) BINARY ,QZPQFK VARCHAR(5) BINARY ,QZPVON DATETIME ,QZPBIS DATETIME ,QZPTXT VARCHAR(50) BINARY ,QZPPRI DECIMAL(3,0) DEFAULT 0,QZPSTA DECIMAL(1,0) DEFAULT 1,QZPDAT DATETIME ,QZPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(QZPPNR,QZPQFK,QZPVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS717QEA ( QEAESA VARCHAR(5) BINARY ,QEAQFK VARCHAR(5) BINARY ,QEATXT VARCHAR(50) BINARY ,QEAZF1 VARCHAR(50) BINARY ,QEAZF2 VARCHAR(50) BINARY ,QEASTA DECIMAL(1,0) DEFAULT 1,QEADAT DATETIME ,QEAERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(QEAESA,QEAQFK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS719PGI ( PGIPLG VARCHAR(5) BINARY ,PGIPRG DECIMAL(1,0) ,PGINUM DECIMAL(3,0) ,PGITXT VARCHAR(50) BINARY ,PGIPRI DECIMAL(3,0) DEFAULT 0,PGIAKT DECIMAL(1,0) DEFAULT 0,PGISTA DECIMAL(1,0) DEFAULT 1,PGIDAT DATETIME ,PGIERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PGIPLG,PGIPRG,PGINUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS720BSS ( BSSPLG VARCHAR(5) BINARY ,BSSESO VARCHAR(5) BINARY ,BSSESA VARCHAR(5) BINARY ,BSSTTP VARCHAR(3) BINARY ,BSSVON DECIMAL(4,0) ,BSSBIS DECIMAL(4,0) ,BSSBSZ VARCHAR(3) BINARY ,BSSTXT VARCHAR(50) BINARY ,BSSSOL DECIMAL(3,0) DEFAULT 0,BSSMIN DECIMAL(3,0) DEFAULT 0,BSSMAX DECIMAL(3,0) DEFAULT 0,BSSMWT DECIMAL(3,1) DEFAULT 0.0,BSSVTG DECIMAL(5,0) DEFAULT 0,BSSATG DECIMAL(5,0) DEFAULT 0,BSSKGW DECIMAL(3,0) DEFAULT 1,BSSKMW DECIMAL(1,0) DEFAULT 0,BSSASW DECIMAL(3,0) DEFAULT 0,BSSCLR VARCHAR(20) BINARY ,BSSSTA DECIMAL(1,0) DEFAULT 1,BSSDAT DATETIME ,BSSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(BSSPLG,BSSESO,BSSESA,BSSTTP,BSSVON,BSSASW)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS723BSD ( BSDKEY VARCHAR(14) BINARY ,BSDLFD DECIMAL(7,0) ,BSDPLG VARCHAR(5) BINARY ,BSDESO VARCHAR(5) BINARY ,BSDESA VARCHAR(5) BINARY ,BSDAUF VARCHAR(30) BINARY ,BSDAFG VARCHAR(5) BINARY ,BSDVON VARCHAR(8) BINARY ,BSDBIS VARCHAR(8) BINARY ,BSDMNG DECIMAL(12,5) DEFAULT 0,BSDMEH DECIMAL(3,0) ,BSDFML VARCHAR(30) BINARY ,BSDZEH DECIMAL(3,0) ,BSDSOL DECIMAL(3,0) DEFAULT 0,BSDLOE DECIMAL(1,0) DEFAULT 0,BSDSTA DECIMAL(1,0) DEFAULT 0,BSDDAT DATETIME ,BSDERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(BSDKEY,BSDLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS723BS1 ( BS1KEY VARCHAR(14) BINARY ,BS1LFD DECIMAL(7,0) ,BS1VON VARCHAR(8) BINARY ,BS1BIS VARCHAR(8) BINARY ,BS1ST1 VARCHAR(4) BINARY ,BS1ST2 VARCHAR(4) BINARY ,BS1ST3 VARCHAR(4) BINARY ,BS1ST4 VARCHAR(4) BINARY ,BS1ST5 VARCHAR(4) BINARY ,BS1ST6 VARCHAR(4) BINARY ,BS1ST7 VARCHAR(4) BINARY ,BS1LOE DECIMAL(1,0)  ,PRIMARY KEY(BS1KEY,BS1LFD,BS1VON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS723BS2 ( BS2ART VARCHAR(1) BINARY ,BS2KEY VARCHAR(14) BINARY ,BS2LFD DECIMAL(7,0) ,BS2VON VARCHAR(8) BINARY ,BS2FEH DECIMAL(2,0) ,BS2NUM DECIMAL(11,0) DEFAULT 0,BS2WHL DECIMAL(5,0) DEFAULT 0,BS2STA DECIMAL(1,0) DEFAULT 0,BS2TXT VARCHAR(400) BINARY ,BS2DAT VARCHAR(15) BINARY ,BS2PLG VARCHAR(5) BINARY ,BS2INF VARCHAR(100) BINARY  ,PRIMARY KEY(BS2ART,BS2KEY,BS2LFD,BS2VON,BS2FEH)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS724BSA ( BSAPLG VARCHAR(5) BINARY ,BSAESO VARCHAR(5) BINARY ,BSAESA VARCHAR(5) BINARY ,BSATTP VARCHAR(3) BINARY ,BSAVON DECIMAL(4,0) ,BSAASW DECIMAL(3,0) DEFAULT 0,BSADTM DATETIME ,BSAAUF VARCHAR(30) BINARY ,BSAAFG VARCHAR(5) BINARY ,BSASOL DECIMAL(3,0) DEFAULT 0,BSAKEY VARCHAR(14) BINARY ,BSALFD DECIMAL(7,0) ,BSASTA DECIMAL(1,0) DEFAULT 1,BSADAT DATETIME ,BSAERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(BSAPLG,BSAESO,BSAESA,BSATTP,BSAVON,BSAASW,BSADTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS725BSM ( BSMBDT DATETIME ,BSMESO VARCHAR(5) BINARY ,BSMESA VARCHAR(5) BINARY ,BSMSZV DECIMAL(4,0) ,BSMSZB DECIMAL(4,0) ,BSMBSZ VARCHAR(3) BINARY ,BSMJHR DECIMAL(4,0) ,BSMMON DECIMAL(2,0) ,BSMWOC DECIMAL(2,0) ,BSMJWC DECIMAL(4,0) ,BSMTAG DECIMAL(1,0) ,BSMTTP VARCHAR(3) BINARY ,BSMSOL DECIMAL(3,0) ,BSMMIN DECIMAL(3,0) ,BSMMAX DECIMAL(3,0) ,BSMIST DECIMAL(3,0) ,BSMPLG VARCHAR(5) BINARY ,BSMHTG DECIMAL(3,0) ,BSMHTV DECIMAL(3,0) ,BSMHTN DECIMAL(3,0) ,BSMASW DECIMAL(3,0) ,BSMKNG DECIMAL(5,0) ,BSMFKT DECIMAL(5,0) ,BSMSTA DECIMAL(1,0) DEFAULT 1,BSMDAT DATETIME ,BSMERF VARCHAR(50) BINARY DEFAULT 'Timesys',BSMID1 DECIMAL(3,0) ,BSMID2 DECIMAL(3,0) ,BSMID3 DECIMAL(3,0) ,BSMID4 DECIMAL(3,0) ,BSMID5 DECIMAL(3,0) ,BSMID6 DECIMAL(3,0) ,BSMID7 DECIMAL(3,0) ,BSMID8 DECIMAL(3,0) ,BSMKOR DECIMAL(1,0) DEFAULT 0,BSMKOS DECIMAL(9,2) ,BSMKO2 DECIMAL(9,2) ,BSMOVA DECIMAL(5,0) ,BSMOVE DECIMAL(5,0)  ,PRIMARY KEY(BSMBDT,BSMESO,BSMESA,BSMSZV,BSMPLG,BSMASW)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS730AFB ( AFBKEY VARCHAR(30) BINARY DEFAULT 0,AFBDVN DATETIME ,AFBDBI DATETIME ,AFBBEG DECIMAL(4,0) ,AFBEND DECIMAL(4,0) ,AFBBES VARCHAR(500) BINARY ,AFBTYP VARCHAR(30) BINARY ,AFBTPN DECIMAL(1,0) ,AFBOVN DATETIME ,AFBOBI DATETIME ,AFBOBG DECIMAL(4,0) ,AFBOED DECIMAL(4,0) ,AFBSTA DECIMAL(1,0) DEFAULT 1,AFBDAT DATETIME ,AFBERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(AFBKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS730AFG ( AFGART VARCHAR(1) BINARY DEFAULT 'A',AFGPNR VARCHAR(8) BINARY ,AFGADT DATETIME ,AFGAZV DECIMAL(4,0) ,AFGAZB DECIMAL(4,0) ,AFGKEY VARCHAR(30) BINARY ,AFGTYP DECIMAL(1,0) ,AFGDVN DATETIME ,AFGDBI DATETIME ,AFGBEG DECIMAL(4,0) ,AFGEND DECIMAL(4,0) ,AFGJHR DECIMAL(4,0) ,AFGMON DECIMAL(2,0) ,AFGWOC DECIMAL(2,0) ,AFGESA VARCHAR(5) BINARY ,AFGESO VARCHAR(5) BINARY ,AFGPLG VARCHAR(5) BINARY ,AFGBSZ VARCHAR(3) BINARY ,AFGSZV DECIMAL(4,0) ,AFGSZB DECIMAL(4,0) ,AFGSTA DECIMAL(1,0) DEFAULT 1,AFGDAT DATETIME ,AFGERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(AFGART,AFGPNR,AFGADT,AFGAZV,AFGKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS730BDP ( BDPPNR VARCHAR(8) BINARY ,BDPBDT DATETIME ,BDPESO VARCHAR(5) BINARY ,BDPESA VARCHAR(5) BINARY ,BDPSZV DECIMAL(4,0) ,BDPSZB DECIMAL(4,0) ,BDPBSZ VARCHAR(3) BINARY ,BDPJHR DECIMAL(4,0) ,BDPMON DECIMAL(2,0) ,BDPWOC DECIMAL(2,0) ,BDPJWC DECIMAL(4,0) ,BDPTAG DECIMAL(1,0) ,BDPTTP VARCHAR(3) BINARY ,BDPZTV DECIMAL(4,0) ,BDPZTB DECIMAL(4,0) ,BDPKST VARCHAR(10) BINARY ,BDPFC1 VARCHAR(3) BINARY DEFAULT NULL,BDPFC2 VARCHAR(3) BINARY DEFAULT NULL,BDPFC3 VARCHAR(3) BINARY ,BDPOSO VARCHAR(5) BINARY ,BDPOSA VARCHAR(5) BINARY ,BDPOSV DECIMAL(4,0) ,BDPOSB DECIMAL(4,0) ,BDPOSZ VARCHAR(3) BINARY ,BDPPLG VARCHAR(5) BINARY ,BDPASW DECIMAL(3,0) ,BDPSTS VARCHAR(1) BINARY DEFAULT ' ',BDPFNR DECIMAL(5,0) DEFAULT 0,BDPSTA DECIMAL(1,0) DEFAULT 1,BDPTXT VARCHAR(60) BINARY ,BDPDAT DATETIME ,BDPERF VARCHAR(50) BINARY DEFAULT 'Timesys',BDPAZT DECIMAL(5,0) ,BDPID1 DECIMAL(3,0) ,BDPID2 DECIMAL(3,0) ,BDPID3 DECIMAL(3,0) ,BDPID4 DECIMAL(3,0) ,BDPID5 DECIMAL(3,0) ,BDPID6 DECIMAL(3,0) ,BDPID7 DECIMAL(3,0) ,BDPID8 DECIMAL(3,0) ,BDPRND DECIMAL(3,0) ,BDPAKT DECIMAL(4,0) DEFAULT 1,BDPBNR DECIMAL(3,0) DEFAULT 1,BDPAWP DECIMAL(3,0) ,BDPPAU DECIMAL(5,0) DEFAULT 0,BDPBZT DECIMAL(5,0) DEFAULT 0,BDPOSW DECIMAL(3,0) DEFAULT 0,BDPKEY VARCHAR(32) BINARY ,BDPKOS DECIMAL(9,2)  ,PRIMARY KEY(BDPPNR,BDPBDT,BDPESO,BDPESA,BDPSZV,BDPPLG,BDPASW,BDPAKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS730BDT ( BDTPNR VARCHAR(8) BINARY ,BDTBDT DATETIME ,BDTESO VARCHAR(5) BINARY ,BDTESA VARCHAR(5) BINARY ,BDTSZV DECIMAL(4,0) ,BDTSZB DECIMAL(4,0) ,BDTBSZ VARCHAR(3) BINARY ,BDTJHR DECIMAL(4,0) ,BDTMON DECIMAL(2,0) ,BDTWOC DECIMAL(2,0) ,BDTJWC DECIMAL(4,0) ,BDTTAG DECIMAL(1,0) ,BDTTTP VARCHAR(3) BINARY ,BDTZTV DECIMAL(4,0) ,BDTZTB DECIMAL(4,0) ,BDTKST VARCHAR(10) BINARY ,BDTFC1 VARCHAR(3) BINARY DEFAULT NULL,BDTFC2 VARCHAR(3) BINARY DEFAULT NULL,BDTFC3 VARCHAR(3) BINARY ,BDTOSO VARCHAR(5) BINARY ,BDTOSA VARCHAR(5) BINARY ,BDTOSV DECIMAL(4,0) ,BDTOSB DECIMAL(4,0) ,BDTOSZ VARCHAR(3) BINARY ,BDTPLG VARCHAR(5) BINARY ,BDTASW DECIMAL(3,0) ,BDTSTS VARCHAR(1) BINARY DEFAULT ' ',BDTFNR DECIMAL(5,0) DEFAULT 0,BDTSTA DECIMAL(1,0) DEFAULT 1,BDTTXT VARCHAR(60) BINARY ,BDTDAT DATETIME ,BDTERF VARCHAR(50) BINARY DEFAULT 'Timesys',BDTAZT DECIMAL(5,0) ,BDTID1 DECIMAL(3,0) ,BDTID2 DECIMAL(3,0) ,BDTID3 DECIMAL(3,0) ,BDTID4 DECIMAL(3,0) ,BDTID5 DECIMAL(3,0) ,BDTID6 DECIMAL(3,0) ,BDTID7 DECIMAL(3,0) ,BDTID8 DECIMAL(3,0) ,BDTRND DECIMAL(3,0) ,BDTAKT DECIMAL(4,0) DEFAULT 1,BDTBNR DECIMAL(3,0) DEFAULT 1,BDTAWP DECIMAL(3,0) ,BDTPAU DECIMAL(5,0) DEFAULT 0,BDTBZT DECIMAL(5,0) DEFAULT 0,BDTOSW DECIMAL(3,0) DEFAULT 0,BDTKEY VARCHAR(32) BINARY DEFAULT NULL,BDTKOS DECIMAL(9,2)  ,PRIMARY KEY(BDTPNR,BDTBDT,BDTESO,BDTESA,BDTSZV,BDTPLG,BDTASW,BDTAKT,BDTKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS735BDK ( BDKKEY VARCHAR(32) BINARY ,BDKLFD DECIMAL(5,0) ,BDKPNR VARCHAR(8) BINARY ,BDKBDT DATETIME ,BDKESO VARCHAR(5) BINARY ,BDKESA VARCHAR(5) BINARY ,BDKSZV DECIMAL(4,0) ,BDKSZB DECIMAL(4,0) ,BDKBSZ VARCHAR(3) BINARY ,BDKJHR DECIMAL(4,0) ,BDKMON DECIMAL(2,0) ,BDKWOC DECIMAL(2,0) ,BDKJWC DECIMAL(4,0) ,BDKTAG DECIMAL(1,0) ,BDKTTP VARCHAR(3) BINARY ,BDKZTV DECIMAL(4,0) ,BDKZTB DECIMAL(4,0) ,BDKKST VARCHAR(10) BINARY ,BDKFC1 VARCHAR(3) BINARY ,BDKFC2 VARCHAR(3) BINARY ,BDKFC3 VARCHAR(3) BINARY ,BDKOSO VARCHAR(5) BINARY ,BDKOSA VARCHAR(5) BINARY ,BDKOSV DECIMAL(4,0) ,BDKOSB DECIMAL(4,0) ,BDKOSZ VARCHAR(3) BINARY ,BDKPLG VARCHAR(5) BINARY ,BDKASW DECIMAL(3,0) ,BDKSTS VARCHAR(1) BINARY ,BDKFNR DECIMAL(5,0) DEFAULT 0,BDKSTA DECIMAL(1,0) DEFAULT 1,BDKTXT VARCHAR(60) BINARY ,BDKDAT DATETIME ,BDKERF VARCHAR(50) BINARY DEFAULT 'Timesys',BDKAZT DECIMAL(5,0) ,BDKID1 DECIMAL(3,0) ,BDKID2 DECIMAL(3,0) ,BDKID3 DECIMAL(3,0) ,BDKID4 DECIMAL(3,0) ,BDKID5 DECIMAL(3,0) ,BDKID6 DECIMAL(3,0) ,BDKID7 DECIMAL(3,0) ,BDKID8 DECIMAL(3,0) ,BDKRND DECIMAL(3,0) ,BDKAKT DECIMAL(4,0) DEFAULT 1,BDKOSW DECIMAL(3,0) ,BDKZVO VARCHAR(8) BINARY ,BDKZBI VARCHAR(8) BINARY  ,PRIMARY KEY(BDKKEY,BDKLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS736BDS ( BDSBDT DATETIME ,BDSPLG VARCHAR(5) BINARY ,BDSESO VARCHAR(5) BINARY ,BDSESA VARCHAR(5) BINARY ,BDSTTP VARCHAR(3) BINARY ,BDSVON DECIMAL(4,0) ,BDSDAT DATETIME ,BDSERF VARCHAR(50) BINARY DEFAULT 'Timesys',BDSBIS DECIMAL(5,0) ,BDSASW DECIMAL(3,0) DEFAULT 0 ,PRIMARY KEY(BDSBDT,BDSPLG,BDSESO,BDSESA,BDSTTP,BDSVON,BDSASW)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS740PUD ( PUDPNR VARCHAR(8) BINARY ,PUDDTM DATETIME ,PUDTYP DECIMAL(3,0) ,PUDKNG DECIMAL(1,0) DEFAULT 1,PUDTXC DECIMAL(3,0) ,PUDPLG VARCHAR(5) BINARY ,PUDERF VARCHAR(50) BINARY DEFAULT 'Timesys',PUDDAT DATETIME  ,PRIMARY KEY(PUDDAT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS746ERR ( ERRPLG VARCHAR(5) BINARY ,ERRKNG VARCHAR(5) BINARY ,ERRDAT DATETIME ,ERRLFN DECIMAL(4,0) DEFAULT 0,ERRPNR VARCHAR(8) BINARY ,ERRESO VARCHAR(5) BINARY ,ERRESA VARCHAR(5) BINARY ,ERRKNZ VARCHAR(5) BINARY ,ERRBDT DATETIME ,ERRZTV DECIMAL(4,0) ,ERRZTB DECIMAL(4,0) ,ERRFNR DECIMAL(5,0) DEFAULT 0,ERRERF VARCHAR(50) BINARY DEFAULT 'Timesys',ERRJBD VARCHAR(14) BINARY ,ERRJBK VARCHAR(32) BINARY  ,PRIMARY KEY(ERRPLG,ERRKNG,ERRDAT,ERRLFN,ERRJBD,ERRJBK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS747PGM ( PGMKNG VARCHAR(5) BINARY ,PGMBEZ VARCHAR(50) BINARY ,PGMUSR VARCHAR(50) BINARY DEFAULT 'Timesys',PGMAKT DATETIME  ,PRIMARY KEY(PGMKNG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS750PTD ( PTDNAM VARCHAR(20) BINARY ,PTDKR1 DECIMAL(1,0) ,PTDKR2 DECIMAL(1,0) ,PTDKR3 DECIMAL(1,0) ,PTDKR4 DECIMAL(1,0) ,PTDLES DECIMAL(1,0) ,PTDZMR VARCHAR(30) BINARY ,PTDDAT DATETIME ,PTDSTA DECIMAL(5,0) DEFAULT 1,PTDERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',PTDREI DECIMAL(2,0) ,PTDKR5 DECIMAL(1,0) DEFAULT 0,PTDWCH DECIMAL(3,0) DEFAULT 1,PTDPRT DECIMAL(1,0) DEFAULT -9,PTDSIM DECIMAL(1,0)  ,PRIMARY KEY(PTDNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS750PTL ( PTLNAM VARCHAR(20) BINARY ,PTLTXT VARCHAR(50) BINARY ,PTLDAT DATETIME ,PTLSTA DECIMAL(5,0) DEFAULT 1,PTLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(PTLNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS751FRB ( FRBNUM DECIMAL(2,0) ,FRBHGF VARCHAR(10) BINARY ,FRBSFB VARCHAR(10) BINARY ,FRBSKN VARCHAR(10) BINARY ,FRBDAT DATETIME ,FRBSTA DECIMAL(5,0) DEFAULT 1,FRBERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(FRBNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS755PKA ( PKAPLG VARCHAR(5) BINARY ,PKANUM VARCHAR(3) BINARY ,PKADTM DATETIME ,PKATTP VARCHAR(3) BINARY ,PKAGWT DECIMAL(22,0) ,PKADAT DATETIME ,PKAERF VARCHAR(50) BINARY  ,PRIMARY KEY(PKAPLG,PKANUM,PKADTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS770WBS ( WBSPNR VARCHAR(8) BINARY ,WBSKEY VARCHAR(14) BINARY ,WBSSTS VARCHAR(1) BINARY ,WBSVON DATETIME ,WBSBIS DATETIME ,WBSESO VARCHAR(5) BINARY ,WBSESA VARCHAR(5) BINARY ,WBSWBS VARCHAR(264) BINARY ,WBSERF VARCHAR(50) BINARY ,WBSDAT DATETIME  ,PRIMARY KEY(WBSPNR,WBSKEY,WBSSTS,WBSVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS800KAT ( KATNUM DECIMAL(11,0) DEFAULT 0,KATWHL DECIMAL(5,0) DEFAULT 0,KATSPR DECIMAL(5,0) DEFAULT 1,KATTXT VARCHAR(120) BINARY ,KATSTA DECIMAL(5,0) DEFAULT 1,KATDAT DATETIME ,KATERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(KATNUM,KATWHL,KATSPR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS802PNRREP ( BPNREP VARCHAR(50) BINARY ,BPNBER DECIMAL(1,0) ,BPNNUM VARCHAR(15) BINARY ,BPNGRP DECIMAL(2,0) ,BPNPNR VARCHAR(50) BINARY ,BPNZUW VARCHAR(50) BINARY ,BPNERF VARCHAR(50) BINARY ,BPNDAT DATETIME ,BPNSAS DECIMAL(1,0) ,BPNABT VARCHAR(15) BINARY ,BPNAKR VARCHAR(5) BINARY ,BPNKST VARCHAR(10) BINARY  ,PRIMARY KEY(BPNREP,BPNBER,BPNNUM,BPNPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS802RTEREP ( RTEREP VARCHAR(50) BINARY ,RTEBER DECIMAL(1,0) ,RTENUM VARCHAR(15) BINARY ,RTEERF VARCHAR(50) BINARY ,RTEDAT DATETIME ,RTESAS DECIMAL(1,0) ,RTETXT VARCHAR(50) BINARY ,RTEGRP DECIMAL(2,0)  ,PRIMARY KEY(RTENUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS898TGB ( TGBDWH VARCHAR(50) BINARY ,TGBSBE VARCHAR(8) BINARY ,TGBPNR VARCHAR(8) BINARY ,TGBZTR DECIMAL(11,0) DEFAULT 1,TGBDTM VARCHAR(8) BINARY ,TGBVT1 DECIMAL(11,0) ,TGBVT2 DECIMAL(11,0) ,TGBMAB DECIMAL(11,0) DEFAULT 0,TGBUNB DECIMAL(11,0) DEFAULT 0,TAGKZV DECIMAL(1,0) ,TAGPZV DECIMAL(1,0) ,ZTGAZT VARCHAR(5) BINARY ,TGBTX1 VARCHAR(30) BINARY ,TGBTX2 VARCHAR(30) BINARY ,TGBTX3 VARCHAR(30) BINARY ,TAGTGB VARCHAR(3) BINARY ,TAGHTV VARCHAR(3) BINARY ,TAGHTN VARCHAR(3) BINARY ,TGBFT1 VARCHAR(30) BINARY ,TGBFT2 VARCHAR(30) BINARY ,TGBFT3 VARCHAR(30) BINARY ,TGBSA1 DECIMAL(11,0) DEFAULT 0,AZVGLV DECIMAL(5,0) DEFAULT 0,AZVGLB DECIMAL(5,0) DEFAULT 0,TGBMAX DECIMAL(11,0) DEFAULT 0,TGBTM1 VARCHAR(2) BINARY ,TGBTM2 VARCHAR(2) BINARY ,TGBTM3 VARCHAR(2) BINARY ,AZVKEV DECIMAL(5,0) DEFAULT 0,AZVKEB DECIMAL(5,0) DEFAULT 0,TGBSA2 DECIMAL(11,0) DEFAULT 0,TGBNRM DECIMAL(11,0) ,TGBGAZ DECIMAL(1,0) ,AZVPSM VARCHAR(5) BINARY ,TGBPSE DECIMAL(11,0) DEFAULT 0,AZVSOL DECIMAL(11,0) DEFAULT 0,ZTGVRA VARCHAR(5) BINARY ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGBSD VARCHAR(5) BINARY ,ZTGTTP VARCHAR(3) BINARY ,TGBSA3 DECIMAL(11,0) DEFAULT 0,TGBVHS DECIMAL(11,0) DEFAULT 0,BAKWTG DECIMAL(5,0) DEFAULT 0,TGBVAB DECIMAL(11,0) DEFAULT 0,DWHBIS VARCHAR(8) BINARY ,BSVPNM VARCHAR(50) BINARY ,BSVABR VARCHAR(5) BINARY ,BSVLUG VARCHAR(10) BINARY DEFAULT '0',BSVURL VARCHAR(5) BINARY ,BSVBGR DECIMAL(5,0) DEFAULT 0,BSVDWT DECIMAL(5,2) DEFAULT 5,BSVSAL VARCHAR(5) BINARY ,BSVLFZ VARCHAR(5) BINARY ,BSVSFR VARCHAR(5) BINARY ,BSVJAM VARCHAR(5) BINARY ,BSVPRZ DECIMAL(5,2) ,BSVMMA DECIMAL(5,0) ,BSVMON DECIMAL(11,0) DEFAULT 0,BSVKAL VARCHAR(5) BINARY ,BSVAGM DECIMAL(11,0) DEFAULT 0,BSVAGV DECIMAL(1,0) ,BSVDMS DECIMAL(11,0) DEFAULT 0,BSVRE0 VARCHAR(50) BINARY ,BSVRE1 VARCHAR(50) BINARY ,BSVRE2 VARCHAR(50) BINARY ,BSVRE3 VARCHAR(50) BINARY ,BSVRE4 VARCHAR(50) BINARY ,BSVRE5 VARCHAR(50) BINARY ,BSVRE6 VARCHAR(50) BINARY ,BSVRE7 VARCHAR(50) BINARY ,BSVRE8 VARCHAR(50) BINARY ,BSVRE9 VARCHAR(50) BINARY ,BSVGVO VARCHAR(8) BINARY ,BSVGBI VARCHAR(8) BINARY ,ZUOGVO VARCHAR(8) BINARY ,ZUOGBI VARCHAR(8) BINARY ,URVJHR DECIMAL(5,0) DEFAULT NULL,UTGGUT DECIMAL(5,2) ,UTGVTG DECIMAL(5,2) ,URVABG DECIMAL(7,2) ,URVJUB DECIMAL(7,2) DEFAULT 0,UTGGKT DECIMAL(5,2) ,URVVJR DECIMAL(7,2) DEFAULT 0,URVSBH DECIMAL(7,2) DEFAULT 0,URVUAN DECIMAL(7,2) DEFAULT 0,URVGUR DECIMAL(7,2) DEFAULT 0,URVMIN DECIMAL(7,2) ,URVVUR DECIMAL(5,2) DEFAULT 0,URVZUS DECIMAL(7,2) DEFAULT 0,URVSUL DECIMAL(7,2) DEFAULT 0,UTGRTG DECIMAL(5,2) DEFAULT 0,UTGVFL DECIMAL(5,2) ,SFZGEN DECIMAL(7,2) ,SFZANS DECIMAL(7,2) ,SFZANT DECIMAL(7,2) ,SFZVPL DECIMAL(7,2) ,SFZRST DECIMAL(7,2) ,SFVVTG DECIMAL(7,2) ,SFVVAN DECIMAL(7,2) ,SFVZUS DECIMAL(5,0) DEFAULT 0,TGBSA4 DECIMAL(11,0) DEFAULT 0,TGBSA5 DECIMAL(11,0) DEFAULT 0,TGBSA6 DECIMAL(11,0) DEFAULT 0,TGBSA7 DECIMAL(11,0) DEFAULT 0,TGBVT4 DECIMAL(11,0) ,TGBVT5 DECIMAL(11,0) ,TGBVT6 DECIMAL(11,0) ,TGBVT7 DECIMAL(11,0) ,TGBVT3 DECIMAL(11,0) ,AZVMAV DECIMAL(5,0) DEFAULT 0,AZVMAB DECIMAL(5,0) DEFAULT 0,TGBDAT VARCHAR(14) BINARY ,JAVJAZ DECIMAL(8,0) ,JAVIST DECIMAL(8,0) ,JAVSOL DECIMAL(8,0) ,JAVDIF DECIMAL(8,0) ,JAVDI2 DECIMAL(8,0) ,TAGNPK DECIMAL(5,0) ,TAGAMP DECIMAL(5,0)  ,PRIMARY KEY(TGBDWH,TGBSBE,TGBPNR,TGBZTR,TGBDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS898ZKB ( ZKBDWH VARCHAR(50) BINARY ,ZKBSBE VARCHAR(8) BINARY ,ZKBPNR VARCHAR(8) BINARY ,ZKBZTR DECIMAL(5,0) DEFAULT 1,ZKBDTM VARCHAR(8) BINARY ,ZKBKST VARCHAR(30) BINARY ,ZKBKTR VARCHAR(6) BINARY ,ZKBKRT VARCHAR(4) BINARY ,ZKBZKT VARCHAR(5) BINARY ,ZKBSTD DECIMAL(11,0) DEFAULT 0,ZKBTGE DECIMAL(11,0) DEFAULT 0,ZKBSTG DECIMAL(11,0) DEFAULT 0,ZKBSTO DECIMAL(11,0) DEFAULT 0,ZKBBEM DECIMAL(11,0) ,ZKBNUM DECIMAL(11,0) ,ZKBANZ DECIMAL(11,0) DEFAULT 0,DWHBIS VARCHAR(8) BINARY ,ZTGVRA VARCHAR(5) BINARY ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGBSD VARCHAR(5) BINARY ,ZTGTTP VARCHAR(3) BINARY ,ZKBDAT VARCHAR(14) BINARY  ,PRIMARY KEY(ZKBDWH,ZKBSBE,ZKBPNR,ZKBZTR,ZKBDTM,ZKBNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899ASW ( ASWPNR VARCHAR(8) BINARY ,ASWNUM VARCHAR(50) BINARY ,ASWGRP VARCHAR(5) BINARY ,ASWBKL VARCHAR(5) BINARY ,ASWGVO VARCHAR(8) BINARY ,ASWGBI VARCHAR(8) BINARY ,ASWSTO VARCHAR(8) BINARY ,ASWSTA DECIMAL(5,0) ,ASWDAT VARCHAR(14) BINARY  ,PRIMARY KEY(ASWPNR,ASWNUM,ASWBKL,ASWGVO,ASWSTO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899BCH ( BCHPNR VARCHAR(8) BINARY ,BCHVON VARCHAR(8) BINARY ,BCHUHR VARCHAR(6) BINARY ,BCHFKT DECIMAL(5,0) DEFAULT 1,BCHTTX VARCHAR(50) BINARY ,BCHFCD VARCHAR(3) BINARY ,BCHFTX VARCHAR(50) BINARY ,BCHKST VARCHAR(30) BINARY ,BCHKTX VARCHAR(50) BINARY ,BCHBUP DECIMAL(5,0) DEFAULT 0,BCHERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',BCHTRM VARCHAR(255) BINARY ,ZTGAZT VARCHAR(5) BINARY ,ZTGVRA VARCHAR(5) BINARY ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGBSD VARCHAR(5) BINARY ,BCHDAT VARCHAR(14) BINARY ,BCH321DAT VARCHAR(20) BINARY  ,PRIMARY KEY(BCHPNR,BCHVON,BCHUHR,BCHFKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899BUP ( BUPPNR VARCHAR(8) BINARY ,BUPTAGTAG VARCHAR(8) BINARY ,BUPTAGVON VARCHAR(8) BINARY ,BUPTAGUHR VARCHAR(6) BINARY ,BUPTAGBIS VARCHAR(8) BINARY ,BUPTAGEND VARCHAR(6) BINARY ,BUPVON VARCHAR(8) BINARY ,BUPUHR VARCHAR(6) BINARY ,BUPFKT DECIMAL(5,0) ,BUPFKTTXT VARCHAR(51) BINARY ,BUPFCD VARCHAR(3) BINARY ,BUPFCDTXT VARCHAR(50) BINARY ,BUPBIS VARCHAR(8) BINARY ,BUPEND VARCHAR(6) BINARY ,BUPFFK DECIMAL(5,0) ,BUPFFKTXT VARCHAR(51) BINARY ,BUPFFC VARCHAR(3) BINARY ,BUPFFCTXT VARCHAR(50) BINARY ,BUPTVO DECIMAL(5,0) ,BUPTBI DECIMAL(5,0) ,BUPAVO DECIMAL(1,0) ,BUPABI DECIMAL(1,0) ,BUPWZV DECIMAL(5,0) ,BUPWZB DECIMAL(5,0) ,BUPTAGDAT DATETIME ,BUPKST VARCHAR(30) BINARY  ,PRIMARY KEY(BUPPNR,BUPTAGTAG,BUPTAGVON,BUPVON,BUPUHR,BUPFKT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899EMA ( EMANAM VARCHAR(50) BINARY ,EMAEMA VARCHAR(50) BINARY ,EMASTA DECIMAL(5,0) DEFAULT 1,EMADAT DATETIME ,EMAERF VARCHAR(50) BINARY  ,PRIMARY KEY(EMANAM,EMAEMA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899PNR ( PNRNUM VARCHAR(8) BINARY ,PNRGEB VARCHAR(8) BINARY ,PNREIN VARCHAR(8) BINARY ,PNRNAM VARCHAR(50) BINARY ,PNRSTR VARCHAR(50) BINARY ,PNRPLZ VARCHAR(10) BINARY ,PNRORT VARCHAR(50) BINARY ,PNRTEL VARCHAR(30) BINARY ,PNRMOB VARCHAR(30) BINARY ,PNRANR DECIMAL(5,0) ,PNRLUG VARCHAR(10) BINARY ,PNRSTA DECIMAL(5,0) ,ZTGAZT VARCHAR(5) BINARY ,ZTGVRA VARCHAR(5) BINARY ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGBSD VARCHAR(5) BINARY ,PNRTIT DECIMAL(5,0) ,PNREML VARCHAR(50) BINARY ,PNRANM VARCHAR(50) BINARY ,PNRGBI VARCHAR(8) BINARY ,PNRMRT VARCHAR(15) BINARY ,PNRFRT VARCHAR(15) BINARY ,PNRFRE VARCHAR(15) BINARY ,PNRBEA DECIMAL(5,0) ,PNRNEB VARCHAR(8) BINARY ,PNRAKT VARCHAR(8) BINARY ,PNREND VARCHAR(8) BINARY ,PNRKRD VARCHAR(20) BINARY ,PNRPRT VARCHAR(15) BINARY ,PNRDAT VARCHAR(14) BINARY ,PNRDWH DECIMAL(1,0)  ,PRIMARY KEY(PNRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899TGB ( TGBPNR VARCHAR(8) BINARY ,TGBZTR DECIMAL(11,0) DEFAULT 1,TGBDTM VARCHAR(8) BINARY ,TGBVT1 DECIMAL(11,0) ,TGBVT2 DECIMAL(11,0) ,TGBMAB DECIMAL(11,0) DEFAULT 0,TGBUNB DECIMAL(11,0) DEFAULT 0,TAGKZV DECIMAL(1,0) ,TAGPZV DECIMAL(1,0) ,ZTGAZT VARCHAR(5) BINARY ,TGBTX1 VARCHAR(30) BINARY ,TGBTX2 VARCHAR(30) BINARY ,TGBTX3 VARCHAR(30) BINARY ,TAGTGB VARCHAR(3) BINARY ,TAGHTV VARCHAR(3) BINARY ,TAGHTN VARCHAR(3) BINARY ,TGBFT1 VARCHAR(30) BINARY ,TGBFT2 VARCHAR(30) BINARY ,TGBFT3 VARCHAR(30) BINARY ,TGBSA1 DECIMAL(11,0) DEFAULT 0,AZVGLV DECIMAL(5,0) DEFAULT 0,AZVGLB DECIMAL(5,0) DEFAULT 0,TGBMAX DECIMAL(11,0) DEFAULT 0,TGBTM1 VARCHAR(2) BINARY ,TGBTM2 VARCHAR(2) BINARY ,TGBTM3 VARCHAR(2) BINARY ,AZVKEV DECIMAL(5,0) DEFAULT 0,AZVKEB DECIMAL(5,0) DEFAULT 0,TGBSA2 DECIMAL(11,0) DEFAULT 0,TGBNRM DECIMAL(11,0) ,TGBGAZ DECIMAL(1,0) ,AZVPSM VARCHAR(5) BINARY ,TGBPSE DECIMAL(11,0) DEFAULT 0,AZVSOL DECIMAL(11,0) DEFAULT 0,ZTGVRA VARCHAR(5) BINARY ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGBSD VARCHAR(5) BINARY ,ZTGTTP VARCHAR(3) BINARY ,TGBSA3 DECIMAL(11,0) DEFAULT 0,TGBVHS DECIMAL(11,0) DEFAULT 0,BAKWTG DECIMAL(5,0) DEFAULT 0,TGBVAB DECIMAL(11,0) DEFAULT 0,DWHBIS VARCHAR(8) BINARY ,BSVPNM VARCHAR(50) BINARY ,BSVABR VARCHAR(5) BINARY ,BSVLUG VARCHAR(10) BINARY DEFAULT '0',BSVURL VARCHAR(5) BINARY ,BSVBGR DECIMAL(5,0) DEFAULT 0,BSVDWT DECIMAL(5,2) DEFAULT 5,BSVSAL VARCHAR(5) BINARY ,BSVLFZ VARCHAR(5) BINARY ,BSVSFR VARCHAR(5) BINARY ,BSVJAM VARCHAR(5) BINARY ,BSVPRZ DECIMAL(5,2) ,BSVMMA DECIMAL(5,0) ,BSVMON DECIMAL(11,0) DEFAULT 0,BSVKAL VARCHAR(5) BINARY ,BSVAGM DECIMAL(11,0) DEFAULT 0,BSVAGV DECIMAL(1,0) ,BSVDMS DECIMAL(11,0) DEFAULT 0,BSVRE0 VARCHAR(50) BINARY ,BSVRE1 VARCHAR(50) BINARY ,BSVRE2 VARCHAR(50) BINARY ,BSVRE3 VARCHAR(50) BINARY ,BSVRE4 VARCHAR(50) BINARY ,BSVRE5 VARCHAR(50) BINARY ,BSVRE6 VARCHAR(50) BINARY ,BSVRE7 VARCHAR(50) BINARY ,BSVRE8 VARCHAR(50) BINARY ,BSVRE9 VARCHAR(50) BINARY ,BSVGVO VARCHAR(8) BINARY ,BSVGBI VARCHAR(8) BINARY ,ZUOGVO VARCHAR(8) BINARY ,ZUOGBI VARCHAR(8) BINARY ,URVJHR DECIMAL(5,0) DEFAULT NULL,UTGGUT DECIMAL(5,2) ,UTGVTG DECIMAL(5,2) ,URVABG DECIMAL(7,2) ,URVJUB DECIMAL(7,2) DEFAULT 0,UTGGKT DECIMAL(5,2) ,URVVJR DECIMAL(7,2) DEFAULT 0,URVSBH DECIMAL(7,2) DEFAULT 0,URVUAN DECIMAL(7,2) DEFAULT 0,URVGUR DECIMAL(7,2) DEFAULT 0,URVMIN DECIMAL(7,2) ,URVVUR DECIMAL(5,2) DEFAULT 0,URVZUS DECIMAL(7,2) DEFAULT 0,URVSUL DECIMAL(7,2) DEFAULT 0,UTGRTG DECIMAL(5,2) DEFAULT 0,UTGVFL DECIMAL(5,2) ,SFZGEN DECIMAL(7,2) ,SFZANS DECIMAL(7,2) ,SFZANT DECIMAL(7,2) ,SFZVPL DECIMAL(7,2) ,SFZRST DECIMAL(7,2) ,SFVVTG DECIMAL(7,2) ,SFVVAN DECIMAL(7,2) ,SFVZUS DECIMAL(5,0) DEFAULT 0,TGBSA4 DECIMAL(11,0) DEFAULT 0,TGBSA5 DECIMAL(11,0) DEFAULT 0,TGBSA6 DECIMAL(11,0) DEFAULT 0,TGBSA7 DECIMAL(11,0) DEFAULT 0,TGBVT4 DECIMAL(11,0) ,TGBVT5 DECIMAL(11,0) ,TGBVT6 DECIMAL(11,0) ,TGBVT7 DECIMAL(11,0) ,TGBVT3 DECIMAL(11,0) ,AZVMAV DECIMAL(5,0) DEFAULT 0,AZVMAB DECIMAL(5,0) DEFAULT 0,TGBDAT VARCHAR(14) BINARY ,JAVJAZ DECIMAL(8,0) ,JAVIST DECIMAL(8,0) ,JAVSOL DECIMAL(8,0) ,JAVDIF DECIMAL(8,0) ,JAVDI2 DECIMAL(8,0) ,TAGNPK DECIMAL(5,0) ,TAGAMP DECIMAL(5,0) ,ZTGTAG DECIMAL(5,0)  ,PRIMARY KEY(TGBPNR,TGBZTR,TGBDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE %SCHEMA%.TMS899ZKB ( ZKBPNR VARCHAR(8) BINARY ,ZKBZTR DECIMAL(5,0) DEFAULT 1,ZKBDTM VARCHAR(8) BINARY ,ZKBKST VARCHAR(30) BINARY ,ZKBKTR VARCHAR(6) BINARY ,ZKBKRT VARCHAR(4) BINARY ,ZKBZKT VARCHAR(5) BINARY ,ZKBSTD DECIMAL(11,0) DEFAULT 0,ZKBTGE DECIMAL(11,0) DEFAULT 0,ZKBSTG DECIMAL(11,0) DEFAULT 0,ZKBSTO DECIMAL(11,0) DEFAULT 0,ZKBBEM DECIMAL(11,0) ,ZKBNUM DECIMAL(11,0) ,ZKBANZ DECIMAL(11,0) DEFAULT 0,ZTGVRA VARCHAR(5) BINARY ,ZTGAKR VARCHAR(5) BINARY ,ZTGABT VARCHAR(15) BINARY ,ZTGKST VARCHAR(30) BINARY ,ZTGKTR VARCHAR(6) BINARY ,ZTGKRT VARCHAR(4) BINARY ,ZTGAGR VARCHAR(5) BINARY ,ZTGBSD VARCHAR(5) BINARY ,ZTGTTP VARCHAR(3) BINARY ,ZKBDAT VARCHAR(14) BINARY  ,PRIMARY KEY(ZKBPNR,ZKBZTR,ZKBDTM,ZKBNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
