SP_Inventory_InOutWarehouseCost (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	sWareHouseGuid	varchar(100)
4	IN	tStartDate	datetime
5	IN	tEndDate	datetime
6	IN	sLocationGuid	varchar(100)
7	IN	sWarehouseLocationGuid	varchar(100)
8	IN	sLoginId	varchar(100)
9	IN	sBrId	varchar(100)
10	IN	sSuId	varchar(100)
11	IN	bFilter	varchar(5000)
12	IN	pageNum	int
13	IN	pageSize	int
14	OUT	totalCount	int
15	IN	countCloumn	varchar(5000)
16	OUT	countMapJson	longtext
17	IN	sFilterOrderBy	varchar(5000)
18	IN	sGroupby_select_sql	varchar(5000)
19	IN	sGroupby_group_sql	varchar(5000)
20	OUT	sCode	int
21	OUT	sReturn	varchar(5000)

Body

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

Narrative

No human-written narrative yet.