# ER Diagram — AR-Reconciliation-Tool

## Data_Backend.accdb

```mermaid
erDiagram
    tblImportBatch ||--o{ tblTransactions : "ImportBatchID"
    tblImportBatch ||--o{ tblBankStatement : "ImportBatchID"
    tblTransactions ||--o| tblReconcileResult : "TransID"
    tblBankStatement ||--o| tblReconcileResult : "StmtID"

    tblImportBatch {
        long BatchID PK
        text FileName
        datetime ImportDate
        long RowCount
        text Status
    }
    tblTransactions {
        long TransID PK
        text Branch
        datetime TxnDate
        currency Amount
        text RefNo
        long ImportBatchID FK
    }
    tblBankStatement {
        long StmtID PK
        datetime TxnDate
        currency Amount
        text BankRefNo
        long ImportBatchID FK
    }
    tblReconcileResult {
        long ResultID PK
        long TransID FK
        long StmtID FK
        text MatchStatus
        currency Variance
        text ReconciledBy
        datetime ReconciledDate
    }
```

## Data_Log.accdb

Separate file — no enforced FK relationship across `.accdb` files, only a shared `BatchID` convention.

```mermaid
erDiagram
    tblErrorLog {
        long LogID PK
        long BatchID
        long RowNo
        text ErrorMsg
        datetime Timestamp
    }
```