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 From Organization
from_c_charge_id numeric 10 From Charge
from_c_currency_id numeric 10 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 To Organization
to_c_charge_id numeric 10 To Charge
to_c_currency_id numeric 10 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 Identifies a Business Partner
from_c_bpartner_id numeric 10 NULL::numeric Identifies a Business Partner
dateacct timestamp 29,6 Accounting Date
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate

Table contained 0 rows at 2024-01-03 13:46 +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

Close relationships  within of separation: