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 shows the Siebel Price List ASI structure, which contains the following components: Price List Item and Price List Organization.

Siebel Price List ASI. This image is described in the surrounding text.

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

Integration Component XML Tag User Keys

Price List

PriceList

  1. Integration Id

  2. Id

  3. Name, Type

Price List Item

PriceListItem

  1. Integration Id

  2. Id

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

Price List_Organization

PriceList_Organization

  1. Integration Id

  2. Division Id

Price List Fields in Siebel Price List ASI

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

Name XML Tag Data Type Length Req. Note

Currency Code

CurrencyCode

DTYPE_TEXT

15

No

None

Description

Description

DTYPE_TEXT

255

No

None

End Date

EndDate

DTYPE_TEXT

NA

No

None

Freight Terms

FreightTerms

DTYPE_TEXT

30

No

None

Id

Id

DTYPE_ID

30

No

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

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

Name

Name

DTYPE_TEXT

50

No

None

Payment Term

PaymentTerm

DTYPE_TEXT

50

No

None

Payment Term Id

PaymentTermId

DTYPE_ID

NA

No

Used to pick a related entity.

Primary Organization

PrimaryOrganization

DTYPE_TEXT

50

No

None

Primary Organization Id

PrimaryOrganizationId

DTYPE_ID

NA

No

Used to pick a related entity.

Shipping Method

ShippingMethod

DTYPE_TEXT

30

No

None

Start Date

StartDate

DTYPE_TEXT

NA

No

None

Type

Type

DTYPE_TEXT

30

No

None

operation

operation

DTYPE_TEXT

30

No

None

Price List ItemFields in Siebel Price List ASI

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

Name XML Tag Data Type Length Req. Note

End Date

EndDate

DTYPE_TEXT

NA

No

None

Id

Id

DTYPE_ID

30

No

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

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

List Price Type Code

ListPriceTypeCode

DTYPE_TEXT

30

No

None

Original List Price

OriginalListPrice

DTYPE_TEXT

NA

No

None

Price List Id

PriceListId

DTYPE_ID

NA

No

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

Product Id

ProductId

DTYPE_ID

NA

No

Used for picking a related entity.

Promotional Price

PromotionalPrice

DTYPE_TEXT

NA

No

None

Start Date

StartDate

DTYPE_TEXT

NA

No

None

operation

operation

DTYPE_TEXT

30

No

None

Price List_Organization Fields in Siebel Price List ASI

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

Name XML Tag Data Type Length Req. Note

Division Id

DivisionId

DTYPE_ID

30

No

None

Integration Id

IntegrationId

DTYPE_TEXT

30

No

None

operation

operation

DTYPE_TEXT

30

No

None