Table idempiere9.adempiere.c_paymenttransaction
Payment Transaction

 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
a_city varchar 60  √  NULL::character varying City or the Credit Card or Account Holder
a_country varchar 40  √  NULL::character varying Country
a_email varchar 60  √  NULL::character varying Email Address
a_ident_dl varchar 20  √  NULL::character varying Payment Identification - Driver License
a_ident_ssn varchar 20  √  NULL::character varying Payment Identification - Social Security No
a_name varchar 60  √  NULL::character varying Name on Credit Card or Account holder
a_state varchar 40  √  NULL::character varying State of the Credit Card or Account holder
a_street varchar 60  √  NULL::character varying Street address of the Credit Card or Account holder
a_zip varchar 20  √  NULL::character varying Zip Code of the Credit Card or Account Holder
accountno varchar 20  √  NULL::character varying Account Number
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
ad_orgtrx_id numeric 10  √  NULL::numeric
ad_org.ad_org_id adorgtrx_cpaymenttransaction R
Performing or initiating organization
c_activity_id numeric 10  √  NULL::numeric
c_activity.c_activity_id cactivity_cpaymenttransaction R
Business Activity
c_bankaccount_id numeric 10  √  NULL::numeric
c_bankaccount.c_bankaccount_id cbankaccount_cpaymenttransacti R
Account at the Bank
c_bp_bankaccount_id numeric 10  √  NULL::numeric
c_bp_bankaccount.c_bp_bankaccount_id cbpbankaccount_cpaymenttransac R
Bank Account of the Business Partner
c_bpartner_id numeric 10
c_bpartner.c_bpartner_id cbpartner_cpaymenttransaction R
Identifies a Business Partner
c_campaign_id numeric 10  √  NULL::numeric
c_campaign.c_campaign_id ccampaign_cpaymenttransaction R
Marketing Campaign
c_cashbook_id numeric 10  √  NULL::numeric
c_cashbook.c_cashbook_id ccashbook_cpaymenttransaction R
Cash Book for recording petty cash transactions
c_charge_id numeric 10  √  NULL::numeric
c_charge.c_charge_id ccharge_cpaymenttransaction R
Additional document charges
c_conversiontype_id numeric 10  √  NULL::numeric
c_conversiontype.c_conversiontype_id cconversiontype_cpaymenttransa R
Currency Conversion Rate Type
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_cpaymenttransaction R
The Currency for this record
c_doctype_id numeric 10  √  null
c_invoice_id numeric 10  √  NULL::numeric
c_invoice.c_invoice_id cinvoice_cpaymenttransaction R
Invoice Identifier
c_order_id numeric 10  √  NULL::numeric
c_order.c_order_id corder_cpaymenttransaction R
Order
c_payment_id numeric 10  √  NULL::numeric
c_payment.c_payment_id cpayment_cpaymenttransaction R
Payment identifier
c_paymentbatch_id numeric 10  √  NULL::numeric
c_paymentbatch.c_paymentbatch_id cpaymentbatch_cpaymenttransact R
Payment batch for EFT
c_paymentprocessor_id numeric 10  √  NULL::numeric
c_paymentprocessor.c_paymentprocessor_id cpaymentprocessor_cpaymenttran R
Payment processor for electronic payments
c_paymenttransaction_id numeric 10
c_paymenttransaction.ref_paymenttransaction_id refpaymenttransaction_cpayment R
Payment Transaction
c_paymenttransaction_uu varchar 36  √  NULL::character varying C_PaymentTransaction_UU
c_postendertype_id numeric 10  √  NULL::numeric
c_postendertype.c_postendertype_id cpostendertype_cpaymenttransac R
POS Tender Type
c_project_id numeric 10  √  NULL::numeric
c_project.c_project_id cproject_cpaymenttransaction R
Financial Project
checkno varchar 20  √  NULL::character varying Check Number
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
creditcardexpmm numeric 10  √  1 Expiry Month
creditcardexpyy numeric 10  √  3 Expiry Year
creditcardnumber varchar 20  √  NULL::character varying Credit Card Number
creditcardtype bpchar 1  √  'M'::bpchar Credit Card (Visa, MC, AmEx)
creditcardvv varchar 4  √  NULL::character varying Credit Card Verification code on credit card
customeraddressid varchar 60  √  NULL::character varying Customer Address ID
customerpaymentprofileid varchar 60  √  NULL::character varying Customer Payment Profile ID
customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
datetrx timestamp 29,6 Transaction Date
description varchar 255  √  NULL::character varying Optional short description of the record
isactive bpchar 1 'Y'::bpchar The record is active in the system
isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
isdelayedcapture bpchar 1 Charge after Shipment
isonline bpchar 1 Can be accessed online
isreceipt bpchar 1 This is a sales transaction (receipt)
isselfservice bpchar 1 This is a Self-Service entry or this entry can be changed via Self-Service
isvoided bpchar 1 'N'::bpchar Voided
micr varchar 20  √  NULL::character varying Combination of routing no, account and check no
orig_trxid varchar 20  √  NULL::character varying Original Transaction ID
payamt numeric 0 0 Amount being paid
ponum varchar 60  √  NULL::character varying Purchase Order Number
r_authcode varchar 20  √  NULL::character varying Authorization Code returned
r_avsaddr bpchar 1  √  NULL::bpchar This address has been verified
r_avszip bpchar 1  √  NULL::bpchar The Zip Code has been verified
r_cvv2match bpchar 1  √  NULL::bpchar Credit Card Verification Code Match
r_info varchar 2000  √  NULL::character varying Response info
r_pnref varchar 20  √  NULL::character varying Payment reference
r_respmsg varchar 60  √  NULL::character varying Response message
r_result varchar 20  √  NULL::character varying Result of transmission
r_voidmsg varchar 255  √  NULL::character varying Void Message
ref_paymenttransaction_id numeric 10  √  NULL::numeric
c_paymenttransaction.c_paymenttransaction_id refpaymenttransaction_cpayment R
Referenced Payment Transaction
routingno varchar 20  √  NULL::character varying Bank Routing Number
taxamt numeric 0  √  null Tax Amount for a document
tendertype bpchar 1 'K'::bpchar Method of Payment
trxtype bpchar 1 'S'::bpchar Type of credit card transaction
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
user1_id numeric 10  √  NULL::numeric
c_elementvalue.c_elementvalue_id user1_cpaymenttransaction R
User defined list element #1
user2_id numeric 10  √  NULL::numeric
c_elementvalue.c_elementvalue_id user2_cpaymenttransaction R
User defined list element #2
voiceauthcode varchar 20  √  NULL::character varying Voice Authorization Code from credit card company
voidit bpchar 1  √  NULL::bpchar Void It
processed bpchar 1 'N'::bpchar The document has been processed
iban varchar 40  √  NULL::character varying International Bank Account Number
swiftcode varchar 20  √  NULL::character varying Swift Code or BIC

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

Indexes:
Column(s) Type Sort Constraint Name
c_paymenttransaction_id Primary key Asc c_paymenttransaction_key
c_paymenttransaction_uu Must be unique Asc c_paymenttransaction_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.