IV_Item_VNDR (IVR10232)

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

Display Name: IV_Item_VNDR
Physical Name: IVR10232
Technical Name: IV_Item_VNDR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['IV_Item_VNDR'].ITEMNMBR AS 'IV_Item_VNDR-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM IVR10232 AS ['IV_Item_VNDR'] INNER JOIN IV00101 AS ['Item Master'] ON ['IV_Item_VNDR'].ITEMNMBR = ['Item Master'].ITEMNMBR
2	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['IV_Item_VNDR'].VENDORID AS 'IV_Item_VNDR-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM IVR10232 AS ['IV_Item_VNDR'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['IV_Item_VNDR'].VENDORID = ['PM Vendor Master File'].VENDORID
3	UOFM	U Of M	String	U_Of_M	8
4	AVERAGEORDQTY_I	Average ORD QTY	Currency	DLR17_QTY_RBS0_UTR	17
5	MNFCTRITMNMBR	Manufacture Item Number	String	STR30_LBAU	30
6	QTYORDERLOTSIZE_I	QTY Order Lot Size	Currency	DLR17_QTY_RBS0_UTR	17