Grouping entities for flexible Sterling Order Management System Software deployments

You can create a flexible Sterling Order Management System Software deployment by using groups of tables.

Flexible deployments are achieved through the use of the following groups of tables:

  • Configuration Data Tables - These groups of tables generally store system or business rules such as sourcing rules, routing guide, shipping preferences, and so on. In addition, these tables store organizations.

    Only one Configuration data table can be used per version and it must be used by all enterprises in the deployment that are on that version.

  • Transaction Data Tables - These groups of tables contain a high volume of constantly-changing data.

    In Sterling Store Inventory Management and in Sterling Order Management System Software, this data is relevant to orders and shipment tasks. It also includes inventory, inventory location, and capacity tables.

  • Master Data Tables - These groups of tables contain data that is created through batch feeds and is often referenced by other organizations. A master data table can be dedicated to a colony.

    In Sterling Order Management System Software, Master Data tables contain data relevant to catalogs, pricing, and customers.

  • Metadata Tables - These groups of tables contain data required for database lookup of core configuration information. It is a set of unique tables across versions and performs “traffic direction” of transactions across sharded, multi-version deployments.
  • Statistics Tables - These groups of tables are used for maintaining statistics for the application such as agent and API statistics.

    Only one Statistics data table can be used per version.