Tabela |
EES |
Notas Fiscais por Itens |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
EES_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
EES_PREEMB |
C |
20 |
0 |
Processo |
@! |
If(FindFunction('NF400Valid'),(EXISTCHAVE('EES') .And. NF400Valid()),EXISTCHAVE('EES')) |
|
|
|
|
N |
EES_NRNF |
C |
9 |
0 |
Nota Fiscal |
@! |
NAOVAZIO() |
|
|
|
|
N |
EES_SERIE |
C |
3 |
0 |
Serie |
!!! |
|
|
|
|
|
N |
EES_DTNF |
D |
8 |
0 |
Dt.N.F. |
@d |
|
|
|
|
|
N |
EES_VLNF |
N |
16 |
4 |
Total N.F. |
@E 99,999,999,999.9999 |
If(FindFunction('NF400Valid'),(Positivo() .And. NF400Valid()),Positivo()) |
|
|
|
|
N |
EES_VLFRET |
N |
16 |
4 |
Frete |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
N |
EES_VLSEGU |
N |
16 |
4 |
Seguro |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
N |
EES_VLMERC |
N |
16 |
4 |
V.Mercadoria |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
N |
EES_COD_I |
C |
15 |
0 |
Codigo Item |
@! |
|
SB1 |
R |
|
|
N |
EES_PEDIDO |
C |
20 |
0 |
Pedido |
@! |
If(FindFunction('NF400Valid'),NF400Valid(),.T.) |
EE7 |
|
|
|
N |
EES_SEQUEN |
C |
6 |
0 |
Sequencia |
|
If(FindFunction('NF400Valid'),NF400Valid(),.T.) |
EE8 |
|
|
|
N |
EES_VLOUTR |
N |
15 |
4 |
Vl Outros |
@E 999,999,999.99 |
POSITIVO() |
|
|
|
|
N |
EES_QTDE |
N |
15 |
3 |
Quant.Embar. |
@E 999,999,999.999 |
|
|
|
|
|
N |
EES_NR_CON |
C |
4 |
0 |
Nr.Contab. |
@! |
|
|
|
|
|
N |
EES_VLNFM |
N |
16 |
4 |
Tot.NF.Moeda |
@E 99,999,999,999.9999 |
Positivo() |
|
R |
|
|
N |
EES_VLFREM |
N |
16 |
4 |
Frete Moeda |
@E 99,999,999,999.9999 |
Positivo() |
|
R |
|
|
N |
EES_VLSEGM |
N |
16 |
4 |
Seguro Moeda |
@E 99,999,999,999.9999 |
Positivo() |
|
R |
|
|
N |
EES_VLMERM |
N |
16 |
4 |
V.Merc.Moeda |
@E 99,999,999,999.9999 |
Positivo() |
|
R |
|
|
N |
EES_VLOUTM |
N |
16 |
4 |
Out.Vl.Moeda |
@E 99,999,999,999.9999 |
Positivo() |
|
R |
|
|
N |
EES_CNPJ |
C |
14 |
0 |
CNPJ/CPF |
@R 99.999.999/9999-99 |
Cgc(M->EEM_CNPJ) |
|
R |
|
|
S |
EES_QTDDEV |
N |
11 |
2 |
Qtde. Dev. |
@E 99,999,999.99 |
|
|
R |
|
|
N |
EES_FATSEQ |
C |
4 |
0 |
Seq.It.NF.Fa |
@! |
|
|
R |
|
|
N |
EES_VALDEV |
N |
14 |
2 |
Valor Dev. |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
EES_DESCON |
N |
16 |
4 |
Vl.Desconto |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
EES_CCERP |
C |
8 |
0 |
C. Custo |
@! |
|
|
|
|
|
S |
EES_QTDORI |
N |
15 |
3 |
Qtde. Orig. |
@E 99,999,999,999.999 |
|
|
R |
|
|
S |
EES_RELACA |
C |
15 |
0 |
Nr.Relacao |
|
|
|
R |
|
|
S |
EES_PEDERP |
C |
20 |
0 |
Pedido ERP |
@! |
|
|
R |
|
|
S |
EES_LANCAM |
C |
3 |
0 |
Lancamento |
@! |
|
|
R |
|
|
S |
EES_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |