Tabela |
CN9 |
Contratos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
CN9_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
M->CN9_FLGCAU == '1' |
S |
CN9_TPCTO |
C |
3 |
0 |
Tp. Contrato |
@! |
CN300TpCtr() |
CN1CN9 |
R |
|
|
S |
CN9_NUMERO |
C |
15 |
0 |
Nr. Contrato |
@! |
ExistChav("CN9") |
|
R |
|
|
S |
CN9_DTINIC |
D |
8 |
0 |
Data Inicio |
|
CN300VlDtI() |
|
R |
|
INCLUI |
S |
CN9_DTASSI |
D |
8 |
0 |
Dt Assinatur |
|
CN300VlDAss() |
|
R |
|
|
S |
CN9_UNVIGE |
C |
1 |
0 |
Un. Vigencia |
@! |
Pertence('1234') |
|
R |
1=Dias;2=Meses;3=Anos;4=Indeterminada |
|
S |
CN9_VIGE |
N |
6 |
0 |
Vigencia |
@E 999999 |
Positivo() |
|
R |
|
FwFldGet("CN9_UNVIGE") != '4' |
S |
CN9_DTFIM |
D |
8 |
0 |
Data Final |
|
|
|
R |
|
|
S |
CN9_CLIENT |
C |
6 |
0 |
Fora de Uso |
@! |
|
SA1 |
R |
|
|
S |
CN9_LOJACL |
C |
2 |
0 |
Fora de Uso |
@! |
|
|
R |
|
|
S |
CN9_MOEDA |
N |
2 |
0 |
Moeda |
99 |
FwFldGet("CN9_MOEDA") > 0 .AND. FwFldGet("CN9_MOEDA") <= MOEDFIN() |
|
R |
|
|
S |
CN9_CONDPG |
C |
3 |
0 |
Cond. Pagto. |
@! |
ExistCpo("SE4") |
SE4 |
R |
|
|
S |
CN9_DESCPG |
C |
30 |
0 |
Desc. Pagto. |
@! |
|
|
V |
|
|
S |
CN9_CODOBJ |
C |
6 |
0 |
Codigo Memo |
@! |
|
|
R |
|
|
S |
CN9_VLINI |
N |
16 |
2 |
Vl. Inicial |
@E 9,999,999,999,999.99 |
|
|
R |
|
CN300EnVl() |
S |
CN9_VLATU |
N |
16 |
2 |
Valor Atual |
@E 9,999,999,999,999.99 |
A300VldVAt(a,c) |
|
R |
|
|
S |
CN9_INDICE |
C |
3 |
0 |
Indice |
@! |
Vazio().or.ExistCpo('CN6') |
CN6 |
R |
|
CN300WReCt() |
S |
CN9_INDDES |
C |
30 |
0 |
Descr Indice |
@! |
|
|
V |
|
|
S |
CN9_FLGREJ |
C |
1 |
0 |
Reajuste S/N |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
CN9_REVISA |
C |
3 |
0 |
Revisao |
@! |
|
|
R |
|
|
S |
CN9_FLGCAU |
C |
1 |
0 |
Caucao S/N |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
CN9_TPCAUC |
C |
1 |
0 |
Ctr. Caucao |
@! |
Pertence("12") |
|
R |
1=Manual;2=Retencao |
FwFldGet("CN9_FLGCAU") == '1' |
S |
CN9_MINCAU |
N |
5 |
2 |
% Caucao |
@E 99.99 |
|
|
R |
|
FwFldGet("CN9_FLGCAU") == '1' |
S |
CN9_DTENCE |
D |
8 |
0 |
Dt Encerram |
|
|
|
R |
|
|
S |
CN9_TIPREV |
C |
3 |
0 |
Tipo Revisao |
@! |
ExistCpo("CN0") |
CN0 |
R |
|
|
S |
CN9_REVATU |
C |
3 |
0 |
Revisao Atua |
@! |
|
|
R |
|
|
S |
CN9_SALDO |
N |
16 |
2 |
Saldo |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CN9_MOTPAR |
C |
3 |
0 |
Mot.Paralisa |
@! |
ExistCpo("CN2") |
CN2 |
R |
|
|
S |
CN9_DTFIMP |
D |
8 |
0 |
Dt.Term.Par. |
|
A300DtRei() |
|
R |
|
|
S |
CN9_DTREIN |
D |
8 |
0 |
Dt .Reinicio |
|
|
|
R |
|
|
S |
CN9_CODJUS |
C |
6 |
0 |
Codigo Memo |
@! |
|
|
R |
|
|
S |
CN9_CODCLA |
C |
6 |
0 |
Codigo Memo |
@! |
|
|
R |
|
|
S |
CN9_OBJCTO |
M |
60 |
0 |
Objeto |
@! |
|
|
V |
|
|
S |
CN9_DTREV |
D |
8 |
0 |
Data Revisao |
|
|
|
R |
|
|
S |
CN9_DTREAJ |
D |
8 |
0 |
Data Reajust |
|
|
|
R |
|
|
S |
CN9_VLREAJ |
N |
16 |
2 |
Valor Reajus |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CN9_VLADIT |
N |
16 |
2 |
Valor Aditiv |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CN9_NUMTIT |
C |
6 |
0 |
Titulo Provi |
@! |
|
|
R |
|
|
S |
CN9_ALTCLA |
M |
254 |
0 |
Clausula |
@! |
|
|
V |
|
|
S |
CN9_JUSTIF |
M |
254 |
0 |
Justificativ |
@! |
|
|
V |
|
.F. |
S |
CN9_VLMEAC |
N |
16 |
2 |
Medicao Acum |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CN9_TXADM |
N |
5 |
2 |
Taxa Admin |
@E 999,99 |
|
|
R |
|
|
S |
CN9_FORMA |
C |
1 |
0 |
Forma |
@! |
|
|
R |
|
|
S |
CN9_DTENTR |
D |
8 |
0 |
Dt. Idel Nec |
|
|
|
R |
|
|
S |
CN9_LOCENT |
C |
2 |
0 |
Fora de Uso |
@! |
ExistCpo("NNR") |
|
R |
|
|
S |
CN9_CODENT |
C |
2 |
0 |
Fora de Uso |
@! |
|
|
R |
|
|
S |
CN9_DESLOC |
C |
30 |
0 |
Almoxarifado |
@! |
|
|
V |
|
|
S |
CN9_DESFIN |
C |
30 |
0 |
No. Financ. |
@! |
|
|
R |
|
|
S |
CN9_CONTFI |
C |
15 |
0 |
No.Cont.Fin. |
@! |
|
|
R |
|
|
S |
CN9_DTINPR |
D |
8 |
0 |
Dt. Prorrog |
|
|
|
R |
|
|
S |
CN9_PERPRO |
N |
3 |
0 |
Per. Prorrog |
999 |
|
|
R |
|
|
S |
CN9_UNIPRO |
C |
1 |
0 |
Unid. Prorro |
@! |
|
|
R |
|
|
S |
CN9_VLRPRO |
N |
16 |
2 |
Vlr. Prorrog |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CN9_DTPROP |
D |
8 |
0 |
Dt Proposta |
|
|
|
R |
|
|
S |
CN9_DTULST |
D |
8 |
0 |
Dt Ult Statu |
|
|
|
R |
|
|
S |
CN9_DTINCP |
D |
8 |
0 |
Dt.Inic.Par. |
|
|
|
R |
|
|
S |
CN9_SITUAC |
C |
2 |
0 |
Situacao |
@! |
Pertence("01020304050607080910A") |
|
R |
01=Cancelado;02=Elaboracao;03=Emitido;04=Aprovacao;05=Vigente;06=Paralisa.;07=Sol. Finalizacao;08=Finali.;09=Revisao;10=Revisado |
|
S |
CN9_DESCRI |
C |
40 |
0 |
Descricao |
@! |
|
|
R |
|
|
S |
CN9_END |
C |
40 |
0 |
Fora de Uso |
@! |
|
|
R |
|
|
S |
CN9_MUN |
C |
15 |
0 |
Fora de Uso |
@! |
|
|
R |
|
|
S |
CN9_BAIRRO |
C |
20 |
0 |
Fora de Uso |
@! |
|
|
R |
|
|
S |
CN9_EST |
C |
2 |
0 |
Estado |
@! |
ExistCpo('SX5','12'+FwFldGet("CN9_EST")) |
12 |
R |
|
|
S |
CN9_ESTADO |
C |
20 |
0 |
Fora de Uso |
@!S20 |
|
|
R |
|
|
S |
CN9_ALCISS |
N |
6 |
2 |
Aliq. ISS |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
CN9_INSSMO |
N |
6 |
2 |
Base INSS MO |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
CN9_INSSME |
N |
6 |
2 |
Base ME |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
CN9_VLDCTR |
C |
1 |
0 |
Vl.Cont |
@! |
Pertence('12') .And. CN300VlCtr() |
|
R |
1=Sim;2=Nao |
|
S |
CN9_CODED |
C |
15 |
0 |
Cod. Edital |
@! |
|
|
|
|
|
S |
CN9_NUMPR |
C |
15 |
0 |
Nr. Processo |
@! |
|
|
|
|
|
S |
CN9_USUAVA |
C |
6 |
0 |
Usr.Avalia. |
@! |
UsrExist(FwFldGet("CN9_USUAVA")) |
USR |
R |
|
GetNewPar( 'MV_USAAEC', '2' ) == '1' |
S |
CN9_PROGRA |
C |
1 |
0 |
Prog. Aval. |
@! |
Pertence('123456') |
|
R |
1=Quinzenal;2=Mensal;3=Bimestral;4=Trimestral;5=Semestral;6=Anual |
GetNewPar( 'MV_USAAEC', '2' ) == '1' |
S |
CN9_ULTAVA |
D |
8 |
0 |
Ult.Aval. |
|
|
|
R |
|
|
S |
CN9_PROXAV |
D |
8 |
0 |
Prox.Aval. |
|
|
|
R |
|
|
S |
CN9_DTVIGE |
D |
8 |
0 |
Dt.Vig.Fut |
|
|
|
R |
|
|
S |
CN9_APROV |
C |
6 |
0 |
Grupo Aprov. |
@! |
Empty(FwFldGet('CN9_APROV')) .OR. ExistCpo("SAL") |
SAL |
R |
|
|
S |
CN9_RESREM |
C |
1 |
0 |
Elim. Reman. |
@! |
|
|
R |
|
|
N |
CN9_FILORI |
C |
2 |
0 |
Fil. Origem |
|
|
|
R |
|
|
S |
CN9_DREFRJ |
D |
8 |
0 |
Ref Reajuste |
|
|
|
R |
|
|
S |
CN9_ESPCTR |
C |
1 |
0 |
Esp. Contrat |
@! |
Pertence("12") |
|
R |
1=Compra;2=Venda |
|
S |
CN9_FILCTR |
C |
2 |
0 |
Filial Ctr. |
|
|
|
R |
|
|
S |
CN9_NATURE |
C |
10 |
0 |
Natureza |
@! |
ExistCpo('SED') |
SED |
R |
|
|
S |
CN9_NUMCOT |
C |
6 |
0 |
Num. Cotacao |
@! |
|
|
R |
|
|
S |
CN9_DATREF |
D |
8 |
0 |
Fora de Uso |
|
|
|
R |
|
|
S |
CN9_ARRAST |
C |
1 |
0 |
Arrasto |
|
Pertence("12") .And. CN300VdArr() |
|
V |
1=Sim;2=Nao |
|
S |
CN9_REDVAL |
C |
1 |
0 |
Redist. Val. |
|
Pertence("12") |
|
V |
1=Sim;2=Nao |
|
S |
CN9_CSLD |
L |
1 |
0 |
Saldo |
|
|
|
V |
|
|
S |
CN9_MPLA |
L |
1 |
0 |
Montante Pla |
|
|
|
V |
|
!FwFldGet('CN9_CSLD') |
S |
CN9_CPARCA |
L |
1 |
0 |
Parcelas Ant |
|
|
|
V |
|
|
S |
CN9_CPARCV |
L |
1 |
0 |
Parcelas Rea |
|
|
|
V |
|
|
S |
CN9_NUMATA |
C |
15 |
0 |
Num. da Ata |
@! |
|
|
R |
|
|
S |
CN9_QTPARC |
N |
1 |
0 |
Quantidade |
9 |
Positivo() |
|
V |
|
|
S |
CN9_NODIA |
C |
10 |
0 |
Seq. Diario |
@! |
|
|
|
|
|
S |
CN9_DIACTB |
C |
2 |
0 |
Cod Diario |
@! |
ExistCPO("CVL") |
CVL |
|
|
|
S |
CN9_TPCROC |
C |
1 |
0 |
Tipo |
@! |
Pertence("12") |
|
V |
1=Acrescimo;2=Decrescimo |
|
S |
CN9_UDMES |
L |
1 |
0 |
Ult Dia Mes |
|
|
|
V |
|
|
S |
CN9_TPCRON |
C |
1 |
0 |
Tipo |
|
pertence("12") |
|
V |
1=Acrescimo;2=Decrescimo |
|
S |
CN9_QTDPAR |
N |
3 |
0 |
Quantidade |
@E 999 |
|
|
V |
|
|
S |
CN9_DESMTP |
C |
50 |
0 |
Desc.Mot.Par |
|
|
|
V |
|
|
S |
CN9_DESC |
C |
30 |
0 |
Desc. Tipo |
|
|
|
V |
|
|
S |
CN9_ASSINA |
D |
8 |
0 |
Dt. Assinat. |
|
|
|
R |
|
|
S |
CN9_GRPAPR |
C |
6 |
0 |
Grp. Apr. MD |
@! |
Empty(FwFldGet('CN9_GRPAPR')) .OR. ExistCpo("SAL") |
SAL |
R |
|
|
S |
CN9_CODNE |
C |
12 |
0 |
Cod Nota Emp |
@! |
|
|
R |
|
|
S |
CN9_DTRRDE |
D |
8 |
0 |
De |
|
|
|
R |
|
|
S |
CN9_DTRRAT |
D |
8 |
0 |
Ate |
|
|
|
R |
|
|
S |
CN9_FILEDT |
C |
2 |
0 |
Fil Edital |
|
|
|
R |
|
|
S |
CN9_LOGHOR |
C |
8 |
0 |
Hora Log |
99:99:99 |
|
|
|
|
|
S |
CN9_LOGUSR |
C |
6 |
0 |
Usuario LOG |
@! |
|
|
R |
|
|
S |
CN9_LOGDAT |
D |
8 |
0 |
Data Log |
|
|
|
|
|
|
S |
CN9_PERI |
N |
6 |
0 |
Periodicidad |
@E 999999 |
|
|
R |
|
CN300WReCt() |
S |
CN9_UNPERI |
C |
1 |
0 |
Un. Period |
@! |
Pertence("123") |
|
R |
1=Dias;2=Meses;3=Anos |
CN300WReCt() |
S |
CN9_MODORJ |
C |
1 |
0 |
Modo |
@! |
Pertence("12") |
|
R |
1=Por Competencia;2=Por Data |
CN300WReCt() |
S |
CN9_PRORAT |
C |
1 |
0 |
Pro Rata |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
CN300WReCt() |
S |
CN9_PROPOS |
C |
6 |
0 |
Cod Proposta |
@! |
|
|
R |
|
|
S |
CN9_PROREV |
C |
2 |
0 |
Rev Proposta |
@! |
|
|
R |
|
|
S |
CN9_PIMSST |
C |
4 |
0 |
Status Integ |
@! |
|
|
R |
|
|
S |
CN9_PIMSER |
M |
254 |
0 |
Erro Integr. |
|
|
|
R |
|
|
S |
CN9_PROXRJ |
D |
8 |
0 |
Prox. Reaj. |
|
|
|
R |
|
|
S |
CN9_DEPART |
C |
6 |
0 |
Area Contrat |
@! |
ExistCpo('CXQ') |
CXQ |
|
|
|
S |
CN9_AREACO |
C |
40 |
0 |
Desc. Area |
|
|
|
V |
|
|
S |
CN9_GESTC |
C |
6 |
0 |
Cod Gestor |
@! |
|
USR |
R |
|
|
S |
CN9_GESTN |
C |
40 |
0 |
Nome Gestor |
|
|
|
V |
|
|
S |