Mareting Data tables

-
Web ActivityConfiguration
Query: Select DMACTIVITY_ID,NAME from DMACTIVITY where name='Shoeb'

Query: Select DMELEMENT_ID,NAME,DMELETEMPLATE_ID,DMACTIVITY_ID from DMELEMENT where DMACTIVITY_id = 10201

Query: Select DMELEMENT_ID, NAME, VALUE from DMELEMENTNVP where DMELEMENT_ID in (10857,10858,10859 

Above relation is explained here: Marketing activity data storage and process flow


E-Marketing Spot
Query: Select EMSPOT_ID, NAME, USAGETYPE from EMSPOT where name = 'Shoeb'

If e-Marketing spot has default content set then, it will be referenced in DMEMSPOTDEF table.
Query: Select * from DMEMSPOTDEF where EMSPOT_ID = 10801

Content

Query: Select COLLATERAL_ID, COLLTYPE_ID, NAME, URL from COLLATERAL where COLLATERAL_ID = 10801

Query: Select COLLATERAL_ID, LOCATION, MARKETINGTEXT from COLLDESC where COLLATERAL_ID =10801



Comments

Post a Comment

Popular posts from this blog

Websphere Commerce Data Load using CSV \Websphere Commerce Data Load using XML

-
Websphere Commerce Data Load using CSV \Websphere Commerce Data Load using XML Data can be loaded into WCS tables using data load utility. Data load utility works in the steps as mentioned below. 1.Data Reader The data reader reads the input file, and transforms the input into a data object. Data objects are typically map objects. Eg: CSV data reader \XML Data Reader 2.Business Object Builder The business object builder instantiates the business object and populates it from the data in the data object. Eg:The table object builder 3. Business Object Mediator The business object mediator converts the business object into physical object. The table object mediator is always used with the table object builder. Eg: table-based mediator 4. Data Writer The data writer writes the physical object into the database. This tutorial uses the default data writer to write the generated physical o...
Read more

Websphere Commerce Catalog Subsystem

-
  Websphere Commerce Catalog Subsystem The Catalog Subsystem contains all logic and data relevant to an online catalog, including catalog groups (or categories), catalog entries, and any associations or relationships among them.    Master Catalog It is the single catalog that contains all products, items, relationships, and standard prices for everything that is for sale in your store. Every store in the Web Sphere Commerce system must have a master catalog. It is possible to share the master catalog across stores. Master Catalog Restrictions 1)The master catalog must be a proper tree, which means that there are no cycles. e.g.The parent category "Women" has a subcategory "WomenDress". It is important that WomenDress and any of WomenDress's subcategories like tops,jeans etc are not the parent category of "Women" category. 2)A catalog entry or category cannot belong to multiple parent categories in the master...
Read more

Calculation Framework in Websphere Commerce.

-
  OrderCalculateCmd OrderCalculateCmd invokes the Promotion engine. PromotionEngineOrderCalculateCmdImpl implements OrderCalculateCmd class. OrderCalculateCmd is invoked when we add, delete, update or merge item/s in cart. This command calculates the order  total based on the sequence in which calculationUsageId is passed into the command. WebSphere Commerce provides the below predefined calculation usages: Calusage_id    Description -1                         Discount -2                         Shipping -3                         Sales Tax -4          ...
Read more