
| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| NN8 | Fixacao do Contrato | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| NN8_FILIAL | C | 2 | 0 | Filial | S | ||||||
| NN8_CODCTR | C | 6 | 0 | Contrato | @! | ExistCpo('NJR') | NJR | R | S | ||
| NN8_ITEMFX | C | 3 | 0 | Fixacao | @! | ExistChav('NN8',M->NN8_CODCTR+M->NN8_ITEMFX) | R | S | |||
| NN8_TIPOFX | C | 1 | 0 | Tipo Fix. | Pertence('01') | R | 0=Prevista;1=Firme | S | |||
| NN8_STATUS | C | 1 | 0 | Status | Pertence('0123') | R | 0=Prevista;1=Aberta;2=Parcial;3=Fechada | S | |||
| NN8_DATA | D | 8 | 0 | Data | R | S | |||||
| NN8_DATINI | D | 8 | 0 | Dt.Ini.Ent. | R | S | |||||
| NN8_DATFIN | D | 8 | 0 | Dt.Fin.Ent. | R | S | |||||
| NN8_QTDFIX | N | 12 | 2 | Qtd. Fixada | @E 999,999,999.99 | Positivo() | R | S | |||
| NN8_QTDENT | N | 12 | 2 | Qtd.Entregue | @E 999,999,999.99 | Positivo() | R | S | |||
| NN8_QTENAF | N | 12 | 2 | Ent. a Fixar | @E 999,999,999.99 | Positivo() | R | S | |||
| NN8_QTDRES | N | 12 | 2 | Qtd. Reserva | @E 999,999,999.99 | R | S | ||||
| NN8_CODIDX | C | 15 | 0 | Indice | @! | ExistCpo('NK0') | NK0 | R | INCLUI | S | |
| NN8_MOEDA | N | 2 | 0 | Moeda | @E 99 | OGX010Moed(M->NN8_MOEDA) | R | Empty(FwFldGet('NN8_CODIDX')) | S | ||
| NN8_TXMOED | N | 10 | 6 | Tx. Moeda | @E 999.999999 | R | Empty(FwFldGet('NN8_CODIDX')).And.FwFldGet('NN8_MOEDA')<>1 | S | |||
| NN8_VLRUNI | N | 14 | 2 | Vlr. Un. Prc | @E 99,999,999,999.99 | R | S | ||||
| NN8_VALUNI | N | 14 | 2 | Val. Un. Fix | @E 99,999,999,999.99 | R | S | ||||
| NN8_VLRTOT | N | 14 | 2 | Vlr. Tot Prc | @E 99,999,999,999.99 | R | S | ||||
| NN8_VALTOT | N | 14 | 2 | Val. Tot Fix | @E 99,999,999,999.99 | R | S | ||||
| NN8_VLENT | N | 14 | 2 | Val. Tot. En | @E 99,999,999,999.99 | R | S | ||||
| NN8_VLRLIQ | N | 14 | 2 | Vlr. Liqu. | @E 99,999,999,999.99 | R | S | ||||
| NN8_VALLIQ | N | 14 | 2 | Val. Liqu. | @E 99,999,999,999.99 | R | S | ||||
| NN8_VALLQT | N | 14 | 2 | Total Fix.Lq | @E 99,999,999,999.99 | R | S | ||||
| NN8_QTDFIN | N | 12 | 2 | Qtd. Financ. | @E 999,999,999.99 | R | S | ||||
| NN8_VLRFIN | N | 12 | 2 | Val. Financ. | @E 999,999,999.99 | R | S | ||||
| NN8_VLRLQT | N | 14 | 2 | Vlr. Tot Liq | @E 99,999,999,999.99 | R | S | ||||
| NN8_FREFIN | N | 14 | 2 | Fre.Em.OP/OR | @E 99,999,999,999.99 | R | S | ||||
| NN8_SEGFIN | N | 14 | 2 | Seg.Em.OP/OR | @E 99,999,999,999.99 | R | S | ||||
| NN8_DSPFIN | N | 14 | 2 | DSP.Em.OP/OR | @E 99,999,999,999.99 | R | S | ||||
| NN8_DTPAGT | D | 8 | 0 | DT.Pagto.Prv | R | S | |||||
| NN8_DATREF | D | 8 | 0 | DT.REF.FIX | R | S | |||||
| NN8_CODCAD | C | 3 | 0 | Cadencia | @! | R | S | ||||
| NN8_CODNGC | C | 6 | 0 | Cod. Negocio | @! | R | S | ||||
| NN8_VERSAO | C | 3 | 0 | Versao | @! | R | S | ||||
| NN8_AGLUTI | C | 6 | 0 | Aglutinador | @! | R | S | ||||
| NN8_QTDAGL | N | 14 | 2 | Qtd. Aglutin | @E 99,999,999,999.99 | R | S | ||||
| NN8_TIPAGL | C | 1 | 0 | Tp. Algutina | @! | R | 0=Nao;1=Sim | S | |||