| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| DF1 | Itens do Agendamento | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| DF1_FILIAL | C | 2 | 0 | Filial | N | ||||||
| DF1_NUMAGE | C | 6 | 0 | Agendamento | @! | TmsA144Val() | DF1 | N | |||
| DF1_ITEAGE | C | 3 | 0 | Item | @! | TmsA144Val() | TmsA144Whe() | N | |||
| DF1_STACOL | C | 1 | 0 | Status Col | @! | TMSAF05Vld() | 1=A Confirmar;2=Confirmado;3=Planejado;4=Em Processo;5=Encerrado;9=Cancelado | TMSAF05Whn() | N | ||
| DF1_STAENT | C | 1 | 0 | Status Ent | @! | 1=A Confirmar;2=Confirmado;3=Planejado;4=Em Processo;5=Encerrado;9=Cancelado | N | ||||
| DF1_LOCCOL | C | 1 | 0 | Local Coleta | @! | Pertence("12") .And. TMSAF05Vld() | 1=Solicitante;2=Remetente | TMSAF05Whn() | N | ||
| DF1_FILORI | C | 2 | 0 | Fil.Origem | TMSAF05Vld() | DLB | TMSAF05Whn() | N | |||
| DF1_CLIREM | C | 6 | 0 | Remetente | @! | TMSAF05Vld() | SA1 | TMSAF05Whn() | N | ||
| DF1_LOJREM | C | 2 | 0 | Loja Remet. | @! | TMSAF05Vld() | TMSAF05Whn() | N | |||
| DF1_NOMREM | C | 40 | 0 | Nome Remet. | @! | V | N | ||||
| DF1_SQEREM | C | 9 | 0 | Seq.End.Rem. | @! | TMSAF05Vld() | DLT1 | TMSAF05Whn() | N | ||
| DF1_END | C | 40 | 0 | Endereco | @! | V | N | ||||
| DF1_BAIRRO | C | 30 | 0 | Bairro | @! | V | N | ||||
| DF1_MUN | C | 15 | 0 | Municipio | @! | V | N | ||||
| DF1_EST | C | 2 | 0 | Estado | @! | V | N | ||||
| DF1_CEP | C | 8 | 0 | CEP | @R 99999-999 | V | N | ||||
| DF1_TIPTRA | C | 1 | 0 | Tipo Transp. | @! | Vazio() .Or. TMSValField("M->DF1_TIPTRA",.T.,"DF1_DESTPT") .And. TMSAF05Vld() | DLC | TMSAF05Whn() | N | ||
| DF1_DESTPT | C | 30 | 0 | Desc.Tp.Tran | @! | V | N | ||||
| DF1_SELORI | C | 1 | 0 | Selec.Regiao | @! | TMSAF05Vld() | 1=Transportadora;2=Cliente Remetente;3=Local Coleta | TMSAF05Whn() | N | ||
| DF1_CDRORI | C | 6 | 0 | Cod.Reg.Ori. | @! | N | |||||
| DF1_REGORI | C | 30 | 0 | Reg.Origem | @! | V | N | ||||
| DF1_DATPRC | D | 8 | 0 | Dt Pre Col | Vazio() .Or. ( M->DF1_DATPRC >= dDataBase .And. TMSAF05Vld() ) | TMSAF05Whn() | N | ||||
| DF1_HORPRC | C | 4 | 0 | Hora Pre Col | @R 99:99 | TMSAF05Vld() | TMSAF05Whn() | N | |||
| DF1_SERVIC | C | 3 | 0 | Servico | @! | TMSAF05Vld() | DLZ | TMSAF05Whn() | N | ||
| DF1_DESSER | C | 30 | 0 | Desc.Servico | @! | V | N | ||||
| DF1_PRDAGE | C | 9 | 0 | Produto(s) | @! | V | TMSAF05Whn() .And. TMSAF05Prd() | N | |||
| DF1_CLIDES | C | 6 | 0 | Destinatario | @! | TMSAF05Vld() | SA1 | TMSAF05Whn() | N | ||
| DF1_LOJDES | C | 2 | 0 | Loja Dest. | @! | TMSAF05Vld() | TMSAF05Whn() | N | |||
| DF1_NOMDES | C | 40 | 0 | Nome Dest. | @! | V | N | ||||
| DF1_SQEDES | C | 9 | 0 | Seq.End.Dest | @! | TMSAF05Vld() | DLT1 | TMSAF05Whn() | N | ||
| DF1_ENDDES | C | 40 | 0 | End. Dest. | @! | V | N | ||||
| DF1_BAIDES | C | 30 | 0 | Bairro Dest. | @! | V | N | ||||
| DF1_MUNDES | C | 15 | 0 | Munic. Dest. | @! | V | N | ||||
| DF1_ESTDES | C | 2 | 0 | Estado Dest. | @! | V | N | ||||
| DF1_CEPDES | C | 8 | 0 | CEP Dest. | @R 99999-999 | V | N | ||||
| DF1_CDRDES | C | 6 | 0 | Cod.Reg.Des. | @! | N | |||||
| DF1_REGDES | C | 30 | 0 | Reg.Destino | @! | V | N | ||||
| DF1_DATPRE | D | 8 | 0 | Dt Pre Ent | Vazio() .Or. ( M->DF1_DATPRE >= dDataBase .And. TMSAF05Vld() ) | TMSAF05Whn() | N | ||||
| DF1_HORPRE | C | 4 | 0 | Hor Pre Ent | @R 99:99 | TMSAF05Vld() | TMSAF05Whn() | N | |||
| DF1_TIPFRE | C | 1 | 0 | Tipo Frete | @! | Vazio() .Or. ( Pertence("12") .And. TMSAF05Vld() ) | 1=CIF;2=FOB | TMSAF05Whn() | N | ||
| DF1_CLIDEV | C | 6 | 0 | Devedor | @! | TMSAF05Vld() | SA1 | TMSAF05Whn() | N | ||
| DF1_LOJDEV | C | 2 | 0 | Loja Dev. | @! | TMSAF05Vld() | TMSAF05Whn() | N | |||
| DF1_NOMDEV | C | 40 | 0 | Nome Dev. | @! | V | N | ||||
| DF1_TIPVEI | C | 9 | 0 | Tipo Veiculo | @! | V | TMSAF05Tip() | N | |||
| DF1_VLRINF | N | 14 | 2 | Frt.Informad | @E 99,999,999,999.99 | Positivo() .And. TmsAF05Vld() | TmsAF05Whn() | N | |||
| DF1_NUMCOT | C | 6 | 0 | No. Cotacao | @! | N | |||||
| DF1_VALFRE | N | 14 | 2 | Vlr Frete | @E 99,999,999,999.99 | N | |||||
| DF1_VALIMP | N | 14 | 2 | Vlr Impostos | @E 99,999,999,999.99 | N | |||||
| DF1_VALTOT | N | 14 | 2 | Vlr Total | @E 99,999,999,999.99 | N | |||||
| DF1_QTDVOL | N | 5 | 0 | Qtde.Volume | 99999 | N | |||||
| DF1_PESO | N | 11 | 4 | Peso Real | @E 999,999.9999 | N | |||||
| DF1_PESOM3 | N | 11 | 4 | Peso Cubado | @E 999,999.9999 | N | |||||
| DF1_METRO3 | N | 11 | 4 | M3 | @E 999,999.9999 | N | |||||
| DF1_VALMER | N | 14 | 2 | Valor Merc. | @E 99,999,999,999.99 | N | |||||
| DF1_FILDOC | C | 2 | 0 | Fil.Docto. | N | ||||||
| DF1_DOC | C | 9 | 0 | No.Docto. | @! | N | |||||
| DF1_SERIE | C | 3 | 0 | Serie Docto. | !!! | N | |||||
| DF1_DATCON | D | 8 | 0 | Dt Confirm | N | ||||||
| DF1_SEQUEN | C | 3 | 0 | Sequencia | TMSAF05Ord() | lAltSeq | N | ||||
| DF1_SEQENT | C | 3 | 0 | Seq.Entrega | R | N | |||||
| DF1_DISTIV | C | 1 | 0 | Dis.Ida/Volt | Pertence("12") | R | 1=Sim;2=Nao;3=Nao Utiliza | M->DF0_TIPDIS == '2' | N | ||
| DF1_DATCAN | D | 8 | 0 | Dt. Cancela | TMSAF05VLD() | R | N | ||||
| DF1_CODOBC | C | 6 | 0 | Cod.Obs.Canc | @! | R | N | ||||
| DF1_OBSCAN | M | 80 | 0 | Obs.Cancel. | @! | V | N | ||||
| DF1_DISTAN | N | 7 | 1 | Dist. Age. | @E 99,999.9 | R | N | ||||
| DF1_MRKPAN | C | 20 | 0 | Marca | @! | R | N | ||||
| DF1_NFBALC | C | 1 | 0 | NF Balcao? | @! | Pertence("12") | R | 1=Sim;2=Nao | N | ||
| DF1_OLDSQR | C | 2 | 0 | Old.Sq.End.R | @! | R | N | ||||
| DF1_OLDSQD | C | 2 | 0 | Old.Sq.End.D | @! | R | N | ||||
| DF1_TIPNFC | C | 1 | 0 | Tipo NFC | @! | PERTENCE('012345678') | R | 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 | N | ||
| DF1_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| DF1_CODNEG | C | 2 | 0 | Cod Negociac | @! | (Vazio() .Or. Existcpo("DDB")) .And. TMSAF05Vld() | DDB1 | R | TMSAF05Whe() | S | |
| DF1_DOCTMS | C | 1 | 0 | Docto.Transp | @! | Vazio() .Or. TMSValField("M->DF1_DOCTMS",.T.,"DF1_DESDOC") .And. TMSAF05Vld() | R | S | |||
| DF1_DESNEG | C | 30 | 0 | Desc Neg Ctr | @! | V | S | ||||
| DF1_NCONTR | C | 15 | 0 | Contrato | @! | R | S | ||||
| DF1_DESDOC | C | 30 | 0 | Desc.Docto. | @! | V | S | ||||
| DF1_SRVCOL | C | 3 | 0 | Serv.Coleta | @! | Vazio() .Or. TMSAF05Vld() | DLJ1 | R | S | ||
| DF1_SCOMAN | C | 1 | 0 | Sol Col Man | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| DF1_DESCOL | C | 30 | 0 | Desc.Srv.Col | @! | V | S | ||||