S3 and M3 tables

 6 Replies
 0 Subscribed to this topic
 3 Subscribed to this forum
Sort:
Author
Messages
New User
Basic Member
Posts: 9
Basic Member
    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
    Posts: 3353
      Those are S3 and different than M3.
      Thanks for using the LawsonGuru.com forums!
      John
      Rob Conrad
      Veteran Member
      Posts: 73
      Veteran Member
        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
        Posts: 3353
          Moving to M3 Financials...
          Thanks for using the LawsonGuru.com forums!
          John
          New User
          Basic Member
          Posts: 9
          Basic Member
            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
            Veteran Member
              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
              Veteran Member
                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.