Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP10109
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Extended Pricing Price Book Header Group Display Name: Item Master
Physical Name: SOP10109
Technical Name: sopExtPricingPriceBookHeader
Group Technical Name: Item Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PRCBKID | PriceBookID | String | STR15_LBU | 15 | |
2 | DESCEXPR | DescriptionForExtPricing | String | STR50 | 50 | |
3 | ISBASE | IsBase | Boolean | CB | 0 | |
4 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Extended Pricing Price Book Header'].NOTEINDX AS 'Extended Pricing Price Book Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SOP10109 AS ['Extended Pricing Price Book Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extended Pricing Price Book Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX |