Siebel Application Services Interface Reference > Predefined Application Service Interfaces >
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 21 describes the Siebel Financial Account ASI structure.
Figure 21. Siebel Financial Account ASI
|
Table 32 lists the integration components and user keys of the Siebel Financial Account ASI.
Table 32. Siebel Financial Account Integration Components
|
|
|
FINCORP Account |
FincorpAccount |
- Integration Id
- Row Id
- Account Number, Primary Organization Name
Status Key: Account Number, Id, Integration Id, operation
|
Contact |
Contact |
- Party UId
- Row Id
- Account Integration Id, Employee Number, Personal Contact
- Person Uid, Personal Contact, Primary Organization
Status Key: Id, Integration Id, operation
|
FINCORP Account Contact |
FincorpAccountContact |
- Contact Id
|
Table 33 lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table 33. Siebel Financial Account ASI Fields
|
|
|
|
|
|
FINCORPAccount |
ABA Number |
ABANumber |
DTYPE_TEXT |
50 |
N |
|
Account Alias |
AccountAlias |
DTYPE_TEXT |
100 |
N |
|
Account Branch ABA |
AccountBranchABA |
DTYPE_TEXT |
50 |
N |
|
Account Branch Id |
AccountBranchId |
DTYPE_ID |
|
N |
|
Account Branch Name |
AccountBranchName |
DTYPE_TEXT |
100 |
N |
|
Account Branch Number |
AccountBranchNumber |
DTYPE_TEXT |
30 |
N |
|
Account Holder |
AccountHolder |
DTYPE_TEXT |
|
N |
|
Account Name |
AccountName |
DTYPE_TEXT |
100 |
N |
|
Account Number |
AccountNumber |
DTYPE_TEXT |
100 |
Y |
|
Account Row Id |
AccountRowId |
DTYPE_ID |
|
N |
|
Account Status |
AccountStatus |
DTYPE_TEXT |
30 |
N |
|
Account Type |
AccountType |
DTYPE_TEXT |
30 |
N |
|
Acct Gen - Account Id |
AcctGen-AccountId |
DTYPE_ID |
|
N |
|
Acct Gen - Average Balance |
AcctGen-AverageBalance |
DTYPE_CURRENCY |
|
N |
|
Acct Gen - Branch Id |
AcctGen-BranchId |
DTYPE_ID |
|
N |
|
Acct Gen - Organization Address Id |
AcctGen-OrganizationAddressId |
DTYPE_ID |
|
N |
|
Acct Gen - Pers Addr - City |
AcctGen-PersAddr-City |
DTYPE_TEXT |
50 |
N |
|
Acct Gen - Pers Addr - Country |
AcctGen-PersAddr-Country |
DTYPE_TEXT |
30 |
N |
|
Acct Gen - Pers Addr - Id |
AcctGen-PersAddr-Id |
DTYPE_ID |
|
N |
|
Acct Gen - Pers Addr - State |
AcctGen-PersAddr-State |
DTYPE_TEXT |
10 |
N |
|
Acct Gen - Pers Addr - Street |
AcctGen-PersAddr-Street |
DTYPE_TEXT |
200 |
N |
|
Acct Gen - Pers Addr - Zip Code |
AcctGen-PersAddr-ZipCode |
DTYPE_TEXT |
30 |
N |
|
Acct Gen - Primary Contact Id |
AcctGen-PrimaryContactId |
DTYPE_ID |
|
N |
|
Acct Gen - Product Line Id |
AcctGen-ProductLineId |
DTYPE_ID |
|
N |
|
Available Balance |
AvailableBalance |
DTYPE_CURRENCY |
|
N |
|
Balance |
Balance |
DTYPE_CURRENCY |
|
N |
|
Bank Number |
BankNumber |
DTYPE_TEXT |
50 |
N |
|
Billing Option |
BillingOption |
DTYPE_TEXT |
30 |
N |
|
Branch |
Branch |
DTYPE_TEXT |
50 |
N |
|
Branch Number |
BranchNumber |
DTYPE_TEXT |
50 |
N |
|
CA Next Statement Date |
CANextStatementDate |
DTYPE_DATE |
|
N |
|
Comments |
Comments |
DTYPE_TEXT |
250 |
N |
|
Commitment Amount |
CommitmentAmount |
DTYPE_CURRENCY |
|
N |
|
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
N |
|
Contact Address Id |
ContactAddressId |
DTYPE_ID |
|
N |
|
Created |
Created |
DTYPE_DATETIME |
30 |
N |
|
Currency |
Currency |
DTYPE_TEXT |
20 |
N |
|
Current Balance |
CurrentBalance |
DTYPE_CURRENCY |
|
N |
|
Customer Number |
CustomerNumber |
DTYPE_TEXT |
50 |
N |
|
Customer Type |
CustomerType |
DTYPE_TEXT |
30 |
N |
|
First Name |
FirstName |
DTYPE_TEXT |
50 |
N |
|
Id |
Id |
DTYPE_ID |
30 |
N |
|
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
N |
|
Last Name |
LastName |
DTYPE_TEXT |
50 |
N |
|
Mod Id |
ModId |
DTYPE_ID |
30 |
N |
|
Name |
Name |
DTYPE_TEXT |
100 |
N |
|
Organization Id |
OrganizationId |
DTYPE_ID |
|
N |
|
Parent ABA Number |
ParentABANumber |
DTYPE_TEXT |
50 |
N |
|
Parent Account Branch ABA |
ParentAccountBranchABA |
DTYPE_TEXT |
50 |
N |
|
Parent Account Branch Id |
ParentAccountBranchId |
DTYPE_ID |
|
N |
|
Parent Account Id |
ParentAccountId |
DTYPE_ID |
|
N |
|
Parent Account Number |
ParentAccountNumber |
DTYPE_TEXT |
100 |
N |
|
Parent Asset ID |
ParentAssetID |
DTYPE_ID |
|
N |
|
Parent Asset Number |
ParentAssetNumber |
DTYPE_TEXT |
100 |
N |
|
Parent Bank |
ParentBank |
DTYPE_TEXT |
50 |
N |
|
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
N |
|
Previous Balance |
PreviousBalance |
DTYPE_CURRENCY |
|
N |
|
Primary Account Id |
PrimaryAccountId |
DTYPE_ID |
|
N |
|
Primary Employee Id |
PrimaryEmployeeId |
DTYPE_ID |
|
N |
|
Primary Org Id |
PrimaryOrgId |
DTYPE_ID |
|
N |
|
Primary Organization Name |
PrimaryOrganizationName |
DTYPE_TEXT |
100 |
N |
|
Primary Position Id |
PrimaryPositionId |
DTYPE_ID |
|
N |
|
Product Id |
ProductId |
DTYPE_ID |
|
Y |
|
Start Date |
StartDate |
DTYPE_DATE |
|
N |
|
Type |
Type |
DTYPE_TEXT |
30 |
N |
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
N |
|
Contact |
Account Id |
AccountId |
DTYPE_ID |
|
N |
|
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
N |
|
Assistant |
Assistant |
DTYPE_TEXT |
50 |
N |
|
Assistant Email Address |
AssistantEmailAddress |
DTYPE_TEXT |
100 |
N |
|
Assistant Phone # |
AssistantPhone |
DTYPE_PHONE |
|
N |
|
Cellular Phone # |
CellularPhone |
DTYPE_PHONE |
|
N |
|
Created |
Created |
DTYPE_DATETIME |
30 |
N |
|
Employee Number |
EmployeeNumber |
DTYPE_TEXT |
30 |
N |
|
Fax Phone # |
FaxPhone |
DTYPE_PHONE |
|
N |
|
First Name |
FirstName |
DTYPE_TEXT |
50 |
Y |
|
Home Phone # |
HomePhone |
DTYPE_PHONE |
|
N |
|
Id |
Id |
DTYPE_ID |
30 |
N |
|
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
N |
|
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
N |
|
Last Name |
LastName |
DTYPE_TEXT |
50 |
Y |
|
Login Name |
LoginName |
DTYPE_TEXT |
50 |
N |
|
M/F |
MF |
DTYPE_TEXT |
30 |
N |
|
M/M |
MM |
DTYPE_TEXT |
15 |
N |
|
Market Cap Pref |
MarketCapPref |
DTYPE_TEXT |
30 |
N |
|
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
N |
|
Mod Id |
ModId |
DTYPE_ID |
30 |
N |
|
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
Y |
|
Party UId |
PartyUId |
DTYPE_TEXT |
100 |
Y |
|
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
Y |
|
Personal Contact |
PersonalContact |
DTYPE_BOOL |
|
N |
|
Preferred Communication Method |
PreferredCommunicationMethod |
DTYPE_TEXT |
20 |
N |
|
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
50 |
N |
|
Privacy Code |
PrivacyCode |
DTYPE_TEXT |
30 |
Y |
|
SSN |
SSN |
DTYPE_TEXT |
11 |
N |
|
Short Name |
ShortName |
DTYPE_TEXT |
50 |
N |
|
Status |
Status |
DTYPE_TEXT |
30 |
N |
|
Type |
Type |
DTYPE_TEXT |
30 |
N |
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
N |
|
Updated By Name |
UpdatedByName |
DTYPE_TEXT |
50 |
N |
|
User Type |
UserType |
DTYPE_TEXT |
30 |
N |
|
Work Phone # |
WorkPhone |
DTYPE_PHONE |
|
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
N |
|
FINCORPAccountContact |
Account |
Account |
DTYPE_TEXT |
100 |
N |
|
Account Id |
AccountId |
DTYPE_ID |
|
N |
|
Asset Id |
AssetId |
DTYPE_ID |
|
N |
|
Cellular Phone Number |
CellularPhoneNumber |
DTYPE_PHONE |
|
N |
|
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
N |
|
Contact Id |
ContactId |
DTYPE_ID |
|
N |
|
Created |
Created |
DTYPE_DATETIME |
30 |
N |
|
Currency |
Currency2 |
DTYPE_TEXT |
|
N |
|
Email Address |
EmailAddress3 |
DTYPE_TEXT |
100 |
N |
|
Fax Number |
FaxNumber |
DTYPE_PHONE |
|
N |
|
First Name |
FirstName |
DTYPE_TEXT |
50 |
N |
|
Home Phone Number |
HomePhoneNumber |
DTYPE_PHONE |
|
N |
|
Id |
Id |
DTYPE_ID |
30 |
N |
|
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
N |
|
Last Name |
LastName |
DTYPE_TEXT |
50 |
Y |
|
Middle Initial |
MiddleInitial |
DTYPE_TEXT |
50 |
N |
|
Mod Id |
ModId |
DTYPE_ID |
30 |
N |
|
Mother's Maiden Name |
MothersMaidenName |
DTYPE_TEXT |
50 |
N |
|
Mr./Ms. |
Mr.Ms. |
DTYPE_ID |
|
N |
|
Primary Personal Address Id |
PrimaryPersonalAddressId |
DTYPE_ID |
|
N |
|
Short Name |
ShortName |
DTYPE_TEXT |
50 |
N |
|
Social Security Number |
SocialSecurityNumber2 |
DTYPE_TEXT |
11 |
N |
|
Title |
Title |
DTYPE_TEXT |
75 |
N |
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
N |
|
Work Phone # |
WorkPhone |
DTYPE_PHONE |
|
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
N |
|
|