View erp.COMPIERE.C_PAYSELECTION_REMITTANCE_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
AD_LANGUAGE varchar2 6
AD_LANGUAGE AD_LANGUAGE Implied Constraint
C_PAYSELECTION_ID number 10
C_PAYSELECTION C_PAYSELECTION_ID Implied Constraint
C_PAYSELECTIONLINE_ID number 10
C_PAYSELECTIONLINE C_PAYSELECTIONLINE_ID Implied Constraint
C_PAYSELECTIONCHECK_ID number 10  √  null
C_PAYSELECTIONCHECK C_PAYSELECTIONCHECK_ID Implied Constraint
PAYMENTRULE char 1
LINE number 10
OPENAMT number 22
PAYAMT number 22
DISCOUNTAMT number 22
DIFFERENCEAMT number 22
C_BPARTNER_ID number 10
C_BPARTNER C_BPARTNER_ID Implied Constraint
DOCUMENTNO nvarchar2 60
DATEINVOICED date 7
GRANDTOTAL number 22
AMTINWORDS number 22
View SQL:
SELECT psl.AD_Client_ID, psl.AD_Org_ID, 
l.AD_Language,
psl.C_PaySelection_ID, psl.C_PaySelectionLine_ID, 
psl.C_PaySelectionCheck_ID,
psl.PaymentRule, psl.Line, psl.OpenAmt, psl.PayAmt, psl.DiscountAmt, psl.DifferenceAmt, 
i.C_BPartner_ID, i.DocumentNo, i.DateInvoiced, i.GrandTotal, i.GrandTotal AS AmtInWords
FROM C_PaySelectionLine psl
  INNER JOIN C_Invoice i ON (psl.C_Invoice_ID=i.C_Invoice_ID)
  INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')


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.