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
Modo: E
Modo Unid.: E
Modo Empr.: E
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 |