This table represents how each store wants the automated commerce reports to be delivered.
Column Name | Column Type | Column Description |
---|---|---|
FISCALYEAR | CHARACTER (50) NOT NULL, DEFAULT '01/01' |
The fiscal year of the store, in the format MM/DD. Used for report delivery if "quarterly" is the frequency selected. |
FORMAT | INTEGER NOT NULL, DEFAULT 0 |
Indicates the format of the report: 0 = text 1 = comma separated |
FREQUENCY | CHARACTER (1) NOT NULL, DEFAULT 'M' |
Indicates the frequency for receiving the report: M = monthly Q = quarterly |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity the report delivery settings belongs to. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035049470 | STOREENT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_926 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|