天心sunlike ERP采购缺货SQL

最新推荐文章于 2018-04-12 10:13:51 发布

hongyelwm

最新推荐文章于 2018-04-12 10:13:51 发布

阅读量596

点赞数

分类专栏：天心SUNLIKE 文章标签：天心SUNLIKE

本文链接：https://blog.csdn.net/hongyelwm/article/details/79898529

版权

ALTER PROCEDURE [dbo].[am_select_que_cg]
	-- @Param1 varchar(30), @Param2 int
AS
BEGIN
SELECT
SALM.NAME as SAL,
CONVERT(varchar(100),MF_POS.CLS_DATE, 23) as CLS_DATE,
CONVERT(varchar(100),TF_POS.EST_DD, 23) as EST_DD,
TF_POS.am_que,
TF_POS.am_msg,--缺货信息
TF_POS.am_sc as jiaoqi,--缺货交期
TF_POS.am_bian as bian,--供应商交期变更次数
TF_POS.am_bian_day as bian_day,--供应商交期

A.am_sc,
A.am_jihua,
A.PRD_NAME as am_cp,
A.OS_NO as am_os,
TF_POS.OS_ID,
--中类代号
PRDT.IDX1,
--中类名称
INDX.NAME as indxname,
-- 货品资料
PRDT.SPC,
--库存数据 
PRDT1.WH,
CAST(PRDT1.QTY AS INT) as KC,
--采购单数据
TF_POS.OS_NO,
TF_POS.QT_NO,
TF_POS.PRD_NO,
TF_POS.PRD_NAME,
CONVERT(varchar(100),TF_POS.OS_DD, 23) as OS_DD,
-- 数量
CAST(TF_POS.QTY AS int) as   QTY,
-- 进货单总数
CAST(TF_POS.QTY_PS AS int) as   QTY_PC,
-- 送货数量
CAST(TF_POS.QTY_RK AS int) as   QTY_TI,
-- 已验收累积数量
CAST(TF_POS.QTY_YS AS int) as   QTY_TY,
CUST.NAME AS CUST
from TF_POS 
/*厂商资料*/
LEFT JOIN MF_POS ON
M