Add Material/Work Groups - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

To add a new material/work group to a supplier, enter all mandatory values.

The arguments of the INS_SUPMG procedure are listed below.

Argument Name

Type

In/Out

P_US_ID

NUMBER, m_user_securities.us_id

IN

P_COL_ARR

RECORD

IN

P_RESULT

VARCHAR2

OUT

P_SMG_ID

NUMBER, m_sup_material_groups.smg_id

OUT

P_SUP_ID

NUMBER, m_suppliers.sup_id

IN

P_COMMIT_IND

VARCHAR2, default ‘Y’

IN

The procedure inserts a record into m_sup_material_groups.

The following table shows the values that can be transferred with P_COL_ARR in the INS_SUPMG procedure.

Column Name

Mandatory

Description

MGTY_CODE

Yes

Supplier ID (NUMBER(12,0), m_matl_group_types.mgty_id)

MG_CODE

Yes

Matl/Work Group ID (NUMBER(12,0), m_sup_material_groups.mg_id)

MG_REVISION_ID

YES

Matl/Work Group Revision (NUMBER(2,0), m_material_groups.revision_id)

QUALIFIED_IND

Yes

Qualified (VARCHAR2(1), m_sup_material_groups.qualified_ind)

QUALIFIED_DATE

No

Qualified Date (DATE), m_sup_material_groups.qualified_date)

APP_DEPARTMENT

No

Approval Department ID (NUMBER(12,0), m_sup_material_groups.dpt_id)

QUALIFICATION_CLASS

Yes

Classification (VARCHAR2(1), m_sup_material_groups.qualification_class)