Home > Technical > Table Definitions > ITEMPACKAGING

ITEMPACKAGING

The amount of packaging used on an item.

Column

Type

Description

LINTITEMNUMBER

INT

The item that this packaging is used on.
ITEM.lintItemNumber

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
1=Our 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.
TRADUNIT.strTradeCode

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)

PACKAGINGHDR.strCode

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)