GET_COMMODITY_CODE - Intergraph Smart Materials - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Materials Customization (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

Description:

This function is called from cr_pds.sql skript to set m_pds_pcd.free1 and on the PDS 10.12 screen to look up the commodity code for the commodity_id. You can use this function to make final modifications to the column free1, for example, to put/remove flags like asterisks or plus symbols in front of the commodity code, depending on your logic for implied material/assemblies.

The function receives:

  • the actual pmc_id

  • Smart Materials company_id

  • the actual company_id in PDS config

  • the transtype where 1 means commodity level and 2 means ident level

  • free4, which contains A for assembly, C for an assembly position, and I for a non-assembly item

  • the commodity_id from the pcd table

  • the ident from the pcd_table, which is only filled when the lines are exploded to the ident level

Type:

Function

Usage:

PDS.10.12

Event:

Default:

See CIP source code