Tabela |
CUP |
Cadastro Inicial do Vinculo |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
CUP_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
CUP_ID |
C |
6 |
0 |
ID |
@! |
|
|
R |
|
|
S |
CUP_VERSAO |
C |
14 |
0 |
Id. Ver. Reg |
@! |
|
|
R |
|
|
S |
CUP_MATRIC |
C |
30 |
0 |
Matricula |
@! |
|
|
R |
|
|
S |
CUP_DTADMI |
D |
8 |
0 |
Dt. Admissao |
|
|
|
R |
|
|
S |
CUP_TPADMI |
C |
1 |
0 |
Tp. Admissao |
@! |
Pertence(" 123456") |
|
R |
#CboTpAdmiss() |
|
S |
CUP_INDADM |
C |
1 |
0 |
Ind Admissao |
@! |
Pertence(" 123") |
|
R |
1=Normal;2=Decorrente de Acao Fiscal;3=Decorrente de Decisao Judicial |
|
S |
CUP_INDPRE |
C |
1 |
0 |
Ind Prim Emp |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
CUP_TPREGT |
C |
1 |
0 |
Tp Reg Trab |
@! |
Pertence(" 12") |
|
R |
1=CLT - Consolidacao das Leis de Trabalho;2=Estatutario |
|
S |
CUP_TPREGP |
C |
1 |
0 |
Tp Reg Prev |
@! |
Pertence(" 123") |
|
R |
1=Reg. Geral da Previdencia Social - RGPS;2=Reg. Proprio de Previdencia Social - RPPS;3=Reg. de Previdencia Social no Exterior |
|
S |
CUP_TPREGJ |
C |
1 |
0 |
Tp Reg Jor |
@! |
Pertence(" 1234") |
|
R |
#CboTpRegJ() |
|
S |
CUP_NATATV |
C |
1 |
0 |
Nat. Ativid. |
@! |
Pertence(" 12") |
|
R |
1=Trabalho Urbano;2=Trabalho Rural |
|
S |
CUP_CODCAT |
C |
6 |
0 |
Id. Cat |
@! |
xFunVldCmp("C87",,,,2,.F.) |
C87 |
R |
|
|
S |
CUP_DCODCA |
C |
220 |
0 |
Des. Cat |
@! |
|
|
V |
|
|
S |
CUP_CODFUN |
C |
6 |
0 |
Cod. Funcao |
@! |
xFunVldCmp("C8X",,,,2,,.F.) |
C8X |
R |
|
|
S |
CUP_DCODFU |
C |
220 |
0 |
Descr Funcao |
@! |
|
|
V |
|
|
S |
CUP_CODCGO |
C |
6 |
0 |
Cod. Cargo |
@! |
xFunVldCmp("C8V",,,,2,,.F.) |
C8V |
R |
|
|
S |
CUP_DCODCG |
C |
220 |
0 |
Descr. Cargo |
@! |
|
|
V |
|
|
S |
CUP_CODCBO |
C |
6 |
0 |
Cod.Ocupacao |
@! |
xFunVldCmp("C8Z",,,,2,,.F.) |
C8Z |
R |
|
|
S |
CUP_DCODCB |
C |
220 |
0 |
Desc.Ocupac. |
@! |
|
|
V |
|
|
S |
CUP_DATAB |
C |
2 |
0 |
Data Base |
99 |
|
|
R |
|
|
S |
CUP_VLSLFX |
N |
16 |
2 |
Vlr Sal Fixo |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CUP_UNSLFX |
C |
1 |
0 |
Und 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 |
CUP_DESSVR |
C |
254 |
0 |
Desc Sal Var |
@! |
|
|
R |
|
|
S |
CUP_TPCONT |
C |
1 |
0 |
Tp. Contrato |
@! |
Pertence(" 123") |
|
R |
1=Prazo indeterminado;2=Prazo determinado, definido em dias;3=Prazo determinado, vinculado a ocorrencia de um fato. |
|
S |
CUP_DTTERM |
D |
8 |
0 |
Dt Term Con |
|
|
|
R |
|
|
S |
CUP_MOTCON |
C |
1 |
0 |
Hipot. Legal |
@! |
Pertence(" 12") |
|
R |
1=Necessidade de substituicao transitoria de pessoal permanente;2=Demanda complementar de servicos. |
|
S |
CUP_CPFTRS |
C |
11 |
0 |
Cpf Trab.Sub |
@R 999.999.999-99 |
xFunVldPJF(,1,.F.) |
|
R |
|
|
S |
CUP_MATSUB |
C |
30 |
0 |
Mat.Trab.Sub |
@! |
|
|
R |
|
|
S |
CUP_TPINSC |
C |
1 |
0 |
Tp Inscricao |
@! |
Pertence(" 1234") .and. XVldTNrIns(M->CUP_TPINSC,FWFLDGET("CUP_NRINSC")) |
|
R |
1=CNPJ;2=CPF;3=CAEPF;4=CNO |
|
S |
CUP_NRINSC |
C |
15 |
0 |
Nr Inscricao |
@! |
XVldTNrIns(FWFLDGET("CUP_TPINSC"),M->CUP_NRINSC) |
|
R |
|
|
S |
CUP_CODLOT |
C |
6 |
0 |
Id. Lotacao |
@! |
xFunVldCmp("C99",,,,2,,.F.) |
C99 |
R |
|
|
S |
CUP_DCODLO |
C |
220 |
0 |
Desc. Compl. |
@! |
|
|
V |
|
|
S |
CUP_DESLOT |
C |
80 |
0 |
Desc. Compl. |
@! |
|
|
R |
|
|
S |
CUP_QTDHJS |
N |
5 |
2 |
Qtd. Horas |
@E 99.99 |
|
|
R |
|
|
S |
CUP_CNPJSD |
C |
14 |
0 |
CNPJ Sind. |
@R 99.999.999/9999-99 |
xFunVldPJF(,2,.F.) |
|
R |
|
|
S |
CUP_ALVJUD |
C |
6 |
0 |
Id Proc Jud |
@! |
xFunVldCmp("C1G",3) |
C1G |
R |
|
|
S |
CUP_DALVJU |
C |
220 |
0 |
Des Proc Jud |
@! |
|
|
V |
|
|
S |
CUP_FGTSOP |
C |
1 |
0 |
Opt. FGTS? |
Pertence(" 12") |
|
|
R |
1=Optante;2=Nao Optante |
|
S |
CUP_DTFGTS |
D |
8 |
0 |
Dt. Op. FGTS |
|
|
|
R |
|
|
S |
CUP_CNPJEA |
C |
14 |
0 |
CNPJ Emp Ant |
@! |
XVldTNrIns(FWFLDGET("CUP_INSANT"),M->CUP_CNPJEA) |
|
R |
|
|
S |
CUP_MATANT |
C |
30 |
0 |
Matr. Ant. |
@! |
|
|
R |
|
|
S |
CUP_DTINVI |
D |
8 |
0 |
Dt.Ini.Vinc |
|
|
|
R |
|
|
S |
CUP_OBSVIN |
M |
10 |
0 |
Obs Vinc Ant |
@! |
|
|
R |
|
|
S |
CUP_CNPJCD |
C |
14 |
0 |
CNPJ Cedente |
@R 99.999.999/9999-99 |
xFunVldPJF(,2,.F.) |
|
R |
|
|
S |
CUP_MATRCD |
C |
30 |
0 |
Mat. Cedente |
@! |
|
|
R |
|
|
S |
CUP_DTADCD |
D |
8 |
0 |
Dt Adm Ced |
|
|
|
R |
|
|
S |
CUP_INFOCD |
C |
1 |
0 |
Inf Onus Ced |
@! |
Pertence(" 123") |
|
R |
1=Onus do Cedente;2=Onus do Cessionario;3=Onus do Cedente e Cessionario |
|
S |
CUP_CODASO |
C |
6 |
0 |
Codigo ASO |
@! |
xFunVldCmp("C8B",,,.F.) |
C8B |
R |
|
|
S |
CUP_DCODAS |
C |
220 |
0 |
Descr. ASO |
@! |
|
|
V |
|
|
S |
CUP_DTINIA |
D |
8 |
0 |
Ini. Afastam |
|
|
|
R |
|
|
S |
CUP_DTDESL |
D |
8 |
0 |
Dt. Desligam |
|
|
|
R |
|
|
S |
CUP_INDPRO |
C |
1 |
0 |
Ind. Provim. |
@! |
Pertence(" 123") |
|
R |
1=Normal;2=Decorrente de Decisao Judicial |
|
S |
CUP_TIPPRO |
C |
2 |
0 |
Tip. Provim. |
@! |
Pertence(" |1 |2 |3 |4 |5 |6 |99") |
|
R |
1=Cgo. efetivo;2=Cgo. comissao;3=Incorpor. Mil.;4=Matric. Mil.;5=Reinclus. Mil.;6=Diplomacao;99=Outros |
|
S |
CUP_DTNOME |
D |
8 |
0 |
Dt. Nomeacao |
|
|
|
R |
|
|
S |
CUP_DTPOSS |
D |
8 |
0 |
Dt. Posse |
|
|
|
R |
|
|
S |
CUP_DTEXER |
D |
8 |
0 |
Dt.Exercicio |
|
|
|
R |
|
|
S |
CUP_TPJORN |
C |
1 |
0 |
Tp. Jornada |
@! |
Pertence(" 1239") |
|
R |
1=Jornada Semanal (seg a dom);2=Jornada 12 x 36;3=Jornada com horario diario fixo e folga variavel;9=Demais Tipos de Jornada |
|
S |
CUP_DTPJOR |
C |
100 |
0 |
Desc.Jornada |
@! |
|
|
R |
|
|
S |
CUP_TPLOGD |
C |
6 |
0 |
Tp Logr Dom. |
@! |
xFunVldCMp("C06",3) |
C06 |
R |
|
|
S |
CUP_DSCTPL |
C |
220 |
0 |
Log. Domest. |
@! |
|
|
V |
|
|
S |
CUP_DELOGD |
C |
100 |
0 |
Des. Lg Dom. |
@! |
|
|
R |
|
|
S |
CUP_NRLOGD |
C |
10 |
0 |
Nr. Logr Dom |
@! |
|
|
R |
|
|
S |
CUP_COMLGD |
C |
30 |
0 |
Comp. Logr D |
@! |
|
|
R |
|
|
S |
CUP_BAIRTD |
C |
60 |
0 |
Bairro Trb D |
@! |
|
|
R |
|
|
S |
CUP_CEPLTD |
C |
8 |
0 |
CEP Logr Dom |
@! |
|
|
R |
|
|
S |
CUP_UFTRBD |
C |
6 |
0 |
UF. Trb Dom. |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
CUP_DUFTRD |
C |
220 |
0 |
Des. UF Dom. |
@! |
|
|
V |
|
|
S |
CUP_CMUNTD |
C |
6 |
0 |
Mun. Trab. D |
@! |
xFunVldCmp("C07",3) |
C07 |
R |
|
|
S |
CUP_DSCMTD |
C |
220 |
0 |
Mun. Trb Dom |
@! |
|
|
V |
|
|
S |
CUP_TPINST |
C |
1 |
0 |
Tp.Insc Tom. |
@! |
Pertence(" 1234") .and. XVldTNrIns(M->CUP_TPINST,FWFLDGET("CUP_NRINST")) |
|
R |
1=CNPJ;2=CPF;3=CAEPF;4=CNO |
|
S |
CUP_NRINST |
C |
15 |
0 |
Nr.Ins. Tom. |
@! |
XVldTNrIns(FWFLDGET("CUP_TPINST"),M->CUP_NRINST) |
|
R |
|
|
S |
CUP_MOTVAF |
C |
6 |
0 |
Cod.Mot.Afas |
@! |
XFUNVldCmp("C8N",,,,2,.T.) |
C8N |
R |
|
|
S |
CUP_RECEVT |
C |
40 |
0 |
Num.Rec.Evt |
@! |
|
|
R |
|
|
S |
CUP_DMOTVA |
C |
220 |
0 |
Desc.Mot.Afa |
@! |
|
|
V |
|
|
S |
CUP_CNPJCP |
C |
14 |
0 |
CNPJ Cat Pro |
@R 99.999.999/9999-99 |
xFunVldPJF(,2,.F.) |
|
|
|
|
S |
CUP_NOMEVE |
C |
5 |
0 |
Nome Evento |
@! |
|
|
R |
|
|
S |
CUP_TPINAP |
C |
1 |
0 |
Tp. Ins Apre |
@! |
Pertence(" 1234") .and. XVldTNrIns(M->CUP_TPINAP,FWFLDGET("CUP_NRINAP")) |
|
R |
1=CNPJ;2=CPF;3=CAEPF;4=CNO |
|
S |
CUP_NRINAP |
C |
15 |
0 |
Nr. Insc Apr |
@! |
XVldTNrIns(FWFLDGET("CUP_TPINAP"),M->CUP_NRINAP) |
|
R |
|
|
S |
CUP_TMPARC |
C |
1 |
0 |
Temp.Parcial |
@! |
Pertence(" 0123") |
|
R |
0=Nao e contrato em tempo parcial;1=Limitado a 25 horas semanais;2=Limitado a 30 horas semanais;3=Limitado a 26 horas semanais. |
|
S |
CUP_CODCAR |
C |
6 |
0 |
Cod.Carreira |
@! |
xFunVldCmp("T5K",1) |
T5K |
R |
|
|
S |
CUP_DESCAR |
C |
220 |
0 |
Des.Carreira |
@! |
|
|
V |
|
|
S |
CUP_DTINGC |
D |
8 |
0 |
Dt. Ingresso |
|
|
|
R |
|
|
S |
CUP_JUSHIP |
M |
255 |
0 |
Just. Legal |
@! |
|
|
R |
|
|
S |
CUP_TPINCL |
C |
1 |
0 |
Tp. Contrato |
@! |
Pertence(" 123") |
|
R |
1=Locais sem filiais;2=Estudo de mercado;3=Contratacao superior a 3 meses |
|
S |
CUP_TPLASM |
C |
1 |
0 |
Tp.Plan.Seg |
@! |
Pertence(" 12") |
|
R |
1=Plano Previdenciario ou Unico; 2=Plano Financeiro |
|
S |
CUP_NPROJE |
C |
6 |
0 |
Proc. Judic. |
@! |
xFunVldCmp("C1G",3) |
C1G |
R |
|
|
S |
CUP_DNPRJE |
C |
220 |
0 |
Des.Proc.Jud |
@! |
|
|
V |
|
|
S |
CUP_TPINTT |
C |
1 |
0 |
Tp.Insc.Est. |
@! |
Pertence(" 1234") .and. XVldTNrIns(M->CUP_TPINTT,FWFLDGET("CUP_NRINTT")) |
|
R |
1=CNPJ;2=CPF;3=CAEPF;4=CNO |
|
S |
CUP_NRINTT |
C |
15 |
0 |
Nr.Insc.Est. |
@! |
XVldTNrIns(FWFLDGET("CUP_TPINTT"),M->CUP_NRINTT) |
|
R |
|
|
S |
CUP_CLAUAS |
C |
1 |
0 |
Clausula Ass |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
CUP_CPFSUB |
C |
11 |
0 |
Cpf Substit. |
@R 999.999.999-99 |
xFunVldPJF(,1,.F.) |
|
R |
|
|
S |
CUP_MATRAN |
C |
30 |
0 |
Matric. Ant. |
@! |
|
|
R |
|
|
S |
CUP_DTTRAN |
D |
8 |
0 |
Dt. Transf. |
|
|
|
R |
|
|
S |
CUP_STASEC |
C |
1 |
0 |
StatusSecund |
@! |
|
|
R |
|
|
S |
CUP_DINSIS |
D |
8 |
0 |
Dt Inc Sist |
|
|
|
R |
|
|
S |
CUP_INSANT |
C |
1 |
0 |
Tp Insc Ante |
@! |
Pertence("125") |
|
R |
1=CNPJ;2=CPF;5=CGC |
|
S |
CUP_OBJDET |
C |
254 |
0 |
Obj. Determi |
@! |
|
|
R |
|
|
S |