| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| RGX | Homolognet Dados Financeiros | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| RGX_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| RGX_MAT | C | 6 | 0 | Matricula | 999999 | R | S | ||||
| RGX_HOMOL | D | 8 | 0 | Dt. Homolog. | R | S | |||||
| RGX_TPRESC | C | 1 | 0 | Tp Rescisao | @! | Pertence("12") | R | 1=Normal;2=Complementar | S | ||
| RGX_TPREG | C | 1 | 0 | Tp Registro | @! | Pertence("12") | R | 1=Rubrica Prevista;2=Demais Rubricas | S | ||
| RGX_MESANO | C | 6 | 0 | Ano/Mes Sal. | @R 9999/99 | Entre('01','12',Substr(M->RGX_MESANO,5,2)) .AND. LEN(ALLTRIM(M->RGX_MESANO))==6 | R | S | |||
| RGX_FORSAL | C | 1 | 0 | F. Salario | @! | Pertence("123") | R | 1=Fixo;2=Variavel;3=Fixo+Variavel | S | ||
| RGX_TPSAL | C | 1 | 0 | Tp Salario | @! | Pertence("123") | R | 1=Hora;2=Mensal;3=Diario | M->RGX_FORSAL$'1/3' | S | |
| RGX_CODRUB | C | 3 | 0 | Cod.Rubrica | 999 | If(M->RGX_TPREG=='1',ValidRCC('S020',M->RGX_CODRUB,1,3),GPEM601V04(M->RGX_TPREG,4,M->RGX_CODRUB)) | S20 | R | GPEM601V04(M->RGX_TPREG,3,,4) | S | |
| RGX_VALRUB | N | 12 | 2 | Vlr Rubrica | @E 999,999,999.99 | M->RGX_VALRUB > 0 | R | GPEM601V01() | S | ||
| RGX_PROD | C | 3 | 0 | Cod.Produto | @! | IF(Empty(M->RGX_PROD),.F.,ChkTarefa(M->RGX_PROD)) | R | M->RGX_TPREG=='1' .AND. M->RGX_CODRUB=='003' | S | ||
| RGX_VALBC | N | 12 | 2 | Vlr.Bse.Calc | @E 999,999,999.99 | M->RGX_VALBC>0 | R | M->RGX_TPREG=='1'.AND.M->RGX_CODRUB $ '003/013/014/018/019' | S | ||
| RGX_QTDPRO | N | 9 | 2 | Qtde de Prod | @E 999,999.99 | M->RGX_QTDPRO>0 | R | M->RGX_TPREG=='1'.AND.M->RGX_CODRUB $ '003' | S | ||
| RGX_PERC | N | 6 | 2 | Percentual | @E 999.99 | M->RGX_PERC>0 | R | GPEM601V02() | S | ||
| RGX_QTDHOR | N | 6 | 2 | Dias/Hs trab | @E 999.99 | M->RGX_QTDHOR>0 | R | GPEM601V03() | S | ||
| RGX_SALLIQ | N | 9 | 2 | Liq Ant.Resc | @E 999,999.99 | R | M->RGX_MESANO == '999999' | S | |||
| RGX_TRIBUT | C | 3 | 0 | FGTS/INSS/IR | 999 | M->RGX_TRIBUT $ ('000/111/100/101/001/011/010/110') | R | M->RGX_TPREG =='2' | S | ||
| RGX_INTBC | C | 3 | 0 | B.Fer/13/AvP | 999 | M->RGX_INTBC $ ('000/111/100/101/001/011/010/110') | R | M->RGX_TPREG =='2' | S | ||
| RGX_QTDDSR | N | 1 | 0 | Qtde DSR | 9 | R | M->RGX_MESANO == '999999' | S | |||
| RGX_ALT | C | 1 | 0 | Status Regis | @! | R | S | ||||