Table STOCK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOCK | STO | Stock | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STO0 | STOFCY+STOCOU | No | |
| STO1 | STOFCY+PALNUM+ITMREF | Yes | |
| STO3 | ITMREF+STOFCY+LOT+SLO+LOC | Yes | |
| STO4 | STOFCY+LOC | Yes | |
| STO5 | ITMREF+SERNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPSLOT | Supplier lot | LOT | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Identifier 2 | CTR | ||||||
| CUMALLQTA | Allocated active qty | QTY | ||||||
| CUMALLQTY | Allocated qty. | QTY | ||||||
| CUMWIPQTA | Act qty in process | QTY | ||||||
| CUMWIPQTY | Qty. in process | QTY | ||||||
| CUNLISNUM | Count worksheet | VCR | ||||||
| CUNLOKFLG | Count in progress | M | 4 | 1 | ||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| EDTFLG | Edit flag | C | 1 | |||||
| EXPNUM | Export number | L | 8 | |||||
| ITMREF | Product | ITF | [ITF]ITF0=ITMREF;STOFCY | Block | ||||
| LASCUNDAT | Last count | D | ||||||
| LASISSDAT | Last issue date | D | ||||||
| LASRCPDAT | Last receipt date | D | ||||||
| LOC | Location | LOC | [STC]STC0=STOFCY;LOC | Block | ||||
| LOCCAT | Location category | M | 15 | 2710 | ||||
| LOCTYP | Location type | TLO | [TLO]TLO0=STOFCY;LOCTYP | Block | ||||
| LOT | Lot | LOT | ||||||
| OWNER | Owner | BPF | ||||||
| PALNUM | Identifier 1 | PAL | ||||||
| PCU | Packing unit | UOM | [TUN]TUN0=[STO]PCU | Block | ||||
| PCUORI | Original packing | UOM | [TUN]TUN0=[STO]PCUORI | Block | ||||
| PCUSTUCOE | PAC-STK conv. | COE | ||||||
| PJT | Project | PJT | [PIM]PIM0=[STO]PJT | BSRA | ||||
| QLYCTLDEM | Analysis request | VCR | ||||||
| QTYPCU | PAC quantity | QTY | ||||||
| QTYPCUORI | Original PAC quant. | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| QTYSTUACT | Active quantity STK | QTY | ||||||
| QTYSTUORI | Original quantity STK | QTY | ||||||
| RCPDAT | Date entry series | D | ||||||
| SERNUM | Serial number | SER | ||||||
| SLO | Sublot | SLO | ||||||
| STA | Status | A | 3 | |||||
| STOCOU | Chronological stock | DCB | 10 | |||||
| STOFCY | Stock site | FCY | [FCY]FCY0=[STO]STOFCY | Block | ||||
| STOFLD1 | Custom field 1 | SF1 | SFD | |||||
| STOFLD2 | Custom field 2 | SF2 | SFD | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Block | WRH |