Table PREQUISO
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PREQUISO | PSO | Link purchase requests | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PSO0 | PSHNUM+PSDLIN+POHNUM+POPLIN+POQSEQ | No | |
| PSO1 | POHNUM+POPLIN+POQSEQ+PSHNUM+PSDLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PSO]CREUSR | Other | ||||
| POHNUM | Order no. | VCR | ||||||
| POPLIN | Line | L | 8 | |||||
| POQSEQ | Sequence number | L | 8 | |||||
| PSDLIN | Line | L | 8 | |||||
| PSHNUM | Request no. | VCR | ||||||
| PUU | Purchase unit | UOM | [TUN]TUN0=[PSO]PUU | Block | ||||
| QTYPUU | PUR quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| STU | Stock unit | UOM | [TUN]TUN0=[PSO]STU | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PSO]UPDUSR | Other |