Tables


SchemaSpy Analysis of idempiere.triniti_idempiere

Generated on Sun Oct 20 03:08 IST 2019

XML Representation
Insertion Order Deletion Order
TABLES 35
VIEWS 29
COLUMNS 1624
Constraints 39

Database Properties

Database Type: PostgreSQL - 9.5.3

Tables

Table / View Children Parents Columns Rows Type Comments
acc2acc_journal_org_roles 0 3 4 3 Table
acc2acc_journal_staging 2 2 13 109 Table
acc2acc_journal_staging_from 0 1 3 111 Table
acc2acc_journal_staging_to 0 1 3 111 Table
acc2acc_transfer_between_org 2 3 6 2 Table
acc2acc_transfer_between_org_from 0 4 6 2 Table
acc2acc_transfer_between_org_staging 2 2 9 10 Table
acc2acc_transfer_between_org_staging_from 0 2 5 10 Table
acc2acc_transfer_between_org_staging_to 0 2 5 10 Table
acc2acc_transfer_between_org_to 0 4 6 2 Table
acc2acc_transfer_from_accounts 0 1 3 36 Table
acc2acc_transfer_setup 4 0 7 36 Table
acc2acc_transfer_to_accounts 0 1 3 41 Table
account_mapping_for_payroll_india 0 0 7 10 Table
ad_attachment_documents 0 1 4 0 Table
adp_file_data_temp 0 0 66 0 Table
ar_n_cash_acct_linetype_mapping 0 0 5 23 Table
bank_file_template 1 1 6 8 Table
bank_file_template_fields 0 1 11 248 Table
bank_statement_lines_v 0 0 38 0 View
c_invoice 1 0 95 569 Table
c_invoiceline 0 0 77 569 Table
c_payment 0 0 106 569 Table
create_bank_statement_lines_from_v 0 0 52 0 View
customer_wise_sales_v 0 0 7 0 View
document_status 0 0 2 4 Table
document_status_relation 0 0 3 4 Table
emp_name_adp_vs_idempiere 0 0 8 50 Table
employee_employer_payroll_taxes_journal_v 0 0 37 0 View
employee_employer_payroll_taxes_journalline_v 0 0 44 0 View
je_salaray_expense_summary 0 0 9 0 View
je_transaction_summary 0 0 7 0 View
open_sales_order_v 0 0 29 0 View
open_sales_orders_v 0 0 25 0 View
open_sales_orders_v1 0 0 29 0 View
payment_transactions_summary_v 0 0 6 0 View
payroll_data_india 0 0 92 0 Table
payroll_tax_expense_journal_v 0 0 37 0 View
payroll_tax_expense_journalline_v 0 0 44 0 View
print_format_details 1 0 5 1 Table
print_format_edapter_classes 0 1 5 2 Table
product_inventory_aging_v 0 0 11 0 View
product_inventory_v 0 0 18 0 View
product_wise_sales_v 0 0 8 0 View
tri2_sow_and_idempiere_product_mapping 0 0 7 1 Table
trial_balance_v 0 0 11 0 View
v_acct_receivable_trxns 0 0 10 0 View
vendor_payment_amount_audit 0 1 5 85 Table
vendor_payment_approvers 0 2 6 238 Table
vendor_payment_invoice_lines_v 0 0 75 0 View
vendor_payment_invoices_v 0 0 142 0 View
vendor_payment_products 0 2 7 354 Table
vendor_payment_taxes 0 4 8 304 Table
vendor_payments_v 0 0 124 0 View
wages_and_salaries_expense_journal_v 0 0 37 0 View
wages_and_salaries_expense_journalline_v 0 0 44 0 View
week_acct_balances 0 0 10 23 Table
week_ar_cash_balances 0 0 17 6 Table
wip_accounting 0 0 58 0 View
xx_crm_opportunities_all_v 0 0 18 0 View
xx_crm_opportunities_v 0 0 18 0 View
xx_crm_opportunities_v1 0 0 13 0 View
xx_crm_opportunities_v2 0 0 22 0 View
xx_pographs 0 0 26 0 View