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