Could you develop some sort of cross-reference database table that you could
interface with your system, so that part numbers 123, 456, and 789 all refer
to new part number xyz?
I am not familiar with the workings of Oracle, but our internally developed
MRP system uses a cross-reference table.
-----Original Message-----
From: Smith, Richard [mailto:[log in to unmask]]
Sent: August 29, 2002 9:47 AM
To: [log in to unmask]
Subject: [TN] Part Consolidation
Folks,
As a result of mergers we now have many duplicate and triplicate parts with
different part numbers in our ERP (ORacle) system. For example 3 resistors
part numbers - 123, 456 and 789, all are 1K, 5%, 1/8W, 0805.
The apparent solution (to maximize buying power and drive MRP) would be to
assign a common part number. But, if all the duplicate and triplicate parts
(thousands) are changed to a common part number at least 66% of the
schematics, CAD data, libraries, etc. will require changes. Hopefully
there's a less costly solution.
Is there anyone out there that can provide some insight?
Thanks,
Rick
Richard G. Smith
CAD Services Manager
C-COR Broadband Communications
999 Research Parkway
[log in to unmask]
Meriden, Ct. 06450
PH: 203-639-7670
FX: 203-317-4421
www.c-cor.net
----------------------------------------------------------------------------
-----
Technet Mail List provided as a free service by IPC using LISTSERV 1.8e
To unsubscribe, send a message to [log in to unmask] with following text in
the BODY (NOT the subject field): SIGNOFF Technet
To temporarily halt or (re-start) delivery of Technet send e-mail to
[log in to unmask]: SET Technet NOMAIL or (MAIL)
To receive ONE mailing per day of all the posts: send e-mail to
[log in to unmask]: SET Technet Digest
Search the archives of previous posts at: http://listserv.ipc.org/archives
Please visit IPC web site http://www.ipc.org/html/forum.htm for additional
information, or contact Keach Sasamori at [log in to unmask] or 847-509-9700
ext.5315
----------------------------------------------------------------------------
-----
---------------------------------------------------------------------------------
Technet Mail List provided as a free service by IPC using LISTSERV 1.8e
To unsubscribe, send a message to [log in to unmask] with following text in
the BODY (NOT the subject field): SIGNOFF Technet
To temporarily halt or (re-start) delivery of Technet send e-mail to [log in to unmask]: SET Technet NOMAIL or (MAIL)
To receive ONE mailing per day of all the posts: send e-mail to [log in to unmask]: SET Technet Digest
Search the archives of previous posts at: http://listserv.ipc.org/archives
Please visit IPC web site http://www.ipc.org/html/forum.htm for additional
information, or contact Keach Sasamori at [log in to unmask] or 847-509-9700 ext.5315
---------------------------------------------------------------------------------
|
