Sp_Calc_spurded (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(5000)
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_spurded'._

Narrative

Business context: 供应商扣款 — audit / un-audit of a 供应商扣款 (supplier deduction / charge-back) bill on purpurchaseinstorededmaster. Tied to the purchase-receipt deduction flow (e.g. supplier shipped short or off-spec, deduct from payable). Most of the post-audit recalculation logic in the body is commented out — current path is a minimal flag flip on master.

What it does: Validates sGuid, refuses when bInvalid=1. On iFlag=1 UPDATE purpurchaseinstorededmaster to flip bCheck=1, sStatus=1, stamp sCheckPerson/tCheckDate; iFlag=0 reverses. Several blocks that would recompute purpurchaseinstorededslave.dMaterialsMoney, dMaterialsPrice, tax-money breakdowns from sistax, etc., are present as comments — historical logic preserved but disabled.

Invocation: No gdsmodule.sProcName binding found in this snapshot, no gdsconfigformmaster.sSqlStr reference, no other proc/func calls it, and no xly-src grep hits. Status: appears orphaned. Either dispatched only from a customer overlay not in this snapshot, deactivated when its mainline logic was commented out, or stub left in place for legacy compatibility — candidate for maintainer audit.

Naming note: lowercase spurded (vs the family's s<Code> style) suggests the proper code is sPurDed; an inconsistent casing of Sp_Calc_sPurDed.