SP_Inventory_InOutWarehouse (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL
• Created: 2026-04-27 19:10:34
• Last altered: 2026-04-27 19:10:34

Parameters

#	Mode	Name	Type
1	IN	sMaterialsGuid	varchar(100)
2	IN	sMaterialsStyleS	varchar(100)
3	IN	sDefineNoS	varchar(100)
4	IN	sDefineNoS2	varchar(100)
5	IN	sWareHouseGuid	varchar(100)
6	IN	tStartDate	datetime
7	IN	tEndDate	datetime
8	IN	bUpdate	int
9	IN	bFlag	int
10	IN	sLocationGuid	varchar(100)
11	IN	sWarehouseLocationGuid	varchar(100)
12	IN	bUpdateAll	int
13	IN	sLoginId	varchar(100)
14	IN	sBrId	varchar(100)
15	IN	sSuId	varchar(100)
16	IN	bFilter	varchar(5000)
17	IN	pageNum	int
18	IN	pageSize	int
19	OUT	totalCount	int
20	IN	countCloumn	varchar(5000)
21	OUT	countMapJson	longtext
22	IN	sFilterOrderBy	varchar(5000)
23	IN	sGroupby_select_sql	varchar(5000)
24	IN	sGroupby_group_sql	varchar(5000)
25	OUT	sCode	int
26	OUT	sReturn	varchar(5000)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESPInventory_InOutWarehouse'._

Narrative

No human-written narrative yet.