Prev
Next
Forums Lawson S3 Financials

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

Sort:
You are not authorized to post a reply.
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: 469
    Veteran Member
    3/7/2013 9:34 PM
      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!!
        You are not authorized to post a reply.