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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / RMS SQL Table Definitions
Microsoft Dynamics RMS (Archived)

RMS SQL Table Definitions

(0) ShareShare
ReportReport
Posted on by sksisme 125

Greetings All,

I have been tasked with pulling some data from the back end tables for our various RMS databases.  I've been searching for some "official" Microsoft Dynamics RMS SQL Table Definitions documentation and I can't find any.  Have any of you run across documentation of this nature in your travels?

Thank you in advance for your help,

sks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Searching for the same thing.  Your best bet is to try to create database diagrams, what version of SQL Server are you running?

    Here are some helpful link:

    snowflakejoins.com/.../index

    http://www.dbvis.com/

  • sksisme Profile Picture
    sksisme 125 on at

    Hi Chazh345 and thank you for your respons. We are running SQL 2008 R2.  I have begun creating relationships based on Primary and foreign keys.  But understanding what all of the columns really mean in relationship with the application is a more involved task.  Hopefully there is some kind of documentation out there.  Good luck on your search as well.

    sks  

  • jdorris Profile Picture
    jdorris 140 on at

    I've been looking for this as well.  Did you ever find anything?  Thanks.

  • Community Member Profile Picture
    Community Member on at

     There are actually no real table relationships in the RMS database.  However since the naming conventions are easy, you usually can just join ID to ItemID, or ID to PurchaseOrderID, ID to OrderID, ID to RecallID, ETC.

    The only other help you will get is by using SP_HELP on the table.  For example EXEC SP_HELP @objname = 'dbo.item';

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Use you could use the schema and the customization guide.  

    The schema will give you each table and data type

    customization guide will give you appropriate values, but the guide is very outdated

    support.microsoft.com/.../938434

    mbs.microsoft.com/.../rmscustomizationguide

    Download link is located at the top right side.

  • wahoo Profile Picture
    wahoo 275 on at

    Ed,

    Can anyone view the customization guide in your second link?  I have access to customer source...as a customer, but it says I do not have access.

    Thanks,

    jane  

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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