Sp_Payables_AP.md 1.12 KB

Sp_Payables_AP (procedure)

应付账款 2025-12-30 新

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

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.