| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CNA | Cabecalho Planilhas Contratos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CNA_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CNA_CONTRA | C | 15 | 0 | Nr Contrato | @! | ExistCpo("CN9") .And. CN200VldCon() | CN9 | R | IIf(FunName()=="CNTA200",INCLUI,!INCLUI.AND.!ALTERA) | S | |
| CNA_NUMERO | C | 6 | 0 | Nr Planilha | @! | ExistChav("CNA",FwFldGet("CNA_CONTRA")+FwFldGet("CNA_REVISA")+FwFldGet("CNA_NUMERO")) | R | INCLUI | S | ||
| CNA_REVISA | C | 3 | 0 | Revisao | @! | (Vazio().Or.ExistCpo('CN9',FwFldGet("CNA_CONTRA")+FwFldGet("CNA_REVISA"))) .And. CN200VldCon() | R | INCLUI | S | ||
| CNA_FORNEC | C | 6 | 0 | Fornecedor | @! | CN300VlFor() | CNC001 | R | EMPTY(FwFldGet("CNA_CLIENT")) | S | |
| CNA_LJFORN | C | 2 | 0 | Loja | @! | CN300VlFor() | R | EMPTY(FwFldGet("CNA_CLIENT")) | S | ||
| CNA_CLIENT | C | 6 | 0 | Cliente | @! | CN300VlCli() | CNC001 | R | S | ||
| CNA_LOJACL | C | 2 | 0 | Lj. Cliente | @! | CN300VlCli() | R | S | |||
| CNA_DTINI | D | 8 | 0 | Data Inicial | CN200VldDini() | R | S | ||||
| CNA_VLTOT | N | 16 | 2 | Valor Total | @E 9,999,999,999,999.99 | CN300VlTot(xOldValue) | R | S | |||
| CNA_SALDO | N | 16 | 2 | Saldo | @E 9,999,999,999,999.99 | R | S | ||||
| CNA_TIPPLA | C | 3 | 0 | Tipo | @! | ExistCpo("CNL") | CNL | R | S | ||
| CNA_DTFIM | D | 8 | 0 | Data Final | CN200VldDfim() | R | S | ||||
| CNA_CRONOG | C | 6 | 0 | Nr Cronogram | @! | R | S | ||||
| CNA_ESPEL | C | 6 | 0 | Nr.Plan.Espe | @! | R | S | ||||
| CNA_FLREAJ | C | 1 | 0 | Reajuste | @! | Pertence("12") | R | 1=Sim;2=Nao | CN300WReCt() | S | |
| CNA_DTMXMD | D | 8 | 0 | Data Max Med | R | S | |||||
| CNA_CRONCT | C | 6 | 0 | Cron.Contab. | @! | R | S | ||||
| CNA_VLCOMS | N | 16 | 2 | Vl. Base Com | @E 9,999,999,999,999.99 | R | S | ||||
| CNA_SADIST | N | 16 | 2 | Sld Dis F\F | @E 9,999,999,999,999.99 | V | S | ||||
| CNA_SADISC | N | 16 | 2 | Sld Dis CB | @E 9,999,999,999,999.99 | V | S | ||||
| CNA_DESCRI | C | 30 | 0 | Descr. Plan. | V | S | |||||
| CNA_PERIOD | C | 1 | 0 | Un.Per.Rec. | 9 | Pertence("1234") | R | 1=Dias;2=Semanas;3=Meses;4=Anos | CN300ENREC() | S | |
| CNA_PERREC | N | 3 | 0 | Period.Recor | @E 999 | Positivo() | R | CN300ENREC() .And. FwFldGet("CNA_PERIOD") $ "1234" | S | ||
| CNA_QTDREC | N | 4 | 0 | Qtd. Recorr. | 9999 | FWFldGet("CNA_QTDREC") >= 0 .And. CN300VLREC(a,b,c,d) | R | CN300ENREC() | S | ||
| CNA_DIASEM | C | 1 | 0 | Dia Semana | Pertence("123") | R | 1=Indiferente;2= Dia Util Seguinte;3=Dia Util Anterior | CN300ENREC() | S | ||
| CNA_DIAMES | N | 2 | 0 | Dia do Mes | 99 | FwFldGet("CNA_DIAMES") >=0 .And. FwFldGet("CNA_DIAMES") <= 31 | R | CN300ENREC() | S | ||
| CNA_PROMED | D | 8 | 0 | Prox. Med. | R | S | |||||
| CNA_ULTMED | D | 8 | 0 | Ult. Med. | R | S | |||||
| CNA_MEDEFE | N | 4 | 0 | Med.Efetuada | 9999 | R | S | ||||
| CNA_INDICE | C | 3 | 0 | Indice | @! | CN6 | S | ||||
| CNA_UNPERI | C | 1 | 0 | Un.Per.Reaju | @! | Pertence("123") | R | 1=Dias;2=Meses;3=Anos | CN300WRePl() | S | |
| CNA_PERI | N | 6 | 0 | Period.Reaju | @E 999999 | Positivo() | R | CN300WRePl() | S | ||
| CNA_PROPAR | C | 2 | 0 | Prox.Parcela | @! | R | S | ||||
| CNA_MODORJ | C | 1 | 0 | Modo | @! | Pertence("12") | R | 1=Por Competencia;2=Por Data | CN300WRePl() | S | |
| CNA_RECMED | C | 6 | 0 | Nr.Ult. Med. | R | S | |||||
| CNA_PRORAT | C | 1 | 0 | Pro Rata | @! | Pertence("012") | R | 0=Contrato(Padrao);1=Sim;2=Nao | CN300WRePl() | S | |
| CNA_DTREAJ | D | 8 | 0 | Dt. Reajuste | R | S | |||||
| CNA_PROXRJ | D | 8 | 0 | Prox. Reajus | R | S | |||||
| CNA_RPGANT | C | 1 | 0 | Pag. Ant. | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| CNA_DESCPL | C | 40 | 0 | Desc Plan | R | S | |||||