Supplying Your Own Import Data - Intergraph Smart Reference Data - Help - Hexagon PPM

Intergraph Smart Reference Data Help Classic (2020)

PPMProduct
Intergraph Smart Reference Data
PPMCategory_custom
Help
Version_SPMat_custom
2020 (10.0)

You can use the S.20.10 screen to transfer data from other systems to Smart Materials. To transfer the data from a system to Smart Materials, you must correctly enter the necessary information into the m_table_import_rows import table. The following table shows the structure of the m_table_import_rows import table. The name of the column appears under Column Name heading. Under the Description heading, information about the column name is provided. For some column names, you can leave the column empty. Other column names require that you enter the data type for the column, the size of the column, and additional information about the column. Refer to the table below for specific column name requirements.

Column Name

Description

TIR_ID

NOT NULL NUMBER (12)

If you leave this field empty, this sequence is automatically filled.

TIR_TYPE

NOT NULL VARCHAR2 (20)

This is the Import Type that you can give an arbitrary name. Automatically converted to uppercase.

TIR_LEVEL

NOT NULL VARCHAR2 (10)

Contains TYPE, TABLE, GROUP, or DETAIL. Automatically converted to uppercase. Defaults to DETAIL.

TIR_CODE

NOT NULL VARCHAR2 (30)

Automatically converted to uppercase. For Level TYPE, GROUP, and DETAIL, the field is trimmed to 10 characters.

NLS_ID

NUMBER (12)

The language identifier is required if you want to supply short_desc and description.

SHORT_DESC

VARCHAR2 (255)

Is not used for Level TYPE. For Level TABLE, the field is trimmed to 20 characters.

DESCRIPTION

VARCHAR2 (2000)

For Level TYPE, the field is trimmed to 60 characters. For Level TABLE, the field is trimmed to 255 characters.

ATTR_CHAR1

VARCHAR2 (255)

Is not used for Level TYPE and TABLE.

ATTR_CHAR2

VARCHAR2 (255)

Is not used for Level TYPE and TABLE.

ATTR_CHAR3

VARCHAR2 (255)

Is not used for Level TYPE and TABLE.

ATTR_NUM1

NUMBER (14,4)

Is not used for Level TYPE and TABLE.

ATTR_NUM2

NUMBER (14,4)

Is not used for Level TYPE and TABLE.

ATTR_NUM3

NUMBER (14,4)

Is not used for Level TYPE and TABLE.

STANDARD_IND

NOT NULL VARCHAR2 (1)

Set to N by default. Is only Y for data supplied by Intergraph.

USR_ID

NOT NULL VARCHAR2 (10)

Set to importing ORACLE user by trigger automatically.

LMOD

NOT NULL DATE

Set to Sysdate by trigger automatically.

INT_REV

NOT NULL NUMBER (6)

Incremented by trigger automatically.