Table erp.COMPIERE.AD_CLIENTINFO

Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
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_CLIENT_ID number 10
AD_ACCESSLOG AD_CLIENT_ID Implied Constraint
AD_ALERT AD_CLIENT_ID Implied Constraint
AD_ALERTPROCESSOR AD_CLIENT_ID Implied Constraint
AD_ALERTPROCESSORLOG AD_CLIENT_ID Implied Constraint
AD_ALERTRECIPIENT AD_CLIENT_ID Implied Constraint
AD_ALERTRULE AD_CLIENT_ID Implied Constraint
AD_ARCHIVE AD_CLIENT_ID Implied Constraint
AD_ATTACHMENT AD_CLIENT_ID Implied Constraint
AD_ATTACHMENTNOTE AD_CLIENT_ID Implied Constraint
AD_ATTRIBUTE AD_CLIENT_ID Implied Constraint
AD_CHANGELOG AD_CLIENT_ID Implied Constraint
AD_COLOR AD_CLIENT_ID Implied Constraint
AD_COLUMN_ACCESS AD_CLIENT_ID Implied Constraint
AD_COLUMN_TRL AD_CLIENT_ID Implied Constraint
AD_DESKTOP AD_CLIENT_ID Implied Constraint
AD_DESKTOPWORKBENCH AD_CLIENT_ID Implied Constraint
AD_DESKTOP_TRL AD_CLIENT_ID Implied Constraint
AD_ELEMENT AD_CLIENT_ID Implied Constraint
AD_ELEMENT_TRL AD_CLIENT_ID Implied Constraint
AD_ERROR AD_CLIENT_ID Implied Constraint
AD_FIELDGROUP AD_CLIENT_ID Implied Constraint
AD_FIELDGROUP_TRL AD_CLIENT_ID Implied Constraint
AD_FIELD_TRL AD_CLIENT_ID Implied Constraint
AD_FIND AD_CLIENT_ID Implied Constraint
AD_FORM AD_CLIENT_ID Implied Constraint
AD_FORM_ACCESS AD_CLIENT_ID Implied Constraint
AD_FORM_TRL AD_CLIENT_ID Implied Constraint
AD_IMAGE AD_CLIENT_ID Implied Constraint
AD_IMPFORMAT AD_CLIENT_ID Implied Constraint
AD_IMPFORMAT_ROW AD_CLIENT_ID Implied Constraint
AD_ISSUE AD_CLIENT_ID Implied Constraint
AD_LABELPRINTER AD_CLIENT_ID Implied Constraint
AD_LABELPRINTERFUNCTION AD_CLIENT_ID Implied Constraint
AD_MENU_TRL AD_CLIENT_ID Implied Constraint
AD_MESSAGE_TRL AD_CLIENT_ID Implied Constraint
AD_NOTE AD_CLIENT_ID Implied Constraint
AD_ORGINFO AD_CLIENT_ID Implied Constraint
AD_ORGTYPE AD_CLIENT_ID Implied Constraint
AD_ORG_V AD_CLIENT_ID Implied Constraint
AD_PINSTANCE AD_CLIENT_ID Implied Constraint
AD_PINSTANCE_PARA AD_CLIENT_ID Implied Constraint
AD_PRINTCOLOR AD_CLIENT_ID Implied Constraint
AD_PRINTFONT AD_CLIENT_ID Implied Constraint
AD_PRINTFORMAT AD_CLIENT_ID Implied Constraint
AD_PRINTFORMATITEM AD_CLIENT_ID Implied Constraint
AD_PRINTFORMATITEM_TRL AD_CLIENT_ID Implied Constraint
AD_PRINTGRAPH AD_CLIENT_ID Implied Constraint
AD_PRINTLABEL AD_CLIENT_ID Implied Constraint
AD_PRINTLABELLINE AD_CLIENT_ID Implied Constraint
AD_PRINTLABELLINE_TRL AD_CLIENT_ID Implied Constraint
AD_PRINTPAPER AD_CLIENT_ID Implied Constraint
AD_PRINTTABLEFORMAT AD_CLIENT_ID Implied Constraint
AD_PRIVATE_ACCESS AD_CLIENT_ID Implied Constraint
AD_PROCESS AD_CLIENT_ID Implied Constraint
AD_PROCESS_PARA AD_CLIENT_ID Implied Constraint
AD_PROCESS_PARA_TRL AD_CLIENT_ID Implied Constraint
AD_PROCESS_TRL AD_CLIENT_ID Implied Constraint
AD_RECORD_ACCESS AD_CLIENT_ID Implied Constraint
AD_REFERENCE_TRL AD_CLIENT_ID Implied Constraint
AD_REF_LIST_TRL AD_CLIENT_ID Implied Constraint
AD_REPLICATION AD_CLIENT_ID Implied Constraint
AD_REPLICATIONSTRATEGY AD_CLIENT_ID Implied Constraint
AD_REPLICATIONTABLE AD_CLIENT_ID Implied Constraint
AD_REPLICATION_LOG AD_CLIENT_ID Implied Constraint
AD_REPLICATION_RUN AD_CLIENT_ID Implied Constraint
AD_REPORTVIEW AD_CLIENT_ID Implied Constraint
AD_REPORTVIEW_COL AD_CLIENT_ID Implied Constraint
AD_ROLE_ORGACCESS AD_CLIENT_ID Implied Constraint
AD_SCHEDULER AD_CLIENT_ID Implied Constraint
AD_SCHEDULERLOG AD_CLIENT_ID Implied Constraint
AD_SCHEDULERRECIPIENT AD_CLIENT_ID Implied Constraint
AD_SCHEDULER_PARA AD_CLIENT_ID Implied Constraint
AD_SESSION AD_CLIENT_ID Implied Constraint
AD_SYSTEM AD_CLIENT_ID Implied Constraint
AD_TABLE_TRL AD_CLIENT_ID Implied Constraint
AD_TAB_TRL AD_CLIENT_ID Implied Constraint
AD_TASK_TRL AD_CLIENT_ID Implied Constraint
AD_TREE AD_CLIENT_ID Implied Constraint
AD_TREEBAR AD_CLIENT_ID Implied Constraint
AD_TREENODE AD_CLIENT_ID Implied Constraint
AD_TREENODEBP AD_CLIENT_ID Implied Constraint
AD_TREENODEMM AD_CLIENT_ID Implied Constraint
AD_TREENODEPR AD_CLIENT_ID Implied Constraint
AD_USERBPACCESS AD_CLIENT_ID Implied Constraint
AD_USERDEF_FIELD AD_CLIENT_ID Implied Constraint
AD_USERDEF_TAB AD_CLIENT_ID Implied Constraint
AD_USERDEF_WIN AD_CLIENT_ID Implied Constraint
AD_USERMAIL AD_CLIENT_ID Implied Constraint
AD_USERQUERY AD_CLIENT_ID Implied Constraint
AD_USER_ORGACCESS AD_CLIENT_ID Implied Constraint
AD_USER_SUBSTITUTE AD_CLIENT_ID Implied Constraint
AD_WF_ACTIVITY AD_CLIENT_ID Implied Constraint
AD_WF_ACTIVITYRESULT AD_CLIENT_ID Implied Constraint
AD_WF_BLOCK AD_CLIENT_ID Implied Constraint
AD_WF_EVENTAUDIT AD_CLIENT_ID Implied Constraint
AD_WF_NEXTCONDITION AD_CLIENT_ID Implied Constraint
AD_WF_NODE_PARA AD_CLIENT_ID Implied Constraint
AD_WF_NODE_TRL AD_CLIENT_ID Implied Constraint
AD_WF_PROCESSDATA AD_CLIENT_ID Implied Constraint
AD_WF_RESPONSIBLE AD_CLIENT_ID Implied Constraint
AD_WINDOW_TRL AD_CLIENT_ID Implied Constraint
AD_WORKBENCH AD_CLIENT_ID Implied Constraint
AD_WORKBENCHWINDOW AD_CLIENT_ID Implied Constraint
AD_WORKBENCH_TRL AD_CLIENT_ID Implied Constraint
AD_WORKFLOWPROCESSOR AD_CLIENT_ID Implied Constraint
AD_WORKFLOWPROCESSORLOG AD_CLIENT_ID Implied Constraint
AD_WORKFLOW_TRL AD_CLIENT_ID Implied Constraint
A_ASSET AD_CLIENT_ID Implied Constraint
A_ASSET_ACCT AD_CLIENT_ID Implied Constraint
A_ASSET_ADDITION AD_CLIENT_ID Implied Constraint
A_ASSET_CHANGE AD_CLIENT_ID Implied Constraint
A_ASSET_CHANGE_AMT AD_CLIENT_ID Implied Constraint
A_ASSET_DELIVERY AD_CLIENT_ID Implied Constraint
A_ASSET_GROUP AD_CLIENT_ID Implied Constraint
A_ASSET_GROUP_ACCT AD_CLIENT_ID Implied Constraint
A_ASSET_RETIREMENT AD_CLIENT_ID Implied Constraint
A_ASSET_USE AD_CLIENT_ID Implied Constraint
A_DEPRECIATION AD_CLIENT_ID Implied Constraint
A_REGISTRATION AD_CLIENT_ID Implied Constraint
A_REGISTRATIONATTRIBUTE AD_CLIENT_ID Implied Constraint
A_REGISTRATIONPRODUCT AD_CLIENT_ID Implied Constraint
A_REGISTRATIONVALUE AD_CLIENT_ID Implied Constraint
B_BID AD_CLIENT_ID Implied Constraint
B_BIDCOMMENT AD_CLIENT_ID Implied Constraint
B_BUYER AD_CLIENT_ID Implied Constraint
B_BUYERFUNDS AD_CLIENT_ID Implied Constraint
B_OFFER AD_CLIENT_ID Implied Constraint
B_SELLER AD_CLIENT_ID Implied Constraint
B_SELLERFUNDS AD_CLIENT_ID Implied Constraint
B_TOPIC AD_CLIENT_ID Implied Constraint
B_TOPICCATEGORY AD_CLIENT_ID Implied Constraint
B_TOPICTYPE AD_CLIENT_ID Implied Constraint
C_ACCTPROCESSOR AD_CLIENT_ID Implied Constraint
C_ACCTPROCESSORLOG AD_CLIENT_ID Implied Constraint
C_ACCTSCHEMA_DEFAULT AD_CLIENT_ID Implied Constraint
C_ACCTSCHEMA_GL AD_CLIENT_ID Implied Constraint
C_ACTIVITY AD_CLIENT_ID Implied Constraint
C_ALLOCATIONHDR AD_CLIENT_ID Implied Constraint
C_ALLOCATIONLINE AD_CLIENT_ID Implied Constraint
C_BANK AD_CLIENT_ID Implied Constraint
C_BANKACCOUNT AD_CLIENT_ID Implied Constraint
C_BANKACCOUNTDOC AD_CLIENT_ID Implied Constraint
C_BANKACCOUNT_ACCT AD_CLIENT_ID Implied Constraint
C_BANKSTATEMENT AD_CLIENT_ID Implied Constraint
C_BANKSTATEMENTLINE AD_CLIENT_ID Implied Constraint
C_BANKSTATEMENTLOADER AD_CLIENT_ID Implied Constraint
C_BANKSTATEMENTMATCHER AD_CLIENT_ID Implied Constraint
C_BPARTNER_PRODUCT AD_CLIENT_ID Implied Constraint
C_BP_BANKACCOUNT AD_CLIENT_ID Implied Constraint
C_BP_CUSTOMER_ACCT AD_CLIENT_ID Implied Constraint
C_BP_EDI AD_CLIENT_ID Implied Constraint
C_BP_EMPLOYEE_ACCT AD_CLIENT_ID Implied Constraint
C_BP_GROUP AD_CLIENT_ID Implied Constraint
C_BP_GROUP_ACCT AD_CLIENT_ID Implied Constraint
C_BP_RELATION AD_CLIENT_ID Implied Constraint
C_BP_VENDOR_ACCT AD_CLIENT_ID Implied Constraint
C_BP_WITHHOLDING AD_CLIENT_ID Implied Constraint
C_CAMPAIGN AD_CLIENT_ID Implied Constraint
C_CASH AD_CLIENT_ID Implied Constraint
C_CASHBOOK AD_CLIENT_ID Implied Constraint
C_CASHBOOK_ACCT AD_CLIENT_ID Implied Constraint
C_CASHLINE AD_CLIENT_ID Implied Constraint
C_CHANNEL AD_CLIENT_ID Implied Constraint
C_CHARGE AD_CLIENT_ID Implied Constraint
C_CHARGE_ACCT AD_CLIENT_ID Implied Constraint
C_COMMISSION AD_CLIENT_ID Implied Constraint
C_COMMISSIONAMT AD_CLIENT_ID Implied Constraint
C_COMMISSIONDETAIL AD_CLIENT_ID Implied Constraint
C_COMMISSIONLINE AD_CLIENT_ID Implied Constraint
C_COMMISSIONRUN AD_CLIENT_ID Implied Constraint
C_CONVERSIONTYPE AD_CLIENT_ID Implied Constraint
C_COUNTRY_TRL AD_CLIENT_ID Implied Constraint
C_CURRENCY_ACCT AD_CLIENT_ID Implied Constraint
C_CURRENCY_TRL AD_CLIENT_ID Implied Constraint
C_CYCLE AD_CLIENT_ID Implied Constraint
C_CYCLEPHASE AD_CLIENT_ID Implied Constraint
C_CYCLESTEP AD_CLIENT_ID Implied Constraint
C_DOCTYPE AD_CLIENT_ID Implied Constraint
C_DOCTYPECOUNTER AD_CLIENT_ID Implied Constraint
C_DOCTYPE_TRL AD_CLIENT_ID Implied Constraint
C_DUNNING AD_CLIENT_ID Implied Constraint
C_DUNNINGLEVEL AD_CLIENT_ID Implied Constraint
C_DUNNINGLEVEL_TRL AD_CLIENT_ID Implied Constraint
C_DUNNINGRUN AD_CLIENT_ID Implied Constraint
C_DUNNINGRUNENTRY AD_CLIENT_ID Implied Constraint
C_DUNNINGRUNLINE AD_CLIENT_ID Implied Constraint
C_DUNNING_HEADER_V AD_CLIENT_ID Implied Constraint
C_DUNNING_HEADER_VT AD_CLIENT_ID Implied Constraint
C_DUNNING_LINE_V AD_CLIENT_ID Implied Constraint
C_DUNNING_LINE_VT AD_CLIENT_ID Implied Constraint
C_ELEMENTVALUE_TRL AD_CLIENT_ID Implied Constraint
C_GREETING AD_CLIENT_ID Implied Constraint
C_GREETING_TRL AD_CLIENT_ID Implied Constraint
C_INTERORG_ACCT AD_CLIENT_ID Implied Constraint
C_INVOICE AD_CLIENT_ID Implied Constraint
C_INVOICEBATCH AD_CLIENT_ID Implied Constraint
C_INVOICEBATCHLINE AD_CLIENT_ID Implied Constraint
C_INVOICELINE AD_CLIENT_ID Implied Constraint
C_INVOICEPAYSCHEDULE AD_CLIENT_ID Implied Constraint
C_INVOICESCHEDULE AD_CLIENT_ID Implied Constraint
C_INVOICETAX AD_CLIENT_ID Implied Constraint
C_INVOICE_HEADER_V AD_CLIENT_ID Implied Constraint
C_INVOICE_HEADER_VT AD_CLIENT_ID Implied Constraint
C_INVOICE_V AD_CLIENT_ID Implied Constraint
C_JOB AD_CLIENT_ID Implied Constraint
C_JOBASSIGNMENT AD_CLIENT_ID Implied Constraint
C_JOBCATEGORY AD_CLIENT_ID Implied Constraint
C_JOBREMUNERATION AD_CLIENT_ID Implied Constraint
C_LANDEDCOST AD_CLIENT_ID Implied Constraint
C_LANDEDCOSTALLOCATION AD_CLIENT_ID Implied Constraint
C_ORDER AD_CLIENT_ID Implied Constraint
C_ORDERLINE AD_CLIENT_ID Implied Constraint
C_ORDERTAX AD_CLIENT_ID Implied Constraint
C_ORDER_HEADER_V AD_CLIENT_ID Implied Constraint
C_ORDER_HEADER_VT AD_CLIENT_ID Implied Constraint
C_ORGASSIGNMENT AD_CLIENT_ID Implied Constraint
C_PAYMENT AD_CLIENT_ID Implied Constraint
C_PAYMENTALLOCATE AD_CLIENT_ID Implied Constraint
C_PAYMENTBATCH AD_CLIENT_ID Implied Constraint
C_PAYMENTPROCESSOR AD_CLIENT_ID Implied Constraint
C_PAYMENTTERM AD_CLIENT_ID Implied Constraint
C_PAYMENTTERM_TRL AD_CLIENT_ID Implied Constraint
C_PAYMENT_V AD_CLIENT_ID Implied Constraint
C_PAYSCHEDULE AD_CLIENT_ID Implied Constraint
C_PAYSELECTION AD_CLIENT_ID Implied Constraint
C_PAYSELECTIONCHECK AD_CLIENT_ID Implied Constraint
C_PAYSELECTIONLINE AD_CLIENT_ID Implied Constraint
C_PAYSELECTION_REMITTANCE_V AD_CLIENT_ID Implied Constraint
C_PAYSELECTION_REMITTANCE_VT AD_CLIENT_ID Implied Constraint
C_PERIODCONTROL AD_CLIENT_ID Implied Constraint
C_PHASE AD_CLIENT_ID Implied Constraint
C_POS AD_CLIENT_ID Implied Constraint
C_POSKEY AD_CLIENT_ID Implied Constraint
C_POSKEYLAYOUT AD_CLIENT_ID Implied Constraint
C_PROJECTISSUE AD_CLIENT_ID Implied Constraint
C_PROJECTISSUEMA AD_CLIENT_ID Implied Constraint
C_PROJECTLINE AD_CLIENT_ID Implied Constraint
C_PROJECTPHASE AD_CLIENT_ID Implied Constraint
C_PROJECTTASK AD_CLIENT_ID Implied Constraint
C_PROJECTTYPE AD_CLIENT_ID Implied Constraint
C_PROJECT_ACCT AD_CLIENT_ID Implied Constraint
C_PROJECT_DETAILS_V AD_CLIENT_ID Implied Constraint
C_PROJECT_DETAILS_VT AD_CLIENT_ID Implied Constraint
C_PROJECT_HEADER_V AD_CLIENT_ID Implied Constraint
C_PROJECT_HEADER_VT AD_CLIENT_ID Implied Constraint
C_RECURRING AD_CLIENT_ID Implied Constraint
C_RECURRING_RUN AD_CLIENT_ID Implied Constraint
C_REMUNERATION AD_CLIENT_ID Implied Constraint
C_REVENUERECOGNITION AD_CLIENT_ID Implied Constraint
C_REVENUERECOGNITION_PLAN AD_CLIENT_ID Implied Constraint
C_REVENUERECOGNITION_RUN AD_CLIENT_ID Implied Constraint
C_RFQ AD_CLIENT_ID Implied Constraint
C_RFQLINE AD_CLIENT_ID Implied Constraint
C_RFQLINEQTY AD_CLIENT_ID Implied Constraint
C_RFQRESPONSE AD_CLIENT_ID Implied Constraint
C_RFQRESPONSELINE AD_CLIENT_ID Implied Constraint
C_RFQRESPONSELINEQTY AD_CLIENT_ID Implied Constraint
C_RFQRESPONSELINEQTY_V AD_CLIENT_ID Implied Constraint
C_RFQRESPONSELINEQTY_VT AD_CLIENT_ID Implied Constraint
C_RFQRESPONSE_V AD_CLIENT_ID Implied Constraint
C_RFQRESPONSE_VT AD_CLIENT_ID Implied Constraint
C_RFQ_TOPIC AD_CLIENT_ID Implied Constraint
C_RFQ_TOPICSUBSCRIBER AD_CLIENT_ID Implied Constraint
C_RFQ_TOPICSUBSCRIBERONLY AD_CLIENT_ID Implied Constraint
C_SALESREGION AD_CLIENT_ID Implied Constraint
C_SERVICELEVEL AD_CLIENT_ID Implied Constraint
C_SERVICELEVELLINE AD_CLIENT_ID Implied Constraint
C_SUBACCT AD_CLIENT_ID Implied Constraint
C_SUBSCRIPTION AD_CLIENT_ID Implied Constraint
C_SUBSCRIPTIONTYPE AD_CLIENT_ID Implied Constraint
C_SUBSCRIPTION_DELIVERY AD_CLIENT_ID Implied Constraint
C_TASK AD_CLIENT_ID Implied Constraint
C_TAX AD_CLIENT_ID Implied Constraint
C_TAXCATEGORY AD_CLIENT_ID Implied Constraint
C_TAXCATEGORY_TRL AD_CLIENT_ID Implied Constraint
C_TAXDECLARATION AD_CLIENT_ID Implied Constraint
C_TAXDECLARATIONACCT AD_CLIENT_ID Implied Constraint
C_TAXDECLARATIONLINE AD_CLIENT_ID Implied Constraint
C_TAXPOSTAL AD_CLIENT_ID Implied Constraint
C_TAX_ACCT AD_CLIENT_ID Implied Constraint
C_TAX_TRL AD_CLIENT_ID Implied Constraint
C_UOM_TRL AD_CLIENT_ID Implied Constraint
C_USERREMUNERATION AD_CLIENT_ID Implied Constraint
C_WITHHOLDING AD_CLIENT_ID Implied Constraint
C_WITHHOLDING_ACCT AD_CLIENT_ID Implied Constraint
GL_BUDGET AD_CLIENT_ID Implied Constraint
GL_BUDGETCONTROL AD_CLIENT_ID Implied Constraint
GL_CATEGORY AD_CLIENT_ID Implied Constraint
GL_DISTRIBUTION AD_CLIENT_ID Implied Constraint
GL_DISTRIBUTIONLINE AD_CLIENT_ID Implied Constraint
GL_FUND AD_CLIENT_ID Implied Constraint
GL_FUNDRESTRICTION AD_CLIENT_ID Implied Constraint
GL_JOURNAL AD_CLIENT_ID Implied Constraint
GL_JOURNALBATCH AD_CLIENT_ID Implied Constraint
GL_JOURNALLINE_ACCT_V AD_CLIENT_ID Implied Constraint
I_BANKSTATEMENT AD_CLIENT_ID Implied Constraint
I_BPARTNER AD_CLIENT_ID Implied Constraint
I_CONVERSION_RATE AD_CLIENT_ID Implied Constraint
I_ELEMENTVALUE AD_CLIENT_ID Implied Constraint
I_GLJOURNAL AD_CLIENT_ID Implied Constraint
I_INOUTLINECONFIRM AD_CLIENT_ID Implied Constraint
I_INVENTORY AD_CLIENT_ID Implied Constraint
I_INVOICE AD_CLIENT_ID Implied Constraint
I_ORDER AD_CLIENT_ID Implied Constraint
I_PAYMENT AD_CLIENT_ID Implied Constraint
I_PRODUCT AD_CLIENT_ID Implied Constraint
I_REPORTLINE AD_CLIENT_ID Implied Constraint
K_CATEGORY AD_CLIENT_ID Implied Constraint
K_CATEGORYVALUE AD_CLIENT_ID Implied Constraint
K_COMMENT AD_CLIENT_ID Implied Constraint
K_ENTRY AD_CLIENT_ID Implied Constraint
K_ENTRYCATEGORY AD_CLIENT_ID Implied Constraint
K_ENTRYRELATED AD_CLIENT_ID Implied Constraint
K_SOURCE AD_CLIENT_ID Implied Constraint
K_SYNONYM AD_CLIENT_ID Implied Constraint
K_TOPIC AD_CLIENT_ID Implied Constraint
K_TYPE AD_CLIENT_ID Implied Constraint
M_ATTRIBUTE AD_CLIENT_ID Implied Constraint
M_ATTRIBUTEINSTANCE AD_CLIENT_ID Implied Constraint
M_ATTRIBUTESEARCH AD_CLIENT_ID Implied Constraint
M_ATTRIBUTESET AD_CLIENT_ID Implied Constraint
M_ATTRIBUTESETEXCLUDE AD_CLIENT_ID Implied Constraint
M_ATTRIBUTESETINSTANCE AD_CLIENT_ID Implied Constraint
M_ATTRIBUTEUSE AD_CLIENT_ID Implied Constraint
M_ATTRIBUTEVALUE AD_CLIENT_ID Implied Constraint
M_BOM AD_CLIENT_ID Implied Constraint
M_BOMALTERNATIVE AD_CLIENT_ID Implied Constraint
M_BOMPRODUCT AD_CLIENT_ID Implied Constraint
M_CHANGENOTICE AD_CLIENT_ID Implied Constraint
M_CHANGEREQUEST AD_CLIENT_ID Implied Constraint
M_COSTELEMENT AD_CLIENT_ID Implied Constraint
M_COSTQUEUE AD_CLIENT_ID Implied Constraint
M_COSTTYPE AD_CLIENT_ID Implied Constraint
M_DEMAND AD_CLIENT_ID Implied Constraint
M_DEMANDDETAIL AD_CLIENT_ID Implied Constraint
M_DEMANDLINE AD_CLIENT_ID Implied Constraint
M_DISCOUNTSCHEMA AD_CLIENT_ID Implied Constraint
M_DISCOUNTSCHEMABREAK AD_CLIENT_ID Implied Constraint
M_DISCOUNTSCHEMALINE AD_CLIENT_ID Implied Constraint
M_DISTRIBUTIONLIST AD_CLIENT_ID Implied Constraint
M_DISTRIBUTIONLISTLINE AD_CLIENT_ID Implied Constraint
M_DISTRIBUTIONRUN AD_CLIENT_ID Implied Constraint
M_DISTRIBUTIONRUNLINE AD_CLIENT_ID Implied Constraint
M_EDI AD_CLIENT_ID Implied Constraint
M_EDI_INFO AD_CLIENT_ID Implied Constraint
M_FORECAST AD_CLIENT_ID Implied Constraint
M_FORECASTLINE AD_CLIENT_ID Implied Constraint
M_FREIGHT AD_CLIENT_ID Implied Constraint
M_FREIGHTCATEGORY AD_CLIENT_ID Implied Constraint
M_INOUT AD_CLIENT_ID Implied Constraint
M_INOUTCONFIRM AD_CLIENT_ID Implied Constraint
M_INOUTCONFIRM_V AD_CLIENT_ID Implied Constraint
M_INOUTCONFIRM_VT AD_CLIENT_ID Implied Constraint
M_INOUTLINE AD_CLIENT_ID Implied Constraint
M_INOUTLINECONFIRM AD_CLIENT_ID Implied Constraint
M_INOUTLINEMA AD_CLIENT_ID Implied Constraint
M_INOUTLINEMA_V AD_CLIENT_ID Implied Constraint
M_INOUTLINEMA_VT AD_CLIENT_ID Implied Constraint
M_INOUT_CANDIDATE_V AD_CLIENT_ID Implied Constraint
M_INOUT_HEADER_V AD_CLIENT_ID Implied Constraint
M_INOUT_HEADER_VT AD_CLIENT_ID Implied Constraint
M_INOUT_LINECONFIRM_V AD_CLIENT_ID Implied Constraint
M_INOUT_LINECONFIRM_VT AD_CLIENT_ID Implied Constraint
M_INVENTORY AD_CLIENT_ID Implied Constraint
M_INVENTORYLINE AD_CLIENT_ID Implied Constraint
M_INVENTORYLINEMA AD_CLIENT_ID Implied Constraint
M_LOT AD_CLIENT_ID Implied Constraint
M_LOTCTL AD_CLIENT_ID Implied Constraint
M_LOTCTLEXCLUDE AD_CLIENT_ID Implied Constraint
M_MATCHINV AD_CLIENT_ID Implied Constraint
M_MATCHPO AD_CLIENT_ID Implied Constraint
M_MOVEMENT AD_CLIENT_ID Implied Constraint
M_MOVEMENTCONFIRM AD_CLIENT_ID Implied Constraint
M_MOVEMENTLINE AD_CLIENT_ID Implied Constraint
M_MOVEMENTLINECONFIRM AD_CLIENT_ID Implied Constraint
M_MOVEMENTLINEMA AD_CLIENT_ID Implied Constraint
M_MOVEMENTLINEMA_V AD_CLIENT_ID Implied Constraint
M_MOVEMENTLINEMA_VT AD_CLIENT_ID Implied Constraint
M_OPERATIONRESOURCE AD_CLIENT_ID Implied Constraint
M_PACKAGE AD_CLIENT_ID Implied Constraint
M_PACKAGELINE AD_CLIENT_ID Implied Constraint
M_PERPETUALINV AD_CLIENT_ID Implied Constraint
M_PRICELIST AD_CLIENT_ID Implied Constraint
M_PRICELIST_VERSION AD_CLIENT_ID Implied Constraint
M_PRODUCTDOWNLOAD AD_CLIENT_ID Implied Constraint
M_PRODUCTION AD_CLIENT_ID Implied Constraint
M_PRODUCTIONLINE AD_CLIENT_ID Implied Constraint
M_PRODUCTIONLINEMA AD_CLIENT_ID Implied Constraint
M_PRODUCTIONPLAN AD_CLIENT_ID Implied Constraint
M_PRODUCTOPERATION AD_CLIENT_ID Implied Constraint
M_PRODUCTPRICE AD_CLIENT_ID Implied Constraint
M_PRODUCT_ACCT AD_CLIENT_ID Implied Constraint
M_PRODUCT_BOM AD_CLIENT_ID Implied Constraint
M_PRODUCT_CATEGORY AD_CLIENT_ID Implied Constraint
M_PRODUCT_CATEGORY_ACCT AD_CLIENT_ID Implied Constraint
M_PRODUCT_COSTING AD_CLIENT_ID Implied Constraint
M_PRODUCT_TRL AD_CLIENT_ID Implied Constraint
M_RELATEDPRODUCT AD_CLIENT_ID Implied Constraint
M_REPLENISH AD_CLIENT_ID Implied Constraint
M_REQUISITION AD_CLIENT_ID Implied Constraint
M_REQUISITIONLINE AD_CLIENT_ID Implied Constraint
M_RMA AD_CLIENT_ID Implied Constraint
M_RMALINE AD_CLIENT_ID Implied Constraint
M_RMATYPE AD_CLIENT_ID Implied Constraint
M_SERNOCTL AD_CLIENT_ID Implied Constraint
M_SERNOCTLEXCLUDE AD_CLIENT_ID Implied Constraint
M_SHIPPER AD_CLIENT_ID Implied Constraint
M_TRANSACTION AD_CLIENT_ID Implied Constraint
M_TRANSACTIONALLOCATION AD_CLIENT_ID Implied Constraint
M_TRANSACTION_V AD_CLIENT_ID Implied Constraint
M_WAREHOUSE_ACCT AD_CLIENT_ID Implied Constraint
PA_ACHIEVEMENT AD_CLIENT_ID Implied Constraint
PA_BENCHMARK AD_CLIENT_ID Implied Constraint
PA_BENCHMARKDATA AD_CLIENT_ID Implied Constraint
PA_COLORSCHEMA AD_CLIENT_ID Implied Constraint
PA_GOAL AD_CLIENT_ID Implied Constraint
PA_GOALRESTRICTION AD_CLIENT_ID Implied Constraint
PA_HIERARCHY AD_CLIENT_ID Implied Constraint
PA_MEASURE AD_CLIENT_ID Implied Constraint
PA_MEASURECALC AD_CLIENT_ID Implied Constraint
PA_RATIO AD_CLIENT_ID Implied Constraint
PA_RATIOELEMENT AD_CLIENT_ID Implied Constraint
PA_REPORT AD_CLIENT_ID Implied Constraint
PA_REPORTCOLUMN AD_CLIENT_ID Implied Constraint
PA_REPORTCOLUMNSET AD_CLIENT_ID Implied Constraint
PA_REPORTLINE AD_CLIENT_ID Implied Constraint
PA_REPORTLINESET AD_CLIENT_ID Implied Constraint
PA_REPORTSOURCE AD_CLIENT_ID Implied Constraint
PA_SLA_CRITERIA AD_CLIENT_ID Implied Constraint
PA_SLA_GOAL AD_CLIENT_ID Implied Constraint
PA_SLA_MEASURE AD_CLIENT_ID Implied Constraint
RV_ALLOCATION AD_CLIENT_ID Implied Constraint
RV_ASSET_CUSTOMER AD_CLIENT_ID Implied Constraint
RV_ASSET_DELIVERY AD_CLIENT_ID Implied Constraint
RV_BPARTNER AD_CLIENT_ID Implied Constraint
RV_CLICK_UNPROCESSED AD_CLIENT_ID Implied Constraint
RV_COMMISSIONRUNDETAIL AD_CLIENT_ID Implied Constraint
RV_COST AD_CLIENT_ID Implied Constraint
RV_COSTDETAIL AD_CLIENT_ID Implied Constraint
RV_COSTSUMMARY AD_CLIENT_ID Implied Constraint
RV_C_RFQRESPONSE AD_CLIENT_ID Implied Constraint
RV_C_RFQ_UNANSWERED AD_CLIENT_ID Implied Constraint
RV_FACT_ACCT AD_CLIENT_ID Implied Constraint
RV_FACT_ACCT_PERIOD AD_CLIENT_ID Implied Constraint
RV_INOUTCONFIRM AD_CLIENT_ID Implied Constraint
RV_INOUTLINECONFIRM AD_CLIENT_ID Implied Constraint
RV_M_REQUISITION AD_CLIENT_ID Implied Constraint
RV_M_TRANSACTION AD_CLIENT_ID Implied Constraint
RV_M_TRANSACTION_SUM AD_CLIENT_ID Implied Constraint
RV_PRINTFORMATDETAIL AD_CLIENT_ID Implied Constraint
RV_PRODUCT_COSTING AD_CLIENT_ID Implied Constraint
RV_REQUESTUPDATES AD_CLIENT_ID Implied Constraint
RV_TRANSACTION AD_CLIENT_ID Implied Constraint
RV_UNPOSTED AD_CLIENT_ID Implied Constraint
R_CATEGORY AD_CLIENT_ID Implied Constraint
R_CATEGORYUPDATES AD_CLIENT_ID Implied Constraint
R_CONTACTINTEREST AD_CLIENT_ID Implied Constraint
R_GROUP AD_CLIENT_ID Implied Constraint
R_GROUPUPDATES AD_CLIENT_ID Implied Constraint
R_INTERESTAREA AD_CLIENT_ID Implied Constraint
R_ISSUEKNOWN AD_CLIENT_ID Implied Constraint
R_ISSUEPROJECT AD_CLIENT_ID Implied Constraint
R_ISSUERECOMMENDATION AD_CLIENT_ID Implied Constraint
R_ISSUESOURCE AD_CLIENT_ID Implied Constraint
R_ISSUESTATUS AD_CLIENT_ID Implied Constraint
R_ISSUESYSTEM AD_CLIENT_ID Implied Constraint
R_ISSUEUSER AD_CLIENT_ID Implied Constraint
R_MAILTEXT AD_CLIENT_ID Implied Constraint
R_MAILTEXT_TRL AD_CLIENT_ID Implied Constraint
R_REQUEST AD_CLIENT_ID Implied Constraint
R_REQUESTACTION AD_CLIENT_ID Implied Constraint
R_REQUESTPROCESSOR AD_CLIENT_ID Implied Constraint
R_REQUESTPROCESSORLOG AD_CLIENT_ID Implied Constraint
R_REQUESTPROCESSOR_ROUTE AD_CLIENT_ID Implied Constraint
R_REQUESTTYPE AD_CLIENT_ID Implied Constraint
R_REQUESTTYPEUPDATES AD_CLIENT_ID Implied Constraint
R_REQUESTUPDATE AD_CLIENT_ID Implied Constraint
R_REQUESTUPDATES AD_CLIENT_ID Implied Constraint
R_RESOLUTION AD_CLIENT_ID Implied Constraint
R_STANDARDRESPONSE AD_CLIENT_ID Implied Constraint
R_STATUS AD_CLIENT_ID Implied Constraint
R_STATUSCATEGORY AD_CLIENT_ID Implied Constraint
S_EXPENSETYPE AD_CLIENT_ID Implied Constraint
S_RESOURCE AD_CLIENT_ID Implied Constraint
S_RESOURCEASSIGNMENT AD_CLIENT_ID Implied Constraint
S_RESOURCETYPE AD_CLIENT_ID Implied Constraint
S_RESOURCEUNAVAILABLE AD_CLIENT_ID Implied Constraint
S_TIMEEXPENSE AD_CLIENT_ID Implied Constraint
S_TIMEEXPENSELINE AD_CLIENT_ID Implied Constraint
S_TIMETYPE AD_CLIENT_ID Implied Constraint
S_TRAINING AD_CLIENT_ID Implied Constraint
S_TRAINING_CLASS AD_CLIENT_ID Implied Constraint
TEST AD_CLIENT_ID Implied Constraint
TIRE_STORAGE AD_CLIENT_ID Implied Constraint
T_AGING AD_CLIENT_ID Implied Constraint
T_DISTRIBUTIONRUNDETAIL AD_CLIENT_ID Implied Constraint
T_INVENTORYVALUE AD_CLIENT_ID Implied Constraint
T_INVOICEGL AD_CLIENT_ID Implied Constraint
T_INVOICEGL_V AD_CLIENT_ID Implied Constraint
T_INVOICEGL_VT AD_CLIENT_ID Implied Constraint
T_REPLENISH AD_CLIENT_ID Implied Constraint
T_TRANSACTION AD_CLIENT_ID Implied Constraint
T_TRIALBALANCE AD_CLIENT_ID Implied Constraint
W_ADVERTISEMENT AD_CLIENT_ID Implied Constraint
W_BASKET AD_CLIENT_ID Implied Constraint
W_BASKETLINE AD_CLIENT_ID Implied Constraint
W_CLICK AD_CLIENT_ID Implied Constraint
W_CLICKCOUNT AD_CLIENT_ID Implied Constraint
W_COUNTER AD_CLIENT_ID Implied Constraint
W_COUNTERCOUNT AD_CLIENT_ID Implied Constraint
W_MAILMSG AD_CLIENT_ID Implied Constraint
W_MAILMSG_TRL AD_CLIENT_ID Implied Constraint
W_STORE_TRL AD_CLIENT_ID Implied Constraint
AD_CLIENT AD_CLIENT_ID ADCLIENT_ADCLIENTINFO
AD_ORG_ID number 10
AD_ORGINFO AD_ORG_ID Implied Constraint
ISACTIVE char 1 'Y'
CREATED date 7 now
CREATEDBY number 10
UPDATED date 7 now
UPDATEDBY number 10
ISDISCOUNTLINEAMT char 1 'Y'
C_CALENDAR_ID number 10  √  null
C_CALENDAR C_CALENDAR_ID CCALENDAR_ADCLIENTINFO
C_ACCTSCHEMA1_ID number 10  √  null
C_ACCTSCHEMA C_ACCTSCHEMA_ID CACCTSCHEMA1_ADCLIENTINFO
C_UOM_VOLUME_ID number 10  √  null
C_UOM C_UOM_ID C_UOM_VOLUME_AD_CLIENTINFO
C_UOM_WEIGHT_ID number 10  √  null
C_UOM C_UOM_ID C_UOM_WEIGHT_AD_CLIENTINFO
C_UOM_LENGTH_ID number 10  √  null
C_UOM C_UOM_ID C_UOM_LENGTH_AD_CLIENTINFO
C_UOM_TIME_ID number 10  √  null
C_UOM C_UOM_ID C_UOM_TIME_AD_CLIENTINFO
AD_TREE_MENU_ID number 10  √  null
AD_TREE AD_TREE_ID ADTREEMENU_ADCLIENTINFO
AD_TREE_ORG_ID number 10  √  null
AD_TREE AD_TREE_ID ADTREEORG_ADCLIENTINFO
AD_TREE_BPARTNER_ID number 10  √  null
AD_TREE AD_TREE_ID ADTREEBPARTNER_ADCLIENTINFO
AD_TREE_PROJECT_ID number 10  √  null
AD_TREE AD_TREE_ID ADTREEPROJECT_ADCLIENTINFO
AD_TREE_SALESREGION_ID number 10  √  null
AD_TREE AD_TREE_ID ADTREESALESREG_ADCLIENTINFO
AD_TREE_PRODUCT_ID number 10  √  null
AD_TREE AD_TREE_ID ADTREEPRODUCT_ADCLIENTINFO
M_PRODUCTFREIGHT_ID number 10  √  null
C_BPARTNERCASHTRX_ID number 10  √  null
KEEPLOGDAYS number 10  √  null
AD_TREE_ACTIVITY_ID number 10  √  null
AD_TREE_CAMPAIGN_ID number 10  √  null

Table contained 2 rows at Wed Mar 15 18:14 SAST 2006

Indexes:
Column(s) Type Sort Constraint Name
AD_CLIENT_ID Primary key Asc AD_CLIENTINFO_KEY


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.