CREATE TABLE TMSYSTEM.ASWBKLDNL ( DNLTRM VARCHAR(255) ,DNLASW VARCHAR(13) ,DNLBKL VARCHAR(3)  ,CONSTRAINT TMSYSTEM.ASWBKLDNL_PK PRIMARY KEY(DNLTRM,DNLASW,DNLBKL)   );
CREATE TABLE TMSYSTEM.G2004TYPTASTEN ( TTNTTY VARCHAR(10) ,TTNTAS NUMERIC(5,0) WITH DEFAULT 0,TTNSTA NUMERIC(5,0) WITH DEFAULT 1,TTNDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTNERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.G2004TYPTASTEN_PK PRIMARY KEY(TTNTTY,TTNTAS)   );
CREATE TABLE TMSYSTEM.G2005ZEITPUNKT ( TZUZPL VARCHAR(10) ,TZUUHR TIME ,TZUSTA NUMERIC(5,0) WITH DEFAULT 1,TZUDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TZUERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.G2005ZEITPUNKT_PK PRIMARY KEY(TZUZPL,TZUUHR)   );
CREATE TABLE TMSYSTEM.G2006DATDNLLST ( DDLLIZ VARCHAR(5) ,DDLMND VARCHAR(5) ,DDLNAM VARCHAR(50) ,DDLTYP NUMERIC(5,0) WITH DEFAULT 0,DDLDNM VARCHAR(200) ,DDLDTV DATE ,DDLDTB DATE ,DDLUZV TIME ,DDLUZB TIME ,DDLSTA NUMERIC(1,0) WITH DEFAULT 1,DDLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,DDLERF VARCHAR(50) WITH DEFAULT 'Timesys',DDLZAG NUMERIC(1,0) WITH DEFAULT 1,DDLTRM VARCHAR(255) ,DDLDLA NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.G2006DATDNLLST_PK PRIMARY KEY(DDLLIZ,DDLMND,DDLNAM,DDLTYP)   );
CREATE TABLE TMSYSTEM.G2006TXTDNLLST ( TXTLIZ VARCHAR(5) ,TXTMND VARCHAR(5) ,TXTNAM VARCHAR(50) ,TXTTYP NUMERIC(5,0) WITH DEFAULT 0,TXTLFD NUMERIC(5,0) ,TXTTXT VARCHAR(4000) ,TXTAUS VARCHAR(50)  ,CONSTRAINT TMSYSTEM.G2006TXTDNLLST_PK PRIMARY KEY(TXTLIZ,TXTMND,TXTNAM,TXTTYP,TXTLFD)   );
CREATE TABLE TMSYSTEM.G2100TASLST ( TTANUM VARCHAR(10) ,TTATYP VARCHAR(10) ,TTATAS NUMERIC(5,0) WITH DEFAULT 0,TTABCH VARCHAR(3) ,TTATTX NUMERIC(5,0) WITH DEFAULT 0,TTASTA NUMERIC(5,0) WITH DEFAULT 1,TTADAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTAERF VARCHAR(50) WITH DEFAULT 'Timesys',TTADNC NUMERIC(5,0) ,TTAFTP NUMERIC(5,0) WITH DEFAULT 0,TTAZUT NUMERIC(5,0) WITH DEFAULT 0,TTARAS NUMERIC(5,0) WITH DEFAULT 0,TTAMSG NUMERIC(5,0) WITH DEFAULT 0,TTAPOS NUMERIC(2,0)  ,CONSTRAINT TMSYSTEM.G2100TASLST_PK PRIMARY KEY(TTANUM,TTATYP,TTATAS)   );
CREATE TABLE TMSYSTEM.G2101SALLST ( TSASAL VARCHAR(10) ,TSALFD NUMERIC(5,0) WITH DEFAULT 0,TSAANZ NUMERIC(5,0) WITH DEFAULT 0,TSAAUS NUMERIC(5,0) WITH DEFAULT 0,TSASTA NUMERIC(5,0) WITH DEFAULT 1,TSADAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TSAERF VARCHAR(50) WITH DEFAULT 'Timesys',TSASPL NUMERIC(2,0)  ,CONSTRAINT TMSYSTEM.G2101SALLST_PK PRIMARY KEY(TSASAL,TSALFD)   );
CREATE TABLE TMSYSTEM.G2102UPLLST ( TUWUPL VARCHAR(10) ,TUWDTN VARCHAR(200) ,TUWLFD NUMERIC(5,0) WITH DEFAULT 1,TUWZPL VARCHAR(10) ,TUWSTA NUMERIC(5,0) WITH DEFAULT 1,TUWDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TUWERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.G2102UPLLST_PK PRIMARY KEY(TUWUPL,TUWDTN,TUWLFD)   );
CREATE TABLE TMSYSTEM.G2103DNLLST ( DLLNAM VARCHAR(10) ,DLLDTN VARCHAR(200) ,DLLLFN NUMERIC(5,0) WITH DEFAULT 1,DLLZPL VARCHAR(10) ,DLLSTA NUMERIC(5,0) WITH DEFAULT 1,DLLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,DLLERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.G2103DNLLST_PK PRIMARY KEY(DLLNAM,DLLDTN,DLLLFN)   );
CREATE TABLE TMSYSTEM.MGSSTFCD ( FCDLIZ VARCHAR(5) ,FCDMND VARCHAR(5) ,FCDNUM VARCHAR(3) ,FCDKRT VARCHAR(2) ,FCDTXT VARCHAR(50) ,FCDDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,FCDTYP NUMERIC(5,0) ,FCDFCD NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.MGSSTFCD_PK PRIMARY KEY(FCDLIZ,FCDMND,FCDNUM)   );
CREATE TABLE TMSYSTEM.MGSSTFTG ( FTGTRM VARCHAR(255) ,FTGLIZ VARCHAR(5) ,FTGMND VARCHAR(5) ,FTGJHR VARCHAR(4) ,FTGDTM VARCHAR(8) ,FTGTXT VARCHAR(20) ,FTGKRT VARCHAR(1) ,FTGDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,FTGKAL VARCHAR(3) WITH DEFAULT ' ' ,CONSTRAINT TMSYSTEM.MGSSTFTG_PK PRIMARY KEY(FTGTRM,FTGLIZ,FTGMND,FTGDTM,FTGKAL)   );
CREATE TABLE TMSYSTEM.MGSSTMDT ( MDTLIZ VARCHAR(5) ,MDTMND VARCHAR(5) ,MDTASW VARCHAR(13) ,MDTDTM VARCHAR(10) ,MDTABE VARCHAR(33) ,MDTSBE VARCHAR(33) ,MDTSTS VARCHAR(1) ,MDTKRT VARCHAR(1) ,MDTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,MDTFCD VARCHAR(3)  ,CONSTRAINT TMSYSTEM.MGSSTMDT_PK PRIMARY KEY(MDTLIZ,MDTMND,MDTASW,MDTDTM,MDTSTS)   );
CREATE TABLE TMSYSTEM.MGSSTMST ( MSTLIZ VARCHAR(5) ,MSTMND VARCHAR(5) ,MSTASW VARCHAR(13) ,MSTSTS VARCHAR(1) ,MSTVBI VARCHAR(23) ,MSTABE VARCHAR(33) ,MSTSBE VARCHAR(33) ,MSTKRT VARCHAR(1) ,MSTKST VARCHAR(50) ,MSTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,MSTVON VARCHAR(8) ,MSTABT VARCHAR(30) ,MSTUH1 VARCHAR(4) ,MSTFCD VARCHAR(3)  ,CONSTRAINT TMSYSTEM.MGSSTMST_PK PRIMARY KEY(MSTLIZ,MSTMND,MSTASW,MSTSTS,MSTVBI,MSTVON)   );
CREATE TABLE TMSYSTEM.MGSST20P ( M20TRM VARCHAR(255) ,M20SCH VARCHAR(2) ,M20TG1 VARCHAR(1) ,M20ZZ2 VARCHAR(5) ,M20OFV VARCHAR(4) ,M20OFB VARCHAR(4) ,M20DAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.MGSST20P_PK PRIMARY KEY(M20TRM,M20SCH,M20TG1,M20ZZ2,M20OFV)   );
CREATE TABLE TMSYSTEM.MGSST35P ( M35TRM VARCHAR(255) ,M35FIR VARCHAR(3) ,M35BKL VARCHAR(5) ,M35LES VARCHAR(2) ,M35WLE VARCHAR(2) ,M35WPL VARCHAR(3) ,M35ZKO VARCHAR(5) ,M35ZZO VARCHAR(5) ,M35BCH VARCHAR(1) ,M35DAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.MGSST35P_PK PRIMARY KEY(M35TRM,M35FIR,M35BKL,M35LES,M35WLE,M35WPL)   );
CREATE TABLE TMSYSTEM.MGSST41P ( M41TRM VARCHAR(255) ,M41FIR VARCHAR(3) ,M41ZPL VARCHAR(3) ,M41WNR VARCHAR(2) ,M41ZZO VARCHAR(3) ,M41TNR VARCHAR(1) ,M41VON VARCHAR(4) ,M41BIS VARCHAR(4) ,M41DAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.MGSST41P_PK PRIMARY KEY(M41TRM,M41FIR,M41ZPL,M41WNR,M41ZZO,M41TNR,M41VON)   );
CREATE TABLE TMSYSTEM.O1201FORMULAR ( FMRNUM VARCHAR(20) ,FMRART NUMERIC(5,0) WITH DEFAULT 0,FMRLNK VARCHAR(50) ,FMRFLD NUMERIC(11,0) WITH DEFAULT 120101,FMRWHL NUMERIC(5,0) WITH DEFAULT 0,FMRTXT VARCHAR(50) ,FMRSTA NUMERIC(5,0) WITH DEFAULT 1,FMRDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,FMRERF VARCHAR(50) WITH DEFAULT 'Timesys',FMRMOD NUMERIC(5,0) ,FMRFRM NUMERIC(1,0) WITH DEFAULT 1,FMRRTE NUMERIC(5,0) WITH DEFAULT 0,FMRMNU NUMERIC(5,0) WITH DEFAULT 0,FMRMDL NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.O1201FORMULAR_PK PRIMARY KEY(FMRNUM)   );
CREATE TABLE TMSYSTEM.O1201SPRACHE ( SPRNUM NUMERIC(5,0) WITH DEFAULT 0,SPRTXT VARCHAR(50) ,SPRSTA NUMERIC(5,0) WITH DEFAULT 1,SPRDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,SPRERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O1201SPRACHE_PK PRIMARY KEY(SPRNUM)   );
CREATE TABLE TMSYSTEM.O1801SCHALT ( SFLNUM VARCHAR(15) ,SFLTXT VARCHAR(50) ,SFLKTX VARCHAR(10) ,SFLFLD NUMERIC(11,0) WITH DEFAULT 2,SFLWHL NUMERIC(5,0) WITH DEFAULT 1,SFLLNK VARCHAR(50) ,SFLBEF VARCHAR(100) ,SFLHOE NUMERIC(5,0) WITH DEFAULT 0,SFLBRE NUMERIC(5,0) WITH DEFAULT 0,SFLSTA NUMERIC(5,0) WITH DEFAULT 1,SFLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,SFLERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O1801SCHALT_PK PRIMARY KEY(SFLNUM)   );
CREATE TABLE TMSYSTEM.O1803FRMSCHALTLST ( FRMSFLFRM VARCHAR(20) ,FRMSFLSCH VARCHAR(15) ,FRMSFLFUN VARCHAR(100) ,FRMSFLSTA NUMERIC(1,0) WITH DEFAULT 1,FRMSFLERF VARCHAR(50) WITH DEFAULT 'TIMESYS',FRMSFLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.O1803FRMSCHALTLST_PK PRIMARY KEY(FRMSFLFRM,FRMSFLSCH)   );
CREATE TABLE TMSYSTEM.O2000TASTTEXTE ( TAZNUM NUMERIC(5,0) WITH DEFAULT 0,TAZTXT VARCHAR(50) ,TAZSTA NUMERIC(5,0) WITH DEFAULT 1,TAZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TAZERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2000TASTTEXTE_PK PRIMARY KEY(TAZNUM)   );
CREATE TABLE TMSYSTEM.O2001SALTEXTE ( STXNAM VARCHAR(50) ,STXSPR NUMERIC(5,0) ,STXNUM NUMERIC(5,0) WITH DEFAULT 0,STXTXT VARCHAR(200) ,STXSTA NUMERIC(5,0) WITH DEFAULT 1,STXDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,STXERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2001SALTEXTE_PK PRIMARY KEY(STXNAM,STXSPR,STXNUM)   );
CREATE TABLE TMSYSTEM.O2002SALWERTE ( SWTNUM NUMERIC(5,0) WITH DEFAULT 0,SWTTXT VARCHAR(50) ,SWTSTA NUMERIC(5,0) WITH DEFAULT 1,SWTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,SWTERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2002SALWERTE_PK PRIMARY KEY(SWTNUM)   );
CREATE TABLE TMSYSTEM.O2002TSW ( TSWIDN VARCHAR(50) ,TSWSTO VARCHAR(8) ,TSWLIZ VARCHAR(5) ,TSWMND VARCHAR(5) ,TSWW01 VARCHAR(8) ,TSWW02 VARCHAR(10) ,TSWW03 VARCHAR(10) ,TSWW04 VARCHAR(10) ,TSWW05 VARCHAR(10) ,TSWW06 VARCHAR(10) ,TSWW07 VARCHAR(10) ,TSWW08 VARCHAR(10) ,TSWW09 VARCHAR(10) ,TSWW10 VARCHAR(10) ,TSWW11 VARCHAR(10) ,TSWW12 VARCHAR(10) ,TSWW13 VARCHAR(10) ,TSWW14 VARCHAR(10) ,TSWW15 VARCHAR(10) ,TSWW16 VARCHAR(10) ,TSWF01 VARCHAR(20) ,TSWF02 VARCHAR(20) ,TSWF03 VARCHAR(20) ,TSWF04 VARCHAR(20) ,TSWF05 VARCHAR(20) ,TSWF06 VARCHAR(20) ,TSWF07 VARCHAR(20) ,TSWF08 VARCHAR(20) ,TSWF09 VARCHAR(20) ,TSWF10 VARCHAR(20) ,TSWAMP VARCHAR(5)  ,CONSTRAINT TMSYSTEM.O2002TSW_PK PRIMARY KEY(TSWIDN)   );
CREATE TABLE TMSYSTEM.O2003BUCHCODE ( TBCCOD VARCHAR(3) ,TBCTXT VARCHAR(50) ,TBCSTA NUMERIC(5,0) WITH DEFAULT 1,TBCDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TBCERF VARCHAR(50) WITH DEFAULT 'Timesys',TBCFCD VARCHAR(3)  ,CONSTRAINT TMSYSTEM.O2003BUCHCODE_PK PRIMARY KEY(TBCCOD)   );
CREATE TABLE TMSYSTEM.O2004TASTTYP ( TTYNAM VARCHAR(10) ,TTYTXT VARCHAR(50) ,TTYSTA NUMERIC(5,0) WITH DEFAULT 1,TTYDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTYERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2004TASTTYP_PK PRIMARY KEY(TTYNAM)   );
CREATE TABLE TMSYSTEM.O2005ZEITMODELL ( TZMNAM VARCHAR(10) ,TZMTXT VARCHAR(50) ,TZMSTA NUMERIC(5,0) WITH DEFAULT 1,TZMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TZMERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2005ZEITMODELL_PK PRIMARY KEY(TZMNAM)   );
CREATE TABLE TMSYSTEM.O2006TRMDATEI ( TRDNAM VARCHAR(200) ,TRDTXT VARCHAR(200) ,TRDART NUMERIC(5,0) WITH DEFAULT 1,TRDTYP NUMERIC(5,0) WITH DEFAULT 0,TRDVER VARCHAR(10) ,TRDSTA NUMERIC(5,0) WITH DEFAULT 1,TRDDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TRDERF VARCHAR(50) WITH DEFAULT 'Timesys',TRDTCN VARCHAR(32) ,TRDLIZ VARCHAR(5) ,TRDMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.O2006TRMDATEI_PK PRIMARY KEY(TRDNAM,TRDTYP,TRDLIZ,TRDMND)   );
CREATE TABLE TMSYSTEM.O2007TRMTYP ( TMTNAM VARCHAR(10) ,TMTTXT VARCHAR(50) ,TMTCMD VARCHAR(64) ,TMTSTA NUMERIC(5,0) WITH DEFAULT 1,TMTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TMTERF VARCHAR(50) WITH DEFAULT 'Timesys',TMTTYP VARCHAR(10)  ,CONSTRAINT TMSYSTEM.O2007TRMTYP_PK PRIMARY KEY(TMTNAM)   );
CREATE TABLE TMSYSTEM.O2008TRANSPROT ( TRSDAT TIMESTAMP ,TRSUSR VARCHAR(50) ,TRSTYP VARCHAR(50) ,TRSFILE VARCHAR(255) ,TRSTRM VARCHAR(255) ,TRSSTA VARCHAR(200)  ,CONSTRAINT TMSYSTEM.O2008TRANSPROT_PK PRIMARY KEY(TRSDAT)   );
CREATE TABLE TMSYSTEM.O2009BUCHPROT ( BPRTRM VARCHAR(255) ,BPRZLS NUMERIC(5,0) ,BPRAWV VARCHAR(50) ,BPRDAT DATE ,BPRDTE DATE ,BPRFCD VARCHAR(5) ,BPRERG NUMERIC(3,0) ,BPRVAR VARCHAR(200)  ,CONSTRAINT TMSYSTEM.O2009BUCHPROT_PK PRIMARY KEY(BPRTRM,BPRZLS,BPRDTE)   );
CREATE TABLE TMSYSTEM.O2100TASTTAB ( TTTNAM VARCHAR(10) ,TTTTXT VARCHAR(50) ,TTTKTX VARCHAR(10) ,TTTSTA NUMERIC(5,0) WITH DEFAULT 1,TTTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTTERF VARCHAR(50) WITH DEFAULT 'Timesys',TTTART NUMERIC(2,0) ,TTTTAS NUMERIC(1,0) ,TTTTTP VARCHAR(10) ,TTTFST VARCHAR(1)  ,CONSTRAINT TMSYSTEM.O2100TASTTAB_PK PRIMARY KEY(TTTNAM)   );
CREATE TABLE TMSYSTEM.O2101SALTAB ( TSLNAM VARCHAR(10) ,TSLDAU NUMERIC(5,0) WITH DEFAULT 0,TSLTXT VARCHAR(50) ,TSLKTX VARCHAR(10) ,TSLSTA NUMERIC(5,0) WITH DEFAULT 1,TSLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TSLERF VARCHAR(50) WITH DEFAULT 'Timesys',TSLART NUMERIC(1,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.O2101SALTAB_PK PRIMARY KEY(TSLNAM)   );
CREATE TABLE TMSYSTEM.O2102UPLTAB ( TUMNAM VARCHAR(10) ,TUMDLY NUMERIC(11,0) WITH DEFAULT 0,TUMTXT VARCHAR(50) ,TUMKTX VARCHAR(10) ,TUMSTA NUMERIC(5,0) WITH DEFAULT 1,TUMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TUMERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2102UPLTAB_PK PRIMARY KEY(TUMNAM)   );
CREATE TABLE TMSYSTEM.O2103DNLTAB ( TDNNAM VARCHAR(10) ,TDNTXT VARCHAR(50) ,TDNKTX VARCHAR(10) ,TDNSTA NUMERIC(5,0) WITH DEFAULT 1,TDNDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TDNERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.O2103DNLTAB_PK PRIMARY KEY(TDNNAM)   );
CREATE TABLE TMSYSTEM.O2106MIN ( MINMIN NUMERIC(5,0) ,STDMIN VARCHAR(4)  ,CONSTRAINT TMSYSTEM.O2106MIN_PK PRIMARY KEY(MINMIN)   );
CREATE TABLE TMSYSTEM.O2106TFK ( TFKTTT VARCHAR(10) ,TFKTNM NUMERIC(5,0) ,TFKWTG NUMERIC(1,0) ,TFKV01 NUMERIC(4,0) ,TFKB01 NUMERIC(4,0) ,TFKV02 NUMERIC(4,0) ,TFKB02 NUMERIC(4,0) ,TFKV03 NUMERIC(4,0) ,TFKB03 NUMERIC(4,0) ,TFKV04 NUMERIC(4,0) ,TFKB04 NUMERIC(4,0) ,TFKV05 NUMERIC(4,0) ,TFKB05 NUMERIC(4,0) ,TFKV06 NUMERIC(4,0) ,TFKB06 NUMERIC(4,0) ,TFKV07 NUMERIC(4,0) ,TFKB07 NUMERIC(4,0) ,TFKV08 NUMERIC(4,0) ,TFKB08 NUMERIC(4,0) ,TFKV09 NUMERIC(4,0) ,TFKB09 NUMERIC(4,0) ,TFKV10 NUMERIC(4,0) ,TFKB10 NUMERIC(4,0) ,TFKV11 NUMERIC(4,0) ,TFKB11 NUMERIC(4,0) ,TFKV12 NUMERIC(4,0) ,TFKB12 NUMERIC(4,0) ,TFKERF VARCHAR(50) ,TFKDAT TIMESTAMP  ,CONSTRAINT TMSYSTEM.O2106TFK_PK PRIMARY KEY(TFKTTT,TFKTNM,TFKWTG)   );
CREATE TABLE TMSYSTEM.O2107TTF ( TTFTTT VARCHAR(10) ,TTFTNM NUMERIC(5,0) ,TTFF01 NUMERIC(1,0) WITH DEFAULT 0,TTFF02 NUMERIC(1,0) WITH DEFAULT 0,TTFF03 NUMERIC(1,0) WITH DEFAULT 0,TTFF04 NUMERIC(1,0) WITH DEFAULT 0,TTFF05 NUMERIC(1,0) WITH DEFAULT 0,TTFF06 NUMERIC(1,0) WITH DEFAULT 0,TTFF07 NUMERIC(1,0) WITH DEFAULT 0,TTFF08 NUMERIC(1,0) WITH DEFAULT 0,TTFF09 NUMERIC(1,0) WITH DEFAULT 0,TTFF10 NUMERIC(1,0) WITH DEFAULT 0,TTFF11 NUMERIC(1,0) WITH DEFAULT 0,TTFF12 NUMERIC(1,0) WITH DEFAULT 0,TTFDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTFFCD VARCHAR(3) ,TTFMNU NUMERIC(1,0) ,TTFFTP NUMERIC(5,0) ,TTFTAV NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.O2107TTF_PK PRIMARY KEY(TTFTTT,TTFTNM,TTFMNU)   );
CREATE TABLE TMSYSTEM.O2108TTA ( TTANUM VARCHAR(10) ,TTATYP VARCHAR(10) ,TTAMNU NUMERIC(1,0) ,TTATAS NUMERIC(5,0) ,TTABCH VARCHAR(3) ,TTAPOS NUMERIC(2,0) ,TTATXT VARCHAR(30) ,TTADNC NUMERIC(5,0) ,TTAFTP NUMERIC(5,0) ,TTADAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTAERF VARCHAR(50) WITH DEFAULT 'Timesys',TTAF01 NUMERIC(1,0) ,TTAF02 NUMERIC(1,0) ,TTAF03 NUMERIC(1,0) ,TTAF04 NUMERIC(1,0) ,TTAF05 NUMERIC(1,0) ,TTAF06 NUMERIC(1,0) ,TTAF07 NUMERIC(1,0) ,TTAF08 NUMERIC(1,0) ,TTAF09 NUMERIC(1,0) ,TTAF10 NUMERIC(1,0) ,TTAF11 NUMERIC(1,0) ,TTAF12 NUMERIC(1,0) ,TTAFCD VARCHAR(3) ,TTAAPS NUMERIC(2,0) ,TTATAV NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.O2108TTA_PK PRIMARY KEY(TTANUM,TTATYP,TTAMNU,TTATAS,TTAPOS)   );
CREATE TABLE TMSYSTEM.O2200SZL ( SZLTXT NUMERIC(5,0) ,SZLWRT NUMERIC(5,0) ,SZLTX1 VARCHAR(50) ,SZLFRM NUMERIC(5,0) ,SZLSTA NUMERIC(1,0) WITH DEFAULT 0,SZLDAT TIMESTAMP ,SZLERF VARCHAR(50) ,SZLEIN NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.O2200SZL_PK PRIMARY KEY(SZLTXT,SZLWRT)   );
CREATE TABLE TMSYSTEM.SALASWDNL ( DNLSAL VARCHAR(10) ,DNLLIZ VARCHAR(5) ,DNLMND VARCHAR(5) ,DNLSPR NUMERIC(1,0) ,DNLASW VARCHAR(13) ,DNLSA1 VARCHAR(20) ,DNLSA2 VARCHAR(20) ,DNLSA3 VARCHAR(20) ,DNLSA4 VARCHAR(20) ,DNLSA5 VARCHAR(20) ,DNLSA6 VARCHAR(20) ,DNLSA7 VARCHAR(20) ,DNLSA8 VARCHAR(20) ,DNLWR1 VARCHAR(20) ,DNLWR2 VARCHAR(20) ,DNLWR3 VARCHAR(20) ,DNLWR4 VARCHAR(20) ,DNLWR5 VARCHAR(20) ,DNLWR6 VARCHAR(20) ,DNLWR7 VARCHAR(20) ,DNLWR8 VARCHAR(20)  ,CONSTRAINT TMSYSTEM.SALASWDNL_PK PRIMARY KEY(DNLSAL,DNLLIZ,DNLMND,DNLSPR,DNLASW)   );
CREATE TABLE TMSYSTEM.SALASWDNL2 ( DNLSAL VARCHAR(10) ,DNLLIZ VARCHAR(5) ,DNLMND VARCHAR(5) ,DNLSPR NUMERIC(1,0) ,DNLASW VARCHAR(13) ,DNLWRT NUMERIC(3,0) ,DNLVAL VARCHAR(20)  ,CONSTRAINT TMSYSTEM.SALASWDNL2_PK PRIMARY KEY(DNLSAL,DNLLIZ,DNLMND,DNLSPR,DNLASW,DNLWRT)   );
CREATE TABLE TMSYSTEM.TMSASWDNL ( DNLKEY VARCHAR(14) ,DNLLFD NUMERIC(5,0) ,DNLMND VARCHAR(5) ,DNLLIZ VARCHAR(5) ,DNLASW VARCHAR(50) ,DNLKZE NUMERIC(1,0) ,DNLKZU NUMERIC(1,0) ,DNLKMP NUMERIC(1,0) ,DNLBKL VARCHAR(6) ,DNLSTA NUMERIC(3,0) ,DNLERF VARCHAR(50) ,DNLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMSASWDNL_PK PRIMARY KEY(DNLKEY,DNLLFD)   );
CREATE TABLE TMSYSTEM.TMSAUTODNL ( DNLKEY VARCHAR(14) ,DNLUSR VARCHAR(50) ,DNLTRM VARCHAR(50) ,DNLSTA NUMERIC(3,0) ,DNLERR NUMERIC(3,0) ,DNLMND VARCHAR(5) ,DNLLIZ VARCHAR(5) ,DNLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMSAUTODNL_PK PRIMARY KEY(DNLKEY,DNLUSR,DNLTRM)   );
CREATE TABLE TMSYSTEM.TMSJOBS ( JOBUSR CHAR(10) ,JOBNUM CHAR(6) ,JOBDAT DATE WITH DEFAULT CURRENT_DATE ,CONSTRAINT TMSYSTEM.TMSJOBS_PK PRIMARY KEY(JOBUSR)   );
CREATE TABLE TMSYSTEM.TMS000CHK ( CHKPRG VARCHAR(512) ,CHKSTA NUMERIC(2,0) WITH DEFAULT 0,CHKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,CHKERF VARCHAR(50) ,CHKCHK VARCHAR(32)  ,CONSTRAINT TMSYSTEM.TMS000CHK_PK PRIMARY KEY(CHKPRG)   );
CREATE TABLE TMSYSTEM.TMS000LOG ( LOGIDE VARCHAR(5) ,LOGPRG VARCHAR(512) ,LOGDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,LOGACT NUMERIC(2,0)  ,CONSTRAINT TMSYSTEM.TMS000LOG_PK PRIMARY KEY(LOGIDE,LOGPRG,LOGDAT)   );
CREATE TABLE TMSYSTEM.TMS000USR ( USRIDE VARCHAR(5) ,USRNAM VARCHAR(50) ,USRPWD VARCHAR(32)  ,CONSTRAINT TMSYSTEM.TMS000USR_PK PRIMARY KEY(USRIDE)   );
CREATE TABLE TMSYSTEM.TMS001ERR ( ERRPRM NUMERIC(10,0) ,ERRLFD NUMERIC(5,0) ,ERRDAT DATE ,ERRPNR VARCHAR(8) ,ERRKEY NUMERIC(8,0)  ,CONSTRAINT TMSYSTEM.TMS001ERR_PK PRIMARY KEY(ERRPRM,ERRLFD)   );
CREATE TABLE TMSYSTEM.TMS001LNK ( LNKSBE VARCHAR(8) ,LNKNUM VARCHAR(10) ,LNKMOD VARCHAR(3) ,LNKMND VARCHAR(2) ,LNKLIZ VARCHAR(5) ,LNKFRM VARCHAR(50) ,LNKDTL VARCHAR(50) ,LNKKEY VARCHAR(200) ,LNKRE1 VARCHAR(100) ,LNKRE2 VARCHAR(100) ,LNKVKZ VARCHAR(1) ,LNKRDT VARCHAR(8) ,LNKDAT VARCHAR(14) ,LNKART VARCHAR(1) ,LNKFLG NUMERIC(3,0) ,LNKPNR VARCHAR(8) ,LNKANM VARCHAR(50) ,LNKGVO VARCHAR(8) WITH DEFAULT '20100101',LNKGBI VARCHAR(8) WITH DEFAULT '20301231',LNKVSB VARCHAR(8)  ,CONSTRAINT TMSYSTEM.TMS001LNK_PK PRIMARY KEY(LNKSBE,LNKNUM)   );
CREATE TABLE TMSYSTEM.TMS001LOG ( LOGPRG VARCHAR(30) ,LOGSTZ VARCHAR(14) ,LOGPRM VARCHAR(150) ,LOGSCH VARCHAR(20) ,LOGMOD VARCHAR(10) ,LOGPNR VARCHAR(8) ,LOGDTM DATE ,LOGFKT VARCHAR(50) ,LOGTERR NUMERIC(5,0) WITH DEFAULT 0,LOGTTXT VARCHAR(256) ,LOGSERR NUMERIC(5,0) WITH DEFAULT 0,LOGSTXT VARCHAR(256) ,LOGMSG VARCHAR(256) ,LOGTYP NUMERIC(1,0) WITH DEFAULT 0,LOGDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP     );
CREATE TABLE TMSYSTEM.TMS001PRM ( PRMNUM NUMERIC(10,0) ,PRMLFD NUMERIC(5,0) ,PRMSCH VARCHAR(50) ,PRMPNR VARCHAR(8) ,PRMDVO DATE ,PRMDBI DATE ,PRMADT DATE ,PRMUSR VARCHAR(50) ,PRMDAT VARCHAR(14) ,PRMINH VARCHAR(8)  ,CONSTRAINT TMSYSTEM.TMS001PRM_PK PRIMARY KEY(PRMNUM,PRMLFD)   );
CREATE TABLE TMSYSTEM.TMS002ERR ( ERRPRM NUMERIC(10,0) ,ERRLFD NUMERIC(5,0) ,ERRTYP NUMERIC(5,0) WITH DEFAULT 1,ERRPNR VARCHAR(8) ,ERRFCD VARCHAR(8) ,ERRDAT DATE ,ERRUHR TIME ,ERRKEY NUMERIC(8,0) ,ERRTIS TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ERRNUM NUMERIC(11,0)  ,CONSTRAINT TMSYSTEM.TMS002ERR_PK PRIMARY KEY(ERRPRM,ERRLFD,ERRPNR,ERRKEY,ERRNUM)   );
CREATE TABLE TMSYSTEM.TMS002PRM ( PRMNUM NUMERIC(10,0) ,PRMLFD NUMERIC(5,0) ,PRMTYP NUMERIC(5,0) WITH DEFAULT 1,PRMSCH VARCHAR(20) ,PRMUSR VARCHAR(50) ,PRMMAP NUMERIC(1,0) ,PRMPNR VARCHAR(8) ,PRMDTM DATE ,PRMDBI DATE ,PRMUHR TIME ,PRMFCD VARCHAR(3) ,PRMABT VARCHAR(15) ,PRMKST VARCHAR(30) ,PRMKTR VARCHAR(6) ,PRMKRT VARCHAR(4) ,PRMVRA VARCHAR(5) ,PRMAZT VARCHAR(6) ,PRMTXT NUMERIC(11,0) ,PRMLOE NUMERIC(1,0) ,PRMBUC NUMERIC(1,0) ,PRMVKD NUMERIC(2,0) ,PRMSTS NUMERIC(2,0) ,PRMERF VARCHAR(50) ,PRMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,PRMTRM NUMERIC(1,0) WITH DEFAULT NULL ,CONSTRAINT TMSYSTEM.TMS002PRM_PK PRIMARY KEY(PRMNUM,PRMLFD,PRMTYP)   );
CREATE TABLE TMSYSTEM.TMS003ERR ( ERRPRM NUMERIC(10,0) ,ERRLFD NUMERIC(5,0) ,ERRTYP NUMERIC(5,0) ,ERRPNR VARCHAR(8) ,ERRFCD VARCHAR(8) ,ERRDAT DATE ,ERRUHR TIME ,ERRKEY NUMERIC(8,0) ,ERRTIS TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ERRNUM NUMERIC(11,0)  ,CONSTRAINT TMSYSTEM.TMS003ERR_PK PRIMARY KEY(ERRPRM,ERRLFD,ERRTYP,ERRPNR,ERRKEY,ERRNUM)   );
CREATE TABLE TMSYSTEM.TMS003PRM ( PRMNUM NUMERIC(10,0) ,PRMLFD NUMERIC(5,0) ,PRMTYP NUMERIC(5,0) WITH DEFAULT 1,PRMSCH VARCHAR(20) ,PRMUSR VARCHAR(50) ,PRMMAP NUMERIC(1,0) ,PRMPNR VARCHAR(8) ,PRMDTM DATE ,PRMDBI DATE ,PRMUHR TIME ,PRMFCD VARCHAR(3) ,PRMABT VARCHAR(15) ,PRMKST VARCHAR(30) ,PRMKTR VARCHAR(6) ,PRMKRT VARCHAR(4) ,PRMVRA VARCHAR(5) ,PRMAZT VARCHAR(6) ,PRMTXT NUMERIC(11,0) ,PRMLOE NUMERIC(1,0) ,PRMBUC NUMERIC(1,0) ,PRMVKD NUMERIC(2,0) ,PRMSTS NUMERIC(2,0) ,PRMERF VARCHAR(50) ,PRMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,PRMTRM NUMERIC(1,0) ,PRMADT DATE ,PRMINH VARCHAR(8)  ,CONSTRAINT TMSYSTEM.TMS003PRM_PK PRIMARY KEY(PRMNUM,PRMLFD,PRMTYP)   );
CREATE TABLE TMSYSTEM.TMS004PRM ( PRMNUM NUMERIC(10,0) ,PRMLFD NUMERIC(5,0) ,PRMTYP NUMERIC(5,0) WITH DEFAULT 1,PRMSCH VARCHAR(20) ,PRMUSR VARCHAR(50) ,PRMMAP NUMERIC(1,0) ,PRMPNR VARCHAR(8) ,PRMDTM DATE ,PRMDBI DATE ,PRMUHR DATE ,PRMFCD VARCHAR(3) ,PRMABT VARCHAR(15) ,PRMKST VARCHAR(30) ,PRMKTR VARCHAR(6) ,PRMKRT VARCHAR(4) ,PRMVRA VARCHAR(5) ,PRMAZT VARCHAR(6) ,PRMTXT NUMERIC(11,0) ,PRMLOE NUMERIC(1,0) ,PRMBUC NUMERIC(1,0) ,PRMVKD NUMERIC(2,0) ,PRMSTS NUMERIC(2,0) ,PRMERF VARCHAR(50) ,PRMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,PRMTRM NUMERIC(1,0) ,PRMADT DATE ,PRMINH VARCHAR(8)  ,CONSTRAINT TMSYSTEM.TMS004PRM_PK PRIMARY KEY(PRMNUM,PRMLFD,PRMTYP)   );
CREATE TABLE TMSYSTEM.TMS010HIS ( HISTNR NUMERIC(7,0) ,HISLFD NUMERIC(2,0) ,HISDEF VARCHAR(15) ,HISUSR VARCHAR(50) ,HISFLD VARCHAR(9) ,HISOVL VARCHAR(255) ,HISNVL VARCHAR(255) ,HISKEY VARCHAR(255) ,HISOUS VARCHAR(50) ,HISIP VARCHAR(15) ,HISDST VARCHAR(50) ,HISDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,HISNUM NUMERIC(11,0) ,HISWHL NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.TMS010HIS_PK PRIMARY KEY(HISTNR,HISLFD)   );
CREATE TABLE TMSYSTEM.TMS010TAZ ( TAZDEF VARCHAR(15) ,TAZMSK VARCHAR(15) ,TAZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS010TAZ_PK PRIMARY KEY(TAZDEF,TAZMSK)   );
CREATE TABLE TMSYSTEM.TMS100DBFLD ( TBSTNA VARCHAR(25) ,TBSLFD NUMERIC(5,0) ,TBSFNA VARCHAR(11) ,TBSFNR NUMERIC(11,0) ,TBSDAT DATE ,TBSERF VARCHAR(50) ,TBSTYP VARCHAR(50) ,TBSLEN NUMERIC(5,0) ,TBSPRE NUMERIC(5,0) ,TBSTMS NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS100DBFLD_PK PRIMARY KEY(TBSTNA,TBSLFD)   );
CREATE TABLE TMSYSTEM.TMS100TBS ( TBSTNA VARCHAR(15) ,TBSLFD NUMERIC(5,0) WITH DEFAULT 0,TBSFNA VARCHAR(9) ,TBSFNR NUMERIC(11,0) WITH DEFAULT 0,TBSAUS NUMERIC(11,0) WITH DEFAULT 0,TBSINI VARCHAR(50) ,TBSFNU VARCHAR(9) ,TBSBZG NUMERIC(5,0) WITH DEFAULT 1,TBSKEY NUMERIC(5,0) WITH DEFAULT 0,TBSIND NUMERIC(5,0) WITH DEFAULT 1,TBSMUS NUMERIC(1,0) WITH DEFAULT 0,TBSSTA NUMERIC(5,0) WITH DEFAULT 1,TBSDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TBSERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS100TBS_PK PRIMARY KEY(TBSTNA,TBSLFD) ,CONSTRAINT TMSYSTEM.TMS100TBS_UK UNIQUE (TBSFNA) );
CREATE TABLE TMSYSTEM.TMS102FTX ( FTXNUM NUMERIC(11,0) WITH DEFAULT 0,FTXTYP NUMERIC(5,0) WITH DEFAULT 1,FTXLAN NUMERIC(5,0) WITH DEFAULT 0,FTXDEZ NUMERIC(5,0) WITH DEFAULT 0,FTXSTA NUMERIC(5,0) WITH DEFAULT 1,FTXDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,FTXERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS102FTX_PK PRIMARY KEY(FTXNUM)   );
CREATE TABLE TMSYSTEM.TMS102TXT ( TEXNUMSPR NUMERIC(11,0) ,TEXWHL NUMERIC(5,0) ,TEXTXT NUMERIC(1,0) WITH DEFAULT 2,TEXDAT DATE WITH DEFAULT CURRENT_DATE,TEXERF VARCHAR(50) WITH DEFAULT 'Timesys',TEXSP2 NUMERIC(1,0) WITH DEFAULT 2,TEXSP3 NUMERIC(1,0) WITH DEFAULT 2,TEXSP4 NUMERIC(1,0) WITH DEFAULT 2,TEXSP5 NUMERIC(1,0) WITH DEFAULT 2,TEXSP6 NUMERIC(1,0) WITH DEFAULT 2,TEXSP7 NUMERIC(1,0) WITH DEFAULT 2,TEXSPR NUMERIC(5,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.TMS102TXT_PK PRIMARY KEY(TEXNUMSPR,TEXWHL,TEXSPR)   );
CREATE TABLE TMSYSTEM.TMS102WHL ( FTXNUMSPR NUMERIC(11,0) WITH DEFAULT 0,FTXWHL NUMERIC(5,0) WITH DEFAULT 0,FTXSPR NUMERIC(5,0) WITH DEFAULT 1,FTXT50 VARCHAR(120) ,FTXT30 VARCHAR(120) ,FTXT10 VARCHAR(10) ,FTXT05 VARCHAR(5) ,FTXMSK NUMERIC(5,0) WITH DEFAULT 1,FTXDOK VARCHAR(16000) ,FTXPRG VARCHAR(16000) ,FTXCLS VARCHAR(20) ,FTXSTASPR NUMERIC(5,0) WITH DEFAULT 1,FTXDATSPR TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,FTXERFSPR VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS102WHL_PK PRIMARY KEY(FTXNUMSPR,FTXWHL,FTXSPR)   );
CREATE TABLE TMSYSTEM.TMS103DMYANM ( DMYANM VARCHAR(50) ,DMYFRM VARCHAR(20) ,DMYFLD VARCHAR(9) ,DMYPOS NUMERIC(5,0) WITH DEFAULT 1,DMYSRT NUMERIC(5,0) WITH DEFAULT 0,DMYRIC VARCHAR(10)  ,CONSTRAINT TMSYSTEM.TMS103DMYANM_PK PRIMARY KEY(DMYANM,DMYFRM,DMYFLD)   );
CREATE TABLE TMSYSTEM.TMS103FRM ( FRMNAM VARCHAR(20) ,FRMLFD NUMERIC(5,0) WITH DEFAULT 0,FRMFLD VARCHAR(9) ,FRMBEA NUMERIC(5,0) WITH DEFAULT 5,FRMTXT NUMERIC(5,0) WITH DEFAULT 1,FRMBBR NUMERIC(11,0) WITH DEFAULT 5,FRMBXP NUMERIC(11,0) WITH DEFAULT 1,FRMBYP NUMERIC(11,0) WITH DEFAULT 1,FRMWBR NUMERIC(11,0) WITH DEFAULT 5,FRMWXP NUMERIC(11,0) WITH DEFAULT 1,FRMWYP NUMERIC(11,0) WITH DEFAULT 1,FRMAUF NUMERIC(5,0) WITH DEFAULT 1,FRMABF VARCHAR(15) ,FRMPOS NUMERIC(5,0) WITH DEFAULT 1,FRMCLS VARCHAR(20) ,FRMZRR NUMERIC(5,0) WITH DEFAULT 1,FRMFFO VARCHAR(15) ,FRMPRF NUMERIC(1,0) WITH DEFAULT 0,FRMBOX NUMERIC(5,0) WITH DEFAULT 0,FRMSTA NUMERIC(5,0) WITH DEFAULT 1,FRMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,FRMERF VARCHAR(50) WITH DEFAULT 'Timesys',FRMIDX NUMERIC(5,0) WITH DEFAULT 0 ,CONSTRAINT TMSYSTEM.TMS103FRM_PK PRIMARY KEY(FRMNAM,FRMLFD)   );
CREATE TABLE TMSYSTEM.TMS103FRMANM ( PFRANM VARCHAR(50) ,PFRFRM VARCHAR(20) ,PFRFLD VARCHAR(9) ,PFRPOS NUMERIC(5,0) WITH DEFAULT 1,PFRSTA NUMERIC(5,0) WITH DEFAULT 1,PFRDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,PFRERF VARCHAR(50) WITH DEFAULT 'Timesys',PFRSRT NUMERIC(5,0) WITH DEFAULT 0,PFRRIC VARCHAR(10) ,PFROST NUMERIC(5,0) ,PFRORI VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS103FRMANM_PK PRIMARY KEY(PFRANM,PFRFRM,PFRFLD)   );
CREATE TABLE TMSYSTEM.TMS103FRMRTR ( RTRNUM VARCHAR(20) ,RTRLFD NUMERIC(5,0) WITH DEFAULT 1,RTRFRM VARCHAR(20) ,RTRINC VARCHAR(60) ,RTRSTA NUMERIC(5,0) WITH DEFAULT 1,RTRDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,RTRERF VARCHAR(50) WITH DEFAULT 'Timesys',RTRFNK VARCHAR(50) ,RTRMOD NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.TMS103FRMRTR_PK PRIMARY KEY(RTRNUM,RTRLFD)   );
CREATE TABLE TMSYSTEM.TMS103FRMTXT ( FRMTXTFRM VARCHAR(20) ,FRMTXTBLK VARCHAR(50) ,FRMTXTFTX NUMERIC(11,0) ,FRMTXTWHL NUMERIC(9,0) ,FRMTXTLFD NUMERIC(5,0) ,FRMTXTART NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS103FRMTXT_PK PRIMARY KEY(FRMTXTFRM,FRMTXTBLK,FRMTXTFTX,FRMTXTWHL)   );
CREATE TABLE TMSYSTEM.TMS104WEB ( WEBANM VARCHAR(50) ,WEBLIZ VARCHAR(5) ,WEBMND VARCHAR(5) ,WEBPNR VARCHAR(8) ,WEBMRT VARCHAR(15) ,WEBMEN VARCHAR(15) ,WEBPRT VARCHAR(15) ,WEBZUG NUMERIC(5,0) WITH DEFAULT 1,WEBSRT VARCHAR(15) ,WEBDYN NUMERIC(1,0) ,WEBFRT VARCHAR(15) ,WEBBEA NUMERIC(11,0) WITH DEFAULT 1,WEBPIN NUMERIC(1,0) ,WEBFRM VARCHAR(20) ,WEBZRR NUMERIC(5,0) WITH DEFAULT 1,WEBSPR NUMERIC(5,0) WITH DEFAULT 1,WEBPGR NUMERIC(5,0) WITH DEFAULT 1,WEBVGR VARCHAR(15) ,WEBGRV VARCHAR(15) ,WEBGRB VARCHAR(15) ,WEBZTR NUMERIC(11,0) WITH DEFAULT 1,WEBKPR NUMERIC(5,0) WITH DEFAULT 1,WEBBAS NUMERIC(11,0) WITH DEFAULT 1,WEBVON DATE ,WEBBIS DATE ,WEBUIP VARCHAR(40) ,WEBDSU NUMERIC(5,0) WITH DEFAULT 1,WEBDSS NUMERIC(5,0) WITH DEFAULT 1,WEBSTA NUMERIC(5,0) WITH DEFAULT 1,WEBDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,WEBERF VARCHAR(50) WITH DEFAULT 'Timesys',WEBTMP VARCHAR(10) ,WEBFRE VARCHAR(15)  ,CONSTRAINT TMSYSTEM.TMS104WEB_PK PRIMARY KEY(WEBANM,WEBLIZ,WEBMND)   );
CREATE TABLE TMSYSTEM.TMS106TYP ( TYPTYP VARCHAR(5) ,TYPBES VARCHAR(20) ,TYPSTA NUMERIC(5,0) WITH DEFAULT 1,TYPDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TYPERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS106TYP_PK PRIMARY KEY(TYPTYP)   );
CREATE TABLE TMSYSTEM.TMS107KKR ( KKRNUM VARCHAR(50) ,KKRBEZ VARCHAR(50) ,KKRSTA NUMERIC(5,0) WITH DEFAULT 1,KKRDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,KKRERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS107KKR_PK PRIMARY KEY(KKRNUM)   );
CREATE TABLE TMSYSTEM.TMS107KKZ ( KKZKKR VARCHAR(50) ,KKZMND VARCHAR(5) ,KKZLIZ VARCHAR(5) ,KKZSTA NUMERIC(5,0) WITH DEFAULT 1,KKZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,KKZERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS107KKZ_PK PRIMARY KEY(KKZKKR,KKZMND,KKZLIZ)   );
CREATE TABLE TMSYSTEM.TMS107KSB ( KSBLIZ VARCHAR(5) ,KSBMND VARCHAR(5) ,KSBNAM VARCHAR(50) ,KSBSTA NUMERIC(5,0) ,KSBDAT TIMESTAMP ,KSBERF VARCHAR(50) ,KSBHOM NUMERIC(1,0) ,KSBNA2 VARCHAR(70) ,KSBKON NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS107KSB_PK PRIMARY KEY(KSBLIZ,KSBMND,KSBNAM)   );
CREATE TABLE TMSYSTEM.TMS107MAW ( MAWANM VARCHAR(50) ,MAWMND VARCHAR(5) ,MAWLIZ VARCHAR(5) ,MAWFLD VARCHAR(9) ,MAWKEY VARCHAR(50)      );
CREATE TABLE TMSYSTEM.TMS108PWA ( PWANUM VARCHAR(10) ,PWAAZT NUMERIC(1,0) ,PWALKW NUMERIC(1,0) ,PWADTA NUMERIC(3,0) ,PWADAZ NUMERIC(3,0) ,PWASTA NUMERIC(5,0) WITH DEFAULT 1,PWADAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,PWAERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS108PWA_PK PRIMARY KEY(PWANUM)   );
CREATE TABLE TMSYSTEM.TMS108PWC ( PWCANM VARCHAR(50) ,PWCLIZ VARCHAR(5) ,PWCMND VARCHAR(5) ,PWCNUM NUMERIC(5,0) ,PWCPSW VARCHAR(60) ,PWCSTA NUMERIC(11,0) WITH DEFAULT 1,PWCDAT DATE WITH DEFAULT CURRENT_DATE,PWCERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS108PWC_PK PRIMARY KEY(PWCANM,PWCLIZ,PWCMND,PWCNUM)   );
CREATE TABLE TMSYSTEM.TMS109INS ( INSPRD VARCHAR(10) ,INSLIZ NUMERIC(5,0) ,INSSTO NUMERIC(5,0) ,INSIDT DATE ,INSADT DATE ,INSMDT DATE ,INSCSM VARCHAR(32) ,INSDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS109INS_PK PRIMARY KEY(INSPRD)   );
CREATE TABLE TMSYSTEM.TMS110LIZ ( LIZLIZ VARCHAR(5) ,LIZMND VARCHAR(5) ,LIZPRD VARCHAR(50) ,LIZVER VARCHAR(10) ,LIZPNR NUMERIC(11,0) WITH DEFAULT 0,LIZIBG DATE ,LIZWBG DATE ,LIZEND DATE ,LIZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,LIZERF VARCHAR(50) WITH DEFAULT 'Timesys',LIZVVU VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS110LIZ_PK PRIMARY KEY(LIZLIZ,LIZMND,LIZPRD)   );
CREATE TABLE TMSYSTEM.TMS110TTB ( TTBNAM VARCHAR(10) ,TTBTXT VARCHAR(30) ,TTBKTX VARCHAR(10) ,TTBSTA NUMERIC(5,0) WITH DEFAULT 1,TTBERF VARCHAR(50) WITH DEFAULT 'Timesys',TTBART NUMERIC(2,0) ,TTBTAS NUMERIC(1,0) ,TTBTTP VARCHAR(10) ,TTBFST NUMERIC(1,0) ,TTBONM VARCHAR(10) ,TTBOTX VARCHAR(30) ,TTBDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTBTXN NUMERIC(3,0) WITH DEFAULT 0,TTBLIZ VARCHAR(5) ,TTBMND VARCHAR(5) ,TTBDIM VARCHAR(10)  ,CONSTRAINT TMSYSTEM.TMS110TTB_PK PRIMARY KEY(TTBNAM,TTBLIZ,TTBMND)   );
CREATE TABLE TMSYSTEM.TMS111ANM ( ANMANM VARCHAR(50) WITH DEFAULT 'Timesys',ANMLIZ VARCHAR(5) ,ANMMND VARCHAR(5) WITH DEFAULT '0',ANMPSW VARCHAR(60) ,ANMVON DATE ,ANMDLA DATE ,ANMPNR VARCHAR(8) WITH DEFAULT 'Timesys',ANMAGB DATE ,ANMATG NUMERIC(5,0) WITH DEFAULT 60,ANMWAR NUMERIC(5,0) WITH DEFAULT 14,ANMNUM NUMERIC(5,0) WITH DEFAULT 0,ANMMIN NUMERIC(5,0) WITH DEFAULT 5,ANMANZ NUMERIC(5,0) WITH DEFAULT 1,ANMAUT NUMERIC(1,0) ,ANMSTA NUMERIC(11,0) WITH DEFAULT 1,ANMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ANMERF VARCHAR(50) WITH DEFAULT 'Timesys',ANMMSG VARCHAR(20)  ,CONSTRAINT TMSYSTEM.TMS111ANM_PK PRIMARY KEY(ANMANM,ANMLIZ,ANMMND)   );
CREATE TABLE TMSYSTEM.TMS111TFK ( TFKTTT VARCHAR(10) ,TFKTNM NUMERIC(5,0) ,TFKWTG NUMERIC(1,0) ,TFKV01 NUMERIC(4,0) ,TFKB01 NUMERIC(4,0) ,TFKV02 NUMERIC(4,0) ,TFKB02 NUMERIC(4,0) ,TFKV03 NUMERIC(4,0) ,TFKB03 NUMERIC(4,0) ,TFKV04 NUMERIC(4,0) ,TFKB04 NUMERIC(4,0) ,TFKV05 NUMERIC(4,0) ,TFKB05 NUMERIC(4,0) ,TFKV06 NUMERIC(4,0) ,TFKB06 NUMERIC(4,0) ,TFKV07 NUMERIC(4,0) ,TFKB07 NUMERIC(4,0) ,TFKV08 NUMERIC(4,0) ,TFKB08 NUMERIC(4,0) ,TFKV09 NUMERIC(4,0) ,TFKB09 NUMERIC(4,0) ,TFKV10 NUMERIC(4,0) ,TFKB10 NUMERIC(4,0) ,TFKV11 NUMERIC(4,0) ,TFKB11 NUMERIC(4,0) ,TFKV12 NUMERIC(4,0) ,TFKB12 NUMERIC(4,0) ,TFKERF VARCHAR(50) ,TFKDAT VARCHAR(14) ,TFKLIZ VARCHAR(5) ,TFKMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS111TFK_PK PRIMARY KEY(TFKTTT,TFKTNM,TFKWTG,TFKLIZ,TFKMND)   );
CREATE TABLE TMSYSTEM.TMS112MND ( MNDLIZ VARCHAR(5) ,MNDNUM VARCHAR(5) ,MNDSTO VARCHAR(5) ,MNDVWS VARCHAR(5) ,MNDNA1 VARCHAR(50) ,MNDNA2 VARCHAR(50) ,MNDSTR VARCHAR(50) ,MNDPLZ VARCHAR(10) ,MNDORT VARCHAR(50) ,MNDEML VARCHAR(50) ,MNDHMD VARCHAR(5) ,MNDKAL NUMERIC(1,0) ,MNDFCD NUMERIC(1,0) ,MNDTRM NUMERIC(1,0) ,MNDORG NUMERIC(1,0) ,MNDVON DATE ,MNDBIS DATE ,MNDSTA NUMERIC(5,0) WITH DEFAULT 1,MNDDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,MNDERF VARCHAR(50) WITH DEFAULT 'Timesys',MNDSCH VARCHAR(20) ,MNDKON NUMERIC(1,0) WITH DEFAULT 0,MNDZKT NUMERIC(1,0) ,MNDBIV NUMERIC(1,0) WITH DEFAULT 0,MNDSOZ NUMERIC(1,0) ,MNDSRE NUMERIC(1,0) ,MNDAPZ DATE WITH DEFAULT CURRENT_DATE,MNDAZU DATE WITH DEFAULT CURRENT_DATE,MNDAMP DATE WITH DEFAULT CURRENT_DATE,MNDLKZ NUMERIC(2,0) ,MNDLDA NUMERIC(1,0) WITH DEFAULT 0,MNDGMV NUMERIC(2,0) ,MNDGMB NUMERIC(2,0) ,MNDKND VARCHAR(200) ,MNDDIC NUMERIC(1,0) ,MNDBNR NUMERIC(8,0) ,MNDMAB NUMERIC(1,0) ,MNDMAD DATE ,MNDST2 VARCHAR(5) ,MNDABS NUMERIC(1,0) WITH DEFAULT 1,MNDMAP NUMERIC(1,0) ,MNDTGB NUMERIC(5,0) ,MNDT01 NUMERIC(5,0) ,MNDT02 NUMERIC(5,0) ,MNDT03 NUMERIC(5,0) ,MNDT04 NUMERIC(5,0) ,MNDT05 NUMERIC(5,0) ,MNDT06 NUMERIC(5,0) ,MNDT07 NUMERIC(5,0) ,MNDT08 NUMERIC(5,0) ,MNDT09 NUMERIC(5,0) ,MNDT10 NUMERIC(5,0) ,MNDT11 NUMERIC(5,0) ,MNDT12 NUMERIC(5,0) ,MNDDWN NUMERIC(5,0) ,MNDD01 NUMERIC(5,0) ,MNDD02 NUMERIC(5,0) ,MNDD03 NUMERIC(5,0) ,MNDD04 NUMERIC(5,0) ,MNDD05 NUMERIC(5,0) ,MNDD06 NUMERIC(5,0) ,MNDD07 NUMERIC(5,0) ,MNDD08 NUMERIC(5,0) ,MNDD09 NUMERIC(5,0) ,MNDD10 NUMERIC(5,0) ,MNDD11 NUMERIC(5,0) ,MNDD12 NUMERIC(5,0) ,MNDATG NUMERIC(11,0) ,MNDAAN NUMERIC(2,0) ,MNDZZO NUMERIC(4,0) WITH DEFAULT 0,MNDPWG NUMERIC(3,0) ,MNDZUK VARCHAR(8) ,MNDFAR NUMERIC(3,0) WITH DEFAULT 1,MNDIAG NUMERIC(3,0) WITH DEFAULT 14,MNDAVZ NUMERIC(3,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.TMS112MND_PK PRIMARY KEY(MNDLIZ,MNDNUM)   );
CREATE TABLE TMSYSTEM.TMS112TMD ( TMDLIZ VARCHAR(5) ,TMDNUM VARCHAR(5) ,TMDNAM VARCHAR(50) ,TMDSTA NUMERIC(5,0) WITH DEFAULT 1,TMDDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TMDERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS112TMD_PK PRIMARY KEY(TMDLIZ,TMDNUM)   );
CREATE TABLE TMSYSTEM.TMS112TTA ( TTANUM VARCHAR(10) ,TTATYP VARCHAR(10) ,TTAMNU NUMERIC(1,0) ,TTATAS NUMERIC(5,0) ,TTABCH VARCHAR(3) ,TTAPOS NUMERIC(2,0) ,TTATXT VARCHAR(30) ,TTADNC NUMERIC(5,0) ,TTAFTP NUMERIC(5,0) ,TTADAT VARCHAR(14) ,TTAERF VARCHAR(50) WITH DEFAULT 'Timesys',TTAF01 NUMERIC(1,0) ,TTAF02 NUMERIC(1,0) ,TTAF03 NUMERIC(1,0) ,TTAF04 NUMERIC(1,0) ,TTAF05 NUMERIC(1,0) ,TTAF06 NUMERIC(1,0) ,TTAF07 NUMERIC(1,0) ,TTAF08 NUMERIC(1,0) ,TTAF09 NUMERIC(1,0) ,TTAF10 NUMERIC(1,0) ,TTAF11 NUMERIC(1,0) ,TTAF12 NUMERIC(1,0) ,TTAFCD VARCHAR(3) ,TTAAPS NUMERIC(2,0) ,TTATAV NUMERIC(1,0) ,TTALIZ VARCHAR(5) ,TTAMND VARCHAR(5) ,TTAIMG VARCHAR(50) ,TTABEZ VARCHAR(30)  ,CONSTRAINT TMSYSTEM.TMS112TTA_PK PRIMARY KEY(TTANUM,TTATYP,TTAMNU,TTATAS,TTAPOS,TTALIZ,TTAMND)   );
CREATE TABLE TMSYSTEM.TMS113AWV ( AWVNUM VARCHAR(50) ,AWVCOD NUMERIC(5,0) WITH DEFAULT 0,AWVSTO VARCHAR(8) ,AWVSTA NUMERIC(5,0) WITH DEFAULT 1,AWVDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,AWVERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS113AWV_PK PRIMARY KEY(AWVNUM)   );
CREATE TABLE TMSYSTEM.TMS113STO ( STONUM VARCHAR(8) ,STOSCH VARCHAR(16) ,STOTXT VARCHAR(50) ,STOKTX VARCHAR(10) ,STOSTA NUMERIC(5,0) WITH DEFAULT 1,STODAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,STOERF VARCHAR(50) WITH DEFAULT 'Timesys',STOMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS113STO_PK PRIMARY KEY(STONUM)   );
CREATE TABLE TMSYSTEM.TMS114TKD ( TKDNAM VARCHAR(255) ,TKDTST VARCHAR(15) ,TKDHER VARCHAR(30) ,TKDART VARCHAR(30) ,TKDSNR VARCHAR(10) ,TKDINT NUMERIC(2,0) ,TKDLDT DATE ,TKDGAR DATE ,TKDWAR VARCHAR(30) ,TKDEND DATE ,TKDSTO VARCHAR(50) ,TKDINV VARCHAR(6) ,TKDKST VARCHAR(10) ,TKDLIE VARCHAR(30) ,TKDLNR VARCHAR(10) ,TKDKAN VARCHAR(30) ,TKDKTL VARCHAR(15) ,TKDTAN VARCHAR(30) ,TKDTTL VARCHAR(15) ,TKDTYP NUMERIC(5,0) WITH DEFAULT 0,TKDEML VARCHAR(50) ,TKDSTA NUMERIC(5,0) WITH DEFAULT 1,TKDDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TKDERF VARCHAR(50) WITH DEFAULT 'Timesys',TKDLIZ VARCHAR(5) ,TKDMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS114TKD_PK PRIMARY KEY(TKDNAM)   );
CREATE TABLE TMSYSTEM.TMS114TSM ( TSMNAM VARCHAR(255) ,TSMACS NUMERIC(1,0) WITH DEFAULT 0,TSMTYP VARCHAR(10) ,TSMTAS VARCHAR(10) ,TSMSAL VARCHAR(10) ,TSMUPL VARCHAR(10) ,TSMDNL VARCHAR(10) ,TSMSTO VARCHAR(30) ,TSMTXT VARCHAR(50) ,TSMKTX VARCHAR(10) ,TSMSTA NUMERIC(5,0) WITH DEFAULT 1,TSMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TSMERF VARCHAR(50) WITH DEFAULT 'Timesys',TSMKSW NUMERIC(1,0) WITH DEFAULT 0,TSMSPR NUMERIC(1,0) WITH DEFAULT 1,TSMMMD NUMERIC(1,0) WITH DEFAULT 1,TSMCTP NUMERIC(2,0)  ,CONSTRAINT TMSYSTEM.TMS114TSM_PK PRIMARY KEY(TSMNAM)   );
CREATE TABLE TMSYSTEM.TMS1140COM ( COMNAM VARCHAR(255) ,COMIPA VARCHAR(15) ,COMGAT VARCHAR(15) ,COMSHS VARCHAR(15) ,COMEHS VARCHAR(15) ,COMGHS VARCHAR(15) ,COMSTP VARCHAR(4) ,COMEVP VARCHAR(4) ,COMTMP VARCHAR(4) ,COMSUB VARCHAR(15) ,COMTWX VARCHAR(10) ,COMPOR VARCHAR(1) ,COMSCH VARCHAR(1) ,COMSTO VARCHAR(2) ,COMTER NUMERIC(1,0) WITH DEFAULT 0,COMPRO VARCHAR(5) ,COMLKN VARCHAR(5) ,COMVOR VARCHAR(10) ,COMTEL VARCHAR(20) ,COMDWL VARCHAR(10) ,COMGID VARCHAR(10) ,COMPRT VARCHAR(4) ,COMLER NUMERIC(5,0) WITH DEFAULT 0,COMWIE NUMERIC(5,0) WITH DEFAULT 0,COMANZ NUMERIC(5,0) WITH DEFAULT 0,COMSTA NUMERIC(5,0) WITH DEFAULT 8,COMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,COMERF VARCHAR(50) WITH DEFAULT 'Timesys',COMAMT VARCHAR(5) ,COMEAT VARCHAR(5) ,COMLIZ VARCHAR(5) ,COMMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS1140COM_PK PRIMARY KEY(COMNAM)   );
CREATE TABLE TMSYSTEM.TMS1140SLT ( SLTTRM VARCHAR(255) ,SLTNUM NUMERIC(3,0) ,SLTTYP NUMERIC(2,0) ,SLTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,SLTERF VARCHAR(50) WITH DEFAULT 'Timesys',SLTTXT VARCHAR(50) ,SLTSTA NUMERIC(1,0) WITH DEFAULT 1,SLTKTX VARCHAR(11) ,SLTTXL VARCHAR(255) ,SLTLIZ VARCHAR(5) ,SLTMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS1140SLT_PK PRIMARY KEY(SLTTRM,SLTNUM)   );
CREATE TABLE TMSYSTEM.TMS1140STS ( STSNAM VARCHAR(10) ,STSKOM VARCHAR(50) ,STSSTS VARCHAR(50) ,STSDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS1140STS_PK PRIMARY KEY(STSNAM,STSKOM)   );
CREATE TABLE TMSYSTEM.TMS1140TRM ( TRMNAM VARCHAR(255) ,TRMTAS VARCHAR(10) ,TRMSAL VARCHAR(10) ,TRMUPL VARCHAR(10) ,TRMDNL VARCHAR(10) ,TRMSPR NUMERIC(5,0) WITH DEFAULT 0,TRMDTM NUMERIC(5,0) WITH DEFAULT 0,TRMAPP VARCHAR(200) ,TRMLOG VARCHAR(200) ,TRMPRA VARCHAR(200) ,TRMSYN NUMERIC(1,0) ,TRMTON NUMERIC(5,0) WITH DEFAULT 0,TRMDAU NUMERIC(5,0) WITH DEFAULT 0,TRMLST NUMERIC(5,0) WITH DEFAULT 50,TRMHST NUMERIC(5,0) WITH DEFAULT 0,TRMALF NUMERIC(5,0) WITH DEFAULT 0,TRMSTO VARCHAR(30) ,TRMTXT VARCHAR(50) ,TRMKTX VARCHAR(10) ,TRMSTA NUMERIC(5,0) WITH DEFAULT 1,TRMDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TRMERF VARCHAR(50) WITH DEFAULT 'Timesys',TRMINT NUMERIC(5,0) WITH DEFAULT 1,TRMMOD VARCHAR(8) WITH DEFAULT NULL,TRMFNK NUMERIC(1,0) ,TRMDIS NUMERIC(1,0) ,TRMQTP NUMERIC(5,0) ,TRMWTG NUMERIC(1,0) WITH DEFAULT 1,TRMPRO NUMERIC(2,0) WITH DEFAULT 99,TRMDAC NUMERIC(1,0) ,TRMDTP NUMERIC(2,0) ,TRMDNM VARCHAR(255) ,TRMDPG NUMERIC(3,0) ,TRMDST NUMERIC(10,0) ,TRMANZ NUMERIC(1,0) ,TRMSEI NUMERIC(2,0) ,TRMSPA NUMERIC(2,0) ,TRMZEI NUMERIC(2,0) ,TRMPLA VARCHAR(25) ,TRMKSW NUMERIC(1,0) ,TRMTWC VARCHAR(10) ,TRMTWP VARCHAR(6) ,TRMTWA VARCHAR(6) ,TRMTWL VARCHAR(6) ,TRMIPA VARCHAR(15) ,TRMIPS VARCHAR(15) ,TRMIPG VARCHAR(15) ,TRMIPH VARCHAR(15) ,TRMIPK VARCHAR(15) ,TRMIPT NUMERIC(5,0) ,TRMIPE NUMERIC(5,0) ,TRMISA VARCHAR(5) ,TRMISQ NUMERIC(5,0) ,TRMISR VARCHAR(30) ,TRMISL NUMERIC(3,0) ,TRMIST VARCHAR(32) ,TRMISM VARCHAR(5) ,TRMTST NUMERIC(1,0) ,TRMDTO VARCHAR(14) ,TRMDTD VARCHAR(14) ,TRMDBE VARCHAR(50) ,TRMDTU VARCHAR(14) ,TRMCTP VARCHAR(10) ,TRMUBE VARCHAR(50) ,TRMINC VARCHAR(5) ,TRMLIZ VARCHAR(5) ,TRMMND VARCHAR(5) ,TRMDPL VARCHAR(10) ,TRMEFB VARCHAR(10)  ,CONSTRAINT TMSYSTEM.TMS1140TRM_PK PRIMARY KEY(TRMNAM,TRMLIZ,TRMMND)   );
CREATE TABLE TMSYSTEM.TMS115TFZ ( TFZTRM VARCHAR(255) ,TFZLIZ VARCHAR(5) ,TFZMND VARCHAR(5) ,TFZSTA NUMERIC(1,0) WITH DEFAULT 1,TFZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TFZERF VARCHAR(50) WITH DEFAULT 'TIMESYS' ,CONSTRAINT TMSYSTEM.TMS115TFZ_PK PRIMARY KEY(TFZTRM,TFZLIZ,TFZMND)   );
CREATE TABLE TMSYSTEM.TMS116MSG ( MSGLFD NUMERIC(10,0) ,MSGLIZ VARCHAR(5) ,MSGMND VARCHAR(2) ,MSGUSR VARCHAR(50) ,MSGHDR VARCHAR(160) ,MSGMOD VARCHAR(3) ,MSGBDY VARCHAR(500) ,MSGSDT DATE ,MSGSTM DATE ,MSGFRM VARCHAR(50) ,MSGEML VARCHAR(75) ,MSGSMS NUMERIC(15,0) ,MSGKEM NUMERIC(1,0) WITH DEFAULT 0,MSGKSM NUMERIC(1,0) WITH DEFAULT 0,MSGKTB NUMERIC(1,0) WITH DEFAULT 1,MSGLNK VARCHAR(255) ,MSGNEW NUMERIC(1,0) WITH DEFAULT 1,MSGNTY DATE  ,CONSTRAINT TMSYSTEM.TMS116MSG_PK PRIMARY KEY(MSGLFD,MSGLIZ,MSGMND,MSGUSR)   );
CREATE TABLE TMSYSTEM.TMS119MSD ( MSDSAL VARCHAR(10) ,MSDLFD NUMERIC(5,0) WITH DEFAULT 0,MSDANZ NUMERIC(5,0) WITH DEFAULT 0,MSDWRT NUMERIC(5,0) WITH DEFAULT 0,MSDSTA NUMERIC(5,0) WITH DEFAULT 1,MSDDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,MSDERF VARCHAR(50) WITH DEFAULT 'TIMESYS',MSDSPL NUMERIC(2,0) WITH DEFAULT 1,MSDTXT VARCHAR(30) ,MSDUVW NUMERIC(3,0) ,MSDLIZ VARCHAR(5) ,MSDMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS119MSD_PK PRIMARY KEY(MSDSAL,MSDLFD,MSDLIZ,MSDMND)   );
CREATE TABLE TMSYSTEM.TMS119MST ( MSTNAM VARCHAR(10) ,MSTTTP VARCHAR(10) ,MSTDAU NUMERIC(5,0) WITH DEFAULT 0,MSTTXT VARCHAR(30) ,MSTSTA NUMERIC(5,0) WITH DEFAULT 1,MSTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,MSTERF VARCHAR(50) WITH DEFAULT 'TIMESYS',MSTTXN NUMERIC(3,0) WITH DEFAULT 0,MSTLIZ VARCHAR(5) ,MSTMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS119MST_PK PRIMARY KEY(MSTNAM,MSTLIZ,MSTMND)   );
CREATE TABLE TMSYSTEM.TMS120KID ( KIDKST VARCHAR(30) ,KIDMND VARCHAR(5) ,KIDLIZ VARCHAR(5) ,KIDNUM NUMERIC(7,0) ,KIDSYS VARCHAR(7) ,KIDTXT VARCHAR(30) ,KIDFNM VARCHAR(50) ,KIDSTA NUMERIC(5,0) ,KIDERF VARCHAR(50) ,KIDDAT DATE WITH DEFAULT CURRENT_DATE ,CONSTRAINT TMSYSTEM.TMS120KID_PK PRIMARY KEY(KIDKST,KIDMND,KIDLIZ)   );
CREATE TABLE TMSYSTEM.TMS121QUA ( QUAQUA VARCHAR(30) ,QUAMND VARCHAR(5) ,QUALIZ VARCHAR(5) ,QUANUM NUMERIC(3,0) ,QUASYS VARCHAR(7) ,QUATXT VARCHAR(30) ,QUASTA NUMERIC(5,0) ,QUAERF VARCHAR(50) ,QUADAT DATE WITH DEFAULT CURRENT_DATE ,CONSTRAINT TMSYSTEM.TMS121QUA_PK PRIMARY KEY(QUAQUA,QUAMND,QUALIZ)   );
CREATE TABLE TMSYSTEM.TMS122DIC ( DICKEY VARCHAR(64) ,DICFNA VARCHAR(9) ,DICTNA VARCHAR(20) ,DICFNK VARCHAR(50) ,DICFNR NUMERIC(11,0) ,DICWHL NUMERIC(5,0) ,DICSTS NUMERIC(5,0) WITH DEFAULT 1,DICDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,DICERF VARCHAR(50) WITH DEFAULT 'TIMESYS' ,CONSTRAINT TMSYSTEM.TMS122DIC_PK PRIMARY KEY(DICKEY,DICFNA)   );
CREATE TABLE TMSYSTEM.TMS122DI2 ( DI2KEY VARCHAR(64) ,DI2FNA VARCHAR(9) ,DI2SPR NUMERIC(5,0) ,DI2TXT VARCHAR(120) ,DI2STS NUMERIC(5,0) WITH DEFAULT 1,DI2DAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,DI2ERF VARCHAR(50) WITH DEFAULT 'TIMESYS' ,CONSTRAINT TMSYSTEM.TMS122DI2_PK PRIMARY KEY(DI2KEY,DI2FNA,DI2SPR)   );
CREATE TABLE TMSYSTEM.TMS132TTP ( TTPNUM VARCHAR(3) ,TTPKRT VARCHAR(2) ,TTPTXT VARCHAR(50) ,TTPKTX VARCHAR(10) ,TTPSTA NUMERIC(11,0) WITH DEFAULT 1,TTPDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TTPERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS132TTP_PK PRIMARY KEY(TTPNUM)   );
CREATE TABLE TMSYSTEM.TMS133BAK ( BAKDTM DATE ,BAKJHR NUMERIC(5,0) WITH DEFAULT 0,BAKMON NUMERIC(5,0) WITH DEFAULT 0,BAKTAG NUMERIC(5,0) WITH DEFAULT 0,BAKWCH NUMERIC(5,0) WITH DEFAULT 0,BAKWTG NUMERIC(5,0) WITH DEFAULT 0,BAKJTG NUMERIC(5,0) WITH DEFAULT 0,BAKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,BAKERF VARCHAR(50) WITH DEFAULT 'Timesys',BAKYOW NUMERIC(4,0) ,BAKCSM VARCHAR(32) ,BAKSTA NUMERIC(5,0) WITH DEFAULT 1,BAKQUA NUMERIC(1,0) ,BAKHJH NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS133BAK_PK PRIMARY KEY(BAKDTM)   );
CREATE TABLE TMSYSTEM.TMS133KAL ( KALNUM VARCHAR(3) ,KALDTM DATE ,KALTTP VARCHAR(3) ,KALTXT VARCHAR(50) ,KALDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,KALERF VARCHAR(50) WITH DEFAULT 'Timesys',KALPTP VARCHAR(3) ,KALGWT NUMERIC(3,0) ,KALBTP VARCHAR(3) ,KALCSM VARCHAR(32) ,KALSTA NUMERIC(5,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.TMS133KAL_PK PRIMARY KEY(KALNUM,KALDTM)   );
CREATE TABLE TMSYSTEM.TMS133PKZ ( PKZLKZ NUMERIC(2,0) ,PKZPLZ VARCHAR(10) ,PKZORT VARCHAR(50) ,PKZBLD VARCHAR(50) ,PKZKAL VARCHAR(3)  ,CONSTRAINT TMSYSTEM.TMS133PKZ_PK PRIMARY KEY(PKZLKZ,PKZPLZ,PKZORT)   );
CREATE TABLE TMSYSTEM.TMS135MUW ( MUWKAL VARCHAR(3) ,MUWTXT VARCHAR(50) ,MUWKTX VARCHAR(10) ,MUWSTA NUMERIC(5,0) WITH DEFAULT 1,MUWDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,MUWERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS135MUW_PK PRIMARY KEY(MUWKAL)   );
CREATE TABLE TMSYSTEM.TMS137WC2 ( WC2KAL VARCHAR(3) ,WC2TAG NUMERIC(5,0) WITH DEFAULT 0,WC2TTP VARCHAR(3) WITH DEFAULT '01',WC2STA NUMERIC(5,0) WITH DEFAULT 1,WC2DAT DATE WITH DEFAULT CURRENT_DATE,WC2ERF VARCHAR(50) WITH DEFAULT 'Timesys',WC2PTP VARCHAR(3)  ,CONSTRAINT TMSYSTEM.TMS137WC2_PK PRIMARY KEY(WC2KAL,WC2TAG)   );
CREATE TABLE TMSYSTEM.TMS138ZPL ( ZPLNUM VARCHAR(10) ,ZPLTXT VARCHAR(50) ,ZPLMND VARCHAR(5) ,ZPLLIZ VARCHAR(5) ,ZPLMON NUMERIC(5,0) ,ZPLDIN NUMERIC(5,0) ,ZPLMIT NUMERIC(5,0) ,ZPLDON NUMERIC(5,0) ,ZPLFRE NUMERIC(5,0) ,ZPLSAM NUMERIC(5,0) ,ZPLSON NUMERIC(5,0) ,ZPLWOC VARCHAR(30) ,ZPLSTA NUMERIC(5,0) ,ZPLERF VARCHAR(50) ,ZPLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS138ZPL_PK PRIMARY KEY(ZPLNUM,ZPLMND,ZPLLIZ)   );
CREATE TABLE TMSYSTEM.TMS139TPL ( TPLZPL VARCHAR(10) ,TPLNUM VARCHAR(10) ,TPLWTG NUMERIC(3,0) ,TPLTXT VARCHAR(50) ,TPLVON NUMERIC(5,0) ,TPLBIS NUMERIC(5,0) ,TPLVRZ NUMERIC(5,0) ,TPLRE1 NUMERIC(5,0) ,TPLRE2 NUMERIC(5,0) ,TPLRE3 NUMERIC(5,0) ,TPLSTA NUMERIC(5,0) ,TPLERF VARCHAR(50) ,TPLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TPLLIZ VARCHAR(5) ,TPLMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS139TPL_PK PRIMARY KEY(TPLZPL,TPLNUM,TPLWTG,TPLVON,TPLLIZ,TPLMND)   );
CREATE TABLE TMSYSTEM.TMS140DPL ( DPLLIZ VARCHAR(5) ,DPLMND VARCHAR(5) ,DPLNUM VARCHAR(10) ,DPLTXT VARCHAR(50) ,DPLMON NUMERIC(5,0) ,DPLDIN NUMERIC(5,0) ,DPLMIT NUMERIC(5,0) ,DPLDON NUMERIC(5,0) ,DPLFRE NUMERIC(5,0) ,DPLSAM NUMERIC(5,0) ,DPLSON NUMERIC(5,0) ,DPLWOC VARCHAR(30) ,DPLSTA NUMERIC(5,0) ,DPLERF VARCHAR(50) ,DPLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS140DPL_PK PRIMARY KEY(DPLLIZ,DPLMND,DPLNUM)   );
CREATE TABLE TMSYSTEM.TMS141DZT ( DZTLIZ VARCHAR(5) ,DZTMND VARCHAR(5) ,DZTZPL VARCHAR(10) ,DZTNUM VARCHAR(10) ,DZTWTG NUMERIC(3,0) ,DZTTXT VARCHAR(50) ,DZTVON NUMERIC(5,0) ,DZTBIS NUMERIC(5,0) ,DZTVRZ NUMERIC(5,0) ,DZTRE1 NUMERIC(5,0) ,DZTRE2 NUMERIC(5,0) ,DZTRE3 NUMERIC(5,0) ,DZTSTA NUMERIC(5,0) ,DZTERF VARCHAR(50) ,DZTDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS141DZT_PK PRIMARY KEY(DZTLIZ,DZTMND,DZTZPL,DZTNUM,DZTWTG,DZTVON)   );
CREATE TABLE TMSYSTEM.TMS200ACK ( ACKMSG VARCHAR(50) ,ACKANM VARCHAR(50) ,ACKMND VARCHAR(5) ,ACKLIZ VARCHAR(5) ,ACKACK VARCHAR(20) ,ACKDSP VARCHAR(20) ,ACKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS200ACK_PK PRIMARY KEY(ACKMSG,ACKANM,ACKMND,ACKLIZ)   );
CREATE TABLE TMSYSTEM.TMS200MSG ( MSGUID VARCHAR(50) ,MSGTNR NUMERIC(5,0) ,MSGTXT VARCHAR(250) ,MSGLNK VARCHAR(250) ,MSGMOD VARCHAR(50) ,MSGSRC VARCHAR(50) ,MSGSCH VARCHAR(20) ,MSGCAT VARCHAR(25) ,MSGADR VARCHAR(10) ,MSGBER VARCHAR(10) ,MSGPRI NUMERIC(5,0) ,MSGTYP VARCHAR(5) ,MSGBRK VARCHAR(5) ,MSGVAL NUMERIC(5,0) ,MSGDBG VARCHAR(1024) ,MSGMND VARCHAR(5) ,MSGLIZ VARCHAR(5) ,MSGTIN VARCHAR(20) ,MSGSTS NUMERIC(5,0) ,MSGERF VARCHAR(50) ,MSGUSR VARCHAR(50) ,MSGDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP ,CONSTRAINT TMSYSTEM.TMS200MSG_PK PRIMARY KEY(MSGUID)   );
CREATE TABLE TMSYSTEM.TMS230RMA ( RMAANM VARCHAR(50) ,RMANUM NUMERIC(11,0) WITH DEFAULT 0,RMAWHL NUMERIC(5,0) WITH DEFAULT 0,RMAMSK VARCHAR(20) ,RMADAT VARCHAR(8) ,RMAANZ NUMERIC(5,0) ,RMAABA NUMERIC(5,0) ,RMASCN NUMERIC(3,0) ,RMAICN NUMERIC(6,0) ,RMASEI VARCHAR(8) ,RMAEDT VARCHAR(8) ,RMAAGR VARCHAR(8) ,RMAPDF VARCHAR(8) ,RMAEML VARCHAR(8) ,RMABEM VARCHAR(1024) ,RMAVRS VARCHAR(10)  ,CONSTRAINT TMSYSTEM.TMS230RMA_PK PRIMARY KEY(RMAANM,RMANUM,RMAWHL)   );
CREATE TABLE TMSYSTEM.TMS230RML ( RMLNUM NUMERIC(11,0) WITH DEFAULT 0,RMLWHL NUMERIC(5,0) WITH DEFAULT 0,RMLTXT VARCHAR(50) ,RMLMSK VARCHAR(20) ,RMLBAB VARCHAR(8) ,RMLBBI VARCHAR(8) ,RMLWTG VARCHAR(30) ,RMLINT VARCHAR(100) ,RMLTOU NUMERIC(3,0) WITH DEFAULT 0,RMLGRP VARCHAR(50) ,RMLERF VARCHAR(50) WITH DEFAULT 'TIMESYS',RMLDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,RMLSTA NUMERIC(5,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.TMS230RML_PK PRIMARY KEY(RMLNUM,RMLWHL,RMLMSK,RMLBAB)   );
CREATE TABLE TMSYSTEM.TMS230RMP ( RMPANM VARCHAR(50) ,RMPNUM NUMERIC(11,0) WITH DEFAULT 0,RMPWHL NUMERIC(5,0) WITH DEFAULT 0,RMPMSK VARCHAR(20) ,RMPFNA VARCHAR(16) ,RMPVAL VARCHAR(2048) ,RMPERF VARCHAR(50) WITH DEFAULT 'TIMESYS',RMPDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,RMPSTA NUMERIC(5,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.TMS230RMP_PK PRIMARY KEY(RMPANM,RMPNUM,RMPWHL,RMPFNA)   );
CREATE TABLE TMSYSTEM.TMS300LPR ( LPRTYP NUMERIC(2,0) ,LPRLIZ VARCHAR(5) ,LPRMND VARCHAR(5) ,LPRPZM NUMERIC(6,0) ,LPRBCH NUMERIC(6,0) ,LPRBC2 NUMERIC(6,0) ,LPRZTG NUMERIC(6,0) ,LPRPDT NUMERIC(8,0) ,LPRCHK VARCHAR(32) ,LPRDAT TIMESTAMP  ,CONSTRAINT TMSYSTEM.TMS300LPR_PK PRIMARY KEY(LPRTYP,LPRLIZ,LPRMND)   );
CREATE TABLE TMSYSTEM.TMS301ASW ( ASWNUM VARCHAR(50) ,ASWGVO DATE WITH DEFAULT CURRENT_DATE,ASWGBI DATE WITH DEFAULT CURRENT_DATE,ASWPNR VARCHAR(8) ,ASWBKL VARCHAR(5) WITH DEFAULT '0',ASWPIN VARCHAR(32) ,ASWCOD NUMERIC(5,0) WITH DEFAULT 0,ASWGRP VARCHAR(5) ,ASWSTA NUMERIC(5,0) WITH DEFAULT 1,ASWDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ASWERF VARCHAR(50) WITH DEFAULT 'Timesys',ASWLIZ VARCHAR(5) WITH DEFAULT '01000',ASWMND VARCHAR(5) WITH DEFAULT '0',ASWATP NUMERIC(2,0) WITH DEFAULT 0,ASWAAN VARCHAR(50) WITH DEFAULT NULL,ASWMTA NUMERIC(2,0) ,ASWSTO VARCHAR(8) ,ASWSPR NUMERIC(5,0) ,ASWSAL VARCHAR(10) ,ASWBK2 VARCHAR(5) ,ASWNAM VARCHAR(50) ,ASWMAP NUMERIC(1,0) ,ASWKST VARCHAR(30) ,ASWKAL VARCHAR(3)  ,CONSTRAINT TMSYSTEM.TMS301ASW_PK PRIMARY KEY(ASWNUM,ASWGVO,ASWBKL)   );
CREATE TABLE TMSYSTEM.TMS301AWB ( AWBASW VARCHAR(50) ,AWBBKL VARCHAR(5) ,AWBLIZ VARCHAR(5) ,AWBMND VARCHAR(5) ,AWBZUV NUMERIC(1,0) ,AWBDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,AWBSTA NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS301AWB_PK PRIMARY KEY(AWBASW,AWBBKL,AWBLIZ,AWBMND)   );
CREATE TABLE TMSYSTEM.TMS301BKL ( BKLASW VARCHAR(50) ,BKLGVO DATE ,BKLGBI DATE ,BKLBKL VARCHAR(5) ,BKLART NUMERIC(1,0) ,BKLLIZ VARCHAR(5) ,BKLMND VARCHAR(5) ,BKLOLI VARCHAR(5) ,BKLOMN VARCHAR(5) ,BKLPNR VARCHAR(8) ,BKLSTM NUMERIC(1,0) ,BKLSKY VARCHAR(30) ,BKLSTA NUMERIC(1,0) ,BKLDAT TIMESTAMP ,BKLERF VARCHAR(50)  ,CONSTRAINT TMSYSTEM.TMS301BKL_PK PRIMARY KEY(BKLASW,BKLGVO,BKLBKL,BKLART,BKLLIZ,BKLMND)   );
CREATE TABLE TMSYSTEM.TMS321BEW ( BEWSCH VARCHAR(20) ,BEWPNR VARCHAR(8) ,BEWTID VARCHAR(255) ,BEWLID VARCHAR(5) ,BEWIDN VARCHAR(50) ,BEWSTO VARCHAR(8) ,BEWDTM DATE ,BEWUHR TIME ,BEWLFN VARCHAR(3) ,BEWART VARCHAR(3) ,BEWTAS VARCHAR(2) ,BEWERA VARCHAR(3) ,BEWKZE CHAR(1) ,BEWBER CHAR(1) ,BEWERQ VARCHAR(10) ,BEWSTA NUMERIC(5,0) ,BEWKST VARCHAR(30) ,BEWQUA VARCHAR(5) ,BEWRES VARCHAR(30) ,BEWDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,BEWERF VARCHAR(50) WITH DEFAULT 'Timesys',BEWUKZ NUMERIC(1,0) ,BEWUDT TIMESTAMP ,BEWSRC VARCHAR(3)  ,CONSTRAINT TMSYSTEM.TMS321BEW_PK PRIMARY KEY(BEWTID,BEWIDN,BEWSTO,BEWDTM,BEWUHR,BEWLFN,BEWSRC)   );
CREATE TABLE TMSYSTEM.TMS401ZAU ( ZAUGRP VARCHAR(5) ,ZAUTGE NUMERIC(5,0) WITH DEFAULT 0,ZAUTXT VARCHAR(50) ,ZAUKTX VARCHAR(10) ,ZAUSTA NUMERIC(5,0) WITH DEFAULT 1,ZAUDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZAUERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS401ZAU_PK PRIMARY KEY(ZAUGRP)   );
CREATE TABLE TMSYSTEM.TMS401ZLK ( ZLKTRM VARCHAR(255) ,ZLKLES NUMERIC(5,0) WITH DEFAULT 0,ZLKTRK VARCHAR(10) ,ZLKLEK NUMERIC(5,0) WITH DEFAULT 0,ZLKAKT NUMERIC(5,0) WITH DEFAULT 0,ZLKDAU NUMERIC(5,0) WITH DEFAULT 0,ZLKSTA NUMERIC(5,0) WITH DEFAULT 1,ZLKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZLKERF VARCHAR(50) WITH DEFAULT 'Timesys',ZLKMTO NUMERIC(5,0) WITH DEFAULT 0,ZLKLIZ VARCHAR(5) ,ZLKMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS401ZLK_PK PRIMARY KEY(ZLKTRM,ZLKLES,ZLKTRK,ZLKLEK)   );
CREATE TABLE TMSYSTEM.TMS401ZLS ( ZLSTRM VARCHAR(255) ,ZLSLES NUMERIC(5,0) WITH DEFAULT 0,ZLSZKO VARCHAR(5) ,ZLSAUS VARCHAR(5) ,ZLSTFR VARCHAR(5) ,ZLSTVR VARCHAR(5) ,ZLSEIN NUMERIC(5,0) WITH DEFAULT 1,ZLSADR NUMERIC(5,0) WITH DEFAULT 1,ZLSTXT VARCHAR(50) ,ZLSKTX VARCHAR(10) ,ZLSSTA NUMERIC(5,0) WITH DEFAULT 1,ZLSDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZLSERF VARCHAR(50) WITH DEFAULT 'Timesys',ZLSEKO VARCHAR(5) ,ZLSFCD VARCHAR(3) ,ZLSKST VARCHAR(30) ,ZLSMSN VARCHAR(50) ,ZLSFTP NUMERIC(5,0) ,ZLSPRO NUMERIC(2,0) ,ZLSSST NUMERIC(2,0) ,ZLSIPA VARCHAR(15) ,ZLSANZ NUMERIC(1,0) ,ZLSSEI NUMERIC(2,0) ,ZLSSPA NUMERIC(2,0) ,ZLSZEI NUMERIC(2,0) ,ZLSFIW NUMERIC(1,0) ,ZLSTON NUMERIC(2,0) ,ZLSLST NUMERIC(1,0) ,ZLSDTO VARCHAR(14) ,ZLSMOD VARCHAR(8) ,ZLSMKO VARCHAR(1) ,ZLSR01 VARCHAR(10) ,ZLSR02 VARCHAR(10) ,ZLSR03 VARCHAR(50) ,ZLSR04 VARCHAR(50) ,ZLSPIN NUMERIC(1,0) WITH DEFAULT 0,ZLSBVW NUMERIC(1,0) WITH DEFAULT 0 ,CONSTRAINT TMSYSTEM.TMS401ZLS_PK PRIMARY KEY(ZLSTRM,ZLSLES)   );
CREATE TABLE TMSYSTEM.TMS402ZKO ( ZKONUM VARCHAR(5) ,ZKOPRT VARCHAR(5) ,ZKOABL VARCHAR(5) ,ZKOZAP VARCHAR(5) ,ZKOAUT NUMERIC(1,0) ,ZKOTFS VARCHAR(5) ,ZKOKAL VARCHAR(3) ,ZKOAUG NUMERIC(1,0) ,ZKOMAX NUMERIC(5,0) WITH DEFAULT 0,ZKOTVR VARCHAR(5) ,ZKOAUF NUMERIC(5,0) WITH DEFAULT 0,ZKOTXT VARCHAR(50) ,ZKOKTX VARCHAR(10) ,ZKOSTA NUMERIC(5,0) WITH DEFAULT 1,ZKODAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZKOERF VARCHAR(50) WITH DEFAULT 'Timesys',ZKOSPA NUMERIC(2,0) ,ZKOZEI NUMERIC(2,0)  ,CONSTRAINT TMSYSTEM.TMS402ZKO_PK PRIMARY KEY(ZKONUM)   );
CREATE TABLE TMSYSTEM.TMS402ZPK ( ZPKTRM VARCHAR(255) ,ZPKLES NUMERIC(5,0) WITH DEFAULT 0,ZPKDTM DATE ,ZPKUHR TIME ,ZPKASW VARCHAR(13) ,ZPKZUS NUMERIC(5,0) WITH DEFAULT 0,ZPKFCD VARCHAR(3) ,ZPKMLD VARCHAR(50) ,ZPKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZPKLFD VARCHAR(3) WITH DEFAULT '001',ZPKZKO VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS402ZPK_PK PRIMARY KEY(ZPKTRM,ZPKLES,ZPKDTM,ZPKUHR,ZPKLFD)   );
CREATE TABLE TMSYSTEM.TMS402ZUZ ( ZUZNUM VARCHAR(5) ,ZUZVON NUMERIC(5,0) ,ZUZBIS NUMERIC(5,0) ,ZUZSTA NUMERIC(5,0) WITH DEFAULT 1,ZUZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZUZERF VARCHAR(50) WITH DEFAULT 'Timesys',ZUZART VARCHAR(1) ,ZUZVRW NUMERIC(5,0) ,ZUZTTP VARCHAR(3) ,ZUZDAU NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS402ZUZ_PK PRIMARY KEY(ZUZNUM,ZUZVON)   );
CREATE TABLE TMSYSTEM.TMS402ZZZ ( ZZZNUM VARCHAR(5) ,ZZZTXT VARCHAR(50) ,ZZZKTX VARCHAR(10) ,ZZZSTA NUMERIC(5,0) WITH DEFAULT 1,ZZZDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZZZERF VARCHAR(50) WITH DEFAULT 'Timesys',ZZZTTP VARCHAR(3)  ,CONSTRAINT TMSYSTEM.TMS402ZZZ_PK PRIMARY KEY(ZZZNUM)   );
CREATE TABLE TMSYSTEM.TMS403ZBK ( ZBKNUM VARCHAR(5) ,ZBKTXT VARCHAR(50) ,ZBKKTX VARCHAR(10) ,ZBKSTA NUMERIC(5,0) WITH DEFAULT 1,ZBKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZBKERF VARCHAR(50) WITH DEFAULT 'Timesys',ZBKART NUMERIC(1,0) ,ZBKLIZ VARCHAR(5) ,ZBKMND VARCHAR(5)  ,CONSTRAINT TMSYSTEM.TMS403ZBK_PK PRIMARY KEY(ZBKNUM)   );
CREATE TABLE TMSYSTEM.TMS404ZBR ( ZBRZBK VARCHAR(5) ,ZBRTTP VARCHAR(3) WITH DEFAULT '0',ZBRZKO VARCHAR(5) ,ZBRZZZ VARCHAR(5) ,ZBRSTA NUMERIC(5,0) WITH DEFAULT 1,ZBRDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZBRERF VARCHAR(50) WITH DEFAULT 'Timesys',ZBRZTB NUMERIC(2,0) ,ZBRSPA NUMERIC(2,0) ,ZBRZEI NUMERIC(2,0) ,ZBRZUT NUMERIC(1,0)  ,CONSTRAINT TMSYSTEM.TMS404ZBR_PK PRIMARY KEY(ZBRZBK,ZBRTTP,ZBRZKO)   );
CREATE TABLE TMSYSTEM.TMS405ZUG ( ZUGGRP VARCHAR(5) ,ZUGTXT VARCHAR(50) ,ZUGKTX VARCHAR(10) ,ZUGSTA NUMERIC(5,0) WITH DEFAULT 1,ZUGDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZUGERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS405ZUG_PK PRIMARY KEY(ZUGGRP)   );
CREATE TABLE TMSYSTEM.TMS405ZU1 ( ZU1GRP VARCHAR(5) ,ZU1ZZS NUMERIC(5,0) WITH DEFAULT 1,ZU1STA NUMERIC(5,0) WITH DEFAULT 1,ZU1DAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZU1ERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS405ZU1_PK PRIMARY KEY(ZU1GRP,ZU1ZZS)   );
CREATE TABLE TMSYSTEM.TMS405ZZS ( ZZSNUM NUMERIC(5,0) WITH DEFAULT 0,ZZSTXT VARCHAR(128) ,ZZSKTX VARCHAR(10) ,ZZSART NUMERIC(5,0) WITH DEFAULT 1,ZZSSTA NUMERIC(5,0) WITH DEFAULT 1,ZZSDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZZSERF VARCHAR(50) WITH DEFAULT 'Timesys',ZZSPRI NUMERIC(5,0) WITH DEFAULT 10,ZZSTCD VARCHAR(3)  ,CONSTRAINT TMSYSTEM.TMS405ZZS_PK PRIMARY KEY(ZZSNUM)   );
CREATE TABLE TMSYSTEM.TMS406ZAA ( ZAANUM VARCHAR(8) ,ZAAISY NUMERIC(2,0) ,ZAAEMP VARCHAR(50) ,ZAAETX VARCHAR(50) ,ZAASMS VARCHAR(50) ,ZAASTX VARCHAR(100) ,ZAASTA NUMERIC(5,0) WITH DEFAULT 1,ZAADAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZAAERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS406ZAA_PK PRIMARY KEY(ZAANUM,ZAAISY,ZAAEMP)   );
CREATE TABLE TMSYSTEM.TMS406ZAK ( ZAKZAP VARCHAR(5) ,ZAKTXT VARCHAR(50) ,ZAKTTP VARCHAR(3) ,ZAKZZZ VARCHAR(5) ,ZAKZUG VARCHAR(5) ,ZAKZAA VARCHAR(8) ,ZAKMIN NUMERIC(11,0) WITH DEFAULT 0,ZAKSTA NUMERIC(5,0) WITH DEFAULT 1,ZAKDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZAKERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS406ZAK_PK PRIMARY KEY(ZAKZAP,ZAKTTP,ZAKZZZ,ZAKZUG,ZAKZAA)   );
CREATE TABLE TMSYSTEM.TMS406ZAP ( ZAPNUM VARCHAR(5) ,ZAPTXT VARCHAR(50) ,ZAPKTX VARCHAR(10) ,ZAPSTA NUMERIC(5,0) WITH DEFAULT 1,ZAPDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,ZAPERF VARCHAR(50) WITH DEFAULT 'Timesys' ,CONSTRAINT TMSYSTEM.TMS406ZAP_PK PRIMARY KEY(ZAPNUM)   );
CREATE TABLE TMSYSTEM.TMS421KSTS ( KSTSTID VARCHAR(255) ,KSTSSLOT1 VARCHAR(24) ,KSTSSLOT2 VARCHAR(24) ,KSTSSLOT3 VARCHAR(24) ,KSTSSLOT4 VARCHAR(24) ,KSTSDTM DATE ,KSTSUHR DATE  ,CONSTRAINT TMSYSTEM.TMS421KSTS_PK PRIMARY KEY(KSTSTID)   );
CREATE TABLE TMSYSTEM.TMS500JOB ( JOBDA1 VARCHAR(14) ,JOBKE2 VARCHAR(32) ,JOBURV VARCHAR(256) ,JOBCMD VARCHAR(256) ,JOBCDI VARCHAR(256) ,JOBPRM VARCHAR(512) ,JOBRUS VARCHAR(128) ,JOBMRT NUMERIC(5,0) ,JOBRTY VARCHAR(2) ,JOBPRI NUMERIC(5,0) ,JOBDLS NUMERIC(5,0) ,JOBDLT VARCHAR(14) ,JOBBEM VARCHAR(256) ,JOBSCD VARCHAR(10) ,JOBSTS VARCHAR(2) ,JOBNAM VARCHAR(64) ,JOBUSR VARCHAR(128) ,JOBNUM VARCHAR(8) ,JOBSDA VARCHAR(14) ,JOBEDA VARCHAR(14) ,JOBNRT VARCHAR(14) ,JOBSTV NUMERIC(5,0) WITH DEFAULT 0 ,CONSTRAINT TMSYSTEM.TMS500JOB_PK PRIMARY KEY(JOBDA1,JOBKE2)   );
CREATE TABLE TMSYSTEM.TMS510ZSP ( ZSPLIZ VARCHAR(5) ,ZSPMND VARCHAR(5) ,ZSPUSR VARCHAR(50) ,ZSPFRM VARCHAR(25) ,ZSPKEY VARCHAR(50) ,ZSPDAT VARCHAR(14) ,ZSPGBI VARCHAR(14) ,ZSPZSP CLOB(2147483647)  ,CONSTRAINT TMSYSTEM.TMS510ZSP_PK PRIMARY KEY(ZSPLIZ,ZSPMND,ZSPUSR,ZSPFRM,ZSPKEY)   );
CREATE TABLE TMSYSTEM.TMS511STK ( STKDAT VARCHAR(14) ,STKSEK NUMERIC(12,0) ,STKUSE NUMERIC(12,8) ,STKLIZ VARCHAR(5) ,STKMND VARCHAR(5) ,STKUSR VARCHAR(50) ,STKFRM VARCHAR(25) ,STKPRM VARCHAR(2048) ,STKDAU NUMERIC(12,8) WITH DEFAULT 0,STKMEM NUMERIC(9,0) WITH DEFAULT 0,STKSZE NUMERIC(9,0) WITH DEFAULT 0,STKUZ1 NUMERIC(9,0) WITH DEFAULT 0,STKUM1 NUMERIC(9,0) WITH DEFAULT 0,STKUZ2 NUMERIC(9,0) WITH DEFAULT 0,STKUM2 NUMERIC(9,0) WITH DEFAULT 0 ,CONSTRAINT TMSYSTEM.TMS511STK_PK PRIMARY KEY(STKDAT,STKSEK,STKUSE,STKLIZ,STKMND,STKUSR,STKFRM)   );
CREATE TABLE TMSYSTEM.TMS512DBG ( DBGDATTIM VARCHAR(14) ,DBGDATSEK NUMERIC(12,0) ,DBGDATUSE NUMERIC(12,8) ,DBGSRVIPA VARCHAR(50) ,DBGSRVHST VARCHAR(256) ,DBGSRVUAG VARCHAR(512) ,DBGSESIDN VARCHAR(50) ,DBGSESNAM VARCHAR(50) ,DBGSESUSR VARCHAR(50) ,DBGSESLIZ VARCHAR(5) ,DBGSESMND VARCHAR(5) ,DBGSESSCH VARCHAR(20) ,DBGSESASC VARCHAR(40) ,DBGREQFRM VARCHAR(20) ,DBGWEBANM VARCHAR(50) ,DBGWEBLIZ VARCHAR(5) ,DBGWEBMND VARCHAR(5) ,DBGWEBPNR VARCHAR(8) ,DBGWEBUIP VARCHAR(15) ,DBGPRMVAL VARCHAR(2048)  ,CONSTRAINT TMSYSTEM.TMS512DBG_PK PRIMARY KEY(DBGDATTIM,DBGDATSEK,DBGDATUSE)   );
CREATE TABLE TMSYSTEM.TMS650ART ( ARTVON DATE ,ARTBIS DATE ,ARTART NUMERIC(5,0) ,ARTMWS NUMERIC(4,2) ,ARTBLG NUMERIC(2,0) ,ARTPSL NUMERIC(2,0) ,ARTUST NUMERIC(2,0) ,ARTKMT NUMERIC(2,0) ,ARTBTR NUMERIC(6,2) ,ARTCSM VARCHAR(32) WITH DEFAULT NULL,ARTPRZ NUMERIC(6,2) ,ARTABZ NUMERIC(2,0) ,ARTGRP NUMERIC(2,0)  ,CONSTRAINT TMSYSTEM.TMS650ART_PK PRIMARY KEY(ARTVON,ARTART)   );
CREATE TABLE TMSYSTEM.TMS651LVP ( LVPLND VARCHAR(10) ,LVPVON DATE ,LVPBIS DATE ,LVPTXT NUMERIC(5,0) ,LVPVP1 NUMERIC(6,2) ,LVPVP2 NUMERIC(6,2) ,LVPVP3 NUMERIC(6,2) ,LVPUPS NUMERIC(6,2) ,LVPCSM VARCHAR(32) WITH DEFAULT NULL ,CONSTRAINT TMSYSTEM.TMS651LVP_PK PRIMARY KEY(LVPLND,LVPVON)   );
CREATE TABLE TMSYSTEM.TMS680IAS ( IASNAM VARCHAR(250) ,IASLNK VARCHAR(250) ,IASSRC VARCHAR(250) ,IASDA2 VARCHAR(25) ,IASTYP NUMERIC(5,0) ,IASFIR VARCHAR(50) ,IASMND VARCHAR(5) ,IASLIZ VARCHAR(5) ,IASSTA NUMERIC(5,0) WITH DEFAULT 0,IASDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,IASERF VARCHAR(50) WITH DEFAULT 'TIMESYS' ,CONSTRAINT TMSYSTEM.TMS680IAS_PK PRIMARY KEY(IASNAM)   );
CREATE TABLE TMSYSTEM.TMS800DWH ( DWHLIZ VARCHAR(5) ,DWHMND VARCHAR(5) ,DWHSCH VARCHAR(20) ,DWHFIR VARCHAR(50) ,DWHNAM VARCHAR(50) ,DWHTXT VARCHAR(100) ,DWHSTS NUMERIC(5,0) ,DWHZTR NUMERIC(5,0) ,DWHVON VARCHAR(8) ,DWHBIS VARCHAR(8) ,DWHDAR NUMERIC(5,0) ,DWHANB NUMERIC(5,0) ,DWHANK NUMERIC(5,0) ,DWHANT NUMERIC(5,0) ,DWHAUS NUMERIC(5,0) ,DWHGRP NUMERIC(5,0) ,DWHSOR NUMERIC(5,0) ,DWHOWN VARCHAR(50) WITH DEFAULT 'TIMESYS',DWHSTA NUMERIC(5,0) WITH DEFAULT 1,DWHDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,DWHERF VARCHAR(50) WITH DEFAULT 'TIMESYS',DWHSQL VARCHAR(500) ,DWHSTT VARCHAR(5) WITH DEFAULT 'A',DWHLNU NUMERIC(5,0) WITH DEFAULT 99,DWHPFR NUMERIC(2,0) ,DWHGRW VARCHAR(3) ,DWHGRT VARCHAR(25) ,DWHKLI NUMERIC(2,0) ,DWHKLT VARCHAR(50) ,DWHKMI NUMERIC(2,0) ,DWHKMT VARCHAR(50) ,DWHKRI NUMERIC(2,0) ,DWHKRT VARCHAR(50) ,DWHFLI NUMERIC(2,0) ,DWHFLT VARCHAR(50) ,DWHFMI NUMERIC(2,0) ,DWHFMT VARCHAR(50) ,DWHFRI NUMERIC(2,0) ,DWHFRT VARCHAR(50) ,DWHGRI NUMERIC(2,0) ,DWHGPI NUMERIC(2,0) ,DWHGPW VARCHAR(3) ,DWHGPT VARCHAR(25) ,DWHMAB NUMERIC(2,0) WITH DEFAULT 1,DWHKAT NUMERIC(3,0) WITH DEFAULT 1,DWHSBE VARCHAR(8) WITH DEFAULT '99999999',DWHSNM VARCHAR(50) ,DWHBER NUMERIC(1,0) WITH DEFAULT 0,DWHCPY VARCHAR(4) WITH DEFAULT NULL ,CONSTRAINT TMSYSTEM.TMS800DWH_PK PRIMARY KEY(DWHLIZ,DWHMND,DWHNAM,DWHSTT,DWHSBE)   );
CREATE TABLE TMSYSTEM.TMS800PRTREP ( PRTBER NUMERIC(1,0) ,PRTNAM VARCHAR(50) ,PRTTAB VARCHAR(100) ,PRTFLD VARCHAR(200) ,PRTFLT VARCHAR(300) ,PRTFNA VARCHAR(500) ,PRTSAN NUMERIC(1,0) ,PRTSDA NUMERIC(1,0) ,PRTSFR NUMERIC(1,0) ,PRTGNU NUMERIC(1,0) ,PRTGNA VARCHAR(20) ,PRTDAV VARCHAR(10) ,PRTDAB VARCHAR(10) ,PRTVON VARCHAR(50) ,PRTVNU NUMERIC(2,0) ,PRTBIS VARCHAR(50) ,PRTBNU NUMERIC(2,0) ,PRTFIL VARCHAR(300) ,PRTSUM VARCHAR(300) ,PRTGRP NUMERIC(1,0) ,PRTAKT NUMERIC(1,0) ,PRTAUS NUMERIC(1,0) ,PRTART NUMERIC(1,0) WITH DEFAULT 1,PRTFIR VARCHAR(100)  ,CONSTRAINT TMSYSTEM.TMS800PRTREP_PK PRIMARY KEY(PRTBER,PRTNAM)   );
CREATE TABLE TMSYSTEM.TMS800REP ( REPNAM VARCHAR(50) ,REPTXT VARCHAR(50) ,REPLDT TIMESTAMP ,REPLBE VARCHAR(8) ,REPSTA NUMERIC(5,0) WITH DEFAULT 0,REPERF VARCHAR(50) ,REPDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,REPKOM VARCHAR(150) ,REPSNU NUMERIC(1,0) WITH DEFAULT 0,REPSDA NUMERIC(1,0) WITH DEFAULT 0,REPSFR NUMERIC(5,0) WITH DEFAULT 0,REPGNU NUMERIC(1,0) WITH DEFAULT 0,REPGNA VARCHAR(50) ,REPDVN DATE WITH DEFAULT CURRENT_DATE,REPDBS DATE WITH DEFAULT CURRENT_DATE,REPSVN VARCHAR(50) ,REPSBS VARCHAR(50) ,REPBER NUMERIC(1,0) ,REPSAS NUMERIC(1,0) WITH DEFAULT 0 ,CONSTRAINT TMSYSTEM.TMS800REP_PK PRIMARY KEY(REPNAM,REPBER)   );
CREATE TABLE TMSYSTEM.TMS800SCD ( SCDNAM VARCHAR(50) ,SCDLIZ VARCHAR(5) ,SCDMND VARCHAR(5) ,SCDSBE VARCHAR(8) ,SCDTXT VARCHAR(100) ,SCDART NUMERIC(5,0) WITH DEFAULT 0,SCDTYP NUMERIC(5,0) WITH DEFAULT 0,SCDTAG VARCHAR(7) ,SCDDTM DATE ,SCDUHR TIME ,SCDDWH VARCHAR(50) ,SCDDWN VARCHAR(100) ,SCDSTA NUMERIC(5,0) WITH DEFAULT 1,SCDDAT TIMESTAMP ,SCDERF VARCHAR(50) ,SCDBIS DATE ,SCDEMS NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.TMS800SCD_PK PRIMARY KEY(SCDNAM,SCDLIZ,SCDMND,SCDSBE)   );
CREATE TABLE TMSYSTEM.TMS800ZUO ( ZUOTAB VARCHAR(15) ,ZUOLFD NUMERIC(5,0) ,ZUOTXT VARCHAR(50) ,ZUOFLD VARCHAR(12) ,ZUONUM NUMERIC(11,0) ,ZUOWHL NUMERIC(5,0) ,ZUOFTX VARCHAR(50) ,ZUOIDX NUMERIC(5,0) ,ZUOSTA NUMERIC(5,0) WITH DEFAULT 1,ZUOLAN NUMERIC(5,0) WITH DEFAULT 10,ZUOTYP VARCHAR(20) ,ZUOPRI NUMERIC(5,0) WITH DEFAULT 1 ,CONSTRAINT TMSYSTEM.TMS800ZUO_PK PRIMARY KEY(ZUOTAB,ZUOLFD,ZUOFLD)   );
CREATE TABLE TMSYSTEM.TMS801EMA ( EMASCD VARCHAR(50) ,EMALIZ VARCHAR(5) ,EMAMND VARCHAR(5) ,EMASBE VARCHAR(8) ,EMALFD NUMERIC(5,0) ,EMAILA VARCHAR(50) ,EMASTA NUMERIC(5,0) WITH DEFAULT 1,EMADAT TIMESTAMP ,EMAERF VARCHAR(50)  ,CONSTRAINT TMSYSTEM.TMS801EMA_PK PRIMARY KEY(EMASCD,EMALIZ,EMAMND,EMASBE,EMALFD)   );
CREATE TABLE TMSYSTEM.TMS801GRP ( GRPLIZ VARCHAR(5) ,GRPMND VARCHAR(5) ,GRPSCH VARCHAR(20) ,GRPFIR VARCHAR(50) ,GRPDWH VARCHAR(50) ,GRPTYP VARCHAR(3) ,GRPKEY VARCHAR(30) ,GRPGPO NUMERIC(5,0) ,GRPPOS NUMERIC(5,0) ,GRPTAB VARCHAR(15) ,GRPFLD VARCHAR(10) ,GRPSTT VARCHAR(5) WITH DEFAULT 'A',GRPSBE VARCHAR(8) WITH DEFAULT '99999999',GRPCPY VARCHAR(4) WITH DEFAULT NULL,GRPAOR NUMERIC(5,0) WITH DEFAULT 0,GRPKLA NUMERIC(1,0) WITH DEFAULT 0,GRPKLZ NUMERIC(1,0) WITH DEFAULT 0,GRPFLC NUMERIC(5,0) WITH DEFAULT 0 ,CONSTRAINT TMSYSTEM.TMS801GRP_PK PRIMARY KEY(GRPLIZ,GRPMND,GRPDWH,GRPTYP,GRPKEY,GRPGPO,GRPPOS,GRPSTT,GRPSBE,GRPFLC)   );
CREATE TABLE TMSYSTEM.TMS801ZUO ( ZUOTAB VARCHAR(15) ,ZUOFLD VARCHAR(9) ,ZUOSUM NUMERIC(1,0) WITH DEFAULT 0,ZUOST1 NUMERIC(1,0) WITH DEFAULT 0,ZUOBER NUMERIC(1,0) WITH DEFAULT NULL,ZUOART NUMERIC(1,0) WITH DEFAULT 0,ZUOVWS VARCHAR(15) ,ZUOBEW VARCHAR(15)  ,CONSTRAINT TMSYSTEM.TMS801ZUO_PK PRIMARY KEY(ZUOTAB,ZUOFLD,ZUOBER)   );
CREATE TABLE TMSYSTEM.TMS802FLD ( FLDLIZ VARCHAR(5) ,FLDMND VARCHAR(5) ,FLDSCH VARCHAR(20) ,FLDFIR VARCHAR(50) ,FLDDWH VARCHAR(50) ,FLDTYP VARCHAR(3) ,FLDKEY VARCHAR(30) ,FLDTXT VARCHAR(120) ,FLDGPO NUMERIC(5,0) ,FLDPOS NUMERIC(5,0) ,FLDTAB VARCHAR(15) ,FLDFLD VARCHAR(10) ,FLDSTT VARCHAR(5) WITH DEFAULT 'A',FLDTY2 VARCHAR(3) ,FLDPO2 NUMERIC(5,0) ,FLDLAN NUMERIC(5,0) WITH DEFAULT 10,FLDSUM NUMERIC(5,0) WITH DEFAULT 0,FLDNUM NUMERIC(11,0) WITH DEFAULT 0,FLDWHL NUMERIC(5,0) ,FLDSPR NUMERIC(5,0) WITH DEFAULT 1,FLDSBE VARCHAR(8) WITH DEFAULT '99999999',FLDCPY VARCHAR(4) WITH DEFAULT NULL ,CONSTRAINT TMSYSTEM.TMS802FLD_PK PRIMARY KEY(FLDLIZ,FLDMND,FLDDWH,FLDTYP,FLDKEY,FLDSTT,FLDSPR,FLDSBE)   );
CREATE TABLE TMSYSTEM.TMS803OPT ( OPTLIZ VARCHAR(5) ,OPTMND VARCHAR(5) ,OPTDWH VARCHAR(50) ,OPTSTT VARCHAR(5) WITH DEFAULT 'A',OPTSBE VARCHAR(8) WITH DEFAULT '99999999',OPTKEY VARCHAR(10) ,OPTVA1 NUMERIC(5,0) WITH DEFAULT 0,OPTTX1 VARCHAR(100) ,OPTVA2 NUMERIC(5,0) WITH DEFAULT 0,OPTTX2 VARCHAR(100) ,OPTF01 VARCHAR(10) ,OPTF02 VARCHAR(10) ,OPTF03 VARCHAR(12) ,OPTF04 VARCHAR(10) ,OPTF05 VARCHAR(10) ,OPTF06 VARCHAR(10) ,OPTCPY VARCHAR(4) WITH DEFAULT NULL ,CONSTRAINT TMSYSTEM.TMS803OPT_PK PRIMARY KEY(OPTLIZ,OPTMND,OPTDWH,OPTSTT,OPTSBE,OPTKEY)   );
CREATE TABLE TMSYSTEM.TMS899TXT ( TXTLIZ VARCHAR(5) ,TXTMND VARCHAR(5) ,TXTTYP VARCHAR(15) ,TXTKEY VARCHAR(30) ,TXTTXT VARCHAR(100)  ,CONSTRAINT TMSYSTEM.TMS899TXT_PK PRIMARY KEY(TXTLIZ,TXTMND,TXTTYP,TXTKEY)   );
CREATE TABLE TMSYSTEM.TMS900ENT ( ENTKEY VARCHAR(14) ,ENTPNR VARCHAR(8) ,ENTUSR VARCHAR(50) ,ENTSCH VARCHAR(50) ,ENTANT NUMERIC(5,0) ,ENTFRG VARCHAR(250) ,ENTSTA NUMERIC(5,0)  ,CONSTRAINT TMSYSTEM.TMS900ENT_PK PRIMARY KEY(ENTKEY,ENTPNR)   );
CREATE TABLE TMSYSTEM.TMS900PRT ( PRTKEY TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,PRTPRG VARCHAR(20) ,PRTTXT VARCHAR(250) ,PRTDAT VARCHAR(20) ,PRTERF VARCHAR(50) ,PRTCHK VARCHAR(32)  ,CONSTRAINT TMSYSTEM.TMS900PRT_PK PRIMARY KEY(PRTKEY,PRTPRG)   );
CREATE TABLE TMSYSTEM.TMS901TABELLEN ( TABNAM VARCHAR(15) ,TABPS1 VARCHAR(4) ,TABPOS VARCHAR(10) ,TABFLD NUMERIC(11,0) WITH DEFAULT 0,TABTXT VARCHAR(50) ,TABFRM VARCHAR(50) ,TABSTA NUMERIC(5,0) WITH DEFAULT 1,TABDAT TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,TABERF VARCHAR(50) WITH DEFAULT 'Timesys',TABREP VARCHAR(10)  ,CONSTRAINT TMSYSTEM.TMS901TABELLEN_PK PRIMARY KEY(TABNAM)   );
CREATE TABLE TMSYSTEM.TMS999TMP ( TMPUSR VARCHAR(100) ,TMPSTR VARCHAR(512) ,TMPDAT DATE WITH DEFAULT CURRENT_DATE ,CONSTRAINT TMSYSTEM.TMS999TMP_PK PRIMARY KEY(TMPUSR,TMPSTR)   );
CREATE TABLE TMSYSTEM.TRMASWDNL ( DNLTRM VARCHAR(255) ,DNLASW VARCHAR(13) ,DNLGVO VARCHAR(8) ,DNLGBI VARCHAR(8) ,DNLSTB VARCHAR(3) ,DNLSTO VARCHAR(8) ,DNLKZE NUMERIC(1,0) ,DNLKZU NUMERIC(1,0) ,DNLSAL VARCHAR(10) ,DNLSPR NUMERIC(1,0) ,DNLLIZ VARCHAR(5) ,DNLMND VARCHAR(5) ,DNLSA1 VARCHAR(7) ,DNLATP NUMERIC(2,0) ,DNLAAN VARCHAR(50) ,DNLL01 VARCHAR(2) ,DNLB01 VARCHAR(3) ,DNLL02 VARCHAR(2) ,DNLB02 VARCHAR(3) ,DNLL03 VARCHAR(2) ,DNLB03 VARCHAR(3) ,DNLL04 VARCHAR(2) ,DNLB04 VARCHAR(3) ,DNLL05 VARCHAR(2) ,DNLB05 VARCHAR(3) ,DNLL06 VARCHAR(2) ,DNLB06 VARCHAR(3) ,DNLL07 VARCHAR(2) ,DNLB07 VARCHAR(3) ,DNLL08 VARCHAR(2) ,DNLB08 VARCHAR(3) ,DNLL09 VARCHAR(2) ,DNLB09 VARCHAR(3) ,DNLL10 VARCHAR(2) ,DNLB10 VARCHAR(3) ,DNLL11 VARCHAR(2) ,DNLB11 VARCHAR(3) ,DNLPIN VARCHAR(32) ,DNLPNR VARCHAR(8) ,DNLNAM VARCHAR(50)  ,CONSTRAINT TMSYSTEM.TRMASWDNL_PK PRIMARY KEY(DNLTRM,DNLASW)   );
CREATE TABLE TMSYSTEM.VERSIONSHISTORIE ( VERSION VARCHAR(5) ,MODUL NUMERIC(2,0) ,FORMULAR VARCHAR(30) ,TEXT NUMERIC(11,0) ,GRAFIK VARCHAR(255) ,HANDBUCH VARCHAR(255) ,AUFTRAG NUMERIC(8,0) ,ERFASSER VARCHAR(50) ,STAMP TIMESTAMP WITH DEFAULT CURRENT_TIMESTAMP,REITER VARCHAR(30) ,ZUSATZ VARCHAR(255) ,PRODUKT VARCHAR(100)  ,CONSTRAINT TMSYSTEM.VERSIONSHISTORIE_PK PRIMARY KEY(VERSION,MODUL,FORMULAR,AUFTRAG,REITER)   );
