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 ) | |||