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