Table MSNOPE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MSNOPE | MOP | Operations | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MOP0 | FCY+MTKNUM+OPENUM | No | |
| MOP1 | FCY+ETTTYP+ETTNUM+ETTNUM2 | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ARE | Mission area | MSA | [MSA]MSA0=FCY;ARE | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[MOP]CREUSR | Other | ||||
| CTR1 | Cntr. | ITC | [ITC]ITC0=FCY;ETTDEP;ITM;CTR1 | Block | ||||
| CTR2 | Cntr. | ITC | [ITC]ITC0=FCY;ETTDEP;ITM;CTR2 | Block | ||||
| CUQ | Number PAC | QTA | ||||||
| DATEND | End date | D | ||||||
| DATSTR | Start date | D | ||||||
| ETTDEP | Depositor | DEP | [DEP]DEP0=FCY;ETTDEP | Block | ||||
| ETTNUM | Entity number | A | 20 | |||||
| ETTNUM2 | Entity number | A | 20 | |||||
| ETTTYP | Entity | ADI | [ADI]CODE=950;ETTTYP | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| HISPTR | Archive | L | 8 | |||||
| HOUEND | End time | HS | ||||||
| HOUSTR | Start time | HS | ||||||
| ITM | Product | ITM | [ITM]ITM0=FCY;ETTDEP;ITM | Block | ||||
| ITMORI | Source | ITO | [ITO]ITO0=FCY;ETTDEP;ITMORI | Block | ||||
| KIT | Type | M | 15 | 357 | ||||
| LOT | Lot no. | A | 20 | |||||
| MSNNUM | Role | MSN | [MSN]MSN0=FCY;MSNNUM | Delete | ||||
| MTKNUM | Task | MTK | ||||||
| OPE | Operator code | OPE | [OPE]OPE0=FCY;OPE | Block | ||||
| OPELIK | Linked | C | 4 | |||||
| OPENUM | Operation | C | 4 | |||||
| OPEREJ | Reason | URN | [URN]URN0=FCY;3;OPEREJ | Block | ||||
| OPESTA | Status | M | 15 | 456 | ||||
| PRC | Parcel | PRC | [PAC]PAC0=FCY;ETTDEP;PRC | Block | ||||
| QTY1 | No. | QTA | ||||||
| QTY2 | No. | QTA | ||||||
| RSA | Reservation no | A | 15 | |||||
| SKN | Stock Status | SKN | [SKN]SKN0=FCY;SKN | Block | ||||
| SLO | Address | SLO | [SLO]SLO0=FCY;STO;SLO | Block | ||||
| SPT | Support no. | A | 15 | |||||
| STO | Store | STO | [STO]STO0=FCY;STO | Block | ||||
| TYP | Type | M | 10 | 454 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[MOP]UPDUSR | Other | ||||
| VOL | Volume | QTY | ||||||
| WEI | Weight | QTY |