# JD Edwards Work Order Status Codes Template > Source: https://netray.co/tools/jde-work-order-status-codes-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable worksheet to document your JD Edwards work order status codes, what each one means, who owns it and where an order can move next. ## Category oracle ## Erp Oracle JD Edwards EnterpriseOne ## Industry Manufacturing ## Audience - JDE functional consultant - Plant maintenance planner - Production supervisor ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Status code **Key:** code **Type:** text #### Description **Key:** desc **Type:** text #### Lifecycle phase **Key:** phase **Type:** select **Options:** - Planning - Released - In process - Complete - Closed - On hold - Cancelled #### Owner role **Key:** owner **Type:** text #### Allowed next codes **Key:** next **Type:** text #### Costs may post **Key:** cost **Type:** select **Options:** - Yes - No #### Visible to planning **Key:** mrp **Type:** select **Options:** - Yes - No #### Business rule or note **Key:** note **Type:** text **Rows:** #### Planning **Code:** 10 **Desc:** Defined (example) **Owner:** Planner **Next:** 20, 99 **Cost:** No **Mrp:** Yes **Note:** Order created, no parts list or routing yet #### Planning **Code:** 20 **Desc:** Planned (example) **Owner:** Planner **Next:** 30, 99 **Cost:** No **Mrp:** Yes **Note:** Parts list and routing attached #### Released **Code:** 30 **Desc:** Released (example) **Owner:** Production control **Next:** 45, 50, 99 **Cost:** Yes **Mrp:** Yes **Note:** Material issues and time entry allowed #### On hold **Code:** 45 **Desc:** On hold (example) **Owner:** Supervisor **Next:** 30, 99 **Cost:** No **Mrp:** Yes **Note:** Quality or material hold, reason required #### In process **Code:** 50 **Desc:** In process (example) **Owner:** Shop floor **Next:** 90 **Cost:** Yes **Mrp:** Yes **Note:** First operation reported #### Complete **Code:** 90 **Desc:** Complete (example) **Owner:** Production control **Next:** 99 **Cost:** Yes **Mrp:** No **Note:** Final receipt posted, variances pending #### Closed **Code:** 99 **Desc:** Closed (example) **Owner:** Cost accountant **Cost:** No **Mrp:** No **Note:** Variance posted, no further activity **Totals:** #### Status codes defined **Key:** code **Agg:** count **Notes:** The values above are examples only. Work order status codes are user defined codes (UDC system 00, type SS) and every site configures its own. Replace the rows with the codes in your own UDC table and your Shop Floor Management setup. ## Content **Intro:** In JD Edwards EnterpriseOne the work order status field lives on the work order master (F4801) and is driven by user defined codes, so no two sites mean exactly the same thing by status 30 or 50. This worksheet lets you write down what each code means in your plant, who may move an order into it and what it allows. **Sections:** #### How to use the worksheet **Body:** Start by pulling your current list from the UDC program (P0004A, system 00, type SS) and typing each code into a row. Then fill in the lifecycle phase, the role that owns the order in that status and the codes it may move to next. The last columns record whether costs may post and whether the order is still visible to planning. Export to Excel and review the result with production control, maintenance planning and cost accounting before you change any setup. **Bullets:** - One row per status code in your UDC table - Write the allowed next codes as a short list, for example 30, 45, 99 - Use the note column for rules such as a mandatory hold reason - Keep one worksheet per order type if types use different flows #### Where status is controlled in JDE **Body:** Status behaviour is not one switch. The order type setup, the Shop Floor Management constants, the status code processing in Work Order Entry and any custom edits all influence which moves are allowed. Many sites also rely on the status to decide when material can be issued or hours can be entered. Documenting it in one place exposes conflicts, such as two codes that mean the same thing or a status that planning still reads after the order is complete. #### Reading the finished design **Body:** Look for dead ends first: any code that has no allowed next code other than closed, and any code that nobody owns. Then check the cost and planning columns against reality. An order in a status that still posts cost but is invisible to planning is a common source of confusing variances. The count of defined codes is shown at the bottom, and a long list is usually a sign that holds, rework and approval states have been mixed into one field. #### Common mistakes **Body:** The biggest mistake is copying codes from another site or from a blog and assuming they match yours. A second is adding a new code without checking reports, UBEs and custom code that test the status by value. Retest anything that filters on status when you change the list, including Orchestrator steps and integrations that read F4801. **Bullets:** - Treating examples as standard JDE values - Adding codes without searching UBEs and BSFNs that hard code values - Using status to carry both lifecycle and quality hold meaning - Leaving the closed status open to edits **Cta:** If you want status flow questions answered from your own F4801 data, for example how many orders sit in each status by age, Netray can connect an on-prem assistant to your JDE database with read-only access. **Faq:** #### Are JDE work order status codes the same everywhere? **Answer:** No. They are user defined codes stored in UDC system 00, type SS, and each implementation sets its own values and descriptions. Some behaviour is tied to the code through setup, so always read your own UDC table instead of relying on a published list. #### Which table holds the work order status? **Answer:** The work order master table F4801 holds the current status of each order. History of status changes can also be captured in related tables depending on your setup, so check your configuration before relying on it for audit reporting. #### Can I use this for plant maintenance work orders? **Answer:** Yes. Maintenance orders use the same work order master with different order types and often a different status flow. Keep a separate worksheet per type and export each to Excel so approvals and reviews stay clear. #### Does this tool change anything in JD Edwards? **Answer:** No. It runs entirely in your browser and only produces a document. Any change to UDC values or Shop Floor setup must be made in your own JDE environment, tested in a non-production path first. ## Search terms jde work order status codes, jd edwards work order status, jde udc 00 ss, jde work order status template, f4801 wasrst status, jd edwards shop floor management status, jde work order lifecycle, jde status code design excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json