| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CN8 | Caucoes | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CN8_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CN8_CODIGO | C | 15 | 0 | Codigo | @! | ExistChav("CN8") | R | S | |||
| CN8_TPCAUC | C | 3 | 0 | Tipo Caucao | @! | ExistCpo("CN3") | CN3 | R | S | ||
| CN8_DESCAU | C | 30 | 0 | Desc Tipo | @! | V | S | ||||
| CN8_CONTRA | C | 15 | 0 | Num.Contrato | @! | ExistCpo("CN9") .And. CN090VldCon() | CN9002 | R | S | ||
| CN8_REVISA | C | 3 | 0 | Revisao | @! | ExistCpo("CN9",M->CN8_CONTRA+M->CN8_REVISA) .And. CN090VldCon() | R | S | |||
| CN8_FORNEC | C | 6 | 0 | Cod.Fornec. | @! | ExistCpo("SA2",M->CN8_FORNEC+M->CN8_LOJA) | CNC001 | R | Empty(M->CN8_CLIENT) | S | |
| CN8_LOJA | C | 2 | 0 | Loja Fornec. | @! | ExistCpo("SA2",M->CN8_FORNEC+M->CN8_LOJA,1) | R | Empty(M->CN8_CLIENT) | S | ||
| CN8_NOME | C | 40 | 0 | Nome | @! | V | S | ||||
| CN8_CLIENT | C | 6 | 0 | Cliente | @! | ExistCpo("SA1",M->CN8_CLIENT+M->CN8_LOJACL) | CNC001 | R | Empty(M->CN8_FORNEC) | S | |
| CN8_LOJACL | C | 2 | 0 | Lj. Cliente | @! | ExistCpo("SA1",M->CN8_CLIENT+M->CN8_LOJACL) | R | Empty(M->CN8_FORNEC) | S | ||
| CN8_NOMCLI | C | 40 | 0 | Nom. Cliente | @! | V | S | ||||
| CN8_NUMDOC | C | 15 | 0 | Documento | @! | R | S | ||||
| CN8_DTENT | D | 8 | 0 | Data Entrega | CN090VldDEn() | R | S | ||||
| CN8_DTINVI | D | 8 | 0 | Data Inicio | CN090VldDIn() | R | S | ||||
| CN8_DTFIVI | D | 8 | 0 | Data Fim | CN090VldDTr() | R | S | ||||
| CN8_BANCO | C | 3 | 0 | Banco | @! | ExistCpo("SA6") | SA6 | R | S | ||
| CN8_AGENCI | C | 5 | 0 | Agencia | @! | R | S | ||||
| CN8_CONTA | C | 10 | 0 | Conta | @! | R | S | ||||
| CN8_DTBX | D | 8 | 0 | Data Baixa | R | S | |||||
| CN8_VLBX | N | 12 | 2 | Vlr. Baixa | @E 9999,999,999.99 | R | S | ||||
| CN8_CORREC | C | 1 | 0 | Correcao ? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| CN8_INDREJ | C | 3 | 0 | Indice Reaj. | @! | V | S | ||||
| CN8_OBSERV | C | 254 | 0 | Observacoes | @! | R | S | ||||
| CN8_VLEFET | N | 12 | 2 | Vlr.Efetivo | @E 999,999,999.99 | Positivo() | R | S | |||
| CN8_EMITEN | C | 30 | 0 | Emitente | @! | R | S | ||||
| CN8_SALDO | N | 16 | 2 | Saldo | @E 9,999,999,999,999.99 | R | S | ||||
| CN8_TPABAT | C | 1 | 0 | Tipo Abat. | @! | Pertence("12") | R | 1=Caucao;2=Titulo | S | ||
| CN8_PERCAB | N | 5 | 2 | % Abatimento | @E 99.99 | Positivo() | R | S | |||
| CN8_VLRRET | N | 12 | 2 | Vlr.Retencao | @E 999,999,999.99 | R | S | ||||
| CN8_TROCAD | C | 15 | 0 | Troca Dest. | @! | R | S | ||||
| CN8_TROCAO | C | 15 | 0 | Troca Origem | @! | R | S | ||||
| CN8_MOEDA | N | 2 | 0 | Moeda | M->CN8_MOEDA <= MoedFin().And. M->CN8_MOEDA <> 0 .And. CN090DescMoed() | R | S | ||||
| CN8_DESCMO | C | 30 | 0 | Descr Moeda | R | S | |||||
| CN8_DIACTB | C | 2 | 0 | Cod Diario | @! | ExistCPO("CVL") | CVL | S | |||
| CN8_NODIA | C | 10 | 0 | Seq. Diario | @! | S | |||||
| CN8_TPDOC | C | 2 | 0 | Tipo do Doc. | @! | ExistCpo("FKB", M->CN8_TPDOC) | FKB | R | S | ||
| CN8_REVGER | C | 3 | 0 | Rev. Gerador | @! | R | S | ||||