Sp_Receivables_Aging.md 1.21 KB

Sp_Receivables_Aging (procedure)

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

Parameters

# Mode Name Type
1 IN iType int
2 IN sStatistics varchar(100)
3 IN tStartDate datetime
4 IN tEndDate datetime
5 IN sZero varchar(100)
6 IN sLoginId varchar(100)
7 INOUT dNoReceiptMoney decimal(18,6)
8 INOUT dDueReceiptMoney decimal(18,6)
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)

Body

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

Narrative

No human-written narrative yet.