View erp.COMPIERE.C_ORDER_HEADER_VT

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
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
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
CREATED date 7
CREATEDBY number 10
UPDATED date 7
UPDATEDBY number 10
AD_LANGUAGE varchar2 6  √  null
AD_LANGUAGE AD_LANGUAGE Implied Constraint
C_ORDER_ID number 10
C_ORDER C_ORDER_ID Implied Constraint
ISSOTRX char 1
DOCUMENTNO nvarchar2 60
DOCSTATUS char 2
C_DOCTYPE_ID number 10
C_DOCTYPE C_DOCTYPE_ID Implied Constraint
C_BPARTNER_ID number 10
C_BPARTNER C_BPARTNER_ID Implied Constraint
BPVALUE nvarchar2 80  √  null
BPTAXID varchar2 20  √  null
NAICS char 6  √  null
DUNS char 11  √  null
ORG_LOCATION_ID number 10  √  null
TAXID varchar2 20
M_WAREHOUSE_ID number 10
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
WAREHOUSE_LOCATION_ID number 10  √  null
DOCUMENTTYPE nvarchar2 120  √  null
DOCUMENTTYPENOTE nvarchar2 4000  √  null
SALESREP_ID number 10  √  null
SALESREP_NAME nvarchar2 120  √  null
DATEORDERED date 7
DATEPROMISED date 7  √  null
BPGREETING nvarchar2 120  √  null
NAME nvarchar2 120  √  null
NAME2 nvarchar2 120  √  null
BPCONTACTGREETING nvarchar2 120  √  null
TITLE nvarchar2 80  √  null
PHONE nvarchar2 80  √  null
CONTACTNAME nvarchar2 120  √  null
C_LOCATION_ID number 10  √  null
C_LOCATION C_LOCATION_ID Implied Constraint
BILL_BPARTNER_ID number 10  √  null
BILL_LOCATION_ID number 10  √  null
BILL_USER_ID number 10  √  null
BILL_BPVALUE nvarchar2 80
BILL_BPTAXID varchar2 20  √  null
BILL_NAME nvarchar2 120
BILL_NAME2 nvarchar2 120  √  null
BILL_TITLE nvarchar2 80  √  null
BILL_PHONE nvarchar2 80  √  null
BILL_CONTACTNAME nvarchar2 120  √  null
BILL_C_LOCATION_ID number 10  √  null
REFERENCENO nvarchar2 80  √  null
DESCRIPTION nvarchar2 510  √  null
POREFERENCE nvarchar2 40  √  null
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
PAYMENTTERM nvarchar2 120  √  null
PAYMENTTERMNOTE nvarchar2 4000  √  null
C_CHARGE_ID number 10  √  null
C_CHARGE C_CHARGE_ID Implied Constraint
CHARGEAMT number 22  √  null
TOTALLINES number 22
GRANDTOTAL number 22
AMTINWORDS number 22
M_PRICELIST_ID number 10
M_PRICELIST M_PRICELIST_ID Implied Constraint
ISTAXINCLUDED char 1
C_CAMPAIGN_ID number 10  √  null
C_CAMPAIGN C_CAMPAIGN_ID Implied Constraint
C_PROJECT_ID number 10  √  null
C_PROJECT C_PROJECT_ID Implied Constraint
C_ACTIVITY_ID number 10  √  null
C_ACTIVITY C_ACTIVITY_ID Implied Constraint
M_SHIPPER_ID number 10  √  null
M_SHIPPER M_SHIPPER_ID Implied Constraint
DELIVERYRULE char 1
DELIVERYVIARULE char 1
PRIORITYRULE char 1
INVOICERULE char 1
View SQL:
SELECT o.AD_Client_ID, o.AD_Org_ID, o.IsActive, o.Created, o.CreatedBy, o.Updated, o.UpdatedBy,
dt.AD_Language,
o.C_Order_ID, o.IsSOTrx, o.DocumentNo, o.DocStatus,  o.C_DocType_ID,
o.C_BPartner_ID, bp.Value AS BPValue, bp.TaxID AS BPTaxID, bp.NAICS, bp.DUNS,
oi.C_Location_ID AS Org_Location_ID, oi.TaxID, 
    o.M_Warehouse_ID, wh.C_Location_ID AS Warehouse_Location_ID,
dt.PrintName AS DocumentType, dt.DocumentNote AS DocumentTypeNote,
o.SalesRep_ID, COALESCE(ubp.Name, u.Name) AS SalesRep_Name,
o.DateOrdered, o.DatePromised,
bpg.Greeting AS BPGreeting,
bp.Name, bp.Name2,
bpcg.Greeting AS BPContactGreeting,
bpc.Title, bpc.Phone,
NULLIF (bpc.Name, bp.Name) AS ContactName,
bpl.C_Location_ID,
    --  Bill to
    o.Bill_BPartner_ID, o.Bill_Location_ID, o.Bill_User_ID,
    bbp.Value AS Bill_BPValue, bbp.TaxID AS Bill_BPTaxID,
    bbp.Name AS Bill_Name, bbp.Name2 AS Bill_Name2,
    bbpc.Title AS Bill_Title, bbpc.Phone AS Bill_Phone,
    NULLIF (bbpc.Name, bbp.Name) AS Bill_ContactName,
    bbpl.C_Location_ID AS Bill_C_Location_ID,
bp.ReferenceNo,
o.Description,
o.POReference,
o.C_Currency_ID,
pt.Name AS PaymentTerm, pt.DocumentNote AS PaymentTermNote,
o.C_Charge_ID, o.ChargeAmt,
o.TotalLines,
o.GrandTotal, o.GrandTotal AS AmtInWords,
o.M_PriceList_ID,
o.IsTaxIncluded,
o.C_Campaign_ID, o.C_Project_ID, o.C_Activity_ID,
o.M_Shipper_ID, o.DeliveryRule, o.DeliveryViaRule, o.PriorityRule, o.InvoiceRule
FROM C_Order o
INNER JOIN C_DocType_Trl dt ON (o.C_DocType_ID=dt.C_DocType_ID)
    INNER JOIN M_Warehouse wh ON (o.M_Warehouse_ID=wh.M_Warehouse_ID)
INNER JOIN C_PaymentTerm_Trl pt ON (o.C_PaymentTerm_ID=pt.C_PaymentTerm_ID AND dt.AD_Language=pt.AD_Language)
INNER JOIN C_BPartner bp ON (o.C_BPartner_ID=bp.C_BPartner_ID)
LEFT OUTER JOIN C_Greeting_Trl bpg ON (bp.C_Greeting_ID=bpg.C_Greeting_ID AND dt.AD_Language=bpg.AD_Language)
INNER JOIN C_BPartner_Location bpl ON (o.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID)
LEFT OUTER JOIN AD_User bpc ON (o.AD_User_ID=bpc.AD_User_ID)
LEFT OUTER JOIN C_Greeting_Trl bpcg ON (bpc.C_Greeting_ID=bpcg.C_Greeting_ID AND dt.AD_Language=bpcg.AD_Language)
INNER JOIN AD_OrgInfo oi ON (o.AD_Org_ID=oi.AD_Org_ID)
LEFT OUTER JOIN AD_User u ON (o.SalesRep_ID=u.AD_User_ID)
LEFT OUTER JOIN C_BPartner ubp ON (u.C_BPartner_ID=ubp.C_BPartner_ID)
    INNER JOIN C_BPartner bbp ON (o.Bill_BPartner_ID=bbp.C_BPartner_ID)
INNER JOIN C_BPartner_Location bbpl ON (o.Bill_Location_ID=bbpl.C_BPartner_Location_ID)
LEFT OUTER JOIN AD_User bbpc ON (o.Bill_User_ID=bbpc.AD_User_ID)
    


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.