viw_po_mis_rcv_list.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 31 行

if object_id('dbo.PO_MIS_Rcv_List') is not null
drop view dbo.PO_MIS_Rcv_List
go




create view PO_MIS_Rcv_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