Dolibarr ERP CRM Wiki

Table llx bank account: Difference between revisions

Page

Table llx bank account (view source)

Revision as of 09:43, 19 July 2011

93 bytes removed ,  15 years ago
→‎Keys
VisualWikitext
No edit summary
 
(11 intermediate revisions by 2 users not shown)
Line 7: Line 7:
[[Category:Banco]]
[[Category:Banco]]


= Contenu =
= Content/Contenu/Contenido =


La table '''llx_bank_account''' stocke les informations sur les comptes bancaires.
{{flag en}} Contains the bank accounts definitions.


Contains bank accounts definitions.
{{flag fr}} Contient les informations sur les comptes bancaires.


Contiene la información de las cuentas bancarias
{{flag sp}} Contiene la información de las cuentas bancarias.


= Structure =
= Structure =
 
== Table ==
<pre>
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+-----------------+--------------+------+-----+-------------------+----------------+
|style="background-color: #e9e9ef"| <b>Field</b>
| Field          | Type        | Null | Key | Default           | Extra         |
|style="background-color: #e9e9ef"| <b>Type</b>
+-----------------+--------------+------+-----+-------------------+----------------+
|style="background-color: #e9e9ef"| <b>Null</b>
| rowid           | int(11)     |     | PRI | NULL              | auto_increment |
|style="background-color: #e9e9ef"| <b>Key</b>
| datec           | datetime     | YES |     | NULL             |               |
|style="background-color: #e9e9ef"| <b>Default</b>
| tms             | timestamp   | YES  |     | CURRENT_TIMESTAMP |               |
|style="background-color: #e9e9ef"| <b>Extra</b>
| ref             | varchar(12) |     |     |                   |               |
|style="background-color: #e9e9ef"| <b>Description</b>
| label           | varchar(30) |     | UNI |                   |               |
|-  
| bank           | varchar(60) | YES |     | NULL             |               |
| rowid  
| code_banque     | varchar(7)   | YES |     | NULL             |               |
| int(11)  
| code_guichet   | varchar(6)   | YES |     | NULL             |               |
| NO
| number         | varchar(255) | YES |     | NULL             |               |
| PRI  
| cle_rib         | varchar(5)   | YES |     | NULL             |               |
|  
| bic             | varchar(11) | YES |     | NULL             |               |
| auto_increment  
| iban_prefix     | varchar(5)   | YES |     | NULL             |               |
| technical index
| domiciliation   | varchar(255) | YES |     | NULL             |               |
|-
| proprio         | varchar(60) | YES  |     | NULL             |               |
| datec  
| adresse_proprio | varchar(255) | YES |     | NULL             |               |
| datetime  
| courant         | smallint(6) |     |     | 0                 |               |
| YES  
| clos           | smallint(6) |     |     | 0                 |               |
|  
| rappro         | smallint(6) | YES |     | 1                 |               |
| NULL  
| url             | varchar(128) | YES |     | NULL             |               |
|
| account_number | varchar(8)   | YES |     | NULL             |               |
| creation date
| currency_code   | char(2)     |     |     |                   |               |
|-
| min_allowed     | int(11)     | YES |     | 0                 |               |
| tms  
| min_desired     | int(11)     | YES |     | 0                 |               |
| timestamp  
| comment         | varchar(254) | YES |     | NULL             |               |
| NO
+-----------------+--------------+------+-----+-------------------+----------------+
|  
 
| CURRENT_TIMESTAMP  
</pre>
|
| 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
|}&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;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/9394...22381"