Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00113
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Item Price List Details
Physical Name: IV00113
Technical Name: ivItemPriceListDtl_SBMSeq 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
['Item Price List Details'].ITEMNMBR AS 'Item Price List Details-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV00113 AS ['Item Price List Details']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Item Price List Details'].ITEMNMBR = ['Item Master'].ITEMNMBR2 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Item Price List Details'].CURNCYID AS 'Item Price List Details-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
IV00113 AS ['Item Price List Details']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Item Price List Details'].CURNCYID = ['Currency Setup'].CURNCYID3 PRCLEVEL PriceLevel String STR10_LBAU 10 4 UOFM U Of M String U_Of_M 8 The unit of measure. The value in this field must exist in Inventory. 5 TOQTY To QTY Currency DLR17_QTY_RBS0_UTR 17 6 PRICTYPE Price Type Integer Price Type 0 7 PRCNTAGE Percentage Currency DLR5_%2 8 8 UOMPRICE U Of M Price Currency DLR17_RBS0_STR$ 17 9 INCORDEC Increase Or Decrease Integer GB 0