Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV10401
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Extended Pricing Price Sheet Work Group Display Name: Item Master
Physical Name: IV10401
Technical Name: ivExtPricingPriceSheetWork
Group Technical Name: Item Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PRCSHID  | PriceSheetID | String | STR15_LBU | 15 | |
| 2 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 3 | EPITMTYP | ExtPricingItemType | String | STR1 | 1 | |
| 4 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Extended Pricing Price Sheet Work'].ITEMNMBR AS 'Extended Pricing Price Sheet Work-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV10401 AS ['Extended Pricing Price Sheet Work']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Extended Pricing Price Sheet Work'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 5 | BRKPTPRC | BreakPointPricing | Boolean | CB_BreakPointPricing | 0 | |
| 6 | ACTIVE | Active | Boolean | CB_Active | 0 | |
| 7 | BASEUOFM | Base U Of M | String | U_Of_M | 8 | |
| 8 | PRODTCOD | PromotionDetailCode | String | STR1 | 1 | |
| 9 | PROMOTYP | PromotionType | Integer | DDL_PromotionType | 0 | |
| 10 | PROMOLVL | PromotionLevel | Integer | DDL_PromotionLevel | 0 | |