TAB_RIB - BoondManager

Defined In: /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:1

Entity's bank details (agency, resource, company).

Index
Properties

Properties

ID_PARENT
ID_RIB
RIB_BIC
RIB_DESCRIPTION
RIB_IBAN
RIB_TYPE

ID_PARENT

Int(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:44

Entity's identifier :

Agency : if TAB_RIB.RIB_TYPE is 0, cf. TAB_SOCIETE.ID_SOCIETE
Resource : if TAB_RIB.RIB_TYPE is 1, cf. TAB_PROFIL.ID_PROFIL
Company : if TAB_RIB.RIB_TYPE is 2, cf. TAB_CRMSOCIETE.ID_CRMSOCIETE

Default: 0

ID_RIB

Int(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:8

Unique identifier.

RIB_BIC

Char(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:27

SWIFT/BIC.

Default: ''

RIB_DESCRIPTION

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:14

Description.

RIB_IBAN

Char(34)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:20

IBAN.

Default: ''

RIB_TYPE

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/rib.txt:34

Entity's type :

0 : Agency
1 : Resource
2 : Company

Default: 0