baan999
7th October 2009, 09:41
Hello,

I entering in Purchase Order Lines and Details the text details (e.g.terms & conditions), it is printing in PO and stored in tdpur040,tdpur041 as test number.

How to convert this code to nomal text or is there any easy way to review.

Please advice

andrew.page
7th October 2009, 11:26
The text is actually stored in the text table tttxt010 where:
t_ctxt is the text number you are seeing
t_clan is the language

It needs to be converted si you can read it

Try this query
select top 10 *, cast((t_text) as varchar(255)) as texttext from ttttxt010xxx

Where xxx is your company no.

- Andrew