Infor LN & BaanFree referencePDF, Excel, Word exportBaan IV / Infor LNAll Infor LN and Baan tools

Infor LN General Tables Reference: tcmcs Common Data

The tcmcs tables in the Common package hold the code lists that almost every LN and Baan session references: units, currencies, countries, languages, item groups, payment and delivery terms, departments, carriers and more. This reference gives the key field, the maintenance session, the tables that point to each one and guidance on sharing them across companies.

Download:

Table	Description	Key field	Maintain session	Typical referencing tables	Share across companies?	Baan IV vs LN note
tcmcs001	Units	cuni	tcmcs0101m000 Units	tcibd001.cuni, tdsls401.cuqs, tdipu001.cuqp	yes	Same number in Baan IV.
tcmcs002	Currencies	ccur	tcmcs0102m000 Currencies	tdsls400.ccur, tccom112.ccur, tdipu001.ccur	yes	Same number in Baan IV.
tcmcs003	Warehouses	cwar	tcmcs0503m000 Warehouses	tdsls401.cwar, tisfc001.cwar, whwmd200, whwmd215	no	Exists in Baan IV and still in LN 10.x; LN adds whwmd200 for warehousing settings.
tcmcs004	Routes	crte	tcmcs0104m000 Routes	tdsls400.crte, tdsls401.crte	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs005	Reasons	rstp reason type + reason code	tcmcs0105m000 Reasons	Reason fields on rejections, returns, cycle counts and inventory adjustments	often	LN 10.x confirmed; the reason type separates uses, and reasons carry effective and expiry dates.
tcmcs006	Unit sets	uset	tcmcs0106m000 Unit Sets	tcibd001.uset	yes	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs008	Currency rates	bcur, ccur, rtyp, stdt	tcmcs0108m000 Currency Rates	Order and invoice currency conversion	often	LN 10.x confirmed; rates by exchange rate type.
tcmcs010	Countries	ccty	tcmcs0510m000 Countries	tccom130.ccty, tcmcs060.ccty	yes	Same number in Baan IV.
tcmcs013	Payment terms	cpay	tcmcs0513m000 Payment Terms	tdsls400.cpay, tccom112.cpay, tdsls300.cpay	often	Same number in Baan IV (terms of payment).
tcmcs015	Product types	ctyp	tcmcs0115m000 Product Types	tcibd001.ctyp	yes	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs021	Discount codes	cdis	tcmcs0121m000 Discount Codes	tdsls401.cdis, tdsls301.cdis	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs023	Item groups	citg	tcmcs0123m000 Item Groups	tcibd001.citg, tcibd003.citg, tdisa010.citg	often	Same number in Baan IV.
tcmcs024	Price groups	cprg	tcmcs0124m000 Price Groups	tdisa001.cpgs, tdipu001.cpgp, tdsls301.cpgs	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs028	Harmonized system codes	ccde	tcmcs0128m000 Harmonized System Codes	tcibd001.ccde	yes	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs029	Business partner types	cbtp	tcmcs0129m000 Business Partner Types	tccom110.cbtp, tccom112.cbtp	yes	Part of the LN business partner model.
tcmcs031	Lines of business	cbrn	tcmcs0131m000 Lines of Business	tdsls400.cbrn, tccom110.cbrn	yes	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs037	Tax codes	cvat	tcmcs0137m000 Tax Codes	tdsls401.cvat, tdisa001.cvat, cisli310.cvat	often	LN 10.x confirmed; rates are maintained in Single Tax Rates (tcmcs0132m000) and Multiple Tax Rates (tcmcs0133m000).
tcmcs040	Exchange rate types	rtyp	tcmcs0140m000 Exchange Rate Types	tcmcs008.rtyp, tdsls400.ratt	yes	LN 10.x confirmed.
tcmcs041	Delivery terms	cdec	tcmcs0141m000 Delivery Terms	tdsls400.cdec, tdsls401.cdec, tdsls406.cdec	yes	Same number in Baan IV (terms of delivery).
tcmcs042	Points of title passage	ptpa	tcmcs0142m000 Points of Title Passage	tdsls400.ptpa, tdsls401.ptpa	yes	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs044	Statistical groups	csgp	tcmcs0144m000 Statistical Groups	tdisa001.csgs, tdipu001.csgp	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs045	Areas	creg	tcmcs0145m000 Areas	tdsls400.creg, tccom110.creg, cisli310.creg	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs046	Languages	clan	tcmcs0146m000 Languages	tccom100.clan, tccom001.clan, tcmcs003.clan	yes	Same number in Baan IV.
tcmcs048	Cost components	cpcp	tcmcs0148m000 Cost Components	tirou002.cpcp, tccom001.cpcp	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs060	Manufacturers	cmnf	tcmcs0160m000 Manufacturers	tcibd001.cmnf, tdipu001.cmnf	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs061	Product lines	cpln	tcmcs0161m000 Product Lines	tcibd001.cpln	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs062	Product classes	cpcl	tcmcs0162m000 Product Classes	tcibd001.cpcl	often	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs064	Credit ratings	crat	tcmcs0564m000 Credit Ratings	tccom112.crat	often	LN 10.x confirmed; holds the credit check actions per rating.
tcmcs065	Departments	cwoc	tcmcs0565m000 Departments	tirou001.cwoc, tccom001.cwoc	no	Departments are site and company specific; typd sets the department type.
tcmcs066	Channels	chan	tcmcs0166m000 Channels	tccom110.chan, tdsls401.chan	yes	LN 10.x confirmed; check your Baan IV dictionary.
tcmcs080	Carriers/LSP	cfrw	tcmcs0580m000 Carriers/LSP	tdsls400.cfrw, tccom111.cfrw, tdsls406.cfrw	often	Same number in Baan IV.

Sharing guidance is a starting point for logical table linking in a multicompany setup, not an Infor rule: share tables whose codes must mean the same everywhere (units, currencies, countries, languages), consider sharing reference lists maintained centrally, and keep logistics and finance-specific tables (warehouses, departments) per company. Numbers, keys and sessions were checked against the LN 10.x online help. Baan IV notes say 'same number' only for well-known tables; for the rest, check the Baan IV data dictionary of your own system.

Planning table sharing for a multicompany LN setup?

Send us your company structure and we will review which tcmcs tables to share and which to keep per company.

Optional. The tool and every export work without this. No spam.

Was this tool useful?

How to use the list

Search by table number, description or field. The Key field column is the code that other tables store: for example tdsls400.cpay holds a tcmcs013 payment term and tcibd001.citg holds a tcmcs023 item group. When a session rejects a value or a report shows a code without a description, find the referencing field here and join to the general table on its key to get dsca. Most maintenance sessions follow the pattern tcmcs01NNm000 for table tcmcs0NN; a few, such as Countries, Payment Terms, Departments, Warehouses and Carriers, use tcmcs05NNm000 in LN 10.x.

Logical table sharing across companies

In a multicompany LN environment, tables can be linked so that several logical companies read one physical company. General tables are the usual candidates because the codes must mean the same thing everywhere. Share units, currencies, countries and languages almost always. Share item groups, price groups and terms when a central master data team owns them. Keep warehouses and departments per company because they carry addresses, financial companies and sites. Decide before go-live: splitting a shared table later means copying data and remapping references.

Share: units, currencies, countries, languages
Often share: item groups, terms, carriers, reasons
Usually not: warehouses, departments

Baan IV versus LN

Many tcmcs numbers are unchanged since Baan IV, which is why old reports still find units in tcmcs001 and item groups in tcmcs023. Warehouses are a common surprise: tcmcs003 still exists in LN 10.x as the warehouse master, while the warehousing-specific settings moved to whwmd200. LN added tables that Baan IV did not have, such as business partner types, unit sets and points of title passage. When you migrate, compare the field list of each table rather than assuming a same-numbered table has the same columns.

Worked example: show descriptions in a report

A sales order report shows codes such as cpay, cdec and creg. To print descriptions, left join tcmcs013 on cpay, tcmcs041 on cdec and tcmcs045 on creg, and select dsca from each. If the tables are logically shared, read them in the company that physically holds the data, which you can see in the company mapping, otherwise the join returns nothing. Some general tables also carry multi-language descriptions, so check which data language your report session uses before you compare text with what users see on screen.

Frequently Asked Questions

What is a general table in Infor LN?

A general table is a code list in the Common (tc) package, mostly tcmcs tables, that other modules reference: units, currencies, countries, item groups, payment terms, delivery terms, departments, carriers and similar. They are maintained in sessions such as tcmcs0101m000 Units and are often shared across companies.

How do I maintain general tables in Infor LN?

Open the maintenance session for the table, for example Item Groups (tcmcs0123m000) or Payment Terms (tcmcs0513m000), and add or change codes there. If the table is logically shared, the change applies to every linked company, so agree changes with the other companies first.

Which table holds item groups in Infor LN?

tcmcs023, keyed by citg, maintained in Item Groups (tcmcs0123m000). The item group code is stored on tcibd001.citg and is also used in conversion factors (tcibd003) and item by business partner records (tdisa010). The same table number was used for item groups in Baan IV.

Should warehouses be shared between companies?

Usually not. tcmcs003 warehouses carry an address, a financial company and links to sites and enterprise units, and warehousing settings in whwmd200 depend on them. Sharing them makes inventory ownership and postings unclear. Share code lists that mean the same everywhere instead.

If you are consolidating companies or cleaning up shared master data in LN, we can help your team query these tables in plain English on your own servers.

Talk to an Expert Explore More Free Tools