SELECT
[v_docRowsExpl].[IdxRigheFatt] AS [IdxRigheFatt],
[v_docRowsExpl].[IdxFatt] AS [IdxFatt],
[v_docRowsExpl].[idxDoc] AS [idxDoc],
[v_docRowsExpl].[Descrizione] AS [Descrizione],
[v_docRowsExpl].[um] AS [um],
[v_docRowsExpl].[prezzoUm] AS [prezzoUm],
[v_docRowsExpl].[qta] AS [qta],
[v_docRowsExpl].[sconto] AS [sconto],
[v_docRowsExpl].[c_iva] AS [c_iva],
[v_docRowsExpl].[no_ritenuta] AS [no_ritenuta],
[v_docRowsExpl].[iva] AS [iva],
[v_docRowsExpl].[netto] AS [netto],
[v_docRowsExpl].[quotaIva] AS [quotaIva],
[v_docRowsExpl].[importo] AS [importo]
FROM [dbo].[v_docRowsExpl] AS [v_docRowsExpl]
SELECT
[v_docsExpl].[idxDoc] AS [idxDoc],
[v_docsExpl].[emesso] AS [emesso],
[v_docsExpl].[Gruppo] AS [Gruppo],
[v_docsExpl].[RagSoc] AS [RagSoc],
[v_docsExpl].[indirizzo] AS [indirizzo],
[v_docsExpl].[localita] AS [localita],
[v_docsExpl].[Cap] AS [Cap],
[v_docsExpl].[prov] AS [prov],
[v_docsExpl].[CF] AS [CF],
[v_docsExpl].[pIva] AS [pIva],
[v_docsExpl].[num] AS [num],
[v_docsExpl].[anno] AS [anno],
[v_docsExpl].[Trim] AS [Trim],
[v_docsExpl].[Mese] AS [Mese],
[v_docsExpl].[netto] AS [netto],
[v_docsExpl].[iva] AS [iva],
[v_docsExpl].[importo] AS [importo],
[v_docsExpl].[tipo] AS [tipo],
[v_docsExpl].[idxCli] AS [idxCli],
[v_docsExpl].[totPagato] AS [totPagato],
[v_docsExpl].[totScadenze] AS [totScadenze],
[v_docsExpl].[Descrizione] AS [Descrizione],
[v_docsExpl].[ritenuta] AS [ritenuta],
[v_docsExpl].[CostiAss] AS [CostiAss],
[v_docsExpl].[Pagamento] AS [Pagamento],
[v_docsExpl].[Note] AS [Note]
FROM [dbo].[v_docsExpl] AS [v_docsExpl]
SELECT
[v_DocTemplate].[idxDoc] AS [idxDoc],
[v_DocTemplate].[emesso] AS [emesso],
[v_DocTemplate].[Gruppo] AS [Gruppo],
[v_DocTemplate].[RagSoc] AS [RagSoc],
[v_DocTemplate].[num] AS [num],
[v_DocTemplate].[anno] AS [anno],
[v_DocTemplate].[Trim] AS [Trim],
[v_DocTemplate].[Mese] AS [Mese],
[v_DocTemplate].[netto] AS [netto],
[v_DocTemplate].[iva] AS [iva],
[v_DocTemplate].[importo] AS [importo],
[v_DocTemplate].[tipo] AS [tipo],
[v_DocTemplate].[idxCli] AS [idxCli],
[v_DocTemplate].[totPagato] AS [totPagato],
[v_DocTemplate].[totScadenze] AS [totScadenze],
[v_DocTemplate].[Descrizione] AS [Descrizione],
[v_DocTemplate].[ritenuta] AS [ritenuta],
[v_DocTemplate].[CostiAss] AS [CostiAss]
FROM [dbo].[v_DocTemplate] AS [v_DocTemplate]
SELECT
[v_resGiorn].[anno] AS [anno],
[v_resGiorn].[mese] AS [mese],
[v_resGiorn].[giorno] AS [giorno],
[v_resGiorn].[numDoc] AS [numDoc],
[v_resGiorn].[totNetto] AS [totNetto],
[v_resGiorn].[totIva] AS [totIva],
[v_resGiorn].[totImporto] AS [totImporto]
FROM [dbo].[v_resGiorn] AS [v_resGiorn]
SELECT
[v_resMens].[anno] AS [anno],
[v_resMens].[mese] AS [mese],
[v_resMens].[numDoc] AS [numDoc],
[v_resMens].[totNetto] AS [totNetto],
[v_resMens].[totIva] AS [totIva],
[v_resMens].[totImporto] AS [totImporto]
FROM [dbo].[v_resMens] AS [v_resMens]
SELECT
[v_ResocontoIvaFatt].[RN] AS [RN],
[v_ResocontoIvaFatt].[Idxfatt] AS [Idxfatt],
[v_ResocontoIvaFatt].[iva] AS [iva],
[v_ResocontoIvaFatt].[imponibile] AS [imponibile],
[v_ResocontoIvaFatt].[imposta] AS [imposta],
[v_ResocontoIvaFatt].[totale] AS [totale]
FROM [dbo].[v_ResocontoIvaFatt] AS [v_ResocontoIvaFatt]
SELECT
[v_RowTemplate].[IdxRigheFatt] AS [IdxRigheFatt],
[v_RowTemplate].[importo] AS [importo],
[v_RowTemplate].[netto] AS [netto],
[v_RowTemplate].[iva] AS [iva],
[v_RowTemplate].[Descrizione] AS [Descrizione]
FROM [dbo].[v_RowTemplate] AS [v_RowTemplate]