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 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 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 Document type or rules
doctypename varchar 60  √  null Name of the Document Type
gl_category_id numeric 10  √  null General Ledger Category
categoryname varchar 60  √  null Name of the Category
c_period_id numeric 10  √  null Period of the Calendar
gl_budget_id numeric 10  √  null 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 Unit of Measure
qty numeric 0  √  0 Quantity
c_validcombination_id numeric 10  √  null Valid Account Combination
orgvalue varchar 40  √  null Key of the Organization
ad_org_id numeric 10  √  null Organizational entity within client
account_id numeric 10  √  null Account used
accountvalue varchar 40  √  null Key of Account Element
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
orgtrxvalue varchar 40  √  null Key of the Transaction Organization
m_product_id numeric 10  √  null 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 Identifies a Business Partner
bpartnervalue varchar 40  √  null Key of the Business Partner
c_project_id numeric 10  √  null Financial Project
projectvalue varchar 40  √  null Key of the Project
c_locto_id numeric 10  √  null Location that inventory was moved to
c_locfrom_id numeric 10  √  null Location that inventory was moved from
c_salesregion_id numeric 10  √  null Sales coverage region
c_activity_id numeric 10  √  null Business Activity
c_campaign_id numeric 10  √  null Marketing Campaign
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null 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:47 +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

Close relationships  within of separation: