AD Item Properties (ADItemP2)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ADItemP2

Display Name: AD Item Properties
Physical Name: ADItemP2
Technical Name: AD_Item_Properties2

Seq 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