Table TMPMAP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPMAP | TMA | Pick dyn temporary tables | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TMA0 | UID+TYP+STO+SLO | Yes | |
| TMA1 | UID+TYP+DEP+ITM | Yes | |
| TMA2 | UID+TYP+ORN | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CLS | Class | A | 1 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[TMA]CREUSR | Other | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Other | ||||
| ITM | Product | ITM | [ITM]ITM0=FCY;DEP;ITM | Other | ||||
| NBR | Number | L | 8 | |||||
| ORN | Sequence | C | 3 | |||||
| SLO | Location | SLO | [SLO]SLO0=FCY;STO;SLO | Other | ||||
| STO | Store | STO | [STO]STO0=FCY;STO | Other | ||||
| TYP | Code | A | 1 | |||||
| UID | Identifier | C | 4 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[TMA]UPDUSR | Other |