c_bankaccount

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_bankaccount_id numeric 10 null
c_bankaccount_acct.c_bankaccount_id cbankaccount_cbankacctacct C
c_bankaccount_processor.c_bankaccount_id cbankaccount_cbankaccountproce R
c_bankaccountdoc.c_bankaccount_id cbankaccount_cbadoc C
c_bankstatement.c_bankaccount_id cbankaccount_cbankstatement R
c_bankstatementloader.c_bankaccount_id cbankacct_cbankstmtloader R
c_banktransfer.from_c_bankaccount_id fromcbankaccount_cbanktransfer R
c_banktransfer.to_c_bankaccount_id tocbankaccount_cbanktransfer R
c_cashline.c_bankaccount_id cbankacct_ccashline R
c_depositbatch.c_bankaccount_id cbankaccount_cdepositbatch R
c_elementvalue.c_bankaccount_id cbankaccount_celementvalue R
c_payment.c_bankaccount_id cbankaccount_cpayment R
c_paymentprocessor.c_bankaccount_id cbankaccount_cpaymtprocessor R
c_paymenttransaction.c_bankaccount_id cbankaccount_cpaymenttransacti R
c_payselection.c_bankaccount_id cbankaccount_cpayselection R
c_pos.c_bankaccount_id cbankaccount_cpos R
c_pospayment.cof_bankaccount_id cofbankaccount_cpospayment R
c_postendertype.cof_bankaccount_id cofbankaccount_cpostendertype R
cof_c_bankintegration.c_bankaccount_id cbankaccount_cofcbankintegrati R
cof_c_controlcheck.c_bankaccount_id cbankaccount_cofccontrolcheck R
cof_conciliacaocartao.c_bankaccount_id cbankaccount_cofconciliacaocar R
cof_dda.c_bankaccount_id cbankaccount_cofdda R
cof_operadorascartao.c_bankaccount_id cbankaccount_cofoperadorascart R
cof_titulo.c_bankaccount_id cbankaccount_coftitulo R
i_bankstatement.c_bankaccount_id cbankaccount_ibankstatement N
i_payment.c_bankaccount_id cbankaccount_ipayment N
u_posterminal.card_bankaccount_id cardbankaccount_uposterminal R
u_posterminal.cardtransferbankaccount_id cardtransferbankaccount_uposte R
u_posterminal.cashtransferbankaccount_id cashtransferbankaccount_uposte R
u_posterminal.check_bankaccount_id checkbankaccount_uposterminal R
u_posterminal.checktransferbankaccount_id checktransferbankaccount_upost R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
c_bank_id numeric 10 null
c_bank.c_bank_id cbank_cbankaccount C
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_cbankaccount R
bankaccounttype bpchar 1 null
accountno varchar 20 null
currentbalance numeric 0 0
creditlimit numeric 0 0
isdefault bpchar 1 'N'::bpchar
iban varchar 40 √ null
description varchar 255 √ null
bban varchar 40 √ null
paymentexportclass varchar 60 √ NULL::character varying
c_bankaccount_uu varchar 36 √ NULL::character varying
name varchar 60 NULL::character varying
value varchar 40 NULL::character varying
cof_composescashflow bpchar 1 √ 'Y'::bpchar
cof_contatransitoriacredito bpchar 1 'N'::bpchar
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cbankaccount R
cof_user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id cofuser2_cbankaccount R
cof_toleranciaconfrontoofx numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
c_bankaccount_pkey Primary key Asc c_bankaccount_id
c_bankaccount_uu_idx Must be unique Asc c_bankaccount_uu
c_bankacct_bank Performance Asc c_bank_id

Check Constraints

Constraint Name Constraint
c_bankaccount_cof_composescashflow_check ((cof_composescashflow = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bankaccount_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bankaccount_cof_contatransitoriacredito_check ((cof_contatransitoriacredito = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation