| SchemaSpy Analysis of idempiere11.adempiereGeneral Ledger | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:48 +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_acctschema | 6 | 1 | 35 | 2 | Rules for accounting |
| c_doctype | 8 | 5 | 42 | 52 | Document type or rules |
| c_period | 3 | 16 | 360 | Period of the Calendar | |
| c_validcombination | 2 | 1 | 29 | 157 | Valid Account Combination |
| gl_budget | 2 | 13 | 1 | General Ledger Budget | |
| gl_budgetcontrol | 2 | 17 | 0 | Budget Control | |
| gl_category | 5 | 16 | 10 | General Ledger Category | |
| gl_distribution | 1 | 2 | 48 | 1 | General Ledger Distribution |
| gl_distributionline | 1 | 39 | 2 | General Ledger Distribution Line | |
| gl_fund | 1 | 1 | 16 | 0 | General Ledger Funds Control |
| gl_fundrestriction | 1 | 13 | 0 | Restriction of Funds | |
| gl_journal | 2 | 7 | 36 | 2 | General Ledger Journal |
| gl_journalbatch | 2 | 4 | 28 | 1 | General Ledger Journal Batch |
| gl_journalgenerator | 1 | 3 | 19 | 2 | GL Journal Generator |
| gl_journalgeneratorline | 1 | 1 | 22 | 6 | Generator Line |
| gl_journalgeneratorsource | 2 | 15 | 8 | Generator Source | |
| gl_journalline | 3 | 43 | 4 | General Ledger Journal Line | |
| 17 Tables | 447 | 608 | |||
| 0 Views | 0 |