Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Data Mappings to Siebel EIM Tables >
Mapping of Limit Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, limit data is stored in the GETM_LIMITS_HANDOFF staging table. Table 18 shows how the limit data stored in this table is mapped to Siebel CRM.
Table 18. Mapping of Limit Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 |
|