Table idempiere9.adempiere.i_payment
Import Payment

 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
i_payment_id numeric 10 Import Payment
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
processed bpchar 1  √  'N'::bpchar The document has been processed
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_ipayment N
Payment identifier
documentno varchar 30  √  null Document sequence number of the document
datetrx timestamp 29,6  √  null Transaction Date
isreceipt bpchar 1  √  'Y'::bpchar This is a sales transaction (receipt)
c_doctype_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_ipayment N
Document type or rules
doctypename varchar 60  √  null Name of the Document Type
trxtype bpchar 1  √  null Type of credit card transaction
c_bankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id cbankaccount_ipayment N
Account at the Bank
bankaccountno varchar 20  √  null Bank Account Number
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_ipayment N
Identifies a Business Partner
bpartnervalue varchar 40  √  null Key of the Business Partner
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_ipayment N
Invoice Identifier
invoicedocumentno varchar 30  √  null Document Number of the Invoice
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_country varchar 40  √  null Country
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
swipe varchar 80  √  null Track 1 and 2 of the Credit Card
orig_trxid varchar 20  √  null Original Transaction ID
ponum varchar 60  √  null Purchase Order Number
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_ipayment R
The Currency for this record
payamt numeric 0  √  0 Amount being paid
discountamt numeric 0  √  0 Calculated amount of discount
writeoffamt numeric 0  √  0 Amount to write-off
isoverunderpayment bpchar 1  √  'N'::bpchar Over-Payment (unallocated) or Under-Payment (partial payment)
overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_ipayment N
Additional document charges
chargename varchar 60  √  null Name of the Charge
chargeamt numeric 0  √  0 Charge Amount
taxamt numeric 0  √  0 Tax Amount for a document
isapproved bpchar 1  √  'N'::bpchar Indicates if this document requires approval
isselfservice bpchar 1  √  'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
isdelayedcapture bpchar 1  √  'N'::bpchar Charge after Shipment
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_info varchar 2000  √  null Response info
processing bpchar 1  √  null Process Now
iso_code bpchar 3  √  null Three letter ISO 4217 Code of the Currency
dateacct timestamp 29,6  √  null Accounting Date
i_payment_uu varchar 36  √  NULL::character varying I_Payment_UU
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
i_payment_id Primary key Asc i_payment_pkey
i_payment_uu Must be unique Asc i_payment_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.