Table idempiere11.adempiere.c_bankstatementloader
Definition of Bank Statement Loader (SWIFT, OFX)

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_bankstatementloader_id numeric 10 Definition of Bank Statement Loader (SWIFT, OFX)
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
c_bankaccount_id numeric 10
c_bankaccount.c_bankaccount_id cbankacct_cbankstmtloader R
Account at the Bank
stmtloaderclass varchar 60  √  null Class name of the bank statement loader
financialinstitutionid varchar 20  √  null The ID of the Financial Institution / Bank
branchid varchar 20  √  null Bank Branch ID
userid varchar 60  √  null User ID or account number
password varchar 60  √  null Password of any length (case sensitive)
pin varchar 20  √  null Personal Identification Number
accountno varchar 20  √  null Account Number
hostaddress varchar 60  √  null Host Address URL or DNS
hostport numeric 10  √  null Host Communication Port
proxyaddress varchar 60  √  null Address of your proxy server
proxyport numeric 10  √  null Port of your proxy server
proxylogon varchar 60  √  null Logon of your proxy server
proxypassword varchar 60  √  null Password of your proxy server
filename varchar 120  √  null Name of the local file or URL
datelastrun timestamp 29,6  √  null Date the process was last run.
dateformat varchar 20  √  null Date format used in the input format
c_bankstatementloader_uu varchar 36  √  NULL::character varying C_BankStatementLoader_UU

Table contained 0 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_bankstatementloader_id Primary key Asc c_bankstatementloader_pkey
c_bankstatementloader_uu Must be unique Asc c_bankstatementloader_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.