declare@StoType_in nvarchar(10)
_declare@StoType_out nvarchar(10)
if @object_type = '59'
begin
if @transaction_type = 'A'
begin
_select@StoType_in=U_StoType from OIGN T0 INNER JOIN IGN1 T1 ON T0.DocNum=T1.DocEntry where T0.DocNum=@list_of_cols_val_tab_del and T1.BaseType=-1
begin
if @StoType_in is null or @StoType_in=''
begin
_select@error = 1
_select@error_message = N'必须录入库存收货类型' end
end
end
end
else if @object_type = '60'
begin
if @transaction_type = 'A'
begin
_select@StoType_out=U_StoType from OIGE T2 INNER JOIN IGN1 T3 ON T2.DocNum=T3.DocEntry where T2.DocNum=@list_of_cols_val_tab_del and T3.BaseType=-1
begin
if @StoType_out is null or @StoType_out=''
begin
_select@error = 1
_select@error_message = N'必须录入库存发货类型'
end
end
end
end
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23503339/viewspace-678459/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23503339/viewspace-678459/