Table STOCKOBJ
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOCKOBJ | SKO | Stock objects | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SKO0 | FCY+SKONUM | No | |
| SKO1 | FCY+DEP+ITM+STO+ADD+SKONUM | No | |
| SKO2 | FCY+DEP+ITM+SLOTYP+CTR+STO+SKONUM | No | |
| SKO3 | FCY+SLOTYP+STO+ADD+DEP+SKOLIKNUM+ITM+SKONUM | No | |
| SKO4 | FCY+DEP+INPNUM+ITM+LOT+SKONUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | SLO | [SLO]SLO0=FCY;STO;ADD | Block | ||||
| ADJNUM | Adjustment no | AJM | [AJM]AJM0=FCY;DEP;ADJNUM | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SKO]CREUSR | Other | ||||
| CSUQTY | Number of CU | QTA | ||||||
| CTCQTY | DCB | 10.2 | ||||||
| CTR | Container | ITC | [ITC]ITC0=FCY;DEP;ITM;CTR | Block | ||||
| CTRCOE | Container coef | COE | ||||||
| CTRLIKNUM | Container no. | NUM | ||||||
| CTRLVL | Container / level | ITC | [ITC]ITC0=FCY;DEP;ITM;CTRLVL(indice) | Block | CTR | |||
| CTRQTY | Number of containers | QTA | ||||||
| CUQLVL | CU quantity/level | QTA | CTR | |||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| FIFDAT | FIFO date | D | ||||||
| HMGCOE | Homogeneous coeff | QTA | ||||||
| HMGCTR | Homogeneous container | ITC | [ITC]ITC0=FCY;DEP;ITM;HMGCTR | Block | ||||
| HMGQTY | Standardised quantity | QTA | ||||||
| INPDAT | Receipt date | D | ||||||
| INPNUM | Input no | INP | [INH]INH0=FCY;DEP;INPNUM | Block | ||||
| ITM | Product | ITM | [ITM]ITM0=FCY;DEP;ITM | Block | ||||
| ITMORI | Source | ITO | [ITO]ITO0=FCY;DEP;ITMORI | Block | ||||
| LOT | Lot no. | A | 20 | |||||
| MND | Manufactured date | D | ||||||
| PDI | No. UC pending input | QTA | ||||||
| PDO | No UC pending output | QTA | ||||||
| QLYNUM | Analysis request | QCR | [QLH]QLH0=FCY;DEP;QLYNUM | Other | ||||
| RSA | Reservation | A | 15 | |||||
| RTD | Detention date | D | ||||||
| SKN | Stock Status | SKN | [SKN]SKN0=FCY;SKN | Block | ||||
| SKOLIKNUM | Link no | NUM | ||||||
| SKONUM | Number | SKO | [SKO]SKO0=FCY;SKONUM | Delete | ||||
| SLD | Sell by date | D | ||||||
| SLOTYP | Type of location | M | 15 | 322 | ||||
| SND | Ship by date | D | ||||||
| SPT | Support no. | A | 15 | |||||
| STLDAT | Storing date | D | ||||||
| STLTIM | Storing time | L | 7 | |||||
| STO | Store | STO | [STO]STO0=FCY;STO | Block | ||||
| STOTYP | Store type | M | 15 | 327 | ||||
| TOO | Allocation Seq | L | 7 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDNUM | Upd | L | 8 | |||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SKO]UPDUSR | Other | ||||
| USD | Use by date | D |