Table MAPPINGD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MAPPINGD | MAD | Dynamic Picking | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MAD0 | FCY+MALNUM+DEP+ITM | No | |
| MAD1 | FCY+MAHNUM+MADSTA+DEP+ITM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLABC | ABC classes | ROT | [ROT]ABC0=FCY;ALLABC | Block | ||||
| ALLASG | Assignment class | CAS | [CAS]CAS0=FCY;ALLASG | Block | ||||
| ALLDAT | Reallocation date | D | ||||||
| ALLSLO | Location | SLO | [SLO]SLO0=FCY;ALLSTO;ALLSLO | Block | ||||
| ALLSTO | Store | STO | [STO]STO0=FCY;ALLSTO | Block | ||||
| ALLSTY | Storage type | STY | [STY]STY0=FCY;ALLSTY | Block | ||||
| ALLTPY | Temporary picking | M | 4 | 1 | ||||
| ALLVOL | Volume class | VOL | [VOL]VOL0=FCY;ALLVOL | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNBR | Containers put out | L | 7 | |||||
| CUQNBR | CU put out | QTA | ||||||
| CUTABC | ABC classes | ROT | [ROT]ABC0=FCY;CUTABC | Block | ||||
| CUTASG | Assignment class | CAS | [CAS]CAS0=FCY;CUTASG | Block | ||||
| CUTSLO | Location | SLO | [SLO]SLO0=FCY;CUTSTO;CUTSLO | Block | ||||
| CUTSTO | Store | STO | [STO]STO0=FCY;CUTSTO | Block | ||||
| CUTSTY | Storage type | STY | [STY]STY0=FCY;CUTSTY | Block | ||||
| CUTVOL | Volume class | VOL | [VOL]VOL0=FCY;CUTVOL | Block | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Delete | ||||
| DOLNBR | Nr of lines DO | L | 7 | |||||
| ENDLIF | Item end of life | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[MAD]FCY | Delete | ||||
| FIROUT | 1st activity | D | ||||||
| FRTNBR | Pla. nb mvt | L | 7 | |||||
| HISPTR | Archive | L | 8 | |||||
| ITM | Product | ITM | [ITM]ITM0=FCY;DEP;ITM | Delete | ||||
| LASALL | Last allocations | D | ||||||
| MADSTA | Status | M | 20 | 372 | ||||
| MAHNUM | PR campaign no | MAH | [MAH]MAH0=FCY;MAHNUM | Delete | ||||
| MALNUM | PR No. | MAL | [MAL]MAL0=FCY;MALNUM | Delete | ||||
| OUMNBR | No of movements | L | 7 | |||||
| OUTVOL | Volume put out | QTY | ||||||
| OUTWEI | Weight put out | QTY | ||||||
| PIKNBR | Nb takes | L | 7 | |||||
| PKONBR | PO no | L | 7 | |||||
| POMNBR | Nb promptings | DCB | 7.2 | |||||
| PRCNBR | No. of parcels | L | 7 | |||||
| RPNNBR | TO nr | L | 7 | |||||
| SESPOM | Weighted prompt | DCB | 7.2 | |||||
| SESVOL | Weighted volume put out | QTY | ||||||
| SESWEI | Weighted weight put out | QTY | ||||||
| STRFRT | Start forecasts | D | ||||||
| THEABC | Ideal rotation class | ROT | [ROT]ABC0=FCY;THEABC | Block | ||||
| THEABC2 | Ideal rotation class | ROT | [ROT]ABC0=FCY;THEABC2 | Block | ||||
| THEVOL | Ideal volume class | VOL | [VOL]VOL0=FCY;THEVOL | Block | ||||
| THEVOL2 | Ideal volume class | VOL | [VOL]VOL0=FCY;THEVOL2 | Block | ||||
| TRMNBR | No of movements | L | 7 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |