| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| T1U | Alteracao de Dados Cadastrais | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| T1U_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| T1U_ID | C | 6 | 0 | ID | @! | R | S | ||||
| T1U_VERSAO | C | 14 | 0 | Id. Ver. Reg | @! | R | S | ||||
| T1U_CPF | C | 11 | 0 | CPF | @R 999.999.999-99 | XFUNVldUni("T1U",4,M->T1U_CPF+DTOS(FWFLDGET("T1U_DTALT") ) +'1') | R | S | |||
| T1U_NOME | C | 70 | 0 | Nome | @! | R | S | ||||
| T1U_DTALT | D | 8 | 0 | Dt. Alterac. | XFUNVldUni("T1U",4,FWFLDGET("T1U_CPF")+DTOS(M->T1U_DTALT)+'1') | R | S | ||||
| T1U_NIS | C | 11 | 0 | NIS | @! | R | S | ||||
| T1U_SEXO | C | 1 | 0 | Sexo | @! | Pertence(" MF") | R | M=Masculino;F=Feminino | S | ||
| T1U_RCCOR | C | 1 | 0 | Raca/Cor | @! | Pertence(" 12345") | R | 1=Branca;2=Negra;3=Parda;4=Amarela;5=Indigena;6=Nao Informado | S | ||
| T1U_ESTCIV | C | 1 | 0 | Estado Civil | @! | Pertence(" 12345") | R | 1=Solteiro;2=Casado;3=Divorciado;4=Separado;5=Viuvo | S | ||
| T1U_GRINST | C | 6 | 0 | Id Grau Inst | @! | xFunVldCmp("CMH",,,,2,.T.) | CMH | R | S | ||
| T1U_DGRINS | C | 220 | 0 | Des Grau Ins | @! | V | S | ||||
| T1U_NRCTPS | C | 11 | 0 | Num. CTPS | @! | R | S | ||||
| T1U_SERCTP | C | 6 | 0 | Serie CTPS | @! | R | S | ||||
| T1U_UFCTPS | C | 6 | 0 | Id. UF CTPS | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| T1U_DUFCTP | C | 220 | 0 | Desc UF CTPS | @! | V | S | ||||
| T1U_NRRIC | C | 14 | 0 | Nr DNI | @! | R | S | ||||
| T1U_OREMRI | C | 20 | 0 | OrgUF EmiRIC | @! | R | S | ||||
| T1U_DTEXRI | D | 8 | 0 | Dt. Exp. RIC | R | S | |||||
| T1U_NRRG | C | 14 | 0 | Num. RG | @! | R | S | ||||
| T1U_OREMRG | C | 20 | 0 | OrgUF EmiRG | @! | R | S | ||||
| T1U_DTEMRG | D | 8 | 0 | Dt. Exp. RG | R | S | |||||
| T1U_NRRNE | C | 14 | 0 | Num. RNE | @! | R | S | ||||
| T1U_OREMRN | C | 20 | 0 | OrgUF EmiRNE | @! | R | S | ||||
| T1U_DTEMRN | D | 8 | 0 | Dt. Exp. RNE | R | S | |||||
| T1U_NUMOC | C | 14 | 0 | Num. OC | @! | R | S | ||||
| T1U_OREMOC | C | 20 | 0 | OrgUF EmiOC | @! | R | S | ||||
| T1U_DTEXOC | D | 8 | 0 | Dt. Exp. OC | R | S | |||||
| T1U_DTVLOC | D | 8 | 0 | Dt. Val. OC | R | S | |||||
| T1U_NRCNH | C | 12 | 0 | Num. CNH | @! | R | S | ||||
| T1U_DTEXCN | D | 8 | 0 | Dt. Exp. CNH | R | S | |||||
| T1U_UFCNH | C | 6 | 0 | UF CNH | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| T1U_DUFCN | C | 220 | 0 | Desc. UF CNH | @! | V | S | ||||
| T1U_DTVLCN | D | 8 | 0 | Dt. Val. CNH | R | S | |||||
| T1U_DTPCNH | D | 8 | 0 | Primeira CNH | R | S | |||||
| T1U_CATCNH | C | 1 | 0 | Categ. CNH | @! | Pertence(" 123456789") | R | 1=A;2=B;3=C;4=D;5=E;6=AB;7=AC;8=AD;9=AE | S | ||
| T1U_PAIS | C | 6 | 0 | Id Pais End | @! | xFunVldCmp("C08",3) | C08 | R | S | ||
| T1U_DPAIS | C | 220 | 0 | Des Pais End | @! | V | S | ||||
| T1U_UF | C | 6 | 0 | Id. UF End. | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| T1U_DUF | C | 220 | 0 | Descr UF End | @! | V | S | ||||
| T1U_MUN | C | 6 | 0 | Id. Mun. End | @! | xFunVldCmp("C07",3) | C07 | R | S | ||
| T1U_DMUN | C | 220 | 0 | Des Mun End | @! | V | S | ||||
| T1U_NOMCID | C | 50 | 0 | Nome Cid Ext | @! | R | S | ||||
| T1U_TPLOGR | C | 6 | 0 | Id. Tp. Log. | @! | xFunVldCmp("C06",3) | C06 | R | S | ||
| T1U_DTPLOG | C | 220 | 0 | Des Tp Log | @! | V | S | ||||
| T1U_LOGRAD | C | 100 | 0 | Descr. Logr. | @! | R | S | ||||
| T1U_NRLOG | C | 10 | 0 | Numero Log. | @! | R | S | ||||
| T1U_COMLOG | C | 30 | 0 | Comp. Log. | @! | R | S | ||||
| T1U_BAIRRO | C | 90 | 0 | Bairro | @! | R | S | ||||
| T1U_CEP | C | 10 | 0 | CEP | @! | R | S | ||||
| T1U_APOSEN | C | 1 | 0 | Aposentado? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_DTCHEG | D | 8 | 0 | Dt. Chegada | R | S | |||||
| T1U_CCTRAE | C | 6 | 0 | Cond. Trab. | @! | xFunVldCmp("T13",1) | T13 | R | S | ||
| T1U_DCONTE | C | 220 | 0 | Desc. Cond T | @! | V | S | ||||
| T1U_CASBRA | C | 1 | 0 | Cas. Brasil? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_FILBRA | C | 1 | 0 | Fil. Brasil? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_DEFFIS | C | 1 | 0 | Def.Fisica ? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_DEFVIS | C | 1 | 0 | Def. Visual? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_DEFAUD | C | 1 | 0 | Def. Audit? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_DEFMEN | C | 1 | 0 | Def. Mental? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_DEFINT | C | 1 | 0 | Def.Intelec? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_REABIL | C | 1 | 0 | Reab/Readap? | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_OBSDEF | M | 10 | 0 | Obs Info Def | @! | R | S | ||||
| T1U_DDDFPR | C | 3 | 0 | DDD Fone Pri | @R 999 | R | S | ||||
| T1U_FONPRC | C | 10 | 0 | Fone Princ. | @R 9999999999 | R | S | ||||
| T1U_DDDFAL | C | 3 | 0 | DDD Fone Alt | @! | R | S | ||||
| T1U_FONALT | C | 10 | 0 | Fone Altern. | @R 9999999999 | R | S | ||||
| T1U_EMAILP | C | 60 | 0 | Email Prin. | @! | R | S | ||||
| T1U_EMAILA | C | 60 | 0 | Email Altern | @! | R | S | ||||
| T1U_PROTUL | C | 44 | 0 | Ult. Prot. | @! | R | S | ||||
| T1U_PROTPN | C | 44 | 0 | Pnlt. Prot. | @! | R | S | ||||
| T1U_STATUS | C | 1 | 0 | Status Reg. | @! | R | S | ||||
| T1U_VERANT | C | 14 | 0 | Ver Ant Reg | @! | R | S | ||||
| T1U_ATIVO | C | 1 | 0 | Reg. Ativo? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| T1U_EVENTO | C | 1 | 0 | Id. Evento | @! | Pertence("IAE") | R | I=Inclusao;A=Alteracao;E=Exclusao | S | ||
| T1U_NOMSOC | C | 70 | 0 | Nome Social | @! | R | S | ||||
| T1U_INFCOT | C | 1 | 0 | Cota Defic. | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| T1U_STASEC | C | 1 | 0 | StatusSecund | @! | R | S | ||||
| T1U_XMLID | C | 36 | 0 | Id do XML. | R | S | |||||
| T1U_DINSIS | D | 8 | 0 | Dt Inc Sist | R | S | |||||
| T1U_DTNASC | D | 8 | 0 | Data Nascim. | R | S | |||||
| T1U_CODPAI | C | 6 | 0 | Id Pais Nasc | @! | xFunVldCmp("C08",3) | C08 | R | S | ||
| T1U_DCODPA | C | 220 | 0 | Des Pais Nas | @! | V | S | ||||
| T1U_CODUF | C | 6 | 0 | Id. UF Nasc. | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| T1U_DCODUF | C | 220 | 0 | Descr UF Nas | V | S | |||||
| T1U_CODMUN | C | 6 | 0 | Id. Mun. Nas | @! | xFunVldCmp("C07",3) | C07 | R | S | ||
| T1U_DCODMU | C | 220 | 0 | Des Mun Nasc | @! | V | S | ||||
| T1U_PAINAC | C | 6 | 0 | Id. Pais Nac | @! | xFunVldCmp("C08",3) | C08 | R | S | ||
| T1U_DPAINA | C | 220 | 0 | Des Pais Nac | @! | R | S | ||||
| T1U_NOMMAE | C | 70 | 0 | Nome Mae | @! | R | S | ||||
| T1U_NOMPAI | C | 70 | 0 | Nome Pai | @! | R | S | ||||
| T1U_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 | |||