Table erp.COMPIERE.C_ACCTSCHEMA

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 C_ACCTSCHEMA_ID number 10 AD_CLIENTINFO C_ACCTSCHEMA1_ID CACCTSCHEMA1_ADCLIENTINFO A_ASSET_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_AASSETACCT A_ASSET_CHANGE_AMT C_ACCTSCHEMA_ID CACCTSCHEMA_AASSETCHANGEAMT A_ASSET_GROUP_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_AASSETGROUPACCT C_ACCTPROCESSOR C_ACCTSCHEMA_ID Implied Constraint C_ACCTSCHEMA_DEFAULT C_ACCTSCHEMA_ID CACCTSCHEMA_DEFAULT C_ACCTSCHEMA_ELEMENT C_ACCTSCHEMA_ID CACCTSCHEMA_CASCHEMAELEMENT C_ACCTSCHEMA_GL C_ACCTSCHEMA_ID CACCTSCHEMA_CACCTSCHEMAGL C_BANKACCOUNT_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CBANKACCOUNTACCT C_BP_CUSTOMER_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CBPCUSTOMERACCT C_BP_EMPLOYEE_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CBPEMPLOYEEACCT C_BP_GROUP_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CBPGROUPACCT C_BP_VENDOR_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CBPVENDORACCT C_CASHBOOK_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CCASHBOOKACCT C_CHARGE_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CCHARGEACCT C_CURRENCY_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CCURRENCYACCT C_INTERORG_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CINTERORGACCT C_PROJECT_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CPROJECTACCT C_REVENUERECOGNITION_PLAN C_ACCTSCHEMA_ID CACCTSCHEMA_CREVRECPLAN C_TAXDECLARATIONACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CTAXDECLACCT C_TAX_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CTAXACCT C_VALIDCOMBINATION C_ACCTSCHEMA_ID CACCTSCHEMA_CVALIDCOMBINATION C_WITHHOLDING_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_CWITHHOLDINGACCT FACT_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_FACTACCT FACT_ACCT_BALANCE C_ACCTSCHEMA_ID CACCTSCHEMA_FACTACCTBAL GL_BUDGETCONTROL C_ACCTSCHEMA_ID CACCTSCHEMA_GLBUDGETCONTROL GL_DISTRIBUTION C_ACCTSCHEMA_ID CACCTSCHEMA_GLDIST GL_FUND C_ACCTSCHEMA_ID CACCTSCHEMA_GLFUND GL_JOURNAL C_ACCTSCHEMA_ID C_ACCTSCHEMA_GL_JOURNAL GL_JOURNALLINE_ACCT_V C_ACCTSCHEMA_ID Implied Constraint I_GLJOURNAL C_ACCTSCHEMA_ID CACCTSCHEMA_IGLJOURNAL M_COST C_ACCTSCHEMA_ID CACCTSCHEMA_MCOST M_COSTDETAIL C_ACCTSCHEMA_ID CACCTSCHEMA_MCOSTDETAIL M_COSTQUEUE C_ACCTSCHEMA_ID CACCTSCHEMA_MCOSTQUEUE M_PRODUCT_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_MPRODUCTACCT M_PRODUCT_CATEGORY_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_MPRODCATACCT M_PRODUCT_COSTING C_ACCTSCHEMA_ID CACCTSCHEMA_MPRODUCTCOSTING M_WAREHOUSE_ACCT C_ACCTSCHEMA_ID CACCTSCHEMA_MWAREHOUSEACCT PA_RATIO C_ACCTSCHEMA_ID CACCTSCHEMA_PARATIO PA_REPORT C_ACCTSCHEMA_ID CACCTSCHEMA_PAREPORT RV_COST C_ACCTSCHEMA_ID Implied Constraint RV_COSTDETAIL C_ACCTSCHEMA_ID Implied Constraint RV_COSTSUMMARY C_ACCTSCHEMA_ID Implied Constraint RV_FACT_ACCT C_ACCTSCHEMA_ID Implied Constraint RV_FACT_ACCT_PERIOD C_ACCTSCHEMA_ID Implied Constraint RV_PRODUCT_COSTING C_ACCTSCHEMA_ID Implied Constraint RV_PROJECTLINEISSUE C_ACCTSCHEMA_ID Implied Constraint T_INVOICEGL_V C_ACCTSCHEMA_ID Implied Constraint T_INVOICEGL_VT C_ACCTSCHEMA_ID Implied Constraint T_TRIALBALANCE C_ACCTSCHEMA_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID AD_CLIENT_C_ACCTSCHEMA AD_ORG_ID number 10 AD_ORG AD_ORG_ID AD_ORG_C_ACCTSCHEMA ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null GAAP char 2 ISACCRUAL char 1 'Y' COSTINGMETHOD char 1 C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID C_CURRENCY_C_ACCTSCHEMA AUTOPERIODCONTROL char 1 'N' C_PERIOD_ID number 10  √  null C_PERIOD C_PERIOD_ID CPERIOD_CACCTSCHEMA PERIOD_OPENHISTORY number 10  √  null PERIOD_OPENFUTURE number 10  √  null SEPARATOR char 1 HASALIAS char 1 'Y' HASCOMBINATION char 1 'Y' ISTRADEDISCOUNTPOSTED char 1 'N' ISDISCOUNTCORRECTSTAX char 1 'N' M_COSTTYPE_ID number 10  √  null M_COSTTYPE M_COSTTYPE_ID MCOSTTYPE_CACCTSCHEMA COSTINGLEVEL char 1 'C' ISADJUSTCOGS char 1 'N' AD_ORGONLY_ID number 10  √  null ISPOSTSERVICES char 1 ('N') ISEXPLICITCOSTADJUSTMENT char 1 ('N') COMMITMENTTYPE char 1 'N' PROCESSING char 1  √  null Table contained 1 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.