Table ITMMVTHIS
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
ITMMVTHIS | ITH | Total product - site history | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
ITH0 | ITMREF+STOFCY+PERSTR | No | |
ITH1 | STOFCY+ITMREF+PERSTR | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AMTDEV | Variance not absorbed | MD1 | ||||||
AMTDEV2 | Variance not absorbed | MD1 | VLT | |||||
AUUID | Single identifier | AUUID | ||||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
EXPNUM | Export number | L | 8 | |||||
FIYNUM | Fiscal year | C | 2 | |||||
ITMREF | Product | ITM | [ITM]ITM0=[ITH]ITMREF | Block | ||||
LASISSDAT | Last issue date | D | ||||||
LASPURDAT | Last purchase date | D | ||||||
LASPURPRI | Last purchase price | MD6 | ||||||
LASRCPDAT | Last receipt date | D | ||||||
LASRCPPRI | Last receipt cost | MD8 | ||||||
LASREODAT | Last reorder date | D | ||||||
MONISSAMT | Period issue amount | MD1 | ||||||
MONISSMVT | Number period issues | L | 7 | |||||
MONISSQTY | Period issue quantity | QTY | ||||||
MONRCPAMT | Period receipts amount | MD1 | ||||||
MONRCPMVT | Number period receipts | L | 7 | |||||
MONRCPQTY | Period receipt quantity | QTY | ||||||
PEREND | Period end | D | ||||||
PERNUM | Period number | C | 2 | |||||
PERSTR | Period start | D | ||||||
STOFCY | Storage site | FCY | [FCY]FCY0=[ITH]STOFCY | Block | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 | |||||
VCRLIN | Entry line no. | L | 8 | |||||
VCRNUM | Entry | VCR | ||||||
VCRTYP | Entry type | M | 15 | 701 | ||||
YEAISSAMT | Annual amt. issued | MD1 | ||||||
YEAISSMVT | No. annual issues | L | 7 | |||||
YEAISSQTY | Annual qty. issued | QTY | ||||||
YEARCPAMT | Annual amt. received | MD1 | ||||||
YEARCPMVT | No. annual receipts | L | 7 | |||||
YEARCPQTY | Annual qty. received | QTY |