Tabela |
T1V |
Alteracao Contrato Trabalhador |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
T1V_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
T1V_ID |
C |
6 |
0 |
ID |
@! |
|
|
R |
|
|
S |
T1V_VERSAO |
C |
14 |
0 |
Id. Ver. Reg |
@! |
|
|
R |
|
|
S |
T1V_CPF |
C |
11 |
0 |
CPF do Trab. |
@R 999.999.999-99 |
xFunVldPJF(,1,.F.) .AND. XFUNVldUni("T1V",3,M->T1V_CPF+FWFLDGET("T1V_MATRIC")+DTOS(FWFLDGET("T1V_DTALT"))+'1') |
|
R |
|
|
S |
T1V_MATRIC |
C |
30 |
0 |
Matricula |
@! |
XFUNVldUni("T1V",3,FWFLDGET("T1V_CPF")+M->T1V_MATRIC+DTOS(FWFLDGET("T1V_DTALT"))+'1') |
|
R |
|
|
S |
T1V_NOME |
C |
70 |
0 |
Nome |
@! |
|
|
R |
|
|
S |
T1V_DTALT |
D |
8 |
0 |
Dt. Alterac. |
|
XFUNVldUni("T1V",3,FWFLDGET("T1V_CPF")+FWFLDGET("T1V_MATRIC")+DTOS(M->T1V_DTALT)+DTOS(M->T1V_DTEF)+'1') |
|
R |
|
|
S |
T1V_NIS |
C |
11 |
0 |
NIS |
@! |
|
|
R |
|
|
S |
T1V_TPREGT |
C |
1 |
0 |
Tp Reg Trab |
@! |
Pertence(" 12") |
|
R |
1=CLT - Consolidacao das Leis de Trabalho;2=Estatutario |
|
S |
T1V_TPREGP |
C |
1 |
0 |
Tp Reg Prev |
@! |
Pertence(" 123") |
|
R |
1=RGPS-Regime Geral Previd. Social;2=RPPS-Regime Proprio Previd. Social no Brasil;3=RPPE-Regime Proprio Previd. Social Exterior |
|
S |
T1V_TPREGJ |
C |
1 |
0 |
Tp Reg Jor |
@! |
Pertence(" 1234") |
|
R |
#CboTpRegJ() |
|
S |
T1V_NATATV |
C |
1 |
0 |
Nat. Ativid. |
@! |
Pertence(" 12") |
|
R |
1=Trabalho Urbano;2=Trabalho Rural |
|
S |
T1V_DATAB |
C |
2 |
0 |
Data Base |
99 |
|
|
R |
|
|
S |
T1V_CNPJCP |
C |
14 |
0 |
CNPJ Cat Pro |
@R 99.999.999/9999-99 |
xFunVldPJF(,2,.F.) |
|
R |
|
|
S |
T1V_CODCGO |
C |
6 |
0 |
Cod. Cargo |
@! |
xFunVldCmp("C8V",,,,2,,.F.) |
C8V |
R |
|
|
S |
T1V_DCODCG |
C |
220 |
0 |
Desc. Cargo |
@! |
|
|
V |
|
|
S |
T1V_CODFUN |
C |
6 |
0 |
Cod. Funcao |
@! |
xFunVldCmp("C8X",,,,2,,.F.) |
C8X |
R |
|
|
S |
T1V_DCODFU |
C |
220 |
0 |
Desc. Funcao |
@! |
|
|
V |
|
|
S |
T1V_CODCAT |
C |
6 |
0 |
Cod. Categ. |
@! |
xFunVldCmp("C87",,,,2,.F.) |
C87 |
R |
|
|
S |
T1V_DCODCA |
C |
220 |
0 |
Desc. Categ. |
@! |
|
|
V |
|
|
S |
T1V_VLSLFX |
N |
16 |
2 |
Vlr Sal Fixo |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
T1V_UNSLFX |
C |
1 |
0 |
Und Sal Fixo |
@! |
Pertence(" 1234567") |
|
|
1=Por Hora;2=Por Dia;3=Por Semana;4=Por Quinzena;5=Por Mes;6=Por Tarefa;7=Nao Aplicavel |
|
S |
T1V_DESSVR |
C |
254 |
0 |
Desc Sal Var |
@! |
|
|
R |
|
|
S |
T1V_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 |
T1V_DTTERM |
D |
8 |
0 |
Dt Term Con |
|
|
|
R |
|
|
S |
T1V_TPINSC |
C |
1 |
0 |
Tp Inscricao |
@! |
Pertence(" 1234") .and. XVldTNrIns(M->T1V_TPINSC,FWFLDGET("T1V_NRINSC")) |
|
R |
1=CNPJ;2=CPF;3=CAEPF;4=CNO |
|
S |
T1V_NRINSC |
C |
15 |
0 |
Nr Inscricao |
@! |
XVldTNrIns(FWFLDGET("T1V_TPINSC"),M->T1V_NRINSC) |
|
R |
|
|
S |
T1V_DESLOT |
C |
220 |
0 |
Desc. Compl. |
@! |
|
|
R |
|
|
S |
T1V_TPLOGD |
C |
6 |
0 |
Tp Logr Dom. |
@! |
xFunVldCMp("C06",3) |
C06 |
R |
|
|
S |
T1V_DSCTPL |
C |
220 |
0 |
Log. Domest. |
@! |
|
|
V |
|
|
S |
T1V_DELOGD |
C |
100 |
0 |
Des. Lg Dom. |
@! |
|
|
R |
|
|
S |
T1V_NRLOGD |
C |
10 |
0 |
Nr. Logr Dom |
@! |
|
|
R |
|
|
S |
T1V_COMLGD |
C |
30 |
0 |
Comp. Logr D |
@! |
|
|
R |
|
|
S |
T1V_BAIRTD |
C |
90 |
0 |
Bairro Trb D |
@! |
|
|
R |
|
|
S |
T1V_CEPLTD |
C |
8 |
0 |
CEP Logr Dom |
@! |
|
|
R |
|
|
S |
T1V_UFTRBD |
C |
6 |
0 |
UF. Trb Dom. |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
T1V_DUFTRD |
C |
220 |
0 |
Des. UF Dom. |
@! |
|
|
V |
|
|
S |
T1V_CMUNTD |
C |
6 |
0 |
Mun Trb Dom |
@! |
xFunVldCmp("C07",3) |
C07 |
R |
|
|
S |
T1V_DSCMTD |
C |
220 |
0 |
Desc Mun Trb |
@! |
|
|
V |
|
|
S |
T1V_QTDHJS |
N |
5 |
2 |
Qtd. Horas |
@E 99.99 |
|
|
R |
|
|
S |
T1V_TPJORN |
C |
1 |
0 |
Tp. Jornada |
@! |
Pertence(" 1239") |
|
R |
1=Jornada Semanal (Seg. a Dom.);2=Jornada 12 x 36;3=Horario fixo e Folga Variavel;9=Demais tipo de Jornada |
|
S |
T1V_DTPJOR |
C |
100 |
0 |
Desc.Jornada |
@! |
|
|
R |
|
|
S |
T1V_CNPJSD |
C |
14 |
0 |
CNPJ Sind. |
@R 99.999.999/9999-99 |
xFunVldPJF(,2,.F.) |
|
R |
|
|
S |
T1V_ALVJUD |
C |
6 |
0 |
Id Proc Jud |
@! |
XFUNVldCmp("C1G",8) |
C1G |
R |
|
|
S |
T1V_DALVJU |
C |
220 |
0 |
Des Proc Jud |
@! |
|
|
V |
|
|
S |
T1V_PROTUL |
C |
44 |
0 |
Ult. Prot. |
@! |
|
|
R |
|
|
S |
T1V_PROTPN |
C |
44 |
0 |
Pnlt. Prot. |
@! |
|
|
R |
|
|
S |
T1V_STATUS |
C |
1 |
0 |
Status Reg. |
@! |
|
|
R |
|
|
S |
T1V_VERANT |
C |
14 |
0 |
Ver Ant Reg |
@! |
|
|
R |
|
|
S |
T1V_EVENTO |
C |
1 |
0 |
Id. Evento |
@! |
Pertence("IAE") |
|
R |
I=Inclusao;A=Alteracao;E=Exclusao |
|
S |
T1V_ATIVO |
C |
1 |
0 |
Reg. Ativo? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
T1V_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 |
T1V_DTEF |
D |
8 |
0 |
Data Efeito |
|
|
|
R |
|
|
S |
T1V_DESALT |
C |
150 |
0 |
Desc. Alter. |
@! |
|
|
R |
|
|
S |
T1V_CODCAR |
C |
6 |
0 |
Cod.Carreira |
@! |
|
T5K |
R |
|
|
S |
T1V_DESCAR |
C |
220 |
0 |
Des.Carreira |
@! |
|
|
V |
|
|
S |
T1V_DTINGC |
D |
8 |
0 |
Dt. Ingresso |
|
|
|
R |
|
|
S |
T1V_JUSTPR |
M |
10 |
0 |
Just. Prorr. |
|
|
|
R |
|
|
S |
T1V_TPLASM |
C |
1 |
0 |
Tp. de Plano |
|
Pertence(" 12") |
|
R |
1=Plano previdenciario ou unico;2=Plano Financeiro |
|
S |
T1V_MTVALT |
C |
1 |
0 |
Motivo Alter |
|
Pertence(" 12389") |
|
R |
1=Promocao;2=Readaptacao;3=Aproveitamento;8=Outros;9=Nao alterado |
|
S |
T1V_TPINAP |
C |
1 |
0 |
Tp. Ins Apre |
@! |
Pertence(" 1234") .and. XVldTNrIns(M->T1V_TPINAP,FWFLDGET("CUP_NRINAP")) |
|
R |
1=CNPJ;2=CPF;3=CAEPF;4=CNO |
|
S |
T1V_NRINAP |
C |
15 |
0 |
Nr. Insc.Apr |
@! |
XVldTNrIns(FWFLDGET("T1V_TPINAP"),M->T1V_NRINAP) |
|
R |
|
|
S |
T1V_STASEC |
C |
1 |
0 |
StatusSecund |
@! |
|
|
R |
|
|
S |
T1V_XMLID |
C |
36 |
0 |
Id do XML. |
|
|
|
R |
|
|
S |
T1V_DINSIS |
D |
8 |
0 |
Dt Inc Sist |
|
|
|
R |
|
|
S |
T1V_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 |
T1V_OBJDET |
C |
254 |
0 |
Obj. Determi |
@! |
|
|
R |
|
|
S |