Bookshelf v8.2: 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. Table 23 shows how the letters of credit data stored in this staging table is mapped to Siebel CRM.

Table 23. Mapping of Letters of Credit 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
CONTRACT_ REF_NO	FINS BIB Contract	Contract Reference Num	S_ASSET	ASSET_NUM	EIM_ASSET	AST_ASSET_NUM
CONTRACT_ 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
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

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