Parent Child Relationships for Accounts

Todd C.

Member
Can anbody tell me how I can get the parent child relationships from the tables in JD Edwards. I have looked at the F0901 accounts master table, but I don't see any fields that say what the parent is for an account or SUB. Is there another table I need to join with to get this info.
 
My understanding is this .....

A parent-child relationship for an account is determined by the account number sequence (OBJ & SUB) in a business unit, its position in the sequence and the account level of detail (LDA).

A parent is the closest account to the child which is also higher in the (ascending) sequence and whose account level of detail is equal to 1 less than its child.

Level of detail can be 1 to 9.
 
There is no parent/child relationship defined in JDE General Ledger.
There is an inferred hierarchical relationship based on your account
numbering sequence (BU.OBJ.SUB) and the use of Level of Detail (LOD)
assigned to each account in the account master file.



Explicit parent/child relationships can be defined in Accounts
Receivable and Fixed Assets



Regards,



Colin
 
Back
Top