9Data Mappings to Siebel EIM Tables
Data Mappings to Siebel EIM Tables
This appendix lists the data mappings used when Oracle Data Integrator retrieves data from Oracle FLEXCUBE Universal Banking staging tables and loads it into the Siebel Enterprise Integration Manager (EIM) tables during the batch data integration process. It includes the following topics:
About Mapping Tables
The tables in this appendix provide details about the way in which Oracle FLEXCUBE Universal Banking data is mapped to Siebel CRM data for each entity that is integrated using the batch data loading process. For each Oracle FLEXCUBE Universal Banking entity attribute, the mapping tables list the following information for the corresponding Siebel attribute:
The Siebel business component and field names
The Siebel base table and column names
The Siebel EIM table and column names
Mapping of Branch Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, branch data is stored in the STTM_BRANCH_HANDOFF staging table. The following information shows how the branch data stored in this table is mapped to Siebel CRM.
Table Branch Data Mapping 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 |
|---|---|---|---|---|---|---|
Branch_Code |
Internal Division |
Location |
S_ORG_EXT |
LOC |
EIM_FN_ ACCNT1 |
ACC_LOC Part of User Key |
Branch_Code |
Internal Division |
Party UId |
S_ORG_EXT |
PARTY_UID |
EIM_FN_ ACCNT1 |
PARTY_UID |
Branch_Name |
Internal Division |
Name |
S_ORG_EXT |
NAME |
EIM_FN_ ACCNT1 |
ACC_NAME Part of User Key |
Routing_ Number |
Internal Division |
ABA Number |
S_ORG_EXT |
ABA_NUMBER |
EIM_FN_ ACCNT1 |
ACC_ABA_ NUMBER |
Parent_ Branch_Code |
Internal Division |
Parent Division Id |
S_ORG_EXT |
PAR_DIVN_ID |
EIM_FN_ ACCNT1 |
PARDIV_ ACCNT_BU PARDIV_ ACCNT_LOC PARDIV_ACCNT_NAME |
Local Currency |
Internal Division |
Currency Code |
S_ORG_EXT |
BASE_CURCY_CD |
EIM_FN_ ACCNT1 |
ACC_BASE_ CURCY_CD |
Address 1 |
Internal Division |
Street Address |
S_CON_ADDR This is a new record in the S_CON_ADDR table. |
ADDR_PER_ID |
EIM_FN_ ACCNT1 |
ADDR_ NAME |
Address 2 |
ACCNT_ID |
ACCNT_BU |
||||
Address 3 |
ACCNT_LOC ACCNT_ NAME |
|||||
Address1 |
CUT Address |
Street Address |
S_ADDR_PER |
ADDR |
EIM_ADDR_ PER |
AP_ADDR |
Address2 |
CUT Address |
Branch Address 2 |
S_ADDR_PER |
ADDR_LINE_2 |
EIM_ADDR_ PER |
AP_ADDR_ LINE_2 |
Address3 |
CUT Address |
Apartment Number |
S_ADDR_PER |
ADDR_LINE_3 |
EIM_ADDR_ PER |
AP_ADDR_ LINE_3 |
Country Code |
CUT Address |
Country |
S_ADDR_PER |
COUNTRY |
EIM_FN_ ACCNT1 |
AP_ COUNTRY |
Mapping of Product Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, product data is stored in the CSTM_PRD_HANDOFF staging table, and account class data is stored in the STTM_ACLASS_HANDOFF staging table. This topic shows how data stored in these tables is mapped to Siebel CRM.
The following information shows the mapping of product data from the Oracle FLEXCUBE Universal Banking CSTM_PRD_HANDOFF table to Siebel CRM.
Table Mapping of Product 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 |
|---|---|---|---|---|---|---|
PRD_CODE |
Internal Product |
Name |
S_PROD_INT |
NAME |
EIM_PROD_INT |
NAME |
PRD_ DESCRIPTION |
Internal Product |
Description |
S_PROD_INT |
DESC_TEXT |
EIM_PROD_INT |
DESC_TEXT |
PRD_TYPE |
Internal Product |
Product Type |
S_PROD_INT |
DETAIL_TYPE_CD |
EIM_PROD_INT |
DETAIL_TYPE_CD |
PRD_SLOGAN |
Not displayed on business component |
No field |
S_PROD_INT |
STRATEGY |
EIM_PROD_INT |
STRATEGY |
PRD_START_DATE |
Internal Product |
Start Date |
S_PROD_INT |
EFF_START_ DT |
EIM_PROD_INT |
EFF_START_DT |
PRD_END_ DATE |
Internal Product |
End Date |
S_PROD_INT |
EFF_END_DT |
EIM_PROD_INT |
EFF_END_DT |
PRD_ REMARKS |
Internal Product |
Comments |
S_PROD_INT |
COMMENTS |
EIM_PROD_INT |
PROD_ COMMENTS |
REVOLVING |
Internal Product |
Featured |
S_PROD_INT |
FEATURED_ FLG |
EIM_PROD_INT |
FEATURED_ FLG |
RECORD STATUS |
Internal Product |
Version Status |
S_PROD_INT |
STATUS_CD |
EIM_PROD_INT |
STATUS_CD |
PRD_GROUP |
Product Line |
Name |
S_PROD_LN |
NAME |
EIM_PROD_LN |
PRDLN_NAME |
S_PROD_ LN_PROD |
PROD_LN_ID |
EIM_PROD_LN |
PRDLN_NAME There is a many-to-many relationship between Product and Product Line. |
|||
S_PROD_ LN_ROD |
PROD_ID |
EIM_PROD_LN |
PROD_PROD_BU PROD_PROD_NAME |
The following information shows the mapping of account class data from the Oracle FLEXCUBE Universal Banking STTM_ACLASS_HANDOFF staging table to Siebel CRM.
Table Mapping of Account Class Data
| Oracle FLEXCUBE Attribute | Siebel Business Compon-ent | Siebel Field | Siebel Base Table | Siebel Base Column | Siebel EIM Table | Siebel EIM Table Column |
|---|---|---|---|---|---|---|
ACCOUNT_ CLASS |
Internal Product |
Name |
S_PROD_INT |
NAME |
EIM_PROD_INT |
NAME |
DESCRIPTION |
Internal Product |
Description |
S_PROD_INT |
DESC_TEXT |
EIM_PROD_INT |
DESC_TEXT |
AC_CLASS_ TYPE |
Internal Product |
Product Type |
S_PROD_INT |
DETAIL_TYPE_CD |
EIM_PROD_INT |
DETAIL_TYPE_CD |
START_DATE |
Internal Product |
Start Date |
S_PROD_INT |
EFF_START_ DT |
EIM_PROD_INT |
EFF_START_DT |
END_DATE |
Internal Product |
End Date |
S_PROD_INT |
EFF_END_DT |
EIM_PROD_INT |
EFF_END_DT |
RECORD STATUS |
Internal Product |
Version Status |
S_PROD_INT |
STATUS_CD |
EIM_PROD_INT |
STATUS_CD |
ACCOUNT_ CODE |
Product Line |
Name |
S_PROD_LN |
NAME |
EIM_PROD_LN |
PRDLN_ NAME |
S_PROD_LN_ PROD |
PROD_LN_ID |
EIM_PROD_LN |
PRDLN_ NAME |
|||
S_PROD_LN_ PROD |
PROD_ID |
EIM_PROD_LN |
PROD_PROD_BU PROD_PROD_NAME |
|||
CHEQUE_ BOOK_ FACILITY OVERDRAFT_ FACILITY PASSBOOK_ FACILITY ATM_FACILITY ILM_ APPLICABLE BRANCH_LIST |
Key Feature A one-to-many mapping exists between Oracle FLEXCUBE products and features. |
Feature |
S_PROD_ SPEC |
DESC_TEXT |
EIM_PROD_ INT1 |
SPEC_DESC_TEXT |
Value |
S_PROD_ SPEC |
VAL |
EIM_PROD_ INT1 |
SPEC_VAL |
||
PROD_ID |
EIM_PROD_ INT1 |
PROD_BU PROD_NAME |
Mapping of Product Rate Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, product rate data is stored in the following staging tables:
Loan data is stored in the CLTM_LOAN_RATE_HDF staging table.
Corporate deposit data is stored in the LDTM_CDRATE_HANDOFF staging table.
Checking account, savings account (CASA) and retail deposit data is stored in the STTM_ACCLASS_UDE_VALHF staging table.
This topic shows how the data stored in these tables is mapped to Siebel CRM.
The following information shows the mapping of loan product rate data from the Oracle FLEXCUBE Universal Banking CLTM_LOAN_RATE_HDF staging table to Siebel CRM.
.
Table Mapping of Loan Product Rate 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 |
|---|---|---|---|---|---|---|
CCY_CODE (Currency) |
Internal Product |
Currency Code |
S_PROD_INT |
CARY_COST_ CURCY_CD |
EIM_FN_PRDINT1 |
PROD_CARYCOSTCURCY |
PRODUCT_ CODE (Product) |
FIN Product Rates |
Product Id |
S_PROD_RATE |
PROD_ID |
EIM_FN_PRDINT1 |
PROD_NAME PROD_BU |
UDE_ID (Rate Component) |
FIN Product Rates |
Not Available |
S_PROD_RATE |
INDEX_CD |
EIM_FN_PRDINT1 |
RT_INDEX_ CD |
UDE_VALUE (Rate Code) |
FIN Product Rates |
Default Rate |
S_PROD_RATE |
INDEX_RATE |
EIM_FN_PRDINT1 |
RT_INDEX_ RATE |
UDE_CCY (Rate Currency) |
FIN Product Rates |
Not Available |
S_PROD_RATE |
PROD_CURCY_CD |
EIM_FN_PRDINT1 |
RT_PROD_ CURCY_CD |
RATE_TYPE (Rate Type) |
FIN Product Rates |
Rate Type |
S_PROD_RATE |
TYPE_CD |
EIM_FN_PRDINT1 |
RT_TYPE_CD |
MAXIMUM_ TENOR (Maximum Tenor) |
FIN Product Rates |
Max Term |
S_PROD_RATE |
MAX_TERM |
EIM_FN_PRDINT1 |
RT_MAX_ TERM |
MINIMUM_ TENOR (Minimum Tenor) |
FIN Product Rates |
Min Term |
S_PROD_RATE |
MIN_TERM |
EIM_FN_PRDINT1 |
RT_MIN_ TERM |
UNITS (Units) |
FIN Product Rates |
Max Term Duration |
S_PROD_RATE |
MAX_TERM_DUR_ CD |
EIM_FN_PRDINT1 |
RT_MAX_TERM_DUR_CD |
Min Term Duration |
MIN_TERM_DUR_ CD |
MIN_TERM_DUR_CD |
||||
RULE_ DESCRIPTION (Rule Description) |
FIN Prod Rate Condition |
Rate Condition |
S_CONDITION |
DESC_TEXT |
EIM_FN_CNDTN |
CND_DESC_TEXT |
Condition Type |
S_CONDITION |
TYPE_CD |
CND_TYPE_CD |
|||
S_PRODRATE_ COND |
COND_ID |
EIM_FN_PRDINT1 |
COND_CND_DESC_TXT1 COND_CND_TYPE_CD1 |
|||
PRODRATE_ID |
RT_DEDUCT_AMT PROD_BI PROD_NAME RT_TYPE_CD |
The following information shows the mapping of corporate deposit product rate data from the Oracle FLEXCUBE Universal Banking LDTM_CDRATE_HANDOFF staging table to Siebel CRM.
Table Mapping of Corporate Deposit Product Rate 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 |
|---|---|---|---|---|---|---|
PRODUCT_ CODE |
FIN Product Rates |
Product Id |
S_PROD_ RATE |
PROD_ID |
EIM_FN_ PRDINT1 |
PROD_NAME PROD_BU |
COMPONENT_NAME |
FIN Product Rates |
Not available |
S_PROD_ RATE |
INDEX_CD |
EIM_FN_ PRDINT1 |
RT_INDEX_ CD |
RATE_TYPE |
FIN Product Rates |
Rate Type |
S_PROD_ RATE |
TYPE_CD |
EIM_FN_ PRDINT1 |
RT_TYPE_CD |
CURRENCY |
Internal Product |
Currency Code |
S_PROD_INT |
CARY_COST_CURCY_CD |
EIM_FN_ PRDINT1 |
PROD_CARYCOSTCURCY |
DEFAULT_ RATE |
FIN Product Rates |
Default Rate |
S_PROD_ RATE |
INDEX_RATE |
EIM_FN_ PRDINT1 |
RT_INDEX_ RATE |
MAXIMUM_ RATE |
FIN Product Rates |
Max Rate |
S_PROD_ RATE |
MAX_RATE |
EIM_FN_ PRDINT1 |
RT_MAX_ RATE |
MINIMUM_ RATE |
FIN Product Rates |
Min Rate |
S_PROD_ RATE |
MIN_RATE |
EIM_FN_ PRDINT1 |
RT_MIN_ RATE |
DEFAULT_ SPREAD |
FIN Product Rates |
Margin Spread |
S_PROD_ RATE |
MARGIN_ SPREAD |
EIM_FN_PRDINT1 |
RT_MARGIN_SPREAD |
MAXIMUM_ TANOR |
FIN Product Rates |
Max Term |
S_PROD_ RATE |
MAX_TERM |
EIM_FN_ PRDINT1 |
RT_MAX_ TERM |
MINIMUM_ TANOR |
FIN Product Rates |
Min Term |
S_PROD_ RATE |
MIN_TERM |
EIM_FN_ PRDINT1 |
RT_MIN_ TERM |
UNITS |
FIN Product Rates |
Max Term Duration |
S_PROD_ RATE |
MAX_TERM_ DUR_CD |
EIM_FN_ PRDINT1 |
RT_MAX_ TERM_DUR_CD |
Min Term Duration |
MIN_TERM_ DUR_CD |
RT_MIN_ TERM_DUR_CD |
The following information shows the mapping of CASA and retail deposit product rate data from the Oracle FLEXCUBE Universal Banking STTM_ACCLASS_UDE_VALHF staging table to Siebel CRM.
Table Mapping of CASA and Retail Deposit Product Rate 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 |
|---|---|---|---|---|---|---|
BRANCH_ CODE |
Internal Product |
Vendor Location |
S_PROD_INT |
OU_ID |
EIM_PROD_ INT |
VENDR_ ACCNT_BU |
VENDR_ ACCNT_LOC |
||||||
VENDR_ ACCNT_NAME |
||||||
CURRENCY_ CODE |
Internal Product |
Currency |
S_PROD_INT |
CARY_COST_CURCY_CD |
EIM_FN_ PRDINT1 |
PROD_CARYCOSTCURCY |
ACCOUNT_ CLASS (Product) |
FIN Product Rates |
Product Id |
S_PROD_ RATE |
PROD_ID |
EIM_FN_ PRDINT1 |
PROD_NAME |
PROD_BU |
||||||
UDE_ID (Rate Component) |
FIN Product Rates |
Not Available |
S_PROD_ RATE |
INDEX_CD |
EIM_FN_ PRDINT1 |
RT_INDEX_ CD |
RATE |
FIN Product Rates |
Default Rate |
S_PROD_ RATE |
INDEX_RATE |
EIM_FN_ PRDINT1 |
RT_INDEX_ RATE |
CHARGE_ AMOUNT |
FIN Product Rates |
Min Amount |
S_PROD_ RATE |
MIN_AMT |
EIM_FN_ PRDINT1 |
RT_MIN_AMT |
CHARGE_ RATE |
FIN Product Rates |
Min Rate |
S_PROD_ RATE |
MIN_RATE |
EIM_FN_ PRDINT1 |
RT_MIN_ RATE |
Mapping of Limit Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, limit data is stored in the GETM_LIMITS_HANDOFF staging table. The following information shows how the limit data stored in the table is mapped to Siebel CRM.
Table Mapping of Limit 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 |
|---|---|---|---|---|---|---|
Available Amount |
FINS BIB Limit Details |
Available Amount |
S_FN_LIMIT |
AVAILABLE_ AMT |
EIM_FN_ LIMIT |
LMT_AVAILABLE_AMT |
Effective Limit Amount |
FINS BIB Limit Details |
Effective Limit Amount |
S_FN_LIMIT |
EFF_LIMIT_ AMT |
EIM_FN_ LIMIT |
LMT_EFF_ LIMIT_AMT |
Line Currency |
FINS BIB Limit Details |
Line Currency |
S_FN_LIMIT |
CURCY_CD |
EIM_FN_ LIMIT |
LMT_CURCY_CD |
Line ID |
FINS BIB Limit Details |
Line ID |
S_FN_LIMIT |
LIMIT_NUM |
EIM_FN_ LIMIT |
LMT_LIMIT_ NUM |
Customer |
FINS BIB Limit Details |
Contact Id |
S_FN_LIMIT |
CONTACT_ID |
EIM_FN_ LIMIT |
LMT_CON_ BU |
LMT_CON_ PRIV_FLG |
||||||
LMT_PERSON_UID |
||||||
Customer |
FINS BIB Limit Details |
Account Id |
S_FN_LIMIT |
ACCOUNT_ID |
EIM_FN_ LIMIT |
LMT_ACCOUNTACCN_BU |
LMT_ACCOUNTACCNTLO |
||||||
LMT_ACCOUNTACCNTNA |
||||||
Main Line ID |
FINS BIB Limit Details |
Main Line ID |
S_FN_LIMIT |
PAR_LIMIT_ID |
EIM_FN_ LIMIT |
LMT_PAR_ LIMIT_NUM |
LMT_PAR_ LMT_ACC_BU |
||||||
LMT_PAR_ LMT_ACCLOC |
||||||
LMT_PAR_ LMTACCNAME |
||||||
LMT_PAR_ LMT_CON_BU |
||||||
LMT_PARLMTCONPRIVF |
||||||
LMT_PARLMTPERSONUI |
Mapping of Mandate Data to Siebel CRM
In Oracle FLEXCUBE Universal Banking, mandate data is stored in the PCTM_CLIENT_HANDOFF staging table. The following information shows how the mandate data stored in the table is mapped to Siebel CRM.
Table Mapping of Mandate 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 |
|---|---|---|---|---|---|---|
Product Code |
FINS BIB Mandate |
Product Code |
S_FN_ MANDATE |
PROD_ID |
EIM_FN_ ASSET1 |
MNDT_PROD_NAME |
MNDT_PROD_BU |
||||||
Customer |
FINS BIB Mandate |
Contact Id |
S_FN_ MANDATE |
CONTACT_ID |
EIM_FN_ ASSET1 |
MNDT_ PERSON_UID |
MNDT_CON_PRIV_FLG |
||||||
MNDT_CON_BU |
||||||
Customer |
FINS BIB Mandate |
Account Id |
S_FN_ MANDATE |
ACCOUNT_ID |
EIM_FN_ ASSET1 |
MNDT_ACCOUNTACCNTN |
MNDT_ACCOUNTACCNTL |
||||||
MNDT_ACCOUNTACC_BU |
||||||
Account |
FINS BIB Mandate |
Account Number |
S_FN_ MANDATE |
FN_ACCNT_ID |
EIM_FN_ ASSET1 |
AST_ASSET_NUM |
AST_BU |
||||||
AST_PROD_BU |
||||||
AST_PROD_NAME |
||||||
AST_REV_ NUM |
||||||
Currency |
FINS BIB Mandate |
Currency Code |
S_FN_ MANDATE |
CURCY_CD |
EIM_FN_ ASSET1 |
MNDT_ CURCY_CD |
Direct Debit Agreement Flag |
FINS BIB Mandate |
Direct Debit Agreement Flag |
S_FN_ MANDATE |
DIRDBT_AGR_REQ_FLG |
EIM_FN_ ASSET1 |
MNDTDIRDBTAGREXSFL |
Creditor Identification Required |
FINS BIB Mandate |
Creditor Identification Required Flag |
S_FN_ MANDATE |
CR_ACC_NUM_REQ_FLG |
EIM_FN_ ASSET1 |
MNDTCRACCNUMREQFLG |
Agreement ID Required |
FINS BIB Mandate |
Agreement ID Required Flag |
S_FN_ MANDATE |
DIRDBT_AGR_EXS_FLG |
EIM_FN_ ASSET1 |
MNDTDIRDBTAGRREQFL |
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.
Table 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 |
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 |
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.
Table 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 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 |