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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Database Schema
Microsoft Dynamics RMS (Archived)

Database Schema

(0) ShareShare
ReportReport
Posted on by Simon Merritt

Does anybody have a database schema for RMS v2?

Thanks.

Simon

*This post is locked for comments

  • Verified answer
    TimB Profile Picture
    TimB on at
    Re: Database Schema

    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
    Simon Merritt on at
    Re: Database Schema

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

  • Verified answer
    TimB Profile Picture
    TimB on at
    Re: Database Schema

    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
    davem on at
    Re: Database Schema

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

    SELECT * FROM INFORMATION_SCHEMA.COLUMNS order by table_name

  • Shawn Meade Profile Picture
    Shawn Meade on at
    Re: Database Schema

    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
    Community Member on at
    RE: Database Schema

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September 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