Table STOLOT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOLOT | STL | Lot numbers | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STL0 | ITMREF+LOT+SLO | No | |
| STL1 | ITMREF+LOTCREDAT+LOT+SLO | No | |
| STL2 | ITMREF+SHLDAT+LOTCREDAT+LOT+SLO | No | |
| STL3 | SHLDAT+ITMREF+LOT+SLO | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACT | IU potency | DCB | 5.4 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPSLOT | Supplier lot | LOT | ||||||
| BPSNUM | Supplier | BPS | [BPS]BPS0=[STL]BPSNUM | Other | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DLU | UBD coefficient | COE | ||||||
| DLUDAT | Use-by date | D | ||||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| ITMREF | Product | ITM | [ITM]ITM0=[STL]ITMREF | Block | ||||
| LOT | Lot | LOT | ||||||
| LOTCREDAT | Lot created | D | ||||||
| LTIDAT | Control date | D | ||||||
| NEWLTIDAT | Recontrol date | D | ||||||
| POT | Potency | DCB | 5.4 | |||||
| REFPER | Expiration reference | D | ||||||
| SHL | Shelf life | C | 4 | |||||
| SHLDAT | Expiration date | D | ||||||
| SHLLTI | Recontrol lead time | C | 4 | |||||
| SHLLTIUOM | Rectrl time unit | M | 15 | 2759 | ||||
| SHLUOM | Expir t unit | M | 15 | 2759 | ||||
| SLO | Sublot | SLO | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| USRFLD1 | Stock custom field 1 | A | 20 | |||||
| USRFLD2 | Stock custom field 2 | A | 10 | |||||
| USRFLD3 | Stock custom field 3 | DCB | 10 | |||||
| USRFLD4 | Stock custom field 4 | D | ||||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRNUM | Entry | VCR | ||||||
| VCRTYP | Entry type | M | 15 | 701 |