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



Meglio ? scusate abitudine...