Tabela |
DE5 |
EDI - Notas Fiscais |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
DE5_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
DE5_CGCREM |
C |
14 |
0 |
CNPJ Remet. |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55VLD() |
DE5 |
|
|
TMSAE55Whe() |
S |
DE5_NOMREM |
C |
20 |
0 |
Nome Remet. |
@! |
|
|
V |
|
|
S |
DE5_DTAEMB |
D |
8 |
0 |
DT Embarque |
|
|
|
|
|
|
S |
DE5_CGCDES |
C |
14 |
0 |
CNPJ Dest |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55VLD() |
DE5 |
|
|
TMSAE55Whe() |
S |
DE5_NOMDES |
C |
20 |
0 |
Nome Dest. |
@! |
|
|
V |
|
|
S |
DE5_SQIDES |
C |
2 |
0 |
Seq.Ins.Dest |
@! |
|
|
|
|
|
S |
DE5_INSDES |
C |
15 |
0 |
Insc.Dest |
@! |
|
|
V |
|
|
S |
DE5_CGCCON |
C |
14 |
0 |
CNPJ Consig. |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55VLD() |
DE5 |
|
|
|
S |
DE5_NOMCON |
C |
20 |
0 |
Nome Consig. |
@! |
|
|
V |
|
|
S |
DE5_CGCDPC |
C |
14 |
0 |
CNPJ Despach |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55VLD() |
DE5 |
|
|
|
S |
DE5_NOMDPC |
C |
20 |
0 |
Nome Despach |
@! |
|
|
V |
|
|
S |
DE5_CGCDEV |
C |
14 |
0 |
CNPJ Devedor |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55VLD() |
DE5 |
|
|
TMSAE55Whe() |
S |
DE5_NOMDEV |
C |
20 |
0 |
Nome Devedor |
@! |
|
|
V |
|
|
S |
DE5_TIPTRA |
C |
1 |
0 |
Tipo Transp. |
@! |
TMSValField("M->DE5_TIPTRA",.T.,"DE5_DESTPT") |
DLC |
|
|
TMSAE55Whe() |
S |
DE5_DESTPT |
C |
30 |
0 |
Desc.Tp.Tran |
@! |
|
|
V |
|
|
N |
DE5_TIPFRE |
C |
1 |
0 |
Tipo Frete |
@! |
Pertence("12") |
|
|
1=CIF;2=FOB |
TMSAE55Whe() |
S |
DE5_DOC |
C |
9 |
0 |
No Docto |
@! |
TMSAE55VLD() |
|
|
|
|
S |
DE5_SERIE |
C |
3 |
0 |
Serie Docto |
@! |
TMSAE55VLD() |
|
|
|
|
S |
DE5_EMINFC |
D |
8 |
0 |
DT Emissao |
|
|
|
|
|
|
S |
DE5_CODPRO |
C |
15 |
0 |
Cod. Produto |
@! |
TMSAE55VLD() |
DE6 |
|
|
TMSAE55Whe() |
S |
DE5_DESPRO |
C |
30 |
0 |
Desc.Produto |
@! |
|
|
V |
|
|
S |
DE5_CODEMB |
C |
3 |
0 |
Embalagem |
@! |
ExistCpo("SX5","MG"+M->DE5_CODEMB) |
MG |
|
|
|
S |
DE5_QTDVOL |
N |
5 |
0 |
Qtd. Volumes |
99999 |
Positivo() |
|
|
|
|
S |
DE5_VALOR |
N |
14 |
2 |
Valor |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
S |
DE5_PESO |
N |
11 |
4 |
Peso |
@E 999,999.9999 |
|
|
|
|
|
S |
DE5_PESOM3 |
N |
11 |
4 |
Peso Cubado |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
DE5_VALSEG |
N |
14 |
2 |
Valor Seguro |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
S |
DE5_FILDPC |
C |
2 |
0 |
Filial Desp. |
|
|
DVL |
|
|
|
S |
DE5_CTRDPC |
C |
10 |
0 |
CTRC Desp. |
@! |
|
|
|
|
|
S |
DE5_STATUS |
C |
1 |
0 |
Status |
@! |
Pertence("12") |
|
|
1=Em aberto;2=Encerrado |
|
S |
DE5_METRO3 |
N |
11 |
4 |
M3 |
@E 999,999.9999 |
Positivo() |
|
R |
|
|
S |
DE5_BASEIC |
N |
14 |
2 |
Base p/ ICMS |
@E 99,999,999,999.99 |
MaFisRef("DE5_BASEIC","MT100",M->DE5_BASEIC) |
|
R |
|
|
S |
DE5_VALICM |
N |
14 |
2 |
Vlr ICMS |
@E 99,999,999,999.99 |
MaFisRef("DE5_VALICM","MT100",M->DE5_VALICM) |
|
R |
|
|
S |
DE5_BASIST |
N |
14 |
2 |
Base ST Tran |
@E 99,999,999,999.99 |
Positivo() .And. MaFisRef("DE5_BASIST","MT100",M->DE5_BASIST) |
|
|
|
|
S |
DE5_VALIST |
N |
14 |
2 |
Val. ST Tran |
@E 99,999,999,999.99 |
Positivo() .And. MaFisRef("DE5_VALIST","MT100",M->DE5_VALIST) |
|
R |
|
|
S |
DE5_CFOPNF |
C |
5 |
0 |
Cod. Fiscal |
@! |
NaoVazio().and.AvalCfo("DE5",M->DE5_CFOPNF) |
13 |
R |
|
|
S |
DE5_NFEID |
C |
44 |
0 |
Chave NF-e |
@! |
|
|
R |
|
|
S |
DE5_LOTEDI |
C |
9 |
0 |
Lote EDI |
@! |
TMSAE55VLD() |
DET |
R |
|
|
N |
DE5_STAUTO |
C |
1 |
0 |
Sta EDI Aut |
@! |
Pertence("012") |
|
R |
0=Nao Executado;1=Exec. com Sucesso;2=Exec. com Erro |
|
N |
DE5_SERVIC |
C |
3 |
0 |
Servico |
@! |
ExistCpo("DC5") |
DC5 |
R |
|
TMSAE55Whe() |
N |
DE5_SERTMS |
C |
1 |
0 |
Serv.Transp. |
@! |
TMSValField("M->DE5_SERTMS",.T.,"DE5_DESSVT") |
DLC |
R |
|
TMSAE55Whe() |
N |
DE5_DESSVT |
C |
30 |
0 |
Desc.Sv.Tran |
@! |
|
|
V |
|
|
N |
DE5_SELORI |
C |
1 |
0 |
Selec.Regiao |
@! |
Pertence("123") |
|
R |
1=Transportadora;2=Cliente Remetente;3=Local Coleta |
|
S |
DE5_OBSAUT |
M |
10 |
0 |
Obs. EDI Aut |
@! |
|
|
R |
|
|
N |
DE5_EDIAUT |
C |
1 |
0 |
EDI Automat. |
@! |
|
|
R |
0=Nao utiliza;1=Lote s/ calculo;2=Lote c/ calculo |
|
N |
DE5_EDILOT |
C |
1 |
0 |
Lote EDI Aut |
@! |
|
|
R |
0=Nao Utiliza;1=Por processamento;2=Por destinatario |
|
N |
DE5_EDIFRT |
C |
1 |
0 |
Frt. EDI Aut |
@! |
|
|
R |
0=Nao Utiliza;1=Assume Frete;2=Somente Informativo |
|
N |
DE5_FILORI |
C |
2 |
0 |
Fil.Origem |
|
|
|
R |
|
|
N |
DE5_LOTNFC |
C |
6 |
0 |
No.Lote |
@! |
|
|
R |
|
|
N |
DE5_SEQEND |
C |
9 |
0 |
Seq.Endereco |
@! |
|
DLT |
R |
|
|
S |
DE5_OLDSEQ |
C |
2 |
0 |
Old.Seq.End. |
@! |
|
|
R |
|
|
S |
DE5_EMINFE |
D |
8 |
0 |
Emissao NF-e |
|
|
|
R |
|
|
S |
DE5_CODNFE |
C |
8 |
0 |
Cd.Ver.NF-e |
@! |
|
|
R |
|
|
S |
DE5_NFELET |
C |
8 |
0 |
NF-e |
@! |
|
|
R |
|
|
S |
DE5_TIPAGD |
C |
1 |
0 |
Tipo Agend. |
|
|
|
R |
0=Prioridade Cliente;1=Prioridade Transportador;2=Cliente;3=Transportador;4=Aguardando Agendamento |
|
S |
DE5_DATAGD |
D |
8 |
0 |
Data Agend. |
|
TMSAE55Vld() |
|
R |
|
|
S |
DE5_CODNEG |
C |
2 |
0 |
Cod Negociac |
@! |
(Vazio() .Or. Existcpo("DDB")) .And. TMSAE55Vld() |
DDB |
R |
|
TMSAE55Whe() |
S |
DE5_PRDAGD |
C |
1 |
0 |
Periodo |
|
TMSAE55Vld() |
|
R |
1=A partir de;2=Ate;3=De / Ate;4=Na hora |
TMSAE55Whe("M->DE5_PRDAGD") |
S |
DE5_DESNEG |
C |
30 |
0 |
Desc Neg Ctr |
@! |
|
|
V |
|
|
S |
DE5_INIAGD |
C |
4 |
0 |
Hr.Ini.Agend |
@R 99:99 |
ATVLDHORA(M->DE5_INIAGD) .And. TMSAE55Vld() |
|
R |
|
TMSAE55Whe("M->DE5_INIAGD") |
S |
DE5_FIMAGD |
C |
4 |
0 |
Hr.Fim Agend |
@R 99:99 |
ATVLDHORA(M->DE5_FIMAGD) .And. TMSAE55Vld() |
|
R |
|
TMSAE55Whe("M->DE5_FIMAGD") |
S |
DE5_MOTAGD |
M |
10 |
0 |
Motivo Agend |
|
|
|
R |
|
|
S |
DE5_INSCRE |
C |
19 |
0 |
Ins.Rem |
@! |
|
|
R |
|
|
S |
DE5_INSDEV |
C |
18 |
0 |
Insc.Dev |
@! |
|
|
R |
|
|
S |
DE5_CGCEXP |
C |
14 |
0 |
Cnpj Expedid |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55VLD() |
|
R |
|
TMSAE55Whe() |
S |
DE5_PESLIQ |
N |
11 |
4 |
Peso Liquido |
@E 999,999.9999 |
|
|
|
|
|
S |
DE5_NOMEXP |
C |
60 |
0 |
Nome Expedid |
@! |
|
|
V |
|
|
S |
DE5_CGCREC |
C |
14 |
0 |
CNPJ Receb. |
@R 99.999.999/9999-99 |
Vazio() .Or. TMSAE55Vld() |
|
R |
|
TMSAE55WHE() |
S |
DE5_NOMREC |
C |
60 |
0 |
Nome Receb. |
@! |
|
|
V |
|
|
S |