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. The following information shows how the bills and collections 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
CONT_REF_ NO	FINS BIB Contract	Contract Reference Num	S_ASSET	ASSET_NUM	EIM_ASSET	AST_ASSET_NUM
		Contract Type		TYPE_CD		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