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

Column Descriptions:

STOREENT_IDINTEGER NOT NULLThe StoreEntity that the report delivery settings are for.
FISCALYEARCHAR (50) NOT NULL DEFAULT '01/01'The beginning of the fiscal year of the StoreEntity, in the MM/DD format. Used for quarterly reports.
FORMATINTEGER NOT NULL DEFAULT 0The format of the report. Valid values are as follows:
  • 0 = plain text
  • 1 = comma separated values
FREQUENCYCHAR (1) NOT NULL DEFAULT 'M'The frequency for receiving the report: M = monthly, Q = quarterly.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType