Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > EIM Import Process Examples >

Visibility of Fields: Example of Importing Opportunities

To make opportunity records visible in the GUI, populate the following tables and columns.

S_REVN

REVN_ITEM_NUM,

SUMMARY_FLG,

OPTY_ID,

ASGN_USR_EXCLD_FLG,

COMMIT_FLG,

BU_ID,

CRDT_POSTN_ID,

SPLIT_FLG,

AUTOQUOTE_APPL_FLG,

REVN_AMT_CURCY_CD,

DYNMC_GRP_NUM,

EFFECTIVE_DT,

PROD_DESC_TEXT

S_OPTY_POSTN

ROW_STATUS,

PRIORITY_FLG,

COMMITTED_FLG,

ASGN_SYS_FLG,

OPTY_ID,

POSITION_ID,

CREDIT_ALLC_PCT,

FCST_CLS_DT,

FCST_REVN_CURCY_CD,

ASGN_MANL_FLG,

ASGN_DNRM_FLG,

SECURE_FLG,

OPTY_BU_ID,

SUM_COMMIT_FLG,

SUM_EFFECTIVE_DT,

CONSUMER_OPTY_FLG,

SUM_REVN_AMT,

OPTY_NAME,

OPTY_CLOSED_FLG

S_OPTY_BU

OPTY_ID,

BU_ID,

SUM_COMMIT_FLG,

SUM_EFFECTIVE_DT,

SUM_REVN_AMT,

OPTY_NAME

S_OPTY

PR_POSTN_ID,

NUM_RC_PERIODS,

SUM_COMMIT_FLG,

CONSUMER_OPTY_FLG,

PR_REP_DNRM_FLG,

PR_TERR_ID,

SECURE_FLG,

PR_REP_SYS_FLG,

NAME,

PR_REP_MANL_FLG,

STATUS_CD,

BU_ID,

CLOSED_FLG,

SUM_REVN_ITEM_ID,

SALES_METHOD_ID,

REVN_SPLIT_FLG,

APPL_OWNER_TYPE_CD,

STG_START_DT,

SUM_EFFECTIVE_DT,

CURCY_CD,

EXEC_PRIORITY_FLG,

ASGN_USR_EXCLD_FLG