Tabela |
EEM |
Controle de Notas Fiscais |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
EEM_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
EEM_PREEMB |
C |
20 |
0 |
Embarque |
@! |
|
|
|
|
|
N |
EEM_TIPOCA |
C |
1 |
0 |
Tipo Cadastr |
@! |
|
|
|
|
|
N |
EEM_NRNF |
C |
9 |
0 |
Nota Fiscal |
@! |
If(FindFunction('NF400Valid'),NF400Valid(),NaoVazio()) |
|
|
|
AE101WHEN('EEM_NRNF') |
N |
EEM_SERIE |
C |
3 |
0 |
Serie |
!!! |
|
|
|
|
AE101WHEN('EEM_SERIE') |
N |
EEM_DTNF |
D |
8 |
0 |
Data da N.F. |
|
NaoVazio() |
|
|
|
AE101WHEN('EEM_DTNF') |
N |
EEM_TIPONF |
C |
1 |
0 |
Tipo de NF |
@! |
Pertence('12345') .And. If(FindFunction('NF400Valid'),NF400Valid(),.T.) |
|
|
1=Saida;2=Complementar;3=Credito;4=Despesa;5=Devolucao |
|
N |
EEM_VLNF |
N |
16 |
4 |
Valor de NF |
@E 99,999,999,999.9999 |
If(FindFunction('NF400Valid'),NF400Valid(),NaoVazio()) |
|
|
|
|
N |
EEM_VLMERC |
N |
16 |
4 |
Vl.Mercad. |
@E 99,999,999,999.9999 |
NaoVazio() |
|
|
|
|
N |
EEM_VLFRET |
N |
16 |
4 |
Vl.Frete |
@E 99,999,999,999.9999 |
|
|
|
|
|
N |
EEM_VLSEGU |
N |
16 |
4 |
Vl.Seguro |
@E 99,999,999,999.9999 |
|
|
|
|
|
N |
EEM_OUTROS |
N |
16 |
4 |
Outros |
@E 99,999,999,999.9999 |
|
|
|
|
|
N |
EEM_TXTB |
N |
15 |
7 |
Tx.Emis.N.F. |
@E 9,999,999.9999999 |
POSITIVO() |
|
|
|
|
N |
EEM_RIEXST |
C |
1 |
0 |
Status RIEX |
@! |
|
|
R |
A=Aceito;R=Rejeitado;E=Enviado |
|
N |
EEM_VLNFM |
N |
16 |
4 |
Vl.NF Moeda |
@E 99,999,999,999.9999 |
|
|
R |
|
|
N |
EEM_VLMERM |
N |
16 |
4 |
Vl.Mer.Moeda |
@E 99,999,999,999.9999 |
|
|
R |
|
|
N |
EEM_VLFREM |
N |
16 |
4 |
Vl.Fr. Moeda |
@E 99,999,999,999.9999 |
|
|
R |
|
|
N |
EEM_VLSEGM |
N |
16 |
4 |
Vl.Seg.Moeda |
@E 99,999,999,999.9999 |
|
|
R |
|
|
N |
EEM_OUTROM |
N |
16 |
4 |
Out.Vl.Moeda |
@E 99,999,999,999.9999 |
|
|
R |
|
|
N |
EEM_TXFRET |
N |
15 |
7 |
Taxa Frete |
@E 9,999,999.9999999 |
|
|
R |
|
|
N |
EEM_TXSEGU |
N |
15 |
7 |
Taxa Seguro |
@E 9,999,999.9999999 |
|
|
R |
|
|
N |
EEM_TXOUDE |
N |
15 |
7 |
Taxa O.Despe |
@E 9,999,999.9999999 |
|
|
R |
|
|
N |
EEM_CF |
C |
5 |
0 |
Cod.Fiscal |
@! |
|
|
R |
|
|
N |
EEM_MODNF |
C |
2 |
0 |
Modelo NF |
@! |
|
YM |
R |
|
|
S |
EEM_CNPJ |
C |
14 |
0 |
CNPJ/CPF |
@R 99.999.999/9999-99 |
If(FindFunction('NF400Valid'),NF400Valid(),Cgc(M->EEM_CNPJ)) |
|
R |
|
|
S |
EEM_RELACA |
C |
15 |
0 |
Nr.Relacao |
@! |
|
|
R |
|
|
S |
EEM_LANCAM |
C |
3 |
0 |
Lancamento |
@! |
|
|
R |
|
|
S |
EEM_DESCON |
N |
16 |
4 |
Vl.Desconto |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
EEM_NFCS |
C |
50 |
0 |
NF Comp. |
@! |
|
|
R |
|
|
S |
EEM_SDOC |
C |
3 |
0 |
Serie Doc |
!!! |
|
|
R |
|
|
S |
EEM_CHVNFE |
C |
44 |
0 |
Chave NFe |
@! |
|
|
R |
|
|
S |