# Checkpoint 327 — Auditable BOQ spreadsheet imports (2026-10-27)

BE-050 now retains immutable spreadsheet import provenance with each imported native BOQ: original filename, SHA-256 of the exact workbook bytes, chosen column mapping, row count and Odoo importer/time. The original workbook is not retained. Odoo restricts raw provenance fields to system-group access; the bridge exposes the metadata only after the caller passes the existing BOQ and project read checks, and React displays it in BOQ details. The source fingerprint and mapping participate in idempotency, so reusing an operation ID with another source file is rejected. Legacy idempotency hashes remain accepted for in-flight retries created before this upgrade.

## Verification

- Isolated clean-database Odoo native retry/provenance/security test: **1 passed**. It verified source metadata readback through the authorized bridge, same-operation retry, changed-content and changed-source rejection, column-mapping validation, immutable fields and denial of forged metadata through direct BOQ creation. The disposable QA database was explicitly terminated and dropped.
- Backend business API + BOQ import suites: **224 passed, 314 subtests passed**, including exact metadata forwarded to Odoo.
- React BOQ spreadsheet import Playwright journey: **1 passed**, including gateway retry with a stable operation ID and audit metadata visible after navigating away and reopening the BOQ.
- Production backend and React images built. React build passed; the existing bundle-over-500-kB advisory remains.
- Local `namaa_ksa` backups verified before each schema upgrade at `/tmp/namaa_ksa_pre_boq_import_history_20261027.dump` (11,543,868 bytes) and `/tmp/namaa_ksa_pre_boq_import_acl_20261027.dump` (11,543,556 bytes), both mode 0600 with archive listings verified. Final installed versions: `be_boq` `20.0.1.0.7`, `namaa_ai_bridge` `20.0.1.0.38`; schema columns verified, Odoo restarted. Authenticated read-only React → BFF → Odoo BOQ/list-options smoke passed. No business record was created in the shared demo database.
- `git diff --check`, Python compilation and QA JSON parsing passed.

BE-050 remains **PARTIAL**: broader ordinary-role/company acceptance, import-history querying/retention policy, reusable mapping templates for other master-data imports and full story criteria remain open. Overall requirements remain **19 DONE, 133 PARTIAL, 2 MISSING, 10 BLOCKED / 164**. See [QA evidence](BOQ_IMPORT_HISTORY_QA.json), [Arabic parser QA](BOQ_IMPORT_ARABIC_QA.json) and [requirements matrix](../REQUIREMENTS_TRACEABILITY.md).
