The fields mapping for the external data for the Data Mediation process
| Column Name | Column Datatype | Column Null Option | Column Comment |
| field_id | integer | not null | Field number (for sorting) |
| table_id | integer | not null | mr_itable.id |
| pos_1 | integer | with null | File parsing start position |
| pos_2 | integer | with null | File parsing end position (for fixed-length records only - not used for now) |
| value_type | integer | with null | 0=from file, 1=static value, 2=user-defined value, 3=regular expression, 4=system variable |
| data_format | nvarchar(32) | with null | Data conversion e.g. date format, picture codes (e.g. NN.NN, NNN-NNN-NNN) |
| value | nvarchar(64) | with null | Static/default value |
| ftype_id | integer | with null | Field type |
Product Name: Unicenter Service Management
Table Type: Table