View idempiere9.adempiere.c_payment_v
Payment_v

 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_payment_id numeric 10  √  null Payment identifier
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
documentno varchar 30  √  null Document sequence number of the document
datetrx timestamp 29,6  √  null Transaction Date
isreceipt bpchar 1  √  null This is a sales transaction (receipt)
c_doctype_id numeric 10  √  null Document type or rules
trxtype bpchar 1  √  null Type of credit card transaction
c_bankaccount_id numeric 10  √  null Account at the Bank
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_invoice_id numeric 10  √  null Invoice Identifier
c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_paymentbatch_id numeric 10  √  null Payment batch for EFT
tendertype bpchar 1  √  null Method of Payment
creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
creditcardnumber varchar 20  √  null Credit Card Number
creditcardvv varchar 4  √  null Credit Card Verification code on credit card
creditcardexpmm numeric 10  √  null Expiry Month
creditcardexpyy numeric 10  √  null Expiry Year
micr varchar 20  √  null Combination of routing no, account and check no
routingno varchar 20  √  null Bank Routing Number
accountno varchar 20  √  null Account Number
checkno varchar 20  √  null Check Number
a_name varchar 60  √  null Name on Credit Card or Account holder
a_street varchar 60  √  null Street address of the Credit Card or Account holder
a_city varchar 60  √  null City or the Credit Card or Account Holder
a_state varchar 40  √  null State of the Credit Card or Account holder
a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
a_ident_dl varchar 20  √  null Payment Identification - Driver License
a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
a_email varchar 60  √  null Email Address
voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
orig_trxid varchar 20  √  null Original Transaction ID
ponum varchar 60  √  null Purchase Order Number
c_currency_id numeric 10  √  null The Currency for this record
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
payamt numeric 0  √  null Amount being paid
discountamt numeric 0  √  null Calculated amount of discount
writeoffamt numeric 0  √  null Amount to write-off
taxamt numeric 0  √  null Tax Amount for a document
overunderamt numeric 0  √  null Over-Payment (unallocated) or Under-Payment (partial payment) Amount
multiplierap int4 10  √  null Payables Multiplier
isoverunderpayment bpchar 1  √  null Over-Payment (unallocated) or Under-Payment (partial payment)
isapproved bpchar 1  √  null Indicates if this document requires approval
r_pnref varchar 20  √  null Payment reference
r_result varchar 20  √  null Result of transmission
r_respmsg varchar 60  √  null Response message
r_authcode varchar 20  √  null Authorization Code returned
r_avsaddr bpchar 1  √  null This address has been verified
r_avszip bpchar 1  √  null The Zip Code has been verified
r_info varchar 2000  √  null Response info
processing bpchar 1  √  null Process Now
oprocessing bpchar 1  √  null This payment can be processed online
docstatus bpchar 2  √  null The current status of the document
docaction bpchar 2  √  null The targeted status of the document
isprepayment bpchar 1  √  null The Payment/Receipt is a Prepayment
c_charge_id numeric 10  √  null Additional document charges
isreconciled bpchar 1  √  null Payment is reconciled with bank statement
isallocated bpchar 1  √  null Indicates if the payment has been allocated
isonline bpchar 1  √  null Can be accessed online
processed bpchar 1  √  null The document has been processed
posted bpchar 1  √  null Posting status
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
chargeamt numeric 0  √  null Charge Amount
c_order_id numeric 10  √  null Order
dateacct timestamp 29,6  √  null Accounting Date
description varchar 255  √  null Optional short description of the record
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
reversal_id numeric 10  √  null ID of document reversal
currencyrate numeric 0  √  null Currency Conversion Rate
convertedamt numeric 0  √  null Converted Amount
isoverridecurrencyrate bpchar 1  √  null Override Currency Conversion Rate

Analyzed at 2021-12-25 14:43 +0100