Table STOQUAL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOQUAL | STQ | Quality control | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STQ0 | QLYCTLDEM | No | |
| STQ1 | ITMREF+LOT+QLYCTLDEM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AAAORIQTY | Original accepted qty | QTY | ||||||
| AAAQTY | Accepted qty. | QTY | ||||||
| ACT | IU potency | DCB | 5.4 | |||||
| ACTFLG | IU control potency | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[STQ]BPRNUM | Block | ||||
| CRDFLG | Tracking record | M | 4 | 1 | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| ENDCTLDAT | Control end date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| EXYFLG | Expiration controlled | M | 4 | 1 | ||||
| ITMREF | Product | ITM | [ITM]ITM0=[STQ]ITMREF | Block | ||||
| LOT | Lot | LOT | ||||||
| MVTDES | Movement description | DES | ||||||
| MVTSEQ | Sequence | C | 4 | |||||
| PJT | Project | PJT | [PIM]PIM0=[STQ]PJT | Block | ||||
| POT | Potency | DCB | 5.4 | |||||
| POTFLG | Potency controlled | M | 4 | 1 | ||||
| PRNFLG | Printed document | M | 4 | 1 | ||||
| QLYCRD | Technical sheet | QLC | [QLC]QLC0=[STQ]QLYCRD | BSRA | ||||
| QLYCTLDEM | Analysis request | VCR | ||||||
| QQQORIQTY | Original control qty | QTY | ||||||
| QQQQTY | QC quantity | QTY | ||||||
| RRRORIQTY | Original rejected qty | QTY | ||||||
| RRRQTY | Rejected qty. | QTY | ||||||
| SHLDAT | Expiration date | D | ||||||
| STAFLG | Control status | M | 4 | 1 | ||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[STQ]STOFCY | Block | ||||
| TRSNUM | Transaction | A | 3 | |||||
| TRSTYP | Transaction type | M | 15 | 704 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRNUM | Analysis request | VCR | ||||||
| VCRTYP | Entry type | M | 15 | 701 |