Table STOPRED
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOPRED | PRE | Pick ticket detail | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PRE0 | PRHNUM+PRELIN | No | |
| PRE1 | ORINUM+ORILIN+ORISEQ | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLQTY | Allocated qty. | QTY | ||||||
| ALLTYP | Allocation type | M | 15 | 294 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| EXPNUM | Export number | L | 8 | |||||
| FLGANN | Cancelled line | C | 4 | |||||
| FLGVT | VT picked line | C | 4 | |||||
| ITMDES1 | Description 1 | DES | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[PRE]ITMREF | Block | ||||
| LINTYP | Line type | M | 15 | 423 | ||||
| LOCDES | Target location | EMP | ||||||
| LOCTYPDES | Dstn. loc. type | TEM | ||||||
| OALQTYSTU | Order qty alloc. STU | QTY | ||||||
| ORILIN | Line no. | L | 8 | |||||
| ORINUM | Document no. | VCR | ||||||
| ORISEQ | Sequence no. | L | 8 | |||||
| ORITYP | Source | M | 20 | 2747 | ||||
| ORITYPSCO | Sub-contract type | C | 4 | |||||
| PACQTYSTU | Qty packed SAL | QTY | ||||||
| PCK | Packaging | PCK | [TPA]TPA0=[PRE]PCK | Block | ||||
| PCKCAP | Packaging capacity | COE | ||||||
| PCKFLG | Packing | M | 4 | 1 | ||||
| PCU | Packing unit | UOM | [TUN]TUN0=[PRE]PCU | Block | ||||
| PCUSTUCOE | PAC-STK conv. | COE | ||||||
| PRELIN | Preparation line | L | 8 | |||||
| PRHNUM | Pick ticket | VCR | ||||||
| PRPTEX | Picking ticket line text | TXC | ||||||
| QTYSTU | Qty. prepared | QTY | ||||||
| REOLOC | Subcontract loc. | EMP | ||||||
| SEQ | Allocation sequence | L | 8 | |||||
| SHTQTY | Shortage | QTY | ||||||
| STOMGTCOD | Stock management | M | 15 | 215 | ||||
| STU | Stock unit | UOM | [TUN]TUN0=[PRE]STU | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |