Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Data Mappings to Siebel EIM Tables >
Mapping of Mandate Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, mandate data is stored in the PCTM_CLIENT_HANDOFF staging table. Table 19 shows how the mandate data stored in this table is mapped to Siebel CRM.
Table 19. Mapping of Mandate Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
Product Code |
FINS BIB Mandate |
Product Code |
S_FN_ MANDATE |
PROD_ID |
EIM_FN_ ASSET1 |
MNDT_PROD_NAME |
MNDT_PROD_BU |
Customer |
FINS BIB Mandate |
Contact Id |
S_FN_ MANDATE |
CONTACT_ID |
EIM_FN_ ASSET1 |
MNDT_ PERSON_UID |
MNDT_CON_PRIV_FLG |
MNDT_CON_BU |
Customer |
FINS BIB Mandate |
Account Id |
S_FN_ MANDATE |
ACCOUNT_ID |
EIM_FN_ ASSET1 |
MNDT_ACCOUNTACCNTN |
MNDT_ACCOUNTACCNTL |
MNDT_ACCOUNTACC_BU |
Account |
FINS BIB Mandate |
Account Number |
S_FN_ MANDATE |
FN_ACCNT_ID |
EIM_FN_ ASSET1 |
AST_ASSET_NUM |
AST_BU |
AST_PROD_BU |
AST_PROD_NAME |
AST_REV_ NUM |
Currency |
FINS BIB Mandate |
Currency Code |
S_FN_ MANDATE |
CURCY_CD |
EIM_FN_ ASSET1 |
MNDT_ CURCY_CD |
Direct Debit Agreement Flag |
FINS BIB Mandate |
Direct Debit Agreement Flag |
S_FN_ MANDATE |
DIRDBT_AGR_REQ_FLG |
EIM_FN_ ASSET1 |
MNDTDIRDBTAGREXSFL |
Creditor Identification Required |
FINS BIB Mandate |
Creditor Identification Required Flag |
S_FN_ MANDATE |
CR_ACC_NUM_REQ_FLG |
EIM_FN_ ASSET1 |
MNDTCRACCNUMREQFLG |
Agreement ID Required |
FINS BIB Mandate |
Agreement ID Required Flag |
S_FN_ MANDATE |
DIRDBT_AGR_EXS_FLG |
EIM_FN_ ASSET1 |
MNDTDIRDBTAGRREQFL |
|