Home > Technical > Table Definitions > PROMOHDR

PROMOHDR

The main header record for a promotion. Promotional details are stored in PROMOGRP and PROMODTL.

Column Type Description

LINTPROMOCODE

INTEGER

Unique number assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

Supplier from which the goods will be purchased.

SUPPLIER.strSupplierCode

STRPROMOTYPE

VARCHAR(10)

The type of promotion.

PROMOTYP.strTypeCode

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.

SUPPLIER.strSupplierCode

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.

LABEL.strLabelCode

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.

LABEL.strLabelCode

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)