Siebel Master Data Applications Reference for Industry Applications > Siebel Master Data Applications Messages > Siebel Master Data Application Messages >

Account Product


UCM 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 24 describes the structure of this message.

Figure 24. UCM Account Products Structure

Table 89 lists the Account Product Query Integration objects.

Table 89. Account Product Query Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFAccountProduct

Account

LookUpAccountProduct

UK1:PartyUId
UK2: Id

CIFAccountProductRs

Account

LookUpAccountProductResponse

UK1:PartyUId
UK2: Id

Table 90 lists the Account Product Query by Name Integration objects.

Table 90. Account Product Query by Name Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFAccountProductByName

Account

LookUpAccountProductByName

UK1:PartyUIdUK2: Id

CIFAccountProductByNameRs

Account

LookUpAccountProductByNameResponse

UK1:PartyUIdUK2: Id

Table 91 lists the Account Product Update Integration objects.

Table 91. Account Product Update Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFAccountProductUpdate

Account

UpdateAccountProduct

UK1:PartyUId
UK2: Id

CIFAccountProductUpdateRs

Account

UpdateAccountProductResponse

UK1:PartyUId
UK2: Id

Table 92 lists the Account Product Insert Integration objects.

Table 92. Account Product Insert Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFAccountProductInsert

Account

InsertAccountProduct

UK1:PartyUIdUK2: Id

CIFAccountProductInsertRs

Account

InsertAccountProductResponse

UK1:PartyUIdUK2: Id

Table 93 lists the Account Product Delete Integration objects.

Table 93. Account Product Delete Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFAccountProductDelete

Account

DeleteAccountProduct

UK1:PartyUIdUK2: Id

CIFAccountProductDeleteRs

Account

DeleteAccountProductResponse

UK1:PartyUIdUK2: Id

Table 94 lists the Account Product Integration Component and Integration Component Fields.

Table 94. Account Product Integration Component and Integration Component Fields
Name
XML Tag
Data Type
Length
Req
Notes

IC: Account

Account Region

AccountRegion

DTYPE_TEXT

30

 

Use for picking a related entity

Account Status

AccountStatus

DTYPE_TEXT

24

 

Bound by ACCOUNT_STATUS

Account Type Code

AccountTypeCode

DTYPE_TEXT

30

4

Bound by CUT_ACCOUNT_TYPE

Account Value

AccountValue

DTYPE_TEXT

30

 

Bound by FIN_CON_VALUE_TYPE

Alias

Alias

DTYPE_TEXT

50

 

 

Annual Revenue

AnnualRevenue

DTYPE_TEXT

22

 

 

Client Flag

ClientFlag

DTYPE_BOOL

1

 

 

Competitor

Competitor

DTYPE_BOOL

1

 

 

Credit Agency Number

CreditAgencyNumber

DTYPE_TEXT

30

 

 

Cumulative Sales

CumulativeSales

DTYPE_NUMBER

22

 

 

Currency Code

CurrencyCode

DTYPE_TEXT

15

4

 

Current Volume

CurrentVolume

DTYPE_CURRENCY

22

 

 

Dont Call

DontCall

DTYPE_BOOL

1

 

 

Drug Spent Currency Code

DrugSpentCurrencyCode

DTYPE_TEXT

30

4

Use for picking a related entity

Employees

Employees

DTYPE_NUMBER

22

 

 

Facility Flag

FacilityFlag

DTYPE_BOOL

1

 

 

Federal Tax Number

FederalTaxNumber

DTYPE_TEXT

15

 

 

Financing Method

FinancingMethod

DTYPE_TEXT

30

 

Bound by FINCORP_CLIENT_FINANCING

Gross Potential Value

GrossPotentialValue

DTYPE_CURRENCY

22

 

 

Group Type Code

GroupTypeCode

DTYPE_TEXT

30

4

Bound by GROUP_TYPE_CD

Home Page

HomePage

DTYPE_TEXT

100

 

 

Id

Id

DTYPE_ID

15

 

For cross-referencing

Integration Id

IntegrationId

DTYPE_TEXT

30

 

 

Internal Org Flag

InternalOrgFlag

DTYPE_BOOL

1

4

 

Investor Flag

InvestorFlag

DTYPE_BOOL

1

 

 

Last Year Sales

LastYearSales

DTYPE_CURRENCY

22

 

 

Legal Status

LegalStatus

DTYPE_TEXT

30

 

Bound by UT_LEGAL_STATUS

Location

Location

DTYPE_TEXT

50

 

 

Main Fax Number

MainFaxNumber

DTYPE_PHONE

40

 

 

Main Phone Number

MainPhoneNumber

DTYPE_PHONE

40

 

 

Master Account Id

MasterAccountId

DTYPE_ID

15

 

 

Name

Name

DTYPE_TEXT

100

 

 

operation

operation

DTYPE_TEXT

30

 

 

Partner Flag

PartnerFlag

DTYPE_BOOL

1

 

 

Party UId

PartyUId

DTYPE_TEXT

100

4

 

Privacy Code

PrivacyCode

DTYPE_TEXT

30

4

Bound by PRIVACY_CODE

Reference Flag

ReferenceFlag

DTYPE_BOOL

1

 

 

Referenciable

Referenciable

DTYPE_BOOL

1

 

 

Revenue Growth

RevenueGrowth

DTYPE_NUMBER

22

 

 

Service Provider Flag

ServiceProviderFlag

DTYPE_TEXT

1

 

 

Status

Status

DTYPE_TEXT

30

 

Bound by FINS_COMPETITOR_STATUS_MLOV

Total # Meters

TotalMeters

DTYPE_NUMBER

22

 

 

Total Potential Volume

TotalPotentialVolume

DTYPE_CURRENCY

22

 

 

Type

Type

DTYPE_TEXT

30

 

Bound by ACCOUNT_TYPE

Unionized

Unionized

DTYPE_BOOL

1

 

 

YTD Net Contribution

YTDNetContribution

DTYPE_CURRENCY

22

 

 

IC: FINCORP Deposit Account

Account Branch Number

AccountBranchNumber

DTYPE_TEXT

100

 

 

Account Category

AccountCategory

DTYPE_TEXT

30

 

Bound by FINS_ASSET_PROD_CLASS_MLOV

Account Number

AccountNumber

DTYPE_TEXT

100

4

 

Account Status

AccountStatus

DTYPE_TEXT

30

 

Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV

Branch

Branch

DTYPE_TEXT

50

 

 

Current Balance

CurrentBalance

DTYPE_CURRENCY

22

 

 

Id

Id

DTYPE_TEXT

100

 

 

Integration Id

Integration Id

DTYPE_TEXT

30

 

 

Name

Name

DTYPE_TEXT

100

4

Use for pick a related entity

operation

operation

DTYPE_TEXT

30

 

 

Product Id

ProductId

DTYPE_ID

100

4

 

searchspec

searchspec

DTYPE_TEXT

250

 

 

Type

Type

DTYPE_TEXT

30

 

Bound by FINS_OWNERSHIP_TYPE_MLOV

IC: FINCORP Loan Account

Account Branch Number

AccountBranchNumber

DTYPE_TEXT

30

 

 

Account Category

AccountCategory

DTYPE_TEXT

30

 

Bound by FINS_ASSET_PROD_CLASS_MLOV

Account Number

AccountNumber

DTYPE_TEXT

100

4

 

Account Status

AccountStatus

DTYPE_TEXT

30

 

Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV

Current Balance

CurrentBalance

DTYPE_CURRENCY

22

 

 

Id

Id

DTYPE_TEXT

30

 

 

Integration Id

IntegrationId

DTYPE_TEXT

30

 

 

Name

Name

DTYPE_TEXT

100

4

Use for pick a related entity

operation

operation

DTYPE_TEXT

30

 

 

Product Id

ProductId

DTYPE_ID

100

4

Use for pick a related entity

searchspec

searchspec

DTYPE_TEXT

250

 

 

Type

Type

DTYPE_TEXT

30

 

FINS_OWNERSHIP_TYPE_MLOV

Siebel Master Data Applications Reference for Industry Applications Copyright © 2007, Oracle. All rights reserved.