Table erp.COMPIERE.C_VALIDCOMBINATION

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_VALIDCOMBINATION_ID number 10 C_ACCTSCHEMA_DEFAULT B_ASSET_ACCT VC_BASSET_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT B_EXPENSE_ACCT VC_BEXPENSE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT B_INTERESTEXP_ACCT VC_BINTERESTEXP_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT B_INTERESTREV_ACCT VC_BINTERESTREV_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT B_INTRANSIT_ACCT VC_BINTRANSIT_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT B_PAYMENTSELECT_ACCT VC_BPAYMENTSELECT_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT B_REVALUATIONGAIN_ACCT VC_BREVALUATIONGAIN_CSCHEMADEF C_ACCTSCHEMA_DEFAULT B_REVALUATIONLOSS_ACCT VC_BREVALUATIONLOSS_CSCHEMADEF C_ACCTSCHEMA_DEFAULT B_SETTLEMENTGAIN_ACCT VC_BSETTLEMENTGAIN_CSCHEMADEFA C_ACCTSCHEMA_DEFAULT B_SETTLEMENTLOSS_ACCT VC_BSETTLEMENTLOSS_CSCHEMADEFA C_ACCTSCHEMA_DEFAULT B_UNALLOCATEDCASH_ACCT VC_BUNALLOCATEDCASH_CSCHEMADEF C_ACCTSCHEMA_DEFAULT B_UNIDENTIFIED_ACCT VC_BUNIDENTIFIED_CSCHEMADEFAUL C_ACCTSCHEMA_DEFAULT CB_ASSET_ACCT VC_CBASSET_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT CB_CASHTRANSFER_ACCT VC_CBCASHTRANSFER_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT CB_DIFFERENCES_ACCT VC_CBDIFFERENCES_CSCHEMADEFAUL C_ACCTSCHEMA_DEFAULT CB_EXPENSE_ACCT VC_CBEXPENSE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT CB_RECEIPT_ACCT VC_CBRECEIPT_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT CH_EXPENSE_ACCT VC_CHEXPENSE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT CH_REVENUE_ACCT VC_CHREVENUE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT C_PREPAYMENT_ACCT VC_CPREPAYMENT_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT C_RECEIVABLE_ACCT VC_CRECEIVABLE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT E_EXPENSE_ACCT VC_EEXPENSE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT E_PREPAYMENT_ACCT VC_EPREPAYMENT_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT NOTINVOICEDRECEIPTS_ACCT VC_NOTINVOICEDRECEIPTS_CSCHEMA C_ACCTSCHEMA_DEFAULT NOTINVOICEDRECEIVABLES_ACCT VC_NOTINVOICEDREC_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT NOTINVOICEDREVENUE_ACCT VC_NOTINVOICEDREVENUE_CSCHEMAD C_ACCTSCHEMA_DEFAULT PAYDISCOUNT_EXP_ACCT VC_PAYDISCOUNTEXP_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT PAYDISCOUNT_REV_ACCT VC_PAYDISCOUNTREV_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT PJ_ASSET_ACCT VC_PJASSET_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT PJ_WIP_ACCT VC_PJWIP_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_ASSET_ACCT VC_PASSET_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_COGS_ACCT VC_PCOGS_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_EXPENSE_ACCT VC_PEXPENSE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_INVOICEPRICEVARIANCE_ACCT VC_PINVOICEPV_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_PURCHASEPRICEVARIANCE_ACCT VC_PPURCHASEPV_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_REVENUE_ACCT VC_PREVENUE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT P_TRADEDISCOUNTGRANT_ACCT VC_PTDISCOUNTGRANT_CSCHEMADEFA C_ACCTSCHEMA_DEFAULT P_TRADEDISCOUNTREC_ACCT VC_PTDISCOUNTREC_CSCHEMADEFAUL C_ACCTSCHEMA_DEFAULT REALIZEDGAIN_ACCT VC_REALIZEDGAIN_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT REALIZEDLOSS_ACCT VC_REALIZEDLOSS_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT T_CREDIT_ACCT VC_TCREDIT_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT T_DUE_ACCT VC_TDUE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT T_EXPENSE_ACCT VC_TEXPENSE_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT T_LIABILITY_ACCT VC_TLIABILITY_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT T_RECEIVABLES_ACCT VC_TREC_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT UNEARNEDREVENUE_ACCT VC_UNEARNEDREVENUE_CSCHEMADEFA C_ACCTSCHEMA_DEFAULT UNREALIZEDGAIN_ACCT VC_UNREALIZEDGAIN_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT UNREALIZEDLOSS_ACCT VC_UNREALIZEDLOSS_CSCHEMADEFAU C_ACCTSCHEMA_DEFAULT V_LIABILITY_ACCT VC_VLIABILITY_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT V_LIABILITY_SERVICES_ACCT VC_VLIABILITYSERVICES_CSCHEMAD C_ACCTSCHEMA_DEFAULT V_PREPAYMENT_ACCT VC_VPREPAYMENT_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT WITHHOLDING_ACCT VC_WITHHOLDING_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT WRITEOFF_ACCT VC_WRITEOFF_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT W_DIFFERENCES_ACCT VC_WDIFFERENCES_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT W_INVACTUALADJUST_ACCT VC_WINVACTUALADJUST_CSCHEMADEF C_ACCTSCHEMA_DEFAULT W_INVENTORY_ACCT VC_WINVENTORY_CSCHEMADEFAULT C_ACCTSCHEMA_DEFAULT W_REVALUATION_ACCT VC_WREVALUATION_CSCHEMADEFAULT C_ACCTSCHEMA_GL CURRENCYBALANCING_ACCT VC_CURRENCYBALANCING_CSCHEMAGL C_ACCTSCHEMA_GL INCOMESUMMARY_ACCT VC_INCOMESUMMARY_CSCHEMAGL C_ACCTSCHEMA_GL INTERCOMPANYDUEFROM_ACCT VC_INTERCOMPANYDUEFROM_CSCHEMA C_ACCTSCHEMA_GL INTERCOMPANYDUETO_ACCT VC_INTERCOMPANYDUETO_CSCHEMAGL C_ACCTSCHEMA_GL PPVOFFSET_ACCT VC_PPVOFFSET_CSCHEMAGL C_ACCTSCHEMA_GL RETAINEDEARNING_ACCT VC_RETAINEDEARNING_CSCHEMAGL C_ACCTSCHEMA_GL SUSPENSEBALANCING_ACCT VC_SUSPENSEBALANCING_CSCHEMAGL C_ACCTSCHEMA_GL SUSPENSEERROR_ACCT VC_SUSPENSEERROR_CSCHEMAGL C_BANKACCOUNT_ACCT B_ASSET_ACCT VC_BASSET_CBANKACCOUNT C_BANKACCOUNT_ACCT B_EXPENSE_ACCT VC_BEXPENSE_CBANKACCOUNT C_BANKACCOUNT_ACCT B_INTERESTEXP_ACCT VC_BINTERESTEXP_CBANKACCOUNT C_BANKACCOUNT_ACCT B_INTERESTREV_ACCT VC_BINTERESTREV_CBANKACCOUNT C_BANKACCOUNT_ACCT B_INTRANSIT_ACCT VC_BINTRANSIT_CBANKACCOUNT C_BANKACCOUNT_ACCT B_PAYMENTSELECT_ACCT VC_BPAYMENTSELECT_CBANKACCOUNT C_BANKACCOUNT_ACCT B_REVALUATIONGAIN_ACCT VC_BREVALUATIONGAIN_CBANKACCOU C_BANKACCOUNT_ACCT B_REVALUATIONLOSS_ACCT VC_BREVALUATIONLOSS_CBANKACCOU C_BANKACCOUNT_ACCT B_SETTLEMENTGAIN_ACCT VC_BSETTLEMENTGAIN_CBANKACCOUN C_BANKACCOUNT_ACCT B_SETTLEMENTLOSS_ACCT VC_BSETTLEMENTLOSS_CBANKACCOUN C_BANKACCOUNT_ACCT B_UNALLOCATEDCASH_ACCT VC_BUNALLOCATEDCASH_CBANKACCOU C_BANKACCOUNT_ACCT B_UNIDENTIFIED_ACCT VC_BUNIDENTIFIED_CBANKACCOUNT C_BP_CUSTOMER_ACCT C_PREPAYMENT_ACCT VC_CPREPAYMENT_CBPCUSTOMER C_BP_CUSTOMER_ACCT C_RECEIVABLE_ACCT VC_CRECEIVABLE_CBPCUSTOMER C_BP_EMPLOYEE_ACCT E_EXPENSE_ACCT VC_EEXPENSE_CBPEMPLOYEE C_BP_EMPLOYEE_ACCT E_PREPAYMENT_ACCT VC_EPREPAYMENT_CBPEMPLOYEE C_BP_GROUP_ACCT C_PREPAYMENT_ACCT VC_CPREPAYMENT_CBPGROUP C_BP_GROUP_ACCT C_RECEIVABLE_ACCT VC_CRECEIVABLE_CBPGROUP C_BP_GROUP_ACCT NOTINVOICEDRECEIPTS_ACCT VC_NOTINVOICEDRECEIPTS_CBPGROU C_BP_GROUP_ACCT NOTINVOICEDRECEIVABLES_ACCT VC_NOTINVOICEDREC_CBPGROUP C_BP_GROUP_ACCT NOTINVOICEDREVENUE_ACCT VC_NOTINVOICEDREVENUE_CBPGROUP C_BP_GROUP_ACCT PAYDISCOUNT_EXP_ACCT VC_PAYDISCOUNTEXP_CBPGROUP C_BP_GROUP_ACCT PAYDISCOUNT_REV_ACCT VC_PAYDISCOUNTREV_CBPGROUP C_BP_GROUP_ACCT UNEARNEDREVENUE_ACCT VC_UNEARNEDREVENUE_CBPGROUP C_BP_GROUP_ACCT V_LIABILITY_ACCT VC_VLIABILITY_CBPGROUP C_BP_GROUP_ACCT V_LIABILITY_SERVICES_ACCT VC_VLIABILITYSERVICES_CBPGROUP C_BP_GROUP_ACCT V_PREPAYMENT_ACCT VC_VPREPAYMENT_CBPGROUP C_BP_GROUP_ACCT WRITEOFF_ACCT VC_WRITEOFF_CBPGROUP C_BP_VENDOR_ACCT V_LIABILITY_ACCT VC_VLIABILITY_CBPVENDOR C_BP_VENDOR_ACCT V_LIABILITY_SERVICES_ACCT VC_VLIABILITYSERVICES_CBPVENDO C_BP_VENDOR_ACCT V_PREPAYMENT_ACCT VC_VPREPAYMENT_CBPVENDOR C_CASHBOOK_ACCT CB_ASSET_ACCT VC_CBASSET_CCASHBOOK C_CASHBOOK_ACCT CB_CASHTRANSFER_ACCT VC_CBCASHTRANSFER_CCASHBOOK C_CASHBOOK_ACCT CB_DIFFERENCES_ACCT VC_CBDIFFERENCES_CCASHBOOK C_CASHBOOK_ACCT CB_EXPENSE_ACCT VC_CBEXPENSE_CCASHBOOK C_CASHBOOK_ACCT CB_RECEIPT_ACCT VC_CBRECEIPT_CCASHBOOK C_CHARGE_ACCT CH_EXPENSE_ACCT VC_CHEXPENSE_CCHARGE C_CHARGE_ACCT CH_REVENUE_ACCT VC_CHREVENUE_CCHARGE C_CURRENCY_ACCT REALIZEDGAIN_ACCT VC_REALIZEDGAIN_CCURRENCY C_CURRENCY_ACCT REALIZEDLOSS_ACCT VC_REALIZEDLOSS_CCURRENCY C_CURRENCY_ACCT UNREALIZEDGAIN_ACCT VC_UNREALIZEDGAIN_CCURRENCY C_CURRENCY_ACCT UNREALIZEDLOSS_ACCT VC_UNREALIZEDLOSS_CCURRENCY C_INTERORG_ACCT INTERCOMPANYDUEFROM_ACCT VC_INTERCOMPANYDUEFROM_CINTERO C_INTERORG_ACCT INTERCOMPANYDUETO_ACCT VC_INTERCOMPANYDUETO_CINTERORG C_PROJECT_ACCT PJ_ASSET_ACCT VC_PJASSET_CPROJECT C_PROJECT_ACCT PJ_WIP_ACCT VC_PJWIP_CPROJECT C_REVENUERECOGNITION_PLAN P_REVENUE_ACCT VC_PREVENUE_CREVENUERECOGNITIO C_REVENUERECOGNITION_PLAN UNEARNEDREVENUE_ACCT VC_UNEARNEDREVENUE_CREVENUEREC C_TAX_ACCT T_CREDIT_ACCT VC_TCREDIT_CTAX C_TAX_ACCT T_DUE_ACCT VC_TDUE_CTAX C_TAX_ACCT T_EXPENSE_ACCT VC_TEXPENSE_CTAX C_TAX_ACCT T_LIABILITY_ACCT VC_TLIABILITY_CTAX C_TAX_ACCT T_RECEIVABLES_ACCT VC_TREC_CTAX C_WITHHOLDING_ACCT WITHHOLDING_ACCT VC_WITHHOLDING_CWITHHOLDING GL_JOURNALLINE C_VALIDCOMBINATION_ID CVC_GLJOURNALLINE GL_JOURNALLINE_ACCT_V C_VALIDCOMBINATION_ID Implied Constraint I_GLJOURNAL C_VALIDCOMBINATION_ID CVALIDCOMBINATION_IGLJOURNAL M_PRODUCT_ACCT P_ASSET_ACCT VC_PASSET_MPRODUCT M_PRODUCT_ACCT P_COGS_ACCT VC_PCOGS_MPRODUCT M_PRODUCT_ACCT P_EXPENSE_ACCT VC_PEXPENSE_MPRODUCT M_PRODUCT_ACCT P_INVOICEPRICEVARIANCE_ACCT VC_PINVOICEPV_MPRODUCT M_PRODUCT_ACCT P_PURCHASEPRICEVARIANCE_ACCT VC_PPURCHASEPV_MPRODUCT M_PRODUCT_ACCT P_REVENUE_ACCT VC_PREVENUE_MPRODUCT M_PRODUCT_ACCT P_TRADEDISCOUNTGRANT_ACCT VC_PTDISCOUNTGRANT_MPRODUCT M_PRODUCT_ACCT P_TRADEDISCOUNTREC_ACCT VC_PTDISCOUNTREC_MPRODUCT M_PRODUCT_CATEGORY_ACCT P_ASSET_ACCT VC_PASSET_MPRODUCTCATEGORY M_PRODUCT_CATEGORY_ACCT P_COGS_ACCT VC_PCOGS_MPRODUCTCATEGORY M_PRODUCT_CATEGORY_ACCT P_EXPENSE_ACCT VC_PEXPENSE_MPRODUCTCATEGORY M_PRODUCT_CATEGORY_ACCT P_INVOICEPRICEVARIANCE_ACCT VC_PINVOICEPV_MPRODUCTCATEGORY M_PRODUCT_CATEGORY_ACCT P_PURCHASEPRICEVARIANCE_ACCT VC_PPURCHASEPV_MPRODUCTCATEGOR M_PRODUCT_CATEGORY_ACCT P_REVENUE_ACCT VC_PREVENUE_MPRODUCTCATEGORY M_PRODUCT_CATEGORY_ACCT P_TRADEDISCOUNTGRANT_ACCT VC_PTDISCOUNTGRANT_MPRODUCTCAT M_PRODUCT_CATEGORY_ACCT P_TRADEDISCOUNTREC_ACCT VC_PTDISCOUNTREC_MPRODUCTCATEG M_WAREHOUSE_ACCT W_DIFFERENCES_ACCT VC_WDIFFERENCES_MWAREHOUSE M_WAREHOUSE_ACCT W_INVACTUALADJUST_ACCT VC_WINVACTUALADJUST_MWAREHOUSE M_WAREHOUSE_ACCT W_INVENTORY_ACCT VC_WINVENTORY_MWAREHOUSE M_WAREHOUSE_ACCT W_REVALUATION_ACCT VC_WREVALUATION_MWAREHOUSE TEST ACCOUNT_ACCT VC_ACCOUNT_TEST AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_VC AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_VC ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 ALIAS nvarchar2 80  √  null COMBINATION nvarchar2 120  √  null DESCRIPTION nvarchar2 510  √  null ISFULLYQUALIFIED char 1 'Y' C_ACCTSCHEMA_ID number 10 C_ACCTSCHEMA C_ACCTSCHEMA_ID CACCTSCHEMA_CVALIDCOMBINATION ACCOUNT_ID number 10 C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEACCOUNT_VC M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_VC C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_VC AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_VC C_LOCFROM_ID number 10  √  null C_LOCATION C_LOCATION_ID MLOCATIONFROM_VC C_LOCTO_ID number 10  √  null C_LOCATION C_LOCATION_ID MLOCATIONTO_VC C_SALESREGION_ID number 10  √  null C_SALESREGION C_SALESREGION_ID CSALESREGION_VC C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_VC C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID SOCAMPAIGN_VC C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_CVALIDCOMBINATION USER1_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER1_VC USER2_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER2_VC C_SUBACCT_ID number 10  √  null C_SUBACCT C_SUBACCT_ID Implied Constraint USERELEMENT1_ID number 10  √  null USERELEMENT2_ID number 10  √  null Table contained 76 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.