SP_Inventory_SemgoodsInOutWareHouse (procedure)

半成品出入库流水账

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

Parameters

#	Mode	Name	Type
1	IN	sCustomerGuid	varchar(100)
2	IN	sProductGuid	varchar(100)
3	IN	sPartsNameGuid	varchar(100)
4	IN	dSinglePQtyGuid	decimal(18,6)
5	IN	sProcessIdGuid	varchar(100)
6	IN	sVerGuid	varchar(100)
7	IN	sDefineNoS	varchar(100)
8	IN	sDefineNoS2	varchar(100)
9	IN	sWareHouseGuid	varchar(100)
10	IN	tStartDate	datetime
11	IN	tEndDate	datetime
12	IN	iUpdate	int
13	IN	iUpdateAll	int
14	IN	sLocationGuid	varchar(100)
15	IN	sWarehouseLocationGuid	varchar(100)
16	IN	sBrId	varchar(100)
17	IN	sSuId	varchar(100)
18	IN	bFilter	varchar(5000)
19	IN	pageNum	int
20	IN	pageSize	int
21	OUT	totalCount	int
22	IN	countCloumn	varchar(5000)
23	OUT	countMapJson	longtext
24	IN	sFilterOrderBy	varchar(5000)
25	IN	sGroupby_select_sql	varchar(5000)
26	IN	sGroupby_group_sql	varchar(5000)

Body

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

Narrative

No human-written narrative yet.