Home > Technical > Table Definitions > 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.
|LINTCODE||INT||The kit transaction to which this item belongs.|
|CTRCODE||INT||Unique number assigned by the system.|
|LINTITEMNUMBER||INT||The number of the item.|
|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)|