dbo.vw_ms_supplier_customer_for_molts

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

create view dbo.vw_ms_supplier_customer_for_molts
---XencX---with encryption
as  
  

SELECT        
  dt_ms_supplier_customer.ms_supplier_customer_id
, dt_ms_supplier_customer.supplier_customer_code
, dt_ms_supplier_customer.supplier_customer_name
, tblNegara.UrEdi AS supplier_customer_country_name
, isnull(vw_ms_molts_invoce_group_supplier.invoice_ready,0) as invoice_ready
, isnull(vw_ms_molts_invoce_group_supplier.invoice_total,0) as invoice_total
, dt_ms_supplier_customer.supplier_customer_address
, dt_ms_supplier_customer.supplier_customer_country 
FROM            vw_ms_molts_invoce_group_supplier RIGHT OUTER JOIN
                         dt_ms_supplier_customer ON vw_ms_molts_invoce_group_supplier.supplier_customer_id = dt_ms_supplier_customer.ms_supplier_customer_id LEFT OUTER JOIN
                         tblNegara ON dt_ms_supplier_customer.supplier_customer_country = tblNegara.KdEdi      
       
       
GO