| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CNB | Itens das Planilhas Contratos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CNB_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CNB_NUMERO | C | 6 | 0 | Nr Planilha | @! | R | S | ||||
| CNB_REVISA | C | 3 | 0 | Revisao | @! | R | S | ||||
| CNB_ITEM | C | 3 | 0 | Nr do Item | @! | R | S | ||||
| CNB_PRODUT | C | 15 | 0 | Produto | @! | ExistCPO("SB1") .And. CN200VldProd(M->CNB_PRODUT) .And. cn200MultT() | SB1 | R | S | ||
| CNB_DESCRI | C | 30 | 0 | Descricao | @! | R | S | ||||
| CNB_UM | C | 2 | 0 | Unidade | ExistCpo("SAH") | SAH | R | S | |||
| CNB_QUANT | N | 12 | 4 | Quantidade | @E 9,999,999.9999 | Positivo() .And. cn200MultT() | R | S | |||
| CNB_REALI | N | 16 | 2 | Vl Realinhad | @E 9,999,999,999,999.99 | R | S | ||||
| CNB_DTREAL | D | 8 | 0 | Dt Realinham | R | S | |||||
| CNB_VLTOTR | N | 16 | 2 | Vl Tot Reali | @E 9,999,999,999,999.99 | R | S | ||||
| CNB_VLUNIT | N | 16 | 2 | Vl. Unitario | @E 9,999,999,999,999.99 | Positivo() .And. cn200MultT() | R | S | |||
| CNB_VLTOT | N | 16 | 2 | Valor Total | @E 9,999,999,999,999.99 | Positivo() .And. cn200MultT() | R | S | |||
| CNB_DESC | N | 6 | 2 | Desconto % | @E 999.99 | Positivo() .And. FwFldGet('CNB_DESC') <= 100 .And. cn200MultT() | R | S | |||
| CNB_VLDESC | N | 14 | 2 | Vl. Desconto | @E 999,999,999.99 | NoRound(FwFldGet('CNB_VLTOT')*FwFldGet('CNB_DESC')/100,TamSx3("CNB_VLDESC")[2]) == FwFldGet("CNB_VLDESC") | R | S | |||
| CNB_CODMEN | C | 6 | 0 | Codigo Memo | @! | R | S | ||||
| CNB_DTANIV | D | 8 | 0 | Dt Anivers | R | S | |||||
| CNB_CONORC | C | 20 | 0 | Conta Orcam | @! | R | S | ||||
| CNB_CONTRA | C | 15 | 0 | Nr Contrato | @! | R | S | ||||
| CNB_DTCAD | D | 8 | 0 | Dt Cadastro | R | S | |||||
| CNB_DTPREV | D | 8 | 0 | Dt Entrega | R | S | |||||
| CNB_QTDMED | N | 16 | 8 | Qtd. Medida | @E 9,999,999.99999999 | R | S | ||||
| CNB_CONTA | C | 20 | 0 | Conta Contab | @! | Vazio() .Or. (CTB105CTA() .And. MTPVLSOLEC()) | CT1 | R | S | ||
| CNB_PERC | N | 6 | 2 | Percentual | @E 999.99 | Positivo() .And. (M->CNB_PERC <= 100) | R | S | |||
| CNB_RATEIO | C | 1 | 0 | Rateio ? S/N | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| CNB_TIPO | C | 1 | 0 | Tipo Item | @! | R | S | ||||
| CNB_ITSOMA | C | 1 | 0 | Item Soma | @! | R | S | ||||
| CNB_PRCORI | N | 16 | 2 | Vlr Original | @E 9,999,999,999,999.99 | R | S | ||||
| CNB_QTDORI | N | 12 | 4 | Qtd Original | @E 999,999.9999 | R | S | ||||
| CNB_QTRDAC | N | 12 | 4 | Qt Acrescida | @E 999,999.9999 | R | S | ||||
| CNB_QTRDRZ | N | 12 | 4 | Qt Reduzida | @E 999,999.9999 | R | S | ||||
| CNB_QTREAD | N | 12 | 4 | Qt Readequad | @E 999,999.9999 | R | S | ||||
| CNB_VLREAD | N | 16 | 2 | Vl Readequad | @E 9,999,999,999,999.99 | R | S | ||||
| CNB_VLRDGL | N | 16 | 2 | Valor Global | @E 9,999,999,999,999.99 | R | S | ||||
| CNB_PERCAL | N | 12 | 4 | % Calculo | @E 99999.99 | R | S | ||||
| CNB_FILHO | N | 5 | 0 | Indica Pai | @E 99999 | R | S | ||||
| CNB_SLDMED | N | 16 | 8 | Saldo | @E 9,999,999.99999999 | R | S | ||||
| CNB_NUMSC | C | 6 | 0 | Numero da SC | @! | SC1 | S | ||||
| CNB_ITEMSC | C | 4 | 0 | Item da SC | @! | S | |||||
| CNB_QTDSOL | N | 12 | 2 | Qt Solicita | @E 999,999,999.99 | S | |||||
| CNB_SLDREC | N | 16 | 8 | Sld Receber | @E 9,999,999.99999999 | R | S | ||||
| CNB_FLGCMS | C | 1 | 0 | Ctr. Com. | @! | Pertence('12') | R | 1=Sim;2=Nao | S | ||
| CNB_TE | C | 3 | 0 | Tipo Entrada | @! | (Vazio().Or.ExistCPO('SF4')) .And. CN300VldTE() | SF4 | R | S | ||
| CNB_TS | C | 3 | 0 | Tipo Saida | @! | CN300VldTS() | SF4 | R | S | ||
| CNB_COPMED | C | 1 | 0 | It Md Gr Cop | @! | S | |||||
| CNB_ITMDST | C | 3 | 0 | Item Destino | R | S | |||||
| CNB_TABPRC | C | 3 | 0 | Tab. Preco | cn300VldTB() | DA0 | R | S | |||
| CNB_FILORI | C | 2 | 0 | Fil. Origem | R | S | |||||
| CNB_BASINS | C | 1 | 0 | Base Instal. | Pertence('12') .And. CN200VlBas() | R | 1=Sim;2=Nao | C200BIWhen('CNB_BASINS') | S | ||
| CNB_GERBIN | C | 1 | 0 | Base Gerada | Pertence('12') | R | 1=Sim;2=Nao | S | |||
| CNB_CC | C | 9 | 0 | Centro Custo | @! | Vazio(M->CNB_CC) .Or. (Ctb105CC() .And. MTPVLSOLEC()) | CTT | R | S | ||
| CNB_CLVL | C | 9 | 0 | Classe Valor | @! | Vazio() .Or. (CTB105CLVL() .And. MTPVLSOLEC()) | CTH | R | S | ||
| CNB_ULTAVA | D | 8 | 0 | Ult. Aval. | R | S | |||||
| CNB_PROXAV | D | 8 | 0 | Prox. Aval. | R | S | |||||
| CNB_PEDTIT | C | 1 | 0 | Nota/Titulo? | @! | Pertence("12") | R | 1=Nota Fiscal;2=Titulo | S | ||
| CNB_ITEMCT | C | 9 | 0 | Item Conta | @! | Vazio() .Or. Ctb105Item() | CTD | R | S | ||
| CNB_GCPIT | C | 6 | 0 | Item Ed | @! | R | S | ||||
| CNB_GCPLT | C | 8 | 0 | Lote Ed | @! | R | S | ||||
| CNB_INDICE | C | 3 | 0 | Indice | @! | Vazio().or.ExistCpo('CN6') | CN6 | R | S | ||
| CNB_IDENT | C | 4 | 0 | Identific. | @! | R | S | ||||
| CNB_RJRTO | L | 1 | 0 | Reaj Retro | R | S | |||||
| CNB_CODNE | C | 12 | 0 | Cod Nota Emp | @! | CX1 | R | A300LibNTE() | S | ||
| CNB_ITEMNE | C | 3 | 0 | Item Nt Emp | @! | R | A300LibNTE() | S | |||
| CNB_ATIVO | C | 1 | 0 | Ativo | Vazio() .Or. Pertence("12") | R | 1=Sim;2=Nao | CN300ENREC() | S | ||
| CNB_PARPRO | N | 6 | 2 | Parc. Propor | @E 999.99 | FwFldGet('CNB_PARPRO') >= 0 .And. FwFldGet('CNB_PARPRO') <= 100 | R | CN300ENREC() | S | ||
| CNB_PRIMED | D | 8 | 0 | Dt.Prim.Med. | R | S | |||||
| CNB_PROREV | C | 2 | 0 | Rev Proposta | @! | R | S | ||||
| CNB_PROPOS | C | 6 | 0 | Cod Proposta | @! | R | S | ||||
| CNB_PROITN | C | 4 | 0 | Item Propost | R | S | |||||
| CNB_PROXRJ | D | 8 | 0 | Prox. Reajus | R | S | |||||
| CNB_IDPED | C | 1 | 0 | ID Pedido | @! | R | S | ||||
| CNB_MODORJ | C | 1 | 0 | Modo | @! | Pertence("12") | R | 1=Por Competencia;2=Por Data | CN300WReIt() | S | |
| CNB_DTREAJ | D | 8 | 0 | Dt. Reajuste | R | CN300WReIt() | S | ||||
| CNB_FLREAJ | C | 1 | 0 | Reajuste | @! | Pertence("12") | R | 1=Sim;2=Nao | CN300WRePl() | S | |
| CNB_PRODSV | C | 15 | 0 | Produto SV | @! | Vazio() .or. ExistCpo("SB1") | SB1 | R | S | ||
| CNB_PERI | N | 6 | 0 | Period. Reaj | @E 999999 | Positivo() | R | CN300WRePl() | S | ||
| CNB_UNPERI | C | 1 | 0 | Un Per Reaju | @! | Pertence('123') | R | 1=Dias;2=Meses;3=Anos | CN300WRePl() | S | |
| CNB_ARREND | C | 1 | 0 | Arrendamento | @! | Pertence("012") .Or. Vazio() | R | 0=Nao se aplica;1=Financeiro;2=Operacional | S | ||