Showing results for 
Search instead for 
Do you mean 
Reply

Reserving block of part numbers

I need to reserve a block of part numbers. My naming convention is "PT"NNNNNNNN and I want to reserve or create all at one time PT00002000 - PT000030000. Any ideas?

 

Thanks...

2 REPLIES

Re: Reserving block of part numbers

You can reserve the part number block by incrementing the database counter to 30001. Anyone creating a new Item will get 30001 or above. Lets say that your counter name is PT_ITEM (its not but for this example it is). Then the sql to reset the counter is:

select PNEXT_ID from PIMANNEXTID where PNAME = 'PT_ITEM';

  PNEXT_ID
----------------
       1999

update PIMANNEXTID set PNEXT_ID = 30001 where PNAME = 'PT_ITEM';

select PNEXT_ID from PIMANNEXTID where PNAME = 'PT_ITEM';

  PNEXT_ID
----------------
      30001

 

 

Creating mass Items is a different story and there are many tools to help you do that. Live Excel is one example, ps_upload is another, then you have a host of programming tools, ITK, SOA, etc.

 

Best,

/Randy


Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
Evaluating:AW 3.2

Re: Reserving block of part numbers

[ Edited ]

Keep in mind that once you reserve the block of numbers, like Randy suggested, you will have to enter part number manually if you you want to use number(s) from the reserved block.

---

Thanks and Regards

Yogesh Fegade