Sp_SalSalesCheck_All (procedure)

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

Parameters

#	Mode	Name	Type
1	IN	sLoginId	varchar(100)
2	IN	sCustomerId	varchar(100)
3	IN	sBrId	varchar(100)
4	IN	sSuId	varchar(100)
5	IN	bFilter	longtext
6	IN	sUnTaskFormId	varchar(100)
7	IN	pageNum	int
8	IN	pageSize	int
9	OUT	totalCount	int
10	IN	countCloumn	text
11	OUT	countMapJson	longtext
12	IN	sFilterOrderBy	text
13	IN	sGroupby_select_sql	text
14	IN	sGroupby_group_sql	text

Body

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

Narrative

Business context: 销售管理 → 销售对账/开票流程 → 销售对账 (salsalescheckingmaster / salsalescheckingslave) — variant of the standard "未对账印件清单" data-source proc Sp_SalSalesCheck that returns the union of all source-bill types (送货单 + 销售订单 + 工单 + …) in one paged listing, rather than the single-type branch the production version picks via SysSystemSettings.CbxSrcNoCheck. Pre-stages a temp table B1 of sMinusSrcId from saldelivergoodsmaster + salrejectgoodsmaster so that delivery notes already replaced by 抵扣/退货 bills are filtered out.

What it does: Reads NetMoney/NetPrice rounding settings, builds a B1 temp table of replaced source ids, resolves Fun_GetLookCustomer for visibility, then CREATE TEMPORARY TABLE TmpSalSalesCheck and inserts from each bill family in turn — selecting (dProductQty - dCheckingQty) AS dNoCheckingQty and the standard projection columns. Caller-supplied bFilter JSON is rewritten to a WHERE clause via Fun_bFilter_toWhere(.,'A') and @sTableAlias@ is replaced with A.. Returns the paged + counted result through the usual Sp_Outstanding_Query-style pager glue.

Invocation: Status: appears orphaned — _All is a feature variant retained alongside the canonical Sp_SalSalesCheck. No gdsconfigformmaster.sSqlStr binds it, no gdsmodule.sProcName references it, no other proc in information_schema.ROUTINES mentions it, and grep -rln Sp_SalSalesCheck_All xly-src returns no hits. Maintainers should confirm whether this is an experimental successor to Sp_SalSalesCheck or stale code; per wiki convention, treat as not-in-production until a binding is re-established.