Tabela |
RGW |
Dados Homolognet |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
RGW_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
RGW_MAT |
C |
6 |
0 |
Matricula |
999999 |
|
|
R |
|
|
S |
RGW_HOMOL |
D |
8 |
0 |
Homologacao |
|
|
|
R |
|
|
S |
RGW_TPRESC |
C |
1 |
0 |
Rescisao |
@! |
Pertence("12") |
|
R |
1=Normal;2=Complementar |
|
S |
RGW_TPREG |
C |
1 |
0 |
Registro |
@! |
Pertence("12") |
|
R |
1=Ferias;2=13º Salario |
|
S |
RGW_DTINI |
D |
8 |
0 |
Ini Per Aqui |
|
|
|
R |
|
|
S |
RGW_DTFIM |
D |
8 |
0 |
Fim Per.Aqui |
|
|
|
R |
|
|
S |
RGW_QUIT |
C |
1 |
0 |
Quitado |
@! |
If(M->RGW_TPREG=='1',Pertence('12'),Pertence('123')) |
|
R |
1=Sim;2=Nao;3=Parcial |
|
S |
RGW_JTCUMP |
C |
1 |
0 |
Jornada Trab |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
RGW_COMPSA |
C |
1 |
0 |
Comp Sabado |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
RGW_FM13 |
C |
1 |
0 |
Form.Calc 13 |
@! |
Pertence("12") |
|
R |
1=CLT;2=Convencionado |
|
S |
RGW_PER13 |
C |
1 |
0 |
Per Calc 13º |
@! |
If(M->RGW_FM13=='2',Pertence('12'),.T.) |
|
R |
1=Ultimos meses;2=Ano corrente |
|
S |
RGW_QTDE13 |
N |
2 |
0 |
Qt meses 13º |
@E 99 |
If(M->RGW_PER13='1',M->RGW_QTDE13 > 0 .and. M->RGW_QTDE13 <= 12 , .T.) |
|
R |
|
|
S |
RGW_MA13 |
N |
2 |
0 |
Maiores 13º |
@E 99 |
If(M->RGW_MA13==0,.T.,(M->RGW_MA13 > 0 .and. M->RGW_MA13 <= 12)) |
|
R |
|
|
S |
RGW_FMFER |
C |
1 |
0 |
F.Cal.Ferias |
@! |
Pertence("12") |
|
R |
1=CLT;2=Convencionado |
|
S |
RGW_PERFER |
C |
1 |
0 |
Per.Calc.Fer |
@! |
Pertence('12') |
|
R |
1=Ultimos meses;2=Periodo Aquisitivo |
|
S |
RGW_QTDFER |
N |
2 |
0 |
Qt meses fer |
@E 99 |
If(M->RGW_FMFER=='1',M->RGW_QTDFER > 0 .and. M->RGW_QTDFER <= 12,.T.) |
|
R |
|
|
S |
RGW_MAFER |
N |
2 |
0 |
Maiores Fer. |
@E 99 |
If(M->RGW_MAFER,.T.,(M->RGW_MAFER > 0 .and. M->RGW_MAFER <= 12)) |
|
R |
|
|
S |
RGW_FMAV |
C |
1 |
0 |
F.Calc.Av |
@! |
Pertence("12") |
|
R |
1=CLT;2=Convencionado |
|
S |
RGW_QTDEAV |
N |
2 |
0 |
Qt meses Av |
@E 99 |
If(M->RGW_FMAV=='2',(M->RGW_QTDEAV > 0 .and. M->RGW_QTDEAV <= 12),.T.) |
|
R |
|
|
S |
RGW_MAAV |
N |
2 |
0 |
Maiores Av |
@E 99 |
If(M->RGW_MAAV==0,.T.,(M->RGW_MAAV > 0 .and. M->RGW_MAAV <= 12)) |
|
R |
|
|
S |
RGW_DAVISO |
N |
2 |
0 |
Dias A.Prev. |
@E 99 |
If(M->RGW_FMAV=='2',M->RGW_DAVISO > 0,.T.) |
|
R |
|
|
S |
RGW_VALP13 |
N |
12 |
2 |
Val pago 13º |
@E 999,999,999.99 |
If(M->RGW_QUIT=='3' .AND. M->RGW_TPREG=='2',M->RGW_VALP13 > 0,.T.) |
|
R |
|
|
S |
RGW_FALT |
N |
2 |
0 |
Nro Faltas |
@E 99 |
if(M->RGW_QUIT=='2',M->RGW_FALT>0,.T.) |
|
R |
|
|
S |
RGW_M01 |
N |
2 |
0 |
Faltas Jan |
@E 99 |
|
|
R |
|
|
S |
RGW_M02 |
N |
2 |
0 |
Faltas Fev |
@E 99 |
|
|
R |
|
|
S |
RGW_M03 |
N |
2 |
0 |
Faltas Mar |
@E 99 |
|
|
R |
|
|
S |
RGW_M04 |
N |
2 |
0 |
Faltas Abr |
@E 99 |
|
|
R |
|
|
S |
RGW_M05 |
N |
2 |
0 |
Faltas Mai |
@E 99 |
|
|
R |
|
|
S |
RGW_M06 |
N |
2 |
0 |
Faltas Jun |
@E 99 |
|
|
R |
|
|
S |
RGW_M07 |
N |
2 |
0 |
Faltas Jul |
@E 99 |
|
|
R |
|
|
S |
RGW_M08 |
N |
2 |
0 |
Faltas Ago |
@E 99 |
|
|
R |
|
|
S |
RGW_M09 |
N |
2 |
0 |
Faltas Set |
@E 99 |
|
|
R |
|
|
S |
RGW_M10 |
N |
2 |
0 |
Faltas Out |
@E 99 |
|
|
R |
|
|
S |
RGW_M11 |
N |
2 |
0 |
Faltas Nov |
@E 99 |
|
|
R |
|
|
S |
RGW_M12 |
N |
2 |
0 |
Faltas Dez |
@E 99 |
|
|
R |
|
|
S |
RGW_NUMID |
C |
20 |
0 |
Numero ID |
@! |
|
|
R |
|
|
S |
RGW_CCUSTO |
C |
9 |
0 |
Centro Custo |
@! |
|
|
R |
|
|
S |
RGW_ALT |
C |
1 |
0 |
Status Regis |
@! |
|
|
R |
|
|
S |