Catalog subsystem extensions for procurement

Some procurement systems require classification codes for catalog entries under different classification standards such as the UNSPC ( United Nations Standard Product and Services classification). 

To accommodate this requirement, the following additional tables have been added to the catalog subsystem:

WebSphere Commerce Catalog and Order Management subsystems use the UN/CEFACT (United Nations Centre for Trade Facilitation and Electronic Business) standard unit of measurement (UOM) code for quantities and pricing calculations. The QTYUNIT table lists the UN/CEFACT UOM codes used, however, procurement system protocols such as MySAP OCI require the ISO standard UOM codes in the messages.

To provide one-to-one mapping between the UN/CEFACT codes in the QTYUNIT table and the UOM codes under other standards, the QTYUNITMAP database table was added to the catalog subsystem. UOM UN/CEFACT codes for catalog entries in the CATENTSHIP table look up other UOM standard codes from the QTYUNITMAP table.