Order Markers Table

Order Markers Table

The following section describes the table used to hold order marker information.

dcs_order_marker

This table to hold information about markers assigned to orders when an order reaches a business process stage.

Column	Data Type	Constraint
`marker_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the marker.
`order_id`	VARCHAR(40)	NOT NULL
	The ID of the order for that has an order marker.
`marker_key`	VARCHAR(100)	NOT NULL
	The name of the business process associated with the marker.
`marker_value`	VARCHAR(100)	NULL
	The name of the business process stage associated with the marker.
`marker_data`	VARCHAR(100)	NULL
	This column is not currently in use.
`creation_date`	timestamp	NULL
	The date the business process stage is reached and the order marker is assigned to the order.
`version`	INTEGER	NOT NULL
	The order marker repository version number. This information is managed and used internally by the repository.
`marker_type`	INTEGER	NULL
	This column is not currently in use.

Contents
Search

loading table of contents...

Introduction
- Commerce Overview
- Finding What You Need
- In This Guide
Configuring and Populating a Production Database
- Creating Database Tables
- Using ATG Commerce with an Oracle Database
  - Configuring Storage Parameters
  - Configuring a Catalog for Oracle Full Text Searching
- Using ATG Commerce with an MSSQL Database
- Transferring Product Catalog and Price List Data Using Copy and Switch
- Transferring Demo Data
  - Exporting the Demo Data from SOLID
  - Importing the Demo Data to Your Database
- Destroying Database Tables for ATG Commerce
Using and Extending the Standard Catalog
- Catalog Repository
- Categories and Products
- SKU Items and SKU Links
- Folders and Media Items
- Designing a Multi-Locale Product Catalog
Using Custom Catalogs
- Using ATG Commerce with Custom Catalogs
- Converting from Standard to Custom Catalogs
- The Custom Catalog Repository
- Custom Catalog Security
- Custom Catalog Navigation
  - Looking Up Items in the Catalog
  - Using the parentCategory Property
- Custom Catalog Searching
- Running the Custom Catalog Maintenance System
  - Batch Services
  - Dynamic Services
- Assigning a Custom Catalog to a User
ATG Commerce Profile Extensions
- Profile Repository Extensions
- Profile Form Handler Extensions
- Profile Tools and Property Manager Extension
Configuring Merchandising Services
- Setting Up Gift Lists and Wish Lists
- Setting Up Product Comparison Lists
- Setting Up Gift Certificates and Coupons
Using and Extending Pricing Services
- Overview of Pricing Services
- Public Pricing Interfaces and Classes
- Default Pricing Engines
- Default Pricing Calculators
- Extending and Creating Pricing Engines
- Extending and Creating Pricing Calculators
  - Adding a New Pricing Calculator
  - Extending Calculators
- Extending the Qualifier Class
- Creating Promotions
- Using Price Lists
Working With Purchase Process Objects
- The Purchase Process Subsystems
- Creating Commerce Objects
- Using Relationship Objects
- Assigning Items to Shipping Groups
- Assigning Costs to Payment Groups
  - Assigning an Order’s Total Cost to Payment Groups
  - Assigning an Order’s Component Costs to Payment Groups
- Setting Handling Instructions
  - HandlingInstruction Objects
  - Adding Handling Instructions to a Shipping Group
- ATG Commerce States
- Purchase Process Class Diagrams
Configuring Purchase Process Services
- Loading Orders
  - Refreshing Orders
- Modifying Orders
  - Understanding the CartModifierFormHandler
  - Modifying the Current Order
- Repricing Orders
- Saving Orders
  - Updating an Order with the OrderManager
- Canceling Orders
- Checking Out Orders
- Processing Payment of Orders
- Scheduling Recurring Orders
- Setting Restrictions on Orders
  - Understanding the Order Restriction Classes
  - Implementing Order Restrictions
- Tracking the Shopping Process
- Troubleshooting Order Problems
- Handling Returned Items
- Working with ATG Commerce Form Handlers
  - Managing Transactions in the ATG Commerce Form Handlers
  - Extending the ATG Commerce Form Handlers
Customizing the Purchase Process Externals
- Purchase Process Event Messages
- Integrating with Purchase Process Services
  - Purchase Process Integration Points
  - Adding Credit Card Types to ATG Commerce
- Extending the Purchase Process
- Merging Orders
Processor Chains and the Pipeline Manager
- Pipeline Manager Overview
- Using the Pipeline Editor
- Running a Processor Chain
- Creating a Processor Pipeline
- Pipelines and Transactions
  - Processor Transaction Management
  - Spanning Transactions over a Chain Subset
- Extending the Processor Pipeline Classes
- Adding a Commerce Processor Using XML Combination
  - Executing Processor Chains from Processors within Other Chains
- Commerce Processor Chains
Inventory Framework
- Overview of the Inventory System
  - Using the Inventory System
- Inventory System Methods
- Inventory Classes
- InventoryManager Implementations
- Examples of Using the Inventory Manager
- Handling Bundled SKUs in the Inventory
- Inventory Repository
- Inventory JMS Messages
- Configuring the SQL Repository
  - Caching the Inventory
- Inventory Repository Administration
  - Using the InventoryLookup Servlet Bean
- Building a New InventoryManager
  - Configuring a New Inventory Manager
Configuring the Order Fulfillment Framework
- Overview of Fulfillment Process
- Running the Fulfillment Server
- Order Fulfillment Classes
- Fulfillment Pipelines
  - Descriptions and Diagrams of Fulfillment Pipelines
- Using Locking in Fulfillment
- Using the OrderFulfiller Interface
- Using the Fulfiller
  - Notifying the HardgoodFulfiller of a Shipment
  - HardGoodFulfiller Examples
- Creating a New Fulfiller
  - Configuring a New Fulfiller
- Order Fulfillment Events
- Fulfillment Server Fault Tolerance
  - Fulfillment Message Redelivery
- Replacing the Default Fulfillment System
- Integrating the Order Fulfillment Framework with an External Shipping System
- Changing Payment Behavior in Fulfillment Server
- Using Scenarios in the Fulfillment Process
- Questions & Answers
Managing the Order Approval Process
- Understanding the Order Approval Process
  - Modifying the Order Approval Process
- Servlet Beans and Form Handlers for Approving Orders
- Pipeline Chains in the Order Approval Process
- JMS Messages in the Order Approval Process
Using Abandoned Order Services
- An Overview of Abandoned Orders
- Defining and Detecting Abandoned Orders
  - Defining Abandoned and Lost Orders
  - Detecting Abandoned and Lost Orders
- Configuring AbandonedOrderService
- Configuring AbandonedOrderTools
- Scenario Events and Actions
  - Scenario Events
  - Scenario Actions
- Tracking Abandoned Orders of Transient Users
- Customizations and Extensions
Generating Invoices
- Overview
- Invoices in Checkout
- Invoice Payment
- The Invoice Repository
Using Requisitions and Contracts
- Requisitions
- Contract Repository Items
- Using Contracts
Preparing to Use Commerce Reporting
- Setting Up Commerce Reporting Environments
- Configuring a Parent Catalog
- Logging Data for Commerce Reporting
- Loading Data for Commerce Reporting
ATG Commerce Web Services
- Order Management Web Services
- Pricing Web Services
- Promotion Web Services
- Inventory Web Services
- Catalog Web Services
- Profile Web Services
- Commerce Web Services Security
  - Using the Order Owner Security Policy
ATG Commerce and Session Backup
ATG Commerce Databases
- Core ATG Commerce Functionality Tables
- ATG Business Commerce Tables
ATG Commerce Messages
- Base ATG Commerce Messages
  - Fulfillment System Messages
- Abandoned Order Messages
- ATG Business Commerce Messages
ATG Commerce Scenario Recorders
- dcs
- dcs-analytics
- shoppingprocess
Index