Table almasdd.COMPIERE.M_ATTRIBUTESETINSTANCE

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_ATTRIBUTESETINSTANCE_ID number 10 A_ASSET M_ATTRIBUTESETINSTANCE_ID MATTRIBUTESETINSTANCE_AASSET C_INVOICELINE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_CINVOICELINE C_LANDEDCOSTALLOCATION M_ATTRIBUTESETINSTANCE_ID MASI_CLANDEDCOSTALLOCATION C_ORDERLINE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_CORDERLINE C_PROJECTISSUE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_CPROJECTISSUE C_PROJECTISSUEMA M_ATTRIBUTESETINSTANCE_ID MASI_CPROJECTISSUEMA C_RFQLINE M_ATTRIBUTESETINSTANCE_ID MASETINSTANCE_CRFQLINE C_RFQRESPONSELINE_V M_ATTRIBUTESETINSTANCE_ID Implied Constraint C_RFQRESPONSELINE_VT M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_ATTRIBUTEINSTANCE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST__MATTRINST M_BOMPRODUCT M_ATTRIBUTESETINSTANCE_ID MASI_MBOMPRODUCT M_COST M_ATTRIBUTESETINSTANCE_ID MASI_MCOST M_COSTDETAIL M_ATTRIBUTESETINSTANCE_ID MASI_MCOSTDETAIL M_COSTQUEUE M_ATTRIBUTESETINSTANCE_ID MASI_MCOSTQUEUE M_INOUTLINE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MINOUTLINE M_INOUTLINEMA M_ATTRIBUTESETINSTANCE_ID MASI_MINOURLINEMA M_INOUTLINEMA_V M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_INOUTLINEMA_VT M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_INOUT_LINECONFIRM_V M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_INOUT_LINECONFIRM_VT M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_INOUT_LINE_V M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_INOUT_LINE_VT M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_INVENTORYLINE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MINVENTORYLINE M_INVENTORYLINEMA M_ATTRIBUTESETINSTANCE_ID MASI_MINVENTORYLINEMA M_MATCHINV M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_MATCHPO M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_MOVEMENTLINE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MMOVEMENTLINE M_MOVEMENTLINEMA M_ATTRIBUTESETINSTANCE_ID MASI_MMOVEMENTLINEMA M_MOVEMENTLINEMA_V M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_MOVEMENTLINEMA_VT M_ATTRIBUTESETINSTANCE_ID Implied Constraint M_PRODUCT M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MPRODUCT M_PRODUCTIONLINE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MPRODUCTIONLINE M_PRODUCTIONLINEMA M_ATTRIBUTESETINSTANCE_ID MASI_MPRODUCTIONLINEMA M_STORAGE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MSTORAGE M_TRANSACTION M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MTRANSACTION M_TRANSACTIONALLOCATION M_ATTRIBUTESETINSTANCE_ID MATTRIBUTESETINST_MTRXALLOC M_TRANSACTION_V M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_COSTDETAIL M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_C_INVOICELINE M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_C_RFQRESPONSE M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_INOUTDETAILS M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_INOUTLINECONFIRM M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_M_TRANSACTION M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_ORDERDETAIL M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_STORAGE M_ATTRIBUTESETINSTANCE_ID Implied Constraint RV_TRANSACTION M_ATTRIBUTESETINSTANCE_ID Implied Constraint T_INVENTORYVALUE M_ATTRIBUTESETINSTANCE_ID MASI_TINVENTORYVALUE T_TRANSACTION M_ATTRIBUTESETINSTANCE_ID MASI_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 M_ATTRIBUTESET_ID number 10  √  null M_ATTRIBUTESET M_ATTRIBUTESET_ID MATTRIBUTESET_MATTRIBSETINST SERNO nvarchar2 80  √  null LOT nvarchar2 80  √  null GUARANTEEDATE date 7  √  null DESCRIPTION nvarchar2 510  √  null M_LOT_ID number 10  √  null M_LOT M_LOT_ID MLOT_MATTRIBUTESETINSTANCE Table contained 4 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.