Table STOSYNW
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
STOSYNW | SYW | Stock resynch work | Stock |
Key | Description | Duplicates | Activity code |
---|---|---|---|
SYW0 | CUNLISNUM+STOFCY+ITMREF+SEQ | No | |
SYW1 | STOFCY+ITMREF+LOT+SLO+LOC+STA | Yes | |
SYW2 | STOFCY+ITMREF+SERNUM | 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=[SYW]BPRNUM | Other | ||||
BPSLOT | Supplier lot | LOT | ||||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CTRNUM | Identifier 2 | CTR | ||||||
CUNLISNUM | Count worksheet | VCR | ||||||
EXPNUM | Export number | L | 8 | |||||
ITMREF | Product | ITM | [ITM]ITM0=[SYW]ITMREF | Other | ||||
LOC | Location | LOC | [STC]STC0=STOFCY;LOC | Other | ||||
LOT | Lot | LOT | ||||||
OWNER | Owner | BPF | ||||||
PALNUM | Identifier 1 | PAL | ||||||
PCU | Unit | UOM | [TUN]TUN0=[SYW]PCU | Other | ||||
PCUSTUCOE | PAC-STK conv. | COE | ||||||
POT | Potency | DCB | 5.4 | |||||
QLYCTLDEM | Analysis request | VCR | ||||||
QTYPCUNEW | Counted stock PAC | QTY | ||||||
QTYPCUSTO | Stock PAC | QTY | ||||||
QTYSTUNEW | Counted STK stock | QTY | ||||||
QTYSTUSTO | Stock STK | QTY | ||||||
SEQ | Sequence | L | 8 | |||||
SERNUM | Serial number | SER | ||||||
SHLDAT | Expiration date | D | ||||||
SLO | Sublot | SLO | ||||||
STA | Stock status | A | 3 | |||||
STOCOU | Chronological stock | DCB | 10 | |||||
STOFCY | Storage site | FCY | [FCY]FCY0=[SYW]STOFCY | Other | ||||
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 |