Table idempiere9.adempiere.c_bankstatementline
Line on a statement from this Bank

 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_bankstatementline_id numeric 10
i_bankstatement.c_bankstatementline_id cbankstmtline_ibankstmt N
Line on a statement from this Bank
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
c_bankstatement_id numeric 10
c_bankstatement.c_bankstatement_id cbstatement_cbstatementline C
Bank Statement of account
line numeric 10 Unique line for this document
description varchar 255  √  null Optional short description of the record
isreversal bpchar 1 'N'::bpchar This is a reversing transaction
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_cbankstmtline R
Payment identifier
valutadate timestamp 29,6 Date when money is available
dateacct timestamp 29,6 Accounting Date
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_cbankstmtline R
The Currency for this record
trxamt numeric 0 0 Amount of a transaction
stmtamt numeric 0 0 Statement Amount
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_cbankstmtlime R
Additional document charges
chargeamt numeric 0 0 Charge Amount
interestamt numeric 0 0 Interest Amount
memo varchar 255  √  null Memo Text
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
ismanual bpchar 1 'N'::bpchar This is a manual process
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
createpayment bpchar 1  √  null Create Payment
statementlinedate timestamp 29,6 Date of the Statement Line
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
eftcurrency varchar 20  √  null Electronic Funds Transfer Currency
eftamt numeric 0  √  0 Electronic Funds Transfer Amount
eftcheckno varchar 20  √  null Electronic Funds Transfer Check No
matchstatement bpchar 1  √  null Match Statement
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_cbankstatementline R
Identifies a Business Partner
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_cbankstatementline R
Invoice Identifier
processed bpchar 1 'N'::bpchar The document has been processed
c_bankstatementline_uu varchar 36  √  NULL::character varying C_BankStatementLine_UU

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

Indexes:
Column(s) Type Sort Constraint Name
c_bankstatementline_id Primary key Asc c_bankstatementline_pkey
c_bankstatementline_uu Must be unique Asc c_bankstatementline_uu_idx
c_bankstatement_id Performance Asc c_bankstmtline_bankstmt


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.