Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV50200
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Stock Count Assignment Temp
Physical Name: IV50200
Technical Name: ivStockCountAssignTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 INCLUDEITEM 
Include Item Boolean CB 0 2 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Stock Count Assignment Temp'].ITEMNMBR AS 'Stock Count Assignment Temp-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV50200 AS ['Stock Count Assignment Temp']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Stock Count Assignment Temp'].ITEMNMBR = ['Item Master'].ITEMNMBR3 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Stock Count Assignment Temp'].LOCNCODE AS 'Stock Count Assignment Temp-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV50200 AS ['Stock Count Assignment Temp']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Stock Count Assignment Temp'].LOCNCODE = ['Site Setup'].LOCNCODE4 BINNMBR Bin Number String STR20 20 5 ITMCLSCD Item Class Code String STR10_Class_ID 10 Key to the Item Class Setup (IV40400).
Click to show/hide
SELECT
['Stock Count Assignment Temp'].ITMCLSCD AS 'Stock Count Assignment Temp-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
IV50200 AS ['Stock Count Assignment Temp']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['Stock Count Assignment Temp'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD6 ABCCODE ABC Code Integer DDL_ABC_Code 0 7 ITMGEDSC Item Generic Description String STR10 10 8 ITEMDESC Item Description String STR100 100 9 LSTCNTDT Last Count Date Date DT 8 10 STCKCNTINTRVL Stock Count Interval Integer INT4_U0 4 11 NXTCNTDT Next Count Date Date DT 8 12 NXTCNTTM Next Count Time Time TM6 6 13 UPDATED Updated Boolean Boolean 0 14 ITEMTYPE Item Type Integer DDL_Item_Type 0 15 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Stock Count Assignment Temp'].USERID AS 'Stock Count Assignment Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IV50200 AS ['Stock Count Assignment Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Stock Count Assignment Temp'].USERID = ['Users Master'].USERID16 IntegerValue IntegerValue Integer INT 0