View: dbo.Tax_Processing_Note_View
View definition
create view dbo.Tax_Processing_Note_View
as
select
tax_processing_note_KEY = PN.processing_note_KEY,
client_KEY = PN.client_KEY,
note = PN.note,
created_date = PN.created_date,
created_date__staff_KEY = PN.created_date__staff_KEY,
edited_date = PN.edited_date,
edited_date__staff_KEY = PN.edited_date__staff_KEY,
processing_note_category_KEY = PN.processing_note_category_KEY,
engagement_item_note_KEY = PN.engagement_item_note_KEY,
processing_note_type_KEY = PN.processing_note_type_KEY,
sequence_number = PN.sequence_number
from
dbo.Processing_Note as PN
where
PN.processing_note_type_KEY = 3