Sp_InsertVoucher_salsalescheckingGW (procedure)

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

Parameters

#	Mode	Name	Type
1	IN	sProInParam	varchar(10000)
2	IN	sMakePerson_s	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 PROCEDURESpInsertVoucher_salsalescheckingGW'._

Narrative

Business context: 财务 / 自动凭证 — GW (港外, "off-port"/overseas) variant of the 销售对账 voucher generator. Identical mechanics to Sp_InsertVoucher_salsaleschecking but covers the subset of sales-reconciliation rows that the parent skips, so that overseas sales post into their own subject set (typically the 5102.04 / foreign-currency branch).

What it does: Parses date range from $.changeValue[0].pChooseDate. Reads p_sSrcInvoiceNo from already-posted udfvoucherslave.sMemo to dedup. Cursors viw_salsaleschecking GROUP BY dCurrencyRate, sCustomerId, sMReserve1 WHERE bCheck=1 AND iVouchermark=0 AND <GW-only filter>, tracking the previous customer (p_sOldCustomerId) to start a new voucher when it changes. Per group: allocates a voucher number via SP_Sis_GetMaxNo, inserts udfvouchermaster + udfvoucherslave debit/credit rows summing money, stamps iVouchermark=1.

Invocation: Called by DB proc Sp_InsertVoucher_salsaleschecking at the end of its main loop (call Sp_InsertVoucher_salsalescheckingGW(sProInParam, …)). xly-src ships install scripts for both as siblings in script/标版/30100101/. No direct form-master/gdsmodule/workflow/Java caller — only reachable via the parent.