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 |