chanley54
Member
Does anyone have a process (Script, SQL, etc.) that can pull the COA from JD Edwards?
DBohner-(db)
Legendary Poster
You might look at R0909P? It has a pre-process(R0909R) that has to be run to populate its F0909 table - but, it should give you want you want.
When you look at it - pay VERY GOOD ATTENTION to the Levels of Detail Sequencing. You really don't want to have any skips!
You will want to review the bOrgacle Document:
E1: 09: FAQ - Frequently Asked Questions Regarding Chart of Accounts [ID 664720.1]
If you need more reading:
JD Edwards EnterpriseOne Financial Management Reports Guide 9.0 [ID 1234465.1]
(db)
When you look at it - pay VERY GOOD ATTENTION to the Levels of Detail Sequencing. You really don't want to have any skips!
You will want to review the bOrgacle Document:
E1: 09: FAQ - Frequently Asked Questions Regarding Chart of Accounts [ID 664720.1]
If you need more reading:
JD Edwards EnterpriseOne Financial Management Reports Guide 9.0 [ID 1234465.1]
(db)
Deepesh
Active Member
In Xe days we used to have an application P80010 to view and check the fields, indexes etc of a table.
Following is a link to creating the same in later versions of E1.
JDESource Create P80010 App
Following is a link to creating the same in later versions of E1.
JDESource Create P80010 App
