Importing Export Mapping
Mapping Types
If REQUIRED_YN is Y then EXPORT_VALUE is mandatory.
Table 24-18 Mapping Types
| Column | Description | Max Data Length | Sample Data | Mandatory |
|---|---|---|---|---|
|
TYPE_DESC |
Mapping Type Description. |
2000 |
EX:(DESCRIPTION) |
|
|
SEQ_NO |
Number |
|||
|
REQUIRED_YN |
1 |
Y/N |
||
|
MAPPING_TYPE |
The code of the export mapping type. |
20 |
EX:(MAP_TYPE) |
|
|
MAPPING_CODE |
Export mapping code to associate with an OPERA Cloud code. |
20 |
EX:(MAP_TYPE_CODE_1) |
|
|
DATA_TYPE |
VARCHAR2/ DATE/ NUMBER |
VARCHAR2/ DATE/ NUMBER |
|
|
|
CONFIG_TYPE |
The code in OPERA Cloud (Mapped To) to which the export mapping type relates and for which a value will be defined using export mapping codes. |
32767 |
EX:(MARKET_CODES) |
|
|
CODE_DESC |
Export Mapping Code Description. |
2000 |
EX:(DESCRIPTION) |
|
Export Mapping
EXPORT_VALUE is mandatory when REQUIRED_YN is Y in Mapping_Types.csv for the corresponding MAPPING_CODE.
Table 24-19 Export Mapping
| Column | Description | Max Data Length | Sample Data | Mandatory |
|---|---|---|---|---|
|
MAPPING_CODE |
Export mapping code to associate with an OPERA Cloud code. |
20 |
EX:(MAP_TYPE_CODE_1) |
|
|
LINKED_CODE |
The code in OPERA Cloud (Mapped To) to which the export mapping type relates and for which a value will be defined using export mapping codes. |
50 |
EX:(MARKET_CODES) |
|
|
EXPORT_VALUE |
Value of the Mapping Code. |
2000 |
EX:(TEST_12345) |
Parent topic: About Data Import