Table PICKORDER
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PICKORDER | PKO | Picking orders | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PKO0 | FCY+DEP+PKONUM | No | |
| PKO1 | FCY+DEP+WAVNUM+PKONUM | No | |
| PKO2 | FCY+DEP+WAVNUM+PMD+PKZ+PKONUM | No |
| 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 | |||||
| CTSCOD | Sort code | CTS | [CTS]CTS0=FCY;CTSCOD | Other | ||||
| DAT | Date | D | ||||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DLONUM | DO no | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Block | ||||
| DLVCLT | Ship to | CLT | [CLT]CLT0=FCY;DLVCLT | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| HISPTR | Archive | L | 8 | |||||
| KIT | PO kit | M | 4 | 1 | ||||
| LVL | Level | M | 15 | 311 | ||||
| PKONUM | PO no | PKP | [PKO]PKO0=FCY;DEP;PKONUM | Delete | ||||
| PKOSTA | Status | M | 15 | 363 | ||||
| PKZ | Preparation area | PKZ | [PKZ]PKZ0=FCY;PKZ | Block | ||||
| PMD | Picking mode | PMD | [PMD]PMD0=FCY;DEP;PMD | Delete | ||||
| QYMNUM | Round no. | DRN | [QYM]QYM0=FCY;2;QYMNUM | RTZ | ||||
| SUBNUM | Wave Sub No. | C | 4 | |||||
| TIM | Time | HM | ||||||
| TOTCUQ | Total CUs | QTA | ||||||
| TOTMVT | Movements | C | 4 | |||||
| TOTPRC | No of parcels | C | 4 | |||||
| TOTSHP | No SU | C | 4 | |||||
| TOTSUR | Surface equivalent | QTY | ||||||
| TOTTIM | Preparation time | QTY | ||||||
| TOTVOL | Total volume | QTY | ||||||
| TOTWEI | Total weight | QTY | ||||||
| TYP | PO type | M | 15 | 388 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PKO]UPDUSR | Other | ||||
| VLDDAT | Posting date | D | ||||||
| VLDDAT2 | Posting date | D | ||||||
| VLDOPE | Valid operator | OPE | [OPE]OPE0=FCY;VLDOPE | Other | ||||
| VLDTIM | Posting time | L | 8 | |||||
| VLDUSR | Valid operator | A | 5 | |||||
| WAVNUM | Wave no | VAC | [VAC]VAC0=FCY;DEP;WAVNUM | Block |