# SyteLine Job Status and Order Status Codes Reference

> Source: https://netray.co/tools/syteline-job-and-order-status-codes-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Look up what Planned, Firm Planned, Released, Stopped, Complete and the other SyteLine status codes mean and how they behave in planning and shipping.

## Category

syteline

## Erp

Infor SyteLine

## Industry

Discrete Manufacturing

## Audience

- SyteLine administrator
- Production planner
- ERP consultant

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### Object

**Key:** object

**Type:** text

#### Stat code

**Key:** code

**Type:** text

#### Status name

**Key:** status

**Type:** text

#### What it means

**Key:** meaning

**Type:** text

#### Planning and MRP behavior

**Key:** planning

**Type:** text

#### Typical next step

**Key:** typical

**Type:** text

**Rows:**

**Object:** Job

**Code:** P

**Status:** Planned

**Meaning:** Job exists as a proposal, often created by planning or entered as a draft.

**Planning:** MRP and APS can change or replace it. Not yet a firm commitment.

**Typical:** Firm or release it when the order is real.

**Object:** Job

**Code:** F

**Status:** Firm Planned

**Meaning:** Job is held fixed against replanning but is not yet on the shop floor.

**Planning:** Planning leaves quantity and dates alone and treats the demand it creates as firm.

**Typical:** Release when materials and capacity are confirmed.

**Object:** Job

**Code:** R

**Status:** Released

**Meaning:** Job is open on the shop floor and can receive material issues, labor and move transactions.

**Planning:** Counts as supply for its parent item and as demand for unissued components.

**Typical:** Report production, then complete.

**Object:** Job

**Code:** S

**Status:** Stopped

**Meaning:** Job is paused. Transactions are blocked until it is released again.

**Planning:** Still visible to planning, so open supply may be overstated while it is stopped.

**Typical:** Resolve the issue and return to Released, or cancel.

**Object:** Job

**Code:** C

**Status:** Complete

**Meaning:** Job is closed to further production transactions.

**Planning:** No longer counts as supply or component demand.

**Typical:** Run job cost close and review variances.

**Object:** Customer order

**Code:** P

**Status:** Planned

**Meaning:** Quote-like order held as a draft, not committed to the customer.

**Planning:** Normally excluded from firm demand unless your planning settings include it.

**Typical:** Convert to Ordered when confirmed.

**Object:** Customer order

**Code:** O

**Status:** Ordered

**Meaning:** Confirmed order that is open and can be picked, shipped and invoiced.

**Planning:** Lines drive demand into MRP and reserve inventory.

**Typical:** Pick, pack and ship.

**Object:** Customer order

**Code:** S

**Status:** Stopped

**Meaning:** Order is held, for example for credit or customer request.

**Planning:** Shipments are blocked while the order is stopped.

**Typical:** Clear the hold or cancel.

**Object:** Customer order

**Code:** F

**Status:** Filled

**Meaning:** All lines are fully shipped but the order is not yet closed out.

**Planning:** No remaining demand.

**Typical:** Invoice remaining shipments and complete.

**Object:** Customer order

**Code:** C

**Status:** Complete

**Meaning:** Order is shipped, invoiced and closed.

**Planning:** No remaining demand.

**Typical:** Archive per retention policy.

**Object:** Customer order line

**Code:** O

**Status:** Ordered

**Meaning:** Line is open with quantity still to ship.

**Planning:** Quantity ordered less shipped is net demand.

**Typical:** Ship against it.

**Object:** Customer order line

**Code:** F

**Status:** Filled

**Meaning:** Line quantity has been shipped in full.

**Planning:** No remaining demand for this line.

**Typical:** Invoice and complete.

**Object:** Customer order line

**Code:** C

**Status:** Complete

**Meaning:** Line is shipped and invoiced.

**Planning:** No remaining demand.

**Typical:** None.

**Object:** Purchase order

**Code:** P

**Status:** Planned

**Meaning:** Draft PO, not yet released to the supplier.

**Planning:** May be treated as planned supply depending on your settings.

**Typical:** Approve and place the order.

**Object:** Purchase order

**Code:** O

**Status:** Ordered

**Meaning:** Placed with the supplier and awaiting receipt.

**Planning:** Counts as firm supply on its due date.

**Typical:** Receive against it.

**Object:** Purchase order

**Code:** F

**Status:** Filled

**Meaning:** All lines are received in full.

**Planning:** No remaining supply.

**Typical:** Match to the supplier invoice.

**Object:** Purchase order

**Code:** C

**Status:** Complete

**Meaning:** PO is received, matched and closed.

**Planning:** No remaining supply.

**Typical:** None.

**Notes:** Codes are the values commonly stored in the stat column of the job, co, coitem, po and poitem tables. Labels and which statuses are available can vary by SyteLine version and by your site settings, so confirm against the status lists in your own forms before building reports or integrations on them.

## Content

**Intro:** SyteLine stores the lifecycle of jobs, customer orders and purchase orders in a one-letter status field. Reports, integrations and planning behavior all key off those letters. This reference lists the common values with what each one does to supply, demand and transactions.

**Sections:**

#### How to use the reference

**Body:** Type a letter, a status name or an object such as Job into the search box to filter the table. Each row gives the stored code, the label you see on the form, what the status means to a planner, how MRP treats it and the usual next move. Use the export buttons to take the table into a runbook, a training deck or an Excel mapping sheet when you are building an integration or a report that must translate codes into readable text.

**Bullets:**

- Search by code when you are reading a query result.
- Search by object to see a full lifecycle at a glance.
- Export to Excel to build a lookup for Power BI or SSRS.

#### Why Firm Planned matters for planners

**Body:** The difference between Planned and Firm Planned is the most misunderstood pair in SyteLine planning. A Planned job is a suggestion the planning engine can regenerate, resize or remove on the next run. A Firm Planned job is protected from that, so it keeps its quantity and dates and still creates component demand. Planners firm jobs to stabilise the near term, but a firm job is also a commitment that nobody revisits, so a stale firm job quietly distorts the plan until someone releases or deletes it.

#### Common mistakes with status codes

**Body:** Teams frequently filter reports on a single status and miss work that sits in another. A WIP report that selects only Released jobs ignores Stopped jobs that still hold issued material. A demand report that selects only Ordered lines ignores partly shipped lines. Another frequent error is hard coding status letters in an integration without checking how your version stores them. Write mappings in one place, test them against live data and re-test after every upgrade.

**Bullets:**

- Stopped jobs still hold WIP value, include them in cost reports.
- Do not treat Filled as Complete: invoicing may be pending.
- Check status values after upgrades before trusting old queries.

**Cta:** If you want these statuses explained inside your own data, such as a plain-language list of every firm planned job older than 30 days, Netray can wire that into a read-only question-and-answer layer over your SyteLine database.

**Faq:**

#### What is the difference between Planned and Firm Planned in SyteLine?

**Answer:** Planned jobs are proposals that the planning run can change or delete. Firm Planned jobs are protected from replanning, keep their quantity and dates and still create component demand. Neither is on the shop floor yet, so no material issues or labor can be posted until the job is released.

#### Can I post transactions to a Stopped job?

**Answer:** No. A Stopped job blocks production transactions until it is set back to Released. That makes Stopped a useful hold, but remember that it keeps its WIP value and still shows in planning, so review stopped jobs regularly instead of leaving them parked.

#### Where is the status stored in the database?

**Answer:** In the stat column of the relevant tables, for example the job table for jobs, co for customer order headers, coitem for order lines and po or poitem for purchasing. In multi-site installations the underlying tables carry a site reference, so filter by site when you query them directly.

#### Do all SyteLine versions use the same status codes?

**Answer:** The core lifecycle is stable across recent versions, but labels, extra values and behavior can differ by version and configuration. Treat this table as a starting reference and verify the values in your own forms and data before relying on them in integrations.

## Search terms

syteline job status, syteline job status codes, syteline firm planned job, syteline customer order status, syteline coitem stat, syteline job_mst stat, infor cloudsuite industrial job status, syteline stopped job

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json