# Oracle and i-Reporter linkage item mapping table

## 1. Oracle->i-Reporter linkage

Oracle field type	i-Reporter cluster type
・CHAR ・NCHAR	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Check ・Single choice ・Multiple choice
・VARCHAR2 ・NVARCHAR2	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Check ・Single choice ・Multiple choice ・Barcode (Only without check "Value is numerical number") ・Barcode reader ・Select master
・NUMBER ・FLOAT ・BINARY_FLOAT ・BINARY_DOUBLE	・Keyboard 　* The automatic numbering mode is not supported. ・Text by handwriting ・Choice of Numerical number ・Numerical number keyboard ・Number of hours ・Check ・Single choice ・Multiple choice ・Barcode ・Barcode reader ・Select master
・DATE ・TIMESTAMP ・TIMESTAMP WITH TIME ZONE ・TIMESTAMP WITH LOCAL TIME ZONE	・Keyboard 　* The automatic numbering mode is not supported. ・Text by handwriting ・Date ・Calender
・INTERVAL YEAR ・INTERVAL DAY ・RAW ・LONG ・LONG RAW ・ROWID ・UROWID ・CLOB ・NCLOB ・BLOB ・BFILE ・JSON	Unsupported

## 2. i-Reporter→Oracle linkage

i-Reporter cluster type	Oracle field type
・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Check ・Single choice ・Multiple choice	・CHAR ・NCHAR
・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Check ・Single choice ・Multiple choice ・Barcode (Only without check "Value is numerical number") ・Barcode reader ・Select master	・VARCHAR2 ・NVARCHAR2 ・LONG
・Keyboard 　* The automatic numbering mode is not supported. ・Text by handwriting ・Choice of Numerical number ・Numerical number keyboard ・Number of hours ・Barcode (Only without check "Value is numerical number")	・NUMBER ・FLOAT ・BINARY_FLOAT ・BINARY_DOUBLE
・Date(Please configure the `NLS_DATE_FORMAT` parameter in Oracle to `'YYYYMMDD'`.) ・Calender(Please configure the `NLS_DATE_FORMAT` parameter in Oracle to `'YYYYMMDD'`.)	・DATE ・TIMESTAMP ・TIMESTAMP WITH TIME ZONE ・TIMESTAMP WITH LOCAL TIME ZONE
Unsupported	・INTERVAL YEAR ・INTERVAL DAY ・RAW ・LONG RAW ・ROWID ・UROWID ・CLOB ・NCLOB ・BLOB ・BFILE ・JSON

## 3. Oracle->ConMas Gateway get data on real-time linkage

Oracle field type	i-Reporter cluster type
・CHAR ・NCHAR	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Single choice
・VARCHAR2 ・NVARCHAR2 ・LONG	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Single choice ・Barcode (Only without check "Value is numerical number")
・NUMBER ・FLOAT ・BINARY_FLOAT ・BINARY_DOUBLE	・Keyboard 　* The automatic numbering mode is not supported. ・Numerical number keyboard ・Check ・Single choice ・Barcode
・DATE ・TIMESTAMP ・TIMESTAMP WITH TIME ZONE ・TIMESTAMP WITH LOCAL TIME ZONE	Plan to support with it in the future
・INTERVAL YEAR ・INTERVAL DAY ・RAW ・LONG RAW ・ROWID ・UROWID ・CLOB ・NCLOB ・BLOB ・BFILE ・JSON	Unsupported

## 4. Oracle->ConMas Gateway get master data on real-time linkage

Oracle field type	i-Reporter cluster type
・CHAR ・NCHAR	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported.
・VARCHAR2 ・NVARCHAR2 ・LONG	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Select master
・NUMBER ・FLOAT ・BINARY_FLOAT ・BINARY_DOUBLE	・Numerical number keyboard ・Select master
・DATE ・TIMESTAMP ・TIMESTAMP WITH TIME ZONE ・TIMESTAMP WITH LOCAL TIME ZONE	Plan to support with it in the future
・INTERVAL YEAR ・INTERVAL DAY ・RAW ・LONG RAW ・ROWID ・UROWID ・CLOB ・NCLOB ・BLOB ・BFILE ・JSON	Unsupported

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://cimtops.gitbook.io/i-repo-link-manual/english/data-source-linkage-all-databases-common/common/oracle-and-i-reporter-linkage-item-mapping-table.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.