• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

In Chartsum table how parent_obj_id relates to seq_number

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
cmmrfrds
New Member
Posts: 3
New Member
3/17/2010 4:54 PM
I am looking at the chartsum table and it looks to me like there is a recursive relationship between seq_number and parent_obj_id. Also, there is a depth field and sumry_acct_id.

Can anybody tell me if there is a recursive relationship between seq_number and parent_obj_id?

If so, should a seq_number have a parent_obj_id that has a lower depth number? In other words, a depth 2 seq_number should have a parent_obj_id with a depth 1.

Thank you.
Milo Tsukroff
Veteran Member
Posts: 47
Veteran Member
4/1/2010 3:31 PM
That is correct. On a project a while back I created a "flattened" form of the CHARTSUM information for each accounting unit. My notes say: "Index # comes from GLCHARTSUM.DEPTH. Setup is self-referential hierarchy within GLCHARTSUM, where higher-numbered accounts point to lower-numbered accounts."