# `Sp_NotPayAbles_list` (procedure)


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sId` | `text` |
| 2 | IN | `sBrId` | `varchar(100)` |
| 3 | IN | `sSuId` | `varchar(100)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_NotPayAbles_list`'`._

## Narrative

**Business context:** Companion to `Sp_NotPayAbles` (1/1 对账( 采购&外协)->付款) — takes a comma-separated list of supplier-payable bill ids (`sId`) and returns the per-bill detail rows. Intended to back the "drill-down/print/选择" sub-panel where the user opens the supplier-payables console, ticks specific bills, and asks for their full breakdown.

**What it does:** Splits the inbound CSV `sId` into a `p_t_sId` temp table (`sBillIdCr` indexed), then builds the same `p_tmp_PayablesWarning` shape as `Sp_NotPayAbles` but filters every source-leg join through `p_t_sId.sBillIdCr` to keep only the bills the caller picked. Returns the detail set directly (no `Sp_Outstanding_Query` paging — small selection).

**Invocation:** Status: appears orphaned. No `gdsconfigformmaster` binding, no `gdsmodule` hook, no other proc/function references it, and no xly-src caller — only the install script `script/标版/30100101/Sp_NotReceivables_list.sql` mentions the name (because the AR-side `Sp_NotReceivables_list` is the sibling). Candidate for maintainer audit.
