Table idempiere9.adempiere.t_trialbalance
Trial Balance

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_pinstance_id numeric 10
ad_pinstance.ad_pinstance_id ad_pinstance_t_trialbalance C
Instance of the process
fact_acct_id numeric 10 Accounting Fact
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
c_acctschema_id numeric 10 Rules for accounting
account_id numeric 10  √  null Account used
datetrx timestamp 29,6  √  null Transaction Date
dateacct timestamp 29,6 Accounting Date
c_period_id numeric 10  √  null Period of the Calendar
ad_table_id numeric 10  √  null Database Table information
record_id numeric 10  √  null Direct internal record ID
line_id numeric 10  √  null Transaction line ID (internal)
gl_category_id numeric 10  √  null General Ledger Category
gl_budget_id numeric 10  √  null General Ledger Budget
c_tax_id numeric 10  √  null Tax identifier
m_locator_id numeric 10  √  null Warehouse Locator
postingtype bpchar 1 The type of posted amount for the transaction
c_currency_id numeric 10  √  null The Currency for this record
amtsourcedr numeric 0  √  null Source Debit Amount
amtsourcecr numeric 0  √  null Source Credit Amount
amtsourcebalance numeric 0  √  null Source Balance Amount
amtacctdr numeric 0 Accounted Debit Amount
amtacctcr numeric 0 Accounted Credit Amount
amtacctbalance numeric 0 Accounted Balance Amount
c_uom_id numeric 10  √  null Unit of Measure
qty numeric 0  √  null Quantity
m_product_id numeric 10  √  null Product, Service, Item
c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_locfrom_id numeric 10  √  null Location that inventory was moved from
c_locto_id numeric 10  √  null Location that inventory was moved to
c_salesregion_id numeric 10  √  null Sales coverage region
c_project_id numeric 10  √  null Financial Project
c_campaign_id numeric 10  √  null Marketing Campaign
c_activity_id numeric 10  √  null Business Activity
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
a_asset_id numeric 10  √  null Asset used internally or by customers
description varchar 255  √  null Optional short description of the record
accountvalue varchar 40  √  null Key of Account Element

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_pinstance_id + fact_acct_id Primary key Asc/Asc t_trialbalance_pkey


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.