Sp_calc_materialsstoreLimit.md
891 Bytes
Sp_calc_materialsstoreLimit (procedure)
材料库存计算:审核包含自身,消审不包含自身 消审要在删除库存明细前调用,审核再插入库存明细后调用
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
- Created: 2026-04-27 19:10:24
- Last altered: 2026-04-27 19:10:24
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sGuid |
varchar(100) |
| 2 | IN | sFormGuid |
varchar(100) |
| 3 | IN | tCreateDate |
datetime |
| 4 | IN | sBrId |
varchar(100) |
| 5 | IN | sSuId |
varchar(100) |
| 6 | IN | iFlag |
int |
| 7 | OUT | sCode |
int |
| 8 | OUT | sReturn |
longtext |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpcalc_materialsstoreLimit'._
Narrative
No human-written narrative yet.