| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SB2 | Saldos Fisico e Financeiro | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| B2_FILIAL | C | 2 | 0 | Filial | S | ||||||
| B2_COD | C | 15 | 0 | Produto | @! | ExistCpo("SB1") .And. A225Desc() .And. A225IniCpo() | SB1 | S | |||
| B2_QFIM | N | 12 | 2 | Qtd. Fim Mes | @E 999,999,999.99 | S | |||||
| B2_LOCAL | C | 2 | 0 | Armazem | @! | ExistCpo("NNR") .And. existchav("SB2",m->b2_cod+m->b2_local) | NNR | S | |||
| B2_DPROD | C | 30 | 0 | Descricao | @! | V | S | ||||
| B2_QATU | N | 14 | 2 | Saldo Atual | @E 99,999,999,999.99 | S | |||||
| B2_VFIM1 | N | 14 | 2 | Vlr.Final | @E 99,999,999,999.99 | S | |||||
| B2_VATU1 | N | 14 | 2 | Sld.Atu. | @E 99,999,999,999.99 | S | |||||
| B2_CM1 | N | 14 | 4 | C Unitario | @E 999,999,999.9999 | IsProdMod(M->B2_COD) | S | ||||
| B2_VFIM2 | N | 14 | 2 | Vlr.Fin.2a M | @E 99,999,999,999.99 | S | |||||
| B2_VATU2 | N | 14 | 2 | Sld.Atu.2a M | @E 99,999,999,999.99 | S | |||||
| B2_CM2 | N | 14 | 4 | Cus.Uni.2a M | @E 999,999,999.9999 | IsProdMod(M->B2_COD) | S | ||||
| B2_VFIM3 | N | 14 | 2 | Vlr.Fin.3a M | @E 99,999,999,999.99 | S | |||||
| B2_VATU3 | N | 14 | 2 | Sld.Atu.3a M | @E 99,999,999,999.99 | S | |||||
| B2_CM3 | N | 14 | 4 | Cus.Uni.3a M | @E 999,999,999.9999 | IsProdMod(M->B2_COD) | S | ||||
| B2_VFIM4 | N | 14 | 2 | Vlr.Fin.4a M | @E 99,999,999,999.99 | S | |||||
| B2_VATU4 | N | 14 | 2 | Sld.Atu.4a M | @E 99,999,999,999.99 | S | |||||
| B2_CM4 | N | 14 | 4 | Cus.Uni.4a M | @E 999,999,999.9999 | IsProdMod(M->B2_COD) | S | ||||
| B2_VFIM5 | N | 14 | 2 | Vlr.Fin.5a M | @E 99,999,999,999.99 | S | |||||
| B2_VATU5 | N | 14 | 2 | Sld.Atu.5a M | @E 99,999,999,999.99 | S | |||||
| B2_CM5 | N | 14 | 4 | Cus.Uni.5a M | @E 999,999,999.9999 | IsProdMod(M->B2_COD) | S | ||||
| B2_QEMP | N | 14 | 4 | Empenho | @E 999,999,999.9999 | S | |||||
| B2_QEMPN | N | 12 | 2 | Qtd. Emp. NF | @E 999,999,999.99 | S | |||||
| B2_QTSEGUM | N | 14 | 2 | Qtd. 2a UM | @E 99,999,999,999.99 | S | |||||
| B2_USAI | D | 8 | 0 | DT.Ult.Saida | S | ||||||
| B2_RESERVA | N | 12 | 2 | Qtd. Reserva | @E 999,999,999.99 | S | |||||
| B2_QPEDVEN | N | 12 | 2 | Qtd.Ped.Vend | @E 999,999,999.99 | S | |||||
| B2_LOCALIZ | C | 15 | 0 | Endereco | @! | S | |||||
| B2_NAOCLAS | N | 12 | 2 | Qtd.N.Endere | @E 999,999,999.99 | S | |||||
| B2_SALPEDI | N | 14 | 4 | Qtd.Prevista | @E 999,999,999.9999 | S | |||||
| B2_DINVENT | D | 8 | 0 | Dt.Invent. | S | ||||||
| B2_DINVFIM | D | 8 | 0 | Dt.Blq.Inv.F | S | ||||||
| B2_QTNP | N | 12 | 2 | Qt.Ter.Ns.Pd | @E 999,999,999.99 | S | |||||
| B2_QNPT | N | 12 | 2 | Qt.Ns.Pd.Ter | @E 999,999,999.99 | S | |||||
| B2_QTER | N | 12 | 2 | Saldo Pod.3 | @E 999,999,999.99 | S | |||||
| B2_QFIM2 | N | 12 | 2 | Qt.Fim Mes 2 | @E 999,999,999.99 | S | |||||
| B2_QACLASS | N | 12 | 2 | Qtd.a Endere | @E 999,999,999.99 | S | |||||
| B2_DTINV | D | 8 | 0 | Dt.Blq.Inv.I | S | ||||||
| B2_CMFF1 | N | 14 | 4 | C Unit.FIFO1 | @E 999,999,999.9999 | S | |||||
| B2_CMFF2 | N | 14 | 4 | C Unit.FIFO2 | @E 999,999,999.9999 | S | |||||
| B2_CMFF3 | N | 14 | 4 | C Unit.FIFO3 | @E 999,999,999.9999 | S | |||||
| B2_CMFF4 | N | 14 | 4 | C Unit.FIFO4 | @E 999,999,999.9999 | S | |||||
| B2_CMFF5 | N | 14 | 4 | C Unit.FIFO5 | @E 999,999,999.9999 | S | |||||
| B2_VFIMFF1 | N | 14 | 2 | Vl.Fin.FIFO1 | @E 99,999,999,999.99 | S | |||||
| B2_VFIMFF2 | N | 14 | 2 | Vl.Fin.FIFO2 | @E 99,999,999,999.99 | S | |||||
| B2_VFIMFF3 | N | 14 | 2 | Vl.Fin.FIFO3 | @E 99,999,999,999.99 | S | |||||
| B2_VFIMFF4 | N | 14 | 2 | Vl.Fin.FIFO4 | @E 99,999,999,999.99 | S | |||||
| B2_VFIMFF5 | N | 14 | 2 | Vl.Fin.FIFO5 | @E 99,999,999,999.99 | S | |||||
| B2_QEMPSA | N | 12 | 2 | Qtd. Emp. SA | @E 999,999,999.99 | S | |||||
| B2_QEMPPRE | N | 14 | 4 | Empen. Previ | @E 999,999,999.9999 | S | |||||
| B2_SALPPRE | N | 14 | 4 | Qtd.Prev. OP | @E 999,999,999.9999 | S | |||||
| B2_QEMP2 | N | 14 | 4 | Empenho 2UM | @E 999,999,999.9999 | S | |||||
| B2_QEMPN2 | N | 12 | 2 | Qtd.Emp.NF 2 | @E 999,999,999.99 | S | |||||
| B2_RESERV2 | N | 12 | 2 | Reserva 2aUM | @E 999,999,999.99 | S | |||||
| B2_QPEDVE2 | N | 12 | 2 | Qt.Pd.Ve.2UM | @E 999,999,999.99 | S | |||||
| B2_QEPRE2 | N | 14 | 4 | Emp.Prev.2UM | @E 999,999,999.9999 | S | |||||
| B2_QFIMFF | N | 12 | 2 | Qtd. Fim Mes | @E 999,999,999.99 | S | |||||
| B2_SALPED2 | N | 14 | 4 | Qtd.Prev.2UM | @E 999,999,999.9999 | S | |||||
| B2_QEMPPRJ | N | 12 | 2 | Qtd.Emp.Prj. | @E 999,999,999.99 | S | |||||
| B2_CODGRP | C | 4 | 0 | Grupo | @!!!! | VldAuxCod1("B2_CODGRP","B2_CODITE") | SBM | V | Inclui | S | |
| B2_CODITE | C | 27 | 0 | Cod. Produto | VldAuxCod2("B2_COD","B2_CODGRP") | B00 | V | Inclui | S | ||
| B2_QEMPPR2 | N | 12 | 2 | Qt Emp Prj 2 | @E 999,999,999.99 | S | |||||
| B2_STATUS | C | 1 | 0 | Status Sld | 9 | pertence(" 12") | 1=Disponivel;2=Indisponivel | S | |||
| B2_CMFIM1 | N | 14 | 4 | C Unit 1a M | @E 999,999,999.9999 | S | |||||
| B2_CMFIM2 | N | 14 | 4 | C Unit 2a M | @E 999,999,999.9999 | S | |||||
| B2_CMFIM3 | N | 14 | 4 | C Unit 3a M | @E 999,999,999.9999 | S | |||||
| B2_CMFIM4 | N | 14 | 4 | C Unit 4a M | @E 999,999,999.9999 | S | |||||
| B2_CMFIM5 | N | 14 | 4 | C Unit 5a M | @E 999,999,999.9999 | S | |||||
| B2_TIPO | C | 1 | 0 | Tipo Armazem | @! | A225Tipo(1) | 1=Padrao;2=Proprio;3=Terceiros;4=Alugados;5=Consignados | S | |||
| B2_CMRP1 | N | 14 | 4 | Rep. Unit. | @E 999,999,999.9999 | IIF(Subs(M->B2_COD,1,3)!='MOD',.F.,.T.) | S | ||||
| B2_VFRP1 | N | 14 | 2 | Rep. Final | @E 99,999,999,999.99 | S | |||||
| B2_CMRP2 | N | 14 | 4 | Rep.Uni.2a M | @E 999,999,999.9999 | IIF(Subs(M->B2_COD,1,3)!='MOD',.F.,.T.) | S | ||||
| B2_VFRP2 | N | 14 | 2 | Rep.Fin.2a M | @E 99,999,999,999.99 | S | |||||
| B2_CMRP3 | N | 14 | 4 | Rep.Uni.3a M | @E 999,999,999.9999 | IIF(Subs(M->B2_COD,1,3)!='MOD',.F.,.T.) | S | ||||
| B2_VFRP3 | N | 14 | 2 | Rep.Fin.3a M | @E 99,999,999,999.99 | S | |||||
| B2_CMRP4 | N | 14 | 4 | Rep.Uni.4a M | @E 999,999,999.9999 | IIF(Subs(M->B2_COD,1,3)!='MOD',.F.,.T.) | S | ||||
| B2_VFRP4 | N | 14 | 2 | Rep.Fin.4a M | @E 99,999,999,999.99 | S | |||||
| B2_CMRP5 | N | 14 | 4 | Rep.Uni.5a M | @E 999,999,999.9999 | IIF(Subs(M->B2_COD,1,3)!='MOD',.F.,.T.) | S | ||||
| B2_VFRP5 | N | 14 | 2 | Rep.Fin.5a M | @E 99,999,999,999.99 | S | |||||
| B2_QULT | N | 14 | 2 | Ultimo Saldo | @E 99,999,999,999.99 | R | S | ||||
| B2_DULT | D | 8 | 0 | Data Envio | R | S | |||||
| B2_BLOQUEI | C | 1 | 0 | Tp.Bloqueio | @! | A225Tipo(2) | 1=Nenhum;2=Consumo;3=Producao;4=Cons/Prod | S | |||
| B2_MSEXP | C | 8 | 0 | Ident.Export | R | S | |||||
| B2_ECSALDO | N | 14 | 2 | Sld E-Commer | @E 99,999,999,999.99 | R | S | ||||
| B2_XDTINI | D | 8 | 0 | Fch. Inicial | S | ||||||
| B2_XDTFIN | D | 8 | 0 | Fch. Final | S | ||||||
| B2_HULT | C | 8 | 0 | Hora Envio | 99:99:99 | R | S | ||||
| B2_DMOV | D | 8 | 0 | Dt Movimento | R | S | |||||
| B2_HMOV | C | 8 | 0 | Hr Movimento | 99:99:99 | R | S | ||||