---
id: TST-ACC-PRD-037
title: Financial setup and completeness queries
kind: integration
product_area: accounting
module: products
revision: 1
status: draft
product_intent: proposed
implementation_evidence: observed
source_sha:
  services-accounting: f47cb263875bbc0c5640fba7dae6785ec32695f8
repository: services-accounting
files:
  - >-
    modules/products/tests/integration/services/persistence/product-accounting-setups.queries.integration.spec.js
implements:
  - ATS-ACC-PRD-017-01
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 3
estimation_note: Planning estimate; no runtime measurement is claimed.
isolation: 'Suite-named local workspaces, isolated fixture records and explicit cleanup or rollback.'
evidence:
  - >-
    services-accounting:modules/products/tests/integration/services/persistence/product-accounting-setups.queries.integration.spec.js
assertion_bindings:
  - scenario: ATS-ACC-PRD-017-01
    assertions:
      - >-
        services-accounting:modules/products/tests/integration/services/persistence/product-accounting-setups.queries.integration.spec.js#lists
        a product whose setup was deleted
      - >-
        services-accounting:modules/products/tests/integration/services/persistence/product-accounting-setups.queries.integration.spec.js#filters
        by status: retired, leaving out a retired product with a setup
    provenance: test
    source: >-
      services-accounting:modules/products/tests/integration/services/persistence/product-accounting-setups.queries.integration.spec.js
coverage_note: Scenario references name existing assertion evidence; broader unexecuted variants remain findings.
---

# Financial setup and completeness queries

## Verification Boundary

The suite exercises real PostgreSQL and Accounting persistence or database functions with isolated local workspace fixtures.

## What This Suite Proves

Queries assemble financial collections and locate products lacking setups using workspace, unit, kind, status and pagination filters.

## What It Does Not Prove

Local execution does not prove deployed infrastructure, downstream purchase behavior, real domain extension completion or atomic remote-template recovery.

## Real Dependencies and Test Doubles

PostgreSQL, transaction context, constraints, foreign keys and Accounting persistence are real. The test owns its workspace fixtures and clock.

## Must Not Be Doubled

Do not double PostgreSQL, row-level security, transaction boundaries, constraints or the persistence implementation when claiming these local guarantees.