|
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 20 shows how the limit data stored in this table is mapped to Siebel CRM.
Table 20. 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 |
| 
