# MAP_LINE: Field Mapper Lines - Name: `MAP_LINE` - Catalog: `AccountView` - Label: Field Mapper Lines - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `MAP_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `IS_KEY` | `boolean` | Part Of Search Key | ☐ | | | `MAP_EXPN` | `string(4)` | Map Expression | ☐ | | | `MAP_ID` | `string(10)` | Field Mapper ID | ☐ | | | `MAP_PARAM` | `string(4)` | Mapping Parameters | ☐ | | | `MAP_TYPE` | `int32` | Mapping Type | ☐ | | | `MAX_LEN` | `boolean` | Maximum Length | ☐ | | | `NO_IMPORT` | `boolean` | Do not import field | ☐ | | | `PAD_LEFT0` | `boolean` | Pad Left With Zeros | ☐ | | | `PARENT_ID` | `string(10)` | Parent Mapping | ☐ | | | `REC_CUST` | `boolean` | Bespoke | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `SRC_DEC` | `decimal` | Source Field Decimals | ☐ | | | `SRC_DESC` | `string(60)` | Source Field Description | ☐ | | | `SRC_FLD` | `string(10)` | Source Field Name | ☐ | | | `SRC_LEN` | `decimal` | Source Field Length | ☐ | | | `SRC_TYPE` | `string(1)` | Source Field Type | ☐ | | | `TGT_DEC` | `decimal` | Target Field Decimals | ☐ | | | `TGT_DESC` | `string(30)` | Target Field Description | ☐ | | | `TGT_EXPN` | `string(20)` | Target Field Expression | ☐ | | | `TGT_FLD` | `string(10)` | Target Field Name | ☐ | | | `TGT_LEN` | `decimal` | Target Field Length | ☐ | | | `TGT_TYPE` | `string(1)` | Target Field Type | ☐ | |