| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| T0F | Alteracao Informacao TSV | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| T0F_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| T0F_ID | C | 6 | 0 | ID | @! | R | S | ||||
| T0F_VERSAO | C | 14 | 0 | Id. Ver. Reg | @! | R | S | ||||
| T0F_NOME | C | 70 | 0 | Nome | @! | R | S | ||||
| T0F_CPF | C | 11 | 0 | CPF | @R 999.999.999-99 | xFunVldPJF(,1,.F.) .And. XFUNVldUni("T0F",3,M->T0F_CPF+ DTOS(FWFLDGET("T0F_DTALT"))+'1') | R | S | |||
| T0F_DTALT | D | 8 | 0 | Dt.Alteracao | XFUNVldUni("T0F",3,FWFLDGET("T0F_CPF") + DTOS(M->T0F_DTALT) +'1') | R | S | ||||
| T0F_NATATV | C | 1 | 0 | Nat Atividad | @! | Pertence(" 12") | R | 1=Trabalhador Urbano;2=Trabalhador Rural | S | ||
| T0F_CARCI | C | 6 | 0 | Id. Cargo | @! | xFunVldCmp("C8V",,,,2,,.F.) | C8V | R | S | ||
| T0F_DCARCI | C | 220 | 0 | Descr. Cargo | @! | V | S | ||||
| T0F_CATAV | C | 6 | 0 | Id. Categ. | @! | xFunVldCmp("C87",,,,2,.F.) | C87 | R | S | ||
| T0F_DCATAV | C | 220 | 0 | Descr. Categ | @! | V | S | ||||
| T0F_VLSLCI | N | 16 | 2 | Vlr Sal Fixo | @E 9,999,999,999,999.99 | R | S | ||||
| T0F_UNSLCI | C | 1 | 0 | Uni Sal Fixo | @! | Pertence(" 1234567") | R | 1=Por Hora;2=Por Dia;3=Por Semana;4=Por Quinzena;5=Por Mes;6=Por Tarefa;7=Nao aplicavel - salario exclusivamente variavel. | S | ||
| T0F_DSVRCI | C | 254 | 0 | Desc Sal Var | @! | R | S | ||||
| T0F_NATEES | C | 1 | 0 | Nat. Estagio | @! | Pertence(" ON") | R | O=Obrigatorio;N=Nao Obrigatorio | S | ||
| T0F_NIVEES | C | 1 | 0 | Niv. Estagio | @! | Pertence(" 123489") | R | 1=Fundamental;2=Medio;3=Formacao Profissional;4=Superior;8=Especial;9=Mae Social | S | ||
| T0F_AREAES | C | 50 | 0 | Area Atuacao | @! | R | S | ||||
| T0F_NRAPES | C | 30 | 0 | Nr. Apolice | @! | R | S | ||||
| T0F_VLBLES | N | 16 | 2 | Vlr. Bolsa | @E 9,999,999,999,999.99 | R | S | ||||
| T0F_DTTEES | D | 8 | 0 | Dt Prev Term | R | S | |||||
| T0F_CNPEES | C | 14 | 0 | CNPJ Ins Ens | @R 99.999.999/9999-99 | xFunVldPJF(,2,.F.) | R | S | |||
| T0F_NOMEES | C | 100 | 0 | Nome Ins Ens | @! | R | S | ||||
| T0F_LOGEES | C | 100 | 0 | Log Inst Ens | @! | R | S | ||||
| T0F_NLGEES | C | 10 | 0 | Nr Log Inst | @! | R | S | ||||
| T0F_BAREES | C | 90 | 0 | Bairro Inst. | @! | R | S | ||||
| T0F_CEPES | C | 8 | 0 | CEP Ag. Int. | @R 99999-999 | R | S | ||||
| T0F_MUNES | C | 6 | 0 | Id. Mun. Ag. | @! | xFunVldCmp("C07",3) | C07 | R | S | ||
| T0F_DMUNES | C | 220 | 0 | Desc Mun Ag | @! | V | S | ||||
| T0F_UFES | C | 6 | 0 | Id. UF Ag. | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| T0F_DUFES | C | 220 | 0 | Des UF Inst. | @! | V | S | ||||
| T0F_CNPAES | C | 14 | 0 | CNPJ Ag. Int | @R 99.999.999/9999-99 | R | S | ||||
| T0F_NOMAES | C | 100 | 0 | Nome Ag. Int | @! | R | S | ||||
| T0F_LOGAES | C | 100 | 0 | Log. Ag. Int | @! | R | S | ||||
| T0F_NLGAES | C | 10 | 0 | Nr. Log. Ag. | @! | R | S | ||||
| T0F_BARAES | C | 90 | 0 | Bairro Ag. | @! | R | S | ||||
| T0F_CEPAES | C | 8 | 0 | CEP Ag. Int. | @! | R | S | ||||
| T0F_MUNAES | C | 6 | 0 | Id. Mun. Ag. | @! | xFunVldCmp("C07",3) | C07 | R | S | ||
| T0F_DMUNAE | C | 220 | 0 | Desc Mun Ag | @! | V | S | ||||
| T0F_UFAES | C | 6 | 0 | Id. UF Ag. | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| T0F_DUFAES | C | 220 | 0 | Descr. UF Ag | @! | V | S | ||||
| T0F_CPFCES | C | 11 | 0 | CPF Sup. Est | @R 999.999.999-99 | R | S | ||||
| T0F_NOMCES | C | 70 | 0 | Nome Sup. | @! | R | S | ||||
| T0F_PROTUL | C | 44 | 0 | Ult. Prot. | @! | R | S | ||||
| T0F_PROTPN | C | 44 | 0 | Pnlt. Prot. | @! | R | S | ||||
| T0F_STATUS | C | 1 | 0 | Status Reg. | @! | R | S | ||||
| T0F_VERANT | C | 14 | 0 | Ver Ant Reg. | @! | R | S | ||||
| T0F_ATIVO | C | 1 | 0 | Reg. Ativo? | @! | R | 1=Sim;2=Nao | S | |||
| T0F_EVENTO | C | 1 | 0 | Id. Evento | @! | R | I=Inclusao;A=Alteracao;E=Exclusao | S | |||
| T0F_NIS | C | 11 | 0 | NIS | @! | R | S | ||||
| T0F_FUNCI | C | 6 | 0 | Id. Funcao | @! | xFunVldCmp("C8X",,,,2,,.F.) | C8X | R | S | ||
| T0F_DFUNCI | C | 220 | 0 | Descr Funcao | @! | V | S | ||||
| T0F_STASEC | C | 1 | 0 | StatusSecund | @! | R | S | ||||
| T0F_XMLID | C | 36 | 0 | Id do XML. | R | S | |||||
| T0F_DINSIS | D | 8 | 0 | Dt Inc Sist | R | S | |||||
| T0F_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 | |||