Tabela |
HL4 |
Tabela Fato de Vendas |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
HL4_LINPRO |
C |
2 |
0 |
Linh Produto |
@! |
|
|
R |
|
|
S |
HL4_ISTCIA |
C |
2 |
0 |
Instancia |
@! |
|
|
R |
|
|
S |
HL4_EMPRES |
C |
32 |
0 |
Empresa |
@! |
|
|
R |
|
|
S |
HL4_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
HL4_ESTABL |
C |
32 |
0 |
Estabelecim. |
@! |
|
|
R |
|
|
S |
HL4_TRANSP |
C |
32 |
0 |
Transportad. |
@! |
|
|
R |
|
|
S |
HL4_REPRES |
C |
32 |
0 |
Representant |
@! |
|
|
R |
|
|
S |
HL4_NATOPR |
C |
32 |
0 |
Natur Operac |
@! |
|
|
R |
|
|
S |
HL4_CFOP |
C |
32 |
0 |
CFOP |
@! |
|
|
R |
|
|
S |
HL4_ITEM |
C |
32 |
0 |
Item |
@! |
|
|
R |
|
|
S |
HL4_FAMCOM |
C |
32 |
0 |
Famil Comerc |
@! |
|
|
R |
|
|
S |
HL4_FAMMAT |
C |
32 |
0 |
Famil. Mat. |
@! |
|
|
R |
|
|
S |
HL4_GRPEST |
C |
32 |
0 |
Grp Estoque |
@! |
|
|
R |
|
|
S |
HL4_PRDUTO |
C |
32 |
0 |
Produto Com. |
@! |
|
|
R |
|
|
S |
HL4_CONDPG |
C |
32 |
0 |
Condcao Pgto |
@! |
|
|
R |
|
|
S |
HL4_PEDIDO |
C |
12 |
0 |
Nro. Pedido |
|
|
|
R |
|
|
S |
HL4_GRPCLI |
C |
32 |
0 |
Grp Cliente |
@! |
|
|
R |
|
|
S |
HL4_CLIENT |
C |
32 |
0 |
Cliente |
@! |
|
|
R |
|
|
S |
HL4_REGIAO |
C |
32 |
0 |
Regiao Geogr |
@! |
|
|
R |
|
|
S |
HL4_MOEDA |
C |
32 |
0 |
Moeda |
@! |
|
|
R |
|
|
S |
HL4_STCRED |
C |
32 |
0 |
Sitcao Crdto |
@! |
|
|
R |
|
|
S |
HL4_UNDNEG |
C |
32 |
0 |
Unidad Negoc |
@! |
|
|
R |
|
|
S |
HL4_DATA |
D |
8 |
0 |
Data Venda |
|
|
|
R |
|
|
S |
HL4_DTENTR |
D |
8 |
0 |
Data Entrega |
|
|
|
R |
|
|
S |
HL4_DTIMPL |
D |
8 |
0 |
Dt Implantac |
|
|
|
|
|
|
S |
HL4_VVENDA |
N |
16 |
2 |
Vl Venda Tot |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
HL4_QVENDA |
N |
16 |
4 |
Qtde Vendida |
@E 99,999,999,999.9999 |
|
|
R |
|
|
S |
HL4_VIMPVD |
N |
16 |
2 |
Vl Impostos |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
HL4_VVMERC |
N |
16 |
2 |
Vl Vnd Merc |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
HL4_VVNDLQ |
N |
16 |
2 |
Vl Venda Liq |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
HL4_QVENFC |
N |
16 |
4 |
Qtde. Vend. |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HL4_QVENFM |
N |
16 |
4 |
Qtde. Vend. |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HL4_CANALV |
C |
32 |
0 |
Canal de Ven |
@! |
|
|
|
|
|
S |
HL4_REGCOM |
C |
32 |
0 |
Regiao Com |
@! |
|
|
|
|
|
S |
HL4_MICREG |
C |
32 |
0 |
Microrregiao |
@! |
|
|
|
|
|
S |
HL4_ROTA |
C |
32 |
0 |
Rota |
@! |
|
|
|
|
|
S |
HL4_TABPCO |
C |
32 |
0 |
Tab.de Preco |
@! |
|
|
|
|
|
S |
HL4_REFER |
C |
32 |
0 |
Referencia |
@! |
|
|
|
|
|
S |
HL4_NMITVD |
C |
10 |
0 |
Num do Item |
@! |
|
|
|
|
|
S |
HL4_VLDESV |
N |
16 |
2 |
Vl Des Venda |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HL4_NMPRIO |
N |
4 |
0 |
Priorida Ped |
@E 9,999 |
|
|
|
|
|
S |
HL4_TRARED |
C |
32 |
0 |
Transp Redes |
@! |
|
|
|
|
|
S |
HL4_STPEDV |
C |
20 |
0 |
Situa Cred |
@! |
|
|
|
|
|
S |
HL4_STITPV |
C |
20 |
0 |
Sit Item Ped |
@! |
|
|
|
|
|
S |
HL4_TPCPIT |
C |
20 |
0 |
Tipo de Item |
@! |
|
|
|
|
|
S |
HL4_LIVRE0 |
N |
16 |
4 |
Livre 0 |
|
|
|
|
|
|
S |
HL4_LIVRE1 |
N |
16 |
4 |
Livre 1 |
|
|
|
|
|
|
S |
HL4_LIVRE2 |
N |
16 |
4 |
Livre 2 |
|
|
|
|
|
|
S |
HL4_LIVRE3 |
N |
16 |
4 |
Livre 3 |
|
|
|
|
|
|
S |
HL4_LIVRE4 |
N |
16 |
4 |
Livre 4 |
|
|
|
|
|
|
S |
HL4_LIVRE5 |
D |
8 |
0 |
Livre 5 |
|
|
|
|
|
|
S |
HL4_LIVRE6 |
D |
8 |
0 |
Livre 6 |
|
|
|
|
|
|
S |
HL4_LIVRE7 |
D |
8 |
0 |
Livre 7 |
|
|
|
|
|
|
S |
HL4_LIVRE8 |
C |
50 |
0 |
Livre 8 |
|
|
|
|
|
|
S |
HL4_LIVRE9 |
C |
50 |
0 |
Livre 9 |
|
|
|
|
|
|
S |
HL4_UNITEM |
C |
32 |
0 |
Und Med Item |
|
|
|
|
|
|
S |
HL4_VIPNIN |
N |
16 |
2 |
Vl Imp n Inc |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |