Mapping part numbers and other identifiers
View Patent ↗The invention provides a technique to prevent confusion between part numbers used by different suppliers and manufacturers. The invention includes a database that (1) creates an association between part numbers that are directed to comparable parts, (2) generates a universal number for comparable parts, and (3) creates an association between the part numbers and the universal part. This set of associations is used to generate documents that include part numbers that the recipient of the document is familiar with. Limitations are placed on what authorities may provide information about a set of associations. Generally, only the supplier of a part or the supplier of a comparable part may create associations between their parts. This limitation helps maintain the integrity of information in the database. This database is coupled to a shared service network such as a hub for design collaboration or supply chain control.
1. A method for translating a document that includes a set of proprietary part numbers over a network, including steps of:
receiving a first document including a first set of proprietary part numbers from a client workstation, said first set of proprietary part numbers provided by a user of said client workstation to engage in supply chain management, design collaboration, or the purchase or sale of services or fungible goods;
translating said first set of proprietary part numbers into a set of universal part numbers, wherein said set of universal part numbers is associated with other numbers than the first set of proprietary part numbers, and said other numbers are associated with different suppliers or manufacturers;
determining availability of one or more parts associated with said set of universal part numbers wherein said one or more parts are identified by one or more of said other numbers;
storing in a first database a record of said other numbers and amounts of parts ordered or backordered;
translating said other numbers into at least part of the proprietary part numbers originally provided by the user; and
generating shipping papers or electronic records using the at least part of the proprietary part numbers originally provided by the user translated from the other numbers that summarizes a transaction involving the one or more parts.
2. A method as in claim 1 , wherein said steps of translating said first set of proprietary part numbers and said steps of translating said set of other numbers are performed by a translation module that translates one or more proprietary part numbers associated with said first document into different part numbers that the recipient of said shipping papers or electronic records readily understands.
3. A method as in claim 2 , wherein said translation module is used to prepare commercial documents.
4. A method as in claim 1 , further comprising the step of identifying what parties may create associations between part numbers or enter new part numbers.
5. A memory, including a set of instructions executable by a processor, said set of instructions including instructions for receiving a first document including a first set of proprietary part numbers from a client workstation, said first set of proprietary part numbers provided by a user of said client workstation to engage in supply chain management, design collaboration, or other purchase or sale of services or fungible goods, and wherein each of the proprietary part numbers provided by the user is selected from the group consisting of the user's own part numbers, part numbers of frequently used suppliers, and part numbers found in an on line catalog;
translating said first set of proprietary part numbers into a set of universal part numbers, wherein said set of universal part numbers is associated with other numbers than the first set of proprietary part numbers, and said other numbers are associated with different suppliers or manufacturers;
determining availability of one or more parts associated with said set of universal part numbers wherein said one or more parts are identified by one or more of said other numbers;
storing in a first database a record of said other numbers and amounts of parts ordered or backordered;
translating said other numbers into at least part of the proprietary part numbers originally provided by the user; and
generating shipping papers or electronic records using the at least part of the proprietary part numbers originally provided by the user translated from the other numbers that summarizes a transaction involving the one or more parts.
6. A memory as in claim 5 , wherein said instructions for translating said first set of proprietary part numbers and said instructions for translating said set of other numbers further include a translation module that translates one or more proprietary part numbers associated with said first document into different part numbers that the recipient of said shipping papers or electronic records readily understands.
7. A memory as in claim 6 , wherein said translation module is used to prepare commercial documents.
8. A memory as in claim 5 , wherein said instructions further include instructions for identifying what parties may create associations between part numbers or enter new part numbers.
9. A method as in claim 1 , wherein said universal part numbers are numerical, alpha-numerical, or part numbers involving symbols.
10. A memory as in claim 5 , wherein said universal part numbers are numerical, alpha-numerical, or part numbers involving symbols.
11. A method as in claim 1 , wherein each of the proprietary part numbers provided by the user is selected from the group consisting of the user's own part numbers, part numbers of frequently used suppliers, and part numbers found in an on line catalog.