Skip to main content

Business Partner

Data Dictionary - Entity Table: Business_Partner#

Business partner (BP) represents business relationship. A business partner can only exist within the system if a Person (individual, legal or person association, etc) has a business relationship with the bank. This relationship can be any sort of client, internal or external relationship that the bank has with individuals or legal entities. Every business partner must have one registered owner. o For clients that means the person is the contractual owner of the bank account o For external parties that means an entity that owns a business partner used for business-related activities o 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.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK,NN1PrimaryKey-ID, Not Null (auto creates)
Internal_IDVARCHAR(45)NULL1995enter internal id
NicknameVARCHAR(45)NULLClient deposit account, CH Wealth AdvisoryContains the nickname of the partnership
CurrencyBIGINT(12)NULL15Currency can define the type of the BP between Person and the Organization. Example: Deposit Account in EUR
Business_Partner_TypeBIGINT(12)NULL1id of Business Partner
BPType(Business_Partner_Type)Business_Partner_Type (id)NO ACTIONNO ACTION
Currency(Currency)Currency (id)NO ACTIONNO ACTION
Type_idxBusiness_Partner(Business_Partner_Type ASC)VISIBLE.
Currency_idxCurrency(Currency ASC)VISIBLE.