Bookshelf Home | Contents | Index | Search | PDF

Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables >

EIM Table Columns

---

Running EIM is an iterative process, with each step accomplishing specific tasks and moving toward successful completion of the entire process. To process on a row-by-row basis, EIM uses several columns common to every interface table. These columns are described in this section.

Several columns are mandatory. Others are conditionally mandatory, depending on the conditions of your import. Your Siebel application offers two methods for determining mandatory columns.

• You can use Siebel Tools to view each column in an EIM table and the EIM table's target base table columns.
• You can also refer to Interface Tables Reference and the Siebel Bookshelf for Enterprise Applications.

By following the recommended import sequence, you make sure that the appropriate data dependencies are established.

NOTE:  For import and merge processes, you must populate the ROW_ID, IF_ROW_STAT, and IF_ROW_BATCH_NUM columns in the EIM tables. This also must be done for delete processes when you run DELETE EXACT. For merge processes, you also need to populate the IF_ROW_MERGE_ID column. Do not populate these required columns with spaces because a space does not equal a NULL value.

Bookshelf Home | Contents | Index | Search | PDF