Bookshelf v8.1/8.2: 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.

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

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