View almasdd.COMPIERE.C_PAYSELECTION_CHECK_V

 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 char 5  √  null
C_PAYSELECTION_ID number 10
C_PAYSELECTION C_PAYSELECTION_ID Implied Constraint
C_PAYSELECTIONCHECK_ID number 10
C_PAYSELECTIONCHECK C_PAYSELECTIONCHECK_ID Implied Constraint
ORG_LOCATION_ID number 10  √  null
TAXID varchar2 20
C_DOCTYPE_ID number 22  √  null
C_BPARTNER_ID number 10
C_BPARTNER C_BPARTNER_ID Implied Constraint
BPVALUE nvarchar2 80
BPTAXID varchar2 20  √  null
NAICS char 6  √  null
DUNS char 11  √  null
BPGREETING nvarchar2 120  √  null
NAME nvarchar2 120
NAME2 nvarchar2 120  √  null
C_LOCATION_ID number 22  √  null
REFERENCENO nvarchar2 80  √  null
POREFERENCE nvarchar2 40  √  null
PAYDATE date 7
PAYAMT number 22
AMTINWORDS number 22
QTY number 22
PAYMENTRULE char 1
DOCUMENTNO nvarchar2 60  √  null
View SQL:
SELECT psc.AD_Client_ID, psc.AD_Org_ID, 
'en_US' AS AD_Language,
psc.C_PaySelection_ID, psc.C_PaySelectionCheck_ID,
oi.C_Location_ID AS Org_Location_ID, oi.TaxID, 0 AS C_DocType_ID,
bp.C_BPartner_ID, bp.Value AS BPValue, bp.TaxID AS BPTaxID, bp.NAICS, bp.DUNS,
bpg.Greeting AS BPGreeting,
bp.Name, bp.Name2,
bpartnerRemitLocation(bp.C_BPartner_ID) AS C_Location_ID,
bp.ReferenceNo, bp.POReference,
ps.PayDate,
psc.PayAmt, psc.PayAmt AS AmtInWords,
psc.Qty, psc.PaymentRule, psc.DocumentNo
FROM C_PaySelectionCheck psc
INNER JOIN C_PaySelection ps ON (psc.C_PaySelection_ID=ps.C_PaySelection_ID)
INNER JOIN C_BPartner bp ON (psc.C_BPartner_ID=bp.C_BPartner_ID)
LEFT OUTER JOIN C_Greeting bpg on (bp.C_Greeting_ID=bpg.C_Greeting_ID)
INNER JOIN AD_OrgInfo oi ON (psc.AD_Org_ID=oi.AD_Org_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.