Table idempiere9.adempiere.i_bankstatement
Import of the Bank Statement

 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_bankstatement_id numeric 10 Import of the Bank Statement
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_bankstatement_id numeric 10  √  null
c_bankstatement.c_bankstatement_id cbankstatement_ibankstatement N
Bank Statement of account
statementdate timestamp 29,6  √  null Date of the statement
description varchar 255  √  null Optional short description of the record
c_bankaccount_id numeric 10  √  null
c_bankaccount.c_bankaccount_id cbankaccount_ibankstatement N
Account at the Bank
routingno varchar 20  √  null Bank Routing Number
bankaccountno varchar 20  √  null Bank Account Number
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_ibankstatement N
Payment identifier
paymentdocumentno varchar 30  √  null Document number of the Payment
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_ibankstatement N
The Currency for this record
iso_code bpchar 3  √  null Three letter ISO 4217 Code of the Currency
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_ibankstatement N
Identifies a Business Partner
name varchar 60  √  null Alphanumeric identifier of the entity
bpartnervalue varchar 40  √  null Key of the Business Partner
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_ibankstatement N
Invoice Identifier
invoicedocumentno varchar 30  √  null Document Number of the Invoice
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_ibankstmt N
Additional document charges
chargename varchar 60  √  null Name of the Charge
chargeamt numeric 0  √  0 Charge Amount
c_bankstatementline_id numeric 10  √  null
c_bankstatementline.c_bankstatementline_id cbankstmtline_ibankstmt N
Line on a statement from this Bank
line numeric 10  √  null Unique line for this document
dateacct timestamp 29,6  √  null Accounting Date
valutadate timestamp 29,6  √  null Date when money is available
statementlinedate timestamp 29,6  √  null Date of the Statement Line
trxtype varchar 20  √  null Type of credit card transaction
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
memo varchar 255  √  null Memo Text
isreversal bpchar 1  √  'N'::bpchar This is a reversing transaction
interestamt numeric 0  √  0 Interest Amount
trxamt numeric 0  √  0 Amount of a transaction
linedescription varchar 255  √  null Description of the Line
stmtamt numeric 0  √  0 Statement Amount
eftstatementdate timestamp 29,6  √  null Electronic Funds Transfer Statement Date
eftstatementreference varchar 60  √  null Electronic Funds Transfer Statement Reference
eftstatementlinedate timestamp 29,6  √  null Electronic Funds Transfer Statement Line Date
eftvalutadate timestamp 29,6  √  null Electronic Funds Transfer Valuta (effective) Date
eftreference varchar 60  √  null Electronic Funds Transfer Reference
eftcheckno varchar 20  √  null Electronic Funds Transfer Check No
efttrxid varchar 40  √  null Electronic Funds Transfer Transaction ID
efttrxtype varchar 20  √  null Electronic Funds Transfer Transaction Type
eftmemo varchar 2000  √  null Electronic Funds Transfer Memo
eftpayee varchar 255  √  null Electronic Funds Transfer Payee information
eftpayeeaccount varchar 40  √  null Electronic Funds Transfer Payee Account Information
eftamt numeric 0  √  0 Electronic Funds Transfer Amount
eftcurrency varchar 20  √  null Electronic Funds Transfer Currency
createpayment bpchar 1  √  null Create Payment
processing bpchar 1  √  null Process Now
matchstatement bpchar 1  √  null Match Statement
i_bankstatement_uu varchar 36  √  NULL::character varying I_BankStatement_UU
iban varchar 40  √  NULL::character varying International Bank Account Number

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

Indexes:
Column(s) Type Sort Constraint Name
i_bankstatement_id Primary key Asc i_bankstatement_pkey
i_bankstatement_uu Must be unique Asc i_bankstatement_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.