View: dbo.Payable_Transaction_Distribution_View
View definition
CREATE VIEW [dbo].[Payable_Transaction_Distribution_View]
AS
SELECT
payable_transaction_distribution_KEY,
payable_transaction_KEY,
gl_account_KEY,
description,
amount,
sequence_number,
is_dedicated_discount_distribution,
first__w2_1099_box_type_KEY,
second__w2_1099_box_type_KEY,
note,
discount_allowed_amount_override,
discount_allowed_amount_original,
discount_allowed_amount = ISNULL(discount_allowed_amount_override, discount_allowed_amount_original)
FROM
dbo.Payable_Transaction_Distribution