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 |