Mapping of Contract Data (Letters of Credit) to Siebel CRM

In Oracle FLEXCUBE Universal Banking, letters of credit data is stored in the LCTB_CONTRACT_HANDOFF staging table. The following table shows how the letters of credit data stored in the staging 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
CONTRACT_ 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
CURRENCY	FINS BIB Contract	Currency Code	S_ASSET	CURCY_CD	EIM_FN_ ASSET	AST_CURCY_CD
CONTRACT_ STATUS	FINS BIB Contract	Contract Status	S_ASSET	STATUS_CD	EIM_FN_ ASSET	AST_STATUS_CD
CONTRACT_ AMT	FINS BIB Contract	Contract Amount	S_ASSET	ASSET_VALUE_AMT	EIM_FN_ ASSET	AST_ ASSETVALUE_AMT
EXPIRY_DT	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
OS_LIABILITY	FINS BIB Contract	Bill Outstanding Amount	S_FN_ ACCNT1_FNX	OUTSTANDING_AMT	EIM_FN_ ASSET3	AST_OUT STANDING AMT
CURRENT_ AVAILABILITY	FINS BIB Contract	Current Availability	S_ASSET	CURRENT_BAL	EIM_ASSET	AST_ CURRENT_ BAL