This table describes how StoreEntities want their automated commerce reports to be delivered.
Column Descriptions
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 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
| Reserved for IBM internal use.
|