| SchemaSpy Analysis of idempiere11.adempiereTemporary | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:56 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_find | 15 | 0 | Find | ||
| ad_pinstance | 8 | 25 | 0 | Instance of the process | |
| ad_pinstance_log | 1 | 10 | 0 | (Non Standard Table) | |
| ad_pinstance_para | 1 | 20 | 0 | AD_PInstance_Para | |
| c_activity | 4 | 14 | 0 | Business Activity | |
| c_bp_group | 2 | 23 | 3 | Business Partner Group | |
| c_bpartner | 6 | 3 | 74 | 18 | Identifies a Business Partner |
| c_campaign | 4 | 17 | 2 | Marketing Campaign | |
| c_conversiontype | 2 | 13 | 4 | Currency Conversion Rate Type | |
| c_currency | 5 | 19 | 175 | The Currency for this record | |
| c_doctype | 8 | 4 | 42 | 52 | Document type or rules |
| c_invoice | 5 | 11 | 72 | 8 | Invoice Identifier |
| c_invoicepayschedule | 2 | 18 | 2 | Invoice Payment Schedule | |
| c_invoiceschedule | 1 | 20 | 1 | Schedule for generating Invoices | |
| c_payschedule | 1 | 17 | 2 | Payment Schedule Template | |
| c_project | 3 | 5 | 48 | 2 | Financial Project |
| fact_acct | 1 | 5 | 47 | 0 | Accounting Fact |
| m_transaction | 1 | 21 | 28 | Inventory Transaction | |
| t_1099extract | 32 | 0 | 1099 Extract | ||
| t_aging | 7 | 46 | 0 | T_Aging | |
| t_bankregister | 14 | 0 | Bank Register | ||
| t_bom_indented | 25 | 0 | Indented BOM Report | ||
| t_bomline | 30 | 0 | Temporal BOM Line | ||
| t_bomline_costs | 39 | view | Cost BOM Line | ||
| t_cashflow | 30 | 0 | T_CashFlow_ID | ||
| t_inventoryvalue | 2 | 24 | 0 | T_InventoryValue | |
| t_invoicegl | 5 | 25 | 0 | Gain/Loss - actual data shown id T_InvoiceGL_v | |
| t_invoicegl_v | 126 | view | Gain/Loss | ||
| t_mrp_crp | 12 | 0 | Temporal MRP & CRP | ||
| t_reconciliation | 11 | 0 | Account reconciliation report | ||
| t_replenish | 2 | 21 | 0 | T_Replenish | |
| t_rv_reconciliation | 192 | view | Accounting Fact Reconciliation Report View | ||
| t_selection | 4 | 0 | |||
| t_selection2 | 3 | 0 | |||
| t_spool | 1 | 3 | 0 | Temporary Spool Table | |
| t_transaction | 2 | 29 | 0 | T_Transaction | |
| 33 Tables | 824 | 297 | |||
| 3 Views | 357 |