|
Oracle Customer Hub (UCM) Master Data Management Reference > ASIs and Messages for Oracle Master Data Management Applications > Messages for Oracle Master Data Management Applications >
Account Product
Account products messages are used in insert, query, update, and delete operations to maintain Account Product (Financial Account) Information. LookUpAccountProduct and LookUpAccountProductByName are used for query operations. UpdateAccountProduct, InsertAccountProduct, and DeleteAccountProduct are message pairs for request and response operations. Figure 21 describes the structure of this message.
Figure 21. Account Products Structure
|
Table 373 lists the Account Product Query Integration objects.
Table 373. Account Product Query Integration Objects
|
|
|
|
CIFAccountProduct |
Account |
LookUpAccountProduct |
UK1:PartyUId
UK2: Id |
CIFAccountProductRs |
Account |
LookUpAccountProductResponse |
UK1:PartyUId
UK2: Id |
Table 374 lists the Account Product Query by Name Integration objects.
Table 374. Account Product Query by Name Integration Objects
|
|
|
|
CIFAccountProductByName |
Account |
LookUpAccountProductByName |
UK1:PartyUIdUK2: Id |
CIFAccountProductByNameRs |
Account |
LookUpAccountProductByNameResponse |
UK1:PartyUIdUK2: Id |
Table 375 lists the Account Product Update Integration objects.
Table 375. Account Product Update Integration Objects
|
|
|
|
CIFAccountProductUpdate |
Account |
UpdateAccountProduct |
UK1:PartyUId
UK2: Id |
CIFAccountProductUpdateRs |
Account |
UpdateAccountProductResponse |
UK1:PartyUId
UK2: Id |
Table 376 lists the Account Product Insert Integration objects.
Table 376. Account Product Insert Integration Objects
|
|
|
|
CIFAccountProductInsert |
Account |
InsertAccountProduct |
UK1:PartyUIdUK2: Id |
CIFAccountProductInsertRs |
Account |
InsertAccountProductResponse |
UK1:PartyUIdUK2: Id |
Table 377 lists the Account Product Delete Integration objects.
Table 377. Account Product Delete Integration Objects
|
|
|
|
CIFAccountProductDelete |
Account |
DeleteAccountProduct |
UK1:PartyUIdUK2: Id |
CIFAccountProductDeleteRs |
Account |
DeleteAccountProductResponse |
UK1:PartyUIdUK2: Id |
Table 378 lists the Account Product Integration Component and Integration Component Fields.
Table 378. Account Product Integration Component and Integration Component Fields
|
|
|
|
|
|
IC: Account |
Account Region |
AccountRegion |
Text |
30 |
No |
Use for picking a related entity |
Account Status |
AccountStatus |
Text |
24 |
No |
Bound by ACCOUNT_STATUS |
Account Type Code |
AccountTypeCode |
Text |
30 |
Yes |
Bound by CUT_ACCOUNT_TYPE |
Account Value |
AccountValue |
Text |
30 |
No |
Bound by FIN_CON_VALUE_TYPE |
Alias |
Alias |
Text |
50 |
No |
None |
Annual Revenue |
AnnualRevenue |
Text |
22 |
No |
None |
Client Flag |
ClientFlag |
Boolean |
1 |
No |
None |
Competitor |
Competitor |
Boolean |
1 |
No |
None |
Credit Agency Number |
CreditAgencyNumber |
Text |
30 |
No |
None |
Cumulative Sales |
CumulativeSales |
Number |
22 |
No |
None |
Currency Code |
CurrencyCode |
Text |
15 |
Yes |
None |
Current Volume |
CurrentVolume |
Currency |
22 |
No |
None |
Dont Call |
DontCall |
Boolean |
1 |
No |
None |
Drug Spent Currency Code |
DrugSpentCurrencyCode |
Text |
30 |
Yes |
Use for picking a related entity |
Employees |
Employees |
Number |
22 |
No |
None |
Facility Flag |
FacilityFlag |
Boolean |
1 |
No |
None |
Federal Tax Number |
FederalTaxNumber |
Text |
15 |
No |
None |
Financing Method |
FinancingMethod |
Text |
30 |
No |
Bound by FINCORP_CLIENT_FINANCING |
Gross Potential Value |
GrossPotentialValue |
Currency |
22 |
No |
None |
Group Type Code |
GroupTypeCode |
Text |
30 |
Yes |
Bound by GROUP_TYPE_CD |
Home Page |
HomePage |
Text |
100 |
No |
|
Id |
Id |
Id |
15 |
No |
For cross-referencing |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Internal Org Flag |
InternalOrgFlag |
Boolean |
1 |
Yes |
None |
Investor Flag |
InvestorFlag |
Boolean |
1 |
No |
None |
Last Year Sales |
LastYearSales |
Currency |
22 |
No |
None |
Legal Status |
LegalStatus |
Text |
30 |
No |
Bound by UT_LEGAL_STATUS |
Location |
Location |
Text |
50 |
No |
None |
Main Fax Number |
MainFaxNumber |
Phone |
40 |
No |
None |
Main Phone Number |
MainPhoneNumber |
Phone |
40 |
No |
None |
Master Account Id |
MasterAccountId |
Id |
15 |
No |
None |
Name |
Name |
Text |
100 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Partner Flag |
PartnerFlag |
Boolean |
1 |
No |
None |
Party UId |
PartyUId |
Text |
100 |
Yes |
None |
Privacy Code |
PrivacyCode |
Text |
30 |
Yes |
Bound by PRIVACY_CODE |
Reference Flag |
ReferenceFlag |
Boolean |
1 |
No |
None |
Referenciable |
Referenciable |
Boolean |
1 |
No |
None |
Revenue Growth |
RevenueGrowth |
Number |
22 |
No |
None |
Service Provider Flag |
ServiceProviderFlag |
Text |
1 |
No |
None |
Status |
Status |
Text |
30 |
No |
Bound by FINS_COMPETITOR_STATUS_MLOV |
Total # Meters |
TotalMeters |
Number |
22 |
No |
None |
Total Potential Volume |
TotalPotentialVolume |
Currency |
22 |
No |
None |
Type |
Type |
Text |
30 |
No |
Bound by ACCOUNT_TYPE |
Unionized |
Unionized |
Boolean |
1 |
No |
None |
YTD Net Contribution |
YTDNetContribution |
Currency |
22 |
No |
None |
IC: FINCORP Deposit Account |
Account Branch Number |
AccountBranchNumber |
Text |
100 |
No |
None |
Account Category |
AccountCategory |
Text |
30 |
No |
Bound by FINS_ASSET_PROD_CLASS_MLOV |
Account Number |
AccountNumber |
Text |
100 |
Yes |
None |
Account Status |
AccountStatus |
Text |
30 |
No |
Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV |
Branch |
Branch |
Text |
50 |
No |
None |
Current Balance |
CurrentBalance |
Currency |
22 |
No |
None |
Id |
Id |
Text |
100 |
No |
None |
Integration Id |
Integration Id |
Text |
30 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
Use it for picking a related entity |
operation |
operation |
Text |
30 |
No |
None |
Product Id |
ProductId |
Id |
100 |
Yes |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Type |
Type |
Text |
30 |
No |
Bound by FINS_OWNERSHIP_TYPE_MLOV |
IC: FINCORP Loan Account |
Account Branch Number |
AccountBranchNumber |
Text |
30 |
No |
None |
Account Category |
AccountCategory |
Text |
30 |
No |
Bound by FINS_ASSET_PROD_CLASS_MLOV |
Account Number |
AccountNumber |
Text |
100 |
Yes |
None |
Account Status |
AccountStatus |
Text |
30 |
No |
Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV |
Current Balance |
CurrentBalance |
Currency |
22 |
No |
None |
Id |
Id |
Text |
30 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
Use it for picking a related entity |
operation |
operation |
Text |
30 |
No |
None |
Product Id |
ProductId |
Id |
100 |
Yes |
Use it for picking a related entity |
searchspec |
searchspec |
Text |
250 |
No |
None |
Type |
Type |
Text |
30 |
No |
FINS_OWNERSHIP_TYPE_MLOV |
| 
