Home > Technical > Table Definitions > SELL

SELL

Stores the sell prices for an ITEM.

Column Type Description
CTRCODE INT Unique number assigned by the system.
LINTITEMNUMBER INT The IPN of the item which this sell is for.
link.gif (858 bytes) ITEM.lintItemNumber
STRSTORECODE VARCHAR(10) The trading unit this sell is applicable to.
link.gif (858 bytes) TRADUNIT.strTradeCode
DTMEFFECTIVE DATETIME The date which the sell price will start.
STRSELLTYPE VARCHAR(10) The type of sell price. Can be Normal/Promo or a value stored in SELLTYPE table.
link.gif (858 bytes) SELLTYPE.strSellType
CURSELL DECIMAL(19,4) The unit sell price for the item
INTDISCOUNTQTY SMALLINT Not currently used.
PERDISCOUNT DECIMAL(19,4) Not currently used.
CURDISCOUNT DECIMAL(19,4) Not currently used.
YSNAVAILABLE VARCHAR(1) ‘T’ if the sell is currently in effect, ‘F’ otherwise. The system will set this flag as required according to the effective and expiry dates.
DTMEXPIRY DATETIME The date the sell will expire. Only filled in if a deal cost
DBLMARGIN DECIMAL(19,4) The margin based on the sell price and the cost available at the time of data-entry. If this is a normal sell, the system will use the best normal cost. If this is a promo sell, the system will use the best cost.
LINTPROMOCODE INT If the system generated this sell because of a promotion, the promotion number will be stored in this field.
STRPROMOSTATUS VARCHAR(1) Not currently used.
STRPROMOTYPE VARCHAR(10) Not currently used.
STRWHO VARCHAR(20) The person who entered the record. Maintained by the system.
DTMWHEN DATETIME The time the record was entered. Maintained by the system.
CURSELL2 DECIMAL(19,4) The second level unit sell price.
DBLMARGIN2 DECIMAL(19,4) The second level margin (see dblMargin above).
CURSELL3 DECIMAL(19,4) The third level unit sell price.
DBLMARGIN3 DECIMAL(19,4) The third level margin (see dblMargin above).
CURSELL4 DECIMAL(19,4) The fourth level unit sell price.
DBLMARGIN4 DECIMAL(19,4) The fourth level margin (see dblMargin above).
CURSELL5 DECIMAL(19,4) The fifth level unit sell price.
DBLMARGIN5 DECIMAL(19,4) The fifth level margin (see dblMargin above).
CUREXPECTEDLANDEDCOST DECIMAL(19,4) The expected landed carton cost for this item. This is set 1) whenever the location, sell type or date is changed, or 2) the ‘Get New Costs/Sells’ process is performed
INTEXPECTEDCARTONSIZE DECIMAL(9,3) The expected carton size for this item. This is set 1) whenever the location, sell type or date is changed, or 2) the ‘Get New Costs/Sells’ process is performed.
STREXPECTEDCOSTTAX VARCHAR(10) Not currently used.
STREXPECTEDSELLTAX VARCHAR(10) The tax code which represents the tax included in the sell price, for example GST.
link.gif (858 bytes) TAX.strTaxCode
CURGP DECIMAL(19,4) The expected GP based on the expected cost, the expected sell tax, sell price 1.
CURGP2 DECIMAL(19,4) The expected GP based on the expected cost, the expected sell tax, sell price 2.
CURGP3 DECIMAL(19,4) The expected GP based on the expected cost, the expected sell tax, sell price 3.
CURGP4 DECIMAL(19,4) The expected GP based on the expected cost, the expected sell tax, sell price 4.
CURGP5 DECIMAL(19,4) The expected GP based on the expected cost, the expected sell tax, sell price 5.
STRCURRENCYCODE VARCHAR(5) The currency code of the sell price.
link.gif (858 bytes) CURRENCYCODE.strCurrencyCode
STRCURRENCYCODE2 VARCHAR(5) Not currently used.
STRCURRENCYCODE3 VARCHAR(5) Not currently used.
STRCURRENCYCODE4 VARCHAR(5) Not currently used.

STRCURRENCYCODE5

VARCHAR(5)

Not currently used.

CURRSELL1X

DECIMAL(19,4)

 

CURRSELL2X

DECIMAL(19,4)

 

CURRSELL3X

DECIMAL(19,4)

 

CURRSELL4X

DECIMAL(19,4)

 

CURRSELL5X

DECIMAL(19,4)

 


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