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