Sp_Payables_AP (procedure)

应付账款 2025-12-30 新

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

Parameters

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

Body

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

Narrative

No human-written narrative yet.