CREATE TABLE TMSYSTEM.TMS500JOB (
    JOBDA1 VARCHAR2(14)  ,
    JOBKE2 VARCHAR2(32)  ,
    JOBURV VARCHAR2(256) ,

    JOBCMD VARCHAR2(256) ,
    JOBCDI VARCHAR2(256) ,
    JOBPRM VARCHAR2(512) ,
    JOBRUS VARCHAR2(128) ,
    JOBMRT DECIMAL(5,0)  ,
    JOBRTY VARCHAR2(2)   ,
    JOBPRI DECIMAL(5,0)  ,
    JOBDLS DECIMAL(5,0)  ,
    JOBDLT VARCHAR2(14)  ,
    JOBBEM VARCHAR2(256) ,
    JOBSCD VARCHAR2(8)   ,

    JOBSTS VARCHAR2(2)   ,
    JOBNAM VARCHAR2(64)  ,
    JOBUSR VARCHAR2(128) ,
    JOBNUM VARCHAR2(8)   ,
    JOBSDA VARCHAR2(14)  ,
    JOBEDA VARCHAR2(14)  ,
    JOBNRT VARCHAR2(14)  ,

CONSTRAINT TMS500JOB_PK PRIMARY KEY (JOBDA1, JOBKE2)
);