Table MFGMATREV
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
MFGMATREV | MMR | Work order - materials audit | Manufacturing |
Key | Description | Duplicates | Activity code |
---|---|---|---|
MFM0 | MFGNUM+MFGLIN+BOMSEQ+ITMREF+REVNUM | 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=[MMR]BOMUOM | Block | ||||
CPNTYP | Component type | M | 15 | 438 | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
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=[MMR]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=[MMR]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=[MMR]PLANNER | Block | ||||
PLNFCY | Planning site | FCY | [FCY]FCY0=[MMR]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 | |||||
REVCOD | Revision code | M | 1 | 2072 | ||||
REVNUM | Revision no. | C | 4 | |||||
REVREASON | Revision reason | A | 50 | |||||
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=[MMR]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 |