Table erp.COMPIERE.I_GLJOURNAL

Generated by SchemaSpy

Implied relationships Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents I_GLJOURNAL_ID number 10 AD_CLIENT_ID number 10  √  null AD_CLIENTINFO AD_CLIENT_ID Implied Constraint CLIENTVALUE nvarchar2 80  √  null AD_ORGDOC_ID number 10  √  null AD_ORG AD_ORG_ID ADORGDOC_IGLJOURNAL ISACTIVE char 1  √  'Y' CREATED date 7  √  now CREATEDBY number 10  √  null UPDATED date 7  √  now UPDATEDBY number 10  √  null I_ISIMPORTED char 1 'N' I_ERRORMSG nvarchar2 4000  √  null PROCESSING char 1  √  null PROCESSED char 1  √  'N' GL_JOURNALBATCH_ID number 10  √  null GL_JOURNALBATCH GL_JOURNALBATCH_ID GLJOURNALBATCH_IGLJOURNAL BATCHDOCUMENTNO nvarchar2 60  √  null BATCHDESCRIPTION nvarchar2 510  √  null GL_JOURNAL_ID number 10  √  null GL_JOURNAL GL_JOURNAL_ID GLJOURNAL_IGLJOURNAL JOURNALDOCUMENTNO nvarchar2 60  √  null POSTINGTYPE char 1  √  null C_ACCTSCHEMA_ID number 10  √  null C_ACCTSCHEMA C_ACCTSCHEMA_ID CACCTSCHEMA_IGLJOURNAL ACCTSCHEMANAME nvarchar2 120  √  null C_DOCTYPE_ID number 10  √  null C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_IGLJOURNAL DOCTYPENAME nvarchar2 120  √  null GL_CATEGORY_ID number 10  √  null GL_CATEGORY GL_CATEGORY_ID GLCATEGORY_IGLJOURNAL CATEGORYNAME nvarchar2 120  √  null C_PERIOD_ID number 10  √  null C_PERIOD C_PERIOD_ID CPERIOD_IGLJOURNAL GL_BUDGET_ID number 10  √  null GL_BUDGET GL_BUDGET_ID GLBUDGET_IGLJOURNAL GL_JOURNALLINE_ID number 10  √  null GL_JOURNALLINE GL_JOURNALLINE_ID GLJOURBELLINE_IGLJOURNAL LINE number 10  √  null DATEACCT date 7  √  null DESCRIPTION nvarchar2 510  √  null AMTSOURCEDR number 22  √  0 AMTACCTDR number 22  √  0 AMTSOURCECR number 22  √  0 AMTACCTCR number 22  √  0 C_CURRENCY_ID number 10  √  null C_CURRENCY C_CURRENCY_ID CCURRENCY_IGLJOURNAL ISO_CODE char 3  √  null CONVERSIONTYPEVALUE nvarchar2 80  √  null C_CONVERSIONTYPE_ID number 10  √  null C_CONVERSIONTYPE C_CONVERSIONTYPE_ID CCONVERSIONTYPE_IGLJOURNAL CURRENCYRATE number 22  √  0 C_UOM_ID number 10  √  null C_UOM C_UOM_ID Implied Constraint QTY number 22  √  0 C_VALIDCOMBINATION_ID number 10  √  null C_VALIDCOMBINATION C_VALIDCOMBINATION_ID CVALIDCOMBINATION_IGLJOURNAL ORGVALUE nvarchar2 80  √  null AD_ORG_ID number 10  √  null AD_ORG AD_ORG_ID ADORG_IGLJOURNAL ACCOUNT_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELVALUEACCOUNT_IGLJOURNAL ACCOUNTVALUE nvarchar2 80  √  null AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_IGLJOURNAL ORGTRXVALUE nvarchar2 80  √  null M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_OGLJOURNAL PRODUCTVALUE nvarchar2 80  √  null UPC varchar2 30  √  null SKU varchar2 30  √  null C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_IGLJOURNAL BPARTNERVALUE nvarchar2 80  √  null C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_IGLJOURNAL PROJECTVALUE nvarchar2 80  √  null C_LOCTO_ID number 10  √  null C_LOCATION C_LOCATION_ID CLOCTO_IGLJOURNAL C_LOCFROM_ID number 10  √  null C_LOCATION C_LOCATION_ID CLOCFROM_IGLJOURNAL C_SALESREGION_ID number 10  √  null C_SALESREGION C_SALESREGION_ID CSALESREGION_IGLJOURNAL C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_GLJOURNAL C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_IGLJOURNAL USER1_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CEVALUEUSER1_IGLJOURNAL USER2_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELVALUEUSER2_IGLJOURNAL ISCREATENEWBATCH char 1  √  null ISCREATENEWJOURNAL char 1  √  null Table contained 0 rows at Wed Mar 15 18:14 SAST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.