Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MRPV0001
Product: Manufacturing (346)
Series:
Display Name: Workbench Item Master Quantity
Physical Name: MRPV0001
Technical Name: IC_IV_Items_MSTR_QTYS
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ITEMNMBR  | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hide | ||||||
| 2 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hide | ||||||
| 3 | BINNMBR | Bin Number | String | STR20 | 20 | |
| 4 | RCRDTYPE | Record Type | Integer | INT1 | 1 | |
| 5 | PRIMVNDR | Primary Vendor | String | STR_15_Vendor_ID | 15 | |
| 6 | ITMFRFLG | Item Freeze Flag | Boolean | YN | 0 | |
| 7 | BGNGQTY | Beginning QTY | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 8 | LSORDQTY | Last ORD QTY | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 9 | LRCPTQTY | Last RCPT QTY | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 10 | LSTORDDT | Last ORD Date | Date | DATE | 6 | |
| 11 | LSORDVND | Last ORD Vendor | String | STR_15_Vendor_ID | 15 | |
| 12 | LSRCPTDT | Last RCPT Date | Date | DATE | 6 | |
| 13 | QTYRQSTN | QTY Requisitioned | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 14 | QTYONORD | QTY On Order | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 15 | QTYBKORD | QTY Back Ordered | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 16 | QTY_Drop_Shipped | QTY Drop Shipped | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 17 | ORDRPNTQTY | Order Point Qty | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 18 | REORDERVARIANCE | Reorder Variance | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 19 | ORDRUPTOLVL | Order Up To Level | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 20 | QTYINUSE | QTY In Use | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 21 | QTYINSVC | QTY In Service | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 22 | QTYRTRND | QTY Returned | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 23 | QTYDMGED | QTY Damaged | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 24 | QTYONHND | QTY On Hand | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 25 | ATYALLOC | QTY Allocated | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 26 | QTYCOMTD | QTY Committed | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 27 | QTYSOLD | QTY Sold | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 28 | NXTCNTDT | Next Count Date | Date | DT | 8 | |
| 29 | NXTCNTTM | Next Count Time | Time | TM6 | 6 | |
| 30 | LSTCNTDT | Last Count Date | Date | DT | 8 | |
| 31 | LSTCNTTM | Last Count Time | Time | TM6 | 6 | |
| 32 | STCKCNTINTRVL | Stock Count Interval | Integer | INT4_U0 | 4 | |