SP_Inventory_InOutWareHouseAll (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(255)
2	IN	sMaterialsStyleS	varchar(255)
3	IN	sDefineNoS	varchar(255)
4	IN	sDefineNoS2	varchar(255)
5	IN	sWareHouseGuid	varchar(255)
6	IN	tStartDate	datetime
7	IN	tEndDate	datetime
8	IN	sLocationGuid	varchar(255)
9	IN	sWarehouseLocationGuid	varchar(255)
10	IN	iStart	int
11	IN	iEnd	int
12	IN	iSelect	int
13	IN	sBrId	varchar(255)
14	IN	sSuId	varchar(255)
15	IN	sLoginId	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	OUT	sCode	int
24	OUT	sReturn	varchar(5000)

Body

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

Narrative

No human-written narrative yet.