Tabela DFP - ITENS DOC.TRANSP.X DOC.SAIDA
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| DFP_FILIAL | Filial | Filial do Sistema | C | Real | 2 |
| DFP_DOCDCT | Doc.Transp. | No.Documento Transporte | C | Real | 9 |
| DFP_SERDCT | Ser.Dc.Tran. | Serie Documento Transport | C | Real | 3 |
| DFP_ITEM | Item | Item | C | Real | 2 |
| DFP_FILDCS | Fil.Dc.Saida | Filial Documento Saida | C | Real | 2 |
| DFP_DOCDCS | Doc.Saida | No.Documento Saida | C | Real | 9 |
| DFP_SERDCS | Ser.Dc.Saida | Serie Documento Saida | C | Real | 3 |
| DFP_CODCLI | Cod.Cliente | Codigo do Cliente | C | Virtual | 6 |
| DFP_LOJCLI | Loja Cliente | Loja do Cliente | C | Virtual | 2 |
| DFP_NOMCLI | Nome Cliente | Nome do Cliente | C | Virtual | 40 |
| DFP_FORNEC | Fornecedor | Codigo do Fornecedor | C | Real | 6 |
| DFP_LOJFOR | Loja | Loja do Fornecedor | C | Real | 2 |
| DFP_VALFRE | Vl.Frete | Valor do Frete | N | Real | 14, 2 |
| DFP_SDOCS | Ser.Dc.Saida | Serie Documento Saida | C | Real | 3 |
| DFP_SDOCT | Ser.Dc.Tran. | Serie Documento Transport | C | Real | 3 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | DFP_FILIAL + DFP_DOCDCT + DFP_SERDCT + DFP_FORNEC + DFP_LOJFOR + DFP_ITEM | Doc.Transp. + Ser.Dc.Tran. + Fornecedor + Loja + Item | |
| 2 | DFP_FILIAL + DFP_DOCDCT + DFP_SERDCT + DFP_FORNEC + DFP_LOJFOR + DFP_FILDCS + DFP_DOCDCS + DFP_SERDCS | Doc.Transp. + Ser.Dc.Tran. + Fornecedor + Loja + Fil.Dc.Saida + Doc.Sa | |
| 3 | DFP_FILIAL + DFP_DOCDCT + DFP_SDOCT + DFP_FORNEC + DFP_LOJFOR + DFP_ITEM | Doc.Transp. + Ser.Dc.Tran. + Fornecedor + Loja + Item | |
| 4 | DFP_FILIAL + DFP_DOCDCT + DFP_SDOCT + DFP_FORNEC + DFP_LOJFOR + DFP_FILDCS + DFP_DOCDCS + DFP_SDOCS | Doc.Transp. + Ser.Dc.Tran. + Fornecedor + Loja + Fil.Dc.Saida + Doc.Sa |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| SF2 (Cabecalho das NF de Saida) | DFP (ITENS DOC.TRANSP.X DOC.SAIDA) | F2_DOC + F2_SERIE + F2_CLIENTE + F2_LOJA | DFP_DOCDCS + DFP_SERDCS + DFP_FORNEC + DFP_LOJFOR | 1 para N |