Determining Data Transfer Areas

The fields required for data transfer vary from Business Object to Business Object.

To inform a user which fields must be included in the Excel document to be transferred, you can specify these fields under the "Transfer File Fields" tab.

Note: File type -> "XML - For Extensible Markup Language [XML]", the fields are specified within the encoding.

After clicking the "New" button, you can select a Database Schema , Database Table , and an existing "Column" in the selected table from the drop-down box. The required fields are automatically fetched by the system.

If you do not want to select a column from an existing table, you can define a new column by specifying the following information.

• Column Code: You must type a "Column Code".
• Column Name: You must type a "Column Name".
• Column Data Type: You must select one of the following options.
1. V - Varchar2
2. N - Numeric
3. NA - Numerical Amount
4. NQ - Numerical Quantity
5. D - Date
6. DT - Date - Time
7. T - Local History
8. TT - Local History - Time
9. C - Character
10. O - CLOB
11. B - BLOB
12. X-XML
• Column Length: You must type a "Column Length".
• Required Field?: You can determine whether the column is mandatory or not by checking the checkbox.

View Data Import Template for File Type : "CSV - Semicolon Separated Values"

After completing the above definitions, you can click the relevant " .xls Download " button on the " Data Transfer Templates " screen.