Prev
Next
Forums Financial Management Lawson M3 Financials

S3 and M3 tables

 6 Replies
 0 Subscribed to this topic
 3 Subscribed to this forum
Sort:
Author
Messages
New User
Basic Member Send Private Message
Posts: 9
Basic Member
9/30/2011 6:28 AM
Hi Guru's I got a table list from following site https://www.lawsonguru.co...81/tables/index.html but iam little confused that these tables are related to S3 or M3? Is there any difference between S3 Financial and M3 Financial tables?? Waiting for replay
John Henley
Send Private Message
Posts: 3351
9/30/2011 11:33 AM
Those are S3 and different than M3.
Thanks for using the LawsonGuru.com forums!
John
Rob Conrad
Veteran Member Send Private Message
Posts: 73
Veteran Member
9/30/2011 6:17 PM
Hi Amogh - Yes. You will need the M3 Metadata Publisher (MDP) to obtain the M3 table and structure information. It is a very nice tool providing you with the ability to look at the table structures and you can also use it to search from a program view and find out what tables are affected/updated by a given M3 program. The M3 API library is also a pretty good source too - when needing to programmatically update/query M3BE. RC
John Henley
Send Private Message
Posts: 3351
9/30/2011 9:11 PM
Moving to M3 Financials...
Thanks for using the LawsonGuru.com forums!
John
New User
Basic Member Send Private Message
Posts: 9
Basic Member
10/5/2011 5:44 AM
Hi John and Rob Thnx for your reply this is very helpful. Can u pls tell me where i will get M3 Financials Tables list on internet? Thnx again!
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
10/13/2011 7:28 PM
You could always generate it yourself... See this link and my reply on 5/27/2011 https://www.lawsonguru.co...-po-comments-fields/
Rob Conrad
Veteran Member Send Private Message
Posts: 73
Veteran Member
10/16/2011 4:33 PM
Hey Guys - You could look at the schema using a database tool - but a lot of the Movex tables are somewhat cryptic and likely to be difficult to associate a table field/index with an actual M3 Program. MDP - Metadata publisher used to be on the Intentia support site and you must now access it through Lawson Support. Again, MDP is more descriptive - it's basically like an interactive web version of the S3 datafile text information, only you can find stuff a lot faster than in the S3 datafile text! RC.