Mapping of Mandate Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, mandate data is stored in the PCTM_CLIENT_HANDOFF staging table. The following information shows how the mandate 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 |
|---|---|---|---|---|---|---|
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 |