Siebel Innovation Pack 2015: Mapping of Mandate Data to Siebel CRM

In Oracle FLEXCUBE Universal Banking, mandate data is stored in the PCTM_CLIENT_HANDOFF staging table. Table 21 shows how the mandate data stored in this table is mapped to Siebel CRM.

Table 21. Mapping of Mandate Data 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
Product Code	FINS BIB Mandate	Product Code	S_FN_ MANDATE	PROD_ID	EIM_FN_ ASSET1	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

Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide		Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.