Table llx societe rib - Revision history

Ssherratt at 08:25, 1 September 2018

2018-09-01T08:25:30Z

← Older revision		Revision as of 08:25, 1 September 2018
Line 95:		Line 95:
	\| NULL		\| NULL
	\|		\|
	\| bank: ~~key account~~		\| bank account: checksum/control digits
	\|-		\|-
	\| bic		\| bic

2018-09-01T07:21:41Z

← Older revision		Revision as of 07:21, 1 September 2018
Line 38:		Line 38:
	\|		\|
	\|		\|
	\| ID of ~~society~~ ([[Table llx_societe\|llx_societe]]->rowid)		\| ID of Third Party ([[Table llx_societe\|llx_societe]]->rowid)
	\|-		\|-
	\| datec		\| datec
Line 46:		Line 46:
	\| NULL		\| NULL
	\|		\|
	\| creation ~~date~~		\| date of creation of record
	{{FieldTms}}		{{FieldTms}}
	\|-		\|-
Line 55:		Line 55:
	\| NULL		\| NULL
	\|		\|
	\| label		\| bank account: name/label (for identification between multiple accounts)
	\|-		\|-
	\| bank		\| bank
Line 63:		Line 63:
	\| NULL		\| NULL
	\|		\|
	\| bank		\| bank name
	\|-		\|-
	\| code_banque		\| code_banque
Line 71:		Line 71:
	\| NULL		\| NULL
	\|		\|
	\| bank code		\| bank account: code
	\|-		\|-
	\| code_guichet		\| code_guichet
Line 79:		Line 79:
	\| NULL		\| NULL
	\|		\|
	\| bank office code		\| bank: office code
	\|-		\|-
	\| number		\| number
Line 87:		Line 87:
	\| NULL		\| NULL
	\|		\|
	\| bank account		\| bank account: account number
	\|-		\|-
	\| cle_rib		\| cle_rib
Line 95:		Line 95:
	\| NULL		\| NULL
	\|		\|
	\| bank key account		\| bank: key account
	\|-		\|-
	\| bic		\| bic
Line 103:		Line 103:
	\| NULL		\| NULL
	\|		\|
	\| bank ~~bic~~		\| bank: BIC/SWIFT code
	\|-		\|-
	\| iban_prefix		\| iban_prefix
Line 111:		Line 111:
	\| NULL		\| NULL
	\|		\|
	\| bank account according to ISO 13616		\| bank account: complete IBAN according to ISO 13616
	\|-		\|-
	\| domiciliation		\| domiciliation
Line 119:		Line 119:
	\| NULL		\| NULL
	\|		\|
	\| bank ~~adress~~		\| bank: address
	\|-		\|-
	\| proprio		\| proprio
Line 127:		Line 127:
	\| NULL		\| NULL
	\|		\|
	\|		\| bank account: name of owner
	\|-		\|-
	\| adresse_proprio		\| adresse_proprio
Line 135:		Line 135:
	\| NULL		\| NULL
	\|		\|
	\|		\|bank account: address of owner
	\|}		\|}

2012-08-10T12:53:24Z

Table

← Older revision		Revision as of 12:53, 10 August 2012
Line 47:		Line 47:
	\|		\|
	\| creation date		\| creation date
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| label		\| label
Line 144:		Line 137:
	\|		\|
	\|}		\|}

	== Keys ==		== Keys ==
	{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"

2011-07-19T15:54:29Z

Structure

← Older revision		Revision as of 15:54, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| 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>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 146:		Line 145:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| 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>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

2009-11-09T10:52:46Z

Structure

← Older revision		Revision as of 10:52, 9 November 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			== Table ==
			'''Version 1.1 2009/10/07'''
	{\| 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 25:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 49:		Line 51:
	\| tms		\| tms
	\| timestamp		\| timestamp
	\| ~~YES~~		\| NO
	\|		\|
	\| CURRENT_TIMESTAMP		\| CURRENT_TIMESTAMP
Line 142:		Line 144:
	\|		\|
	\|		\|
	\|}		\|}
			== Keys ==
			'''Version 1.1 2009/10/07'''
			{\| 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>Key</b>
			\|style="background-color: #e9e9ef"\| <b>Type</b>
			\|style="background-color: #e9e9ef"\| <b>Fields</b>
			\|-
			\| PRIMARY
			\| PRIMARY
			\| rowid
			\|}

2009-09-17T07:02:31Z

Structure

@@ Line 30: / Line 30: @@
 | auto_increment
 | technical index
 |}

2009-09-15T15:41:33Z

Contenu

← Older revision		Revision as of 15:41, 15 September 2009
Line 5:		Line 5:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =
	~~Contient les RIB des sociétés (clients et fournisseurs)~~

	Contains the bank accounts of companies (clients or providers).		{{flag_en}} Contains the bank accounts of companies (clients or providers).

	Contiene las cuentas bancarias de las empresas (clientes y proveedores).		{{flag_fr}} Contient les RIB des sociétés (clients et fournisseurs)

			{{flag_sp}} Contiene las cuentas bancarias de las empresas (clientes y proveedores).

	= Structure =		= Structure =

2009-05-06T07:13:03Z

Structure

2009-05-04T17:47:35Z

Contenu

← Older revision		Revision as of 17:47, 4 May 2009
Line 8:		Line 8:
	Contient les RIB des sociétés (clients et fournisseurs)		Contient les RIB des sociétés (clients et fournisseurs)

	Contains the ~~RIB~~ (clients or providers).		Contains the bank accounts of companies (clients or providers).

	Contiene las cuentas bancarias de las empresas (clientes y proveedores).		Contiene las cuentas bancarias de las empresas (clientes y proveedores).

2009-05-04T17:45:47Z

Contenu

← Older revision		Revision as of 17:45, 4 May 2009
Line 6:		Line 6:

	= Contenu =		= Contenu =
			Contient les RIB des sociétés (clients et fournisseurs)

			Contains the RIB (clients or providers).

			Contiene las cuentas bancarias de las empresas (clientes y proveedores).

	= Structure =		= Structure =