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 |