Siebel Application Services Interface Reference > Siebel Communications, Media, and Energy ASIs >
Siebel Account
The Siebel Account ASI is used for business processes related to customer information management. This ASI facilitates inbound and outbound data synchronization between Siebel applications and external systems. Figure 35 describes the Siebel Account ASI structure.
Figure 35. Siebel Account ASI
|
Table 75 lists the integration components and XML tags of this ASI.
Table 75. Siebel Account ASI Integration Components
|
|
|
Account |
Account |
- Account Id
- Integration Id
- Location, Name, Primary Organization
|
Business Address |
BusinessAddress |
- Address Integration Id
|
Com Financial Profile |
FinancialProfile |
- Name
|
Com Invoice Profile |
BillingProfile |
- Name
|
Credit Profile |
CreditProfile |
- Credit Profile Integration Id
- Credit Area
|
Related Contact |
RelatedContact |
1 Person UId, Primary Organization
- Contact Id
- Contact Integration Id
|
Related Industry |
RelatedIndustry |
- Industry Integration Id
- Industry
- SIC Code
|
Related Organization |
RelatedOrganization |
- Organization Integration Id
- Organization
|
Related Sales Rep |
RelatedSalesRep |
- Position Integration Id
- Division, Position
- Login
|
Table 76 lists the Siebel Account fields and their attributes.
Table 76. Siebel Account ASI Fields
|
|
|
|
|
|
Account |
|
Account Id |
AccountId |
DTYPE_ID |
30 |
N |
|
Account Status |
AccountStatus |
DTYPE_TEXT |
24 |
N |
|
Alias |
Alias |
DTYPE_TEXT |
50 |
N |
|
Assignment Area Code |
AssignmentAreaCode |
DTYPE_TEXT |
5 |
N |
|
Assignment Country Code |
AssignmentCountryCode |
DTYPE_TEXT |
5 |
N |
|
Competitor Flag |
CompetitorFlag |
DTYPE_TEXT |
|
N |
|
Credit Auto Approval Limit |
CreditAutoApprovalLimit |
DTYPE_NUMBER |
|
N |
|
Credit Status Date |
CreditStatusDate |
DTYPE_TEXT |
|
N |
|
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
N |
|
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
N |
|
Description |
Description |
DTYPE_TEXT |
255 |
N |
|
Domestic Ultimate DUNS |
DomesticUltimateDUNS |
DTYPE_TEXT |
15 |
N |
|
Expertise |
Expertise |
DTYPE_TEXT |
30 |
N |
|
Global Ultimate DUNS |
GlobalUltimateDUNS |
DTYPE_TEXT |
15 |
N |
|
Home Page |
HomePage |
DTYPE_TEXT |
100 |
N |
|
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
N |
|
Language Code |
LanguageCode |
DTYPE_ID |
15 |
N |
|
Location |
Location |
DTYPE_TEXT |
50 |
N |
|
Main Fax Number |
MainFaxNumber |
DTYPE_TEXT |
|
N |
|
Main Phone Number |
MainPhoneNumber |
DTYPE_TEXT |
|
N |
|
Master Account Id |
MasterAccountId |
DTYPE_ID |
|
N |
|
Name |
Name |
DTYPE_TEXT |
100 |
N |
|
Number of Employees |
NumberofEmployees |
DTYPE_NUMBER |
|
N |
|
PO Approved Flag |
POApprovedFlag |
DTYPE_TEXT |
|
N |
|
PO Auto Approval Currency Code |
POAutoApprovalCurrencyCode |
DTYPE_TEXT |
20 |
N |
|
PO Auto Approval Date |
POAutoApprovalDate |
DTYPE_DATETIME |
|
N |
|
PO Auto Approval Limit |
POAutoApprovalLimit |
DTYPE_TEXT |
|
N |
|
Parent Account Id |
ParentAccountId |
DTYPE_ID |
|
N |
|
Parent Account Integration Id |
ParentAccountIntegrationId |
DTYPE_TEXT |
30 |
N |
|
Parent Account Location |
ParentAccountLocation |
DTYPE_TEXT |
50 |
N |
|
Parent Account Name |
ParentAccountName |
DTYPE_TEXT |
100 |
N |
|
Parent HQ DUNS |
ParentHQDUNS |
DTYPE_TEXT |
15 |
N |
|
Partner Flag |
PartnerFlag |
DTYPE_TEXT |
|
N |
|
Price List |
PriceList |
DTYPE_TEXT |
|
N |
|
Price List Id |
PriceListId |
DTYPE_ID |
|
N |
|
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
N |
|
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
N |
|
Skip Credit Check |
SkipCreditCheck |
DTYPE_TEXT |
|
N |
|
Type |
Type |
DTYPE_TEXT |
255 |
N |
|
VAT registration number |
VATregistrationnumber |
DTYPE_TEXT |
30 |
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
Business Address |
|
Address Id |
AddressId |
DTYPE_ID |
30 |
N |
|
Address Integration Id |
AddressIntegrationId |
DTYPE_TEXT |
30 |
N |
|
City |
City |
DTYPE_TEXT |
50 |
N |
|
Country |
Country |
DTYPE_TEXT |
50 |
N |
|
County |
County |
DTYPE_TEXT |
50 |
N |
|
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
N |
|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
N |
|
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
N |
|
Province |
Province |
DTYPE_TEXT |
50 |
N |
|
State |
State |
DTYPE_TEXT |
10 |
N |
|
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
N |
|
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
Com Financial Profile |
|
Account Id |
AccountId |
DTYPE_ID |
|
N |
|
Account Type |
AccountType |
DTYPE_TEXT |
30 |
N |
|
Annual Income |
AnnualIncome |
DTYPE_TEXT |
|
N |
|
Bank Account Name |
BankAccountName |
DTYPE_TEXT |
100 |
N |
|
Bank Account Number |
BankAccountNumber |
DTYPE_TEXT |
50 |
N |
|
Bank Branch |
BankBranch |
DTYPE_TEXT |
100 |
N |
|
Bank Name |
BankName |
DTYPE_TEXT |
100 |
N |
|
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
N |
|
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
N |
|
Contact Id |
ContactId |
DTYPE_ID |
|
N |
|
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
N |
|
Corporate Number |
CorporateNumber |
DTYPE_TEXT |
30 |
N |
|
Created |
Created |
DTYPE_DATETIME |
30 |
N |
|
Credit Agency |
CreditAgency |
DTYPE_TEXT |
30 |
N |
|
Credit Card Expire Date |
CreditCardExpireDate |
DTYPE_DATETIME |
|
N |
|
Credit Card Number |
CreditCardNumber |
DTYPE_TEXT |
30 |
N |
|
Credit Card Type |
CreditCardType |
DTYPE_TEXT |
30 |
N |
|
Credit Score |
CreditScore2 |
DTYPE_NUMBER |
|
N |
|
Credit Update Date |
CreditUpdateDate |
DTYPE_DATETIME |
|
N |
|
Credit Updated By |
CreditUpdatedBy |
DTYPE_ID |
|
N |
|
Currency Code |
CurrencyCode2 |
DTYPE_TEXT |
20 |
N |
|
Current Address Id |
CurrentAddressId |
DTYPE_ID |
|
N |
|
Current City |
CurrentCity |
DTYPE_TEXT |
50 |
N |
|
Current Country |
CurrentCountry |
DTYPE_TEXT |
30 |
N |
|
Current Hire Date |
CurrentHireDate |
DTYPE_DATETIME |
|
N |
|
Current Postal Code |
CurrentPostalCode |
DTYPE_TEXT |
30 |
N |
|
Current State |
CurrentState |
DTYPE_TEXT |
10 |
N |
|
Current Street Address |
CurrentStreetAddress |
DTYPE_TEXT |
200 |
N |
|
D B Identifier |
DBIdentifier |
DTYPE_TEXT |
30 |
N |
|
Employer Id |
EmployerId |
DTYPE_ID |
|
N |
|
Employer Name |
EmployerName |
DTYPE_TEXT |
100 |
N |
|
Exchange Date |
ExchangeDate |
DTYPE_DATETIME |
|
N |
|
Former Address Id |
FormerAddressId |
DTYPE_ID |
|
N |
|
Former City |
FormerCity |
DTYPE_TEXT |
50 |
N |
|
Former Country |
FormerCountry |
DTYPE_TEXT |
30 |
N |
|
Former Postal Code |
FormerPostalCode |
DTYPE_TEXT |
30 |
N |
|
Former State |
FormerState |
DTYPE_TEXT |
10 |
N |
|
Former Street Address |
FormerStreetAddress |
DTYPE_TEXT |
200 |
N |
|
Id |
Id |
DTYPE_ID |
30 |
N |
|
Id Type |
IdType |
DTYPE_TEXT |
30 |
N |
|
Identifier |
Identifier |
DTYPE_TEXT |
30 |
N |
|
Legal Name |
LegalName |
DTYPE_TEXT |
100 |
N |
|
Mod Id |
ModId |
DTYPE_ID |
30 |
N |
|
Name |
Name |
DTYPE_TEXT |
100 |
N |
|
Own or Rent |
OwnorRent |
DTYPE_TEXT |
30 |
N |
|
Previous Employer Id |
PreviousEmployerId |
DTYPE_ID |
|
N |
|
Status |
Status |
DTYPE_TEXT |
30 |
N |
|
Tax Id |
TaxId2 |
DTYPE_TEXT |
30 |
N |
|
Tax Profile Cd |
TaxProfileCd |
DTYPE_TEXT |
30 |
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 |
|
Com Invoice Profile |
|
Account Id |
AccountId |
DTYPE_ID |
|
N |
|
Address Id |
AddressId2 |
DTYPE_ID |
|
N |
|
Bank Account Name |
BankAccountName2 |
DTYPE_TEXT |
|
N |
|
Bank Account Number |
BankAccountNumber2 |
DTYPE_TEXT |
|
N |
|
Bank Account Type |
BankAccountType |
DTYPE_TEXT |
30 |
N |
|
Bank Authorization Flag |
BankAuthorizationflag |
DTYPE_TEXT |
|
N |
|
Bank Branch |
BankBranch2 |
DTYPE_TEXT |
|
N |
|
Bank Language Code |
BankLanguageCode |
DTYPE_TEXT |
5 |
N |
|
Bank Language Id |
BankLanguageId |
DTYPE_TEXT |
5 |
N |
|
Bank Name |
BankName2 |
DTYPE_TEXT |
|
N |
|
Bill Average |
BillAverage |
DTYPE_TEXT |
|
N |
|
Bill Cycle |
BillCycle |
DTYPE_NUMBER |
|
N |
|
Bill Cycle Day |
BillCycleDay |
DTYPE_NUMBER |
|
N |
|
Bill Frequency |
BillFrequency |
DTYPE_TEXT |
|
N |
|
Bill Sequence |
BillSequence |
DTYPE_NUMBER |
|
N |
|
Bill Source |
BillSource |
DTYPE_TEXT |
30 |
N |
|
Bill Type |
BillType |
DTYPE_TEXT |
|
N |
|
Bill Vendor Id |
BillVendorId |
DTYPE_ID |
|
N |
|
Budget Billing Flag |
BudgetBillingFlag |
DTYPE_TEXT |
|
N |
|
CPNI Date |
CPNIDate |
DTYPE_DATETIME |
|
N |
|
CPNI Flag |
CPNIFlag |
DTYPE_TEXT |
|
N |
|
Collections Flag |
CollectionsFlag |
DTYPE_TEXT |
|
N |
|
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
N |
|
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
N |
|
Contact Id |
ContactId |
DTYPE_ID |
|
N |
|
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
N |
|
Created |
Created |
DTYPE_DATETIME |
30 |
N |
|
Credit Card Block Flag |
CreditCardBlockFlag |
DTYPE_TEXT |
|
N |
|
Credit Card Block Reason |
CreditCardBlockReason |
DTYPE_TEXT |
30 |
N |
|
Credit Card Category |
CreditCardCategory |
DTYPE_TEXT |
30 |
N |
|
Credit Card Expiration Date |
CreditCardExpirationDate |
DTYPE_DATETIME |
|
N |
|
Credit Card Name |
CreditCardName |
DTYPE_TEXT |
|
N |
|
Credit Card Number |
CreditCardNumber2 |
DTYPE_TEXT |
|
N |
|
Credit Card Type |
CreditCardType2 |
DTYPE_TEXT |
|
N |
|
Currency Type |
CurrencyType |
DTYPE_TEXT |
20 |
N |
|
Days To Cash |
DaysToCash |
DTYPE_NUMBER |
|
N |
|
Email Bill To |
EmailBillTo |
DTYPE_TEXT |
100 |
N |
|
External Billing Account Number |
ExternalBillingAccountNumber |
DTYPE_TEXT |
30 |
N |
|
Extra Copies |
ExtraCopies |
DTYPE_NUMBER |
|
N |
|
Id |
Id |
DTYPE_ID |
30 |
N |
|
Interest at Invoice Flag |
InterestatInvoiceFlag |
DTYPE_TEXT |
|
N |
|
Last Bill Amount |
LastBillAmount |
DTYPE_TEXT |
|
N |
|
Last Bill Date |
LastBillDate |
DTYPE_DATETIME |
|
N |
|
Media Type |
MediaType |
DTYPE_TEXT |
30 |
N |
|
Mod Id |
ModId |
DTYPE_ID |
30 |
N |
|
Name |
Name |
DTYPE_TEXT |
100 |
N |
|
No Pay Form Flag |
NoPayFormFlag |
DTYPE_TEXT |
|
N |
|
Number of Manual Invoices |
NumberofManualInvoices |
DTYPE_NUMBER |
|
N |
|
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
N |
|
Reason for Manual Outsource |
ReasonforManualOutsource |
DTYPE_TEXT |
30 |
N |
|
Repeat Debtor Flag |
RepeatDebtorFlag |
DTYPE_TEXT |
|
N |
|
Row Id |
RowId |
DTYPE_ID |
|
N |
|
Standing Order Flag |
StandingOrderFlag |
DTYPE_TEXT |
|
N |
|
Statement Flag |
StatementFlag |
DTYPE_TEXT |
|
N |
|
Status |
Status |
DTYPE_TEXT |
30 |
N |
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
N |
|
Yearly Advance Payment Flag |
YearlyAdvancePaymentFlag |
DTYPE_TEXT |
|
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
N |
|
Credit Profile |
|
Credit Area |
CreditArea |
DTYPE_TEXT |
30 |
N |
|
Credit Available |
CreditAvailable |
DTYPE_NUMBER |
|
N |
|
Credit Currency Code |
CreditCurrencyCode |
DTYPE_TEXT |
20 |
N |
|
Credit Limit |
CreditLimit |
DTYPE_NUMBER |
|
N |
|
Credit Profile Id |
CreditProfileId |
DTYPE_ID |
30 |
N |
|
Credit Profile Integration Id |
CreditProfileIntegrationId |
DTYPE_TEXT |
30 |
N |
|
Credit Reporting Group |
CreditReportingGroup |
DTYPE_TEXT |
50 |
N |
|
Credit Status Code |
CreditStatusCode |
DTYPE_TEXT |
30 |
N |
|
Credit Status Message |
CreditStatusMessage |
DTYPE_TEXT |
250 |
N |
|
Credit Used |
CreditUsed |
DTYPE_NUMBER |
|
N |
|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
N |
|
Risk Category Code |
RiskCategoryCode |
DTYPE_TEXT |
30 |
N |
|
operation |
operation |
DTYPE_TEXT |
30 |
N |
|
Related Industry |
|
Industry |
Industry |
DTYPE_TEXT |
50 |
N |
|
Industry Id |
IndustryId |
DTYPE_ID |
30 |
N |
|
Industry Integration Id |
IndustryIntegrationId |
DTYPE_TEXT |
30 |
N |
|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
N |
|
SIC Code |
SICCode |
DTYPE_TEXT |
30 |
N |
|
Related Sales Rep |
|
Division |
Division |
DTYPE_TEXT |
255 |
N |
|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
N |
|
Login |
Login |
DTYPE_TEXT |
50 |
N |
|
Position |
Position |
DTYPE_TEXT |
50 |
N |
|
Position Id |
PositionId |
DTYPE_ID |
30 |
N |
|
Position Integration Id |
PositionIntegrationId |
DTYPE_TEXT |
30 |
N |
|
Related Contact |
|
Assistant Phone # |
AssistantPhone |
DTYPE_TEXT |
|
N |
|
Cellular Phone # |
CellularPhone |
DTYPE_TEXT |
|
N |
|
Contact Id |
ContactId |
DTYPE_ID |
30 |
N |
|
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
N |
|
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
N |
|
Fax Phone # |
FaxPhone |
DTYPE_TEXT |
|
N |
|
First Name |
FirstName |
DTYPE_TEXT |
50 |
N |
|
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
N |
|
Last Name |
LastName |
DTYPE_TEXT |
50 |
N |
|
M/F |
MF |
DTYPE_TEXT |
255 |
N |
|
M/M |
MM |
DTYPE_TEXT |
15 |
N |
|
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
N |
|
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
N |
|
Work Phone # |
WorkPhone |
DTYPE_TEXT |
|
N |
|
Related Organization |
|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
N |
|
Organization |
Organization |
DTYPE_TEXT |
50 |
N |
|
Organization Id |
OrganizationId |
DTYPE_ID |
|
N |
|
Organization Integration Id |
OrganizationIntegrationId |
DTYPE_TEXT |
30 |
N |
|
|