Bookshelf v8.1/8.2: Siebel Financial Account

The Siebel Financial Account ASI is an ASI for privacy data management-related business processes. This ASI facilitates inbound and outbound financial account data synchronization between a Siebel application and a UCM system. Figure 19 describes the Siebel Financial Account ASI structure.

Table 28 lists the integration components and user keys of the Siebel Financial Account ASI.

Table 29 lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.

Table 29. Siebel Financial Account ASI Fields
Name	XML Tag	Data Type	Length	Req.
FINCORPAccount
ABA Number	ABANumber	DTYPE_TEXT	50	No
Account Alias	AccountAlias	DTYPE_TEXT	100	No
Account Branch ABA	AccountBranchABA	DTYPE_TEXT	50	No
Account Branch Id	AccountBranchId	DTYPE_ID	Not applicable	No
Account Branch Name	AccountBranchName	DTYPE_TEXT	100	No
Account Branch Number	AccountBranchNumber	DTYPE_TEXT	30	No
Account Holder	AccountHolder	DTYPE_TEXT	Not applicable	No
Account Name	AccountName	DTYPE_TEXT	100	No
Account Number	AccountNumber	DTYPE_TEXT	100	Yes
Account Row Id	AccountRowId	DTYPE_ID	Not applicable	No
Account Status	AccountStatus	DTYPE_TEXT	30	No
Account Type	AccountType	DTYPE_TEXT	30	No
Acct Gen - Account Id	AcctGen-AccountId	DTYPE_ID	Not applicable	No
Acct Gen - Average Balance	AcctGen-AverageBalance	DTYPE_CURRENCY	Not applicable	No
Acct Gen - Branch Id	AcctGen-BranchId	DTYPE_ID	Not applicable	No
Acct Gen - Organization Address Id	AcctGen-OrganizationAddressId	DTYPE_ID	Not applicable	No
Acct Gen - Pers Addr - City	AcctGen-PersAddr-City	DTYPE_TEXT	50	No
Acct Gen - Pers Addr - Country	AcctGen-PersAddr-Country	DTYPE_TEXT	30	No
Acct Gen - Pers Addr - Id	AcctGen-PersAddr-Id	DTYPE_ID	Not applicable	No
Acct Gen - Pers Addr - State	AcctGen-PersAddr-State	DTYPE_TEXT	10	No
Acct Gen - Pers Addr - Street	AcctGen-PersAddr-Street	DTYPE_TEXT	200	No
Acct Gen - Pers Addr - Zip Code	AcctGen-PersAddr-ZipCode	DTYPE_TEXT	30	No
Acct Gen - Primary Contact Id	AcctGen-PrimaryContactId	DTYPE_ID	Not applicable	No
Acct Gen - Product Line Id	AcctGen-ProductLineId	DTYPE_ID	Not applicable	No
Available Balance	AvailableBalance	DTYPE_CURRENCY	Not applicable	No
Balance	Balance	DTYPE_CURRENCY	Not applicable	No
Bank Number	BankNumber	DTYPE_TEXT	50	No
Billing Option	BillingOption	DTYPE_TEXT	30	No
Branch	Branch	DTYPE_TEXT	50	No
Branch Number	BranchNumber	DTYPE_TEXT	50	No
CA Next Statement Date	CANextStatementDate	DTYPE_DATE	Not applicable	No
Comments	Comments	DTYPE_TEXT	250	No
Commitment Amount	CommitmentAmount	DTYPE_CURRENCY	Not applicable	No
Conflict Id	ConflictId	DTYPE_ID	30	No
Contact Address Id	ContactAddressId	DTYPE_ID	Not applicable	No
Created	Created	DTYPE_DATETIME	30	No
Currency	Currency	DTYPE_TEXT	20	No
Current Balance	CurrentBalance	DTYPE_CURRENCY	Not applicable	No
Customer Number	CustomerNumber	DTYPE_TEXT	50	No
Customer Type	CustomerType	DTYPE_TEXT	30	No
First Name	FirstName	DTYPE_TEXT	50	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Last Name	LastName	DTYPE_TEXT	50	No
Mod Id	ModId	DTYPE_ID	30	No
Name	Name	DTYPE_TEXT	100	No
Organization Id	OrganizationId	DTYPE_ID	Not applicable	No
Parent ABA Number	ParentABANumber	DTYPE_TEXT	50	No
Parent Account Branch ABA	ParentAccountBranchABA	DTYPE_TEXT	50	No
Parent Account Branch Id	ParentAccountBranchId	DTYPE_ID	Not applicable	No
Parent Account Id	ParentAccountId	DTYPE_ID	Not applicable	No
Parent Account Number	ParentAccountNumber	DTYPE_TEXT	100	No
Parent Asset ID	ParentAssetID	DTYPE_ID	Not applicable	No
Parent Asset Number	ParentAssetNumber	DTYPE_TEXT	100	No
Parent Bank	ParentBank	DTYPE_TEXT	50	No
Payment Type	PaymentType	DTYPE_TEXT	30	No
Previous Balance	PreviousBalance	DTYPE_CURRENCY	Not applicable	No
Primary Account Id	PrimaryAccountId	DTYPE_ID	Not applicable	No
Primary Employee Id	PrimaryEmployeeId	DTYPE_ID	Not applicable	No
Primary Org Id	PrimaryOrgId	DTYPE_ID	Not applicable	No
Primary Organization Name	PrimaryOrganizationName	DTYPE_TEXT	100	No
Primary Position Id	PrimaryPositionId	DTYPE_ID	Not applicable	No
Product Id	ProductId	DTYPE_ID	Not applicable	Yes
Start Date	StartDate	DTYPE_DATE	Not applicable	No
Type	Type	DTYPE_TEXT	30	No
Updated	Updated	DTYPE_DATETIME	30	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No
Contact
Account Id	AccountId	DTYPE_ID	Not applicable	No
Account Integration Id	AccountIntegrationId	DTYPE_TEXT	30	No
Assistant	Assistant	DTYPE_TEXT	50	No
Assistant Email Address	AssistantEmailAddress	DTYPE_TEXT	100	No
Assistant Phone #	AssistantPhone	DTYPE_PHONE	Not applicable	No
Cellular Phone #	CellularPhone	DTYPE_PHONE	Not applicable	No
Created	Created	DTYPE_DATETIME	30	No
Employee Number	EmployeeNumber	DTYPE_TEXT	30	No
Fax Phone #	FaxPhone	DTYPE_PHONE	Not applicable	No
First Name	FirstName	DTYPE_TEXT	50	Yes
Home Phone #	HomePhone	DTYPE_PHONE	Not applicable	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Job Title	JobTitle	DTYPE_TEXT	75	No
Last Name	LastName	DTYPE_TEXT	50	Yes
Login Name	LoginName	DTYPE_TEXT	50	No
M/F	MF	DTYPE_TEXT	30	No
M/M	MM	DTYPE_TEXT	15	No
Market Cap Pref	MarketCapPref	DTYPE_TEXT	30	No
Middle Name	MiddleName	DTYPE_TEXT	50	No
Mod Id	ModId	DTYPE_ID	30	No
Party Type Code	PartyTypeCode	DTYPE_TEXT	30	Yes
Party UId	PartyUId	DTYPE_TEXT	100	Yes
Person UId	PersonUId	DTYPE_TEXT	100	Yes
Personal Contact	PersonalContact	DTYPE_BOOL	Not applicable	No
Preferred Communication Method	PreferredCommunicationMethod	DTYPE_TEXT	20	No
Primary Organization	PrimaryOrganization	DTYPE_TEXT	50	No
Privacy Code	PrivacyCode	DTYPE_TEXT	30	Yes
SSN	SSN	DTYPE_TEXT	11	No
Short Name	ShortName	DTYPE_TEXT	50	No
Status	Status	DTYPE_TEXT	30	No
Type	Type	DTYPE_TEXT	30	No
Updated	Updated	DTYPE_DATETIME	30	No
Updated By Name	UpdatedByName	DTYPE_TEXT	50	No
User Type	UserType	DTYPE_TEXT	30	No
Work Phone #	WorkPhone	DTYPE_PHONE	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No
FINCORPAccountContact
Account	Account	DTYPE_TEXT	100	No
Account Id	AccountId	DTYPE_ID	Not applicable	No
Asset Id	AssetId	DTYPE_ID	Not applicable	No
Cellular Phone Number	CellularPhoneNumber	DTYPE_PHONE	Not applicable	No
Conflict Id	ConflictId	DTYPE_ID	30	No
Contact Id	ContactId	DTYPE_ID	Not applicable	No
Created	Created	DTYPE_DATETIME	30	No
Currency	Currency2	DTYPE_TEXT	Not applicable	No
Email Address	EmailAddress3	DTYPE_TEXT	100	No
Fax Number	FaxNumber	DTYPE_PHONE	Not applicable	No
First Name	FirstName	DTYPE_TEXT	50	No
Home Phone Number	HomePhoneNumber	DTYPE_PHONE	Not applicable	No
Id	Id	DTYPE_ID	30	No
Job Title	JobTitle	DTYPE_TEXT	75	No
Last Name	LastName	DTYPE_TEXT	50	Yes
Middle Initial	MiddleInitial	DTYPE_TEXT	50	No
Mod Id	ModId	DTYPE_ID	30	No
Mother's Maiden Name	MothersMaidenName	DTYPE_TEXT	50	No
Mr./Ms.	Mr.Ms.	DTYPE_ID	Not applicable	No
Primary Personal Address Id	PrimaryPersonalAddressId	DTYPE_ID	Not applicable	No
Short Name	ShortName	DTYPE_TEXT	50	No
Social Security Number	SocialSecurityNumber2	DTYPE_TEXT	11	No
Title	Title	DTYPE_TEXT	75	No
Updated	Updated	DTYPE_DATETIME	30	No
Work Phone #	WorkPhone	DTYPE_PHONE	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No

Siebel Application Services Interface Reference		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.