bxozwa
Member
Hi everyone
I was busy developing a table conversion with a foreign table as input and JDE f0101z2 as output. The data source for the SQL server table was created and I can see the table on TC mappings. There are three data types on the SQL table, namely, int, number and nvarchar.
When I try to map the input table fields with the output table fields, the data types are not the same. The int and number data types are fine. The nvarchar has changed once viewed through JDE table conversion. The data type is now Binary ?!?!.
Can anyone help me solve this problem as I have tried numerous ways of mapping the input to output fields and I haven't been able to fix this problem. JDE doesn't seem to identify data type NVARCHAR and the source system database tables have many instances of this data types.
Please help.
Babs
Deloitte & Touche Active Era
Johannesburg
South Africa
+27 83 734 0991
I was busy developing a table conversion with a foreign table as input and JDE f0101z2 as output. The data source for the SQL server table was created and I can see the table on TC mappings. There are three data types on the SQL table, namely, int, number and nvarchar.
When I try to map the input table fields with the output table fields, the data types are not the same. The int and number data types are fine. The nvarchar has changed once viewed through JDE table conversion. The data type is now Binary ?!?!.
Can anyone help me solve this problem as I have tried numerous ways of mapping the input to output fields and I haven't been able to fix this problem. JDE doesn't seem to identify data type NVARCHAR and the source system database tables have many instances of this data types.
Please help.
Babs
Deloitte & Touche Active Era
Johannesburg
South Africa
+27 83 734 0991