Table erp.COMPIERE.AD_ORGINFO

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

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

Indexes:
Column(s) Type Sort Constraint Name
AD_ORG_ID Primary key Asc AD_ORGINFO_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.