| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GWN | ROMANEIOS DE CARGA | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GWN_FILIAL | C | 2 | 0 | Filial | S | ||||||
| GWN_NRROM | C | 8 | 0 | Nr Romaneio | 99999999 | R | S | ||||
| GWN_CDTPOP | C | 10 | 0 | Tipo Oper | @! | GFEExistC("GV4",,M->GWN_CDTPOP,"GV4->GV4_SIT=='1'") | GV4 | R | S | ||
| GWN_CDCLFR | C | 4 | 0 | Class Frete | @! | ALLTRIM(M->GWN_CDCLFR)=="".OR.GFEExistC("GUB",,M->GWN_CDCLFR,"GUB->GUB_SIT=='1'") | GUB | R | S | ||
| GWN_DSCLFR | C | 50 | 0 | Desc Class | @! | V | S | ||||
| GWN_CDTRP | C | 14 | 0 | Transp | @! | GFEExistC("GU3",,M->GWN_CDTRP,"GU3->GU3_SIT=='1'.AND.(GU3->GU3_TRANSP=='1'.OR.GU3->GU3_AUTON=='1')") | GU3TRP | R | GFEA050WCT() | S | |
| GWN_DSTRP | C | 80 | 0 | Nome Transp | V | S | |||||
| GWN_CDMTR | C | 6 | 0 | Motorista | @! | GFEA50RLMT(M->GWN_CDMTR, M->GWN_CDMTR2,"1",.F.) | GUUMTR | R | S | ||
| GWN_NMMTR | C | 50 | 0 | Nome Motoris | @! | V | S | ||||
| GWN_CDMTR2 | C | 6 | 0 | Motorista 2 | @! | GFEA50RLMT(M->GWN_CDMTR, M->GWN_CDMTR2,"2",.F.) | GUUMTR | R | S | ||
| GWN_NMMTR2 | C | 50 | 0 | Nm Motoris 2 | @! | V | S | ||||
| GWN_CDTPVC | C | 10 | 0 | Tipo Veiculo | @! | GFEA50TPVC(M->GWN_CDTPVC) | GV3 | R | S | ||
| GWN_PLACAD | C | 8 | 0 | Placa Diant | @R XXX-9999 | GFEA50PLC(M->GWN_PLACAD, M->GWN_PLACAT, M->GWN_PLACAM, "D",.F.) | GU8RPL | R | S | ||
| GWN_PLACAT | C | 8 | 0 | Placa Trasei | @R XXX-9999 | GFEA50PLC(M->GWN_PLACAD, M->GWN_PLACAT, M->GWN_PLACAM, "T",.F.) | GU8RPL | R | S | ||
| GWN_PLACAM | C | 8 | 0 | Placa Meio | @R XXX-9999 | GFEA50PLC(M->GWN_PLACAD, M->GWN_PLACAT, M->GWN_PLACAM, "M",.F.) | GU8RPL | R | S | ||
| GWN_SIT | C | 1 | 0 | Situacao | @! | Pertence("1234") | R | 1=Digitado;2=Emitido;3=Liberado;4=Encerrado | S | ||
| GWN_DTIMPL | D | 8 | 0 | Data Criacao | R | S | |||||
| GWN_HRIMPL | C | 5 | 0 | Hora Criacao | @R 99:99 | R | S | ||||
| GWN_CALC | C | 1 | 0 | Sit Calculo | @! | Pertence("1234") | R | 1=Calculado com Sucesso;2=Nao Calculado;3=Tentativa sem Sucesso;4=Necessita Recalculo | S | ||
| GWN_DTCALC | D | 8 | 0 | Data Calculo | R | S | |||||
| GWN_HRCALC | C | 5 | 0 | Hora Calculo | @R 99:99 | R | S | ||||
| GWN_USUIMP | C | 50 | 0 | Usuario | @! | R | S | ||||
| GWN_ORI | C | 1 | 0 | Origem | @! | Pertence("1234") | R | 1=Usuario;2=ERP;3=Outros;4=Sistema | S | ||
| GWN_PRIOR | N | 2 | 0 | Prioridade | 99 | R | S | ||||
| GWN_DTSAI | D | 8 | 0 | Dt Said/Entr | R | S | |||||
| GWN_HRSAI | C | 5 | 0 | Hr Said/Entr | @R 99:99 | R | S | ||||
| GWN_DISTAN | N | 8 | 1 | Percurso | @E 999,999.9 | Positivo() | R | S | |||
| GWN_NRCIDD | C | 7 | 0 | Cidade Dest | 9999999 | ALLTRIM(M->GWN_NRCIDD)=="".OR.GFEExistC("GU7",,M->GWN_NRCIDD,"GU7->GU7_SIT=='1'") | GU7GUA | R | S | ||
| GWN_NMCIDD | C | 50 | 0 | Nome Cidade | @! | V | S | ||||
| GWN_CEPD | C | 8 | 0 | CEP Destino | @R 99.999-999 | R | S | ||||
| GWN_BLOQPF | C | 1 | 0 | Bloq PF | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| GWN_OBS | M | 10 | 0 | Observacoes | R | S | |||||
| GWN_AGRUP | C | 1 | 0 | Agrupado? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| GWN_MTCALC | M | 10 | 0 | Observacao | R | S | |||||
| GWN_RASTR | C | 18 | 0 | Cod Rastream | R | S | |||||
| GWN_VALEP | C | 1 | 0 | Vale Pedagio | @! | Pertence("123") | R | 1=Nao se aplica;2=Nao conferido;3=Conferido | S | ||
| GWN_VPVAL | N | 8 | 2 | Valor Pedag | @E 99,999.99 | R | GFE50VERVP() | S | |||
| GWN_VPNUM | C | 16 | 0 | Comprov Peda | @! | R | GFE50VERVP() | S | |||
| GWN_VPCDOP | C | 14 | 0 | Op Vale Ped | @! | GFEExistC("GU3",,M->GWN_VPCDOP, "GU3->GU3_SIT=='1'.AND.GU3->GU3_FORN=='1'") | GU3FOR | R | GFE50VERVP() | S | |
| GWN_VPNMOP | C | 80 | 0 | Nome Op Vale | @! | V | S | ||||
| GWN_DTRET | D | 8 | 0 | Data Retorno | R | S | |||||
| GWN_HRRET | C | 5 | 0 | Hora Retorno | 99:99 | R | S | ||||
| GWN_HODSAI | N | 6 | 0 | Hodom Saida | 999999 | R | S | ||||
| GWN_HODRET | N | 6 | 0 | Hodom Retorn | 999999 | R | S | ||||
| GWN_DSREAL | N | 6 | 0 | Dist. Real | 999999 | R | S | ||||
| GWN_FECHAM | C | 1 | 0 | Apur Periodo | @! | Pertence("1234") | R | 1=Nao se aplica;2=Pendente;3=Efetuada;4=Sem efeito | S | ||
| GWN_DTFECH | D | 8 | 0 | Data Fecham | R | S | |||||
| GWN_NRCIDO | C | 7 | 0 | Cid Origem | 9999999 | ALLTRIM( M->GWN_NRCIDO)=="".OR.GFEExistC("GU7",,M->GWN_NRCIDO,"GU7->GU7_SIT=='1'") | GU7GUA | R | S | ||
| GWN_NMCIDO | C | 50 | 0 | Nm Cid Orig | @! | V | S | ||||
| GWN_CEPO | C | 8 | 0 | CEP Origem | @R 99.999-999 | R | S | ||||
| GWN_NRMOV | C | 8 | 0 | Nr Mov | @! | R | .F. | S | |||
| GWN_MOTREA | M | 10 | 0 | Mot Reab. | R | S | |||||
| GWN_DTREAB | D | 8 | 0 | Data Reab | R | S | |||||
| GWN_HRREAB | C | 5 | 0 | Hora Reab | R | S | |||||
| GWN_USUREA | C | 50 | 0 | Usuario Reab | R | S | |||||
| GWN_LACRE | C | 50 | 0 | Nr Lacre | @! | R | S | ||||
| GWN_TOTVOL | N | 11 | 5 | Tot Volume | @E 99,999.99999 | V | S | ||||
| GWN_TOTPER | N | 13 | 5 | Tot Pes Real | @E 9,999,999.99999 | V | S | ||||
| GWN_TOTPEC | N | 13 | 5 | Tot Peso Cub | @E 9,999,999.99999 | V | S | ||||
| GWN_TOTALT | N | 13 | 5 | Tot Peso Liq | @E 9,999,999.99999 | V | S | ||||
| GWN_TQTVOL | N | 8 | 0 | Tot Qt Volum | @E 99,999,999 | V | S | ||||
| GWN_VIAGEM | C | 8 | 0 | Viagem | 99999999 | Vazio() .Or. GFEExistC("GWP",,M->GWN_VIAGEM,"GWP->GWP_SIT=='1'.AND.GWP->GWP_CDTRP == '"+M->GWN_CDTRP+"'") | GWPGWN | R | If(ALTERA,GFEA058RVG(),.T.) | S | |
| GWN_CPESO | N | 13 | 5 | Peso compart | @E 9,999,999.99999 | M->CPESO == 0 .Or. POSITIVO() | R | Empty(M->GWN_VIAGEM) .And. If(ALTERA,GFEA058RVG(),.T.) | S | ||
| GWN_CVOL | N | 11 | 5 | Volume comp | @E 99,999.99999 | M->GWN_CVOL == 0 .Or. POSITIVO() | R | Empty(M->GWN_VIAGEM) .And. If(ALTERA,GFEA058RVG(),.T.) | S | ||
| GWN_CVAL | N | 11 | 2 | Vlr Carga Co | @E 99,999,999.99 | M->GWN_CVAL == 0 .Or. POSITIVO() | R | Empty(M->GWN_VIAGEM) .And. If(ALTERA,GFEA058RVG(),.T.) | S | ||
| GWN_CQTDE | N | 13 | 5 | Qtde compart | @E 9,999,999.99999 | M->GWN_CQTDE == 0 .Or. POSITIVO() | R | Empty(M->GWN_VIAGEM) .And. If(ALTERA,GFEA058RVG(),.T.) | S | ||
| GWN_ENVNFE | C | 1 | 0 | Enviado NFe | @! | R | 1=Sim; 2=Nao; 3=Nao se aplica | S | |||
| GWN_MOTNFE | M | 10 | 0 | Mot Env NF | @! | R | S | ||||
| GWN_NRCT | C | 12 | 0 | Num Contrato | @! | VAZIO() .OR. GFEExistC("GXT",,M->GWN_NRCT,"GXT->GXT_CDTRP==M->GWN_CDTRP") | GWNGXT | R | S | ||