# `Sp_InsertVoucher_Universal` (procedure)


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProInParam` | `varchar(10000)` |
| 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 PROCEDURE `Sp_InsertVoucher_Universal`'`._

## Narrative

**Business context:** 财务 / 凭证模板 / 自动凭证 (通用) — template-driven generic voucher generator. Replaces the per-source `Sp_InsertVoucher_<Module>` family with one parametric proc that takes a `sVoucherId` (pointing at `udfvouchertemplatemaster`) and assembles a voucher from whichever source table the template names. The companion `Sp_InsertVoucher_Universals_All` is the bulk version (no `sVoucherId` — picks the default template per `sFormId`).

**What it does:** Extracts `sTemplateGuid` from `$.changeValue.sVoucherId` (returns `'未选择凭证模板，请选择后操作'` with `sCode=-1` if empty). Looks up template metadata (`sVoucherFormId`, `sSumType`, `sVoucherOrder`) from `udfvouchertemplatemaster` and the source-table name + label from `gdsconfigformmaster`. Derives `p_sVoucherTableName` by stripping `master`/`slave` suffix and prepending `viw_` so it always reads the view. Reads already-posted `sSrcSlaveId` from `viw_udfvoucher` to skip already-posted source rows; then for the remaining source rows uses `sSumType` (sCustomerId / sSupplyId / sBillNo / sFormId) as the grouping key and `sVoucherOrder` to drive the debit/credit ordering. Allocates voucher numbers via `SP_Sis_GetMaxNo` and inserts `udfvouchermaster` + `udfvoucherslave`. Also tracks per-column flags (`b_sWareHouseId`, `b_sMaterialsId`, `b_sCustomerId`, `b_sSupplyId`, `b_sProductId`) so the template can opt-in to auxiliary-accounting dimensions.

**Invocation:** Status: appears orphaned. Signature matches the `GenericProcedureCallServiceImpl.doGenericProcedureCall()` voucher-button shape; no form-master/`gdsmodule`/workflow reference and no xly-src match besides install scripts (`script/标版/30100101/Sp_InsertVoucher_Universals.sql` and `script/标版/upgrade/20211115生成凭证/Sp_InsertVoucher_Universal_month.sql`). Likely the "single-bill" entry point for the template engine, invoked from a 生成凭证 button on the 凭证模板 module that didn't survive into the current form-master definitions. Candidate for maintainer audit.