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_QTYSSeq 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
SELECT
['Workbench Item Master Quantity'].ITEMNMBR AS 'Workbench Item Master Quantity-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MRPV0001 AS ['Workbench Item Master Quantity']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Workbench Item Master Quantity'].ITEMNMBR = ['Item Master'].ITEMNMBR2 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Workbench Item Master Quantity'].LOCNCODE AS 'Workbench Item Master Quantity-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
MRPV0001 AS ['Workbench Item Master Quantity']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Workbench Item Master Quantity'].LOCNCODE = ['Site Setup'].LOCNCODE3 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