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 |