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 |