Table 57. 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 |
