Table idempiere9.adempiere.c_paymentprocessor
Payment processor for electronic payments

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_paymentprocessor_id numeric 10
c_bankaccount_processor.c_paymentprocessor_id cpaymentprocessor_cbankaccount R
c_bp_bankaccount.c_paymentprocessor_id cpaymentprocessor_cbpbankaccou R
c_payment.c_paymentprocessor_id cpaymentprocessor_cpayment R
c_paymentbatch.c_paymentprocessor_id cpaymtprocessor_cpaymtbatch R
c_paymenttransaction.c_paymentprocessor_id cpaymentprocessor_cpaymenttran R
Payment processor for electronic payments
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
c_bankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id cbankaccount_cpaymtprocessor R
Account at the Bank
ad_sequence_id numeric 10  √  null
ad_sequence.ad_sequence_id adsequence_cpaymentprocessor R
Document Sequence
payprocessorclass varchar 60  √  null Payment Processor Java Class
hostaddress varchar 60  √  null Host Address URL or DNS
hostport numeric 10  √  null Host Communication Port
proxyaddress varchar 60  √  null Address of your proxy server
proxyport numeric 10  √  null Port of your proxy server
proxylogon varchar 60  √  null Logon of your proxy server
proxypassword varchar 60  √  null Password of your proxy server
acceptvisa bpchar 1 'Y'::bpchar Accept Visa Cards
acceptmc bpchar 1 'Y'::bpchar Accept Master Card
acceptamex bpchar 1 'Y'::bpchar Accept American Express Card
acceptdiners bpchar 1 'Y'::bpchar Accept Diner's Club
acceptdiscover bpchar 1 'Y'::bpchar Accept Discover Card
acceptcorporate bpchar 1 'Y'::bpchar Accept Corporate Purchase Cards
acceptcheck bpchar 1 'Y'::bpchar Accept ECheck (Electronic Checks)
acceptatm bpchar 1 'Y'::bpchar Accept Bank ATM Card
requirevv bpchar 1 'N'::bpchar Require 3/4 digit Credit Verification Code
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_cpaymentprocessor R
The Currency for this record
costpertrx numeric 0 0 Fixed cost per transaction
commission numeric 0 Commission stated as a percentage
minimumamt numeric 0  √  0 Minimum Amount in Document Currency
acceptdirectdebit bpchar 1 'N'::bpchar Accept Direct Debits (vendor initiated)
acceptdirectdeposit bpchar 1 'N'::bpchar Accept Direct Deposit (payee initiated)
c_paymentprocessor_uu varchar 36  √  NULL::character varying C_PaymentProcessor_UU
trxtype bpchar 1  √  NULL::bpchar Type of credit card transaction

Table contained 2 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_paymentprocessor_id Primary key Asc c_paymentprocessor_pkey
c_paymentprocessor_id Must be unique Asc c_paymentprocessor_key
c_paymentprocessor_uu Must be unique Asc c_paymentprocessor_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.