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 | 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 |