View: dbo.Payable_Transaction_View
View definition
CREATE VIEW dbo.Payable_Transaction_View
AS
SELECT PT.*,
funding_processed_status_filter_type_KEY = (
CASE
WHEN PT.funding_processed_status_KEY IN (1, 2) THEN 2 -- Pending
WHEN PT.funding_processed_status_KEY = 3 THEN 3 -- Funded
WHEN PT.funding_processed_status_KEY = 4 THEN 4 -- Not Applicable
ELSE 10 -- Invalid funding_processed_status_KEY
END
)
FROM
dbo.Payable_Transaction PT