Sp_BillOfNoPicking_copy1 (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sBrId	varchar(100)
2	IN	sSuId	varchar(100)
3	IN	sLoginId	varchar(100)
4	IN	bFilter	text
5	IN	pageNum	int
6	IN	pageSize	int
7	IN	sUnTaskFormId	varchar(100)
8	OUT	totalCount	int
9	IN	countCloumn	varchar(5000)
10	OUT	countMapJson	longtext
11	IN	sFilterOrderBy	varchar(5000)
12	IN	sGroupby_select_sql	varchar(5000)
13	IN	sGroupby_group_sql	varchar(5000)

Body

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

Narrative

Business context: Backup / snapshot variant of Sp_BillOfNoPicking (_copy1 suffix). Per wiki convention, backup objects are not narrated (see the index).

What it does: Same as Sp_BillOfNoPicking at the time of copy.

Invocation: Not expected to be called from production code; verify before relying on it.