@PHONTOD

CREATE TABLE "PHMMVS"
(
  "CODSIN"	 VARCHAR(4) NOT NULL,
  "SEQUEN"       VARCHAR(4) NOT NULL, 
  "DATINI"	 VARCHAR(10), 
  "DATFIN"	 VARCHAR(10),
  "CODEVE"	 VARCHAR(4), 
  "QUANTI"	 VARCHAR(5),
  "DESCR1"	 VARCHAR(40),
  "DESCR2"	 VARCHAR(40),
 PRIMARY KEY ("CODSIN", "SEQUEN")
);

@EXECSQL

@PHONTOD

CREATE TABLE "PHMMVG" 
(
  "CODEMP"	 VARCHAR(3) NOT NULL,
  "SEQUEN"	 VARCHAR(4) NOT NULL,
  "DATINI"	 VARCHAR(10),
  "DATFIN"	 VARCHAR(10),
  "CODEVE"	 VARCHAR(4),
  "QUANTI"	 VARCHAR(5),
  "DESCRI"	 VARCHAR(60),
  "NIVEL1"	 VARCHAR(5),
  "NIVEL2"	 VARCHAR(5),
  "NIVEL3"	 VARCHAR(5),
  "NIVEL4"	 VARCHAR(5),
  "CODSIN"	 VARCHAR(5),
  "CODGRU"	 VARCHAR(3),
  "SELDEP"	 VARCHAR(100),
  "SELSET"	 VARCHAR(100),
  "SELSEC"	 VARCHAR(100),
  "SELCCU"	 VARCHAR(100),
  "SELGRU"	 VARCHAR(100),
  "SELSIN"	 VARCHAR(100),
  "TRAESP"	 VARCHAR(2),
 PRIMARY KEY ("CODEMP", "SEQUEN")
);
@EXECSQL

@PHONTOD

CREATE TABLE "PHWSYS" 
(
  "REGSYS"	 VARCHAR(10) NOT NULL,
  "REGSEQ"	 VARCHAR(4)  NOT NULL,
  "IDEESP"       VARCHAR(20),
  "CPPPAD"       VARCHAR(4),
  "DIGPAD"       VARCHAR(4),
  "MANPAD"       VARCHAR(4),   
  "TAMCHA"       VARCHAR(4), 
  "THRFER"       VARCHAR(4), 
  "THNFER"       VARCHAR(4),
  "HRSEVT"       VARCHAR(2),
  "RNDGER"       VARCHAR(2), 
  "RNDGRI"       VARCHAR(2), 
  "RNDINT"       VARCHAR(2),
  "KACERT"       VARCHAR(2), 
  "KAUTOM"       VARCHAR(2), 
  "KRELOG"       VARCHAR(2), 
  "TRFCOD"       VARCHAR(4), 
  "TRFTRA"       VARCHAR(2), 
  "DWPASS"       VARCHAR(2), 
  "HOSTDW"       VARCHAR(2), 
  "KKK001"       VARCHAR(20), 
  "KKK002"       VARCHAR(20), 
  "KKK003"       VARCHAR(20),
  "KKK004"       VARCHAR(20),
  "KKK005"       VARCHAR(20),
  "KKK006"       VARCHAR(20),
  "KKK007"       VARCHAR(20),
  "KKK008"       VARCHAR(20),
  "KKK009"       VARCHAR(20),
  "KKK010"       VARCHAR(20),
 PRIMARY KEY ("REGSYS", "REGSEQ")
);
@EXECSQL

