| SchemaSpy Analysis of idempiere11.adempiereBank Statement | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:47 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| c_bank | 1 | 15 | 2 | Bank | |
| c_bankaccount | 7 | 2 | 22 | 3 | Account at the Bank |
| c_bankaccountdoc | 1 | 15 | 2 | Checks, Transfers, etc. | |
| c_bankstatement | 2 | 1 | 33 | 2 | Bank Statement of account |
| c_bankstatementline | 1 | 5 | 42 | 2 | Line on a statement from this Bank |
| c_bankstatementloader | 1 | 28 | 0 | Definition of Bank Statement Loader (SWIFT, OFX) | |
| c_bankstatementmatcher | 13 | 0 | Algorithm to match Bank Statement Info to Business Partners, Invoices and Payments | ||
| c_bpartner | 5 | 1 | 74 | 18 | Identifies a Business Partner |
| c_currency | 6 | 19 | 175 | The Currency for this record | |
| c_depositbatch | 2 | 1 | 20 | 0 | Deposit Batch |
| c_depositbatchline | 2 | 15 | 0 | Deposit Batch Line | |
| c_invoice | 6 | 6 | 72 | 8 | Invoice Identifier |
| c_payment | 6 | 8 | 102 | 2 | Payment identifier |
| c_paymentprocessor | 1 | 2 | 36 | 2 | Payment processor for electronic payments |
| i_bankstatement | 7 | 60 | 0 | Import of the Bank Statement | |
| 15 Tables | 566 | 216 | |||
| 0 Views | 0 |