Tabela |
GXS |
Resultados da Requisicao |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GXS_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
GXS_IDREQ |
C |
8 |
0 |
Ident Req |
|
|
|
R |
|
|
S |
GXS_SEQ |
C |
2 |
0 |
Sequencia |
|
|
|
R |
|
|
S |
GXS_MRKBR |
L |
1 |
0 |
Selecionado |
|
|
|
R |
|
|
S |
GXS_JUSTIF |
C |
254 |
0 |
Justif Selec |
|
|
|
R |
|
|
S |
GXS_CDTRP |
C |
14 |
0 |
Cod Transp |
@! |
GFEExistC("GU3",1,M->GXS_CDTRP,"GU3->GU3_SIT=='1'.AND.(GU3->GU3_TRANSP=='1'.OR.GU3->GU3_AUTON=='1')") |
GU3TRP |
R |
|
|
S |
GXS_NMTRP |
C |
80 |
0 |
Nome Transp |
|
|
|
V |
|
|
S |
GXS_NRCT |
C |
12 |
0 |
Nr Contrato |
|
Vazio() .OR. GFEExistC("GXT", 1, M->GXS_NRCT, ) |
GXT |
R |
|
|
S |
GXS_FILCT |
C |
2 |
0 |
Fil Contrato |
|
|
|
R |
|
|
S |
GXS_NRNEG |
C |
6 |
0 |
Nr Neg Tab |
|
|
GV9GXS |
R |
|
|
S |
GXS_NRTAB |
C |
6 |
0 |
Nr Tab Frete |
|
|
|
R |
|
|
S |
GXS_FILTAB |
C |
2 |
0 |
Fil Tab Fret |
|
|
|
R |
|
|
S |
GXS_CODREF |
C |
5 |
0 |
Cod Refer |
|
Vazio() .OR. GFEExistC("GUN", 1, M->GXS_CODREF, "GUN->GUN_TPTAB=='4'") |
|
R |
|
|
S |
GXS_FILREF |
C |
2 |
0 |
Fil Refer |
|
|
|
R |
|
|
S |
GXS_PESOT |
N |
13 |
5 |
Peso Total |
@E 9,999,999.99999 |
|
|
R |
|
|
S |
GXS_QTDET |
N |
13 |
5 |
Qtde Total |
@E 9,999,999.99999 |
|
|
R |
|
|
S |
GXS_TOTFRT |
N |
11 |
2 |
Total Frete |
@E 99,999,999.99 |
|
|
R |
|
|
S |
GXS_FRTPES |
N |
11 |
2 |
Frt Peso Neg |
@E 99,999,999.99 |
|
|
R |
|
|
S |
GXS_PRAZO |
N |
3 |
0 |
Prazo |
@E 999 |
|
|
R |
|
|
S |
GXS_TPPRAZ |
C |
1 |
0 |
Tipo Prazo |
|
Pertence("012") |
|
R |
0=Dias Uteis;1=Dias Corridos;2=Horas |
|
S |
GXS_FRTCOT |
N |
11 |
2 |
Frt Peso Cot |
@E 99,999,999.99 |
|
|
R |
|
|
S |
GXS_FRTQTD |
N |
11 |
2 |
Frete Qtde |
@E 99,999,999.99 |
|
|
R |
|
|
S |
GXS_ORICOT |
C |
1 |
0 |
Origem |
@! |
PERTENCE("12") |
|
R |
1=Usuario;2=Sistema |
|
S |
GXS_STATUS |
C |
1 |
0 |
Sit Cotac |
|
Pertence("0123") |
|
R |
0=Nao Solicitado;1=Ativo;2=Inativo;3=Aguardando Retorno |
|
S |
GXS_DTATU |
D |
8 |
0 |
Data Atu |
|
|
|
R |
|
|
S |
GXS_NMCONT |
C |
50 |
0 |
Nome Contato |
@! |
|
|
R |
|
|
S |
GXS_EMCONT |
C |
50 |
0 |
Email Contat |
@! |
|
|
R |
|
|
S |
GXS_HRATU |
C |
5 |
0 |
Hora Atu |
99:99 |
|
|
R |
|
|
S |
GXS_FOCONT |
C |
15 |
0 |
Fone Contato |
|
|
|
R |
|
|
S |
GXS_JUSCOT |
C |
254 |
0 |
Justif Cotac |
|
|
|
R |
|
|
S |
GXS_UMPESO |
C |
2 |
0 |
Unid Peso |
|
ExistCPO("SAH",M->GUN_UMPESO) |
SAH |
R |
|
M->GUN_TPTAB == "4" |
S |