Part Number Skemes

Yahoo Archive
1
Tod,

Just a point of reference:

In the "Dark Ages", before computers, all of our part numbers were alpha
numeric and descriptive in nature. It helped when you were looking for
somthing in the confines of WIP and Stock Room when all records were manual.

When God invented the affordable computer, we changed to a numeric part
number system but kept the descriptive part number as the part description.

During the days of Classic we wrote querie reports sorting by description
for us old fossils that did not want to change.

With Vantage and its various browsers, we can still find what we need using
search words. Who needs descriptive part numbers when the description is in
full view.

Just my opinion.

Wayne

-----Original Message-----
From: Todd Anderson [mailto:tanderson@...]
Sent: Monday, March 05, 2001 4:11 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Part Number Skemes


Try this ...

For each of the part numbers listed - assign a part number of 1, 2, 3, 4, 5
etc

Now type in each format 500 times ... Which do you prefer ?

Wouldn't it be much easier to have formatted item descriptions and then sort
by item description if you need to find an item number ?

I know, I know, to each his own ... I always felt sorry for the little old
ladies we used to have in our keypunch department 20 years ago. 8 hrs / day
of long part numbers being typed in over and over and over and over ...

Todd Anderson

P.S. No insults intended ... You have a VERY logical item number ...


-----Original Message-----
From: Robert Bruton [mailto:bob@...]
Sent: Monday, March 05, 2001 2:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Number Skemes


We started with the UNS code letter for the alloy. Then an Alloy designator
and shape.

G1018 CRS FLT0160048 = 1018 CRS Flat, .250 x 0.750
G1018 CRS FLT2160432 = 1018 CRS Flat, 2.25 x 4.500
G1018 CRS RND0048 = 1018 CRS Round, 0.750 dia.
G4140CFAN RND0200 = 4140 Cf, Ann, Round, 2.000 dia
G4140CFHT RND0200 = 4140 Cf, Ht, Round, 2.000 dia.
GA36 HRP PLT0116048 = A36 Plate 1.250 x 48.0
GA569 HRS SHT-14G = Hot Rolled Sheet, 14ga (.0747)

SHCS-.500-13 X .750 = Socket Cap Screw 1/2-13 x 3/4
MCMASTER 92290A242 = SHCS, 316SS, M5 x .8 x 20 (Purchased from McMaster)

Our original system (pre-Classic) only allowed for a 10 digit part number.
We had a brand new, fresh out of school Industrial Engineer design a number
system. He loved 64ths. Actually, now that we have 20 digits, it seems
like a lot. We retained the 64ths and expanded the alloy portion. Used to
be the UNS code letter and 2 alphas.

However you go, keep in mind the Vantage Alpha sort order. I find it very
useful to find the next size larger just 1 step down my list. Often, I can
substitute a larger size as long as the alloy doesn't change. Therefore
alloys first then sizes.




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridOptions&t=ad> Click Here to Find Software
Faster
Click Here to Find Software Faster

<http://us.adserver.yahoo.com/l?M=162801.1342103.2934627/D=egroupmail/S=1700
007183:N/A=599089/rand=396395566>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .






Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I would appreciate it if any one could provide suggested part number schemes
that they might be using for purchased parts. We are in metal fabrication
and would appreciate suggestions for the purchase of metal sheets, formed,
fasteners such as bolts, screws, etc. and supplies. Thanks.
3
063-6061-T6-48X144

-----Original Message-----
From: Terry Dank [mailto:tdank@...]
Sent: Monday, March 05, 2001 11:56 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Part Number Skemes


I would appreciate it if any one could provide suggested part number schemes
that they might be using for purchased parts. We are in metal fabrication
and would appreciate suggestions for the purchase of metal sheets, formed,
fasteners such as bolts, screws, etc. and supplies. Thanks.




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
Hi Terry,

We use the following format for metal:

060CR36144 is for CRS, 16 ga, 36 x 144
074EZC48120 is for EZC, 14 ga, 48 x 120

First part of the part number is for the thickness, second part
distinguishes the type of metal and the last part is the measurement of the
metal.

Jamie

--
Jamie Copsey
Database Administrator
AMF Electronics / Accurate Metal Fabricators
1011 Seal Beach Blvd
Seal Beach, CA 90704
(562) 596-4740 x138
Fax: (562) 596-6799
jcopsey@...

> -----Original Message-----
> From: Terry Dank [SMTP:tdank@...]
> Sent: Monday, March 05, 2001 8:56 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Part Number Skemes
>
> I would appreciate it if any one could provide suggested part number
> schemes
> that they might be using for purchased parts. We are in metal fabrication
> and would appreciate suggestions for the purchase of metal sheets, formed,
> fasteners such as bolts, screws, etc. and supplies. Thanks.
>
5
We use a Suffix and Prefix, with a 5 digit primary number (XX-XXXXX-XX)
We've reserved all numbers between 50000 and 60000 to purchased parts
(XX-50000-XX). By including the alphabet you pretty much have a never
ending supply of numbers and number variations.
Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron

-----Original Message-----
From: Terry Dank [mailto:tdank@...]
Sent: Monday, March 05, 2001 11:56 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Part Number Skemes


I would appreciate it if any one could provide suggested part number
schemes
that they might be using for purchased parts. We are in metal fabrication
and would appreciate suggestions for the purchase of metal sheets, formed,
fasteners such as bolts, screws, etc. and supplies. Thanks.

Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
6
Hi Terry,

We start with 2 characters for material type (PL = plate, FB = flat
bar, etc.), then some dimensional description and finally grade. For
example, PL025036 is plate, 0.250 thick, A36. This first sorts like
materials, then like thicknesses.

We also use dimensional inventory, so we don't include sheet sizes in
the part number unless there is a specific, unusual size that we use
for a certain product. If we needed 80" x 236" sheets of 1/4 A36 on
a regular basis, we would enter a number PL02503680*236.

If you have questions, feel free to e-mail me directly.

Jeff Kroes
Pacal Industries


--- In vantage@y..., Terry Dank <tdank@e...> wrote:
> I would appreciate it if any one could provide suggested part
number schemes
> that they might be using for purchased parts. We are in metal
fabrication
> and would appreciate suggestions for the purchase of metal sheets,
formed,
> fasteners such as bolts, screws, etc. and supplies. Thanks.
7
Terry
Here is how we handle fasteners:

Part Number Discription Search
HVYHXNT875NC Nut, Hvy Hex x 7/8"-9 Nut

Regards,
Mike :)


>From: Terry Dank <tdank@...>
>Reply-To: vantage@yahoogroups.com
>To: "'vantage@yahoogroups.com'" <vantage@yahoogroups.com>
>Subject: [Vantage] Part Number Skemes
>Date: Mon, 5 Mar 2001 08:55:40 -0800
>
>I would appreciate it if any one could provide suggested part number
>schemes
>that they might be using for purchased parts. We are in metal fabrication
>and would appreciate suggestions for the purchase of metal sheets, formed,
>fasteners such as bolts, screws, etc. and supplies. Thanks.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
8
For fasteners we use:

SM1/4-20x0.50PPHZ

Screw Machine 1/4-20 x 1/2" Pan Head Phillips Zinc

As you can see we abbreviate a variety of characters but you get use to the
format and the nice thing is it sorts all the like sizes in order.
9
We started with the UNS code letter for the alloy. Then an Alloy designator
and shape.

G1018 CRS FLT0160048 = 1018 CRS Flat, .250 x 0.750
G1018 CRS FLT2160432 = 1018 CRS Flat, 2.25 x 4.500
G1018 CRS RND0048 = 1018 CRS Round, 0.750 dia.
G4140CFAN RND0200 = 4140 Cf, Ann, Round, 2.000 dia
G4140CFHT RND0200 = 4140 Cf, Ht, Round, 2.000 dia.
GA36 HRP PLT0116048 = A36 Plate 1.250 x 48.0
GA569 HRS SHT-14G = Hot Rolled Sheet, 14ga (.0747)

SHCS-.500-13 X .750 = Socket Cap Screw 1/2-13 x 3/4
MCMASTER 92290A242 = SHCS, 316SS, M5 x .8 x 20 (Purchased from McMaster)

Our original system (pre-Classic) only allowed for a 10 digit part number.
We had a brand new, fresh out of school Industrial Engineer design a number
system. He loved 64ths. Actually, now that we have 20 digits, it seems
like a lot. We retained the 64ths and expanded the alloy portion. Used to
be the UNS code letter and 2 alphas.

However you go, keep in mind the Vantage Alpha sort order. I find it very
useful to find the next size larger just 1 step down my list. Often, I can
substitute a larger size as long as the alloy doesn't change. Therefore
alloys first then sizes.




[Non-text portions of this message have been removed]
10
Try this ...

For each of the part numbers listed - assign a part number of 1, 2, 3, 4, 5
etc

Now type in each format 500 times ... Which do you prefer ?

Wouldn't it be much easier to have formatted item descriptions and then sort
by item description if you need to find an item number ?

I know, I know, to each his own ... I always felt sorry for the little old
ladies we used to have in our keypunch department 20 years ago. 8 hrs / day
of long part numbers being typed in over and over and over and over ...

Todd Anderson

P.S. No insults intended ... You have a VERY logical item number ...


-----Original Message-----
From: Robert Bruton [mailto:bob@...]
Sent: Monday, March 05, 2001 2:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Number Skemes


We started with the UNS code letter for the alloy. Then an Alloy designator
and shape.

G1018 CRS FLT0160048 = 1018 CRS Flat, .250 x 0.750
G1018 CRS FLT2160432 = 1018 CRS Flat, 2.25 x 4.500
G1018 CRS RND0048 = 1018 CRS Round, 0.750 dia.
G4140CFAN RND0200 = 4140 Cf, Ann, Round, 2.000 dia
G4140CFHT RND0200 = 4140 Cf, Ht, Round, 2.000 dia.
GA36 HRP PLT0116048 = A36 Plate 1.250 x 48.0
GA569 HRS SHT-14G = Hot Rolled Sheet, 14ga (.0747)

SHCS-.500-13 X .750 = Socket Cap Screw 1/2-13 x 3/4
MCMASTER 92290A242 = SHCS, 316SS, M5 x .8 x 20 (Purchased from McMaster)

Our original system (pre-Classic) only allowed for a 10 digit part number.
We had a brand new, fresh out of school Industrial Engineer design a number
system. He loved 64ths. Actually, now that we have 20 digits, it seems
like a lot. We retained the 64ths and expanded the alloy portion. Used to
be the UNS code letter and 2 alphas.

However you go, keep in mind the Vantage Alpha sort order. I find it very
useful to find the next size larger just 1 step down my list. Often, I can
substitute a larger size as long as the alloy doesn't change. Therefore
alloys first then sizes.




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridOptions&t=ad> Click Here to Find Software
Faster
Click Here to Find Software Faster

<http://us.adserver.yahoo.com/l?M=162801.1342103.2934627/D=egroupmail/S=1700
007183:N/A=599089/rand=396395566>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
11
I find that I only have to enter a part number once. After that I usually
select it from a list.
In material requirements, job entry, order entry, PO entry etc. the part
number search defaults
to part number. A radio button will let me select search word. Or I can do
a contains with the
description. None of these are as useful to me as the part number.
Especially when they present
materials in sorted order by size. Or vendor. Or customer. $.02 worth.

-----Original Message-----
From: Todd Anderson [mailto:tanderson@...]
Sent: Monday, March 05, 2001 4:11 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Part Number Skemes


Try this ...

For each of the part numbers listed - assign a part number of 1, 2, 3, 4, 5
etc

Now type in each format 500 times ... Which do you prefer ?

Wouldn't it be much easier to have formatted item descriptions and then sort
by item description if you need to find an item number ?

I know, I know, to each his own ... I always felt sorry for the little old
ladies we used to have in our keypunch department 20 years ago. 8 hrs / day
of long part numbers being typed in over and over and over and over ...

Todd Anderson

P.S. No insults intended ... You have a VERY logical item number ...


-----Original Message-----
From: Robert Bruton [mailto:bob@...]
Sent: Monday, March 05, 2001 2:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Number Skemes


We started with the UNS code letter for the alloy. Then an Alloy designator
and shape.

G1018 CRS FLT0160048 = 1018 CRS Flat, .250 x 0.750
G1018 CRS FLT2160432 = 1018 CRS Flat, 2.25 x 4.500
G1018 CRS RND0048 = 1018 CRS Round, 0.750 dia.
G4140CFAN RND0200 = 4140 Cf, Ann, Round, 2.000 dia
G4140CFHT RND0200 = 4140 Cf, Ht, Round, 2.000 dia.
GA36 HRP PLT0116048 = A36 Plate 1.250 x 48.0
GA569 HRS SHT-14G = Hot Rolled Sheet, 14ga (.0747)

SHCS-.500-13 X .750 = Socket Cap Screw 1/2-13 x 3/4
MCMASTER 92290A242 = SHCS, 316SS, M5 x .8 x 20 (Purchased from McMaster)

Our original system (pre-Classic) only allowed for a 10 digit part number.
We had a brand new, fresh out of school Industrial Engineer design a number
system. He loved 64ths. Actually, now that we have 20 digits, it seems
like a lot. We retained the 64ths and expanded the alloy portion. Used to
be the UNS code letter and 2 alphas.

However you go, keep in mind the Vantage Alpha sort order. I find it very
useful to find the next size larger just 1 step down my list. Often, I can
substitute a larger size as long as the alloy doesn't change. Therefore
alloys first then sizes.




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

<
http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
>
599089/* http://www.knowledgestorm.com/jump_white.html?c=Yahoo
<http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput>
&n=eLert_Comput
ersInternet_Software_WhiteGridOptions&t=ad> Click Here to Find Software
Faster
Click Here to Find Software Faster

<
http://us.adserver.yahoo.com/l?M=162801.1342103.2934627/D=egroupmail/S=1700
<http://us.adserver.yahoo.com/l?M=162801.1342103.2934627/D=egroupmail/S=1700
>
007183:N/A=599089/rand=396395566>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .




Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridOptions&t=ad> Click Here to Find Software
Faster
Click Here to Find Software Faster

<http://us.adserver.yahoo.com/l?M=162801.1342103.2934627/D=egroupmail/S=1700
007183:N/A=599089/rand=675666279>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]