Tabela NC0 - Relac. Embarque x Prov. Invoic
Chave Unica: NC0_FILIAL + NC0_IEMB + NC0_CODINV + NC0_CODCTR + NC0_ITEMPE + NC0_ITEMRF + NC0_ITEMPF
Sumario:
Campos
Campo
| Titulo
| Descricao
| Tipo
| Contexto
| Tamanho
|
NC0_FILIAL |
Filial |
Filial |
C |
Real |
2 |
NC0_IEMB |
Instr. Embar |
Instrucao Embarque |
C |
Real |
30 |
NC0_ITEMPE |
Item Pre Ent |
Item Previsao Entrega |
C |
Real |
3 |
NC0_CODCTR |
Cod Contrato |
Codigo Contrato |
C |
Real |
6 |
NC0_ITEMRF |
Reg. Fiscal |
Regra Fiscal |
C |
Real |
3 |
NC0_CODINV |
Prov. Invoic |
Cod. Provisional Invoice |
C |
Real |
20 |
NC0_ITEMPF |
Item Prev.Fi |
Item Previsao Financeira |
C |
Real |
3 |
NC0_DATA |
Data Movto |
Data Movimento |
D |
Real |
8 |
NC0_VALOR |
Valor Movto |
Valor Movimento |
N |
Real |
16, 4 |
Indices
Ordem
| Chave
| Descricao
| Nickname
|
1 |
NC0_FILIAL + NC0_IEMB + NC0_CODINV + NC0_CODCTR + NC0_ITEMPE + NC0_ITEMRF + NC0_ITEMPF |
Instr. Embar + Prov. Invoic + Cod Contrato + Item Pre Ent + Reg. Fisca |
|
2 |
NC0_FILIAL + NC0_IEMB + NC0_CODCTR |
Instr. Embar + Cod Contrato |
|
Relacionamentos
Tabela Origem
| Tabela Destino
| Expressao Origem
| Expressao Destino
| Relacionamento
|
N7S (Instrucao Embarque x Regra Fis) |
NC0 (Relac. Embarque x Prov. Invoic) |
N7S_CODINE + N7S_CODCTR + N7S_ITEM + N7S_SEQPRI |
NC0_IEMB + NC0_CODCTR + NC0_ITEMPE + NC0_ITEMRF |
1 para 1 |
Tabelas do Protheus v4.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros