Organization Entity To Business Partner
#
Data Dictionary - Entity Table: Organization_Entity_To_Business_PartnerContains 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 | . |