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