Tabela ND1 - Fixacao X Previsao
Chave Unica: ND1_FILIAL + ND1_CODCTR + ND1_ITEMPE + ND1_ITEMRF + ND1_SEQCP + ND1_SEQPF + ND1_SEQN9J + ND1_SEQ
Modo: E
Modo Unid.: E
Modo Empr.: E
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| ND1_FILIAL | Filial | Filial do Sistema | C | Real | 2 |
| ND1_CODCTR | Contrato | Contrato | C | Real | 6 |
| ND1_ITEMPE | Seq.Prev.Ent | Seq. Previsao de Entrega | C | Real | 3 |
| ND1_ITEMRF | Seq.Reg.Fis | Seq. Regra Fiscal | C | Real | 3 |
| ND1_SEQCP | Seq.Cond.Pgt | Seq. Condicao Pagamento | C | Real | 2 |
| ND1_SEQPF | Seq.Prev.Fin | Sequencia Prev. Financ. | C | Real | 3 |
| ND1_SEQN9J | Seq. N9J | Seq. N9J | C | Real | 3 |
| ND1_SEQ | Sequencia | Sequencia | C | Real | 3 |
| ND1_ITEMFX | Item fixacao | Item da fixacao | C | Real | 3 |
| ND1_VLUFIX | Vlr. Fixacao | Vlr. da Fixacao | N | Real | 14, 6 |
| ND1_VLUFAT | Vlr. Faturam | Valor do Faturamento | N | Real | 14, 6 |
| ND1_VLUFIN | Vlr. Fin | Valor Financeiro | N | Real | 14, 6 |
| ND1_VLUDEM | Vlr. Demonst | Valor Demonstrativo | N | Real | 14, 6 |
| ND1_VLUDES | Vlr. Un.Desp | Vlr Unitario Despesas | N | Real | 14, 6 |
| ND1_MOEDA | Moeda | Moeda | N | Real | 2 |
| ND1_VLTAXA | Vlr. Taxa | Valor da Taxa | N | Real | 14, 6 |
| ND1_DTTAX | Data Cotacao | Data da Cotacao | D | Real | 8 |
| ND1_QTDE | Quantidade | Quantidade | N | Real | 12, 2 |
| ND1_DTVCTO | Dt. Vcto | Data de Vencimento | D | Real | 8 |
| ND1_TIPPRC | Tipo Preco | Tipo de Preco | C | Real | 10 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | ND1_FILIAL + ND1_CODCTR + ND1_ITEMPE + ND1_ITEMRF + ND1_SEQCP + ND1_SEQPF + ND1_SEQN9J + ND1_SEQ | Contrato + Seq.Prev.Ent + Seq.Reg.Fis + Seq.Cond.Pgt + Seq.Prev.Fin + | |
| 2 | ND1_FILIAL + ND1_CODCTR + ND1_ITEMPE + ND1_ITEMRF + ND1_SEQCP + ND1_SEQPF + ND1_SEQN9J + ND1_ITEMFX | Contrato + Seq.Prev.Ent + Seq.Reg.Fis + Seq.Cond.Pgt + Seq.Prev.Fin + |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| N9J (Relacionamento Regra fiscal x) | ND1 (Fixacao X Previsao) | N9J_CODCTR + N9J_ITEMPE + N9J_ITEMRF + N9J_SEQCP + N9J_SEQPF + N9J_SEQ | ND1_CODCTR + ND1_ITEMPE + ND1_ITEMRF + ND1_SEQCP + ND1_SEQPF + ND1_SEQN9J | 1 para N |
| NJR (Contratos) | ND1 (Fixacao X Previsao) | NJR_CODCTR | ND1_CODCTR | 1 para N |