Jump to main content
HCL Logo Product Documentation
Customer Support Software Academy Community Forums
IBM WebSphere Commerce V7
  • Product overview
  • WebSphere Commerce search
  • Precision marketing
  • What's new
  • User Guide
  • Reference
  • Other versions
  1. Home
  2. Reference
  3. Data models

    Any given database data model displays the relationship among database tables in the schema.

  4. Order Management

    The order management data model shows the relationship between database tables related to the Order Management subsystem.

  5. ATP inventory fulfillment

    The ATP inventory fulfillment data model shows the relationship between database tables that contain information about ATP inventory fulfillment.

  • Reference
    • Cross-reference of data beans, EJB beans, and tables

      Data beans are grouped into several component groups.

    • Cross-reference of commands, tasks, and tables

      URL commands, controller commands, task commands, view commands and tables are related to each other.

    • Cross reference: Commands to beans to database tables

      Use this information when you are customizing a command and you want to know which tables are affected. You should also use this topic if you are modifying a table and want to know which commands and beans are affected.

    • HCL Commerce API reference

      Legacy API classes can be browsed via Javadoc. New API classes are exposed using the REST interface.

    • Shopping flow URLs

      WebSphere Commerce shopping flow URLs are organized by subsystem.

    • WebSphere Commerce search URLs

      The starter stores consist of pages that are associated with URLs that are run by WebSphere Commerce search. You can use the following URLs to invoke various WebSphere Commerce search tasks.

    • WebSphere Commerce database schema

      The WebSphere Commerce database model was designed for data integrity and optimal performance. WebSphere Commerce provides several hundred tables that store WebSphere Commerce instance data. To maintain data integrity, and to ease maintenance referential integrity, constraints are widely used in the database model. Indexes are used carefully on tables to avoid over-indexing and to provide a good balance between data retrieval and data manipulation activities (insert and update). The business rules are implemented at the application level rather than by using database trigger. Triggers, however, are used to facilitate data staging and optimistic locking. A limited number of SQL-based database stored procedures are used for data intensive activities.

    • Data models

      Any given database data model displays the relationship among database tables in the schema.

      • Legend for data models

        Database tables within the WebSphere Commerce database schema are organized into functional groups, called data models.

      • Catalog

        The catalog data model shows the relationship between database tables related to the Catalog subsystem.

      • Content versioning

        The content versioning data model shows the relationship between database tables that contain information about the content versioning.

      • Content management system integration

        The content management system integration data model shows the relationship between database tables used by the solution.

      • IBM Gift Center

        The IBM Gift Center data model shows the relationship between database tables that contain information about IBM Gift Center.

      • Folder (for feature pack 5)

        The folder data model shows the relationship between database tables that contain information about folders.

      • Folder (for feature pack 6)

        The folder data model shows the relationship between database tables that contain information about folders.

      • WebSphere Commerce search engine optimization

        The WebSphere Commerce search engine optimization (SEO) shows the relationship between database tables that contain information about WebSphere Commerce search engine optimization (SEO).

      • Promotions

        The promotions data models show the relationship between database tables that are related to the promotions.

      • Marketing

        The marketing data model shows the relationship between database tables related to the Marketing subsystem.

      • Access control

        The access control data model shows relationships between the access control policy tables. An access control policy is composed of a member group, resource group, and action group. It can optionally contain a relationship or relationship group as well. Access control policies are grouped into policy groups, to which organizations subscribe.

      • Access logging

        The access logging data model shows the relationships among tables that log access violations.

      • Authentication

        The authentication data model shows the relationship between database tables that contain information about security policies within the system.

      • Member

        The member data model shows the relationship between database tables that contain information about users, organizational entities, user groups, and roles

      • Order Management

        The order management data model shows the relationship between database tables related to the Order Management subsystem.

        • ATP inventory

          The ATP inventory data model shows the relationship between database tables that contain information about ATP inventory.

        • ATP inventory adjustment

          This diagram shows the relationship between database tables that contain information about ATP inventory adjustments.

        • ATP expected inventory

          The ATP expected inventory data model shows the relationship between database tables that contain information ATP expected inventory.

        • ATP inventory fulfillment

          The ATP inventory fulfillment data model shows the relationship between database tables that contain information about ATP inventory fulfillment.

        • ATP inventory orders

          The ATP inventory orders data model shows the relationship between database tables that contain information about ATP inventory orders.

        • ATP inventory reservations

          The ATP inventory reservations data model diagram shows the relationship between database tables that contain information about ATP inventory reservations.

        • Billing

          The database tables that contain information about billing do not have any direct relationship with each other.

        • Calculation code

          The Calculation code data model shows the relationship between database tables that contain information about calculation codes.

        • Calculation code - direct attachment

          The Calculation code - direct attachment data model shows the relationship between database tables that contain information about direct attachments in calculation codes.

        • Calculation code - indirect attachment

          The Calculation code - indirect attachment data model shows the relationship between database tables that contain information about indirect attachments in calculation codes.

        • Calculation method

          Each row in the CALMETHOD database table indicates a task command that can be used by a store, or by stores in a store group, to perform calculations of discounts, shipping charges, sale or use tax, and shipping taxes (depending on its calculation usage).

        • Calculation rule

          A CalculationCode can have several different CalculationRules. Each CalculationRule provides a way of producing monetary amounts for each of a group of OrderItems. Which rules are used depend on the result of the CalculationRuleCombine and CalculationRuleQualify CalculationMethods, and the actual calculation is performed by the CalculationRuleCalculate CalculationMethod.

        • Calculation rule - discount

          The Calculation rule - discount data model shows the relationship between database tables that contain information about discount data in calculation rules.

        • Calculation rule - shipping

          The Calculation rule - shipping data model shows the relationship between database tables that contain information about shipping data in calculation rules.

        • Calculation rule - tax

          The Calculation rule - tax data model shows the relationship between database tables that contain information about tax data in calculation rules.

        • Calculation scale

          The Calculation scale data model shows the relationship between database tables that contain information about calculation scales. You can use calculation scales to define ways to calculate discounts, shipping charges, and taxes within a store. The scale is part of a StoreEntity and can be associated with a particular QuantityUnit or Currency.

        • Calculation usage

          The calculation usage data model shows the relationship between database tables that contain information about calculation usage. Calculation usage includes discounts, shipping charges, and sales and shipping taxes. Calculation usage can be specified for individual stores, and affects the way that calculation codes and methods are used.

        • Country and state code

          The Country and state code data model shows the relationship between database tables that contain information about the state and country codes for taxes.

        • Currency

          The currency data model shows the relationship between database tables that contain information about currency within payments.

        • DOM inventory cache data model

          The DOM inventory cache data model shows the relationship between database tables that contain information about inventory configuration and inventory cache in DOM inventory.

        • Fulfillment

          The Fulfillment data model shows the relationship between database tables that contain information about fulfillment. Fulfillment centers are not part of a store, and hold inventory on behalf of stores.

        • Interest item

          The Interest item data model shows the relationship between database tables that contain information about interest items.

        • ***
        • Offers

          The Offers data model shows the relationship between database tables containing information about offers for trading positions.

        • Order

          The Order data model shows the relationship between database tables that contain information about orders. Members can own StoreEntities. Other Members can create Orders and Addresses. An Order may have a billing address.

        • Order adjustment

          The Order adjustment data model shows the relationship between database tables that contain information about order adjustments. Each OrderAdjustment is the total of the OrderItemAdjustments that are created when the results from a particular CalculationCode calculation are applied.

        • Order management adjustment and tax

          The Order management adjustment and tax data model shows the relationship between database tables that contain information about order management adjustment and tax data for an Order.

        • Order management - receipt and disposition

          The Order management - receipt and disposition data model shows the relationship between database tables that contain information about receipt and disposition data for an Order.

        • Order management - RMA

          The Order management - RMA data model shows the relationship between database tables that contain information about RMA (return merchandise authorization) data for an Order.

        • Order management - RMAitem

          The Order management - RMAitem data model shows the relationship between database tables that contain information about RMA (return merchandise authorization) item data for an Order.

        • Order release

          The Order release data model shows the relationship between database tables that contain information about release data for an Order.

        • Order tax

          The Order tax data model shows the relationship between database tables that contain information about tax data for an Order.

        • Order trading agreement

          The Order trading agreement data model shows the relationship between database tables that contain information about order trading agreements.

        • Order item

          The Order item data model shows the relationship between database tables that contain information about order item data.

        • Order item - allocated

          The Order item - allocated data model shows the relationship between database tables that contain information about allocated data for an OrderItem.

        • Order item - backordered

          The Order item - backordered data model shows the relationship between database tables that contain information about backordered data for an OrderItem.

        • Pricing

          The Pricing data model shows the relationship between database tables that contain information about pricing.

        • Price rules

          The price rules data model shows the relationship between tables used in the Catalog Filter and Pricing tool.

        • Procurement

          The Procurement data model shows the relationship between database tables that contain information about procurements.

        • Quantity unit

          The Quantity unit data model shows the relationship between database tables that contain information about quantity units.

        • Quantity unit - references

          The Quantity unit - references data model shows the relationship between database tables that contain information about quantity units.

        • Receipt

          The Receipt data model shows the relationship between database tables that contain information about receipts.

        • Shipping

          The shipping data model shows the relationship between database tables that contain information about shipping.

        • Buy online, pickup in-store

          The Buy online, pickup in-store data model shows the relationship between database tables that contain information about online orders that are to be picked up in-store.

        • Suborders

          The suborders data model shows the relationship between database tables that contain information about suborders.

        • Subscriptions and recurring orders

          The subscriptions and recurring orders data model shows the relationship between database tables related to the service provider solution.

        • Tax type and category

          The Tax type and category data model shows the relationship between database tables that contain information about categories and types of taxes.

        • Ticklers

          The Ticklers shows the relationship between database tables that contain information about ticklers.

        • Vendor

          The Vendor data model shows the relationship between database tables that contain information about vendor.

      • Payment

        The payment data models show the database table related to the WebSphere Commerce Payments Multipayment framework and the Payments subsystem.

      • Store

        The store data models show the relationship between database tables that are related to stores.

      • System

        The system data models show the relationship of database tables used for WebSphere Commerce system functions.

      • Trading

        The trading data models show the relationship of database tables in the Trading subsystem.

      • Workspaces

        The Workspaces data model show the relationship of database tables used in workspaces.

      • WebSphere Commerce search

        WebSphere Commerce search data models show the relationship between database tables that are related to WebSphere Commerce search.

    • WebSphere Commerce store pages properties
    • Caching defaults

      During installation, WebSphere Commerce sets up the caching system with the default values.

    • Cache-entry elements

      The root element of the cachespec.xml file, <cache>, contains <cache-entry> elements. The WebSphere dynamic cache service parses the cachespec.xml file during startup, and extracts a set of configuration parameters from each <cache-entry> element.

    • Ant targets

      A WebSphere Commerce instance can be created from the command line. The command-line utility uses Apache Ant to create the objects required. The targets are divided into several high-level groups that correspond to the environment that is to be configured.

    • IBM Sales Center extension points

      The extension points listed on this page are provided by IBM and used in the IBM Sales Center.

    • IBM Sales Center Business Object Document response builders available by default
    • WebSphere Commerce REST API

      WebSphere Commerce REST services are JAX-RS REST services that are built on top of Apache Wink. The implementation classes contain JAX-RS annotations such as @Path, @Produces, @Consumes, @QueryParam, and @PathParam.

    • Payments subsystem

      In WebSphere Commerce Version 6.x the Payments subsystem was introduced. Payment processing using the WebSphere Commerce Multipayment Framework (used in version 5.x) and payment processing using the Payments subsystem is fundamentally different.

    • WebSphere Commerce Payments command reference

      Parameters for the commands described here apply to the framework only. Note that in most cases, WebSphere Commerce Payments does not check for duplicate parameters. If more than one instance of a parameter is specified, then the last instance will be used.

    • Data Load utility configuration file schema

      The Data Load utility contains several configuration files. You can use the configuration file schema to understand and customize the data load configuration files.

    • Glossary

ATP inventory fulfillment data model

The ATP inventory fulfillment data model shows the relationship between database tables that contain information about ATP inventory fulfillment.

Click any of the database table boxes to see more information about that table. You can also refer to one of the following types of ATP inventory data models: ATP inventory, ATP inventory adjustment, ATP inventory expected, ATP inventory orders, and ATP inventory reservations.

Image mapBASEITEMRECEIPTPICKBATCHITEMSPCORDPICKHSTORDSHIPHSTORDERITEMSMANIFESTFFMCENTERORDERSORDRELEASE
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences