Table TMPSHP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPSHP | SHQ | Temporary table | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SHQ0 | IDENT+FCY+DEP+SHPNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADDQAT | Address | SLO | [SLO]SLO0=FCY;STOQAT;ADDQAT | Block | ||||
| AFC | Function | A | 15 | |||||
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | A | 8 | |||||
| CREUSR | User | AUS | [AUS]CODUSR=[SHQ]CREUSR | Other | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Other | ||||
| DLONUM | DO number | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Block | ||||
| DLVCLT | Ship to | CLT | [CLT]CLT0=FCY;DLVCLT | Block | ||||
| DLVNAM1 | Company name | NAM | ||||||
| DLVPOS | Postal code | POS | ||||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Other | ||||
| FLGCTLQAT | Stock on dock ctrl | M | 4 | 1 | ||||
| IDENT | Identifier | A | 15 | |||||
| LODCTL | Parcel load ctrl | M | 4 | 1 | ||||
| OPANUM | APO no. | OPA | [OPA]OPA0=FCY;DEP;OPANUM | Block | ||||
| PKONUM | PO no | PKP | [PKO]PKO0=FCY;DEP;PKONUM | Block | ||||
| PKZ | Preparation area | PKZ | [PKZ]PKZ0=FCY;PKZ | Block | ||||
| PMD | Picking mode | PMD | [PMD]PMD0=FCY;DEP;PMD | Block | ||||
| PRCNBR | No. of parcels | C | 4 | |||||
| SHPDTH | Depth | QTY | ||||||
| SHPHEI | Height | QTY | ||||||
| SHPNUM | Column number | A | 100 | |||||
| SHPSNGDLO | Single DO SU | M | 4 | 1 | ||||
| SHPSNGDLV | Single consignee SU | M | 4 | 1 | ||||
| SHPSTA | Status | M | 15 | 368 | ||||
| SHPTHEWEI | Estimated weight | QTY | ||||||
| SHPVOL | Volume | QTY | ||||||
| SHPWEI | Weight | QTY | ||||||
| SHPWID | Width | QTY | ||||||
| SHU | SU type | SHU | [SHU]SHU0=FCY;SHU | Block | ||||
| SSCCOD | SU SSCC code | A | 18 | |||||
| STAQAT | Stock on dock status | M | 15 | 430 | ||||
| STOQAT | Store | STO | [STO]STO0=FCY;STOQAT | Block | ||||
| TAR | Weight | QTY | ||||||
| TYPCRE | Creation type | M | 15 | 442 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Valid operator | A | 5 | |||||
| VLDOPE | Valid operator | OPE | [OPE]OPE0=FCY;VLDOPE | Other | ||||
| WAVNUM | Wave no | VAC | [VAC]VAC0=FCY;DEP;WAVNUM | Block |