| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CND | Cabecalho Medicao de Contratos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CND_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CND_NUMMED | C | 6 | 0 | Nr Medicao | @! | R | S | ||||
| CND_CONTRA | C | 15 | 0 | Nr Contrato | @! | CN120VlCon() | CN9003 | R | S | ||
| CND_REVISA | C | 3 | 0 | Nr Revisao | @! | IIf(IsInCallStack('CNTA121'),CN121Carga(FwFldGet('CND_CONTRA'),FwFldGet('CND_REVISA')),.T.) | R | S | |||
| CND_FORNEC | C | 6 | 0 | Fornecedor | @! | CN130VldForn() | CNC001 | R | !(FwIsInCallStack("CN130MANUT").AND. !EMPTY(M->CND_NUMERO)) | S | |
| CND_LJFORN | C | 2 | 0 | Loja | @! | CN130VldForn() | R | S | |||
| CND_CLIENT | C | 6 | 0 | Cliente | @! | CN130VldCli() | CNC002 | R | !(FwIsInCallStack("CN130MANUT").AND. !EMPTY(M->CND_NUMERO)) | S | |
| CND_LOJACL | C | 2 | 0 | Lj. Cliente | @! | CN130VldCli() | R | S | |||
| CND_VLTOT | N | 16 | 2 | Valor Total | @E 9,999,999,999,999.99 | IIf(IsInCallStack('CNTA121'),CN121VlCmp(),.T.) | R | S | |||
| CND_TOTADT | N | 16 | 2 | Valor Adiant | @E 9,999,999,999,999.99 | CnCNDTotVl() | R | S | |||
| CND_RETCAC | N | 15 | 2 | Ret. Caucao | @E 9999,999,999.99 | CnCNDTotVl() | R | S | |||
| CND_MOEDA | N | 2 | 0 | Moeda | 99 | M->CND_MOEDA > 0 .AND. M->CND_MOEDA <= MOEDFIN() | R | S | |||
| CND_DTINIC | D | 8 | 0 | Dt Inclusao | R | S | |||||
| CND_DTFIM | D | 8 | 0 | Data Final | R | S | |||||
| CND_VLMEAC | N | 16 | 2 | Med Acum | @E 9,999,999,999,999.99 | R | S | ||||
| CND_VLSALD | N | 16 | 2 | Saldo Med | @E 9,999,999,999,999.99 | R | S | ||||
| CND_OBS | M | 254 | 0 | Observacao | @! | R | S | ||||
| CND_DTVENC | D | 8 | 0 | Vencimento | R | S | |||||
| CND_DATAIN | D | 8 | 0 | Fora de Uso | R | S | |||||
| CND_DATAFI | D | 8 | 0 | Fora de Uso | R | S | |||||
| CND_ZERO | C | 1 | 0 | Zero? S/N | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| CND_CODOBS | C | 6 | 0 | Cod. Obs. | @! | R | S | ||||
| CND_COMPET | C | 7 | 0 | Competencia | @! | IIf(IsInCallStack('CNTA121'),CN121VlCmp(),.T.) | R | S | |||
| CND_CONDPG | C | 3 | 0 | Cond Pagto | @! | ExistCpo("SE4") | SE4 | R | S | ||
| CND_DESCCP | C | 15 | 0 | Desc Cond | @! | V | S | ||||
| CND_VLCONT | N | 16 | 2 | Vl Contrato | @E 9,999,999,999,999.99 | R | S | ||||
| CND_VLADIT | N | 16 | 2 | Vl Aditivo | @E 9,999,999,999,999.99 | R | S | ||||
| CND_VLREAJ | N | 16 | 2 | Vl Reajuste | @E 9,999,999,999,999.99 | R | S | ||||
| CND_VLGER | N | 16 | 2 | Vl Tot Contr | @E 9,999,999,999,999.99 | R | S | ||||
| CND_NUMERO | C | 6 | 0 | Nr Planilha | @! | R | S | ||||
| CND_TIPPLA | C | 3 | 0 | Tipo | @! | Pertence("123") | CNL | V | S | ||
| CND_DESCTP | C | 30 | 0 | Desc Tip Pla | @! | V | S | ||||
| CND_MEDRET | C | 6 | 0 | Medicao Orig | @! | R | S | ||||
| CND_RETIFI | C | 1 | 0 | Retificada? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| CND_FLREAJ | C | 1 | 0 | Reajuste | @! | R | S | ||||
| CND_VLPREV | N | 16 | 2 | Vl Previsto | @E 9,999,999,999,999.99 | CnCNDTotVl() | R | S | |||
| CND_DESCME | N | 16 | 2 | Desconto Med | @E 9,999,999,999,999.99 | CnCNDTotVl() | R | S | |||
| CND_ALCAPR | C | 1 | 0 | Sit. Alcada | @! | R | B=Bloqueada;L=Liberada | S | |||
| CND_APROV | C | 6 | 0 | Aprovadores | @! | Empty(M->CND_APROV) .OR. ExistCpo("SAL") | SAL | R | S | ||
| CND_PARC1 | N | 12 | 2 | Parcela 1 | @E 999,999,999.99 | Positivo() .Or. Vazio() | R | S | |||
| CND_DATA1 | D | 8 | 0 | Vencimento1 | cn120VTip9() | R | S | ||||
| CND_PARC2 | N | 12 | 2 | Parcela 2 | @E 999,999,999.99 | Positivo() .Or. Vazio() | R | S | |||
| CND_DATA2 | D | 8 | 0 | Vencimento 2 | cn120VTip9() | R | S | ||||
| CND_PARC3 | N | 12 | 2 | Parcela 3 | @E 999,999,999.99 | Positivo() .Or. Vazio() | R | S | |||
| CND_DATA3 | D | 8 | 0 | Vencimento 3 | cn120VTip9() | R | S | ||||
| CND_PARC4 | N | 12 | 2 | Parcela 4 | @E 999,999,999.99 | Positivo() .Or. Vazio() | R | S | |||
| CND_DATA4 | D | 8 | 0 | Vencimento4 | cn120VTip9() | R | N | ||||
| CND_PARCEL | C | 2 | 0 | Num Parcela | @! | R | S | ||||
| CND_AUTFRN | C | 1 | 0 | Aut. Fornec. | @! | R | 1=Nao;2=Sim | S | |||
| CND_PEDIDO | C | 6 | 0 | Num. Pedido | @! | R | S | ||||
| CND_RESID | C | 1 | 0 | Resid. Elim. | @! | Pertence('S') | S | ||||
| CND_SERVIC | C | 1 | 0 | Med. Servico | @! | Pertence('12') | R | 1=Nao;2=Sim | S | ||
| CND_FILMED | C | 2 | 0 | Filial Med. | R | S | |||||
| CND_FILCTR | C | 2 | 0 | Filial Ctr. | R | S | |||||
| CND_NUMTIT | C | 9 | 0 | No. Titulo | @! | R | S | ||||
| CND_VLLIQD | N | 16 | 2 | Vlr. Liquido | @E 9,999,999,999,999.99 | CnCNDTotVl() | R | S | |||
| CND_SITUAC | C | 2 | 0 | Sit. Medicao | @! | R | S | ||||
| CND_REVGER | C | 3 | 0 | Rev. Gerador | @! | S | |||||
| CND_ULTMED | D | 8 | 0 | Ult. Med. | R | S | |||||
| CND_RECMED | C | 6 | 0 | Nr. Ult. Med | R | S | |||||
| CND_VLMULT | N | 16 | 2 | Vlr. Multa | @E 9,999,999,999,999.99 | CnCNDTotVl() | R | S | |||
| CND_VLBONI | N | 16 | 2 | Vlr. Bonif | @E 9,999,999,999,999.99 | CnCNDTotVl() | R | S | |||