E8.0 How to Query Planned Work Orders

[scarpajn]

Hi all,

I need to Query the Planned Work Orders in JD Edwards.
Could somebody please give me some guidance on how to write the SQL script?
For instance, which Table should I reference? Any fields which must be filtered?

Many thanks in advance!
Regards,

Juan

 

[markdcci]

Scarpajn,
The primary table for Work Orders is F4801. It's impossible for me to predict which fields are important to you but if you are looking for a basic query to get you started:

select
wadoco as wo_number,
wadcto as wo_type,
wadl01 as wo_description,
wasrst as wo_status,
wadpl as requested_date,
wastrt as planned_start_date,
wadrqj as planned_finish_date,
wastrx as actual_finish_date
from <your_data_source>.f4801;

From here you should be able to take a look at P4801 and find any columns you need to add.

The dates I included above are in Julian format and are obviously not converted. Your conversion to Gregorian format can depend on your database and/or your reporting tool which you likely already have figured out.