Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV50300
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: ABC Analysis Temp
Physical Name: IV50300
Technical Name: ivABCAnalysisTempSeq 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
['ABC Analysis Temp'].ITEMNMBR AS 'ABC Analysis Temp-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV50300 AS ['ABC Analysis Temp']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ABC Analysis Temp'].ITEMNMBR = ['Item Master'].ITEMNMBR2 ITEMDESC Item Description String STR100 100 3 ITEMTYPE Item Type Integer DDL_Item_Type 0 4 ABCCODE ABC Code Integer DDL_ABC_Code 0 5 SGGSTDABCCD Suggested ABC Code Integer DDL_ABC_Code 0 6 INCLUDEITEM Include Item Boolean CB 0 7 QTYONHND QTY On Hand Currency DLR17_QTY_RBS0_STR 17 8 PRCNTOFTTL Percent of Total Currency DLR1_4 6 9 CMLTVPRCNTOFTTL Cumulative Percent of Total Currency DLR1_4 6 10 CMLTVPRCNTOFITMS Cumulative Percent of Items Currency DLR1_4 6 11 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 12 RANKINGVALUE Ranking Value Currency DLR19_QTY_RBS0_STR 19 13 SMMRYDPNDNTUSGQTY Summary Dependent Usage QTY Currency DLR19_QTY_RBS0_STR 19 14 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 15 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 16 UPDATED Updated Boolean Boolean 0