Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV30101
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Inventory Sales Summary History Group Display Name: Inventory Sales Summary History
Physical Name: IV30101
Technical Name: IV_SUM_HIST
Group Technical Name: Inventory Sales Summary History
| 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/hideSELECT
['Inventory Sales Summary History'].ITEMNMBR AS 'Inventory Sales Summary History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV30101 AS ['Inventory Sales Summary History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Inventory Sales Summary History'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 2 | SQTYSYTD | Summary QTYS - YTD | Currency | DLR19_QTY_RBS0_STR | 19 | |
| 3 | SUMCSYTD | Summary Costs - YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 4 | SMSLSYTD | Summary Sales - YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 5 | SQTYSLYR | Summary QTYS - LYR | Currency | DLR19_QTY_RBS0_STR | 19 | |
| 6 | SUMCSLYR | Summary Costs - LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 7 | SMSLSLYR | Summary Sales - LYR | Currency | DLR19_RBS0_STR$ | 19 | |