Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STQOTCFG
This table is used to config the quote on a store entity.
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 can 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 SQL100520030435460 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 _vcc_freeselect_bottom_