| 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 | |||||