Table MTOLINK
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
MTOLINK | MLK | Demand/resource assignments | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
MLK0 | STOFCY+ITMREF+DEMTYP+DEMNUM+DEMLIN+DEMSEQ | Yes | |
MLK1 | STOFCY+ITMREF+RESSTYP+RESSNUM+RESSLIN+RESSSEQ | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
DEMLIN | Demand line | L | 8 | |||||
DEMNUM | Demand journal | VCR | ||||||
DEMSEQ | Demand sequence | L | 8 | |||||
DEMTYP | Request type | M | 15 | 701 | ||||
DWIPSTA | Order status | M | 10 | 317 | ||||
DWIPTYP | Order type | M | 15 | 306 | ||||
EXPNUM | Export number | L | 8 | |||||
FMIFLG | Back-to-back order | M | 4 | 1 | ||||
FRCFLG | Forced | M | 4 | 1 | ||||
ITMREF | Product | ITF | [ITF]ITF0=ITMREF;STOFCY | Block | ||||
LIKQTY | Quantity assigned | QTY | ||||||
MTOREF | MTO network | MTO | [MTO]MTO0=MTOREF | RTZ | ||||
RESSLIN | Resouce line | L | 8 | |||||
RESSNUM | Resource document | VCR | ||||||
RESSSEQ | Resource sequence | L | 8 | |||||
RESSTYP | Resource type | M | 15 | 701 | ||||
RWIPSTA | Order status | M | 10 | 317 | ||||
RWIPTYP | Order type | M | 15 | 306 | ||||
STOFCY | Storage site | FCY | [FCY]FCY0=[MLK]STOFCY | Other | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |