Table STOQLYD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOQLYD | QLD | Quality control detail | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| QLD0 | VCRTYP+VCRNUM+VCRLIN | No | |
| QLD1 | ITMREF+STOFCY+VCRTYP+VCRNUM+VCRLIN | No | |
| QLD2 | VCRTYP+VCRNUM+LOT+SLO+SERNUM | Yes | |
| QLD3 | VCRTYP+VCRNUM+VCRLINORI+SERNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CRDFLG | Tracking record | M | 4 | 1 | ||||
| CRDSEQ | Seq no. analysis file | L | 8 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Identifier 2 | CTR | ||||||
| ECCVALMAJ | Major version | ECS | ||||||
| ECCVALMIN | Minor version | EVL | ||||||
| EXPNUM | Export number | L | 8 | |||||
| ITMREF | Product | ITM | [ITM]ITM0=[QLD]ITMREF | Block | ||||
| 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 | Other | LPN | |||
| OWNER | Owner | BPF | ||||||
| PALNUM | Identifier 1 | PAL | ||||||
| PCU | Packing unit | UOM | [TUN]TUN0=[QLD]PCU | Block | ||||
| PCUSTUCOE | Coefficient | COE | ||||||
| QLYCRD | Technical sheet | QLC | [QLC]QLC0=QLYCRD;1 | Block | ||||
| QTYPCU | PAC quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| SERNUM | Serial number | SER | ||||||
| SLO | Sublot | SLO | ||||||
| STA | Status | A | 3 | |||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[QLD]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 | |||||
| VCRLIN | Line no. analyzed | L | 5 | |||||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUM | Analysis request | VCR | ||||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Block | WRH |