限制生产订单抬头的销售订单、实际开始日期、实际完工日期、供应商(委外)等字段必填
----生产订单:产订单抬头的销售订单、实际开始日期、实际完工日期、供应商(委外)等字段必填
IF @object_type = '202'
BEGIN
IF @transaction_type = 'A'
OR @transaction_type = 'U'
BEGIN
IF EXISTS (
SELECT T0.[OriginNum]
FROM OWOR T0
WHERE T0.Status = 'R'
AND T0.[OriginNum] IS NULL
AND T0.DocEntry = @list_of_cols_val_tab_del
)
BEGIN
SET @error = 20201;
SET @error_message = N'生产订单抬头的销售订单字段不能为空!!!';
END;
BEGIN
IF EXISTS (
SELECT T0.[U_VendorCode]
FROM OWOR T0
WHERE T0.[Status] = 'R'
AND T0.[U_VendorCode] IS NULL
AND T0.DocEntry = @list_of_cols_val_tab_del
)
BEGIN
SET @error = 20202;
SET @error_message = N'生产订单抬头的委外供应商字段不能为空!!!';
END;
END;
END;
END
声明:欢迎来到五六零学院。