RMS 2.0 Data Dictionary

Apr 19, 2007 4 Replies
L

Hi,



Does anyone know of a data dictionary or document that lists the changes between RMS 1.31 and RMS 2.0? I have a third party software and I want to make sure that when I upgrade to 2.0 it still works and that RMS 2.0 will still work. They have asked for the changes but I haven't been able to find any documentation.



Any ideas?



Thanks, Laura


Vote
Twitter Facebook LinkedIn
C

Hi Laura, Here's a site you can go to that gives you information on v 2.0 in a "what's new" format....

formatting link
If your third party software works with store ops manager, you could setup a test environment on a separate machine where you would install 1.3, recreate your 1.3 database, upgrade to 2.0 and test the 3rd party software; if it works with store ops POS, you can do the same but you'll need to call MS to reinstall the 2.0 license in your production PC after your testing is done...you should also consider engaging a RMS-certified partner, they may have gone through the pains already and save yourself some potential headaches...

Good luck with your upgrade - h> Hi,

Vote
Twitter Facebook LinkedIn
A

There has not been any tables deleted. These are the changes and New Additions:

New Table Dimensions => New Fields (i) DimensionName (ii) Description (iii) DBTimeStamp.

New Table Matrix AttributeDisplayOrder => New Fields (i) ItemClassID (ii) Dimension (iii) Attribute (iv) Code (v) Inactive (vi) HQID

New Table DimensionAttribute => New Fields (i) Attribute (ii) Code (iii) DisplayOrder (iv) DimensionID, (v) DBTimeStamp

Modified Tables ItemClass => Fields (i) Notes (ii) DepartmentID (iii) CategoryID (iv) Price (v) Cost (vi) SupplierID (vii) BarcodeFormat (viii) SubDescription 1, 2, 3 (ix) TaxId

All the rest are the same as before. If you need the prebious info contact me and I will sen you the old info.

Vote
Twitter Facebook LinkedIn
J

We need a data dictionary also. We need to see relationships. We are writing a de-dupe tool that shows the user all duplicates (Customers) and there may be orders on each. We show the user the dupes and let them choose which record should have the orders. What tables other than [transaction] are involved.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required