Appendix A. Commerce Service Center Database Tables
This appendix describes the database
tables
used by Commerce Service Center.
ATG Commerce Service Center Installation and Programming Guide
.
Documentation Home
Feedback
Highlighting
Prev
Next
Contents
Search
Introduction
Audience
Documentation Conventions
Related Documents
Before You Begin
Browser and Environment Requirements
Commerce Service Center Architecture
Customer-Facing Server Configuration
Agent-Facing Server Configuration
Multiple Sites and Data Sharing
Site Groups
Shareables and/or Shareable Types
Site Context
Site Priority
Installing Commerce Service Center
Requirements for Commerce Service Center
Database and Schema Requirements
Installing with the Configuration and Installation Manager
Repositories
Using IDGenerators
Understanding Lock Management
Accessing Commerce Service Center
Configuring Commerce Service Center
Configuring Order and Profile Search
Order and Profile Search Overview
Configuring Live Indexing for Oracle ATG Web Commerce Search
Creating Search Indexing Environments
Preloading the Index
Purging Older Orders
Performing a Manual Re-Index
Adding Searchable Properties
Configuring Oracle for Catalog Searching
Configuring Multiple Sites
Site Configuration Overview
Configuring the Default Site
Configuring the Default Site Icon
Configuring a Site Icon
Configuring Shareables
Enabling Multisite
Customizing Wish/Gift Lists
Modifying the New Gift List Form
Configuring the Gift Registry Search
Configuring Returnable Order States
Creating Return Reason Codes
Creating Returned Item Dispositions
Configuring Scheduled Orders
Enabling and Disabling Scheduled Orders
Configuring Price Lists
Configuring Promotions Browser Access
Customizing Gift with Purchase Promotions
Returns and Exchanges of Gifts with Purchases
Configuring Order Approval
Enabling the Order Approval Process
Setting Global Appeasement Limits
Modifying Individual Appeasement Limits
Providing Approval Authorization
Servlet Beans and Form Handlers for Approving Orders
Setting Up Internal Access Control
Access Control Overview
Default Internal User Access Control Configuration
Global Roles
Access Controllers
Creating New Roles
Creating Agent Profiles
Creating a New Agent Role
Default Roles
Customizing the Default Landing Page
Programming Commerce Service Center
Using the CSRConfigurator Component
Customizing E-Mail
Configuring E-mail Notifications
Configuring New Passwords
Configuring Order Confirmation E-Mails
Configuring E-Mail Templates
Configuring Audit Logging
Viewing Audit Logs
Adding a New Agent Audit Log Record
Disabling Audit Logging Events
Using Window Scoped Failover
Adding Additional Components
Configuring Current Catalog and Price Lists
Using the Current Catalog
Using the Current Price List
Defining the Default Catalog
Defining the Default Price List
Setting the Pricing Locale
Specifying Quick Access Catalogs and Price Lists
Environment Monitoring
CSREnvironmentTools
CSREnvironmentMonitor
CSREnvironmentConstants
EnvironmentChangeFormHandler, ChangeOrder
Ticket Disposition Monitoring
EnvironmentTools
Environment Management and Site Context
Pricing Overview
Loading Orders and Pricing
Price Lists and Pricing
Original versus Current Pricing
Automatic Removal of Items
Promotions
Determining the Correct PricingModelHolder
Configuring Manual Pricing Adjustments
Working with Scheduled Order Templates
Customizing Shipping and Payments
Shipping and Payment Group Configuration Overview
Default Shipping Group Types
Default Payment Group Types
Configuring Shipping Addresses
Shipping and Payment Group Servlet Beans and Form Handlers
Working with Addresses
Enabling and Disabling Copies
Disabling Address Sharing
Modifying Submitted Orders
Cloning Pipeline Chains
Cloning Core Classes
Extending Objects for Cloning
Handling and Fulfillment
Fulfillment Notification for Order Modifications
Customizing Refund Methods
Customizing Returns and Exchanges
Returns and Exchanges Overview
Calculating Suggested and Actual Refund Amounts
ItemCostAdjustments
Extending Return Request Objects
Configuring Default Return Fees
Identifying Returnable Orders and Items
Customizing Shipping Refund Calculations
ItemPriceSource Objects
Accessing Working Orders
Pricing Exchange Orders
Applying Promotions to Exchange Orders
Customizing Scheduled Orders
Displaying Scheduling Information
Scheduled Order Components
Scheduled Orders Pipeline Additions
Using Scenarios
Configuring Scenario Events
Working with Scenario Managers
Configuring Process Editor Servers
Configuring the Customer-Facing Scenario Manager
Configuring the Agent-Facing Scenario Managers
Commerce Service Center Reporting Framework
Data Collection Overview
Loader Pipeline Overview
Commerce Service Center Database Tables
Commerce Service Center Core Tables
Commerce Service Center Order Approval Tables
Commerce Service Center Profile Tables
Commerce Service Center Logging Tables
Commerce Service Center Access Rights Comparison
CIM Configuration Components
Available Added Functionality
Server Instances
Add On Modifications
Data Source Configuration
JTDataSource for Agent
JTDataSource for Production
Switching Data Source
CIM File Configuration
Production Server File Configurations
Agent Server File Configurations
Prerequisites for Running CIM
Running CIM
Configuring Live Help On Demand Click to Call
Overview
Initiating a Call
Using a CTI System
Specifying Links and Pop-Ups
Automatic Initialization of the Agent’s Working Environment
Click to Call Requirements
IBM WebSphere Requirements
Oracle WebLogic Requirements
Configuring the Click to Call Account
Adding an Agent to Commerce Service Center
Adding Agent Phone Numbers
Configuring Customer-Facing Store Web Pages
Configuring Automatic Page Instrumentation
Configuring a Static Link
Disabling the Orphaned Session Service
Creating Store-Facing Links
Using the clickToConnectSave() Function
ATGCallToken
Creating Store-Facing Static Click to Call Links
Creating a Click to Call Link
Creating a Click to Call Pop-Up
Creating a Customized Link or Pop-Up
Using Live Help On Demand Agent Console
Integrating with the Live Help On Demand Agent Console
Integrating without Live Help On Demand Agent Console
Manual CTI Integration
Configuring Commerce Service Center Authentication with the Agent Console
Enabling Commerce Service Center Auto-Authentication
Disabling Commerce Service Center Auto-Authentication
Configuring Commerce Service Center Landing Page Components
Default Landing Page
Customizing Landing Page Components
Index
Search Terms