Tabela ND1 - Fixacao X Previsao

Chave Unica: ND1_FILIAL + ND1_CODCTR + ND1_ITEMPE + ND1_ITEMRF + ND1_SEQCP + ND1_SEQPF + ND1_SEQN9J + ND1_SEQ


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
Tabelas do Protheus v4.2 (baseado no P12.1.33) - 08/10/2021 - 10.106 tabelas e 10.324 parametros