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
 
Supplier Master Report Query
Report layout information that was provided 
Supplier Master Report - supplier code, supplier name, phone no., fax no., e-mail address, contact name (s), address, payment terms, freight terms etc.
 
Suggested report query to apply
The main supplier database is in the SUPINFO table. These records link to the SHIPBILL table via the R_link and C_link fields, where details of  the multiple ship-to and bill-to addresses are kept. The contacts are maintained in the CCONTACT table, linked to the customer by the custno field.
Article ID: 3169