Extended Pricing Price Sheet Header (SOP10110)

azurecurveProductsMicrosoft Dynamics GP (0)SalesExtended Pricing Price Sheet Header (SOP10110)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP10110

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Extended Pricing Price Sheet Header
Physical Name: SOP10110
Technical Name: sopExtPricingPriceSheetHeader

Group Display Name: Item Master
Group Technical Name: Item Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PRCSHID SearchPriceSheetIDSTR15_LBUString15
2DESCEXPR SearchDescriptionForExtPricingSTR50String50
3NTPRONLY SearchNetPriceOnlyCB_NetPriceOnlyBoolean0
4ACTIVE SearchActiveCB_ActiveBoolean0
5STRTDATE SearchStart DateDTDate8
6ENDDATE SearchEnd DateDTDate8
7NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extended Pricing Price Sheet Header'].NOTEINDX AS 'Extended Pricing Price Sheet Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SOP10110 AS ['Extended Pricing Price Sheet Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extended Pricing Price Sheet Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
8PROMO SearchPromotionCB_PromotionBoolean0
9CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Extended Pricing Price Sheet Header'].CURNCYID AS 'Extended Pricing Price Sheet Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SOP10110 AS ['Extended Pricing Price Sheet Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Extended Pricing Price Sheet Header'].CURNCYID = ['Currency Setup'].CURNCYID
10DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SalesExtended Pricing Price Sheet Header (SOP10110)

Leave a Reply

Your email address will not be published. Required fields are marked *