Table ITEM
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| ITEM | ITM | Products | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ITM0 | FCY+DEP+ITM | No | |
| ITM1 | FCY+SKCCLS+SKCNBR+LASSKCDAT+CREDAT+DEP+ITM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALCVOL | Pure alcohol volume | QTY | ||||||
| AMMNUM | AMM no | A | 7 | |||||
| AST | Alert stock | QTA | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CDKMGT | Cross docking | M | 4 | 1 | ||||
| COD | Other code | A | 20 | |||||
| CODE | Classification code | A | 5 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTLCODDAC | Key in control code | M | 4 | 1 | ||||
| DAG | Active matter | DAG | [DAG]DAG0=FCY;DAG(indice) | Block | DG0 | |||
| DAGPCT | % | DCB | 6.2 | DG0 | ||||
| DAGPRTLBL | Printable description | M | 4 | 1 | DG0 | |||
| DCTNUM | Transport category | DCT | [DCT]DCT0=FCY;DCTNUM | Block | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DFTCTR | Default container | ITC | [ITC]ITC0=FCY;DEP;ITM;DFTCTR | RTZ | ||||
| DFTCTRLVL | Def. cntr. level | M | 15 | 311 | ||||
| DGG | Material | DGG | [DGG]DGG0=FCY;DEP;DGG | Block | ||||
| DGGMGT | Hazardous materials | M | 4 | 1 | ||||
| DGGREFTUN | Tunnel restriction | A | 6 | |||||
| DIC | ICPE class | DIC | [DIC]DIC0=FCY;DIC | Block | ||||
| DMCNUM | Haz mat class | DMC | [DMC]DMC0=FCY;DMCNUM | Block | ||||
| ENAFLG | Active | M | 4 | 1 | ||||
| ENDLIF | Item end of life | D | ||||||
| FAM | Family | FAM | [FAM]FAM0=FCY;DEP;FAM | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| FIFDAT | FIFO date nature | M | 25 | 346 | ||||
| FIFDEV | FIFO tolerance | C | 2 | |||||
| FIFDEVUOM | FIFO gap unit | M | 10 | 347 | ||||
| FIRINPDAT | First arrival | D | ||||||
| FRZPNT | Freezing point | L | 5 | |||||
| FRZREV | Freezing reversibility | M | 15 | 421 | ||||
| GENLEVINS | General level of inspection | A | 2 | |||||
| GRP | Packaging group | M | 1 | 420 | ||||
| GRU | Group | GRU | [GRU]GRU0=FCY;DEP;GRU | Block | ||||
| IDENT1 | Identifier 1 | ID1 | ||||||
| INPLOK | Blocked in input | M | 4 | 1 | ||||
| INPLOK2 | Blocked in input | M | 4 | 1 | ||||
| INPMOD | Input mode | IMD | [IMD]IMD0=FCY;DEP;INPMOD | Block | ||||
| ITM | Product | ITM | [ITM]ITM0=FCY;DEP;ITM | Delete | ||||
| ITMDESAXX | Description | AX3 | ||||||
| ITMDESAXX2 | Description | AX3 | ||||||
| ITMSHOAXX | Short description | AX1 | ||||||
| LASINPDAT | Last receipt | D | ||||||
| LASOUTDAT | Last output | D | ||||||
| LASSKCDAT | Last stock count | D | ||||||
| LGTPNT | Flash point | L | 3 | |||||
| LOTMGT | Key in lot no. | M | 4 | 1 | ||||
| MAXSTK | Maximum stock | QTA | ||||||
| MINSTK | Minimum stock | QTA | ||||||
| NETVOL | Net volume | QTY | ||||||
| NETWEI | Net weight | QTY | ||||||
| NQA | AQL | DCB | 3.1 | |||||
| ONU | ONU codes | DON | [DON]DON0=FCY;ONU | Block | ||||
| ORI | Source | ITO | [ITO]ITO0=FCY;DEP;ORI | Block | ||||
| OUTLOK | Blocked in output | M | 4 | 1 | ||||
| OUTLOK2 | Blocked in input | M | 4 | 1 | ||||
| OUTMOD | Output mode | OMD | [OMD]OMD0=FCY;DEP;OUTMOD | Block | ||||
| PRI | Price | MD1 | ||||||
| QLYCRD | Quality record | A | 8 | |||||
| QLYFLG | QC management | M | 4 | 1 | ||||
| QLYSKN | Stock Status | SKN | [SKN]SKN0=FCY;QLYSKN | Block | ||||
| REFQTY | Referred qty | DCB | 7.3 | |||||
| REFUNT | Referred unit | UOM | [TUN]TUN0=[ITM]REFUNT | Block | ||||
| RTDTER | Detention length | C | 2 | |||||
| RTDUOM | Detention unit | M | 10 | 347 | ||||
| SFA | Sub-family | SFA | [SFA]SFA0=FCY;DEP;SFA | Block | ||||
| SGR | Subgroup | SGR | [SGR]SGR0=FCY;DEP;SGR | Block | ||||
| SKCCLS | Stock count class | SCC | [SCC]CCL0=FCY;SKCCLS | Block | ||||
| SKCNBR | No. stock counts | C | 3 | |||||
| SKCNUM | Stock count | SKH | [SKH]SKH0=FCY;SKCNUM | Other | ||||
| SLDTER | SBD length | C | 2 | |||||
| SLDUOM | SBD unit | M | 10 | 347 | ||||
| SMPTYP | Sampling type | M | 15 | 395 | ||||
| SNDTER | SbD length | C | 2 | |||||
| SNDUOM | SbD unit | M | 10 | 347 | ||||
| SNGLOTCTL | Single lot control | M | 4 | 1 | ||||
| SNGLOTMGT | Single lot | M | 4 | 1 | ||||
| SOLCOD | Solvent code | A | 30 | |||||
| SRNMGT | Key in serial no | M | 4 | 1 | ||||
| STU | Stock unit | UOM | [TUN]TUN0=[ITM]STU | Block | ||||
| STUMGT | Stock unit management | M | 4 | 1 | ||||
| TECFLD | Technical field | A | 30 | |||||
| TRFMOD | Auto transfer mode | M | 15 | 365 | ||||
| TRM | Transmis | M | 10 | 352 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| USDTER | UBD length | C | 2 | |||||
| USDUOM | UBD unit | M | 10 | 347 |