Table idempiere11.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 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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 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
levelno numeric 10  √  '0'::numeric Level no
t_trialbalance_uu varchar 36  √  NULL::character varying T_TrialBalance_UU

Table contained 0 rows at 2024-01-03 13:48 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_pinstance_id + fact_acct_id + account_id + ad_org_id Primary key Asc/Asc/Asc/Asc t_trialbalance_pkey
t_trialbalance_uu Must be unique Asc t_trialbalance_uu_idx

Close relationships  within of separation: