SchemaSpy Analysis of idempiere9.adempiereTemporary Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:56 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table / View Children Parents Columns Rows Comments
ad_find 15 0 Find
ad_pinstance 8 22 0 Instance of the process
ad_pinstance_log 1 9 0 (Non Standard Table)
ad_pinstance_para 1 19 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 17 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 71 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 3 0
t_selection2 3 0
t_spool 1 3 0 Temporary Spool Table
t_transaction 2 29 0 T_Transaction
           
33 Tables     817 296  
3 Views     357