Load UNSPSC Product Codes (IC516)
Run Load UNSPSC Product Codes (IC516) to import a CSV file of codes that can be attached to the Item Master records to create an item hierarchy. The hierarchy file was designed to accept the UNSPSC (United Nations Standard Product Specification Codes), but any four level hierarchy can be imported into the application.
Process at a glance
The codes are used by the Requisitions application to do a step search down through the hierarchy to find a group of items.
More information
The CSV file needs to be placed in the $LAWDIR/productline/interface (UNIX) or LAWDIR/productline/interface (IBM i) directory. The layout of the file is:
| Field | Max Size |
|---|---|
|
IIC-ICSEGMENT (UNIX/Windows) or DIICICSGMN (IBM i) |
2 |
|
IIC-ICFAMILY (UNIX/Windows) or DIICICFMLY (IBM i) |
2 |
|
IIC-ICCLASS (UNIX/WIndows) or DIICICCLSS (IBM i) |
2 |
|
IIC-ICCOMMODITY (UNIX/Windows) or DIICICCMMD (IBM i) |
2 |
|
IIC-ICCODE-SDESC (UNIX/Windows) or DIICICSDSC (IBM i) |
20 |
|
IIC-ICCODE-LDESC (UNIX/Windows) or DIICICLDSC (IBM i) |
80 |