This discussion is archived
0 Replies Latest reply: Aug 2, 2012 2:41 AM by 945471 RSS

JDE table information

945471 Newbie
Currently Being Moderated
Hi,

I've started a new project where I'll be using JD Edwards as the source system to extract the following data -

* Operating Costs - operating costs against every cost centre and expense element combination
* Workforce Data - Salary, oncosts information for all employees
* Capital expenditure - Capital project/ fixed assets hierarchy and related capital expenditure data
* Revenue information -
* General Ledger accounts - for balance sheet and P&L

Not sure if my terminology is correct above as I've not used JD Edwards before.

Now It will be great if someone can answer my following basic questions -
* Can you please tell me the table numbers from where I can extract the above mentioned information in JD Edwards.
* How is operating costs stored in JD Edwards - Is it by cost centre and expense element combination.
* What is the term used for expense element or expense type? How do you identify different expense types ?
* How can I see what a GL account is made of ?

Thanks in Advance!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points