dbo.vw_ms_data_all_invoice

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_data_all_invoice
---XencX---with encryption
as 

SELECT        invoice_no, invoice_date, 'MOLTS' type_invoice 
FROM            dt_ms_molts_invoice
union all

SELECT        dt_ms_manual_invoice.invoice_no, dt_ms_manual_invoice.invoice_date , enum_ms_manual_invoice_type.ms_manual_invoice_type_name as type_invoice
FROM            dt_ms_manual_invoice INNER JOIN
                         enum_ms_manual_invoice_type ON dt_ms_manual_invoice.ms_manual_invoice_type_id = enum_ms_manual_invoice_type.ms_manual_invoice_type_id
GO