| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GWF | CALCULO DE FRETE | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GWF_FILIAL | C | 2 | 0 | Filial | S | ||||||
| GWF_NRCALC | C | 8 | 0 | Calculo | 99999999 | Val(M->GWF_NRCALC) > 0 .AND. ExistChav("GWF",M->GWF_NRCALC) | R | S | |||
| GWF_EMIREM | C | 14 | 0 | Remetente | @! | ExistCpo("GU3",M->GWF_EMIREM) | GU3GUC | R | S | ||
| GWF_NMREM | C | 80 | 0 | Nome Rem | V | S | |||||
| GWF_EMIDES | C | 14 | 0 | Destinatario | @! | ExistCpo("GU3",M->GWF_EMIDES) | GU3GUC | R | S | ||
| GWF_NMDEST | C | 80 | 0 | Nome Dest | V | S | |||||
| GWF_EMIRED | C | 14 | 0 | Redesp. | @! | Vazio() .OR. ExistCpo("GU3",M->GWF_EMIRED) | GU3TRP | R | S | ||
| GWF_NMRED | C | 80 | 0 | Nome Redesp | V | S | |||||
| GWF_EMIPAG | C | 14 | 0 | Pagador | @! | ExistCpo("GU3",M->GWF_EMIPAG) | GU3GUC | R | S | ||
| GWF_NMPAG | C | 80 | 0 | Nome Pag | V | S | |||||
| GWF_TRANSP | C | 14 | 0 | Transp. | @! | ExistCpo("GU3",M->GWF_TRANSP) | R | S | |||
| GWF_NMTRP | C | 80 | 0 | Nome Transp | V | S | |||||
| GWF_ORIGEM | C | 1 | 0 | Origem Valor | @! | Pertence("1234") | R | 1=Calculado;2=Informado;3=Apuracao Periodo;4=Simulacao | S | ||
| GWF_TPCALC | C | 1 | 0 | Tipo Calculo | @! | Pertence("12345678") | R | 1=Normal;2=Compl Valor;3=Compl Imposto;4=Reentrega;5=Devolucao;6=Redespacho;7=Servico;8=Estimativa | S | ||
| GWF_TPFRET | C | 1 | 0 | Tipo Frete | @! | Pertence("123456") | R | 1=CIF;2=CIF Redesp.;3=FOB;4=FOB Redesp.;5=Consignado;6=Consig. Redesp. | S | ||
| GWF_FINCAL | C | 1 | 0 | Finalidade | @! | Pertence("123") | R | 1=CTR;2=NFST;3=Contrato | S | ||
| GWF_CIDORI | C | 7 | 0 | Cid. Origem | 9999999 | ExistCpo("GU7",M->GWF_CIDORI) | R | S | |||
| GWF_NMCIOR | C | 50 | 0 | Nome Cid Ori | @! | V | S | ||||
| GWF_CIDDES | C | 7 | 0 | Cid. Destino | 9999999 | ExistCpo("GU7",M->GWF_CIDDES) | R | S | |||
| GWF_NMCIDE | C | 50 | 0 | Nome Cid Des | @! | V | S | ||||
| GWF_ENDENT | C | 50 | 0 | Ender. Entr. | @! | Texto() | R | S | |||
| GWF_BAIENT | C | 30 | 0 | Bairro Entr. | @! | Texto() | R | S | |||
| GWF_CIDENT | C | 7 | 0 | Cid. Entrega | 9999999 | Vazio() .OR. ExistCpo("GU7",M->GWF_CIDENT) | R | S | |||
| GWF_DTCRIA | D | 8 | 0 | Data Criacao | R | S | |||||
| GWF_HRCRIA | C | 5 | 0 | Hora Criacao | @R 99:99 | R | S | ||||
| GWF_USUCRI | C | 50 | 0 | Usr. Criacao | @! | R | S | ||||
| GWF_DTPREN | D | 8 | 0 | Dat Prev Ent | R | S | |||||
| GWF_HRPREN | C | 5 | 0 | Hr Prev Entr | @R 99:99 | R | S | ||||
| GWF_CARREG | C | 12 | 0 | Carregamento | R | S | |||||
| GWF_NRROM | C | 8 | 0 | Romaneio | 99999999 | R | S | ||||
| GWF_VLAJUS | N | 12 | 2 | Valor Ajuste | @E 999,999,999.99 | R | S | ||||
| GWF_TPTRIB | C | 1 | 0 | Tipo Tribut. | Pertence("123456") | R | 1=Tributado;2=Isento/Nao-tributado;3=Subs Tributaria;4=Diferido;5=Reduzido;6=Outros;7=Presumido | S | |||
| GWF_IMPOST | C | 1 | 0 | Imposto | R | 1=ICMS;2=ISS | S | ||||
| GWF_BASISS | N | 12 | 2 | Base ISS | @E 999,999,999.99 | Positivo() | R | M->GWF_IMPOST = "2" | S | ||
| GWF_PCISS | N | 9 | 5 | % ISS | @E 999.99999 | Positivo() | R | M->GWF_IMPOST = "2" | S | ||
| GWF_VLISS | N | 12 | 2 | Vl. ISS | @E 999,999,999.99 | R | M->GWF_IMPOST = "2" | S | |||
| GWF_BASICM | N | 12 | 2 | Base ICMS | @E 999,999,999.99 | R | M->GWF_IMPOST = "1" | S | |||
| GWF_PCICMS | N | 9 | 5 | % ICMS Aplic | @E 999.99999 | R | M->GWF_IMPOST = "1" | S | |||
| GWF_PCREIC | N | 9 | 5 | % Red. ICMS | @E 999.99999 | R | S | ||||
| GWF_VLICMS | N | 12 | 2 | Vl. ICMS | @E 999,999,999.99 | R | M->GWF_IMPOST = "1" | S | |||
| GWF_ICMRET | N | 12 | 2 | ICMS Retido | @E 999,999,999.99 | R | S | ||||
| GWF_CRDICM | C | 1 | 0 | Cred ICMS | @! | R | 1=Sim;2=Nao | S | |||
| GWF_BAPICO | N | 12 | 2 | Base PIS/COF | @E 999,999,999.99 | R | S | ||||
| GWF_VLPIS | N | 12 | 2 | Vl. PIS | @E 999,999,999.99 | R | S | ||||
| GWF_VLCOFI | N | 12 | 2 | Vl. COFINS | @E 999,999,999.99 | R | S | ||||
| GWF_FILPRE | C | 2 | 0 | Fil. Pre-fat | R | S | |||||
| GWF_NRPREF | C | 8 | 0 | Nr Pre-fat. | 99999999 | Vazio .OR. ExistCpo("GWJ",M->GWF_FILIAL+M->GWF_NRPREF) | R | S | |||
| GWF_NRCONT | C | 8 | 0 | Nr Contrato | 99999999 | R | S | ||||
| GWF_IDFRVI | C | 1 | 0 | Fr Viagem? | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| GWF_AGRUP | C | 1 | 0 | Agrupado? | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| GWF_SEQTRE | C | 3 | 0 | Sequencia | R | S | |||||
| GWF_OBS | M | 10 | 0 | Observacoes | R | S | |||||
| GWF_CRDPC | C | 1 | 0 | Cred PIS/COF | @! | R | 1=Sim;2=Nao | S | |||
| GWF_NROCO | C | 8 | 0 | Ocorrencia | 99999999 | R | S | ||||
| GWF_ADICIS | C | 1 | 0 | Ad. ICMS/ISS | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| GWF_CDTPSE | C | 20 | 0 | Tp Servico | @! | R | S | ||||
| GWF_CDESP | C | 5 | 0 | Especie DF | @! | R | S | ||||
| GWF_EMISDF | C | 14 | 0 | Emissor DF | @! | R | S | ||||
| GWF_DSTPSE | C | 50 | 0 | Descricao | @! | V | S | ||||
| GWF_SERDF | C | 5 | 0 | Serie DF | R | S | |||||
| GWF_NRDF | C | 16 | 0 | Numero DF | R | S | |||||
| GWF_DTEMDF | D | 8 | 0 | Data Emis DF | R | S | |||||