# Infor LN General Table Maintenance: Finding and Editing Tables Safely

> Source: https://netray.co/erp-help/infor-ln-general-table-maintenance-tables-safe-changes
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

LN code and data tables are named by package and module (for example tc for Common, td for Distribution, ti for Manufacturing), and nearly every table has a maintenance session. Find the session that owns the table, edit through it so validation and audit apply, and avoid direct SQL updates except under a controlled procedure.

## Kind

how-to

## System

infor-ln

## Erp

Infor LN

## Module

Tools / Common Data / Table Maintenance

## Query

infor ln general table maintenance

## Alternate Queries

- general table maintenance infor ln
- infor ln edit table data
- infor ln find session for table
- infor ln maintain table contents

## Applies To

Infor LN 10.x and Baan 5 style data dictionaries. Session codes depend on your release and installed packages.

## Steps

### How to find and change table data

**Items:**

- Identify the table code. LN table names follow a pattern of package, module and number, such as a tc table for common data.
- Use the Web UI session search or the Tools data dictionary sessions to find which session maintains that table.
- Open the session in a test company first and check the fields, domains and any dependent tables.
- Make the change through the session so LN runs its validation, authorization and audit logic.
- For bulk changes use an import or a documented conversion program, not manual edits.
- Record who changed what and why, and move the change through test, acceptance and production.

## Sections

### How LN names tables and sessions

**Body:**

Tables carry a package prefix, a module code and a number. The package tells you the area, so a tc table is shared master data and a td table belongs to distribution. Sessions follow the same pattern with a suffix that indicates the type, for example a maintain or display session.

The data dictionary in Tools lists tables, fields and domains, and cross references to the sessions that use them. It is the reliable way to answer which session edits this table.

### Why not edit the database directly

**Body:**

Direct updates skip validation, dependent records, authorizations and audit. LN also keeps its own logic about companies and table sharing, so a direct update in one company table can silently miss another. For read-only investigation a query is fine. For writes use the application.

If a vendor or consultant proposes a direct fix, ask for a backup, a test run and a rollback plan before you agree.

### Safe-change practices

**Body:**

Change in a test company first, take a copy of the affected rows before and after, and keep a short change log. Check the effect on running transactions: changing a code used by open orders can leave inconsistent documents. Schedule risky changes outside business hours.

## Pitfalls

- Updating tables with SQL because it is faster.
- Editing production data without a test run.
- Forgetting that table sharing means a change can affect several companies.
- Changing codes used by open orders.

## Ai Angle

An AI assistant over the LN data dictionary can answer which session maintains a table and which fields reference it, and can read table data without write access. Netray's agents stay read-only by default; any change is a proposal for a human to execute through the normal session.

## Faq

### How do I find which session maintains a table?

**Answer:** Use the data dictionary in Tools to see where the table is used, or search sessions by the package and module of the table code. Then open the maintain session.

### Is it ever fine to update LN tables with SQL?

**Answer:** Only under a controlled procedure with a backup, a test run and agreement from the application owner. For normal changes use the session.

### What does the tc prefix mean?

**Answer:** It marks the Common package, which holds shared master data such as items and business partners.

### How do I change many records at once?

**Answer:** Use an import session or a conversion program with validation, tested in a non-production company.

## Search terms

infor ln general table maintenance, infor ln table maintenance, infor ln data dictionary, infor ln find table session, baan table maintenance, infor ln tc table, infor ln edit table data, infor ln safe data change

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json