PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/16/2011 12:33 PM by  Rob Conrad
S3 and M3 tables
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
New User
BPA
ASL
Basic Member
(15 points)
Basic Member
Posts:9


Send Message:

--
09/30/2011 2:28 AM
    Hi Guru's

    I got a table list from following site

    https://www.lawsonguru.com/gurucont...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
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    09/30/2011 7:33 AM
    Those are S3 and different than M3.
    Thanks for using the LawsonGuru.com forums!
    John
    Rob Conrad
    Private
    Private
    Veteran Member
    (206 points)
    Veteran Member
    Posts:70


    Send Message:

    --
    09/30/2011 2: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
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    09/30/2011 5:11 PM
    Moving to M3 Financials...
    Thanks for using the LawsonGuru.com forums!
    John
    New User
    BPA
    ASL
    Basic Member
    (15 points)
    Basic Member
    Posts:9


    Send Message:

    --
    10/05/2011 1: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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    10/13/2011 3:28 PM
    You could always generate it yourself... See this link and my reply on 5/27/2011
    https://www.lawsonguru.com/forums/u...ts-fields/
    Rob Conrad
    Private
    Private
    Veteran Member
    (206 points)
    Veteran Member
    Posts:70


    Send Message:

    --
    10/16/2011 12: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.
    You are not authorized to post a reply.