Claimable Tables

Claimable Tables

ATG Commerce uses the following table to store claimable information:

dcspp_claimable

Column	Data Type	Constraint
`claimable_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository id of the claimable repository item.
`version`	INTEGER	NOT NULL
	Used by the repository to detect “out of date” updates. This information is managed internally by the ATG repositories.
`type`	INTEGER	NOT NULL
	Indicates whether a particular instance of a repository item is a coupon or a gift certificate.
`status`	INTEGER	NULL
	Indicates if a particular item has been claimed or not.
`expiration_date`	DATE	NULL
	If there is an expiration date, then an item cannot be claimed after this date.

dcspp_giftcert

Column	Data Type	Constraint
`giftcertificate_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the gift certificate. References `dcspp_claimable(claimable_id)`
`amount`	DOUBLE PRECISION	NOT NULL
	The amount of the gift certificate.
`amount_authorized`	DOUBLE PRECISION	NOT NULL
	The amount of the gift certificate authorized to be used at the time a purchase is made.
`amount_remaining`	DOUBLE PRECISION	NOT NULL
	The amount of the gift certificate remaining after it has been used. Before the gift certificate has been claimed, this amount is equal to the amount property.
`purchaser_id`	VARCHAR(40)	NULL
	The profile id of the person who purchased the gift certificate.
`purchase_date`	DATE	NULL
	The date on which the gift certificate is purchased
`last_used`	DATE	NULL
	The date on which the gift certificate was last used.

dcs_storecred_clm

This table includes information on store credit.

Column	Data Type	Constraint
`store_credit_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_claimable(claimable_id)`
`amount`	DOUBLE PRECISION	NOT NULL
	Contains the original amount of the store credit
`amount_authorized`	DOUBLE PRECISION	NOT NULL
	Contains the amount of the store credit authorized.
`amount_remaining`	DOUBLE PRECISION	NOT NULL
	The amount of the store credit which has not been consumed yet.
`owner_id`	VARCHAR(40)	NULL
	The profile id of the owner of this store credit.
`issue_date`	TIMESTAMP	NULL
	The date the store credit was issued.
`expiration_date`	TIMESTAMP	NULL
	The date the store credit expires. Can be NULL.
`last_used`	TIMESTAMP	NULL
	The date the store credit was last used.

dcspp_coupon

Column	Data Type	Constraint
`coupon_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the coupon. References `dcspp_claimable(claimable_id)`
`promotion_id`	VARCHAR(40)	NOT NULL
	The unique identifier associated with the promotion.

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