Table erp.COMPIERE.C_CURRENCY

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_CURRENCY_ID number 10 AD_REGISTRATION C_CURRENCY_ID Implied Constraint AD_ROLE C_CURRENCY_ID C_CURRENCY_AD_ROLE C_ACCTSCHEMA C_CURRENCY_ID C_CURRENCY_C_ACCTSCHEMA C_ALLOCATIONHDR C_CURRENCY_ID CCURRENCY_CALLOCATION C_BANKACCOUNT C_CURRENCY_ID CCURRENCY_CBANKACCOUNT C_BANKSTATEMENTLINE C_CURRENCY_ID CCURRENCY_CBANKSTMTLINE C_CASHBOOK C_CURRENCY_ID CCURRENCY_CCASHBOOK C_CASHLINE C_CURRENCY_ID CCURRENCY_CCASHLINE C_COMMISSION C_CURRENCY_ID CCURRENCY_CCOMMISSION C_COMMISSIONDETAIL C_CURRENCY_ID CCURRENCY_CCOMMISSIONDETAIL C_CONVERSION_RATE C_CURRENCY_ID CCURRENCY_CCONVERSIONRATE C_CONVERSION_RATE C_CURRENCY_ID_TO C_CURRENCYCONVRATETO C_COUNTRY C_CURRENCY_ID CCURRENCY_CCOUNTRY C_CURRENCY_ACCT C_CURRENCY_ID CCURRENCY_CCURRENCYACCT C_CURRENCY_TRL C_CURRENCY_ID CCURRENCY_CCURRENCYTRL C_CYCLE C_CURRENCY_ID CCURRENCY_CCYCLE C_DUNNINGRUNENTRY C_CURRENCY_ID CCURRENCY_CDUNNINGRUNENTRY C_ELEMENTVALUE C_CURRENCY_ID CCURRENCY_CELEMENTVALUE C_INVOICE C_CURRENCY_ID CCURRENCY_CINVOICE C_INVOICEBATCH C_CURRENCY_ID CCURRENCY_CINVOICEBATCH C_INVOICE_HEADER_V C_CURRENCY_ID Implied Constraint C_INVOICE_HEADER_VT C_CURRENCY_ID Implied Constraint C_INVOICE_V C_CURRENCY_ID Implied Constraint C_ORDER C_CURRENCY_ID CCURRENCY_CORDER C_ORDERLINE C_CURRENCY_ID CCURRENCY_CORDERLINE C_ORDER_HEADER_V C_CURRENCY_ID Implied Constraint C_ORDER_HEADER_VT C_CURRENCY_ID Implied Constraint C_PAYMENT C_CURRENCY_ID CCURRENCY_CPAYMENT C_PAYMENTPROCESSOR C_CURRENCY_ID CCURRENCY_CPAYMENTPROCESSOR C_PAYMENT_V C_CURRENCY_ID Implied Constraint C_PROJECT C_CURRENCY_ID CCURRENCY_CPROJECT C_PROJECT_HEADER_V C_CURRENCY_ID Implied Constraint C_PROJECT_HEADER_VT C_CURRENCY_ID Implied Constraint C_REVENUERECOGNITION_PLAN C_CURRENCY_ID CCURRENCY_CREVENUERECPLAN C_RFQ C_CURRENCY_ID CCURRENCY_CRFQ C_RFQRESPONSE C_CURRENCY_ID CCURRENCY_CRFQRESPONSE C_RFQRESPONSE_V C_CURRENCY_ID Implied Constraint C_RFQRESPONSE_VT C_CURRENCY_ID Implied Constraint C_TAXDECLARATIONLINE C_CURRENCY_ID CCURRENCY_CTAXDECLLINE FACT_ACCT C_CURRENCY_ID C_CURRENCY_FACT_ACCT GL_JOURNAL C_CURRENCY_ID CCURRENCY_GLJOURNAL GL_JOURNALBATCH C_CURRENCY_ID CCURRENCY_GLJOURNALBATCH GL_JOURNALLINE C_CURRENCY_ID CCURRENCY_GLJOURNALLINE GL_JOURNALLINE_ACCT_V C_CURRENCY_ID Implied Constraint I_BANKSTATEMENT C_CURRENCY_ID CCURRENCY_IBANKSTATEMENT I_CONVERSION_RATE C_CURRENCY_ID CCURRENCY_ICONVRATE I_CONVERSION_RATE C_CURRENCY_ID_TO CCURRENCY_ICONVRATETO I_GLJOURNAL C_CURRENCY_ID CCURRENCY_IGLJOURNAL I_INVOICE C_CURRENCY_ID CCURRENCY_IINVOICE I_ORDER C_CURRENCY_ID CCURRENCY_IORDER I_PAYMENT C_CURRENCY_ID Implied Constraint I_PRODUCT C_CURRENCY_ID CCURRENCY_IPRODUCT M_FREIGHT C_CURRENCY_ID CCURRENCY_MFREIGHT M_PRICELIST C_CURRENCY_ID CCURRENCY_MPRICELIST M_PRODUCT_PO C_CURRENCY_ID CCURRENCY_MPRODUCTPO M_RMA C_CURRENCY_ID Implied Constraint PA_REPORTCOLUMN C_CURRENCY_ID CCURRENCY_PAREPORTCOLUMN RV_ALLOCATION C_CURRENCY_ID Implied Constraint RV_COMMISSIONRUNDETAIL C_CURRENCY_ID Implied Constraint RV_COST C_CURRENCY_ID Implied Constraint RV_COSTDETAIL C_CURRENCY_ID Implied Constraint RV_COSTSUMMARY C_CURRENCY_ID Implied Constraint RV_C_RFQRESPONSE C_CURRENCY_ID Implied Constraint RV_C_RFQ_UNANSWERED C_CURRENCY_ID Implied Constraint RV_FACT_ACCT C_CURRENCY_ID Implied Constraint RV_FACT_ACCT_PERIOD C_CURRENCY_ID Implied Constraint S_TIMEEXPENSELINE C_CURRENCY_ID CCURRENCY_STIMEEXPENSELINE TEST C_CURRENCY_ID Implied Constraint T_AGING C_CURRENCY_ID CCURRENCY_TAGING T_INVENTORYVALUE C_CURRENCY_ID CCURRENCY_TINVENTORYVALUE T_INVOICEGL_V C_CURRENCY_ID Implied Constraint T_INVOICEGL_VT C_CURRENCY_ID Implied Constraint T_TRIALBALANCE C_CURRENCY_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID C_CURRENCYCLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID C_CURRENCYORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 ISO_CODE char 3 CURSYMBOL nvarchar2 20  √  null DESCRIPTION nvarchar2 510 STDPRECISION number 10 COSTINGPRECISION number 10 ISEURO char 1 'N' ISEMUMEMBER char 1 'N' EMUENTRYDATE date 7  √  null EMURATE number 22  √  0 Table contained 173 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.