?? view_mis_gr_list.sql
字號:
if object_id('dbo.View_MIS_GR_List') is not null
drop view dbo.View_MIS_GR_List
go
create view View_MIS_GR_List
as
select
distinct
b.lotno ,
b.single_no as GR_DocNo,
a.pono as Order_Number,
b.vdr_no as Vendor_ID,
b.dnno as DN_Number,
a.Itemno as HPN,
b.Model,
a.Unit as UoM,
b.Invoice_no as Invoice_No,
a.Recdepot as Warehouse,
a.Rec_qty as Rcv_Qty,
a.Real_Qty as Actual_Qty,
a.Scrap_Qty as Scrap_Qty,
a.short_Qty as Short_Qty,
a.Rej_Qty as Return_Qty,
b.rec_date as gr_dt,
b.Fir_oper as Created_by,
b.Fir_date as Creation_dt
from dpt_gtrc a,dpt_gtr b where a.single_id = b.single_id and che=1
go
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -