Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Data Mappings to Siebel EIM Tables >
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 21 shows how the letters of credit data stored in this staging table is mapped to Siebel CRM.
Table 21. Mapping of Letters of Credit Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 |
|