EnterpriseOne SQL Samples
23 March 2006Here are some JDE EnterpriseOne (OneWorld) SQL examples for extrating various data.
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
No comments yet
Leave a Reply
You must be logged in to post a comment.