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. |