ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
KITTING Query - How to create a query to view items that have been Kitted

If the objective is to view items that have been KITTED, then this information resides in the kalocate table. This table is linked to the kamain table by the kaseqnum field. The kamain table contains work order, dept_id actual quantity and date, and uniq_key. The uniq_key is linked to the inventor table to find the part number and revision.
Also in the kalocate table is the W-key, which links to invtmfgr table and warehouse/location information. Also is the uniqmfgrhd, which links to the invtmfhd table where the AVL information is contained.

Article ID: 3167