View erp.COMPIERE.C_PAYMENT_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
C_PAYMENT_ID number 10
C_PAYMENT C_PAYMENT_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
DOCUMENTNO nvarchar2 60
DATETRX date 7
ISRECEIPT char 1
C_DOCTYPE_ID number 10
C_DOCTYPE C_DOCTYPE_ID Implied Constraint
TRXTYPE char 1
C_BANKACCOUNT_ID number 10
C_BANKACCOUNT C_BANKACCOUNT_ID Implied Constraint
C_BPARTNER_ID number 10  √  null
C_BPARTNER C_BPARTNER_ID Implied Constraint
C_INVOICE_ID number 10  √  null
C_INVOICE C_INVOICE_ID Implied Constraint
C_BP_BANKACCOUNT_ID number 10  √  null
C_BP_BANKACCOUNT C_BP_BANKACCOUNT_ID Implied Constraint
C_PAYMENTBATCH_ID number 10  √  null
C_PAYMENTBATCH C_PAYMENTBATCH_ID Implied Constraint
TENDERTYPE char 1
CREDITCARDTYPE char 1  √  null
CREDITCARDNUMBER nvarchar2 40  √  null
CREDITCARDVV varchar2 4  √  null
CREDITCARDEXPMM number 10  √  null
CREDITCARDEXPYY number 10  √  null
MICR nvarchar2 40  √  null
ROUTINGNO nvarchar2 40  √  null
ACCOUNTNO nvarchar2 40  √  null
CHECKNO nvarchar2 40  √  null
A_NAME nvarchar2 120  √  null
A_STREET nvarchar2 120  √  null
A_CITY nvarchar2 120  √  null
A_STATE nvarchar2 80  √  null
A_ZIP nvarchar2 40  √  null
A_IDENT_DL nvarchar2 40  √  null
A_IDENT_SSN nvarchar2 40  √  null
A_EMAIL nvarchar2 120  √  null
VOICEAUTHCODE nvarchar2 40  √  null
ORIG_TRXID nvarchar2 40  √  null
PONUM nvarchar2 120  √  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
PAYAMT number 22  √  null
DISCOUNTAMT number 22  √  null
WRITEOFFAMT number 22  √  null
TAXAMT number 22  √  null
OVERUNDERAMT number 22  √  null
MULTIPLIERAP number 22  √  null
ISOVERUNDERPAYMENT char 1
ISAPPROVED char 1
R_PNREF nvarchar2 40  √  null
R_RESULT nvarchar2 40  √  null
R_RESPMSG nvarchar2 120  √  null
R_AUTHCODE nvarchar2 40  √  null
R_AVSADDR char 1  √  null
R_AVSZIP char 1  √  null
R_INFO nvarchar2 4000  √  null
PROCESSING char 1  √  null
OPROCESSING char 1  √  null
DOCSTATUS char 2
DOCACTION char 2
ISPREPAYMENT char 1
C_CHARGE_ID number 10  √  null
C_CHARGE C_CHARGE_ID Implied Constraint
ISRECONCILED char 1
ISALLOCATED char 1
ISONLINE char 1
PROCESSED char 1
POSTED char 1
View SQL:
SELECT C_Payment_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy,
    DocumentNo, DateTrx, IsReceipt, C_DocType_ID, TrxType,
    C_BankAccount_ID, C_BPartner_ID, C_Invoice_ID, C_BP_BankAccount_ID, C_PaymentBatch_ID,
    TenderType, CreditCardType, CreditCardNumber, CreditCardVV, CreditCardExpMM, CreditCardExpYY,
    Micr, RoutingNo, AccountNo, CheckNo,
    A_Name, A_Street, A_City, A_State, A_Zip, A_Ident_DL, A_Ident_SSN, A_EMail,
    VoiceAuthCode, Orig_TrxID, PONum,
    C_Currency_ID, C_ConversionType_ID,
    CASE IsReceipt WHEN 'Y' THEN PayAmt ELSE PayAmt*-1 END AS PayAmt,
    CASE IsReceipt WHEN 'Y' THEN DiscountAmt ELSE DiscountAmt*-1 END AS DiscountAmt, 
    CASE IsReceipt WHEN 'Y' THEN WriteOffAmt ELSE WriteOffAmt*-1 END AS WriteOffAmt,
    CASE IsReceipt WHEN 'Y' THEN TaxAmt ELSE TaxAmt*-1 END AS TaxAmt, 
    CASE IsReceipt WHEN 'Y' THEN OverUnderAmt ELSE OverUnderAmt*-1 END AS OverUnderAmt,
    CASE IsReceipt WHEN 'Y' THEN 1 ELSE -1 END AS MultiplierAP,
    IsOverUnderPayment, IsApproved,
    R_PnRef, R_Result, R_RespMsg, R_AuthCode, R_AvsAddr, R_AvsZip, R_Info,
    Processing, OProcessing, DocStatus, DocAction,
    IsPrepayment, C_Charge_ID,
    IsReconciled, IsAllocated, IsOnline, Processed, Posted
FROM C_Payment


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.