Table idempiere11.adempiere.c_banktransfer
Bank Transfer

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_banktransfer_id numeric 10
c_allocationline.c_banktransfer_id cbanktransfer_callocationline R
c_payment.c_banktransfer_id cbanktransfer_cpayment R
Bank Transfer
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
description varchar 255  √  NULL::character varying Optional short description of the record
docaction bpchar 2 'CO'::bpchar The targeted status of the document
docstatus bpchar 2 'DR'::bpchar The current status of the document
documentno varchar 30 Document sequence number of the document
isactive bpchar 1 'Y'::bpchar The record is active in the system
c_banktransfer_uu varchar 36  √  NULL::character varying C_BankTransfer_UU
processed bpchar 1 The document has been processed
processing bpchar 1  √  NULL::bpchar Process Now
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
paydate timestamp 29,6 Date Payment made
from_c_bankaccount_id numeric 10
c_bankaccount.c_bankaccount_id fromcbankaccount_cbanktransfer R
From Bank Account
from_ad_org_id numeric 10
ad_org.ad_org_id fromadorg_cbanktransfer R
From Organization
from_c_charge_id numeric 10
c_charge.c_charge_id fromccharge_cbanktransfer R
From Charge
from_c_currency_id numeric 10
c_currency.c_currency_id fromccurrency_cbanktransfer R
From Bank Currency
from_amt numeric 0 From Amount
to_c_bankaccount_id numeric 10
c_bankaccount.c_bankaccount_id tocbankaccount_cbanktransfer R
To Bank Account
to_ad_org_id numeric 10
ad_org.ad_org_id toadorg_cbanktransfer R
To Organization
to_c_charge_id numeric 10
c_charge.c_charge_id toccharge_cbanktransfer R
To Charge
to_c_currency_id numeric 10
c_currency.c_currency_id toccurrency_cbanktransfer R
To Bank Currency
to_amt numeric 0 To Amount
rate numeric 0 Rate or Tax or Exchange
from_tendertype bpchar 1 'A'::bpchar From Tender Type
to_tendertype bpchar 1 'D'::bpchar To Tender Type
to_c_bpartner_id numeric 10 NULL::numeric
c_bpartner.c_bpartner_id tocbpartner_cbanktransfer R
Identifies a Business Partner
from_c_bpartner_id numeric 10 NULL::numeric
c_bpartner.c_bpartner_id fromcbpartner_cbanktransfer R
Identifies a Business Partner
dateacct timestamp 29,6 Accounting Date
c_conversiontype_id numeric 10  √  null
c_conversiontype.c_conversiontype_id cconversiontype_cbanktransfer R
Currency Conversion Rate Type
isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate

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

Indexes:
Column(s) Type Sort Constraint Name
c_banktransfer_id Primary key Asc c_banktransfer_key
c_banktransfer_uu Must be unique Asc c_banktransfer_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.