Tabela
CNE Itens da Medicao de Contratos
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
CNE_FILIAL C 2 0 Filial R S
CNE_TIPO C 1 0 Tipo @! R S
CNE_ITEM C 3 0 Numero Item @! R S
CNE_PRODUT C 15 0 Produto @! ExistCPO("SB1") .And. CN121MultT() .And. CN120VldProd() SB1 R S
CNE_DESCRI C 50 0 Descricao @! V S
CNE_QTDSOL N 16 8 Qtd. Solicit @E 9,999,999.99999999 R S
CNE_QTAMED N 16 8 Saldo Medir @E 9,999,999.99999999 R S
CNE_QUANT N 16 8 Quantidade @E 9,999,999.99999999 Positivo() .And. CN121VldQtd().And.cn121MultT() R S
CNE_PERC N 6 2 Percentual @E 999.99 Positivo() .And. CN121VldPerc().And.cn121MultT() R S
CNE_VLUNIT N 16 4 Vl. Unitario @E 99,999,999,999.9999 If(IsInCallStack('CNTA120'), cn130VlUnt(),cn121VlUnt(a,b,c,d)).And.cn121MultT() R S
CNE_VLTOT N 16 2 Vl. Total @E 9,999,999,999,999.99 Positivo() .And. CN121VlTot().And.cn121MultT() R S
CNE_PDESC N 6 2 % Desc.Contr @E 999.99 IIF(IsInCallStack('CNTA120'), (M->CNE_PDESC <= 100 .And. CN130TotMed(4)), FwFldGet('CNE_PDESC')<=100) R S
CNE_VLDESC N 14 2 Vl Desc.Cont @E 999,999,999.99 R S
CNE_DTANIV D 8 0 Dt. Aniver R S
CNE_CONTRA C 15 0 Nr Contrato @! R S
CNE_DTENT D 8 0 Data Entrega CN121VldDtEnt() R S
CNE_REVISA C 3 0 Num. Revisao @! R S
CNE_NUMERO C 6 0 Num.Planilha @! R S
CNE_NUMMED C 6 0 Num. Medicao @! R S
CNE_ITSOMA C 1 0 Item Soma @! R S
CNE_QTRETI N 16 8 Qt. Retific. @E 9,999,999.99999999 R S
CNE_PEDIDO C 6 0 Num. Pedido @! R S
CNE_FLGCMS C 1 0 Ctr. Com. Pertence('12') R 1=Sim;2=Nao S
CNE_TE C 3 0 Tipo Entrada @! (Vazio().Or.ExistCPO('SF4')) .And. CN130VldTE() SF4 R S
CNE_TS C 3 0 Tipo Saida @! cn130VldTS() SF4 R S
CNE_RESID C 1 0 Resid. Elim. @! Pertence('S') S
CNE_QTDORI N 16 8 Qt. Original @E 9,999,999.99999999 R S
CNE_VUNORI N 16 4 Vl. Original @E 99,999,999,999.9999 R S
CNE_CC C 9 0 Centro Custo @! Vazio() .Or. Ctb105CC() CTT S
CNE_CONTA C 20 0 Cta Contabil @! Vazio() .Or. Ctb105CTA() CT1 S
CNE_ITEMCT C 9 0 Item Conta @! Vazio() .Or. Ctb105Item() CTD S
CNE_CLVL C 9 0 Cod Cl Val @! Vazio() .Or. CTB105CLVL() CTH CtbInUse() S
CNE_TABPRC C 3 0 Tab. Preco ExistCpo('DA0') .Or. Empty() DA0 R S
CNE_EXCEDE C 1 0 Excedente Pertence('12') R 1=Sim;2=Nao S
CNE_PEDTIT C 1 0 Nota/Titulo? @! Pertence("12") .And. VldPedTit() R 1=Nota Fiscal;2=Titulo S
CNE_ITEMNE C 3 0 Item Nt Emp @! ValidCODED() R S
CNE_CODNE C 12 0 Cod Nota Emp @! ValidCODED() R S
CNE_CRONOG C 6 0 Nr. Cronogra @! R S
CNE_IDPED C 1 0 Agrup. Doc @! R S
CNE_MULTA N 14 2 Multa @E 99,999,999,999.99 R S
CNE_BONIF N 14 2 Bonificacao @E 99,999,999,999.99 R S
CNE_TOTCAN N 14 2 Tot. Cancela @E 99,999,999,999.99 R S
CNE_VLRCAN N 14 2 Vlr. Cancela @E 99,999,999,999.99 R S
CNE_ITEMGR C 4 0 It. Agrup R S
CNE_PRODSV C 15 0 Produto SV @! Vazio() .or. ExistCpo("SB1") SB1 R S
CNE_15ANOS N 14 2 VlrAp 15anos @E 99,999,999,999.99 Positivo() .And. CnrTotApEs() R S
CNE_20ANOS N 14 2 VlrAp 20anos @E 99,999,999,999.99 Positivo() .And. CnrTotApEs() R S
CNE_25ANOS N 14 2 VlrAp 25anos @E 99,999,999,999.99 Positivo() .And. CnrTotApEs() R S
CNE_TPSERV C 2 0 Tipo servico @! DZ R S
CNE_VLLIQD N 16 2 Vl Liq @E 9,999,999,999,999.99 R S
CNE_DTLANC D 8 0 Data Lanc. R S
CNE_ARREND C 1 0 Arrendamento @! Pertence("012") R 0=Nao se aplica;1=Financeiro;2=Operacional S