Tabela
DT5 Solicitacao de Coleta
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
DT5_FILIAL C 2 0 Filial N
DT5_FILORI C 2 0 Fil.Origem TMSValidEmp(cEmpAnt+M->DT5_FILORI) DLB N
DT5_NUMSOL C 9 0 No.Sl.Coleta @! ExistChav("DT5",M->DT5_FILORI+M->DT5_NUMSOL) N
DT5_DATSOL D 8 0 Data M->DT5_DATSOL >= dDataBase N
DT5_HORSOL C 4 0 Hora @R 99:99 N
DT5_TIPCOL C 1 0 Tipo Coleta @! Pertence("12") 1=Digitada;2=Automatica N
DT5_CODSOL C 9 0 Cod. Solicit @! ExistCpo("DUE",M->DT5_CODSOL) .And. TMSA460Val() DL92 R S
DT5_DDD C 3 0 DDD @! N
DT5_TEL C 15 0 Telefone @! N
DT5_SEQEND C 9 0 Seq.Endereco @! Vazio() .Or. TMSA460Val() DLA1 N
DT5_NOME C 40 0 Solicitante @! V N
DT5_END C 40 0 Endereco @! V N
DT5_BAIRRO C 30 0 Bairro @! V N
DT5_MUN C 15 0 Municipio @! V N
DT5_EST C 2 0 Estado @! Vazio() .Or. ExistCpo("SX5","12"+M->DUE_EST) 12 V N
DT5_CEP C 8 0 CEP @R 99999-999 V N
DT5_CONTAT C 15 0 Contato @! V N
DT5_HORCOI C 4 0 Hora Ini.Col @R 99:99 V N
DT5_HORCOF C 4 0 Hora Fim Col @R 99:99 V N
DT5_CDRORI C 6 0 Cod.Reg.Ori. @! ExistCpo("DUY",M->DT5_CDRORI,1) .And. TMSA460Val() DUY N
DT5_REGORI C 30 0 Reg.Origem @! V N
DT5_CLIDES C 6 0 Destinatario @! Tmsa460Val() SA1 N
DT5_LOJDES C 2 0 Loja Dest. @! Tmsa460Val() N
DT5_NOMDES C 40 0 Nome Dest. @! V N
DT5_SQEDES C 9 0 Seq.End.Des. @! Vazio() .Or. Tmsa460Val() DLV N
DT5_ENDDES C 40 0 End. Dest. @! V N
DT5_BAIDES C 30 0 Bairro Dest. @! V N
DT5_MUNDES C 15 0 Mun. Dest. @! V N
DT5_ESTDES C 2 0 Estado Dest. @! V N
DT5_CEPDES C 8 0 CEP Dest. @! V N
DT5_TIPTRA C 1 0 Tipo Transp. @! TMSValField("M->DT5_TIPTRA",.T.,"DT5_DESTPT") DLC N
DT5_DESTPT C 30 0 Desc.Tp.Tran @! V N
DT5_CDRDCA C 6 0 Cod.Reg.Carg @! ExistCpo('DUY',M->DT5_CDRDCA,1) .And. TMSA460Val() DUY Tmsa460Whe() N
DT5_REGDCA C 30 0 Destino Carg @! V N
DT5_FILDES C 2 0 Fil. Destino V N
DT5_NUMCOT C 6 0 No.Cotacao @! Vazio() .Or. TMSA460Val() DVN Inclui N
DT5_USER C 6 0 Cod.Usuario @! N
DT5_DATPRV D 8 0 Dta. Pre Col M->DT5_DATPRV >= dDataBase N
DT5_HORPRV C 4 0 Hora Pre Col @R 99:99 AtVldHora(M->DT5_HORPRV) N
DT5_DATENT D 8 0 Dta. Pre Ent Vazio() .Or. M->DT5_DATENT >= dDataBase N
DT5_HORENT C 4 0 Hora Pre Ent @R 99:99 Vazio() .Or. AtVldHora(M->DT5_HORENT) N
DT5_CODOBS C 6 0 Codigo Obs. 999999 N
DT5_OBS M 80 0 Observacao V N
DT5_DATCAN D 8 0 Data Cancela (M->DT5_DATCAN >= M->DT5_DATSOL) N
DT5_CODOBC C 6 0 Cod.Obs.Canc 999999 N
DT5_OBSCAN M 80 0 Obs.Cancelam V N
DT5_FILDOC C 2 0 Fil.Docto. N
DT5_DOC C 9 0 No.Docto. @! N
DT5_SERIE C 3 0 Serie Docto. !!! N
DT5_ROTPRE C 6 0 Rot.Prevista @! N
DT5_STATUS C 1 0 Status @! Pertence("1234569") 1=Em Aberto;2=Indicada para Coleta;3=Em Transito;4=Encerrada;5=Documento Informado;6=Bloqueada;7=Em Conferencia;9=Cancelada N
DT5_USRLIB C 6 0 Usr.Liberac. @! N
DT5_DATLIB D 8 0 Data Liberac N
DT5_HORLIB C 4 0 Hora Liberac @R 99:99 N
DT5_CLIDEV C 6 0 Devedor @! Tmsa460Val() SA1 R N
DT5_LOJDEV C 2 0 Loja Devedor @! Tmsa460Val() R N
DT5_NOMDEV C 40 0 Nome devedor @! V N
DT5_CADPOR C 1 0 Cad.Portal Pertence("12") R 1=Sim;2=Nao N
DT5_NUMATD C 6 0 Atendimento @! R N
DT5_ITEATD C 3 0 Item Atend. @! R N
DT5_OLDSEQ C 2 0 Old.Seq.End. @! R N
DT5_OLDSQD C 2 0 Old.Sq.End.D @! R N
DT5_SDOC C 3 0 Serie Doc. !!! R S
DT5_NCONTR C 15 0 Contrato @! R S
DT5_CODNEG C 2 0 Cod Negociac @! (Vazio() .Or. Existcpo("DDB")) .And. TMSA460Val() DDB1 R TMSA460Whe() S
DT5_DESNEG C 30 0 Desc Neg Ctr @! V S
DT5_SERVIC C 3 0 Servico @! (Vazio() .Or. ExistCpo("DC5",,1)) .And. TMSA460VAL() DLJ1 R TMSA460Whe() S
DT5_DESSER C 30 0 Descr Servic @! V S
DT5_TIPFRE C 1 0 Tipo Frete @! Pertence("12") .And. TMSA460VAL() R 1=CIF;2=FOB TMSA460Whe() S
DT5_CLIREM C 6 0 Remetente @! Tmsa460Val() SA1 R S
DT5_LOTE C 6 0 Lote Coleta @! DTP R N
DT5_KM N 7 1 KM @E 99,999.9 Positivo() R N
DT5_LOJREM C 2 0 Loja Remet @! Tmsa460Val() R S
DT5_SQEREM C 9 0 Seq.End.Rem @! Vazio() .Or. Tmsa460Val() DLA R S
DT5_LOCCOL C 1 0 Local Coleta @! Pertence('12') .And. TMSA460Val() R 1=Solicitante;2=Remetente N
DT5_NOMREM C 40 0 Nome Remet. @! V S
DT5_SRVENT C 3 0 Serv.Entrega @! (Vazio() .Or. ExistCpo("DC5",,1)) .And. TMSA460VAL() DLJ1 R TMSA460Whe() S
DT5_DESENT C 30 0 Desc.Srv.Ent @! V S
DT5_CODDMD C 8 0 Cod. Demanda @! R S
DT5_SEQDMD C 2 0 Seq. Demanda @! R S
DT5_ORIDMD C 1 0 Origem Deman @! R 1=Demanda; 2=TMS S