SV_Extended_Pricing_Matrix_SETP (SV00167)

azurecurveProductsWennSoft Products (131)3rd PartySV_Extended_Pricing_Matrix_SETP (SV00167)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Extended_Pricing_Matrix_SETP
Physical Name: SV00167
Technical Name: SV_Extended_Pricing_Matrix_SETP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString15
2WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer8
3WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer8
4SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
5Price_Matrix_Option SearchPrice Matrix OptionSTR30String30
6Price_Matrix_Option_Req SearchPrice Matrix Option RequiredCBBoolean0
7MODIFDT SearchModified DateDTDate8
8Modified_Time SearchModified TimeTM6Time6
9MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Extended_Pricing_Matrix_SETP'].MDFUSRID AS 'SV_Extended_Pricing_Matrix_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00167 AS ['SV_Extended_Pricing_Matrix_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Extended_Pricing_Matrix_SETP'].MDFUSRID = ['Users Master'].USERID
azurecurveProductsWennSoft Products (131)3rd PartySV_Extended_Pricing_Matrix_SETP (SV00167)

Leave a Reply

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