UPDATE OR INSERT INTO VRH_BASE_TVERBAS_PADRAO (BDCODVERPD,BDAPEVERPD,BDDESCVERPD,BDDESCREDVERPD,BDCLAVERPD,BDREFVERPD,BDTIPOCODVERPD,BDINSSVERPD,BDFGTSVERPD,BDIRVERPD,BDTIPOREFVERPD,BDBASESFVERPD,BDPISVERPD,BDBASEHEVERPD,BDBASEMAIORVERPD,BDRAISVERPD,BDBASEGPSVERPD,BDMENORESVERPD,BDPROPVERPD,BDBASEVTVERPD,BDREEMBGPSVERPD,BDHEVERPD,BDGRAVAFICHAHNVERPD,BDCCPRINCIPALVERPD,BDFORMREFVERPD,BDFORMVALVERPD,BDBASEDSRHEVERPD,BDBASEDSRRVVERPD,BDFORMREFAUXVERPD,BDDEDFORMREFAUXVERPD,BDDEDFORMREFVERPD,BDDEDFORMVALVERPD,BDRENDISENTOIRVERPD,BDFORMINTVERPD,BDSITVERPD,BDPAGAESTOUROVERPD,BDSIMPLESNACIONALPD,BDBASE13HNPD,BDBASEFERHNPD,BDBASEAVHNPD,BDGARANTIAMINVERPD,BDSITMATVERPD,BDSITDOEVERPD,BDSITACITRABVERPD,BDSITMILITARVERPD,BDSITMATEMPVERPD,BDSITACITRAB15VERPD,BDSITDOETRABVERPD,BDSITLICVENCVERPD,BDSITDOE15VERPD,BDSITSINDICALVERPD,BDSITAPOINVVERPD,BDSITOUTRASPD,BDTIPOVERPD,BDINDRESCPD,BDULTALTPD,BDBASESALRAISPD,BDNAOCONVHORASVERPD) VALUES (14503,'FDESC','Desconto de férias','Desconto de férias','0.190.0.0.001',190001,1,0,0,0,0,0,'FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','0','FALSE',null,null,'SOCLASS(''0.100'', ''0.110'', ''0.120'', ''0.130'', ''0.140'', ''0.150'', ''0.191'') - (VALINSSFERFOL + VALIRFERFOL) - SOCLASS(''0.710.0.0'', ''0.710.0.1'', ''0.710.0.2'', ''0.710.0.3'', ''0.710.0.4'') - VALFERIASFOLHA(90021)',null,null,null,'FALSE','FALSE','TRUE','FALSE',null,0,'FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE',1,'FALSE','11/30/2015','FALSE','FALSE') MATCHING(BDCODVERPD, BDREFVERPD);
COMMIT WORK;
UPDATE VRH_BASE_TVERBAS_PADRAO SET BDULTALTPD = '12/31/2015';
COMMIT WORK;
UPDATE VRH_BASE_TVERBAS_REF SET BDFORMVALVER = 'SOCLASS(''0.100'', ''0.110'', ''0.120'', ''0.130'', ''0.140'', ''0.150'', ''0.191'') - (VALINSSFERFOL + VALIRFERFOL) - SOCLASS(''0.710.0.0'', ''0.710.0.1'', ''0.710.0.2'', ''0.710.0.3'', ''0.710.0.4'') - VALFERIASFOLHA(90021)' WHERE BDCODVER = 14503 and BDFORMVALVER = 'SOCLASS(''0.100'', ''0.110'', ''0.120'', ''0.130'', ''0.140'', ''0.150'', ''0.191'') - (VALINSSFERFOL + VALIRFERFOL) - SOCLASS(''0.710.0.0'', ''0.710.0.1'', ''0.710.0.2'', ''0.710.0.3'', ''0.710.0.4'')';
COMMIT WORK;