Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

MAS90 and MAS200 Data Dictionary Online

May 1, 2008 by Wayne Schulz

mas90 mas200 data dictionary online.jpg

Have you ever wondered what the file structure was for a certain MAS90 or MAS200 table? You can alway view this from within the Resources tab of your Sage MAS90 or MAS200 system. However there is another way to see this information when you aren’t in front of your accounting system.

Sage Software publishes two data dictionaries which are free and available online with no login.

Access the dictionaries at:

Link: Sage MAS 90 and MAS 200 Version 4.30 Data Dictionary

Link: Sage MAS90 and MAS200 Version 4.20 Data Dictionary

Link: Sage MAS 90 and MAS200 Version 4.10 Data Dictionary
Tip: Data dictionaries for versions 4.4+ are only within the MAS90 program itself

Sage MAS 90 and 200 4.40 or later:

  • From the View menu, click View Tasks.
  • From the Tasks panel, click Resources.
  • In the Resources window, click File Layouts and Program Information.
  • From the Contents tab, double-click any of the help topics, which are listed below.
  • File Layouts
  • Program Listings
  • File and Table Listings
  • Data Class Definitions Listing
  • File Names and Key Information
  • Cross Reference Information. This topic also includes Old File Names to New File Names Mapping and Old Field Names to New Field Names Mapping.

Share this:

  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook
  • Email a link to a friend (Opens in new window) Email
  • Share on LinkedIn (Opens in new window) LinkedIn

Filed Under: Hidden Options, Sage 100 ERP, Tips and Tricks

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage-certified consultant based in Connecticut. He has worked with Sage 100 since 1986 and provides remote consulting to companies throughout the United States. He is a founding member of the 90 Minds Consulting Group. To discuss working with Schulz Consulting, start with the Sage 100 inquiry page. Information is reviewed before follow-up about fit and next steps; technical work is scoped and priced separately.

Comments

  1. Ron says

    January 22, 2010 at 5:40 pm

    Hello,
    Is there one for MAS90 4.05?
    Thxs.

  2. Wayne Schulz says

    January 24, 2010 at 2:03 pm

    There is a 4.05 (and below) data dictionary. Unfortunately it requires logging into the Sage Online Support Center so I'm not able to directly link it here.

    If you have a login you can access it via
    http://support.sagesoftwareonline.com/mas/file_…

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

Copyright © 2026 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter

Schulz Says Email Newsletter

Sent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.