Home > Technical > Table Definitions > 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 |
|
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) |