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 in the following tables.

About Prebuilt ASIs

The following table lists the prebuilt ASIs provided by Oracle.

Table Prebuilt Application Services Interfaces

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/External Opportunity Query/External Opportunity Update

ASI to facilitate the inbound and outbound transfer of opportunity data from the Siebel application. For details, see External Opportunity Create/External Opportunity Query/External Opportunity 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

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

Table Siebel Account Integration Components

Integration Component XML Tag User Keys

Account

Account

  1. Account Id

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

Business Address

BusinessAddress

  1. Address Id

  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

  1. 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

  1. 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

The following table lists the fields and attributes of this ASI.

Table Siebel Account ASI Fields

Name XML Tag Data Type Length Req. Notes

Account

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 for picking 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 for picking 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

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

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

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

Industry

Industry

DTYPE_TEXT

50

No

None

Industry Id

IndustryId

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

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

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

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

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

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

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

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

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

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

Table Siebel Action Integration Components

Integration Component XML Tag User Keys

Action

Action

  1. Id

  2. Activity UID

Action_Contact

Action_Contact

  1. Contact Id

Activity Prospects

ActivityProspects

  1. Prospective Contact UID

Contact(All)

ContactAll

  1. Party UId

Employee (MM)

EmployeeMm

  1. Party UId

Expense Item

ExpenseItem

  1. Expense Item Number, Owner Id

FS Activity Parts Movement

FsactivityPartsMovement

  1. 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

  1. SeqNum, Step Type Id

FS Instruction

FsInstruction

  1. Instruction, Instruction Type

Internal Product

InternalProduct

  1. Id

Messaging

Messaging

  1. Message Number

Time Sheet Daily Hours

TimeSheetDailyHours

  1. Id

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

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

Table Siebel Action ASI Fields

Name XML Tag Data Type Length Req.

Action

Account Id

AccountId

DTYPE_ID

Not applicable

No

Activity SR Id

ActivitySRId

DTYPE_ID

Not applicable

No

Activity UID

ActivityUID

DTYPE_TEXT

30

No

Alarm

Alarm

DTYPE_TEXT

Not applicable

No

Appt Alarm Time Min

ApptAlarmTimeMin

DTYPE_NUMBER

Not applicable

No

Asset Id

AssetId

DTYPE_ID

Not applicable

No

Assignment Excluded

AssignmentExcluded

DTYPE_TEXT

Not applicable

No

Associated Cost

AssociatedCost

DTYPE_TEXT

Not applicable

No

Audience

Audience

DTYPE_TEXT

30

No

Billable Flag

BillableFlag

DTYPE_TEXT

Not applicable

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

Not applicable

No

Description

Description

DTYPE_TEXT

100

No

Display

Display

DTYPE_TEXT

30

No

Done

Done

DTYPE_DATETIME

Not applicable

No

Due

Due

DTYPE_TEXT

Not applicable

No

Est Work Time Remaining

EstWorkTimeRemaining

DTYPE_NUMBER

Not applicable

No

Exchange Date

ExchangeDate

DTYPE_DATETIME

Not applicable

No

Id

Id

DTYPE_ID

30

No

Meeting Location

MeetingLocation

DTYPE_TEXT

100

No

No Sooner Than Date

NoSoonerThanDate

DTYPE_DATETIME

Not applicable

No

Opportunity Id

OpportunityId

DTYPE_ID

Not applicable

No

Percent Complete

PercentComplete

DTYPE_NUMBER

Not applicable

No

Planned

Planned

DTYPE_DATETIME

Not applicable

No

Planned Completion

PlannedCompletion

DTYPE_DATETIME

Not applicable

No

Previous Activity Id

PreviousActivityId

DTYPE_ID

Not applicable

No

Price List Id

PriceListId

DTYPE_ID

Not applicable

No

Primary Owner Id

PrimaryOwnerId

DTYPE_ID

Not applicable

No

Priority

Priority

DTYPE_TEXT

30

No

Private

Private

DTYPE_TEXT

Not applicable

No

Rate List Id

RateListId

DTYPE_ID

Not applicable

No

Repeating Expires

RepeatingExpires

DTYPE_DATETIME

Not applicable

No

Repeating Type

RepeatingType

DTYPE_TEXT

30

No

Resolution Code

ResolutionCode

DTYPE_TEXT

30

No

Started

Started

DTYPE_DATETIME

Not applicable

No

Status

Status

DTYPE_TEXT

30

No

Status Report Flag

StatusReportFlag

DTYPE_TEXT

Not applicable

No

Type

Type

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

searchspec

searchspec

DTYPE_TEXT

250

No

Action_Contact

Contact Id

Contact Id

DTYPE_ID

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Activity_Prospects

Prospective Contact UID

ProspectiveContactUID

DTYPE_TEXT

100

No

Contact

Party UId

PartyUId

DTYPE_TEXT

30

No

Employee (MM)

Party UId

PartyUId

DTYPE_TEXT

30

No

Expense Item

Account Id

AccountId

DTYPE_ID

Not applicable

No

Amount

Amount

DTYPE_TEXT

Not applicable

No

Billable Flag

BillableFlag

DTYPE_TEXT

Not applicable

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

Not applicable

No

Establishment

Establishment

DTYPE_TEXT

50

No

Exchange Date

ExchangeDate

DTYPE_DATETIME

Not applicable

No

Exchange Rate

ExchangeRate

DTYPE_NUMBER

Not applicable

No

Expense Item Number

ExpenseItemNumber

DTYPE_ID

Not applicable

No

Expense Item Type

ExpenseItemTypeName

DTYPE_TEXT

50

No

Internal Comments

InternalComments

DTYPE_TEXT

250

No

Item Room Amount

ItemRoomAmount

DTYPE_TEXT

Not applicable

No

Item Room Other Tax Amount

ItemRoomOtherTaxAmount

DTYPE_TEXT

Not applicable

No

Item Room Tax Amount

ItemRoomTaxAmount

DTYPE_TEXT

Not applicable

No

Mileage Distance

MileageDistance

DTYPE_NUMBER

Not applicable

No

Mileage Rate

MileageRate

DTYPE_TEXT

Not applicable

No

Mileage Route

MileageRoute

DTYPE_TEXT

100

No

Opty Id

OptyId

DTYPE_ID

Not applicable

No

Owner Id

OwnerId

DTYPE_ID

Not applicable

No

Payment Type

PaymentType

DTYPE_TEXT

30

No

Project Billing Class

ProjectBillingClass

DTYPE_TEXT

30

No

Reimbursable Flag

ReimbursablFlag

DTYPE_TEXT

Not applicable

No

Start Date

StartDate

DTYPE_DATETIME

Not applicable

No

FS Activity Parts Movement

Asset Id

AssetId

DTYPE_ID

Not applicable

No

Billable Flag

BillableFlag

DTYPE_TEXT

Not applicable

No

Commit Txn Flag

CommitTxnFlag

DTYPE_TEXT

Not applicable

No

Destination

Destination

DTYPE_TEXT

30

No

Movement Date

MovementDate

DTYPE_DATETIME

Not applicable

No

Order Id

OrderId

DTYPE_ID

Not applicable

No

Order Item Id

OrderItemId

DTYPE_ID

Not applicable

No

PartMvtNum

PartMvtNum

DTYPE_ID

Not applicable

No

Product Id

ProductId

DTYPE_ID

Not applicable

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

Not applicable

No

Used Quantity

UsedQuantity

DTYPE_NUMBER

Not applicable

No

FS Activity Skill

Comments

Comments

DTYPE_TEXT

250

No

Item Type Name

ItemTypeName

DTYPE_TEXT

75

No

Name

Name

DTYPE_TEXT

50

No

FS Activity Skill Item

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

Not applicable

No

Product Id

ProdId

DTYPE_TEXT

Not applicable

No

FS Activity Step

Comments

Comments

DTYPE_TEXT

250

No

End Date

EndDate

DTYPE_DATETIME

Not applicable

No

Performed

Performed

DTYPE_TEXT

Not applicable

No

Performed by

Performedby

DTYPE_ID

Not applicable

No

SeqNum

SeqNum

DTYPE_NUMBER

Not applicable

No

Start Date

StartDate

DTYPE_DATETIME

Not applicable

No

Step Type Id

StepTypeId

DTYPE_ID

Not applicable

No

FS Instruction

Instruction

Instruction

DTYPE_NOTE

Not applicable

No

Instruction Type

InstructionType

DTYPE_TEXT

30

No

Messaging

Account Id

AccountId

DTYPE_ID

Not applicable

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

Not applicable

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

Not applicable

No

Priority

Priority

DTYPE_TEXT

30

No

Private Flag

PrivateFlag

DTYPE_TEXT

Not applicable

No

Recipient Id

Recipient Id

DTYPE_ID

Not applicable

No

Sender Id

SenderId

DTYPE_ID

Not applicable

No

Service Request Id

ServiceRequestId

DTYPE_ID

Not applicable

No

Time Sheet Daily Hours

Billable Flag

BillableFlag

DTYPE_TEXT

Not applicable

No

Billing Class

BillingClass

DTYPE_TEXT

Not applicable

No

Billing Rate Type

BillingRateType

DTYPE_TEXT

Not applicable

No

Created

Created

DTYPE_DATETIME

Not applicable

No

End Time

EndTime

DTYPE_DATETIME

Not applicable

No

External Comments

ExternalComments

DTYPE_TEXT

Not applicable

No

Id

Id

DTYPE_ID

Not applicable

No

Internal Comments

InternalComments

DTYPE_TEXT

Not applicable

No

Item Date

ItemDate

DTYPE_DATETIME

Not applicable

No

Oppty Id

OpptyId

DTYPE_ID

Not applicable

No

Owner Id

OwnerId

DTYPE_ID

Not applicable

No

Project Id

ProjectId

DTYPE_ID

Not applicable

No

Service Request Id

ServiceRequestId

DTYPE_ID

Not applicable

No

Start Time

StartTime

DTYPE_DATETIME

Not applicable

No

Time Sheet Item Num

TimeSheetItemNum

DTYPE_TEXT

Not applicable

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

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

Table Siebel Business Address Integration Components

Integration Component XML Tag User Keys

Address

Address

  1. Id

  2. Integration Id

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

Table Siebel Business Address ASI Fields

Name XML Tag Data Type Length Required

Address

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

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

Table Siebel Personal Address Integration Components

Integration Component XML Tag User Keys

Address

Address

  1. Id

  2. Integration Id

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

Table Siebel Personal Address ASI Fields

Name XML Tag Data Type Length Required

Address

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

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

Table Siebel Asset Integration Components

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

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

Table Siebel Asset ASI Fields

Name XML Tag Data Type Length Req.

Asset Mgmt - Asset XA

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

Asset Mgmt - Asset - Header

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

Not applicable

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

Not applicable

No

Quantity

Quantity

DTYPE_NUMBER

Not applicable

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

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

Not applicable

No

Id

Id

DTYPE_ID

15

No

Install Date

InstallDate

DTYPE_DATETIME

Not applicable

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

Not applicable

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

Not applicable

No

Quantity

Quantity

DTYPE_NUMBER

Not applicable

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

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

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

Table Siebel Contact Integration Components

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

  3. Account, Account Organization

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

The following table lists the fields and their attributes.

Table Siebel Contact ASI Fields

Name XML Tag Data Type Length Req. Note

Contact

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

NA

No

None

Social Security Number

SocialSecurityNumber

DTYPE_TEXT

NA

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

NA

No

None

Suppress All Mailings

SuppressAllMailings

DTYPE_TEXT

1

No

None

Time Zone Id

TimeZoneId

DTYPE_ID

NA

No

None

Time Zone Name

TimeZoneName

DTYPE_TEXT

100

No

None

Work Phone #

WorkPhone

DTYPE_TEXT

NA

No

None

Work Phone Extension

WorkPhoneExtension

DTYPE_TEXT

10

No

None

Personal Address

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

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

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

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

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

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

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

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

Table Siebel CUT Address MSAG Service Integration Components

Integration Component XML Tag User Keys

CUT MSAG Profile

CutMsagProfile

  1. Id

  2. Address Id, Profile Type

The following table lists the fields and their attributes.

Table Siebel CUT Address MSAG Service ASI Fields

Name XML Tag Data Type Length Req.

CUT MSAG Profile

Address Id

AddressId

DTYPE_ID

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

Not applicable

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

Not applicable

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

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

Table Siebel Cost List Integration Components

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

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

Table Siebel Cost List ASI Fields

Name XML Tag Data Type Length Req. Note

Cost List

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 for picking 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

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

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

  • User key field.

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

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

  • User key field.

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

The following table lists the Siebel Employee integration components.

Table 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

  1. 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

The following table lists the fields and their attributes.

Table Siebel Employee ASI Fields

Name XML Tag Data Type Length Req.

CMS Certifications Qualifications

Certification

Certification

DTYPE_TEXT

30

No

Comments

Comments

DTYPE_TEXT

250

No

Date of Certification

DateofCertification

DTYPE_TEXT

Not applicable

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

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

Not applicable

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

Not applicable

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

Competency Id

CompetencyId

DTYPE_ID

Not applicable

No

Skill Name

SkillName

DTYPE_TEXT

50

No

Current Skill Level

CurrentSkillLevel

DTYPE_TEXT

100

No

Current Skill Level Id

CurrentSkillLevelId

DTYPE_ID

Not applicable

No

Current Skill Level Value

CurrentSkillLevelValue

DTYPE_NUMBER

Not applicable

No

Date of Accomplishment

DateOfAccomplishment

DTYPE_DATETIME

Not applicable

No

Employee Id

EmployeeId

DTYPE_ID

Not applicable

No

Id

Id

DTYPE_ID

30

No

Required Skill Level Value

RequiredSkillLevelValue

DTYPE_NUMBER

Not applicable

No

Required Skill Level Id

RequiredSkillLevel Id

DTYPE_ID

Not applicable

No

Parent Skill

ParentSkill

DTYPE_TEXT

50

No

Rating Scale Id

RatingScaleId

DTYPE_ID

Not applicable

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

Not applicable

No

Skill Description

SkillDescription

DTYPE_TEXT

250

No

Root Category Id

RootCategoryId

DTYPE_ID

Not applicable

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

Not applicable

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

Not applicable

No

Assessment Type

AssessmentType

DTYPE_TEXT

30

No

Approved By Id

ApprovedById

DTYPE_ID

Not applicable

No

Mod Id

ModId

DTYPE_ID

30

No

CMS Honors Awards

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

Not applicable

No

Relevance to Company

RelevancetoCompany

DTYPE_TEXT

30

No

operation

operation

DTYPE_TEXT

30

No

CMS Memberships

Active Status

ActiveStatus

DTYPE_TEXT

Not applicable

No

Comments

Comments

DTYPE_TEXT

250

No

End Date

EndDate

DTYPE_TEXT

Not applicable

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

Not applicable

No

operation

operation

DTYPE_TEXT

30

No

CMS Past Work Experience

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

Not applicable

No

First Name

FirstName

DTYPE_TEXT

50

No

Id

Id

DTYPE_ID

30

No

Industry

Industry

DTYPE_ID

Not applicable

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

Not applicable

No

operation

operation

DTYPE_TEXT

30

No

Employee

Alias

Alias

DTYPE_TEXT

50

No

Availability Status

AvailabilityStatus

DTYPE_TEXT

30

No

Availability Status Until

AvailabilityStatusUntil

DTYPE_TEXT

Not applicable

No

Bonus Target %

BonusTarget

DTYPE_NUMBER

Not applicable

No

Building Number

BuildingNumber

DTYPE_TEXT

30

No

CP Region

CPRegion

DTYPE_TEXT

50

No

CP Region Id

CPRegionId

DTYPE_ID

Not applicable

No

CP Region Integration Id

CPRegionIntegrationId

DTYPE_TEXT

30

No

Cell Phone #

CellPhone

DTYPE_TEXT

Not applicable

No

Cost Currency Code

CostCurrencyCode

DTYPE_TEXT

30

No

Cost Per Hour

CostPerHour

DTYPE_TEXT

Not applicable

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

Not applicable

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

Not applicable

No

First Name

FirstName

DTYPE_TEXT

50

No

Hire Date

HireDate

DTYPE_DATETIME

Not applicable

No

Home Phone #

HomePhone

DTYPE_TEXT

Not applicable

No

Id

Id

DTYPE_ID

30

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

Job Code Id

JobCodeId

DTYPE_ID

Not applicable

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

Not applicable

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

Not applicable

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

Not applicable

No

Pager Type

PagerType

DTYPE_TEXT

30

No

Personal Title

PersonalTitle

DTYPE_TEXT

15

No

Phone #

Phone

DTYPE_TEXT

Not applicable

No

Preferred Communications

PreferredCommunications

DTYPE_TEXT

30

No

Private

Private

DTYPE_TEXT

Not applicable

No

Readiness

Readiness

DTYPE_TEXT

30

No

Seniority Date

SeniorityDate

DTYPE_TEXT

Not applicable

No

Share Address Flag

ShareAddressFlag

DTYPE_TEXT

Not applicable

No

Share Home Phone Flag

ShareHomePhoneFlag

DTYPE_TEXT

Not applicable

No

Shift Id

ShiftId

DTYPE_ID

Not applicable

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

Not applicable

No

Termination Date

TerminationDate

DTYPE_DATETIME

Not applicable

No

Time Zone Id

TimeZoneId

DTYPE_ID

Not applicable

No

Time Zone Name

TimeZoneName

DTYPE_TEXT

100

No

operation

operation

DTYPE_TEXT

30

No

Employee_Employee Organization

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

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

Division

Division

DTYPE_TEXT

255

No

Division Id

DivisionId

DTYPE_ID

Not applicable

No

Division Integration Id

DivisionIntegrationId

DTYPE_TEXT

30

No

Employee End Date

EmployeeEndDate

DTYPE_DATETIME

NA

No

Employee Start Date

EmployeeStartDate

DTYPE_DATETIME

Not applicable

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

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

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

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

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

Division

Division

DTYPE_TEXT

255

No

Division Id

DivisionId

DTYPE_ID

Not applicable

No

Division Integration Id

DivisionIntegrationId

DTYPE_TEXT

30

No

Employee End Date

EmployeeEndDate

DTYPE_DATETIME

Not applicable

No

Employee Start Date

EmployeeStartDate

DTYPE_DATETIME

Not applicable

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

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

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

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

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

Table Siebel Financial Account Integration Components

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

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

Table Siebel Financial Account ASI Fields

Name XML Tag Data Type Length Req.

FINCORPAccount

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

Not applicable

No

Account Branch Name

AccountBranchName

DTYPE_TEXT

100

No

Account Branch Number

AccountBranchNumber

DTYPE_TEXT

30

No

Account Holder

AccountHolder

DTYPE_TEXT

Not applicable

No

Account Name

AccountName

DTYPE_TEXT

100

No

Account Number

AccountNumber

DTYPE_TEXT

100

Yes

Account Row Id

AccountRowId

DTYPE_ID

Not applicable

No

Account Status

AccountStatus

DTYPE_TEXT

30

No

Account Type

AccountType

DTYPE_TEXT

30

No

Acct Gen - Account Id

AcctGen-AccountId

DTYPE_ID

Not applicable

No

Acct Gen - Average Balance

AcctGen-AverageBalance

DTYPE_CURRENCY

Not applicable

No

Acct Gen - Branch Id

AcctGen-BranchId

DTYPE_ID

Not applicable

No

Acct Gen - Organization Address Id

AcctGen-OrganizationAddressId

DTYPE_ID

Not applicable

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

Not applicable

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

Not applicable

No

Acct Gen - Product Line Id

AcctGen-ProductLineId

DTYPE_ID

Not applicable

No

Available Balance

AvailableBalance

DTYPE_CURRENCY

Not applicable

No

Balance

Balance

DTYPE_CURRENCY

Not applicable

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

Not applicable

No

Comments

Comments

DTYPE_TEXT

250

No

Commitment Amount

CommitmentAmount

DTYPE_CURRENCY

Not applicable

No

Conflict Id

ConflictId

DTYPE_ID

30

No

Contact Address Id

ContactAddressId

DTYPE_ID

Not applicable

No

Created

Created

DTYPE_DATETIME

30

No

Currency

Currency

DTYPE_TEXT

20

No

Current Balance

CurrentBalance

DTYPE_CURRENCY

Not applicable

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

Not applicable

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

Not applicable

No

Parent Account Id

ParentAccountId

DTYPE_ID

Not applicable

No

Parent Account Number

ParentAccountNumber

DTYPE_TEXT

100

No

Parent Asset ID

ParentAssetID

DTYPE_ID

Not applicable

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

Not applicable

No

Primary Account Id

PrimaryAccountId

DTYPE_ID

Not applicable

No

Primary Employee Id

PrimaryEmployeeId

DTYPE_ID

Not applicable

No

Primary Org Id

PrimaryOrgId

DTYPE_ID

Not applicable

No

Primary Organization Name

PrimaryOrganizationName

DTYPE_TEXT

100

No

Primary Position Id

PrimaryPositionId

DTYPE_ID

Not applicable

No

Product Id

ProductId

DTYPE_ID

Not applicable

Yes

Start Date

StartDate

DTYPE_DATE

Not applicable

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

Account Id

AccountId

DTYPE_ID

Not applicable

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

Not applicable

No

Cellular Phone #

CellularPhone

DTYPE_PHONE

Not applicable

No

Created

Created

DTYPE_DATETIME

30

No

Employee Number

EmployeeNumber

DTYPE_TEXT

30

No

Fax Phone #

FaxPhone

DTYPE_PHONE

Not applicable

No

First Name

FirstName

DTYPE_TEXT

50

Yes

Home Phone #

HomePhone

DTYPE_PHONE

Not applicable

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

Not applicable

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

Not applicable

No

operation

operation

DTYPE_TEXT

30

No

searchspec

searchspec

DTYPE_TEXT

250

No

FINCORPAccountContact

Account

Account

DTYPE_TEXT

100

No

Account Id

AccountId

DTYPE_ID

Not applicable

No

Asset Id

AssetId

DTYPE_ID

Not applicable

No

Cellular Phone Number

CellularPhoneNumber

DTYPE_PHONE

Not applicable

No

Conflict Id

ConflictId

DTYPE_ID

30

No

Contact Id

ContactId

DTYPE_ID

Not applicable

No

Created

Created

DTYPE_DATETIME

30

No

Currency

Currency2

DTYPE_TEXT

Not applicable

No

Email Address

EmailAddress3

DTYPE_TEXT

100

No

Fax Number

FaxNumber

DTYPE_PHONE

Not applicable

No

First Name

FirstName

DTYPE_TEXT

50

No

Home Phone Number

HomePhoneNumber

DTYPE_PHONE

Not applicable

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

Not applicable

No

Primary Personal Address Id

PrimaryPersonalAddressId

DTYPE_ID

Not applicable

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

Not applicable

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

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

Table Siebel Forecast Integration Components

Integration Component XML Tag User Keys

Forecast

Forecast

  1. Forecast Number

Forecast Item Detail Flat

ForecastItemDetailFlat

  1. Detail Date

  2. Forecast Item Id

  3. Owner Forecast Id

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

Table Siebel Forecast ASI Fields

Name XML Tag Data Type Length Req.

Forecast

Archive Timestamp

ArchiveTimestamp

DTYPE_TEXT

Not applicable

No

Created By Login

CreatedByLogin

DTYPE_TEXT

50

No

Forecast Base Period Type

ForecastBasePeriodType

DTYPE_TEXT

30

No

Forecast Date

ForecastDate

DTYPE_TEXT

Not applicable

No

Forecast End Date

ForecastEndDate

DTYPE_TEXT

Not applicable

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

Not applicable

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

Account Id

AccountId

DTYPE_ID

15

No

Amount Revenue

Revenue

DTYPE_TEXT

Not applicable

No

Best Case

BestCase

DTYPE_TEXT

Not applicable

No

Commit Flag

CommitFlag

DTYPE_TEXT

1

No

Cost

Cost

DTYPE_TEXT

Not applicable

No

Currency

CurrencyCode

DTYPE_TEXT

Not applicable

No

Detail Date

DetailDate

DTYPE_TEXT

Not applicable

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

Not applicable

No

Product Quantity

ProductQuantity

DTYPE_TEXT

Not applicable

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

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

The following table lists the integration components of this ASI.

Table Siebel Invoice Integration Components

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. The following table lists the fields and their attributes.

Table Siebel Invoice ASI Fields

Name XML Tag Data Type Length Req. Note

FS Invoice

Account Id

AccountId

DTYPE_ID

15

No

  • Used for picking from Picklist Account.

  • User key field.

Account Integration Id

AccountIntegrationId

DTYPE_TEXT

30

No

  • Used for picking from Picklist Account.

  • User key field.

Account Location

AccountLocation

DTYPE_TEXT

30

No

Used for picking from Picklist Account.

Account Name

AccountName

DTYPE_TEXT

50

No

Used for picking from Picklist Account.

Account Organization Name

AccountOrganizationName

DTYPE_TEXT

100

No

Used for picking from Picklist Account.

Activity Id

ActivityId

DTYPE_ID

15

No

Used for picking from FS Activity Pick List.

Activity User Defined Unique Id

ActivityUserDefinedUniqueId

DTYPE_TEXT

30

No

Used for picking 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 for picking from Service Agreement.

Contract Integration Id

ContractIntegrationId

DTYPE_TEXT

30

No

Used for picking from Service Agreement.

Contract Name

ContractName

DTYPE_TEXT

50

No

Used for picking from Service Agreement.

Contract Organization Name

ContractOrganizationName

DTYPE_TEXT

100

No

Used for picking from Service Agreement.

Contract Revision Number

ContractRevisionNumber

DTYPE_NUMBER

22

No

Used for picking from Service Agreement.

Currency Code

CurrencyCode

DTYPE_TEXT

20

Yes

Used for picking 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 for picking 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 for picking 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

  • Bound by FS_INVOICE_TYPE LOV.

  • User key field.

Id

Id

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

Order Id

OrderId

DTYPE_ID

15

No

Used for picking from Order Entry Picklist.

Order Integration Id

OrderIntegrationId

DTYPE_TEXT

30

No

Used for picking from Order Entry Picklist.

Order Number

OrderNumber

DTYPE_TEXT

30

No

Used for picking from Order Entry Picklist.

Order Organization Name

OrderOrganizationName

DTYPE_TEXT

100

No

Used for picking 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 for picking from Picklist Payment Term.

Payment Term Id

PaymentTermId

DTYPE_ID

15

No

Used for picking from Picklist Payment Term.

Project Id

ProjectId

DTYPE_ID

15

No

Used for picking 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 for picking from Picklist Project.

Project Organization Name

ProjectOrganizationName

DTYPE_TEXT

100

No

Used for picking 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 for picking 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 for picking from Service Request Picklist.

FS Invoice Line Items

Activity Id

ActivityId

DTYPE_ID

15

No

Used for picking from FS Activity Picklist.

Activity User Defined Unique Id

ActivityUserDefinedUniqueId

DTYPE_TEXT

30

No

Used for picking from FS Activity Picklist.

Contract Id

ContractId

DTYPE_ID

15

No

Used for picking from FS PickList Agreement Item - All.

Contract Integration Id

ContractIntegrationId

DTYPE_TEXT

30

No

Used for picking from FS PickList Agreement Item - All.

Contract Line Id

ContractLineId

DTYPE_ID

15

No

Used for picking from FS PickList Agreement Item - All.

Contract Name

ContractName

DTYPE_TEXT

50

No

Used for picking from FS PickList Agreement Item - All.

Contract Organization Name

ContractOrganizationName

DTYPE_TEXT

100

No

Used for picking from FS PickList Agreement Item - All.

Contract Revision Number

ContractRevisionNumber

DTYPE_NUMBER

22

No

Used for picking from FS PickList Agreement Item - All.

CurrencyCode

CurrencyCode

DTYPE_TEXT

20

Yes

Used for picking 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 for picking from FS Invoice Line Item Type Picklist.

Order Id

OrderId

DTYPE_ID

15

No

Used for picking from Order Entry Picklist.

Order Integration Id

OrderIntegrationId

DTYPE_TEXT

30

No

Used for picking from Order Entry Picklist.

Order Item Id

OrderItemId

DTYPE_ID

15

No

Used for picking from Order Entry - Line Item Picklist.

Order Item Integration Id

OrderItemIntegrationId

DTYPE_TEXT

30

No

Used for picking 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 for picking 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 for picking from Order Entry - Line Item Picklist.

Person Id

PersonId

DTYPE_ID

15

No

Used for picking from PS PickList Project Resource.

Product Id

ProductId

DTYPE_ID

15

No

Used for picking from Order Entry - Product PickList.

Product Integration Id

ProductIntegrationId

DTYPE_TEXT

30

No

Used for picking from Order Entry - Product PickList.

Product Name

ProductName

DTYPE_TEXT

100

No

Used for picking from Order Entry - Product PickList.

Product Organization Name

ProductOrganizationName

DTYPE_TEXT

100

No

Used for picking from Order Entry - Product PickList.

Product Vendor Organization Name

ProductVendorOrganizationName

DTYPE_TEXT

100

No

Used for picking from Order Entry - Product PickList.

Project Id

ProjectId

DTYPE_ID

15

No

Used for picking from Picklist Project.

Project Integration Id

ProjectIntegrationId

DTYPE_TEXT

30

No

Used for picking from Picklist Project.

Project Item Id

ProjectItemId

DTYPE_ID

15

No

Used for picking 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 for picking from Picklist Project.

Project Organization Name

ProjectOrganizationName

DTYPE_TEXT

100

No

Used for picking from Picklist Project.

Project Resource Id

ProjectResourceId

DTYPE_ID

15

No

Used for picking from PS PickList Project Resource.

Project Resource Number

ProjectResourceNumber

DTYPE_TEXT

30

No

Used for picking from PS PickList Project Resource.

Service Request Id

ServiceRequestId

DTYPE_ID

15

No

Used for picking 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 for picking 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/External Opportunity Query/External Opportunity Update

The External Opportunity Create/External Opportunity Query/External Opportunity 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/External Opportunity Query/External Opportunity Update ASI.

Opportunity Sharing ASI

    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).

    Table ANI Opportunity Message (PRM ANI) Integration Components

    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

    1. 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

    1. 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

    1. 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

    1. Revenue Item Number

    Transfer Details

    TransferDetails

    No user keys.

    The following table lists the fields and their attributes.

    Table ANI Opportunity Message (PRM ANI) ASI Fields

    Name XML Tag Data Type Length Req.

    Account

    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

    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

    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

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Location

    Location

    DTYPE_TEXT

    50

    No

    Name

    Name

    DTYPE_TEXT

    100

    No

    Channel Partner Business Address

    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

    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

    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

    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

    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

    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

    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

    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

    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

    DUNS Number

    DUNSNumber

    DTYPE_TEXT

    15

    No

    Id

    Id

    DTYPE_ID

    15

    No

    Name

    Name

    DTYPE_TEXT

    100

    No

    Organization Business Address

    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

    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

    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).

      Table ANI Message Header (PRM ANI) Integration Components

      Integration Component XML Tag User Keys

      Message Details

      MessageDetails

      No user keys.

      Transfer Details

      TransferDetails

      No user keys.

      The following table lists the fields and their attributes.

      Table ANI Message Header (PRM ANI) ASI Fields

      Name XML Tag Data Type Length Req.

      Message Details

      External Id

      ExternalId

      DTYPE_TEXT

      Not applicable

      No

      External Id Description

      ExternalIdDescription

      DTYPE_TEXT

      Not applicable

      No

      Internal Id

      InternalId

      DTYPE_TEXT

      Not applicable

      No

      Internal Id Description

      InternalIdDescription

      DTYPE_TEXT

      Not applicable

      No

      Message Generation Time Stamp

      MessageGenerationTimeStamp

      DTYPE_DATETIME

      Not applicable

      No

      Method

      Method

      DTYPE_TEXT

      Not applicable

      No

      Redirection URL

      RedirectionURL

      DTYPE_TEXT

      Not applicable

      No

      Transfer Details

      Transfer Date

      TransferDate

      DTYPE_DATETIME

      Not applicable

      No

      Transfer Recipient

      TransferRecipient

      DTYPE_TEXT

      Not applicable

      No

      Transfer Status

      TransferStatus

      DTYPE_TEXT

      Not applicable

      No

      Transfer Status Message

      TransferStatusMessage

      DTYPE_TEXT

      Not applicable

      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).

        Table Opportunity (PRM ANI) Integration Components

        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

        1. 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

        1. 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

        1. Revenue Item Number

        The following table lists the fields and their attributes.

        Table Opportunity (PRM ANI) ASI Fields

        Name XML Tag Data Type Length Req.

        Action

        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

        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

        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

        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

        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

        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

        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

        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

        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).

          Table Destination Channel Partner (PRM ANI) Integration Components

          Integration Component XML Tag User Keys

          Channel Partner

          ChannelPartner

          1. Location, Name

          Channel Partner Business Address

          ChannelPartnerAddress

          1. Account Id, Address Name

          The following table lists the fields and their attributes.

          Table Destination Channel Partner (PRM ANI) ASI Fields

          Name XML Tag Data Type Length Required

          Channel Partner

          DUNS Number

          DUNSNumber

          DTYPE_TEXT

          15

          No

          Location

          Location

          DTYPE_TEXT

          50

          No

          Name

          Name

          DTYPE_TEXT

          100

          No

          Channel Partner Business Address

          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

          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).

            Table Source Organization (PRM ANI) Integration Components

            Integration Component XML Tag User Keys

            Organization

            Organization

            1. DUNS Number

            Organization Business Address

            OrganizationAddress

            1. Account Id, Address Name

            The following table lists the fields and their attributes.

            Table Source Organization (PRM ANI) ASI Fields

            Name XML Tag Data Type Length Required

            Organization

            DUNS Number

            DUNSNumber

            DTYPE_TEXT

            15

            No

            Id

            Id

            DTYPE_ID

            15

            No

            Name

            Name

            DTYPE_TEXT

            100

            No

            Organization Business Address

            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

            Not applicable

            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).

              Table Opportunity Account (PRM ANI) Integration Components

              Integration Component XML Tag User Keys

              Account

              Account

              1. 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

              The following table lists the fields and their attributes.

              Table Opportunity Account (PRM ANI) ASI Fields

              Name XML Tag Data Type Length Required

              Account

              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

              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

                The following table lists the integration components of this ASI.

                Table Siebel Order Integration Components

                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. The following table lists the fields and their attributes.

                Table Siebel Order ASI Fields

                Name XML Tag Data Type Length Req.

                Attributes

                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

                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

                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

                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

                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

                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

                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

                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

                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

                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

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

                Table Siebel Position Integration Components

                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. The following table lists the fields and their attributes.

                Table Siebel Position ASI Fields

                Name XML Tag Data Type Length Req.

                Billing Product

                BillingProduct

                DTYPE_TEXT

                100

                No

                Billing Product Id

                BillingProductId

                DTYPE_ID

                Not applicable

                No

                Billing Product Integration Id

                BillingProductIntegrationId

                DTYPE_TEXT

                30

                No

                Compensatable

                Compensatable

                DTYPE_TEXT

                Not applicable

                No

                Description

                Description

                DTYPE_TEXT

                255

                No

                Division

                Division

                DTYPE_TEXT

                255

                Yes

                Division Id

                DivisionId

                DTYPE_ID

                Not applicable

                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

                Not applicable

                No

                Organization Integration Id

                OrganizationIntegrationId

                DTYPE_TEXT

                30

                No

                Parent Position Id

                ParentPositionId

                DTYPE_ID

                Not applicable

                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

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

                Table Siebel Price List Integration Components

                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

                The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length.

                Table Siebel Price List ASI Fields

                Name XML Tag Data Type Length Req. Note

                Price List

                Currency Code

                CurrencyCode

                DTYPE_TEXT

                15

                No

                None

                Description

                Description

                DTYPE_TEXT

                255

                No

                None

                End Date

                EndDate

                DTYPE_TEXT

                No

                None

                Freight Terms

                FreightTerms

                DTYPE_TEXT

                30

                No

                None

                Id

                Id

                DTYPE_ID

                30

                No

                Used for picking 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

                No

                Used for picking a related entity.

                Primary Organization

                PrimaryOrganization

                DTYPE_TEXT

                50

                No

                None

                Primary Organization Id

                PrimaryOrganizationId

                DTYPE_ID

                No

                Used for picking a related entity.

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                30

                No

                None

                Start Date

                StartDate

                DTYPE_TEXT

                No

                None

                Type

                Type

                DTYPE_TEXT

                30

                No

                None

                operation

                operation

                DTYPE_TEXT

                30

                No

                None

                Price List Item

                End Date

                EndDate

                DTYPE_TEXT

                No

                None

                Id

                Id

                DTYPE_ID

                30

                No

                Used for picking 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

                No

                None

                Price List Id

                PriceListId

                DTYPE_ID

                No

                Used for picking 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

                No

                Used for picking a related entity.

                Promotional Price

                PromotionalPrice

                DTYPE_TEXT

                No

                None

                Start Date

                StartDate

                DTYPE_TEXT

                No

                None

                operation

                operation

                DTYPE_TEXT

                30

                No

                None

                Price List_Organization

                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

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

                Table Siebel Quote/External Quote Integration Components

                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 fields and their attributes for this ASI.

                Table Siebel Quote/External Quote ASI Fields

                Name XML Tag Data Type Length Req. Note

                Quote

                Account

                Account

                DTYPE_TEXT

                100

                No

                Used for picking a related entity.

                Account Id

                AccountId

                DTYPE_ID

                15

                No

                None

                Account Integration Id

                AccountIntegrationId

                DTYPE_TEXT

                30

                No

                Used for picking a related entity.

                Account Site

                AccountSite

                DTYPE_TEXT

                50

                No

                Used for picking 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 for picking 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 for picking 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 for picking 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 for picking a 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 for picking a related entity.

                Contact Last Name

                ContactLastName

                DTYPE_TEXT

                50

                No

                Used for picking 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 for picking a related entity.

                Credit Card Number

                CreditCardNumber

                DTYPE_TEXT

                50

                No

                Used for picking 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 for picking 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

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

                User key field for Quote.

                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 for picking a related entity.

                Opportunity Name

                OpportunityName

                DTYPE_TEXT

                100

                No

                Used for picking a related entity.

                Payment Method

                PaymentMethod

                DTYPE_TEXT

                30

                No

                Used for picking a related entity.

                Payment Term

                PaymentTerm

                DTYPE_TEXT

                50

                No

                Used for picking a related entity.

                Payment Term Id

                PaymentTermId

                DTYPE_ID

                15

                No

                None

                Payment Term Integration Id

                PaymentTermIntegrationId

                DTYPE_TEXT

                30

                No

                Used for picking a related entity.

                Price List

                PriceList

                DTYPE_TEXT

                50

                No

                Used for picking a related entity.

                Price List Id

                PriceListId

                DTYPE_ID

                15

                No

                Used for picking 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 for picking 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 for picking 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 for picking 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 for picking 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 for picking a related entity.

                Ship To Contact First Name

                ShipToContactFirstName

                DTYPE_TEXT

                50

                No

                None

                Ship To Contact Id

                ShipToContactId

                DTYPE_ID

                15

                No

                Used for picking 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 for picking 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 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.

                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

                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

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

                User key field for Attributes.

                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

                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

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

                User key field for Line Items.

                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 for picking 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 for picking a related entity.

                Ship to Account Integration Id

                ShiptoAccountIntegrationId

                DTYPE_TEXT

                30

                No

                Used for picking 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 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.

                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

                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

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

                User key field for Promised Schedule Lines.

                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 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.

                Related Order

                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

                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

                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

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

                User key field for Related Service Agreement.

                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

                Id

                Id

                DTYPE_ID

                30

                No

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

                User key field for Requested Schedule Lines.

                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

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

                Table Siebel ATP Response/External ATP Check Integration Components

                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

                1. Id

                Payments

                Payments

                1. Id

                Promised Schedule Line

                PromisedScheduleLine

                1. Integration Id

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

                Table Siebel ATP Response/External ATP Check ASI Fields

                Name XML Tag Data Type Length Req.

                ATPHeader

                Account

                Account

                DTYPE_TEXT

                Not applicable

                No

                Account Id

                AccountId

                DTYPE_TEXT

                Not applicable

                No

                Account Integration Id

                AccountIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Available Date

                AvailableDate

                DTYPE_TEXT

                Not applicable

                No

                Available Message

                AvailableMessage

                DTYPE_TEXT

                Not applicable

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                Not applicable

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                Not applicable

                No

                Carrier

                Carrier

                DTYPE_TEXT

                Not applicable

                No

                Contact First Name

                ContactFirstName

                DTYPE_TEXT

                Not applicable

                No

                Contact Id

                ContactId

                DTYPE_TEXT

                Not applicable

                No

                Contact Last Name

                ContactLastName

                DTYPE_TEXT

                Not applicable

                No

                Currency Code

                CurrencyCode

                DTYPE_TEXT

                Not applicable

                No

                Document Type Id

                DocumentTypeId

                DTYPE_TEXT

                Not applicable

                No

                Header Number

                HeaderNumber

                DTYPE_TEXT

                Not applicable

                No

                Id

                HeaderRowId

                DTYPE_TEXT

                Not applicable

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Name

                Name

                DTYPE_TEXT

                Not applicable

                No

                Order Date

                OrderDate

                DTYPE_TEXT

                Not applicable

                No

                Order Priority

                OrderPriority

                DTYPE_TEXT

                Not applicable

                No

                Organization

                Organization

                DTYPE_TEXT

                Not applicable

                No

                Organization DUNS Number

                OrganizationDUNSNumber

                DTYPE_TEXT

                Not applicable

                No

                Organization Id

                OrganizationId

                DTYPE_TEXT

                Not applicable

                No

                Organization Integration Id

                OrganizationIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                Not applicable

                No

                Revision

                Revision

                DTYPE_NUMBER

                Not applicable

                No

                Ship Complete Flag

                ShipCompleteFlag

                DTYPE_TEXT

                Not applicable

                No

                Ship To Account

                ShipToAccount

                DTYPE_TEXT

                Not applicable

                No

                Ship To Account Id

                ShipToAccountId

                DTYPE_TEXT

                Not applicable

                No

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Ship To Address

                ShipToAddress

                DTYPE_TEXT

                Not applicable

                No

                Ship To Address Id

                ShipToAddressId

                DTYPE_TEXT

                Not applicable

                No

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Ship To City

                ShipToCity

                DTYPE_TEXT

                Not applicable

                No

                Ship To Country

                ShipToCountry

                DTYPE_TEXT

                Not applicable

                No

                Ship To First Name

                ShipToFirstName

                DTYPE_TEXT

                Not applicable

                No

                Ship To Last Name

                ShipToLastName

                DTYPE_TEXT

                Not applicable

                No

                Ship To Site

                ShipToSite

                DTYPE_TEXT

                Not applicable

                No

                Ship To State

                ShipToState

                DTYPE_TEXT

                Not applicable

                No

                Ship To Zip

                ShipToZip

                DTYPE_TEXT

                Not applicable

                No

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                Not applicable

                No

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                Not applicable

                No

                Shipping Terms Info

                ShippingTermsInfo

                DTYPE_TEXT

                Not applicable

                No

                Single Delivery

                SingleDelivery

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Loc Id

                SourceInventoryLocId

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Loc Integration Id

                SourceInventoryLocIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                Not applicable

                No

                Time To Reserve

                TimeToReserve

                DTYPE_TEXT

                Not applicable

                No

                Time To Reserve UOM

                TimeToReserveUOM

                DTYPE_TEXT

                Not applicable

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                ATPLineItems

                ATP Message Line

                ATPMessageLine

                DTYPE_TEXT

                Not applicable

                No

                Available Date

                AvailableDate

                DTYPE_TEXT

                Not applicable

                No

                Available Quantity

                AvailableQuantity

                DTYPE_TEXT

                Not applicable

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                Not applicable

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                Not applicable

                No

                Carrier

                Carrier

                DTYPE_TEXT

                Not applicable

                No

                Extended Quantity

                ExtendedQuantity

                DTYPE_TEXT

                Not applicable

                No

                Id

                RowId

                DTYPE_TEXT

                Not applicable

                No

                Integration Id

                IntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Item Price

                ItemPrice

                DTYPE_TEXT

                Not applicable

                No

                Line Number

                LineNumber

                DTYPE_TEXT

                Not applicable

                No

                Minimum Lot Size

                MinimumLotSize

                DTYPE_TEXT

                Not applicable

                No

                Net Price

                NetPrice

                DTYPE_TEXT

                Not applicable

                No

                Package

                Package

                DTYPE_TEXT

                Not applicable

                No

                Parent Row Id

                ParentRowId

                DTYPE_TEXT

                Not applicable

                No

                Parent Row Line Number

                ParentRowLineNumber

                DTYPE_TEXT

                Not applicable

                No

                Part Number

                PartNumber

                DTYPE_TEXT

                Not applicable

                No

                Product Global Identifier

                ProductGlobalIdentifier

                DTYPE_TEXT

                Not applicable

                No

                Product Id

                ProductId

                DTYPE_TEXT

                Not applicable

                No

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Product Status Code

                ProductStatusCode

                DTYPE_TEXT

                Not applicable

                No

                Product Unit Of Measure

                ProductUnitOfMeasure

                DTYPE_TEXT

                Not applicable

                No

                Requested Date

                RequestedDate

                DTYPE_TEXT

                Not applicable

                No

                Requested Quantity

                RequestedQuantity

                DTYPE_TEXT

                Not applicable

                No

                Rollup Item Price

                RollupItemPrice

                DTYPE_TEXT

                Not applicable

                No

                Sales Unit Of Measure

                SalesUnitOfMeasure

                DTYPE_TEXT

                Not applicable

                No

                Ship Complete Flag

                ShipCompleteFlag

                DTYPE_TEXT

                Not applicable

                No

                Ship To Account Id

                ShipToAccountId

                DTYPE_TEXT

                Not applicable

                No

                Ship To Account Integration Id

                ShipToAccountIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Ship To Address

                ShipToAddress

                DTYPE_TEXT

                Not applicable

                No

                Ship To Address Id

                ShipToAddressId

                DTYPE_TEXT

                Not applicable

                No

                Ship To Address Integration Id

                ShipToAddressIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Ship To City

                ShipToCity

                DTYPE_TEXT

                Not applicable

                No

                Ship To Contact First Name

                ShipToContactFirstName

                DTYPE_TEXT

                Not applicable

                No

                Ship To Contact Last Name

                ShipToContactLastName

                DTYPE_TEXT

                Not applicable

                No

                Ship To Country

                ShipToCountry

                DTYPE_TEXT

                Not applicable

                No

                Ship To State

                ShipToState

                DTYPE_TEXT

                Not applicable

                No

                Ship To Zip

                ShipToZip

                DTYPE_TEXT

                Not applicable

                No

                Shipping Method

                ShippingMethod

                DTYPE_TEXT

                Not applicable

                No

                Shipping Terms

                ShippingTerms

                DTYPE_TEXT

                Not applicable

                No

                Single Delivery

                SingleDelivery

                DTYPE_TEXT

                Not applicable

                No

                Smart Part Number

                SmartPartNumber

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Loc Id

                SourceInventoryLocId

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Location Integration Id

                SourceInventoryLocIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Start Price

                StartPrice

                DTYPE_TEXT

                Not applicable

                No

                Time To Reserve

                TimeToReserve

                DTYPE_TEXT

                Not applicable

                No

                Time To Reserve UOM

                TimeToReserveUOM

                DTYPE_TEXT

                Not applicable

                No

                Unit Of Measure

                UnitOfMeasure

                DTYPE_TEXT

                Not applicable

                No

                Unit Price

                UnitPrice

                DTYPE_TEXT

                Not applicable

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Attributes

                Description

                AttributeDescription

                DTYPE_TEXT

                Not applicable

                No

                Id

                AttributeId

                DTYPE_ID

                Not applicable

                No

                Name

                AttributeName

                DTYPE_TEXT

                Not applicable

                No

                Value

                AttributeValue

                DTYPE_TEXT

                Not applicable

                No

                operation

                operation

                DTYPE_TEXT

                30

                No

                Payments

                Credit Check Message

                CreditCheckMessage

                DTYPE_TEXT

                Not applicable

                No

                Credit Check Status

                CreditCheckStatus

                DTYPE_TEXT

                Not applicable

                No

                Credit Check Status As Of Date

                CreditCheckStatusAsOfDate

                DTYPE_TEXT

                Not applicable

                No

                Id

                Id

                DTYPE_TEXT

                Not applicable

                No

                Payment Method

                PaymentMethod

                DTYPE_TEXT

                Not applicable

                No

                Transaction Amount

                TransactionAmount

                DTYPE_TEXT

                Not applicable

                No

                operation

                operation

                DTYPE_TEXT

                Not applicable

                No

                PromisedScheduleLine

                Available Date

                AvailableDate

                DTYPE_TEXT

                Not applicable

                No

                Available Quantity

                AvailableQuantity

                DTYPE_TEXT

                Not applicable

                No

                Available Status

                AvailableStatus

                DTYPE_TEXT

                Not applicable

                No

                Available Status As Of Date

                AvailableStatusAsOfDate

                DTYPE_TEXT

                Not applicable

                No

                Id

                Id

                DTYPE_TEXT

                Not applicable

                No

                Line Number

                LineNumber

                DTYPE_TEXT

                Not applicable

                No

                Part Number

                PartNumber

                DTYPE_TEXT

                Not applicable

                No

                Product Id

                ProductId

                DTYPE_TEXT

                Not applicable

                No

                Product Integration Id

                ProductIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Loc Id

                SourceInventoryLocId

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Loc Integration Id

                SourceInventoryLocIntegrationId

                DTYPE_TEXT

                Not applicable

                No

                Source Inventory Location

                SourceInventoryLocation

                DTYPE_TEXT

                Not applicable

                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

                  The following table lists the integration component of this ASI.

                  Table Credit Check Request Integration Components

                  Integration Component XML Tag User Keys

                  Line Items

                  LineItems

                  No user keys

                  Request Credit Check

                  RequestCreditCheck

                  No user keys

                  The following table lists the fields and definitions. Fields without a length specified do not have a maximum length associated with them.

                  Table Credit Check Request ASI Fields

                  Name XML Tag Data Type Length Req. Note

                  Request Credit Check

                  Amount

                  Amount

                  DTYPE_NUMBER

                  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

                  Applicable only if Document Type is Order.

                  Line Items

                  Extended Quantity

                  ExtendedQuantity

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Id

                  Id

                  DTYPE_ID

                  15

                  No

                  None

                  Item Price

                  ItemPrice

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Line Number

                  LineNumber

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Net Price

                  NetPrice

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Parent Order Item Number

                  ParentOrderItemNumber

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Product Id

                  ProductId

                  DTYPE_ID

                  15

                  No

                  None

                  Quantity Requested

                  QuantityRequested

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Rollup Item Price

                  RollupItemPrice

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Start Price

                  StartPrice

                  DTYPE_NUMBER

                  22

                  No

                  None

                  Unit Price

                  UnitPrice

                  DTYPE_NUMBER

                  22

                  No

                  None

                    Credit Check Response

                    The following table lists the integration component of this ASI.

                    Table Credit Check Response Integration Components

                    Integration Component XML Tag User Keys

                    Request Credit Check Response

                    RequestCreditCheckResponse

                    No user keys

                    The following table lists the fields and attributes of this ASI.

                    Table Credit Check Response ASI Fields

                    Name XML Tag Data Type Length Req.

                    Request Credit Check Response

                    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

                    Not applicable

                    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 of this ASI.

                        Table Shipment Tracking Interface Request Integration Components

                        Integration Component XML Tag User Keys

                        Shipment Information

                        ShipmentInformation

                        No user keys

                        The following table lists the fields and their attributes.

                        Table Shipment Tracking Interface Request ASI Fields

                        Name XML Tag Data Type Length Req. Note

                        Carrier

                        Carrier

                        DTYPE_TEXT

                        30

                        No

                        Used for picking 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 (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 (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 (required if Package Tracking Number or Shipment Identification Number is not provided).

                        Shipper Number

                        ShipperNumber

                        DTYPE_TEXT

                        60

                        C

                        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

                          The following table lists all the integration components of this ASI.

                          Table Shipment Tracking Interface Response ASI Integration Components

                          Integration Component XML Tag User Keys

                          Shipment Information

                          ShipmentInformation

                          No user keys

                          Package Information

                          PackageInformation

                          No user keys

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

                          Table Shipment Tracking Interface Response ASI Fields

                          Name XML Tag Data Type Length Req. Notes

                          Shipment Information

                          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 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 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

                          Comments

                          Comments

                          DTYPE_TEXT

                          100

                          No

                          None

                          Package Activity Date

                          PackageActivityDate

                          DTYPE_DATE

                          20

                          No

                          None

                          Package Activity Location City

                          PackageActivityLocationCity

                          DTYPE_TEXT

                          20

                          No

                          None

                          Package Activity Location Country

                          PackageActivityLocationCountry

                          DTYPE_TEXT

                          20

                          No

                          None

                          Package Activity Location Description

                          PackageActivityLocationDescription

                          DTYPE_TEXT

                          20

                          No

                          None

                          Package Activity Location Signed For By Name

                          PackageActivityLocationSignedForByName

                          DTYPE_TEXT

                          20

                          No

                          None

                          Package Activity Status Description

                          PackageActivityStatusDescription

                          DTYPE_TEXT

                          20

                          No

                          None

                          Package Activity Time

                          PackageActivityTime

                          DTYPE_TIME

                          20

                          No

                          None

                          Package Tracking Number

                          PackageTrackingNumber

                          DTYPE_TEXT

                          20

                          Yes

                          None

                          Response Code

                          ResponseCode

                          DTYPE_TEXT

                          10

                          No

                          None

                          Response Message

                          ResponseMessage

                          DTYPE_TEXT

                          100

                          No

                          None

                            Siebel SIA Service Request

                            This 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

                            The following table lists the integration components of this ASI.

                            Table Siebel SIA Service Request Integration Components

                            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

                            1. Name, Version

                            Service Request

                            ServiceRequest

                            1. Id

                            2. Primary Organization Id, SR Number

                            The following table lists the integration components and field attributes.

                            Table Siebel SIA Service Request ASI Fields

                            Name XML Tag Data Type Length Required

                            Action

                            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

                            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

                            Name

                            Name

                            DTYPE_TEXT

                            100

                            No

                            Version

                            Version

                            DTYPE_TEXT

                            30

                            No

                            Service Request

                            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

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

                            Table Siebel Service Request Integration Components

                            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

                            1. Name, Version

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

                            Table Siebel Service Request ASI Fields

                            Name XML Tag Data Type Length Required

                            Account External Product

                            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

                            Action

                            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

                            Service Request

                            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

                            Name

                            Name

                            DTYPE_TEXT

                            100

                            No

                            Version

                            Version

                            DTYPE_TEXT

                            30

                            No

                            Siebel Simple Product

                            This 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

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

                            Table Siebel Simple Product ASI Integration Components

                            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

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

                            Table Siebel Simple Product ASI Fields

                            Name XML Tag Data Type Length Req.

                            Internal Product

                            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

                            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

                            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

                            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

                            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

                            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

                            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

                            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

                            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

                            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