Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Data Mappings to Siebel EIM Tables >
Mapping of Branch Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, branch data is stored in the STTM_BRANCH_HANDOFF staging table. Table 12 shows how the branch data stored in this table is mapped to Siebel CRM.
Table 12. Branch Data Mapping to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
Branch_Code |
Internal Division |
Location |
S_ORG_EXT |
LOC |
EIM_FN_ ACCNT1 |
ACC_LOC Part of User Key |
Branch_Code |
Internal Division |
Party UId |
S_ORG_EXT |
PARTY_UID |
EIM_FN_ ACCNT1 |
PARTY_UID |
Branch_Name |
Internal Division |
Name |
S_ORG_EXT |
NAME |
EIM_FN_ ACCNT1 |
ACC_NAME Part of User Key |
Routing_ Number |
Internal Division |
ABA Number |
S_ORG_EXT |
ABA_NUMBER |
EIM_FN_ ACCNT1 |
ACC_ABA_ NUMBER |
Parent_ Branch_Code |
Internal Division |
Parent Division Id |
S_ORG_EXT |
PAR_DIVN_ID |
EIM_FN_ ACCNT1 |
PARDIV_ ACCNT_BU PARDIV_ ACCNT_LOC PARDIV_ACCNT_NAME |
Local Currency |
Internal Division |
Currency Code |
S_ORG_EXT |
BASE_CURCY_CD |
EIM_FN_ ACCNT1 |
ACC_BASE_ CURCY_CD |
Address 1 |
Internal Division |
Street Address |
S_CON_ADDR This is a new record in the S_CON_ADDR table. |
ADDR_PER_ID |
EIM_FN_ ACCNT1 |
ADDR_ NAME |
Address 2 |
ACCNT_ID |
ACCNT_BU |
Address 3 |
ACCNT_LOC ACCNT_ NAME |
Address1 |
CUT Address |
Street Address |
S_ADDR_PER |
ADDR |
EIM_ADDR_ PER |
AP_ADDR |
Address2 |
CUT Address |
Branch Address 2 |
S_ADDR_PER |
ADDR_LINE_2 |
EIM_ADDR_ PER |
AP_ADDR_ LINE_2 |
Address3 |
CUT Address |
Apartment Number |
S_ADDR_PER |
ADDR_LINE_3 |
EIM_ADDR_ PER |
AP_ADDR_ LINE_3 |
Country Code |
CUT Address |
Country |
S_ADDR_PER |
COUNTRY |
EIM_FN_ ACCNT1 |
AP_ COUNTRY |
|