Database Table: REPDLVRY

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035049470 STOREENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_926 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable