Home > Technical > Table Definitions > KITDTL

KITDTL

A kit item is an item that is made up of other items (like a recipe) but the stock is kept on the main item, not the ingredients, for example a pack might contain three shirts and two pants. A kit can be created (remove stock from ingredients and make up stock on the kit item) or broken up (remove stock from kit and put back into ingredients). You create kit transactions to create or break kit items. The KITHDR contains details about the kit transaction and KITDTL contains the items in the transaction. 

KITDTL will contain the details of the actual items being created/broken. It will also contain the ingredient items of those kit items. So you can see that kit item 1 is made up out of Shirt A plus Pants B. Both sets oif items are in the same table. You can tell the kit items because lintMainItemNumber will be the same as the lintItemNumber.

Column Type Description
LINTCODE INT The kit transaction to which this item belongs.

KITHDR.lintCode

CTRCODE INT Unique number assigned by the system.
LINTITEMNUMBER INT The number of the item.

ITEM.lintItemNumber

STRORDERCODE VARCHAR(20) The order code of the item.
STRDESCRIPTION VARCHAR(120) Description of the item.
LINTMAINITEMNUMBER INT The main item number to which this item relates. If this was a kit item, it would be the same as LINTITEMNUMBER. If it was an ingredient of a kit, this would be the number of the kit item to which the ingredient item belongs.
DBLQUANTITY DECIMAL(19,6) The quantity of the item (how much stock to adjust). If this was an igredient item it would be the quantity of the kit item x dblContribQty.
DBLCONTRIBQTY DECIMAL(19,6) The quantity of the ingredient required for one kit item. So if you have three shirts in a kit, this will be three.
DBLSTOCKONHAND DECIMAL(19,6) Current stock on hand of this item.
 

Primary Key: LINTCODE + CTRCODE

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