Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV30102
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Inventory Sales Summary Period History Group Display Name: Inventory Sales Summary History
Physical Name: IV30102
Technical Name: IV_SUM_HIST_Period
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 Period History'].ITEMNMBR AS 'Inventory Sales Summary Period History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV30102 AS ['Inventory Sales Summary Period History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Inventory Sales Summary Period History'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 2 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Inventory Sales Summary Period History'].LOCNCODE AS 'Inventory Sales Summary Period History-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV30102 AS ['Inventory Sales Summary Period History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Inventory Sales Summary Period History'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 3 | SMRYTYPE | Summary Type | Integer | INT | 0 | |
| 4 | SMRYPMTH | Summary Prd/Mth | Integer | INT3 | 3 | |
| 5 | YEAR1 | Year | Integer | Year | 4 | |
| 6 | SMRYQTYS | Summary QTYS | Currency | DLR19_QTY_RBS0_STR | 19 | |
| 7 | SMRYCOST | Summary Costs | Currency | DLR19_RBS0_STR$ | 19 | |
| 8 | SMRYSALS | Summary Sales | Currency | DLR19_RBS0_STR$ | 19 | |
| 9 | SMMRYDPNDNTUSGQTY | Summary Dependent Usage QTY | Currency | DLR19_QTY_RBS0_STR | 19 | |
| 10 | SMMRYDPNDNTUSGCST | Summary Dependent Usage Cost | Currency | DLR19_RBSO_STR$ | 19 | |
| 11 | SMMRYPRJCTDUSGQTY | Summary Projected Usage QTY | Currency | DLR19_QTY_RBS0_STR | 19 | |