Part.TypeCode Blank Title 125596


(system) #1

Cathy,


Thank you for your response.  I was hoping to pull from the database, but that was the answer we had come to as well.



---In vantage@yahoogroups.com, <kflatford@...> wrote:

Thank you for the response.  I am actually looking for where the drop down text 'Manufactured Part' and 'Purchased Part' comes from.  We would like to display this text else where, but the the Part.TypeCode only contains the M or P.



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

<!-- #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475MsoNormal, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475MsoNormal, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 a:link, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475MsoHyperlink { color:blue;text-decoration:underline;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 a:visited, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475MsoHyperlinkFollowed { color:purple;text-decoration:underline;} #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p {

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 code
{
font-family:“Courier New”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 pre
{

margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:“Courier New”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475cat
{}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ct
{}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475HTMLPreformattedChar
{

font-family:“Consolas”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475attach, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475attach, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475attach
{

margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475bold, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475bold, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475bold
{

margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:“Arial”, “sans-serif”;font-weight:bold;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475green, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475green, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475green
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;color:#628C2A;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475replbq, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475replbq, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475replbq
{
margin:3.0pt;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475underline, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475underline, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475underline
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475yshortcuts
{}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad1, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad1, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad1
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad2, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad2, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475ad2
{

margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 p.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475underline1, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 li.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475underline1, #ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475underline1
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;text-decoration:underline;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475yshortcuts1
{
font-family:“Verdana”, “sans-serif”;font-weight:bold;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475yshortcuts2
{
font-family:“Verdana”, “sans-serif”;font-weight:normal;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 span.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475EmailStyle36
{
font-family:“Calibri”, “sans-serif”;color:#1F497D;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 .ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475MsoChpDefault
{
font-size:10.0pt;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 div.ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475WordSection1
{}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475
filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {
}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Symbol;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:“Courier New”;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 filtered #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 ol
{margin-bottom:0in;}
#ygrps-yiv-1137923413 #ygrps-yiv-1137923413ygrps-yiv-1196651731 #ygrps-yiv-1137923413ygrps-yiv-1196651731ygrps-yiv-358857475 ul
{margin-bottom:0in;}
–>

Classifies Parts into the following…

M = Manufactured Part.

P = Purchased Part

This type code does limit referencing any part in any way. For example a type “P” can be entered on a sales order, or a type “M” can be referenced in a Purchase Order.

This field will also be used as a selection parameter in certain reports, such as Time Phase Requirements.

 

This is found in the data dictionary in Vantage 8.03.409C – there may be more codes in your version…The table would be Part.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kflatford@…
Sent: Monday, October 21, 2013 12:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part.TypeCode

 

 

We are wanting to display the Part.TypeCode on the order line tab. I cannot find where the text options for the drop down are coming from.  Is there a table in the database that specifies the TypeCodes available or a setup in Customer?  

Currently, we are displaying just the letter code that is stored in the Part, but would like the full text of the type code displayed.



(system) #2
We are wanting to display the Part.TypeCode on the order line tab. I cannot find where the text options for the drop down are coming from.  Is there a table in the database that specifies the TypeCodes available or a setup in Customer?  

Currently, we are displaying just the letter code that is stored in the Part, but would like the full text of the type code displayed.

(system) #3
<!-- #ygrps-yiv-1156650410 _filtered #ygrps-yiv-1156650410 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1156650410 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1156650410 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1156650410 {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1156650410 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1156650410 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1156650410 #ygrps-yiv-1156650410 p.ygrps-yiv-1156650410MsoNormal, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410MsoNormal, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1156650410 a:link, #ygrps-yiv-1156650410 span.ygrps-yiv-1156650410MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1156650410 a:visited, #ygrps-yiv-1156650410 span.ygrps-yiv-1156650410MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1156650410 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1156650410 code
{
font-family:“Courier New”;}
#ygrps-yiv-1156650410 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1156650410 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410cat
{}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410ct
{}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410HTMLPreformattedChar
{

font-family:“Consolas”, “serif”;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410attach, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410attach, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410bold, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410bold, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410green, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410green, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410replbq, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410replbq, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410ad, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410ad, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410underline, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410underline, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410yshortcuts
{}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410ad1, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410ad1, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410ad2, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410ad2, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1156650410 p.ygrps-yiv-1156650410underline1, #ygrps-yiv-1156650410 li.ygrps-yiv-1156650410underline1, #ygrps-yiv-1156650410 div.ygrps-yiv-1156650410underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1156650410 span.ygrps-yiv-1156650410EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1156650410 .ygrps-yiv-1156650410MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1156650410 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1156650410 div.ygrps-yiv-1156650410WordSection1
{}
#ygrps-yiv-1156650410
_filtered #ygrps-yiv-1156650410 {
}
_filtered #ygrps-yiv-1156650410 {

font-family:Symbol;}
_filtered #ygrps-yiv-1156650410 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1156650410 {

font-family:Wingdings;}
#ygrps-yiv-1156650410 ol
{margin-bottom:0in;}
#ygrps-yiv-1156650410 ul
{margin-bottom:0in;}
–>

Classifies Parts into the following…

M = Manufactured Part.

P = Purchased Part

This type code does limit referencing any part in any way. For example a type “P” can be entered on a sales order, or a type “M” can be referenced in a Purchase Order.

This field will also be used as a selection parameter in certain reports, such as Time Phase Requirements.

 

This is found in the data dictionary in Vantage 8.03.409C – there may be more codes in your version…The table would be Part.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kflatford@…
Sent: Monday, October 21, 2013 12:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part.TypeCode

 

 

We are wanting to display the Part.TypeCode on the order line tab. I cannot find where the text options for the drop down are coming from.  Is there a table in the database that specifies the TypeCodes available or a setup in Customer?  

Currently, we are displaying just the letter code that is stored in the Part, but would like the full text of the type code displayed.


(system) #4

There is one more type and that is K = Kit.

 

As far as I know there isn’t a table where Parttype is stored to display the descriptions(like part class, product groups, etc).

 

You might just write code to display the 3 part types in Order Entry.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Monday, October 21, 2013 10:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part.TypeCode

 

 

Classifies Parts into the following...

M = Manufactured Part.

P = Purchased Part

This type code does limit referencing any part in any way. For example a type "P" can be entered on a sales order, or a type "M" can be referenced in a Purchase Order.

This field will also be used as a selection parameter in certain reports, such as Time Phase Requirements.

 

This is found in the data dictionary in Vantage 8.03.409C – there may be more codes in your version…The table would be Part.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kflatford@...
Sent: Monday, October 21, 2013 12:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part.TypeCode

 

 

We are wanting to display the Part.TypeCode on the order line tab. I cannot find where the text options for the drop down are coming from.  Is there a table in the database that specifies the TypeCodes available or a setup in Customer?  

Currently, we are displaying just the letter code that is stored in the Part, but would like the full text of the type code displayed.


(system) #5

Thank you for the response.  I am actually looking for where the drop down text 'Manufactured Part' and 'Purchased Part' comes from.  We would like to display this text else where, but the the Part.TypeCode only contains the M or P.



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

<!-- #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475MsoNormal, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475MsoNormal, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 a:link, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475MsoHyperlink { color:blue;text-decoration:underline;} #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 a:visited, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475MsoHyperlinkFollowed { color:purple;text-decoration:underline;} #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p {

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 code
{
font-family:“Courier New”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 pre
{

margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:“Courier New”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 tt
{
font-family:“Courier New”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475cat
{}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475ct
{}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475HTMLPreformattedChar
{

font-family:“Consolas”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475attach, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475attach, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475attach
{

margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475bold, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475bold, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475bold
{

margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:“Arial”, “sans-serif”;font-weight:bold;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475green, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475green, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475green
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;color:#628C2A;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475replbq, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475replbq, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475replbq
{
margin:3.0pt;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475ad, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475ad, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475ad
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475underline, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475underline, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475underline
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475yshortcuts
{}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475ad1, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475ad1, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475ad1
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475ad2, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475ad2, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475ad2
{

margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 p.ygrps-yiv-2137526008ygrps-yiv-358857475underline1, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 li.ygrps-yiv-2137526008ygrps-yiv-358857475underline1, #ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475underline1
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;text-decoration:underline;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475yshortcuts1
{
font-family:“Verdana”, “sans-serif”;font-weight:bold;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475yshortcuts2
{
font-family:“Verdana”, “sans-serif”;font-weight:normal;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 span.ygrps-yiv-2137526008ygrps-yiv-358857475EmailStyle36
{
font-family:“Calibri”, “sans-serif”;color:#1F497D;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 .ygrps-yiv-2137526008ygrps-yiv-358857475MsoChpDefault
{
font-size:10.0pt;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 div.ygrps-yiv-2137526008ygrps-yiv-358857475WordSection1
{}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475
filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {
}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Symbol;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:“Courier New”;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 filtered #ygrps-yiv-2137526008ygrps-yiv-358857475 {

font-family:Wingdings;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 ol
{margin-bottom:0in;}
#ygrps-yiv-2137526008 #ygrps-yiv-2137526008ygrps-yiv-358857475 ul
{margin-bottom:0in;}
–>

Classifies Parts into the following…

M = Manufactured Part.

P = Purchased Part

This type code does limit referencing any part in any way. For example a type “P” can be entered on a sales order, or a type “M” can be referenced in a Purchase Order.

This field will also be used as a selection parameter in certain reports, such as Time Phase Requirements.

 

This is found in the data dictionary in Vantage 8.03.409C – there may be more codes in your version…The table would be Part.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kflatford@…
Sent: Monday, October 21, 2013 12:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part.TypeCode

 

 

We are wanting to display the Part.TypeCode on the order line tab. I cannot find where the text options for the drop down are coming from.  Is there a table in the database that specifies the TypeCodes available or a setup in Customer?  

Currently, we are displaying just the letter code that is stored in the Part, but would like the full text of the type code displayed.