EIM Memo

[Siebel Interface Manager]

PROCESS = \"Import_S_OPTY\"

; Description: EIM Config file to load oppertunity; Version Name Date Description

; --------------------------------------------------------------; 1.0 Zhang JUN 21 2014 Initial Version[Import_S_OPTY] TYPE = SHELL INCLUDE = IMP_S_OPTY INCLUDE = IMP_S_OPTY_XM[IMP_S_OPTY] TYPE = IMPORT BATCH = 1000-1999 TABLE = EIM_OPTY LOG TRANSACTIONS = FALSE USE INDEX HINTS = FALSE USE ESSENTIAL INDEX HINTS = TRUE USING SYNONYMS = FALSE NET CHANGE = FALSE DEFAULT COLUMN = OPTY_CLOSED_FLG,\"N\" DEFAULT COLUMN = OPTYEXECPRIORITYFL,\"N\" DEFAULT COLUMN = OPTY_HST_AFFL_FLG,\"N\" DEFAULT COLUMN = OPTY_INACTIVE_FLG,\"N\" DEFAULT COLUMN = OPTYONDEMANDSYNCFL,\"N\" DEFAULT COLUMN = OPTY_PRBU_DNRM_FLG,\"N\" DEFAULT COLUMN = OPTY_PRBU_MANL_FLG,\"N\" DEFAULT COLUMN = OPTY_PR_BU_SYS_FLG,\"N\" DEFAULT COLUMN = OPTY_REVN_SPLITFLG,\"N\" DEFAULT COLUMN = OPTY_SUM_CMMT_FLG,\"N\" DEFAULT COLUMN = OPTY_TEMPLATE_FLG,\"N\" DEFAULT COLUMN = OPTY_CURCY_CD,\"JPY\" ONLY BASE TABLES = S_OPTY,S_OPTY_X INSERT ROWS = S_OPTY, TRUE UPDATE ROWS = S_OPTY, FALSE INSERT ROWS = S_OPTY_X, TRUE UPDATE ROWS = S_OPTY_X, FALSE ONLY BASE COLUMNS = S_OPTY.BU_ID,\\ S_OPTY.NAME,\\ S_OPTY.CURCY_CD,\\ S_OPTY.IN_ACCNT_ID,\\ S_OPTY.CUST_ACCNT_ID,\\ S_OPTY.X_BUYING_REASON1,\\ S_OPTY.X_BUYING_REASON2,\\ S_OPTY.X_BANK_ID,\\ S_OPTY.X_BANK_BRANCH_ID,\\ S_OPTY_X.PAR_ROW_ID,\\ S_OPTY_X.ATTRIB_16,\\ S_OPTY_X.ATTRIB_17,\\ S_OPTY_X.ATTRIB_18,\\ S_OPTY_X.ATTRIB_19,\\ S_OPTY_X.ATTRIB_20[IMP_S_OPTY_XM] TYPE = IMPORT

1. 通过INCLUDE可将多个IFB合并成2. 当IFB只导入一个实体时，[Impo1. 对应EIM表IF_ROW_BATCH_NUM, IFB2. 可以通过参数传入（$AUTO_NUM）3. 可以设置成固定或某固定范围，范围1. 可选项参数，具体用法参2. 位置任意，甚至可以放到3. 当放在Siebel Interface Ma例：NET CHANGE：TRUE 如常更新。1. 默认值设置，相2. 系统预定义必须3. 对于BC自定义的4. 当前系统时间预指定目标BASE表。1. EIM对应的Targe2.导入与更新控制处理对象1. 当目标ONLY BA2. 反斜扛3. 中间不释。4. 必须包 TABLE = EIM_OPTY_XM BATCH = 1000-1999

LOG TRANSACTIONS = FALSE USE INDEX HINTS = FALSE

USE ESSENTIAL INDEX HINTS = TRUE USING SYNONYMS = FALSE

ONLY BASE TABLES = S_OPTY_XM

ONLY BASE COLUMNS = S_OPTY_XM.PAR_ROW_ID,\\ S_OPTY_XM.NAME,\\ S_OPTY_XM.TYPE,\\ S_OPTY_XM.ATTRIB_01

Common Error Msg

1. Error: Must include the target tablein ONLY BASE TABLES for the EIM table.2. Warning: No columns included in S_PART, assuming all columns.3. Error: No value for the Required Columns.

4. Error: This column contains a bounded picklist value and the value given does not correspond to a value in the list-o

1. 分号为注释。2. 可以注掉任意参数命令行。3. 在ONLY BASE COLUMNS 部位特殊，合并成一个IFB，顺序导入。[Import_S_OPTY] 部分可去掉，PROCESS直接命名M, IFB只会处理对应的批次。UM）。，范围不能超过1000。用法参照官方文档。以放到ONLY BASE COLUMNS部分后面。ce Manager下面时可理解为全局参数。RUE 如果更新成空，则不更新；FALSE 正置，相应的EIM表字段。义必须字段，通常在这里赋默认值。定义的必须字段，在导EIM的程序里赋值更佳（性能）。时间预定义参数“$CURRENT_DATETIME”E表。Target Base Table必须包含。新控制（性能）理对象字段。当目标表出现在ONLY BASE TABLES，但没有相应字段出现在LY BASE COLUMNS时，默认全字段（性能）。反斜扛后面不能有空格，否则文件无效。中间不能单独注掉中间某一行，否则注掉行后面的都被当成注。必须包含非空的UK字段。nd to a value in the list-of-values table for the given picklisttype.