Document Properties
KbidY24843
Last Modified04-Feb-2020
Added to KB03-Jul-2013
Public AccessEveryone
StatusOnline
Doc TypeReferences
Product
  • ICM 7.6
  • ICM 7.7
  • ICM 7.8
  • ICM 7.9
  • ICM 7.10

Reference - Type Codes

Table of Contents

Product Version

6.4

Product To Version

 

Status

final

1 Introduction

This reference for developers is an excerpt of all common type codes in Enfinity Suite 6 and Intershop 7.

To make the document as simple as possible following conventions are used:

  • captions in all UPPERCASE refer to table names in the Intershop database schema
  • The tables are listed in alphabetical order
  • If not mentioned otherwise the column name is the same as the attribute name
  • If not mentioned otherwise the referring persistent object name can be deduced from the table name + suffix PO - adjust the case as necessary of course.
  • The data type is listed as it is defined in the model (edl) for the persistent object. The interface type may differ. If there is no persistent object for the table, the data type is listed like in the Oracle database
  • Known differences between Enfinity Suite 6 and Intershop 7 are mentioned.
  • Sources that define type codes or describe them are listed, other documents are linked if they may be helpful.

Type codes are unique identifiers to denote different (sub) types of a business object.

2 Custom Attributes in separate *_AV tables

Data type for attribute type: int required  

2.1 Enfinity Suite 6 and Intershop 7

TypeMeaning
0still no type
1int
2double
3string
4multiple int
5multiple double
6multiple string
7object

2.2 Additional Types since Intershop 7

TypeMeaning
8long
9boolean
10date
11decimal
12money
13quantity
14text
15multiple long
16multiple boolean
17multiple date
18multiple decimal

Related Source:

  • core/javasource/com/intershop/beehive/core/capi/domain/AttributeDefinitionConstants.java
  • core/edl/com/intershop/beehive/core/capi/domain/AttributeValuePO.edl

3 ACCOUNT

Data type for attribute typeCode: int

Account / Owner TypeCodes are described as followed:

Numeric type codes can be used to distinguish different types of accounts for UI purposes

TypeCode / Owner
for Procurement:

Type CodeMeaning

1

User:Profile

2

Department

3

CostCenter

4

Contract

for Affiliate:

50

AffiliatePartner

50

AffiliateProgram

since 6.2 until 7.1:

60

Bonus Point account

since 6.5:

80

Promotion Account


4 ACCOUNTTRANSACTION

Data type for attribute typeCode: int readonly

Account Transaction TypeCodes (TransactionTypes) - Source: Pipeline comments:

Type Code

Meaning

0

(undefined, fallback for standard TypeCode in Pipelet CreateAccountTransaction)

1

Manually created account transaction

2

Product line item debit transaction

3

Requisition debit transaction

4

Product line item credit transaction (caused by cancel)

5

Requisition credit transaction (caused by cancel)

6

Requisition credit transaction (caused by reject)

7

Product line item credit transaction (caused by reject)

8

Service line item debit transaction

9

Service line item credit transaction

for Affiliate Accounts:

50

Affiliate Transaction

for Bonus Point Accounts:

60

Manual Change

61

Grant Pending Points

62

Make Pending Points Redeemable

63

Cancel Pending Points

64

Grant Redeemable Points

65

Redeem Points

66

Undo Redeeming Points


5 ALERT

Data type for attribute typeCode: int required

"type code handling is futile because of no typecode will be set"

There are no pre-defined typecodes for alerts

Currently it is not used in the standard product

The alert handler class is at the moment more important


6 ATTRIBUTEGROUP

Data type for attribute TypeCode: int required

Originally meant to have way to distinguish between attribute groups for different objects.

The type code can be used to distinguish between several types of attribute groups, i.e. product and category attribute groups.

There are no pre-defined values

not used

related sources IS 7:

  • bc_foundation/javasource/com/intershop/component/foundation/capi/attributegroup/AttributeGroup.java
  • bc_foundation/edl/com/intershop/component/foundation/capi/attributegroup/AttributeGroup.edl
  • pipeline code of ViewProductAttributeGroups_32

7 AUCTION

Data type for attribute typeCode: int

This attribute defines the type of the auction (i.e. one of english, dutch, forward or reverse). The TypeCode is just copied from the assigned auction definition to avoid performance critical joins when searching for auctions of a defined type.

Related Source IS 7.3.2:

  • bc_tendering/javasource/com/intershop/component/tendering/capi/auction/Auction.java
  • bc_tendering/edl/com/intershop/component/tendering/capi/auction/Auction.edl

8 AUCTIONDEFINITION

Data type for attribute typeCode: int

predefined values:

Type CodeMeaning
0reserved for operations with all types
1AUCTION_TYPE_FORWARD
2AUCTION_TYPE_REVERSE

Related Sources 7.3.2:

  • bc_tendering/javasource/com/intershop/component/tendering/capi/auction/AuctionDefinition.java
  • bc_tendering/edl/com/intershop/component/tendering/internal/auction/AuctionDefinitionPO.edl
  • bc_tendering/edl/com/intershop/component/tendering/internal/auction/AuctionPO.edl

9 BASICADDRESS 

9.1 Enfinity Suite 6

Data type for attribute typeCode: int = 0

The typecode of the addresses is coded bit-wise as follows:

isInvoiceToAddress
       return (getTypeCode() & 1) != 0;

isShipToAddress
       return (getTypeCode() & 2) != 0;

isShipFromAddress()
       return (getTypeCode() & 4) != 0;

Type Code - bit wise

Meaning

1 = 001

invoice-to address

2 = 010

ship-to address

3 = 011

invoice-to and ship-to-address

4 = 100

ship-from address

5 = 101

ship-from and invoice-to address

6 = 110

ship-from and ship-to address

7 = 111

invoice-to address, ship-from address and ship-to address

8 = 1000

service-to address (new in 6.2)

16 = 1 0000

install-to address (new in 6.2)

28 = 1 1100

ship-from, service-to and install-to address

31 = 1 1111

invoice-to address, ship-from address, ship-to address, service-to and install-to address

32 = 10 0000

store address (new in 6.2)

34 = 10 0010

store address and ship-to address

These typecodes are used for all basic addresses, thus for user address, department address, and organization address.

9.2 Intershop 7

Deprecated!

Although type codes still may be set and changed they are not really used anymore.

Information about the usage of addresses is now stored as custom attributes.

You see this information because remnants of legacy code still manipulate it. It is not used in the storefront though.

Ignore the typecode field unless you have a very compelling reason not to do so.

 


10 BASICPROFILE

Data type for attribute typeCode: int = 0

The typeCode of a profile is necessary to distinguish between a profile of a 'real' user, profile of a unit or a customer.

The profile typecodes are set as follows:

Type Code

Meaning

0

User Profile

1

Domain Profile (default typecode, here also all organizations have their profiles)

2

Department Profile

3Customer profile

Related sources:

  • core/javasource/com/intershop/beehive/core/internal/profile/BasicProfilePO.java
  •  core/javasource/com/intershop/beehive/core/capi/profile/ProfileConstants.java

11 BUDGET

Data type for attribute type: int

Although named type the attribute works like a type code.

The numeric budget type code is used to distinguish different types of budgets for UI purposes. Currently two different type codes are defined  for interval and schedule budgets.
In the promotion context, the type is set to 1 ( BUDGET_TYPE_SCHEDULE) by default.

TypeMeaning
0for all types
1scheduled type: The budget has a defined start and end date. The budget is only valid and redeemable during this time period.
In the promotion context, the start and end dates of the budget are identical to the start and end dates of the promotion.
2

interval type: The budget has a defined interval that repeats itself. These intervals can be, for instance: weekly, monthly, quarterly etc.
The budget renews itself at the beginning of each new interval.
This type of budget is currently not used in the system.

Related Source

    bc_organization/edl/com/intershop/component/organization/internal/budget/BudgetPO.edl



12 CATALOG

Data type for attribute typeCode: int

Type CodeMeaningRemark
0for operations that handle all types 
1Standard Catalog 
2Classification Catalog 
3External CatalogNot used in IS7.
4Shared Catalog 
5Private CatalogNot used in IS7.
6Auction CatalogNot used in IS7.
7General Pages CatalogNot used in IS7.
10Amazon Catalogonly enfinity suite 6
40Forum catalogonly enfinity suite 6

 

Related Source

  • bc_mvc/javasource/com/intershop/component/mvc/capi/catalog/MVCatalogConstants.java

13 CATALOGCATEGORYLINK

13.1 Enfinity Suite 6

Data type for attribute typeCode: int = 1 required

There is only one defined type code in Enfinity Suite 6:

TypeCode

Meaning

1

Plain

13.2 Intershop 7

Catalog Category link type codes are now realized using the type code definitions.

See also TYPECODEDEFINITION.

Each CatalogCategoryLink has a typeCode. All the typeCodes used by CatalogCategoryLink need to be defined by TypeCodeDefinitions.

The TypeCodeDefinitions must have a TypeCodeDefinition:Group equal to constant CatalogCategoryLink:TypeCodeDefinitionGroup.

To ensure uniqueness of the TypeCodeDefinition:Name the following naming convention should be used: Use the project name as a prefix for the type code name, followed by an underscore. Standard Enfinity will have to use "ES_" as prefix for its type code names.

Data type for attribute typeCode: String  (in the java interface only this type code attribute is available)

Data type for attribute typeCodeInteger int required - this attribute refers to the database table column TYPECODE

constant TypeCodeDefinitionGroup : string = "CatalogCategoryLink";

Related Sources

  • xcs/edl/com/intershop/beehive/xcs/internal/catalog/CatalogCategoryLinkPO.edl
  • xcs/edl/com/intershop/beehive/xcs/capi/catalog/CatalogCategoryLink.edl

 


14 CHANNELTYPE

Data type for attribute channelTypeCode: int searchable

The typecode used to mark a channel repository as of this type

Channel Type CodeMeaning
32Partner Channel
42Business Channel  (until 6.4)
52Consumer Channel + SMB channel (IS7)
62Content Channel (old CMS until 6.4)

14.1 Relations Between Organization, Repository and Channel Type Codes 

Channel & Repositories TypeCodes are coded based on the Organizations:

Type Code

Organization

Type Code

Channel/Repository

Meaning

10

 

Operations Organization

20

 

Enterprise/Root Selling Organization

 

21

Enterprise Master Repository

 

22

Recycle Bin Repository

 27Content Sharing Relation Proxy Repository
30 Partner Organization
 32

Partner Channel

40 Buying Organization

 

42

Business Channel (until 6.4)

50 Anonymous Consumer Organization
 52

Consumer Channel

 53Application Specific Objects Repository (cms, ...)
 62

Content Channel (old CMS until 6.4)

Database Tables:

  • ORGANIZATION:TYPECODE
  • CHANNELTYPE.CHANNELTYPECODE
  • REPOSITORY.TYPECODE

15 COMMODITYGROUP

Data type for attribute typeCode: int

Only type code 0 is used at the moment.

no pre defined values

Type CodeMeaning
0Untyped ?

16 CONTRACT

Data type for attribute typeCode: int

Type CodeMeaning
20CONTRACT_TYPE
21SHAREDCONTRACT_TYPE

Related source: 

  • bc_mvc/javasource/com/intershop/component/mvc/capi/catalog/MVCatalogConstants.java

17 DERIVEDPRODUCT

Data type for attribute typeCode: int

The usage is the same as in PRODUCT.

Please note: the possibly changed type code compared to the base code is displayed as if it was the same offer type (offered or not offered) as in the source product.

However - all shared products are always handled as offered products using ProductViewImpl.


18 DOMAIN

Data type for attribute typeCode:  int required

The type code of this domain. Depending on its value, this domain represents the system domain, a site or a mere unit.  It is composed by the composition of three bits that can be found in DomainConstants.

Domain TypeCodes are coded bit wise, too.

Type Code - bit wise

Meaning

4 = 100

System Domain Bit

2 = 010

Site Bit

1 = 001

Unit Bit

Database Tables:

  • DOMAIN.TYPECODE

Related source:

  • core/javasource/com/intershop/beehive/core/capi/domain/DomainConstants.java


19 FILTEROBJECTASSIGNMENT

Data type for attribute typeCode:  int

describes the handled object type

Type CodeMeaning
0for operations with all types
1CatalogCategoryPO

Related source:

  • bc_mvc/javasource/com/intershop/component/mvc/capi/filter/CatalogFilterConstants.java


20 IMPORTUPDATEDTYPECODE

Data type of column NUMBER(*,0) NOT NULL

no referring PO

Part of import tracking tables for SQL loader import of products - so it is not used in IS 7 anymore

Type code values here are the same as defined for the product (see PRODUCT)

Please note: since the introduction of XML attributes for the PRODUCT table, products are not imported anymore via SQL loader. So this table is not in use anymore since version 6.3.

Related sources:

  • xcs/javasource/com/intershop/beehive/xcs/internal/impex/product/BulkerProductTypeCodeMgr.java
  • xcs/javasource/resources/xcs/dbinit/scripts/createProductImportTables.sql

21 ISCOMMENT

Data type for attribute typeCode: int required

Persistent object: CommentPO

By the use of the attribute TypeCode the scope of the comment can be defined.

The scope is defined as a bit mask

This table lists the pre defined values:

Related source

  • bc_foundation/javasource/com/intershop/component/foundation/capi/comment/CommentsConstants.java
Type Code - bit wiseMeaning
1= 0000 0001PRC_SCOPE_BUYER
2= 0000 0010PRC_SCOPE_APPROVER
4= 0000 0100PRC_SCOPE_ORDERMGR
8= 0000 1000PRC_SCOPE_SUPPLIER
16 = 0001 0000UCM_BUSINESSUNIT_DATAREPLICATIONMGR
32= 0010 0000UCM_SYSTEM_DATAREPLICATIONMGR
64= 0100 0000PRC_SCOPE_SELLER
128 = 1000 0000PRC_SCOPE_SOURCINGMGR

Actually used are at least in parts of enfinity suite 6 and Intershop 7 different values

Replication comments:

Type CodeMeaning
8comment on replication task on enterprise or channel level
16comment on replication task on Operations (system) level

Other types are still available in the pipeline OrderStatusTracking and also do not confirm with the values in the CommentsConstants class.

It looks like this feature is nowhere used anymore.

Hard coded typecodes there are: 20, 21, 22, 23, 24, 30, 31 and there is a possibility to provide a custom type code as well.

Please note: The pipeline OrderStatusTracking  is still part of the code basis of Intershop 7 but may be not in use anymore.

More related sources:

  • bc_foundation/javasource/com/intershop/component/foundation/internal/comment/CommentPO.java
  • bc_foundation/edl/com/intershop/component/foundation/internal/comment/CommentPO.edl
  • sld_ch_partner_plugin/staticfiles/cartridge/pipelines/ViewReplicationTask_32.xml
  • sld_ch_consumer_plugin/staticfiles/cartridge/pipelines/ViewReplicationTask_52.xml
  • sld_enterprise_app/staticfiles/cartridge/pipelines/ViewReplicationTask.xml
  • bc_requisition/staticfiles/cartridge/pipelines/OrderStatusTracking.xml

22 JOURNALENTRY

Data type for attribute typeCode: int

Description: By the use of the attribute typeCode the scope of the journal entry can be defined.

type code not used 

no pre defined values


23 MESSAGEBODY

23.1 Enfinity Suite 6

Table is used for the message body of messages in the es6 procurement part.

Type CodeMeaning

1

message sent via message center
2user registration event

23.2 Intershop 7

not used anymore


24 METHODCALCMODEL

24.1 Enfinity Suite 6:

Data type for attribute typeCode: int required;

Part of the shipping fame work implementation in Enfinity Suite 6.

Referring PO:   MethodCalculationModelPO

The type codes are set as follows:

Type Code

Meaning

0

Unknown

1

Amount Model

2

Fixed Model

3

Unit Model

4

Weight Model

24.2 Intershop 7

Still referenced in the code until version 7.2, but not used anymore.


25 ORGANIZATION

Data type for attribute typeCode: int searchable

TypeCodes of Organizations, see also Concept - Organization:

Type Code

Meaning

10

"Operations" organization

20

Root organization (enterprise or sales organization)

30

Partner organization

40

Buying organization

50

Anonymous organization of a consumer channel

Database Tables:

  • ORGANIZATION.TYPECODE

For the relation to channel type and repository type codes see here Relations between Organization Repository and Channel type codes


26 ORGANIZATIONGROUPASSIGNMENT

Data type for attribute typeCode: int searchable

Persistent Object: OrganizationUserGroupAssignmentPO

type code is not used

no pre defined values


27 PRICEDEFINITIONPRODUCTBINDING

Data type for attribute typeCode: int

Persistent object: PriceDefinitionProductAssignmentPO

27.1 Enfinity Suite 6

In this table the product assignment for scaled prices outside of price lists is stored.

This is used in the procurement scenario.

typecode is the same as in PRICESCALETABLE

27.2 Intershop 7

Objects and tables are still there but it is not used .


28 PRICELIST

28.1 Since Intershop 7

Data type for attribute priceType: string<256> required

Uses the name of a TypeCodeDefinition to define the type of the price list type

Type defnition group:  PriceList

In the standard system are supported the following price types:

  • Sale price (ES_SalePrice) - a normal price list price;
  • Warranty price (ES_WarrantyPrice) - exploited by the warranties which implement their own pricing models atop of price lists;

To avoid disambiguation please note that the API-s also expose price types which are something  different than the values defined in the PriceList group. These types are used to bound a specific name to a price list provider which resolves the actual price. Supported are:

  • List price
  • Cost price
  • Sale price - a price that may come from a price list

These types are defined in com.intershop.component.product.pricing.capi.CommonPriceTypes. Custom projects may define their own price types which are bound to specific price list providers and use them when customizing the backoffice and the storefront applications.

Related source:

  • bc_pricing/edl/com/intershop/component/pricing/internal/pricelist/PriceListPO.edl
  • bc_pricing/javasource/com/intershop/component/pricing/dbinit/data/pricing/TypeCodeDefinitionsPriceList.properties
  • bc_warranty/javasource/com/intershop/component/warranty/internal/price/ES_WarrantyPrice.java

  • - xcs/javasource/com/intershop/beehive/xcs/internal/price/ES_SalePrice.java

  • xcs/javasource/com/intershop/beehive/xcs/internal/price/ES_CostPrice.java

  • xcs/javasource/com/intershop/beehive/xcs/internal/price/ES_ListPrice.java

  • com.intershop.component.product.pricing.capi.CommonPriceTypes .java

29 PRICESCALEENTRY

Data type for attribute typeCode: int

Type CodeMeaning
0reserved for operations that affect all type codes
1amount
2percentage
3quantity triggered surcharge
4value triggered surcharge

Related source: bc_pricing/javasource/com/intershop/component/pricing/capi/scale/PriceScaleEntryConstants.java

These typecodes are used and supported by IS7.


30 PRICESCALETABLE

Data type for attribute typeCode: int

Price Scale Table typecodes are defined as follows:

Type Code

Meaning

1

Scaled Product List Price

2

Scaled Product Group Price

3

Contract List Price

4

Contract Scaled List Price

5

Small Scale Surcharge

100

Custom Price Definition

Any other number, for example 10 or 34, are combinations of the listed codes. 10 means a combination of 2 and 8; 34 means a combination of 32 and 2. 

Related source:

  • com.intershop.beehive.xcs.capi.product.ProductConstants

See also https://intranet.intershop.com/kb/index.php/Display/1C0402

IS7 Note: Currently Contract List Price and Contract Scaled List Price are not supported by the standard product.


31 PRICESCALETABLEASSIGNMENT

Data type for attribute typeCode: int

In this table the product assignment for scaled prices for price lists is stored´
The type codes are the same as in PRICESCALETABLE

Note on IS7: Currently not used in the standard product but nevertheless maintained.

This attribute however is stored by auditing the object
Source 7.3.2: Reference - Auditing (7.3) https://intranet.intershop.com/kb/index.php/Display/T24086


32 PRODUCT 

Data type for attribute typeCode: int = 0 observable

ProductItems, ProductBundles, ProductMasters and Offers are distinguished using a typeCode.

Product type codes are defined as bit mask:

Type Code - bit wise

Meaning

1 = 0 0000 0001

Offer

2 = 0 0000 0010

Item

4 = 0 0000 0100

Bundle

8 = 0 0000 1000

Bundled

16 = 0 0001 0000

Master

32 = 0 0010 0000

Mastered

64 = 0 0100 0000

Offered

128 = 0 1000 0000

Retail Set

256 = 1 0000 0000

Part of Retail Set

They can be combined as needed, for example

  • 3 = offer item
  • 35 = item that is part of a variation product

Related source:

  • xcs/javasource/com/intershop/beehive/xcs/capi/product/ProductConstants.java

Note on IS7: The offer flag is obsolete and has no special semantics in IS7. Nevertheless it is still used by order processing code which supports order routing. This is a feature that is not relevant in IS7. If the offer flag is not maintained the code will break and unexpected results may occur.


33 PRODUCTCONFVALD

Note:

The product configuration feature is not available in the standard product. Nevertheless the code that implements the feature is shipped with IS7 so that partners are supported. Apart from that the standard IS7 maintains no rows in the product configuration tables.

33.1 Since Intershop 7

Data type of attribute validatorType:   string<256> required;

Persistent object:    ProductConfigurationValidator

Uses the name of a TypeCodeDefinition to define the type of the product configuration validator.

Type defnition group:    ProductConfigurationValidator

See: TYPECODEDEFINITION

Related source:

  • bc_product_configuration/edl/com/intershop/component/productconfiguration/internal/orm/validator/ProductConfigurationValidatorPO.edl
  • bc_product_configuration/javasource/com/intershop/component/productconfiguration/dbinit/data/TypeCodeDefinitionsProductConfigurationValidatorType.properties

34 PRODUCTCONFOPT

Note:

The product configuration feature is not available in the standard product. Nevertheless the code that implements the feature is shipped with IS7 so that partners are supported. Apart from that the standard IS7 maintains no rows in the product configuration tables

34.1 Since Intershop 7

Data type of attribute type: string < 256 >  

Persistent object:   ProductConfigurationOptionPO  

Uses the name of a TypeCodeDefinition to define the type of the product configuration option.

Type defnition group:  ProductConfigurationValueType

See: TYPECODEDEFINITION

Related source:

  • bc_product_configuration/edl/com/intershop/component/productconfiguration/internal/orm/set/ProductConfigurationOptionPO.edl

35 PRODUCTDATADECLARATION

Data type of attribute typeCode: int required

This table contains data of syndication product mapping rules; the same type codes as PRODUCTDATAMAPPINGRULE

Related source:

  • bc_mvc/edl/com/intershop/component/mvc/capi/mapping/ProductDataDeclaration.edl (type codes 1 - 6)

36 PRODUCTDATADECLARATIONLIST

Data type of attribute typeCode: int required

This table contains data of syndication product mapping rules

Type CodeMeaning
1Source list
2Target list

Related source:

  • bc_mvc/javasource/com/intershop/component/mvc/capi/mapping/ProductDataMappingConstants.java

37 PRODUCTDATAMAPPINGRULE

Data type of attribute typeCode: int required

This table contains data of syndication product mapping rules. The type codes are hard coded in templates and pipelines

Type CodeMeaning
1product id mapping
2product attribute mapping
3product category mapping
4product price mapping
5product attachment mapping
6product replacement mapping
7attribute group mapping
8product classification mapping
9product link mapping
10product variation mapping
11product bundle assignment mapping
12product retail set assignment mapping

 

Related source:

  • bc_mvc/edl/com/intershop/component/mvc/internal/mapping/ProductDataMappingRulePO.edl

38 PRODUCTLINK

38.1 Enfinity Suite 6

Data type for attribute typeCode: int = 1 required

Product typecodes are defined as follows:

Type Code

Meaning

1

Default

1

Cross-selling

2

Replacement Product

3

Up-Selling

4

Accessory

5

Follow-Up

6

Different Order Unit

7

Spare Parts

8

Other

38.2 Intershop 7

Data type for attribute typeCode: String  (in the java interface only this type code attribute is available)

Data type for attribute typeCodeInteger int required - this attribute refers to the database table column TYPECODE

 

Product link type codes are now realized using the type code definitions.

See also TYPECODEDEFINITION

Each ProductLink has a typeCode. All the typeCodes used by ProductLink need to be defined by TypeCodeDefinitions.

The TypeCodeDefinitions must have a TypeCodeDefinition:Group equal to constant ProductLink:TypeCodeDefinitionGroup.

To ensure uniqueness of the TypeCodeDefinition:Name the following naming convention should be used: Use the project name as a prefix for the type code name, followed by an underscore. Standard Enfinity will have to use "ES_" as prefix for its type code names.

Attention: The CAPI interface ProductLink deals only with the string representations of typeCodes (TypeCodeDefinition:Name).

constant TypeCodeDefinitionGroup : string = "ProductLink";


Related Sources

  • xcs/edl/com/intershop/beehive/xcs/internal/product/ProductLinkPO.edl
  • xcs/edl/com/intershop/beehive/xcs/capi/product/ProductLink.edl

39 PRODUCTLIST

Data type for attribute typeCode: int required

39.1 Enfinity Suite 6

Used for lists of products like wish lists, shopping lists and so on

Attribute typecode is the Type coder of product list. Can be used to distinguish different kinds of lists.

Product list typecodes are defined as follows:

Type Code

Meaning

0

Untyped

1

Bookmarks

2

Wishlist

3

Shoppinglist

4

Quote

Related source:

  • bc_mvc/javasource/com/intershop/component/mvc/capi/product/ProductListingConstants.java

39.2 Intershop 7

Product lists are currently used only for wishlists. The ORMWishlistBORepositoryImpl in IS 7 creates all wish lists as untyped lists (type code 0). The type code is not relevant anymore although there are still pipelines that refer to it.

These pipelines are still there and able to create shopping lists (requisition templates) and quotes, but they are not used anyhow in the standard product

  • ProcessRequisitionTemplate.xml
  • ProcessGlobalRequisitionTemplate.xml
  • ProcessQuote.xml

This pipeline creates a quote with code 4 (business extension)

  • bc_b2b_ext/staticfiles/cartridge/pipelines/ProcessQuote.xml

Related other sources:

  • bc_mvc/javasource/com/intershop/component/mvc/capi/product/ProductListingConstants.java
  • (IS7 only) bc_wishlist_orm/javasource/com/intershop/component/wishlist/orm/internal/ORMWishlistBORepositoryImpl.java

40 PRODUCTLISTEVENT

Data type for attribute typeCode: string <256> required

The type code of the product list event is a string like 'Approved', 'Accepted', 'Cancelled'.

implemented into quotes (type codes are equal to the event names defined in QuoteConstants, meaning can be deducted from the type code value)

Type Code
AcceptedByApprover
AcceptedBySeller
ApprovedByApprover
AutoAccepted
CancelledByApprover
CancelledBySeller
ClosedByBuyer
CreatedByBuyer
RefusedByApprover
RespondedByApprover
RespondedBySeller
SubmittedToApprover
SubmittedToSeller

Related Sources:

  • bc_mvc/javasource/com/intershop/component/mvc/capi/quote/QuoteConstants.java
  • bc_mvc/edl/com/intershop/component/mvc/capi/product/ProductListEvent.edl
  • bc_mvc/staticfiles/cartridge/queries/quote/SearchQuotesByDomain.query

  • bc_mvc/staticfiles/cartridge/queries/quote/SearchQuotesByOwner.query

  • bc_mvc/staticfiles/cartridge/queries/quote/SearchQuotesByOwningDomain.query

40.1 Intershop 7

Currently not used.


41 PRODUCTMAPPINGRULE

Data type for attribute typeCode: int

41.1 Enfinity Suite 6

For product mapping rules in the procurement part

This class represents a single product mapping rule instance that can be applied to catalogs and offer repositories.

A product mapping rule is used to map offered products that suffice specified rule conditions to a target catalog category.

The search machanism based on the MultiSite Platform SearchQueryFramework with WebForms.

So all search conditions are held as webform paramters.

type code not used

41.2 Intershop 7

Currently has no meaning in the standard product.

For product mapping rules in the old procurement, based on stored web forms and the old query framework

Related source:

  • bc_mvc/edl/com/intershop/component/mvc/capi/mapping/ProductMappingRule.edl

42 PROFANITYCHECKENTRY

42.1 Since Intershop 7

Data type for atribute typeCode: int required

Type CodeMeaning
1word
2(Probably later) regex

 


43 PROMOTION

Data type for atribute typeCode: int

Enfinity Suite 6

Type CodeMeaning
1

discount

2reusable coupon
3unique coupon

Related sources:

  • bc_marketing/edl/com/intershop/component/marketing/internal/rebate/PromotionPO.edl
  • bc_marketing/javasource/com/intershop/component/marketing/capi/rebate/PromotionTypes.java

43.1 Intershop 7

typeCode is now marked as deprecated


44 RATINGCOMMENT

Data type for atribute typeCode: int

44.1 Enfinity Suite 6

The type code indicating the sort of object to be rated

Type CodeMeaning
1Product

Related sources

  • bc_rating_orm/edl/com/intershop/component/ratingorm/internal/orm/RatingCommentPO.edl
  • bc_mvc/staticfiles/cartridge/pipelines/ProcessProductRating.xml
  • bc_foundation/javasource/com/intershop/component/foundation/internal/rating/RatingMgrImpl.java

44.2 Intershop 7

typeCode attribute is now deprecated - dedicated assignment tables are used instead


45 REBATE

Data type of attribute typeCode: int

45.1 Enfinity Suite 6

Rebate type codes are defined as follows:

Type Code

Meaning

0

no rule assigned

1

no condition

2

order value condition

4

product number condition

8

small surcharge

16

abandoned basket condition

Related sources:

  • bc_marketing/javasource/com/intershop/component/marketing/capi/rebate/DiscountConditionToDiscountActionMappingHelper.java

  • prc_buyer_site/staticfiles/cartridge/pipelines/ProcessSmallScaleSurchargeRebate.xml

  • sld_ch_base/staticfiles/cartridge/pipelines/ProcessRebateRule.xml

  • sld_ch_base/staticfiles/cartridge/pipelines/ViewPromotion.xml

45.2 Intershop 7

deprecated?


46 REBATECONDITION

46.1 Since Intershop7

Data type of argument typeCode: int

Description of the field says: Condition is an operator condition

 bit mask for operator types

Type CodeMeaning
0Defines a condition as 'normal' condition
1Defines a condition as operator
2Defines a condition as grouping operator
4Defines a condition as type group operator

Related source:

  • bc_marketing/edl/com/intershop/component/marketing/internal/promotion/condition/RebateConditionPO.edl
  • bc_marketing/javasource/com/intershop/component/marketing/internal/promotion/condition/RebateConditionPO.java

47 REPOSITORY

Data type of argument typeCode: int

Type CodeMeaning
0For operations affecting all types
1Offer repository
2Product repository
3Contract repository
21Enterprise master repository
22Recycle bin repository - in MVCatalogConstants: REPOSITORY_TYPE_CHANNEL
32Partner channel repository
42Business channel repository (es6)
52Consumer channel repository+ SMB channel repository (IS7)
62Content Channel repository

Related sources:

  • bc_mvc/edl/com/intershop/component/mvc/internal/catalog/RepositoryPO.edl
  • bc_mvc/javasource/com/intershop/component/mvc/capi/catalog/MVCatalogConstants.java

For the relation to channel type and repository type codes see here Relations Between Organization Repository and Channel Type Codes.


48 REQUISITIONAWFSTEP

Data type for attribute typeCode: int = 0 required

Type CodeMeaning
0Initial type code for a RequisitionAWFStep after creation
1step by user
2

Step by role

    Type code for a RequisitionAWFStep after setRole(). This indicates that getRole() returns a valid value

3Step by relative role

  Type code for a RequisitionAWFStep after setRelative(). This indicates that getRelativeRole() and getRelativePath() return valid values.

Related sources

  • bc_requisition/javasource/com/intershop/component/requisition/capi/approval/RequisitionAWFConstants.java
  • bc_requisition/edl/com/intershop/component/requisition/internal/approval/RequisitionAWFStepPO.ed

49 RFQPARAMETERVALUE

Data type for attribute typeCode: int

no predefined values

not used


50 STATICADDRESS

Data type for attribute typeCode: int

See at BASICADDRESS.


51 TYPECODEDEFINITION 

51.1 Since Intershop 7

Data type for attribute typeCode:   int required

Contains type code definitions that can be used with the type codes framework.

There are type code groups that can have defined several type code names

Every type code name gets assigned an integer type code value that is stored in its typeCode attribute.

The integer value itself is not guaranteed to be constant for a certain name and group over versions or different installations.

So the lookup for the type code definition of a typed object should always be done by group and name via the TypeCodeDefinition

The assigned type code definition will be stored in the typed object as the integer value in the typeCode attribute of the object or as the type definition name in an attribute of type String.



52 TYPEDPRODUCTCATEGORYASSM

Data Type for attribute typeCodeInteger : int required column "TYPECODE"

Persistent Object: TypedProductCategoryAssignment

The integer typeCode of the TypedProductCategoryAssignment.

This is a TypeCodeDefinition:TypeCode out of the TypeCodeDefinitions with TypeCodeDefinition:Group equal to constant TypedProductCategoryAssignment:TypeCodeDefinitionGroup. Attention: The CAPI interface TypedProductCategoryAssignment deals only with the string representations of typeCodes (TypeCodeDefinition:Name).

 Type code group: TypedProductCategoryAssignment

 See at TYPECODEDEFINITION.

Related Source:

  • xcs/edl/com/intershop/beehive/xcs/capi/catalog/AbstractTypedProductCategoryAssignmentPO.edl

53 USERDELEGATION

Data type of attribute typeCode: int searchable

The typecode for custom delegations.

Custom delegations have to handle different types by their own.

Type CodeMeaning
1Buying delegation
2Approval delegation
10Custom Delegation

Related sources:

  • bc_organization/javasource/com/intershop/component/organization/capi/OrganizationConstants.java
  • bc_organization/edl/com/intershop/component/organization/internal/delegation/UserDelegationPO.edl

54 USERGROUP

Data type for attribute typeCode: int

Not used.


Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

Customer Support
Knowledge Base
Product Resources
Support Tickets