Home > Technical > Table Definitions > 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. |
STRSTORECODE |
VARCHAR(10) |
The trading unit this sell is applicable to. |
STRSELLTYPE |
VARCHAR(10) |
The type of sell price. Normal/Promo. |
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) |