To support entirely new business entities or a very large number of extension columns, Siebel Tools provides the ability to create custom table definitions using the New Table wizard. The following types of tables can be created:
Standalone tables
1:1 extension tables for existing tables
1:M extension tables for existing tables
Intersection tables to support many-to-many (M:M) relationships
The New Table wizard creates the table and all required system columns as well as some index and user key definitions. However, any additionally required attribute columns as well as any required indexes or user keys must be created manually.
One of the key requirements of the All Hardware Company is to provide a unified list of all customer documents (opportunities, quotes, orders, and campaign responses) to their employees.
The technical architects have determined that a custom table must be created to support the storage of the document...