WebSphere Commerce database table: STQOTCFG

WebSphere Commerce database table: STQOTCFG

This table is used to configure the quote on a store entity.

Column Descriptions
Column Name Column Type Description

STOREENT_ID INTEGER NOT NULL The store entity ID to which the quote config apply.

RETIREFLAG INTEGER DEFAULT 1 Service Representative quote configuration. 1=A quote is retired once an order is created from it. 2= A quote is retired when order is submitted

CSREXPIREPERIOD BIGINT DEFAULT 5184000 The maximum expiry period that the CSR can set if they override the default period (e.g. no more than 60 days).

CSSEXPIREPERIOD BIGINT DEFAULT -1 The maximum expiry period that CSR supervisor can set. Default value is -1. -1 means the period ban be unlimited.

EXPIREPERIOD BIGINT DEFAULT 2592000 Provides the default time period for which a single-seller quote is valid.

OPTCOUNTER SMALLINT IBM Internal Use.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235256450 STOREENT_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

R_3447 STOREENT_ID STOREENT STOREENT_ID Cascade

Column Name	Column Type	Description
STOREENT_ID	INTEGER NOT NULL	The store entity ID to which the quote config apply.
RETIREFLAG	INTEGER DEFAULT 1	Service Representative quote configuration. 1=A quote is retired once an order is created from it. 2= A quote is retired when order is submitted
CSREXPIREPERIOD	BIGINT DEFAULT 5184000	The maximum expiry period that the CSR can set if they override the default period (e.g. no more than 60 days).
CSSEXPIREPERIOD	BIGINT DEFAULT -1	The maximum expiry period that CSR supervisor can set. Default value is -1. -1 means the period ban be unlimited.
EXPIREPERIOD	BIGINT DEFAULT 2592000	Provides the default time period for which a single-seller quote is valid.
OPTCOUNTER	SMALLINT	IBM Internal Use.