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.

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."