View almasdd.COMPIERE.RV_C_INVOICE

 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
C_INVOICE_ID number 10
C_INVOICE C_INVOICE_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
CREATED date 7
CREATEDBY number 10
UPDATED date 7
UPDATEDBY number 10
ISSOTRX char 1
DOCUMENTNO nvarchar2 60
DOCSTATUS char 2
DOCACTION char 2
ISPRINTED char 1
ISDISCOUNTPRINTED char 1
PROCESSING char 1  √  null
PROCESSED char 1
ISTRANSFERRED char 1
ISPAID char 1
C_DOCTYPE_ID number 10
C_DOCTYPE C_DOCTYPE_ID Implied Constraint
C_DOCTYPETARGET_ID number 10
C_ORDER_ID number 10  √  null
C_ORDER C_ORDER_ID Implied Constraint
DESCRIPTION nvarchar2 510  √  null
ISAPPROVED char 1
SALESREP_ID number 10  √  null
DATEINVOICED date 7
DATEPRINTED date 7  √  null
DATEACCT date 7
C_BPARTNER_ID number 10
C_BPARTNER C_BPARTNER_ID Implied Constraint
C_BPARTNER_LOCATION_ID number 10
C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID Implied Constraint
AD_USER_ID number 10  √  null
AD_USER AD_USER_ID Implied Constraint
C_BP_GROUP_ID number 10
C_BP_GROUP C_BP_GROUP_ID Implied Constraint
POREFERENCE nvarchar2 40  √  null
DATEORDERED date 7  √  null
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
C_CONVERSIONTYPE_ID number 10  √  null
C_CONVERSIONTYPE C_CONVERSIONTYPE_ID Implied Constraint
PAYMENTRULE char 1
C_PAYMENTTERM_ID number 10
C_PAYMENTTERM C_PAYMENTTERM_ID Implied Constraint
M_PRICELIST_ID number 10
M_PRICELIST M_PRICELIST_ID Implied Constraint
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
ISPAYSCHEDULEVALID char 1
C_COUNTRY_ID number 10
C_COUNTRY C_COUNTRY_ID Implied Constraint
C_REGION_ID number 10  √  null
C_REGION C_REGION_ID Implied Constraint
POSTAL varchar2 10  √  null
CITY nvarchar2 120  √  null
C_CHARGE_ID number 10  √  null
C_CHARGE C_CHARGE_ID Implied Constraint
CHARGEAMT number 22  √  null
TOTALLINES number 22  √  null
GRANDTOTAL number 22  √  null
MULTIPLIER number 22  √  null
View SQL:
SELECT i.C_Invoice_ID, 
i.AD_Client_ID,i.AD_Org_ID,i.IsActive,i.Created,i.CreatedBy,i.Updated,i.UpdatedBy,
i.IsSOTrx, i.DocumentNo, i.DocStatus, i.DocAction, 
i.IsPrinted, i.IsDiscountPrinted, i.Processing, i.Processed, i.IsTransferred, i.IsPaid,
i.C_DocType_ID, i.C_DocTypeTarget_ID, i.C_Order_ID, i.Description, i.IsApproved, 
i.SalesRep_ID, i.DateInvoiced, i.DatePrinted, i.DateAcct,
i.C_BPartner_ID, i.C_BPartner_Location_ID, i.AD_User_ID, b.C_BP_Group_ID,
i.POReference, i.DateOrdered, i.C_Currency_ID, C_ConversionType_ID, i.PaymentRule, i.C_PaymentTerm_ID,
i.M_PriceList_ID, i.C_Campaign_ID, i.C_Project_ID, i.C_Activity_ID, 
    i.IsPayScheduleValid,
    loc.C_Country_ID, loc.C_Region_ID, loc.Postal, loc.City,
-- Amounts
i.C_Charge_ID,
CASE WHEN charAt(d.DocBaseType,3)='C' THEN i.ChargeAmt*-1 ELSE i.ChargeAmt END AS ChargeAmt,
CASE WHEN charAt(d.DocBaseType,3)='C' THEN i.TotalLines*-1 ELSE i.TotalLines END AS TotalLines,
CASE WHEN charAt(d.DocBaseType,3)='C' THEN i.GrandTotal*-1 ELSE i.GrandTotal END AS GrandTotal,
CASE WHEN charAt(d.DocBaseType,3)='C' THEN -1 ELSE 1 END AS Multiplier
FROM  C_Invoice i
 INNER JOIN C_DocType d ON (i.C_DocType_ID=d.C_DocType_ID)
 INNER JOIN C_BPartner b ON (i.C_BPartner_ID=b.C_BPartner_ID)
 INNER JOIN C_BPartner_Location bpl ON (i.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID)
 INNER JOIN C_Location loc ON (bpl.C_Location_ID=loc.C_Location_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.