4,395
edits
Table llx bank account: Difference between revisions
Jump to navigation
Jump to search
→Structure
m (moved Bank account (Table SQL) to Table llx bank account) |
|||
| Line 16: | Line 16: | ||
= Structure = | = Structure = | ||
'''Version 1.31 2009/07/16''' | |||
{| 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" | {| 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" | ||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| Line 23: | Line 25: | ||
|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 | | NULL | ||
| auto_increment | | auto_increment | ||
| technical index | |||
|- | |- | ||
| datec | | datec | ||
| Line 36: | Line 40: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| creation date | |||
|- | |- | ||
| tms | | tms | ||
| timestamp | | timestamp | ||
| | | 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 80: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| bank | |||
|- | |- | ||
| code_banque | | code_banque | ||
| Line 71: | Line 88: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| bank code | |||
|- | |- | ||
| code_guichet | | code_guichet | ||
| Line 78: | Line 96: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| office code | |||
|- | |- | ||
| number | | number | ||
| Line 85: | Line 104: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| account | |||
|- | |- | ||
| cle_rib | | cle_rib | ||
| Line 92: | Line 112: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| key | |||
|- | |- | ||
| bic | | bic | ||
| Line 99: | Line 120: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| bic | |||
|- | |- | ||
| iban_prefix | | iban_prefix | ||
| Line 106: | Line 128: | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| IBAN, according to ISO 13616 | |||
|- | |- | ||
| domiciliation | | domiciliation | ||
| Line 113: | Line 136: | ||
| | | | ||
| NULL | | NULL | ||
| | |||
| | | | ||
|- | |- | ||
| Line 120: | Line 144: | ||
| | | | ||
| NULL | | NULL | ||
| | |||
| | | | ||
|- | |- | ||
| Line 127: | Line 152: | ||
| | | | ||
| NULL | | NULL | ||
| | |||
| | | | ||
|- | |- | ||
| courant | | courant | ||
| smallint(6) | | smallint(6) | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| | |||
| | | | ||
|- | |- | ||
| clos | | clos | ||
| smallint(6) | | smallint(6) | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| | |||
| | | | ||
|- | |- | ||
| Line 148: | Line 176: | ||
| | | | ||
| 1 | | 1 | ||
| | |||
| | | | ||
|- | |- | ||
| Line 155: | Line 184: | ||
| | | | ||
| NULL | | NULL | ||
| | |||
| | | | ||
|- | |- | ||
| Line 162: | Line 192: | ||
| | | | ||
| NULL | | NULL | ||
| | |||
| | | | ||
|- | |- | ||
| currency_code | | currency_code | ||
| char(2) | | char(2) | ||
| NO | |||
| | | | ||
| | | | ||
| | | | ||
| | | currency | ||
|- | |- | ||
| min_allowed | | min_allowed | ||
| Line 176: | Line 208: | ||
| | | | ||
| 0 | | 0 | ||
| | | | ||
| amount min. | |||
|- | |- | ||
| min_desired | | min_desired | ||
| Line 183: | Line 216: | ||
| | | | ||
| 0 | | 0 | ||
| | | | ||
| amount min. desired | |||
|- | |- | ||
| comment | | comment | ||
| Line 191: | Line 225: | ||
| NULL | | NULL | ||
| | | | ||
| comentary | |||
|} | |} | ||