Home > Technical > Table Definitions > PROMOITEM

PROMOITEM

This table is not a standard table in the system. It is used by PromotionsV2 which is not a standard system program.

Column Type Description

LINTPROMOCODE

INTEGER(4)

Unique number assigned by the system.

LINTBASELINENUMBER

INTEGER(4)

 

LINTITEMNUMBER

INTEGER(4)

 

STRTRADECODE

VARCHAR(10)

 

INTCARTONSIZE

DECIMAL5(9,3)

 

INTMINORDER

DECIMAL5(9,3)

 

CUREXPECTEDNORMALLANDEDCOST

DECIMAL9(19,4)

 

CUREXPECTEDREBATES

DECIMAL9(19,4)

 

CUREXPECTEDCOREBONUS

DECIMAL9(19,4)

 

CUREXPECTEDNORMALFINALCOST

DECIMAL9(19,4)

 

STRDEALTYPE

VARCHAR(5)

 

DBLDEALRATE

DECIMAL9(19,4)

 

CURPROMOLANDEDCOST

DECIMAL9(19,4)

 

CURPROMOCORE

DECIMAL9(19,4)

 

CURPROMOFINALCOST

DECIMAL9(19,4)

 

CURNORMALSELL

DECIMAL9(19,4)

 

CURNORMALGP

DECIMAL9(19,4)

 

DBLNORMALMARGIN

DECIMAL9(19,4)

 

CURPROMOSELL

DECIMAL9(19,4)

 

CURPROMOSELL2

DECIMAL9(19,4)

 

CURPROMOSELL3

DECIMAL9(19,4)

 

CURPROMOSELL4

DECIMAL9(19,4)

 

CURPROMOSELL5

DECIMAL9(19,4)

 

DBLEXPECTEDMARGIN

DECIMAL9(19,4)

 

DBLEXPECTEDMARGIN2

DECIMAL9(19,4)

 

DBLEXPECTEDMARGIN3

DECIMAL9(19,4)

 

DBLEXPECTEDMARGIN4

DECIMAL9(19,4)

 

DBLEXPECTEDMARGIN5

DECIMAL9(19,4)

 

CURPROMOGP

DECIMAL9(19,4)

 

CURPROMOGP2

DECIMAL9(19,4)

 

CURPROMOGP3

DECIMAL9(19,4)

 

CURPROMOGP4

DECIMAL9(19,4)

 

CURPROMOGP5

DECIMAL9(19,4)

 

STRSUPPLIERCODE

VARCHAR(10)

 

STRMANUFACTURER

VARCHAR(10)

 

STRORDERCODE

VARCHAR(20)

 

STRITEMSTATUS

VARCHAR(1)

 

STRLABELCODE

VARCHAR(10)

 

STRMEDIA

VARCHAR(30)

 

DTMBUYSTART

DATETIME(8)

 

DTMBUYEND

DATETIME(8)

 

INTPAGENUM

INT(4)

 

INTPAGESEQUENCE

INT(4)

 

STRSAVELABEL

VARCHAR(10)

 

STRSAVEVALUE

VARCHAR(20)

 

STRBONUSLABEL

VARCHAR(10)

 

LINTBONUSITEMNUMBER

INT(4)

 

STRBONUSORDERCODE

VARCHAR(20)

 

STRBONUSDESCRIPTION

VARCHAR(20)

 

STRPROMOCOMMENT

VARCHAR(255)

 

STRCHANGECOMMENT

VARCHAR(255)

 

STRDEPTCODE

VARCHAR(10)

 

STRCATCODE

VARCHAR(10)

 

STRGROUPCODE

VARCHAR(10)

 

STRSUBGROUPCODE

VARCHAR(10)

 

STRSELLTAXCODE

VARCHAR(10)

 

YSNITEMTICKET

VARCHAR(1)

 

STRIMAGE

VARCHAR(1)

 

YSNVIRTUALWAREHOUSE

VARCHAR(1)

 

YSNPROMOHISTORY

VARCHAR(1)

 

STRPROMOREBATECODE

VARCHAR(20)

 

DBLPROMOREBATERATE

DECIMAL9(19,4)

 

STRPROMOREBATETYPE

VARCHAR(10)

 

STRREBATESOURCE

VARCHAR(1)

 

STRPROMOTYPE

VARCHAR(10)

 

YSNFEATURE

VARCHAR(1)

 

INTEXPECTEDQTY

INT(4)

 

 

Primary Key: LINTPROMOCODE + LINTBASELINENUMBER + LINTITEMNUMBER + STRTRADECODE

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