Sp_NotReceivables (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sCustomerGuid |
varchar(100) |
| 2 | OUT | iOut |
int |
| 3 | IN | sLoginId |
varchar(100) |
| 4 | IN | sBrId |
varchar(100) |
| 5 | IN | sSuId |
varchar(100) |
| 6 | IN | bFilter |
text |
| 7 | IN | sUnTaskFormId |
varchar(100) |
| 8 | IN | pageNum |
int |
| 9 | IN | pageSize |
int |
| 10 | OUT | totalCount |
int |
| 11 | IN | countCloumn |
text |
| 12 | OUT | countMapJson |
longtext |
| 13 | IN | sFilterOrderBy |
text |
| 14 | IN | sGroupby_select_sql |
text |
| 15 | IN | sGroupby_group_sql |
text |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpNotReceivables'._
Narrative
Business context: KPI流程操作菜单 → 财务收付款 → 1/1 销售对账->收款 — AR-side counterpart of Sp_NotPayAbles. Paged customer-receivables warning list: pulls every still-unreceived sales bill (delivery, advance, financial-adjust, payment, AR-init) into one window so the credit/collections desk can prioritise follow-ups.
What it does: Reads SysAccountPeriod.tAPDate as the AR cutoff, calls Sp_Sis_GetConst for ReceiptInit/Advance/FinancialAdjust/Payment language labels, builds ReceivablesWarning (customer, product, qty, money, currency, due-date, reserves) by UNION-ing across the AR source views filtered to sBrId/sSuId and tCreateDate >= tAPDate, then forwards the final SQL to Sp_Outstanding_Query for paging, bFilter/sFilterOrderBy splicing, countCloumn totals, and sGroupby_* rollups.
Invocation: Bound as the data-source of form gfm.sId=19211681015115285266337740 (1/1 销售对账->收款) via gdsconfigformmaster.sSqlStr. Also referenced by the helper Fun_getInitColumnByProName (column-discovery for the dynamic-grid layer). Install script ships at script/标版/30100101/Sp_NotReceivables.sql.