View: dbo.AR_Transaction_Full_View
View definition
-- Create a view for surfacing basic AR Transaction info in one view.
-- This is to be used mostly by filters to simplify how they will work with the data.
CREATE VIEW dbo.AR_Transaction_Full_View
as
(
SELECT
gl_transaction_KEY = ARTV.gl_transaction_KEY,
client_KEY = Cu.client_KEY,
customer_KEY = ARTV.customer_KEY,
journal_KEY = GLT.journal_KEY,
payment_term_KEY = ARTV.payment_term_KEY,
purchase_order_number = ARTV.purchase_order_number,
gl_account_KEY = ARTV.gl_account_KEY,
reference_number = ARTV.reference_number,
amount = ARTV.amount,
due_date = ARTV.due_date,
transaction_date = ARTV.transaction_date
FROM dbo.AR_Transaction_View ARTV
INNER JOIN dbo.Customer AS Cu
ON ARTV.customer_KEY = Cu.customer_KEY
INNER JOIN dbo.GL_Transaction AS GLT
ON ARTV.gl_transaction_KEY = GLT.gl_transaction_KEY
)