| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| DT4 | Cotacao de Frete | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| DT4_FILIAL | C | 2 | 0 | Filial | N | ||||||
| DT4_FILORI | C | 2 | 0 | Fil.Origem | TMSValidEmp(cEmpAnt+M->DT4_FILORI).And.TmsA040Vld() | DLB | N | ||||
| DT4_NUMCOT | C | 6 | 0 | No.Cotacao | @! | ExistChav("DT4",M->DT4_FILORI+M->DT4_NUMCOT) | N | ||||
| DT4_DATCOT | D | 8 | 0 | Data | @D | M->DT4_DATCOT >= dDataBase | N | ||||
| DT4_HORCOT | C | 4 | 0 | Hora | @R 99:99 | N | |||||
| DT4_CODSOL | C | 9 | 0 | Cod. Solicit | @! | TmsA040Vld().And.ExistCpo("DUE",M->DT4_CODSOL).And.Tmsa040Cot() | DL92 | R | S | ||
| DT4_DDD | C | 3 | 0 | DDD | @! | TmsA040Vld().And.ExistCpo("DUE",M->DT4_DDD+AllTrim(M->DT4_TEL)).And.Tmsa040Cot() | N | ||||
| DT4_TEL | C | 15 | 0 | Telefone | @! | TmsA040Vld().And.ExistCpo("DUE",M->DT4_DDD+AllTrim(M->DT4_TEL)).And.Tmsa040Cot() | N | ||||
| DT4_NOMSOL | C | 40 | 0 | Solicitante | @! | V | N | ||||
| DT4_CONTAT | C | 15 | 0 | Contato | @! | V | N | ||||
| DT4_NUMSOL | C | 9 | 0 | No.Sl.Coleta | @! | Vazio() .Or. TMSA040Vld() | DVM | Inclui | N | ||
| DT4_PRZVAL | D | 8 | 0 | Prz.Validade | N | ||||||
| DT4_TIPFRE | C | 1 | 0 | Tipo Frete | @! | Pertence("12").And.TMSA040Vld() | 1=CIF;2=FOB | N | |||
| DT4_CODOBS | C | 6 | 0 | Codigo Obs. | 999999 | N | |||||
| DT4_OBS | M | 80 | 0 | Observacao | V | N | |||||
| DT4_USER | C | 6 | 0 | Cod.Usuario | @! | N | |||||
| DT4_SELORI | C | 1 | 0 | Selec.Regiao | @! | Pertence("123") .And. TMSSelOri("DT4",M->DT4_SELORI,M->DT4_CLIREM,M->DT4_LOJREM,,M->DT4_FILORI,M->DT4_NUMSOL) | R | 1=Transportadora;2=Cliente Remetente;3=Local Coleta | N | ||
| DT4_CDRORI | C | 6 | 0 | Cod.Reg.Ori. | @! | TMSA040Vld() | DUY | N | |||
| DT4_REGORI | C | 30 | 0 | Reg.Origem | @! | V | N | ||||
| DT4_CDRDES | C | 6 | 0 | Cod.Reg.Des. | @! | TMSA040Vld().And. Tmsa040Cot() | DUY | N | |||
| DT4_REGDES | C | 30 | 0 | Reg.Destino | @! | V | N | ||||
| DT4_SERTMS | C | 1 | 0 | Serv.Transp. | @! | TMSValField("M->DT4_SERTMS",.T.,"DC5_DESSVT") .And. TMSA040Vld() | DLC | N | |||
| DT4_DESSVT | C | 30 | 0 | Desc.Sv.Tran | @! | V | N | ||||
| DT4_TIPTRA | C | 1 | 0 | Tipo Transp. | @! | TMSValField("M->DT4_TIPTRA",.T.,"DT4_DESTPT") .And. TMSA040Vld() | DLC | N | |||
| DT4_DESTPT | C | 30 | 0 | Desc.Tp.Tran | @! | V | N | ||||
| DT4_SERVIC | C | 3 | 0 | Servico | @! | Vazio() .Or. TMSA040Vld() | DLJ1 | TMSA040Whe() | N | ||
| DT4_DESSER | C | 30 | 0 | Desc Servico | @! | V | N | ||||
| DT4_TABFRE | C | 4 | 0 | Tabela Frete | @! | N | |||||
| DT4_TIPTAB | C | 2 | 0 | Tp.Tab.Frete | @! | N | |||||
| DT4_SEQTAB | C | 2 | 0 | Sq.Tab Frete | @! | N | |||||
| DT4_DESC | N | 15 | 5 | Desconto | @E 999,999,999.99999 | N | |||||
| DT4_TMENTI | C | 5 | 0 | Tmp.Entr.De | @R 999:99 | N | |||||
| DT4_TMENTF | C | 5 | 0 | Tmp.Entr.Ate | @R 999:99 | N | |||||
| DT4_CLIREM | C | 6 | 0 | Remetente | @! | TMSA040Vld() | SA1 | N | |||
| DT4_LOJREM | C | 2 | 0 | Loja Remet. | @! | TMSA040Vld() | N | ||||
| DT4_NOMREM | C | 40 | 0 | Nome Remet. | @! | V | N | ||||
| DT4_CLIDES | C | 6 | 0 | Destinatario | @! | TMSA040Vld() | SA1 | N | |||
| DT4_LOJDES | C | 2 | 0 | Loja Destino | @! | TMSA040Vld() | N | ||||
| DT4_NOMDES | C | 40 | 0 | Nome Destino | @! | V | N | ||||
| DT4_CLIDEV | C | 6 | 0 | Devedor | @! | TMSA040Vld() | SA1 | N | |||
| DT4_LOJDEV | C | 2 | 0 | Loja Devedor | @! | TMSA040Vld() | N | ||||
| DT4_NOMDEV | C | 40 | 0 | Nome Devedor | @! | V | N | ||||
| DT4_DATCAN | D | 8 | 0 | Data Cancela | N | ||||||
| DT4_CODOBC | C | 6 | 0 | Cod.Obs.Canc | 999999 | N | |||||
| DT4_OBSCAN | M | 80 | 0 | Obs.Cancelam | V | N | |||||
| DT4_STATUS | C | 1 | 0 | Status | @! | Pertence("123459") | 1=Pendente;2=Bloqueada;3=Aprovada;4=Encerrada;5=Divergencia De Produtos/RRE;9=Cancelada | N | |||
| DT4_USRAPV | C | 6 | 0 | Us.Aprovacao | R | N | |||||
| DT4_ACRESC | N | 15 | 5 | Acrescimo | @E 999,999,999.99999 | R | N | ||||
| DT4_PESSOA | C | 1 | 0 | Fisica/Jurid | @! | Pertence("12") | 1=Fisica;2=Juridica | TMSA040Whe("M->DT4_PESSOA") | N | ||
| DT4_TIPNFC | C | 1 | 0 | Tipo NFC | @! | Pertence("012345678") .And. TMSA040Vld() | 0=Normal;1=Devolucao;2=Subcontratacao;3=Nao Fiscal;4=Exportacao;5=Redesp;6=Nao Fiscal 1;7=Nao Fiscal 2;8=Serv Vincul.Multimodal | A040WhTpNf() | N | ||
| DT4_KM | N | 7 | 0 | KM | @E 99,999.9 | Positivo() | N | ||||
| DT4_INCISS | C | 1 | 0 | ISS no preco | @! | Pertence("12") | 1=Sim;2=Nao | N | |||
| DT4_DISTIV | C | 1 | 0 | Dis.Ida/Volt | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| DT4_INCOTE | C | 3 | 0 | Incoterm | @! | TMSA040VLD() | MP | TMSA040WHE('M->DT4_INCOTE') | N | ||
| DT4_MOEDA | N | 1 | 0 | Moeda | @E 9 | M->DT4_MOEDA > 0 .And. M->DT4_MOEDA <= MoedFin() | TMSA040WHE('M->DT4_MOEDA') | N | |||
| DT4_ROTA | C | 6 | 0 | Rota | @! | VAZIO() .Or. TMSA040VLD() | DI5 | TMSA040WHE('M->DT4_ROTA') | N | ||
| DT4_DESROT | C | 30 | 0 | Praca Princ. | @! | V | N | ||||
| DT4_CONTRI | C | 1 | 0 | Contribuinte | @! | Pertence('012') | R | 0=Nao Utiliza;1=Sim;2=Nao | TMSA040Whe('M->DT4_CONTRI') | N | |
| DT4_CADPOR | C | 1 | 0 | Cad.Portal | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| DT4_NUMATD | C | 6 | 0 | Atendimento | @! | R | N | ||||
| DT4_ITEATD | C | 3 | 0 | Item Atend. | @! | R | N | ||||
| DT4_SOLFLG | N | 8 | 0 | Soli. Fluig | 99999999 | R | N | ||||
| DT4_DOCTMS | C | 1 | 0 | Docto.Transp | @! | Vazio() .Or. TMSValField("M->DT4_DOCTMS",.T.,"DT4_DESDOC") .And. TMSA040Vld() | R | S | |||
| DT4_NCONTR | C | 15 | 0 | Contrato | @! | R | TMSA040Whe() | S | |||
| DT4_CODNEG | C | 2 | 0 | Cod Negociac | @! | (Vazio() .Or. Existcpo("DDB")) .And. TMSA040Vld() | DDB1 | R | TMSA040Whe() | S | |
| DT4_DESDOC | C | 30 | 0 | Desc.Docto. | @! | V | S | ||||
| DT4_DESNEG | C | 30 | 0 | Desc Neg Ctr | @! | V | S | ||||