Enterprise Software Development

EnterpriseOne SQL Samples

Here are some JDE EnterpriseOne (OneWorld) SQL examples for extrating various data.

You will need some tools

General Ledger

select * from F0911usually you will want to select only posted records, do this by adding a

where glpost='P'

to the end of the statement

Purchasing Headers / Subcontract Headers

select * from f4301

Purchasing Detail / Subcontract Detail

select * from f4311

usually you will want to select only purchase order or subcontracts that are in a ‘printed’ state.. youll need to see what status code your system is setup for printed status po’s here is an example of ours

select * from f4311 where pdnxtr >= '440'

Accounts Payable

select * from f0411

Address Book

select * from f0101