AD Item Properties (ADItemPr)

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_Properties

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1AD_Item_Saved SearchAD Item SavedBooleanBoolean0
2ADBUY SearchAD BuyBooleanCB0
3ADDSGNAUTH SearchAD Design AuthorityStringSTR100100
4ADREVNMBR SearchAD Revision NumberStringSTR5050
5ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
6AD_ItemExists SearchAD ItemExistsBooleanboolean0
7ADITEMNMBR SearchAD Item NumberStringSTR5050
8ITMCLSCD SearchItem Class CodeStringSTR10_Class_ID10
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'].ITMCLSCD
9UOFM SearchU Of MStringU_Of_M8
10UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
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'].UOMSCHDL
11ADITEMDESC SearchAD Item DescriptionTextSTR512512

Leave a Reply

Your email address will not be published. Required fields are marked *