I’m not sure if they’re saying that I can pickup one among all these names to define the manufacturer p/n. And what does the # symbol mean? It’s a placeholder for something or it has to be part of the label itself?
@hildogjr can better answer this, but I suppose # is a standard abbreviation of “number”. You youngsters may assume it means “hashtag” or something… It is just an alternative for “number”, “num”, “no”, “nro” or whatever word or abbreviation is used in any particular language.
As for the variants, I assume they are all suitable, I don’t see any other reason to mention them.
are synonyms and internally translate to (used at the output spreadsheet as) manf#.
The other are the synonyms to distributors stock numbers, which I (for sake of simplicity) prefer to use the distributor# format, e.g.: digikey#, mouser#, …
The stock number are prioritized over MPN at the searcher. User case: you have a to much generic MPN that returns fine for all web-site distributors at least from Digikey. So you can use MPN/part#/… from the manufacture plus digikey# stock number fields for this part.