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
Integration Component
XML Tag
User Keys

Account

Account

  1. Account Id
  2. Integration Id
  3. Location, Name, Primary Organization

Business Address

BusinessAddress

1 Address Id
  1. Address Integration Id

Com Financial Profile

FinancialProfile

1 Id
  1. Name

Com Invoice Profile

BillingProfile

1 Id, Name
  1. Name

Credit Profile

CreditProfile

1 Credit Profile Id
  1. Credit Profile Integration Id
  2. Credit Area

Related Contact

RelatedContact

1 Person UId, Primary Organization
  1. Contact Id
  2. Contact Integration Id

Related Industry

RelatedIndustry

1 Industry Id
  1. Industry Integration Id
  2. Industry
  3. SIC Code

Related Organization

RelatedOrganization

1 Organization Id
  1. Organization Integration Id
  2. Organization

Related Sales Rep

RelatedSalesRep

1 Position Id
  1. Position Integration Id
  2. Division, Position
  3. Login

Table 76 lists the Siebel Account fields and their attributes.

Table 76. Siebel Account ASI Fields
Name
XML Tag
Data Type
Length
Req.
Notes

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

 

Siebel Application Services Interface Reference Copyright © 2006, Oracle. All rights reserved.