This table describes how StoreEntities want their automated commerce reports to be delivered.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031304490 |
STOREENT_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_926 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.