Infor LN & BaanFree referencePDF, Excel, Word exportInfor LNAll Infor LN and Baan tools

Infor LN Production Tables Reference: tisfc001, tibom010, tirou102 and Related

This reference maps the LN 10.x Manufacturing tables that shop floor reports and MES interfaces read: production orders, operations, estimated and actual material and hours, BOM lines, routings, work centers, machines and tasks. Each row gives keys, the columns you need and the join path.

Download:

Table	Description	Key fields	Important columns	Join to	Session	Notes
tisfc001	Production orders	pdno	mitm item, qrdr quantity ordered, qdlv quantity delivered, qrjc scrapped, osta order status, prdt production start, pldt planned delivery date, cwar warehouse, opro routing, site	tisfc001.mitm = tcibd001.item	tisfc0501m000 Production Orders	For osta values and their meaning see the production order status reference.
tisfc010	Production order operations (production planning)	pdno, opno	opst operation status, cwoc work center, mcno machine, tano task, sutm average setup time, rutm cycle time, prte production rate, most man occupation for setup, mopr man occupation for production, mcoc machine occupation, qbfd done, qtbf to do, qrjc scrapped, cmdt completion date	tisfc010.pdno = tisfc001.pdno; tisfc010.cwoc = tirou001.cwoc	tisfc0110m000 Production Planning; tisfc0130m000 Report Operations Completed	Copied from tirou102 when the order is created, then updated by reporting.
ticst001	Estimated and actual material costs	pdno, pono	sitm item, opno operation, cwar warehouse, ques estimated quantity, qucs actual quantity, cpes estimated unit cost, cpcs actual standard cost, bfls backflushing, clot lot	ticst001.pdno = tisfc001.pdno; ticst001.sitm = tcibd001.item	ticst0101m000 Estimated Materials; ticst0501m000 Estimated vs. Actual Material Costs	Material list of the order, copied from the BOM.
ticst002	Estimated and actual hours	pdno, opno	cwoc work center, cowc costing work center, tano reference operation, qpln quantity planned, awgc actual labor costs, amcc actual machine costs, aohc actual overhead costs, ascc actual subcontracting costs	ticst002.pdno, opno = tisfc010.pdno, opno	ticst0502m000 Estimated vs. Actual Hours Costs	Aggregated hour costs per operation for variance reports.
bptmm120	Production order hours (hours accounting)	emno, year, peri and a line number (check the index in your dictionary)	emno employee, orno production order, opno operation, tano task, mcno machine, hrma machine time, stup setup time, perc percentage completed, trdt transaction date, proc processed	bptmm120.orno = tisfc001.pdno	bptmm1120m000 Production Order Hours	Hours accounting lives in the People (bp) package; processed hours feed ticst002.
tibom010	Bill of material lines	mitm, pono, seqn	sitm component item, qana net quantity, opno operation, cwar warehouse, indt effective date, exdt expiry date, scpf scrap percentage, scpq scrap quantity, cpha phantom	tibom010.mitm = tcibd001.item (parent); tibom010.sitm = tcibd001.item (component)	tibom1110m000 Bill of Material	Use indt and exdt to select the lines valid on a date.
tirou101	Item routings (routing codes by item)	mitm, opro	opro routing, stor standard routing, strc standard routing code, runi routing unit, ruoq up to quantity	tirou101.mitm = tcibd001.item; tisfc001.opro = tirou101.opro	tirou1101m000 Item - Routings	An item can have several routings, chosen by quantity or by default.
tirou102	Routing operations	mitm, opro, opno, seqn	tano task, cwoc work center, mcno machine, nopr next operation, sutm setup time (min), rutm cycle time (min), prte production rate, most man occupation for setup, mopr man occupation for production, mcoc machine occupation, qutm queue time, mvtm move time, indt/exdt effective and expiry dates	tirou102.mitm, opro = tirou101.mitm, opro; tirou102.cwoc = tirou001.cwoc	tirou1102m000 Routing Operations	Run time per unit is cycle time divided by production rate when the rate is not 1.
tirou001	Work centers	cwoc	kowc work center type, mnwc parent work center, nomc number of machines, noop available labor resources, wcru week capacity, dcru basic day capacity, qutm queue time, mvtm move time, wipw shop floor warehouse	tisfc010.cwoc = tirou001.cwoc	tirou0101m000 Work Centers	Work centers are also departments in tcmcs065.
tirou002	Machines (machine types)	mcno	cwoc work center, mcrt machine rate, cpcp cost component, mccp week capacity, mdcp basic day capacity, site	tirou102.mcno = tirou002.mcno	tirou0102m000 Machines (Machine Types)	Machine rate and cost component drive machine cost in ticst002.
tirou003	Tasks (reference operations)	tano	dsca description, cwoc default work center, mcno default machine, mlwc work center selection method, mlmc machine selection method	tirou102.tano = tirou003.tano	tirou0103m000 Tasks (Reference Operations)	Defaults are copied into routing operations.
tiipd001	Item - production	item	cpha phantom, scpf scrap percentage, runi routing unit, bfep backflush materials, bfhr backflush hours, rgrp routing group, sfpl shop floor planner	tiipd001.item = tcibd001.item	tiipd0101m000 Item - Production	Backflush flags default into production orders (tisfc001.bfep, bfhr).
tcibd001	Items - general	item	dsca description, kitm item type, citg item group, cuni inventory unit	tisfc001.mitm, tibom010.sitm, ticst001.sitm = tcibd001.item	tcibd0501m000 Items	Use it for descriptions and units in every production report.
tcmcs065	Departments	cwoc	typd department type, site, comp financial company, emno manager	tirou001.cwoc = tcmcs065.cwoc	tcmcs0565m000 Departments	A work center is a department of type work center.
tcmcs048	Cost components	cpcp	cpus component type, cref cost type, fxvc fixed or variable, dinc direct or indirect	tirou002.cpcp = tcmcs048.cpcp	tcmcs0148m000 Cost Components	Groups labor, machine, material and overhead costs in cost reports.

Physical names add t and the company number (ttisfc001100). SQL columns use t_ on SQL Server and t$ on Oracle. Tables and fields were checked against the LN 10.x online help for the sessions listed. Status fields (osta, opst) are enumerations; read their meaning from the domain, and see the production order status reference for the order lifecycle.

Want a work center load query for your LN plant?

Share your LN release and time units and we will review a tisfc010 load query against your routings.

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

Was this tool useful?

From master data to a production order

Master data sits in tibom010 (BOM lines keyed by parent item mitm, position and sequence), tirou101 (routings per item) and tirou102 (routing operations with task, work center, machine and times). When a production order is created in tisfc001, LN copies the operations into tisfc010 and the material into ticst001. Reporting operations and hours updates tisfc010 and bptmm120, and costing aggregates into ticst002. Report Orders Completed then raises tisfc001.qdlv. Because the order holds copies, a later change to the BOM or routing does not change open orders.

Master: tibom010, tirou101, tirou102, tirou001, tirou002, tirou003
Order: tisfc001, tisfc010, ticst001
Actuals: bptmm120, ticst002

Worked example: operation load per work center

Select open operations from tisfc010 where opst is not completed, join tisfc001 on pdno for the order quantity and status, and group by cwoc. For each operation, remaining run time is roughly the to-do quantity times cycle time divided by production rate, plus setup time if setup is not done. Multiply by man or machine occupation to get labor or machine hours. Join tirou001 on cwoc for week capacity wcru to compare load against capacity. Use the time unit fields on the tables, since times may be stored in minutes.

Gotchas

tibom010 and tirou102 carry effective and expiry dates, so a BOM explosion without a date filter returns old and new lines together. Phantoms (cpha) are exploded into the parent order, so a phantom item never gets its own production order, and its components appear directly in the parent order material in ticst001. Hours live in the bp package (bptmm120), not in ti, which surprises people porting Baan IV reports. Do not repeat status text in reports: osta and opst are enumerations whose labels come from the domain in your language.

How to check the result in LN

Compare your query with the sessions. For one order, the operations in your result should match Production Planning (tisfc0110m000), the material should match Estimated Materials (ticst0101m000) and the cost totals should match Estimated vs. Actual Material Costs (ticst0501m000) and Estimated vs. Actual Hours Costs (ticst0502m000). Field help in each session shows the table and field behind a value. If a number differs, check the time unit, the routing unit and whether hours accounting has been processed, because unprocessed bptmm120 lines are not yet in ticst002.

Frequently Asked Questions

Is there an Infor LN data dictionary for manufacturing tables?

The authoritative dictionary is the one in your own LN environment, where each table definition lists fields, domains and indexes. Field help in each session shows the table and field behind a field. This page summarizes the standard LN 10.x production tables so you know where to look first.

Which table holds production order operations in LN?

tisfc010, keyed by production order pdno and operation opno. It holds the operation status, work center, machine, task, setup and cycle times, production rate, man and machine occupation and the done, to-do and scrapped quantities. Sessions Production Planning (tisfc0110m000) and Report Operations Completed (tisfc0130m000) show it.

Where are routing setup and cycle times stored?

In tirou102 Routing Operations (tirou1102m000): sutm is setup time and rutm is cycle time, with prte production rate, most and mopr man occupation for setup and production, and mcoc machine occupation. They are copied into tisfc010 when an order is created.

What is the difference between ticst001 and tibom010?

tibom010 is the master bill of material for an item. ticst001 is the material list of one production order, copied from the BOM at order creation and then updated with actual issued quantities and costs. Reports on what an order used should read ticst001, not the BOM.

If planners want to ask LN which orders are late or which work centers are overloaded in plain English on your own servers, we can add a read-only AI layer over these tables.

Talk to an Expert Explore More Free Tools