Table almasdd.COMPIERE.M_INOUT

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_INOUT_ID number 10 C_LANDEDCOST M_INOUT_ID MINOUT_CLANDEDCOST M_INOUT REF_INOUT_ID MINOUT_REF M_INOUTCONFIRM M_INOUT_ID MINOUT_MINOUTCONFIRM M_INOUTCONFIRM_V M_INOUT_ID Implied Constraint M_INOUTCONFIRM_VT M_INOUT_ID Implied Constraint M_INOUTLINE M_INOUT_ID MINOUT_MINOUTLINE M_INOUTLINEMA_V M_INOUT_ID Implied Constraint M_INOUTLINEMA_VT M_INOUT_ID Implied Constraint M_INOUT_HEADER_V M_INOUT_ID Implied Constraint M_INOUT_HEADER_VT M_INOUT_ID Implied Constraint M_INOUT_LINECONFIRM_V M_INOUT_ID Implied Constraint M_INOUT_LINECONFIRM_VT M_INOUT_ID Implied Constraint M_INOUT_LINE_V M_INOUT_ID Implied Constraint M_INOUT_LINE_VT M_INOUT_ID Implied Constraint M_PACKAGE M_INOUT_ID MINOUT_MPACKAGE M_RMA M_INOUT_ID MINOUT_MRMA M_TRANSACTION_V M_INOUT_ID Implied Constraint RV_INOUTCONFIRM M_INOUT_ID Implied Constraint RV_INOUTDETAILS M_INOUT_ID Implied Constraint RV_INOUTLINECONFIRM M_INOUT_ID Implied Constraint RV_TRANSACTION M_INOUT_ID Implied Constraint R_REQUEST M_INOUT_ID MINOUT_RREQUEST R_REQUESTACTION M_INOUT_ID MINOUT_MREQUESTACTION R_REQUEST_V M_INOUT_ID Implied Constraint T_TRANSACTION M_INOUT_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_MINOUT ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 ISSOTRX char 1 'Y' DOCUMENTNO nvarchar2 60 DOCACTION char 2 DOCSTATUS char 2 POSTED char 1 'N' PROCESSING char 1  √  null PROCESSED char 1 'N' C_DOCTYPE_ID number 10 C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_MINOUT DESCRIPTION nvarchar2 510  √  null C_ORDER_ID number 10  √  null C_ORDER C_ORDER_ID CORDER_MINOUT DATEORDERED date 7  √  null ISPRINTED char 1 'N' MOVEMENTTYPE char 2 MOVEMENTDATE date 7 DATEACCT date 7 C_BPARTNER_ID number 10 C_BPARTNER C_BPARTNER_ID CBPARTNER_MINOUT C_BPARTNER_LOCATION_ID number 10 C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID VBPLOCATION_MINOUT M_WAREHOUSE_ID number 10 M_WAREHOUSE M_WAREHOUSE_ID MWAREHOUSE_MINOUT POREFERENCE nvarchar2 40  √  null DELIVERYRULE char 1 FREIGHTCOSTRULE char 1 FREIGHTAMT number 22  √  0 DELIVERYVIARULE char 1 M_SHIPPER_ID number 10  √  null M_SHIPPER M_SHIPPER_ID MSHIPPER_MINOUT C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID CCHARGE_MINOUT CHARGEAMT number 22  √  0 PRIORITYRULE char 1 DATEPRINTED date 7  √  null C_INVOICE_ID number 10  √  null C_INVOICE C_INVOICE_ID Implied Constraint CREATEFROM char 1  √  null GENERATETO char 1  √  null SENDEMAIL char 1 'N' AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_MINOUT SALESREP_ID number 10  √  null AD_USER AD_USER_ID ADUSER_SR_MINOUT NOPACKAGES number 10  √  null PICKDATE date 7  √  null SHIPDATE date 7  √  null TRACKINGNO nvarchar2 120  √  null AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_MINOUT C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_MINOUT C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_MINOUT C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_MINOUT USER1_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER1_MINOUT USER2_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER2_MINOUT DATERECEIVED date 7  √  null ISINTRANSIT char 1 'N' REF_INOUT_ID number 10  √  null M_INOUT M_INOUT_ID MINOUT_REF CREATECONFIRM char 1  √  null CREATEPACKAGE char 1  √  null ISAPPROVED char 1 'N' ISINDISPUTE char 1 'N' Table contained 9 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.