Table 29. QueryCustomerPartyListResponseEBM
|
Oracle FLEXCUBE Service Name |
Oracle FLEXCUBE Interface Object |
Oracle FLEXCUBE Interface Column |
Siebel Contact Business Compon-ent |
|
Siebel Account Business Compon-ent |
|
/Identification /ID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CUSTNO |
Contact |
Integration Id |
Account |
Integration Id |
/Identification /Application ObjectKey/ID |
FCUBS Customer Service |
ST-Modify Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/XREF |
Contact |
Id |
Account |
id |
/Identification /Application ObjectKey /ContextID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CTYPE |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference/Address/LineOne |
FCUBS Customer Service |
ST-Modify Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN1 |
CUT Address |
Street Address |
CUT Address |
Street Address |
/PartyLocation /Location Reference/Address/LineTwo |
FCUBS Customer Service |
ST-Modify Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN2 |
CUT Address |
Street Address 2 |
CUT Address |
Street Address 2 |
/PartyLocation /Location Reference/Address/LineThree |
FCUBS Customer Service |
ST-Modify Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN3 |
CUT Address |
City |
CUT Address |
City |
/PartyLocation /Location Reference/Address/LineFour |
FCUBS Customer Service |
ST-Modify Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN4 |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference/Address/CountryCode |
FCUBS Customer Service |
ST-Modify Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/COUNTRY |
CUT Address |
Country |
CUT Address |
Country |
/PartyContact /Contact/ContactPhone Communica tion/PhoneComm unication/Complete Number |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/TEL |
Contact |
Work Phone # |
Not applicable |
Not applicable |
/PartyContact /Contact/ContactFax Communica tion/FaxComm unication/Complete Number |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custpersonal/FAX |
Contact |
Fax Phone # |
Not applicable |
Not applicable |
/PartyContact /Contact/ContactEmail Communica tion/EmailComm unication/URI |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custpersonal/EMAIL |
Contact |
Email Address |
Not applicable |
Not applicable |
/Person/GenderCode |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/SEX |
Contact |
M/F |
Not applicable |
Not applicable |
/Person/MaritalStatus Code |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/MARTIALSTAT |
Contact |
Marital Status |
Not applicable |
Not applicable |
/Person/BirthDateTime |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/DOB |
Contact |
Birth Date |
Not applicable |
Not applicable |
/Person/Language Code |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LANG |
Contact |
Language Code |
Not applicable |
Not applicable |
/Person/Nationality CountryCode |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personalNLTY |
Contact |
Citizenship |
Not applicable |
Not applicable |
/Person/RentOrOwn Code |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/ACCOMADATE |
Contact |
Own or Rent |
Not applicable |
Not applicable |
/Person/Deceased Indicator |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/DEAD |
Contact |
Deceased Flag |
Not applicable |
Not applicable |
/Person/PersonName /FirstName |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/FSTNAME |
Contact |
First Name |
Not applicable |
Not applicable |
/Person/PersonName /MiddleName |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/MIDNAME |
Contact |
Middle Name |
Not applicable |
Not applicable |
/Person/PersonName /FamilyName |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS _BODY/Customer-Full/Cust personal/LSTNAME |
Contact |
Last Name |
Not applicable |
Not applicable |
/Person/PersonName /Title |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/TITLE |
Contact |
M/M |
Not applicable |
Not applicable |
/Person/PersonName /Alias |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/SNAME |
Contact |
Alias |
Not applicable |
Not applicable |
/Person /Education Record /MajorCourse Category |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/EDUSTAT |
Contact |
FINS Education |
Not applicable |
Not applicable |
/Person/Employment Record /Employer Organization Name |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/CURREMP |
Contact |
Employer Name Free Text |
Not applicable |
Not applicable |
/Person /Employment Record /JobTitle |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/CURR DESIG |
Contact |
Job Title |
Not applicable |
Not applicable |
/Organization /Name |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/CORPNAME |
Not applicable |
Not applicable |
Account |
Name |
/Organization /LineOf Business |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/CORPDESC |
Not applicable |
Not applicable |
Account |
Line of Business |
/Person/TaxPayer IdentificationNumber |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/SSN |
Contact |
SSN |
Not applicable |
Not applicable |
/Organization /Home CountryCode |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/NLTY |
Not applicable |
Not applicable |
BIB Account BC |
Country of Incorpora- tion |
/Organization /BankBranch Reference /BankBranch Identification /ID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LBRN |
Not applicable |
Not applicable |
BIB Account BC |
Branch Code |
/LevelCode |
Not applicable |
Not applicable |
Values provided are PROSPECT,CUSTOMER |
Contact |
Status |
Account |
Account Status |
/Customer PartyCredit Profile/Credit RatingCode |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CRRATE |
BIB Contact BC |
Credit Rating |
Account |
Credit Rating |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/Party Identification /Application ObjectKey/ID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Relation ship-Linkage/CUSTOMER |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/ PartyRelated PersonParty /PersonParty Reference /Party Identification /Application ObjectKey /ContextID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Relation ship-Linkage/XREF |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party /Party Relationship /Relationship Code |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust accdet/Relation ship-Linkage/RELATIONSHIP |
Party Relation- ship To |
Relation- ship Type |
Party Relation- ship To |
Relation- ship Type |
/Customer Party Specification /Specification /Name |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCBUBS_ BODY/Customer-Full/UIDNAME |
Contact |
ID Type |
Not applicable |
Not applicable |
/Customer Party Specification /Specification /ValueText |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/UIDVAL |
Contact |
ID Informa-tion |
Not applicable |
Not applicable |
/Customer PartyFinancialServiceProfile /Financial Institution Branch BusinessUnit Reference/BusinessUnit Identification /iD |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LBRN |
BIB Contact BC |
BIB Contact BC |
Not applicable |
Not applicable |
/PartyContact /Contact /Preferred Communica tion ChannelCode |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/MEDIA |
Contact |
Preferred Communi-cation Method |
Account |
Preferred Communi-cation Method |
/Person /Personal National Identity /TypeCode |
Not applicable |
Not applicable |
Not applicable |
Contact |
Other ID Type |
Not applicable |
Not applicable |
/Person /Personal National Identity /Identification /ID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/PPTNO |
Contact |
Other ID Number |
Not applicable |
Not applicable |
/Resident Indicator |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/STATUS |
BIB Contact BC |
Permenant Resident |
Not applicable |
Not applicable |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PersonName /FullName |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/SPNAME |
Contact |
Spouse Name |
Not applicable |
Not applicable |
/Person Total Dependent Count |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/DEPOTH |
BIB Contact BC |
Number Of Depend-ents |
Not applicable |
Not applicable |
/Person /Employment Record /PositionType Code |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS _RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/EMPSTAT |
BIB Contact BC |
Employ-ment Status |
Not applicable |
Not applicable |
/Person/Employment Record/Employment Duration |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof /EMPTEN-URE |
BIB Contact BC |
Years Employed |
Not applicable |
Not applicable |
/Person /Personal Income Amount |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/SALARY |
FIN Contact Income |
Amount |
Not applicable |
Not applicable |
/Potential Revenue Amount |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/OTH INCOME |
FIN Contact Income |
Amount |
Not applicable |
Not applicable |
/Organization /Incorpora tionDate |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/INCORPDT |
Not applicable |
Not applicable |
Account |
Date Formed |
/Organization/ShortName |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS _RES_ENV/FCBUBS_ BODY/Customer-Full/SNAME |
Not applicable |
Not applicable |
Account |
Alias |
/Classification Code |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CUST CLASSFN |
Contact |
Customer Value |
Account |
Account Value |
/Customer PartyFinancial ServiceProfile /Financial Institution Reference /Party Identification /ID |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LBRN |
BIB Contact BC |
Bank Code |
BIB Account BC |
Bank Code |
/Organization/Incorporation CountryCode |
FCUBS Customer Service |
ST-Query Customer-Res-Full-MSG.xsd |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ INCORP CNTRY |
Not applicable |
Not applicable |
BIB Account BC |
Country of Incorpora- tion |
/EBMHeader /Sender /Transaction Code |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |