Prev
Next
Forums Financial Management Lawson S3 Financials

How do I create a new ATN-OBJ-ID?

 2 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Donna
Basic Member
Posts: 6
Basic Member
3/7/2013 6:27 PM
    I need to populate forms GL76 and AC46 directly from SQL. We are pulling from a different system and do not want to use Add-Ins. I know that I will need to have an ATN-OBJ-ID and a new GLT-OBJ-ID for the rows that will be inserted into ACCOMMITX and GLCOMMITX. Which table would have the last number used for these fields? Are these calculated bases on data in a particular table?
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    3/7/2013 9:34 PM
    • Accepted Answer
    The table is OBJID. The obj_types are probably GLTRN and ACTRN

    OBJ-TYPE,DESCRIPTION,LAST-OBJ-ID,LIST-TOKEN,VIEW-TOKEN,MAN-LIST-TOKEN,CATEGORIES
    "ACGRP","Activity Group",460,"AC143",,"AC144","Y","Y","N"
    "ACTRN","Activity Transaction",38831227,,,,"Y","N","N"
    "ACTVY","Activity",5908,"AC133","AC136","AC134","Y","Y","Y"

    "GL40",,97038,,,,,,
    "GLTRN","General Ledger Transaction",52551228,,,,"Y","N","N"
    "HRHST",,4254274,,,,,,

    Donna
    Basic Member
    Posts: 6
    Basic Member
    3/7/2013 10:13 PM
      That was certainly right with the GL76! THANK YOU SO MUCH!!