---
id: TST-ACC-REC-036
title: Reconciliation state and financial totals constraints
kind: integration
product_area: accounting
module: reconciliation
revision: 1
status: draft
source_sha:
  services-accounting: f47cb263875bbc0c5640fba7dae6785ec32695f8
repository: services-accounting
files:
  - modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js
implements:
  - ATS-ACC-REC-009-03
  - ATS-ACC-REC-009-08
  - ATS-ACC-REC-010-07
  - ATS-ACC-REC-011-02
  - ATS-ACC-REC-012-04
  - ATS-ACC-REC-013-01
  - ATS-ACC-REC-013-04
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 5
isolation: Suite-owned workspace fixtures and deterministic records removed by suite cleanup.
evidence:
  - >-
    services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js
bindings:
  - scenario: ATS-ACC-REC-009-03
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#generates
        the difference as claimed items less payouts, the brief’s sign
  - scenario: ATS-ACC-REC-009-08
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#refuses
        a 10,001st claim
  - scenario: ATS-ACC-REC-010-07
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#refuses
        a 201st manual item
  - scenario: ATS-ACC-REC-011-02
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#refuses
        a finalized batch whose difference is not zero (INV-07)
  - scenario: ATS-ACC-REC-012-04
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#refuses
        any change to a voided batch
  - scenario: ATS-ACC-REC-013-01
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#refuses
        to reopen a finalized batch
  - scenario: ATS-ACC-REC-013-04
    assertions:
      - >-
        services-accounting:modules/reconciliation/tests/integration/db/reconciliation-batches.table.integration.spec.js#refuses
        a reversal approved by the person who requested it
---

# Reconciliation state and financial totals constraints

## Verification Boundary

This suite exercises record constraints and database security using the application role and suite-owned fixtures. Direct writes isolate database enforcement from command behavior.

## What This Suite Proves

The executable assertions identified in the binding records supply the registered scenario observations. When a scenario names several suites, this suite supplies its listed assertions and does not independently establish every clause.

## What It Does Not Prove

Deployed infrastructure, live console behavior and shared scheduling delivery are outside this local boundary.

## Real Dependencies and Test Doubles

PostgreSQL, migrations and the exercised production code are real. Fixtures supply the financial world and caller context; deterministic setup and owner-side inspection do not replace database enforcement.

## Must Not Be Doubled

The exercised database constraints, transactional services and route enforcement remain real. Replacing them would remove the boundary this suite registers.