View erp.COMPIERE.RV_PAYMENT

Generated by
SchemaSpy

Legend:

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	Nulls	Default
C_PAYMENT_ID	undefined	√	null
AD_CLIENT_ID	undefined	√	null
AD_ORG_ID	undefined	√	null
ISACTIVE	undefined	√	null
CREATED	undefined	√	null
CREATEDBY	undefined	√	null
UPDATED	undefined	√	null
UPDATEDBY	undefined	√	null
DOCUMENTNO	undefined	√	null
DATETRX	undefined	√	null
ISRECEIPT	undefined	√	null
C_DOCTYPE_ID	undefined	√	null
TRXTYPE	undefined	√	null
C_BANKACCOUNT_ID	undefined	√	null
C_BPARTNER_ID	undefined	√	null
C_INVOICE_ID	undefined	√	null
C_BP_BANKACCOUNT_ID	undefined	√	null
C_PAYMENTBATCH_ID	undefined	√	null
TENDERTYPE	undefined	√	null
CREDITCARDTYPE	undefined	√	null
CREDITCARDNUMBER	undefined	√	null
CREDITCARDVV	undefined	√	null
CREDITCARDEXPMM	undefined	√	null
CREDITCARDEXPYY	undefined	√	null
MICR	undefined	√	null
ROUTINGNO	undefined	√	null
ACCOUNTNO	undefined	√	null
CHECKNO	undefined	√	null
A_NAME	undefined	√	null
A_STREET	undefined	√	null
A_CITY	undefined	√	null
A_STATE	undefined	√	null
A_ZIP	undefined	√	null
A_IDENT_DL	undefined	√	null
A_IDENT_SSN	undefined	√	null
A_EMAIL	undefined	√	null
VOICEAUTHCODE	undefined	√	null
ORIG_TRXID	undefined	√	null
PONUM	undefined	√	null
C_CURRENCY_ID	undefined	√	null
C_CONVERSIONTYPE_ID	undefined	√	null
PAYAMT	undefined	√	null
DISCOUNTAMT	undefined	√	null
WRITEOFFAMT	undefined	√	null
TAXAMT	undefined	√	null
OVERUNDERAMT	undefined	√	null
MULTIPLIERAP	undefined	√	null
ALLOCATEDAMT	undefined	√	null
AVAILABLEAMT	undefined	√	null
ISOVERUNDERPAYMENT	undefined	√	null
ISAPPROVED	undefined	√	null
R_PNREF	undefined	√	null
R_RESULT	undefined	√	null
R_RESPMSG	undefined	√	null
R_AUTHCODE	undefined	√	null
R_AVSADDR	undefined	√	null
R_AVSZIP	undefined	√	null
R_INFO	undefined	√	null
PROCESSING	undefined	√	null
OPROCESSING	undefined	√	null
DOCSTATUS	undefined	√	null
DOCACTION	undefined	√	null
ISPREPAYMENT	undefined	√	null
C_CHARGE_ID	undefined	√	null
ISRECONCILED	undefined	√	null
ISALLOCATED	undefined	√	null
ISONLINE	undefined	√	null
PROCESSED	undefined	√	null
POSTED	undefined	√	null

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, paymentAllocated(C_Payment_ID, C_Currency_ID) AS AllocatedAmt, paymentAvailable(C_Payment_ID) AS AvailableAmt, 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

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,
    paymentAllocated(C_Payment_ID, C_Currency_ID) AS AllocatedAmt,
    paymentAvailable(C_Payment_ID) AS AvailableAmt,
    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