Good suggestion josh, once I saw the field I agree. When they use delimiters like that it's frustrating, though solvable, good to hear you got it worked out.
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 3:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Got it. I remember the term Patch Field, so I did a search.
snielsen28
Message 2 of 4 , Jan 29
View Source
If you look at field help at this field in order entry you will see the external check box is checked (it will be grayed out). This means the field is stored in another table, usually the PatchFld table. This is a temporary table that Epicor uses to store fields until a patch with a schema change moves them to the table they should be in. You can link the OrderHed table to the PatchFld table with OrderHed.Company=PatchFld.Company and OrderHed.OrderNum=PatchFld.ForeignKey. Set the criteria for the PatchFld.TableName=OrderHed and PatchFld.Field=InvcOrderCmp. You can then access the PatchFld.DataLogical field for the True/False value.
So I brought in the PatchFld table to my query and set these criterias.
for each PatchFld no-lock where PatchFld.TableName = 'OrderDtl' And PatchFld.FieldName = 'JobTypeMFG' And PatchFld.DataCharacter = 'NO' .
The ForeignKey values gives me the Order~Line
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
In this instance you are looking for that field in the Patch table. God speed sir lol
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905702A-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
http://tinyurl.com/m3w573e
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 12:05 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
So what do you mean specifically by Sales Orders were set to no Job, how and where was that indicated in the Order Entry screen?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 2:00 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Nope, 40% of our orders are Inv orders.
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 11:53 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Could you derive that when the release, make direct is not checked?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 1:50 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Query.
Seems that some sales orders were set to no job. So a request was put in to display all open sales orders with that field set as NO.
But that field is not a DB Field, so I cant query it or display it/
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 11:42 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
As in pulling a leg or pork? What are you trying to do?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 1:39 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>
Subject: [Vantage] E9: Is there a way to pull a field that is not in a table?
OrderDtl.JobTypeMfg
It is in the Sales Order Entry, Lines Tab > Job Type
Miguel A. Santillan
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 3:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Got it. I remember the term Patch Field, so I did a search.
snielsen28
Message 2 of 4 , Jan 29
View Source
If you look at field help at this field in order entry you will see the external check box is checked (it will be grayed out). This means the field is stored in another table, usually the PatchFld table. This is a temporary table that Epicor uses to store fields until a patch with a schema change moves them to the table they should be in. You can link the OrderHed table to the PatchFld table with OrderHed.Company=PatchFld.Company and OrderHed.OrderNum=PatchFld.ForeignKey. Set the criteria for the PatchFld.TableName=OrderHed and PatchFld.Field=InvcOrderCmp. You can then access the PatchFld.DataLogical field for the True/False value.
So I brought in the PatchFld table to my query and set these criterias.
for each PatchFld no-lock where PatchFld.TableName = 'OrderDtl' And PatchFld.FieldName = 'JobTypeMFG' And PatchFld.DataCharacter = 'NO' .
The ForeignKey values gives me the Order~Line
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
In this instance you are looking for that field in the Patch table. God speed sir lol
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905702A-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
http://tinyurl.com/m3w573e
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 12:05 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
So what do you mean specifically by Sales Orders were set to no Job, how and where was that indicated in the Order Entry screen?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 2:00 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Nope, 40% of our orders are Inv orders.
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 11:53 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Could you derive that when the release, make direct is not checked?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 1:50 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
Query.
Seems that some sales orders were set to no job. So a request was put in to display all open sales orders with that field set as NO.
But that field is not a DB Field, so I cant query it or display it/
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 11:42 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E9: Is there a way to pull a field that is not in a table?
As in pulling a leg or pork? What are you trying to do?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>> [mailto:vantage@yahoogroups.com]
Sent: Friday, March 20, 2015 1:39 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>
Subject: [Vantage] E9: Is there a way to pull a field that is not in a table?
OrderDtl.JobTypeMfg
It is in the Sales Order Entry, Lines Tab > Job Type
Miguel A. Santillan
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]