STQOTCFG

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

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe store entity ID to which the quote config apply.
RETIREFLAGINTEGER DEFAULT 1Service Representative quote configuration. 1=A quote is retired once an order is created from it. 2= A quote is retired when order is submitted
CSREXPIREPERIODBIGINT DEFAULT 5184000The maximum expiry period that the CSR can set if they override the default period (for example, no more than 60 days).
CSSEXPIREPERIODBIGINT DEFAULT -1The maximum expiry period that CSR supervisor can set. Default value is -1. -1 means the period can be unlimited.
EXPIREPERIODBIGINT DEFAULT 2592000Provides the default time period for which a single-seller quote is valid.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STOREENT_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
R_3447STOREENT_IDSTOREENTSTOREENT_IDCascade