6Predefined Application Service Interfaces

Predefined Application Service Interfaces

This chapter provides a list of the prebuilt ASIs that are provided with Siebel applications. You can use these ASIs to receive, send, or request data from other applications.

An ASI consists of a business service, which implements various methods and integration objects, and holds whatever data is present in run time. An integration object can consist of multiple integration components, each with multiple fields. All these fields are active by default and are used by the ASI. You can deactivate unnecessary fields. For more information, see Deactivating ASI Components and Fields.

Each ASI is based on an integration object and can be used to integrate data for all fields of that integration object.

This chapter includes the following topics:

Note: Required is abbreviated as Req. and Not Applicable is abbreviated as NA or N/A in the following tables.

About Prebuilt ASIs

The following table lists the prebuilt ASIs provided by Oracle.

ASI Description

Siebel Account

ASI to facilitate the inbound and outbound transfer of account data from the Siebel application. For details, see Siebel Account.

Siebel Action

ASI to facilitate the inbound and outbound transfer of activity data from the Siebel application. For details, see Siebel Action.

Siebel Business Address

ASI to facilitate the inbound and outbound transfer of business address data from the Siebel application. For details, see Siebel Business Address.

Siebel Personal Address

ASI to facilitate the inbound and outbound transfer of personal address data from the Siebel application. For details, see Siebel Personal Address

Siebel Asset

ASI that associates a customer with a unique product. For details, see Siebel Assets.

Siebel Contact

ASI to facilitate the inbound and outbound transfer of contact data from the Siebel application. For details, see Siebel Contact.

Siebel Cost List

ASI to enable the synchronization and update of a cost list and the cost list items. For details, see Siebel Cost List.

Siebel Employee

ASI to facilitate the inbound and outbound transfer of employee data from the Siebel application. For details, see Siebel Employee.

Siebel Financial Account

ASI to facilitate the inbound and outbound financial account data synchronization between the Siebel application and the UCM system. For details, see Siebel Financial Account.

Siebel Forecast

ASI to facilitate the outbound data synchronization between the Siebel application and an external back-office system. For details, see Siebel Forecast.

Siebel Invoice

ASI to facilitate the inbound and outbound transfer of invoice data from the Siebel application. For details, see Siebel Invoice.

External Opportunity Create/Query/Update

ASI to facilitate the inbound and outbound transfer of opportunity data from the Siebel application. For details, see External Opportunity Create/Query/Update.

Siebel Order

ASI to facilitate the inbound and outbound transfer of order data from the Siebel application. For details, see Siebel Order.

Siebel Position

ASI to facilitate the inbound and outbound transfer of position data from the Siebel application. For details, see Siebel Position.

Siebel Price List

ASI to enable the synchronization and update of a price list and the price list items. For details, see Siebel Price List.

Siebel ATP Response/External ATP Check

ASI to facilitate request of availability-to-promise data. For details, see Siebel ATP Response/External ATP Check.

External Credit Check

ASI to facilitate the request for a credit check from an external system. For details, see External Credit Check.

Siebel SIA Service Request

ASI to create an SIA service request within the Siebel application. For details, see Siebel SIA Service Request.

Siebel Service Request

ASI to synchronize service requests in the Siebel application with an external target application. For details, see Siebel Service Request.

Siebel Simple Product

ASI to facilitate the inbound and outbound transfer of simple product data from the Siebel application. For details, see Siebel Simple Product.

Siebel Account

Use this ASI for customer information management-related business processes. This ASI facilitates inbound and outbound account data synchronization between a Siebel application and any external system. The following image describes the Siebel Account ASI structure.

Siebel Account ASI. In this image, Account has the following components: Business Address, Credit Profile, Related Contact, Related Industry, Related Organization, and Related Sales Rep.

The following table lists the user keys of the Siebel Account ASI.

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

  2. Address Integration Id

  3. City, State, Street Address

Credit Profile

CreditProfile

  1. Credit Profile Id

  2. Credit Profile Integration Id

  3. Credit Area

Related Bill To Account

RelatedBillToAccount

  1. Id

  2. Integration Id

  3. Bill To Account, Location

  4. CSN

Related Contact

RelatedContact

  1. Person UId, Primary Organization

  2. Contact Id

  3. Contact Integration Id

  4. First Name, Last Name, Middle Name

Related Credit Profile

RelatedCreditProfile

  • Credit Control Area Code

Related Industry

RelatedIndustry

  1. Industry Id

  2. Industry Integration Id

  3. Industry

  4. SIC Code

Related Organization

RelatedOrganization

  1. Organization Id

  2. Organization Integration Id

  3. Organization

Related Payer Account

RelatedPayerAccount

  1. Id

  2. Integration Id

  3. Payer Account, Location

  4. CSN

Related Sales Organization

RelatedSalesOrganization

  • Organization Id

Related Sales Rep

RelatedSalesRep

  1. Position Id

  2. Position Integration Id

  3. Division, Position

  4. Login

Related Ship To Account

RelatedShipToAccount

  1. Id

  2. Integration Id

  3. Ship To Account, Location

  4. CSN

Related Sold To Account

RelatedSoldToAccount

  1. Id

  2. Integration Id

  3. Sold To Account, Location

  4. CSN

Account Fields in Siebel Account ASI

The following table lists the Account fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Account Id

AccountId

DTYPE_ID

30

No

None

Account Organization Integration Id

AccountOrganizationIntegrationId

DTYPE_TEXT

30

No

None

Account Status

AccountStatus

DTYPE_TEXT

24

No

None

Alias

Alias

DTYPE_TEXT

50

No

None

Assignment Area Code

AssignmentAreaCode

DTYPE_TEXT

5

No

None

Assignment Country Code

AssignmentCountryCode

DTYPE_TEXT

5

No

None

Back Office Order Query End Dt

BackOfficeOrderQueryEndDt

DTYPE_DATETIME

NA

No

None

Back Office Order Query Start Dt

BackOfficeOrderQueryStartDt

DTYPE_DATETIME

NA

No

None

Back Office Sales Area Division Code

BackOfficeSalesAreaDivisionCode

DTYPE_TEXT

30

No

None

CSN

CSN

DTYPE_TEXT

30

No

None

Competitor Flag

CompetitorFlag

DTYPE_BOOL

NA

No

None

Created

Created

DTYPE_DATETIME

30

No

None

Credit Auto Approval Limit

CreditAutoApprovalLimit

DTYPE_CURRENCY

NA

No

None

Credit Status Date

CreditStatusDate

DTYPE_UTCDAYETIME

7

No

None

Currency Code

CurrencyCode

DTYPE_TEXT

15

No

Used to pick a related entity.

Customer Account Group

CustomerAccountGroup

DTYPE_TEXT

30

No

None

Description

Description

DTYPE_TEXT

255

No

None

Disable Data Cleansing

DisableDataCleansing

DTYPE_TEXT

NA

No

None

Division

Division

DTYPE_TEXT

30

No

None

DUNS Number

DUNSNumber

DTYPE_TEXT

15

No

None

Domestic Ultimate DUNS

DomesticUltimateDUNS

DTYPE_TEXT

15

No

None

EAI Sync Date

EAISyncDate

DTYPE_TEXT

NA

No

None

EAI Sync Error Text

EAISyncErrorText

DTYPE_TEXT

2000

No

None

EAI Sync Status Code

EAISyncStatusCode

DTYPE_TEXT

30

No

None

Expertise

Expertise

DTYPE_TEXT

30

No

Bound by ACCOUNT_EXPERTISE LOV.

Freight Terms

FreightTerms

DTYPE_TEXT

30

No

None

Freight Terms Info

FreightTermsInfo

DTYPE_TEXT

100

No

None

Global Ultimate DUNS

GlobalUltimateDUNS

DTYPE_TEXT

15

No

None

Home Page

HomePage

DTYPE_TEXT

100

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

User key field.

Internal Org Flag

InternalOrgFlag

DTYPE_TEXT

NA

No

None

Language Code

LanguageCode

DTYPE_ID

NA

No

None

Location

Location

DTYPE_TEXT

50

No

None

Main Fax Number

MainFaxNumber

DTYPE_PHONE

NA

No

None

Main Phone Number

MainPhoneNumber

DTYPE_PHONE

NA

No

None

Name

Name

DTYPE_TEXT

100

No

User key field.

Number of Employees

NumberofEmployees

DTYPE_NUMBER

NA

No

None

operation

operation

DTYPE_TEXT

30

No

None

PO Approved Flag

POApprovedFlag

DTYPE_TEXT

NA

No

None

PO Auto Approval Currency Code

POAutoApprovalCurrencyCode

DTYPE_TEXT

20

No

Used to pick a related entity.

PO Auto Approval Date

POAutoApprovalDate

DTYPE_DATETIME

NA

No

None

PO Auto Approval Limit

POAutoApprovalLimit

DTYPE_TEXT

NA

No

None

Parent Account Division

ParentAccountDivision

DTYPE_TEXT

NA

No

None

Parent Account Id

ParentAccountId

DTYPE_ID

NA

No

None

Parent Account Integration Id

ParentAccountIntegrationId

DTYPE_TEXT

30

No

None

Parent Account Location

ParentAccountLocation

DTYPE_TEXT

50

No

None

Parent Account Location Level

ParentAccountLocationLevel

DTYPE_TEXT

30

No

None

Parent Account Name

ParentAccountName

DTYPE_TEXT

100

No

None

Parent Account Region

ParentAccountRegion

DTYPE_TEXT

30

No

None

Parent HQ DUNS

ParentHQDUNS

DTYPE_TEXT

15

No

None

Partner Flag

PartnerFlag

DTYPE_TEXT

1

No

None

Partners

Partners

DTYPE_TEXT

100

No

None

Party Name

PartyName

DTYPE_TEXT

30

No

None

Party Type Code

PartyTypeCode

DTYPE_TEXT

30

No

None

Party UId

PartyUId

DTYPE_TEXT

30

No

None

Price List

PriceList

DTYPE_TEXT

NA

No

None

Price List End Date

PriceListEndDate

DTYPE_TEXT

NA

No

None

Price List Id

PriceListId

DTYPE_ID

NA

No

None

Price List Integration Id

PriceListIntegrationId

DTYPE_TEXT

30

No

None

Price List Start Date

PriceListStartDate

DTYPE_TEXT

NA

No

None

Primary Account City

PrimaryAccountCity

DTYPE_TEXT

50

No

None

Primary Account Country

PrimaryAccountCountry

DTYPE_TEXT

30

No

None

Primary Account Postal Code

PrimaryAccountPostalCode

DTYPE_TEXT

30

No

None

Primary Account State

PrimaryAccountState

DTYPE_TEXT

10

No

None

Primary Account Street Address

PrimaryAccountStreetAddress

DTYPE_TEXT

200

No

None

Primary Address Id

PrimaryAddressId

DTYPE_ID

NA

No

None

Primary Assignment Denorm Flag

PrimaryAssignmentDenormFlag

DTYPE_TEXT

NA

No

None

Primary Assignment Manual Flag

PrimaryAssignmentManualFlag

DTYPE_TEXT

NA

No

None

Primary Assignment System Flag

PrimaryAssignmentSystemFlag

DTYPE_TEXT

NA

No

None

Primary Assignment Type

PrimaryAssignmentType

DTYPE_TEXT

30

No

None

Primary Bill To Address Id

PrimaryBillToAddressId

DTYPE_ID

NA

No

None

Primary Bill To City

PrimaryBillToCity

DTYPE_TEXT

50

No

None

Primary Bill To Country

PrimaryBillToCountry

DTYPE_TEXT

30

No

None

Primary Bill To First Name

PrimaryBillToFirstName

DTYPE_TEXT

50

No

None

Primary Bill To Job Title

PrimaryBillToJobTitle

DTYPE_TEXT

75

No

None

Primary Bill To Last Name

PrimaryBillToLastName

DTYPE_TEXT

50

No

None

Primary Bill To Person Id

PrimaryBillToPersonId

DTYPE_ID

NA

No

None

Primary Bill To Postal Code

PrimaryBillToPostalCode

DTYPE_TEXT

30

No

None

Primary Bill To State

PrimaryBillToState

DTYPE_TEXT

10

No

None

Primary Bill To Street Address

PrimaryBillToStreetAddress

DTYPE_TEXT

200

No

None

Primary Fulfill InvLoc Integration Id

PrimaryFulfillInvLoc IntegrationId

DTYPE_TEXT

30

No

None

Primary Fulfillment InvLoc Id

PrimaryFulfillmentInvLocId

DTYPE_TEXT

NA

No

None

Primary Fulfillment Inventory Location

PrimaryFulfillment InventoryLocation

DTYPE_TEXT

NA

No

None

Primary Industry Id

PrimaryIndustryId

DTYPE_ID

NA

No

None

Primary Organization

PrimaryOrganization

DTYPE_TEXT

100

No

User key field.

Primary Organization Id

PrimaryOrganizationId

DTYPE_ID

NA

No

None

Primary Payer Account

PrimaryPayerAccount

DTYPE_TEXT

100

No

None

Primary Payer Account Id

PrimaryPayerAccountId

DTYPE_ID

NA

No

None

Primary Position Id

PrimaryPositionId

DTYPE_ID

NA

No

None

Primary Service Agreement Id

PrimaryServiceAgreementId

DTYPE_ID

NA

No

None

Primary Ship To Address Id

PrimaryShipToAddressId

DTYPE_ID

NA

No

None

Primary Ship To City

PrimaryShipToCity

DTYPE_TEXT

50

No

None

Primary Ship To Country

PrimaryShipToCountry

DTYPE_TEXT

30

No

None

Primary Ship To First Name

PrimaryShipToFirstName

DTYPE_TEXT

50

No

None

Primary Ship To Job Title

PrimaryShipToJobTitle

DTYPE_TEXT

75

No

None

Primary Ship To Last Name

PrimaryShipToLastName

DTYPE_TEXT

50

No

None

Primary Ship To Person Id

PrimaryShipToPersonId

DTYPE_ID

NA

No

None

Primary Ship To Postal Code

PrimaryShipToPostalCode

DTYPE_TEXT

30

No

None

Primary Ship To State

PrimaryShipToState

DTYPE_TEXT

10

No

None

Primary Ship To Street Address

PrimaryShipToStreetAddress

DTYPE_TEXT

200

No

None

Primary Territory Id

PrimaryTerritoryId

DTYPE_ID

NA

No

None

Primary Type Id

PrimaryTypeId

DTYPE_ID

NA

No

None

Region

Region

DTYPE_TEXT

30

No

None

Relationship Type

RelationshipType

DTYPE_TEXT

30

No

None

Revenue Growth

RevenueGrowth

DTYPE_NUMBER

NA

No

None

Skip Credit Check

SkipCreditCheck

DTYPE_TEXT

NA

No

None

Start Date

StartDate

DTYPE_DATETIME

NA

No

None

Strategies

Strategies

DTYPE_TEXT

500

No

None

Strategy

Strategy

DTYPE_TEXT

2000

No

None

Success Factors

SuccessFactors

DTYPE_TEXT

500

No

None

Territory Item Type

TerritoryItemType

DTYPE_TEXT

30

No

None

Type

Type

DTYPE_TEXT

255

No

None

Updated

Updated

DTYPE_DATETIME

30

No

None

VAT registration number

VATregistrationnumber

DTYPE_TEXT

30

No

None

Business Address Fields in Siebel Account ASI

The following table lists the Business Address fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Address Active Status

AddressActiveStatus

DTYPE_TEXT

NA

No

None

Address Id

AddressId

DTYPE_ID

30

No

None

Address Integration Id

AddressIntegrationId

DTYPE_TEXT

30

No

None

Address Name

AddressName

DTYPE_TEXT

100

No

None

Bill Address Flag

BillAddressFlag

DTYPE_TEXT

NA

No

None

City

City

DTYPE_TEXT

50

No

None

Country

Country

DTYPE_TEXT

50

No

None

County

County

DTYPE_TEXT

50

No

None

Disable Data Cleansing

DisableDataCleansing

DTYPE_TEXT

NA

No

None

Email Address

EmailAddress

DTYPE_TEXT

50

No

None

Fax Number

FaxNumber

DTYPE_TEXT

NA

No

None

Main Address Flag

MainAddressFlag

DTYPE_TEXT

NA

No

None

operation

operation

DTYPE_TEXT

30

No

None

Phone Number

PhoneNumber

DTYPE_TEXT

NA

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Postal Code

PostalCode

DTYPE_TEXT

30

No

None

Province

Province

DTYPE_TEXT

50

No

None

Ship Address Flag

ShipAddressFlag

NA

NA

No

None

State

State

DTYPE_TEXT

10

No

None

Street Address

StreetAddress

DTYPE_TEXT

200

No

None

Street Address 2

Street Address2

DTYPE_TEXT

100

No

None

Credit Profile Fields in Siebel Account ASI

The following table lists the Credit Profile fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Credit Area

CreditArea

DTYPE_TEXT

30

No

None

Credit Available

CreditAvailable

DTYPE_NUMBER

NA

No

None

Credit Currency Code

CreditCurrencyCode

DTYPE_TEXT

20

No

None

Credit Limit

CreditLimit

DTYPE_NUMBER

NA

No

None

Credit Profile Id

CreditProfileId

DTYPE_ID

30

No

None

Credit Profile Integration Id

CreditProfileIntegrationId

DTYPE_TEXT

30

No

None

Credit Reporting Group

CreditReportingGroup

DTYPE_TEXT

50

No

None

Credit Status Code

CreditStatusCode

DTYPE_TEXT

30

No

None

Credit Status Message

CreditStatusMessage

DTYPE_TEXT

NA

No

None

Credit Used

CreditUsed

DTYPE_NUMBER

NA

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Risk Category Code

RiskCategoryCode

DTYPE_TEXT

30

No

None

operation

operation

DTYPE_TEXT

30

No

None

Related Contact Fields in Siebel Account ASI

The following table lists the Related Contact fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Alternate Phone #

AlternatePhone

DTYPE_TEXT

NA

No

None

Assistant Phone #

AssistantPhone

DTYPE_TEXT

NA

No

None

Cellular Phone #

CellularPhone

DTYPE_TEXT

NA

No

None

Conflict Id

ConflictId

DTYPE_ID

30

No

None

Contact Id

ContactId

DTYPE_ID

30

No

None

Contact Integration Id

ContactIntegrationId

DTYPE_TEXT

30

No

None

Email Address

EmailAddress

DTYPE_TEXT

50

No

None

Employee Number

EmployeeNumber

DTYPE_TEXT

30

No

None

Fax Phone #

FaxPhone

DTYPE_TEXT

NA

No

None

First Name

FirstName

DTYPE_TEXT

50

No

None

Home Phone #

HomePhone

DTYPE_TEXT

NA

No

None

Job Title

JobTitle

DTYPE_TEXT

75

No

None

Last Name

LastName

DTYPE_TEXT

50

No

None

M/F

MF

DTYPE_TEXT

255

No

None

M/M

MM

DTYPE_TEXT

15

No

None

Middle Name

MiddleName

DTYPE_TEXT

50

No

None

Organization

Organization

DTYPE_TEXT

50

No

None

Person UId

PersonUId

DTYPE_TEXT

100

No

None

Primary Organization

PrimaryOrganization

DTYPE_TEXT

100

No

None

Work Phone #

WorkPhone

DTYPE_TEXT

NA

No

None

Work Phone Extension

WorkPhoneExtension

DTYPE_TEXT

10

No

None

Related Industry Fields in Siebel Account ASI

The following table lists the Related Industry fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Industry

Industry

DTYPE_TEXT

50

No

None

Industry Id

IndustryId

DTYPE_ID

30

No

None

Industry Integration Id

IndustryIntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

SIC Code

SICCode

DTYPE_TEXT

30

No

None

Related Organization Fields in Siebel Account ASI

The following table lists the Related Organization fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Organization

Organization

DTYPE_TEXT

50

No

None

Organization Id

OrganizationId

DTYPE_ID

15

No

None

Organization Integration Id

OrganizationIntegrationId

DTYPE_TEXT

30

No

None

Related Sales Rep Fields in Siebel Account ASI

The following table lists the Related Sales Rep fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Division

Division

DTYPE_TEXT

255

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Login

Login

DTYPE_TEXT

50

No

None

Position

Position

DTYPE_TEXT

50

No

None

Position Id

PositionId

DTYPE_ID

30

No

None

Position Integration Id

PositionIntegrationId

DTYPE_TEXT

30

No

None

Related Sales Organization Fields in Siebel Account ASI

The following table lists the Related Sales Organization fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Account Status

AccountStatus

DTYPE_TEXT

30

No

None

Back Office Distribution Channel

BackOfficeDistributionChannel

DTYPE_TEXT

30

No

None

Back Office Sales Area Division Code

BackOfficeSalesAreaDivisionCode

DTYPE_TEXT

30

No

None

Back Office Sales Organization

BackOfficeSalesOrganization

DTYPE_TEXT

30

No

None

Conflict Id

ConflictId

DTYPE_ID

30

No

None

Created

Created

DTYPE_DATETIME

30

No

None

Currency Code

CurrencyCode

DTYPE_TEXT

20

No

None

Freight Terms

FreightTerms

DTYPE_TEXT

30

No

None

Freight Terms Info

FreightTermsInfo

DTYPE_TEXT

100

No

None

Id

Id

DTYPE_TEXT

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

Language Code

LanguageCode

DTYPE_ID

NA

No

None

Mod Id

ModId

DTYPE_ID

30

No

None

Organization

Organization

DTYPE_TEXT

100

No

None

Organization Id

OrganizationId

DTYPE_ID

NA

No

None

Parent Account Id

ParentAccountId

DTYPE_ID

NA

No

None

Party Id

PartyId

DTYPE_ID

NA

No

None

Payment Terms

PaymentTerms

DTYPE_ID

NA

No

None

Payment Terms Integration Id

PaymentTermsIntegrationId

DTYPE_TEXT

NA

No

None

Payment Terms Name

PaymentTermsName

DTYPE_TEXT

NA

No

None

Price List Type

PriceListType

DTYPE_ID

NA

No

None

Primary Bill To Account Id

PrimaryBillToAccountId

DTYPE_ID

NA

No

None

Primary Fulfillment InvLoc

PrimaryFulfillmentInvLoc

DTYPE_TEXT

NA

No

None

Primary Fulfillment InvLoc ID

PrimaryFulfillmentInvLocID

DTYPE_ID

NA

No

None

Primary Fulfillment InvLoc Integration Id

PrimaryFulfillmentInvLocIntegrationId

DTYPE_TEXT

NA

No

None

Primary Payer Account Id

PrimaryPayerAccountId

DTYPE_ID

NA

No

None

Primary Ship To Account Id

PrimaryShipToAccountId

DTYPE_ID

NA

No

None

Shipping Conditions

ShippingConditions

DTYPE_TEXT

30

No

None

Type

Type

DTYPE_TEXT

30

No

None

Updated

Updated

DTYPE_DATETIME

30

No

None

Related Bill to Account Fields in Siebel Account ASI

The following table lists the Related Bill to Account fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Bill To Account

BillToAccount

DTYPE_TEXT

100

No

None

CSN

CSN

DTYPE_TEXT

30

No

None

Id

Id

DTYPE_TEXT

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Location

Location

DTYPE_TEXT

50

No

None

Related Payer Account Fields in Siebel Account ASI

The following table lists the Related Payer Account fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

CSN

CSN

DTYPE_TEXT

30

No

None

Id

Id

DTYPE_TEXT

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Location

Location

DTYPE_TEXT

50

No

None

Payer Account

PayerAccount

DTYPE_TEXT

100

No

None

Related Ship to Account Fields in Siebel Account ASI

The following table lists the Related Ship to Account fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

CSN

CSN

DTYPE_TEXT

30

No

None

Id

Id

DTYPE_TEXT

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Location

Location

DTYPE_TEXT

50

No

None

Ship To Account

ShipToAccount

DTYPE_TEXT

100

No

None

Related Sold to Account Fields in Siebel Account ASI

The following table lists the Related Sold to Account fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

CSN

CSN

DTYPE_TEXT

30

No

None

Id

Id

DTYPE_TEXT

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Location

Location

DTYPE_TEXT

50

No

None

Sold To Account

SoldToAccount

DTYPE_TEXT

100

No

None

Related Credit Profile Fields in Siebel Account ASI

The following table lists the Related Credit Profile fields and their attributes in Siebel Account ASI.

Name XML Tag Data Type Length Req. Notes

Block Credit Flag

BlockCreditFlag

DTYPE_TEXT

NA

No

None

Credit Control Area Code

CreditControlAreaCode

DTYPE_TEXT

30

No

None

Siebel Action

The Siebel Action ASI is based on the Siebel Action Business Component. It is an ASI for business processes related to Activity management (for example, a Calendar event such as an appointment). This ASI facilitates inbound and outbound activity data synchronization between Siebel 6.3 applications and Siebel 7.5 applications.

The following image describes the Siebel Action ASI structure.

Siebel Action ASI. In the image, Action Prospects has the following components: Action_Contact, Activity Prospects, Contact (ALL), Employee(MM), Expense, FS Activity Parts Movement, FS Activity Skill (FS Activity Skill Item), FS Activity Step, FS Instruction, Internal Product, Messaging, TimeSheet Daily Hours.

The following table lists the integration components and user keys of the Siebel Action ASI.

Integration Component XML Tag User Keys

Action

Action

  1. Id

  2. Activity UID

Action_Contact

Action_Contact

  • Contact Id

Activity Prospects

ActivityProspects

  • Prospective Contact UID

Contact(All)

ContactAll

  • Party UId

Employee (MM)

EmployeeMm

  • Party UId

Expense Item

ExpenseItem

  • Expense Item Number, Owner Id

FS Activity Parts Movement

FsactivityPartsMovement

  • PartMvtNum

FS Activity Skill

FsActivitySkill

  1. Name

  2. Item Type Name

FS Activity Skill Item

FsActivitySkillItem

  1. Expertise Code, Low Char 1

  2. Low Char 2, Low Number 1

FS Activity Step

FsActivityStep

  • SeqNum, Step Type Id

FS Instruction

FsInstruction

  • Instruction, Instruction Type

Internal Product

InternalProduct

  • Id

Messaging

Messaging

  • Message Number

Time Sheet Daily Hours

TimeSheetDailyHours

  1. Id

  2. Item Date, Owner Id, Time Sheet Item Num

Action Fields in Siebel Action ASI

The following table lists the Action fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Account Id

AccountId

DTYPE_ID

N/A

No

Activity SR Id

ActivitySRId

DTYPE_ID

N/A

No

Activity UID

ActivityUID

DTYPE_TEXT

30

No

Alarm

Alarm

DTYPE_TEXT

N/A

No

Appt Alarm Time Min

ApptAlarmTimeMin

DTYPE_NUMBER

N/A

No

Asset Id

AssetId

DTYPE_ID

N/A

No

Assignment Excluded

AssignmentExcluded

DTYPE_TEXT

N/A

No

Associated Cost

AssociatedCost

DTYPE_TEXT

N/A

No

Audience

Audience

DTYPE_TEXT

30

No

Billable Flag

BillableFlag

DTYPE_TEXT

N/A

No

Call Id

CallId

DTYPE_TEXT

30

No

Class

Class

DTYPE_TEXT

30

No

Comment

Comment

DTYPE_TEXT

1,500

No

Currency Code

CurrencyCode

DTYPE_TEXT

N/A

No

Description

Description

DTYPE_TEXT

100

No

Display

Display

DTYPE_TEXT

30

No

Done

Done

DTYPE_DATETIME

N/A

No

Due

Due

DTYPE_TEXT

N/A

No

Est Work Time Remaining

EstWorkTimeRemaining

DTYPE_NUMBER

N/A

No

Exchange Date

ExchangeDate

DTYPE_DATETIME

N/A

No

Id

Id

DTYPE_ID

30

No

Meeting Location

MeetingLocation

DTYPE_TEXT

100

No

No Sooner Than Date

NoSoonerThanDate

DTYPE_DATETIME

N/A

No

Opportunity Id

OpportunityId

DTYPE_ID

N/A

No

Percent Complete

PercentComplete

DTYPE_NUMBER

N/A

No

Planned

Planned

DTYPE_DATETIME

N/A

No

Planned Completion

PlannedCompletion

DTYPE_DATETIME

N/A

No

Previous Activity Id

PreviousActivityId

DTYPE_ID

N/A

No

Price List Id

PriceListId

DTYPE_ID

N/A

No

Primary Owner Id

PrimaryOwnerId

DTYPE_ID

N/A

No

Priority

Priority

DTYPE_TEXT

30

No

Private

Private

DTYPE_TEXT

N/A

No

Rate List Id

RateListId

DTYPE_ID

N/A

No

Repeating Expires

RepeatingExpires

DTYPE_DATETIME

N/A

No

Repeating Type

RepeatingType

DTYPE_TEXT

30

No

Resolution Code

ResolutionCode

DTYPE_TEXT

30

No

Started

Started

DTYPE_DATETIME

N/A

No

Status

Status

DTYPE_TEXT

30

No

Status Report Flag

StatusReportFlag

DTYPE_TEXT

N/A

No

Type

Type

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

searchspec

searchspec

DTYPE_TEXT

250

No

Action_Contact Fields in Siebel Action ASI

The following table lists the Action_Contact fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Contact Id

Contact Id

DTYPE_ID

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Activity_Prospects Fields in Siebel Action ASI

The following table lists the Activity_Prospects field and attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Prospective Contact UID

ProspectiveContactUID

DTYPE_TEXT

100

No

Contact (All) Fields in Siebel Action ASI

The following table lists the Contact field and attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Party UId

PartyUId

DTYPE_TEXT

30

No

Employee (MM) Fields in Siebel Action ASI

The following table lists the Employee (MM) field and attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Party UId

PartyUId

DTYPE_TEXT

30

No

Expense Item Fields in Siebel Action ASI

The following table lists the Expense Item fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Account Id

AccountId

DTYPE_ID

N/A

No

Amount

Amount

DTYPE_TEXT

N/A

No

Billable Flag

BillableFlag

DTYPE_TEXT

N/A

No

Comments

Comments

DTYPE_TEXT

250

No

Currency Code

CurrencyCode

DTYPE_TEXT

20

No

Description

Desc

DTYPE_TEXT

250

No

End Date

EndDate

DTYPE_DATETIME

N/A

No

Establishment

Establishment

DTYPE_TEXT

50

No

Exchange Date

ExchangeDate

DTYPE_DATETIME

N/A

No

Exchange Rate

ExchangeRate

DTYPE_NUMBER

N/A

No

Expense Item Number

ExpenseItemNumber

DTYPE_ID

N/A

No

Expense Item Type

ExpenseItemTypeName

DTYPE_TEXT

50

No

Internal Comments

InternalComments

DTYPE_TEXT

250

No

Item Room Amount

ItemRoomAmount

DTYPE_TEXT

N/A

No

Item Room Other Tax Amount

ItemRoomOtherTaxAmount

DTYPE_TEXT

N/A

No

Item Room Tax Amount

ItemRoomTaxAmount

DTYPE_TEXT

N/A

No

Mileage Distance

MileageDistance

DTYPE_NUMBER

N/A

No

Mileage Rate

MileageRate

DTYPE_TEXT

N/A

No

Mileage Route

MileageRoute

DTYPE_TEXT

100

No

Opty Id

OptyId

DTYPE_ID

N/A

No

Owner Id

OwnerId

DTYPE_ID

N/A

No

Payment Type

PaymentType

DTYPE_TEXT

30

No

Project Billing Class

ProjectBillingClass

DTYPE_TEXT

30

No

Reimbursable Flag

ReimbursablFlag

DTYPE_TEXT

N/A

No

Start Date

StartDate

DTYPE_DATETIME

N/A

No

FS Activity Parts Movement Fields in Siebel Action ASI

The following table lists the FS Activity Parts Movement fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Asset Id

AssetId

DTYPE_ID

N/A

No

Billable Flag

BillableFlag

DTYPE_TEXT

N/A

No

Commit Txn Flag

CommitTxnFlag

DTYPE_TEXT

N/A

No

Destination

Destination

DTYPE_TEXT

30

No

Movement Date

MovementDate

DTYPE_DATETIME

N/A

No

Order Id

OrderId

DTYPE_ID

N/A

No

Order Item Id

OrderItemId

DTYPE_ID

N/A

No

PartMvtNum

PartMvtNum

DTYPE_ID

N/A

No

Product Id

ProductId

DTYPE_ID

N/A

No

Product Name

ProductName

DTYPE_TEXT

100

No

Source

Source

DTYPE_TEXT

30

No

Status

Status

DTYPE_TEXT

30

No

Trunk Invloc Id

TrunkInvlocId

DTYPE_ID

N/A

No

Used Quantity

UsedQuantity

DTYPE_NUMBER

N/A

No

FS Activity Skill Fields in Siebel Action ASI

The following table lists the FS Activity Skill fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Comments

Comments

DTYPE_TEXT

250

No

Item Type Name

ItemTypeName

DTYPE_TEXT

75

No

Name

Name

DTYPE_TEXT

50

No

FS Activity Skill Item Fields in Siebel Action ASI

The following table lists the FS Activity Skill Item fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Expertise Code

ExpertiseCode

DTYPE_TEXT

30

No

Low Char 1

LowChar1

DTYPE_TEXT

50

No

Low Char 2

LowChar2

DTYPE_TEXT

50

No

Low Number 1

LowNumber1

DTYPE_NUMBER

N/A

No

Product Id

ProdId

DTYPE_TEXT

N/A

No

FS Activity Step Fields in Siebel Action ASI

The following table lists the FS Activity Step fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Comments

Comments

DTYPE_TEXT

250

No

End Date

EndDate

DTYPE_DATETIME

N/A

No

Performed

Performed

DTYPE_TEXT

N/A

No

Performed by

Performedby

DTYPE_ID

N/A

No

SeqNum

SeqNum

DTYPE_NUMBER

N/A

No

Start Date

StartDate

DTYPE_DATETIME

N/A

No

Step Type Id

StepTypeId

DTYPE_ID

N/A

No

FS Instruction Fields in Siebel Action ASI

The following table lists the FS Instruction fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Instruction

Instruction

DTYPE_NOTE

N/A

No

Instruction Type

InstructionType

DTYPE_TEXT

30

No

Messaging Fields in Siebel Action ASI

The following table lists the Messaging fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Account Id

AccountId

DTYPE_ID

N/A

No

Alert Type CD

AlertTypeCD

DTYPE_TEXT

30

No

Comments

Comments

DTYPE_TEXT

2000

No

Contact Last Name

ContactLastName

DTYPE_TEXT

50

No

Creation Time

CreationTime

DTYPE_TEXT

N/A

No

Message Number

MessageNumber

DTYPE_TEXT

30

No

Message Status CD

MessageStatusCD

DTYPE_TEXT

30

No

Message Text

Message Text

DTYPE_TEXT

2000

No

Opportunity Id

OpportunityId

DTYPE_ID

N/A

No

Priority

Priority

DTYPE_TEXT

30

No

Private Flag

PrivateFlag

DTYPE_TEXT

N/A

No

Recipient Id

Recipient Id

DTYPE_ID

N/A

No

Sender Id

SenderId

DTYPE_ID

N/A

No

Service Request Id

ServiceRequestId

DTYPE_ID

N/A

No

Time Sheet Daily Hours Fields in Siebel Action ASI

The following table lists the Time Sheet Daily Hours fields and their attributes in Siebel Action ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Billable Flag

BillableFlag

DTYPE_TEXT

N/A

No

Billing Class

BillingClass

DTYPE_TEXT

N/A

No

Billing Rate Type

BillingRateType

DTYPE_TEXT

N/A

No

Created

Created

DTYPE_DATETIME

N/A

No

End Time

EndTime

DTYPE_DATETIME

N/A

No

External Comments

ExternalComments

DTYPE_TEXT

N/A

No

Id

Id

DTYPE_ID

N/A

No

Internal Comments

InternalComments

DTYPE_TEXT

N/A

No

Item Date

ItemDate

DTYPE_DATETIME

N/A

No

Oppty Id

OpptyId

DTYPE_ID

N/A

No

Owner Id

OwnerId

DTYPE_ID

N/A

No

Project Id

ProjectId

DTYPE_ID

N/A

No

Service Request Id

ServiceRequestId

DTYPE_ID

N/A

No

Start Time

StartTime

DTYPE_DATETIME

N/A

No

Time Sheet Item Num

TimeSheetItemNum

DTYPE_TEXT

N/A

No

Siebel Business Address

Siebel Business Address is part of the Customer Order Lifecycle business process. The Customer Address is a business address associated with a specific customer. This ASI facilitates inbound and outbound address data synchronization between Siebel applications and external systems.

The following image describes the Siebel Business Address ASI structure.

Siebel Business Address ASI. In this image, Address and Address Information are connected.

The following table lists the integration components and user keys of this ASI.

Integration Component XML Tag User Keys

Address

Address

  1. Id

  2. Integration Id

Address Fields in Siebel Business Address ASI

The following table lists the Address fields and their attributes in Siebel Business Address ASI.

Name XML Tag Data Type Length Required

Address Line 1

AddressLine1

DTYPE_TEXT

200

No

Address Line 2

AddressLine2

DTYPE_TEXT

200

No

City

City

DTYPE_TEXT

50

No

Country

Country

DTYPE_TEXT

50

No

Id

Id

DTYPE_TEXT

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

Postal Code

PostalCode

DTYPE_TEXT

50

No

State

State

DTYPE_TEXT

10

No

Siebel Personal Address

Siebel Personal Address is part of the Customer Order Lifecycle business process. The Customer Address is a personal address associated with a specific customer. This ASI facilitates inbound and outbound address data synchronization between Siebel applications and external systems.

The following image describes the Siebel Personal Address ASI structure.

Siebel Personal Address ASI. In this image, Address and Address Information are connected.

The following table lists the integration components and user keys of the Siebel Personal Address ASI.

Integration Component XML Tag User Keys

Address

Address

  1. Id

  2. Integration Id

Address Fields in Siebel Personal Address ASI

The following table lists the Address fields and their attributes in Siebel Personal Address ASI.

Name XML Tag Data Type Length Required

Address Line 1

AddressLine1

DTYPE_TEXT

200

No

Address Line 2

AddressLine2

DTYPE_TEXT

200

No

City

City

DTYPE_TEXT

50

No

Country

Country

DTYPE_TEXT

50

No

Id

Id

DTYPE_TEXT

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

Postal Code

PostalCode

DTYPE_TEXT

50

No

State

State

DTYPE_TEXT

10

No

Siebel Assets

Siebel Asset is part of the Customer Order Lifecycle business process. The Customer Asset is a serialized product or service that a customer has purchased from a company. When a customer creates an order, the seller removes the product from the finished goods inventory, and upon shipment, the item becomes a customer asset with a unique serial number. The asset is only associated with that specific customer.

The following image describes the Siebel Asset ASI structure.

Siebel Asset ASI. In this image, Header has a one-to-many relationship with Asset. Asset has a one-to-many relationship with Asset XA and a one-to-many relationship with itself.

The following table lists the integration components and user keys of this ASI.

Integration Component XML Tag User Keys

Asset Mgmt - Asset

Asset

  1. Id

  2. Integration Id

  3. Asset Number, Product Id

Asset Mgmt - Asset - Header

AssetHeader

  1. Id

  2. Integration Id

  3. Asset Number, Product Id

Asset Mgmt - Asset XA

AssetXA

  1. Integration Id

  2. Name

Asset Mgmt - Asset Fields in Siebel Asset ASI

The following table lists the Asset Mgmt - Asset fields and their attributes in Siebel Asset ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Asset Currency Code

AssetCurrencyCode

DTYPE_TEXT

20

No

Asset Description

AssetDescription

DTYPE_TEXT

250

No

Asset Number

AssetNumber

DTYPE_TEXT

100

No

Comments

Comments

DTYPE_TEXT

255

No

Customizable Flag

CustomizableFlag

DTYPE_TEXT

1

No

Extended Quantity

ExtendedQuantity

DTYPE_NUMBER

N/A

No

Id

Id

DTYPE_ID

15

No

Install Date

InstallDate

DTYPE_DATETIME

N/A

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Inventory Location Id

InventoryLocationId

DTYPE_ID

15

No

Name

Name

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Operating Status

OperatingStatus

DTYPE_TEXT

30

No

Order Integration Id

OrderIntegrationId

DTYPE_TEXT

30

No

Organization Id

OrganizationId

DTYPE_ID

15

No

Original Cost

OriginalCost

DTYPE_NUMBER

N/A

No

Original Order Id

OriginalOrderId

DTYPE_ID

15

No

Owner

Owner

DTYPE_ID

15

No

Owner Account Id

OwnerAccountId

DTYPE_ID

15

No

Parent Asset Id

ParentAssetId

DTYPE_ID

15

No

Price List Id

PriceListId

DTYPE_ID

15

No

Primary Contact Id

PrimaryContactId

DTYPE_ID

15

No

Prod Item Id

ProdItemId

DTYPE_ID

15

No

Product Description

ProductDescription

DTYPE_TEXT

255

No

Product Id

ProductId

DTYPE_ID

15

No

Product Name

ProductName

DTYPE_TEXT

100

No

Product Serialized Flag

ProductSerializedFlag

DTYPE_TEXT

1

No

Purchase Date

PurchaseDate

DTYPE_DATETIME

N/A

No

Quantity

Quantity

DTYPE_NUMBER

N/A

No

Root Asset Id

RootAssetId

DTYPE_ID

15

No

Root Product Id

RootProductId

DTYPE_ID

15

No

Serial Number

SerialNumber

DTYPE_TEXT

100

No

Status

Status

DTYPE_TEXT

30

No

Version

Version

DTYPE_TEXT

30

No

Asset Mgmt - Asset - Header Fields in Siebel Asset ASI

The following table lists the Asset Mgmt - Asset - Header fields and their attributes in Siebel Asset ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Asset Currency Code

AssetCurrencyCode

DTYPE_TEXT

20

No

Asset Description

AssetDescription

DTYPE_TEXT

250

No

Asset Number

AssetNumber

DTYPE_TEXT

100

No

Comments

Comments

DTYPE_TEXT

255

No

Id

Id

DTYPE_ID

15

No

Install Date

InstallDate

DTYPE_DATETIME

N/A

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Inventory Location Id

InventoryLocationId

DTYPE_ID

15

No

Name

ProductName

DTYPE_TEXT

100

No

Organization Id

OrganizationId

DTYPE_ID

15

No

Original Cost

OriginalCost

DTYPE_NUMBER

NA

No

Original Order Id

OriginalOrderId

DTYPE_ID

15

No

Owner Account Id

OwnerAccountId

DTYPE_ID

15

No

Parent Asset Id

ParentAssetId

DTYPE_ID

15

No

Primary Contact Id

PrimaryContactId

DTYPE_ID

15

No

Product Id

ProductId

DTYPE_ID

15

No

Purchase Date

PurchaseDate

DTYPE_DATETIME

N/A

No

Quantity

Quantity

DTYPE_NUMBER

N/A

No

Root Asset Id

RootAssetId

DTYPE_ID

15

No

Serial Number

SerialNumber

DTYPE_TEXT

100

No

Serialized Flag

ProductSerializedFlag

DTYPE_TEXT

1

No

Status

Status

DTYPE_TEXT

30

No

Version

Version

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

Asset Mgmt - Asset XA Fields in Siebel Asset ASI

The following table lists the Asset Mgmt - Asset XA fields and their attributes in Siebel Asset ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Data Type

DataType

DTYPE_TEXT

30

No

Description

AttributeDescription

DTYPE_TEXT

250

No

Display Name

DisplayName

DTYPE_TEXT

100

No

Id

Id

DTYPE_ID

15

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Name

AttributeName

DTYPE_TEXT

75

No

Required

Required

DTYPE_TEXT

1

No

Unit of Measure

UnitofMeasure

DTYPE_TEXT

30

No

Value

AttributeValue

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Siebel Contact

The Siebel Contact ASI is an ASI for customer information management-related business processes. This ASI facilitates inbound and outbound contact data synchronization between a Siebel application and any external system. The following image describes the Siebel Contact ASI structure.

Siebel Contact ASI. In this image, Contact has the following integration components: Related Account, Related Sales Rep, Related Household, Communication Address, Alternate Phone, Related Organization, Personal Address.

The following table lists the integration component and user keys of this ASI.

Integration Component XML Tag User Keys

Contact

Contact

  1. Contact ID

  2. Integration ID

  3. Person UId

Related Account

RelatedAccount

  1. Id

  2. Integration Id

Personal Address

PersonalAddress

  1. Id

  2. Integration Id

Communication Address

CommunicationAddress

  1. Id

  2. Integration Id

  3. Alternate Email Address, Communication Address Medium Type, Communication Address Name

Alternate Phone

AlternatePhone

  1. Id

  2. Integration Id

  3. Alternate Phone #, Alternate Phone Medium Type, Alternate Phone Name

Related Households

RelatedHouseholds

  1. Id

  2. Integration Id

Related Organization

RelatedOrganization

  1. Id

  2. Integration Id

  3. Organization

Related Sales Rep

RelatedSalesRep

  1. Id

  2. Integration Id

  3. Division, Position

  4. Login

Contact Fields in Siebel Contact ASI

The following table lists the Contact fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Alias

Alias

DTYPE_TEXT

50

No

None

Assistant

Assistant

DTYPE_TEXT

50

No

None

Birth Date

BirthDate

DTYPE_DATETIME

7

No

None

Cellular Phone #

CellularPhone

DTYPE_TEXT

NA

No

None

Comment

Comment

DTYPE_TEXT

255

No

None

Disable Data Cleansing

DisableDataCleansing

DTYPE_TEXT

NA

No

None

Email Address

EmailAddress

DTYPE_TEXT

50

No

None

Fax Phone #

FaxPhone

DTYPE_TEXT

NA

No

None

First Name

FirstName

DTYPE_TEXT

50

No

None

Gender

Gender

DTYPE_TEXT

255

No

None

Home Phone #

HomePhone

DTYPE_TEXT

NA

No

None

Id

Id

DTYPE_ID

30

No

None

Income

Income

DTYPE_TEXT

NA

No

None

Income Currency Code

IncomeCurrencyCode

DTYPE_TEXT

20

No

None

Income Exchange Date

IncomeExchangeDate

DTYPE_DATETIME

NA

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

User key field

Job Title

JobTitle

DTYPE_TEXT

75

No

None

Last Name

LastName

DTYPE_TEXT

50

No

None

Manager First Name

ManagerFirstName

DTYPE_TEXT

50

No

None

Manager Id

ManagerId

DTYPE_ID

15

No

None

Manager Integration Id

ManagerIntegrationId

DTYPE_TEXT

30

No

None

Manager Last Name

ManagerLastName

DTYPE_TEXT

50

No

None

Manager Middle Name

ManagerMiddleName

DTYPE_TEXT

50

No

None

Manager Primary Organization

ManagerPrimaryOrganization

DTYPE_TEXT

100

No

None

Manager UId

ManagerUId

DTYPE_TEXT

100

No

None

Middle Name

MiddleName

DTYPE_TEXT

50

No

None

operation

operation

DTYPE_TEXT

30

No

None

Person UId

PersonUId

DTYPE_TEXT

100

No

None

Personal Title

PersonalTitle

DTYPE_TEXT

15

No

None

Preferred Communications

PreferredCommunications

DTYPE_TEXT

30

No

None

Preferred Language Code

PreferredLanguageCode

DTYPE_TEXT

3

No

None

Primary Address Id

PrimaryAddressId

DTYPE_ID

N/A

No

None

Social Security Number

SocialSecurityNumber

DTYPE_TEXT

N/A

No

None

Status

Status

DTYPE_TEXT

30

No

Bound by CONTACT_STATUS LOV

Suppress All Calls

SuppressAllCalls

DTYPE_TEXT

1

No

None

Suppress All Emails

SuppressAllEmails

DTYPE_TEXT

1

No

None

Suppress All Faxes

SuppressAllFaxes

DTYPE_TEXT

N/A

No

None

Suppress All Mailings

SuppressAllMailings

DTYPE_TEXT

1

No

None

Time Zone Id

TimeZoneId

DTYPE_ID

N/A

No

None

Time Zone Name

TimeZoneName

DTYPE_TEXT

100

No

None

Work Phone #

WorkPhone

DTYPE_TEXT

N/A

No

None

Work Phone Extension

WorkPhoneExtension

DTYPE_TEXT

10

No

None

Personal Address Fields in Siebel Contact ASI

The following table lists the Personal Address fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

operation

operation

DTYPE_TEXT

30

No

None

Personal City

PersonalCity

DTYPE_TEXT

50

No

None

Personal Country

PersonalCountry

DTYPE_TEXT

50

No

None

Personal Postal Code

PersonalPostalCode

DTYPE_TEXT

30

No

None

Personal State

PersonalState

DTYPE_TEXT

10

No

None

Personal Street Address

PersonalStreetAddress

DTYPE_TEXT

200

No

None

Personal Street Address 2

PersonalStreetAddress2

DTYPE_TEXT

100

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Communication Address Fields in Siebel Contact ASI

The following table lists the Communication Address fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Alternate Email Address

AlternateEmailAddress

DTYPE_TEXT

100

No

None

Communication Address Medium Type

CommunicationAddressMediumType

DTYPE_TEXT

30

No

None

Communication Address Name

CommunicationAddressName

DTYPE_TEXT

50

No

None

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Alternate Phone Fields in Siebel Contact ASI

The following table lists the Alternate Phone fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Alternate Phone #

AlternatePhone

DTYPE_TEXT

100

No

None

Alternate Phone Medium Type

AlternatePhoneMediumType

DTYPE_TEXT

30

No

None

Alternate Phone Name

AlternatePhoneName

DTYPE_TEXT

50

No

None

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Related Account Fields in Siebel Contact ASI

The following table lists the Related Account fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Account

Account

DTYPE_TEXT

100

No

None

Account Location

AccountLocation

DTYPE_TEXT

50

No

None

Account Organization

AccountOrganization

DTYPE_TEXT

100

No

None

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Related Households Fields in Siebel Contact ASI

The following table lists the Related Households fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

HouseHold Name

HouseHoldName

DTYPE_TEXT

50

No

None

Household Number

HouseholdNumber

DTYPE_TEXT

100

No

None

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Related Organization Fields in Siebel Contact ASI

The following table lists the Related Organization fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

Organization

Organization

DTYPE_TEXT

50

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Related Sales Rep Fields in Siebel Contact ASI

The following table lists the Related Sales Rep fields and their attributes in Siebel Contact ASI.

Name XML Tag Data Type Length Req. Note

Division

Division

DTYPE_TEXT

255

No

None

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

None

Login

Login

DTYPE_TEXT

50

No

None

operation

operation

DTYPE_TEXT

30

No

None

Position

Position

DTYPE_TEXT

50

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Siebel CUT Address MSAG Service

The Siebel CUT Address MSAG Service ASI is an ASI for address validation business processes. This ASI facilitates inbound and outbound address data synchronization between a Siebel application and any external system. The following image describes the Siebel CUT Address MSAG Service ASI structure.

Siebel CUT Address MSAG Service ASI. In this image, Address and Address Information are connected.

The following table lists the integration component and user keys of this ASI.

Integration Component XML Tag User Keys

CUT MSAG Profile

CutMsagProfile

  1. Id

  2. Address Id, Profile Type

CUT MSAG Profile Fields in Siebel CUT Address MSAG Service ASI

The following table lists the CUT MSAG Profile fields and their attributes in Siebel CUT Address MSAG Service ASI.

Name XML Tag Data Type Length Req.

Address Id

AddressId

DTYPE_ID

N/A

No

Conflict Id

ConflictId

DTYPE_ID

30

No

Created

Created

DTYPE_DATETIME

30

No

Id

Id

DTYPE_ID

30

No

Internal Validation Flag

InternalValidationFlag

DTYPE_TEXT

N/A

No

Mod Id

ModId

DTYPE_ID

30

No

Profile Type

ProfileType

DTYPE_TEXT

30

No

SA Access Instruction

SAAccessInstruction

DTYPE_TEXT

255

No

SA City

SACity

DTYPE_TEXT

50

No

SA Country

SACountry

DTYPE_TEXT

50

No

SA County

SACounty

DTYPE_TEXT

50

No

SA Descriptive Location

SADescriptiveLocation

DTYPE_TEXT

30

No

SA Directional

SADirectional

DTYPE_TEXT

10

No

SA Driving Instructions

SADrivingInstruction

DTYPE_NOTE

N/A

No

SA House Number

SAHouseNumber

DTYPE_TEXT

8

No

SA House Prefix

SAHousePrefix

DTYPE_TEXT

5

No

SA House Suffix

SAHouseSuffix

DTYPE_TEXT

5

No

SA Location Designator 1

SALocationDesignator1

DTYPE_TEXT

50

No

SA Location Designator 2

SALocationDesignator2

DTYPE_TEXT

50

No

SA Location Designator 3

SALocationDesignator3

DTYPE_TEXT

50

No

SA Location Value 1

SALocationValue1

DTYPE_TEXT

50

No

SA Location Value 2

SALocationValue2

DTYPE_TEXT

50

No

SA Location Value 3

SALocationValue3

DTYPE_TEXT

50

No

SA State

SAState

DTYPE_TEXT

10

No

SA Street Name

SAStreetName

DTYPE_TEXT

50

No

SA Street Suffix

SAStreetSuffix

DTYPE_TEXT

4

No

SA Thoroughfare

SAThoroughfare

DTYPE_TEXT

20

No

SA Zipcode

SAZipcode

DTYPE_TEXT

30

No

Updated

Updated

DTYPE_DATETIME

30

No

operation

operation

DTYPE_TEXT

30

No

searchspec

searchspec

DTYPE_TEXT

250

No

Siebel Cost List

Standard product costs that exist in external systems are created in the Siebel application based on the costs existing in the external manufacturing and accounting systems. The initial cost types include standard costs, base costs, and the variable costs for a given product.

This inbound ASI enables the synchronization and update of a cost list and the cost list items. The following image describes the Siebel Cost List ASI structure.

Siebel Cost List ASI. In this image, Cost List has a one-to-many relationship with Cost List Item.

The following table lists the integration components and user keys of this ASI.

Integration Component XML Tag User Keys

Cost List

CostList

  1. Name, Type

  2. Id
  3. Integration Id

Cost List Item

CostListItem

  1. Product Id

  2. Id

  3. Integration Id

Cost List Fields in Siebel Cost List ASI

The following table lists the Cost List fields and their attributes in Siebel Cost List ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req. Note

Cost Method

CostMethod

DTYPE_TEXT

30

No

None

Currency Code

CurrencyCode

DTYPE_TEXT

20

No

None

Description

Description

DTYPE_TEXT

255

No

None

End Date

EndDate

DTYPE_TEXT

NA

No

None

Id

Id

DTYPE_ID

30

No

Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

Name

Name

DTYPE_TEXT

50

No

User key field.

Start Date

StartDate

DTYPE_TEXT

NA

No

None

Type

Type

DTYPE_TEXT

30

No

User key field.

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Cost List Item Fields in Siebel Cost List ASI

The following table lists the Cost List Item fields and their attributes in Siebel Cost List ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req. Note

Average Cost

AverageCost

DTYPE_TEXT

NA

No

None

Currency Code

CurrencyCode

DTYPE_TEXT

20

No

None

Description

Description

DTYPE_TEXT

255

No

None

End Date

EndDate

DTYPE_TEXT

NA

No

None

Ext OT Pct Increase

ExtOTPctIncrease

DTYPE_NUMBER

NA

No

None

Id

Id

DTYPE_ID

30

No

User key field. Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

Integration Id

IntegrationId

DTYPE_TEXT

30

No

User key field.

Last Cost

LastCost

DTYPE_TEXT

NA

No

None

Next Cost

NextCost

DTYPE_TEXT

NA

No

None

Product Id

ProductId

DTYPE_ID

NA

No

User key field. Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

Standard Cost

StandardCost

DTYPE_TEXT

NA

No

None

Start Date

StartDate

DTYPE_TEXT

NA

No

None

Std OT Pct Increase

StdOTPctIncrease

DTYPE_NUMBER

NA

No

None

operation

operation

DTYPE_TEXT

30

No

None

searchspec

searchspec

DTYPE_TEXT

250

No

None

Siebel Employee

The Siebel Employee ASI is an ASI for employee-related business processes. The Employee Integration Object enables inbound and outbound data integration between Siebel applications and third-party applications that process employee data. This can include employee core data, job-related data, responsibilities, position, or resume data. The integration business services are included to perform the basic Create, Update, Delete, and Query functions on Employee objects in the Siebel application. The following image shows the Siebel Employee ASI structure.

Siebel Employee ASI. In this image, Employee has the following integration components: Personal Address, Related Organization, Related Position (Related Position Business Address), Related Subcontractor, CMS Certification Qualification, CMS Education, CMS Past Work Experience, CMS Honors Award, CMS Memberships. There is a one-to-many relationship between Employee and its components.

The following table lists the Siebel Employee integration components.

Integration Component XML Tag User Keys

CMS Certifications Qualifications

CmsCertificationsQualifications

  1. Id

  2. Integration Id

  3. Certification

CMS Education

CmsEducation

  1. Id

  2. Integration Id

  3. Education

CMS Employee Competency Administration

CmsEmployeeCompetencyAdministration

  1. Competency Id

  2. Employee Id

CMS Honors Awards

CmsHonorsAwards

  1. Id

  2. Integration Id

  3. Honor Award

CMS Memberships

CmsMemberships

  1. Id

  2. Integration Id

  3. Membership

CMS Past Work Experience

CmsPastWorkExperience

  1. Id

  2. Integration Id

  3. Company Name

Employee

Employee

  1. Id

  2. Integration Id

  3. Login Domain, Login Name

  4. Login Name

  5. First Name, Last Name, Middle Name

Employee_Employee Organization

EmployeeEmployeeOrganization

  1. Employee Organization Id

  2. Employee Organization Integration Id

  3. Employee Organization

Employee_Personal Address

EmployeePersonalAddress

  1. Personal Address Id

  2. Personal Address Integration Id

Employee_Position

EmployeePosition

  1. Position Id

  2. Position Integration Id

  3. Division, Position

Employee_Subcontractor

EmployeeSubcontractor

  1. Subcontractor Account Id

  2. Subcontractor Integration Id

  3. Subcontractor Name

Employee_Responsibility

EmployeeResponsibility

  1. Responsibility Id

  2. Responsibility Integration Id

  3. Responsibility

Personal Address

PersonalAddress

  1. Personal Address Id

  2. Personal Address Integration Id

Related Employee Organization

RelatedEmployeeOrganization

  1. Employee Organization Id

  2. Employee Organization Integration Id

  3. Employee Organization

Related Position

RelatedPosition

  1. Position Id

  2. Position Integration Id

  3. Division, Position

Related Position Business Address

RelatedPositionBusinessAddress

  • Address Id

Related Responsibility

RelatedResponsibility

  1. Responsibility Id

  2. Responsibility Integration Id

  3. Responsibility

Related Subcontractor

RelatedSubcontractor

  1. Subcontractor Account Id

  2. Subcontractor Integration Id

  3. Subcontractor Name

CMS Certifications Qualifications Fields in Siebel Employee ASI

The following table lists the CMS Certifications Qualifications fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Certification

Certification

DTYPE_TEXT

30

No

Comments

Comments

DTYPE_TEXT

250

No

Date of Certification

DateofCertification

DTYPE_TEXT

N/A

No

Id

Id

DTYPE_ID

30

No

Institution

Institution

DTYPE_TEXT

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

CMS Education Fields in Siebel Employee ASI

The following table lists the CMS Education fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Comments

Comments

DTYPE_TEXT

250

No

Country

Country

DTYPE_TEXT

30

No

Degree

Degree

DTYPE_TEXT

30

No

Education

Education

DTYPE_TEXT

30

No

Grade

Grade

DTYPE_TEXT

30

No

Graduation Date

GraduationDate

DTYPE_TEXT

N/A

No

Id

Id

DTYPE_ID

30

No

Institution

Institution

DTYPE_TEXT

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Major

Major

DTYPE_TEXT

30

No

Number of Years

NumberofYears

DTYPE_NUMBER

N/A

No

Scale

Scale

DTYPE_TEXT

30

No

Type of Education

TypeofEducation

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

CMS Employee Competency Administration Fields in Siebel Employee ASI

The following table lists the CMS Employee Competency Administration fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Competency Id

CompetencyId

DTYPE_ID

N/A

No

Skill Name

SkillName

DTYPE_TEXT

50

No

Current Skill Level

CurrentSkillLevel

DTYPE_TEXT

100

No

Current Skill Level Id

CurrentSkillLevelId

DTYPE_ID

N/A

No

Current Skill Level Value

CurrentSkillLevelValue

DTYPE_NUMBER

N/A

No

Date of Accomplishment

DateOfAccomplishment

DTYPE_DATETIME

N/A

No

Employee Id

EmployeeId

DTYPE_ID

N/A

No

Id

Id

DTYPE_ID

30

No

Required Skill Level Value

RequiredSkillLevelValue

DTYPE_NUMBER

N/A

No

Required Skill Level Id

RequiredSkillLevel Id

DTYPE_ID

N/A

No

Parent Skill

ParentSkill

DTYPE_TEXT

50

No

Rating Scale Id

RatingScaleId

DTYPE_ID

N/A

No

Required Skill Level

Required Skill Level

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Updated

Updated

DTYPE_DATETIME

30

No

Status

Status

DTYPE_TEXT

30

No

Skill Gap

SkillGap

DTYPE_NUMBER

N/A

No

Skill Description

SkillDescription

DTYPE_TEXT

250

No

Root Category Id

RootCategoryId

DTYPE_ID

N/A

No

Root Category

RootCategory

DTYPE_TEXT

50

No

searchspec

searchspec

DTYPE_TEXT

250

No

Manager Comments

ManagerComments

DTYPE_TEXT

2000

No

Employee Comments

EmployeeComments

DTYPE_TEXT

2000

No

Delete Record Flag

DeleteRecordFlag

DTYPE_TEXT

N/A

No

Criticality

Criticality

DTYPE_TEXT

30

No

Created

Created

DTYPE_DATETIME

30

No

Conflict Id

ConflictId

DTYPE_ID

30

No

Category Id

CategoryId

DTYPE_ID

N/A

No

Assessment Type

AssessmentType

DTYPE_TEXT

30

No

Approved By Id

ApprovedById

DTYPE_ID

N/A

No

Mod Id

ModId

DTYPE_ID

30

No

CMS Honors Awards Fields in Siebel Employee ASI

The following table lists the CMS Honors Awards fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.
Name XML Tag Data Type Length Req.

Comments

Comments

DTYPE_TEXT

250

No

Honor Award

HonorAward

DTYPE_TEXT

30

No

Id

Id

DTYPE_ID

30

No

Institution

Institution

DTYPE_TEXT

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Received Date

ReceivedDate

DTYPE_TEXT

N/A

No

Relevance to Company

RelevancetoCompany

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

CMS Memberships Fields in Siebel Employee ASI

The following table lists the CMS Memberships fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Active Status

ActiveStatus

DTYPE_TEXT

N/A

No

Comments

Comments

DTYPE_TEXT

250

No

End Date

EndDate

DTYPE_TEXT

N/A

No

Id

Id

DTYPE_ID

30

No

Institution

Institution

DTYPE_TEXT

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Membership

Membership

DTYPE_TEXT

30

No

Relevance to Company

RelevancetoCompany

DTYPE_TEXT

30

No

Start Date

StartDate

DTYPE_TEXT

N/A

No

operation

operation

DTYPE_TEXT

30

No

CMS Past Work Experience Fields in Siebel Employee ASI

The following table lists the CMS Past Work Experience fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Business Title

BusinessTitle

DTYPE_TEXT

50

No

Business Unit

BusinessUnit

DTYPE_TEXT

30

No

Comments

Comments

DTYPE_TEXT

250

No

Company Name

CompanyName

DTYPE_TEXT

30

No

End Date

EndDate

DTYPE_TEXT

N/A

No

First Name

FirstName

DTYPE_TEXT

50

No

Id

Id

DTYPE_ID

30

No

Industry

Industry

DTYPE_ID

N/A

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Last Name

LastName

DTYPE_TEXT

50

No

Position

Position

DTYPE_TEXT

50

No

Start Date

StartDate

DTYPE_TEXT

N/A

No

operation

operation

DTYPE_TEXT

30

No

Employee Fields in Siebel Employee ASI

The following table lists the Employee fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Alias

Alias

DTYPE_TEXT

50

No

Availability Status

AvailabilityStatus

DTYPE_TEXT

30

No

Availability Status Until

AvailabilityStatusUntil

DTYPE_TEXT

N/A

No

Bonus Target %

BonusTarget

DTYPE_NUMBER

N/A

No

Building Number

BuildingNumber

DTYPE_TEXT

30

No

CP Region

CPRegion

DTYPE_TEXT

50

No

CP Region Id

CPRegionId

DTYPE_ID

N/A

No

CP Region Integration Id

CPRegionIntegrationId

DTYPE_TEXT

30

No

Cell Phone #

CellPhone

DTYPE_TEXT

N/A

No

Cost Currency Code

CostCurrencyCode

DTYPE_TEXT

30

No

Cost Per Hour

CostPerHour

DTYPE_TEXT

N/A

No

Cubicle Number

CubicleNumber

DTYPE_TEXT

20

No

EMail Addr

EMailAddr

DTYPE_TEXT

50

No

Emergency Notification

EmergencyNotification

DTYPE_TEXT

30

No

Emp #

Emp

DTYPE_TEXT

30

No

Employee Flag

EmployeeFlag

DTYPE_TEXT

N/A

No

Employee Type Code

EmployeeTypeCode

DTYPE_TEXT

30

No

Employment Status

EmploymentStatus

DTYPE_TEXT

30

No

End Shift to

EndShiftto

DTYPE_TEXT

30

No

Fax #

Fax

DTYPE_TEXT

N/A

No

First Name

FirstName

DTYPE_TEXT

50

No

Hire Date

HireDate

DTYPE_DATETIME

N/A

No

Home Phone #

HomePhone

DTYPE_TEXT

N/A

No

Id

Id

DTYPE_ID

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Job Code Id

JobCodeId

DTYPE_ID

N/A

No

Job Code Integration Id

JobCodeIntegrationId

DTYPE_TEXT

30

No

Job Code Name

JobCodeName

DTYPE_TEXT

30

No

Job Title

JobTitle

DTYPE_TEXT

75

No

Last Name

LastName

DTYPE_TEXT

50

No

Last Promotion Date

LastPromotionDate

DTYPE_DATETIME

N/A

No

License Plate Number

LicensePlateNumber

DTYPE_TEXT

50

No

Login Domain

LoginDomain

DTYPE_TEXT

50

No

Login Name

LoginName

DTYPE_TEXT

50

No

M/F

MF

DTYPE_TEXT

1

No

Maiden Name

MaidenName

DTYPE_TEXT

50

No

Middle Name

MiddleName

DTYPE_TEXT

50

No

Next Annual Review Date

NextAnnualReviewDate

DTYPE_DATETIME

N/A

No

Next Availability Status

NextAvailabilityStatus

DTYPE_TEXT

30

No

Nick Name

NickName

DTYPE_TEXT

50

No

Overtime Code

OvertimeCode

DTYPE_TEXT

30

No

Pager PIN

PagerPIN

DTYPE_TEXT

10

No

Pager Phone #

PagerPhone

DTYPE_TEXT

N/A

No

Pager Type

PagerType

DTYPE_TEXT

30

No

Personal Title

PersonalTitle

DTYPE_TEXT

15

No

Phone #

Phone

DTYPE_TEXT

N/A

No

Preferred Communications

PreferredCommunications

DTYPE_TEXT

30

No

Private

Private

DTYPE_TEXT

N/A

No

Readiness

Readiness

DTYPE_TEXT

30

No

Seniority Date

SeniorityDate

DTYPE_TEXT

N/A

No

Share Address Flag

ShareAddressFlag

DTYPE_TEXT

N/A

No

Share Home Phone Flag

ShareHomePhoneFlag

DTYPE_TEXT

N/A

No

Shift Id

ShiftId

DTYPE_ID

N/A

No

Shift Integration Id

ShiftIntegrationId

DTYPE_TEXT

30

No

Shift Name

ShiftName

DTYPE_TEXT

100

No

Standard Notification

StandardNotification

DTYPE_TEXT

30

No

Start Shift From

StartShiftFrom

DTYPE_TEXT

30

No

Subcontractor Flag

SubcontractorFlag

DTYPE_TEXT

N/A

No

Termination Date

TerminationDate

DTYPE_DATETIME

N/A

No

Time Zone Id

TimeZoneId

DTYPE_ID

N/A

No

Time Zone Name

TimeZoneName

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Employee_Employee Organization Fields in Siebel Employee ASI

The following table lists the Employee_Employee Organization fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Employee Organization

EmployeeOrganization

DTYPE_TEXT

50

No

Employee Organization Id

EmployeeOrganizationId

DTYPE_ID

30

No

Employee Organization Integration Id

EmployeeOrganizationIntegraitionId

DTYPE_TEXT

30

No

IsPrimaryMVG

IsPrimaryMvg

DTYPE_TEXT

1

No

Employee_Personal Address Fields in Siebel Employee ASI

The following table lists the Employee_Personal Address fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

IsPrimaryMVG

IsPrimaryMvg

DTYPE_TEXT

1

No

Personal Address Id

PersonalAddressId

DTYPE_ID

30

No

Personal Address Integration Id

PersonalAddressIntegrationId

DTYPE_TEXT

30

No

Personal City

PersonalCity

DTYPE_TEXT

50

No

Personal Country

PersonalCountry

DTYPE_TEXT

50

No

Personal County

PersonalCounty

DTYPE_TEXT

50

No

Personal Postal Code

PersonalPostalCode

DTYPE_TEXT

30

No

Personal Province

PersonalProvince

DTYPE_TEXT

50

No

Personal State

PersonalState

DTYPE_TEXT

10

No

Personal Street Address

PersonalStreetAddress

DTYPE_TEXT

200

No

Personal Street Address 2

PersonalStreetAddress2

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Employee_Position Fields in Siebel Employee ASI

The following table lists the Employee_Position fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Division

Division

DTYPE_TEXT

255

No

Division Id

DivisionId

DTYPE_ID

N/A

No

Division Integration Id

DivisionIntegrationId

DTYPE_TEXT

30

No

Employee End Date

EmployeeEndDate

DTYPE_DATETIME

N/A

No

Employee Start Date

EmployeeStartDate

DTYPE_DATETIME

N/A

No

IsPrimaryMVG

IsPrimaryMvg

DTYPE_TEXT

1

No

Position

Position

DTYPE_TEXT

50

No

Position Id

PositionId

DTYPE_ID

30

No

Position Integration Id

PositionIntegrationId

DTYPE_TEXT

30

No

Employee_Responsibility Fields in Siebel Employee ASI

The following table lists the Employee_Responsibility fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Responsibility

Responsibility

DTYPE_TEXT

50

No

Responsibility Id

ResponsibilityId

DTYPE_ID

30

No

Responsibility Integration Id

ResponsibilityIntegrationId

DTYPE_TEXT

30

No

Employee_Subcontractor Fields in Siebel Employee ASI

The following table lists the Employee_Subcontractor fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Subcontractor Account Id

SubcontractorAccountId

DTYPE_ID

30

No

Subcontractor Integration Id

SubcontractorIntegrationId

DTYPE_TEXT

30

No

Subcontractor Name

Subcontractor Name

DTYPE_TEXT

100

No

Personal Address Fields in Siebel Employee ASI

The following table lists the Personal Address fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Personal Address Id

PersonalAddressId

DTYPE_ID

30

No

Personal Address Integration Id

PersonalAddressIntegrationId

DTYPE_TEXT

30

No

Personal City

PersonalCity

DTYPE_TEXT

50

No

Personal Country

PersonalCountry

DTYPE_TEXT

50

No

Personal County

PersonalCounty

DTYPE_TEXT

50

No

Personal Postal Code

PersonalPostalCode

DTYPE_TEXT

30

No

Personal Province

PersonalProvince

DTYPE_TEXT

50

No

Personal State

PersonalState

DTYPE_TEXT

10

No

Personal Street Address

PersonalStreetAddress

DTYPE_TEXT

200

No

Personal Street Address 2

PersonalStreetAddress2

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Related Employee Organization Fields in Siebel Employee ASI

The following table lists the Related Employee Organization fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Employee Organization

EmployeeOrganization

DTYPE_TEXT

50

No

Employee Organization Id

EmployeeOrganizationId

DTYPE_ID

30

No

Employee Organization Integration Id

EmployeeOrganizationIntegrationId

DTYPE_TEXT

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Related Position Fields in Siebel Employee ASI

The following table lists the Related Position fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Division

Division

DTYPE_TEXT

255

No

Division Id

DivisionId

DTYPE_ID

N/A

No

Division Integration Id

DivisionIntegrationId

DTYPE_TEXT

30

No

Employee End Date

EmployeeEndDate

DTYPE_DATETIME

N/A

No

Employee Start Date

EmployeeStartDate

DTYPE_DATETIME

N/A

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Position

Position

DTYPE_TEXT

50

No

Position Id

PositionId

DTYPE_ID

30

No

Position Integration Id

PositionIntegrationId

DTYPE_TEXT

30

No

Related Position Business Address Fields in Siebel Employee ASI

The following table lists the Related Position Business Address fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

Address Id

AddressId

DTYPE_ID

30

No

Address Integration Id

AddressIntegrationId

DTYPE_TEXT

30

No

Address Name

AddressName

DTYPE_TEXT

100

No

City

City

DTYPE_TEXT

50

No

Country

Country

DTYPE_TEXT

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Postal Code

PostalCode

DTYPE_TEXT

30

No

State

State

DTYPE_TEXT

10

No

Street Address

StreetAddress

DTYPE_TEXT

200

No

Related Responsibility Fields in Siebel Employee ASI

The following table lists the Related Responsibility fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Responsibility

Responsibility

DTYPE_TEXT

50

No

Responsibility Id

ResponsibilityId

DTYPE_ID

30

No

Responsibility Integration Id

ResponsibilityIntegrationId

DTYPE_TEXT

30

No

Related Subcontractor Fields in Siebel Employee ASI

The following table lists the Related Subcontractor fields and their attributes in Siebel Employee ASI.

Name XML Tag Data Type Length Req.

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Subcontractor Account Id

SubcontractorAccountId

DTYPE_ID

30

No

Subcontractor Integration Id

SubcontractorIntegrationId

DTYPE_TEXT

30

No

Subcontractor Name

SubcontractorName

DTYPE_TEXT

100

No

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. The following image describes the Siebel Financial Account ASI structure.

Siebel Financial Account ASI. In this image, Financial Account has the following children: Contact and Financial Account Contact.

The following table lists the integration components and user keys of the Siebel Financial Account ASI.

Integration Component XML Tag User Keys

FINCORP Account

FincorpAccount

  1. Integration Id

  2. Row Id

  3. Account Number, Primary Organization Name

    Status Key: Account Number, Id, Integration Id, operation

Contact

Contact

  1. Integration Id

  2. Party UId

  3. Row Id

  4. Account Integration Id, Employee Number, Personal Contact

  5. Person Uid, Personal Contact, Primary Organization

    Status Key: Id, Integration Id, operation

FINCORP Account Contact

FincorpAccountContact

  1. Asset Id, Contact Id

  2. Contact Id

FINCORP Account Fields in Siebel Financial Account ASI

The following table lists the FINCORP Account fields and their attributes in Siebel Financial Account ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

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

N/A

No

Account Branch Name

AccountBranchName

DTYPE_TEXT

100

No

Account Branch Number

AccountBranchNumber

DTYPE_TEXT

30

No

Account Holder

AccountHolder

DTYPE_TEXT

N/A

No

Account Name

AccountName

DTYPE_TEXT

100

No

Account Number

AccountNumber

DTYPE_TEXT

100

Yes

Account Row Id

AccountRowId

DTYPE_ID

N/A

No

Account Status

AccountStatus

DTYPE_TEXT

30

No

Account Type

AccountType

DTYPE_TEXT

30

No

Acct Gen - Account Id

AcctGen-AccountId

DTYPE_ID

N/A

No

Acct Gen - Average Balance

AcctGen-AverageBalance

DTYPE_CURRENCY

N/A

No

Acct Gen - Branch Id

AcctGen-BranchId

DTYPE_ID

N/A

No

Acct Gen - Organization Address Id

AcctGen-OrganizationAddressId

DTYPE_ID

N/A

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

N/A

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

N/A

No

Acct Gen - Product Line Id

AcctGen-ProductLineId

DTYPE_ID

N/A

No

Available Balance

AvailableBalance

DTYPE_CURRENCY

N/A

No

Balance

Balance

DTYPE_CURRENCY

N/A

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

N/A

No

Comments

Comments

DTYPE_TEXT

250

No

Commitment Amount

CommitmentAmount

DTYPE_CURRENCY

N/A

No

Conflict Id

ConflictId

DTYPE_ID

30

No

Contact Address Id

ContactAddressId

DTYPE_ID

N/A

No

Created

Created

DTYPE_DATETIME

30

No

Currency

Currency

DTYPE_TEXT

20

No

Current Balance

CurrentBalance

DTYPE_CURRENCY

N/A

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

N/A

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

N/A

No

Parent Account Id

ParentAccountId

DTYPE_ID

N/A

No

Parent Account Number

ParentAccountNumber

DTYPE_TEXT

100

No

Parent Asset ID

ParentAssetID

DTYPE_ID

N/A

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

N/A

No

Primary Account Id

PrimaryAccountId

DTYPE_ID

N/A

No

Primary Employee Id

PrimaryEmployeeId

DTYPE_ID

N/A

No

Primary Org Id

PrimaryOrgId

DTYPE_ID

N/A

No

Primary Organization Name

PrimaryOrganizationName

DTYPE_TEXT

100

No

Primary Position Id

PrimaryPositionId

DTYPE_ID

N/A

No

Product Id

ProductId

DTYPE_ID

N/A

Yes

Start Date

StartDate

DTYPE_DATE

N/A

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 Fields in Siebel Financial Account ASI

The following table lists the Contact fields and their attributes in Siebel Financial Account ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Account Id

AccountId

DTYPE_ID

N/A

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

N/A

No

Cellular Phone #

CellularPhone

DTYPE_PHONE

N/A

No

Created

Created

DTYPE_DATETIME

30

No

Employee Number

EmployeeNumber

DTYPE_TEXT

30

No

Fax Phone #

FaxPhone

DTYPE_PHONE

N/A

No

First Name

FirstName

DTYPE_TEXT

50

Yes

Home Phone #

HomePhone

DTYPE_PHONE

N/A

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

N/A

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

N/A

No

operation

operation

DTYPE_TEXT

30

No

searchspec

searchspec

DTYPE_TEXT

250

No

FINCORP Account Contact Fields in Siebel Financial Account ASI

The following table lists the FINCORP Account Contact fields and their attributes in Siebel Financial Account ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Account

Account

DTYPE_TEXT

100

No

Account Id

AccountId

DTYPE_ID

N/A

No

Asset Id

AssetId

DTYPE_ID

N/A

No

Cellular Phone Number

CellularPhoneNumber

DTYPE_PHONE

N/A

No

Conflict Id

ConflictId

DTYPE_ID

30

No

Contact Id

ContactId

DTYPE_ID

N/A

No

Created

Created

DTYPE_DATETIME

30

No

Currency

Currency2

DTYPE_TEXT

N/A

No

Email Address

EmailAddress3

DTYPE_TEXT

100

No

Fax Number

FaxNumber

DTYPE_PHONE

N/A

No

First Name

FirstName

DTYPE_TEXT

50

No

Home Phone Number

HomePhoneNumber

DTYPE_PHONE

N/A

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

N/A

No

Primary Personal Address Id

PrimaryPersonalAddressId

DTYPE_ID

N/A

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

N/A

No

operation

operation

DTYPE_TEXT

30

No

searchspec

searchspec

DTYPE_TEXT

250

No

Siebel Forecast

The Siebel Forecast ASI consists of internal and external integration objects and a business service. This ASI facilitates the outbound data synchronization between the Siebel application and an external back-office system. This ASI is used by the Export Forecast business process, which queries the Siebel application for data on a given forecast and returns the data to a back-office system.

The following image describes the Siebel Forecast ASI structure.

Siebel Forecast ASI. In this image, Forecast Header has a one-to-many relationship with Forecast Items.

The following table lists the integration components and user keys of the Siebel Forecast ASI.

Integration Component XML Tag User Keys

Forecast

Forecast

  • Forecast Number

Forecast Item Detail Flat

ForecastItemDetailFlat

  1. Detail Date

  2. Forecast Item Id

  3. Owner Forecast Id

Forecast Fields in Siebel Forecast ASI

The following table lists the Forecast fields and their attributes in Siebel Forecast ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Archive Timestamp

ArchiveTimestamp

DTYPE_TEXT

N/A

No

Created By Login

CreatedByLogin

DTYPE_TEXT

50

No

Forecast Base Period Type

ForecastBasePeriodType

DTYPE_TEXT

30

No

Forecast Date

ForecastDate

DTYPE_TEXT

N/A

No

Forecast End Date

ForecastEndDate

DTYPE_TEXT

N/A

No

Forecast Id

ForecastId

DTYPE_ID

15

No

Forecast Name

ForecastSeriesName

DTYPE_TEXT

20

No

Forecast Number

ForecastNumber

DTYPE_TEXT

30

No

Forecast Start Date

ForecastStartDate

DTYPE_TEXT

N/A

No

operation

operation

DTYPE_TEXT

30

No

Owner Organization Id

OwnerOrganizationId

DTYPE_ID

15

No

Owner Position Id

OwnerPositionId

DTYPE_ID

15

No

Forecast Item Detail Flat Fields in Siebel Forecast ASI

The following table lists the Forecast Item Detail Flat fields and their attributes in Siebel Forecast ASI. Fields without a length specified do not have a maximum length associated with them.

Name XML Tag Data Type Length Req.

Account Id

AccountId

DTYPE_ID

15

No

Amount Revenue

Revenue

DTYPE_TEXT

N/A

No

Best Case

BestCase

DTYPE_TEXT

N/A

No

Commit Flag

CommitFlag

DTYPE_TEXT

1

No

Cost

Cost

DTYPE_TEXT

N/A

No

Currency

CurrencyCode

DTYPE_TEXT

N/A

No

Detail Date

DetailDate

DTYPE_TEXT

N/A

No

DUNS Number

DUNSNumber

DTYPE_TEXT

15

No

Forecast Id

ForecastId

DTYPE_ID

15

No

Forecast Item Id

ForecastItemId

DTYPE_ID

15

No

Id

Id

DTYPE_ID

15

No

Link Type

LinkType

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

Opportunity Id

OpportunityId

DTYPE_ID

15

No

Organization Id

OrganizationId

DTYPE_ID

15

No

Owner Forecast Id

OwnerForecastId

DTYPE_ID

15

No

Primary Product Line Id

ProductLineId

DTYPE_ID

15

No

Product Id

ProductId

DTYPE_ID

15

No

Product Price

ProductPrice

DTYPE_TEXT

N/A

No

Product Quantity

ProductQuantity

DTYPE_TEXT

N/A

No

Sales Rep Id

SalesRepPositionId

DTYPE_ID

15

No

Service Request Id

ServiceRequestId

DTYPE_ID

15

No

Unit of Measure

UnitOfMeasure

DTYPE_TEXT

30

No

Worst Case

WorstCase

DTYPE_TEXT

N/A

No

Siebel Invoice

The Siebel Invoice ASI enables the implementation of replication of invoices from back-office accounting systems to the Siebel application, which allows sales professionals, call center agents, partners, as well as the customer, to access invoice information in the Siebel application for related inquiries. A typical process involves the creation of the invoice in the back-end system after the fulfillment of an order, which is then followed by the replication of this invoice (as well as all of its updates) in the front-end systems. The Siebel Invoice ASI enables the creation, update, deletion and queries of invoice information for inbound and outbound directions in Siebel applications.

The following image describes the structure of the Siebel Invoice ASI.

Siebel Invoice ASI. In this image, FS Invoice is connected to FS Invoice Line Item.

The following table lists the integration components of this ASI.

Integration Component XML Tag User Keys

FS Invoice (primary)

Invoice

  1. Id

  2. Integration Id

  3. Document Type, Document Number

FS Invoice Line Items

FSInvoiceLineItems

  1. Id

  2. Integration Id

  3. Line Number

The Siebel Invoice ASI uses the same user keys as the FS Invoice integration component. You can use the fields for the integration, which means that values for each of these fields may be written to an XML file for transport.

FS Invoice Fields in Siebel Invoice ASI

The following table lists the FS Invoice (primary) fields and their attributes in Siebel Invoice ASI.

Name XML Tag Data Type Length Req. Note

Account Id

AccountId

DTYPE_ID

15

No

User key field.

Used to pick from Picklist Account.

Account Integration Id

AccountIntegrationId

DTYPE_TEXT

30

No

User key field.

Used to pick from Picklist Account.

Account Location

AccountLocation

DTYPE_TEXT

30

No

Used to pick from Picklist Account.

Account Name

AccountName

DTYPE_TEXT

50

No

Used to pick from Picklist Account.

Account Organization Name

AccountOrganizationName

DTYPE_TEXT

100

No

Used to pick from Picklist Account.

Activity Id

ActivityId

DTYPE_ID

15

No

Used to pick from FS Activity Pick List.

Activity User Defined Unique Id

ActivityUserDefinedUniqueId

DTYPE_TEXT

30

No

Used to pick from FS Activity Pick List.

Amount Paid

AmountPaid

DTYPE_CURRENCY

22

No

None

Balance Forward

BalanceForward

DTYPE_CURRENCY

22

No

None

Contract Id

ContractId

DTYPE_ID

15

No

Used to pick from Service Agreement.

Contract Integration Id

ContractIntegrationId

DTYPE_TEXT

30

No

Used to pick from Service Agreement.

Contract Name

ContractName

DTYPE_TEXT

50

No

Used to pick from Service Agreement.

Contract Organization Name

ContractOrganizationName

DTYPE_TEXT

100

No

Used to pick from Service Agreement.

Contract Revision Number

ContractRevisionNumber

DTYPE_NUMBER

22

No

Used to pick from Service Agreement.

Currency Code

CurrencyCode

DTYPE_TEXT

20

Yes

Used to pick from Picklist Currency.

Delinquent Flag

DelinquentFlag

DTYPE_BOOL

1

No

None

Document Date

DocumentDate

DTYPE_UTCDATETIME

7

No

None

Document Description

DocumentDescription

DTYPE_TEXT

250

No

None

Document Number

DocumentNumber

DTYPE_TEXT

50

Yes

User key field for Invoice.

Document Period Id

DocumentPeriodId

DTYPE_ID

15

No

Used to pick from Picklist Period.

Document Period Name

DocumentPeriodName

DTYPE_TEXT

50

No

Used for picking from Picklist Period.

Document Period Organization Name

DocumentPeriodOrganizationName

DTYPE_TEXT

100

No

Used to pick from Picklist Period.

Document Revision Number

DocumentRevisionNumber

DTYPE_NUMBER

15

No

None

Document Status

DocumentStatus

DTYPE_TEXT

30

No

Bound by FS_INVOICE_TYPE LOV.

Document Sub Type

DocumentSubType

DTYPE_TEXT

30

No

Bound by FS_INVOICE_CODE LOV.

Document Type

DocumentType

DTYPE_TEXT

30

No

User key field.

Bound by FS_INVOICE_TYPE LOV.

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

Order Id

OrderId

DTYPE_ID

15

No

Used to pick from Order Entry Picklist.

Order Integration Id

OrderIntegrationId

DTYPE_TEXT

30

No

Used to pick from Order Entry Picklist.

Order Number

OrderNumber

DTYPE_TEXT

30

No

Used to pick from Order Entry Picklist.

Order Organization Name

OrderOrganizationName

DTYPE_TEXT

100

No

Used to pick from Order Entry Picklist.

Order Type

OrderType

DTYPE_TEXT

50

No

Used for picking from Order Entry Picklist.

Payment Term

PaymentTerm

DTYPE_TEXT

50

No

Used to pick from Picklist Payment Term.

Payment Term Id

PaymentTermId

DTYPE_ID

15

No

Used to pick from Picklist Payment Term.

Project Id

ProjectId

DTYPE_ID

15

No

Used to pick from Picklist Project.

Project Integration Id

ProjectIntegrationId

DTYPE_TEXT

30

No

Used for picking from Picklist Project.

Project Number

ProjectNumber

DTYPE_TEXT

30

No

Used to pick from Picklist Project.

Project Organization Name

ProjectOrganizationName

DTYPE_TEXT

100

No

Used to pick from Picklist Project.

STORED Adjustment Amount

STOREDAdjustmentAmount

DTYPE_CURRENCY

22

No

None

STORED Discount Amount

STOREDDiscountAmount

DTYPE_CURRENCY

22

No

None

STORED Gross Amount

STOREDGrossAmount

DTYPE_CURRENCY

22

No

None

STORED Surcharge Amount

STOREDSurchargeAmount

DTYPE_CURRENCY

22

No

None

STORED Tax Amount

STOREDTaxAmount

DTYPE_CURRENCY

22

No

None

Service Request Id

ServiceRequestId

DTYPE_ID

15

No

Used to pick from Service Request Picklist.

Service Request Number

ServiceRequestNumber

DTYPE_TEXT

64

No

Used to pick from Service Request Picklist.

Service Request Organization Name

ServiceRequestOrganizationName

DTYPE_TEXT

100

No

Used to pick from Service Request Picklist.

FS Invoice Line Items Fields in Siebel Invoice ASI

The following table lists the FS Invoice Line Items fields and their attributes in Siebel Invoice ASI.

Name XML Tag Data Type Length Req. Note

Activity Id

ActivityId

DTYPE_ID

15

No

Used to pick from FS Activity Picklist.

Activity User Defined Unique Id

ActivityUserDefinedUniqueId

DTYPE_TEXT

30

No

Used to pick from FS Activity Picklist.

Contract Id

ContractId

DTYPE_ID

15

No

Used to pick from FS PickList Agreement Item - All.

Contract Integration Id

ContractIntegrationId

DTYPE_TEXT

30

No

Used to pick from FS PickList Agreement Item - All.

Contract Line Id

ContractLineId

DTYPE_ID

15

No

Used to pick from FS PickList Agreement Item - All.

Contract Name

ContractName

DTYPE_TEXT

50

No

Used to pick from FS PickList Agreement Item - All.

Contract Organization Name

ContractOrganizationName

DTYPE_TEXT

100

No

Used to pick from FS PickList Agreement Item - All.

Contract Revision Number

ContractRevisionNumber

DTYPE_NUMBER

22

No

Used to pick from FS PickList Agreement Item - All.

CurrencyCode

CurrencyCode

DTYPE_TEXT

20

Yes

Used to pick from Picklist Currency.

Description

Description

DTYPE_TEXT

250

No

None

Discount Amount

DiscountAmount

DTYPE_CURRENCY

22

No

None

Gross Amount

GrossAmount

DTYPE_CURRENCY

22

No

None

Id

Id

DTYPE_ID

30

No

User key field for Line Item.

Integration Id

IntegrationId

DTYPE_TEXT

30

No

User key field for Line Item.

Line Number

LineNumber

DTYPE_NUMBER

22

Yes

User key field for Line Item.

Line Quantity

LineQuantity

DTYPE_NUMBER

22

Yes

None

Line Type

LineType

DTYPE_TEXT

30

No

Used to pick from FS Invoice Line Item Type Picklist.

Order Id

OrderId

DTYPE_ID

15

No

Used to pick from Order Entry Picklist.

Order Integration Id

OrderIntegrationId

DTYPE_TEXT

30

No

Used to pick from Order Entry Picklist.

Order Item Id

OrderItemId

DTYPE_ID

15

No

Used to pick from Order Entry - Line Item Picklist.

Order Item Integration Id

OrderItemIntegrationId

DTYPE_TEXT

30

No

Used to pick from Order Entry - Line Item Picklist.

Order Line Number

OrderLineNumber

DTYPE_NUMBER

22

No

Used for picking from Order Entry - Line Item Picklist.

Order Number

OrderNumber

DTYPE_TEXT

30

No

Used to pick from Order Entry - Line Item Picklist.

Order Organization Name

OrderOrganizationName

DTYPE_TEXT

100

No

Used for picking from Order Entry - Line Item Picklist.

Order Type

OrderType

DTYPE_TEXT

50

No

Used to pick from Order Entry - Line Item Picklist.

Person Id

PersonId

DTYPE_ID

15

No

Used to pick from PS PickList Project Resource.

Product Id

ProductId

DTYPE_ID

15

No

Used to pick from Order Entry - Product PickList.

Product Integration Id

ProductIntegrationId

DTYPE_TEXT

30

No

Used to pick from Order Entry - Product PickList.

Product Name

ProductName

DTYPE_TEXT

100

No

Used to pick from Order Entry - Product PickList.

Product Organization Name

ProductOrganizationName

DTYPE_TEXT

100

No

Used to pick from Order Entry - Product PickList.

Product Vendor Organization Name

ProductVendorOrganizationName

DTYPE_TEXT

100

No

Used to pick from Order Entry - Product PickList.

Project Id

ProjectId

DTYPE_ID

15

No

Used to pick from Picklist Project.

Project Integration Id

ProjectIntegrationId

DTYPE_TEXT

30

No

Used to pick from Picklist Project.

Project Item Id

ProjectItemId

DTYPE_ID

15

No

Used to pick from Project Item PickList.

Project Item Number

ProjectItemNumber

DTYPE_TEXT

30

No

Used for picking from Project Item PickList.

Project Number

ProjectNumber

DTYPE_TEXT

30

No

Used to pick from Picklist Project.

Project Organization Name

ProjectOrganizationName

DTYPE_TEXT

100

No

Used to pick from Picklist Project.

Project Resource Id

ProjectResourceId

DTYPE_ID

15

No

Used to pick from PS PickList Project Resource.

Project Resource Number

ProjectResourceNumber

DTYPE_TEXT

30

No

Used to pick from PS PickList Project Resource.

Service Request Id

ServiceRequestId

DTYPE_ID

15

No

Used to pick from Service Request Picklist.

Service Request Number

ServiceRequestNumber

DTYPE_TEXT

64

No

Used for picking from Service Request Picklist.

Service Request Organization Name

ServiceRequestOrganizationName

DTYPE_TEXT

100

No

Used to pick from Service Request Picklist.

Surcharge Amount

SurchargeAmount

DTYPE_CURRENCY

22

No

None

Tax Amount

TaxAmount

DTYPE_CURRENCY

22

No

None

Unit of Measure

UnitofMeasure

DTYPE_TEXT

30

Yes

Bound by UNIT_OF_MEASURE LOV.

External Opportunity Create/Query/Update

The External Opportunity Create/Query/Update ASI facilitates the inbound and outbound transfer of opportunity data and associated child-level data such as contacts, notes, revenues, and activities. It is based on the Opportunity business object and supports the create, update, and query functions. The Opportunity Sharing ASIs are as follows:

The following image describes the structure of the External Opportunity Create/Query/Update ASI.

Opportunity Sharing ASI. In this image, Opportunity Message has a 1:M relationship with children: Opportunity, Channel Partner, Organization, Account, Transfer Details, and Contact Account. Opportunity has a 1:M relationship with children: Opportunity Business Address, Action, Opportunity Note, Revenue, and Contact. Contact has a 1:M relationship with its children: Contact Personal Address and Contact Business Address. Channel Partner has a 1:M relationship with its child: Channel Partner Business Address. Organization has a 1:M relationship with its child: Organization Business Address. Account has a 1:M relationship with its child: Account Business Address. Contact Account has a 1:M relationship with its child: Contact Account Business Address.

    ANI Opportunity Message (PRM ANI)

    The ANI Opportunity Message (PRM ANI) ASI is the main interface for the Opportunity Sharing ASI, which encapsulates these ASIs (Opportunity, Opportunity Account, ANI Message Header, Destination Channel Partner, and Source Organization) and the associated data contained in the ASIs.

    The following table lists the primary integration components of ANI Opportunity Message (PRM ANI) ASI.

    Integration Component XML Tag User Keys

    Account

    Account

    No user keys.

    Account_Business Address

    Account_BusinessAddress

    1. City, Country, Postal Code, State, Street Address, Street Address 2

    2. Address Name, City, Postal Code, State, Street Address

    3. City, Postal Code, State

    4. Address Name

    Action

    Action

    1. Due, Id, Type

    2. Comment, Description, Due, Type

    3. Comment, Description, Due, Type

    Channel Partner

    ChannelPartner

    • Location, Name

    Channel Partner Business Address

    ChannelPartnerAddress

    1. City, Country, Postal Code, State, Street Address, Street Address 2

    2. Account Id, Address Name, City, Postal Code, State, Street Address

    3. City, Postal Code, State

    4. Account Id, Address Name

    Contact

    Contact

    1. First Name, Id, Last Name

    2. First Name, Last Name, Middle Name, Primary Account Name

    3. Account Integration Id, First Name, Last Name, Middle Name

    4. First Name, Last Name, Middle Name

    5. First Name, Last Name

    6. Account Integration Id, First Name, Last Name, Middle Name

    7. First Name, Last Name, Middle Name, Primary Account Name

    8. First Name, Last Name, Middle Name

    Contact_Account

    Contact_Account

    • Account, Account Location

    Contact_Account_Business Address

    Contact_Account_BusinessAddress

    1. City, Country, Postal Code, State, Street Address, Street Address 2

    2. Address Name, City, Postal Code, State, Street Address

    3. City, Postal Code, State

    4. Address Name

    Contact_Personal Address

    Contact_PersonalAddress

    1. City, Country, Postal Code, State, Street Address, Street Address 2

    2. City, Country, Postal Code, State, Street Address, Street Address 2

    3. City, Postal Code, State

    4. Integration Id

    Message Details

    MessageDetails

    No user keys.

    Opportunity

    Opportunity

    1. Name

    2. Account Integration Id, Name

    3. Account, Account Location, Name

    4. Name

    Opportunity Note

    OpportunityNote

    1. Id, Note, Note Type, Oppty Name

    2. Note Type, Oppty Name

    3. Note, Note Type

    4. Note Type, Oppty Name

    5. Id, Note, Note Type, Oppty Name

    Opportunity_Business Address

    OpportunityBusinessAddress

    1. City, Country, Postal Code, State, Street Address, Street Address 2

    2. City, Postal Code, State, Street Address

    3. City, Postal Code, State

    4. City, Postal Code, State

    5. City, Country, Postal Code, State, Street Address, Street Address 2

    6. Integration Id

    Organization

    Organization

    • DUNS Number

    Organization Business Address

    OrganizationAddress

    1. City, Country, Postal Code, State, Street Address, Street Address 2

    2. City, Postal Code, State, Street Address

    3. City, Postal Code, State

    4. Account Id, Address Name

    Revenue

    Revenue

    • Revenue Item Number

    Transfer Details

    TransferDetails

    No user keys.

    Account Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Account fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Currency Code

    CurrencyCode

    DTYPE_TEXT

    15

    No

    Customer Account Group

    CustomerAccountGroup

    DTYPE_TEXT

    30

    No

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Group Type Code

    GroupTypeCode

    DTYPE_TEXT

    30

    No

    Id

    Id

    DTYPE_ID

    30

    No

    Location

    Location

    DTYPE_TEXT

    50

    No

    Name

    Name

    DTYPE_TEXT

    100

    No

    Party Type Code

    PartyTypeCode

    DTYPE_TEXT

    30

    No

    Account_Business Address Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Account_Business Address fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Address Name

    AddressName

    DTYPE_TEXT

    100

    No

    City

    City

    DTYPE_TEXT

    50

    No

    Country

    Country

    DTYPE_TEXT

    50

    No

    Email Address

    EmailAddress

    DTYPE_TEXT

    50

    No

    IsPrimaryMVG

    IsPrimaryMVG

    DTYPE_TEXT

    1

    No

    Phone Number

    PhoneNumber

    DTYPE_TEXT

    40

    No

    Postal Code

    PostalCode

    DTYPE_TEXT

    30

    No

    State

    State

    DTYPE_TEXT

    10

    No

    Street Address

    StreetAddress

    DTYPE_TEXT

    200

    No

    Street Address 2

    StreetAddress2

    DTYPE_TEXT

    100

    No

    Action Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Action fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Comment

    Comment

    DTYPE_TEXT

    1,500

    No

    Description

    Description

    DTYPE_TEXT

    100

    No

    Done

    Done

    DTYPE_TEXT

    50

    No

    Due

    Due

    DTYPE_TEXT

    50

    No

    Id

    Id

    DTYPE_ID

    30

    No

    Planned

    Planned

    DTYPE_TEXT

    50

    No

    Planned Completion

    PlannedCompletion

    DTYPE_TEXT

    50

    No

    Priority

    Priority

    DTYPE_TEXT

    30

    No

    Started

    Started

    DTYPE_TEXT

    50

    No

    Status

    Status

    DTYPE_TEXT

    50

    No

    Type

    Type

    DTYPE_TEXT

    30

    No

    Channel Partner Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Channel Partner fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Location

    Location

    DTYPE_TEXT

    50

    No

    Name

    Name

    DTYPE_TEXT

    100

    No

    Channel Partner Business Address Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Channel Partner Business Address fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Account Id

    AccountId

    DTYPE_ID

    15

    No

    Address Name

    AddressName

    DTYPE_TEXT

    100

    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

    Phone Number

    PhoneNumber

    DTYPE_TEXT

    40

    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

    Contact Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Contact fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Account Id

    AccountId

    DTYPE_ID

    15

    No

    Account Integration Id

    AccountIntegrationId

    DTYPE_TEXT

    30

    No

    Cellular Phone #

    CellularPhone

    DTYPE_TEXT

    40

    No

    Comment

    Comment

    DTYPE_TEXT

    255

    No

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Email Address

    EmailAddress

    DTYPE_TEXT

    50

    No

    Fax Phone #

    FaxPhone

    DTYPE_TEXT

    40

    No

    First Name

    FirstName

    DTYPE_TEXT

    50

    No

    Home Phone #

    HomePhone

    DTYPE_TEXT

    40

    No

    Id

    Id

    DTYPE_ID

    30

    No

    Job Title

    JobTitle

    DTYPE_TEXT

    75

    No

    Last Name

    LastName

    DTYPE_TEXT

    50

    No

    M/M

    MM

    DTYPE_TEXT

    15

    No

    Middle Name

    MiddleName

    DTYPE_TEXT

    50

    No

    Primary Account Name

    PrimaryAccountName

    DTYPE_TEXT

    100

    No

    Work Phone #

    WorkPhone

    DTYPE_TEXT

    40

    No

    Contact_Account Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Contact_Account fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Account

    Name

    DTYPE_TEXT

    100

    No

    Account Location

    Location

    DTYPE_TEXT

    50

    No

    Currency Code

    CurrencyCode

    DTYPE_TEXT

    15

    No

    Customer Account Group

    CustomerAccountGroup

    DTYPE_TEXT

    30

    No

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Group Type Code

    GroupTypeCode

    DTYPE_TEXT

    30

    No

    IsPrimaryMVG

    IsPrimaryMVG

    DTYPE_TEXT

    1

    No

    Party Type Code

    PartyTypeCode

    DTYPE_TEXT

    30

    No

    Contact_Account_Business Address Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Contact_Account_Business Address fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Address Name

    AddressName

    DTYPE_TEXT

    100

    No

    City

    City

    DTYPE_TEXT

    50

    No

    Country

    Country

    DTYPE_TEXT

    50

    No

    Email Address

    EmailAddress

    DTYPE_TEXT

    50

    No

    IsPrimaryMVG

    IsPrimaryMVG

    DTYPE_TEXT

    1

    No

    Phone Number

    PhoneNumber

    DTYPE_TEXT

    40

    No

    Postal Code

    PostalCode

    DTYPE_TEXT

    30

    No

    State

    State

    DTYPE_TEXT

    10

    No

    Street Address

    StreetAddress

    DTYPE_TEXT

    200

    No

    Street Address 2

    StreetAddress2

    DTYPE_TEXT

    100

    No

    Contact_Personal Address Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Contact_Personal Address fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Address Name

    AddressName

    DTYPE_TEXT

    100

    No

    Integration Id

    IntegrationId

    DTYPE_TEXT

    30

    No

    IsPrimaryMVG

    IsPrimaryMVG

    DTYPE_TEXT

    1

    No

    Personal City

    PersonalCity

    DTYPE_TEXT

    50

    No

    Personal Country

    PersonalCountry

    DTYPE_TEXT

    50

    No

    Personal Postal Code

    PersonalPostalCode

    DTYPE_TEXT

    30

    No

    Personal State

    PersonalState

    DTYPE_TEXT

    10

    No

    Personal Street Address

    PersonalStreetAddress

    DTYPE_TEXT

    200

    No

    Personal Street Address 2

    PersonalStreetAddress2

    DTYPE_TEXT

    100

    No

    Message Details Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Message Details fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    External Id

    ExternalId

    DTYPE_TEXT

    250

    No

    External Id Description

    ExternalIdDescription

    DTYPE_TEXT

    50

    No

    Internal Id

    InternalId

    DTYPE_TEXT

    250

    No

    Internal Id Description

    InternalIdDescription

    DTYPE_TEXT

    50

    No

    Message Generation Time Stamp

    MessageGenerationTimeStamp

    DTYPE_DATETIME

    50

    No

    Method

    Method

    DTYPE_TEXT

    50

    No

    Redirection URL

    RedirectionURL

    DTYPE_TEXT

    50

    No

    Opportunity Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Opportunity fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Account

    AccountName

    DTYPE_TEXT

    100

    No

    Account Id

    AccountId

    DTYPE_TEXT

    30

    No

    Account Integration Id

    AccountIntegrationId

    DTYPE_TEXT

    30

    No

    Account Location

    AccountLocation

    DTYPE_TEXT

    50

    No

    Currency Code

    CurrencyCode

    DTYPE_TEXT

    15

    No

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Description

    Description

    DTYPE_TEXT

    255

    No

    Id

    Id

    DTYPE_ID

    30

    No

    Name

    Name

    DTYPE_TEXT

    100

    No

    Parent Opportunity Name

    ParentOpportunityName

    DTYPE_TEXT

    100

    No

    Primary Revenue Amount

    PrimaryRevenueAmount

    DTYPE_TEXT

    22

    No

    Primary Revenue Class

    PrimaryRevenueClass

    DTYPE_TEXT

    30

    No

    Primary Revenue Close Date

    PrimaryRevenueCloseDate

    DTYPE_DATETIME

    50

    No

    Primary Revenue Type

    PrimaryRevenueType

    DTYPE_TEXT

    30

    No

    Primary Revenue Win Probability

    PrimaryRevenueWinProbability

    DTYPE_NUMBER

    22

    No

    Sales Method

    SalesMethod

    DTYPE_TEXT

    30

    No

    Sales Stage

    SalesStage

    DTYPE_TEXT

    30

    No

    Opportunity Note Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Opportunity Note fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Id

    Id

    DTYPE_ID

    30

    No

    Note

    Note

    DTYPE_NOTE

    1,000

    No

    Note Type

    NoteType

    DTYPE_TEXT

    30

    No

    Opportunity Name

    OpportunityName

    DTYPE_TEXT

    100

    No

    Opportunity_Business Address Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Opportunity_Business Address fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    City

    City

    DTYPE_TEXT

    50

    No

    Country

    Country

    DTYPE_TEXT

    50

    No

    Integration Id

    IntegrationId

    DTYPE_TEXT

    30

    No

    IsPrimaryMVG

    IsPrimaryMVG

    DTYPE_TEXT

    1

    No

    Postal Code

    PostalCode

    DTYPE_TEXT

    30

    No

    State

    State

    DTYPE_TEXT

    10

    No

    Stree Address Line 2

    StreetAddressLine2

    DTYPE_TEXT

    100

    No

    Street Address

    StreetAddress

    DTYPE_TEXT

    200

    No

    Organization Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Organization fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Id

    Id

    DTYPE_ID

    15

    No

    Name

    Name

    DTYPE_TEXT

    100

    No

    Organization Business Address Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Organization Business Address fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    City

    City

    DTYPE_TEXT

    50

    No

    Country

    Country

    DTYPE_TEXT

    50

    No

    Integration Id

    Integration Id

    DTYPE_TEXT

    30

    No

    IsPrimaryMVG

    IsPrimaryMVG

    DTYPE_TEXT

    1

    No

    Postal Code

    PostalCode

    DTYPE_TEXT

    30

    No

    State

    State

    DTYPE_TEXT

    10

    No

    Street Address

    StreetAddress

    DTYPE_TEXT

    200

    No

    Street Address 2

    StreetAddress2

    DTYPE_TEXT

    100

    No

    Revenue Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Revenue fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Account

    Account

    DTYPE_TEXT

    100

    No

    Account Location

    AccountLocation

    DTYPE_TEXT

    50

    No

    Committed

    Committed

    DTYPE_TEXT

    1

    No

    Currency Code

    CurrencyCode4

    DTYPE_TEXT

    20

    No

    Date

    Date

    DTYPE_DATETIME

    50

    No

    Description

    Description

    DTYPE_TEXT

    100

    No

    Id

    Id

    DTYPE_ID

    30

    No

    Part Number

    PartNumber

    DTYPE_TEXT

    50

    No

    Price

    Price

    DTYPE_TEXT

    22

    No

    Product

    Product

    DTYPE_TEXT

    50

    No

    Quantity

    Quantity

    DTYPE_NUMBER

    22

    No

    Revenue

    Revenue

    DTYPE_TEXT

    22

    No

    Revenue Class

    RevenueClass

    DTYPE_TEXT

    30

    No

    Revenue Item Number

    RevenueItemNumber

    DTYPE_TEXT

    30

    No

    Revenue Type

    RevenueType

    DTYPE_TEXT

    30

    No

    Summary

    Summary

    DTYPE_TEXT

    1

    No

    Win Probability

    WinProbability

    DTYPE_NUMBER

    22

    No

    Transfer Details Fields in the ANI Opportunity Message (PRM ANI) ASI

    The following table lists the Transfer Details fields and their attributes in the ANI Opportunity Message (PRM ANI) ASI.

    Name XML Tag Data Type Length Req.

    Transfer Date

    TransferDate

    DTYPE_DATETIME

    50

    No

    Transfer Recipient

    TransferRecipient

    DTYPE_TEXT

    20

    No

    Transfer Status

    TransferStatus

    DTYPE_TEXT

    50

    No

    Transfer Status Message

    TransferStatusMessage

    DTYPE_TEXT

    200

    No

      ANI Message Header (PRM ANI)

      The ANI Message Header ASI (PRM ANI) encapsulates information related to the exchange of the Opportunity Sharing message, such as whether the creation or update of the opportunity was successful.

      The following table lists the primary integration components of ANI Message Header (PRM ANI).

      Integration Component XML Tag User Keys

      Message Details

      MessageDetails

      No user keys.

      Transfer Details

      TransferDetails

      No user keys.

      Message Details Fields in the ANI Message Header (PRM ANI) ASI

      The following table lists the Message Details fields and their attributes in the ANI Message Header (PRM ANI) ASI.

      Name XML Tag Data Type Length Req.

      External Id

      ExternalId

      DTYPE_TEXT

      N/A

      No

      External Id Description

      ExternalIdDescription

      DTYPE_TEXT

      N/A

      No

      Internal Id

      InternalId

      DTYPE_TEXT

      N/A

      No

      Internal Id Description

      InternalIdDescription

      DTYPE_TEXT

      N/A

      No

      Message Generation Time Stamp

      MessageGenerationTimeStamp

      DTYPE_DATETIME

      N/A

      No

      Method

      Method

      DTYPE_TEXT

      N/A

      No

      Redirection URL

      RedirectionURL

      DTYPE_TEXT

      N/A

      No

      Transfer Details Fields in the ANI Message Header (PRM ANI) ASI

      The following table lists the Transfer Details fields and their attributes in the ANI Message Header (PRM ANI) ASI.

      Name XML Tag Data Type Length Req.

      Transfer Date

      TransferDate

      DTYPE_DATETIME

      N/A

      No

      Transfer Recipient

      TransferRecipient

      DTYPE_TEXT

      N/A

      No

      Transfer Status

      TransferStatus

      DTYPE_TEXT

      N/A

      No

      Transfer Status Message

      TransferStatusMessage

      DTYPE_TEXT

      N/A

      No

        Opportunity (PRM ANI)

        The Opportunity (PRM ANI) ASI encapsulates all the data that is directly related to the Opportunity object. This data includes fields such as Opportunity Name, Status, and so on.

        The following table lists the primary integration components of Opportunity (PRM ANI).

        Integration Component XML Tag User Keys

        Action

        Action

        1. Due, Id, Type

        2. Comment, Description, Due, Type

        3. Comment, Description, Due, Type

        Contact

        Contact

        1. DUNS Number, First Name, ID, Last Name, Middle Name

        2. DUNS Number, First Name, Last Name, Middle Name

        3. First Name, Last Name, Middle Name, Primary Account Name

        4. First Name, Last Name, Middle Name, Primary Account Name

        5. First Name, Last Name

        Contact_Account

        Contact_Account

        • Account, Account Location

        Contact_Account_Business Address

        Contact_Account_BusinessAddress

        1. City, Country, Postal Code, State, Street Address, Street Address 2

        2. Address Name, City, Postal Code, State, Street Address

        3. City, Postal Code, State

        4. Address Name

        Contact_Personal Address

        Contact_PersonalAddress

        1. City, Country, Postal Code, State, Street Address, Street Address 2

        2. Address Name, City, Postal Code, State, Street Address

        3. City, Integration Id, Postal Code, State

        4. Integration Id

        Opportunity

        Opportunity

        • Name

        Opportunity Note

        OpportunityNote

        1. Note, Note Type, Oppty Name

        2. Note Type, Oppty Name

        3. Note, Note Type

        4. Note Type

        5. Id

        Opportunity_Business Address

        OpportunityBusinessAddress

        1. Address Name, City, Country, Postal Code, State, Street Address, Street Address 2

        2. City, Postal Code, State, Street Address

        3. City, Integration Id, Postal Code, State

        4. Integration Id

        Revenue

        Revenue

        • Revenue Item Number

        Action Fields in Opportunity (PRM ANI) ASI

        The following table lists the Action fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Comment

        Comment

        DTYPE_TEXT

        1,500

        No

        Description

        Description

        DTYPE_TEXT

        100

        No

        Done

        Done

        DTYPE_TEXT

        50

        No

        Due

        Due

        DTYPE_TEXT

        50

        No

        Id

        Id

        DTYPE_ID

        30

        No

        Planned

        Planned

        DTYPE_TEXT

        50

        No

        Planned Completion

        PlannedCompletion

        DTYPE_TEXT

        50

        No

        Priority

        Priority

        DTYPE_TEXT

        30

        No

        Started

        Started

        DTYPE_TEXT

        50

        No

        Status

        Status

        DTYPE_TEXT

        30

        No

        Type

        Type

        DTYPE_TEXT

        30

        No

        Contact Fields in Opportunity (PRM ANI) ASI

        The following table lists the Contact fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Account Id

        AccountId

        DTYPE_ID

        15

        No

        Account Integration Id

        AccountIntegrationId

        DTYPE_TEXT

        30

        No

        Cellular Phone #

        CellularPhone

        DTYPE_TEXT

        40

        No

        Comment

        Comment

        DTYPE_TEXT

        255

        No

        DUNS Number

        DUNSNumber

        DTYPE_TEXT

        15

        No

        Email Address

        EmailAddress

        DTYPE_TEXT

        50

        No

        Fax Phone #

        FaxPhone

        DTYPE_TEXT

        40

        No

        First Name

        FirstName

        DTYPE_TEXT

        50

        No

        Home Phone #

        HomePhone

        DTYPE_TEXT

        40

        No

        Id

        Id

        DTYPE_ID

        30

        No

        Job Title

        JobTitle

        DTYPE_TEXT

        75

        No

        Last Name

        LastName

        DTYPE_TEXT

        50

        No

        M/M

        MM

        DTYPE_TEXT

        15

        No

        Middle Name

        MiddleName

        DTYPE_TEXT

        50

        No

        Primary Account Name

        PrimaryAccountName

        DTYPE_TEXT

        100

        No

        Work Phone #

        WorkPhone

        DTYPE_TEXT

        40

        No

        Contact_Account Fields in Opportunity (PRM ANI) ASI

        The following table lists the Contact_Account fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Account

        Name

        DTYPE_TEXT

        100

        No

        Account Location

        Location

        DTYPE_TEXT

        50

        No

        Currency Code

        CurrencyCode

        DTYPE_TEXT

        15

        No

        Customer Account Group

        CustomerAccountGroup

        DTYPE_TEXT

        30

        No

        DUNS Number

        DUNSNumber

        DTYPE_TEXT

        15

        No

        Group Type Code

        GroupTypeCode

        DTYPE_TEXT

        30

        No

        IsPrimaryMVG

        IsPrimaryMVG

        DTYPE_TEXT

        1

        No

        Party Type Code

        PartyTypeCode

        DTYPE_TEXT

        30

        No

        Contact_Account_Business Address Fields in Opportunity (PRM ANI) ASI

        The following table lists the Contact_Account_Business Address fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Address Name

        AddressName

        DTYPE_TEXT

        100

        No

        City

        City

        DTYPE_TEXT

        50

        No

        Country

        Country

        DTYPE_TEXT

        50

        No

        Email Address

        EmailAddress

        DTYPE_TEXT

        50

        No

        IsPrimaryMVG

        IsPrimaryMVG

        DTYPE_TEXT

        1

        No

        Phone Number

        PhoneNumber

        DTYPE_TEXT

        40

        No

        Postal Code

        PostalCode

        DTYPE_TEXT

        30

        No

        State

        State

        DTYPE_TEXT

        10

        No

        Street Address

        StreetAddress

        DTYPE_TEXT

        200

        No

        Street Address 2

        StreetAddress2

        DTYPE_TEXT

        100

        No

        Contact_Personal Address Fields in Opportunity (PRM ANI) ASI

        The following table lists the Contact_Personal Address fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Address Name

        AddressName

        DTYPE_TEXT

        100

        No

        Integration Id

        IntegrationId

        DTYPE_TEXT

        30

        No

        IsPrimaryMVG

        IsPrimaryMVG

        DTYPE_TEXT

        1

        No

        Personal City

        PersonalCity

        DTYPE_TEXT

        50

        No

        Personal Country

        PersonalCountry

        DTYPE_TEXT

        50

        No

        Personal Postal Code

        PersonalPostalCode

        DTYPE_TEXT

        30

        No

        Personal State

        PersonalState

        DTYPE_TEXT

        10

        No

        Personal Street Address

        PersonalStreetAddress

        DTYPE_TEXT

        200

        No

        Personal Street Address 2

        PersonalStreetAddress2

        DTYPE_TEXT

        100

        No

        Opportunity Fields in Opportunity (PRM ANI) ASI

        The following table lists the Opportunity fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Account

        AccountName

        DTYPE_TEXT

        100

        No

        Account Integration Id

        AccountIntegrationId

        DTYPE_TEXT

        30

        No

        Account Location

        AccountLocation

        DTYPE_TEXT

        50

        No

        Currency Code

        CurrencyCode

        DTYPE_TEXT

        15

        No

        DUNS Number

        DUNSNumber

        DTYPE_TEXT

        15

        No

        Description

        Description

        DTYPE_TEXT

        255

        No

        Id

        Id

        DTYPE_ID

        30

        No

        Name

        Name

        DTYPE_TEXT

        100

        No

        Parent Opportunity Name

        ParentOpportunityName

        DTYPE_TEXT

        100

        No

        Primary Revenue Amount

        PrimaryRevenueAmount

        DTYPE_TEXT

        22

        No

        Primary Revenue Class

        PrimaryRevenueClass

        DTYPE_TEXT

        30

        No

        Primary Revenue Close Date

        PrimaryRevenueCloseDate

        DTYPE_DATETIME

        50

        No

        Primary Revenue Type

        PrimaryRevenueType

        DTYPE_TEXT

        30

        No

        Primary Revenue Win Probability

        PrimaryRevenueWinProbability

        DTYPE_NUMBER

        22

        No

        Sales Method

        SalesMethod

        DTYPE_TEXT

        30

        No

        Sales Stage

        SalesStage

        DTYPE_TEXT

        30

        No

        Opportunity Note Fields in Opportunity (PRM ANI) ASI

        The following table lists the Opportunity Note fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Id

        Id

        DTYPE_ID

        30

        No

        Note

        Note

        DTYPE_NOTE

        1,000

        No

        Note Type

        NoteType

        DTYPE_TEXT

        30

        No

        Opportunity Name

        OpportunityName

        DTYPE_TEXT

        100

        No

        Opportunity_Business Address Fields in Opportunity (PRM ANI) ASI

        The following table lists the Opportunity_Business Address fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Address Name

        AddressName

        DTYPE_TEXT

        50

        No

        City

        City

        DTYPE_TEXT

        50

        No

        Country

        Country

        DTYPE_TEXT

        50

        No

        Integration Id

        IntegrationId

        DTYPE_TEXT

        30

        No

        IsPrimaryMVG

        IsPrimaryMVG

        DTYPE_TEXT

        1

        No

        Postal Code

        PostalCode

        DTYPE_TEXT

        30

        No

        State

        State

        DTYPE_TEXT

        10

        No

        Stree Address Line 2

        StreeAddressLine2

        DTYPE_TEXT

        100

        No

        Street Address

        StreetAddress

        DTYPE_TEXT

        200

        No

        Revenue Fields in Opportunity (PRM ANI) ASI

        The following table lists the Revenue fields and their attributes in the Opportunity (PRM ANI) ASI.

        Name XML Tag Data Type Length Req.

        Account

        Account

        DTYPE_TEXT

        100

        No

        Account Location

        AccountLocation

        DTYPE_TEXT

        50

        No

        Committed

        Committed

        DTYPE_TEXT

        1

        No

        Currency Code

        CurrencyCode

        DTYPE_TEXT

        20

        No

        Date

        Date

        DTYPE_DATETIME

        50

        No

        Description

        Description

        DTYPE_TEXT

        100

        No

        Id

        Id

        DTYPE_ID

        30

        No

        Part Number

        PartNumber

        DTYPE_TEXT

        50

        No

        Price

        Price

        DTYPE_TEXT

        22

        No

        Product

        Product

        DTYPE_TEXT

        50

        No

        Quantity

        Quantity

        DTYPE_NUMBER

        22

        No

        Revenue

        Revenue

        DTYPE_TEXT

        22

        No

        Revenue Class

        RevenueClass

        DTYPE_TEXT

        30

        No

        Revenue Item Number

        RevenueItemNumber

        DTYPE_TEXT

        30

        No

        Revenue Type

        RevenueType

        DTYPE_TEXT

        30

        No

        Summary

        Summary

        DTYPE_TEXT

        1

        No

        Win Probability

        WinProbability

        DTYPE_NUMBER

        22

        No

          Destination Channel Partner (PRM ANI)

          The Destination Channel Partner (PRM ANI) ASI encapsulates information related to the partner company with which the opportunity is being shared. Examples of this information include Partner DUNS Number and Company Name.

          The following table lists the primary integration components of Destination Channel Partner (PRM ANI).

          Integration Component XML Tag User Keys

          Channel Partner

          ChannelPartner

          • Location, Name

          Channel Partner Business Address

          ChannelPartnerAddress

          • Account Id, Address Name

          Channel Partner Fields in Destination Channel Partner (PRM ANI) ASI

          The following table lists the Channel Partner fields and their attributes in the Destination Channel Partner (PRM ANI) ASI.

          Name XML Tag Data Type Length Required

          DUNS Number

          DUNSNumber

          DTYPE_TEXT

          15

          No

          Location

          Location

          DTYPE_TEXT

          50

          No

          Name

          Name

          DTYPE_TEXT

          100

          No

          Channel Partner Business Address Fields in Destination Channel Partner (PRM ANI) ASI

          The following table lists the Channel Partner Business Address fields and their attributes in the Destination Channel Partner (PRM ANI) ASI.

          Name XML Tag Data Type Length Required

          Account Id

          AccountId

          DTYPE_ID

          15

          No

          Address Name

          AddressName

          DTYPE_TEXT

          100

          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

          Phone Number

          PhoneNumber

          DTYPE_TEXT

          N/A

          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

            Source Organization (PRM ANI)

            The Source Organization (PRM ANI) ASI encapsulates information related to the source company that is initiating the create or update opportunity message. Examples of this information include Partner DUNS Number, Company Name, and so on.

            The following table lists the primary integration components of Source Organization (PRM ANI).

            Integration Component XML Tag User Keys

            Organization

            Organization

            • DUNS Number

            Organization Business Address

            OrganizationAddress

            • Account Id, Address Name

            Organization Fields in Source Organization (PRM ANI) ASI

            The following table lists the Organization fields and their attributes in the Source Organization (PRM ANI) ASI.

            Name XML Tag Data Type Length Required

            DUNS Number

            DUNSNumber

            DTYPE_TEXT

            15

            No

            Id

            Id

            DTYPE_ID

            15

            No

            Name

            Name

            DTYPE_TEXT

            100

            No

            Organization Business Address Fields in Source Organization (PRM ANI) ASI

            The following table lists the Organization Business Address fields and their attributes in the Source Organization (PRM ANI) ASI.

            Name XML Tag Data Type Length Required

            Account Id

            AccountId

            DTYPE_ID

            15

            No

            Address Name

            AddressName

            DTYPE_TEXT

            100

            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

            Phone Number

            PhoneNumber

            DTYPE_TEXT

            N/A

            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

              Opportunity Account (PRM ANI)

              The Opportunity Account (PRM ANI) ASI encapsulates account-related information for all the opportunity accounts identified in the opportunity message.

              The following table lists the primary integration components of Opportunity Account (PRM ANI).

              Integration Component XML Tag User Keys

              Account

              Account

              • Location, Name

              Account Business Address

              Account_BusinessAddress

              1. City, Country, Postal Code, State, Street Address, Street Address 2

              2. Address Name, City, Postal Code, State, Street Address

              3. City, Postal Code, State

              4. Address Name

              AccountFields in Opportunity Account (PRM ANI) ASI

              The following table lists the Account fields and their attributes in the Opportunity Account (PRM ANI) ASI.

              Name XML Tag Data Type Length Required

              Currency Code

              CurrencyCode

              DTYPE_TEXT

              15

              No

              Customer Account Group

              CustomerAccountGroup

              DTYPE_TEXT

              30

              No

              DUNS Number

              DUNSNumber

              DTYPE_TEXT

              15

              No

              Group Type Code

              GroupTypeCode

              DTYPE_TEXT

              30

              No

              Id

              Id

              DTYPE_ID

              30

              No

              Location

              Location

              DTYPE_TEXT

              50

              No

              Name

              Name

              DTYPE_TEXT

              100

              No

              Party Type Code

              PartyTypeCode

              DTYPE_TEXT

              30

              No

              Account Business Address Fields in Opportunity Account (PRM ANI) ASI

              The following table lists the Account Business Address fields and their attributes in the Opportunity Account (PRM ANI) ASI.

              Name XML Tag Data Type Length Required

              Address Name

              AddressName

              DTYPE_TEXT

              100

              No

              City

              City

              DTYPE_TEXT

              50

              No

              Country

              Country

              DTYPE_TEXT

              50

              No

              Email Address

              EmailAddress

              DTYPE_TEXT

              50

              No

              IsPrimaryMVG

              IsPrimaryMVG

              DTYPE_TEXT

              1

              No

              Phone Number

              PhoneNumber

              DTYPE_TEXT

              40

              No

              Postal Code

              PostalCode

              DTYPE_TEXT

              30

              No

              State

              State

              DTYPE_TEXT

              10

              No

              Street Address

              StreetAddress

              DTYPE_TEXT

              200

              No

              Street Address 2

              StreetAddress2

              DTYPE_TEXT

              100

              No

                Siebel Order

                The Siebel Order ASI allows customers to accurately capture and validate orders in order to submit them to a fulfillment system. The following image describes the structure of the Siebel Order ASI.

                Siebel Order ASI. In this image, Orders has a 1:M relationship with its children: Related Shipment, Related Sales Rep, Related Organization, Line Items, and Payments. Related Shipment has a 1:M relationship with its child: Shipment Item. Line Items has a 1:M relationship with its children: Attributes, Requested Schedule Lines, and Promised Schedule Lines.

                The following table lists the integration components of this ASI.

                Integration Component XML Tag User Keys

                Attributes

                Attributes

                1. Id

                2. Integration Id

                3. Name

                Line Items

                LineItems

                1. Id

                2. Integration Id

                3. Line Number

                Orders

                Orders

                1. Id

                2. Integration Id

                3. Order Number, Order Type, Primary Organization, Revision

                4. External Order Number

                5. Order Number, Order Type, Organization DUNS Number, Revision

                Payments

                Payments

                1. Id

                2. Integration Id

                3. Payment Number, Payment Type

                Promised Schedule Lines

                PromisedScheduleLines

                1. Id

                2. Integration Id

                3. Line Item Action Number

                Related Organization

                RelatedOrganization

                1. Id

                2. Integration Id

                3. Name

                Related Sales Rep

                RelatedSalesRep

                1. Id

                2. Integration Id

                3. Position Name

                4. Login

                Related Shipment

                RelatedShipment

                1. Id

                2. Integration Id

                3. Shipment Number

                Requested Schedule Lines

                RequestedScheduleLines

                1. Id

                2. Integration Id

                3. Line Number

                Shipment Item

                ShipmentItem

                1. Id

                2. Integration Id

                3. Line Number

                The Siebel Order ASI uses the same user keys as the Orders integration component. You can use the component fields for the integration, which means that values for each of these fields can be written to an XML file for transport.

                Attributes Fields in Siebel Order ASI

                The following table lists the Attribute fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Action Code

                ActionCode

                DTYPE_TEXT

                30

                No

                Attribute Id

                AttributeId

                DTYPE_ID

                NA

                No

                Data Type

                DataType

                DTYPE_TEXT

                30

                No

                Description

                Description

                DTYPE_TEXT

                255

                No

                Hidden

                Hidden

                DTYPE_TEXT

                NA

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                LOV Type

                ListOfValueType

                DTYPE_TEXT

                30

                No

                Name

                Name

                DTYPE_TEXT

                75

                No

                Object Id

                ObjectId

                DTYPE_ID

                NA

                No

                Read Only

                ReadOnly

                DTYPE_TEXT

                NA

                No

                Required

                Required

                DTYPE_TEXT

                NA

                No

                Sequence

                Sequence

                DTYPE_NUMBER

                NA

                No

                Validation

                Validation

                DTYPE_TEXT

                250

                No

                Value

                Value

                DTYPE_TEXT

                100

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Line Items Fields in Siebel Order ASI

                The following table lists the Line Items fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Action Code

                ActionCode

                DTYPE_TEXT

                30

                No

                Asset Id

                AssetId

                DTYPE_ID

                NA

                No

                Asset Integration Id

                AssetIntegrationId

                DTYPE_TEXT

                30

                No

                Asset Number

                AssetNumber

                DTYPE_TEXT

                NA

                No

                Available Date

                AvailableDate

                DTYPE_TEXT

                NA

                No

                Available Quantity

                AvailableQuantity

                DTYPE_NUMBER

                NA

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                30

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Base Price

                BasePrice

                DTYPE_TEXT

                NA

                No

                Billable Flag

                BillableFlag

                DTYPE_TEXT

                NA

                No

                Billing Account Id

                BillingAccountId

                DTYPE_ID

                NA

                No

                Cancelled Quantity

                CancelledQuantity

                DTYPE_NUMBER

                NA

                No

                Carrier Priority

                CarrierPriority

                DTYPE_TEXT

                30

                No

                Covered Product Unit Price

                CoveredProductUnitPrice

                DTYPE_TEXT

                NA

                No

                Delivery Status

                DeliveryStatus

                DTYPE_TEXT

                30

                No

                Description

                Description

                DTYPE_TEXT

                NA

                No

                Destination Inventory Location

                DestinationInventoryLocation

                DTYPE_TEXT

                100

                No

                Destination Inventory Location Id

                DestinationInventoryLocationId

                DTYPE_ID

                NA

                No

                Destination Inventory Location Integration Id

                DestinationInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Discount Amount

                DiscountAmount

                DTYPE_TEXT

                NA

                No

                Extended Quantity

                ExtendedQuantity

                DTYPE_NUMBER

                NA

                No

                Freight Amount

                FreightAmount

                DTYPE_TEXT

                NA

                No

                Has Children

                HasChildren

                DTYPE_TEXT

                NA

                No

                Hold Flag

                HoldFlag

                DTYPE_TEXT

                NA

                No

                Hold Reason

                HoldReason

                DTYPE_TEXT

                30

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Integration Status

                IntegrationStatus

                DTYPE_TEXT

                30

                No

                Integration Status As Of Date

                IntegrationStatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Invoiced Quantity

                InvoicedQuantity

                DTYPE_NUMBER

                NA

                No

                IsComplexProduct

                IsComplexProduct

                DTYPE_TEXT

                NA

                No

                Item Price

                ItemPrice

                DTYPE_TEXT

                NA

                No

                Line Number

                LineNumber

                DTYPE_NUMBER

                NA

                No

                Loaner Flag

                LoanerFlag

                DTYPE_TEXT

                NA

                No

                Net Price

                NetPrice

                DTYPE_TEXT

                NA

                No

                Note

                Note

                DTYPE_TEXT

                1,500

                No

                Order Header Id

                OrderHeaderId

                DTYPE_ID

                NA

                No

                Order Number

                OrderNumber

                DTYPE_TEXT

                30

                No

                Package Name (Inbound)

                PackageNameInbound

                DTYPE_TEXT

                50

                No

                Package Name (Outbound)

                PackageNameOutbound

                DTYPE_TEXT

                NA

                No

                Parent Order Item Id

                ParentOrderItemId

                DTYPE_ID

                NA

                No

                Parent Order Item Number

                ParentOrderItemNumber

                DTYPE_NUMBER

                NA

                No

                Part Number

                PartNumber

                DTYPE_TEXT

                50

                No

                Partial Ship

                PartialShip

                DTYPE_TEXT

                NA

                No

                Product

                Product

                DTYPE_TEXT

                100

                No

                Product Global Identifier

                ProductGlobalIdentifier

                DTYPE_TEXT

                50

                No

                Product Id

                ProductId

                DTYPE_ID

                NA

                No

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                30

                No

                Product Port Id

                ProductPortId

                DTYPE_ID

                15

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                NA

                No

                Requested Quantity

                RequestedQuantity

                DTYPE_NUMBER

                NA

                No

                Return To Account DUNS Number

                ReturnToAccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Return To Account Id

                ReturnToAccountId

                DTYPE_ID

                NA

                No

                Return To Account Integration Id

                ReturnToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Return To Account Name

                ReturnToAccountName

                DTYPE_TEXT

                100

                No

                Return To Account Site

                ReturnToAccountSite

                DTYPE_TEXT

                50

                No

                Return To Address Id

                ReturnToAddressId

                DTYPE_ID

                NA

                No

                Return To Address Integration Id

                ReturnToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Return To Contact Id

                ReturnToContactId

                DTYPE_ID

                NA

                No

                Return To Contact Integration Id

                ReturnToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Return To First Name

                ReturnToFirstName

                DTYPE_TEXT

                50

                No

                Return To Last Name

                ReturnToLastName

                DTYPE_TEXT

                50

                No

                Rollup Item Price

                RollupItemPrice

                DTYPE_TEXT

                NA

                No

                Root Order Item Id

                RootOrderItemId

                DTYPE_ID

                NA

                No

                Sales Unit of Measure

                SalesUnitofMeasure

                DTYPE_TEXT

                30

                No

                Ship Complete

                ShipComplete

                DTYPE_TEXT

                NA

                No

                Ship Date

                ShipDate

                DTYPE_DATETIME

                NA

                No

                Ship Instruction

                ShipInstruction

                DTYPE_TEXT

                250

                No

                Ship Quantity

                ShipQuantity

                DTYPE_NUMBER

                NA

                No

                Ship To Account

                ShipToAccount

                DTYPE_TEXT

                100

                No

                Ship To Account DUNS Number

                ShipToAccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Ship To Account Id

                ShipToAccountId

                DTYPE_ID

                NA

                No

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Ship To Account Site

                ShipToAccountSite

                DTYPE_TEXT

                50

                No

                Ship To Address

                ShipToAddress

                DTYPE_TEXT

                50

                No

                Ship To Address 2

                ShipToAddress2

                DTYPE_TEXT

                50

                No

                Ship To Address Id

                ShipToAddressId

                DTYPE_ID

                NA

                No

                Ship To City

                ShipToCity

                DTYPE_TEXT

                30

                No

                Ship To Contact - First Name

                ShipToContact-FirstName

                DTYPE_TEXT

                50

                No

                Ship To Contact - Last Name

                ShipToContact-LastName

                DTYPE_TEXT

                50

                No

                Ship To Contact Id

                ShipToContactId

                DTYPE_ID

                NA

                No

                Ship To Contact Integration Id

                ShipToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Ship To Country

                ShipToCountry

                DTYPE_TEXT

                15

                No

                Ship To State

                ShipToState

                DTYPE_TEXT

                15

                No

                Ship To Zip

                ShipToZip

                DTYPE_TEXT

                15

                No

                Ship to Address Integration Id

                ShiptoAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Shipping Carrier

                ShippingCarrier

                DTYPE_TEXT

                30

                No

                Shipping Charges

                ShippingCharges

                DTYPE_TEXT

                NA

                No

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                30

                No

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                30

                No

                Single Source

                SingleSource

                DTYPE_TEXT

                NA

                No

                Smart Part Number

                SmartPartNumber

                DTYPE_TEXT

                250

                No

                Source Inventory Loc Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                NA

                No

                Start Price

                StartPrice

                DTYPE_TEXT

                NA

                No

                Status

                Status

                DTYPE_TEXT

                30

                No

                Status As Of Date

                StatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Tax Amount

                TaxAmount

                DTYPE_TEXT

                NA

                No

                Unit Price

                UnitPrice

                DTYPE_TEXT

                NA

                No

                Unit of Measure

                UnitofMeasure

                DTYPE_TEXT

                30

                No

                Volume

                Volume

                DTYPE_NUMBER

                NA

                No

                Volume Unit of Measure

                VolumeUnitofMeasure

                DTYPE_TEXT

                30

                No

                Weight

                Weight

                DTYPE_NUMBER

                NA

                No

                Weight Unit of Measure

                WeightUnitofMeasure

                DTYPE_TEXT

                30

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Orders Fields in Siebel Order ASI

                The following table lists the Orders fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Account

                Account

                DTYPE_TEXT

                100

                No

                Account DUNS Number

                AccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Account Id

                AccountId

                DTYPE_ID

                NA

                No

                Account Integration Id

                AccountIntegrationId

                DTYPE_TEXT

                30

                No

                Account Site

                AccountSite

                DTYPE_TEXT

                100

                No

                Active

                Active

                DTYPE_TEXT

                NA

                No

                Approved

                Approved

                DTYPE_TEXT

                NA

                No

                Approved By

                ApprovedBy

                DTYPE_TEXT

                NA

                No

                Approved By Date

                ApprovedByDate

                DTYPE_TEXT

                NA

                No

                Available Date

                AvailableDate

                DTYPE_TEXT

                NA

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                30

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Bill To - First Name

                BillTo-FirstName

                DTYPE_TEXT

                50

                No

                Bill To - Last Name

                BillTo-LastName

                DTYPE_TEXT

                50

                No

                Bill To Account

                BillToAccount

                DTYPE_TEXT

                100

                No

                Bill To Account DUNS Number

                BillToAccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Bill To Account Id

                BillToAccountId

                DTYPE_ID

                NA

                No

                Bill To Account Integration Id

                BillToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Bill To Account Site

                BillToAccountSite

                DTYPE_TEXT

                50

                No

                Bill To Address

                BillToAddress

                DTYPE_TEXT

                50

                No

                Bill To Address 2

                BillToAddress2

                DTYPE_TEXT

                50

                No

                Bill To Address Id

                BillToAddressId

                DTYPE_ID

                NA

                No

                Bill To Address Integration Id

                BillToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Bill To City

                BillToCity

                DTYPE_TEXT

                30

                No

                Bill To Contact Id

                BillToContactId

                DTYPE_ID

                NA

                No

                Bill To Contact Integration Id

                BillToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Bill To Country

                BillToCountry

                DTYPE_TEXT

                15

                No

                Bill To State

                BillToState

                DTYPE_TEXT

                30

                No

                Bill To Zip

                BillToZip

                DTYPE_TEXT

                15

                No

                Billable Flag

                BillableFlag

                DTYPE_TEXT

                NA

                No

                Billing Block

                BillingBlock

                DTYPE_TEXT

                30

                No

                Campaign Id

                CampaignId

                DTYPE_ID

                NA

                No

                Campaign Integration Id

                CampaignIntegrationId

                DTYPE_TEXT

                30

                No

                Campaign Name

                CampaignName

                DTYPE_TEXT

                100

                No

                Carrier

                Carrier

                DTYPE_TEXT

                30

                No

                Carrier Priority

                CarrierPriority

                DTYPE_TEXT

                30

                No

                Comments

                Comments

                DTYPE_TEXT

                250

                No

                Contact First Name

                ContactFirstName

                DTYPE_TEXT

                50

                No

                Contact Id

                ContactId

                DTYPE_ID

                NA

                No

                Contact Integration Id

                ContactIntegrationId

                DTYPE_TEXT

                30

                No

                Contact Last Name

                ContactLastName

                DTYPE_TEXT

                50

                No

                Contract Id

                ContractId

                DTYPE_ID

                NA

                No

                Contract Integration Id

                ContractIntegrationId

                DTYPE_TEXT

                30

                No

                Contract Name

                ContractName

                DTYPE_TEXT

                50

                No

                Credit Status

                CreditStatus

                DTYPE_TEXT

                NA

                No

                Currency Code

                CurrencyCode

                DTYPE_TEXT

                20

                No

                Delivery Status

                DeliveryStatus

                DTYPE_TEXT

                30

                No

                Description

                Description

                DTYPE_TEXT

                255

                No

                Destination Inventory Id

                DestinationInventoryLocationId

                DTYPE_ID

                NA

                No

                Destination Inventory Location

                DestinationInventoryLocation

                DTYPE_TEXT

                100

                No

                Destination Inventory Location Integration Id

                DestinationInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Discount Amount

                DiscountAmount

                DTYPE_TEXT

                NA

                No

                Entitlement Id

                EntitlementId

                DTYPE_ID

                NA

                No

                Entitlement Name

                EntitlementName

                DTYPE_TEXT

                50

                No

                External Order Number

                ExternalOrderNumber

                DTYPE_TEXT

                NA

                No

                Hold Flag

                HoldFlag

                DTYPE_TEXT

                NA

                No

                Hold Reason

                HoldReason

                DTYPE_TEXT

                30

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Integration Message

                IntegrationMessage

                DTYPE_TEXT

                2,000

                No

                Integration Status

                IntegrationStatus

                DTYPE_TEXT

                30

                No

                Integration Status As Of Date

                IntegrationStatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Opportunity Id

                OpportunityId

                DTYPE_ID

                NA

                No

                Opportunity Integration Id

                OpportunityIntegrationId

                DTYPE_TEXT

                30

                No

                Opportunity Name

                OpportunityName

                DTYPE_TEXT

                100

                No

                Order Date

                OrderDate

                DTYPE_TEXT

                NA

                No

                Order Number

                OrderNumber

                DTYPE_TEXT

                30

                No

                Order Priority

                OrderPriority

                DTYPE_TEXT

                30

                No

                Order Type

                OrderType

                DTYPE_TEXT

                30

                No

                Order Type Id

                OrderTypeId

                DTYPE_ID

                NA

                No

                Organization DUNS Number

                OrganizationDUNSNumber

                DTYPE_TEXT

                9

                No

                Parent Order Id

                ParentOrderId

                DTYPE_ID

                NA

                No

                Partial Ship

                PartialShip

                DTYPE_TEXT

                NA

                No

                Pay To Account

                PayToAccount

                DTYPE_TEXT

                100

                No

                Pay To Account DUNS Number

                PayToAccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Pay To Account Id

                PayToAccountId

                DTYPE_ID

                NA

                No

                Pay To Account Integration Id

                PayToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Pay To Account Site

                PayToAccountSite

                DTYPE_TEXT

                50

                No

                Pay To Address Id

                PayToAddressId

                DTYPE_ID

                NA

                No

                Pay To Address Integration Id

                PayToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Pay To Contact First Name

                PayToContactFirstName

                DTYPE_TEXT

                50

                No

                Pay To Contact Id

                PayToContactId

                DTYPE_ID

                NA

                No

                Pay To Contact Integration Id

                PayToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Pay To Contact Last Name

                PayToContactLastName

                DTYPE_TEXT

                50

                No

                Payment Term

                PaymentTerm

                DTYPE_TEXT

                50

                No

                Payment Term Id

                PaymentTermId

                DTYPE_ID

                NA

                No

                Payment Term Integration Id

                PaymentTermIntegrationId

                DTYPE_TEXT

                30

                No

                Price List

                PriceList

                DTYPE_TEXT

                50

                No

                Price List Id

                PriceListId

                DTYPE_ID

                NA

                No

                Price List Integration Id

                PriceListIntegrationId

                DTYPE_TEXT

                30

                No

                Pricing Date

                PricingDate

                DTYPE_TEXT

                NA

                No

                Primary Organization

                PrimaryOrganization

                DTYPE_TEXT

                100

                No

                Primary Organization Id

                PrimaryOrganizationId

                DTYPE_ID

                NA

                No

                Project Id

                ProjectId

                DTYPE_ID

                NA

                No

                Project Integration Id

                ProjectIntegrationId

                DTYPE_TEXT

                30

                No

                Project Name

                ProjectName

                DTYPE_TEXT

                100

                No

                Promotion Id

                PromotionId

                DTYPE_ID

                NA

                No

                Purchase Order Number

                PurchaseOrderNumber

                DTYPE_TEXT

                50

                No

                Quote Id

                QuoteId

                DTYPE_ID

                NA

                No

                Quote Integration Id

                QuoteIntegrationId

                DTYPE_TEXT

                30

                No

                Quote Number

                QuoteNumber

                DTYPE_TEXT

                30

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                NA

                No

                Return Reason

                ReturnReason

                DTYPE_TEXT

                30

                No

                Return To Account

                ReturnToAccount

                DTYPE_TEXT

                100

                No

                Return To Account DUNS Number

                ReturnToAccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Return To Account Id

                ReturnToAccountId

                DTYPE_ID

                NA

                No

                Return To Account Integration Id

                ReturnToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Return To Account Site

                ReturnToAccountSite

                DTYPE_TEXT

                50

                No

                Return To Address Id

                ReturnToAddressId

                DTYPE_ID

                NA

                No

                Return To Address Integration Id

                ReturnToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Return To Contact First Name

                ReturnToContactFirstName

                DTYPE_TEXT

                50

                No

                Return To Contact Id

                ReturnToContactId

                DTYPE_ID

                NA

                No

                Return To Contact Integration Id

                ReturnToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Return To Contact Last Name

                ReturnToContactLastName

                DTYPE_TEXT

                50

                No

                Revision

                Revision

                DTYPE_NUMBER

                NA

                No

                Service Request Id

                ServiceRequestId

                DTYPE_ID

                NA

                No

                Service Request Number

                ServiceRequestNumber

                DTYPE_TEXT

                NA

                No

                Ship Complete

                ShipComplete

                DTYPE_TEXT

                NA

                No

                Ship Instructions

                ShipInstructions

                DTYPE_TEXT

                250

                No

                Ship To - First Name

                ShipTo-FirstName

                DTYPE_TEXT

                50

                No

                Ship To - Last Name

                ShipTo-LastName

                DTYPE_TEXT

                50

                No

                Ship To Account

                ShipToAccount

                DTYPE_TEXT

                100

                No

                Ship To Account DUNS Number

                ShipToAccountDUNSNumber

                DTYPE_TEXT

                9

                No

                Ship To Account Id

                ShipToAccountId

                DTYPE_ID

                NA

                No

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Ship To Account Site

                ShipToAccountSite

                DTYPE_TEXT

                50

                No

                Ship To Address

                ShipToAddress

                DTYPE_TEXT

                50

                No

                Ship To Address 2

                ShipToAddress2

                DTYPE_TEXT

                50

                No

                Ship To Address Id

                ShipToAddressId

                DTYPE_ID

                NA

                No

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Ship To City

                ShipToCity

                DTYPE_TEXT

                30

                No

                Ship To Contact Id

                ShipToContactId

                DTYPE_ID

                NA

                No

                Ship To Contact Integration Id

                ShipToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Ship To Country

                ShipToCountry

                DTYPE_TEXT

                15

                No

                Ship To State

                ShipToState

                DTYPE_TEXT

                30

                No

                Ship To Zip

                ShipToZip

                DTYPE_TEXT

                15

                No

                Shipping Charges

                ShippingCharges

                DTYPE_TEXT

                NA

                No

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                30

                No

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                30

                No

                Shipping Terms Info

                FreightTermsInfo

                DTYPE_TEXT

                100

                No

                Source Inventory Id

                SourceInventoryLocationId

                DTYPE_ID

                NA

                No

                Source Inventory Loc Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Status

                Status

                DTYPE_TEXT

                30

                No

                Status As Of Date

                StatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Submit Date

                SubmitDate

                DTYPE_TEXT

                NA

                No

                Tax Amount

                TaxAmount

                DTYPE_TEXT

                NA

                No

                Tax Exempt

                TaxExempt

                DTYPE_TEXT

                NA

                No

                Tax Exempt Code

                TaxExemptCode

                DTYPE_TEXT

                80

                No

                Tax Exempt Id

                TaxExemptId

                DTYPE_TEXT

                30

                No

                Tax Rate

                TaxRate

                DTYPE_NUMBER

                NA

                No

                Total Volume

                TotalVolume

                DTYPE_NUMBER

                NA

                No

                Total Volume UoM

                TotalVolumeUoM

                DTYPE_TEXT

                30

                No

                Total Weight

                TotalWeight

                DTYPE_NUMBER

                NA

                No

                Total Weight UoM

                TotalWeightUoM

                DTYPE_TEXT

                30

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Payments Fields in Siebel Order ASI

                The following table lists the Payments fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Account Number

                AccountNumber

                DTYPE_TEXT

                50

                No

                Authorization Code

                AuthorizationCode

                DTYPE_TEXT

                40

                No

                Bill To Address Id

                BillToAddressId

                DTYPE_ID

                NA

                No

                Bill To Address Integration Id

                BillToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Card Holder

                CardHolder

                DTYPE_TEXT

                50

                No

                Credit Card Expiration Month

                CreditCardExpirationMonth

                DTYPE_TEXT

                30

                No

                Credit Card Expiration Year

                CreditCardExpirationYear

                DTYPE_TEXT

                30

                No

                Credit Check Message

                CreditCheckMessage

                DTYPE_TEXT

                250

                No

                Credit Check Status

                CreditCheckStatus

                DTYPE_TEXT

                30

                No

                Credit Check Status As Of Date

                CreditCheckStatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Encryption Key

                EncryptionKey

                DTYPE_TEXT

                30

                No

                Encryption Key Reference

                EncryptionKeyReference

                DTYPE_TEXT

                30

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Issuing Bank Customer Id

                IssuingBankCustomerId

                DTYPE_TEXT

                30

                No

                Issuing Bank Name

                IssuingBankName

                DTYPE_TEXT

                30

                No

                Issuing Bank Phone Number

                IssuingBankPhoneNumber

                DTYPE_TEXT

                40

                No

                Merchant Id

                MerchantId

                DTYPE_TEXT

                30

                No

                Payment #

                Payment

                DTYPE_TEXT

                30

                No

                Payment Account Id

                PaymentAccountId

                DTYPE_ID

                NA

                No

                Payment Account Integration Id

                PaymentAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Payment Account Name

                PaymentAccountName

                DTYPE_TEXT

                100

                No

                Payment Account Site

                PaymentAccountSite

                DTYPE_TEXT

                50

                No

                Payment Method

                PaymentMethod

                DTYPE_TEXT

                30

                No

                Payment Status

                PaymentStatus

                DTYPE_TEXT

                30

                No

                Payment Status As Of Date

                PaymentStatusAsOfDate

                DTYPE_DATETIME

                NA

                No

                Payment Type

                PaymentType

                DTYPE_TEXT

                30

                No

                Transaction Amount

                TransactionAmount

                DTYPE_TEXT

                NA

                No

                Transaction Id

                TransactionId

                DTYPE_TEXT

                30

                No

                Transaction Time

                TransactionTime

                DTYPE_TEXT

                30

                No

                Verification Number

                VerificationNumber

                DTYPE_TEXT

                10

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Promised Schedule Lines Fields in Siebel Order ASI

                The following table lists the Promised Schedule Lines fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Available Status

                AvailableStatus

                DTYPE_TEXT

                30

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                NA

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Line Item Action Number

                LineItemActionNumber

                DTYPE_TEXT

                NA

                No

                Order Item Id

                OrderItemId

                DTYPE_ID

                NA

                No

                Order Item Integration Id

                OrderItemIntegrationId

                DTYPE_TEXT

                30

                No

                Part Number

                PartNumber

                DTYPE_TEXT

                50

                No

                Product Id

                ProductId

                DTYPE_ID

                NA

                No

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                30

                No

                Product Name

                ProductName

                DTYPE_TEXT

                100

                No

                Promised Date

                PromisedDate

                DTYPE_TEXT

                NA

                No

                Promised Quantity

                PromisedQuantity

                DTYPE_NUMBER

                NA

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                NA

                No

                Source Inventory Location Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Related Organization Fields in Siebel Order ASI

                The following table lists the Related Organization fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                IsPrimaryMVG

                IsPrimaryMVG

                DTYPE_TEXT

                1

                No

                Organization

                Organization

                DTYPE_TEXT

                50

                No

                Organization Id

                OrganizationId

                DTYPE_ID

                NA

                No

                Related Sales Rep Fields in Siebel Order ASI

                The following table lists the Related Sales Rep fields and the attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                IsPrimaryMVG

                IsPrimaryMVG

                DTYPE_TEXT

                1

                No

                Login

                Login

                DTYPE_TEXT

                50

                No

                Position

                Position

                DTYPE_TEXT

                50

                No

                Requested Schedule Lines Fields in Siebel Order ASI

                The following table lists the Requested Schedule Lines fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Line Number

                LineNumber

                DTYPE_NUMBER

                NA

                No

                Order Item Id

                OrderItemId

                DTYPE_ID

                NA

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                NA

                No

                Requested Quantity

                RequestedQuantity

                DTYPE_NUMBER

                NA

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                NA

                No

                Source Inventory Location Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Related Shipment Fields in Siebel Order ASI

                The following table lists the Related Shipment fields and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Carrier

                Carrier

                DTYPE_TEXT

                30

                No

                Destination Inventory Location Id

                DestinationInventoryId

                DTYPE_ID

                15

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Shipment Number

                ShipmentNumber

                DTYPE_TEXT

                30

                No

                Source Inventory Location Id

                SourceInventoryId

                DTYPE_ID

                15

                No

                Waybill Number

                WaybillNumber

                DTYPE_TEXT

                50

                No

                operation

                operation

                DTYPE_TEXT

                NA

                No

                Shipment Item Fields in Siebel Order ASI

                The following table lists the Shipment Item field and their attributes in Siebel Order ASI.

                Name XML Tag Data Type Length Req.

                Confirmed Qty

                ConfirmedQty

                DTYPE_NUMBER

                NA

                No

                Delivery Date

                DeliveryDate

                DTYPE_DATETIME

                NA

                No

                Delivery Qty

                DeliveryQty

                DTYPE_NUMBER

                NA

                No

                Id

                Id

                DTYPE_ID

                NA

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                NA

                No

                Order Line Id

                OrderLineId

                DTYPE_ID

                NA

                No

                Product Id

                ProductId

                DTYPE_ID

                NA

                No

                Shipment Date

                ShipmentDate

                DTYPE_DATETIME

                NA

                No

                Shipment Line Number

                ShipmentLineNumber

                DTYPE_TEXT

                NA

                No

                Shipment Qty

                ShipmentQty

                DTYPE_NUMBER

                NA

                No

                operation

                operation

                DTYPE_TEXT

                NA

                No

                Siebel Position

                The Siebel Position ASI is based on the Position Interface integration object, which is based on the Position integration component and the Position business component. The following image describes the Siebel Position ASI structure.

                Siebel Position ASI. In this image, Position is connected by one-way arrow to Position.

                The following table lists the integration components and user keys of this ASI.

                Integration Component Business Component XML Tag User Keys

                Position

                Position

                Position

                1. App Id

                2. Integration Id

                3. Division

                4. Name

                The Siebel Position ASI uses the same user keys as the Position Interface integration component and has 19 fields. You can use these fields for the integration, which means that values for each of these fields may be written to an XML file for transport.

                Position Fields in Siebel Position ASI

                The following table lists the Position fields and their attributes in Siebel Position ASI.

                Name XML Tag Data Type Length Req.

                Billing Product

                BillingProduct

                DTYPE_TEXT

                100

                No

                Billing Product Id

                BillingProductId

                DTYPE_ID

                N/A

                No

                Billing Product Integration Id

                BillingProductIntegrationId

                DTYPE_TEXT

                30

                No

                Compensatable

                Compensatable

                DTYPE_TEXT

                N/A

                No

                Description

                Description

                DTYPE_TEXT

                255

                No

                Division

                Division

                DTYPE_TEXT

                255

                Yes

                Division Id

                DivisionId

                DTYPE_ID

                N/A

                Yes

                Division Integration Id

                DivisionIntegrationId

                DTYPE_TEXT

                30

                No

                Id

                Id

                DTYPE_ID

                30

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Name

                Name

                DTYPE_TEXT

                50

                Yes

                Organization

                Organization

                DTYPE_TEXT

                255

                No

                Organization Id

                OrganizationId

                DTYPE_ID

                N/A

                No

                Organization Integration Id

                OrganizationIntegrationId

                DTYPE_TEXT

                30

                No

                Parent Position Id

                ParentPositionId

                DTYPE_ID

                N/A

                No

                Parent Position Integration Id

                ParentPositionIntegrationId

                DTYPE_TEXT

                30

                No

                Parent Position Name

                ParentPositionName

                DTYPE_TEXT

                50

                No

                Position Type

                PositionType

                DTYPE_TEXT

                30

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Siebel Price List

                A price list is a set of standard prices for products and services. Price lists contain the prices a buyer first sees, before any pricing adjustments have occurred. A product must be assigned a price in a given price list in order to appear in a catalog and to become visible to customers.

                A product’s price, as defined in the price list, is commonly used as a starting price for other prices generated by the Siebel Pricer application.

                This inbound ASI enables the synchronization and update of a price list and the price list items. The following image describes the Siebel Price List ASI structure.

                Siebel Price List ASI. In this image, Price List has a 1:M relationship with its children: Price List Item and Price List Organization.

                The following table lists the integration components and user keys of this ASI.

                Integration Component XML Tag User Keys

                Price List

                PriceList

                1. Integration Id

                2. Id

                3. Name, Type

                Price List Item

                PriceListItem

                1. Integration Id

                2. Id

                3. List Price Type Code, Price List Id, Product Id

                Price List_Organization

                PriceList_Organization

                1. Integration Id

                2. Division Id

                Price List Fields in Siebel Price List ASI

                The following table lists the Price List fields and their attributes in the Siebel Price List ASI. Fields without a length specified do not have a maximum length.

                Name XML Tag Data Type Length Req. Note

                Currency Code

                CurrencyCode

                DTYPE_TEXT

                15

                No

                None

                Description

                Description

                DTYPE_TEXT

                255

                No

                None

                End Date

                EndDate

                DTYPE_TEXT

                NA

                No

                None

                Freight Terms

                FreightTerms

                DTYPE_TEXT

                30

                No

                None

                Id

                Id

                DTYPE_ID

                30

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                None

                Name

                Name

                DTYPE_TEXT

                50

                No

                None

                Payment Term

                PaymentTerm

                DTYPE_TEXT

                50

                No

                None

                Payment Term Id

                PaymentTermId

                DTYPE_ID

                NA

                No

                Used to pick a related entity.

                Primary Organization

                PrimaryOrganization

                DTYPE_TEXT

                50

                No

                None

                Primary Organization Id

                PrimaryOrganizationId

                DTYPE_ID

                NA

                No

                Used to pick a related entity.

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                30

                No

                None

                Start Date

                StartDate

                DTYPE_TEXT

                NA

                No

                None

                Type

                Type

                DTYPE_TEXT

                30

                No

                None

                operation

                operation

                DTYPE_TEXT

                30

                No

                None

                Price List ItemFields in Siebel Price List ASI

                The following table lists the Price List Item fields and their attributes in the Siebel Price List ASI. Fields without a length specified do not have a maximum length.

                Name XML Tag Data Type Length Req. Note

                End Date

                EndDate

                DTYPE_TEXT

                NA

                No

                None

                Id

                Id

                DTYPE_ID

                30

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                None

                List Price Type Code

                ListPriceTypeCode

                DTYPE_TEXT

                30

                No

                None

                Original List Price

                OriginalListPrice

                DTYPE_TEXT

                NA

                No

                None

                Price List Id

                PriceListId

                DTYPE_ID

                NA

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Product Id

                ProductId

                DTYPE_ID

                NA

                No

                Used for picking a related entity.

                Promotional Price

                PromotionalPrice

                DTYPE_TEXT

                NA

                No

                None

                Start Date

                StartDate

                DTYPE_TEXT

                NA

                No

                None

                operation

                operation

                DTYPE_TEXT

                30

                No

                None

                Price List_Organization Fields in Siebel Price List ASI

                The following table lists the Price List_Organization fields and their attributes in the Siebel Price List ASI. Fields without a length specified do not have a maximum length.

                Name XML Tag Data Type Length Req. Note

                Division Id

                DivisionId

                DTYPE_ID

                30

                No

                None

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                None

                operation

                operation

                DTYPE_TEXT

                30

                No

                None

                Siebel Quote/External Quote

                The Siebel Quote/External Quote ASI is an ASI for quote and order management-related business processes. This ASI facilitates the transfer of quote data between the Siebel application and any external system. The following image shows the Siebel Quote/External Quote ASI structure.

                Siebel Quote/External Quote ASI. In this image, Quotes has the following children: Related Organizations, Related Order, Line Items, and Related Service Agreements. Line Items has the children: Attributes, Requested Schedule Lines, and Promised Schedule Lines.

                The following table lists the integration components and user keys for this ASI.

                Integration Component XML Tag User Keys

                Quote

                Quote

                1. Id

                2. Integration Id

                3. Quote Number, Primary Organization Name, Revision

                Attributes

                Attribute

                1. Id

                2. Integration Id

                3. Name

                Line Items

                LineItems

                1. Integration Id

                2. Line Item Id

                3. Line Number, Line Number 2

                4. Parent Quote Item Id

                5. Root Quote Item Id

                Promised Schedule Lines

                PromisedScheduleLines

                1. Id

                2. Integration Id

                3. Line Number

                Related Order

                RelatedOrder

                1. Order Number

                2. Order Type

                3. Primary Organization

                4. Revision

                Related Organization

                RelatedOrganization

                1. Integration Id

                2. Organization

                3. Organization Id

                Related Service Agreement

                RelatedServiceAgreement

                1. Account

                2. Id

                3. Integration Id

                4. Primary Organization

                5. Revision

                Requested Schedule Lines

                RequestedScheduleLines

                1. Id

                2. Integration Id

                3. Line Number

                The following table lists the Quote fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Account

                Account

                DTYPE_TEXT

                100

                No

                Used to pick a related entity.

                Account Id

                AccountId

                DTYPE_ID

                15

                No

                None

                Account Integration Id

                AccountIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Account Site

                AccountSite

                DTYPE_TEXT

                50

                No

                Used to pick a related entity.

                Active

                Active

                DTYPE_BOOL

                1

                No

                None

                Available Date

                AvailableDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Available Status

                AvailableStatus

                DTYPE_TEXT

                30

                No

                None

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Bill To Account

                BillToAccount

                DTYPE_TEXT

                100

                No

                None

                Bill To Account Id

                BillToAccountId

                DTYPE_ID

                15

                No

                None

                Bill To Account Integration Id

                BillToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Bill To Account Site

                BillToAccountSite

                DTYPE_TEXT

                50

                No

                None

                Bill To Address Id

                BillToAddressId

                DTYPE_ID

                15

                No

                None

                Bill To Address Integration Id

                BillToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Bill To Contact Last Name

                BillToContactLastName

                DTYPE_TEXT

                50

                No

                None

                Bill To Contact First Name

                BillToContactFirstName

                DTYPE_TEXT

                50

                No

                None

                Bill To Contact Id

                BillToContactId

                DTYPE_ID

                15

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Bill To Contact Integration Id

                BillToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pickia related entity.

                Carrier

                Carrier

                DTYPE_TEXT

                30

                No

                Bound by FS_CARRIER LOV.

                Carrier Priority

                CarrierPriority

                DTYPE_TEXT

                30

                No

                Bound by CARRIER_PRIORITY LOV.

                Contact First Name

                ContactFirstName

                DTYPE_TEXT

                50

                No

                None

                Contact Id

                ContactId

                DTYPE_ID

                15

                No

                None

                Contact Integration Id

                ContactIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Contact Last Name

                ContactLastName

                DTYPE_TEXT

                50

                No

                Used to pick a related entity.

                Credit Card Expiration Month

                CreditCardExpirationMonth

                DTYPE_TEXT

                30

                No

                Bound by MONTH_NUMBER LOV.

                Credit Card Expiration Year

                CreditCardExpirationYear

                DTYPE_TEXT

                30

                No

                Bound by YEAR LOV.

                Credit Card Holder

                CreditCardHolder

                DTYPE_TEXT

                50

                No

                None

                Credit Card Name

                CreditCardName

                DTYPE_TEXT

                50

                No

                Used to pick a related entity.

                Credit Card Number

                CreditCardNumber

                DTYPE_TEXT

                50

                No

                Used to pick a related entity.

                Credit Status

                CreditStatus

                DTYPE_TEXT

                30

                No

                Bound by ACCT_CRDT_STAT_TYPE LOV.

                Credit Status As Of Date

                CreditStatusAsOfDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Credit Status Message

                CreditStatusMessage

                DTYPE_TEXT

                250

                No

                None

                Currency Code

                CurrencyCode

                DTYPE_TEXT

                20

                Yes

                Used to pick a related entity.

                Description

                Description

                DTYPE_TEXT

                255

                No

                None

                Discount Amount

                DiscountAmount

                DTYPE_CURRENCY

                22, 7

                No

                None

                Due Date

                DueDate

                DTYPE_DATE

                7

                No

                None

                Effective Date

                EffectiveDate

                DTYPE_DATE

                7

                No

                None

                Expiration Date

                ExpirationDate

                DTYPE_DATE

                7

                No

                None

                Id

                Id

                DTYPE_ID

                15

                No

                User key field for Quote.

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Quote.

                Integration Message

                IntegrationMessage

                DTYPE_TEXT

                2,000

                No

                None

                Integration Status

                IntegrationStatus

                DTYPE_TEXT

                30

                No

                Bound by EAI_ORDER_SYNC_STATUS LOV.

                Integration Status As Of Date

                IntegrationStatusAsOfDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Name

                Name

                DTYPE_TEXT

                50

                Yes

                None

                Opportunity Id

                OpportunityId

                DTYPE_ID

                15

                No

                None

                Opportunity Integration Id

                OpportunityIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Opportunity Name

                OpportunityName

                DTYPE_TEXT

                100

                No

                Used to pick a related entity.

                Payment Method

                PaymentMethod

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Payment Term

                PaymentTerm

                DTYPE_TEXT

                50

                No

                Used to pick a related entity.

                Payment Term Id

                PaymentTermId

                DTYPE_ID

                15

                No

                None

                Payment Term Integration Id

                PaymentTermIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Price List

                PriceList

                DTYPE_TEXT

                50

                No

                Used to pick a related entity.

                Price List Id

                PriceListId

                DTYPE_ID

                15

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Price List Integration Id

                PriceListIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Primary Organization

                PrimaryOrganization

                DTYPE_TEXT

                100

                No

                User key field for Quote.

                Quote Number

                QuoteNumber

                DTYPE_TEXT

                30

                No

                User key field for Quote.

                Quote Type

                QuoteType

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Requested Date

                RequestedDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Revision

                Revision

                DTYPE_INTEGER

                22, 7

                No

                User key field for Quote.

                Ship Complete

                ShipComplete

                DTYPE_BOOL

                1

                No

                None

                Ship To Account

                ShipToAccount

                DTYPE_TEXT

                100

                No

                Used to pick a related entity.

                Ship To Account Id

                ShipToAccountId

                DTYPE_ID

                15

                No

                None

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Used for picking a related entity.

                Ship To Account Site

                ShipToAccountSite

                DTYPE_TEXT

                50

                No

                None

                Ship To Address Id

                ShipToAddressId

                DTYPE_ID

                15

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Ship To Contact First Name

                ShipToContactFirstName

                DTYPE_TEXT

                50

                No

                None

                Ship To Contact Id

                ShipToContactId

                DTYPE_ID

                15

                No

                Used to pick a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Ship To Contact Integration Id

                ShipToContactIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Ship To Contact Last Name

                ShipToContactLastName

                DTYPE_TEXT

                50

                No

                None

                Shipping Charges

                ShippingCharges

                DTYPE_CURRENCY

                22, 7

                No

                None

                Shipping Info

                ShippingInfo

                DTYPE_TEXT

                250

                No

                None

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                30

                No

                Bound by FREIGHT_TERMS LOV.

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Used to pick a related entity.

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                15

                No

                None

                Source Inventory Location Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Status

                Status

                DTYPE_TEXT

                30

                Yes

                Bound by FS_ORDER_STATUS LOV.

                Status As Of Date

                StatusAsOfDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Tax Amount

                TaxAmount

                DTYPE_CURRENCY

                22, 7

                No

                None

                Tax Exempt

                TaxExempt

                DTYPE_BOOL

                1

                No

                None

                Tax Exemption Code

                TaxExemptionCode

                DTYPE_TEXT

                80

                No

                Bound by GLOBAL_TAX_EXEMPTION LOV.

                Tax Exemption Id

                TaxExemptionId

                DTYPE_TEXT

                30

                No

                None

                Tax Rate

                TaxRate

                DTYPE_NUMBER

                22, 7

                No

                None

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Attributes Fields in Siebel Quote/External Quote ASI

                The following table lists the Attributes fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Action Code

                ActionCode

                DTYPE_TEXT

                30

                No

                None

                Attribute Id

                AttributeId

                DTYPE_ID

                15

                No

                None

                Data Type

                DataType

                DTYPE_TEXT

                30

                No

                Bound by XA_ATTR_DTYPE LOV.

                Description

                Description

                DTYPE_TEXT

                250

                No

                None

                Id

                Id

                DTYPE_ID

                30

                No

                User key field for Attributes.

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Attributes.

                List Of Value Type

                ListOfValueType

                DTYPE_TEXT

                30

                No

                Bound by LOV._TYPE LOV.

                Name

                Name

                DTYPE_TEXT

                75

                No

                User key field for Attributes.

                Value

                Value

                DTYPE_TEXT

                100

                No

                Bound by Type.

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Line Items Fields in Siebel Quote/External Quote ASI

                The following table lists the Line Items fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Action Code

                ActionCode

                DTYPE_TEXT

                30

                No

                Bound by DELTA_ACTION_CODE LOV.

                Available Date

                AvailableDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Available Quantity

                AvailableQuantity

                DTYPE_NUMBER

                22, 7

                No

                None

                Base Price

                BasePrice

                DTYPE_CURRENCY

                22, 7

                No

                None

                Discount Amount

                DiscountAmount

                DTYPE_CURRENCY

                22, 7

                No

                None

                Extended Quantity

                ExtendedQuantity

                DTYPE_NUMBER

                22, 7

                No

                None

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Line Items.

                Line Item Id

                LineItemId

                DTYPE_ID

                15

                No

                User key field for Line Items.

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Line Number

                LineNumber

                DTYPE_NUMBER

                22, 7

                Yes

                User key field for Line Items.

                Line Number 2

                LineNumber2

                DTYPE_NUMBER

                22, 7

                No

                User key field for Line Items.

                Note

                Note

                DTYPE_TEXT

                1500

                No

                None

                Package Name External

                PackageNameExternal

                DTYPE_TEXT

                100

                No

                None

                Package Name Siebel

                PackageNameSiebel

                DTYPE_TEXT

                50

                No

                None

                Parent Quote Item Id

                ParentQuoteItemId

                DTYPE_ID

                15

                No

                User key field for Line Items.

                Product

                Product

                DTYPE_TEXT

                100

                No

                Used for picking a related entity.

                Product Id

                ProductId

                DTYPE_ID

                15

                No

                None

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Requested Date

                RequestedDate

                DTYPE_DATE

                7

                No

                None

                Requested Quantity

                RequestedQuantity

                DTYPE_NUMBER

                22, 7

                Yes

                The default is 1.

                Root Quote Item Id

                RootQuoteItemId

                DTYPE_ID

                15

                No

                User key field for Line Items.

                Ship To Account

                ShipToAccount

                DTYPE_TEXT

                100

                No

                Used for picking a related entity.

                Ship To Account Id

                ShipToAccountId

                DTYPE_ID

                15

                No

                None

                Ship To Account Site

                ShipToAccountSite

                DTYPE_TEXT

                50

                No

                None

                Ship To Address Id

                ShipToAddressId

                DTYPE_ID

                15

                No

                None

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Ship to Account Integration Id

                ShiptoAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Shipping Charges

                ShippingCharges

                DTYPE_CURRENCY

                22, 7

                No

                None

                Single Source

                SingleSource

                DTYPE_BOOL

                1

                No

                None

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Used to pick a related entity.

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                15

                No

                None

                Source Inventory Location Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Start Price

                StartPrice

                DTYPE_CURRENCY

                22, 7

                No

                None

                Tax Amount

                TaxAmount

                DTYPE_CURRENCY

                22, 7

                No

                None

                Unit of Measure

                UnitofMeasure

                DTYPE_TEXT

                30

                No

                None

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Promised Schedule Lines Fields in Siebel Quote/External Quote ASI

                The following table lists the Promised Schedule Lines fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Available Status

                AvailableStatus

                DTYPE_TEXT

                30

                No

                None

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Id

                Id

                DTYPE_ID

                30

                No

                User key field for Promised Schedule Lines.

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Promised Schedule Lines.

                Line Number

                LineNumber

                DTYPE_NUMBER

                22, 7

                No

                User key field for Promised Schedule Lines.

                Promised Date

                PromisedDate

                DTYPE_DATE

                7

                No

                None

                Promised Quantity

                PromisedQuantity

                DTYPE_NUMBER

                22, 7

                No

                None

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Used to pick a related entity.

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                15

                No

                None

                Source Inventory Location Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Used to pick a related entity.

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Related Order Fields in Siebel Quote/External Quote ASI

                The following table lists the Related Order fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Id

                Id

                DTYPE_ID

                30

                No

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                Order Number

                OrderNumber

                DTYPE_TEXT

                30

                Yes

                User key field for Related Order.

                Order Type

                OrderType

                DTYPE_TEXT

                30

                Yes

                Used for picking a related entity.

                Primary Organization

                PrimaryOrganization

                DTYPE_TEXT

                100

                No

                User key field for Related Order.

                Revision

                Revision

                DTYPE_INTEGER

                22, 7

                No

                User key field for Related Order.

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Related Organization Fields in Siebel Quote/External Quote ASI

                The following table lists the Related Organization fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Related Organization.

                IsPrimaryMVG

                IsPrimaryMVG

                DTYPE_TEXT

                1

                No

                This field determines whether this child record is the primary one. The value is determined in run time.

                Organization

                Organization

                DTYPE_TEXT

                50

                No

                User key field for Related Organization.

                Organization Id

                OrganizationId

                DTYPE_ID

                15

                No

                User key field for Related Organization.

                Related Organization Fields in Siebel Quote/External Quote ASI

                The following table lists the Related Organization fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Related Organization.

                IsPrimaryMVG

                IsPrimaryMVG

                DTYPE_TEXT

                1

                No

                This field determines whether this child record is the primary one. The value is determined in run time.

                Organization

                Organization

                DTYPE_TEXT

                50

                No

                User key field for Related Organization.

                Organization Id

                OrganizationId

                DTYPE_ID

                15

                No

                User key field for Related Organization.

                Related Service Agreement Fields in Siebel Quote/External Quote ASI

                The following table lists the Related Service Agreement fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Account

                Account

                DTYPE_TEXT

                100

                No

                Used for picking a related entity. User key field for Related Service Agreement.

                Id

                Id

                DTYPE_ID

                30

                No

                User key field for Related Service Agreement.

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Related Service Agreement.

                Name

                Name

                DTYPE_TEXT

                50

                Yes

                User key field for Related Service Agreement.

                Primary Organization

                PrimaryOrganization

                DTYPE_TEXT

                100

                No

                User key field for Related Service Agreement.

                Revision

                Revision

                DTYPE_NUMBER

                22, 7

                Yes

                User key field for Related Service Agreement.

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Requested Schedule Lines Fields in Siebel Quote/External Quote ASI

                The following table lists the Requested Schedule Lines fields and their attributes in Siebel Quote/External Quote ASI.

                Name XML Tag Data Type Length Req. Note

                Id

                Id

                DTYPE_ID

                30

                No

                User key field for Requested Schedule Lines.

                This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.

                Integration Id

                IntegrationId

                DTYPE_TEXT

                30

                No

                User key field for Requested Schedule Lines.

                Line Number

                LineNumber

                DTYPE_NUMBER

                22, 7

                Yes

                User key field for Requested Schedule Lines.

                Requested Date

                RequestedDate

                DTYPE_UTCDATETIME

                7

                No

                None

                Requested Quantity

                RequestedQuantity

                DTYPE_NUMBER

                22, 7

                No

                None

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                100

                No

                Used for picking a related entity.

                Source Inventory Location Id

                SourceInventoryLocationId

                DTYPE_ID

                15

                No

                None

                Source Inventory Location Integration Id

                SourceInventoryLocationIntegrationId

                DTYPE_TEXT

                30

                No

                Used for picking a related entity.

                Operation

                Operation

                DTYPE_TEXT

                30

                No

                System field.

                Siebel ATP Response/External ATP Check

                The Siebel ATP Response/External ATP Check ASI enables a customer to check for a quantity of goods that is available for delivery in the desired time frame, and for the price of these goods in the external system. Siebel ATP Response/External ATP Check uses two ASIs for request and response, which use the same components and field definitions. The following image describes the structure of this ASI.

                Siebel ATP Response/External ATP Check ASI. In this image, ATP Header has a 1:M relationship with children: ATP Line Items and Payments. ATP Line Items has a 1:M relationship with children: Attributes, Requested Schedule Lines, and Promised Schedule Lines.

                The following table lists the XML tags and user keys for this ASI.

                Integration Component XML Tag User Keys

                ATP Header

                ATPHeader

                1. Id

                2. Order Number, Organization Type, Revision

                3. Order Number, Revision

                4. Id

                ATP Line Items

                ATPLineItems

                1. Line Number

                2. Id

                Attributes

                Attributes

                • Id

                Payments

                Payments

                • Id

                Promised Schedule Line

                PromisedScheduleLine

                • Integration Id

                ATP Header Fields in Siebel ATP Response/External ATP Check ASI

                The following table lists the ATPHeader fields and their attributes in the Siebel ATP Response/External ATP Check ASI. Fields without a length specified do not have a maximum length associated with them.

                Name XML Tag Data Type Length Req.

                Account

                Account

                DTYPE_TEXT

                N/A

                No

                Account Id

                AccountId

                DTYPE_TEXT

                N/A

                No

                Account Integration Id

                AccountIntegrationId

                DTYPE_TEXT

                N/A

                No

                Available Date

                AvailableDate

                DTYPE_TEXT

                N/A

                No

                Available Message

                AvailableMessage

                DTYPE_TEXT

                N/A

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                N/A

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                N/A

                No

                Carrier

                Carrier

                DTYPE_TEXT

                N/A

                No

                Contact First Name

                ContactFirstName

                DTYPE_TEXT

                N/A

                No

                Contact Id

                ContactId

                DTYPE_TEXT

                N/A

                No

                Contact Last Name

                ContactLastName

                DTYPE_TEXT

                N/A

                No

                Currency Code

                CurrencyCode

                DTYPE_TEXT

                N/A

                No

                Document Type Id

                DocumentTypeId

                DTYPE_TEXT

                N/A

                No

                Header Number

                HeaderNumber

                DTYPE_TEXT

                N/A

                No

                Id

                HeaderRowId

                DTYPE_TEXT

                N/A

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                N/A

                No

                Name

                Name

                DTYPE_TEXT

                N/A

                No

                Order Date

                OrderDate

                DTYPE_TEXT

                N/A

                No

                Order Priority

                OrderPriority

                DTYPE_TEXT

                N/A

                No

                Organization

                Organization

                DTYPE_TEXT

                N/A

                No

                Organization DUNS Number

                OrganizationDUNSNumber

                DTYPE_TEXT

                N/A

                No

                Organization Id

                OrganizationId

                DTYPE_TEXT

                N/A

                No

                Organization Integration Id

                OrganizationIntegrationId

                DTYPE_TEXT

                N/A

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                N/A

                No

                Revision

                Revision

                DTYPE_NUMBER

                N/A

                No

                Ship Complete Flag

                ShipCompleteFlag

                DTYPE_TEXT

                N/A

                No

                Ship To Account

                ShipToAccount

                DTYPE_TEXT

                N/A

                No

                Ship To Account Id

                ShipToAccountId

                DTYPE_TEXT

                N/A

                No

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                N/A

                No

                Ship To Address

                ShipToAddress

                DTYPE_TEXT

                N/A

                No

                Ship To Address Id

                ShipToAddressId

                DTYPE_TEXT

                N/A

                No

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                N/A

                No

                Ship To City

                ShipToCity

                DTYPE_TEXT

                N/A

                No

                Ship To Country

                ShipToCountry

                DTYPE_TEXT

                N/A

                No

                Ship To First Name

                ShipToFirstName

                DTYPE_TEXT

                N/A

                No

                Ship To Last Name

                ShipToLastName

                DTYPE_TEXT

                N/A

                No

                Ship To Site

                ShipToSite

                DTYPE_TEXT

                N/A

                No

                Ship To State

                ShipToState

                DTYPE_TEXT

                N/A

                No

                Ship To Zip

                ShipToZip

                DTYPE_TEXT

                N/A

                No

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                N/A

                No

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                N/A

                No

                Shipping Terms Info

                ShippingTermsInfo

                DTYPE_TEXT

                N/A

                No

                Single Delivery

                SingleDelivery

                DTYPE_TEXT

                N/A

                No

                Source Inventory Loc Id

                SourceInventoryLocId

                DTYPE_TEXT

                N/A

                No

                Source Inventory Loc Integration Id

                SourceInventoryLocIntegrationId

                DTYPE_TEXT

                N/A

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                N/A

                No

                Time To Reserve

                TimeToReserve

                DTYPE_TEXT

                N/A

                No

                Time To Reserve UOM

                TimeToReserveUOM

                DTYPE_TEXT

                N/A

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                ATP Line Items Fields in Siebel ATP Response/External ATP Check ASI

                The following table lists the ATPLineItems fields and their attributes in the Siebel ATP Response/External ATP Check ASI. Fields without a length specified do not have a maximum length associated with them.

                Name XML Tag Data Type Length Req.

                ATP Message Line

                ATPMessageLine

                DTYPE_TEXT

                N/A

                No

                Available Date

                AvailableDate

                DTYPE_TEXT

                N/A

                No

                Available Quantity

                AvailableQuantity

                DTYPE_TEXT

                N/A

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                N/A

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                N/A

                No

                Carrier

                Carrier

                DTYPE_TEXT

                N/A

                No

                Extended Quantity

                ExtendedQuantity

                DTYPE_TEXT

                N/A

                No

                Id

                RowId

                DTYPE_TEXT

                N/A

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                N/A

                No

                Item Price

                ItemPrice

                DTYPE_TEXT

                N/A

                No

                Line Number

                LineNumber

                DTYPE_TEXT

                N/A

                No

                Minimum Lot Size

                MinimumLotSize

                DTYPE_TEXT

                N/A

                No

                Net Price

                NetPrice

                DTYPE_TEXT

                N/A

                No

                Package

                Package

                DTYPE_TEXT

                N/A

                No

                Parent Row Id

                ParentRowId

                DTYPE_TEXT

                N/A

                No

                Parent Row Line Number

                ParentRowLineNumber

                DTYPE_TEXT

                N/A

                No

                Part Number

                PartNumber

                DTYPE_TEXT

                N/A

                No

                Product Global Identifier

                ProductGlobalIdentifier

                DTYPE_TEXT

                N/A

                No

                Product Id

                ProductId

                DTYPE_TEXT

                N/A

                No

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                N/A

                No

                Product Status Code

                ProductStatusCode

                DTYPE_TEXT

                N/A

                No

                Product Unit Of Measure

                ProductUnitOfMeasure

                DTYPE_TEXT

                N/A

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                N/A

                No

                Requested Quantity

                RequestedQuantity

                DTYPE_TEXT

                N/A

                No

                Rollup Item Price

                RollupItemPrice

                DTYPE_TEXT

                N/A

                No

                Sales Unit Of Measure

                SalesUnitOfMeasure

                DTYPE_TEXT

                N/A

                No

                Ship Complete Flag

                ShipCompleteFlag

                DTYPE_TEXT

                N/A

                No

                Ship To Account Id

                ShipToAccountId

                DTYPE_TEXT

                N/A

                No

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                N/A

                No

                Ship To Address

                ShipToAddress

                DTYPE_TEXT

                N/A

                No

                Ship To Address Id

                ShipToAddressId

                DTYPE_TEXT

                N/A

                No

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                N/A

                No

                Ship To City

                ShipToCity

                DTYPE_TEXT

                N/A

                No

                Ship To Contact First Name

                ShipToContactFirstName

                DTYPE_TEXT

                N/A

                No

                Ship To Contact Last Name

                ShipToContactLastName

                DTYPE_TEXT

                N/A

                No

                Ship To Country

                ShipToCountry

                DTYPE_TEXT

                N/A

                No

                Ship To State

                ShipToState

                DTYPE_TEXT

                N/A

                No

                Ship To Zip

                ShipToZip

                DTYPE_TEXT

                N/A

                No

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                N/A

                No

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                N/A

                No

                Single Delivery

                SingleDelivery

                DTYPE_TEXT

                N/A

                No

                Smart Part Number

                SmartPartNumber

                DTYPE_TEXT

                N/A

                No

                Source Inventory Loc Id

                SourceInventoryLocId

                DTYPE_TEXT

                N/A

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                N/A

                No

                Source Inventory Location Integration Id

                SourceInventoryLocIntegrationId

                DTYPE_TEXT

                N/A

                No

                Start Price

                StartPrice

                DTYPE_TEXT

                N/A

                No

                Time To Reserve

                TimeToReserve

                DTYPE_TEXT

                N/A

                No

                Time To Reserve UOM

                TimeToReserveUOM

                DTYPE_TEXT

                N/A

                No

                Unit Of Measure

                UnitOfMeasure

                DTYPE_TEXT

                N/A

                No

                Unit Price

                UnitPrice

                DTYPE_TEXT

                N/A

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Attributes Fields in Siebel ATP Response/External ATP Check ASI

                The following table lists the Attributes fields and their attributes in the Siebel ATP Response/External ATP Check ASI. Fields without a length specified do not have a maximum length associated with them.

                Name XML Tag Data Type Length Req.

                Description

                AttributeDescription

                DTYPE_TEXT

                N/A

                No

                Id

                AttributeId

                DTYPE_ID

                N/A

                No

                Name

                AttributeName

                DTYPE_TEXT

                N/A

                No

                Value

                AttributeValue

                DTYPE_TEXT

                N/A

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Payments Fields in Siebel ATP Response/External ATP Check ASI

                The following table lists the Payments fields and their attributes in the Siebel ATP Response/External ATP Check ASI. Fields without a length specified do not have a maximum length associated with them.

                Name XML Tag Data Type Length Req.

                Credit Check Message

                CreditCheckMessage

                DTYPE_TEXT

                N/A

                No

                Credit Check Status

                CreditCheckStatus

                DTYPE_TEXT

                N/A

                No

                Credit Check Status As Of Date

                CreditCheckStatusAsOfDate

                DTYPE_TEXT

                N/A

                No

                Id

                Id

                DTYPE_TEXT

                N/A

                No

                Payment Method

                PaymentMethod

                DTYPE_TEXT

                N/A

                No

                Transaction Amount

                TransactionAmount

                DTYPE_TEXT

                N/A

                No

                operation

                operation

                DTYPE_TEXT

                N/A

                No

                Promised Schedule Line Fields in Siebel ATP Response/External ATP Check ASI

                The following table lists the PromisedScheduleLine fields and their attributes in the Siebel ATP Response/External ATP Check ASI. Fields without a length specified do not have a maximum length associated with them.

                Name XML Tag Data Type Length Req.

                Available Date

                AvailableDate

                DTYPE_TEXT

                N/A

                No

                Available Quantity

                AvailableQuantity

                DTYPE_TEXT

                N/A

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                N/A

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                N/A

                No

                Id

                Id

                DTYPE_TEXT

                N/A

                No

                Line Number

                LineNumber

                DTYPE_TEXT

                N/A

                No

                Part Number

                PartNumber

                DTYPE_TEXT

                N/A

                No

                Product Id

                ProductId

                DTYPE_TEXT

                N/A

                No

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                N/A

                No

                Source Inventory Loc Id

                SourceInventoryLocId

                DTYPE_TEXT

                N/A

                No

                Source Inventory Loc Integration Id

                SourceInventoryLocIntegrationId

                DTYPE_TEXT

                N/A

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                N/A

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                External Credit Check

                The External Credit Check ASI is an ASI for quote and order management-related business processes. This ASI enables the Siebel application to request a credit check from a back-office or credit management system. There are two ASIs for External Credit Check—one for requests and one for responses.

                  Credit Check Request

                  The Credit Check Request ASI is an outbound call that triggers the back-office credit limit check business service in an order, and populates the credit status check result in the Siebel application. The Siebel application issues a warning; if a customer does have a sufficient credit limit, the status shown indicates failure.

                  The following image describes the structure of this ASI.

                  Credit Check Request. In this image, Request Credit Check has a 1:M relationship with Line Items.

                  The following table lists the integration component of this ASI.

                  Integration Component XML Tag User Keys

                  Line Items

                  LineItems

                  No user keys

                  Request Credit Check

                  RequestCreditCheck

                  No user keys

                  Request Credit Check Fields in Credit Check Request ASI

                  The following table lists the Request Credit Check fields and their attributes in the Credit Check Request ASI. Fields without a length specified do not have a maximum length associated with them.

                  Name XML Tag Data Type Length Req. Note

                  Amount

                  Amount

                  DTYPE_NUMBER

                  NA

                  No

                  None

                  Bill To Account Id

                  BillToAccountId

                  DTYPE_ID

                  15

                  No

                  None

                  Bill To Account Integration Id

                  BillToAccountIntegrationId

                  DTYPE_ID

                  30

                  No

                  None

                  Bill To Account Location

                  BillToAccountLocation

                  DTYPE_TEXT

                  50

                  No

                  None

                  Bill To Account Name

                  BillToAccountName

                  DTYPE_TEXT

                  100

                  No

                  None

                  Bill To Address Id

                  BillToAddressId

                  DTYPE_ID

                  15

                  No

                  None

                  Bill To Alias

                  BillToAlias

                  DTYPE_TEXT

                  50

                  No

                  None

                  Bill To City

                  BillToCity

                  DTYPE_TEXT

                  50

                  No

                  None

                  Bill To Country

                  BillToCountry

                  DTYPE_TEXT

                  50

                  No

                  None

                  Bill To County

                  BillToCounty

                  DTYPE_TEXT

                  50

                  No

                  None

                  Bill To DUNS Number

                  BillToDUNSNumber

                  DTYPE_TEXT

                  15

                  No

                  None

                  Bill To Postal Code

                  BillToPostalCode

                  DTYPE_TEXT

                  30

                  No

                  None

                  Bill To Primary Organization Id

                  BillToPrimaryOrganizationId

                  DTYPE_ID

                  15

                  No

                  None

                  Bill To Primary Organization Name

                  BillToPrimaryOrganizationName

                  DTYPE_TEXT

                  100

                  No

                  None

                  Bill To Province

                  BillToProvince

                  DTYPE_TEXT

                  50

                  No

                  None

                  Bill To State

                  BillToState

                  DTYPE_TEXT

                  10

                  No

                  None

                  Bill To Street Address

                  BillToStreetAddress

                  DTYPE_TEXT

                  200

                  No

                  None

                  Bill To Street Address 2

                  BillToStreetAddress2

                  DTYPE_TEXT

                  100

                  No

                  None

                  Bill To VAT Registration Number

                  BillToVATRegistrationNumber

                  DTYPE_TEXT

                  30

                  No

                  None

                  Currency

                  Currency

                  DTYPE_TEXT

                  20

                  No

                  None

                  Document Id

                  DocumentId

                  DTYPE_TEXT

                  30

                  Yes

                  None

                  Document Integration Id

                  DocumentIntegrationId

                  DTYPE_TEXT

                  30

                  No

                  None

                  Document Type

                  DocumentType

                  DTYPE_TEXT

                  10

                  Yes

                  Contains either Quote or Order value.

                  Order Type Id

                  OrderTypeId

                  DTYPE_ID

                  15

                  No

                  Applies only if Document Type is Order.

                  Line Items Fields in Credit Check Request ASI

                  The following table lists the Line Items fields and their attributes in the Credit Check Request ASI. Fields without a length specified do not have a maximum length associated with them.

                  Name XML Tag Data Type Length Req.

                  Extended Quantity

                  ExtendedQuantity

                  DTYPE_NUMBER

                  22

                  No

                  Id

                  Id

                  DTYPE_ID

                  15

                  No

                  Item Price

                  ItemPrice

                  DTYPE_NUMBER

                  22

                  No

                  Line Number

                  LineNumber

                  DTYPE_NUMBER

                  22

                  No

                  Net Price

                  NetPrice

                  DTYPE_NUMBER

                  22

                  No

                  Parent Order Item Number

                  ParentOrderItemNumber

                  DTYPE_NUMBER

                  22

                  No

                  Product Id

                  ProductId

                  DTYPE_ID

                  15

                  No

                  Quantity Requested

                  QuantityRequested

                  DTYPE_NUMBER

                  22

                  No

                  Rollup Item Price

                  RollupItemPrice

                  DTYPE_NUMBER

                  22

                  No

                  Start Price

                  StartPrice

                  DTYPE_NUMBER

                  22

                  No

                  Unit Price

                  UnitPrice

                  DTYPE_NUMBER

                  22

                  No

                    Credit Check Response

                    The following table lists the integration component in the Credit Check Response ASI.

                    Integration Component XML Tag User Keys

                    Request Credit Check Response

                    RequestCreditCheckResponse

                    No user keys

                    Request Credit Check Response Fields in Credit Check Response ASI

                    The following table lists the Request Credit Check Response fields and their attributes in the Credit Check Response ASI.

                    Name XML Tag Data Type Length Req.

                    Bill To Account Id

                    BillToAccountId

                    DTYPE_ID

                    15

                    No

                    Bill To Account Integration Id

                    BillToAccountIntegrationId

                    DTYPE_ID

                    30

                    No

                    Bill To Account Location

                    BillToAccountLocation

                    DTYPE_TEXT

                    50

                    No

                    Bill To Account Name

                    BillToAccountName

                    DTYPE_TEXT

                    100

                    No

                    Bill To Primary Organization Id

                    BillToPrimaryOrganizationId

                    DTYPE_ID

                    15

                    No

                    Bill To Primary Organization Name

                    BillToPrimaryOrganizationName

                    DTYPE_TEXT

                    100

                    No

                    Credit Status As Of

                    CreditStatusAsOf

                    DTYPE_DATETIME

                    NA

                    No

                    Credit Status Code

                    CreditStatusCode

                    DTYPE_TEXT

                    30

                    No

                    Credit Status Message

                    CreditStatusMessage

                    DTYPE_TEXT

                    250

                    No

                    Document Id

                    DocumentId

                    DTYPE_ID

                    15

                    Yes

                    Document Integration Id

                    DocumentIntegrationId

                    DTYPE_TEXT

                    15

                    No

                    Document Type

                    DocumentType

                    DTYPE_TEXT

                    10

                    Yes

                    Error Status

                    ErrorStatus

                    DTYPE_TEXT

                    30

                    Yes

                    Error Text

                    ErrorText

                    DTYPE_TEXT

                    250

                    No

                      External Shipment Tracking

                      The External Shipment Tracking ASI enables a customer to check the location and status of an order after it leaves the seller.

                      There are two ASIs for External Shipment Tracking—one for requests and one for responses.

                        Shipment Tracking Interface Request

                        The Shipment Tracking Interface Request uses the Shipment Information Business Component. The following table lists the components in the Shipment Tracking Interface Request ASI.

                        Integration Component XML Tag User Keys

                        Shipment Information

                        ShipmentInformation

                        No user keys

                        Shipment Information Fields in Shipment Tracking Interface Request ASI

                        The following table lists the Shipment Information fields and their attributes in the Shipment Tracking Interface Request ASI.

                        Name XML Tag Data Type Length Req. Note

                        Carrier

                        Carrier

                        DTYPE_TEXT

                        30

                        No

                        Used to pick a related entity.

                        Country Code

                        CountryCode

                        DTYPE_TEXT

                        10

                        No

                        None

                        Language

                        Language

                        DTYPE_TEXT

                        10

                        No

                        None

                        Package Tracking Number

                        PackageTrackingNumber

                        DTYPE_TEXT

                        40

                        C

                        Package tracking number. Conditionally required if Shipment Identification Number or Shipment Reference Number is not provided.

                        Request Action

                        RequestAction

                        DTYPE_TEXT

                        20

                        Yes

                        None

                        Request Option

                        RequestOption

                        DTYPE_TEXT

                        20

                        No

                        None

                        Shipment Identification Number

                        ShipmentIdentificationNumber

                        DTYPE_TEXT

                        50

                        C

                        Shipment tracking number. Conditionally required if Package Tracking Number or Shipment Reference Number is not provided.

                        Shipment Reference Number

                        ShipmentReferenceNumber

                        DTYPE_TEXT

                        30

                        C

                        Shipment Reference number is defined by the seller (and is conditionally required if Package Tracking Number or Shipment Identification Number is not provided).

                        Shipper Number

                        ShipperNumber

                        DTYPE_TEXT

                        60

                        C

                        Conditionally required if Shipment Reference Number is provided.

                          Shipment Tracking Interface Response

                          The following image describes the structure for Shipment Tracking Interface Response.

                          Shipment Tracking Interface Response ASI. In this image, Shipment Information has a 1:M relationship to Package Information.

                          The following table lists the integration components in the Shipment Tracking Interface Response ASI.

                          Integration Component XML Tag User Keys

                          Shipment Information

                          ShipmentInformation

                          No user keys

                          Package Information

                          PackageInformation

                          No user keys

                          Shipment Information Fields in Shipment Tracking Interface Response ASI

                          The following table lists the Shipment Information fields and their attributes in the Shipment Tracking Interface Response ASI. Fields without a length specified do not have a maximum length associated with them.

                          Name XML Tag Data Type Length Req. Notes

                          Response Code

                          ResponseCode

                          DTYPE_TEXT

                          10

                          Yes

                          None

                          Response Message

                          ResponseMessage

                          DTYPE_TEXT

                          100

                          Yes

                          None

                          Shipment Identification Number

                          ShipmentIdentificationNumber

                          DTYPE_TEXT

                          50

                          C

                          Tracking number at the shipment level (logical construct). Conditionally required if Shipment Reference Number is not provided.

                          Shipment Pickup Date

                          ShipmentPickupDate

                          DTYPE_UTCDATETIME

                          10

                          No

                          None

                          Shipment Reference Number

                          ShipmentReferenceNumber

                          DTYPE_TEXT

                          30

                          C

                          Conditionally required if Shipment Identification Number is not provided.

                          Shipment Scheduled Delivery Date

                          ShipmentScheduledDeliveryDate

                          DTYPE_UTCDATETIME

                          10

                          No

                          None

                          Shipment Service Description

                          ShipmentServiceDescription

                          DTYPE_TEXT

                          100

                          No

                          None

                          Shipment Ship To Address Line 1

                          ShipmentShipToAddressLine1

                          DTYPE_TEXT

                          200

                          No

                          None

                          Shipment Ship To Address Line 2

                          ShipmentShipToAddressLine2

                          DTYPE_TEXT

                          100

                          No

                          None

                          Shipment Ship To City

                          ShipmentShipToCity

                          DTYPE_TEXT

                          50

                          No

                          None

                          Shipment Ship To Country

                          ShipmentShipToCountry

                          DTYPE_TEXT

                          30

                          No

                          None

                          Shipment Ship To Postal Code

                          ShipmentShipToPostalCode

                          DTYPE_TEXT

                          30

                          No

                          None

                          Shipment Ship To State

                          ShipmentShipToState

                          DTYPE_TEXT

                          10

                          No

                          None

                          Shipper Number

                          ShipperNumber

                          DTYPE_TEXT

                          60

                          Y

                          None

                          Package Information Fields in Shipment Tracking Interface Response ASI

                          The following table lists the Package Information fields and their attributes in the Shipment Tracking Interface Response ASI. Fields without a length specified do not have a maximum length associated with them.

                          Name XML Tag Data Type Length Req.

                          Comments

                          Comments

                          DTYPE_TEXT

                          100

                          No

                          Package Activity Date

                          PackageActivityDate

                          DTYPE_DATE

                          20

                          No

                          Package Activity Location City

                          PackageActivityLocationCity

                          DTYPE_TEXT

                          20

                          No

                          Package Activity Location Country

                          PackageActivityLocationCountry

                          DTYPE_TEXT

                          20

                          No

                          Package Activity Location Description

                          PackageActivityLocationDescription

                          DTYPE_TEXT

                          20

                          No

                          Package Activity Location Signed For By Name

                          PackageActivityLocationSignedForByName

                          DTYPE_TEXT

                          20

                          No

                          Package Activity Status Description

                          PackageActivityStatusDescription

                          DTYPE_TEXT

                          20

                          No

                          Package Activity Time

                          PackageActivityTime

                          DTYPE_TIME

                          20

                          No

                          Package Tracking Number

                          PackageTrackingNumber

                          DTYPE_TEXT

                          20

                          Yes

                          Response Code

                          ResponseCode

                          DTYPE_TEXT

                          10

                          No

                          Response Message

                          ResponseMessage

                          DTYPE_TEXT

                          100

                          No

                            Siebel SIA Service Request

                            The Siebel SIA Service Request ASI enables an application to create an SIA service request within the Siebel application. The following image describes the Siebel SIA Service Request ASI structure.

                            Siebel SIA Service Request ASI. In this image, Service Request has a 1:M relationship with children: Activities and Notes.

                            The following table lists the integration components of this ASI.

                            Name XML Tag User Keys

                            Action

                            Action

                            1. Id

                            2. Activity UId

                            Related Account External Product

                            AccountExternalProduct

                            1. Id

                            2. AEP Account Id, AEP Product Id, Version

                            SR External Product

                            SRExternalProduct

                            • Name, Version

                            Service Request

                            ServiceRequest

                            1. Id

                            2. Primary Organization Id, SR Number

                            Action Fields in Siebel SIA Service Request ASI

                            The following table lists the Action fields and their attributes in Siebel SIA Service Request ASI.

                            Name XML Tag Data Type Length Required

                            Abstract

                            Abstract

                            DTYPE_TEXT

                            100

                            No

                            Activity SR Id

                            ActivitySRId

                            DTYPE_ID

                            15

                            No

                            Activity UID

                            ActivityUID

                            DTYPE_TEXT

                            30

                            No

                            Asset Id

                            AssetId

                            DTYPE_ID

                            15

                            No

                            Asset Number

                            AssetNumber

                            DTYPE_TEXT

                            100

                            No

                            Audience

                            Audience

                            DTYPE_TEXT

                            30

                            No

                            Comment

                            Comment

                            DTYPE_TEXT

                            1,500

                            No

                            Description

                            Description

                            DTYPE_TEXT

                            100

                            No

                            Done

                            Done

                            DTYPE_TEXT

                            30

                            No

                            Duration Hours

                            DurationHours

                            DTYPE_NUMBER

                            22

                            No

                            Duration Minutes

                            DurationMinutes

                            DTYPE_NUMBER

                            22

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Planned

                            Planned

                            DTYPE_TEXT

                            30

                            No

                            Planned Completion

                            PlannedCompletion

                            DTYPE_TEXT

                            30

                            No

                            Primary Owner Id

                            PrimaryOwnerId

                            DTYPE_ID

                            15

                            No

                            Resolution Code

                            ResolutionCode

                            DTYPE_TEXT

                            30

                            No

                            Started

                            Started

                            DTYPE_TEXT

                            30

                            No

                            Type

                            Type

                            DTYPE_TEXT

                            30

                            No

                            Related Account External Product Fields in Siebel SIA Service Request ASI

                            The following table lists the Related Account External Product fields and their attributes in Siebel SIA Service Request ASI.

                            Name XML Tag Data Type Length Required

                            AEP Account Id

                            AEPAccountId

                            DTYPE_ID

                            30

                            No

                            AEP Product Id

                            AEPProductId

                            DTYPE_ID

                            30

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Version

                            Version

                            DTYPE_TEXT

                            30

                            No

                            SR External Product Fields in Siebel SIA Service Request ASI

                            The following table lists the SR External Product fields and their attributes in Siebel SIA Service Request ASI.

                            Name XML Tag Data Type Length Required

                            Name

                            Name

                            DTYPE_TEXT

                            100

                            No

                            Version

                            Version

                            DTYPE_TEXT

                            30

                            No

                            Service Request Fields in Siebel SIA Service Request ASI

                            The following table lists the Service Request fields and their attributes in Siebel SIA Service Request ASI.

                            Name XML Tag Data Type Length Required

                            Abstract

                            Abstract

                            DTYPE_TEXT

                            100

                            No

                            Account

                            Account

                            DTYPE_TEXT

                            100

                            No

                            Account Id

                            AccountId

                            DTYPE_ID

                            15

                            No

                            Account Location

                            AccountLocation

                            DTYPE_TEXT

                            50

                            No

                            Agreement Id

                            AgreementId

                            DTYPE_ID

                            15

                            No

                            Asset Id

                            AssetId

                            DTYPE_ID

                            15

                            No

                            Closed Date

                            ClosedDate

                            DTYPE_TEXT

                            30

                            No

                            Commit Time

                            CommitTime

                            DTYPE_TEXT

                            30

                            No

                            Contact Business Phone

                            ContactBusinessPhone

                            DTYPE_TEXT

                            30

                            No

                            Contact Created

                            ContactCreated

                            DTYPE_TEXT

                            30

                            No

                            Contact First Name

                            ContactFirstName

                            DTYPE_TEXT

                            50

                            No

                            Contact Id

                            ContactId

                            DTYPE_ID

                            15

                            No

                            Contact Last Name

                            ContactLastName

                            DTYPE_TEXT

                            50

                            No

                            Customer Ref Number

                            CustomerRefNumber

                            DTYPE_TEXT

                            64

                            No

                            Description

                            Description

                            DTYPE_TEXT

                            2,000

                            No

                            Entitlement Id

                            EntitlementId

                            DTYPE_ID

                            15

                            No

                            Entitlement Name

                            EntitlementName

                            DTYPE_TEXT

                            50

                            No

                            Group Id

                            GroupId

                            DTYPE_ID

                            15

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Owned By Id

                            OwnedById

                            DTYPE_ID

                            15

                            No

                            Owner

                            Owner

                            DTYPE_TEXT

                            50

                            No

                            Primary Organization Id

                            PrimaryOrganizationId

                            DTYPE_ID

                            15

                            No

                            Primary Service Agreement Id

                            PrimaryServiceAgreementId

                            DTYPE_ID

                            15

                            No

                            Priority

                            Priority

                            DTYPE_TEXT

                            30

                            No

                            Product

                            Product

                            DTYPE_TEXT

                            100

                            No

                            Product Id

                            ProductId

                            DTYPE_ID

                            15

                            No

                            SR Number

                            SRNumber

                            DTYPE_TEXT

                            64

                            No

                            SR Type

                            SRType

                            DTYPE_TEXT

                            30

                            No

                            Serial Number

                            SerialNumber

                            DTYPE_TEXT

                            100

                            No

                            Service Request Type

                            ServiceRequestType

                            DTYPE_TEXT

                            30

                            No

                            Severity

                            Severity

                            DTYPE_TEXT

                            30

                            No

                            Source

                            Source

                            DTYPE_TEXT

                            30

                            No

                            Status

                            Status

                            DTYPE_TEXT

                            30

                            No

                            Sub-Area

                            Subarea

                            DTYPE_TEXT

                            30

                            No

                            Sub-Status

                            Sub-Status

                            DTYPE_TEXT

                            30

                            No

                            Type

                            Type

                            DTYPE_TEXT

                            30

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Siebel Service Request

                            The Siebel Service Request ASI is part of the Manage Service Request business process. Use this ASI to synchronize service requests in the Siebel application with an external target application. This ASI facilitates both outbound and inbound data synchronization between the Siebel application and an external target application.

                            The following image describes the Siebel Service Request ASI structure.

                            Siebel Service Request ASI. In this image, Service Request has a 1:M relationship with its children: Action and Account External Product.

                            The following table lists the integration components and user keys of this ASI.

                            Integration Component XML Tag User Keys

                            Action

                            Action

                            1. Id

                            2. Activity UID

                            Account External Product

                            AccountExternalProduct

                            1. Id

                            2. AEP Account Id, AEP Product Id, Version

                            Service Request

                            ServiceRequest

                            1. Id

                            2. Primary Organization Id, SR Number

                            SR External Product

                            SrExternalProduct

                            • Name, Version

                            Action Fields in Siebel Service Request ASI

                            The following table lists the Action fields and their attributes in Siebel Service Request ASI. Fields without a length specified do not have a maximum length associated with them.

                            Name XML Tag Data Type Length Required

                            Abstract

                            Abstract

                            DTYPE_TEXT

                            100

                            No

                            Activity SR Id

                            ActivitySRId

                            DTYPE_ID

                            15

                            No

                            Activity UID

                            ActivityUID

                            DTYPE_TEXT

                            30

                            No

                            Asset Id

                            AssetId

                            DTYPE_ID

                            15

                            No

                            Asset Number

                            AssetNumber

                            DTYPE_TEXT

                            100

                            No

                            Audience

                            Audience

                            DTYPE_TEXT

                            30

                            No

                            Comment

                            Comment

                            DTYPE_TEXT

                            1,500

                            No

                            Description

                            Description3

                            DTYPE_TEXT

                            100

                            No

                            Done

                            Done

                            DTYPE_TEXT

                            30

                            No

                            Duration Hours

                            DurationHours

                            DTYPE_NUMBER

                            22

                            No

                            Duration Minutes

                            DurationMinutes

                            DTYPE_NUMBER

                            22

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Planned

                            Planned

                            DTYPE_TEXT

                            30

                            No

                            Planned Completion

                            PlannedCompletion

                            DTYPE_TEXT

                            30

                            No

                            Primary Owner Id

                            PrimaryOwnerId

                            DTYPE_ID

                            15

                            No

                            Resolution Code

                            ResolutionCode

                            DTYPE_TEXT

                            30

                            No

                            Started

                            Started

                            DTYPE_TEXT

                            30

                            No

                            Type

                            Type

                            DTYPE_TEXT

                            30

                            No

                            Account External Product Fields in Siebel Service Request ASI

                            The following table lists the Account External Product fields and their attributes in Siebel Service Request ASI. Fields without a length specified do not have a maximum length associated with them.

                            Name XML Tag Data Type Length Required

                            AEP Account Id

                            AEPAccountId

                            DTYPE_ID

                            30

                            No

                            AEP Product Id

                            AEPProductId

                            DTYPE_ID

                            30

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Version

                            Version

                            DTYPE_TEXT

                            30

                            No

                            Service Request Fields in Siebel Service Request ASI

                            The following table lists the Service Request fields and their attributes in Siebel Service Request ASI. Fields without a length specified do not have a maximum length associated with them.

                            Name XML Tag Data Type Length Required

                            Abstract

                            Abstract

                            DTYPE_TEXT

                            100

                            No

                            Account

                            Account

                            DTYPE_TEXT

                            100

                            No

                            Account Id

                            AccountId

                            DTYPE_ID

                            15

                            No

                            Account Location

                            AccountLocation

                            DTYPE_TEXT

                            50

                            No

                            Agreement Id

                            AgreementId

                            DTYPE_ID

                            15

                            No

                            Area

                            Area

                            DTYPE_TEXT

                            30

                            No

                            Asset Id

                            AssetId

                            DTYPE_ID

                            15

                            No

                            Closed Date

                            ClosedDate

                            DTYPE_TEXT

                            30

                            No

                            Commit Time

                            CommitTime

                            DTYPE_TEXT

                            30

                            No

                            Contact Business Phone

                            ContactBusinessPhone

                            DTYPE_TEXT

                            NA

                            No

                            Contact Created

                            ContactCreated

                            DTYPE_TEXT

                            30

                            No

                            Contact First Name

                            ContactFirstName

                            DTYPE_TEXT

                            50

                            No

                            Contact Id

                            ContactId

                            DTYPE_ID

                            15

                            No

                            Contact Last Name

                            ContactLastName

                            DTYPE_TEXT

                            50

                            No

                            Customer Reference Number

                            CustomerReferenceNumber

                            DTYPE_TEXT

                            64

                            No

                            Description

                            Description

                            DTYPE_TEXT

                            2,000

                            No

                            Entitlement Id

                            EntitlementId

                            DTYPE_ID

                            15

                            No

                            Entitlement Name

                            EntitlementName

                            DTYPE_TEXT

                            50

                            No

                            Group Id

                            GroupId

                            DTYPE_ID

                            NA

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Owned By Id

                            OwnedById

                            DTYPE_ID

                            30

                            No

                            Owner

                            Owner

                            DTYPE_TEXT

                            50

                            No

                            Primary Organization Id

                            PrimaryOrganizationId

                            DTYPE_ID

                            15

                            No

                            Primary Service Agreement Id

                            PrimaryServiceAgreementId

                            DTYPE_ID

                            15

                            No

                            Priority

                            Priority

                            DTYPE_TEXT

                            30

                            No

                            Product

                            Product

                            DTYPE_TEXT

                            100

                            No

                            Product Id

                            ProductId

                            DTYPE_ID

                            15

                            No

                            SR Number

                            SRNumber

                            DTYPE_TEXT

                            64

                            No

                            SR Type

                            SRType

                            DTYPE_TEXT

                            30

                            No

                            Serial Number

                            SerialNumber

                            DTYPE_TEXT

                            NA

                            No

                            Service Request Type

                            ServiceRequestType

                            DTYPE_TEXT

                            30

                            No

                            Severity

                            Severity

                            DTYPE_TEXT

                            30

                            No

                            Source

                            Source

                            DTYPE_TEXT

                            30

                            No

                            Status

                            Status

                            DTYPE_TEXT

                            30

                            No

                            Sub-Area

                            Sub-Area

                            DTYPE_TEXT

                            30

                            No

                            Sub-Status

                            Sub-Status

                            DTYPE_TEXT

                            30

                            No

                            Type

                            Type

                            DTYPE_TEXT

                            30

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            SR External Product Fields in Siebel Service Request ASI

                            The following table lists the SR External Product fields and their attributes in Siebel Service Request ASI. Fields without a length specified do not have a maximum length associated with them.

                            Name XML Tag Data Type Length Required

                            Name

                            Name

                            DTYPE_TEXT

                            100

                            No

                            Version

                            Version

                            DTYPE_TEXT

                            30

                            No

                            Siebel Simple Product

                            The Siebel Simple Product ASI receives information about simple products created in third-party systems and enables users to create, update, and query a product in the Siebel application. The Siebel Simple Product ASI is intended to synchronize the Siebel application to external product masters, and does not support the receipt of information for customized products or bundles.

                            The following image describes the structure of the Siebel Simple Product ASI.

                            Siebel Simple Product ASI. In this image, Internal product has a 1:M relationship with children: Related Product Line, Related Equivalent Product, Inventory Options, Related Warranty and Related Product, Related Organization, Product Inventory, Related Sales Tool By Product, and Related Inventory Location.

                            The following table lists the integration components and user keys for this ASI.

                            Integration Component XML Tag User Keys

                            Internal Product

                            InternalProduct

                            1. Id

                            2. Integration Id

                            3. Product Name, Primary Organization, Primary Vendor, Vendor Site, Vendor Primary Organization

                            Inventory Options

                            InventoryOptions

                            1. Id

                            2. Integration Id

                            3. Inventory Type, Product Name

                            Product Inventory

                            ProductInventory

                            1. Id

                            2. Product Name, Inventory Location Id

                            Related Equivalent Product

                            RelatedEquivalentProduct

                            1. Id

                            2. Integration Id

                            3. Equivalent Product, Equivalent Product Primary Organization, Equivalent Product Vendor, Equivalent Product Vendor Location, Equivalent Product Vendor Organization

                            Related Inventory Location

                            RelatedInventoryLocation

                            1. Id

                            2. Integration Id

                            3. Inventory Name, Primary Organization

                            Related Organization

                            RelatedOrganization

                            1. Id

                            2. Integration Id

                            3. Organization

                            Related Product

                            RelatedProduct

                            1. Id

                            2. Integration Id

                            3. Product Name, Vendor, Vendor Location, Organization

                            Related Product Line

                            RelatedProductLine

                            1. Id

                            2. Integration Id

                            3. Product Line

                            Related Sales Tool by Product

                            RelatedSalesToolByProduct

                            1. Id

                            2. Integration Id

                            3. Name, Primary Organization

                            Related Warranty

                            RelatedWarranty

                            1. Id

                            2. Integration Id

                            3. Warranty Name, Warranty Provider Name, Warranty Provider Primary Organization, Warranty Provider Site

                            Internal Product Fields in Siebel Simple Product ASI

                            The following table lists the Internal Product fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Allocate Below Safety Flag

                            AllocateBelowSafetyFlag

                            DTYPE_TEXT

                            30

                            No

                            Auto Allocate Flag

                            AutoAllocateFlag

                            DTYPE_TEXT

                            30

                            No

                            Auto Substitute Flag

                            AutoSubstituteFlag

                            DTYPE_TEXT

                            30

                            No

                            Class Id

                            ClassId

                            DTYPE_ID

                            NA

                            No

                            Class Integration Id

                            ClassIntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Class Name

                            ClassName

                            DTYPE_TEXT

                            75

                            No

                            Class Type

                            ClassType

                            DTYPE_TEXT

                            30

                            No

                            Compensable

                            CompensableFlag

                            DTYPE_TEXT

                            NA

                            No

                            Description

                            Description

                            DTYPE_TEXT

                            255

                            No

                            Division Code

                            DivisionCode

                            DTYPE_TEXT

                            30

                            No

                            Effective End Date

                            EffectiveEndDate

                            DTYPE_DATETIME

                            NA

                            No

                            Effective Start Date

                            EffectiveStartDate

                            DTYPE_DATETIME

                            NA

                            No

                            Field Replacable

                            FieldReplacable

                            DTYPE_TEXT

                            NA

                            No

                            Global Assembly Level Code

                            GlobalAssemblyLevelCode

                            DTYPE_TEXT

                            50

                            No

                            Global Product Classification Code

                            GlobalProductClassificationCode

                            DTYPE_TEXT

                            50

                            No

                            Global Product Identifier

                            GlobalProductIdentifier

                            DTYPE_TEXT

                            50

                            No

                            Global Product Lifecycle Status Code

                            GlobalProductLifecycleStatusCode

                            DTYPE_TEXT

                            50

                            No

                            Global Supply Chain Code

                            GlobalSupplyChainCode

                            DTYPE_TEXT

                            50

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Image Name

                            ImageName

                            DTYPE_TEXT

                            100

                            No

                            Image Primary Organization Name

                            ImagePrimaryOrganizationName

                            DTYPE_TEXT

                            100

                            No

                            ImageFileName

                            ImageFileName

                            DTYPE_TEXT

                            200

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            IsAdminMode

                            IsAdminMode

                            DTYPE_TEXT

                            NA

                            No

                            Item Size

                            ItemSize

                            DTYPE_NUMBER

                            NA

                            No

                            Lead Time

                            LeadTime

                            DTYPE_TEXT

                            30

                            No

                            MTBF

                            MTBF

                            DTYPE_NUMBER

                            NA

                            No

                            MTTR

                            MTTR

                            DTYPE_NUMBER

                            NA

                            No

                            Maximum Quantity

                            MaximumQuantity

                            DTYPE_NUMBER

                            NA

                            No

                            Minimum Quantity

                            MinimumQuantity

                            DTYPE_NUMBER

                            NA

                            No

                            Orderable

                            Orderable

                            DTYPE_TEXT

                            NA

                            No

                            Parent Internal Product Id (Joined)

                            ParentInternalProductId

                            DTYPE_ID

                            NA

                            No

                            Parent Internal Product Integration Id

                            ParentInternalProductIntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Parent Internal Product Name

                            ParentInternalProductName

                            DTYPE_TEXT

                            100

                            No

                            Parent Internal Product Primary Organization

                            ParentInternalProductPrimaryOrganization

                            DTYPE_TEXT

                            100

                            No

                            Parent Internal Product Vendor

                            ParentInternalProductVendor

                            DTYPE_TEXT

                            100

                            No

                            Parent Internal Product Vendor Location

                            ParentInternalProductVendorLocation

                            DTYPE_TEXT

                            50

                            No

                            Parent Internal Product Vendor Organization

                            ParentInternalProductVendorOrganization

                            DTYPE_TEXT

                            100

                            No

                            Part Number

                            PartNumber

                            DTYPE_TEXT

                            50

                            No

                            Primary Organization

                            PrimaryOrganization

                            DTYPE_TEXT

                            50

                            No

                            Primary Vendor

                            PrimaryVendor

                            DTYPE_TEXT

                            100

                            No

                            Product Image Id

                            ProductImageId

                            DTYPE_ID

                            NA

                            No

                            Product Image Integration Id

                            ProductImageIntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Product Level

                            ProductLevel

                            DTYPE_NUMBER

                            NA

                            No

                            Product Name

                            ProductName

                            DTYPE_TEXT

                            100

                            No

                            Product Thumbnail Image Id

                            ProductThumbnailImageId

                            DTYPE_ID

                            NA

                            No

                            Product Type

                            ProductType

                            DTYPE_TEXT

                            30

                            No

                            Return if Defective

                            ReturnifDefective

                            DTYPE_TEXT

                            NA

                            No

                            Revision

                            Version

                            DTYPE_TEXT

                            30

                            No

                            Sales Product

                            SalesProduct

                            DTYPE_TEXT

                            NA

                            No

                            Serialized

                            Serialized

                            DTYPE_TEXT

                            NA

                            No

                            Service Product

                            ServiceProduct

                            DTYPE_TEXT

                            NA

                            No

                            Ship Carrier

                            Carrier

                            DTYPE_TEXT

                            30

                            No

                            Shipping Via

                            ShippingVia

                            DTYPE_TEXT

                            30

                            No

                            Status

                            Status

                            DTYPE_TEXT

                            30

                            No

                            Targeted Country

                            TargetedCountry

                            DTYPE_TEXT

                            250

                            No

                            Targeted Industry

                            TargetedIndustry

                            DTYPE_TEXT

                            250

                            No

                            Targeted Max Age

                            TargetedMaxAge

                            DTYPE_NUMBER

                            NA

                            No

                            Targeted Min Age

                            TargetedMinAge

                            DTYPE_NUMBER

                            NA

                            No

                            Targeted Postal Code

                            TargetedPostalCode

                            DTYPE_TEXT

                            250

                            No

                            Tool Flag

                            ToolFlag

                            DTYPE_TEXT

                            NA

                            No

                            Unit of Measure

                            UnitofMeasure

                            DTYPE_TEXT

                            30

                            No

                            Units In Inventory

                            UnitsInInventory

                            DTYPE_NUMBER

                            NA

                            No

                            Units In Inventory As Of

                            UnitsInInventoryAsOf

                            DTYPE_TEXT

                            NA

                            No

                            Vendor Id

                            VendorId

                            DTYPE_ID

                            NA

                            No

                            Vendor Integration Id

                            VendorIntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Vendor Part Number

                            VendorPartNumber

                            DTYPE_TEXT

                            50

                            No

                            Vendor Primary Organization

                            VendorPrimaryOrganization

                            DTYPE_TEXT

                            100

                            No

                            Vendor Site

                            VendorSite

                            DTYPE_TEXT

                            50

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Inventory Options Fields in Siebel Simple Product ASI

                            The following table lists the Inventory Options fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Allocate Below Safety Flag

                            AllocateBelowSafetyFlag

                            DTYPE_TEXT

                            30

                            No

                            Auto Allocate Flag

                            AutoAllocateFlag

                            DTYPE_TEXT

                            30

                            No

                            Auto Substitute Flag

                            AutoSubstituteFlag

                            DTYPE_TEXT

                            30

                            No

                            Class ABC

                            ClassABC

                            DTYPE_TEXT

                            30

                            No

                            Class XYZ

                            ClassXYZ

                            DTYPE_TEXT

                            30

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Inventory Type

                            InventoryType

                            DTYPE_TEXT

                            30

                            No

                            Product Name

                            ProductName

                            DTYPE_TEXT

                            100

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Product Inventory Fields in Siebel Simple Product ASI

                            The following table lists the Product Inventory fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Allocate Below Safety Stock Flag

                            AllocateBelowSafetyStockFlag

                            DTYPE_TEXT

                            30

                            No

                            Auto Allocate Flag

                            AutoAllocateFlag

                            DTYPE_TEXT

                            30

                            No

                            Auto Substitute Flag

                            AutoSubstituteFlag

                            DTYPE_TEXT

                            30

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Inventory Location Id

                            InventoryLocationId

                            DTYPE_ID

                            30

                            No

                            Maximum Inventory Level

                            MaximumInventoryLevel

                            DTYPE_NUMBER

                            22

                            No

                            Minimum Inventory Level

                            MinimumInventoryLevel

                            DTYPE_NUMBER

                            22

                            No

                            Movement Class

                            MovementClass

                            DTYPE_TEXT

                            30

                            No

                            Product Id

                            ProductId

                            DTYPE_TEXT

                            30

                            No

                            Product Name

                            ProductName

                            DTYPE_TEXT

                            100

                            No

                            Safety Stock Level

                            SafetyStockLevel

                            DTYPE_NUMBER

                            22

                            No

                            Value Class

                            ValueClass

                            DTYPE_TEXT

                            30

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Equivalent Product Fields in Siebel Simple Product ASI

                            The following table lists the Related Equivalent Product fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Equivalent Product

                            EquivalentProduct

                            DTYPE_TEXT

                            100

                            No

                            Equivalent Product Primary Organization

                            EquivalentProductPrimaryOrganization

                            DTYPE_TEXT

                            50

                            No

                            Equivalent Product Vendor

                            EquivalentProductVendor

                            DTYPE_TEXT

                            100

                            No

                            Equivalent Product Vendor Location

                            EquivalentProductVendorLocation

                            DTYPE_TEXT

                            50

                            No

                            Equivalent Product Vendor Organization

                            EquivalentProductVendorOrganization

                            DTYPE_TEXT

                            100

                            No

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            IsPrimaryMVG

                            IsPrimaryMVG

                            DTYPE_TEXT

                            1

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Inventory Location Fields in Siebel Simple Product ASI

                            The following table lists the Related Inventory Location fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Inventory Name

                            InventoryName

                            DTYPE_TEXT

                            100

                            No

                            Primary Organization Name

                            PrimaryOrganizationName

                            DTYPE_TEXT

                            100

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Organization Fields in Siebel Simple Product ASI

                            The following table lists the Related Organization fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            IsPrimaryMVG

                            IsPrimaryMVG

                            DTYPE_TEXT

                            1

                            No

                            Organization

                            Organization

                            DTYPE_TEXT

                            50

                            No

                            Sales Unit of Measure

                            SalesUnitofMeasure

                            DTYPE_TEXT

                            30

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Product Fields in Siebel Simple Product ASI

                            The following table lists the Related Product fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            IsPrimaryMVG

                            IsPrimaryMVG

                            DTYPE_TEXT

                            1

                            No

                            Organization

                            Organization

                            DTYPE_TEXT

                            50

                            No

                            Product Name

                            ProductName

                            DTYPE_TEXT

                            100

                            No

                            Vendor

                            Vendor

                            DTYPE_TEXT

                            100

                            No

                            Vendor Location

                            VendorLocation

                            DTYPE_TEXT

                            50

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Product Line Fields in Siebel Simple Product ASI

                            The following table lists the Related Product Line fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            IsPrimaryMVG

                            IsPrimaryMVG

                            DTYPE_TEXT

                            1

                            No

                            Product Line

                            ProductLine

                            DTYPE_TEXT

                            100

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Sales Tool by Product Fields in Siebel Simple Product ASI

                            The following table lists the Related Sales Tool by Product fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Literature Type

                            LiteratureType

                            DTYPE_TEXT

                            30

                            No

                            LitFileName

                            LitFileName

                            DTYPE_TEXT

                            220

                            No

                            Name

                            Name

                            DTYPE_TEXT

                            50

                            No

                            Primary Organization

                            PrimaryOrganization

                            DTYPE_TEXT

                            50

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No

                            Related Warranty Fields in Siebel Simple Product ASI

                            The following table lists the Related Warranty fields and their attributes in Siebel Simple Product ASI. Fields without a length specified do not have a maximum length associated with them

                            Name XML Tag Data Type Length Req.

                            Id

                            Id

                            DTYPE_ID

                            30

                            No

                            Integration Id

                            IntegrationId

                            DTYPE_TEXT

                            30

                            No

                            Warranty Name

                            WarrantyName

                            DTYPE_TEXT

                            100

                            No

                            Warranty Provider Name

                            WarrantyProviderName

                            DTYPE_TEXT

                            100

                            No

                            Warranty Provider Primary Organization

                            WarrantyProviderPrimaryOrganization

                            DTYPE_TEXT

                            100

                            No

                            Warranty Provider Site

                            WarrantyProviderSite

                            DTYPE_TEXT

                            50

                            No

                            operation

                            operation

                            DTYPE_TEXT

                            30

                            No

                            searchspec

                            searchspec

                            DTYPE_TEXT

                            250

                            No