Tags for Supplier Material Groups - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

You can insert as many supplier material groups for a supplier as you want.

<SUPMG_PROC_TYPE>

Mandatory.

Processing type.

Allowable values: I, U, and N.

'I' means that the object is to be inserted. ‘U’ means that an update is to be performed. ‘N’ means that the supplier material group is not processed, that is, neither inserted nor modified. ‘N’ is not required for the supplier material group, only for suppliers.

<SUPMG_MGTY_CODE>

Mandatory.

Name (code) of the material group type.

<SUPMG_MG_CODE>

Mandatory.

Name (code) of the material group.

<SUPMG_MG_REVISION_ID>

Mandatory.

Revision.

<SUPMG_QUALIFIED_IND>

Optional (default ‘N’).

Indicator that this supplier is qualified for this material group.

<SUPMG_QUALIFIED_DATE>

Optional.

Date on which the supplier was classified as qualified for this material group. If this tag is NULL and tag <SUPMG_QUALIFIED_IND> is ‘Y’, then this field will be filled with SYSDATE.

<SUPMG_APP_DEPARTMENT>

Optional.

Department that has approved the qualification.

<SUPMG_QUALIFICATION_CLASS>

Optional (default ‘N’).

Classification of a supplier's qualification for a material group.

The following values are available:

Not qualified

= 'N'

Potential

= 'P'

Hold

= 'H'

Qualified as stockist

= 'S'

Qualified with conditions

= 'C'

Qualified

= 'Q'