Sp_Receivables_ARDetail.md 1.18 KB

Sp_Receivables_ARDetail (procedure)

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

Parameters

# Mode Name Type
1 IN iType int
2 IN sCustomerId varchar(100)
3 IN tStartDate varchar(100)
4 IN tEndDate varchar(100)
5 IN sLoginId varchar(100)
6 INOUT dNoReceiptMoney decimal(18,6)
7 INOUT dDueReceiptMoney 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)
19 OUT sCode int
20 OUT sReturn longtext

Body

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

Narrative

No human-written narrative yet.