Table erp.COMPIERE.C_ELEMENTVALUE

Generated by SchemaSpy

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 C_ELEMENTVALUE_ID number 10 C_ACCTSCHEMA_ELEMENT C_ELEMENTVALUE_ID CELEMENTVALUE_CASCHEMAELEMENT C_CASH USER1_ID CELEMENTVALUEUSER1_CCASH C_CASH USER2_ID CELEMENTVALUEUSER2_CCASH C_ELEMENTVALUE_TRL C_ELEMENTVALUE_ID CELEMENTVALUE_CEVALUETRL C_INVOICE USER1_ID CELEMENTVALUEUSER1_CINVOICE C_INVOICE USER2_ID CELEMENTVALUEUSER2_CINVOICE C_INVOICEBATCHLINE USER1_ID CELEMENTVALUEU1_CINVOICEBLINE C_INVOICEBATCHLINE USER2_ID CELEMENTVALUEU2_CINVOICEBLINE C_ORDER USER1_ID CELEMENTVALUEUSER1_CORDER C_ORDER USER2_ID CELEMENRVALUEUSER2_CORDER C_PAYMENT USER1_ID CELEMENTVALUEUSER1_CPAYMENT C_PAYMENT USER2_ID CELEMENTVALUEUSER2_CPAYMENT C_SUBACCT C_ELEMENTVALUE_ID CELEMENTVALUE_CSUBACCT C_VALIDCOMBINATION ACCOUNT_ID CELEMENTVALUEACCOUNT_VC C_VALIDCOMBINATION USER1_ID CELEMENTVALUEUSER1_VC C_VALIDCOMBINATION USER2_ID CELEMENTVALUEUSER2_VC FACT_ACCT ACCOUNT_ID CELEMENTVALUE_FACTACCT FACT_ACCT USER1_ID CELEMENTVALUEUSER1_FACTACCT FACT_ACCT USER2_ID CELEMENTVALUEUSER2_FACTACCT FACT_ACCT_BALANCE ACCOUNT_ID CELEMENTVALUEACCT_FACTACCTBAL FACT_ACCT_BALANCE USER1_ID CELEMENTVALUEU1_FACTACCTBAL FACT_ACCT_BALANCE USER2_ID CELEMENTVALUEU2_FACTACCTBAL GL_DISTRIBUTION ACCOUNT_ID CEVALUEACCT_GLDIST GL_DISTRIBUTION USER1_ID CEVALUEUSER1_GLDIST GL_DISTRIBUTION USER2_ID CEVALUEUSER2_GLDIST GL_DISTRIBUTIONLINE ACCOUNT_ID CEVALUEACCT_GLDISTLINE GL_DISTRIBUTIONLINE USER1_ID CEVALUEUSER1_GLDISTLINE GL_DISTRIBUTIONLINE USER2_ID CEVALUEUSER2_GLDISTLINE GL_FUNDRESTRICTION C_ELEMENTVALUE_ID CELEMENTVALUE_GLFUNDRESTR I_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUE_IELEMENTVALUE I_ELEMENTVALUE PARENTELEMENTVALUE_ID CEVALUEPARENT_IELEMENTVALUE I_GLJOURNAL ACCOUNT_ID CELVALUEACCOUNT_IGLJOURNAL I_GLJOURNAL USER1_ID CEVALUEUSER1_IGLJOURNAL I_GLJOURNAL USER2_ID CELVALUEUSER2_IGLJOURNAL I_REPORTLINE C_ELEMENTVALUE_ID CELEMENTVALUE_IREPORTLINE M_INOUT USER1_ID CELEMENTVALUEUSER1_MINOUT M_INOUT USER2_ID CELEMENTVALUEUSER2_MINOUT M_INVENTORY USER1_ID CELEMENTVALUEUSER1_MINVENT M_INVENTORY USER2_ID CELEMENTVALUEUSER2_MINVENT M_MOVEMENT USER1_ID CELEMENTVALUEUSER1_MMOVE M_MOVEMENT USER2_ID CELEMENTVALUEUSER2_MMOVE M_PRODUCTION USER1_ID CELEMENTVALUEUSER1_MPROD M_PRODUCTION USER2_ID CELEMENTVALUEUSER2_MPROD PA_RATIOELEMENT ACCOUNT_ID CELEMENTVALUE_PARATIOELEMENT PA_REPORTCOLUMN C_ELEMENTVALUE_ID CELEMENTVALUE_PAREPORTCOLUMN PA_REPORTSOURCE C_ELEMENTVALUE_ID CELEMENTVALUE_PAREPORTSOURCE AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_CELEMENTVALUE AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_CELEMENTVALUE ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 VALUE nvarchar2 80 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null ACCOUNTTYPE char 1 ACCOUNTSIGN char 1 ISDOCCONTROLLED char 1  √  'N' C_ELEMENT_ID number 10 C_ELEMENT C_ELEMENT_ID CELEMENT_CELEMENTVALUE ISSUMMARY char 1 'N' VALIDFROM date 7  √  null VALIDTO date 7  √  null POSTACTUAL char 1 'Y' POSTBUDGET char 1 'Y' POSTENCUMBRANCE char 1 'Y' POSTSTATISTICAL char 1 'Y' ISBANKACCOUNT char 1  √  'N' C_BANKACCOUNT_ID number 10  √  null C_BANKACCOUNT C_BANKACCOUNT_ID CBANKACCOUNT_CELEMENTVALUE ISFOREIGNCURRENCY char 1  √  'N' C_CURRENCY_ID number 10  √  null C_CURRENCY C_CURRENCY_ID CCURRENCY_CELEMENTVALUE Table contained 363 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.