Table almasdd.COMPIERE.C_RFQ

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 C_RFQ_ID number 10 C_RFQLINE C_RFQ_ID CRFQ_CRFQLINE C_RFQRESPONSE C_RFQ_ID CRFQ_CRFQRESPONSE C_RFQRESPONSE_V C_RFQ_ID Implied Constraint C_RFQRESPONSE_VT C_RFQ_ID Implied Constraint RV_C_RFQRESPONSE C_RFQ_ID Implied Constraint RV_C_RFQ_UNANSWERED C_RFQ_ID Implied Constraint 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 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null HELP nvarchar2 4000  √  null C_RFQ_TOPIC_ID number 10 C_RFQ_TOPIC C_RFQ_TOPIC_ID CRFQTOPIC_CRFQ C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID CCURRENCY_CRFQ DATERESPONSE date 7 ISRFQRESPONSEACCEPTED char 1 'Y' DATEWORKSTART date 7  √  null DELIVERYDAYS number 10  √  0 DATEWORKCOMPLETE date 7  √  null QUOTETYPE char 1 ISQUOTETOTALAMT char 1 'N' ISQUOTEALLQTY char 1 'Y' ISSELFSERVICE char 1 'N' ISINVITEDVENDORSONLY char 1 'N' C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_CRFQ C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPLOCATION_CRFQ AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_CRFQ SALESREP_ID number 10 AD_USER AD_USER_ID ADUSERSALESREP_CRFQ MARGIN number 22  √  null CREATESO char 1  √  null CREATEPO char 1  √  null PUBLISHRFQ char 1  √  null C_ORDER_ID number 10  √  null C_ORDER C_ORDER_ID CORDER_CRFQ COPYLINES char 1  √  null RANKRFQ char 1  √  null PROCESSING char 1  √  null PROCESSED char 1 'N' DOCUMENTNO nvarchar2 60 '.' Table contained 1 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.