| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GXT | Contrato de Transporte | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GXT_FILIAL | C | 2 | 0 | Filial | S | ||||||
| GXT_NRCT | C | 12 | 0 | Num Contrato | @! | R | S | ||||
| GXT_DTCT | D | 8 | 0 | Dt Contrato | FwFldGet("GXT_DTCT") <= dDataBase | R | S | ||||
| GXT_USUAR | C | 50 | 0 | Usr Inclusao | @! | CUSERNAME | R | S | |||
| GXT_CDTRP | C | 14 | 0 | Cod Transp | @! | GFEExistC("GU3",1,M->GXT_CDTRP,"GU3->GU3_SIT=='1'.AND.(GU3->GU3_TRANSP=='1'.OR.GU3->GU3_AUTON=='1')") | GU3TRP | R | IIF(INCLUI,.T.,GFEA079Trp()) | S | |
| GXT_NMTRP | C | 60 | 0 | Nm Transp | @! | V | S | ||||
| GXT_CDCLFR | C | 4 | 0 | Class Frete | @! | Vazio() .OR. GFEExistC("GUB", 1, M->GXT_CDCLFR, "GUB->GUB_SIT=='1'") | GUB | R | S | ||
| GXT_DSCLFR | C | 50 | 0 | Desc C Frete | @! | V | S | ||||
| GXT_CDTPOP | C | 10 | 0 | Tp Operacao | @! | Vazio() .OR. GFEExistC("GV4", 1, M->GXT_CDTPOP, "GV4->GV4_SIT=='1'") | GV4 | R | S | ||
| GXT_DSTPOP | C | 50 | 0 | Desc Tp Oper | @! | V | S | ||||
| GXT_PESOT | N | 15 | 4 | Peso Contrat | @E 9,999,999,999.9999 | V | S | ||||
| GXT_QTDET | N | 15 | 4 | Qtd Contrata | @E 9,999,999,999.9999 | V | S | ||||
| GXT_DTIRET | D | 8 | 0 | Dt Ini Carre | R | S | |||||
| GXT_DTFRET | D | 8 | 0 | Dt fim Carre | R | S | |||||
| GXT_DTFENT | D | 8 | 0 | Dt Fim Entrg | R | S | |||||
| GXT_OBSCGA | M | 10 | 0 | Cond Carga | R | S | |||||
| GXT_OBSDGA | M | 10 | 0 | Cond Descarg | R | S | |||||
| GXT_OBSPAG | M | 10 | 0 | Info Pgmto | R | S | |||||
| GXT_OBSCLA | M | 10 | 0 | Info Contrat | R | S | |||||
| GXT_NRTAB | C | 6 | 0 | Tab Frete | 999999 | Vazio() .OR. GFEExistC("GVA",1,M->GXT_CDTRP+M->GXT_NRTAB,"GVA_CDEMIT == GXT_CDTRP") | GVAGXT | R | S | ||
| GXT_NRNEG | C | 6 | 0 | Neg Frete | 999999 | Vazio() .OR. GFEExistC("GV9", 1, M->GXT_CDTRP+M->GXT_NRTAB+M->GXT_NRNEG, "GV9->GV9_SIT=='2'") | GXTGV9 | R | S | ||
| GXT_SIT | C | 1 | 0 | Situacao | @! | Pertence("123456") | R | 1=Criado;2=Emitido;3=Enviado;4=Confirmado;5=Encerrado;6=Cancelado | S | ||
| GXT_DTIENT | D | 8 | 0 | Dt Ini Entrg | R | S | |||||
| GXT_CODCTR | C | 14 | 0 | Contratante | GFEExistC("GU3",1,M->GXT_CODCTR,"GU3->GU3_SIT=='1'") | GU3 | R | S | |||
| GXT_DESCTR | C | 60 | 0 | Desc Contrat | V | S | |||||
| GXT_CODCLI | C | 14 | 0 | Destinatario | GFEExistC("GU3",1,M->GXT_CODCLI,"GU3->GU3_SIT=='1'") | GU3 | R | S | |||
| GXT_DESCLI | C | 60 | 0 | Desc Destina | V | S | |||||
| GXT_TOMFRT | C | 1 | 0 | Tomador Fret | 9 | Pertence("123") | R | 1=Contratante;2=Contratada;3=Cliente | S | ||
| GXT_EMICAR | C | 14 | 0 | Emi Carreg | GFEExistC("GU3",1,M->GXT_EMICAR,"GU3->GU3_SIT=='1'") | GU3 | R | S | |||
| GXT_DSECAR | C | 60 | 0 | Nm Emi Carre | V | S | |||||
| GXT_EMIENT | C | 14 | 0 | Emi Entrega | GFEExistC("GU3",1,M->GXT_EMIENT,"GU3->GU3_SIT=='1'") | GU3 | R | S | |||
| GXT_DSEENT | C | 60 | 0 | Nm Emi Ent | V | S | |||||
| GXT_CSTRES | C | 3 | 0 | Setor Resp | @! | NM | R | S | |||
| GXT_DSTRES | C | 100 | 0 | Ds Setor Res | V | S | |||||
| GXT_ENCERR | C | 1 | 0 | Cond Encerr | Pertence("012345") | R | 0=Externo;1=Manual;2=Valor;3=Peso;4=Quantidade;5=Pontual | S | |||
| GXT_INFENT | C | 1 | 0 | Inf Entrega | Pertence("012") | R | 0=Regra do Emitente;1=Obrigatoria;2=Opcional | S | |||
| GXT_DATENV | D | 8 | 0 | Data Envio | R | S | |||||
| GXT_DATCFG | D | 8 | 0 | Data Confirm | R | S | |||||
| GXT_DATENC | D | 8 | 0 | Data Encerr | R | S | |||||
| GXT_MOTCAN | M | 10 | 0 | Mot Cancel | R | S | |||||
| GXT_VLLIM | N | 12 | 2 | Valor Limite | @E 999,999,999.99 | R | M->GXT_ENCERR == "2" | S | |||
| GXT_VLPREV | N | 12 | 2 | Valor Prev | @E 999,999,999.99 | R | S | ||||
| GXT_VLREAL | N | 12 | 2 | Valor Realiz | @E 999,999,999.99 | R | S | ||||
| GXT_VLSDO | N | 12 | 2 | Valor Saldo | @E 999,999,999.99 | R | S | ||||
| GXT_QTLIM | N | 13 | 5 | Qtde Limite | @E 9,999,999.99999 | R | M->GXT_ENCERR == "4" | S | |||
| GXT_QTPREV | N | 13 | 5 | Qtde Previst | @E 9,999,999.99999 | R | S | ||||
| GXT_QTREAL | N | 13 | 5 | Qtde Realiz | @E 9,999,999.99999 | R | S | ||||
| GXT_QTSDO | N | 13 | 5 | Qtde Saldo | @E 9,999,999.99999 | R | S | ||||
| GXT_PSLIM | N | 13 | 5 | Peso Limite | @E 9,999,999.99999 | R | M->GXT_ENCERR == "3" | S | |||
| GXT_PSPREV | N | 13 | 5 | Peso Prev | @E 9,999,999.99999 | R | S | ||||
| GXT_PSREAL | N | 13 | 5 | Peso Realiz | @E 9,999,999.99999 | R | S | ||||
| GXT_PSSDO | N | 13 | 5 | Peso Saldo | @E 9,999,999.99999 | R | S | ||||