Sp_OverdueNoCheck (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 |
text |
| 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 PROCEDURESpOverdueNoCheck'._
Narrative
Business context: 销售管理 → 客户对账管理 → 超期未对账预警表 — overdue-no-reconciliation early-warning report. Lists customer-level delivery / billing amounts that have passed the configured reconciliation grace window without an issued 对账单 (statement), so AR can chase the missing reconciliations.
What it does: Builds the temp table OverdueNoCheck with the dollar columns (dProductMoney, etc.), pulls candidate bills from delivery / billing tables filtered to sCustomerId (optional), sBrandsId, sSubsidiaryId, plus the data-permission p_sLookCustomer filter; computes per-row "overdue" by comparing today's date against the customer's reconciliation cycle / 对账日 from the bills' metadata. Hands the resulting dynamic SQL plus paging/grouping inputs to the generic Sp_Outstanding_Query helper for pagination, total-count and countMapJson totals.
Invocation: Bound as the data-source of the 超期未对账预警表 form gfm.sId=19211681019715708437112060 via gdsconfigformmaster.sSqlStr — module 超期未对账预警表 under 客户对账管理 → 销售管理. Loaded when the user opens the report. Install script: script/标版/30100101/Sp_OverdueNoCheck.sql.