Table almasdd.COMPIERE.M_WAREHOUSE

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 M_WAREHOUSE_ID number 10 AD_ORGINFO M_WAREHOUSE_ID MWAREHOUSE_ADORGINFO AD_ORG_V M_WAREHOUSE_ID Implied Constraint C_BP_EDI M_WAREHOUSE_ID MWAREHOUSE_CBPEDI C_ORDER M_WAREHOUSE_ID MWAREHOUSE_CORDER C_ORDERLINE M_WAREHOUSE_ID MWAREHOUSE_CORDERLINE C_ORDER_HEADER_V M_WAREHOUSE_ID Implied Constraint C_ORDER_HEADER_VT M_WAREHOUSE_ID Implied Constraint C_POS M_WAREHOUSE_ID MWAREHOUSE_CPOS C_PROJECT M_WAREHOUSE_ID MWAREHOUSE_CPROJECT C_PROJECT_HEADER_V M_WAREHOUSE_ID Implied Constraint C_PROJECT_HEADER_VT M_WAREHOUSE_ID Implied Constraint I_INVENTORY M_WAREHOUSE_ID MWAREHOUSE_IINVENTORY I_ORDER M_WAREHOUSE_ID MWAREHOUSE_IORDER M_EDI M_WAREHOUSE_ID MWAREHOUSE_MEDI M_INOUT M_WAREHOUSE_ID MWAREHOUSE_MINOUT M_INOUTCONFIRM_V M_WAREHOUSE_ID Implied Constraint M_INOUTCONFIRM_VT M_WAREHOUSE_ID Implied Constraint M_INOUT_CANDIDATE_V M_WAREHOUSE_ID Implied Constraint M_INOUT_HEADER_V M_WAREHOUSE_ID Implied Constraint M_INOUT_HEADER_VT M_WAREHOUSE_ID Implied Constraint M_INOUT_LINECONFIRM_V M_WAREHOUSE_ID Implied Constraint M_INOUT_LINECONFIRM_VT M_WAREHOUSE_ID Implied Constraint M_INOUT_LINE_V M_WAREHOUSE_ID Implied Constraint M_INOUT_LINE_VT M_WAREHOUSE_ID Implied Constraint M_INVENTORY M_WAREHOUSE_ID MWAREHOUSE_MINVENTORY M_LOCATOR M_WAREHOUSE_ID M_WAREHOUSE_LOCATOR M_PERPETUALINV M_WAREHOUSE_ID MWAREHOUSE_MPERPETUALINV M_REPLENISH M_WAREHOUSE_ID M_WAREHOUSE_REPLENISH M_REQUISITION M_WAREHOUSE_ID MWAREHOUSE_MREQUISITION M_WAREHOUSE_ACCT M_WAREHOUSE_ID M_WAREHOUSE_WAREHOUSE_ACCT RV_INOUTCONFIRM M_WAREHOUSE_ID Implied Constraint RV_INOUTDETAILS M_WAREHOUSE_ID Implied Constraint RV_INOUTLINECONFIRM M_WAREHOUSE_ID Implied Constraint RV_M_REQUISITION M_WAREHOUSE_ID Implied Constraint RV_M_TRANSACTION_SUM M_WAREHOUSE_ID Implied Constraint RV_ORDERDETAIL M_WAREHOUSE_ID Implied Constraint RV_PROJECTCYCLE M_WAREHOUSE_ID Implied Constraint RV_STORAGE M_WAREHOUSE_ID Implied Constraint RV_TRANSACTION M_WAREHOUSE_ID Implied Constraint RV_WAREHOUSEPRICE M_WAREHOUSE_ID Implied Constraint S_RESOURCE M_WAREHOUSE_ID MWAREHOUSE_SRESOURCE S_TIMEEXPENSE M_WAREHOUSE_ID MWAREHOUSE_STIMEEXPENSE T_INVENTORYVALUE M_WAREHOUSE_ID MWAREHOUSE_TINVENTORYVALUE T_REPLENISH M_WAREHOUSESOURCE_ID MWAREHOUSESOURCE_TREPLENISH T_REPLENISH M_WAREHOUSE_ID MWAREHOUSE_TREPLENISH W_STORE M_WAREHOUSE_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID M_WAREHOUSE_CLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID M_WAREHOUSE_ORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 VALUE nvarchar2 80 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null C_LOCATION_ID number 10 C_LOCATION C_LOCATION_ID C_LOCATION_WAREHOUSE SEPARATOR char 1 M_WAREHOUSESOURCE_ID number 10  √  null REPLENISHMENTCLASS nvarchar2 120  √  null Table contained 2 rows at ‰Î 3 07 12:14 JST 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.