# Epicor PartTran Transaction Types: STK-MTL, PUR-STK, MFG-STK and More > Source: https://netray.co/tools/epicor-part-transaction-types-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Decode the TranType codes in Epicor's PartTran table so inventory audits and cost reconciliations stop being guesswork. ## Category epicor ## Erp Epicor Kinetic ## Industry Discrete Manufacturing ## Audience - Epicor admin - Inventory controller - Cost accountant ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### TranType **Key:** code **Type:** text #### From **Key:** from **Type:** text #### To **Key:** to **Type:** text #### Meaning **Key:** meaning **Type:** text #### Typically created by **Key:** typical **Type:** text **Rows:** **Code:** STK-STK **From:** Stock **To:** Stock **Meaning:** Inventory transfer between bins or warehouses **Typical:** Inventory Transfer, Warehouse Transfer **Code:** STK-MTL **From:** Stock **To:** Job material **Meaning:** Material issued from stock to a job **Typical:** Issue Material, backflush on labor **Code:** MTL-STK **From:** Job material **To:** Stock **Meaning:** Unused job material returned to stock **Typical:** Return Material **Code:** PUR-STK **From:** Purchase **To:** Stock **Meaning:** Purchase receipt put directly into stock **Typical:** Receive Purchase Order **Code:** PUR-MTL **From:** Purchase **To:** Job material **Meaning:** Purchase receipt sent straight to a job (direct) **Typical:** Receive Purchase Order with job destination **Code:** PUR-INS **From:** Purchase **To:** Inspection **Meaning:** Purchase receipt held for inspection **Typical:** Receive Purchase Order for inspected parts **Code:** PUR-UKN **From:** Purchase **To:** Unknown **Meaning:** Receipt where cost is recorded but destination is not fixed yet **Typical:** Receipt entry and later matching **Code:** MFG-STK **From:** Manufacturing **To:** Stock **Meaning:** Finished quantity from a job received into stock **Typical:** Receipt to Inventory from job **Code:** MFG-INS **From:** Manufacturing **To:** Inspection **Meaning:** Job completion sent to inspection **Typical:** Job receipt for inspected parts **Code:** MFG-CUS **From:** Manufacturing **To:** Customer **Meaning:** Job output shipped directly to the customer **Typical:** Customer Shipment from a job **Code:** STK-CUS **From:** Stock **To:** Customer **Meaning:** Shipment of stock to a customer **Typical:** Customer Shipment Entry **Code:** STK-INS **From:** Stock **To:** Inspection **Meaning:** Stock moved into inspection **Typical:** Inspection processing **Code:** INS-STK **From:** Inspection **To:** Stock **Meaning:** Passed inspection quantity moved to stock **Typical:** Inspection Processing **Code:** INS-MTL **From:** Inspection **To:** Job material **Meaning:** Passed inspection quantity sent to a job **Typical:** Inspection Processing with job destination **Code:** INS-DMR **From:** Inspection **To:** Discrepant material **Meaning:** Failed quantity sent to a discrepant material record **Typical:** Inspection Processing with reject **Code:** DMR-STK **From:** Discrepant material **To:** Stock **Meaning:** Disposition of a DMR as use as is or rework back to stock **Typical:** Material Review Disposition **Code:** ADJ-QTY **From:** Adjustment **To:** Stock **Meaning:** Quantity adjustment from a count or manual correction **Typical:** Inventory Quantity Adjustment **Notes:** The table lists the common standard codes. Your release may add or label codes differently, so run SELECT DISTINCT TranType FROM Erp.PartTran in a BAQ to see what your company actually uses before building reports on this list. ## Content **Intro:** Every inventory movement in Epicor writes a row to PartTran with a TranType such as STK-MTL or PUR-STK. The code reads as from-to, but it is easy to forget. This lookup explains each common code in plain language. **Sections:** #### How to read a TranType **Body:** A TranType has two three-letter parts separated by a hyphen. The first part is where quantity came from and the second is where it went. STK is stock, MTL is job material, MFG is manufacturing output of a job, PUR is a purchase receipt, INS is inspection, CUS is a customer, and DMR is discrepant material. So STK-MTL is stock issued to a job and MTL-STK is the return of unused material. Once you know the vocabulary, most codes decode themselves. #### Using the codes in BAQs and audits **Body:** Filter PartTran by TranType and a date range to answer common questions: what was issued to jobs this week (STK-MTL minus MTL-STK), what the receiving dock put away (PUR-STK plus PUR-MTL), and what finished production received (MFG-STK). Always filter by TranDate because PartTran is one of the largest tables in the database and an unfiltered scan is slow. **Bullets:** - Net issues to a job: STK-MTL minus MTL-STK - Receipts by day: PUR-STK, PUR-MTL, PUR-INS - Production output: MFG-STK, MFG-INS, MFG-CUS - Cycle count variances: ADJ-QTY #### Common mistakes **Body:** People often sum quantities across all types and get nonsense because transfers appear as a single row that is neither a gain nor a loss. Another mistake is ignoring that direct-to-job receipts (PUR-MTL) never touch stock, so a stock reconciliation that only counts PUR-STK will not agree with purchasing. Finally, cost columns on PartTran reflect the cost method of that moment, so compare cost to GL postings using the posting date rather than recalculating. **Cta:** Netray can add a read-only question layer over PartTran so planners and controllers can ask for issues, receipts and adjustments by job or part and see the SQL behind each answer. **Faq:** #### What does STK-MTL mean in Epicor? **Answer:** STK-MTL is material moved from stock to a job's material line, which is a job issue. It reduces on-hand quantity and adds to the job's issued quantity and cost. The reverse movement is MTL-STK, the return of unused material to stock. #### Where do I see all TranTypes my system uses? **Answer:** Run a BAQ or SQL query with SELECT DISTINCT TranType from Erp.PartTran. That lists exactly the codes present in your data and avoids guessing, since add-ons and configuration can introduce additional types. #### Why do receipts to a job not show in stock? **Answer:** Direct receipts to a job use PUR-MTL, which never lands in a bin. The material is charged to the job immediately. Stock-based reports will miss it, so include PUR-MTL when reconciling purchasing receipts. #### Is PartTran safe to query often? **Answer:** Query it with a TranDate range and a PartNum or JobNum filter. Large unfiltered queries over years of transactions are slow and can hurt other users, so schedule heavy analysis off peak. ## Search terms epicor parttran trantype, epicor STK-MTL, epicor MFG-STK meaning, epicor inventory transaction types, epicor PUR-STK, epicor part transaction history codes, epicor trantype list --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json