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