Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MAS90/200 Database Table Structure 1

Status
Not open for further replies.
andyLog

andyLog

Programmer
Nov 11, 2008
5
US
I developed a VB application that extracts Items and customer information using ODBC(DSN=SOTAMAS90) connection from MAS90. Can I use the same application to extract items and customers information from another version of MAS90(the version I used to test the application is 3.70) or MAS200. Are tabel and table column names remain the same in different versions of MAS90? Also are they different between MAS200 and MAS90. The reason I didn't used VI is because I couldn't find the fields I need linked together in one file.

Thanks
 
Sort by date Sort by votes
V3.70 came with a technical reference and support guide CB (TRSG). This contained the layout of all tables.

On a side note v3.70? Why don't you upgrade? MAS is currently at v4.30 meaning you are at least 5 releases behind.
 
Upvote 0 Downvote
BigLouie,

Thanks for the fast reply. The thing is we have an application which has to communicate with different financial backend applications, of our clients, like MAS90/200, QuickBooks, PeachTree and the likes. We developed the apllication, which I mentioned in my last post, to work with MAS90 version 3.70 because it is the earliest release we can find. Our application is supposed to work with all versions of MAS90 and MAS200. To be more clear, my question was whether the table and column names of different versions of MAS90/200 are the same as MAS90 vesrion 3.70 or not. Form the TRSG I know the table layout of all tables of version 3.70 .

Thanks again
 
Upvote 0 Downvote
For v3.XX the table names do not change and remain constant from version to version. Starting with v4.0 as the modules move to the Business Framework the tables and fields change. Currently GL, AR, AP, SO, BR are all on the Business Framework.

Note you would need to change your application if the client is using v4.0 or higher.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mg1230
  • Locked
  • Question
mas90 3.71 support needed
Replies
0
Views
704
mg1230
mg1230
loren1175
  • Locked
  • Question
MAS90
Replies
0
Views
507
loren1175
loren1175
EBey24
  • Locked
  • Question
I have an old version of Mas90 and
Replies
0
Views
610
EBey24
EBey24
fawncampos
  • Locked
  • Question
MAS90 support
Replies
1
Views
347
LouieGrandie
LouieGrandie
Stircrazy08
  • Locked
  • Question
MAS90 - EDI 846 file
Replies
1
Views
223
LouieGrandie
LouieGrandie

Part and Inventory Search

Sponsor

Back
Top