Account Transactions Report with Manual Payments applied to Purchase Invoices

In this Post i'm sharing a view regarding the Smartlist report of Account Transaction as i linked this view with another tables to get the Manual Payments that are applied to purchase invoices.
this view contains the work and history tables.
you will find the invoice number, date and the applied amount.



USE [Company_NAME]
GO

/****** Object:  View [dbo].[_AccountTransactionsVSPayementsAndInvoices_AK]    Script Date: 5/21/2018 10:45:50 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO




CREATE VIEW [dbo].[_AccountTransactionsVSPayementsAndInvoices_AK] AS

select AccountTransactions.* ,  PM20100.APTVCHNM , PM20100.DOCDATE , PM20100.APTODCNM , PM20100.APPLDAMT , PM20100.APTODCDT
from AccountTransactions as AccountTransactions left join PM20100 as PM20100
on AccountTransactions.[Originating Control Number] = PM20100.VCHRNMBR
--where AccountTransactions.[Originating Control Number]='00000000000001094'
union all
select AccountTransactions.* ,  PM30300.APTVCHNM , PM30300.DOCDATE , PM30300.APTODCNM , PM30300.APPLDAMT , PM30300.APTODCDT
from AccountTransactions as AccountTransactions left join PM30300 as PM30300
on AccountTransactions.[Originating Control Number] = PM30300.VCHRNMBR
--where AccountTransactions.[Originating Control Number]='00000000000002380'




GO

Best Regards,