Sp_Calc_sMit1.md 1.7 KB

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.