Organization Entity To Business Partner

Data Dictionary - Entity Table: Organization_Entity_To_Business_Partner

Contains all the relations between Business Partners and divisions/teams within the Organization.

Primary Key ('id')	.	ENGINE = InnoDB	.	.
Column Name	Data Type	PK Primary Key, NN-Not Null, Null	Example	Comments
id	BIGINT(12)	PK, NN	1	PrimaryKey-ID, Not Null (auto creates)
Business_Partner	BIGINT(12)	NULL	.	12
Organizational_Entity	BIGINT(12)	NULL	.	132
Relationship_Type	BIGINT(12)	NULL	33	Relationship Type id
CONSTRAINT	FOREIGN KEY	REFERENCES	ON DELETE	ON UPDATE
BP_Relationship	(Business_Partner)	Business_Partner (id)	NO ACTION	NO ACTION
OE_Relationship	(Organizational_Entity)	Organizational_Entity (id)	NO ACTION	NO ACTION
OE_To_BP_Type	(Relationship_Type)	Organization_Entity_To_ Business_Partner_Type (id)	NO ACTION	NO ACTION
CREATE INDEX	ON	ASC	VISIBLE	.
BP_idx	Organization_Entity_To_ Business_Partner	(Business_Partner ASC)	VISIBLE	.
OE_idx	Organization_Entity_To_ Business_Partner	(Organizational_Entity ASC)	VISIBLE	.
Type_idx	Organization_Entity_To_ Business_Partner	(Relationship_Type ASC)	VISIBLE	.