View: dbo.Payable_Transaction_Template_View
View definition
CREATE VIEW dbo.Payable_Transaction_Template_View
AS
SELECT
ptt.transaction_template_KEY,
ptt.vendor_KEY,
ptt.payable__gl_account_KEY,
ptt.payable_transaction_type_KEY,
ptt.reference_number,
ptt.purchase_order_number,
ptt.vendor__contact_address_type_KEY,
ptt.payment_term_KEY,
ptt.not_eligible_for_discount_allowed_amount,
ptt.memo,
ptt.description,
ptt.transaction_status_KEY,
pttd.amount,
pttd.discount_allowed_amount
FROM
dbo.Payable_Transaction_Template as ptt
INNER JOIN
(
SELECT
transaction_template_KEY,
cast(sum(amount) as decimal(17, 2)) as amount,
cast(sum(discount_allowed_amount) as decimal(17, 2)) as discount_allowed_amount
FROM
dbo.Payable_Transaction_Template_Distribution
GROUP BY
transaction_template_KEY
) AS pttd
ON ptt.transaction_template_KEY = pttd.transaction_template_KEY;