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 |