Home > Technical > Table Definitions > PROMODTL

PROMODTL

This table contains the details of the actual items on promotion.

Column Type Description

LINTPROMOCODE

INT(4)

The promotion which this item belongs to.

PROMOGRP.lintPromoCode

LINTPROMOGROUP

INT(4)

The promotion group this item belongs to.

PROMOGRP.lintPromoCode

LINTITEMNUMBER

INT(4)

The IPN of the item on promotion.

ITEM.lintItemNumber

INTEXPECTEDQTY

SMALLINT(2)

The expected number of units to be purchased, if known.

CUREXPECTEDNORMALCOST

DECIMAL9(19,4)

The expected normal cost at the time of data entry.

CURCOOPAMT

DECIMAL9(19,4)

The coop carton deal (ex tax).

CUROFFINVOICE

DECIMAL9(19,4)

The off-invoice carton deal (ex tax). This has been superceded by strDealType and dblDealRate.

CURDEFERRED

DECIMAL9(19,4)

The deferred carton deal (ex tax).

CUREXPECTEDCOST

DECIMAL9(19,4)

The nett expected carton cost. (Expected normal cost less deals).

CURPROMOSUGGESTEDSELL

DECIMAL9(19,4)

Supplier’s suggested sell price, if any.

CURPROMOSELL

DECIMAL9(19,4)

The promotion sell price.

YSNEXPLODED

VARCHAR(1)

If this item is a member of a family group, this flag indicates whether the family group has been ‘exploded’ to all of its members.

INTEXPECTEDCARTONSIZE

SMALLINT(2)

The expected carton size at the time of data entry.

DBLEXPECTEDMARGIN

DECIMAL9(19,4)

The expected margin based on the expected cost and promotion sell.

YSNFEATURE

VARCHAR(1)

‘T’ if this is a feature item within the promotion.

CURMIPAMT

DECIMAL9(19,4)

The MIP carton deal (ex tax).

CUREXPECTEDLANDEDCOST

DECIMAL9(19,4)

The expected landed carton cost.

CUREXPECTEDEXTAXCOST

DECIMAL9(19,4)

 

CUREXPECTEDNORMALSELL

DECIMAL9(19,4)

The expected normal sell price.

DBLEXPECTEDNORMALMARGIN

DECIMAL9(19,4)

The expected normal margin.

STRDEALTYPE

VARCHAR(5)

This is used in conjunction with dblDealRate to work out the deal value. It allows deals to be expressed in terms of dollar or percentage, ex tax or inc tax. Its values are '% Ex', '$ Ex', '% Inc' or  '$ Inc'. A 15% ex- tax deal would have this value set to '% Ex'. This supercedes the use of curOffInvoice.

DBLDEALRATE

DECIMAL9(19,4)

This is used in conjunction with strDealType to work out the deal value. It is simply a number which when used with strDealType enables the system to calculate the value. A 15% ex- tax deal would have this value set to 15.

STRCOMMENT

VARCHAR(255)

A general comment about the promotion deal.

CURPROMOSELL2

DECIMAL9(19,4)

The second level promotional sell price.

CURPROMOSELL3

DECIMAL9(19,4)

The third level promotional sell price.

CURPROMOSELL4

DECIMAL9(19,4)

The fourth level promotional sell price.

CURPROMOSELL5

DECIMAL9(19,4)

The fifth level promotional sell price.

DBLEXPECTEDMARGIN2

DECIMAL9(19,4)

The expected margin based on the expected cost and promotion sell 2.

DBLEXPECTEDMARGIN3

DECIMAL9(19,4)

The expected margin based on the expected cost and promotion sell 3.

DBLEXPECTEDMARGIN4

DECIMAL9(19,4)

The expected margin based on the expected cost and promotion sell 4.

DBLEXPECTEDMARGIN5

DECIMAL9(19,4)

The expected margin based on the expected cost and promotion sell 5.

 

Primary Key: LINTPROMOCODE + LINTPROMOGROUP + LINTITEMNUMBER

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)