Sp_Calc_sMit1 (procedure)
材料期初数据导入(财务)
- 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 PROCEDURESpCalc_sMit1'._
Narrative
Business context: 材料期初数据导入(财务) — finance-side variant of the material opening-balance import, touching AccMaterialsInitMaster instead of the warehouse-side MitMaterialsInitMaster that Sp_Calc_sMit handles. Auditing this period would commit the finance-only opening valuations.
What it does: Standard Sp_Calc_s<Code> skeleton: defaults the IN params, branches on iFlag and updates AccMaterialsInitMaster.bCheck/audit-person/audit-date. The body is leaner than Sp_Calc_sMit — no MitMaterialsStore or EleMaterialsStock writes, consistent with a finance-only ledger seed rather than a stock seed.
Invocation: Status: appears orphaned. No gdsmodule.sProcName binding, no gdsconfigformmaster reference, no other routine refs. xly-src contains only the install scripts script/标版/30100101/Sp_Calc_sMit1.sql and script/标版/optimize/Sp_Calc_sMit1.sql — no caller code — so the finance-side 材料期初导入 may have been folded into Sp_Calc_sMit or retired. Candidate for maintainer audit.