Table almasdd.COMPIERE.M_INOUTLINE

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_INOUTLINE_ID number 10 A_ASSET M_INOUTLINE_ID Implied Constraint A_ASSET_DELIVERY M_INOUTLINE_ID MOUTLINE_AASSETDELIVERY C_INVOICELINE M_INOUTLINE_ID MINOUTLINE_CINVOICELINE C_LANDEDCOST M_INOUTLINE_ID MINOUTLINE_CLANDEDCOST C_PROJECTISSUE M_INOUTLINE_ID MINOUTLINE_CPROJECTISSUE M_COSTDETAIL M_INOUTLINE_ID MINOUTLINE_MCOSTDETAIL M_INOUTLINE REF_INOUTLINE_ID MINOUTLINE_REF M_INOUTLINECONFIRM M_INOUTLINE_ID MINOUTLINE_MINOUTCONFIRM M_INOUTLINEMA M_INOUTLINE_ID MINOUTLINE_MINOUTLINEMA M_INOUTLINEMA_V M_INOUTLINE_ID Implied Constraint M_INOUTLINEMA_VT M_INOUTLINE_ID Implied Constraint M_INOUT_LINECONFIRM_V M_INOUTLINE_ID Implied Constraint M_INOUT_LINECONFIRM_VT M_INOUTLINE_ID Implied Constraint M_INOUT_LINE_V M_INOUTLINE_ID Implied Constraint M_INOUT_LINE_VT M_INOUTLINE_ID Implied Constraint M_MATCHINV M_INOUTLINE_ID MINOUTLINE_MMATCHINV M_MATCHPO M_INOUTLINE_ID MINOUTLINE_MMATCHPO M_PACKAGELINE M_INOUTLINE_ID MINOUTLINE_MPACKAGELINE M_RMALINE M_INOUTLINE_ID MINOUTLINE_MRMALINE M_TRANSACTION M_INOUTLINE_ID MINOUTLINE_MTRANSACTION M_TRANSACTIONALLOCATION M_INOUTLINE_ID MINOUTLINE_MTRXALLOC M_TRANSACTIONALLOCATION OUT_M_INOUTLINE_ID MINOUTLINEOUT_MTRXALLOC M_TRANSACTION_V M_INOUTLINE_ID Implied Constraint RV_ASSET_DELIVERY M_INOUTLINE_ID Implied Constraint RV_COSTDETAIL M_INOUTLINE_ID Implied Constraint RV_INOUTDETAILS M_INOUTLINE_ID Implied Constraint RV_INOUTLINECONFIRM M_INOUTLINE_ID Implied Constraint RV_PROJECTLINEISSUE M_INOUTLINE_ID Implied Constraint RV_TRANSACTION M_INOUTLINE_ID Implied Constraint T_TRANSACTION M_INOUTLINE_ID MINOUTLINE_TTRANSACTION AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint 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 LINE number 10 DESCRIPTION nvarchar2 510  √  null M_INOUT_ID number 10 M_INOUT M_INOUT_ID MINOUT_MINOUTLINE C_ORDERLINE_ID number 10  √  null C_ORDERLINE C_ORDERLINE_ID CORDERLINE_MINOUT M_LOCATOR_ID number 10  √  null M_LOCATOR M_LOCATOR_ID MLOCATOR_MINOUTLINE M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_MINOUTLINE C_UOM_ID number 10 C_UOM C_UOM_ID CUOM_MINOUTLINE MOVEMENTQTY number 22 0 ISINVOICED char 1 'N' M_ATTRIBUTESETINSTANCE_ID number 10  √  0 M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MINOUTLINE ISDESCRIPTION char 1 'N' CONFIRMEDQTY number 22  √  0 PICKEDQTY number 22  √  0 SCRAPPEDQTY number 22  √  0 TARGETQTY number 22  √  0 REF_INOUTLINE_ID number 10  √  null M_INOUTLINE M_INOUTLINE_ID MINOUTLINE_REF PROCESSED char 1 'N' QTYENTERED number 22 C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID Implied Constraint C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID Implied Constraint Table contained 27 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.