Difference between revisions of "ITrack/Enterprise/Tag Number"

From ISoft Wiki
Jump to navigationJump to search
 
Line 2: Line 2:


In Enterprise, our users have tended to refer to a "Part Number" as their identifier for inventory records.  This has caused confusion, as there are other fields called "[[Part Number (Enterprise)|Part Number]]" that refer to industry standard names for parts, or vendor-specific names for parts.
In Enterprise, our users have tended to refer to a "Part Number" as their identifier for inventory records.  This has caused confusion, as there are other fields called "[[Part Number (Enterprise)|Part Number]]" that refer to industry standard names for parts, or vendor-specific names for parts.
When creating new part records, the setting "Parts"/"Default format for tag #'s on new replenishable parts" contains a string that represents the default format to use on new replenishable parts.  There are several fields registered that can be used in this format string as follows:
* {vendor.code}: the vendor code for the default purchase vendor
* {inventory.partnumber}: the part # that the default purchase vendor uses to refer to this part (labeled "Part number" on the replenishable tab on the parts screen)
* {inventory.partnumberstripped}: same as above, but with company-specific [[String Delimeters (Enterprise)|Delimeters]] stripped out (such as dashes or spaces).
* {manufacturer.code}: the [[Manufacturer (Enterprise)|manufacturer]] code of the part.
* {model.name}: the [[Model (Enterprise)|model]] of the part.
* {model.strippedname}: same as above, but with company-specific delimeters stripped out.
* {inventory.inventoryid}: the unique SKU of the inventory record.
For example, let use consider an example:
Manufacturer: Fuller (code: FUL)
Model: S-1659
Default purchase vendor: MW
vendor part number: S1659
The default format is "{vendor.code} {inventory.partnumber}" which would result in:
MW S1659
However, another format that could be used is "{manufacturer.code}-{model.name}" which would result in:
FUL-S-1659


==Database==
==Database==

Latest revision as of 16:45, 18 September 2009

As in Pro, the Enterprise tag number is the user identifier for inventory records.

In Enterprise, our users have tended to refer to a "Part Number" as their identifier for inventory records. This has caused confusion, as there are other fields called "Part Number" that refer to industry standard names for parts, or vendor-specific names for parts.

When creating new part records, the setting "Parts"/"Default format for tag #'s on new replenishable parts" contains a string that represents the default format to use on new replenishable parts. There are several fields registered that can be used in this format string as follows:

  • {vendor.code}: the vendor code for the default purchase vendor
  • {inventory.partnumber}: the part # that the default purchase vendor uses to refer to this part (labeled "Part number" on the replenishable tab on the parts screen)
  • {inventory.partnumberstripped}: same as above, but with company-specific Delimeters stripped out (such as dashes or spaces).
  • {manufacturer.code}: the manufacturer code of the part.
  • {model.name}: the model of the part.
  • {model.strippedname}: same as above, but with company-specific delimeters stripped out.
  • {inventory.inventoryid}: the unique SKU of the inventory record.

For example, let use consider an example:

Manufacturer: Fuller (code: FUL) Model: S-1659 Default purchase vendor: MW vendor part number: S1659

The default format is "{vendor.code} {inventory.partnumber}" which would result in: MW S1659

However, another format that could be used is "{manufacturer.code}-{model.name}" which would result in: FUL-S-1659

Database

Tag number is stored in the inventory table with the column name `tagnumber`

See Also

Tag Number (Pro)