Skip to main content

Business Partner To Person

Data Dictionary - Entity Table: Business_Partner_To_Person#

Relationship between business partner and person. The Business partner is connected with a person.

One person can have multiple business partner objects.

Typical example of relationship is that every business partner must have one registered owner. 1.For clients that means the person is the contractual owner of the bank account 2.For external parties that means an entity that owns a business partner used for business-related activities 3.For internal parties these are Entities of the bank itself that own the internal nostros, in-house accounting (e.g. ATM) and also the business partners that are business units Example of other types of relationship are: account owner (the legal owner of the business partner) and beneficial owner (a person who benefits from the Business Partner Relationship).

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
Business_PartnerBIGINT(12)NULL1Business Partner ID
PersonBIGINT(12)NULL1Person ID
Relationship_TypeBIGINT(12)NULL1Relationship type id
Business_Partner(Business_Partner)Business_Partner (id)NO ACTIONNO ACTION
BP_P_Relationship_Type(Relationship_Type)Business_Partner_To_Person_Relationship_Type (id)NO ACTIONNO ACTION
BP_P_Person(Person)Person (id)NO ACTIONNO ACTION
Business_Partner_idxBusiness_Partner_To_Person(Business_Partner ASC)VISIBLE.
Relationship_Type_idxBusiness_Partner_To_Person(Relationship_Type ASC)VISIBLE.
Person_idxBusiness_Partner_To_Person(Person ASC)VISIBLE.