| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CUU | Informacao TSV | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CUU_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CUU_ID | C | 6 | 0 | ID | @! | R | S | ||||
| CUU_VERSAO | C | 14 | 0 | Id. Ver. Reg | @! | R | S | ||||
| CUU_DTINAV | D | 8 | 0 | Dt. Ingresso | R | S | |||||
| CUU_CATAV | C | 6 | 0 | Id. Categ. | @! | xFunVldCmp("C87",,,,2,.T.) | C87 | R | S | ||
| CUU_DCATAV | C | 220 | 0 | Descr. Categ | @! | V | S | ||||
| CUU_DTINCI | D | 8 | 0 | Dt. Ingresso | R | S | |||||
| CUU_CATCI | C | 6 | 0 | Id. Categ. | @! | xFunVldCmp("C87",,,,2,.F.) | C87 | R | S | ||
| CUU_DCATCI | C | 220 | 0 | Descr. Categ | @! | V | S | ||||
| CUU_CARCI | C | 6 | 0 | Id. Cargo | @! | xFunVldCmp("C8V",,,,2,,.F.) | C8V | R | S | ||
| CUU_DCARCI | C | 220 | 0 | Descr. Cargo | @! | V | S | ||||
| CUU_FUNCI | C | 6 | 0 | Id. Funcao | @! | xFunVldCmp("C8X",,,,2,,.F.) | C8X | R | S | ||
| CUU_DFUNCI | C | 220 | 0 | Descr Funcao | @! | V | S | ||||
| CUU_CBOCI | C | 6 | 0 | Id. CBO | @! | xFunVldCmp("C8Z",,,,2) | C8Z | R | S | ||
| CUU_DCBOCI | C | 220 | 0 | Descr. CBO | @! | V | S | ||||
| CUU_VLSLCI | N | 16 | 2 | Vlr Sal Fixo | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_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 | ||
| CUU_DSVRCI | C | 254 | 0 | Desc Sal Var | @! | R | S | ||||
| CUU_OPFGCI | C | 1 | 0 | Optante FGTS | @! | Pertence(" 12") | R | 1=Optante;2=Nao Optante | S | ||
| CUU_DTFGCI | D | 8 | 0 | Dt. Opcao | R | S | |||||
| CUU_DTINSP | D | 8 | 0 | Data Posse | R | S | |||||
| CUU_CATSP | C | 6 | 0 | Id. Categ. | @! | xFunVldCmp("C87",,,,2,.F.) | C87 | R | S | ||
| CUU_DCATSP | C | 220 | 0 | Descr. Categ | @! | V | S | ||||
| CUU_CARSP | C | 6 | 0 | Id. Cargo | @! | xFunVldCmp("C8V",,,,2,,.F.) | C8V | R | S | ||
| CUU_DCARSP | C | 220 | 0 | Descr. Cargo | @! | V | S | ||||
| CUU_FUNSP | C | 6 | 0 | Id. Funcao | @! | xFunVldCmp("C8X",,,,2,,.F.) | C8X | S | |||
| CUU_DFUNSP | C | 220 | 0 | Descr Funcao | @! | V | S | ||||
| CUU_CBOSP | C | 6 | 0 | Id. CBO | @! | xFunVldCmp("C8Z",,,,2) | C8Z | R | S | ||
| CUU_DCBOSP | C | 220 | 0 | Descr. CBO | @! | V | S | ||||
| CUU_VLSLSP | N | 16 | 2 | Vlr Sal Fixo | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_UNSLSP | C | 1 | 0 | Uni Sal Fixo | @! | Pertence(" 123456") | R | 1=Por Hora;2=Por Dia;3=Por Semana;4=Por Quinzena;5=Por Mes;6=Por Tarefa | S | ||
| CUU_DSVRSP | C | 90 | 0 | Desc Sal Var | @! | R | S | ||||
| CUU_DTINDS | D | 8 | 0 | Data Inicio | R | S | |||||
| CUU_CATDS | C | 6 | 0 | Id. Categ. | @! | xFunVldCmp("C87",,,,2,.F.) | C87 | R | S | ||
| CUU_DCATDS | C | 220 | 0 | Descr. Categ | @! | V | S | ||||
| CUU_CATODS | C | 6 | 0 | Id Categ Ori | @! | xFunVldCmp("C87",,,,2,.F.) | C87 | R | S | ||
| CUU_DCATOD | C | 220 | 0 | Desc Cat Ori | @! | V | S | ||||
| CUU_CNPJDS | C | 14 | 0 | CNPJ Emp Ori | @R 99.999.999/9999-99 | xFunVldPJF(,2,.F.) | R | S | |||
| CUU_DTADDS | D | 8 | 0 | Dt. Adm. Ori | R | S | |||||
| CUU_MATODS | C | 30 | 0 | Matric. Ori. | @! | R | S | ||||
| CUU_DTINES | D | 8 | 0 | Data Inicio | R | S | |||||
| CUU_CATES | C | 6 | 0 | Id. Categ. | @! | xFunVldCmp("C87",,,,2,.F.) | C87 | R | S | ||
| CUU_DCATES | C | 220 | 0 | Descr. Categ | @! | V | S | ||||
| CUU_NATEES | C | 1 | 0 | Nat. Estagio | @! | Pertence(" ON") | R | O=Obrigatorio;N=Nao Obrigatorio | S | ||
| CUU_NIVEES | C | 1 | 0 | Niv. Estagio | @! | Pertence(" 123489") | R | 1=Fundamental;2=Medio;3=Formacao Profissional;4=Superior;8=Especial;9=Mae social. (Lei 7644, de 1987) | S | ||
| CUU_AREAES | C | 50 | 0 | Area Atuacao | @! | R | S | ||||
| CUU_NRAPES | C | 30 | 0 | Nr. Apolice | @! | R | S | ||||
| CUU_VLBLES | N | 16 | 2 | Vlr. Bolsa | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_DTTEES | D | 8 | 0 | Dt Prev Term | R | S | |||||
| CUU_CNPEES | C | 14 | 0 | CNPJ Ins Ens | @R 99.999.999/9999-99 | xFunVldPJF(,2,.F.) | R | S | |||
| CUU_NOMEES | C | 100 | 0 | Nome Ins Ens | @! | R | S | ||||
| CUU_LOGEES | C | 100 | 0 | Log Inst Ens | @! | R | S | ||||
| CUU_NLGEES | C | 10 | 0 | Nr Log Inst | @! | R | S | ||||
| CUU_BAREES | C | 90 | 0 | Bairro Inst. | @! | R | S | ||||
| CUU_CEPES | C | 8 | 0 | CEP Inst Ens | @R 99999-999 | R | S | ||||
| CUU_UFES | C | 6 | 0 | Id. UF Inst. | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| CUU_DUFES | C | 220 | 0 | Des UF Inst. | @! | V | S | ||||
| CUU_MUNES | C | 6 | 0 | Id. Mun. Ins | @! | xFunVldCmp("C07",3) | C07 | R | S | ||
| CUU_DMUNES | C | 220 | 0 | Des Mun Inst | @! | V | S | ||||
| CUU_CNPAES | C | 14 | 0 | CNPJ Ag. Int | @R 99.999.999/9999-99 | R | S | ||||
| CUU_NOMAES | C | 100 | 0 | Nome Ag. Int | @! | R | S | ||||
| CUU_LOGAES | C | 100 | 0 | Log. Ag. Int | @! | R | S | ||||
| CUU_NLGAES | C | 10 | 0 | Nr. Log. Ag. | @! | R | S | ||||
| CUU_BARAES | C | 90 | 0 | Bairro Ag. | @! | R | S | ||||
| CUU_CEPAES | C | 8 | 0 | CEP Ag. Int. | @R 99999-999 | R | S | ||||
| CUU_UFAES | C | 6 | 0 | Id. UF Ag. | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| CUU_DUFAES | C | 220 | 0 | Descr. UF Ag | @! | V | S | ||||
| CUU_MUNAES | C | 6 | 0 | Id. Mun. Ag. | @! | xFunVldCmp("C07",3) | C07 | R | S | ||
| CUU_DMUNAE | C | 220 | 0 | Desc Mun Ag | @! | V | S | ||||
| CUU_CPFCES | C | 11 | 0 | CPF Sup. Est | @R 999.999.999-99 | xFunVldPJF(,1,.F.) | R | S | |||
| CUU_NOMCES | C | 70 | 0 | Nome Sup. | @! | R | S | ||||
| CUU_DTERAV | D | 8 | 0 | Dt. Termino | R | S | |||||
| CUU_DTERCI | D | 8 | 0 | Dt. Termino | R | S | |||||
| CUU_TPDDCI | C | 6 | 0 | Id. Tp. Desl | @! | xFunVldCmp("CML",,,,2,.T.) | CML | R | S | ||
| CUU_DTPDDC | C | 220 | 0 | Des Tp. Desl | @! | V | S | ||||
| CUU_BCCPCI | N | 16 | 2 | BC Cont Prev | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_BCIRCI | N | 16 | 2 | BC. IRRF | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_BCFGCI | N | 16 | 2 | BC. FGTS | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_BCMACI | N | 16 | 2 | BC. FGTS Mes | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_VDCPCI | N | 16 | 2 | Vlr Desc Seg | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_VPRVCI | N | 16 | 2 | Vlr. Proven. | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_VDESCI | N | 16 | 2 | Vlr Descont. | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_VLIQCI | N | 16 | 2 | Vlr. Liquido | @E 9,999,999,999,999.99 | R | S | ||||
| CUU_DTTESP | D | 8 | 0 | Dt. Termino | R | S | |||||
| CUU_DTTEDS | D | 8 | 0 | Dt. Termino | R | S | |||||
| CUU_DTERES | D | 8 | 0 | Dt. Termino | R | S | |||||
| CUU_NOMEVE | C | 5 | 0 | Nome Evento | @! | R | S | ||||
| CUU_NATATV | C | 1 | 0 | Nat Atividad | @! | Pertence(" 12") | R | 1=Trabalho Urbano;2=Trabalho Rural | S | ||
| CUU_DTQUA | D | 8 | 0 | Dt Fim Quar | R | S | |||||
| CUU_ONUSCE | C | 1 | 0 | Onus Cessao | @! | Pertence(" 123") | R | 1=Cedente;2=Cessionario;3=Cedente e Cessionario | S | ||
| CUU_CNPJTC | C | 14 | 0 | CNPJ Emp Ced | @R 99.999.999/9999-99 | xFunVldPJF(,2,.F.) | S | ||||
| CUU_MOTDES | C | 6 | 0 | Mot. Deslig. | @! | xFunVldCmp("CML",,,,2,.T.) | CML | R | S | ||
| CUU_DMOTDE | C | 220 | 0 | Descr Motivo | @! | V | S | ||||
| CUU_MATRCE | C | 30 | 0 | Mat Emp Ced | @! | R | S | ||||
| CUU_DTADTC | D | 8 | 0 | Dt Adm Ced | R | S | |||||
| CUU_INDMVI | C | 1 | 0 | Ind.Mult.Vin | @! | Pertence(" 123") | R | 1=Contrib descontada pelo empregador;2=Contrib descontada por outra empresa;3=Contrib sobre o limite max de salario de contrib | S | ||
| CUU_TPREGT | C | 1 | 0 | Tp Reg Trab | @! | Pertence(" 12") | R | 1=CLT - Consolidacao das Leis de Trabalho;2=Estatutario | S | ||
| CUU_TPREGP | C | 1 | 0 | Tp Reg Prev | @! | Pertence(" 123") | R | 1=RGPS-Reg. Geral Previdencia Social;2=RPPS-Reg. Proprio Previdencia Social;3=RPSE-Reg. Previdencia Social no Exterior | S | ||
| CUU_DTINIA | D | 8 | 0 | Ini. Afastam | R | S | |||||
| CUU_MOTVAF | C | 6 | 0 | Cod.Mot.Afas | @! | XFUNVldCmp("C8N",,,,2,.T.) | C8N | R | S | ||
| CUU_DMOTVA | C | 220 | 0 | Desc.Mot.Afa | @! | V | S | ||||
| CUU_DTTERM | D | 8 | 0 | Dt. Termino | R | S | |||||
| CUU_STASEC | C | 1 | 0 | StatusSecund | @! | R | S | ||||
| CUU_DINSIS | D | 8 | 0 | Dt Inc Sist | R | S | |||||