Mapping of Limit Data to Siebel CRM

In Oracle FLEXCUBE Universal Banking, limit data is stored in the GETM_LIMITS_HANDOFF staging table. The following information shows how the limit data stored in the table is mapped to Siebel CRM.

Oracle FLEXCUBE Attribute	Siebel Business Compon-ent	Siebel Field	Siebel Base Table	Siebel Base Column	Siebel EIM Table	Siebel EIM Table Column
Available Amount	FINS BIB Limit Details	Available Amount	S_FN_LIMIT	AVAILABLE_ AMT	EIM_FN_ LIMIT	LMT_AVAILABLE_AMT
Effective Limit Amount	FINS BIB Limit Details	Effective Limit Amount	S_FN_LIMIT	EFF_LIMIT_ AMT	EIM_FN_ LIMIT	LMT_EFF_ LIMIT_AMT
Line Currency	FINS BIB Limit Details	Line Currency	S_FN_LIMIT	CURCY_CD	EIM_FN_ LIMIT	LMT_CURCY_CD
Line ID	FINS BIB Limit Details	Line ID	S_FN_LIMIT	LIMIT_NUM	EIM_FN_ LIMIT	LMT_LIMIT_ NUM
Customer	FINS BIB Limit Details	Contact Id	S_FN_LIMIT	CONTACT_ID	EIM_FN_ LIMIT	LMT_CON_ BU
						LMT_CON_ PRIV_FLG
						LMT_PERSON_UID
Customer	FINS BIB Limit Details	Account Id	S_FN_LIMIT	ACCOUNT_ID	EIM_FN_ LIMIT	LMT_ACCOUNTACCN_BU
						LMT_ACCOUNTACCNTLO
						LMT_ACCOUNTACCNTNA
Main Line ID	FINS BIB Limit Details	Main Line ID	S_FN_LIMIT	PAR_LIMIT_ID	EIM_FN_ LIMIT	LMT_PAR_ LIMIT_NUM
						LMT_PAR_ LMT_ACC_BU
						LMT_PAR_ LMT_ACCLOC
						LMT_PAR_ LMTACCNAME
						LMT_PAR_ LMT_CON_BU
						LMT_PARLMTCONPRIVF
						LMT_PARLMTPERSONUI