EIM tables (Interface tables) act as staging area which holds the data that has to be imported, data exported from the Siebel base tables, data to be deleted and that to be merged.
Every Siebel interface table has 4 types of temporary columns as defined below:
- UNQ column.
- EXS column.
- RID column.
- STA column.
Each of the temporary columns has a naming format as follows:
" T_<base table without prefix S_>__<temporary column type> "
Examples: T_ORG_EXT__UNQ, T_ORG_EXT__EXS, T_ORG_EXT__STA, T_ORG_EXT__RID
There are few exceptions for this naming rule.
Examples: T_ACCNTPOST__STA, T_OPTYPOSTN__RID, T_PRODLNPOSTN__RID
