Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ADItemPr
Product: Manufacturing (346)
Series:
Display Name: AD Item Properties
Physical Name: ADItemPr
Technical Name: AD_Item_PropertiesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 AD_Item_Saved 
AD Item Saved Boolean Boolean 0 2 ADBUY AD Buy Boolean CB 0 3 ADDSGNAUTH AD Design Authority String STR100 100 4 ADREVNMBR AD Revision Number String STR50 50 5 ITEMTYPE Item Type Integer DDL_Item_Type 0 6 AD_ItemExists AD ItemExists Boolean boolean 0 7 ADITEMNMBR AD Item Number String STR50 50 8 ITMCLSCD Item Class Code String STR10_Class_ID 10 Key to the Item Class Setup (IV40400).
Click to show/hide
SELECT
['AD Item Properties'].ITMCLSCD AS 'AD Item Properties-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ADItemPr AS ['AD Item Properties']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['AD Item Properties'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD9 UOFM U Of M String U_Of_M 8 10 UOMSCHDL U Of M Schedule String STR10_Schedule 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['AD Item Properties'].UOMSCHDL AS 'AD Item Properties-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ADItemPr AS ['AD Item Properties']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['AD Item Properties'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL11 ADITEMDESC AD Item Description Text STR512 512