Table STOTRK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOTRK | STR | Traceability | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STR0 | ITMREF+LOT+SLO-IPTDAT+MVTSEQ+STOFCY | No | |
| STR1 | VCRTYP+VCRNUM+VCRLIN | Yes | |
| STR2 | ITMREF+SERNUM-IPTDAT+MVTSEQ+STOFCY | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACT | IU potency | DCB | 5.4 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[STR]BPRNUM | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Identifier 2 | CTR | ||||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| IPTDAT | Allocation date | D | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[STR]ITMREF | Block | ||||
| LOT | Lot | LOT | ||||||
| MVTIND | Index | L | 8 | |||||
| MVTSEQ | Sequence | L | 8 | |||||
| MVTSEQSTJ | STOJOU sequence | L | 8 | |||||
| PALNUM | Identifier 1 | PAL | ||||||
| POT | Potency | DCB | 5.4 | |||||
| QLYCTLDEM | Analysis request | VCR | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| REGFLG | Adjusted movement | M | 4 | 1 | ||||
| SERNUM | Serial number | SER | ||||||
| SHLDAT | Expiration date | D | ||||||
| SLO | Sublot | SLO | ||||||
| STA | Status | A | 3 | |||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[STR]STOFCY | Block | ||||
| STOFLD1 | Custom field 1 | SF1 | SFD | |||||
| STOFLD2 | Custom field 2 | SF2 | SFD | |||||
| STU | Stock unit | UOM | [TUN]TUN0=[STR]STU | Block | ||||
| 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 | |||||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUM | Entry | VCR | ||||||
| VCRNUMORI | Original document | VCR | ||||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| VCRTYPORI | Source document type | M | 15 | 701 |