OAIF v1.1.0 - Attachment Support

[GitHubNewbie0]

Release Notes

## What's New

### Attachment Table
OAIF now supports storing document attachments (receipts, contracts, supporting documents) linked to transactions.

**Features:**
- Embedded binary storage for complete portability
- External path/URL references for large files or cloud systems
- SHA-256 checksum for integrity verification
- Full source tracking for import/export fidelity
- Validation view to catch storage issues

**Schema Addition:**
```sql
CREATE TABLE attachment (
    attachment_id INTEGER PRIMARY KEY,
    txn_id INTEGER REFERENCES txn_header(txn_id),
    filename TEXT NOT NULL,
    mime_type TEXT,
    file_size INTEGER,
    file_data BLOB,
    external_path TEXT,
    external_url TEXT,
    checksum TEXT,
    description TEXT,
    document_date TEXT,
    uploaded_at TEXT,
    source_id TEXT,
    source_system TEXT,
    source_raw TEXT
);

Platform Support:

• QuickBooks Desktop/Online ✅
• Xero ✅
• Manager.io ✅
• FreshBooks ✅
• Sage Intacct ✅
• Zoho Books ✅
• Wave ✅

Migration

Existing v1.0 files remain valid. The attachment table is optional.

To upgrade a v1.0 file:

1. Add the attachment table
2. Update oaif_version metadata to '1.1'

---

## 6. COMMIT MESSAGE

Add attachment support (OAIF v1.1)

• Add attachment table for storing receipts and documents
• Support embedded binary, local path, or cloud URL storage
• Include v_attachment_issues validation view
• Add platform mappings for all supported systems
• Update documentation and examples

---

## Quick Checklist

- [ ] Add attachment table SQL to `schema/oaif_schema.sql`
- [ ] Add Attachments section to `docs/SPECIFICATION.md`
- [ ] Add Attachment Mappings to `docs/PLATFORM_MAPPINGS.md`
- [ ] Update file structure in `README.md`
- [ ] Update roadmap version in `README.md`
- [ ] Commit changes
- [ ] Create release v1.1.0

<hr /><em>This discussion was created from the release <a href='https://github.com/GitHubNewbie0/oaif-open-accounting-format/releases/tag/1.1.0'>OAIF v1.1.0 - Attachment Support</a>.</em>