| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CXN | Planilha Med. de Contratos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CXN_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CXN_CHECK | L | 1 | 0 | Selecionado | R | S | |||||
| CXN_CONTRA | C | 15 | 0 | Nr. Contrato | @! | ExistCpo("CN9") .AND. CN200VldCon() | R | S | |||
| CXN_REVISA | C | 3 | 0 | Revisao | @! | (Vazio().Or.ExistCpo('CN9',FwFldGet("CXN_CONTRA")+FwFldGet("CXN_REVISA"))) .And. CN200VldCon() | R | S | |||
| CXN_NUMMED | C | 6 | 0 | Nr. Medicao | @! | R | S | ||||
| CXN_NUMPLA | C | 6 | 0 | Nr. Planilha | @! | ExistChav("CXN",FwFldGet("CXN_CONTRA")+FwFldGet("CXN_REVISA")+FwFldGet("CXN_NUMERO")) | R | S | |||
| CXN_TIPPLA | C | 3 | 0 | Tp. Plan. | @! | ExistCpo("CNL") | R | S | |||
| CXN_DESCRI | C | 30 | 0 | Desc. Plan. | V | S | |||||
| CXN_CRONOG | C | 6 | 0 | Cronograma | @! | R | S | ||||
| CXN_CRONCT | C | 6 | 0 | Cron. Contab | @! | R | S | ||||
| CXN_PARCEL | C | 2 | 0 | Parcela | @! | CN121VParc() | CNFPAR | R | S | ||
| CXN_DTINI | D | 8 | 0 | Data Inicial | R | S | |||||
| CXN_FORNEC | C | 6 | 0 | Fornecedor | @! | Cn121VldFC(a,b,c) | R | S | |||
| CXN_CLIENT | C | 6 | 0 | Cliente | @! | Cn121VldFC(a,b,c) | R | S | |||
| CXN_DTFIM | D | 8 | 0 | Data Final | R | S | |||||
| CXN_LJFORN | C | 2 | 0 | Loja Fornec. | @! | Cn121VldFC(a,b,c) | R | S | |||
| CXN_LJCLI | C | 2 | 0 | Loja Cliente | @! | Cn121VldFC(a,b,c) | R | S | |||
| CXN_DTMXMD | D | 8 | 0 | Data Max Med | R | S | |||||
| CXN_VLSALD | N | 16 | 2 | Saldo | @E 9,999,999,999,999.99 | R | S | ||||
| CXN_VLPREV | N | 16 | 2 | Vlr. Prev | @E 9,999,999,999,999.99 | CnCXNTotVl() | R | S | |||
| CXN_VLMULT | N | 16 | 2 | Vlr. Multa | @E 9,999,999,999,999.99 | CnCXNTotVl() | R | S | |||
| CXN_VLLIQD | N | 16 | 2 | Vlr. Liquido | @E 9,999,999,999,999.99 | CnCXNTotVl() | R | S | |||
| CXN_VLBONI | N | 16 | 2 | Vlr. Bonif | @E 9,999,999,999,999.99 | CnCXNTotVl() | R | S | |||
| CXN_VLDESC | N | 16 | 2 | Vl. Desconto | @E 9,999,999,999,999.99 | CnCXNTotVl() | R | S | |||
| CXN_VLTOT | N | 16 | 2 | Vlr. Total | @E 9,999,999,999,999.99 | R | S | ||||
| CXN_VLCOMS | N | 16 | 2 | Vl. Comissao | @E 9,999,999,999,999.99 | R | S | ||||
| CXN_VLREAJ | N | 16 | 2 | Vl. Reajuste | @E 9,999,999,999,999.99 | R | S | ||||
| CXN_NUMTIT | C | 9 | 0 | Nr. Titulo | @! | R | S | ||||
| CXN_DTVENC | D | 8 | 0 | Vencimento | R | S | |||||
| CXN_VLRADI | N | 16 | 2 | Vlr. Adianta | @E 9,999,999,999,999.99 | CnCXNTotVl() | R | S | |||
| CXN_ZERO | C | 1 | 0 | Med. Zerada | @! | Pertence('01') | R | 0=Nao;1=Sim | CxnZeroWhe() | S | |