Table llx bank account: Difference between revisions

Jump to navigation Jump to search

Table llx bank account (view source)

Revision as of 09:43, 19 July 2011

573 bytes added ,  15 years ago
→‎Keys
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;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/12148...22381"

Navigation menu