Sp_MaterialAgingAnalysis_detail.md 1.29 KB

Edit Raw Blame History



Sp_MaterialAgingAnalysis_detail (procedure)


材料库龄分析详情表


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL

Created: 2026-04-27 19:10:38

Last altered: 2026-04-27 19:10:38


Parameters


#
Mode
Name
Type


1
IN
iType
int


2
IN
sMaterialsId
varchar(100)


3
IN
sMaterialsStyle
varchar(100)


4
IN
sWareHouseId
varchar(100)


5
IN
sLocationId
varchar(100)


6
IN
sWareHouseLocationId
varchar(100)


7
IN
sDefineNo
varchar(100)


8
IN
sDefineNo2
varchar(100)


9
IN
sBrId
varchar(100)


10
IN
sSuId
varchar(100)


11
IN
sLoginId
varchar(100)


12
IN
bFilter
longtext


13
IN
pageNum
int


14
IN
pageSize
int


15
OUT
totalCount
int


16
IN
countCloumn
longtext


17
OUT
countMapJson
longtext


18
IN
sFilterOrderBy
longtext


19
IN
sGroupby_select_sql
longtext


20
IN
sGroupby_group_sql
longtext


Body

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


Narrative

No human-written narrative yet.