Sp_financialClosing_BtnEventOutSideEstimation (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sProInParam	longtext
2	IN	sMakePerson	varchar(100)
3	IN	sBrId	varchar(100)
4	IN	sSuId	varchar(100)
5	OUT	sReturn	varchar(1000)
6	OUT	sCode	int

Body

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

Narrative

Business context: 系统设置 → 系统参数 → 财务结账 — 发外暂估 (outside-processing estimate) generator for month-end close. Same shape as Sp_financialClosing_BtnEventEstimation but operates on the 发外加工 cost ledger accordercostanalysis (with iType=7 for this-period estimate, iType=5 prior estimate, iType=3 invoice) and the parallel finished-goods inventory ledger accoutsideproductstore.

What it does: Parses sCostPeriod from sProInParam. Reads sysaccountperiod for window dates and bCost; refuses (sBtnDepartFinished) if the period is already cost-finalised. Refuses if prior-period 发外暂估 (iType=5) or this-period 发外发票 (iType=3) rows are still bConfirm=0 (sClosingConfirmLastFwData / sSystemProductionFwfpConfirm). Deletes the period's existing iType=7 accordercostanalysis rows and accoutsideproductstore rows. Rebuilds via temp tables Sp_instore / Sp_instoreSum populated from outsource-process checking and invoice views, resolves estimate prices, and re-inserts the summed rows into accordercostanalysis (iType=7) plus the matching accoutsideproductstore records.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() from the 财务结帐 form's 发外暂估 toolbar button. Sibling variants Sp_financialClosing_BtnEventOutSideEstimation_new and _test exist as in-progress / test rewrites — verify which is wired in production before changing behaviour. xly-src ships script/标版/30100101/cost/Sp_financialClosing_BtnEventOutSideEstimation.sql.