Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC516


IC516 - Load UNSPSC Product Codes

**Form Purpose
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 (iSeries) directory. The layout of the file
is:



Field

    Max Size


IIC-ICSEGMENT (UNIX/Windows) or DIICICSGMN (iSeries)

    2


IIC-ICFAMILY (UNIX/Windows) or DIICICFMLY (iSeries)

    2


IIC-ICCLASS (UNIX/WIndows) or DIICICCLSS (iSeries)

    2


IIC-ICCOMMODITY (UNIX/Windows) or DIICICCMMD (iSeries)

    2


IIC-ICCODE-SDESC (UNIX/Windows) or DIICICSDSC (iSeries)

    20


IIC-ICCODE-LDESC (UNIX/Windows) or DIICICLDSC (iSeries)

    80




Updated Files CKPOINT - ICITEMCODE - Referenced Files ITEMMAST -