# What is ProjectOrderLine?

**URL:** <https://www.epiusers.help/t/what-is-projectorderline/69073>\
**Category:** Epicor ERP 10\
**Tags:** project\
**Created:** [July 17, 2020, 12:09pm UTC](https://www.epiusers.help/t/what-is-projectorderline/69073 "2020-07-17T12:09:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\
**Post date:** [July 17, 2020, 12:09pm UTC](https://www.epiusers.help/t/what-is-projectorderline/69073/1 "2020-07-17T12:09:20Z")

</div>

For a specific 16 projects in our system, I get this error if I try to open Project Entry:

> Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> 
> Table: ProjectOrderLine  
> Company=‘29632’ OrderNum=‘29851’ OrderLine=‘1’ SysRowID=‘935c8581-a5b8-4df4-8559-a2cd4f266a61’: ForeignKeyConstraint ProjectOrderLine requires the child key values (29632, ) to exist in the parent table.

Long story short, it is the **phases** that are messing this up. I can delete and re-add the projects with DMT all day long. But I can never get rid of the phases for these projects. I still see them after deleting, with a BAQ. And if I try to delete the phases with DMT, I get that same error all 32 times.

I have had problems before with the link between projects and order lines and with phases and order releases, and have always found a way around it. But it’s been over a week and I am still stuck.

So maybe you all can help me with whatever the error is trying to tell me.

What is ProjectOrderLine?

It says it’s a table, but that’s not true; I can’t even find it in SSMS. It also says it’s a “ForeignKeyConstraint,” but I have no idea what that is.

I know there is a DMT in “Project Entities” for “Sales Order Line.” It mimics the “add” feature of Project Entry. But all I thought it did was put the project number in the project field on OrderDtl. But now I wonder if there is some other link in the background…

![image](https://www.epiusers.help/uploads/default/original/3X/1/a/1a22976f450c08b3d7293fabb8c12190580396bd.png)

![image](https://www.epiusers.help/uploads/default/original/3X/0/0/00ce7b36b8e3d6020c3f9d601b180f8c5c14500e.png)

---

<div class="post-metadata">

**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\
**Post date:** [July 17, 2020, 12:48pm UTC](https://www.epiusers.help/t/what-is-projectorderline/69073/2 "2020-07-17T12:48:54Z")

</div>

I think your issue is on Sales Order Detail. You can only reference a Sales Order Line number on a Project Phase just once. And I don’t know why. You can reference the Project alone on a Sales Order as many times as you want but a phase can only be referenced on a sales order once. So we always left the phases off of the sales order detail lines.

---

<div class="post-metadata">

**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\
**Post date:** [July 17, 2020, 12:51pm UTC](https://www.epiusers.help/t/what-is-projectorderline/69073/3 "2020-07-17T12:51:18Z")

</div>

I GOT IT!!!

There is an Order Number and Order Line on the phases. I made a uBAQ to be able to update them, and now it all works.

 ![image](https://www.epiusers.help/uploads/default/original/3X/e/2/e2a6e57320fa85e08c44c5b1a35e6ba6caea9c67.png)

@Mark_Wonsil I totally agree that that was the rootest of root causes, though. The phase field on the order release is just evil and has caused nothing but problems.