Siebel Innovation Pack 2015: Mapping of Contract Data (Bills and Collections) to Siebel CRM

In Oracle FLEXCUBE Universal Banking, bills and collections contract data is stored in the BCTB_CONTRACT_HANDOFF staging table. Table 22 shows how the bills and collections data stored in this table is mapped to Siebel CRM.

Table 22. Mapping of Bills and Collections 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
CONT_REF_ NO	FINS BIB Contract	Contract Reference Num	S_ASSET	ASSET_NUM	EIM_ASSET	AST_ASSET_NUM
CONT_REF_ NO	FINS BIB Contract	Contract Type	S_ASSET	TYPE_CD	EIM_ASSET	AST_TYPE_ CD
PRODUCT_ CODE	FINS BIB Contract	Product Id	S_ASSET	PROD_ID	EIM_ASSET	AST_PROD_NAME; AST_PROD_BU
BRANCH_ CODE	FINS BIB Contract	Branch Id	S_ASSET	BRANCH_ID	EIM_FN_ ASSET	BRANCH_ACCNT_BU
						BRANCH_ACCNT_LOC
						BRANCH_ACCNT_NAME
BILL_CCY	FINS BIB Contract	Currency Code	S_ASSET	CURCY_CD	EIM_FN_ ASSET	AST_CURCY_CD
CONT_ STATUS	FINS BIB Contract	Contract Status	S_ASSET	STATUS_CD	EIM_FN_ ASSET	AST_STATUS_CD
BILL_AMT	FINS BIB Contract	Contract Amount	S_ASSET	ASSET_VALUE_AMT	EIM_FN_ ASSET	AST_ASSETVALUE_AMT
MAT_DATE	FINS BIB Contract	Maturity Date	S_FN_ACCNT1_FNX	CP_MATURITY_DT	EIM_FN_ ASSET3	AST_CP_MATURITY_DT
CUSTOMER_ ID	FINS BIB Contract	Account Id	S_ASSET	OWNER_ ACCNT_ID	EIM_ASSET	OWNER_ACCNT_BU
						OWNER_ACCNT_LOC
						OWNER_ACCNT_NAME
CUSTOMER_ ID	FINS BIB Contract	Contact Id	S_ASSET_CON	CONTACT_ID	EIM_ASSET	CON_CON_ PRIV_FLG
						CON_ PERSON_UID
						CON_CON_ BU
BILL_OUT_ AMT	FINS BIB Contract	Bill Outstanding Amount	S_FN_ ACCNT1_FNX	OUTSTANDING_AMT	EIM_FN_ ASSET3	AST_OUTSTANDINGAMT
DISC_FLAG	FINS BIB Contract	Discrepancies Flag	S_FN_ ACCNT1_FNX	DISCREPANCY_FLG	EIM_FN_ ASSET3	AST_DISCREPANCYFLG
EXCPTN_ FLAG	FINS BIB Contract	Exceptions Flag	S_FN_ ACCNT1_FNX	TXN_FAILURE_FLG	EIM_FN_ ASSET3	AST_TXN_ FAILUREFLG
LC_CONT_ REF_NO	FINS BIB Contract	LC Reference Number	S_ASSET	REF_NUMBER_1	EIM_FN_ ASSET	AST_REF_ NUMBER_1

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