| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CN1 | Tipos de Contrato | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CN1_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CN1_CODIGO | C | 3 | 0 | Codigo | @! | ExistChav("CN1") | R | S | |||
| CN1_DESCRI | C | 30 | 0 | Descricao | @! | NaoVazio() | R | S | |||
| CN1_ESPCTR | C | 1 | 0 | Esp. Contrat | @! | Pertence("12") .AND. CN021GatPl("CN1_ESPCTR",FwFldGet("CN1_ESPCTR")) | R | 1=Compra;2=Venda | INCLUI | S | |
| CN1_MEDEVE | C | 1 | 0 | Med Eventual | Pertence("12") .AND. CN021GatPl("CN1_MEDEVE",FwFldGet("CN1_MEDEVE")) | R | 1=Sim;2=Nao | INCLUI | S | ||
| CN1_MEDAUT | C | 1 | 0 | Med. Automat | @! | Pertence("12") .AND. CN021GatPl("CN1_MEDAUT",FwFldGet("CN1_MEDAUT")) | R | 1=Sim;2=Nao | S | ||
| CN1_CTRFIX | C | 1 | 0 | Ctr. Fixo | @! | Pertence("123") .AND. CN021GatPl("CN1_CTRFIX",FwFldGet("CN1_CTRFIX")) | R | 1=Sim;2=Nao;3=Semi-Fixo | INCLUI .AND. (M->CN1_MEDEVE='1') .AND. (M->CN1_CROCTB='2') | S | |
| CN1_CROFIS | C | 1 | 0 | Cronog. Fis. | @! | Pertence("12") .AND. CN021GatPl("CN1_CROFIS",FwFldGet("CN1_CROFIS")) | R | 1=Sim;2=Nao | INCLUI | S | |
| CN1_VLRPRV | C | 1 | 0 | Previsao Fin | @! | Pertence('12') | R | 1=Sim;2=Nao | INCLUI .AND. (M->CN1_CTRFIX='2') | S | |
| CN1_CROCTB | C | 1 | 0 | Cronog. Cont | @! | Pertence("12") .AND. CN021GatPl("CN1_CROCTB",FwFldGet("CN1_CROCTB")) | R | 1=Sim;2=Nao | INCLUI | S | |
| CN1_TPMULT | C | 1 | 0 | Multa/Bonif. | @! | Pertence("12") | R | 1=Recebimento;2=Medicao | S | ||
| CN1_MULMAN | C | 1 | 0 | Mult. manual | @! | Pertence("1234") | R | 1=Nao permite;2=Multas;3=Bonificacoes;4=Ambos | S | ||
| CN1_LMTMED | N | 5 | 2 | Limite Med. | @E 99.99 | Positivo() | R | S | |||
| CN1_TPLMT | C | 1 | 0 | Tp. Limite | @! | Pertence("12") .AND. CN021GatPl("CN1_TPLMT" ,FwFldGet("CN1_TPLMT" )) | R | 1=Financeiro;2=Fisico | S | ||
| CN1_PRDALT | C | 3 | 0 | Dias / Aviso | 999 | CN021VldDt() | R | S | |||
| CN1_CTRDOC | C | 1 | 0 | Ctr. Dt.Doc. | @! | Pertence('12') | R | 1=Sim;2=Nao | S | ||
| CN1_CTRAPR | C | 1 | 0 | Ctrl. Aprov. | @! | Pertence("12") .AND. CN021GatPl("CN1_CTRAPR" ,FwFldGet("CN1_CTRAPR" )) | R | 1=Sim;2=Nao | S | ||
| CN1_GRPSIT | C | 6 | 0 | Grp.Apr Sit | @! | (Vazio() .OR. ExistCpo("SAL")) | SAL | R | M->CN1_CTRAPR == '1' .AND. (INCLUI .OR. ALTERA) | S | |
| CN1_DGRSIT | C | 20 | 0 | Desc.Apr Sit | @! | V | S | ||||
| CN1_GRPAPR | C | 6 | 0 | Grp. Apr Med | @! | (Vazio() .OR. ExistCpo("SAL")) | SAL | R | S | ||
| CN1_DESCAP | C | 20 | 0 | Desc.Apr Med | @! | V | S | ||||
| CN1_ALINSS | N | 6 | 2 | Aliq. INSS | @E 999.99 | Positivo() | R | S | |||
| CN1_ALQTIR | N | 6 | 2 | Aliq. IR | @E 999.99 | Positivo() | R | S | |||
| CN1_ALQPIS | N | 6 | 2 | Aliq. PIS | @E 999.99 | Positivo() | R | S | |||
| CN1_ALCOFI | N | 6 | 2 | Aliq. COFINS | @E 999.99 | Positivo() | R | S | |||
| CN1_ALCSLL | N | 6 | 2 | Aliq. CSLL | @E 999.99 | Positivo() | R | S | |||
| CN1_CREALM | C | 1 | 0 | Realinha Med | Pertence("12").And.Cn021CReal() | R | 1=Sim;2=Nao | S | |||
| CN1_CREAJM | C | 1 | 0 | Reajusta Med | Pertence("12").And.Cn021CReaj() | R | 1=Sim;2=Nao | S | |||
| CN1_CTRMED | C | 1 | 0 | tIp.Ctrl.Med | @! | Pertence('12') | R | 1=Pedido;2=Duplicata | INCLUI | S | |
| CN1_ALCCTR | C | 1 | 0 | Alc. Contrat | @! | Pertence("0123") | R | 0=Todos;1=Documento;2=Ent. Contabil;3=Sem Aprovacao | S | ||
| CN1_TPSFIX | C | 1 | 0 | Semi-Fixo | Pertence("12") | R | 1=Por Produto;2=Por Agrupador | S | |||
| CN1_INTEGR | L | 1 | 0 | Integ. PIMS | CnPimsTpCt() | R | S | ||||