Forums
Lawson M3 Financials
S3 and M3 tables
Author
Messages
New User
Basic Member
Posts: 9
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
Senior Member
Posts: 3348
9/30/2011 11:33 AM
Those are S3 and different than M3.
Rob Conrad
Veteran Member
Posts: 73
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
Senior Member
Posts: 3348
9/30/2011 9:11 PM
Moving to M3 Financials...
New User
Basic Member
Posts: 9
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
Posts: 1498
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
Posts: 73
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.