# Infor LN General Tables Reference: tcmcs Common Data > Source: https://netray.co/tools/infor-ln-common-data-tcmcs-general-tables-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer The tcmcs general tables that almost every LN session references, with key field, maintenance session, typical referencing tables and table sharing guidance. ## Category infor-ln ## Erp Baan IV / Infor LN ## Audience - ERP administrator - LN developer - Implementation consultant ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Description **Key:** description **Type:** text #### Key field **Key:** key **Type:** text #### Maintain session **Key:** session **Type:** text #### Typical referencing tables **Key:** refs **Type:** text #### Share across companies? **Key:** share **Type:** select **Options:** - yes - often - no #### Baan IV vs LN note **Key:** baan **Type:** text **Rows:** **Table:** tcmcs001 **Description:** Units **Key:** cuni **Session:** tcmcs0101m000 Units **Refs:** tcibd001.cuni, tdsls401.cuqs, tdipu001.cuqp **Share:** yes **Baan:** Same number in Baan IV. **Table:** tcmcs002 **Description:** Currencies **Key:** ccur **Session:** tcmcs0102m000 Currencies **Refs:** tdsls400.ccur, tccom112.ccur, tdipu001.ccur **Share:** yes **Baan:** Same number in Baan IV. **Table:** tcmcs003 **Description:** Warehouses **Key:** cwar **Session:** tcmcs0503m000 Warehouses **Refs:** tdsls401.cwar, tisfc001.cwar, whwmd200, whwmd215 **Share:** no **Baan:** Exists in Baan IV and still in LN 10.x; LN adds whwmd200 for warehousing settings. **Table:** tcmcs004 **Description:** Routes **Key:** crte **Session:** tcmcs0104m000 Routes **Refs:** tdsls400.crte, tdsls401.crte **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs005 **Description:** Reasons **Key:** rstp reason type + reason code **Session:** tcmcs0105m000 Reasons **Refs:** Reason fields on rejections, returns, cycle counts and inventory adjustments **Share:** often **Baan:** LN 10.x confirmed; the reason type separates uses, and reasons carry effective and expiry dates. **Table:** tcmcs006 **Description:** Unit sets **Key:** uset **Session:** tcmcs0106m000 Unit Sets **Refs:** tcibd001.uset **Share:** yes **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs008 **Description:** Currency rates **Key:** bcur, ccur, rtyp, stdt **Session:** tcmcs0108m000 Currency Rates **Refs:** Order and invoice currency conversion **Share:** often **Baan:** LN 10.x confirmed; rates by exchange rate type. **Table:** tcmcs010 **Description:** Countries **Key:** ccty **Session:** tcmcs0510m000 Countries **Refs:** tccom130.ccty, tcmcs060.ccty **Share:** yes **Baan:** Same number in Baan IV. **Table:** tcmcs013 **Description:** Payment terms **Key:** cpay **Session:** tcmcs0513m000 Payment Terms **Refs:** tdsls400.cpay, tccom112.cpay, tdsls300.cpay **Share:** often **Baan:** Same number in Baan IV (terms of payment). **Table:** tcmcs015 **Description:** Product types **Key:** ctyp **Session:** tcmcs0115m000 Product Types **Refs:** tcibd001.ctyp **Share:** yes **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs021 **Description:** Discount codes **Key:** cdis **Session:** tcmcs0121m000 Discount Codes **Refs:** tdsls401.cdis, tdsls301.cdis **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs023 **Description:** Item groups **Key:** citg **Session:** tcmcs0123m000 Item Groups **Refs:** tcibd001.citg, tcibd003.citg, tdisa010.citg **Share:** often **Baan:** Same number in Baan IV. **Table:** tcmcs024 **Description:** Price groups **Key:** cprg **Session:** tcmcs0124m000 Price Groups **Refs:** tdisa001.cpgs, tdipu001.cpgp, tdsls301.cpgs **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs028 **Description:** Harmonized system codes **Key:** ccde **Session:** tcmcs0128m000 Harmonized System Codes **Refs:** tcibd001.ccde **Share:** yes **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs029 **Description:** Business partner types **Key:** cbtp **Session:** tcmcs0129m000 Business Partner Types **Refs:** tccom110.cbtp, tccom112.cbtp **Share:** yes **Baan:** Part of the LN business partner model. **Table:** tcmcs031 **Description:** Lines of business **Key:** cbrn **Session:** tcmcs0131m000 Lines of Business **Refs:** tdsls400.cbrn, tccom110.cbrn **Share:** yes **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs037 **Description:** Tax codes **Key:** cvat **Session:** tcmcs0137m000 Tax Codes **Refs:** tdsls401.cvat, tdisa001.cvat, cisli310.cvat **Share:** often **Baan:** LN 10.x confirmed; rates are maintained in Single Tax Rates (tcmcs0132m000) and Multiple Tax Rates (tcmcs0133m000). **Table:** tcmcs040 **Description:** Exchange rate types **Key:** rtyp **Session:** tcmcs0140m000 Exchange Rate Types **Refs:** tcmcs008.rtyp, tdsls400.ratt **Share:** yes **Baan:** LN 10.x confirmed. **Table:** tcmcs041 **Description:** Delivery terms **Key:** cdec **Session:** tcmcs0141m000 Delivery Terms **Refs:** tdsls400.cdec, tdsls401.cdec, tdsls406.cdec **Share:** yes **Baan:** Same number in Baan IV (terms of delivery). **Table:** tcmcs042 **Description:** Points of title passage **Key:** ptpa **Session:** tcmcs0142m000 Points of Title Passage **Refs:** tdsls400.ptpa, tdsls401.ptpa **Share:** yes **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs044 **Description:** Statistical groups **Key:** csgp **Session:** tcmcs0144m000 Statistical Groups **Refs:** tdisa001.csgs, tdipu001.csgp **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs045 **Description:** Areas **Key:** creg **Session:** tcmcs0145m000 Areas **Refs:** tdsls400.creg, tccom110.creg, cisli310.creg **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs046 **Description:** Languages **Key:** clan **Session:** tcmcs0146m000 Languages **Refs:** tccom100.clan, tccom001.clan, tcmcs003.clan **Share:** yes **Baan:** Same number in Baan IV. **Table:** tcmcs048 **Description:** Cost components **Key:** cpcp **Session:** tcmcs0148m000 Cost Components **Refs:** tirou002.cpcp, tccom001.cpcp **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs060 **Description:** Manufacturers **Key:** cmnf **Session:** tcmcs0160m000 Manufacturers **Refs:** tcibd001.cmnf, tdipu001.cmnf **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs061 **Description:** Product lines **Key:** cpln **Session:** tcmcs0161m000 Product Lines **Refs:** tcibd001.cpln **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs062 **Description:** Product classes **Key:** cpcl **Session:** tcmcs0162m000 Product Classes **Refs:** tcibd001.cpcl **Share:** often **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs064 **Description:** Credit ratings **Key:** crat **Session:** tcmcs0564m000 Credit Ratings **Refs:** tccom112.crat **Share:** often **Baan:** LN 10.x confirmed; holds the credit check actions per rating. **Table:** tcmcs065 **Description:** Departments **Key:** cwoc **Session:** tcmcs0565m000 Departments **Refs:** tirou001.cwoc, tccom001.cwoc **Share:** no **Baan:** Departments are site and company specific; typd sets the department type. **Table:** tcmcs066 **Description:** Channels **Key:** chan **Session:** tcmcs0166m000 Channels **Refs:** tccom110.chan, tdsls401.chan **Share:** yes **Baan:** LN 10.x confirmed; check your Baan IV dictionary. **Table:** tcmcs080 **Description:** Carriers/LSP **Key:** cfrw **Session:** tcmcs0580m000 Carriers/LSP **Refs:** tdsls400.cfrw, tccom111.cfrw, tdsls406.cfrw **Share:** often **Baan:** Same number in Baan IV. **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the list **Body:** 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 **Body:** 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. **Bullets:** - Share: units, currencies, countries, languages - Often share: item groups, terms, carriers, reasons - Usually not: warehouses, departments #### Baan IV versus LN **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### What is a general table in Infor LN? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms general table infor ln, infor ln general table maintenance, infor ln item group, tcmcs tables list, tcmcs001 units, tcmcs023 item groups, infor ln logical table sharing --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json