Tabela |
HHA |
Tabela Fato Remito |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
HHA_LINPRO |
C |
2 |
0 |
Linha Prod |
|
|
|
|
|
|
S |
HHA_ISTCIA |
C |
2 |
0 |
Instancia |
|
|
|
|
|
|
S |
HHA_EMPRES |
C |
32 |
0 |
Empresa |
|
|
|
|
|
|
S |
HHA_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
HHA_ESTABL |
C |
32 |
0 |
Estabelecime |
|
|
|
|
|
|
S |
HHA_TABPCO |
C |
32 |
0 |
Tab Preco |
|
|
|
|
|
|
S |
HHA_CANALV |
C |
32 |
0 |
Canal Venda |
|
|
|
|
|
|
S |
HHA_ITEM |
C |
32 |
0 |
Item |
|
|
|
|
|
|
S |
HHA_FAMCOM |
C |
32 |
0 |
Familia Come |
|
|
|
|
|
|
S |
HHA_FAMMAT |
C |
32 |
0 |
Familia Mate |
|
|
|
|
|
|
S |
HHA_GRPEST |
C |
32 |
0 |
Grp Est |
|
|
|
|
|
|
S |
HHA_PRDUTO |
C |
32 |
0 |
Produto Come |
|
|
|
|
|
|
S |
HHA_REPRES |
C |
32 |
0 |
Representant |
|
|
|
|
|
|
S |
HHA_TRANSP |
C |
32 |
0 |
Transportado |
|
|
|
|
|
|
S |
HHA_ROTA |
C |
32 |
0 |
Rota |
|
|
|
|
|
|
S |
HHA_NATOPR |
C |
32 |
0 |
Naturz Op |
|
|
|
|
|
|
S |
HHA_CFOP |
C |
32 |
0 |
CFOP |
|
|
|
|
|
|
S |
HHA_REGCOM |
C |
32 |
0 |
Reg Comercia |
|
|
|
|
|
|
S |
HHA_MICREG |
C |
32 |
0 |
Microrregiao |
|
|
|
|
|
|
S |
HHA_REFER |
C |
32 |
0 |
Referencia |
|
|
|
|
|
|
S |
HHA_SERNF |
C |
8 |
0 |
Sr Nota Fisc |
|
|
|
|
|
|
S |
HHA_NUMNF |
C |
35 |
0 |
Num NF |
|
|
|
|
|
|
S |
HHA_NMITNF |
C |
10 |
0 |
Num Item |
|
|
|
|
|
|
S |
HHA_GRPCLI |
C |
32 |
0 |
Grp Cliente |
|
|
|
|
|
|
S |
HHA_CLIENT |
C |
32 |
0 |
Cliente |
|
|
|
|
|
|
S |
HHA_REGIAO |
C |
32 |
0 |
Regiao |
|
|
|
|
|
|
S |
HHA_MOEDA |
C |
32 |
0 |
Moeda |
|
|
|
|
|
|
S |
HHA_CONDPG |
C |
32 |
0 |
Cond Pagment |
|
|
|
|
|
|
S |
HHA_UNDNEG |
C |
32 |
0 |
Und Negocio |
|
|
|
|
|
|
S |
HHA_UNITEM |
C |
32 |
0 |
Und Med Item |
|
|
|
|
|
|
S |
HHA_REMITO |
C |
13 |
0 |
Num Remito |
|
|
|
|
|
|
S |
HHA_SERREM |
C |
3 |
0 |
Serie Remito |
|
|
|
|
|
|
S |
HHA_ITEREM |
C |
4 |
0 |
Item do Remi |
|
|
|
|
|
|
S |
HHA_DATA |
D |
8 |
0 |
Data Emis NF |
|
|
|
|
|
|
S |
HHA_VFATOT |
N |
16 |
2 |
Vl Tot Fat |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VCMFAT |
N |
16 |
2 |
Vl Coms Fat |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VLCSFT |
N |
16 |
2 |
Vl Custo Fat |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VLDESF |
N |
16 |
2 |
Vl Desc Fat |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VRECFI |
N |
16 |
2 |
Vl Rec Fatur |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VFRTNF |
N |
16 |
2 |
Vl Frete NF |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VDESPE |
N |
16 |
2 |
Vl Despesas |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VFATME |
N |
16 |
2 |
Vl Fat Merca |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_VFATLQ |
N |
16 |
2 |
Vl Fat Liq |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_QFATIT |
N |
16 |
4 |
Qtde Faturad |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_QFATFM |
N |
16 |
4 |
Qnt Fat Fami |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_QFATFC |
N |
16 |
4 |
Qnt Fam Come |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_QPDREM |
N |
16 |
4 |
Qtde Pedida |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_VCTCTB |
N |
16 |
2 |
Vl Custo Co |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
HHA_PEDIDO |
C |
12 |
0 |
Num Ped Vend |
|
|
|
|
|
|
S |
HHA_FGERDP |
C |
1 |
0 |
Item Gera Du |
|
|
|
|
|
|
S |
HHA_DTSANF |
D |
8 |
0 |
Dt Saida NF |
|
|
|
|
|
|
S |
HHA_QPRZDP |
N |
16 |
4 |
Qtde Prazo D |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_TPFRET |
C |
3 |
0 |
Tipo de Fret |
|
|
|
|
|
|
S |
HHA_TPNOTA |
C |
20 |
0 |
Tipo de Nota |
|
|
|
|
|
|
S |
HHA_QTPESL |
N |
16 |
4 |
Peso Liquido |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_QTPESB |
N |
16 |
4 |
Peso Bruto |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_TRARED |
C |
32 |
0 |
Transp Redes |
|
|
|
|
|
|
S |
HHA_FBXEST |
C |
1 |
0 |
Item Baixa E |
|
|
|
|
|
|
S |
HHA_TPCPIT |
C |
20 |
0 |
Tipo de Item |
|
|
|
|
|
|
S |
HHA_LIVRE0 |
N |
16 |
4 |
Livre 0 |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_LIVRE1 |
N |
16 |
4 |
Livre 1 |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_LIVRE2 |
N |
16 |
4 |
Livre 2 |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_LIVRE3 |
N |
16 |
4 |
Livre 3 |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_LIVRE4 |
N |
16 |
4 |
Livre 4 |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
HHA_LIVRE5 |
D |
8 |
0 |
Livre 5 |
|
|
|
|
|
|
S |
HHA_LIVRE6 |
D |
8 |
0 |
Livre 6 |
|
|
|
|
|
|
S |
HHA_LIVRE7 |
D |
8 |
0 |
Livre 7 |
|
|
|
|
|
|
S |
HHA_LIVRE8 |
C |
50 |
0 |
Livre 8 |
|
|
|
|
|
|
S |
HHA_LIVRE9 |
C |
50 |
0 |
Livre 9 |
|
|
|
|
|
|
S |