Home > Technical > Table Definitions > KITHDR

KITHDR

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.

Column Type Description
LINTCODE INT A unique code assigned by the system.
STRTRADECODE VARCHAR(10) The location where the stock will be adjusted.

TRADUNIT.strTradeCode

STRTYPE VARCHAR(1) Indicates whether the kit is being created (C) or broken (X).
STRWHO VARCHAR(20) The user who created the transaction.
DTMWHEN DATETIME The date the transaction was created.
INTCHANGEFLAG INT A number used to track changes to the record
INTNEWFLAG INT A number used to track when a new record is created.
MEMCOMMENT TEXT A full description of the kit transaction.
STRSTATUS VARCHAR(10) Status of the transaction: New / Printed/ Accepted
DTMSTATUS DATETIME The date the status last changed.
STRAUTHORISEDBY VARCHAR(20) The user who authorised the acceptance of the transaction.
 

Primary Key: LINTCODE

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