Showing posts with label EIM Temporary Columns. Show all posts
Showing posts with label EIM Temporary Columns. Show all posts

Tuesday, July 24, 2012

Temporary Columns in EIM Tables

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