SELECT dbo.MA_JournalEntries.PostingDate AS DATAREGISTRAZIONE,
dbo.MA_JournalEntries.DocumentDate AS DATADOCUMENTO,
dbo.MA_JournalEntries.DocNo AS NUMERODOCUMENTO,
dbo.MA_AccountingReasons.Description AS DESCRIZIONEMOVIMENTO,
dbo.MA_JournalEntriesGLDetail.AmountType AS TIPOAMOUNT,
dbo.MA_JournalEntriesGLDetail.Account AS CONTO,
dbo.MA_JournalEntriesGLDetail.Amount,
dbo.MA_JournalEntries.Currency,
dbo.MA_JournalEntriesGLDetail.FixingDate, dbo.MA_JournalEntriesGLDetail.Fixing,
CASE WHEN MA_JournalEntriesGLDetail.DebitCreditSign = '4980736' THEN 'DARE' ELSE 'AVERE' END AS [DARE/AVERE],
dbo.MA_JournalEntriesGLDetail.CustSupp AS [IDCLIENTE/FORNITORE],
MA_JournalEntriesGLDetail.CustSuppType AS TIPO,
dbo.MA_CustSupp.CompanyName AS RAGIONESOCIALE,
dbo.MA_JournalEntriesGLDetail.JournalEntryId,
dbo.MA_JournalEntriesGLDetail.OffsetGroupNo
FROM dbo.MA_JournalEntries INNER JOIN
dbo.MA_JournalEntriesGLDetail ON dbo.MA_JournalEntries.JournalEntryId = dbo.MA_JournalEntriesGLDetail.JournalEntryId LEFT OUTER JOIN
dbo.MA_AccountingReasons ON dbo.MA_AccountingReasons.Reason = dbo.MA_JournalEntriesGLDetail.AccRsn LEFT OUTER JOIN
dbo.MA_CustSupp ON dbo.MA_CustSupp.CustSupp = dbo.MA_JournalEntriesGLDetail.CustSupp AND
dbo.MA_CustSupp.CustSuppType = dbo.MA_JournalEntriesGLDetail.CustSuppType
ORDER BY DATAREGISTRAZIONE DESC

Questa è la select che genera la View, ci sono numero documento e ragione sociale, e il risultato è quella tabellina che ho postato prima, piu logicamente tutto gli altri campi.