WebSphere Commerce database table: REPDLVRY

REPDLVRY

This table describes how StoreEntities want their automated commerce reports to be delivered.

Column Descriptions:

Name 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 as follows:

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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> STOREENT_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_926 STOREENT_ID STOREENT STOREENT_ID Cascade

Related reference
Store data model

Name	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 as follows: 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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.