Extended Pricing Promotion Report Temp (SOP50401)

azurecurveProductsMicrosoft Dynamics GP (0)SalesExtended Pricing Promotion Report Temp (SOP50401)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Extended Pricing Promotion Report Temp
Physical Name: SOP50401
Technical Name: sopExtPricingPromoReportTemp

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Extended Pricing Promotion Report Temp'].ITEMNMBR AS 'Extended Pricing Promotion Report Temp-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SOP50401 AS ['Extended Pricing Promotion Report Temp']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Extended Pricing Promotion Report Temp'].ITEMNMBR = ['Item Master'].ITEMNMBR
2EPITMTYP SearchExtPricingItemTypeStringSTR11
3STRTDATE SearchStart DateDateDT8
4ENDDATE SearchEnd DateDateDT8
5PRCSHID SearchPriceSheetIDStringSTR15_LBU15
6BASEUOFM SearchBase U Of MStringU_Of_M8
7ACTIVE SearchActiveBooleanCB_Active0
8PRODTCOD SearchPromotionDetailCodeStringSTR11
9QTYFROM SearchQTYFromCurrencyDLR17_QTY_RBS0_UTR17
10PSITMVAL SearchPriceSheetItemValueCurrencyDLR17_RBS0_STR17
11FREEITEM SearchFreeItemStringSTR30_Item_Number30
12FREEUOFM SearchFreeItemUofMStringU_Of_M8
azurecurveProductsMicrosoft Dynamics GP (0)SalesExtended Pricing Promotion Report Temp (SOP50401)

Leave a Reply

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