Reference > Database > Data models

Order Management data models

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

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

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

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

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

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

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

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

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

• Calculation code - direct attachment data model
  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 data model
  The Calculation code - indirect attachment data model shows the relationship between database tables that contain information about indirect attachments in calculation codes.

• Calculation method data model
  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 data model
  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 data model
  The Calculation rule - discount data model shows the relationship between database tables that contain information about discount data in calculation rules.

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

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

• Calculation scale data model
  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 data model
  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 data model
  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 data model
  The currency data model shows the relationship between database tables that contain information about currency within payments.

• Fulfillment data model
  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 data model
  The Interest item data model shows the relationship between database tables that contain information about interest items.

• Jurisdiction data model
  The Jurisdiction data model shows the relationship between database tables that contain information about tax and shipping jurisdictions.

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

• Order data model
  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 data model
  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 data model
  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 data model
  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 data model
  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 data model
  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 data model
  The Order release data model shows the relationship between database tables that contain information about release data for an Order.

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

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

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

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

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

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

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

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

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

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

• Ship data model
  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.

• Store locator
  The Store locator data model shows the relationship between database tables that contain information for the store locator functionality.

• Store data model
  The Store data model shows the relationship between database tables that contain information about stores.

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

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

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

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

Related reference

Data models

Legend for data models

+

Search Tips   |   Advanced Search