Table almasdd.COMPIERE.AD_ORG

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 AD_ORG_ID number 10 AD_CLIENTSHARE AD_ORG_ID ADORG_ADCLIENTSHARE AD_COLUMN AD_ORG_ID COLUMNORG AD_FIELD AD_ORG_ID FIELDORG AD_LANGUAGE AD_ORG_ID LANGUAGEORG AD_MENU AD_ORG_ID AD_MENU_ORG AD_MESSAGE AD_ORG_ID MESSAGEORG AD_ORGINFO AD_ORG_ID ADORG_ADORGINFO AD_ORGINFO PARENT_ORG_ID ADORGPARENT_ADORGINFO AD_PREFERENCE AD_ORG_ID AD_PREFERENCE_ORG AD_PROCESS_ACCESS AD_ORG_ID AD_PROCESSTACCESS_ORG AD_REFERENCE AD_ORG_ID REFERENCEORG AD_REF_LIST AD_ORG_ID AD_REFLIST_ORG AD_REF_TABLE AD_ORG_ID REF_TABLEORG AD_ROLE AD_ORG_ID AD_ROLEORG AD_ROLE_ORGACCESS AD_ORG_ID ADORG_ADROLEORGACCESS AD_SEQUENCE AD_ORG_ID SEQUENCEORG AD_SEQUENCE_AUDIT AD_ORG_ID SEQUENCE_AUDITORG AD_SEQUENCE_NO AD_ORG_ID SEQUENCE_NOORG AD_TAB AD_ORG_ID TABORG AD_TABLE AD_ORG_ID TABLEORG AD_TABLE_ACCESS AD_ORG_ID AD_DATAACCESSORG AD_TASK AD_ORG_ID TASKORG AD_TASKINSTANCE AD_ORG_ID TASKINSTANCEORG AD_TASK_ACCESS AD_ORG_ID AD_TASKACCESS_ORG AD_USER AD_ORGTRX_ID ADORGTRX_ADUSER AD_USER AD_ORG_ID AD_USER_ORG AD_USER_ORGACCESS AD_ORG_ID ADORG_ADUSERORGACCESS AD_USER_ROLES AD_ORG_ID AD_USERROLESORG AD_VAL_RULE AD_ORG_ID VAL_RULEORG AD_WF_NODE AD_ORG_ID WF_NODEORG AD_WF_NODENEXT AD_ORG_ID WF_NODENEXTORG AD_WF_PROCESS AD_ORG_ID WF_INSTANCEORG AD_WF_RESPONSIBLE AD_ORG_ID ADORG_ADWFRESPONSIBLE AD_WINDOW AD_ORG_ID WINDOWORG AD_WINDOW_ACCESS AD_ORG_ID AD_FUNCTACCESSORG AD_WORKFLOW AD_ORG_ID WORKFLOWORG AD_WORKFLOW_ACCESS AD_ORG_ID AD_WORKFLOWACCESS_ORG C_ACCTSCHEMA AD_ORG_ID AD_ORG_C_ACCTSCHEMA C_ACCTSCHEMA_ELEMENT AD_ORG_ID ADORGID_C_ASCHEMAELEMENT C_ACCTSCHEMA_ELEMENT ORG_ID ADORG_CASCHEMAELEMENT C_BPARTNER AD_ORGBP_ID ADORG_CBPARTNERORG C_BPARTNER AD_ORG_ID ADORG_CBPARTNER C_BPARTNER_LOCATION AD_ORG_ID C_BUSPARTNER_LOCATIONORG C_CALENDAR AD_ORG_ID C_CALENDARORG C_CASH AD_ORGTRX_ID ADORGTRX_CCASH C_CASH AD_ORG_ID ADORG_CCASH C_CITY AD_ORG_ID C_CITYORG C_COMMISSIONLINE ORG_ID ADORGTRX_CCOMMISSIONLINE C_CONVERSION_RATE AD_ORG_ID C_CONVERSION_RATEORG C_COUNTRY AD_ORG_ID C_COUNTRYORG C_CURRENCY AD_ORG_ID C_CURRENCYORG C_ELEMENT AD_ORG_ID C_ELEMENTORG C_ELEMENTVALUE AD_ORG_ID ADORG_CELEMENTVALUE C_INTERORG_ACCT AD_ORGTO_ID ADORGTO_CINTERORGACCT C_INTERORG_ACCT AD_ORG_ID ADORG_CINTERORGACCT C_INVOICE AD_ORGTRX_ID ADORGTRX_CINVOICE C_INVOICE AD_ORG_ID ADORG_CINVOICE C_INVOICEBATCHLINE AD_ORGTRX_ID ADORGTRX_CINVOICEBATCHLINE C_INVOICEBATCHLINE AD_ORG_ID ADORG_CINVOICEBATCHLINE C_LOCATION AD_ORG_ID ADORG_CLOCATION C_NONBUSINESSDAY AD_ORG_ID C_NONBUSINESDAYSORG C_ORDER AD_ORGTRX_ID ADORGTRX_CORDER C_ORDER AD_ORG_ID ADORG_CORDER C_ORGASSIGNMENT AD_ORG_ID ADORG_CORGASSIGNMENT C_PAYMENT AD_ORGTRX_ID ADORGTRX_CPAYMENT C_PAYMENT AD_ORG_ID ADORG_CPAYMENT C_PERIOD AD_ORG_ID C_PERIODORG C_PROJECT AD_ORG_ID ADORG_CPROJECT C_REGION AD_ORG_ID C_REGIONORG C_UOM AD_ORG_ID C_UOMORG C_UOM_CONVERSION AD_ORG_ID C_UOM_CONVERSIONORG C_VALIDCOMBINATION AD_ORGTRX_ID ADORGTRX_VC C_VALIDCOMBINATION AD_ORG_ID ADORG_VC C_YEAR AD_ORG_ID C_YEARORG FACT_ACCT AD_ORGTRX_ID AD_ORGTRX_FACT_ACCT FACT_ACCT AD_ORG_ID AD_ORG_FACT_ACCT FACT_ACCT_BALANCE AD_ORGTRX_ID ADORGTRX_FACTACCTBAL FACT_ACCT_BALANCE AD_ORG_ID ADORG_FACTACCTBAL GL_DISTRIBUTION AD_ORGTRX_ID ADORGTRX_GLDIST GL_DISTRIBUTION AD_ORG_ID ADORG_GLDIST GL_DISTRIBUTION ORG_ID ADORGORG_GLDIST GL_DISTRIBUTIONLINE AD_ORGTRX_ID ADORGTRX_GLDISTLINE GL_DISTRIBUTIONLINE AD_ORG_ID ADORG_GLDISTLINE GL_DISTRIBUTIONLINE ORG_ID ADORGORG_GLDISTLINE GL_JOURNALLINE AD_ORG_ID ADORG_GLJOURNALLINE I_GLJOURNAL AD_ORGDOC_ID ADORGDOC_IGLJOURNAL I_GLJOURNAL AD_ORGTRX_ID ADORGTRX_IGLJOURNAL I_GLJOURNAL AD_ORG_ID ADORG_IGLJOURNAL I_INVOICE AD_ORGTRX_ID ADORGTRX_IINVOICE I_INVOICE AD_ORG_ID ADORG_IINVOICE I_ORDER AD_ORGTRX_ID ADORGTRX_IORDER I_ORDER AD_ORG_ID ADORG_IORDER M_COST AD_ORG_ID ADORG_M_COST M_COSTDETAIL AD_ORG_ID ADORG_MCOSTDETAIL M_INOUT AD_ORGTRX_ID ADORGTRX_MINOUT M_INOUT AD_ORG_ID ADORG_MINOUT M_INVENTORY AD_ORGTRX_ID ADORGTRX_MINVENTORY M_INVENTORY AD_ORG_ID ADORG_MINVENTORY M_LOCATOR AD_ORG_ID M_WH_LOCATOR_ORG M_MOVEMENT AD_ORGTRX_ID ADORGTRX_MMOVEMENT M_MOVEMENT AD_ORG_ID ADORG_MMOVEMENT M_PRODUCT AD_ORG_ID AD_ORG_MPRODUCT M_PRODUCTION AD_ORGTRX_ID ADORGTRX_MPRODUCTION M_PRODUCTION AD_ORG_ID ADORG_MPRODUCTION M_PRODUCT_PO AD_ORG_ID M_PRODUCTPO_ORG M_STORAGE AD_ORG_ID M_ITEM_STORAGE_ORG M_SUBSTITUTE AD_ORG_ID M_SUBSTITUTE_ORG M_WAREHOUSE AD_ORG_ID M_WAREHOUSE_ORG PA_GOALRESTRICTION AD_ORG_ID ADORG_PAGOALRESTRICTION PA_GOALRESTRICTION ORG_ID ADORG2_PAGOALRESTRICTION PA_REPORT AD_ORG_ID ADORG_PAREPORT PA_REPORTCOLUMN ORG_ID ADORG_PAREPORTCOLUMN PA_REPORTSOURCE ORG_ID ADORG_PAREPORTSOURCE X_POSTAL AD_ORG_ID X_POSTALORG AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_ADORG 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 ISSUMMARY char 1 'N' Table contained 3 rows at ‰Î 3 07 12:14 JST 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.