SELLCHANGEOVER

CTRCODE

INT(4)

LINTITEMNUMBER

INT(4)

The IPN of the item which this sell is for.

ITEM.lintItemNumber

STRSTORECODE

VARCHAR(10)

The trading unit this sell is applicable to.

TRADUNIT.strTradeCode

STRSELLTYPE

VARCHAR(10)

The type of sell price. Normal/Promo.

SELLTYPE.strSellType

CURSELL

DECIMAL9(19,4)

The unit sell price for the item.

CURSELL2

DECIMAL9(19,4)

The second level unit sell price.

CURSELL3

DECIMAL9(19,4)

The third level unit sell price.

CURSELL4

DECIMAL9(19,4)

The fourth level unit sell price.

CURSELL5

DECIMAL9(19,4)

The fifth level unit sell price.

CURGP

DECIMAL9(19,4)

The expected GP based on the expected cost, the expected sell tax, sell price 1.

CURGP2

DECIMAL9(19,4)

The expected GP based on the expected cost, the expected sell tax, sell price 2.

CURGP3

DECIMAL9(19,4)

The expected GP based on the expected cost, the expected sell tax, sell price 3.

CURGP4

DECIMAL9(19,4)

The expected GP based on the expected cost, the expected sell tax, sell price 4.

CURGP5

DECIMAL9(19,4)

The expected GP based on the expected cost, the expected sell tax, sell price 5.

YSNUSE

VARCHAR(1)

If 'T' will be used for margin checking. If 'F' will not be used.