Tabela | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
SJ3 | Acumulados Mensais | ||||||||||
Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
J3_PRODUTO | C | 15 | 0 | Produto | @! | existcpo("SB1") | S | ||||
J3_REGVEND | C | 3 | 0 | Regiao | @! | S | |||||
J3_ANO | C | 4 | 0 | Ano | @! | S | |||||
J3_FATVEN | C | 1 | 0 | Fat/Vendas | @! | pertence("FV") .AND. EXISTCHAV("SJ3",M->J3_PRODUTO+M->J3_ANO+M->J3_REGVEND+M->J3_FATVEN) | F=Faturamento;V=Pedido | S | |||
J3_VALR01 | N | 16 | 2 | Val Real JAN | @E 999,999,999,999.99 | S | |||||
J3_VALR02 | N | 16 | 2 | Val Real FEV | @E 999,999,999,999.99 | S | |||||
J3_VALR03 | N | 16 | 2 | Val Real MAR | @E 999,999,999,999.99 | S | |||||
J3_VALR04 | N | 16 | 2 | Val Real ABR | @E 999,999,999,999.99 | S | |||||
J3_VALR05 | N | 16 | 2 | Val Real MAI | @E 999,999,999,999.99 | S | |||||
J3_VALR06 | N | 16 | 2 | Val Real JUN | @E 999,999,999,999.99 | S | |||||
J3_VALR07 | N | 16 | 2 | Val Real JUL | @E 999,999,999,999.99 | S | |||||
J3_VALR08 | N | 16 | 2 | Val Real AGO | @E 999,999,999,999.99 | S | |||||
J3_VALR09 | N | 16 | 2 | Val Real SET | @E 999,999,999,999.99 | S | |||||
J3_VALR10 | N | 16 | 2 | Val Real OUT | @E 999,999,999,999.99 | S | |||||
J3_VALR11 | N | 16 | 2 | Val Real NOV | @E 999,999,999,999.99 | S | |||||
J3_VALR12 | N | 16 | 2 | Val Real DEZ | @E 999,999,999,999.99 | S | |||||
J3_QUAR01 | N | 16 | 2 | Qtd.Real JAN | @E 999,999,999,999.99 | S | |||||
J3_QUAR02 | N | 16 | 2 | Qtd.Real FEV | @E 999,999,999,999.99 | S | |||||
J3_QUAR03 | N | 16 | 2 | Qtd.Real MAR | @E 999,999,999,999.99 | S | |||||
J3_QUAR04 | N | 16 | 2 | Qtd.Real ABR | @E 999,999,999,999.99 | S | |||||
J3_QUAR05 | N | 16 | 2 | Qtd.Real MAI | @E 999,999,999,999.99 | S | |||||
J3_QUAR06 | N | 16 | 2 | Qtd.Real JUN | @E 999,999,999,999.99 | S | |||||
J3_QUAR07 | N | 16 | 2 | Qtd.Real JUL | @E 999,999,999,999.99 | S | |||||
J3_QUAR08 | N | 16 | 2 | Qtd.Real AGO | @E 999,999,999,999.99 | S | |||||
J3_QUAR09 | N | 16 | 2 | Qtd.Real SET | @E 999,999,999,999.99 | S | |||||
J3_QUAR10 | N | 16 | 2 | Qtd.Real OUT | @E 999,999,999,999.99 | S | |||||
J3_QUAR11 | N | 16 | 2 | Qtd.Real NOV | @E 999,999,999,999.99 | S | |||||
J3_QUAR12 | N | 16 | 2 | Qtd.Real DEZ | @E 999,999,999,999.99 | S | |||||
J3_VALO01 | N | 16 | 2 | Val Orc. JAN | @E 999,999,999,999.99 | S | |||||
J3_VALO02 | N | 16 | 2 | Val Orc. FEV | @E 999,999,999,999.99 | S | |||||
J3_VALO03 | N | 16 | 2 | Val Orc. MAR | @E 999,999,999,999.99 | S | |||||
J3_VALO04 | N | 16 | 2 | Val Orc. ABR | @E 999,999,999,999.99 | S | |||||
J3_VALO05 | N | 16 | 2 | Val Orc. MAI | @E 999,999,999,999.99 | S | |||||
J3_VALO06 | N | 16 | 2 | Val Orc. JUN | @E 999,999,999,999.99 | S | |||||
J3_VALO07 | N | 16 | 2 | Val Orc. JUL | @E 999,999,999,999.99 | S | |||||
J3_VALO08 | N | 16 | 2 | Val Orc. AGO | @E 999,999,999,999.99 | S | |||||
J3_VALO09 | N | 16 | 2 | Val Orc. SET | @E 999,999,999,999.99 | S | |||||
J3_VALO10 | N | 16 | 2 | Val Orc. OUT | @E 999,999,999,999.99 | S | |||||
J3_VALO11 | N | 16 | 2 | Val Orc. NOV | @E 999,999,999,999.99 | S | |||||
J3_VALO12 | N | 16 | 2 | Val Orc. DEZ | @E 999,999,999,999.99 | S | |||||
J3_QUAO01 | N | 16 | 2 | Qtd.Orc. JAN | @E 999,999,999,999.99 | S | |||||
J3_QUAO02 | N | 16 | 2 | Qtd.Orc. FEV | @E 999,999,999,999.99 | S | |||||
J3_QUAO03 | N | 16 | 2 | Qtd.Orc. MAR | @E 999,999,999,999.99 | S | |||||
J3_QUAO04 | N | 16 | 2 | Qtd.Orc. ABR | @E 999,999,999,999.99 | S | |||||
J3_QUAO05 | N | 16 | 2 | Qtd.Orc. MAI | @E 999,999,999,999.99 | S | |||||
J3_QUAO06 | N | 16 | 2 | Qtd.Orc. JUN | @E 999,999,999,999.99 | S | |||||
J3_QUAO07 | N | 16 | 2 | Qtd.Orc. JUL | @E 999,999,999,999.99 | S | |||||
J3_QUAO08 | N | 16 | 2 | Qtd.Orc. AGO | @E 999,999,999,999.99 | S | |||||
J3_QUAO09 | N | 16 | 2 | Qtd.Orc. SET | @E 999,999,999,999.99 | S | |||||
J3_QUAO10 | N | 16 | 2 | Qtd.Orc. OUT | @E 999,999,999,999.99 | S | |||||
J3_QUAO11 | N | 16 | 2 | Qtd.Orc. NOV | @E 999,999,999,999.99 | S | |||||
J3_QUAO12 | N | 16 | 2 | Qtd.Orc. DEZ | @E 999,999,999,999.99 | S | |||||
J3_FILIAL | C | 2 | 0 | Filial | S | ||||||
J3_CLIENTE | C | 6 | 0 | Cliente | @! | SA1 | S | ||||
J3_LOJA | C | 2 | 0 | Loja | @! | SA1 | S |