Table idempiere9.adempiere.i_gljournal
Import General Ledger Journal

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
i_gljournal_id numeric 10 Import General Ledger Journal
ad_client_id numeric 10  √  null Client/Tenant for this installation.
clientvalue varchar 40  √  null Key of the Client
ad_orgdoc_id numeric 10  √  null
ad_org.ad_org_id adorgdoc_igljournal N
Document Organization (independent from account organization)
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
processing bpchar 1  √  null Process Now
processed bpchar 1  √  'N'::bpchar The document has been processed
gl_journalbatch_id numeric 10  √  null
gl_journalbatch.gl_journalbatch_id gljournalbatch_igljournal N
General Ledger Journal Batch
batchdocumentno varchar 30  √  null Document Number of the Batch
batchdescription varchar 255  √  null Description of the Batch
gl_journal_id numeric 10  √  null
gl_journal.gl_journal_id gljournal_igljournal N
General Ledger Journal
journaldocumentno varchar 30  √  null Document number of the Journal
postingtype bpchar 1  √  null The type of posted amount for the transaction
c_acctschema_id numeric 10  √  null
c_acctschema.c_acctschema_id cacctschema_igljournal N
Rules for accounting
acctschemaname varchar 60  √  null Name of the Accounting Schema
c_doctype_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_igljournal N
Document type or rules
doctypename varchar 60  √  null Name of the Document Type
gl_category_id numeric 10  √  null
gl_category.gl_category_id glcategory_igljournal N
General Ledger Category
categoryname varchar 60  √  null Name of the Category
c_period_id numeric 10  √  null
c_period.c_period_id cperiod_igljournal N
Period of the Calendar
gl_budget_id numeric 10  √  null
gl_budget.gl_budget_id glbudget_igljournal N
General Ledger Budget
gl_journalline_id numeric 10  √  null
gl_journalline.gl_journalline_id gljourbelline_igljournal N
General Ledger Journal Line
line numeric 10  √  null Unique line for this document
dateacct timestamp 29,6  √  null Accounting Date
description varchar 255  √  null Optional short description of the record
amtsourcedr numeric 0  √  0 Source Debit Amount
amtacctdr numeric 0  √  0 Accounted Debit Amount
amtsourcecr numeric 0  √  0 Source Credit Amount
amtacctcr numeric 0  √  0 Accounted Credit Amount
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_igljournal N
The Currency for this record
iso_code bpchar 3  √  null Three letter ISO 4217 Code of the Currency
conversiontypevalue varchar 40  √  null Key value for the Currency Conversion Rate Type
c_conversiontype_id numeric 10  √  null
c_conversiontype.c_conversiontype_id cconversiontype_igljournal N
Currency Conversion Rate Type
currencyrate numeric 0  √  0 Currency Conversion Rate
c_uom_id numeric 10  √  null
c_uom.c_uom_id cuom_igljournal R
Unit of Measure
qty numeric 0  √  0 Quantity
c_validcombination_id numeric 10  √  null
c_validcombination.c_validcombination_id cvalidcombination_igljournal N
Valid Account Combination
orgvalue varchar 40  √  null Key of the Organization
ad_org_id numeric 10  √  null
ad_org.ad_org_id adorg_igljournal N
Organizational entity within client
account_id numeric 10  √  null
c_elementvalue.c_elementvalue_id celvalueaccount_igljournal N
Account used
accountvalue varchar 40  √  null Key of Account Element
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_igljournal N
Performing or initiating organization
orgtrxvalue varchar 40  √  null Key of the Transaction Organization
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_ogljournal N
Product, Service, Item
productvalue varchar 40  √  null Key of the Product
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_igljournal N
Identifies a Business Partner
bpartnervalue varchar 40  √  null Key of the Business Partner
c_project_id numeric 10  √  null
c_project.c_project_id cproject_igljournal N
Financial Project
projectvalue varchar 40  √  null Key of the Project
c_locto_id numeric 10  √  null
c_location.c_location_id clocto_igljournal N
Location that inventory was moved to
c_locfrom_id numeric 10  √  null
c_location.c_location_id clocfrom_igljournal N
Location that inventory was moved from
c_salesregion_id numeric 10  √  null
c_salesregion.c_salesregion_id csalesregion_igljournal N
Sales coverage region
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_gljournal N
Business Activity
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_igljournal N
Marketing Campaign
user1_id numeric 10  √  null
c_elementvalue.c_elementvalue_id cevalueuser1_igljournal N
User defined list element #1
user2_id numeric 10  √  null
c_elementvalue.c_elementvalue_id celvalueuser2_igljournal N
User defined list element #2
iscreatenewbatch bpchar 1  √  'N'::bpchar If selected a new batch is created
iscreatenewjournal bpchar 1  √  'N'::bpchar If selected a new journal within the batch is created
i_gljournal_uu varchar 36  √  NULL::character varying I_GLJournal_UU
activityvalue varchar 40  √  NULL::character varying Text key for Activity
campaignvalue varchar 40  √  NULL::character varying Text key of the Campaign
salesregionvalue varchar 40  √  NULL::character varying Text key of the Sales Region

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

Indexes:
Column(s) Type Sort Constraint Name
i_gljournal_id Primary key Asc i_gljournal_pkey
i_gljournal_uu Must be unique Asc i_gljournal_uu_idx


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.