Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SC020130
Product: Manufacturing (346)
Series:
Display Name: Sales Forecast Line Group Display Name: Manufacturing Sales Fcst.
Physical Name: SC020130
Technical Name: SF_LINE
Group Technical Name: Manufacturing SFC
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PLANNAME_I | Plan Name | String | STR15 | 15 | |
2 | SFLINEITEM_I | SF Line Item | Integer | INT3 | 3 | |
3 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Sales Forecast Line'].ITEMNMBR AS 'Sales Forecast Line-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SC020130 AS ['Sales Forecast Line']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Sales Forecast Line'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
4 | LISTPRCE | List Price | Currency | DLR17_RBS0_STR$ | 17 | |
5 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
6 | TOTALQTYTOFORECAST_I | Total QTY To Forecast | Currency | DLR17_QTY_RBS0_STR | 17 |