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 SearchPriceSheetIDStringSTR15_LBU15
2DESCEXPR SearchDescriptionForExtPricingStringSTR5050
3NTPRONLY SearchNetPriceOnlyBooleanCB_NetPriceOnly0
4ACTIVE SearchActiveBooleanCB_Active0
5STRTDATE SearchStart DateDateDT8
6ENDDATE SearchEnd DateDateDT8
7NOTEINDX SearchNote IndexCurrencyDLR1414
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 SearchPromotionBooleanCB_Promotion0
9CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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
azurecurveProductsMicrosoft Dynamics GP (0)SalesExtended Pricing Price Sheet Header (SOP10110)

Leave a Reply

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