Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
TMPPRC | PRQ | Temporary parcel mvt table | Geode GX |
Key | Description | Duplicates | Activity code |
---|---|---|---|
TRQ0 | IDENT+FCY+DEP+QATNUM | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ADDQAT | Address | SLO | [SLO]SLO0=FCY;STOQAT;ADDQAT | Other | ||||
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=[PRQ]CREUSR | Other | ||||
DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Other | ||||
DLONUM | DO number | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Other | ||||
FCY | Site | FCY | [FCY]FCY0=FCY | Other | ||||
IDENT | Identifier | A | 15 | |||||
PRCACT | Parcel action | M | 15 | 434 | ||||
PRCNUM | Parcel no. | PRC | [PAC]PAC0=FCY;DEP;PRCNUM | Other | ||||
PRCSTA | Status | M | 15 | 358 | ||||
QATNUM | Column number | A | 100 | |||||
SHPNUM | SU no | SHP | [SHP]SHP0=FCY;DEP;SHPNUM | Other | ||||
STAQAT | Stock on dock status | M | 15 | 430 | ||||
STOQAT | Store | STO | [STO]STO0=FCY;STOQAT | Other | ||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Valid operator | A | 5 | |||||
VLDOPE | Valid operator | OPE | [OPE]OPE0=FCY;VLDOPE | Other |