web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Database Schema

(0) ShareShare
ReportReport
Posted on by 2,270

Does anybody have a database schema for RMS v2?

Thanks.

Simon

*This post is locked for comments

I have the same question (0)
  • Verified answer
    TimB Profile Picture
    1,175 on at

    Jean Holland Group do have a download that contains the db schema. There are also some other docs in the zip. You'll probably have to create an account to be able to download.

    www.jeanholland.com/index.php

  • Simon Merritt Profile Picture
    2,270 on at

    Where is it on the site? I must have missed it.

  • Verified answer
    TimB Profile Picture
    1,175 on at

    It's in the RMS technical documents zip file. The file name in the zip is "SO Table and Column Schema.csv"

  • davem Profile Picture
    100 on at

    uh... just fire up SO Administrator and do:  

    SELECT * FROM INFORMATION_SCHEMA.COLUMNS order by table_name

  • Shawn Meade Profile Picture
    on at

    You can also access the database Schema for both Headquarters and Store levels for RTM as well as Feature Pack 1 on Customer Source.  The address is below.

     

    How to obtain the database schemas for Microsoft Dynamics Retail Management System

    https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmylsvqusptntnsmqpywvszrwsuxyqtqsks

  • Community Member Profile Picture
    on at

    You an help yourself with this link

    www.google.com/url;rct=j&q=&esrc=s&source=web&cd=1&ved=0ahUKEwibpca8k6TTAhWCLyYKHYQNBgoQFggmMAA&url=https%3A%2F%2Fstatic.austinhartzheim.me%2Ffiles%2Fdocs%2Fmicrosoft-rms%2Fmicrosoft-rms-database-structure.pdf&usg=AFQjCNFwQB_-0vbEfnxrqWx5JJEsbmkTCg&cad=rja

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans