Table MFGMAT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MFGMAT | MFM | Work order - materials | Manufacturing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MFM0 | MFGNUM+MFGLIN+BOMSEQ+ITMREF | No | |
| MFM1 | MFGFCY+RETDAT | Yes | |
| MFM2 | MFGFCY+MFGPIO+RETDAT | Yes | |
| MFM3 | MFGNUM+BOMOPE+ITMREF | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLQTY | Allocated quantity | QTY | ||||||
| ALLSTA | Allocation status | M | 15 | 340 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BASQTY | Base quantity | QTY | ||||||
| BOMOFS | Operation lead time | C | 4 | |||||
| BOMOPE | Operation number | OPE | ||||||
| BOMQTY | UOM link quantity | QTY | ||||||
| BOMSEQ | BOM sequence | C | 4 | |||||
| BOMSEQORI | Source sequence | C | 4 | MWM | ||||
| BOMSHO | Link description | DES | ||||||
| BOMSTUCOE | UOM-STK factor | COE | ||||||
| BOMUOM | UOM | UOM | [TUN]TUN0=[MFM]BOMUOM | Block | ||||
| CPNTYP | Component type | M | 15 | 438 | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTN | Master container | A | 8 | MWC | ||||
| CUMFLG | Cumulated requirement | M | 4 | 1 | ||||
| CUMFXDQTY | Cumul total qty | QTY | ||||||
| DEFPOT | Default potency % | DCB | 5.4 | |||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| ISSMGTCOD | Stock issuing method | M | 15 | 724 | ||||
| ITMREF | Product | ITM | [ITM]ITM0=[MFM]ITMREF | Block | ||||
| LIKQTY | Link quantity | QTY | ||||||
| LIKQTYCOD | Link quantity code | M | 15 | 226 | ||||
| LOC | Location | LOC | [STC]STC0=MFGFCY;LOC | Other | ||||
| LOT | Preferred lot | LOT | ||||||
| MATSTA | Material status | M | 15 | 363 | ||||
| MFGFCY | Production site | FCY | [FCY]FCY0=[MFM]MFGFCY | Block | ||||
| MFGLIN | Line no. | L | 8 | |||||
| MFGNUM | Order no. | VCR | ||||||
| MFGPIO | Priority | M | 2 | 365 | ||||
| MFGSTA | Order status | M | 10 | 317 | ||||
| MFMTEX | Link text | TXC | ||||||
| MFMTRKFLG | Tracking flag | M | 15 | 339 | ||||
| PICPRN | Mat. slip printing | M | 4 | 1 | ||||
| PKC | Pick list code | M | 15 | 2328 | MWM | |||
| PLANNER | Planner | AUS | [AUS]CODUSR=[MFM]PLANNER | Block | ||||
| PLNFCY | Planning site | FCY | [FCY]FCY0=[MFM]PLNFCY | Block | ||||
| PRPSTA | Picking status | M | 15 | 338 | ||||
| QTYCOD | Management unit | M | 15 | 225 | ||||
| QTYRND | Quantity rounding | M | 15 | 293 | ||||
| RELSCATIA | Shrink with release | M | 4 | 1 | ||||
| RETDAT | Requirement date | D | ||||||
| RETQTY | Requirement quantity | QTY | ||||||
| RETQTYORI | Source quantity | QTY | MWM | |||||
| SCA | Scrap factor % | DCB | 3.3 | |||||
| SCOFLG | Type of supply | M | 30 | 2225 | ||||
| SHTQTY | Shortage | QTY | ||||||
| STA | Preferential status | A | 12 | |||||
| STDQTY | Standard quantity | QTY | ||||||
| STOMGTCOD | Stock management | M | 15 | 215 | ||||
| STU | Stock unit | UOM | [TUN]TUN0=[MFM]STU | Block | ||||
| TRKFIRST | First tracking date | D | ||||||
| TRKFIRSTC | First tracking date | D | ||||||
| TRKLAST | Last tracking date | D | ||||||
| TRKLASTC | Last tracking date | D | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| USEQTY | Consumed quantity | QTY | ||||||
| WGGBOX | Weighing... | M | 4 | 1 | MWM | |||
| WGGSTA | Weighing situation | M | 15 | 2322 | MWM | |||
| WGGSTAAVS | Weighing situation before completion | M | 15 | 2322 | MWM | |||
| WIPNUM | Order no. | VCR |