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