Importing Export Mapping

Mapping Types

If  REQUIRED_YN is Y then EXPORT_VALUE is mandatory.

Table 24-20 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-21 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)