Table PREQUIS
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PREQUIS | PSH | Purchase requests | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PSH0 | PSHNUM | No | |
| PSH1 | PSHFCY+PSHNUM | No | |
| PSH2 | PRQDAT+PSHNUM | No | |
| PSH3 | PSHNUMMMS+PSHNUM | No | MMS |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| APPFLG | Signed | M | 15 | 280 | ||||
| APPLINNBR | No. of signed lines | C | 4 | |||||
| ATECORI | Source | M | 15 | 7885 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CLEFLG | Closed | M | 4 | 1 | ||||
| CLELINNBR | No. closed lines | C | 4 | |||||
| CPY | Company | CPY | [CPY]CPY0=[PSH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[PSH]DIE | Block | ANA | |||
| EXPNUM | Export number | L | 8 | |||||
| FBULINNBR | No. lines > budg | C | 4 | |||||
| LINNBR | Number of lines | C | 4 | |||||
| MMSURL | Maintenance URL | A | 250 | |||||
| ORDFLG | Ordered | M | 4 | 1 | ||||
| ORDLINNBR | No. of order lines | C | 4 | |||||
| PJTH | Project | PJT | [PIM]PIM0=PJTH | Block | ||||
| PRNFLG | Printed | M | 4 | 1 | ||||
| PRQDAT | Request date | D | ||||||
| PSHFCY | Request site | FCY | [FCY]FCY0=[PSH]PSHFCY | Block | ||||
| PSHNUM | Request no. | VCR | ||||||
| PSHNUMMMS | Maintenance no. | A | 15 | |||||
| REQUSR | Requester | AUS | [AUS]CODUSR=[PSH]REQUSR | Block | ||||
| TEX1 | Text | TXC | ||||||
| TEX2 | Text | TXC | ||||||
| TOTPRQ | Request total -tax | MD1 | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |