Home > Technical > Table Definitions > PROMOHDR
The main header record for a promotion. Promotional details are stored in PROMOGRP and PROMODTL.
Column | Type | Description |
INTEGER |
Unique number assigned by the system. |
|
STRSUPPLIERCODE |
VARCHAR(10) |
Supplier from which the goods will be purchased. |
STRPROMOTYPE |
VARCHAR(10) |
The type of promotion. |
DTMSTART |
DATE |
The date the sell price will start. |
DTMEND |
DATE |
The date the sell price will finish. |
INTLEADDAYS |
SMALLINT |
The number of days before the sell starts when the deal price starts. |
INTENDDAYS |
SMALLINT |
The number of days after the sell ends when the deal price ends. |
CURCOOPAMT |
DECIMAL(19,4) |
The lumpsum co-op offered by the manufacturer. |
MEMCOMMENTS |
TEXT |
General comments for stores. |
STRMANUFACTURER |
VARCHAR(10) |
Original manufacturer of the goods. |
STRCLAIMTYPE |
VARCHAR(10) |
The method by which claims will be raised. Sales/Purchases. |
MEMHEADCOMMENTS |
BLOB |
General comments for head office. |
DTMBUYSTART |
DATE |
The date the deal starts. System calculates this as dtmStart - intLeadDays. |
DTMBUYEND |
DATE |
The date the deal ends. System calculates this as dtmEnd + intEndDays. |
STRCOOPTYPE |
VARCHAR(10) |
The type of labels required for this promotion. |
STRLABELCODE |
VARCHAR(10) |
|
DTMLASTCLAIMED |
DATE |
The last date which we have raised claims for. Initially empty to indicate no claim has been raised. |
YSNAMENDED |
VARCHAR(1) |
‘T’ if promotion has been amended. Set by the user. |
STRMEDIA |
VARCHAR(20) |
Free-format field to indicate the type of media advertising which will be used. |
STRFEATURELABELCODE |
VARCHAR(10) |
The label required for feature items. |
CUREXTRACOOPAMT |
DECIMAL(19,4) |
Any extra coop amount offered by the manufacturer. |
STRPROMONAME |
VARCHAR(50) |
* |
DTMCATALOGUEDATE |
DATE |
* |
DTMRELEASETOSTORES |
DATE |
* |
DTMSELLSCREATED |
DATE |
|
STRTRADECODE |
VARCHAR(10) |
|
DTMCOSTSCREATED |
DATE |
* |
* These fields are extensions to the standard table used by PromotionsV2 which is not a standard system program.
Primary Key: LINTPROMOCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |