Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: REPDLVRY
This table describes how StoreEntities want their automated commerce reports to be delivered.
Column Name Column Type Description STOREENT_ID INTEGER NOT NULL The StoreEntity that the report delivery settings are for. FISCALYEAR CHAR(50) NOT NULL DEFAULT '01/01' The beginning of the fiscal year of the StoreEntity, in the MM/DD format. Used for quarterly reports. FORMAT INTEGER NOT NULL DEFAULT 0 The format of the report. Valid values are...
- 0 = plain text
- 1 = comma separated values
FREQUENCY CHAR(1) NOT NULL DEFAULT 'M' The frequency for receiving the report: M = monthly, Q = quarterly. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030421700 STOREENT_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_926 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference
_vcc_freeselect_bottom_