Table ORDERS
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| ORDERS | ORD | WIP | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ORD0 | WIPTYP+WIPNUM+ITMREF | No | |
| ORD1 | STOFCY+ITMREF+ENDDAT | Yes | |
| ORD2 | ITMREF+ENDDAT | Yes | |
| ORD3 | STOFCY+VCRTYP+VCRNUM+VCRLIN+VCRSEQ | Yes | |
| ORD4 | ITMREF+STOFCY+WIPTYP | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABBFIL | File abbreviation | A | 3 | |||||
| ALLQTY | Allocated qty. | QTY | ||||||
| ATECORI | Source | M | 15 | 7885 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BOMALT | BOM code | TBO | [TBO]TBO0=BOMALTTYP;BOMALT | RTZ | ||||
| BOMALTTYP | BOM type | M | 15 | 224 | ||||
| BOMOFS | Operation lead time | C | 4 | |||||
| BOMOPE | Operation number | OPE | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[ORD]BPRNUM | RTZ | ||||
| CCMRID | Request ID | CCMCRID | CCM | |||||
| CCMSTA | Request status | M | 20 | 2044 | CCM | |||
| CPLQTY | Total completed qty. | QTY | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| ENDDAT | End date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| EXTQTY | Planned qty. | QTY | ||||||
| FMI | Product source | M | 20 | 445 | ||||
| GFSPUBTIM | Optimized datetime | ADATIM | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=ITMREF | Block | ||||
| ITMREFORI | Source product | ITM | [ITM]ITM0=[ORD]ITMREFORI | Other | ||||
| MRPDAT | MRP date | D | ||||||
| MRPMES | MRP message | M | 15 | 318 | ||||
| MRPQTY | MRP qty. | QTY | ||||||
| MTOQTY | Assigned qty. | QTY | ||||||
| MTOREF | MTO network | MTO | [MTO]MTO0=MTOREF | RTZ | ||||
| OPTFLG | Optimization flag | M | 4 | 1 | ||||
| ORI | Source | M | 15 | 298 | ||||
| ORIFCY | Original site | FCY | [FCY]FCY0=[ORD]ORIFCY | Block | ||||
| PIO | Priority | M | 15 | 410 | ||||
| PJT | Project | PJT | [PIM]PIM0=[ORD]PJT | Block | ||||
| RMNEXTQTY | Remaining qty. | QTY | ||||||
| SHTQTY | Shortage | QTY | ||||||
| STOFCY | Stock site | FCY | [FCY]FCY0=[ORD]STOFCY | Block | ||||
| STRDAT | Start date | D | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUM | Subcon. req./order | VCR | ||||||
| VCRNUMORI | Original document | VCR | ||||||
| VCRSEQ | Document sequence no. | L | 8 | |||||
| VCRSEQORI | Source seq. | L | 8 | |||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| VCRTYPORI | Source document type | M | 15 | 701 | ||||
| WIPNUM | Order no. | VCR | ||||||
| WIPSTA | WIP status | M | 15 | 317 | ||||
| WIPTYP | Order type | M | 15 | 306 |