Infor LN Text Table: How Text Fields Are Stored

How to find and read the text behind a record

1. 1Open the record's table definition in the data dictionary and identify the field of text type, for example a text field on the item or order.
2. 2Read the numeric text number stored in that field for your record (zero means there is no text).
3. 3Find the physical text table for your company; the naming convention prefixes t and suffixes the company number, for example ttttxt010 followed by the company number.
4. 4Query the text table by text number (and language if you need one) to get the lines.
5. 5Concatenate the lines in line order to reconstruct the text.
6. 6To copy text, use the text copy or text management functions in the application, which assign a new text number properly.

Reading it with SQL

-- Illustrative only: adjust schema, company number and column names to your system
SELECT t.t_ctxt, t.t_clan, t.t_seqe, t.t_text
FROM ttttxt010100 t
WHERE t.t_ctxt = 123456
ORDER BY t.t_clan, t.t_seqe;

Common pitfalls

• !Inserting rows into the text table directly, creating orphaned or colliding text numbers.
• !Assuming one text number is valid across companies.
• !Ignoring language: reading one language's lines and missing the rest.
• !Joining without the company suffix, so queries hit the wrong or a missing table.