View idempiere9.adempiere.gl_journalline_acct_v
GL_JournalLine_Acct_v

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
gl_journalline_id numeric 10  √  null
ad_client_id numeric 10  √  null
ad_org_id numeric 10  √  null
isactive bpchar 1  √  null
created timestamp 29,6  √  null
createdby numeric 10  √  null
updated timestamp 29,6  √  null
updatedby numeric 10  √  null
gl_journal_id numeric 10  √  null
line numeric 10  √  null
isgenerated bpchar 1  √  null
description varchar 255  √  null
amtsourcedr numeric 0  √  null
amtsourcecr numeric 0  √  null
c_currency_id numeric 10  √  null
c_conversiontype_id numeric 10  √  null
currencyrate numeric 0  √  null
dateacct timestamp 29,6  √  null
amtacctdr numeric 0  √  null
amtacctcr numeric 0  √  null
c_uom_id numeric 10  √  null
qty numeric 0  √  null
c_validcombination_id numeric 10  √  null
c_acctschema_id numeric 10  √  null
account_id numeric 10  √  null
m_product_id numeric 10  √  null
c_bpartner_id numeric 10  √  null
ad_orgtrx_id numeric 10  √  null
c_locfrom_id numeric 10  √  null
c_locto_id numeric 10  √  null
c_salesregion_id numeric 10  √  null
c_project_id numeric 10  √  null
c_campaign_id numeric 10  √  null
user1_id numeric 10  √  null
user2_id numeric 10  √  null
isfullyqualified bpchar 1  √  null
c_activity_id numeric 10  √  null

Analyzed at 2021-12-25 14:43 +0100