Home > Technical > Table Definitions > ITEMSPECIALDATES
This table contains special dates that can effect when an item can be used for specific tasks. An item can contain many special dates, one for each location/date type. The Set Store Costs/Sells process will select the dates for a specific location and update the corresponding fields in STORERNG. The POS and inventory programs will use these STORERNG values rather than try to calculate the appropriate values from ITEMSPECIALDATES. This is to improve the overall performance of the system.
|STRGUID||VARCHAR(38)||A unique code assigned by the system.|
|LINTITEMNUMBER||INT||The item to which this special date applies.|
location to which this special date applies.
|INTDATETYPE||INT||The type of
task to which this date applies.
|DTMDATE||DATETIME||The actual special date.|
Primary Key: STRGUID
|Converted from CHM to HTML with chm2web Pro 2.85 (unicode)|