Tabela NC0 - Relac. Embarque x Prov. Invoic
Chave Unica: NC0_FILIAL + NC0_IEMB + NC0_CODINV + NC0_CODCTR + NC0_ITEMPE + NC0_ITEMRF + NC0_ITEMPF
Modo: E
Modo Unid.: E
Modo Empr.: E
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 |