Table STOSRGW
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOSRGW | SGW | Storage (details) | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SGW0 | STOCOU+VCRTYP+VCRNUM+VCRLIN+SRGSEQ | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACT | IU potency | DCB | 5.4 | |||||
| ACTQTY | Active quantity | QTY | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPSLOT | Supplier lot | LOT | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREPPS | List date | D | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Identifier 2 | CTR | ||||||
| ECCVALMAJ | Major version | ECS | ||||||
| ECCVALMIN | Minor version | EVL | ||||||
| EXPNUM | Export number | L | 8 | |||||
| GESLOT | Lot source | A | 1 | |||||
| LOC | Location | LOC | [STC]STC0=STOFCY;LOC | Block | ||||
| LOCTYP | Location type | TLO | [TLO]TLO0=STOFCY;LOCTYP | Block | ||||
| LOT | Lot | LOT | ||||||
| LPNNUM | License plate number | LPN | [LPN]LPN0=LPNNUM | Block | LPN | |||
| ORICOD | Source | M | 15 | 2720 | ||||
| PALNUM | Identifier 1 | PAL | ||||||
| PCU | Unit | UOM | [TUN]TUN0=[SGW]PCU | Block | ||||
| PCUSTUCOE | Coefficient | COE | ||||||
| POT | Potency | DCB | 5.4 | |||||
| QTYPCU | Quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| REFPER | Expiration reference | D | ||||||
| SERNUM | Serial number | SER | ||||||
| SERNUMF | Ending serial number | SER | ||||||
| SHL | Shelf life | C | 4 | |||||
| SHLDAT | Expiration date | D | ||||||
| SLO | Sublot | SLO | ||||||
| SRGPPS | List number | SRG | ||||||
| SRGSEQ | Sequence number | L | 8 | |||||
| STA | Status | A | 3 | |||||
| STOCOU | Chronological stock | DCB | 10 | |||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[SGW]STOFCY | Block | ||||
| STOFLD1 | Custom field 1 | SF1 | SFD | |||||
| STOFLD2 | Custom field 2 | SF2 | SFD | |||||
| STOSEQTWS | TWS sequence no. | C | 4 | |||||
| STU | Stock unit | UOM | [TUN]TUN0=[SGW]STU | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SGW]UPDUSR | Other | ||||
| 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 | ||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Block | WRH | |||
| WSTOFLG | Entry OK indicator | C | 4 |