Sp_Receivables_AR_new (procedure)

应收账款-优化搜索条件

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

Parameters

#	Mode	Name	Type
1	IN	iType	int
2	IN	sSalesManNameParam	varchar(100)
3	IN	sCustomerClassifyNameParam	varchar(100)
4	IN	sStatistics	varchar(100)
5	IN	tStartDate	datetime
6	IN	tEndDate	datetime
7	IN	sZero	varchar(100)
8	IN	sLoginId	varchar(100)
9	INOUT	dNoReceiptMoney	decimal(18,6)
10	INOUT	dDueReceiptMoney	decimal(18,6)
11	IN	sBrId	varchar(100)
12	IN	sSuId	varchar(100)
13	IN	bFilter	longtext
14	IN	pageNum	int
15	IN	pageSize	int
16	OUT	totalCount	int
17	IN	countCloumn	varchar(5000)
18	OUT	countMapJson	longtext
19	IN	sFilterOrderBy	varchar(5000)
20	IN	sGroupby_select_sql	varchar(5000)
21	IN	sGroupby_group_sql	varchar(5000)

Body

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

Narrative

No human-written narrative yet.