Bookshelf Home | Contents | Index | PDF |
Configuring Siebel eBusiness Applications > Configuring Tables and Columns > About Extension Tables > About One-to-Many Extension TablesThe names of 1:M extension tables are appended with the suffix _XM. In a 1:M extension table, there can be multiple rows for a single row in the base table. Like 1:1 extension tables, 1:M extension tables have a set of generic columns (ATTRIB_xx) that you can use to store custom attributes. However, unlike 1:1 extension tables, 1:M extension tables have a Type property value of Data (Public) rather than Extension. You can use 1:M extension tables to track additional entities that have a 1:M relationship with a parent business component but are not represented by existing Siebel business components. You can store data for multiple business components in an _XM table. The Type column is used to group records in the _XM table. You configure each business component to retrieve only the rows of a given type. One-to-many extension tables require the following configuration at the business object layer:
CAUTION: Avoid an _XM table as an extension to an existing _XM table. It will cause problems with EIM and docking processes. Related Topics |
Configuring Siebel eBusiness Applications |