A One-To-Many Extension Table Stores Data From Multiple Business Components

A one-to-many extension table is a table that you can use to track an entity that includes a one-to-many relationship with a parent business component but that a predefined business component does not represent. Note the following:

  • You can store data for multiple business components in a one-to-many extension table.

  • You use the Type column to group records in a one-to-many extension table.

  • You configure each business component to get only the rows of a single type.

  • A one-to-many extension table can contain multiple rows for a single row in the base table.

  • The name of a one-to-many extension table includes an _XM suffix.

  • Similar to a one-to-one extension table, a one-to-many extension table includes a set of generic ATTRIB_nn columns that you can use to store custom data.

  • Unlike a one-to-one extension table, the value in the Type property of a one-to-many extension table is Data (Public) rather than Extension.

For more information, see the following topics: