Bookshelf Home | Contents | Index | Search | PDF

Configuration Guidelines > Creating and Modifying Objects > Constructing Joins >

Creating Explicit Joins

---

Explicit joins consist of the following:

Joins to non-party related tables.

In an explicit join, the only column you can update is the field (in the parent business component) with the foreign key value. You must specify the table to join to and whether it is an outer join. You must also specify the join specification definition with the source field in the parent business component that stores the foreign key value and the destination column in the child table, which is usually ROW_ID.

Joins to party related tables.

Joins to tables that are extensions of the S_PARTY table (such as S_CONTACT, S_ORG_EXT, or S_USER, S_POSTN) require that the foreign key value be exposed as the source field, as stated previously. However, the destination Column must reference the PAR_ROW_ID column in the joined table.

Bookshelf Home | Contents | Index | Search | PDF