Table erp.COMPIERE.C_ORDER

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_ORDER_ID number 10 B_BUYERFUNDS C_ORDER_ID CORDER_BBUYERSFUNDS B_SELLERFUNDS C_ORDER_ID CORDER_BSELLERFUNDS C_ALLOCATIONLINE C_ORDER_ID CORDER_CALLOCATION C_INVOICE C_ORDER_ID CORDER_CINVOICE C_INVOICE_HEADER_V C_ORDER_ID Implied Constraint C_INVOICE_HEADER_VT C_ORDER_ID Implied Constraint C_INVOICE_V C_ORDER_ID Implied Constraint C_ORDER REF_ORDER_ID CORDER_REF C_ORDERLINE C_ORDER_ID CORDER_CORDERLINE C_ORDERTAX C_ORDER_ID CORDER_CORDERTAX C_ORDER_HEADER_V C_ORDER_ID Implied Constraint C_ORDER_HEADER_VT C_ORDER_ID Implied Constraint C_PAYMENT C_ORDER_ID Implied Constraint C_PROJECTLINE C_ORDERPO_ID CORDERPO_CPROJECTLINE C_PROJECTLINE C_ORDER_ID CORDER_CPROJECTLINE C_PROJECTPHASE C_ORDER_ID CORDER_CPROJECTPHASE C_RECURRING C_ORDER_ID CORDER_CRECURRING C_RECURRING_RUN C_ORDER_ID CORDER_CRECURRINGRUN C_RFQ C_ORDER_ID CORDER_CRFQ C_RFQRESPONSE C_ORDER_ID CORDER_CRFQRESPONSE I_ORDER C_ORDER_ID CORDER_IORDER M_INOUT C_ORDER_ID CORDER_MINOUT M_INOUTCONFIRM_V C_ORDER_ID Implied Constraint M_INOUTCONFIRM_VT C_ORDER_ID Implied Constraint M_INOUT_CANDIDATE_V C_ORDER_ID Implied Constraint M_INOUT_HEADER_V C_ORDER_ID Implied Constraint M_INOUT_HEADER_VT C_ORDER_ID Implied Constraint M_RMA C_ORDER_ID Implied Constraint RV_ALLOCATION C_ORDER_ID Implied Constraint RV_INOUTCONFIRM C_ORDER_ID Implied Constraint RV_INOUTLINECONFIRM C_ORDER_ID Implied Constraint R_REQUEST C_ORDER_ID CORDER_RREQUEST R_REQUESTACTION C_ORDER_ID CORDER_RREQUESTACTION T_INVOICEGL_V C_ORDER_ID Implied Constraint T_INVOICEGL_VT C_ORDER_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_CORDER 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 DOCSTATUS char 2 DOCACTION char 2 PROCESSING char 1  √  null PROCESSED char 1 'N' C_DOCTYPE_ID number 10 C_DOCTYPE C_DOCTYPE_ID C_DOCTYPE_CORDER C_DOCTYPETARGET_ID number 10 C_DOCTYPE C_DOCTYPE_ID CDOCTYPETARGET_CORDER DESCRIPTION nvarchar2 510  √  null ISAPPROVED char 1 'Y' ISCREDITAPPROVED char 1 'N' ISDELIVERED char 1 'N' ISINVOICED char 1 'N' ISPRINTED char 1 'N' ISTRANSFERRED char 1 'N' ISSELECTED char 1 'N' SALESREP_ID number 10  √  null AD_USER AD_USER_ID ADUSER_SR_CORDER DATEORDERED date 7 DATEPROMISED date 7  √  null DATEPRINTED date 7  √  null DATEACCT date 7 C_BPARTNER_ID number 10 C_BPARTNER C_BPARTNER_ID CBPARTNER_CORDER C_BPARTNER_LOCATION_ID number 10 C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_CORDER POREFERENCE nvarchar2 40  √  null ISDISCOUNTPRINTED char 1 'Y' C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID CCURRENCY_CORDER PAYMENTRULE char 1 C_PAYMENTTERM_ID number 10 C_PAYMENTTERM C_PAYMENTTERM_ID CPAYMENTTERM_SOHEADER INVOICERULE char 1 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_CORDER C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID CCHARGE_CORDER CHARGEAMT number 22  √  0 PRIORITYRULE char 1 TOTALLINES number 22 0 GRANDTOTAL number 22 0 M_WAREHOUSE_ID number 10 M_WAREHOUSE M_WAREHOUSE_ID MWAREHOUSE_CORDER M_PRICELIST_ID number 10 M_PRICELIST M_PRICELIST_ID MPRICELIST_SOHEADER ISTAXINCLUDED char 1 'N' C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_CORDER C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_CORDER C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_CORDER POSTED char 1 'N' C_PAYMENT_ID number 10  √  null C_PAYMENT C_PAYMENT_ID CPAYMENT_CORDER C_CASHLINE_ID number 10  √  null C_CASHLINE C_CASHLINE_ID CCASHLINE_CORDER SENDEMAIL char 1 'N' AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_CORDER COPYFROM char 1  √  null ISSELFSERVICE char 1 'N' AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_CORDER USER1_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER1_CORDER USER2_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENRVALUEUSER2_CORDER C_CONVERSIONTYPE_ID number 10  √  null C_CONVERSIONTYPE C_CONVERSIONTYPE_ID CCONVERSIONTYPE_CORDER BILL_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNERBILL_CORDER BILL_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPLOCATIONBILL_CORDER BILL_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSERBILL_CORDER PAY_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNERPAY_CORDER PAY_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPLOCATIONPAY_CORDER REF_ORDER_ID number 10  √  null C_ORDER C_ORDER_ID CORDER_REF ISDROPSHIP char 1 'N' Table contained 7 rows at Wed Mar 15 18:14 SAST 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.