Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings >

About the Second Row Property on EIM Table Mapping Objects

The Second Row property is set for base tables that always have data row pairs, such as the S_INV_LGR_ENTRY base table.

When the Second Row property check box is checked, this means that one row in the EIM table becomes two different rows in the base table. This property is set when a base table is mapped twice to an EIM table.

For example, the EIM_INV_TXN interface table is mapped twice. Both the TXN_MINUS_QTY interface column and the TXN_QTY interface column map to the QTY base table column and this makes two separate rows in the base table as follows:

Base Table Row
Interface Columns
Base Table Columns
1
TXN_TXN_DT
INV_TXN_DT
TXN_MINUS_QTY
QTY
2
TXN_TXN_DT
INV_TXN_DT
TXN_QTY
QTY

To set the Second Row property

  1. Start Siebel Tools.
  2. In Object Explorer, click the Types tab.
  3. Click EIM Interface Table.
  4. In the EIM Tables window, select the EIM table to which a base table is mapped twice.

 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004