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 |