Home > Technical > Table Definitions > SELLCHANGEOVER

SELLCHANGEOVER

This is a snapshot of the SELL records for the conversion to GST in Australia.

Column Type Description

CTRCODE

INT(4)

 

LINTITEMNUMBER

INT(4)

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

STRSELLTYPE

VARCHAR(10)

The type of sell price. Normal/Promo.

link.gif (858 bytes) 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.

 

Primary Key: CTRCODE + STRSTORECODE

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