Dolibarr ERP CRM Wiki

Table llx bank account: Difference between revisions

VisualWikitext
 
(6 intermediate revisions by 2 users not shown)
Line 16: Line 16:


= Structure =
= Structure =
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
== Table ==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 23: Line 24:
  |style="background-color: #e9e9ef"| <b>Default</b>
  |style="background-color: #e9e9ef"| <b>Default</b>
  |style="background-color: #e9e9ef"| <b>Extra</b>
  |style="background-color: #e9e9ef"| <b>Extra</b>
|style="background-color: #e9e9ef"| <b>Description</b>
|-  
|-  
| rowid  
| rowid  
| int(11)  
| int(11)  
| NO
| PRI
|  
|  
| PRI
| NULL
| auto_increment  
| auto_increment  
| technical index
|-
|-
| datec  
| datec  
Line 36: Line 39:
|  
|  
| NULL  
| NULL  
|  
|
| creation date
|-
|-
| tms  
| tms  
| timestamp  
| timestamp  
| YES
| NO
|  
|  
| CURRENT_TIMESTAMP  
| CURRENT_TIMESTAMP  
|  
|
| last update date
|-
|-
| ref  
| ref  
| varchar(12)  
| varchar(12)  
| NO
|  
|  
|  
|  
|  
|
|  
| reference
|-
|-
| label  
| label  
| varchar(30)  
| varchar(30)  
|  
| NO
| UNI  
| UNI  
|  
|  
|
| label
|-
| entity
| int(11)
| NO
| UNI
| 1
|  
|  
| multi company id
|-
|-
| bank  
| bank  
Line 64: Line 79:
|  
|  
| NULL  
| NULL  
|  
|
| bank
|-
|-
| code_banque  
| code_banque  
Line 71: Line 87:
|  
|  
| NULL  
| NULL  
|  
|
| bank code
|-
|-
| code_guichet  
| code_guichet  
Line 78: Line 95:
|  
|  
| NULL  
| NULL  
|  
|
| office code
|-
|-
| number  
| number  
Line 85: Line 103:
|  
|  
| NULL  
| NULL  
|  
|
| account
|-
|-
| cle_rib  
| cle_rib  
Line 92: Line 111:
|  
|  
| NULL  
| NULL  
|  
|
| key
|-
|-
| bic  
| bic  
Line 99: Line 119:
|  
|  
| NULL  
| NULL  
|  
|
| bic
|-
|-
| iban_prefix  
| iban_prefix  
Line 106: Line 127:
|  
|  
| NULL  
| NULL  
|  
|
| IBAN, according to ISO 13616
|-
|-
| domiciliation  
| domiciliation  
Line 113: Line 135:
|  
|  
| NULL
| NULL
|
|  
|  
|-
|-
Line 120: Line 143:
|  
|  
| NULL  
| NULL  
|
|  
|  
|-
|-
Line 127: Line 151:
|  
|  
| NULL  
| NULL  
|
|  
|  
|-
|-
| courant  
| courant  
| smallint(6)  
| smallint(6)  
|  
| NO
|  
|  
| 0  
| 0  
|
|  
|  
|-
|-
| clos  
| clos  
| smallint(6)  
| smallint(6)  
|  
| NO
|  
|  
| 0  
| 0  
|
|  
|  
|-
|-
Line 148: Line 175:
|  
|  
| 1  
| 1  
|
|  
|  
|-
|-
Line 155: Line 183:
|  
|  
| NULL  
| NULL  
|
|  
|  
|-
|-
Line 162: Line 191:
|  
|  
| NULL  
| NULL  
|
|  
|  
|-
|-
| currency_code  
| currency_code  
| char(2)  
| char(2)  
| NO
|  
|  
|  
|  
|  
|
|  
| currency
|-
|-
| min_allowed  
| min_allowed  
Line 176: Line 207:
|  
|  
| 0  
| 0  
|  
|
| amount min.
|-
|-
| min_desired  
| min_desired  
Line 183: Line 215:
|  
|  
| 0  
| 0  
|  
|
| amount min. desired
|-
|-
| comment  
| comment  
Line 191: Line 224:
| NULL  
| NULL  
|  
|  
|}
| comentary
|}&nbsp;
== Keys ==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Fields</b>
|-
| PRIMARY
| PRIMARY
| rowid
|-
| uk_bank_account_label
| UNIQUE
| label,entity
|}&nbsp;

Latest revision as of 09:43, 19 July 2011


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png

Content/Contenu/Contenido

  Contains the bank accounts definitions.

  Contient les informations sur les comptes bancaires.

  Contiene la información de las cuentas bancarias.

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
datec datetime YES NULL creation date
tms timestamp NO CURRENT_TIMESTAMP last update date
ref varchar(12) NO reference
label varchar(30) NO UNI label
entity int(11) NO UNI 1 multi company id
bank varchar(60) YES NULL bank
code_banque varchar(7) YES NULL bank code
code_guichet varchar(6) YES NULL office code
number varchar(255) YES NULL account
cle_rib varchar(5) YES NULL key
bic varchar(11) YES NULL bic
iban_prefix varchar(5) YES NULL IBAN, according to ISO 13616
domiciliation varchar(255) YES NULL
proprio varchar(60) YES NULL
adresse_proprio varchar(255) YES NULL
courant smallint(6) NO 0
clos smallint(6) NO 0
rappro smallint(6) YES 1
url varchar(128) YES NULL
account_number varchar(8) YES NULL
currency_code char(2) NO currency
min_allowed int(11) YES 0 amount min.
min_desired int(11) YES 0 amount min. desired
comment varchar(254) YES NULL comentary

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
uk_bank_account_label UNIQUE label,entity

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_bank_account&oldid=22381"