Import/export template > Module Manufacturing > Import/export template MESMKI (Production reporting import)
 |
 |
Production reporting import
Use this template to extract production tracking data. You can use it to import work order or material tracking data from any third party product into Sage X3 and to export from Sage X3.
Imported data is converted into the right format to populate the work order header information (function Work order (GESMFG)). Product, quantity and fields associated with products such as stock units on the following tabs are also populated:
- Header
- Components
Mandatory fields in the template
The mandatory fields are as follows:
Table MFGITMTRK – Manufacturing tracking - products
- Production site (MFGFCY)
- Order number (MFGNUM)
- Product (ITMREF)
- Actual quantity (UOMCPLQTY)
- Release unit (UOM)
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
| Table |
Table description |
|---|---|
|
MFGHEADTRK [MTK] |
|
|
MFGITMTRK [MKI] |
|
|
STOJOU [STJ] |
Stock journal |