desc F4111 in 8.9

[sourire]
Hello List,

Could anybody send me the result of the DESC oracle command on the F4111 table ?
I want to see the differences between Xe en 8.9 for string fields.
Thanks for advance.

regards,

Guenael,

Here it is:

Name Null? Type
----------------------------------------------------------------------------------- -------- ------
ILNLIN NUMBER
ILITM NUMBER
ILLITM NCHAR(25)
ILAITM NCHAR(25)
ILMCU NCHAR(12)
ILLOCN NCHAR(20)
ILLOTN NCHAR(30)
ILPLOT NCHAR(30)
ILSTUN NUMBER
ILLDSQ NUMBER
ILTRNO NUMBER
ILFRTO NCHAR(1)
ILLMCX NCHAR(1)
ILLOTS NCHAR(1)
ILLOTP NUMBER
ILLOTG NCHAR(3)
ILKIT NUMBER
ILMMCU NCHAR(12)
ILDMCT NCHAR(12)
ILDMCS NUMBER
ILKCO NCHAR(5)
ILDOC NUMBER
ILDCT NCHAR(2)
ILSFX NCHAR(3)
ILJELN NUMBER
ILICU NUMBER
ILDGL NUMBER(6)
ILGLPT NCHAR(4)
ILDCTO NCHAR(2)
ILDOCO NUMBER
ILKCOO NCHAR(5)
ILLNID NUMBER
ILIPCD NCHAR(1)
ILTRDJ NUMBER(6)
ILTRUM NCHAR(2)
ILAN8 NUMBER
ILTREX NCHAR(30)
ILTREF NCHAR(8)
ILRCD NCHAR(3)
ILTRQT NUMBER
ILUNCS NUMBER
ILPAID NUMBER
ILTERM NCHAR(10)
ILUKID NOT NULL NUMBER
ILTDAY NUMBER
ILUSER NCHAR(10)
ILPID NCHAR(10)
ILCRDJ NUMBER(6)
ILAID NCHAR(8)
ILASID NCHAR(25)
ILMCUZ NCHAR(12)
ILOBJ NCHAR(6)
ILSBL NCHAR(8)
ILSUB NCHAR(8)
ILUOM2 NCHAR(2)
ILCMOO NCHAR(1)
ILRE NCHAR(1)
ILSBLT NCHAR(1)
ILSQOR NUMBER
ILVPEJ NUMBER(6)
ILHDGJ NUMBER(6)
ILSHAN NUMBER
ILOPSQ NUMBER
ILRFLN NUMBER
ILTGN NUMBER
ILLOTC NCHAR(3)
ILSVDT NUMBER(6)
ILLRCD NCHAR(3)

JDEList may have killed the formatting, though...

Regards,
Alexander Pastuhov
http://www.pastuhov.com.au/index.htm