dbo.vw_ms_manual_invoice_invoce_item_list

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_manual_invoice_invoce_item_list
---XencX---with encryption
as 
  
SELECT        
  dt_ms_manual_invoice_detail.ms_manual_invoice_detail_id
, dt_ms_item.part_no as int_part_no
, dt_ms_item.part_name as int_part_name
, dt_ms_item.ms_item_custom_no as int_ms_item_custom_no
, dt_ms_item.uom as int_uom
, dt_ms_manual_invoice_detail.part_no
, dt_ms_manual_invoice_detail.part_name
, dt_ms_manual_invoice_detail.kode_barang
, dt_ms_manual_invoice_detail.order_qty
, dt_ms_manual_invoice_detail.order_no
, dt_ms_manual_invoice_detail.order_date
, dt_ms_manual_invoice_detail.req_eta_date
, dt_ms_manual_invoice_detail.inv_qty
, dt_ms_manual_invoice_detail.rec_qty
, dt_ms_manual_invoice_detail.unit
, dt_ms_manual_invoice_detail.istatus
, dt_ms_manual_invoice_detail.price
, dt_ms_manual_invoice_detail.amount
, dt_ms_manual_invoice_detail.remark

, isnull(dt_ms_manual_invoice_detail.bruto,0) as bruto
, isnull(dt_ms_manual_invoice_detail.netto,0) as netto

, isnull(dt_ms_item.ms_item_id,0) as mapped
, dt_ms_manual_invoice_detail.mapping_ms_item_id
, dt_ms_manual_invoice_detail.mapping_date
, users_mapping.username as mapping_by
, dt_ms_manual_invoice_detail.create_date
, users_create.username AS create_by
, dt_ms_manual_invoice_detail.ms_manual_invoice_id
, dt_ms_manual_invoice.ms_manual_invoice_type_id

FROM            users AS users_create RIGHT OUTER JOIN
                         dt_ms_item RIGHT OUTER JOIN
                         dt_ms_manual_invoice INNER JOIN
                         dt_ms_manual_invoice_detail ON dt_ms_manual_invoice.ms_manual_invoice_id = dt_ms_manual_invoice_detail.ms_manual_invoice_id ON dt_ms_item.ms_item_id = dt_ms_manual_invoice_detail.mapping_ms_item_id ON 
                         users_create.id = dt_ms_manual_invoice_detail.create_by LEFT OUTER JOIN
                         users AS users_mapping ON dt_ms_manual_invoice_detail.mapping_by = users_mapping.id


GO