ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
Advanced Search
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
  
ICM Query-The Hierarchies of Inventory Tables in ManEx
Inventory tables in ManEx:
1.  Inventor - Table contains Part number, type, class, revision, etc information.  Unique identifier for each record is the value of the UNIQ_KEY

2.  Invtmfhd - Table contains MPN information.  Unique identifier of each record in the table is UNIQMFGRHD. Link to the Inventor table by UNIQ_KEY.

3.  InvtMfgr - Table contains WH/Location and quantities information for each MPN.  Unique identifier of each record W_KEY.  Link to the InvtMfhd using UNIQMFGHD.




Article ID: 3205
   ManEx, Inc.
Content intended for information only. Do not redistribute without written consent.		 Knowledge Base Software
Powered By: NovoSolutions, Inc.