Table TMPQAT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPQAT | TMQ | Temporary table dock loc. | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TMQ0 | IDENT+FCY+QATNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADDQAT | Address | SLO | [SLO]SLO0=FCY;STOQAT;ADDQAT | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[TMQ]CREUSR | Other | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DLONUM | DO number | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Delete | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| IDENT | Identifier | A | 15 | |||||
| NBR1 | No. of parcels | L | 8 | |||||
| NBR2 | Nb on-dock | L | 8 | |||||
| NBR3 | Nb pending transfer | L | 8 | |||||
| PRCNUM | Parcel no. | PRC | [PAC]PAC0=FCY;DEP;PRCNUM | Delete | ||||
| PRCSTA | Status | M | 15 | 358 | ||||
| QATNUM | Column number | A | 40 | |||||
| QYMNUM | Round no. | DRN | [QYM]QYM0=FCY;2;QYMNUM | RTZ | ||||
| SHPNUM | SU no | SHP | [SHP]SHP0=FCY;DEP;SHPNUM | RTZ | ||||
| STAQAT | Stock on dock status | M | 15 | 430 | ||||
| STOQAT | Store | STO | [STO]STO0=FCY;STOQAT | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[TMQ]UPDUSR | Other |