Table 55. QueryLoanAccountResponseEBM
|
Oracle FLEXCUBE Service Name |
Oracle FLEXCUBE Interface Object |
Oracle FLEXCUBE Interface Column |
Siebel Contact Business Component |
|
/AccountNumber |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/ACCNO |
FINCORP Account |
Account Number |
/FinancialAccount Identification /ApplicationObjectKey /ContextID |
Not applicable |
Not applicable |
Hard coded to CL |
FINCORP Account |
Sub Type |
/FinancialAccount FinancialInstitution BranchBusinessUnit /FinancialAccount FinancialInstitution BranchBusinessUnit Reference/Business UnitIdentification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/BRN |
FINCORP BIB Account |
Branch Code |
/CurrencyCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CCY |
FINCORP Account |
Currency |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference/PartyIdentification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CPTY |
FINCORP BIB Account |
Not applicable |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference /PartyIdentification/ApplicationObjectKey/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/XREF |
FINCORP Account |
Organiza- tion Id Acct Gen - Authorized Users - Last Name |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference/ PartyIdentification/ ApplicationObjectKey/ContextID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
Values are I or C (Individual customer, Corporate customer) |
FINCORP BIB Account |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
FINCORP Account |
Acct Gen - Primary Contact Id |
/Status/Code |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/ACCSTAT |
FINCORP Account |
Account Status |
/ItemReference/ItemIdentification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/PRD |
FINCORP Account |
Name |
/MaturityDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/MATDT |
FINCORP Account |
Maturity Date |
/FinancialAccount Holder/Financial AccountSigning Authority/TypeCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/Othr-Applicants/RESP |
FINCORP Account Contact |
Type |
/BookedDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/BOOKDT |
FINCORP BIB Account |
Book Date |
/EffectiveDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/VALDT |
FINCORP Account |
Start Date |
/Status/SubStatusCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CONSTAT |
FINCORP BIB Account |
Contract Status |
/LoanAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/AMOUNT |
FINCORP Account |
Loan Amount |
/DisbursedAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/DISBAMT |
FINCORP BIB Account |
Amount Disbursed |
Components |
/LoanAccount Component/Identification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/COMPNAME |
FINCORP BIB Account Loan Components VBC |
Component Id |
/LoanAccount Component/TypeCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/COMPDESC |
FINCORP BIB Account Loan Components VBC |
Component Name |
/LoanAccount Component/Expected RepaidAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/EXPAMT |
FINCORP BIB Account Loan Components VBC |
Expected Amount |
/LoanAccount Component/Overdue Amount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/OVDAMT |
FINCORP BIB Account Loan Components VBC |
Overdue Amount |
/LoanAccount Component/Remaining Amount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/OUTSTDAMT |
FINCORP BIB Account Loan Components VBC |
Outstand- ing Amount |
/LoanAccount Component/Prepaid Amount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/ADVAMT |
FINCORP BIB Account Loan Components VBC |
Advance Amount |
/LoanAccount Component/Remaining Amount/@currencyCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/CCY |
FINCORP BIB Account Loan Components VBC |
Currency |
/LoanAccount Component/Effective InterestRate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/INTRT |
FINCORP BIB Account Loan Components VBC |
Latest Interest Rate |
Schedules |
/LoanAccount ScheduledRepayment/Identification/ID |
Not applicable |
Not applicable |
Running serial number |
FINCORP BIB Account Loan Schedule VBC |
Component Id |
/LoanAccount ScheduledRepayment/RepaymentDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/DUEDATE |
FINCORP BIB Account Loan Schedule VBC |
Schedule Due Date |
/LoanAccount ScheduledRepayment/RepaymentAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/AMTSETT |
FINCORP BIB Account Loan Schedule VBC |
Amount Settled |
/LoanAccount ScheduledRepayment/OverdueAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/AMTDUE |
FINCORP BIB Account Loan Schedule VBC |
Amount Due |
/LoanAccount ScheduledRepayment /EquatedInstallment PrincipalAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/EMIAMT |
FINCORP BIB Account Loan Schedule VBC |
EMI Amount |
/LoanAccount ScheduledRepayment /CurrentCycleInterest AccrualAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/ACCRAMT |
FINCORP BIB Account Loan Schedule VBC |
Accrued Amount |
/LoanAccount ScheduledRepayment /EquatedInstallment TotalAmount |
Not applicable |
Not applicable |
The amortized principal is derived based on the EMI amount and the amount due For the interest component.This applies to amortized loans only. |
FINCORP BIB Account Loan Schedule VBC |
Amortized Principal |