SBO二次开发.docVIP

SBO二次开发 set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER proc [dbo].[SBO_SP_TransactionNotification] @object_type nvarchar(20), -- SBO Object Type @transaction_type nchar(1), -- [A]dd, [U]pdate, [D]elete, [C]ancel, C[L]ose @num_of_cols_in_key int, @list_of_key_cols_tab_del nvarchar(255), @list_of_cols_val_tab_del nvarchar(255) AS begin -- Return values declare @error int -- Result (0 for no error) declare @error_message nvarchar (200) -- Error string to be displayed select @error = 0 select @error_message = NOk -------------------------------------------------------------------------------------------------------------------------------- declare @baseentry nvarchar(40) declare @baseline int declare @basetype int declare @itemcode nvarchar(40) declare @projectcode nvarchar(40) declare @u_ordernum nvarchar(40) ---12-08-20 update declare @u_sordertype nvarchar(200) declare @so nvarchar(40) declare @line nvarchar(40) declare @btype nvarchar(40) declare @utype nvarchar(40) declare @usign int declare @cardcodes nvarchar(40) declare @groupcode nvarchar(40) declare @WhsCode nvarchar(40) declare @FILLER nvarchar(40) declare @shipdate datetime declare @baseRef nvarchar(40) declare @ocrCode nvarChar(40) declare @sendType nvarchar(40) declare @receiptType nvarchar(40) declare @amount float declare @AcctCode nvarchar(40) declare @CogsAcct nvarchar(40) declare @price float declare @Quantity numeric(19, 6) declare @DocEntry nvarchar(40) declare @LineNum smallint declare @OPENQTY numeric(19, 6) declare @BaseOpnQty numeric(19, 6) declare @COMMENTS nvarchar (100) declare @DocStatus nvarchar(40) -- ADD YOUR CODE HERE --库存收货检查 2012-09-12 添加,入库金额不能为0 if((@object_type =N59 )and @transaction_type in (NA,U)) begin declare curDetail cursor for select price from IGN1 t0