Home > Technical > Table Definitions > MARGINITEM

MARGINITEM

These are used to record default margins for an item. Default margins can also be set at the department/category/group level in the MARGINDEPT table.

Column Type Description
STRSTORECODE VARCHAR(10) The location this default margin is to be used for. This can be a specific store or a group.
TRADUNIT.strTradeCode
LINTITEMNUMBER INT The item this default margin is to be used for.
ITEM.lintItemNumber
DBLMARGIN1 DECIMAL(19,4) The default margin to be used for Sell Price 1.
DBLMARGIN2 DECIMAL(19,4) The default margin to be used for Sell Price 2.
DBLMARGIN3 DECIMAL(19,4) The default margin to be used for Sell Price 1.
DBLMARGIN4 DECIMAL(19,4) The default margin to be used for Sell Price 1.
DBLMARGIN5 DECIMAL(19,4) The default margin to be used for Sell Price 1.
STRMARGINCALC1 VARCHAR(1) '0' indicates that dblMargin1 should be used to calculate the sell as a margin on cost.
STRMARGINCALC2 VARCHAR(1) '0' indicates that dblMargin2 should be used to calculate the sell as a margin on cost.
'1' indicates that sell should be calculated by adjusting sell 1 by dblMargin2.
STRMARGINCALC3 VARCHAR(1) '0' indicates that dblMargin3 should be used to calculate the sell as a margin on cost.
'1' indicates that sell should be calculated by adjusting sell 1 by dblMargin3.
'2' indicates that sell should be calculated by adjusting sell 2 by dblMargin3.
STRMARGINCALC4 VARCHAR(1) '0' indicates that dblMargin4 should be used to calculate the sell as a margin on cost.
'1' indicates that sell should be calculated by adjusting sell 1 by dblMargin4.
'2' indicates that sell should be calculated by adjusting sell 2 by dblMargin4.
'3' indicates that sell should be calculated by adjusting sell 3 by dblMargin4.
STRMARGINCALC5 VARCHAR(1) '0' indicates that dblMargin5 should be used to calculate the sell as a margin on cost.
'1' indicates that sell should be calculated by adjusting sell 1 by dblMargin5.
'2' indicates that sell should be calculated by adjusting sell 2 by dblMargin5.
'3' indicates that sell should be calculated by adjusting sell 3 by dblMargin5.
'4' indicates that sell should be calculated by adjusting sell 4 by dblMargin5.
 

Primary Key: STRSTORECODE + LINTITEMNUMBER

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