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