Home > Technical > Table Definitions > ITEMPACKAGING
The amount of packaging used on an item.
Column |
Type |
Description |
LINTITEMNUMBER |
INT |
The item that this packaging is used on. |
STRGUID |
VARCHAR(38) |
A unique code assigned by the system for the record. |
INTTYPE |
INT |
Indicates if this manufacturer or our packaging. 0=Manufacturer Packaging |
STRTRADECODE |
VARCHAR(10) |
The location to which this rule belongs. Its not intended that
you would have some codes at one location then some more at a
higher level and the system works out the correct location to use.
Its intended that the locations would be for different areas at the
same level. So all rules defined for AREA1. Then rules defined for
AREA2. A store would only ever use rules for one location. These
are locations that can be used in the cost hierarchy. |
DTMSTART |
DATETIME |
The date the rate becomes effective, if any. The system reads the rules backwards from newest to oldest, looking for the first one which is applicable. |
DTMEND |
DATETIME |
The date the rate expires. Record can still be used on this date. It can't be used afterwards. |
STRPACKAGECODE |
VARCHAR(10) |
|
DBLQUANTITY |
DECIMAL(19,4) |
The amount of packaging used on the item, usually kilos. |
Primary Key: LINTITEMNUMBER + STRGUID
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |