清库（Clear storehouse）.docVIP

清库（Clear storehouse） Qing library.Txt love is a very tough word. The upper half of it is taken from abnormal, and the lower half is taken from the abnormal state. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER PROCEDURE Indi_p_DetailPBill @s_UserID varchar (30) -- User @s_BillObjID varchar (16) - document number AS ----------------------------------------- - Last Update: 2007-02-05 -- inquire about the detailed records of an index document - to increase the nature of the funds, the classification of the economy, and whether they are confidential - increasing the type of automatic receipt, the unit of collection - modify security permissions and filter conditions - increase the reported amount field ----------------------------------------- DECLARE @s_IndiObjID varchar (16) DECLARE @s_LayDesID varchar (1) DECLARE @s_BillTypeID varchar (16) - index document type DECLARE, @s_OpeUserID, varchar (30) -- single person DECLARE @s_AuthFlag varchar (1) DECLARE, @s_AuditState, varchar (1), @s_BillDate, varchar (50) DECLARE, @s_PlanUseIndi, varchar (5), @s_HasDoc, varchar (1) DECLARE, @s_IndiNo, varchar (60), @s_DocNo, varchar (60), @d_BillDate, datetime, @s_OpeDeptID, varchar (30) DECLARE, @s_FilterID, varchar (16), @s_FilterString, varchar (8000) DECLARE, @s_Start, varchar (20), @s_End, varchar (5), @s_FilterCla1, varchar (8000), @s_FilterCla2, varchar (8000) DECLARE @s_ExtCol1 varchar (255) DECLARE @s_ExtCol2 varchar (255) DECLARE @s_ExtCol3 varchar (255) DECLARE @s_ExtCol4 varchar (255) DECLARE @s_ExtCol5 varchar (255) DECLARE @s_ExtCol6 varchar (255) DECLARE @s_OperType varchar (5) DECLARE @s_DivAuditFlag varchar (5) DECLARE @s_FirstAuditFlag varchar (5) SELECT, @s_FilterCla1= , @s_FilterCla2 =, @s_FilterString = , @s_Start =, @s_End = - take the user settings and calculate whether the balance is in use SELECT, @s_PlanUseIndi = Remark, FROM, Pub_t_SysCode, WHERE, TypeID =planuseindi IF, @s_PlanUseIndi, IS, NULL, SELECT, @s_PlanUseIndi =0 -- take the document ty