# `Sp_Calc_sMsy` (procedure)

> @author:zhucx
							@date:2021.12.12
							@describe: 
							1.PC端-采购管理-采购询价-保存自动调用本过程,当系统设定中本单据为自动审核时


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `iFlag` | `int` |
| 2 | IN | `iTmpCheck` | `int` |
| 3 | IN | `sFormGuid` | `varchar(100)` |
| 4 | IN | `sGuid` | `varchar(100)` |
| 5 | IN | `sLoginId` | `varchar(100)` |
| 6 | OUT | `sReturn` | `varchar(4000)` |
| 7 | IN | `sBrId` | `varchar(100)` |
| 8 | IN | `sSuId` | `varchar(100)` |
| 9 | OUT | `sCode` | `int` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Calc_sMsy`'`._

## Narrative

**Business context:** 采购管理 → 采购单据 → 采购询价单 — purchase RFQ (price-inquiry) audit / un-audit. Per the proc header, this runs automatically on save when the form is configured for auto-audit. Auditing an RFQ promotes the negotiated supplier prices into the live material-supply pricing on `elematerialssupply`, so downstream PO creation picks them up.

**What it does:** Defaults the IN params, branches on `iFlag`. The only data touch is `Update elematerialssupply` — back-writing the RFQ-line prices/lead-times onto the per-supplier material-supply rows. `iFlag=0` reverses the same column writes.

**Invocation:** Bound to `gdsmodule.sProcName` on `采购询价单` (sId `19211681019715693170550680`) under 采购管理 → 采购单据. Dispatched by Java `BusinessBaseServiceImpl.getPrcName(sFormGuid, …)` either on the 审核 button or — per the header — automatically by the save handler when 系统设定 marks 采购询价单 as auto-audit. xly-src ships `script/标版/30100101/Sp_Calc_sMsy.sql` and `script/标版/optimize/Sp_Calc_sMsy.sql`.