Table STOSRG
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOSRG | SRG | Storage | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SRG0 | STOCOU+VCRTYP+VCRNUM+VCRLIN | No | |
| SRG1 | STOFCY+ITMREF | Yes | |
| SRG2 | STOFCY+LOC | Yes | |
| SRG3 | STOFCY+VCRTYP+VCRNUM+VCRLIN | Yes | |
| SRG4 | STOFCY+SRGPPS | Yes | |
| SRG5 | STOFCY+VCRNUM+VCRLIN | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[SRG]BPRNUM | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREPPS | List date | D | ||||||
| CRETIM | Time | HM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| EXPNUM | Export number | L | 8 | |||||
| IPTDAT | Allocation date | D | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[SRG]ITMREF | Block | ||||
| LOC | Location | LOC | [STC]STC0=STOFCY;LOC | Block | ||||
| MVTDES | Movement description | DES | ||||||
| ORICOD | Source | M | 15 | 2720 | ||||
| PCU | Packing unit | UOM | [TUN]TUN0=[SRG]PCU | Block | ||||
| PCUSTUCOE | PAC-STK conv. | COE | ||||||
| PJT | Project | PJT | [PIM]PIM0=[SRG]PJT | Block | ||||
| QTYPCU | PAC quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| QTYSTUACT | Active quantity STK | QTY | ||||||
| QUAFLG | QC management | M | 25 | 275 | ||||
| QUAFRE | Frequency | C | 1 | |||||
| SRGPPS | List number | SRG | ||||||
| STA | Status | A | 3 | |||||
| STAFLG | Status | M | 15 | 2716 | ||||
| STOCOU | Chronological stock | DCB | 10 | |||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[SRG]STOFCY | Block | ||||
| TRFFCY | Transfer site | FCY | [FCY]FCY0=[SRG]TRFFCY | Other | ||||
| TRSTYP | Transaction type | M | 15 | 704 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUM | Entry | VCR | ||||||
| VCRNUMORI | Original document | VCR | ||||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| VCRTYPORI | Source document type | M | 15 | 701 | ||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Block | WRH |