Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ADItemP2
Product: Manufacturing (346)
Series:
Display Name: AD Item Properties
Physical Name: ADItemP2
Technical Name: AD_Item_Properties2Seq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 AD_Item_Saved AD Item Saved Boolean Boolean 0 2 ADDSGNAUTH AD Design Authority String STR100 100 3 ADBUY AD Buy Boolean CB 0 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
ADItemP2 AS ['AD Item Properties']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['AD Item Properties'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
9 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
ADItemP2 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'].UOMSCHDL
11 ADITEMDESC AD Item Description Text STR512 512