Tabela T61 - Ident Lei Remun. Per. Anter.
Rotina (SysObj): TAFA413
Chave Unica: T61_FILIAL + T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL + T61_DEMPAG + DTOS(T61_DTLEI) + T61_NUMLEI + T61_ORGSUC
Sumario:
Campos
Campo
| Titulo
| Descricao
| Tipo
| Contexto
| Tamanho
|
T61_FILIAL |
Filial |
Filial |
C |
Real |
2 |
T61_ID |
ID |
Identificador do Registro |
C |
Real |
36 |
T61_VERSAO |
Id. Ver. Reg |
Id Versao Registro |
C |
Real |
14 |
T61_INDAPU |
Ind.Per.Apur |
Indic.Periodo Apuracao |
C |
Real |
1 |
T61_PERAPU |
Per.Apuracao |
Periodo da Apuracao |
C |
Real |
6 |
T61_TRABAL |
Id.Trab. |
Id. do Trabalhador |
C |
Real |
6 |
T61_DEMPAG |
Id Dem. Pag. |
Ident. Demonst. Pagamento |
C |
Real |
30 |
T61_DTLEI |
Data Lei |
Data da Lei |
D |
Real |
8 |
T61_NUMLEI |
Num. Lei |
Numero da Lei |
C |
Real |
12 |
T61_DTEFET |
Dt Efet Lei |
Dt. Lei Produz. Efeitos |
D |
Real |
8 |
T61_ORGSUC |
Rem.Org.Suce |
Remuneracao Org. Sucessao |
C |
Real |
1 |
Indices
Ordem
| Chave
| Descricao
| Nickname
|
1 |
T61_FILIAL + T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL + T61_DEMPAG + DTOS(T61_DTLEI) + T61_NUMLEI + T61_ORGSUC |
ID + Id. Ver. Reg + Ind.Per.Apur + Per.Apuracao + Id.Trab. + Id Dem. P |
|
2 |
T61_FILIAL + DTOS(T61_DTLEI) + T61_NUMLEI |
Data Lei + Num. Lei |
|
3 |
T61_FILIAL + T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL + T61_DEMPAG + T61_ORGSUC |
ID + Id. Ver. Reg + Ind.Per.Apur + Per.Apuracao + Id.Trab. + Id Dem. P |
|
Relacionamentos
Tabela Origem
| Tabela Destino
| Expressao Origem
| Expressao Destino
| Relacionamento
|
C91 (Folha de Pagamento) |
T61 (Ident Lei Remun. Per. Anter.) |
C91_ID + C91_VERSAO + C91_INDAPU + C91_PERAPU + C91_TRABAL |
T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL |
1 para N |
T14 (Ident. Demonstr. Val. Trabal.) |
T61 (Ident Lei Remun. Per. Anter.) |
T14_IDEDMD |
T61_DEMPAG |
1 para N |
T14 (Ident. Demonstr. Val. Trabal.) |
T61 (Ident Lei Remun. Per. Anter.) |
T14_ID + T14_VERSAO + T14_INDAPU + T14_PERAPU + T14_TRABAL + T14_IDEDMD |
T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL + T61_DEMPAG |
1 para N |
T61 (Ident Lei Remun. Per. Anter.) |
T6H (Ident. Periodo de Remuneracao) |
T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL + T61_DEMPAG + T61_DTLEI + T61_NUMLEI |
T6H_ID + T6H_VERSAO + T6H_INDAPU + T6H_PERAPU + T6H_TRABAL + T6H_DEMPAG + T6H_DTLEI + T6H_NUMLEI |
1 para N |
T61 (Ident Lei Remun. Per. Anter.) |
T6H (Ident. Periodo de Remuneracao) |
T61_ID + T61_VERSAO + T61_INDAPU + T61_PERAPU + T61_TRABAL + T61_DEMPAG + T61_DTLEI + T61_NUMLEI + T61_ORGSUC |
T6H_ID + T6H_VERSAO + T6H_INDAPU + T6H_PERAPU + T6H_TRABAL + T6H_DEMPAG + T6H_DTLEI + T6H_NUMLEI + T6H_ORGSUC |
1 para N |
Tabelas do Protheus v4.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros