---
title: "mapping (Odoo)"
description: "itgen_odoo_mapping"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.base_import.mapping
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.base_import.mapping
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# mapping: Odoo itgen_odoo_mapping

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `base_import`
- Label: itgen_odoo_mapping

Base Import Mapping

Can only retrieve data.

## Summary

mapping of previous column:field selections

    This is useful when repeatedly importing from a third-party
    system: column names generated by the external system may
    not match Odoo's field names or labels. This model is used
    to save the mapping between column names and fields so that
    next time a user imports from the same third-party systems
    we can automatically match the columns to the correct field
    without them having to re-enter the mapping every single
    time.

## Table Columns

The columns of the table `mapping` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `column_name` | `varchar2` | Column Name | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `field_name` | `varchar2` | Field Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `res_model` | `varchar2` | Res Model | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

