Table erp.COMPIERE.C_PAYMENT

Generated by SchemaSpy

Implied relationships Related columns Constraint names Legend

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 Size Nulls Auto Default Children Parents C_PAYMENT_ID number 10 B_BUYERFUNDS C_PAYMENT_ID CPAYMENT_BBUYERFUNDS B_SELLERFUNDS C_PAYMENT_ID CPAYMENT_BSELLERFUNDS C_ALLOCATIONLINE C_PAYMENT_ID CPAYMENT_CALLOCATIONLINE C_BANKSTATEMENTLINE C_PAYMENT_ID CPAYMENT_CBANKSTMTLINE C_DUNNINGRUNLINE C_PAYMENT_ID CPAYMENT_CDUNNINGRUNLINE C_INVOICE C_PAYMENT_ID CPAYMENT_CINVOICE C_ORDER C_PAYMENT_ID CPAYMENT_CORDER C_PAYMENTALLOCATE C_PAYMENT_ID CPAYMENT_CPAYMENTALLOCATE C_PAYMENT_V C_PAYMENT_ID Implied Constraint C_PAYSELECTIONCHECK C_PAYMENT_ID CPAYMENT_CPAYSELECTIONCHECK C_RECURRING C_PAYMENT_ID CPAYMENT_CRECURRING C_RECURRING_RUN C_PAYMENT_ID CPAYMENT_CRECURRINGRUN I_BANKSTATEMENT C_PAYMENT_ID CPAYMENT_IBANKSTATEMENT I_PAYMENT C_PAYMENT_ID CPAYMENT_IPAYMENT RV_ALLOCATION C_PAYMENT_ID Implied Constraint R_REQUEST C_PAYMENT_ID CPAYMENT_RREQUEST R_REQUESTACTION C_PAYMENT_ID CPAYMENT_RREQUESTACTION TEST C_PAYMENT_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_CPAYMENT ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 DOCUMENTNO nvarchar2 60 DATETRX date 7 ISRECEIPT char 1 'Y' C_DOCTYPE_ID number 10 C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_CPAYMENT TRXTYPE char 1 C_BANKACCOUNT_ID number 10 C_BANKACCOUNT C_BANKACCOUNT_ID CBANKACCOUNT_CPAYMENT C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_CPAYMENT 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 CBPBANKACCT_CPAYMENT C_PAYMENTBATCH_ID number 10  √  null C_PAYMENTBATCH C_PAYMENTBATCH_ID CPAYMENTBATCH_CPAYMENT 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 CCURRENCY_CPAYMENT PAYAMT number 22 0 DISCOUNTAMT number 22  √  0 WRITEOFFAMT number 22  √  0 TAXAMT number 22  √  0 ISAPPROVED char 1 'N' 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 ISRECONCILED char 1 'N' ISALLOCATED char 1 'N' ISONLINE char 1 'N' PROCESSED char 1 'N' POSTED char 1 'N' ISOVERUNDERPAYMENT char 1 'N' OVERUNDERAMT number 22  √  0 A_COUNTRY nvarchar2 80  √  null C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_CPAYMENT ISSELFSERVICE char 1 'N' CHARGEAMT number 22  √  0 C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID CCHARGE_CPAYMENT ISDELAYEDCAPTURE char 1 'N' R_AUTHCODE_DC nvarchar2 40  √  null R_CVV2MATCH char 1  √  null R_PNREF_DC nvarchar2 40  √  null SWIPE varchar2 80  √  null AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_CPAYMENT C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_CPAYMENT C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_CPAYMENT USER1_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER1_CPAYMENT USER2_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER2_CPAYMENT C_CONVERSIONTYPE_ID number 10  √  null C_CONVERSIONTYPE C_CONVERSIONTYPE_ID CCONVERSIONTYPE_CPAYMENT DESCRIPTION nvarchar2 510  √  null DATEACCT date 7 C_ORDER_ID number 10  √  null C_ORDER C_ORDER_ID Implied Constraint ISPREPAYMENT char 1 'N' REF_PAYMENT_ID number 10  √  null Table contained 2 rows at Wed Mar 15 18:14 SAST 2006

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.