Table idempiere11.adempiere.i_fajournal
FA 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
c_subacct_id numeric 10  √  null Sub account for Element Value
userelement1_id numeric 10  √  null User defined accounting Element
userelement2_id numeric 10  √  null User defined accounting Element
i_fajournal_id numeric 10 FA Journal
ad_client_id numeric 10  √  null Tenant for this installation.
ad_orgdoc_id numeric 10  √  null
ad_org.ad_org_id adorgdoc_ifajournal R
Document Organization (independent from account organization)
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_ifajournal R
Performing or initiating organization
ad_org_id numeric 10  √  null Organizational entity within tenant
a_asset_id numeric 10  √  null Asset used internally or by customers
a_entry_type varchar 3  √  null Entry Type
accountvalue varchar 80  √  null Key of Account Element
account_id numeric 10  √  null
c_elementvalue.c_elementvalue_id account_ifajournal R
Account used
acctschemaname varchar 120  √  null Name of the Accounting Schema
amtacctcr numeric 0  √  null Accounted Credit Amount
amtacctdr numeric 0  √  null Accounted Debit Amount
amtsourcecr numeric 0  √  null Source Credit Amount
amtsourcedr numeric 0  √  null Source Debit Amount
bpartnervalue varchar 80  √  null Key of the Business Partner
batchdescription varchar 510  √  null Description of the Batch
batchdocumentno varchar 60  √  null Document Number of the Batch
c_acctschema_id numeric 10  √  null
c_acctschema.c_acctschema_id cacctschema_ifajournal R
Rules for accounting
gl_budget_id numeric 10  √  null
gl_budget.gl_budget_id glbudget_ifajournal R
General Ledger Budget
doctypename varchar 120  √  null Name of the Document Type
description varchar 510  √  null Optional short description of the record
dateacct timestamp 29,6  √  null Accounting Date
currencyratetype bpchar 1  √  null Currency Rate Type
currencyrate numeric 0  √  null Currency Conversion Rate
createdby numeric 10  √  null User who created this records
created timestamp 29,6 statement_timestamp() Date this record was created
conversiontypevalue varchar 40  √  null Key value for the Currency Conversion Rate Type
processing bpchar 1  √  null Process Now
processed bpchar 1  √  null The document has been processed
postingtype bpchar 1  √  null The type of posted amount for the transaction
orgvalue varchar 40  √  null Key of the Organization
orgtrxvalue varchar 40  √  null Key of the Transaction Organization
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_ifajournal R
Product, Service, Item
line numeric 10  √  null Unique line for this document
journaldocumentno varchar 60  √  null Document number of the Journal
isdepreciated varchar 1  √  null The asset will be depreciated
user2_id numeric 10  √  null
c_elementvalue.c_elementvalue_id user2_ifajournal R
User defined list element #2
user1_id numeric 10  √  null
c_elementvalue.c_elementvalue_id user1_ifajournal R
User defined list element #1
updatedby numeric 10  √  null User who updated this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
qty numeric 0  √  null Quantity
projectvalue varchar 40  √  null Key of the Project
productvalue varchar 40  √  null Key of the Product
isactive bpchar 1 The record is active in the system
i_isimported bpchar 1 Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
iso_code varchar 3  √  null Three letter ISO 4217 Code of the Currency
gl_journal_id numeric 10  √  null
gl_journal.gl_journal_id gljournal_ifajournal R
General Ledger Journal
gl_journalline_id numeric 10  √  null
gl_journalline.gl_journalline_id gljournalline_ifajournal R
General Ledger Journal Line
gl_journalbatch_id numeric 10  √  null
gl_journalbatch.gl_journalbatch_id gljournalbatch_ifajournal R
General Ledger Journal Batch
gl_category_id numeric 10  √  null
gl_category.gl_category_id glcategory_ifajournal R
General Ledger Category
clientvalue varchar 80  √  null Key of the Tenant
categoryname varchar 120  √  null Name of the Category
c_validcombination_id numeric 10  √  null
c_validcombination.c_validcombination_id cvalidcombination_ifajournal R
Valid Account Combination
c_uom_id numeric 10  √  null
c_uom.c_uom_id cuom_ifajournal R
Unit of Measure
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_ifajournal R
Business Activity
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_ifajournal R
Identifies a Business Partner
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_ifajournal R
Marketing Campaign
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_ifajournal R
The Currency for this record
c_doctype_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_ifajournal R
Document type or rules
c_locfrom_id numeric 10  √  null
c_location.c_location_id clocfrom_ifajournal R
Location that inventory was moved from
c_locto_id numeric 10  √  null
c_location.c_location_id clocto_ifajournal R
Location that inventory was moved to
c_period_id numeric 10  √  null
c_period.c_period_id cperiod_ifajournal R
Period of the Calendar
c_project_id numeric 10  √  null
c_project.c_project_id cproject_ifajournal R
Financial Project
c_salesregion_id numeric 10  √  null
c_salesregion.c_salesregion_id csalesregion_ifajournal R
Sales coverage region
i_fajournal_uu varchar 36  √  NULL::character varying I_FAJournal_UU

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

Indexes:
Column(s) Type Sort Constraint Name
i_fajournal_id Primary key Asc i_fajournal_key
i_fajournal_uu Must be unique Asc i_fajournal_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.