Tabela |
DT6 |
Documentos de Transporte |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
DT6_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
DT6_FILDOC |
C |
2 |
0 |
Fil.Docto. |
|
|
|
|
|
|
S |
DT6_DOC |
C |
9 |
0 |
No.Docto. |
@! |
|
|
|
|
|
S |
DT6_SERIE |
C |
3 |
0 |
Serie Docto. |
!!! |
|
|
|
|
|
S |
DT6_DATEMI |
D |
8 |
0 |
Data Emissao |
|
|
|
|
|
|
S |
DT6_HOREMI |
C |
4 |
0 |
Hora Emissao |
@R 99:99 |
|
|
|
|
|
S |
DT6_VOLORI |
N |
5 |
0 |
Vol. Orig. |
99999 |
Positivo() |
|
|
|
|
S |
DT6_QTDVOL |
N |
5 |
0 |
Qtde. Volume |
99999 |
Positivo() .And. TMSA500Vld() |
|
|
|
|
S |
DT6_PESO |
N |
11 |
4 |
Peso Real |
@E 999,999.9999 |
Positivo() .And. TMSA500Vld() |
|
|
|
|
S |
DT6_PESOM3 |
N |
11 |
4 |
Peso Cubado |
@E 999,999.9999 |
|
|
|
|
|
S |
DT6_PESCOB |
N |
14 |
4 |
Peso Cobrado |
@E 999,999,999.9999 |
|
|
|
|
|
S |
DT6_METRO3 |
N |
11 |
4 |
M3 |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
DT6_VALMER |
N |
14 |
2 |
Vlr.Mercad. |
@E 99,999,999,999.99 |
TMSA500Vld() |
|
|
|
|
S |
DT6_QTDUNI |
N |
5 |
0 |
Unitizadores |
99999 |
Positivo() |
|
|
|
|
S |
DT6_VALFRE |
N |
14 |
2 |
Vlr.Frete |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
DT6_VALIMP |
N |
14 |
2 |
Vlr.Impostos |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
DT6_VALTOT |
N |
14 |
2 |
Vlr.Total |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
DT6_BASSEG |
N |
14 |
2 |
Base RR |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
DT6_SERTMS |
C |
1 |
0 |
Serv.Transp. |
@! |
|
|
|
|
|
S |
DT6_DESSVT |
C |
30 |
0 |
Desc.Sv.Tran |
@! |
|
|
V |
|
|
S |
DT6_TIPTRA |
C |
1 |
0 |
Tipo Transp. |
@! |
TmsValField("M->DT6_TIPTRA",.T.,"DT6_DESTPT") |
DLC |
|
|
|
S |
DT6_DESTPT |
C |
30 |
0 |
Desc.Tp.Tran |
@! |
|
|
V |
|
|
S |
DT6_DOCTMS |
C |
1 |
0 |
Docto.Transp |
@! |
|
|
|
|
|
S |
DT6_DESDOC |
C |
30 |
0 |
Desc.Docto. |
@! |
|
|
V |
|
|
S |
DT6_CDRORI |
C |
6 |
0 |
Cod.Reg.Ori. |
@! |
|
|
|
|
|
S |
DT6_CDRDES |
C |
6 |
0 |
Cod.Reg.Des. |
@! |
|
|
|
|
|
S |
DT6_CDRCAL |
C |
6 |
0 |
Cod.Reg.Cal. |
@! |
|
|
R |
|
|
S |
DT6_TABFRE |
C |
4 |
0 |
Tabela Frete |
@! |
|
|
|
|
|
S |
DT6_TIPTAB |
C |
2 |
0 |
Tp.Tab.Frete |
@! |
|
|
|
|
|
S |
DT6_SEQTAB |
C |
2 |
0 |
Sq.Tab Frete |
@! |
|
|
|
|
|
S |
DT6_TIPFRE |
C |
1 |
0 |
Tipo Frete |
@! |
Pertence("12") |
|
|
1=CIF;2=FOB |
|
S |
DT6_DOCSEG |
C |
9 |
0 |
Docto.Seguro |
@! |
|
|
|
|
|
S |
DT6_NCONTR |
C |
15 |
0 |
No.Contrato |
@! |
|
|
|
|
|
S |
DT6_PRZENT |
D |
8 |
0 |
Prz.Entrega |
@! |
|
|
|
|
|
S |
DT6_FILORI |
C |
2 |
0 |
Fil.Origem |
|
|
|
|
|
|
S |
DT6_LOTNFC |
C |
6 |
0 |
No.Lote TMS |
@! |
|
|
|
|
|
S |
DT6_FILDES |
C |
2 |
0 |
Fil.Destino |
|
|
|
|
|
|
S |
DT6_OK |
C |
2 |
0 |
Ok |
@! |
|
|
|
|
|
S |
DT6_FIMP |
C |
1 |
0 |
Flag Imp. |
@! |
|
|
|
0=Nao Impresso;1=Impresso |
|
S |
DT6_BLQDOC |
C |
1 |
0 |
Blq.Docto. |
@! |
Pertence("123") |
|
|
1=Sim;2=Nao;3=Descarregando |
|
S |
DT6_PRIPER |
C |
1 |
0 |
Doc.1o.Perc. |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
DT6_PERDCO |
N |
9 |
5 |
% Doc.Origem |
@E 999.99999 |
|
|
|
|
|
S |
DT6_FILDCO |
C |
2 |
0 |
Fil.Doc.Orig |
|
|
|
|
|
|
S |
DT6_DOCDCO |
C |
9 |
0 |
No.Doc.Orig |
@! |
|
|
|
|
|
S |
DT6_SERDCO |
C |
3 |
0 |
Ser.Doc.Orig |
!!! |
|
|
|
|
|
S |
DT6_CLIREM |
C |
6 |
0 |
Remetente |
@! |
|
SA1 |
|
|
|
S |
DT6_LOJREM |
C |
2 |
0 |
Loja Remet. |
@! |
|
|
|
|
|
S |
DT6_NOMREM |
C |
40 |
0 |
Nome Remet. |
@! |
|
|
V |
|
|
S |
DT6_CLIDES |
C |
6 |
0 |
Destinatario |
@! |
|
SA1 |
|
|
|
S |
DT6_LOJDES |
C |
2 |
0 |
Loja Dest. |
@! |
TmsA500Vld() |
|
R |
|
|
S |
DT6_NOMDES |
C |
40 |
0 |
Nome Dest. |
@! |
|
|
V |
|
|
S |
DT6_CLICON |
C |
6 |
0 |
Consignatar. |
@! |
|
SA1 |
|
|
|
S |
DT6_LOJCON |
C |
2 |
0 |
Loja Consig. |
@! |
|
|
|
|
|
S |
DT6_NOMCON |
C |
40 |
0 |
Nome Consig. |
@! |
|
|
V |
|
|
S |
DT6_CLIDPC |
C |
6 |
0 |
Despachante |
@! |
|
SA1 |
|
|
|
S |
DT6_LOJDPC |
C |
2 |
0 |
Loja Despach |
@! |
|
|
|
|
|
S |
DT6_NOMDPC |
C |
40 |
0 |
Nome Despach |
@! |
|
|
V |
|
|
S |
DT6_CLIDEV |
C |
6 |
0 |
Devedor |
@! |
IIf(IsInCallStack("TMSA500Mnt"), A500VldCli() , .T. ) |
SA1 |
|
|
IIf(IsInCallStack("TMSA500Mnt"),.T.,.F.) |
S |
DT6_LOJDEV |
C |
2 |
0 |
Loja Devedor |
@! |
IIf(IsInCallStack("TMSA500Mnt"), A500VldCli() , .T. ) |
|
|
|
IIf(IsInCallStack("TMSA500Mnt"),.T.,.F.) |
S |
DT6_NOMDEV |
C |
40 |
0 |
Nome Devedor |
@! |
|
|
V |
|
|
S |
DT6_CLICAL |
C |
6 |
0 |
Cli. Calculo |
@! |
|
SA1 |
|
|
|
S |
DT6_LOJCAL |
C |
2 |
0 |
Loja Calculo |
@! |
|
|
|
|
|
S |
DT6_NOMCAL |
C |
40 |
0 |
Nome Calculo |
@! |
|
|
V |
|
|
S |
DT6_DEVFRE |
C |
1 |
0 |
Dev. Frete |
@! |
Pertence("1234567") .And. TMSA500Vld() |
|
|
1=Remetente;2=Destinatario;3=Consignatario;4=Despachante;6=Expedidor;7=Recebedor |
|
S |
DT6_LOTCET |
C |
6 |
0 |
Lote Cpv.Ent |
@! |
|
|
|
|
|
S |
DT6_FATURA |
C |
9 |
0 |
Fatura |
@! |
|
|
|
|
|
S |
DT6_SERVIC |
C |
3 |
0 |
Servico |
@! |
TmsA500Vld() |
DLJ |
R |
|
|
S |
DT6_DESSER |
C |
30 |
0 |
Desc.Servico |
@! |
|
|
V |
|
|
S |
DT6_ROTENT |
C |
6 |
0 |
Rota Entrega |
@! |
|
|
|
|
|
S |
DT6_DATENT |
D |
8 |
0 |
Data Entrega |
@! |
|
|
|
|
|
S |
DT6_SELFIS |
C |
10 |
0 |
Selo Fiscal |
@! |
|
|
|
|
|
S |
DT6_CODMSG |
C |
6 |
0 |
Cod.Msg Fis. |
@! |
|
|
|
|
|
S |
DT6_ULTEMB |
D |
8 |
0 |
Dat.Embarque |
@! |
|
|
|
|
|
S |
DT6_FILVGA |
C |
2 |
0 |
Fil.Vge.Atu. |
|
|
|
|
|
|
S |
DT6_NUMVGA |
C |
6 |
0 |
Num.Vge.Atu. |
|
|
|
|
|
|
S |
DT6_NUMCMP |
C |
6 |
0 |
N.Composicao |
@! |
|
|
|
|
|
S |
DT6_STATUS |
C |
1 |
0 |
Status |
@! |
Pertence("123456789BCD") |
|
|
#TMSA500CBX() |
|
S |
DT6_CUSTO1 |
N |
14 |
2 |
Custo Moeda1 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
DT6_CUSTO2 |
N |
14 |
2 |
Custo Moeda2 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
DT6_CUSTO3 |
N |
14 |
2 |
Custo Moeda3 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
DT6_CUSTO4 |
N |
14 |
2 |
Custo Moeda4 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
DT6_CUSTO5 |
N |
14 |
2 |
Custo Moeda5 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
DT6_DATEDI |
D |
8 |
0 |
Data EDI |
|
|
|
|
|
|
S |
DT6_MANIFE |
C |
9 |
0 |
Manifesto |
@! |
|
|
V |
|
|
S |
DT6_NUMSOL |
C |
6 |
0 |
No.Sol.Trans |
@! |
|
|
|
|
|
S |
DT6_VENCTO |
D |
8 |
0 |
Dt.Vencto. |
|
|
|
|
|
|
S |
DT6_ACRESC |
N |
14 |
2 |
Vl.Acresc. |
@E 999,999,999.99 |
|
|
|
|
|
S |
DT6_DECRES |
N |
14 |
2 |
Vl.Decresc. |
@E 999,999,999.99 |
|
|
|
|
|
S |
DT6_FILDEB |
C |
2 |
0 |
Fil.Debito |
|
|
|
|
|
|
S |
DT6_PREFIX |
C |
3 |
0 |
Prefixo |
@! |
|
|
|
|
|
S |
DT6_NUM |
C |
9 |
0 |
No.Titulo |
@! |
|
|
|
|
|
S |
DT6_TIPO |
C |
3 |
0 |
Tipo Titulo |
@! |
|
|
|
|
|
S |
DT6_MOEDA |
N |
2 |
0 |
Moeda |
99 |
|
|
|
|
|
S |
DT6_BAIXA |
D |
8 |
0 |
Dt.Baixa |
@! |
|
|
|
|
|
S |
DT6_FILNEG |
C |
2 |
0 |
Filial Negoc |
|
|
|
R |
|
|
S |
DT6_VALFAT |
N |
14 |
2 |
Valor Fatura |
@E 999,999,999.99 |
|
|
R |
|
|
S |
DT6_ALIANC |
C |
2 |
0 |
Alianca |
@! |
|
|
|
|
|
S |
DT6_REENTR |
N |
2 |
0 |
Qt.Reentrega |
99 |
Positivo() |
|
R |
|
|
S |
DT6_TIPMAN |
C |
1 |
0 |
Tipo Manut. |
@! |
Pertence('0123') |
|
R |
0=Nao tem;1=Automatica;2=Manual calculada;3=Manual digitada |
|
S |
DT6_FLOREF |
C |
2 |
0 |
Fil Lot Ref |
@! |
|
|
R |
|
|
S |
DT6_LOTREF |
C |
6 |
0 |
Lote Refat |
@! |
|
|
R |
|
|
S |
DT6_TPACAO |
C |
1 |
0 |
Tipo de Acao |
@! |
Pertence('0123') |
|
V |
0=Nenhuma;1=Devolucao;2=Armazenagem;3=Ambas |
|
S |
DT6_CODOBS |
C |
6 |
0 |
Obs Compl. |
@! |
|
|
R |
|
|
S |
DT6_PESLIQ |
N |
11 |
4 |
Peso Liquido |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
DT6_USRGER |
C |
6 |
0 |
Usr.Geracao |
@! |
|
|
|
|
|
S |
DT6_USRIMP |
C |
6 |
0 |
Usr.Impress. |
@! |
|
|
|
|
|
S |
DT6_SIGTRA |
C |
2 |
0 |
Sigla Transp |
@! |
|
|
|
|
|
S |
DT6_NUMRED |
C |
6 |
0 |
Redespacho |
@! |
|
|
V |
|
|
S |
DT6_CODRED |
C |
8 |
0 |
Cod. Redesp. |
@! |
|
|
V |
|
|
S |
DT6_LOJRED |
C |
2 |
0 |
Loja Redesp. |
@! |
|
|
V |
|
|
S |
DT6_NOMRED |
C |
30 |
0 |
Nome Redesp. |
@! |
|
|
V |
|
|
S |
DT6_NFELET |
C |
8 |
0 |
NF-e |
@! |
|
|
R |
|
|
S |
DT6_EMINFE |
D |
8 |
0 |
Emissao NF-e |
@D |
|
|
R |
|
|
S |
DT6_CODNFE |
C |
8 |
0 |
Cd.Ver.NF-e |
@! |
|
|
R |
|
|
S |
DT6_IDRCTE |
C |
3 |
0 |
ID Rej.CTe |
@! |
|
|
R |
|
|
S |
DT6_PROCTE |
C |
15 |
0 |
Protoco. CTE |
@! |
|
|
R |
|
|
S |
DT6_CHVCTE |
C |
44 |
0 |
Chave Acesso |
@! |
|
|
R |
|
|
S |
DT6_SITCTE |
C |
1 |
0 |
Situacao CTe |
@! |
Pertence("0123456") |
|
R |
0=Nao Se Aplica;1=Aguardando;2=Autorizado;3=Nao Autorizado;4=Em Contingencia;5=Falha Comunicacao;6=Nao Transmitido |
|
S |
DT6_RETCTE |
C |
150 |
0 |
Ret da Sefaz |
@! |
|
|
R |
|
|
S |
DT6_AMBIEN |
N |
1 |
0 |
Ambiente Cte |
9 |
|
|
R |
|
|
S |
DT6_RECISS |
C |
1 |
0 |
Recolhe ISS |
@! |
Pertence('12') |
|
V |
1=Sim;2=Nao |
|
S |
DT6_NUMAGD |
C |
6 |
0 |
Agendamento |
|
|
|
R |
|
|
N |
DT6_ITEAGD |
C |
3 |
0 |
Item Agend. |
|
|
|
R |
|
|
N |
DT6_CHVCTG |
C |
44 |
0 |
Chv Conting. |
@! |
|
|
R |
|
|
S |
DT6_SERMAN |
C |
3 |
0 |
Serie Manife |
!!! |
|
|
V |
|
|
S |
DT6_NUMPER |
C |
4 |
0 |
No.Permisso |
9999 |
|
|
|
|
|
S |
DT6_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
DT6_SDOCMN |
C |
3 |
0 |
Serie Manife |
!!! |
|
|
R |
|
|
S |
DT6_SDOCOR |
C |
3 |
0 |
Ser.Doc.Orig |
!!! |
|
|
R |
|
|
S |
DT6_MODFAT |
C |
1 |
0 |
Modo Fat. |
@! |
|
|
|
|
|
S |
DT6_CLIEXP |
C |
6 |
0 |
Expedidor |
@! |
|
SA1 |
R |
|
|
S |
DT6_LOJEXP |
C |
2 |
0 |
Loja Exp. |
@! |
|
|
|
|
|
S |
DT6_NOMEXP |
C |
40 |
0 |
Nome Exp. |
@! |
|
|
V |
|
|
S |
DT6_CODNEG |
C |
2 |
0 |
Cod Negociac |
@! |
(Vazio() .Or. Existcpo("DDB")) .And. TMSA500Vld() |
DDB |
R |
|
TMSA500Whe() |
S |
DT6_DESNEG |
C |
30 |
0 |
Desc Neg Ctr |
@! |
|
|
V |
|
|
S |
DT6_IDDES |
C |
1 |
0 |
Ev. Desacord |
@! |
Pertence("0123456") |
|
R |
"0=Nao transmitido;1=Aguardando retorno SEFAZ;2=Evento vinculado com sucesso;3=Erro na transmissao" |
|
S |
DT6_ORICAL |
C |
1 |
0 |
Sel.Orig.Cal |
@! |
TmsA500Vld() |
|
R |
0=Outros;1=Filial;2=Cliente |
|
S |
DT6_DESCAL |
C |
1 |
0 |
Sel.Des.Cal |
@! |
TmsA500Vld() |
|
R |
1=Filial;2=Cliente;3=Coleta;4=Outros |
|
S |
DT6_OBSDES |
M |
80 |
0 |
Obs.Desacord |
@! |
|
|
R |
|
|
S |
DT6_SITAVB |
C |
40 |
0 |
Situ Averba |
@! |
|
|
V |
|
|
S |
DT6_SQEDES |
C |
9 |
0 |
Seq.End.Dest |
@! |
TmsA500Vld() |
DLT1 |
R |
|
TMSA500Whe() |
S |
DT6_CLIREC |
C |
6 |
0 |
Recebedor |
@! |
|
SA1 |
R |
|
|
S |
DT6_LOJREC |
C |
2 |
0 |
Loja Recebed |
@! |
|
|
R |
|
|
S |
DT6_NOMREC |
C |
60 |
0 |
Nome Receb |
@! |
|
|
V |
|
|
S |
DT6_RETIRA |
C |
1 |
0 |
Retira? |
@! |
|
|
R |
1=Sim;2=Nao |
TMSA500Whe() |
S |