Tabela |
GW2 |
CONTRATOS COM AUTONOMOS |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GW2_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
GW2_NRCONT |
C |
8 |
0 |
Nr Contrato |
99999999 |
|
|
R |
|
|
S |
GW2_SITCON |
C |
1 |
0 |
Situacao |
@! |
|
|
R |
1=Criado;2=Confirmado;3=Emitido;4=Cancelado |
|
S |
GW2_DTCRIA |
D |
8 |
0 |
Dt Criacao |
|
|
|
R |
|
|
S |
GW2_DTVENC |
D |
8 |
0 |
Dt Vencto |
|
|
|
R |
|
|
S |
GW2_CDPROP |
C |
14 |
0 |
Proprietario |
@! |
ExistCpo("GU3") |
GU3AUT |
R |
|
|
S |
GW2_NMABRV |
C |
12 |
0 |
Nome Abrev |
@! |
|
|
V |
|
|
S |
GW2_QTDEIR |
N |
2 |
0 |
Nr Depend. |
99 |
|
|
R |
|
|
S |
GW2_CDMTR |
C |
6 |
0 |
Motorista |
@! |
ExistCpo("GUU") |
GUU |
R |
|
|
S |
GW2_NMMTR |
C |
50 |
0 |
Nom Motorist |
@! |
|
|
V |
|
|
S |
GW2_DTIMPR |
D |
8 |
0 |
Dt Impressao |
|
|
|
R |
|
|
S |
GW2_VLMUDE |
N |
12 |
2 |
Mult Atr Des |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLMUEN |
N |
12 |
2 |
Multa Atr En |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_CDVEI1 |
C |
16 |
0 |
Veiculo 1 |
@! |
GFEExistC("GU8",1,M->GW2_CDVEI1,"GU8->GU8_SIT=='1'") |
GU8 |
R |
|
|
S |
GW2_PLACA1 |
C |
8 |
0 |
Placa 1 |
@R XXX-9999 |
|
|
V |
|
|
S |
GW2_CDVEI2 |
C |
16 |
0 |
Veiculo 2 |
@! |
GFEExistC("GU8",1,M->GW2_CDVEI2,"GU8->GU8_SIT=='1'") |
GU8 |
R |
|
|
S |
GW2_PLACA2 |
C |
8 |
0 |
Placa 2 |
@R XXX-9999 |
|
|
V |
|
|
S |
GW2_CDVEI3 |
C |
16 |
0 |
Veiculo 3 |
@! |
GFEExistC("GU8",1,M->GW2_CDVEI3,"GU8->GU8_SIT=='1'") |
GU8 |
R |
|
|
S |
GW2_PLACA3 |
C |
8 |
0 |
Placa 3 |
@R XXX-9999 |
|
|
V |
|
|
S |
GW2_LOCCAR |
C |
50 |
0 |
Local Carga |
@! |
|
|
R |
|
|
S |
GW2_LOCDES |
C |
50 |
0 |
Loc Descarga |
@! |
|
|
R |
|
|
S |
GW2_RESCAR |
C |
50 |
0 |
Resp Carga |
@! |
|
|
R |
|
|
S |
GW2_RESDES |
C |
30 |
0 |
Resp. Descar |
@! |
|
|
R |
|
|
S |
GW2_PZCARG |
C |
12 |
0 |
Prz Carga |
@! |
|
|
R |
|
|
S |
GW2_PZDESC |
C |
12 |
0 |
Prz Descarga |
@! |
|
|
R |
|
|
S |
GW2_QTENTR |
N |
3 |
0 |
Nr Entregas |
999 |
|
|
R |
|
|
S |
GW2_PZENTR |
C |
12 |
0 |
Prz Entrega |
@! |
|
|
R |
|
|
S |
GW2_QTPESO |
N |
13 |
5 |
Peso |
@E 9,999,999.99999 |
Positivo() |
|
R |
|
|
S |
GW2_QTDIST |
N |
8 |
1 |
Distancia |
@E 999,999.9 |
|
|
R |
|
|
S |
GW2_CIDORI |
C |
7 |
0 |
Cidade Orig |
9999999 |
GFEExistC("GU7",1,M->GW2_CIDORI,"GU7->GU7_SIT=='1'") |
GU7GUA |
R |
|
|
S |
GW2_NMCIDO |
C |
50 |
0 |
Cidade Orig |
@! |
|
|
V |
|
|
S |
GW2_CIDDES |
C |
7 |
0 |
Cidade Term |
9999999 |
GFEExistC("GU7",1,M->GW2_CIDDES,"GU7->GU7_SIT=='1'") |
GU7GUA |
R |
|
|
S |
GW2_NMCIDT |
C |
50 |
0 |
Cidade Termi |
@! |
|
|
V |
|
|
S |
GW2_TEST1 |
C |
30 |
0 |
Testemunha 1 |
@! |
|
|
R |
|
|
S |
GW2_TEST2 |
C |
30 |
0 |
Testemunha 2 |
@! |
|
|
R |
|
|
S |
GW2_USUCRI |
C |
50 |
0 |
Usuario |
@! |
|
|
R |
|
|
S |
GW2_ACINT |
C |
1 |
0 |
Acao de Int |
|
|
|
V |
1=Financeiro;2=RH;3=Apropriacao Despesa |
|
S |
GW2_SITFIN |
C |
1 |
0 |
Situacao Fin |
@! |
Pertence("12345") |
|
R |
1=Nao Enviado;2=Pendente;3=Rejeitado;4=Atualizado;5=Pendente Cancelamento |
|
S |
GW2_DTFIN |
D |
8 |
0 |
Dt Env Finan |
|
|
|
R |
|
|
S |
GW2_HRFIN |
C |
5 |
0 |
Hr Env Finan |
@R 99:99 |
|
|
R |
|
|
S |
GW2_USUFIN |
C |
50 |
0 |
Usr Env Fin |
@! |
|
|
R |
|
|
S |
GW2_SITRH |
C |
1 |
0 |
Situacao RH |
@! |
Pertence("12345") |
|
R |
1=Nao Enviado;2=Pendente;3=Rejeitado;4=Atualizado;5=Pendente Desatualizacao |
|
S |
GW2_DTRH |
D |
8 |
0 |
Dt Env RH |
|
|
|
R |
|
|
S |
GW2_HRRH |
C |
5 |
0 |
Hr Env RH |
@R 99:99 |
|
|
R |
|
|
S |
GW2_USURH |
C |
50 |
0 |
Usr Env RH |
@! |
|
|
R |
|
|
S |
GW2_SITREC |
C |
1 |
0 |
Sit Receb |
@! |
Pertence("123456") |
|
R |
1=Nao Enviado;2=Pendente;3=Rejeitado;4=Atualizado;5=Pendente Desatualizacao;6=Nao se Aplica |
|
S |
GW2_DTREC |
D |
8 |
0 |
Dt Env Rec |
|
|
|
R |
|
|
S |
GW2_HRREC |
C |
5 |
0 |
Hr Env Rec |
@R 99:99 |
|
|
R |
|
|
S |
GW2_USUREC |
C |
50 |
0 |
Usr Env Rec |
@! |
|
|
R |
|
|
S |
GW2_DTCANC |
D |
8 |
0 |
Dt Cancela |
|
|
|
R |
|
|
S |
GW2_USUCAN |
C |
50 |
0 |
Usuario Canc |
@! |
|
|
R |
|
|
S |
GW2_OBS |
M |
10 |
0 |
Observacoes |
|
|
|
R |
|
|
S |
GW2_VLBAIN |
N |
12 |
2 |
Base INSS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLBAIR |
N |
12 |
5 |
Base IR |
@E 999,999.99999 |
|
|
R |
|
|
S |
GW2_VLDEDP |
N |
12 |
2 |
Desc Depend |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLINOE |
N |
12 |
2 |
INSS Out Emp |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_INSSPE |
N |
12 |
2 |
INSS Periodo |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLREIR |
N |
12 |
2 |
VL DED IR |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLFRET |
N |
12 |
2 |
Frete Contr |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLADIC |
N |
12 |
2 |
Adicionais |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLDESC |
N |
12 |
2 |
Descontos |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLSEST |
N |
12 |
2 |
SEST/SENAT |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLISS |
N |
12 |
2 |
ISS Recolher |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLINSS |
N |
12 |
2 |
INSS Terc re |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLIRRF |
N |
12 |
2 |
IRRF |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLLIQ |
N |
12 |
2 |
VL Liquido |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLIMP |
N |
12 |
2 |
VL Impostos |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_VLINEM |
N |
12 |
2 |
INSS Pat Em |
@E 999,999,999.99 |
|
|
R |
|
|
S |
GW2_DSINCD |
C |
5 |
0 |
Cod INSS Emp |
|
|
|
V |
|
|
S |
GW2_DSINCL |
C |
14 |
0 |
Cla INSS Emp |
|
|
|
V |
|
|
S |
GW2_DSIACD |
C |
5 |
0 |
Cod INSS Aut |
|
|
|
V |
|
|
S |
GW2_DSIACL |
C |
14 |
0 |
Cla INSS Aut |
|
|
|
V |
|
|
S |
GW2_DSSSCD |
C |
5 |
0 |
C SEST/SENAT |
|
|
|
V |
|
|
S |
GW2_DSSSCL |
C |
14 |
0 |
C SEST/SENAT |
|
|
|
V |
|
|
S |
GW2_DSIRCD |
C |
5 |
0 |
Cod IRRF |
|
|
|
V |
|
|
S |
GW2_DSIRCL |
C |
14 |
0 |
Class IRR |
|
|
|
V |
|
|
S |
GW2_DSISCD |
C |
5 |
0 |
Cod ISS Ret |
|
|
|
V |
|
|
S |
GW2_DSISCL |
C |
14 |
0 |
Cla ISS Ret |
|
|
|
V |
|
|
S |
GW2_DSESCO |
C |
2 |
0 |
Especie do C |
@! |
|
|
V |
|
|
S |
GW2_MOTFIN |
M |
10 |
0 |
Mot Rej Fin |
|
|
|
R |
|
|
S |
GW2_MOTRH |
M |
10 |
0 |
Mot Rej Rh |
|
|
|
R |
|
|
S |
GW2_MOTREC |
M |
10 |
0 |
Mot Rej Rec |
|
|
|
R |
|
|
S |
GW2_MATREX |
C |
8 |
0 |
Mat Trad Ext |
|
|
|
V |
|
|
S |
GW2_CIOT |
C |
12 |
0 |
CIOT |
@! |
|
|
R |
|
|
S |