Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Business Objects Layer > Party Business Components and Joins: Party Extension Tables >

Bringing Party Data into a Non-Party Business Component

---

For example, you can bring account data from the S_ORG_EXT table into the Opportunity business component to display in an applet, as shown in Figure 97.

Figure 97.  Bringing Party Data into a Non-Party Business Component

Join Definition

The join definition references the extension table storing the data of interest (Figure 98).

Figure 98.  Join Definition

Join Specification Definition

Source Field references the relevant foreign key column to the joined table. Destination Column references the PAR_ROW_ID column in the joined table (Figure 99).

Figure 99.  Join Specification Definition

PAR_ROW_ID

The PAR_ROW_ID column identifies the primary key of the related record (Figure 100).

Figure 100.  PAR_ROW_ID

Bookshelf Home | Contents | Index | Search | PDF