Tabela |
T5T |
Benef. Previdenciarios - RPPS |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
T5T_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
T5T_ID |
C |
6 |
0 |
ID |
@! |
|
|
R |
|
|
S |
T5T_VERSAO |
C |
14 |
0 |
Id. Ver. Reg |
@! |
|
|
R |
|
|
S |
T5T_CPF |
C |
11 |
0 |
CPF Benef. |
@R 999.999.999-99 |
xFunVldPJF(,1,.F.) .And. xFunVldUni("T5T",2,ALLTRIM(M->T5T_CPF)+"1") |
|
R |
|
|
S |
T5T_NOME |
C |
70 |
0 |
Nome Benef |
@! |
|
|
R |
|
|
S |
T5T_DTNASC |
D |
8 |
0 |
Data Nasc |
|
|
|
R |
|
|
S |
T5T_CODPAI |
C |
6 |
0 |
Id Pais Nasc |
@! |
xFunVldCmp("C08",3) |
C08 |
R |
|
|
S |
T5T_DCODPA |
C |
220 |
0 |
Des Pais Nas |
@! |
|
|
V |
|
|
S |
T5T_CODUF |
C |
6 |
0 |
Id. UF Nasc. |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
T5T_DCODUF |
C |
220 |
0 |
Descr UF Nas |
@! |
|
|
V |
|
|
S |
T5T_CODMUN |
C |
6 |
0 |
Id. Mun. Nas |
@! |
xFunVldCmp("C07",3) |
C07 |
R |
|
|
S |
T5T_DCODMU |
C |
220 |
0 |
Des Mun Nasc |
@! |
|
|
V |
|
|
S |
T5T_PAINAC |
C |
6 |
0 |
Id. Pais Nac |
@! |
xFunVldCmp("C08",3) |
C08 |
R |
|
|
S |
T5T_DPAINA |
C |
220 |
0 |
Des Pais Nac |
@! |
|
|
V |
|
|
S |
T5T_NOMMAE |
C |
70 |
0 |
Nome Mae |
@! |
|
|
R |
|
|
S |
T5T_NOMPAI |
C |
70 |
0 |
Nome Pai |
@! |
|
|
R |
|
|
S |
T5T_PAIS |
C |
6 |
0 |
Id Pais End |
@! |
xFunVldCmp("C08",3) |
C08 |
R |
|
|
S |
T5T_DPAIS |
C |
220 |
0 |
Des Pais End |
@! |
|
|
V |
|
|
S |
T5T_UF |
C |
6 |
0 |
Id. UF End. |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
T5T_DUF |
C |
220 |
0 |
Descr UF End |
@! |
|
|
V |
|
|
S |
T5T_MUN |
C |
6 |
0 |
Id. Mun. End |
@! |
xFunVldCmp("C07",3) |
C07 |
R |
|
|
S |
T5T_DMUN |
C |
220 |
0 |
Des Mun En |
@! |
|
|
V |
|
|
S |
T5T_TPLOGR |
C |
6 |
0 |
Id. Tp. Log. |
@! |
|
C06 |
R |
|
|
S |
T5T_DTPLOG |
C |
220 |
0 |
Des Tp Log |
@! |
|
|
V |
|
|
S |
T5T_LOGRAD |
C |
100 |
0 |
Descr. Log |
@! |
|
|
R |
|
|
S |
T5T_NRLOG |
C |
10 |
0 |
Numero Log. |
@! |
|
|
R |
|
|
S |
T5T_COMLOG |
C |
30 |
0 |
Compl. Log |
@! |
|
|
R |
|
|
S |
T5T_BAIRRO |
C |
90 |
0 |
Bairro |
@! |
|
|
R |
|
|
S |
T5T_CEP |
C |
8 |
0 |
CEP |
@R 99.999-999 |
|
|
R |
|
|
S |
T5T_NOMCID |
C |
50 |
0 |
Nome Cid Ext |
@! |
|
|
R |
|
|
S |
T5T_CXPOST |
C |
12 |
0 |
Caixa Postal |
@! |
|
|
R |
|
|
S |
T5T_TPPLRP |
C |
1 |
0 |
Tp Plano RP |
@! |
Pertence("12") |
|
R |
1=Plano previd. ou unico;2=Plano financeiro |
|
S |
T5T_TPBENE |
C |
6 |
0 |
Tp. Benef. |
@! |
xFunVldCmp("T5G",1) |
T5G |
R |
|
|
S |
T5T_DTPBEN |
C |
220 |
0 |
Des Tp Ben. |
@! |
|
|
V |
|
|
S |
T5T_NUMBEN |
C |
20 |
0 |
Num. Benef. |
@! |
|
|
R |
|
|
S |
T5T_DTINIB |
D |
8 |
0 |
Dt Ini Benef |
|
|
|
R |
|
|
S |
T5T_VLRBEN |
N |
16 |
2 |
Vl Beneficio |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
T5T_IDQUOT |
C |
30 |
0 |
Id Quota Ben |
@! |
|
|
R |
|
|
S |
T5T_CPFINS |
C |
11 |
0 |
CPF Instit. |
@R 999.999.999-99 |
xFunVldPJF(,1,.F.) |
|
R |
|
|
S |
T5T_DTFIMB |
D |
8 |
0 |
Dt Fim Benef |
|
|
|
R |
|
|
S |
T5T_MTVFIM |
C |
6 |
0 |
Motivo Fim |
@! |
xFunVldCmp("T5H",1) |
T5H |
R |
|
|
S |
T5T_DMTVFI |
C |
220 |
0 |
Des Motv Fim |
@! |
|
|
V |
|
|
S |
T5T_VERANT |
C |
14 |
0 |
Id. Ver. Ant |
@! |
|
|
R |
|
|
S |
T5T_STATUS |
C |
1 |
0 |
Status Reg. |
@! |
Pertence(" 012349") |
|
R |
0=Reg.Valido;1=Reg.Invalido;2=Reg.Transmitido;3=Reg.Transmitido com inconsistencias;4=Reg.Transmitido valido;9=Em Processamento |
|
S |
T5T_PROTUL |
C |
44 |
0 |
Ult.Prot.Tr. |
@! |
|
|
R |
|
|
S |
T5T_PROTPN |
C |
44 |
0 |
Pnlt.Prot.Tr |
@! |
|
|
R |
|
|
S |
T5T_EVENTO |
C |
1 |
0 |
Id. Evento |
@! |
Pertence("IAE") |
|
R |
I=Inclusao;A=Alteracao;E=Exclusao |
|
S |
T5T_ATIVO |
C |
1 |
0 |
Reg. Ativo? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
T5T_XMLID |
C |
36 |
0 |
Id do XML. |
|
|
|
R |
|
|
S |
T5T_LOGOPE |
C |
1 |
0 |
Log Operacao |
@! |
|
|
R |
1=Incl.Integr;2=Incl.Manual;3=Incl.Integr+Alt.Integr;4=Incl.Integr+Alt.Manual;5=Incl.Manual+Alt.Integr;6=Incl.Manual+Alt.Manual |
|
S |