出入库单据查询语句.sql

来自「仓储系统」· SQL 代码 · 共 86 行

                  --------------出、入库单据查询-------需要显示的字段--------------
--采购入库单
select a.In_Bill as 入库单号,a.Pr_No as 合同编号,a.Plan_id as 计划编号,   
       a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,b.Mate_Type as 规格型号,  
       a.Gys as 供应商,a.Dept_id as 部门,a.In_Date as 入库日期,a.KfNo as 库房,a.KwNo as 库位,  
       a.In_Type as 入库类别,a.In_Amount as 入库数量,a.In_Price as 入库单价,a.In_Zj as 入库总价,   
       a.In_Post as 过帐标志,a.In_man as 经手人,a.Exam_man as 检验人,a.Oper_id as 制单人,a.Rk_memo as 备注 
       from mate_CgRk a      
       left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code

--自制入库单
select a.In_Bill as 入库单号,a.Pr_No as 合同编号,a.Plan_id as 计划编号,                
               a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,                          
               b.Mate_Type as 规格型号,b.Mate_Class as 物料类别,                         
               a.Gys as 供应商,a.Dept_id as 部门,a.KfNo as 库房,a.KwNo as 库位,          
               a.In_Date as 入库日期 ,a.In_Type as 入库类别,                             
               a.In_Price as 入库单价,a.In_Amount as 入库数量,a.In_Zj as 总价,a.In_Post as 过帐标志,  
               a.In_man as 经手人,a.Exam_man as 检验人,a.Oper_id as 制单人,a.Rk_memo as 备注          
         from Mate_ZzRk a                                                                        
         left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code

--成品入库单
select a.In_Bill as 入库单号,a.Plan_id as 计划编号,          
                a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,           
                b.Mate_Type as 规格型号,b.Mate_Class as 物料类别,          
                a.Dept_id as 部门,a.KfNo as 库房代码,a.KwNo as 库位代码,   
                a.In_Date as 入库日期 ,a.In_Type as 入库类别,              
                a.In_Price as 入库单价,a.In_Amount as 入库数量,            
                a.In_Zj as 总价,a.In_Post as 过帐标志,                     
                a.In_man as 经手人,a.Exam_man as 检验人,                   
                a.Oper_id as 制单人,a.Rk_memo as 备注                      
          from Product_Rk a                                            
          left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code
--退料入库单
select a.TL_Bill as 退料单号,a.Plan_id as 计划编号,                               
                a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,b.Mate_Type as 规格型号,   
                a.Dept_id as 部门,a.KfNo as 库房,a.KwNo as 库位,                          
                a.TL_Date as 退料日期,a.TL_Type as 入库类别,                              
                a.TL_Amount as 退料数量,a.TL_Price as 单价,                               
                a.TL_Zj as 总价,a.TL_Post as 过帐标志,                                    
                a.TL_man as 经手人,a.Audit_man as 审批人,a.Exam_man as 检验人,            
                a.Oper_id as 制单人,a.TL_memo as 备注                                     
         from TuiLiao_Rk a                                                               
         left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code
--成品出库单
select a.Out_Bill as 入库单号,a.Plan_id as 计划编号,
                a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,
                b.Mate_Type as 规格型号,b.Mate_Class as 物料类别,
                a.Cust_id as 客户代码,a.KfNo as 库房,a.KwNo as 库位,
                a.Out_Date as 出库日期,a.Out_Type as 出库类别,
                a.Out_Amount as 出库数量,a.Out_Price as 单价,
                a.Out_Zj as 总价,a.Out_Post as 过帐标志,
                a.Out_man 经手人,a.Exam_man as 检验人,
                a.Oper_id as 制单人,a.Ck_memo as 备注
          from Mate_Ck a
          left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code

--领用出库单
select a.Ly_Bill as 领用单号,a.Plan_id as 计划编号,
                a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,
                b.Mate_Type as 规格型号,b.Mate_Class as 物料类别,
                a.Dept_id as 部门,a.KfNo as 库房,KwNo as 库位,
                a.Out_Type as 出库类别,a.Out_Date as 出库日期,
                a.Out_Amount as 出库数量,a.Out_Price as 单价,
                a.Out_Zj as 总价,a.Out_Post as 过帐标志,
                a.Out_man as 经手人,a.Checker as 检验人,
                a.Oper_id as 制单人,a.Out_Memo as 备注
          from Mate_Ly a
          left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code

--报废出库单
select a.Bf_Bill as 报废单号,a.Plan_id as 计划编号,
                 a.Mate_Code as 物料编码,b.Mate_Name as 物料名称,
                 b.Mate_Type as 规格型号,b.Mate_Class as 物料类别,
                 a.Dept_id as 部门,a.KfNo as 库房,KwNo as 库位,
                 a.Out_Type as 出库类别,a.Out_Date as 出库日期,
                 a.Out_Amount as 出库数量,a.Out_Price as 单价,
                 a.Out_Zj as 总价,a.Out_Post as 过帐标志,
                 a.Checker as 审核人,a.Exam_man as 检验人,
                 a.Oper_id as 制单人,a.Out_Memo as 备注
           from mate_Bf a
           left outer join Mate_Basic b on a.Mate_Code=b.Mate_Code