# Features — superbowl_daily (Superbowl Daily)

Evidence date: 2026-10-02.

Source: `git@bitbucket.org:overdrive/superbowl_daily.git`, `main` at `1ba6c4a` (2026-08-04).

Status words: current (runs on the `Run()` path or an enabled button), completed (present and historically finished in comments), in-development (none found), planned (none found), deprecated (code remains but the daily path is disabled or emptied).

## Current

| Feature | What it does | Where |
|---|---|---|
| Unattended or manual batch | Load runs `Run()` only when `blnDebug` is false. **ReRun** always calls `Run()`. | `frmMain_Load`, `btnRun_Click` |
| Fiscal period seed | Inserts up to six `mstPeriod` rows from the RGBC company fiscal start. | `Run` |
| Warehouse census row | Inserts customer and product counts into `dlyDataWarehouse`. | `Run` |
| Cognos customer import | `cognos09.txt` insert/update of `mstCustomer`, including inverted active flag and optional liquor licence. | `ProcessInsert` / `ProcessUpdate`, `sql_update_Customer_daily`, `sql_insert_Customer` |
| Customer warehouse sync | Inserts missing `dwdCustomer` keys, then runs `sysQuery` 8 and 31. | `Run` post-process `Customer` |
| Cognos sales import | `cognos14.txt` into `stgCognos14`, with pack-type suffix and pink-slip column. | `ProcessInsert` `Sales` |
| Sales warehouse and free stock | Rebuilds `dwfSales`, promotional triple entry, pink-slip onto `dwfSales` and `fsrRequisition`. | `Run` post-process `Sales` |
| Stock actuals from sales | Writes `stkProductPeriod.dblActual` from Cognos 14 flats. | same |
| ZMB movements | `zmb59-daily.txt` into receipts, exports, repack, and damages. | `ProcessInsert` `stgZMB`, post-process |
| Daily depot stock | `cognos12.txt` into `dwfStock` for `txtDate`. | `ProcessInsert` `Stock` |
| SALBA | Workbook `MonthQuery2` into `dwfSalba`. Batch uses the last `SALBA_*` file. **Salba** imports all of them. | `loadSalba`, `btnSalba_Click` |
| Export sales staging | `Export Sales.xls` into `stgExports` and unprocessed `mstExports` (batch `999090`). | `ProcessInsert` `stgExports` |
| AdCheck LISP | Replaces `dwfACLisp` for audit periods and seeds unmapped product and store map rows. | `Run` case `dwfAdCheckLisp` |
| AdSpend | Moves `AdSpend.xls` off the BMI folder and inserts `dwfAdSpend`, including `ai_imagefile`. | copy loop, `ProcessInsert` `AdSpend` |
| Stock-control retotal | Opening, closing, and months of cover. Also **Post SC** and **Re Total SC**. | `updatePPBalance` |
| BFBE files | Tab-delimited invoice and customer extracts from named `sysQuery` rows. Day 1 uses the previous sales month. | `bfbeExports` |
| Import log email | HTML mail of `dlyImportLog` rows flagged `blnEmail = 1`. **Email** sends without a batch. | `MailLog`, `btnEmail_Click` |
| File error log | Daily `Logs\error_yyyyMMdd.log`, including unhandled exceptions. | `ErrorLogger.vb`, `ApplicationEvents.vb` |
| Import archive | Release moves processed files to `Imported\`. DEBUG copies them. | `Run` archive block |
| Progress UI | Per-file and overall progress bars and a total label. | `setPGBTotals`, `pgBar`, `pgTotal` |

## Completed in history, still in the running code

These are described as versioned changes in the `Main.vb` header. They are the current behaviour, not a separate mode.

| Version note | Date in comment | Behaviour now |
|---|---|---|
| v1.10 transaction date on `dwfSales` | 2009-04-06 | `strDate` written from the sales period |
| v1.14 Cognos 14 column change | 2009-05-29 | Current column mapping |
| v1.17 promotional free-stock triple entry | comment only | Still in the sales post-process |
| v1.21 extended Cognos 12 columns | 2009-10-19 | Current `sql_insert_Stock` |
| v1.26 active flag inverted | 2013-09-03 | `sql_update_Customer_daily` |
| v1.28 pink-slip restored | 2015-08-27 | `strPSN` and `fsrRequisition` update |
| v1.30 SMTP change | 2018-08-30 | DEBUG uses Office 365. Release uses `SMTPHost`. |
| v1.31 AdSpend `ai_imagefile` | 2018-11-07 | Current insert. `ProductSubCategory` insert is commented. |
| v1.32 zero opening stock | 2019-01-09 | `dblOpeningImports` branch in `updatePPBalance` |
| v1.33 Benriach renamed to Hennessy | 2024-11-27 | UNC paths in `Main.vb` |
| v1.34 liquor licence | 2026-06-24 | `GetLiquorLicenseFromRow`, commit `2a4fdbe` |
| Error logging | 2026-08-04 | commit `1ba6c4a` |

The Git history does not contain the 2009–2019 edits. Those notes are comments inside the initial code commit.

## Deprecated or disabled

| Feature | Evidence | Still reachable |
|---|---|---|
| Mint / eSales Charter file pickup | Copy condition `And False`. Comment v1.27, 2013-12-09. | Yes, if the CSV is already in `Imports\` |
| Sales Charter query export on the daily run | `ProduceSalesCharterQueries(True)` commented in `Run()`. | Yes, **SCQ** button |
| LVMH-only Sales Charter files | Commented inside `ProduceSalesCharterQueries` (2010-05-22). IDs 15 and 16 are still unioned into the RGBC customer-rep file. | No separate LVMH files |
| BFBE mail from the daily run | `MailBrandon()` commented in `Run()` (`temp disabled`). | Yes, **Mondayly** button |
| Fix SAP credit documents | `btnFix_Click` body commented out | Button visible, no effect |
| Snell area and supergroup post-checks | Commented in the customer post-process | No |
| AdSpend only on the 13th | Comment v1.24: try the move every day | Daily move is current |
| Monday-and-month-end mail of BFBE during `Run` | Comment v1.22b described mailing Brandon and PJ. The call is commented. | Files still generate every `Run` |
| `sql_insert_Users_OLD_WITH_PASSWORD` | Commented methods on `sqlDB_Superbowl`. Live methods on `sqlDB_StockControl` have no caller in `Main.vb`. | Not called by this batch |

## In-development

None. The latest commit is error logging on 2026-08-04. No branch other than `main` was on the remote.

## Planned

No roadmap, TODO issue list, or unfinished feature flag was found. Comments that say `temp disabled` or `not being used / not 100%` (customer segmentation Excel sheet) are disabled behaviour, not a stated plan.

## Removed from the product surface

| Item | Evidence |
|---|---|
| SonarQube project files named in the 2026-09-28 onboarding snapshot | Not in the Git tree at `1ba6c4a` |
| Benriach UNC paths | Replaced by Hennessy in live statements. Old paths remain as comments. `Settings.settings` still defaults the release SQL host to `Benriach`. |

## UI that does not match the changelog version

The form caption is v1.31. The changelog's last line is v1.34. Assembly version is 1.4.0.0. ClickOnce version is 1.31.0.*. See project plan for the confirmation this needs.