Part Master - Total Parts

Good Day:

Sun has 280,650 part#'s. 18,000 have QOH at any given time.
35,000 have some usage during a year.

400,000 records in PartsMtl.


len.hartka@...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Thursday, May 26, 2011 1:47 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Part Master - Total Parts

Table Records Size Min Max Mean Count Factor
Factor
PUB.Part 83762 33.8M 370 1995 423 127207 1.5
7.1

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Thu, May 26, 2011 at 1:11 PM, Blake Clemens
<blake.clemens@...>wrote:

>
>
> Just curious, how many parts does everyone have in their part master?
> We're looking to add a bunch of parts and I want to make sure that we
> don't add too many parts.
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> [Non-text portions of this message have been removed]
>
>
>


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
Just curious, how many parts does everyone have in their part master?
We're looking to add a bunch of parts and I want to make sure that we
don't add too many parts.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[Non-text portions of this message have been removed]
I know we're north of 75k. I'm pretty sure I've heard of people using
several hundred thousand.

On Thu, May 26, 2011 at 1:11 PM, Blake Clemens <blake.clemens@...>wrote:

>
>
> Just curious, how many parts does everyone have in their part master?
> We're looking to add a bunch of parts and I want to make sure that we
> don't add too many parts.
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Around 55K
with slightly over 19K active in the last 3 years

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> Just curious, how many parts does everyone have in their part master?
> We're looking to add a bunch of parts and I want to make sure that we
> don't add too many parts.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> [Non-text portions of this message have been removed]
>
Table Records Size Min Max Mean Count Factor
Factor
PUB.Part 83762 33.8M 370 1995 423 127207 1.5
7.1

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Thu, May 26, 2011 at 1:11 PM, Blake Clemens <blake.clemens@...>wrote:

>
>
> Just curious, how many parts does everyone have in their part master?
> We're looking to add a bunch of parts and I want to make sure that we
> don't add too many parts.
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
You should get rid of those 423 mean parts, im thinking the margin is
better on nice parts.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084

(Click the logo to view our site)



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Thursday, May 26, 2011 12:47 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Part Master - Total Parts

Table Records Size Min Max Mean Count Factor
Factor
PUB.Part 83762 33.8M 370 1995 423 127207 1.5
7.1

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Thu, May 26, 2011 at 1:11 PM, Blake Clemens
<blake.clemens@...>wrote:

>
>
> Just curious, how many parts does everyone have in their part master?
> We're looking to add a bunch of parts and I want to make sure that we
> don't add too many parts.
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> [Non-text portions of this message have been removed]
>
>
>


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
haha nice one

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Thu, May 26, 2011 at 1:51 PM, Rob Bucek <rbucek@...> wrote:

>
>
> You should get rid of those 423 mean parts, im thinking the margin is
> better on nice parts.
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
>
> (Click the logo to view our site)
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Thursday, May 26, 2011 12:47 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Part Master - Total Parts
>
>
> Table Records Size Min Max Mean Count Factor
> Factor
> PUB.Part 83762 33.8M 370 1995 423 127207 1.5
> 7.1
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Thu, May 26, 2011 at 1:11 PM, Blake Clemens
> <blake.clemens@...>wrote:
>
> >
> >
> > Just curious, how many parts does everyone have in their part master?
> > We're looking to add a bunch of parts and I want to make sure that we
> > don't add too many parts.
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


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